This documentation demonstrates the main functionality of the CorpWatch API. The API publishes information about public companies and their subsidiaries scraped from the subsidiary section of their SEC 10-K filings. There are many known errors in the output data. The API, database, and scraping code are being developed for CorpWatch by Greg Michalec and Skye Bender-deMoll, with funding provided by a grant from the Sunlight Foundation.
This API is ready for public release but is still subject to change. The API is currently serving data from the 2003-2009 filing periods and will be updated periodically as new filings become available. The documentation is partially generated via calls to the API.
We welcome questions, bug reports and feedback or suggestions about the API structure. Please email support@api.corpwatch.org.
/['year']/companies
?search_parameters=parameter_values/cw_id_of_company/locations/names/filings/parents/children/history/availableYears/companyNames/companyLocations/industryCodes/placeNamesThe response will always contain two sections:
meta: contains information about the searchresult: contains the actual data elements retrieved as a list of companies, years, company_names, filings, locations, groups, or countries objects.success: A boolean value noting whether or not the request was successfully completed
status: The HTTP status code corresponding to the success or failure of the request (see Error Types for more details)
query: The SQL query used to generate the results (for debugging purposes only - will not appear in public API)
total_results: The total number of entries in the database which fulfill the request query. This will not correspond to the number of entities returned if it exceeds the response limit.
results_complete: A boolean value indicating whether the returned entities represent the total number that fulfill the request
api_version: Indicates what version of the API returned the results. The first number indicates the api source code version number, the date indicates the SEC data release used in processing.
parameters: An associative array containing the list of modifiers used by the request and their values. This includes both parameters set by the user as well as system-imposed defaults. The meanings of limit and index are described in the section on "paging" and the function of year is given in the section on filing years below.
The API is set up to support multiple output types, currently JSON and XML. The type of data returned is determined by suffix (".xml" ".json") of the method called, defaulting to JSON.
http://api.corpwatch.org/dummy_method.xml<?xml version="1.0" encoding="UTF-8"?>
<corpwatch>
<meta>
<success>0</success>
<status>400</status>
<status_string>User Input Error: Bad url: dummy_method</status_string>
<total_results>0</total_results>
<results_complete>0</results_complete>
<api_version>0.04 (2012-02-03)</api_version>
<parameters>
<limit>100</limit>
<index>0</index>
<year>most_recent</year>
</parameters>
</meta>
<result />
</corpwatch>
http://api.corpwatch.org/dummy_method.json{ "meta": { "success": 0, "status": 400, "status_string": "User Input Error: Bad url: dummy_method", "total_results": 0, "results_complete": 0, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { } }
http://api.corpwatch.org/api_method.json?param_name=value&key=abcd1234efghi56789jklmnop
The basic entity is the company, indexed by its newly-minted CorpWatch company id (cw_id). To retrieve the summary information for a single company, we can append the company id to the /companies path. For example, to return info on a single company by its cw id:
Example url: http://api.corpwatch.org/companies/cw_1572.json
Response:
{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "cw_1572": { "cw_id": "cw_1572", "cik": "86144", "company_name": "SAFEWAY INC", "irs_number": "943019135", "sic_code": "5411", "industry_name": "Retail-grocery stores", "sic_sector": "5400", "sector_name": "Food stores", "source_type": "filers", "raw_address": "5918 STONERIDGE MALL RD, PLEASANTON CA 94588", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_1572", "num_parents": "0", "num_children": "40", "max_year": "2011", "min_year": "2003" } } } }
cw_id : id for the company within our databasecik : SEC's Central Index Key id code for filing companiescompany_name : our standardized name for the companyirs_number : IRS EIN (tax id) for the company, if knownsic_code : Standard Industrial Classification code for the company, if knownindustry_name : text version of the SIC codesic_sector : code for the higher-level SIC sectorsector_name : text version of the higher-level SIC sectorsource_type : "filers" indicates a filing company, "relationships" indicates a company parsed from the Exhibit 21 relationshipsraw_address : most complete of known addresses for the companycountry_code : two-letter UN country code for raw_addresssubdiv_code : two- or three-letter UN subdivision (state or province) code for raw_addresstop_parent_id : calculated best guess of the cw_id at the top of the hierarchy this company is a part of num_parents : number of known "parent" companies that this company is a subsidiary ofnum_children : number of known "child" (subsidiary) companies that this company hasmax_year : most recent year that filing data is available for this company via the APImin_year : least recent year that filing data is available for this company via the APIThe API provides data reported in SEC filings from 2003-2009, and will be updated periodically as new data becomes available. Because properties of the companies may change over time (including name, location, number of subsidiaries, etc) many methods require that a year be specified in order to deliver the appropriate data in the company object. The year is requested with a four-digit year at the top level of the url. For example, to get data pertaining to 2008, the url should always begin with:
http://api.corpwatch.org/2008/...
The year field of the query meta parameters returned will also indicate the time period the request was processed for.
http://api.corpwatch.org/availableYears.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1982494", "results_complete": 0, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "years": [ "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012" ] } }
As companies file their SEC paperwork at different times, the most recent year is usually not fully complete - not all of the companies will have submitted their filings. If no year is specified in a request, the API will deliver the most recent data available for that company. Note: this means that if a year value is not specified for a method that returns multiple company objects, it is possible that the companies will contain data for different years. In this case, the year query parameter will have the value "most_recent" and the data in the company object will correspond to the year indicated by max_year.
For example, notice how the properties like company_name and num_children vary for McAffe Inc, which changed its name from Network Associates in its 2004 filings:
http://api.corpwatch.org/2003/companies/cw_8484.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "2003" } }, "result": { "companies": { "cw_8484": { "cw_id": "cw_8484", "cik": "890801", "company_name": "NETWORKS ASSOCIATES INC", "irs_number": "770316593", "sic_code": "7372", "industry_name": "Services-prepackaged software", "sic_sector": "7300", "sector_name": "Business services", "source_type": "filers", "raw_address": "3965 FREEDOM CIRCLE, SANTA CLARA CA 95054", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_8484", "num_parents": "0", "num_children": "9", "max_year": "2011", "min_year": "2003" } } } }
http://api.corpwatch.org/2004/companies/cw_8484.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "2004" } }, "result": { "companies": { "cw_8484": { "cw_id": "cw_8484", "cik": "890801", "company_name": "McAfee Inc", "irs_number": "770316593", "sic_code": "7372", "industry_name": "Services-prepackaged software", "sic_sector": "7300", "sector_name": "Business services", "source_type": "filers", "raw_address": "3965 FREEDOM CIRCLE, SANTA CLARA CA 95054", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_8484", "num_parents": "0", "num_children": "2", "max_year": "2011", "min_year": "2003" } } } }
http://api.corpwatch.org/companies/cw_8484.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "cw_8484": { "cw_id": "cw_8484", "cik": "890801", "company_name": "McAfee Inc", "irs_number": "770316593", "sic_code": "7372", "industry_name": "Services-prepackaged software", "sic_sector": "7300", "sector_name": "Business services", "source_type": "filers", "raw_address": "3965 FREEDOM CIRCLE, SANTA CLARA CA 95054", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_8484", "num_parents": "0", "num_children": "2", "max_year": "2011", "min_year": "2003" } } } }
/history method, which returns a list of company objects (indexed by year) with the appropriate values for the company for each year. In this case, even though CITIZENS BANK has a max_year of 2008 and a min_year of 2004, we don't actually have data for any of the intermediate years.
http://api.corpwatch.org/companies/cw_373/history.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "2", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "year_2004": { "cw_id": "cw_373", "cik": "20447", "company_name": "CITIZENS BANK", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "ONE CITIZENS BANKING CNTR, FLINT MI 48502", "country_code": "US", "subdiv_code": "MI", "top_parent_id": "cw_373", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2004", "year": "2004" }, "year_2008": { "cw_id": "cw_373", "cik": "20447", "company_name": "CITIZENS BANK NEW HAMPSHIRE", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "875 ELM ST, MANCHESTER NH 03101", "country_code": "US", "subdiv_code": "NH", "top_parent_id": "cw_373", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2004", "year": "2008" } } } }
year parameter in the url.
Because we have parsed in mailing addresses, business addresses, and jurisdiction of incorporation, each company may have multiple locations associated with it. To retrieve them use the /locations method:
http://api.corpwatch.org/companies/cw_1014/locations.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "9", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "locations": [ { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "CO", "type": "business", "raw_address": "6300 S SYRACUSE WAY STE 300, ENGLEWOOD CO 80111-6723", "street_1": "6300 S SYRACUSE WAY STE 300", "street_2": null, "city": "ENGLEWOOD", "state": "CO", "postal_code": "80111-6723", "country": null, "date": "2003-11-26", "max_year": "2003", "min_year": "2003" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "CO", "type": "mailing", "raw_address": "6300 S SYRACUSE WAY SUITE 300, ENGLEWOOD CO 80111", "street_1": "6300 S SYRACUSE WAY SUITE 300", "street_2": null, "city": "ENGLEWOOD", "state": "CO", "postal_code": "80111", "country": null, "date": "2003-11-26", "max_year": "2003", "min_year": "2003" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "CT", "type": "business", "raw_address": "765 STRAITS TURNPIKE, SUITE 2000, MIDDLEBURY CT 06762", "street_1": "765 STRAITS TURNPIKE", "street_2": "SUITE 2000", "city": "MIDDLEBURY", "state": "CT", "postal_code": "06762", "country": null, "date": "2004-11-24", "max_year": "2005", "min_year": "2004" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "CT", "type": "mailing", "raw_address": "765 STRAITS TURNPIKE, SUITE 2000, MIDDLEBURY CT 06762", "street_1": "765 STRAITS TURNPIKE", "street_2": "SUITE 2000", "city": "MIDDLEBURY", "state": "CT", "postal_code": "06762", "country": null, "date": "2004-11-24", "max_year": "2005", "min_year": "2004" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "DE", "type": "state_of_incorp", "raw_address": "DE", "street_1": null, "street_2": null, "city": null, "state": null, "postal_code": null, "country": null, "date": "2003-11-26", "max_year": "2011", "min_year": "2003" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "MO", "type": "business", "raw_address": "305 ROCK INDUSTRIAL PARK DRIVE, BRIDGETON MO 63044", "street_1": "305 ROCK INDUSTRIAL PARK DRIVE", "street_2": null, "city": "BRIDGETON", "state": "MO", "postal_code": "63044", "country": null, "date": "2008-06-19", "max_year": "2011", "min_year": "2008" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "MO", "type": "mailing", "raw_address": "305 ROCK INDUSTRIAL PARK DRIVE, BRIDGETON MO 63044", "street_1": "305 ROCK INDUSTRIAL PARK DRIVE", "street_2": null, "city": "BRIDGETON", "state": "MO", "postal_code": "63044", "country": null, "date": "2008-06-19", "max_year": "2011", "min_year": "2008" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "VA", "type": "business", "raw_address": "2461 S. CLARK ST., SUITE 630, ARLINGTON VA 22202", "street_1": "2461 S. CLARK ST.", "street_2": "SUITE 630", "city": "ARLINGTON", "state": "VA", "postal_code": "22202", "country": null, "date": "2006-11-28", "max_year": "2007", "min_year": "2006" }, { "cw_id": "cw_1014", "country_code": "US", "subdiv_code": "VA", "type": "mailing", "raw_address": "2461 S. CLARK ST., SUITE 630, ARLINGTON VA 22202", "street_1": "2461 S. CLARK ST.", "street_2": "SUITE 630", "city": "ARLINGTON", "state": "VA", "postal_code": "22202", "country": null, "date": "2006-11-28", "max_year": "2007", "min_year": "2006" } ] } }
If you scroll through the results you will notice that this company changes locations several times over the years although it remains incorporated in Delaware. For efficiency, we do not repeatedly store the same locations for successive years. Instead each location record includes dates indicating the range of filings it was parsed from with the min_year and max_year properties. The complete set of known locations will be returned, regardless of what year parameter is set in the request.
The origin of the location information is given by the type parameter, with a value of "relation_loc", "business", "mailing" or "state_of_incorp". The location information available for subsidiaries (type of "relation_loc") is much less precise than for filing companies. Because of the differences in filings formats, we are not able to automatically determine wether the location is a jurisdiction of incorporation or the location where the subsidiary company does business. The former is more common.
/names method:
http://api.corpwatch.org/companies/cw_36284/names.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "6", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "names": [ { "company_name": "Blackwater Midstream Corp", "cw_id": "cw_36284", "source": "filer_match_name", "date": "2008-11-14", "max_year": "2011", "min_year": "2008" }, { "company_name": "BLACKWATER MIDSTREAM CORP", "cw_id": "cw_36284", "source": "cik_former_name", "date": null, "max_year": "2007", "min_year": "2004" }, { "company_name": "Blackwater Midstream Corp.", "cw_id": "cw_36284", "source": "filer_conformed_name", "date": "2008-11-14", "max_year": "2011", "min_year": "2008" }, { "company_name": "Laycor Ventures Corp", "cw_id": "cw_36284", "source": "filer_match_name", "date": "2004-12-29", "max_year": "2007", "min_year": "2004" }, { "company_name": "LAYCOR VENTURES CORP", "cw_id": "cw_36284", "source": "cik_former_name", "date": null, "max_year": "2011", "min_year": "2008" }, { "company_name": "Laycor Ventures Corp.", "cw_id": "cw_36284", "source": "filer_conformed_name", "date": "2004-12-29", "max_year": "2007", "min_year": "2004" } ] } }
max_year and min_year give the time range of filings that the company used each name. The date is the date of the filing the name was parsed from.
The source parameter indicates how the name was derived. For example, "filer_match_name" is a standardized form with most punctuation removed, "filer_conformed_name" is the official name registered with the SEC and "cik_former_name" indicates a previous SEC name for the filer that may be earlier than our data coverage. The parsed subsidiaries will have a "relationships_company_name" which is as close as possible to the name listed in Exhibit 21, and "relationships_clean_company" which is the standardized name used for matching.
/filings method.
http://api.corpwatch.org/2008/companies/cw_1572/filings.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "2008" } }, "result": { "filings": [ { "cw_id": "cw_1572", "cik": "86144", "year": "2008", "quarter": "1", "period_of_report": "20071229", "filing_date": "2008-02-26", "form_10K_url": "http:\/\/www.sec.gov\/Archives\/edgar\/data\/86144\/0001193125-08-038856.txt", "sec_21_url": "http:\/\/www.sec.gov\/Archives\/edgar\/data\/86144\/000119312508038856\/dex211.htm", "company_is_filer": "1" } ] } }
form_10K_url but some filings will not have a sec_21_url because they did not file an Exhibit 21. If the company_is_filer parameter = 1, it means the filings was made in the company's name, otherwise the company appeared on a subsidiaries list. If the company for some reason did not file a 10-K form, or has not yet filed yet for the current year, it is possible that no filings will be shown.
top_parent_id.) In reality the ownership patterns can be much more complex than a simple "tree", many types of relationships are not reported in the filing, and some companies have multiple "parents". We are also not able to parse all of the filings completely or correctly. For example, we are forced to skip over subsidiary company listings that do not include jurisdiction or location information, and in some cases we are not able to parse the hierarchy described within a filing.
The "parents" and "children" methods below return only the immediate parents and children - the next step up or down in the hierarchy when the ownership relations are described as a tree. However, for those filings for which we have been unable to extract the hierarchy, all of the subsidiaries found (both direct and indirect) will be returned.
These methods respect the year parameter in the request url. If a year is specified, only subsidiaries/parents for that year will be returned and the data in the company objects returned will be set appropriately for the request year.
To look up the "parents" (principal owning companies) of a company we append /parents after the company id and the API will return a list of company objects that are above in the hierarchy.
For example, if we look at Wise LLC in 2007:
Example url: http://api.corpwatch.org/2007/companies/cw_100970/parents.json
Response:
{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "2007" } }, "result": { "companies": { "cw_21795": { "cw_id": "cw_21795", "cik": "1144945", "company_name": "PENN VIRGINIA RESOURCE PARTNERS L P", "irs_number": "233087517", "sic_code": "1221", "industry_name": "Bituminous coal & lignite surface mining", "sic_sector": "1200", "sector_name": "Coal mining", "source_type": "filers", "raw_address": "THREE RADNOR CORP CTR, 100 MATSONFORD RD STE 300, RADNOR PA 19087", "country_code": "US", "subdiv_code": "PA", "top_parent_id": "cw_21795", "num_parents": "0", "num_children": "10", "max_year": "2012", "min_year": "2003" } } } }
http://api.corpwatch.org/2008/companies/cw_100970/parents.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "3", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "2008" } }, "result": { "companies": { "cw_1411": { "cw_id": "cw_1411", "cik": "77159", "company_name": "PENN VIRGINIA CORP", "irs_number": "231184320", "sic_code": "1311", "industry_name": "Crude petroleum & natural gas", "sic_sector": "1300", "sector_name": "Oil and gas extraction", "source_type": "filers", "raw_address": "100 MATSONFORD ROAD SUITE 300, THREE RADNOR CORPORATE CENTER, RADNOR PA 19087", "country_code": "US", "subdiv_code": "PA", "top_parent_id": "cw_1411", "num_parents": "0", "num_children": "48", "max_year": "2012", "min_year": "2003" }, "cw_45170": { "cw_id": "cw_45170", "cik": "1366292", "company_name": "Penn Virginia GP Holdings LP", "irs_number": "205116532", "sic_code": "1221", "industry_name": "Bituminous coal & lignite surface mining", "sic_sector": "1200", "sector_name": "Coal mining", "source_type": "filers", "raw_address": "THREE RADNOR CORPORATE CENTER, SUITE 300, RADNOR PA 19087", "country_code": "US", "subdiv_code": "PA", "top_parent_id": "cw_1411", "num_parents": "1", "num_children": "31", "max_year": "2011", "min_year": "2006" }, "cw_21795": { "cw_id": "cw_21795", "cik": "1144945", "company_name": "PENN VIRGINIA RESOURCE PARTNERS L P", "irs_number": "233087517", "sic_code": "1221", "industry_name": "Bituminous coal & lignite surface mining", "sic_sector": "1200", "sector_name": "Coal mining", "source_type": "filers", "raw_address": "THREE RADNOR CORP CTR, 100 MATSONFORD RD STE 300, RADNOR PA 19087", "country_code": "US", "subdiv_code": "PA", "top_parent_id": "cw_21795", "num_parents": "0", "num_children": "29", "max_year": "2012", "min_year": "2003" } } } }
/children method returns a set of companies that are the subsidiaries or "children" of a company - in this case Safeway Inc
http://api.corpwatch.org/2008/companies/cw_1572/children.json{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "45", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "limit": 100, "index": 0, "year": "2008" } }, "result": { "companies": { "cw_162649": { "cw_id": "cw_162649", "cik": "0", "company_name": "Blackhawk Marketing LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2010", "min_year": "2007" }, "cw_162641": { "cw_id": "cw_162641", "cik": "1411488", "company_name": "Blackhawk Network Holdings Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "4", "max_year": "2011", "min_year": "2007" }, "cw_162650": { "cw_id": "cw_162650", "cik": "0", "company_name": "Casa Ley Services Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2008" }, "cw_162651": { "cw_id": "cw_162651", "cik": "0", "company_name": "Cayam Energy LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162652": { "cw_id": "cw_162652", "cik": "0", "company_name": "ePOS! Marketing Co", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "CA", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162653": { "cw_id": "cw_162653", "cik": "0", "company_name": "GFM Holdings I Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2007" }, "cw_162656": { "cw_id": "cw_162656", "cik": "0", "company_name": "GFM Holdings II Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2010", "min_year": "2007" }, "cw_162657": { "cw_id": "cw_162657", "cik": "0", "company_name": "Lahaina Beverage Management Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "HI", "country_code": "US", "subdiv_code": "HI", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "4", "max_year": "2009", "min_year": "2007" }, "cw_225126": { "cw_id": "cw_225126", "cik": "0", "company_name": "Milford Insurance (Bermuda) Ltd (Bermuda)", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "Bermuda", "country_code": "BM", "subdiv_code": null, "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2008" }, "cw_162663": { "cw_id": "cw_162663", "cik": "0", "company_name": "Milford Insurance Brokerage Services Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162664": { "cw_id": "cw_162664", "cik": "0", "company_name": "Oakland Property Brokerage Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162665": { "cw_id": "cw_162665", "cik": "0", "company_name": "Pak N Save Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "CA", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162666": { "cw_id": "cw_162666", "cik": "0", "company_name": "Photo Acquisition I Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2008", "min_year": "2007" }, "cw_162668": { "cw_id": "cw_162668", "cik": "0", "company_name": "Point Fosdick Square LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "WA", "country_code": "US", "subdiv_code": "WA", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162669": { "cw_id": "cw_162669", "cik": "0", "company_name": "Randalls Holdings Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "3", "max_year": "2011", "min_year": "2007" }, "cw_162676": { "cw_id": "cw_162676", "cik": "0", "company_name": "Safeway #0638 Exchange LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "OR", "country_code": "US", "subdiv_code": "OR", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162677": { "cw_id": "cw_162677", "cik": "0", "company_name": "Safeway Australia Holdings Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162678": { "cw_id": "cw_162678", "cik": "0", "company_name": "Safeway Canada Holdings Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2007" }, "cw_162686": { "cw_id": "cw_162686", "cik": "0", "company_name": "Safeway Claim Services Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162687": { "cw_id": "cw_162687", "cik": "0", "company_name": "Safeway Corporate Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "4", "max_year": "2011", "min_year": "2007" }, "cw_162692": { "cw_id": "cw_162692", "cik": "0", "company_name": "Safeway Dallas Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "16", "max_year": "2011", "min_year": "2007" }, "cw_162709": { "cw_id": "cw_162709", "cik": "0", "company_name": "Safeway Denver Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "7", "max_year": "2011", "min_year": "2007" }, "cw_162717": { "cw_id": "cw_162717", "cik": "0", "company_name": "Safeway Gift Cards LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "AZ", "country_code": "US", "subdiv_code": "AZ", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162718": { "cw_id": "cw_162718", "cik": "0", "company_name": "Safeway Global Sourcing Holdings Ltd", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "BVI", "country_code": "VG", "subdiv_code": null, "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2008" }, "cw_162720": { "cw_id": "cw_162720", "cik": "0", "company_name": "Safeway Holdings I LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2007" }, "cw_162723": { "cw_id": "cw_162723", "cik": "0", "company_name": "Safeway Leasing Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162724": { "cw_id": "cw_162724", "cik": "0", "company_name": "Safeway Liquor Stores Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "WY", "country_code": "US", "subdiv_code": "WY", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162725": { "cw_id": "cw_162725", "cik": "0", "company_name": "Safeway of Western Nebraska Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "NE", "country_code": "US", "subdiv_code": "NE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162726": { "cw_id": "cw_162726", "cik": "0", "company_name": "Safeway Philtech Holdings Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2007" }, "cw_162728": { "cw_id": "cw_162728", "cik": "0", "company_name": "Safeway Richmond Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "2", "max_year": "2011", "min_year": "2007" }, "cw_162732": { "cw_id": "cw_162732", "cik": "0", "company_name": "Safeway Select Gift Source Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162733": { "cw_id": "cw_162733", "cik": "0", "company_name": "Safeway Southern California Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "5", "max_year": "2011", "min_year": "2007" }, "cw_162739": { "cw_id": "cw_162739", "cik": "0", "company_name": "Safeway Stores 42 Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162740": { "cw_id": "cw_162740", "cik": "0", "company_name": "Safeway Stores 43 Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162741": { "cw_id": "cw_162741", "cik": "0", "company_name": "Safeway Stores 64 Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162742": { "cw_id": "cw_162742", "cik": "0", "company_name": "Safeway Stores 99 Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162743": { "cw_id": "cw_162743", "cik": "0", "company_name": "Safeway Stores Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2007" }, "cw_162744": { "cw_id": "cw_162744", "cik": "0", "company_name": "Safeway Supply Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "8", "max_year": "2011", "min_year": "2007" }, "cw_162753": { "cw_id": "cw_162753", "cik": "0", "company_name": "Safeway Trucking Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162754": { "cw_id": "cw_162754", "cik": "0", "company_name": "SRG Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162755": { "cw_id": "cw_162755", "cik": "0", "company_name": "SSI AK Holdings Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2007" }, "cw_162759": { "cw_id": "cw_162759", "cik": "0", "company_name": "Taylor Properties Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162760": { "cw_id": "cw_162760", "cik": "0", "company_name": "Vons REIT Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "DE", "country_code": "US", "subdiv_code": "DE", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2007" }, "cw_162769": { "cw_id": "cw_162769", "cik": "0", "company_name": "Vons Sherman Oaks LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "OR", "country_code": "US", "subdiv_code": "OR", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_162770": { "cw_id": "cw_162770", "cik": "0", "company_name": "Westgate Center LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "WA", "country_code": "US", "subdiv_code": "WA", "top_parent_id": "cw_1572", "num_parents": "1", "num_children": "0", "max_year": "2008", "min_year": "2007" } } } }
To retrieve groups of companies that match some criteria, we add query parameters to the /companies url using the?to indicate the parameters. This will return a list of companies in the result indexed by the company cw_id. However, it will only search for companies that had a property that matches within the specified year. If no year is specified, it will search the most recent year for each company.
http://api.corpwatch.org/2008/companies.json?sic_code=2011{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "8", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "sic_code": "2011", "limit": 100, "index": 0, "year": "2008" } }, "result": { "companies": { "cw_39027": { "cw_id": "cw_39027", "cik": "1317880", "company_name": "Diamond Ranch Foods Ltd NEW", "irs_number": "201389815", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "555 WEST STREET, NEW YORK NY 10014", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_39027", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2005" }, "cw_4408": { "cw_id": "cw_4408", "cik": "766659", "company_name": "ENERGROUP HOLDINGS CORP", "irs_number": "870420774", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "NO. 9, XIN YI STREET, GANJINGZI DISTRICT, DALIAN CITY,, LIAONING PROVINCE, F4 116039", "country_code": "CN", "subdiv_code": null, "top_parent_id": "cw_4408", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_881": { "cw_id": "cw_881", "cik": "48465", "company_name": "HORMEL FOODS CORP", "irs_number": "410319970", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "1 HORMEL PL, AUSTIN MN 55912-3680", "country_code": "US", "subdiv_code": "MN", "top_parent_id": "cw_881", "num_parents": "0", "num_children": "50", "max_year": "2012", "min_year": "2003" }, "cw_34134": { "cw_id": "cw_34134", "cik": "1273784", "company_name": "NATIONAL BEEF PACKING CO LLC", "irs_number": "481129505", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "12200 NORTH AMBASSADOR DRIVE, KANSAS CITY MO 64163", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_34134", "num_parents": "0", "num_children": "9", "max_year": "2011", "min_year": "2003" }, "cw_20131": { "cw_id": "cw_20131", "cik": "1122491", "company_name": "PERDIGAO SA", "irs_number": "0", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "760 AV ESCOLA POLITECNIA, JAGUARE 05350-000, SAO PAULO SP BRAZIL D5 00000", "country_code": "BR", "subdiv_code": null, "top_parent_id": "cw_20131", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2003" }, "cw_1598": { "cw_id": "cw_1598", "cik": "88121", "company_name": "SEABOARD CORP", "irs_number": "42260388", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "9000 W. 67TH STREET, SHAWNEE MISSION KS 66202", "country_code": "US", "subdiv_code": "KS", "top_parent_id": "cw_1598", "num_parents": "0", "num_children": "90", "max_year": "2011", "min_year": "2003" }, "cw_1651": { "cw_id": "cw_1651", "cik": "91388", "company_name": "SMITHFIELD FOODS INC", "irs_number": "520845861", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "200 COMMERCE STREET, EXECUTIVE OFFICE BUILDING, SMITHFIELD VA 23430", "country_code": "US", "subdiv_code": "VA", "top_parent_id": "cw_1651", "num_parents": "0", "num_children": "146", "max_year": "2012", "min_year": "2003" }, "cw_34528": { "cw_id": "cw_34528", "cik": "1277092", "company_name": "ZHONGPIN INC", "irs_number": "542100419", "sic_code": "2011", "industry_name": "Meat packing plants", "sic_sector": "2000", "sector_name": "Food and kindred products", "source_type": "filers", "raw_address": "C\/O PRYOR CASHMAN SHERMAN & FLYNN LLP, 410 PARK AVENUE, NEW YORK NY 10022", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_34528", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2004" } } } }
http://api.corpwatch.org/2008/companies.json?sic_sector=4100{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "10", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "sic_sector": "4100", "limit": 100, "index": 0, "year": "2008" } }, "result": { "companies": { "cw_14157": { "cw_id": "cw_14157", "cik": "1035423", "company_name": "ATLANTIC EXPRESS TRANSPORTATION CORP", "irs_number": "133924567", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "7 NORTH STREET, STATEN ISLAND, NEW YORK NY 10302-1205", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_14157", "num_parents": "0", "num_children": "1", "max_year": "2009", "min_year": "2004" }, "cw_23353": { "cw_id": "cw_23353", "cik": "1170016", "company_name": "BESTWAY COACH EXPRESS INC", "irs_number": "133961159", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "2 MOTT STREET, SUITE 705, NEW YORK NY 10013", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_23353", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2004" }, "cw_19693": { "cw_id": "cw_19693", "cik": "1114875", "company_name": "CONCORDIA BUS AB PUBL", "irs_number": "0", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "CT CORPORATION SYSTEM, 111 EIGHTH AVE, NEW YORK NY 10011", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_19693", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2003" }, "cw_36216": { "cw_id": "cw_36216", "cik": "1291823", "company_name": "Concordia Bus Nordic AB", "irs_number": "0", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "SOLNA STRANDVAG 78, SOLNA V7 SE-171 54", "country_code": "SE", "subdiv_code": null, "top_parent_id": "cw_36216", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2004" }, "cw_36217": { "cw_id": "cw_36217", "cik": "1291827", "company_name": "Concordia Bus Nordic Holding AB", "irs_number": "0", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "SOLNA STRANDVAG 78, SOLNA V7 SE-171 54", "country_code": "SE", "subdiv_code": null, "top_parent_id": "cw_36217", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2004" }, "cw_42075": { "cw_id": "cw_42075", "cik": "1344154", "company_name": "Emergency Medical Services CORP", "irs_number": "203738384", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "6200 S. SYRACUSE WAY, GREENWOOD VILLAGE CO 80111", "country_code": "US", "subdiv_code": "CO", "top_parent_id": "cw_42075", "num_parents": "0", "num_children": "156", "max_year": "2011", "min_year": "2005" }, "cw_41003": { "cw_id": "cw_41003", "cik": "1334544", "company_name": "Emergency Medical Services LP", "irs_number": "0", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "6200 SOUTH SYRACUSE WAY, SUITE 200, GREENWOOD VILLAGE CO 80111", "country_code": "US", "subdiv_code": "CO", "top_parent_id": "cw_41003", "num_parents": "0", "num_children": "156", "max_year": "2011", "min_year": "2005" }, "cw_238498": { "cw_id": "cw_238498", "cik": "737874", "company_name": "LAIDLAW INTERNATIONAL INC", "irs_number": "980390488", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "55 SHUMAN BLVD., SUITE 400, NAPERVILLE IL 60563", "country_code": "US", "subdiv_code": "IL", "top_parent_id": "cw_238498", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2003" }, "cw_9405": { "cw_id": "cw_9405", "cik": "906326", "company_name": "RURAL\/METRO CORP", "irs_number": "860746929", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "9221 EAST VIA DE VENTURA, SCOTTSDALE AZ 85258", "country_code": "US", "subdiv_code": "AZ", "top_parent_id": "cw_9405", "num_parents": "0", "num_children": "81", "max_year": "2011", "min_year": "2003" }, "cw_44976": { "cw_id": "cw_44976", "cik": "1364796", "company_name": "Southland Health Services Inc", "irs_number": "200340136", "sic_code": "4100", "industry_name": "Local & suburban transit & interurban hwy passenger trans", "sic_sector": "4100", "sector_name": "Local and interurban passenger transit", "source_type": "filers", "raw_address": "2344 WOODRIDGE AVENUE, KINGSPORT TN 37664", "country_code": "US", "subdiv_code": "TN", "top_parent_id": "cw_44976", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2006" } } } }
/industryCodes method and the section on "Getting lists of categories" below.
Lists of companies can also be returned by searching the company name.
Example url: http://api.corpwatch.org/2008/companies.json?company_name=safeway+inc
Response:
{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "company_name": "safeway inc", "limit": 100, "index": 0, "year": "2008" } }, "result": { "companies": { "cw_1572": { "cw_id": "cw_1572", "cik": "86144", "company_name": "SAFEWAY INC", "irs_number": "943019135", "sic_code": "5411", "industry_name": "Retail-grocery stores", "sic_sector": "5400", "sector_name": "Food stores", "source_type": "filers", "raw_address": "5918 STONERIDGE MALL RD, PLEASANTON CA 94588", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_1572", "num_parents": "0", "num_children": "45", "max_year": "2011", "min_year": "2003" } } } }
substring_match=1 parameter is added to the query, the words in the search query will be treated as phrase to be matched anywhere they appears as part of a company name. The drawback is that using the substring_match parameter can make searches take 10 times longer and places a much heavier load on the servers hosting the API.
Although the search actually takes place in the overall collection of company names, each company is returned only once. This means that if a search matches against a company name alias, the matching name might not be the one shown in the company summary information. Some filer companies that have changed their names will have a cik_former_name that will match independent of the year restriction. (This is helpful when searching for companies that may have recently changed their names.)
Note: spaces and other characters that are not permitted in urls must be properly escaped or the query will be truncated. Spaces should be replaced with "+" or "%20".
http://api.corpwatch.org/companies?cik=37996{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "cik": "37996", "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "cw_721": { "cw_id": "cw_721", "cik": "37996", "company_name": "FORD MOTOR CO", "irs_number": "380549190", "sic_code": "3711", "industry_name": "Motor vehicles & passenger car bodies", "sic_sector": "3700", "sector_name": "Transportation equipment", "source_type": "filers", "raw_address": "ONE AMERICAN ROAD, DEARBORN MI 48126", "country_code": "US", "subdiv_code": "MI", "top_parent_id": "cw_721", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2003" } } } }
http://api.corpwatch.org/companies.json?irs_number=911653725{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "1", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "irs_number": "911653725", "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "cw_10884": { "cw_id": "cw_10884", "cik": "933136", "company_name": "WASHINGTON MUTUAL INC", "irs_number": "911653725", "sic_code": "6035", "industry_name": "Savings institution, federally chartered", "sic_sector": "6000", "sector_name": "Depository institutions", "source_type": "filers", "raw_address": "1301 SECOND AVENUE, SEATTLE WA 98101", "country_code": "US", "subdiv_code": "WA", "top_parent_id": "cw_10884", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2003" } } } }
raw_address) of company addresses for a specific fragment, like the word "empire":
http://api.corpwatch.org/companies.json?raw_address=empire{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "83", "results_complete": 1, "api_version": "0.04 (2012-02-03)", "parameters": { "raw_address": "empire", "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "cw_246437": { "cw_id": "cw_246437", "cik": "1000897", "company_name": "AZUREL LTD", "irs_number": "0", "sic_code": "2844", "industry_name": "Perfumes, cosmetics & other toilet preparations", "sic_sector": "2800", "sector_name": "Chemicals and allied products", "source_type": "filers", "raw_address": "EMPIRE STATE BUILDING, 350 5TH AVENUE SUITE 2204, NEW YORK NY 10118", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_246437", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2003" }, "cw_390514": { "cw_id": "cw_390514", "cik": "1456787", "company_name": "DRAGON JADE INTERNATIONAL LTD", "irs_number": "0", "sic_code": "7389", "industry_name": "Services-business services, nec", "sic_sector": "7300", "sector_name": "Business services", "source_type": "filers", "raw_address": "SUITE 14B EMPIRE LAND COMMERICAL CENTER, 81-86 LOCKHART ROAD, HONG KONG F4 00000", "country_code": "CN", "subdiv_code": null, "top_parent_id": "cw_390514", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2009" }, "cw_13315": { "cw_id": "cw_13315", "cik": "1023512", "company_name": "DRDGOLD LTD", "irs_number": "0", "sic_code": "1040", "industry_name": "Gold and silver ores", "sic_sector": "1000", "sector_name": "Metal mining", "source_type": "filers", "raw_address": "45 EMPIRE ROAD, PARKTOWN, JOHANNESBURG T3 2193", "country_code": "ZA", "subdiv_code": null, "top_parent_id": "cw_13315", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_240084": { "cw_id": "cw_240084", "cik": "831659", "company_name": "DURHAM MARKETING CORP", "irs_number": "870454377", "sic_code": "7372", "industry_name": "Services-prepackaged software", "sic_sector": "7300", "sector_name": "Business services", "source_type": "filers", "raw_address": "2621 WEST EMPIRE AVENUE, SUITE 0, BURBANK CA 91504", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_240084", "num_parents": "0", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_605563": { "cw_id": "cw_605563", "cik": "1133957", "company_name": "EMPIRE DISTRICT ELECTRIC TRUST I", "irs_number": null, "sic_code": "4911", "industry_name": "Electric services", "sic_sector": "4900", "sector_name": "Electric, gas, and sanitary services", "source_type": "filers", "raw_address": "C\/O THE EMPIRE DISTRICT ELECTRIC CO., 602 JOPLIN ST, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_605563", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_20898": { "cw_id": "cw_20898", "cik": "1134010", "company_name": "EMPIRE DISTRICT ELECTRIC TRUST II", "irs_number": null, "sic_code": "4911", "industry_name": "Electric services", "sic_sector": "4900", "sector_name": "Electric, gas, and sanitary services", "source_type": "filers", "raw_address": "602 JOPLIN ST, C\/O EMPIRE DISTRICT ELECTRIC CO, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_20898", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_748": { "cw_id": "cw_748", "cik": "39273", "company_name": "FROZEN FOOD EXPRESS INDUSTRIES INC", "irs_number": "751301831", "sic_code": "4213", "industry_name": "Trucking (no local)", "sic_sector": "4200", "sector_name": "Motor freight transportation and warehousing", "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_748", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2003" }, "cw_238389": { "cw_id": "cw_238389", "cik": "729365", "company_name": "KAISER VENTURES INC", "irs_number": "940594733", "sic_code": "6519", "industry_name": "Lessors of real property, nec", "sic_sector": "6500", "sector_name": "Real estate", "source_type": "filers", "raw_address": "3633 E INLAND EMPIRE BLVD, STE 850, ONTARIO CA 91764-4922", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_238389", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2004" }, "cw_21789": { "cw_id": "cw_21789", "cik": "1144834", "company_name": "KAISER VENTURES LLC", "irs_number": "0", "sic_code": "6519", "industry_name": "Lessors of real property, nec", "sic_sector": "6500", "sector_name": "Real estate", "source_type": "filers", "raw_address": "3633 E INLAND EMPIRE BLVD, STE 850, ONTARIO CA 91764-4922", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_21789", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2003" }, "cw_33536": { "cw_id": "cw_33536", "cik": "1267023", "company_name": "LBI MEDIA HOLDINGS INC", "irs_number": "0", "sic_code": "4832", "industry_name": "Radio broadcasting stations", "sic_sector": "4800", "sector_name": "Communications", "source_type": "filers", "raw_address": "1845 WEST EMPIRE AVE., BURBANK CA 91504", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_33536", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2003" }, "cw_313656": { "cw_id": "cw_313656", "cik": "1279094", "company_name": "LIBERMAN BROADCASTING INC", "irs_number": "0", "sic_code": "4832", "industry_name": "Radio broadcasting stations", "sic_sector": "4800", "sector_name": "Communications", "source_type": "filers", "raw_address": "1845 WEST EMPIRE AVENUE, BURBANK CA 91504", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_313656", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2004" }, "cw_622661": { "cw_id": "cw_622661", "cik": "1505323", "company_name": "ADF FOODS (USA) LTD", "irs_number": "273571601", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "EMPIRE STATE BUILDING - C\/O SONNY ANAND, 350 FIFTH AVENUE, 41ST FLOOR, NEW YORK NY 10118", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_622661", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_345422": { "cw_id": "cw_345422", "cik": "1336579", "company_name": "Aflease Gold & Uranium Resources Ltd", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "AFLEASE GOLD & URANIUM RESOURCES LTD, 55 EMPIRE ROAD, PARKTOWN 2193 SOUTH T3 000000", "country_code": "ZA", "subdiv_code": null, "top_parent_id": "cw_345422", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2005" }, "cw_5942": { "cw_id": "cw_5942", "cik": "822359", "company_name": "AFLEASE GOLD LTD", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "GROUND FLOOR, BLOCK A, EMPIRE OFFICE PARK, 55 EMPIRE ROAD, PARKTOWN T3 00000", "country_code": "ZA", "subdiv_code": null, "top_parent_id": "cw_5942", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2003" }, "cw_622442": { "cw_id": "cw_622442", "cik": "1505076", "company_name": "Anderson Sarah J", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3633 E. INLAND EMPIRE BLVD., SUITE 480, ONTARIO CA 91764", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_622442", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_397521": { "cw_id": "cw_397521", "cik": "1466843", "company_name": "ARIES NETWORK INC", "irs_number": "954805027", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "2101 EMPIRE STREET, BURBANK CA 91504", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_397521", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_298564": { "cw_id": "cw_298564", "cik": "1247615", "company_name": "ARO THOMAS W", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "PO BOX 5013, C\/O EMPIRE RESORTS INC, MONTICELLO NY 12701", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_298564", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2005" }, "cw_294626": { "cw_id": "cw_294626", "cik": "1237320", "company_name": "BAGGETT W MIKE", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PL, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_294626", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2005" }, "cw_24796": { "cw_id": "cw_24796", "cik": "1182595", "company_name": "BARNES EDWARD A", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1349 EMPIRE CENTRAL, SUITE 900, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_24796", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2004" }, "cw_296301": { "cw_id": "cw_296301", "cik": "1241560", "company_name": "BENDHEIM JACK", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESOURCES, INC., 1 PARKER PLAZA, SUIET 10, FORT LEE NJ 07024", "country_code": "US", "subdiv_code": "NJ", "top_parent_id": "cw_296301", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2007" }, "cw_32809": { "cw_id": "cw_32809", "cik": "1258946", "company_name": "BERNSTEIN JOSEPH E", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "EMPIRE RESORTS INC, PO BOX 5013, MONTICELLO NY 12701", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_32809", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2003" }, "cw_349586": { "cw_id": "cw_349586", "cik": "1344652", "company_name": "Catania Frank", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESORTS, INC., 701 N. GREEN VALLEY PARKWAY, SUITE 200, HENDERSON NV 89074", "country_code": "US", "subdiv_code": "NV", "top_parent_id": "cw_349586", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2005" }, "cw_366350": { "cw_id": "cw_366350", "cik": "1378421", "company_name": "Colgin Harold R II", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 JOPLIN STREEY, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_366350", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2006" }, "cw_30855": { "cw_id": "cw_30855", "cik": "1238666", "company_name": "COOK TERRY L", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "KAISER VENTURES LLC, 3633 E. INLAND EMPIRE BLVD., SUITE 480, ONTARIO CA 91764", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_30855", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_633773": { "cw_id": "cw_633773", "cik": "1514702", "company_name": "DAS SATYA BRATA", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "SUITE 208 EMPIRE BUILDING, 10080 JASPER AVENUE, EDMONTON A0 T5J 1V9", "country_code": "CA", "subdiv_code": "AB", "top_parent_id": "cw_633773", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_59961": { "cw_id": "cw_59961", "cik": "1428788", "company_name": "Degliomini Charles", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESORTS, INC., 701 N. GREEN VALLEY PARKWAY, SUITE 200, HENDERSON NV 89074", "country_code": "US", "subdiv_code": "NV", "top_parent_id": "cw_59961", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_396385": { "cw_id": "cw_396385", "cik": "1465390", "company_name": "DISTRESSED ASSET FUND I LP", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O BARONE EMPIRE MANAGEMENT, LLC, 5776 RUFFIN ROAD, SAN DIEGO CA 92123", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_396385", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_668027": { "cw_id": "cw_668027", "cik": "1532304", "company_name": "Driftmier Donald A.", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3130-C INLAND EMPIRE BLVD., ONTARIO CA 91764", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_668027", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_59783": { "cw_id": "cw_59783", "cik": "1428528", "company_name": "Ehrlich Clifford", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESORTS, INC., 701 N. GREEN VALLEY PARKWAY, SUITE 200, HENDERSON NV 89074", "country_code": "US", "subdiv_code": "NV", "top_parent_id": "cw_59783", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_66796": { "cw_id": "cw_66796", "cik": "1441794", "company_name": "Empire District Electric Trust III", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 JOPLIN AVENUE, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_66796", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_390537": { "cw_id": "cw_390537", "cik": "1456816", "company_name": "eSolar Inc", "irs_number": "20796258", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3355 W. EMPIRE AVENUE, SUITE 200, BURBANK CA 91504", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_390537", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2009" }, "cw_660155": { "cw_id": "cw_660155", "cik": "1522646", "company_name": "Fine Scott A", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE CAPITAL MANAGEMENT, LLC, ONE GORHAM ISLAND, SUITE 201, WESTPORT CT 06880", "country_code": "US", "subdiv_code": "CT", "top_parent_id": "cw_660155", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_280182": { "cw_id": "cw_280182", "cik": "1201160", "company_name": "GAGNE KEVIN M", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE FINANCIAL GROUP INC, 1385 WEST STATES ROAD 434, LONGWOOD FL 32750", "country_code": "US", "subdiv_code": "FL", "top_parent_id": "cw_280182", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2005" }, "cw_282732": { "cw_id": "cw_282732", "cik": "1207866", "company_name": "GIBSON DAVID W", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE DISTRICT ELECTRIC CO, 602 JOPLIN STREET PO BOX 127, JOPLIN MO 64802", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_282732", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2004" }, "cw_282814": { "cw_id": "cw_282814", "cik": "1208108", "company_name": "GRIMES ROBERT S", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O RS GRIMES & CO INC, EMPIRE STATE BLDG 350 FIFTH AVE STE 7801, NEW YORK NY 10018", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_282814", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2004" }, "cw_10154": { "cw_id": "cw_10154", "cik": "920062", "company_name": "HEALTHCARE COMMUNITY SECURITIES Corp", "irs_number": "141764768", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "ONE EMPIRE DRIVE, RENSSELAER NY 12144", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_10154", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_351569": { "cw_id": "cw_351569", "cik": "1348267", "company_name": "Hickerson John", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_351569", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2006" }, "cw_353025": { "cw_id": "cw_353025", "cik": "1351220", "company_name": "Huang Brenda", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "750 E. EMPIRE AVENUE, SALT LAKE CITY UT 84106", "country_code": "US", "subdiv_code": "UT", "top_parent_id": "cw_353025", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_357131": { "cw_id": "cw_357131", "cik": "1359297", "company_name": "ICB Financial", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3999 e inland empire blvd, ontario ca 91764", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_357131", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_257849": { "cw_id": "cw_257849", "cik": "1097717", "company_name": "KAHN NATHAN", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESOURCES INC, 1 PARKER PL. #10, FORT LEE NJ 07024", "country_code": "US", "subdiv_code": "NJ", "top_parent_id": "cw_257849", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2005" }, "cw_296303": { "cw_id": "cw_296303", "cik": "1241566", "company_name": "KAHN SANDRA", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESOURCES, INC., 1 PARKER PLAZA, SUIET 10, FORT LEE NJ 07024", "country_code": "US", "subdiv_code": "NJ", "top_parent_id": "cw_296303", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2007" }, "cw_282112": { "cw_id": "cw_282112", "cik": "1206288", "company_name": "KEHNEMUND MARK D", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "7030 EMPIRE CENTRAL DR, HOUSTON TX 77040", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_282112", "num_parents": "0", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_400638": { "cw_id": "cw_400638", "cik": "1470647", "company_name": "Kilpatrick Kevin", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_400638", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_638269": { "cw_id": "cw_638269", "cik": "1520578", "company_name": "Kluesener John W.", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3633 INLAND EMPIRE BLVD., SUITE 480, ONTARIO CA 91764", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_638269", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_389069": { "cw_id": "cw_389069", "cik": "1454358", "company_name": "Knutson Ronald J", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_389069", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_276714": { "cw_id": "cw_276714", "cik": "1192511", "company_name": "KRCA TELEVISION INC", "irs_number": "951457322", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1845 WEST EMPIRE AVENUE, BURBANK CA 91504", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_276714", "num_parents": "0", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_282858": { "cw_id": "cw_282858", "cik": "1208212", "company_name": "MARTIN LINDA L", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1349 EMPIRE CENTRAL, SUITE 900, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_282858", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_294192": { "cw_id": "cw_294192", "cik": "1236195", "company_name": "MCELWEE F DIXON JR", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PL, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_294192", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2004" }, "cw_282733": { "cw_id": "cw_282733", "cik": "1207871", "company_name": "MCKINNEY MYRON W", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE DISTRICT ELECTRIC CO, 602 JOPLIN STREET PO BOX 127, JOPLIN MO 64802", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_282733", "num_parents": "0", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_404724": { "cw_id": "cw_404724", "cik": "1476149", "company_name": "McManama John", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_404724", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_282051": { "cw_id": "cw_282051", "cik": "1206145", "company_name": "MELIA ROSALIE T", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "7030 EMPIRE CENTRAL DR, HOUSTON TX 77040", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_282051", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2003" }, "cw_637401": { "cw_id": "cw_637401", "cik": "1519312", "company_name": "MERTENS BLAKE A", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 S JOPLIN AVENUE, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_637401", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_676909": { "cw_id": "cw_676909", "cik": "1539322", "company_name": "METROPOLITAN GLOBAL TAXICAB CORP", "irs_number": "721621938", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "EMPIRE STATE BUILDING, 350 FIFTH AV., 59TH FLOOR, NEW YORK NY 10118", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_676909", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2012" }, "cw_342550": { "cw_id": "cw_342550", "cik": "1331454", "company_name": "Milner Louis R", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESOURCES, INC., ONE PARK PLAZA, FORT LEE NJ 07024", "country_code": "US", "subdiv_code": "NJ", "top_parent_id": "cw_342550", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2005" }, "cw_321391": { "cw_id": "cw_321391", "cik": "1292972", "company_name": "Mullis Wade", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1349 EMPIRE CENTRAL, SUITE 900, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_321391", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_280146": { "cw_id": "cw_280146", "cik": "1201083", "company_name": "PATRICK MATTHEW G", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "11835 NE GLENN WIDING DR, BLDG E, PORTLAND OR 97220", "country_code": "US", "subdiv_code": "OR", "top_parent_id": "cw_280146", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_665747": { "cw_id": "cw_665747", "cik": "1529455", "company_name": "Penalty Box Restaurants LLC", "irs_number": "272544626", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3212 EAST EMPIRE STREET, BLOOMINGTON IL 61704", "country_code": "US", "subdiv_code": "IL", "top_parent_id": "cw_665747", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_631868": { "cw_id": "cw_631868", "cik": "1512450", "company_name": "Penning Martin O", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 S. JOPLIN AVENUE, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_631868", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_295921": { "cw_id": "cw_295921", "cik": "1240613", "company_name": "PETERSEN SANDRA", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O ASSISTED LIVING CONCEPTS, 1349 EMPIRE CENTRAL #900, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_295921", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_394030": { "cw_id": "cw_394030", "cik": "1462439", "company_name": "Portney Paul R", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 S JOPLIN AVENUE, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_394030", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_27625": { "cw_id": "cw_27625", "cik": "1207868", "company_name": "POSNER MARY MCCLEARY", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE DISTRICT ELECTRIC CO, 602 JOPLIN STREET PO BOX 127, JOPLIN MO 64802", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_27625", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_350192": { "cw_id": "cw_350192", "cik": "1345784", "company_name": "Pruden Gary M", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_350192", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2005" }, "cw_660156": { "cw_id": "cw_660156", "cik": "1522647", "company_name": "Richards Peter J", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE CAPITAL MANAGEMENT, LLC, ONE GORHAM ISLAND, SUITE 201, WESTPORT CT 06880", "country_code": "US", "subdiv_code": "CT", "top_parent_id": "cw_660156", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_381176": { "cw_id": "cw_381176", "cik": "1411580", "company_name": "Roberts Michael William", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE ENERGY CORPORATION INT., 16801 W. 116TH STREET, SUITE 100, LENEXA KS 66219", "country_code": "US", "subdiv_code": "KS", "top_parent_id": "cw_381176", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2007" }, "cw_294190": { "cw_id": "cw_294190", "cik": "1236193", "company_name": "ROBERTSON CHARLES G", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PL, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_294190", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2004" }, "cw_663918": { "cw_id": "cw_663918", "cik": "1527263", "company_name": "Sager Robert W", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 S JOPLIN AVENUE, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_663918", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_357115": { "cw_id": "cw_357115", "cik": "1359248", "company_name": "SBCVC FUND II L P A CAYMAN ISLANDS EXEMPTED L P", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "15 A-C HUA MIN EMPIRE PLAZA, 728 WEST YAN AN RD, SHANGHI CHINA F4 200050", "country_code": "CN", "subdiv_code": null, "top_parent_id": "cw_357115", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_361785": { "cw_id": "cw_361785", "cik": "1368653", "company_name": "SBCVC Fund II L.P. A Cayman Islands Exempted Limited Partnership", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "15 A-C Hua Min Empire Plaza, 728 West An Rd, Shanghai, China F4 00000", "country_code": "CN", "subdiv_code": null, "top_parent_id": "cw_361785", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_385796": { "cw_id": "cw_385796", "cik": "1430927", "company_name": "SBCVC FUND III LP", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "15 A-C HUA MIN EMPIRE PLAZA, 728 WEST YAN AN ROAD, SHANGHAI E9 200050", "country_code": "KY", "subdiv_code": null, "top_parent_id": "cw_385796", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_357116": { "cw_id": "cw_357116", "cik": "1359249", "company_name": "SBCVC PRINCIPALS FUND II L P A CAYMAN ISLAND EXEMPTED L P", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "15 A-C HUA MIN EMPIRE PLAZA, 728 WEST YAN AM RD, SHANGHAI CHINA F4 200050", "country_code": "CN", "subdiv_code": null, "top_parent_id": "cw_357116", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2007" }, "cw_296566": { "cw_id": "cw_296566", "cik": "1242203", "company_name": "SMITH MORRIS P", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESOURCES INC, 1 PARKER PLZ #10, FORT LEE NJ 07024", "country_code": "US", "subdiv_code": "NJ", "top_parent_id": "cw_296566", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2005" }, "cw_56962": { "cw_id": "cw_56962", "cik": "1423364", "company_name": "St. George William Richard Jr", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "152 WEST 57TH STREET, EMPIRE ADVISORY 27TH FLOOR, NEW YORK NY 10019", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_56962", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_394151": { "cw_id": "cw_394151", "cik": "1462582", "company_name": "Steven D Staal", "irs_number": "264669710", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "15 S G ST, EMPIRE CA 95319", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_394151", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_30854": { "cw_id": "cw_30854", "cik": "1238663", "company_name": "STODDARD RICHARD E", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "KAISER VENTURES LLC, 3633 E. INLAND EMPIRE BLVD., SUITE 480, ONTARIO CA 91764", "country_code": "US", "subdiv_code": "CA", "top_parent_id": "cw_30854", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2004" }, "cw_42137": { "cw_id": "cw_42137", "cik": "1344399", "company_name": "Stoney Russell Stubbs", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_42137", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2005" }, "cw_30613": { "cw_id": "cw_30613", "cik": "1236196", "company_name": "STUBBS STONEY M JR", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_30613", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2004" }, "cw_602537": { "cw_id": "cw_602537", "cik": "1490154", "company_name": "Sullivan C James", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "THE EMPIRE DISTRICT ELECTRIC COMPANY, 602 S JOPLIN AVENUE, JOPLIN MO 64801", "country_code": "US", "subdiv_code": "MO", "top_parent_id": "cw_602537", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_676308": { "cw_id": "cw_676308", "cik": "1538572", "company_name": "Traders Circle Inc", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "EMPIRE STATE BUILDING, 350 FIFTH AVENUE, 59TH FLOOR, NEW YORK NY 10118", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_676308", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2012" }, "cw_246999": { "cw_id": "cw_246999", "cik": "1007876", "company_name": "VICK STEVEN L", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1349 EMPIRE CENTRAL SUITE 900, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_246999", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_267383": { "cw_id": "cw_267383", "cik": "1164543", "company_name": "WILMERS ROBERT G", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "FIRST EMPIRE STATE CORP, ONE M&T PLAZA, BUFFALO NY 14240", "country_code": "US", "subdiv_code": "NY", "top_parent_id": "cw_267383", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2003" }, "cw_296305": { "cw_id": "cw_296305", "cik": "1241568", "company_name": "WRUBEL HARVEY", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O EMPIRE RESOURCES, INC., 1 PARKER PLAZA, SUIET 10, FORT LEE NJ 07024", "country_code": "US", "subdiv_code": "NJ", "top_parent_id": "cw_296305", "num_parents": "0", "num_children": "0", "max_year": "2007", "min_year": "2007" }, "cw_43430": { "cw_id": "cw_43430", "cik": "1353925", "company_name": "Yetter Thomas G", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "1145 EMPIRE CENTRAL PLACE, DALLAS TX 75247", "country_code": "US", "subdiv_code": "TX", "top_parent_id": "cw_43430", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2006" }, "cw_644066": { "cw_id": "cw_644066", "cik": "0", "company_name": "Empire Sports & Entertainment", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "The Empire Sports & Entertainment, Co", "country_code": "CL", "subdiv_code": "CO", "top_parent_id": "cw_61791", "num_parents": "1", "num_children": "1", "max_year": "2011", "min_year": "2011" } } } }
substring_match=1 parameter will cause the query to return cases where the search string matches anywhere in the raw_address field, at a severe penalty to performance.
Most of the address have also been matched to the standardized UN country and subdivision codes. The majority of the subsidiary companies do not have complete addresses in the filings, but most have at least some location information. For example we can search for companies tagged as having an address in the Virgin Islands (country_code "VI"):
Example url: http://api.corpwatch.org/companies?country_code=VI
Response:
{ "meta": { "success": 1, "status": 200, "status_string": "Success", "total_results": "385", "results_complete": 0, "api_version": "0.04 (2012-02-03)", "parameters": { "country_code": "VI", "limit": 100, "index": 0, "year": "most_recent" } }, "result": { "companies": { "cw_391333": { "cw_id": "cw_391333", "cik": "1458182", "company_name": "Acadia Liquidity Fund LP", "irs_number": "263946917", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "52 KING STREET, 3RD FLOOR, SUITE 1& 2, CHRISTIANSTED VI 00820", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_391333", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2009" }, "cw_312418": { "cw_id": "cw_312418", "cik": "1276722", "company_name": "AGRADE LTD", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "PO BOX OFFSHORE INC. CENTRE, ROAD TOWN, TORTOLA BRITISH V.I. VI 00000", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_312418", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_599420": { "cw_id": "cw_599420", "cik": "1452766", "company_name": "ALPINE SECURITIES USVI LLC", "irs_number": "660710378", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "6100 RED HOOK QRT#2 SUITE A2-3, ST. THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_599420", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2010" }, "cw_34885": { "cw_id": "cw_34885", "cik": "1280052", "company_name": "ASCEND MARKET NEUTRAL FUND LTD", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "PO BOX 3460, BISON FINANCIAL SERVICES LTD, TORTOLA VI 00000", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_34885", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2006" }, "cw_627161": { "cw_id": "cw_627161", "cik": "1452764", "company_name": "C T U S INVESTORS LP", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "34-35 Dronningens Gade, Hibiscus Alley, St. Thomas, U.S. VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_627161", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2011" }, "cw_260343": { "cw_id": "cw_260343", "cik": "1115793", "company_name": "DENALI PARTNERS L P", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "5020 ANCHOR WAY, 2ND FLOOR, CHRISTIANSTED VI 00820-4633", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_260343", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2009" }, "cw_580933": { "cw_id": "cw_580933", "cik": "1134560", "company_name": "DRIEHAUS CAPITAL MANAGEMENT (USVI) LLC", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "TUNICK BUILDING 1336 BELTJEN ROAD, THOMAS UNITED STATE VIRGIN ISLANDS, US VIRGIN ISLANDS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_580933", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2003" }, "cw_662542": { "cw_id": "cw_662542", "cik": "1525605", "company_name": "Financial Trust Co Inc", "irs_number": "660567418", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "6100 RED HOOK QUARTER, SUITE B-3, ST. THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_662542", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2011" }, "cw_605740": { "cw_id": "cw_605740", "cik": "1269609", "company_name": "GC ST CROIX CO INC", "irs_number": "660575696", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "14A NORRE GADE, ST. THOMAS VI 0000", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_605740", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_316199": { "cw_id": "cw_316199", "cik": "1283412", "company_name": "GRENMA INC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "4034 & 4035 CHRISTIANSTED, ST CROIX VI 00820", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_316199", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2004" }, "cw_6397": { "cw_id": "cw_6397", "cik": "837641", "company_name": "GRUEN HANS PETER", "irs_number": "111111111", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "VIA CA' BALBI 82, VICENZA 36100 L6 FOREIGN", "country_code": "IT", "subdiv_code": null, "top_parent_id": "cw_6397", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2003" }, "cw_344998": { "cw_id": "cw_344998", "cik": "1335812", "company_name": "King Street Institutional Ltd", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O WALKERS CHAMBER, P.O. BOX 92, ROAD TOWN, TORTOLA D8", "country_code": "VG", "subdiv_code": null, "top_parent_id": "cw_344998", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2005" }, "cw_18926": { "cw_id": "cw_18926", "cik": "1104186", "company_name": "MASTERS CAPITAL MANAGEMENT LLC", "irs_number": "582440923", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "PO BOX 224229, CHRISTIANSTED VI 00822", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_18926", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_15631": { "cw_id": "cw_15631", "cik": "1056767", "company_name": "MILLER & JACOBS CAPITAL LLC", "irs_number": "133920489", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "PO BOX 26039 GALLOWS BAY STATION, CHRISTRANSTED ST CRO VI 00824", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_15631", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2004" }, "cw_13919": { "cw_id": "cw_13919", "cik": "1032442", "company_name": "MILLER JEFFREY A", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "P O BOX 26039, GALLOWS BAY STATION, CHRISTIANSTED VI 00824", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_13919", "num_parents": "0", "num_children": "0", "max_year": "2009", "min_year": "2003" }, "cw_317926": { "cw_id": "cw_317926", "cik": "1286531", "company_name": "MINSTER DOUGLAS J", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O ATLANTIC TELE-NETWORK, INC., 9719 ESTATE THOMAS HAVENSIGHT, ST THOMAS, VIRGIN IS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_317926", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_303231": { "cw_id": "cw_303231", "cik": "1258915", "company_name": "MORAINE INVESTMENTS INC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "CHARLOTTE HOUSE, CHARLOTTE ST PO BOX N-65, NASSAU C5 00000", "country_code": "BS", "subdiv_code": null, "top_parent_id": "cw_303231", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_582175": { "cw_id": "cw_582175", "cik": "1483103", "company_name": "Nexus Capital Investing Ltd", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "TRIDENT CHAMBERS, WICKHAMS CAY 1, P.O. BOX 146, ROAD TOWN TORTOLA VI VG1110", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_582175", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_341755": { "cw_id": "cw_341755", "cik": "1329936", "company_name": "NUTMEG GROUP LLC", "irs_number": "660617525", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "3346 COMMERCIAL AVENUE, NORTHBROOK IL 60062", "country_code": "US", "subdiv_code": "IL", "top_parent_id": "cw_341755", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2005" }, "cw_317927": { "cw_id": "cw_317927", "cik": "1286532", "company_name": "PARRISH STEVEN J", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O ATLANTIC TELE-NETWORK INC, 5719 ESTATE THOMAS HAVENSIGHT, ST THOMAS, VIRGIN IS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_317927", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_348154": { "cw_id": "cw_348154", "cik": "1341779", "company_name": "Patricia L Armstrong Trust", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O ELIZABETH A ARMSTRONG, CO-TRUSTEE, P.O. BOX 25200, GALLOWS BAY, ST. CRO VI 00824", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_348154", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2005" }, "cw_360763": { "cw_id": "cw_360763", "cik": "1366518", "company_name": "Prior Family Foundation", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "P.O. BOX 12030, ST. THOMAS VI 00801", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_360763", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_360944": { "cw_id": "cw_360944", "cik": "1366935", "company_name": "Prior Gertrude J", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "P O BOX 12030, ST THOMAS VI 00801", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_360944", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_336416": { "cw_id": "cw_336416", "cik": "1320252", "company_name": "PRUDENT GLOBAL NATURAL RESOUCRCES FUND LP", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "43-46 NORREE GADE STE 137, ST THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_336416", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2005" }, "cw_362848": { "cw_id": "cw_362848", "cik": "1371255", "company_name": "PRUDENT GLOBAL NATURAL RESOURCES FUND II L P", "irs_number": "0", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "43-46 NORRE GADE STE 137, ST THOMAS USVI VI 00000", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_362848", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_577127": { "cw_id": "cw_577127", "cik": "1429162", "company_name": "REMBRANDT PARTNERS MASTER FUND LTD", "irs_number": "980330077", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O BISON FINANCIAL SERVICES LTD, P.O. BOX 3460, ROAD TOWN, TORTOLA D8 B VI", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_577127", "num_parents": "0", "num_children": "0", "max_year": "2012", "min_year": "2010" }, "cw_619021": { "cw_id": "cw_619021", "cik": "1503759", "company_name": "Saunders Paul H.", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "5001 TAMARIND REEF, SUITE 28, CHRISTIANSTED, ST. CROIX VI 00820", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_619021", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_8447": { "cw_id": "cw_8447", "cik": "890222", "company_name": "SESLIA VIRGIN ISLANDS SECURITIES INC", "irs_number": "660485436", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "2107 CRYSTAL GADE 7A, CHARLOTTE AMALIE, ST THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_8447", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_58855": { "cw_id": "cw_58855", "cik": "1426812", "company_name": "SPCH LLLP", "irs_number": "660668213", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "6501 RED HOOK PLAZA, SUITE 201, ST. THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_58855", "num_parents": "0", "num_children": "0", "max_year": "2008", "min_year": "2008" }, "cw_329528": { "cw_id": "cw_329528", "cik": "1307483", "company_name": "Stonetree Group LLLP", "irs_number": "660618186", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "P. O. BOX 3032, KINGS HILL VI 00851", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_329528", "num_parents": "0", "num_children": "0", "max_year": "2004", "min_year": "2004" }, "cw_14798": { "cw_id": "cw_14798", "cik": "1044734", "company_name": "SUSSMAN S DONALD", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "6100 RED HOOK QUARTER, 18B, SUITES C, 1-6, ST. THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_14798", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_41803": { "cw_id": "cw_41803", "cik": "1342044", "company_name": "T H BROKERAGE SERVICES LLC", "irs_number": "203079812", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "6100 RED HOOK QTR #2, SUITE A2-3, ST. THOMAS VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_41803", "num_parents": "0", "num_children": "0", "max_year": "2011", "min_year": "2007" }, "cw_299512": { "cw_id": "cw_299512", "cik": "1250083", "company_name": "THOMPSON BRAD A", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "227 KING STREET, FREDERIKSTED VI 00840", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_299512", "num_parents": "0", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_353091": { "cw_id": "cw_353091", "cik": "1351360", "company_name": "VITAMIN WORLD (VI) INC", "irs_number": "331129839", "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "CITIBANK BUILDING, VETERAN'S DRIVE, SUITE 208, P.O. BOX 5304, ST. THOMAS VI 00803", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_353091", "num_parents": "0", "num_children": "0", "max_year": "2006", "min_year": "2006" }, "cw_298583": { "cw_id": "cw_298583", "cik": "1247673", "company_name": "WHEATLEY HENRY U", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "C\/O ATLANTIC TELENETWORK, INC., 19 ESTATE THOMAS HAVENSITE, ST, THOMAS, VIRGIN I VI 00801", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_298583", "num_parents": "0", "num_children": "0", "max_year": "2005", "min_year": "2005" }, "cw_600999": { "cw_id": "cw_600999", "cik": "1487836", "company_name": "White Bay Advisor USVI LLC", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "filers", "raw_address": "61000 Red Hook, Qtr #2, Suite A2 - 3, Saint Thomas VI 00802", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_600999", "num_parents": "0", "num_children": "0", "max_year": "2010", "min_year": "2010" }, "cw_405884": { "cw_id": "cw_405884", "cik": "0", "company_name": "&E Export Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_1564", "num_parents": "1", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_409458": { "cw_id": "cw_409458", "cik": "0", "company_name": "AAFC International Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_1816", "num_parents": "1", "num_children": "0", "max_year": "2004", "min_year": "2003" }, "cw_122869": { "cw_id": "cw_122869", "cik": "0", "company_name": "Abbott Trading Co Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_3", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2003" }, "cw_96307": { "cw_id": "cw_96307", "cik": "0", "company_name": "Aberdare Developments Ltd", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "Virgin Islands ,", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_18909", "num_parents": "1", "num_children": "0", "max_year": "2010", "min_year": "2003" }, "cw_96308": { "cw_id": "cw_96308", "cik": "0", "company_name": "Aberdare Two Developments Ltd", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "Virgin Islands ,", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_18909", "num_parents": "1", "num_children": "0", "max_year": "2010", "min_year": "2008" }, "cw_410564": { "cw_id": "cw_410564", "cik": "0", "company_name": "ACP Export Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_5648", "num_parents": "1", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_130443": { "cw_id": "cw_130443", "cik": "0", "company_name": "AFC Foreign Sales Corp", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_2578", "num_parents": "1", "num_children": "0", "max_year": "2011", "min_year": "2005" }, "cw_413821": { "cw_id": "cw_413821", "cik": "0", "company_name": "AIMCOR St. Croix", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_6379", "num_parents": "1", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_86501": { "cw_id": "cw_86501", "cik": "0", "company_name": "Aircraft Foreign Sales Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_502", "num_parents": "1", "num_children": "0", "max_year": "2009", "min_year": "2003" }, "cw_414749": { "cw_id": "cw_414749", "cik": "0", "company_name": "Aldila Foreign Sales Corp", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_9162", "num_parents": "1", "num_children": "0", "max_year": "2003", "min_year": "2003" }, "cw_414900": { "cw_id": "cw_414900", "cik": "0", "company_name": "Alexandra International Sales Inc", "irs_number": null, "sic_code": null, "industry_name": null, "sic_sector": null, "sector_name": null, "source_type": "relationships", "raw_address": "U.S. Virgin Islands", "country_code": "VI", "subdiv_code": null, "top_parent_id": "cw_1318", "num_parents": "3", "num_children": "0", "max_year": "2006", "min_year": "2003" }, "cw_415170": { "cw_id": "cw_415170", "cik": "0", "company_name": "Allen Organ International Inc",