Edmonton's labour market status, annual

The Labour Force Survey (LFS) provides participation rates, and employment and unemployment rates. This dataset is taken from Statistics Canada CANSIM table 14-10-0385-01 and presents the estimated number of people in the Edmonton census metropolitan area (CMA) that are in the labour force, in employment, unemployment and not in the labour force.

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 \"openperformance-edmonton-ca/edmontons-labour-market-status-annual-sgqp-8xua\".\"edmontons_labour_market_status_annual\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.