Tag Archives: Houston

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.

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.

School District Demographic Trends: 2010-2015

.. data and tools to examine how school districts of interest are changing … based on total population, the largest 10 school districts in 2015, all experienced an increase in total population over the period 2010-2015. Five of these districts had a decrease in school age population (ages 5-17 years). Four of these districts had a decrease in the number of related children in families ages 5-17 years. See characteristics of districts in this interactive table. See the related Web section for more details.

School Districts with 2015 Population 100,000 or More
More than 600 of the total 13,245 school districts have a total 2015 population of 100,000 or more (red markers).

– view developed with CVGIS software and related GIS project.

Using New 2015 Estimates Released December 2016
– for use in 2017 ESEA Title I Allocations
Analyze annual demographic data for each U.S. school district for the period 2010 through 2015. These data include the Federal official 2015 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. Use the interactive table in this section to view, rank, compare, query demographic characteristics of districts of interest.

The annual estimates for each school district include:
• total population
• number of children ages 5 to 17
• number of related children ages 5 to 17 in families in poverty

Using Interactive Data Tools
Use the interactive table to view, rank, compare, query ZIP codes based on a selection of demographic measures. The following graphics illustrate how the table can be used. Click graphic for larger view.

Total Population — 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

School Age Population — 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

Related Children Ages 5-17 in Poverty
– 10 districts with largest change 2010-15
– ranked descending on rightmost column

– click graphic for larger view.

Try it yourself. Use the table to examine a set of districts on your selected criteria in for a state/area of interest.

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.

Examining Health Characteristics by Census Tract

.. new data, new ways to examine health characteristics at the city and census tract/subcounty level.  For example, among the 500 largest U.S. cities in 2014, the incidence of high blood pressure ranged from 22.5% (Longmont, CO) to 47.8% (Gary, IN). Use the interactive table to view, rank, compare this and other new wide-ranging health statistics for the 500 largest U.S. cities and associated census tracts. See the related Web section for more detail.

At the census tract/neighborhood level, 937 tracts have more than 10% of the population ages 18 years and over with coronary heart disease. What are characteristics of health-related factors in your city, neighborhood and census tracts of interest? Use tools reviewed in this section to access/analyze a wide range of health-related characteristics (see items list below) — not available at the city or census tract level before.

Patterns of High Blood Pressure: Honolulu, HI by Census Tract
This graphic illustrates visual analysis and analytical potential for tracts in cities covered.

– Click graphic for larger view with high blood pressure %population label
– View developed with CV XE GIS software and related GIS project/fileset.

Accsss/analyze these data for approximately 28,000 tracts (of a total approximate 74,000) on topics including chronic disease risk factors, health outcomes and clinical preventive service use for the largest 500 cities in the U.S. These small area data enable stakeholders in cities, local health departments, neighborhoods and study areas to better understand the characteristics and geographic distribution of health-related measures and how they might impact health-related programs and other demographic-economic issues.

Scope of 500 Cities
The following graphic shows the 500 cities (green areas) included in project. Data for these cities and intersecting tracts are available. Click graphic for larger view providing county visibility and city name labels. Expand browser to full window for best quality view.

– View developed with CV XE GIS software and related GIS project/fileset.

The 500 Cities data have been developed as a part of the CDC 500 Cities project, a collaboration between the Centers for Disease Control (CDC), the Robert Wood Johnson Foundation and the CDC Foundation. These data are being integrated into the Situation & Outlook (S&O) database and included in the S&O metro reports. Examine health-related characteristics of metro cities and drill-down areas in combination with other demographic-economic measures.

Analytical Potential
These data provide only the health characteristics attributes. They are a small, but important, subset of a larger set of key health metrics. These data are estimates subject to errors of estimation and provide a snapshot view of one point in time.

The value of these data can be leveraged by linking them with other demographic-economic data from the American Community Survey (ACS 2015) tract and city data. Integrate and analyze these data with related data and alternative geography. See related health data analytics section.

Patterns of Heart Disease; Charlotte, NC-SC Area by Tract
This graphic illustrates coronary heart disease patterns by census tract for cities included in the database. Gray areas are census tracts not included in the 500 cities database. Click graphic for larger view.
– View developed with CV XE GIS software and related GIS project/fileset.

Using the Interactive Table
Use the interactive table to view, rank, compare, query these health measures by city. The following graphic illustrates how the table can be used to examine patterns of Texas cities. Table operations are used to selected Texas cities then rank the cities based on the “Access” column — “Current lack of health insurance among adults aged 18-64 Years”.

Try it yourself. Use the table to examine a set of cities in a state of interest.

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.

2016 Presidential Election – Voting & Citizen Voting Age Population by County

In 2015, the U.S. citizen voting age population (CVAP) was 227,019,486 of the total U.S. resident population of 321,418,821 (70.6%). 2016 CVAP data are not yet available. In the 2016 presidential election, 128,298,470 votes were cast — approximately 56% of the citizen voting age population. For individual counties the 2016 presidential election vote ranged from 16% of the CVAP to near 100%. Use the interactive table in this section to examine characteristics of the 2016 presidential election vote and citizen voting age population by county.

This section reviews access to tools to view/analyze characteristics of the U.S. voting population (ages 18 and older and citizen) and participation in the 2016 presidential election. Data are based on Census Bureau annual population estimates, American Community Survey 2010-14 5 year (ACS 2014) Citizen Voting Age Population (CVAP) special tabulation and 2016 presidential election results.

Visual Analysis of 2016 Presidential Election Vote by County
The following graphic shows the 2016 presidential vote as a percent of the citizen voting age population.

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

U.S. Electorate Profile: Characteristics of the Citizen, 18 and Older Population

– based on 2015 American Community Survey 1-Year estimates
*Except where noted, “race” refers to people reporting only one race.
**Hispanic refers to the ethnicity category and may be of any race.
***Households with citizen householders.

U.S. by County Interactive Table Analysis 
Use the interactive table to examine characteristics of the 2016 presidential election vote and citizen voting age population by county. The following graphic illustrates how the table can be used to examine patterns in the Houston, TX metro by county. The Find in CBSA button is used below the table to select only counties in this CBSA/metro. The rightmost column header cell is clicked to rank counties on the voter participation rate for the 2016 presidential election.

– click graphic for larger view.

Try it yourself. Use the table to examine a set of counties in a metro or state of interest.

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.

Regional Economic Information System: Annual Updates

.. which counties are experiencing the fastest economic growth? by what economic component? what does this look like on a per capita level?

.. access & analyze economic characteristics and patterns by county and state .. annual time series 1969 through 2015 with projections.  Personal income is the income available to persons for consumption expenditures, taxes, interest payments, transfer payments to governments and the rest of the world, or for saving. Use the interactive table to examine characteristics of counties and regions of interest. The table provides access to 31 personal income related summary measures. These data are a selection of a broader set of annual time series data from the Regional Economic Information System (REIS). REIS is a part of the ProximityOne State & Regional Income & Product Accounts (SRIPA) and Situation & Outlook (S&O) featuring current (2016) estimates and demographic-economic projections. Go to table.

Visual Analysis of Per Capita Personal Income Patterns
The following map shows the Houston metro (view profile) with bold brown boundary. Counties are labeled with county name and 2014 per capita personal income.

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

Per Capita Personal Income Change 2008-2014 by County
.. relative to U.S 2008-2014 change

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

Interactive Analysis – County or State Profiles
The following graphic illustrate use of the interactive table to view an economic profile for Harris County, TX. Use the table to examine characteristics of any county or state. Click graphic for larger view.

Interactive Analysis
– comparing per capita personal income across counties
The next graphics illustrates use of the interactive table to rank/compare per capita personal income across counties. Rank/compare states. Choose any of the economic profile items. 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.

Personal Consumption Expenditures by State: Updates & Pattern Analysis

.. data and tools to develop insights into personal consumption patterns by state .. growth in state personal consumption expenditures (PCE) – the measure of goods and services purchased by or on behalf of households – decelerated to 3.6 percent on average in 2015 from 4.4 percent in 2014. In 2015, PCE growth ranged from 1.5 percent in Wyoming to 5.0 percent in Florida. PCE by state data for 16 expenditure categories are shown for the U.S. and by state in the interactive table. See related Web section for more detail.

Per Capita Personal Consumption Expenditures
  — Patterns & Characteristics by State

The following graphic shows patterns of percent change in total PCE 2010-2015 by state labeled with 2015 per capita total PCE. Use CVGIS project to examine PCE by types and different years. Integrate additional subject matter and types of geography. Click graphic for larger view with details.

– views developed with CVGIS and related GIS project & datasets.

In 2015, the fastest growing categories of expenditures across all states were food services and accommodations, health care and other nondurable goods. These categories along with housing and utilities were also the largest contributors to growth in total PCE by state.

Per capita PCE by state measures average PCE spending per person in a state. Across all states, per capita total PCE was $38,196. Per capita PCE by state ranged from a high of $49,717 in Massachusetts to a low of $29,330 in Mississippi.

Personal Consumption Expenditure by Category
PCE by state is the state counterpart of the Nation’s personal consumption expenditures (PCE). PCE by state measures the goods and services purchased by or on behalf of households and the net expenditures of nonprofit institutions serving households (NPISHs) by state of residence for all states and DC. PCE by state reflects spending on activities that are attributable to the residents of a state, even when those activities take place outside of the state. Per capita PCE by state measures average PCE spending per person in a state.

Interactive Analysis
The following two graphics illustrate use of the interactive PCE table. View 1 shows Texas by PCE type ranked in ascending order on percent change from 2010 to 2015 (ranked on far right column). View 2 shows Texas by PCE type ranked in descending order on percent change from 2010 to 2015 (ranked on far right column). Use the table to examine characteristics of states of interest. Click graphic for larger view.

Texas by PCE Type; Ranked Ascending on PCPCE Change 2010-15

Texas by PCE Type; Ranked Descending on PCPCE Change 2010-15

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.