Data Access & Use Web Sessions

Navigating the Website & Accessing Resources

Warren Glimpse
ProximityOne -- http://proximityone.com
.. we build and apply decision-making information and develop related tools empowering you
wglimpse@proximityone.com

About this Session

This session is designed for a 30 minute presentation and up to 30 minute discussion.
.. the Topics section provides session structure but many items have only passing reference.
.. details vary by week.

Topics today

• Site Navigation
• SiteMap

• Prospective Developments .. goto top

- Archiving the Federal GeoStatistical System
- Economics, Poverty & Inequality in K-12 Education -- the School District Community
- Developing a Housing Plan/Study Using Federal GeoStatistical Data

- Service/market area, city/place, county, urban area
- size: under 20,000, 20,000 - 50,000, over 50,000 population

• Topics from the ProximityOne Weekly Update

• Using DEDE to Develop ACS 2023 Foreign Born Datasets

DEDE Subject Matter Items File

B01001_001E TotPopA23  Total Population
B05006_001E FBTotA23   Total Foreign-Born Population in U.S.
B05006_139E FBLAA23    Latin America
B05006_143E FBCubaA23  Latin America:Caribbean:Cuba
B05006_154E FBLACAA23  Latin America:Central America
B05006_160E FBLCMexA23 Latin America:Central America:Mexico
B05006_164E FBSAA23    South America
B05006_165E FBARA23    South America:Argentina
B05006_166E FBBOA23    South America:Bolivia	
B05006_167E FBBRA23    South America:Brazil	
B05006_168E FBCHA23    South America:Chile	
B05006_169E FBCOA23    South America:Colombia
B05006_170E FBECA23    South America:Ecuador
B05006_171E FBGUA23    South America:Guyana	
B05006_172E FBPEA23    South America:Peru	
B05006_173E FBURA23    South America:Uruguay
B05006_174E FBVEA23    South America:Venezuela	
B05006_175E FBOTA23    South America:Other

End of Session

• K-12 Public Schools Characteristics & Analytics .. 2022-23 & 2023-24
.. K-12 Public Schools Characteristics & Analytics
.. new: added selected 2023-24 NCES Common Core of Data .. released in December
.. examining free and reduced price lunch characteristics by 2023-24 school

• Birth and Natality Characterstics and Patterns
.. examining births and birth rates by county

• Blog Post -- The Importance of Small Area Data
.. continuing series
.. iVDA Blog Post

• Kansas Demographic-Economic Data Analytics -- Updates
.. updating VDAGIS project -- added block group layer
.. new section on using the iVDA Table/Query with KSDE
.. KSDE Section

• Census 2020 Block Demographics
.. updating VDAGIS project .. housing trends by census block
.. Census 2020 Blocks Section

• Annual update -- BEA U.S. by County Personal Income by Major Source & related Files .. released 11/14/24
.. annual time series data through 2023
.. being integrated Regional Economic Information System
.. key components of analyzing/understanding local area economy and trends

• 2010-2020 Intercensal Population Estimates 11/7/24
.. annual time series 2010 through 2020; for states, counties, cities, towns/townshipa
.. Intercensal Interactive Table
.. being integrated into Regional Economic Information System
.. key components of analyzing/understanding local area economy and trends

• 119th Congressional District Election Results Interactive Table and related demographics
.. frequent election results updates
.. integrating ACS 2023 1-year 2023 data, additional Subject matter soon
.. integrating Census 2020 DP1 data -- December 2024
.. being integrated into VDAGIS Base project.
Application: new incumbents entering Congress

• Updates to the VDAGIS Base Project.
.. SLD 2024 layers have been added.
.. three (elm, sec, uni) school district layers with school district finances integrated.
.. Urban Areas layer showing population change
.. TIGER 2024 interstate layer
.. TIGER 2024 detailed roads layer (LA & Orange County)
.. Public Use Microdata Areas with demographics trends

Application: The 400 Myrtle St street segment (see pointer) is a bounding street segment for blocks 060590626052003 and 060590626052002
. Click the street segment to show the street segment profile.

End of Session
..

• Using GIS & GeoDemographics Course -- amplify your skillset

• Geographic Summary Levels & Geocodes
- new section

• Census Tracts Main Section updates
- updated interactive table

• Demographic-Economic Data Explorer (DEDE) updates
- creating demographic-economic datasets

• Using the Demographic Analytics Tool
- creating narrative profiles for your area

• 119th Congress Block Equivalency Files .. new this week
- integrating the CD code in block shapefiles
- adding CC code, selected 2020 pop & hsg items, 2024 hsg and GQ, urban/rural flag, urban area geocode
- will be available state by state layers as a VDAGIS project and accessible using most VDAGIS tools.

• 119th Congress, 2024 SLDs, ACS Data .. related topics

• iVDA updates
- new feature -- uploading your shapefile
- Knowing Your Neighborhood
- Metros
- America's Cities
- Examining K-12 Schools & School Districts
- Congressional Communities & Congressional Districts

• Vintage 2024 TIGER/Line files

• Hispanic Population by Specific Origin by ZIP Code Area .. https://proximityone.com/hispanic_origin_zip.htm
- embedded iVDA interactive mapping; demonstrating new iVDA features
- new VDA GIS Hispanic Population by Specific Origin project; acceesible by many VDAGIS tools
- blog post

• Accessing Healthcare Resources updates -- https://proximityone.com/healthcare_resources.htm
- to review next week

End of session

• Housing Units by Census Block -- 2020-2024 .. Using VDAD with US1_2024

• State Personal Income -- Quarterly PCPI 2020Q1-2023Q4
- integrated iVDA mapping and interactive table
- access using VDAGIS Discovery
- updates quarterly; next update June 28

• VDAGIS Discovery Updates -- https://proximityone.com/vdagis_discovery

• Examining Citizen Voting Age Population (CVAP) new section

• America's Cities -- Examining Population Change 2020-2023 .. interactive table

• 2023 Population Density by Vintage 2023 Metropolitan Statistical Area

- create views like above graphic using OpenVDA
- using only a Web browser; no registration, no login, no fee.

• Examining Longitudinal Patterns of Housing Price Index by ZIP Code
- HPI by ZIP Code section updated with 2020-2024 HPI

• Examining National Scope Census Block Housing Unit/Demographic Change 2020 to 2024

• VDA GIS Updates
- VDA Embedded Beta
- VDAW
- OVDAW .. OpenVDA
- VDA Desktop .. VDAD
- GeoSelect/Site Analysis feature updated in all VDAGIS tools
- Base Project updates .. available by all VDAGIS tools

• Dependency Ratio by Neighborhood/Census Tract
- new dependency ratio web section
- added VDA GIS Base project
• Diversity Index by Neighborhood/Census Tract
- about the diversity index
- added VDA GIS Base project
• DEDE3 updates
• DA2 updates
• Citizenship & Voting
- Citizenship Data from ACS2020 regular program
- Citizen Voting Age Population ACS 2022 Special Tabulation
- Citizenship & Voting Data from the Current Population Survey
• New annual estimates of housing units authorized by building permits
- released May 1, 2024: U.S., Region, State, Metropolitan Area, County, and Place
- new annual 2023 data
- revised annual 2022 data

04.30.24. Topics
• DEDE3 updates

• How & Why Michigan Demographics are Changing
- state by state sections developed in upcoming months

• How & Why County Demographics are Changing
- interactive table

• CountyTrends GIS Project

• Demographic Analytics 2 updates & illustrative views
- These web-based HTML versions can also be created using in XLS format using DA2.
- illustrative views
- select ACS 1-year or 5-year data
- census tract up by summary level

Recent Topics
04.16.24. Topic .. How & Why Metropolitan Areas are Changing
- updated main page, new interactive table, metro demographic change included in VDAGIS Base project

Did you know .. among the 15 2023 vintage Michigan Metropolitan Statistical Areas
.. six increased in population during 2020-2023, one had no change, and eight lost population?
.. learn how and why this change has occurred.

The Detroit MSA, its two component Metropolitan Divisions, the MSA component counties.

04.09.24. Topic .. Mobility .. 1-year migration based on residence one year ago
- developing for places using ACS 2022

04.02.24. Topic .. Language Spoken at Home (LSAH)
- developing for counties using ACS 2022

03.26.24. Topic .. Examining the School District Community
- Clark County School District

Topic 2 .. Updates to the VDAGIS "Base" project
- . Click to start Open VDA Web GIS featuring the Base project

03.19.24. Topic .. Migration .. how & why county population is changing
- developing for counties using Vintage 2023 model-based estimates

03.12.24. Topic .. Examining the Daytime (commuter adjusted) Population
- developing for places using ACS 2022
- reviewing computation and data required
- creating dataset using DEDE
- file created: C:\dede\api_items_acs22_daytime_places.dbf
- modify file: Commuter-adjusted population = Total resident population + Total workers working in area - Total workers living in area.
- integrate shapefile into places shapefile using CVXEGIS Database>dBMerge
- add shapefile to GIS project, adjust layer, show in map:

• Migration .. how & why county population is changing
- examining county/metro demographic change using Vintage 2023 model-based estimates

How & Why County Population Has Changed 2020-2023

Selected County Profiles
- Fresno, CA
- Orange, CA
- Los Angeles, CA
- Harris County, TX

Using US1 GIS project to examine county/metro population & components of change

• New Tracts 2022 Web section/page & interactive table
- dataset integrated into VDAGIS Base project
• Open VDA Web GIS CD review/update; very similar to Open VDA Web GIS
• Demographic Analytics (DA) updates
- tabular & narrative comparative analysis reports
• Demographic Economic Data Explorer (DEDE) updates
- DEDE2 - ACS time series & geocomposite
- DEDE-DP Update -- Demographic Economic Data Explorer - Data Profiles .. demo of work-in-progress
- dbtools/dbf development added; all school districts added
- illustrative DP views: DP5 General Demographics .. DP2 Social .. DP3 Economic .. DP4 Housing
• ChartGraphics update/review -- population pyramids
• January 2024 Place/County Building Permits time series monthly update; new data released 02.26.24

Using VDAGIS to Promote Community Business Growth
See related section

By establishing areas that promote economic development, qualified entities can encourage and sustain business growth in their communities. Federal programs available to facilitate such investment and growth are the Opportunity Zones and HUBZones.

The following map illustrates how VDAGIS tools can be used to examine qualified areas in the Atlanta region. The view shows block groups. Block group areas may be of interest to applicants and investors in understanding and documenting demographic-economic characteristics.

Opportunity Zones
An Opportunity Zone is an economically distressed area where new investments may be eligible for certain tax benefits. There are 8,764 Opportunity Zones spread throughout the 50 states, DC and five U.S. territories.

HUBZones
The HUBZone program creates incentives (called "preferences") for federal agencies to purchase goods and services from businesses that operate and employ people in areas designated as HUBZones. The acronym HUB stands for "Historically Underutilized Business," and a HUBZone is a historically underdeveloped business zone that meets one or more of five defined criteria. HUBZones are mainly areas that are Qualified Census Tracts.

Upcoming Topics:
Demographics Today:
• Migration
• Climate Change impact
• School District Community

Release dates:
• 03.06.24. QCEW 2023Q3 Quarterly
.. this table update; VDAGIS Base project updates
• 03.14.24. Census Model-based Vintage 2023 County Population Estimates & Components of Change
.. this table update; VDAGIS Base project updates
• 04.15.24. ProximityOne 2024 Q2 S&O Estimates & Projections

Recent:
• Block Groups ACS 2022 Interactive Table .. about Block Groups
• Voter Demographic Analytics
• Finding & Viewing a Census Tract .. Blog topic
• Demographic-Economic Data Explorer .. DEDE updates
• Vintage 2023 Population Estimates for the U.S. & States with Components of Change
- released 12/19/23 see below
- added to VDAGIS Base
• Using Demographic Analytics with Remote Desktop Service (P1 WinServer)
- nothing to install; use with PC, Mac, iOS, other
- use narrative for talking points; tell a story
- requires app add request
• vintage TIGER Digital Map Database updates

Topics
- 01 Federal GeoStatistical System
- 02 Selected News Items

- 03 Geography: Summary Levels & TIGER

- 04 K-12 Education & School Districts
- 05 Congressional Districts, State Legislative Districts, Congressional Communities
- 06 Metros, Counties, Cities, Towns
- 07 Neighborhoods, Census Tracts

- 08 Population, Births, Deaths, Migration Annual Estimates
- 09 Housing & Real Estate
- 10 Income & Poverty

- 11 GDP & Personal Income
- 12 Labor Force & Employment
- 13 Inflation & Cost of Living
- 14 Establishments, Employment, Wages

- 15 Energy & Environment
- 16 Banking & Finance
- 17 Crime & Social
- 18 Health & Healthcare

Selected Statistical Programs
- 19 American Community Survey (ACS)
- 20 Census 2020
- 21 Current Population Survey

- 22 Using Open VDA Web GIS
- 23 Using VDA Desktop GIS (VDAD)

- 24 Demographic Analytics
- 25 Demographic-Economic Data Explorer
- 26 Regional Economic Information System

- 27 Situation & Outlook Estimates & Projections

- 28 Selected Recent & Upcoming Data Releases; Tuesday Session Programs Ahead

01. Federal GeoStatistical System .. goto topics
.. The Federal GeoStatistical System .. a dynamic "book"
- weekly updates in the Tuesday session
- section recaps shared in Tuesday session roughly monthly
- only available here until possible "printed" copy in ~spring 2024
- only here .. dialoging on topics of interest

.. Overview
.. multi-sourced data access and integration
.. what is where and how to access it; variations on public data structures

02. Selected News Items .. goto topics

12.19.23. Vintage 2023 Population Estimates for the U.S. and States with Components of Change
.. start of 2023-24 annual cycle

12.07.23. GDP by County, Metro .. series through 2022
.. released 12/07/23
.. Regional Economic Information System

12.07.23. ACS2022 5-year estimates .. annual update

12.01.23. Vintage 20230 TIGER Digital Map Database released .. annual update

11.16.23. Personal Income by County, Metro .. series through 2022
.. released 11/16/23
.. Regional Economic Information System

11.09.23. Census Releases Population Projections to 2100
.. U.S. national scope only
.. Datasets
.. Projected Population by Year, Matrix

03. Geography: Summary Levels & TIGER .. goto topics

3.1. Selected Geography .. access data for these area using Demographic Analytics tool .. Summary Levels
- Census Blocks (100)
limited scope demographics available only from decennial census
- Block Groups (150)
richer demographics, smallest tabulation area available from annual ACS 5-year program
- Census Tracts (140)
yet richer demographics, available from decennial census & annual ACS 5-year program
current estimates and projections available from ProximityOne Situation & Outlook program
- Counties (050)
above three geographies nest within counties
- Metropolitan Statistical Areas (3XX) .. CBSAs
above four geographies nest within CBSAs Core-Based Statistical Areas
- Urban Areas (400)
- Cities/Places (160)
- Congressional Districts (500)
- Congressional Communities (501)
- ZIP Codes (860)
- School Districts (9xx)

3.2. TIGER Digital Map Database
.. main section

04. K-12 Education & School Districts .. goto topics

Summary level 9xx

.. CCD
.. RCNE
.. School District Community

Getting Your School District Total Population from ACS 2022
.. what is ACS 2022; why ACS 2022 1-year? when not to?
.. illustration for Lexington School District 5, SC
.. Step 1 .. get the school district code
.. Step 2 .. use the API
.. api call: https://api.census.gov/data/2022/acs/acs1?get=NAME,B01001_001E&for=school%20district%20(unified):02820&in=state:45
.. return: [["NAME","B01001_001E","state","school district (unified)"],
.. return: ["Lexington School District 5, South Carolina","107290","45","02820"]]

2022 population for Lexington School District 5, SC: 107,290

05. Congressional Districts & Congressional Communities .. goto topics

.. Congressional Districts .. summary level 500
.. Congressional Communities .. summary level 501

- 06 Metro, Counties, Cities, Towns
- 07 Neighborhoods, Census Tracts
06. Metros, Counties, Cities, Towns .. goto topics

07. Neighborhoods, Census Tracts .. goto topics

08. Population, Births, Deaths, Migration Annual Estimates .. goto topics

8.1. County Annual Estimates
.. Census sourced

8.2. Migration
.. annual county estimates interactive table

.. DEDE County Profile .. Fresno County, CA report section 3.1 .. Fresno County, CA Movers Dataset (XLS)
annual; most recent year 2020 ACS 5-year based

.. State-to-State Migration Flows ACS 2022 1-year

8.3. Urban/Rural
.. Urban/Rural 2020

8.4.Vintage 2023 Population Estimates for the U.S. & States with Components of Change
.. July 1, 2023 with corresponding annual estimates and components of change since 2020 Census.
.. start of vintage 2023 estimates culminating in June 2024

09. Housing & Real Estate .. goto topics
.. Annual Census Estimates
.. Building Permits, monthly/annual

10. Income & Poverty .. goto topics
.. Small Area Income and Poverty Estimates
..

11. GDP & Personal Income .. goto topics
.. GDP
.. Personal Income

12. Labor Force & Employment .. goto topics
.. BLS programs
.. Census programs
.. BEA programs
13. Inflation & Cost of Living .. goto topics
.. CPI
.. PCE

14. Establishments, Employment, Wages .. goto topics
.. BLS QCEW
.. Census CBP

15. Energy & Environment .. goto topics
..

16. Banking & Finance .. goto topics
.. FDIC
.. FFIEC

17. Crime & Social .. goto topics
.. BJS

18. Health & Healthcare .. goto topics
.. HHS

19. American Community Survey (ACS) .. goto topics
.. main section .. ACS 2022

20. Census 2020 .. goto topics
.. main section

21. Current Population Survey (CPS) .. goto topics
.. BLS CPS main
.. Census CPS main
.. Monthly Supplements
ASEC .. Annual Demographic File

22. Using Open VDA Web GIS & Base project .. goto topics
.. click here to start .. see more about .. as shown in the graphic below.
.. no fee, no login, nothing to install, any browser, desktop recommended.

Layers in Base Project -- recently added layers/subject matter

States
New Interstate
New State $PCPI %Chg22_23Q2
New State $PCPI 23Q2
State PCRealGDP 2023Q1
New K-12 Schools Elem
New K-12 Schools Middle
New K-12 Schools High
CBSAs/Metros/MSAs Label
CBSAs/Metros/MSAs
Cong District Code
Cong Districts
Cong Districts Bold
Cong Comm Label
Cong Communities
Cong Communities Div Lbl
Cong Communities Diversity
Cong District Diversity Label
Cong District Diversity
CD 118 PopChg% 2020-22
St Leg Dist Upper
St Leg Dist Lower
School Districts Label
Replaced School Districts
Urban Areas Label
Urban Areas
ZIP Codes Label
ZIP Codes
County Name
Counties1
Counties2
Cities/Places Label
Cities/Places
Cty Population Gain 2020-22
Cty Population Loss 2020-22
Tracts Label
Tracts DP1 Label
Tracts DP1 %Age 65+
Tracts ACS $MHI
Tracts LMI23 Label
Tracts LMI23 MFI Tract/MSA%
BaseLayer
States1

23. Using VDA Desktop GIS (VDAD) .. goto topics
.. VDAD Installer .. click to run .. updated 11/07/23; shows as version 11.08.23

.. TIGERweb Web Map Service (WMS)
.. illustrative appplication

24. Demographic Analytics .. goto topics
.. Demographic Analytics main

25. Demographic-Economic Data Explorer .. goto topics
.. new DEDE2 & Installer .. about DEDE2
.. run DEDE2 installer

.. DEDE compared to DEDE2

.. DEDE Guide updates .. http://proximityone.com/dede_guide/guide
.. DEDE Installer Updated
.. run DEDE installer
.. software not updated but ACS 2021 and 2022 subject matter items files (SMIF) have been updated.
.. see ACS 2021 SMIF used for the start-up display
.. similar to ACS 2022 SMIF
.. items scroll section:

Each of these files include these newly added age fields:
B01001_003E A0004MA22 Male: Under 5 years
B01001_004E A0509MA22 Male: 5 to 9 years
B01001_005E A1014MA22 Male: 10 to 14 years
B01001_006E A1517MA22 Male: 15 to 17 years
B01001_027E A0004FA22 Female: Under 5 years
B01001_028E A0509FA22 Female: 5 to 9 years
B01001_029E A1014FA22 Female: 10 to 14 years
B01001_030E A1517FA22 Female: 15 to 17 years
enabling computation of the dependency ratio.

They also include these newly added educational attainment fields
B15002_011E EAHSMA22 Male: High school graduate (includes equivalency)
B15002_015E EABMA22 Male: Bachelor's degree
B15002_016E EAMMA22 Male: Master's degree
B15002_017E EAPMA22 Male: Professional school degree
B15002_018E EADMA22 Male: Doctorate degree
B15002_028E EAHSFA22 Female: High school graduate (includes equivalency)
B15002_032E EABFA22 Female: Bachelor's degree
B15002_033E EAMFA22 Female: Master's degree
B15002_034E EAPFA22 Female: Professional school degree
B15002_035E EADFA22 Female: Doctorate degree
Enabling new ability to create percentages of educational attainment by highest EA level

They also include these newly added citizen fields:
B29001_001E VATOTA22 Total Citizen, Voting-Age Population
B29001_002E VA1829A22 Total Citizen, Voting-Age Population 18 to 29 years
B29001_003E VA3044A22 Total Citizen, Voting-Age Population 30 to 44 years
B29001_004E VA4564A22 Total Citizen, Voting-Age Population 45 to 64 years
B29001_005E VA65UPA22 Total Citizen, Voting-Age Population 65 or more years
Enabling analysis of age-based citizen voting age population

26. Regional Economic Information System (REIS) .. goto topics

26.1. REIS Main Section
.. reviewing new county level 2022 personal income data released 11/16/22
.. reviewing updated REIS software package

26.2. U.S. & State Quarterly Personal Income Components Dataset
.. 6 BEA sourced datasets developed into a standardized structure running from 2010Q1 through 2023Q2
.. to be restructured some in the week or two ahead
.. other series to be added
.. data reflect a comprehensive update that was finalized this fall

.. using these and related data to simulate projection of the 2023Q3 data to be released by BEA in December
.. also in December, BEA will release similar annual time series data at the county level thru 2022

Scope of Subject Matter .. Corresponding County Level Components
.. Table CA4 - Personal Income by Major Source
.. Table CA5 - Earnings by Source & Sector
.. Table CA25 - Employment by Sector
.. Table CA30 - Economic Profile
.. Table CA35 - Transfer Payments

27. Situation & Outlook Estimates & Projections Overview .. goto topics
See S&O Calendar

28. Selected Recent & Upcoming Data Releases; Tuesday Session Programs .. goto topics
09.06.23. QCEW Quarterly 2023Q1 U.S. by County Establishments, Employment, Earnings (BLS)
- updated quarterly/annual time series by type of business/NAICS
- related Regional Economic Information System
10.04.23. Personal Consumption Expenditures by State, 2022
11.16.23. Personal Income by County and Metropolitan Area, 2022 (BEA); updated annual time series
- related Regional Economic Information System
12.07.23. QCEW Quarterly 2023Q2 U.S. by County Establishments, Employment, Earnings (BLS)
- updated quarterly/annual time series by type of business/NAICS
- related Regional Economic Information System
12.07.23. Gross Domestic Product by County and Metropolitan Area, 2022 (BEA); updated annual time series
- related Regional Economic Information System
12.07.23. 2022 American Community Survey 5-year estimates (Census); data to block group level
- related 2022 American Community Survey
12.14.23. Real Personal Consumption Expenditures by State and Real Personal Income
- by State and Metropolitan Area, 2022
12.15.23. 2022 Small Area Income and Poverty Estimates (Census); school district & county
- related SAIPE

12.22.23. Gross Domestic Product by State and Personal Income by State, 3rd Quarter 2023

01.15.24. U.S. by County Population by Age, Race/Ethnicity, Gender Annual Projections to 2060 (ProximityOne)
- aggregates to metro, state & U.S.
- related Demographics 2060

01.15.24. Situation & Outlook Quarterly Release

01.25.24. K-12 School & School District Administrative Data release (NCES/CCD)
- data for 2022-23 school year

03.08.24. QCEW Quarterly 2023Q3 U.S. by County Establishments, Employment, Earnings (BLS)
- updated quarterly/annual time series by type of business/NAICS
- related Regional Economic Information System

04.15.24. Situation & Outlook Quarterly Release

03.31.24. Gross Domestic Product by State and Personal Income by State, 4th Quarter 2023 and Year 2023 (Preliminary)

Welcome! .. goto interactive mapping below

Introductions

Warren Glimpse
ProximityOne -- http://proximityone.com
.. we build and apply decision-making information and
develop/operate/provide tools for related data access/integration/analysis
wglimpse@proximityone.com

Dan Carracino
Founder, Congressional Communities
.. about Congressional Communities
.. https://congressionalcommunities.org
dan@congressionalcommunities.org

Who this session is for and how you benefit
.. leaders, decision-makers, policy-makers, stakeholders needing to understand demographic-economic change
.. learners & researchers regarding access to and use of tools and data to analyze demographic-economic
characteristics & change

• Site Navigation
• SiteMap
• Register to receive these weekly updates by e-mail.

This session includes the topics listed below.
.. illustrative applications focused selected geography & subject matter
.. ask questions/dialog as we go
.. ~30 minute presentation followed by discussion.

Topics ..
01 Where and How the 119th Congressional Districts are Changing
02 How the Geography of CD 118 and CD 119 Differ
03 About Congressional Communities & Congressional Districts
04 Congressional Communities & Congressional District Demographic Profile -- Demographic Insights
05 Congressional Communities & Congressional District Extended Data -- Broader Insights
06 Examining Congressional Districts/Congressional Communities of Interest
07 Exploring Demographic and Economic Data for Congressional Districts

01. Where and How the 119th Congressional Districts are Changing .. goto topics
The 119th congressional districts ranged in percent population change, 2020-2023, from -9.4% (NY06) to 13.8% (TX03) .. the CD with the lowest 2023 median household income ($MHI) was KY05 ($44,175) and the CD with the highest $MHI was CA17 ($175,010). The economic divide continues to expand.

119th Congressional Districts - Patterns of Population %Change 2020-23
The graphic below shows patterns of percent population change from 2020 (Census 2020) to 2023 (ACS 2023) by 119th Congressional District, contiguous 48 states. See inset legend to associate color pattern to percent change. Click graphic to for larger view with CDs labeled with percent change.

• Above view interactively using iVDA .. reviewed in session
• More about the 119th Congressional Districts

119th Congressional District Interactive Table .. goto top
Use the buttons & tools below the table for most effective use of this table and data.
Click ShowAll button between Find/Queries. Use mouseover on column header to view column description.
See usage notes below table.

Usage Notes

.. Click header cell to sort; click again to sort in other direction.
.. Use buttons below table to query or place filters on the table.

Column notes:
Incumbent -- current incumbent name .. voted into office November 5, 2024 or more recent special election
St -- USPS state abbreviation
St1 -- State FIPS code
CD -- 119th Congressional District code
StCD -- USPS Sate Abbreviation + 119th CD code
Old Party -- party of incumbent before November 5, 2024 election
New Party -- party of current incumbent as of the November 5 election or more recent
.. this field is blank when the election is undecided.
Status -- not used
New Incumbent -- coded "1" if incumbent new to this district
Flip -- coded "1" if this district flipped party in November 2024 election
Note -- note about this district

Pop 2020 - Census 2020
Pop 2023 - ACS 2023 1 year estimate
Pop 20-23 Change
Pop 20-23 %Change
Median Household Income - ACS 2023 1 year estimate

2. How the Geography of CD 118 and CD 119 Differ .. goto topics

• CD 118 geography (shapefiles) are based on TIGER 2023 (released August 2023)
• CD 119 geography (shapefiles) are based on TIGER 2024 (released August 2024)
• CD 118 and CD 119 are the same except for AL, GA, LA, NC, NY (new boundaries for CD 119)
• Compare CD 118 to CD 119 using iVDA with Base project - click here to start
operations reviewed in this web session

• Gerrymandering and Congressional Districts

3. About Congressional Communities & Congressional Districts .. goto topics

Congressional Communities (CCs) are geographic areas that subdivide Congressional Districts based on census blocks. CCs in a CD uniquely exactly exhaust the area of the corresponding CD. CCs provide a way to examine regional differences across each CD. New 119th CCs have been developed based on the 119th Congressional Districts. CCs typical range from 30,000 to 70,000 in population. CCs provide a way for stakeholders to make their voice better heard on legislative policy and agency rule-making issues that affect residents that affect commeunity needs. Participate in your Congressional Community (CC), a subdivision of a Congressional District.

4. Congressional Communities & Congressional District Demographic Profile -- Demographic Insights .. goto topics

• About the Census 2020 Demographic Profile ("DP1") data
• Reviewing scope, structure, use and access of 119th CC-CD dataset and shapefile.

5. Congressional Communities & Congressional District Extended Data -- Broader Insights .. goto topics

• American Community Survey (ACS 2023) annual demographic, social, economic and housing characteristics
• Current (2025) demographic, social, economic and housing data with projections to 2030

6. Examining Congressional Districts/Congressional Communities of Interest .. goto topics

• Extended drill-down characteristics
• Washington Congressional District 03 Briefing Resources
• Using the Kansas CC-CD Demographic-Economics -- illustrative drill down analytics

7. Exploring Demographic and Economic Data for Congressional Districts .. goto topics

Use the new series of videos, new topics each week. Each video focuses on CD(s) and CC(s) and highlights a specific topic, providing local, regional and national insights. To get data tailored to your area, contact us at info@congressionalcommunities.org or wglimpse@proximityone.com.

Discover how these data can drive informed decisions for your community

Related notes:
• Santos resigns as Census Bureau Director .. Census 2030 issues

End of Session

Other Topics

• Demographics for 119th Congressional Districts
- 119th CD geography differs from 118th CDs only in 5 states: AL,GA,LA,NC,NY
- new Census 2020 detailed summary file data .. release date 12.05.24
- illustrative data access via Census API .. Washington CD Demographics
- new ACS 2023 Data Profiles expected February 2025
- relating Congressional Districts to Congressional Communities

• Regional Economic Information System
- personal income by major sources; county time series
- Lewis County, WA REIS Profiles
- relating to Congressional Districts & Congressional Communities

• Relating Counties to CD WA03 using iVDA

• Gross Domestic Product by County and Metropolitan Area, 2023 .. time series .. new 2023 data
Lewis County, WA Example

• Employment Status ACS 2022 by Block Group
- about block groups
- relating to Congressional Districts & Congressional Communities
- using iVDA

United States Employment Status ACS 2023 1 year estimates (Table B23025)

Patterns of Unemployment Rate by Block Group .. Washington State CD 03

• Examining Net Migration: County Groups in WA CD 03
narrated steps using VDAGIS tools

• Examining new 2023-24 K-12 Schools Data
Patterns of Free & Reduced Price Lunch (FRPL) Participation
in context of Washington Congressional District 03 & Congressional Communities
red markers: K-12 schools with 100 or more students and percent FRPL 50% or more
yellow markers: all K-12 schools
click for larger view

• A look ahead: 12.18.24 Topics
- similar Washington state geography focus
- Kansas Congressional District 04 and related Congressional Communities
- accessing & examining data from the ACS 2023 5-year data for these areas .. relased 12/12/14

• Discussion

Start-up View of iVDA focused on Washington Congressional District CD 03
.. an active interactive mapping/data analytics tool.

• End of Session

11.20.24. K-12 Schools & School Districts

Topics
• School District GeoDemographics

• Using iVDA -- Examining Mixed Geographic Relationships

• School District Finances

• upcoming release of 2023-24 K-12 school and school district administrative data (Jan-Feb 2025)

• More about K-12 Schools/School Districts Geography
• More about K-12 Schools/School Districts Subject Matter

• Discussion

• End of Session

11.13.24. 119th Congress Congressional District Composition & Characteristics

Topics include use of interactive mapping and table to examine the composition of the 119th Congressional Districts by district/incumbent.
.. New 119th Congressional Districts section

11.06.26. Examining the Citizen Voting Age Population
The United States Citizen Voting Age Population CVAP increased from 235,418,734 (71.7%) in 2019 to 241,601,029 (72.1%) in 2023. The change is more dramatic for many smaller areas, such as census tracts. The Citizen Voting Age Population (CVAP) is the population 18 year and older who are U.S. citizens. CVAP data are estimated annually for many geographic levels as a part of the American Community Survey ACS 2023. CVAP data are important for many reasons, such as redistricting and analysis of voter registration, voter suppression and voter turnout..

Use iVDA to Examine CVAP for Areas of Interest
Click to start iVDA in the VDAGIS Discovery section for locations and by geography of interest.

Notes about CVAP Data
CVAP data are tabulated annually as a part of the American Community Survey.
• 2023 CVAP data are the most recent "ACS 1-year" data available .. for areas 65,000 and over.
• 2022 CVAP data are the most recent "ACS 5-year" data available .. for all geographic areas.
- down to the block group level
- estimates centric to 2020
- new 2023 ACS 5-year data become available December 2024 .. center to 2021
• CVAP data are available race/origin, educational attainment & age.
• analytical power of using the ACS CVAP data include use of related measures.

CVAP data for census tracts, other small area geography, and generally areas under 65,000 population,

Comparing CVAP and Voter Data
• Using the Orange County, CA OC Vote GIS project .. d:\ocvote\ocvote_110424.gis
• Using OC Vote GIS projects using VDAW

Patterns of CVAP and Voter Registration by Block Group in Laguna Beach, CA Area
.. zoom in view of two block groups (black boundary)
.. markers show registered voters
.. pointer in one block group shows BG labeled with BG CVAP (739) and BG sum of registered voters (528)
.. alternative views & discussion

Other topics
food security
energy related
environmental related
crime related
climate change
prices PCEPI
migration
cities
urban/rural
state legislative districts