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
1 1 Akron OH A A1 3351 391535307001006 0.646292021263085
2 2 Akron OH A A1 3351 391535307003009 0.554689821818668
3 3 Akron OH A A1 3351 391535307003008 0.864987146752408
4 4 Akron OH A A1 3351 391535307001001 0.963289457637564
5 5 Akron OH A A1 3351 391535307002003 1.0
6 6 Akron OH A A1 3351 391535307002008 1.0
7 7 Akron OH A A1 3351 391535307003017 1.0
8 8 Akron OH A A1 3351 391535307001007 1.0
9 9 Akron OH A A1 3351 391535206002024 0.0281454684714575
10 10 Akron OH A A1 3351 391535307001009 1.0
11 11 Akron OH A A1 3351 391535307001011 0.288735532960741
12 12 Akron OH A A1 3351 391535307001005 1.0
13 13 Akron OH A A1 3351 391535307003006 1.0
14 14 Akron OH A A1 3351 391535307003010 1.0
15 15 Akron OH A A1 3351 391535307003005 1.0
16 16 Akron OH A A1 3351 391535307003012 0.0180454340504957
17 17 Akron OH A A1 3351 391535307003013 0.0908179281861271
18 18 Akron OH A A1 3351 391535307002017 0.563990139040023
19 19 Akron OH A A1 3351 391535307002002 1.0
20 20 Akron OH A A1 3351 391535307003016 1.0
21 21 Akron OH A A1 3351 391535307002001 1.0
22 22 Akron OH A A1 3351 391535307001002 0.995923444302748
23 23 Akron OH A A1 3351 391535307003011 0.705368423217092
24 24 Akron OH A A1 3351 391535307003002 1.0
25 25 Akron OH A A1 3351 391535307002006 0.777918185630505
26 26 Akron OH A A1 3351 391535307003004 1.0
27 27 Akron OH A A1 3351 391535307003001 0.945234508220771
28 28 Akron OH A A1 3351 391535307002005 0.968483788012578
29 29 Akron OH A A1 3351 391535307002000 1.0
30 30 Akron OH A A1 3351 391535307003007 1.0
31 31 Akron OH A A1 3351 391535307001003 1.0
32 32 Akron OH A A1 3351 391535307001010 0.792922320222215
33 33 Akron OH A A1 3351 391535307003015 1.0
34 34 Akron OH A A1 3351 391535307001004 1.0
35 35 Akron OH A A1 3351 391535307001008 1.0
36 36 Akron OH A A1 3351 391535307002007 1.0
37 37 Akron OH A A1 3351 391535306042020 0.0161616530675842
38 38 Akron OH A A1 3351 391535307002004 0.0910501785859548
39 39 Akron OH A A1 3351 391535307001000 0.682459778478271
40 40 Akron OH A A1 3351 391535307002009 0.762946066887464
41 41 Akron OH A A1 3351 391535304011015 0.0051829954225031
42 42 Akron OH A A1 3351 391535307002015 0.0190809916966894
43 43 Akron OH A A1 3351 391535206002023 0.0014644438449565
44 44 Akron OH A A1 3351 391535307003003 0.687613605711884
45 45 Akron OH A A10 3316 391535047002004 0.988618365054903
46 46 Akron OH A A10 3316 391535047004003 1.0
47 47 Akron OH A A10 3316 391535047004009 1.0
48 48 Akron OH A A10 3316 391535047004016 1.0
49 49 Akron OH A A10 3316 391535047005007 1.0
50 50 Akron OH A A10 3316 391535047004002 1.0
51 51 Akron OH A A10 3316 391535048005007 1.0
52 52 Akron OH A A10 3316 391535047005000 1.0
53 53 Akron OH A A10 3316 391535048002004 0.558940141185351
54 54 Akron OH A A10 3316 391535047005005 1.0
55 55 Akron OH A A10 3316 391535047005008 1.0
56 56 Akron OH A A10 3316 391535048003003 1.0
57 57 Akron OH A A10 3316 391535047006006 0.243881745578592
58 58 Akron OH A A10 3316 391535047002005 1.0
59 59 Akron OH A A10 3316 391535047004001 1.0
60 60 Akron OH A A10 3316 391535048003008 0.480694608373045
61 61 Akron OH A A10 3316 391535048005004 1.0
62 62 Akron OH A A10 3316 391535048005027 1.0
63 63 Akron OH A A10 3316 391535048003002 1.0
64 64 Akron OH A A10 3316 391535047003004 0.0200057360941459
65 65 Akron OH A A10 3316 391535047002011 0.953685185705002
66 66 Akron OH A A10 3316 391535048005005 1.0
67 67 Akron OH A A10 3316 391535047005012 1.0
68 68 Akron OH A A10 3316 391535047005001 0.614268973057456
69 69 Akron OH A A10 3316 391535047004006 1.0
70 70 Akron OH A A10 3316 391535048003000 1.0
71 71 Akron OH A A10 3316 391535047006000 0.297095831767144
72 72 Akron OH A A10 3316 391535048005017 1.0
73 73 Akron OH A A10 3316 391535048005009 1.0
74 74 Akron OH A A10 3316 391535047003007 0.0332259841642684
75 75 Akron OH A A10 3316 391535047002013 1.0
76 76 Akron OH A A10 3316 391535047004019 1.0
77 77 Akron OH A A10 3316 391535048004001 0.0227108831408985
78 78 Akron OH A A10 3316 391535047005009 0.438427832975051
79 79 Akron OH A A10 3316 391535048003013 0.999999999999999
80 80 Akron OH A A10 3316 391535047003010 1.0
81 81 Akron OH A A10 3316 391535047004013 1.0
82 82 Akron OH A A10 3316 391535048003018 0.508414220143308
83 83 Akron OH A A10 3316 391535048005019 1.0
84 84 Akron OH A A10 3316 391535048005011 1.0
85 85 Akron OH A A10 3316 391535048005003 1.0
86 86 Akron OH A A10 3316 391535047005006 1.0
87 87 Akron OH A A10 3316 391535047004017 1.0
88 88 Akron OH A A10 3316 391535047004000 1.0
89 89 Akron OH A A10 3316 391535048003001 1.0
90 90 Akron OH A A10 3316 391535047004012 1.0
91 91 Akron OH A A10 3316 391535048003015 1.0
92 92 Akron OH A A10 3316 391535047004011 1.0
93 93 Akron OH A A10 3316 391535048003009 1.0
94 94 Akron OH A A10 3316 391535048003029 1.0
95 95 Akron OH A A10 3316 391535047002003 0.980421225068111
96 96 Akron OH A A10 3316 391535048003023 0.501677258073889
97 97 Akron OH A A10 3316 391535047004015 0.937882822895939
98 98 Akron OH A A10 3316 391535048005029 1.0
99 99 Akron OH A A10 3316 391535047004007 1.0
100 100 Akron OH A A10 3316 391535047005010 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
);