Tag Archives: children’s demographics

Children’s Demographics by School District

.. data and tools to analyze children’s demographics by school district ..  the ACS 2014 median household income for the Houston ISD, TX (HISD) was $46,069 (all households) compared to $41,896 (grade relevant children’s households). How does economic prosperity (or choose from many other attributes) vary between the total population of an area and to those of total children or grade relevant children by type of enrollment in districts of interest? See related Web section with interactive table.

This section summarizes data and tools to access to the children’s demographic-economic data, based on the 2014 American Community Survey (ACS 2014) school district special tabulation (SDST), for each/all school districts. These data provide insights into the population, social, economic and housing characteristics of total children and grade relevant children — in contrast to the total population and housing. Use the interactive table below to view, rank, compare, query children’s characteristics.

Patterns of Economic Prosperity by School District; Children’s Households
— Median Household Income for Grade Relevant Children Households
The following thematic map shows patterns of median household income for grade relevant children households by school district for Texas and adjacent states. Click graphic for larger view (shows metros). Expand browser to full extent for best quality view.

View developed using CV XE GIS software and associated GIS project.

Additional Views:
Dallas metro area
Houston metro area
Los Angeles metro area

Importance of these Data
The annually updated SDST data are a unique source of data to help stakeholders understand demographic-economic characteristics of total children as well as grade relevant children. The real power of these data is that they enable analysis of children’s living characteristics by type of enrollment (enrolled in public school, enrolled in private school, not enrolled) by school district. For example, in this Houston ISD, TX profile it can be determined that of those grade relevant children who ‘speak English less than “very well”.
– enrolled in public school
… 36,995 or 18.7% of total grade relevant children enrolled public
– enrolled in private school
… 810 or 3.9% of total grade relevant children enrolled private (very low)
– not enrolled
… 3,265 or 30.9% of total grade relevant children not enrolled (very high)

How does Houston ISD compare to Dallas ISD? … to Los Angeles Unified? … use these data to find out. Whether ability to speak English, or other living/demographic environmental characteristics, these are among the factors that can primarily influence educational outcomes.

Comparing the Number of Households
The total number of households compared to the number of households with grade relevant children is often in the range of 3-to-4 to 1. The following table shows illustrative examples for selected districts.

Scope of the School District Special Tabulation
The School District Special Tabulation is a tabulation of the characteristics of children who reside within the boundaries of a school district. Note that such residents/children might attend a school located outside of the school district of residence. Subject matter items are tabulated for these seven universes:
• all children — population ages 0-19, 18 & 19 not high school graduates
• all school age, grade relevant children
– children enrolled
– children enrolled in public school
– children enrolled in private school
– relevant children not enrolled
See about related data

Children’s Demographics by Type of Enrollment
  — Interactive Table
The following graphic illustrates use of the interactive table to rank districts by total relevant children and views percentage distributions by type of enrollment. Note that among the largest 10 districts, Las Vegas (Clark County, NV) has the largest percent not enrolled (12.x% — far right column). Use the full interactive table to compare contrast district based on your criteria.

– click graphic for larger view.

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

Tip of the Day – Median Household Income by School District

.. tip of the day .. a continuing weekly or more frequent tip on developing, integrating, accessing and using geographic, demographic, economic and statistical data. Join in .. tip of the day posts are added to the Data Analytics Blog on an irregular basis, normally weekly. Follow the blog to receive updates as they occur. Options and tools for accessing and using median household income by school district are outlined below.

Richmond & Henrico County, VA School Districts
  – patterns of median household income by census tract; an illustration.
  – often drill-down geography, like census tracts, is needed.
  – click graphic for larger view.
.. view developed with ProximityOne CV XE GIS and related GIS project.

Accessing/Using Median Household Income by School District
.. the most recent estimate of median household income for school districts is as of 2014. These data are based on the American Community Survey (ACS2014) 5-year and 1-year estimates. See details about other years and longitudinal data below in this section. The subject matter “median household income” is used here but other wide-ranging subject matter can be accessed/analyzed using options described below.

Number and Type of Schools Districts — ACS 2014 tabulation areas
– 2013-2014 school year; as of January 1, 2014

Geographic Areas 1-year estimates 5-year estimates
population of 65,000+ all areas
School District (Elementary) 74 2,181
School District (Secondary) 88 538
School District (Unified) 842 10,923
Total 1,004 13,012

Option 1. Use the interactive table:
– go to http://proximityone.com/sd14dp3.htm (5-year estimates)
– median household income is item E086.
– scroll left on the table until E086 appears in the header column
– this column shows the data for E086 for all school districts
– see usage notes below table.

Option 2. Use the API operation:
– 5-year estimates for unified school districts in Arizona …
– median houshold income (MHI) is item B19013_001E.
click this link to get B19013_001E (MHI) using the API tool.
.. this API must be used on a state-by-state basis.
.. the state FIPS code must be the last two characters in the URL.
– a new page displays showing a line/row for each school district.
– MHI appears on the left, then school district name and then codes.
– optionally save this file and import the data into a preferred program.
– more about API tools.
– more about using 1-year and 5-year estimates.

Option 3. View the median household income in context of other attributes for a school district.
click this link to select a school district of interest.
– click link to view school district report (request a district).
– when report displays, scroll down in table to the household income section.

See the related section on school district community.

This section is focused on median household income and school districts. Many other subject matter items will be apparent when these methods are used. Optionally adjust above details to view different subject matter for school districts.

Data for Other Years & Longitudinal Data
Annual data for median household income by school district are available from the American Community Survey as summarized below.

ACS Year School Year Boundary as of:
2009 2008-2009 January 1, 2008
2010 2009-2010 January 1, 2010
2011 2009-2010 January 1, 2010
2012 2011-2012 January 1, 2012
2013 2011-2012 January 1, 2012
2014 2013-2014 January 1, 2014

Join me in a Data Analytics Lab session to discuss more details about accessing and using children’s demographics, schools and school districts 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 Poverty by School District

.. in the context of “decision-making information,” this section is about using current estimates of the number of children in poverty by school district for each of the more than 14,000 school districts. This measure/estimate is used as a basis for allocation of Federal funds to school districts under the Elementary and Secondary Education Act., the largest Federal school district funding program. These data have far broader uses, providing insights to economic prosperity among children by school district. See related Web section for more details and use of an interactive table to rank and compare school districts.

Percent School Age Children in Poverty
Phoenix, AZ Area Elementary School Districts


View developed with CV XE GIS software.
Click graphic for larger view with more details; labeled with percent in poverty.

In 2013, 15 percent of all school districts had poverty rates greater than 30 percent for the population of school-age children in families. For the U.S. overall, the number of related children ages 5 to 17 in families in poverty (10,957,266) was 20.4 percent of the total number of children ages 5 to 17 (53,715,325).

As of December 2014, we have new 2013 school district estimates of the total population, number of grade relevant children ages 5 to 17, and number of grade relevant related children ages 5 to 17 in families in poverty. These data are based on Census Bureau estimates developed annually under sponsorship of the U.S. Department of Education.

These data are used as an input to the allocation formula for Title I of the Elementary and Secondary Education Act. The Title I program distributes funding to school districts based on the number and percentage of low-income children. The U.S. Department of Education will use these 2013 estimates to allocate fiscal year 2015 funds for Title I and other programs to states and school districts for use primarily in the 2015-16 school year.

Percent Children in Poverty by School District, 2013
The following graphic shows the grade relevant children in poverty as a percent of total grade relevant children by school district.

View developed with CV XE GIS software. Click graphic for larger view.

The above view shows all school districts (elementary, secondary and unified). In states such as California and Illinois, where two school districts may cover an intersecting area (e.g, an elementary and a secondary) some poverty incidence might be masked. The larger view shows that districts are shown as three layers (ESD, SSD, USD) — each layer uses the same shapefile with a query placed on type of district selected. With all three layers checked, ESDs are shown above SSDs and above USDs. See these additional views (click links to open map views):
Houston Metro; unified districts layer only; districts labeled with percent children in poverty
Arizona & southwest region; unified districts layer only; districts labeled with percent children in poverty
Arizona & southwest region; all district types; unified districts labeled with percent children in poverty

Interactive Table
The following graphic is a view of the interactive table — click here to use interactive table — showing the largest California school districts based on the number of grade relevant school age children. Note the wide-ranging variation in the rightmost column showing the percent of school age children in poverty.

Click graphic for larger view.

Related Data
2013-14 School District Boundary Files (shapefiles)
ACS 2012 School District Demographic-Economic interactive tables
    General Demographics .. Social Characteristics .. Economic Characteristics .. Housing Characteristics
ACS 2012 Children’s Demographics by School District – school district profiles

Support Using these Resources
Learn more about demographic economic data and related analytical tools. 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.