Tag Archives: Children

School District Demographic Trends: 2010-2016

.. while enrollment in many school districts is growing, for many it is declining — these include some of the largest districts. Declining enrollment in school districts can result in school closings that destabilize neighborhoods, cause layoffs of essential staff and concerns that the students who remain are some of the neediest and most difficult to educate. See related narrative.

Based on total population, the largest 10 school districts in 2016 (see table below), all experienced an increase in population over the period 2010-2016. Five of these districts had a decrease in school age population (ages 5-17 years). Five of these districts had a decrease in the number of related children in poverty in families ages 5-17 years.

See the related Web section that provides tools to analyze annual demographic data for each U.S. school district for the period 2010 through 2016. This post summarizes selected details. These data include Census Bureau official 2016 estimates available for all districts. Developed for use as inputs for the ESEA Title I allocation formula, the data have broader uses of interest to school district demographics stakeholders. The 2016 estimates were released in November 2016; 2017 estimates become available in late 2018. ProximityOne uses these data in combination with other data to develop school district current estimates and annual projections through 2022 with related drill-down demographic-economic subject matter. Use the interactive table in the Web section to view, rank, compare demographic characteristics of districts of interest.

Largest 10 School Districts based on 2016 Population Age 5-17

Patterns of 2016 School Age Population in Poverty by School District
The graphic below shows school districts with total 2016 population of 1,000 or more by poverty incidence. Markers show the population ages 5-17 in families in poverty as a percent of population ages 5-17. Salmon markers: 40-50%. Red markers: 50% or more.

– view developed with CVGIS software and related GIS project.

School District Demographic Trends Interactive Table
Use the interactive table to view, rank, compare demographic characteristics of districts of interest.

More About K-12 Education & Children’s Demographics
See the related section on School District Demographic Trends 2010-2016:
http://proximityone.com/sdtrends.htm.

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 L

America’s Cities: Demographic-Economic Characteristics Annual Update

.. tools and data to interactively examine demographic-economic characteristics of America’s 29,321 cities/places .. understanding demographic-economic characteristics of cities and places is essential for business development, market analysis, planning, economic development, program management and general awareness of patterns and trends. This section provides access to data and tools to examine characteristics of all cities/places in the U.S. This annual update includes data for 29,321 cities/places based on ACS 2015 data.

Accessing the Data; Using Interactive Tables
Each of the four links below opens a new page providing access to U.S. by city/place interactive tables — by type of subject matter. Use tools and usage notes below table to select operations to perform queries, sort and select columns.
General Demographics
Social Characteristics
Economic Characteristics
Housing Characteristics

How the the Tables/Data Can be Used
The following table shows data derived from the Economic Characteristics table. The top 10 cities/places having the highest median household income ($MHI) are shown. The table also shows population, median family income ($MFI) and per capita income ($PCI). The $250,000 value is a cap; the actual value is $250,000 or higher. Use the interactive tables to create similar views for states of interest. Use the button below the table to select/view cities within a selected metro. Compare attributes of cities of interest to a peer group based on population size.

Visual Analysis of City/Place Population Patterns
Use GIS resources to visually examine city/place demographic-economic patterns. The following view shows patterns of population percent change by city in the Charlotte, NC-SC metro area.

… view developed using the CV XE GIS software.
… click map for larger view and details.

Related Data
Cities/Places Main Section
Citie Population Estimates & Trends, 2010-15

More About Using These Data
Using ACS 1-year and 5-year data

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.

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.

Children in Households by Neighborhood

Between 1970 and 2012, the share of households that were married couples with children under 18 decreased from 40 percent to 20 percent. During this period, the average number of people per household declined from 3.1 to 2.6
(details). These trends vary by state and region. Patterns vary widely at the neighborhood level. What are the characteristics and patterns of households with children under 18 at the neighborhood level?

This section illustrates use of CV XE GIS with associated GIS project to examine patterns of children in households by age by block group. Data are based on Census 2010 Summary File 1 Table 32 as shown in the table presented below in this section. See more about the GIS project. See related Web section for more details.

San Francisco Area
  — Patterns of Children in Households by Block Group
Block groups with 400 or more children in households (item P0320001) appear blue. Block groups with 100-300 children in households appear with green fill pattern.

Click graphic for larger view

San Francisco Zoom-In
  — Patterns of Children in Households by Block Group
Block groups with 400 or more children in households (item P0320001) appear blue. Block groups with 100-300 children in households appear with green fill pattern.

Click graphic for larger view

San Francisco Zoom-In
  — Patterns of Children in Households, ages 6-17, by Block Group
Illustrating different colors, different ranges, population by age; other ages could be used. Block groups with 300 or more children in households (items p0320009 – p0320012 summed) appear red. Block groups with 100-300 children in households appear with orange fill pattern.

Click graphic for larger view

Cupertino Area Zoom-In
  — Patterns of Children in Households, ages 6-17, by Block Group
Illustrating further zoom-in, street detail, labels showing total population under 18 years; could be other item as label.
Block groups with 300 or more children in households (items P0320009 – P0320012 summed) appear red. Block groups with 100-300 children in households appear with orange fill pattern.

Click graphic for larger view — larger view use of identify tool to profile a selected block group.

Examining Study Areas Using Site Analysis Tool
Above view in site analysis mode; selecting three block groups as a study area using SiteAnalysis API tool. See summary profile in lower right section/table; export to HTML or XLS file. Use mouse to cherry pick areas to add and/or use circular area selection.

Click graphic for larger view.

Viewing Selected Records in Tabular Form
After selecting areas (block groups in this example) that comprise a study area, click the View File in the lower right panel above the grid. The dBrowse feature is started; the selected records dataset can be opened and used. The $$siterecs.dbf is overwritten with each new site selection. It can be optionally be saved to a CSV, TXT or dBase file for later use; possibly merger/comparison with other study area selections.

Click graphic for larger view.

GIS Project
The GIS project used to develop views shown in this section is focused on the state of California by block group. It can be used to examine patterns similar to those shown here for any area in California. A similar project could be developed for a specific county, another state or the U.S.

Data from Census 2010 SF1 Table P32 (see item list below) were merged into the California block group shapefile. Many of the items available in Table P32 were not used in the map views shown here but could be used to develop alternative views; e.g., specific age patterns or percentages.

A GIS project is itself a file that knits together a set of layers that have certain settings. In the GIS project used here, the layers mainly reflect attributes of a corresponding shapefile (U.S. by state, U.S. by county and California by block group).

Children in Households; Census 2010 Summary File 1; Table P32
P32.  HOUSEHOLD TYPE BY RELATIONSHIP BY AGE
FOR THE POPULATION UNDER 18 YEARS [45]
Universe: Population under 18 years
P0320001   Total
P0320002     In households
P0320003       Householder or spouse
P0320004       Related child:
P0320005         Own child:
P0320006           Under 3 years
P0320007           3 and 4 years
P0320008           5 years
P0320009           6 to 11 years
P0320010           12 and 13 years
P0320011           14 years
P0320012           15 to 17 years
See full table item list in related Web section.

About Households
A household contains one or more people. Everyone living in a housing unit makes up a household. One of the people who owns or rents the residence is designated as the householder. For the purposes of examining family and household composition, two types of households are defined: family and nonfamily.

A family household has at least two members related by birth, marriage, or adoption, one of whom is the householder. A nonfamily household can be either a person living alone or a householder who shares the housing unit only with nonrelatives; for example, boarders or roommates. The nonrelatives of the householder may be related to each other.

Family households are maintained by married couples or by a man or woman living with other relatives. Children may or may not be present. Nonfamily households are maintained only by men or women with no relatives at home.

Own children are a subset of all children; they are the biological, step, or adopted child of the householder or family reference person (in the case of subfamilies) for the universe being considered, whether household, family, or family group. Own children are also limited to children who have never been married, are under the age of 18 (unless otherwise specified), and are not themselves a family reference person. Foster children are not included as own children since they are not related to the householder.

Support & DMI Web Sessions
Learn more about using resources described in this section. Join us in a Decision-Making Information Web session. There is no fee for these one-hour Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants. We can address your specific questions about tools to analyze patterns of children’s demographics.