Race and Ethnicity Data

Dataset showing responses to questions on race and ethnicity. The data on race were derived from answers to the question on race that was asked of all people during the decennial (every ten years) Census. The U.S. Census Bureau collects race data in accordance with guidelines provided by the U.S. Office of Management and Budget (OMB), and these data are based on self-identification. The racial categories included in the census questionnaire generally reflect a social definition of race recognized in this country, and not an attempt to define race biologically, anthropologically, or genetically. In addition, it is recognized that the categories of the race item include racial and national origin or socio-cultural groups.

Definitions from OMB guide the Census Bureau in classifying written responses to the race question:

White

Black or African American

American Indian or Alaska Native

Asian

Native Hawaiian or Other Pacific Islander

Some Other Race

Two or More Races

There are two minimum categories for ethnicity: Hispanic or Latino and Not Hispanic or Latino. The federal government considers race and Hispanic origin to be two separate and distinct concepts. Hispanics and Latinos may be of any race

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/race-and-ethnicity-data-6gak-8jxa\".\"race_and_ethnicity_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.