Workforce By Industry: 2001 - 2021

This data set indicates how many people employed in Cambridge are covered by the unemployment insurance compensation system, the number employed by economic sector, and how much these workers earn.

The data covers the work force in Cambridge, regardless of their place of residence, and are taken from the Commonwealth of Massachusetts, Executive Office of Labor and Workforce Development, ES-202 Series based on the requirements set forth in the Massachusetts Employment Security Law and the Compensation for Federal Employees Law. Note that the unemployment compensation system does cover all workers, excluding groups such as the self-employer, religious workers and some domestic workers.

This data set assigns workers to sectors using the North American Industrial Classification System (NAICS) code system. Prior to 2001 only the Standard Industrial Classification (SIC) system was used to assign workers to sectors. Older, historic data is available in the open data set "Cambridge Workforce By Industry: 1967 - 2001". The 2001 figures summarize the same raw data but are recoded to NAICS here.

Note that Natural Resources and Mining establishments are not included in the industry breakdown but are included in total employment.

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 \"cambridgema-gov/workforce-by-industry-2001-2021-cmjx-t9pi\".\"workforce_by_industry_2001_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.