Educational Attainment by Age Range and Gender 2009-2016 County Annual Education

data.pa.gov | Last Updated 17 Oct 2022

County level educational attainment data on the adult working aged population (25-64) by age range and gender. Data is sourced from the US Census Bureau’s American Community Survey (ACS) 5-year estimates allowing for increased statistical reliability of the data for less populated areas and small population subgroups. More information here - https://www.census.gov/data/developers/data-sets/acs-5year.html

Tags: education, attainment, workforce, job

This dataset has the following 17 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Census Yearcensus_yearcalendar_dateThe calendar year of the Census survey.
County FIPS Codecounty_fips_codetextThis is the 5-digit FIPS code for each county. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html
Economic Development Regioneconomic_development_regiontextThe PA Department of Economic Development region of the county (https://dced.pa.gov/dced-regional-offices/).
Workforce Development Areaworkforce_development_areatextThe PA Workforce Development Area in which the county is located (https://www.pawork.org/about/
County Namecounty_nametextThe name of the county. Pennsylvania has 67 counties.
County Codecounty_codetextThis is a 2-digit text field that aligns counties within Pennsylvania with a code that can be used to integrate other datasets with this same field.
Age Rangeage_rangetextThe age range of adults represented in this record.
GendergendertextThe gender of adults represented in this record
Total Populationtotal_populationnumberThe total population of the record (equal to the sum of the attainment level values).
No High School Diplomano_high_school_diplomanumberThe estimated number of adults with no high school diploma.
High School Diploma Or Equivalenthigh_school_diploma_ornumberThe estimated number of adults with a high school diploma or equivalent credential.
Some College No Degreesome_college_no_degreenumberThe estimated number of adults with some college experience, but no degree.
Associate's Degreeassociate_s_degreenumberThe estimated number of adults with an associate’s degree.
Bachelor's Degreebachelor_s_degreenumberThe estimated number of adults with a bachelor’s degree.
Graduate or Professional Degreegraduate_or_professionalnumberThe estimated number of adults with a graduate or professional degree.
Total Post-Secondary Degreestotal_post_secondarynumberThe number of adults with either an Associate's, Bachelor's, or Graduate/Professional Degree
New Georeferenced Columngeocoded_columnlocationThis is a geo-coded column with a centroid or Latitude and Longitude generic point for each county so that the information can be used to create a mapping visualization.