Category Archives: Enrollment

State of the States: Demographic Economic Update

.. tools and resources to examine the demographic-economic state of the states .. in 2016, the U.S. median housing value was $205,000 while states ranged from $113,900 (Mississippi) to $592,000 (Hawaii). See item/column H089 in the interactive table to view, rank, compare, analyze state based on this measure … in context of related housing characteristics. These data uniquely provide insights into many of the most important housing characteristics.

Use new tools, data and methods to access, integrate and analyze demographic-economic conditions for the U.S. and states. These data will update in September 2018.

Approximately 600 subject matter items from the American Community Survey ACS 2016 database (released September 2017) are included in these four pages/tables:
• General Demographics
• Social Characteristics
• Economic Characteristics
• Housing Characteristics

GIS, Data Integration & Visual Data Analysis
Use data extracted from these tables in a ready-to-use GIS project. These ACS sourced data (from the four tables listed above) have been integrated with population estimates trend data, components of change and personal income quarterly trend data. See details in this section.

Examining Characteristics & Trends
Below are four thematic pattern maps extracted from the main sections listed above. Click a map graphic for a larger view. Use the GIS project to create variations of these views.

Patterns of Median Age by State
Yellow label shows the state USPS abbreviation; white label shows median age. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column D017 in the interactive table to view, rank, compare, analyze state based on median age.

Patterns of Educational Attainment by State
Yellow label shows the state USPS abbreviation; white label shows % college graduates. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column S067 in the interactive table to view, rank, compare, analyze state based on percent college graduates.

Patterns of Economic Prosperity by State
Yellow label shows the state USPS abbreviation; white label shows $MHI. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column E062 in the interactive table to view, rank, compare, analyze state based on median household income.

Patterns of Median Housing Value by State
Yellow label shows the state USPS abbreviation; white label shows $MHV. Legend shows color patterns associated with percent population change 2010-2016.

– View developed using CV XE GIS software and associated GIS project.
– See item/column H089 in the interactive table to view, rank, compare, analyze state based on median housing value.

Examining Characteristics & Trends; Using Data Analytics
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.

Creating Custom School District Maps

…tools & data to map & geospatially analyze school districts. Ready-to-use state-by-state GIS projects may be downloaded enabling you to view and create custom maps almost instantly. Benefit from the power of using GIS software to perform tasks not available on Web-based mapping options. Use the latest school district and related shapefiles. See more information about using these resources in this related Web section.

Federal Revenue per Student by School District
Create views similar to the one shown below. Optionally combine layers as illstrated here by showing four Texas metros.

.. view developed with CV XE GIS and related GIS project.

Extending Reference and Analytical Possibilities

Texas by School District
Examine reference maps at the state, regional or local level. Optionally combine with roads/streets and other layers.

Patterns of Economic Prosperity by School District
Select from many ready-to-use demographic-economic subject matter items to create custom pattern views.

Drill-down — Houston Metro Area by School District
Zoom-in to a school district of interest. Set attributes of district as shown here.

County/School District
Visually examine the boundaries or school districts and counties. This view shows Harris County, TX area; select a county of interest.

Drill-down to Street Level
Add road/street and other layers. Drill-down within Fort Bend ISD, Houston metro, showing general earth surface features with streets layers. Mouse used to click on street (see pointer) and display mini-profile of street segment attributes.

Use for Analysis, Reference or in the Classroom
Schools and teachers: consider using these resources for classroom use. Familiarize students about how GIS resources can be used with a minimum of learning time and no cost. Enable students to use their own geography and adapt that learning to more general geography. See related Mapping Statistical Data ready-to-use GIS projects.

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.

Tools to Analyze County Demographic-Economic Characteristics

.. demographic-economic characteristics of counties are 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 these data for all counties in the U.S. This annual update includes geographic area characteristics based on ACS 2015 data.  The tools/data are organized into four related sections summarized below.

1. General Demographics
View interactive table at http://proximityone.com/us155dp1.htm
Patterns of School Age Population by County
Use GIS tools to visually examine county general demographics as illustrated below. The following view shows patterns of percent population ages 5 to 17 years of age by county — item D001-D004-D018 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

2. Social Characteristics
View interactive table at http://proximityone.com/us155dp2.htm 
Patterns of Educational Attainment by County
– percent college graduate
Use GIS tools to visually examine county social characteristics as illustrated below. The following view shows patterns of percent college graduate by county — item S067 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

3. Economic Characteristics
View interactive table at http://proximityone.com/us155dp3.htm 
Patterns of Median Household Income by County
Use GIS tools to visually examine county economic characteristics as illustrated below. The following view shows patterns median household income by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

4. Housing Characteristics
View interactive table at http://proximityone.com/us155dp4.htm 
Patterns of Median Housing Value by County
Use GIS tools to visually examine county housing characteristics as illustrated below. The following view shows patterns median housing value by county — item E062 in the interactive table. Create your own views.

… view developed using the CV XE GIS software.

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.

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.

Accessing & Using ZIP Code Demographics

.. 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.

… February 2017 updates .. 5 ways to access/analyze the most recent estimates of median housing value and other subject matter by ZIP Code area .. updates on accessing/downloading/using American Community Survey (ACS1115) 5-year estimates. See more detail in related Web section.

Site analysis (Option 5 below)
– create site analysis profiles from a location/ZIP code.

Contents
Five data access and use options, listed in the links below, are reviewed. Each method illustrates how ZIP code demographic-economic data can be accessed/ analyzed/used in different contexts. The most basic data access/data download is illustrated in Option 3. The following links open new windows that take you to the related section with more detail.
Option 1 – View the data as a thematic pattern map.
Option 2 – View, compare, rank query data in interactive tables.
Option 3 – Access data using API Tools; create datasets.
.. Option 3a – Extended ZIP Code subject matter access.
.. Option 3b – ZIP code urban/rural data access.
.. Option 3c – Additional API ACS data access resources.
Option 4 – View $MHI in structured profile in context of related data.
Option 5 – Site analysis – view circular area profile from a location.

Related ZIP Code Data Access & Use sections
Interactive access to demographics based on an address
Summary of ZIP Code Data Resources & Tools
10 Reasons to use Census Tracts Versus ZIP Codes
Analyzing Census Tract Demographics by ZIP Code Area
ZIP Code to Census Tract Equivalence Table
ZIP Code Urban/Rural Geography & Demographics
Mapping ZIP Code Demograhics
Housing Price Index by 5-digit ZIP Code – time series; annual updates
Housing Price Index by 3-digit ZIP Code – time series; quarterly updates
ZIP Code Business Establishment, Employment & Earnings by industry
ZIP Code Retail Trade Establishment & Sales by industry
ZIP Code Equivalence Tables — ZIP Code to School District

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.

Congressional District 2015 Demographic-Economic Characteristics

.. congressional districts vary widely in demographic-economic characteristics.  We have new data for 2015 providing insights to characteristics of the 114th Congressional Districts.  This section summarize a few of these characteristics and provides access to a wide range of data that you can use to view, sort, rank, and compare congressional districts using interactive tables.

Patterns of 2015 Educational Attainment
The following graphic shows patterns of educational attainment (percent college graduate) by congressional district in the Los Angeles area. White label shows the congressional district code; yellow label shows percent college graduate. Legend shows color patterns associated with percent college graduate intervals.

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

How Congressional Districts Compare
Reference items refer to items/columns shown in tables described below.

.. general demographics: congressional district UT03 has the smallest median age (27.5 years — item D017) and FL11 has the highest median age (53.5 years).

.. social characteristics: congressional district KY05 has the fewest number of people who speak English less than “very well” (2,676 — item S113) and FL27 has the largest number (281,053).

.. economic characteristics: congressional district ND00 has the lowest unemployment rate (2.6% — item E009) and MI13 has the highest unemployment rate (14.6%).

.. housing characteristics: congressional district MI13 has the lowest median housing value ($63,100 — item H089) and CA18 has the highest median housing value ($1,139,900).

Access the Detailed Interactive Tables
Click a link to view more thematic pattern maps and use the interactive tables.
.. General Demographics
.. Social Characteristics
.. Economic Characteristics
.. Housing Characteristics

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.

Largest School Districts Enrollment Characteristics

..  while school district enrollment is reported by school districts, only public school enrollment is reported. Public and private school enrollment are available by district from the American Community Survey (ACS 2015).  With few exceptions, school districts do not report on demographic-economic characteristics of the school district.  These data are only available from ACS. See the related interactive table to access and compare enrollment characteristics of school districts of interest.

In 2015, there were 1,016 school districts with total population of 65,000 or more (of total 14,650) for which “1-year estimates” were tabulated.  These estimates are based on respondent data for calendar year 2015.  This section summarizes selected enrollment characteristics of the largest districts and provides access to much more detail for each of these districts.

Largest 10 School Districts
The following graphic shows the largest 10 school districts based on the size of the 2015 school age population ages 5-to-17. Click graphic for larger view.

Mapping the Largest School Districts
The following graphic shows locations of the largest school districts as red markers. Click graphic for larger view that opens in a new window. Expand browser window for bets quality view. The larger view shows school district locations on context of metropolitan statistical areas (MSAs).

  view created using CV XE GIS software and related GIS project.

School Districts Tabulated in ACS 2015
ACS 2015 data are tabulated for 14,650 school districts (among many other wide-ranging geography). The following table shows the number of districts for which 1-year estimates and 5-year estimates are tabulated. There are 1,016 districts for which 1-year estimates were tabulated.

These data show enrollment of residents of the district whether enrolled in that district or otherwise. Enrollment data are provided for preschool, K-12 and college and not enrolled.

Using the School District Enrollment Interactive Table
The following graphic illustrates use of the interactive table (click that link to use the table) showing enrollment in kindergarten by school district ranked in descending order.

– click graphic for larger view.

Using the table, you can select total, public or private enrollment for selected grade ranges.

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.