Median Household Income by Percentiles

American Community Survey data provided by the Urban Institute. To identify income percentiles, all households are ranked by income from lowest to highest. The income level at the threshold between the poorest 20 percent of households and the richest 80 percent is the 20th percentile. Similarly, the threshold between the poorest and richest halves is the 50th percentile (or median), and threshold between the poorest 80 percent and richest 20 percent is the 80th percentile.

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/median-household-income-by-percentiles-36zh-ityf\".\"median_household_income_by_percentiles\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.