The Lasting Legacy Of Redlining: zone-block-matches.csv

Table actions

This repo contains the data behind the story The Lasting Legacy Of Redlining. There are two csv files in this repo: metro-grades.csv and zone-block-matches.csv.

metro-grades.csv contains 2020 population total estimates by race/ethnicity for combined zones of each redlining grade (from Home Owners' Loan Corporation [HOLC] maps originally drawn in 1935-40, downloaded from the Mapping Inequality project) within micro- and metropolitan areas. Also included are population estimates in the surrounding area of each metropolitan area's HOLC map (computed by adding a 10 percent buffer radius to the minimum bounding circle of all zones in that metro area) and location quotients (LQs) for each racial/ethnic group and HOLC grade. LQs are small-area measures of segregation that specifically compare one racial/ethnic group’s proportion in a granular geography to their proportion in a larger surrounding geography. An LQ above 1 for a given racial group indicates overrepresentation in that HOLC zone relative to the broader surrounding area, and values below 1 indicate underrepresentation.

Population and race/ethnicity data comes from the 2020 U.S. decennial census. White, Black and Asian data excludes those who indicated Hispanic or Latino ethnicity. Hispanic/Latino data includes all who indicated Hispanic or Latino ethnicity, regardless of race. Other race data includes all population counts that did not fall under white, Black, Asian or Latino groups.

Only micro- and metropolitan areas with both A- (“best”) and D-rated (“hazardous”) zones in their redlining map are included — 138 of a total 143 metropolitan areas in the data from Mapping Inequality.

Header Definition
metro_area Official U.S. Census name of micro- or metropolitan area — defined as "Core-Based Statistical Areas". The first city and state listed are used as the display name for each micro/metropolitan area in the story (for example, "Chicago-Naperville-Elgin, IL-IN-WI" is referred to as "Chicago, IL").
holc_grade Grade assigned by the Home Owners' Loan Corporation (HOLC). A: "best" (green). B: "Still Desirable" (blue). C: "Definitely Declining" (yellow). D: "Hazardous" (red).
white_pop Estimate of non-Hispanic white population within HOLC zones with a given holc_grade in a given metro_area. Rounded to the nearest integer.
black_pop Estimate of non-Hispanic Black population within HOLC zones with a given holc_grade in a given metro_area. Rounded to the nearest integer.
hisp_pop Estimate of Hispanic/Latino population within HOLC zones with a given holc_grade in a given metro_area. Rounded to the nearest integer.
asian_pop Estimate of non-Hispanic Asian population within HOLC zones with a given holc_grade in a given metro_area. Rounded to the nearest integer.
other_pop Estimate of population in any other racial/ethnic groups within HOLC zones with a given holc_grade in a given metro_area. Rounded to the nearest integer.
total_pop Estimate of total population (across all racial/ethnic groups) within HOLC zones with a given holc_grade in a given metro_area. Rounded to the nearest integer.
pct_white Estimate of the percentage of total population within HOLC zones with a given holc_grade in a given metro_area that are non-Hispanic white. Represented between 0-100. Rounded to the nearest two decimal places.
pct_black Estimate of the percentage of total population within HOLC zones with a given holc_grade in a given metro_area that are non-Hispanic Black. Represented between 0-100. Rounded to the nearest two decimal places.
pct_hisp Estimate of the percentage of total population within HOLC zones with a given holc_grade in a given metro_area that are Hispanic/Latino. Represented between 0-100. Rounded to the nearest two decimal places.
pct_asian Estimate of the percentage of total population within HOLC zones with a given holc_grade in a given metro_area that are non-Hispanic Asian. Represented between 0-100. Rounded to the nearest two decimal places.
pct_other Estimate of the percentage of total population within HOLC zones with a given holc_grade in a given metro_area in any other racial/ethnic group. Represented between 0-100. Rounded to the nearest two decimal places.
lq_white Non-Hispanic white location quotient for a given holc_grade and metro_area.
lq_black Non-Hispanic Black location quotient for a given holc_grade and metro_area.
lq_hisp Hispanic/Latino location quotient for a given holc_grade and metro_area.
lq_asian Non-Hispanic Asian location quotient for a given holc_grade and metro_area.
lq_other All other racial/ethnic groups' location quotient for a given holc_grade and metro_area.
surr_area_white_pop Estimate of non-Hispanic white population within surrounding area of a given metro_area's HOLC zones. Rounded to nearest integer. Repeated for each holc_grade for a given metro_area.
surr_area_black_pop Estimate of non-Hispanic Black population within surrounding area of a given metro_area's HOLC zones. Rounded to nearest integer. Repeated for each holc_grade for a given metro_area.
surr_area_hisp_pop Estimate of Hispanic/Latino population within surrounding area of a given metro_area's HOLC zones. Rounded to nearest integer. Repeated for each holc_grade for a given metro_area.
surr_area_asian_pop Estimate of non-Hispanic Asian population within surrounding area of a given metro_area's HOLC zones. Rounded to nearest integer. Repeated for each holc_grade for a given metro_area.
surr_area_other_pop Estimate of population in any other racial/ethnic groups within surrounding area of a given metro_area's HOLC zones. Rounded to nearest integer. Repeated for each holc_grade for a given metro_area.
surr_area_total_pop Estimate of total population (across all racial/ethnic groups) within surrounding area of a given metro_area's HOLC zones. Rounded to nearest integer. Repeated for each holc_grade for a given metro_area.
surr_area_pct_white Estimate of the percentage of total population within surrounding area of a given metro_area's HOLC zones that are non-Hispanic white. Represented between 0-100. Rounded to the nearest two decimal places. Repeated for each holc_grade for a given metro_area.
surr_area_pct_black Estimate of the percentage of total population within surrounding area of a given metro_area's HOLC zones that are non-Hispanic Black. Represented between 0-100. Rounded to the nearest two decimal places. Repeated for each holc_grade for a given metro_area.
surr_area_pct_hisp Estimate of the percentage of total population within surrounding area of a given metro_area's HOLC zones that are Hispanic/Latino. Represented between 0-100. Rounded to the nearest two decimal places. Repeated for each holc_grade for a given metro_area.
surr_area_pct_asian Estimate of the percentage of total population within surrounding area of a given metro_area's HOLC zones that are non-Hispanic Asian. Represented between 0-100. Rounded to the nearest two decimal places. Repeated for each holc_grade for a given metro_area.
surr_area_pct_other Estimate of the percentage of total population within surrounding area of a given metro_area's HOLC zones in any other racial/ethnic group. Represented between 0-100. Rounded to the nearest two decimal places. Repeated for each holc_grade for a given metro_area.

zone-block-matches.csv is a crosswalk between 2020 U.S. decennial census blocks and Home Owners' Loan Corporation (HOLC) zones (from the collective spatial data shapefile, made available for download by the Mapping Inequality project). HOLC zones were matched to census blocks by first determining census blocks geographically intersected with each zone, then calculating the proportion of the block’s total area that intersects with that HOLC zone. This intersecting area was used to weight each block's census data, which was then summed to estimate 2020 census totals in each HOLC zone.

HOLC zones do not have a unique ID column in the Mapping Inequality shapefile (across all cities and states), but each HOLC zone should have a unique combination of the five columns that begin with holc_ below.

The spatial calculations that generated this data were conducted using the Albers Equal-Area Conic projection.

Header Definition
holc_city City name from this zone's HOLC map. Matches to city column in the Mapping Inequality shapefile.
holc_state State abbreviation from this zone's HOLC map. Matches to state column in the Mapping Inequality shapefile.
holc_grade HOLC grade assigned to this zone (A, B, C or D). Matches to holc_grade column in the Mapping Inequality shapefile.
holc_id HOLC ID assigned to this zone (may be empty). Matches to holc_id column in the Mapping Inequality shapefile.
holc_neighborhood_id Neighborhood ID. Unique for all HOLC zones except holc_ids B6 and B7 in Savannah, GA, which share a holc_neighborhood_id of 8678. Matches to neighborho column in the Mapping Inequality shapefile.
block_geoid20 GEOID20 of 2020 U.S. census block that intersects with a given HOLC zone.
pct_match Estimated percent of the 2020 U.S. census block's total area that intersects with a given HOLC zone. Use this column to weight census data to compute aggregate 2020 U.S. census estimates within an HOLC zone.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

752,351 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ holc_city holc_state holc_grade holc_id holc_neighborhood_id block_geoid20 pct_match
101 101 Akron OH A A10 3316 391535047002012 1.0
102 102 Akron OH A A10 3316 391535047006008 1.0
103 103 Akron OH A A10 3316 391535047006001 0.240249942617352
104 104 Akron OH A A10 3316 391535048002005 0.559913576991339
105 105 Akron OH A A10 3316 391535048004000 0.0526783985905994
106 106 Akron OH A A10 3316 391535047003006 0.867679544149956
107 107 Akron OH A A10 3316 391535048003014 1.0
108 108 Akron OH A A10 3316 391535048002006 1.0
109 109 Akron OH A A10 3316 391535048005010 1.0
110 110 Akron OH A A10 3316 391535048005018 1.0
111 111 Akron OH A A10 3316 391535047006009 1.0
112 112 Akron OH A A10 3316 391535047004010 1.0
113 113 Akron OH A A10 3316 391535048005028 1.0
114 114 Akron OH A A10 3316 391535048003010 1.0
115 115 Akron OH A A10 3316 391535048003017 1.0
116 116 Akron OH A A10 3316 391535048002008 0.10563361656965
117 117 Akron OH A A10 3316 391535048003005 0.486766809246056
118 118 Akron OH A A10 3316 391535048005013 1.0
119 119 Akron OH A A10 3316 391535047004014 1.0
120 120 Akron OH A A10 3316 391535048005014 1.0
121 121 Akron OH A A10 3316 391535048005020 0.827541163166453
122 122 Akron OH A A10 3316 391535047006007 0.446218244088359
123 123 Akron OH A A10 3316 391535048003027 0.995397001810027
124 124 Akron OH A A10 3316 391535048005016 1.0
125 125 Akron OH A A10 3316 391535048003019 0.495025679404671
126 126 Akron OH A A10 3316 391535047002002 0.810071512899047
127 127 Akron OH A A10 3316 391535047002006 1.0
128 128 Akron OH A A10 3316 391535048005026 0.863913739916246
129 129 Akron OH A A10 3316 391535047005011 1.0
130 130 Akron OH A A10 3316 391535047003011 0.997305682424551
131 131 Akron OH A A10 3316 391535048003004 1.0
132 132 Akron OH A A10 3316 391535048005008 1.0
133 133 Akron OH A A10 3316 391535048003016 1.0
134 134 Akron OH A A10 3316 391535048002007 1.0
135 135 Akron OH A A10 3316 391535048002003 0.463418158664581
136 136 Akron OH A A10 3316 391535048002009 0.148691109212005
137 137 Akron OH A A10 3316 391535048005002 0.944829208669751
138 138 Akron OH A A10 3316 391535047004008 1.0
139 139 Akron OH A A10 3316 391535048003012 1.0
140 140 Akron OH A A10 3316 391535048001000 7.6926116369349e-05
141 141 Akron OH A A10 3316 391535048001001 0.0140450613123634
142 142 Akron OH A A10 3316 391535048005015 1.0
143 143 Akron OH A A10 3316 391535047004004 0.598634588457534
144 144 Akron OH A A10 3316 391535047004005 1.0
145 145 Akron OH A A10 3316 391535047005004 0.642450173689727
146 146 Akron OH A A10 3316 391535045002007 0.0506853243079912
147 147 Akron OH A A10 3316 391535047003005 0.194229912486013
148 148 Akron OH A A10 3316 391535045002008 0.024685305145325
149 149 Akron OH A A10 3316 391535048003024 0.493369088778986
150 150 Akron OH A A10 3316 391535048005012 1.0
151 151 Akron OH A A10 3316 391535047004018 1.0
152 152 Akron OH A A10 3316 391535047002007 0.902236465228109
153 153 Akron OH A A10 3316 391535048003028 1.0
154 154 Akron OH A A10 3316 391535048003026 0.992212831053515
155 155 Akron OH A A10 3316 391535048005006 1.0
156 156 Akron OH A A10 3316 391535047003009 0.377094403267274
157 157 Akron OH A A10 3316 391535048003011 1.0
158 158 Akron OH A A11 3309 391535103015008 0.239666922357128
159 159 Akron OH A A11 3309 391535103023011 1.0
160 160 Akron OH A A11 3309 391535103015007 0.240797372824884
161 161 Akron OH A A11 3309 391535103023013 0.86701000142699
162 162 Akron OH A A11 3309 391535103015013 0.0710301868120024
163 163 Akron OH A A11 3309 391535103015023 1.0
164 164 Akron OH A A11 3309 391535103015024 1.0
165 165 Akron OH A A11 3309 391535103023017 0.341378131089832
166 166 Akron OH A A11 3309 391535103015021 0.0689568309315392
167 167 Akron OH A A11 3309 391535103014001 0.951318351067182
168 168 Akron OH A A11 3309 391535103015009 1.0
169 169 Akron OH A A11 3309 391535103023012 1.0
170 170 Akron OH A A11 3309 391535103015012 0.0715169100637492
171 171 Akron OH A A11 3309 391535103023003 0.220306247167244
172 172 Akron OH A A11 3309 391535103015022 1.0
173 173 Akron OH A A11 3309 391535103015011 1.0
174 174 Akron OH A A11 3309 391535103015014 1.0
175 175 Akron OH A A11 3309 391535103014002 0.99489442365372
176 176 Akron OH A A11 3309 391535103023018 0.325753063400827
177 177 Akron OH A A11 3309 391535103015015 1.0
178 178 Akron OH A A11 3309 391535103015019 1.0
179 179 Akron OH A A11 3309 391535103014004 0.0031356868037856
180 180 Akron OH A A11 3309 391535103023009 0.759191547395475
181 181 Akron OH A A11 3309 391535103015006 0.239046063177601
182 182 Akron OH A A11 3309 391535103023014 0.834799548927357
183 183 Akron OH A A11 3309 391535103014000 0.90626546148369
184 184 Akron OH A A11 3309 391535103023010 0.340225278742564
185 185 Akron OH A A11 3309 391535103015017 1.0
186 186 Akron OH A A11 3309 391535103015020 0.0680981044109586
187 187 Akron OH A A11 3309 391535103023021 0.281721557963062
188 188 Akron OH A A11 3309 391535103014003 0.0685049667323827
189 189 Akron OH A A11 3309 391535103023007 0.0480545106590983
190 190 Akron OH A A11 3309 391535103023016 1.0
191 191 Akron OH A A11 3309 391535103023015 0.806867319111038
192 192 Akron OH A A11 3309 391535103015016 1.0
193 193 Akron OH A A11 3309 391535103015018 1.0
194 194 Akron OH A A11 3309 391535103015005 0.0172492805846344
195 195 Akron OH A A11 3309 391535103014005 0.0002024353229881
196 196 Akron OH A A11 3309 391535103015010 1.0
197 197 Akron OH A A2 3347 391535202025014 1.0
198 198 Akron OH A A2 3347 391535203022020 0.882316240167993
199 199 Akron OH A A2 3347 391535204001017 0.449668944036181
200 200 Akron OH A A2 3347 391535203023038 1.0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "redlining/zone-block-matches" (
"holc_city" TEXT,
  "holc_state" TEXT,
  "holc_grade" TEXT,
  "holc_id" TEXT,
  "holc_neighborhood_id" INTEGER,
  "block_geoid20" INTEGER,
  "pct_match" REAL
);