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 pct_match
This data as json, copyable, CSV (advanced)
Link | rowid | holc_city | holc_state | holc_grade | holc_id | holc_neighborhood_id | block_geoid20 | pct_match ▼ |
---|---|---|---|---|---|---|---|---|
720491 | 720491 | Tulsa | OK | A | A | 8062 | 401430114002004 | 7.38127739696866e-13 |
302296 | 302296 | Harrisburg | PA | B | B | 9205 | 420430220003006 | 5.7309763650908195e-12 |
720858 | 720858 | Tulsa | OK | A | A | 8062 | 401430114002003 | 9.49216362578303e-12 |
633182 | 633182 | Savannah | GA | C | C14 | 8690 | 130510021001029 | 1.3230299365675498e-11 |
326530 | 326530 | Indianapolis | IN | C | C7 | 5460 | 180973226021001 | 3.4183414951914394e-11 |
695973 | 695973 | Stockton | CA | D | D2 | 876 | 60770008031000 | 2.2139022536697e-10 |
186429 | 186429 | Columbus | OH | D | D1 | 544 | 390490007203019 | 4.62272124863246e-10 |
5020 | 5020 | Akron | OH | C | C20 | 3305 | 391535054003009 | 5.09388307815824e-10 |
632824 | 632824 | Savannah | GA | C | C14 | 8690 | 130510027001002 | 6.112257701994931e-10 |
285925 | 285925 | Grand Rapids | MI | B | B6 | 4351 | 260810041001025 | 8.50638775404422e-10 |
320618 | 320618 | Indianapolis | IN | A | A1 | 5416 | 180973207001059 | 8.94144084600429e-10 |
245980 | 245980 | Duluth | MN | B | B1 | 2849 | 271370007001007 | 1.84971866580457e-09 |
738581 | 738581 | Wheeling | WV | C | C6 | 6521 | 540510213003006 | 2.50944983884849e-09 |
41580 | 41580 | Beaumont | TX | C | C | 8879 | 482450011003014 | 2.81309971796618e-09 |
587992 | 587992 | Racine | WI | D | D4 | 5346 | 551010029001017 | 3.13824507304543e-09 |
580642 | 580642 | Queens | NY | C | C73 | 2517 | 360810142022007 | 3.13881871011347e-09 |
215544 | 215544 | Des Moines | IA | C | C3 | 8380 | 191530110283028 | 4.27205685344211e-09 |
3118 | 3118 | Akron | OH | C | C12 | 3294 | 391535068001020 | 4.477903842516071e-09 |
683885 | 683885 | St. Paul | MN | C | C4 | 8107 | 271230316002010 | 5.0229522326269806e-09 |
459893 | 459893 | Mobile | AL | D | D6 | 3915 | 10970006002001 | 5.9681478845218105e-09 |
181357 | 181357 | Columbus | OH | A | A3 | 567 | 390490002201002 | 6.1801953557001305e-09 |
276037 | 276037 | Fort Worth | TX | B | B | 8959 | 484391012023023 | 6.19545834099956e-09 |
739062 | 739062 | Wheeling | WV | D | D6 | 6516 | 540510205001008 | 7.276385035320951e-09 |
421609 | 421609 | Macon | GA | C | C16 | 4078 | 130210129002031 | 7.973158333433721e-09 |
683898 | 683898 | St. Paul | MN | C | C4 | 8107 | 271230316002006 | 8.38990388604047e-09 |
538328 | 538328 | Pittsburgh | PA | B | B20 | 2166 | 420034782001004 | 8.7122329021367e-09 |
450674 | 450674 | Milwaukee Co. | WI | D | D13 | 6365 | 550790185001015 | 9.241955462267462e-09 |
243295 | 243295 | Detroit | MI | D | D50 | 5967 | 260992583002019 | 9.85336441226559e-09 |
287280 | 287280 | Grand Rapids | MI | C | C25 | 4350 | 260810041001025 | 1.04163045436986e-08 |
519768 | 519768 | Philadelphia | PA | B | B6 | 5719 | 421010254001002 | 1.16484158234823e-08 |
649308 | 649308 | Somerville | MA | C | C2 | 5047 | 250173510022000 | 1.1749937472036e-08 |
266759 | 266759 | Evansville | IN | A | A2 | 3847 | 181630006002000 | 1.23514806260694e-08 |
511827 | 511827 | Pawtucket & Central Falls | RI | A | A1 | 9512 | 440070118001036 | 1.37971182906817e-08 |
669650 | 669650 | St. Louis | MO | A | A27 | 6808 | 291892165001007 | 1.43210374285096e-08 |
215935 | 215935 | Des Moines | IA | C | C6 | 8373 | 191530002023003 | 1.45435122539504e-08 |
48687 | 48687 | Bergen Co. | NJ | C | C41 | 7364 | 340030232011009 | 1.45450517100211e-08 |
497765 | 497765 | Oakland | CA | D | D15 | 6749 | 60014060001039 | 1.54604505823381e-08 |
6505 | 6505 | Akron | OH | D | D7 | 3323 | 391535026001009 | 1.62697564585757e-08 |
197562 | 197562 | Dallas | TX | D | D3 | 6451 | 481130211002003 | 1.70383943429854e-08 |
671618 | 671618 | St. Louis | MO | B | B13 | 6859 | 295101076002019 | 1.71967521309945e-08 |
505502 | 505502 | Oklahoma City | OK | D | 90R | 8728 | 401091053003049 | 1.80498621420167e-08 |
634065 | 634065 | Schenectady | NY | B | B4 | 5187 | 360930208002001 | 1.88409272756455e-08 |
341307 | 341307 | Kalamazoo | MI | C | C16 | 3374 | 260770006012009 | 1.99701287562835e-08 |
698504 | 698504 | Syracuse | NY | C | C4 | 5246 | 360670008002005 | 2.04012276571929e-08 |
740033 | 740033 | Wichita | KS | C | C1 | 4177 | 201730009002002 | 2.29642395862568e-08 |
503511 | 503511 | Oklahoma City | OK | C | 5Y | 8813 | 401091066011010 | 2.49143876744913e-08 |
161947 | 161947 | Chicago | IL | D | D72 | 1490 | 170316122003000 | 2.83832421429254e-08 |
516232 | 516232 | Philadelphia | PA | A | A9 | 5669 | 421010375002000 | 2.97240073152044e-08 |
623314 | 623314 | San Diego | CA | D | D4 | 634 | 60730050001025 | 3.07540290814816e-08 |
734927 | 734927 | Waterbury | CT | B | B5 | 9551 | 90053601005004 | 3.20429732740619e-08 |
629826 | 629826 | San Jose | CA | B | B2 | 816 | 60855006004006 | 3.3917530134696e-08 |
556939 | 556939 | Portland | OR | C | C15 | 6118 | 410510077001027 | 3.49037772874536e-08 |
720146 | 720146 | Troy | NY | D | D4 | 2339 | 360830407013006 | 3.5195479217053e-08 |
587502 | 587502 | Racine | WI | C | C2 | 5344 | 551010013021001 | 3.69982976315059e-08 |
649300 | 649300 | Somerville | MA | C | C2 | 5047 | 250173509001000 | 3.73600514393565e-08 |
426343 | 426343 | Manchester | NH | C | C9 | 6925 | 330110003003001 | 3.77046854630943e-08 |
213573 | 213573 | Denver | CO | D | D8 | 6560 | 80310007042008 | 3.79351273711698e-08 |
676300 | 676300 | St. Louis | MO | C | C16 | 6857 | 295101151005001 | 3.82673275284204e-08 |
647269 | 647269 | Sioux City | IA | C | C3 | 8321 | 191930015001019 | 3.99852801548152e-08 |
7958 | 7958 | Albany | NY | D | D4 | 6578 | 360010026004009 | 4.03430595458334e-08 |
451304 | 451304 | Milwaukee Co. | WI | D | D5 | 6305 | 550791859001015 | 4.32394338330553e-08 |
426320 | 426320 | Manchester | NH | C | C9 | 6925 | 330110003003000 | 4.36089124694075e-08 |
422506 | 422506 | Macon | GA | D | D7 | 4079 | 130210129002031 | 4.46643347442165e-08 |
625600 | 625600 | San Francisco | CA | B | B3 | 712 | 60750428002006 | 4.63011657520417e-08 |
112352 | 112352 | Chicago | IL | B | B123 | 1601 | 170317503001002 | 4.78664679383663e-08 |
300076 | 300076 | Hamilton | OH | B | B2 | 110 | 390170010023016 | 4.84149391409349e-08 |
740265 | 740265 | Wichita | KS | C | C4 | 4193 | 201730003001014 | 4.86836197167073e-08 |
249641 | 249641 | East St. Louis | IL | C | C6 | 4584 | 171635012003007 | 4.89082296307373e-08 |
503779 | 503779 | Oklahoma City | OK | C | 74Y | 8732 | 401091071031000 | 5.01672614239834e-08 |
492705 | 492705 | Oakland | CA | B | B20 | 6705 | 60014052003010 | 5.18934509565468e-08 |
662515 | 662515 | Springfield | IL | D | D13 | 4094 | 171670023003008 | 5.60576726488164e-08 |
461016 | 461016 | Montgomery | AL | D | D1 | 3961 | 11010001001086 | 5.88054413388458e-08 |
430767 | 430767 | Melrose | MA | B | B1 | 5138 | 250173354003015 | 5.93809443509861e-08 |
257435 | 257435 | Essex Co. | NJ | A | A11 | 7120 | 340130194003003 | 6.3261725677312e-08 |
720507 | 720507 | Tulsa | OK | A | A | 8057 | 401430037003026 | 6.3695172525832e-08 |
173109 | 173109 | Cleveland | OH | C | C4 | 462 | 390351342042010 | 6.75981917529508e-08 |
452885 | 452885 | Minneapolis | MN | A | A2 | 9101 | 270531099004000 | 6.87167312646733e-08 |
551619 | 551619 | Pontiac | MI | D | D4 | 4845 | 261251459003001 | 6.90444745094121e-08 |
505379 | 505379 | Oklahoma City | OK | D | 87R | 8723 | 401091048001002 | 7.00309094820928e-08 |
214382 | 214382 | Des Moines | IA | A | A3 | 8369 | 191530048002002 | 7.08682624681093e-08 |
198389 | 198389 | Dallas | TX | D | D8 | 6428 | 481130018021014 | 7.13173833209423e-08 |
664979 | 664979 | Springfield | OH | A | A3 | 3272 | 390230006001000 | 7.19491890244931e-08 |
358272 | 358272 | Lincoln | NE | B | B12 | 9566 | 311090016004015 | 7.26227492140779e-08 |
87402 | 87402 | Brooklyn | NY | D | D19 | 2672 | 360470606001002 | 7.34097616483696e-08 |
670324 | 670324 | St. Louis | MO | B | B1 | 6891 | 295101141014000 | 7.34836939327955e-08 |
642290 | 642290 | Seattle | WA | D | D10 | 1747 | 530330096002007 | 7.40807275403933e-08 |
42970 | 42970 | Belmont | MA | D | D1 | 5085 | 250173543003000 | 7.41700816589734e-08 |
391094 | 391094 | Los Angeles | CA | C | C22 | 7616 | 60371861004002 | 7.63924748275169e-08 |
439405 | 439405 | Miami | FL | C | C21 | 917 | 120860004171032 | 7.67514654768786e-08 |
157871 | 157871 | Chicago | IL | D | D37 | 1415 | 170318382001001 | 7.76373059175451e-08 |
501119 | 501119 | Oklahoma City | OK | A | 10G | 8807 | 401091093001011 | 8.3510371383311e-08 |
523645 | 523645 | Philadelphia | PA | C | C13 | 5663 | 421010111003002 | 8.50785249246131e-08 |
40197 | 40197 | Bay City | MI | D | D3 | 4284 | 260172865001001 | 8.82429219803893e-08 |
12256 | 12256 | Amarillo | TX | D | D | 8660 | 483750122003003 | 8.86051057417995e-08 |
383149 | 383149 | Los Angeles | CA | C | C134 | 7853 | 60375018023006 | 8.95199283912774e-08 |
482856 | 482856 | New Orleans | LA | D | LA I3 | 3016 | 220710039002031 | 9.12279491428174e-08 |
550567 | 550567 | Pittsburgh | PA | D | D9 | 2124 | 420035231004004 | 9.50936397092515e-08 |
458717 | 458717 | Minneapolis | MN | D | D9 | 9135 | 270531064002021 | 9.74209277717782e-08 |
424569 | 424569 | Malden | MA | C | C1 | 5132 | 250173411013006 | 1.00959489810255e-07 |
300091 | 300091 | Hamilton | OH | B | B2 | 110 | 390170011003007 | 1.0444454051708e-07 |
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 );