The Lasting Legacy Of Redlining: zone-block-matches.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
752,351 rows sorted by holc_id
This data as json, copyable, CSV (advanced)
Link | rowid | holc_city | holc_state | holc_grade | holc_id ▼ | holc_neighborhood_id | block_geoid20 | pct_match |
---|---|---|---|---|---|---|---|---|
206145 | 206145 | Decatur | IL | B | 5475 | 171150011002034 | 1.0 | |
206146 | 206146 | Decatur | IL | B | 5474 | 171150024023004 | 0.0633654221609767 | |
206147 | 206147 | Decatur | IL | B | 5475 | 171150011002020 | 0.159168872759262 | |
206148 | 206148 | Decatur | IL | B | 5474 | 171150024022016 | 1.0 | |
206149 | 206149 | Decatur | IL | B | 5474 | 171150024022014 | 0.0291411662653848 | |
206150 | 206150 | Decatur | IL | B | 5474 | 171150024022046 | 1.0 | |
206151 | 206151 | Decatur | IL | B | 5474 | 171150024022018 | 1.0 | |
206152 | 206152 | Decatur | IL | B | 5475 | 171150011002038 | 0.781063915596479 | |
206153 | 206153 | Decatur | IL | B | 5474 | 171150024023003 | 0.0244483945528032 | |
206154 | 206154 | Decatur | IL | B | 5475 | 171150011002021 | 0.0773674595559507 | |
206155 | 206155 | Decatur | IL | B | 5474 | 171150024022012 | 0.856208731243099 | |
206156 | 206156 | Decatur | IL | B | 5474 | 171150024022019 | 1.0 | |
206157 | 206157 | Decatur | IL | B | 5474 | 171150024021010 | 0.0101198913560791 | |
206158 | 206158 | Decatur | IL | B | 5474 | 171150024021009 | 0.0005938852034592 | |
206159 | 206159 | Decatur | IL | B | 5474 | 171150024022017 | 1.0 | |
206160 | 206160 | Decatur | IL | B | 5475 | 171150011002035 | 0.0579519781360699 | |
206161 | 206161 | Decatur | IL | B | 5475 | 171150011001056 | 0.363719426577767 | |
206162 | 206162 | Decatur | IL | B | 5474 | 171150024023000 | 0.0567106029653342 | |
206163 | 206163 | Decatur | IL | B | 5474 | 171150024023001 | 0.0196015722525891 | |
206164 | 206164 | Decatur | IL | B | 5475 | 171150011002040 | 1.0 | |
206165 | 206165 | Decatur | IL | B | 5474 | 171150024022047 | 1.0 | |
206166 | 206166 | Decatur | IL | B | 5474 | 171150024021012 | 0.0778095634099552 | |
206167 | 206167 | Decatur | IL | B | 5474 | 171150024022008 | 0.291146782603215 | |
206168 | 206168 | Decatur | IL | B | 5475 | 171150011002033 | 1.0 | |
206169 | 206169 | Decatur | IL | B | 5475 | 171150011001055 | 0.0041083716232136 | |
206170 | 206170 | Decatur | IL | B | 5474 | 171150024022045 | 1.0 | |
206171 | 206171 | Decatur | IL | B | 5475 | 171150011002037 | 0.162565224899521 | |
206172 | 206172 | Decatur | IL | B | 5474 | 171150024022020 | 0.0162104680110644 | |
206173 | 206173 | Decatur | IL | B | 5474 | 171150024022013 | 1.0 | |
206174 | 206174 | Decatur | IL | B | 5475 | 171150011002039 | 0.801378592743822 | |
206175 | 206175 | Decatur | IL | B | 5474 | 171150024022015 | 1.0 | |
207145 | 207145 | Decatur | IL | D | 5476 | 171150011002009 | 1.0 | |
207146 | 207146 | Decatur | IL | D | 5476 | 171150021001036 | 0.164211411375026 | |
207147 | 207147 | Decatur | IL | D | 5476 | 171150011002000 | 0.0917081435082369 | |
207148 | 207148 | Decatur | IL | D | 5476 | 171150011002004 | 1.0 | |
207149 | 207149 | Decatur | IL | D | 5476 | 171150010001016 | 1.0 | |
207150 | 207150 | Decatur | IL | D | 5476 | 171150011002008 | 0.122024635611453 | |
207151 | 207151 | Decatur | IL | D | 5476 | 171150021001020 | 0.0047712936711202 | |
207152 | 207152 | Decatur | IL | D | 5476 | 171150021001035 | 0.982042454740983 | |
207153 | 207153 | Decatur | IL | D | 5476 | 171150011002006 | 0.997627106300355 | |
207154 | 207154 | Decatur | IL | D | 5476 | 171150010001011 | 0.945991964649134 | |
207155 | 207155 | Decatur | IL | D | 5476 | 171150010001014 | 1.0 | |
207156 | 207156 | Decatur | IL | D | 5476 | 171150010001013 | 1.0 | |
207157 | 207157 | Decatur | IL | D | 5476 | 171150010001027 | 0.987473018343385 | |
207158 | 207158 | Decatur | IL | D | 5476 | 171150010001045 | 0.941730663362854 | |
207159 | 207159 | Decatur | IL | D | 5476 | 171150010001041 | 0.0015869503637124 | |
207160 | 207160 | Decatur | IL | D | 5476 | 171150011002007 | 1.0 | |
207161 | 207161 | Decatur | IL | D | 5476 | 171150010001012 | 0.176695427388974 | |
207162 | 207162 | Decatur | IL | D | 5476 | 171150010001040 | 0.0099981233163554 | |
207163 | 207163 | Decatur | IL | D | 5476 | 171150010001043 | 1.0 | |
207164 | 207164 | Decatur | IL | D | 5476 | 171150011002003 | 0.0702272449626395 | |
207165 | 207165 | Decatur | IL | D | 5476 | 171150010001010 | 0.83661533038435 | |
207166 | 207166 | Decatur | IL | D | 5476 | 171150010001042 | 0.999800438924339 | |
207167 | 207167 | Decatur | IL | D | 5476 | 171150010001019 | 6.19615832094068e-05 | |
207168 | 207168 | Decatur | IL | D | 5476 | 171150021001026 | 0.138055485606226 | |
207169 | 207169 | Decatur | IL | D | 5476 | 171150011002002 | 1.0 | |
207170 | 207170 | Decatur | IL | D | 5476 | 171150010001044 | 0.976111580959626 | |
214448 | 214448 | Des Moines | IA | A | 8372 | 191530006003001 | 1.0 | |
214449 | 214449 | Des Moines | IA | A | 8372 | 191530006003002 | 0.0087564446309512 | |
214450 | 214450 | Des Moines | IA | A | 8378 | 191530006002003 | 0.833026334633271 | |
214451 | 214451 | Des Moines | IA | A | 8372 | 191530006002010 | 0.0025257904317139 | |
214452 | 214452 | Des Moines | IA | A | 8372 | 191530006003009 | 0.910583469872104 | |
214453 | 214453 | Des Moines | IA | A | 8372 | 191530006002015 | 0.999697425889137 | |
214454 | 214454 | Des Moines | IA | A | 8372 | 191530006002014 | 0.884795052583836 | |
214455 | 214455 | Des Moines | IA | A | 8378 | 191530105001017 | 0.0010211773939668 | |
214456 | 214456 | Des Moines | IA | A | 8372 | 191530006001017 | 0.0609734068803346 | |
214457 | 214457 | Des Moines | IA | A | 8372 | 191530006002013 | 0.042971201557881 | |
214458 | 214458 | Des Moines | IA | A | 8372 | 191530006002017 | 0.7734315888554 | |
214459 | 214459 | Des Moines | IA | A | 8372 | 191530006001014 | 0.0561481309322304 | |
214460 | 214460 | Des Moines | IA | A | 8372 | 191530006003000 | 0.0630137555105147 | |
214461 | 214461 | Des Moines | IA | A | 8372 | 191530006003004 | 0.0112862744934434 | |
214462 | 214462 | Des Moines | IA | A | 8372 | 191530006001015 | 0.979321496061243 | |
214463 | 214463 | Des Moines | IA | A | 8378 | 191530006002007 | 0.130802326854176 | |
214464 | 214464 | Des Moines | IA | A | 8372 | 191530006002016 | 0.992357801549854 | |
214465 | 214465 | Des Moines | IA | A | 8372 | 191530006001016 | 1.0 | |
214466 | 214466 | Des Moines | IA | A | 8378 | 191530006002002 | 0.996639341461548 | |
214467 | 214467 | Des Moines | IA | A | 8378 | 191530105001064 | 0.0194184801713532 | |
214468 | 214468 | Des Moines | IA | A | 8378 | 191530006002001 | 0.119531102701465 | |
214469 | 214469 | Des Moines | IA | A | 8372 | 191530006002011 | 0.0109263406685224 | |
274842 | 274842 | Fort Wayne | IN | C | 4127 | 180030115013019 | 0.0058514285534008 | |
274843 | 274843 | Fort Wayne | IN | C | 4127 | 180030115013012 | 0.172950868217828 | |
274844 | 274844 | Fort Wayne | IN | C | 4127 | 180030115013020 | 0.798119871794234 | |
275014 | 275014 | Fort Wayne | IN | D | 4131 | 180030013002014 | 0.385768882723744 | |
275015 | 275015 | Fort Wayne | IN | D | 4131 | 180030013002013 | 0.860187796756792 | |
308585 | 308585 | Houston | TX | A | 7936 | 482014107061002 | 1.0 | |
308586 | 308586 | Houston | TX | A | 7917 | 482013129022002 | 1.0 | |
308587 | 308587 | Houston | TX | A | 7917 | 482013126032043 | 1.0 | |
308588 | 308588 | Houston | TX | A | 7936 | 482014107032001 | 1.0 | |
308589 | 308589 | Houston | TX | A | 7936 | 482014107061004 | 1.0 | |
308590 | 308590 | Houston | TX | A | 7936 | 482014109002008 | 1.0 | |
308591 | 308591 | Houston | TX | A | 7917 | 482013126012002 | 1.0 | |
308592 | 308592 | Houston | TX | A | 7917 | 482013125022030 | 0.658804998858305 | |
308593 | 308593 | Houston | TX | A | 7917 | 482013124001015 | 1.0 | |
308594 | 308594 | Houston | TX | A | 7936 | 482014119011012 | 1.0 | |
308595 | 308595 | Houston | TX | A | 7917 | 482013126032022 | 1.0 | |
308596 | 308596 | Houston | TX | A | 7936 | 482014119021030 | 1.0 | |
308597 | 308597 | Houston | TX | A | 7917 | 482013125021015 | 0.88420650740743 | |
308598 | 308598 | Houston | TX | A | 7936 | 482014120001001 | 0.624256070429729 | |
308599 | 308599 | Houston | TX | A | 7936 | 482014107061041 | 0.528873268896602 | |
308600 | 308600 | Houston | TX | A | 7917 | 482013127001006 | 1.0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );