BP 2010 00 CZ2 Business Trends Zip Code by Occupation, Sector, and Establishment Size

2010 census data on the number of establishments per zip code grouped by sector and payrolled employees/establishment size. To create a pointmap of this dataset you must filter for "Meaning of 2007 North American Industry Classification System (NAICS)" AND "Number of Employees".

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bronx-lehman-cuny-edu/bp-2010-00-cz2-business-trends-zip-code-by-camc-vngn\".\"bp_2010_00_cz2_business_trends_zip_code_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.