Full-time Workers Living Below the Poverty Level By Industry

Data from the American Community Survey (ACS) Public Use Microdata Sample (PUMS) 5-year estimate. Based on workers aged 18-64 who report usually working at least 30 hours per week last year and worked at least 27 weeks out of the year. The definition of poverty is based on HHS poverty guidelines to calculate family-level poverty, which accounts for family size.​

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 \"ramseycounty-us/fulltime-workers-living-below-the-poverty-level-by-9nfu-mswh\".\"fulltime_workers_living_below_the_poverty_level_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.