|
U.S. Securities and Exchange Commission Corporate Ownership RDF Data First posted April 2008, updated September 2008 I've taken corporate ownership records from the U.S. SEC (forms 3, 4, and 5 from its EDGAR database, 2004-June 2008) and turned it into dereferencable RDF. It is 1.8 million triples. Some example dereferencable URIs are given below which you can use to explore the data in your browser. A brief description of the schema is provided after that (there is no formal schema). Below that you'll find a box to run SPARQL queries, and below the box some example queries. Source code to download from the SEC and transform the data are browsable here, and you can also download the N3 file with the triples (8MB gzipped). The records establish board membership, officer positions, and 10%-or-more ownership relations. Note that people can enter into any of those relations with corporations, but additionally corporations can be 10% owners of other corporations. The records exist at time points when the interest (i.e. stock ownership) of an individual or corporation that is in one of the relations above with a corporation changes. It is thus possible (and likely) that individuals who are no longer in such a relation with a corporation are still listed as such in this data. I really hardly know anything about the SEC, so my interpretation of any of their data is quite fast and loose. Notable URIsHere are some notable URIs in the data:
SchemaHere's a brief run-down of the schema. The main namespace ("sec:") is <http://www.rdfabout.com/rdf/schema/ussec/>. The sec:cik predicate relates a corporation or individual in the data to its Central Index Key (CIK), a plain literal value. Everything with a CIK is given a foaf:name. When known, corporations are typed foafcorp:Company and individuals foaf:Person, but the SEC data is light on that. Corporations that have stock trading symbols have that information in the sec:tradingSymbol property (which gives a plain literal value). Owners of corporations (either individuals or other corporations) have an address given in the vcard:ADR property (it links to a bnode which in turn has standard vcard properties). The sec:hasRelation property relates owners to "relation" bnodes that indicate the corporation (sec:corporation), type of relation (rdf:type to sec:DirectorRelation, sec:OfficerRelation, or sec:TenPercentOwnerRelation, or none of these if it is another type of relation), and the date the relation was indicated for (dc:date). In addition, a sec:officerTitle predicate of one of these relation bnodes indicates the title of the individual owner, such as "President". It is a plain literal. SPARQL QueryEnter a SPARQL query below. The endpoint URI is http://rdfabout.com/sparql. Useful NamespacesPREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX dc: <http://purl.org/dc/elements/1.1/> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX vcard: <http://www.w3.org/2001/vcard-rdf/3.0#> PREFIX sec: <http://www.rdfabout.com/rdf/schema/ussec/> PREFIX seccik: <http://www.rdfabout.com/rdf/usgov/sec/id/> Example QueriesTry out these examples: Find who is on the board of directors of both Ford and EBay:
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX sec: <http://www.rdfabout.com/rdf/schema/ussec/>
PREFIX seccik: <http://www.rdfabout.com/rdf/usgov/sec/id/>
SELECT ?name WHERE {
[foaf:name ?name]
sec:hasRelation [ sec:corporation [foaf:name "FORD MOTOR CO"] ];
sec:hasRelation [ sec:corporation [foaf:name "EBAY INC"] ].
}
|