mydata-iowa-gov/iowa-median-earnings-in-past-12-months-for-the-dzfq-93gb
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 2 hours ago

Iowa Median Earnings in Past 12 Months for the Civilian Employed Population 16 Years and Over by Industry (ACS 5-Year Estimates)

This dataset provides median earnings in past 12 months for the civilian employed population 16 years and over by industry for State of Iowa, individual Iowa counties, Iowa places and census tracts within Iowa. Data is from the American Community Survey, Five Year Estimates, Table B24031.

The following industries are included in the dataset: Agriculture forestry fishing and hunting, Mining quarrying and oil and gas extraction, Construction, Manufacturing, Wholesale trade, Retail trade, Transportation and warehousing, Utilities, Information, Finance and insurance, Real estate and rental and leasing, Professional scientific and technical services, Management of companies and enterprises, Administrative and support and waste management services, Educational services, Health care and social assistance, Arts entertainment and recreation, Accommodation and food services, Other services except public administration, and Public administration. A few roll up into industry groups.

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 \"mydata-iowa-gov/iowa-median-earnings-in-past-12-months-for-the-dzfq-93gb\".\"iowa_median_earnings_in_past_12_months_for_the\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • iowa_median_earnings_in_past_12_months_for_the
     
     
     
     
     
Upstream Metadata