Workforce By Industry: 1967 - 2001
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 (1967 to present) and the Compensation for Federal Employees Law (1980 to present). 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 the Standard Industrial Classification (SIC) system. Since 2001, only the North American Industrial Classification System (NAICS) code system is used to assign workers to sectors. Older, historic data is available in the open data set "Cambridge Workforce By Industry: 2001 - Present". The 2001 figures summarize the same raw data but are recoded to NAICS there.
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-1967-2001-pb99-d47j\".\"workforce_by_industry_1967_2001\"
LIMIT 100
"}
EOFSee the Splitgraph documentation for more information.