Icon for Socrata external plugin
Updated 11 days ago
Indexed 3 hours ago

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

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 -


NameSocrata field nameColumn name in sgr mountData typeDescription
Workforce Development Areaworkforce_development_areaworkforce_development_areaTextThe PA Workforce Development Area in which the county is located (
Bachelor's Degreebachelor_s_degreebachelor_s_degreeNumberThe estimated number of adults with a bachelor’s degree.
Associate's Degreeassociate_s_degreeassociate_s_degreeNumberThe estimated number of adults with an associate’s degree.
High School Diploma Or Equivalenthigh_school_diploma_orhigh_school_diploma_orNumberThe estimated number of adults with a high school diploma or equivalent credential.
Total Post-Secondary Degreestotal_post_secondarytotal_post_secondaryNumberThe number of adults with either an Associate's, Bachelor's, or Graduate/Professional Degree
Graduate or Professional Degreegraduate_or_professionalgraduate_or_professionalNumberThe estimated number of adults with a graduate or professional degree.
Total Populationtotal_populationtotal_populationNumberThe total population of the record (equal to the sum of the attainment level values).
County Codecounty_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.
Economic Development Regioneconomic_development_regioneconomic_development_regionTextThe PA Department of Economic Development region of the county (
New Georeferenced Column (address)geocoded_column_addressgeocoded_column_addressText
New Georeferenced Column (city)geocoded_column_citygeocoded_column_cityText
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumber
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4Number
Pa Senatorial Districts (2017-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumber
Pa House Districts (2017-01):@computed_region_r6rf_p9et:@computed_region_r6rf_p9etNumber
Pa School Districts (2017):@computed_region_rayf_jjgk:@computed_region_rayf_jjgkNumber
New Georeferenced Column (zip)geocoded_column_zipgeocoded_column_zipText
New Georeferenced Column (state)geocoded_column_stategeocoded_column_stateText
Census Yearcensus_yearcensus_yearCalendar dateThe calendar year of the Census survey.
New Georeferenced Columngeocoded_columngeocoded_columnPointThis 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.
Age Rangeage_rangeage_rangeTextThe age range of adults represented in this record.
GendergendergenderTextThe gender of adults represented in this record
Some College No Degreesome_college_no_degreesome_college_no_degreeNumberThe estimated number of adults with some college experience, but no degree.
No High School Diplomano_high_school_diplomano_high_school_diplomaNumberThe estimated number of adults with no high school diploma.
County Namecounty_namecounty_nameTextThe name of the county. Pennsylvania has 67 counties.
County FIPS Codecounty_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 -
  • educational_attainment_by_age_range_and_gender
Upstream Metadata