LMISI - Michigan Union Membership

2008 - Present. Annual measures of union membership in Michigan. Dataset includes the total number of employed individuals in Michigan, the total number of individuals who hold union membership in Michigan, and the total number of individuals whose jobs are covered by a union or an employee association contract. Data provided by the Bureau of Labor Statistics in the US Department of Labor. To find more union membership data, visit https://www.bls.gov/webapps/legacy/cpslutab5.htm.

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 \"michigan-gov/lmisi-michigan-union-membership-9thz-9zpu\".\"lmisi_michigan_union_membership\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.