Educational Attainment of Washington Population by Age, Race/Ethnicity/, and PUMA Region

The American Community Survey (ACS) is designed to estimate the characteristic distribution of populations* and estimated counts should only be used to calculate percentages. They do not represent the actual population counts or totals. Beginning in 2019, the Washington Student Achievement Council (WSAC) has measured educational attainment for the Roadmap Progress Report using one-year American Community Survey (ACS) data from the United States Census Bureau. These public microdata represents the most current data, but it is limited to areas with larger populations leading to some multi-county regions**.

*The American Community Survey is not the official source of population counts. It is designed to show the characteristics of the nation's population and should not be used as actual population counts or housing totals for the nation, states or counties. The official population count — including population by age, sex, race and Hispanic origin — comes from the once-a-decade census, supplemented by annual population estimates (which do not typically contain educational attainment variables) from the following groups and surveys:

-- Washington State Office of Financial Management (OFM):

  https://www.ofm.wa.gov/washington-data-research/population-demographics

-- US Census Decennial Census: https://www.census.gov/programs-surveys/decennial-census.html and Population Estimates Program: https://www.census.gov/programs-surveys/popest.html

**In prior years, WSAC used both the five-year and three-year (now discontinued) data. While the 5-year estimates provide a larger sample, they are not recommended for year to year trends and also are released later than the one-year files.

Detailed information about the ACS at https://www.census.gov/programs-surveys/acs/guidance.html

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 \"wa-gov/educational-attainment-of-washington-population-by-aqa5-4cee\".\"educational_attainment_of_washington_population_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.