Tag Archives: school age population

National Children & Education Statistics Program Updates

.. NCES Program updates .. tools, data & methodology to examine national scope children & education .. school, school district & extended geographic-statistical data with drill-down to school and intersection level. See more about the NCES Program below.

New this Week
ACS 2015 school district demographic-economic interactive tables
– view, compare, analyze selected/all U.S. school districts
– more focused blog updates coming soon.

School Districts with Highest Median Household Income
Use the interactive table to examine economic characteristics of school districts. Below is a list of the 10 school districts having the highest median household income developed using the Economic Characteristics interactive table. Develop similar views for metros and states of interest.

– ranked on item E062 — median household income.
– click graphic for larger view.

Use GIS tools to develop thematic pattern maps such as the one shown below with NCES GIS projects. Select from hundreds of statistical measures. Create your own regional;/district views. Integrate other data.

Patterns of Economic Prosperity by School District
– median household income (item E062 in table)

– view developed with CVGIS software & related GIS project and data.
– click graphic for larger view.

See the School Districts Economic Characteristics Interactive Table.

About the National Children & Education Statistics Program
The National Children & Education Statistics (NCES) Program provides access to tools, data & methodology to examine national scope children’s demographics & education-related characteristics. These resources enable stakeholders to view and analyze detailed geographic and statistical data at the school, neighborhood, community, attendance zone, school district and higher level geography. Integrate these data with drill-down demographic-economic data to the census block and intersection levels. Examine characteristics of schools, school districts and education data with related and higher level geography including urban/rural, cities, counties, metros, state and the U.S.

See NCES Main Section.

Contents: Summary of NCES Program Resources
Click a link to view more detail on a selected topic.
Updates: New Resources, Events & Related Topics
Analytics, Blogs, Studies
Using Software Tools & Datasets
01 Mapping & Visual Analysis Tools
02 School District Annual Demographic-Economic Data Resources
03 Children’s Demographics & Living Environment by School District
04 School District Enrollment & Operational Characteristics
05 School District Finances: Sources & Uses of Funds
06 School District Geographic Size & Characteristics
07 School District-ZIP Code Area Relationship Table
08 K-12 Public Schools
09 K-12 Private Schools
10 K-12 Public School Attendance Zones
11 K-12 Public Schools by Urban/Rural Status
12 Census Tract Demographic-Economic Characteristics
13 Metropolitan Area Situation & Outlook Reports

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Single Year of Age Demographics

Single year of age (SYOA) demographics are demographic data summarized for the single year of age population (e.g., age 1, age 2, etc.) for a geographic area such as a county, census tract or ZIP code area. This section is part one of three sections and is focused on tools and methods to access, integrate and analyze SYOA data. The second part is focused on integrating these data with other data and use of GIS and geospatial analysis. The third part reviews how these data are used to develop projections and access to/use of projections.  See more details in related Web section

Population Age 0 Relative to 1,000 Population by ZIP Code
  — Atlanta Metro


– Crude birth rate approximation: population age 0 relative to 1,000 population
– Darker green: rate 16+; medium green: rate 12-16; light green: less than 12
– Click graphic for larger view, zoom-in, labeled with ZIP codes and rate.
– View developed with CV XE GIS.

Using SYOA Demographics
Except for possibly the single year of age 0, less than one year of age, single year of age demographics are intrinsically not in high demand. The fact that the single year of age demographics can be aggregated to standardized age cohorts and custom age groups is another matter entirely. Analysts and researchers often need current estimates or projections for age-gender-race/origin groups that are not available from pre-planned tabulations.

Uses of these SYOA data include the basics of understanding the size of a specific age group relative to the total population. Or, how the size of a total population age group compares among genders or a specific race/origin. There are a myriad of more focused applications such as estimating voter propensities/outcomes for certain combinations of age by gender by race/origin combinations. What single year of age data are available and how can they be used to meet these needs?

SYOA Data Options
The only Census Bureau-sourced option for SYOA county or sub-county geography data from Census 2010 forward is Census 2010. Age-related data from the American Community Survey (ACS) exist only for age groups (other than a few selected single year tabulations). Age-related data from the Census Bureau model-based annual estimates (county-up) are only available at the 5-year age cohort level. Most SYOA data (covering each age to age 99 and 100 and over) are further broken out only by gender and race/origin. That is, there are no SYOA summary data for other attributes such as foreign born for each/all ages. Census 2010 and ACS Public Use Microdata Sample data can be used to tabulate/estimate SYOA data with extended attributes though 1) such estimates can only be developed for areas 100,000 population or more and 2) the thinness of number of cases generally makes this infeasible.

The National Center for Health Statistics (NCHS/NVSS) provides SYOA data for county geography. These data are controlled to Census Bureau annual model-based estimates (not released by Census). The NCHS “bridge estimates” data are available annually 2010 forward (2013 estimates available as of March 2015). See more information.

ProximityOne provides census tract, ZIP code area and county-up geography SYOA estimates and projections to 2020. See more information about 5-year projections and projections to 2060.

Census 2010 SYOA
The Census-sourced single year of age demographics for sub-county areas are from the Census 2010 Summary File 1 (SF1). The Census 2010 SF1 “PCT012” (PCT: Population Census Tract and higher geography) tables provide single year of age by gender by race/origin population data for U.S. national scope census tract, ZIP code area and higher level geography. See more about the content and structure of the PCT012 tables.

SYOA-based profiles based on the PCT012 data for ZIP Code area 77077 (Houston, TX) are shown below. The tables have been developed using the ProximityOne Modeler2 software (more below).

Table 1. Single Year of Age by Race/Origin; 2010; ZIP Code Area: 77070

Click graphic to view full scroll section.

Table 2. Age by Race/Origin; Age Groups; 2010; ZIP Code Area: 77070

Click graphic for larger view.

Modeler2 Software
The Modeler2 software has been developed by ProximityOne to create demographic-economic estimates and projections at the sub-county geographic levels including census tracts and ZIP code areas. Annual estimates and projections are developed for 2010 through 2020 by single year of age, and for age groups, by census tract and ZIP code area.

The Modeler2 software can also be used to develop Census 2010-based SYOA profiles such as those shown above. While the Census 2010 PCT012 tables provide the basic data needed to develop these profiles, there is a lot that lies between the data existing and the development/availability of consumable data. As shown in the description of the PCT012 tables, the data are organized in Census 2010 SF1 as a set of tables that need to be separately accessed … and then transformed to a usable format. The Modeler2 software provides two options to access and use the basic PCT012 data: via a locally stored all U.S. dataset or via the Census API (a feature integrated into the Modeler2 software).

Members of the ProximityOne User Group can download and use Modeler2 Level 1 and create SYOA profiles for any county in the U.S. See the User Group section for more information about installation and use.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data.