ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

203,591 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
200593 2020-06-03 Autauga Alabama 1001 240 5
200594 2020-06-03 Baldwin Alabama 1003 308 9
200595 2020-06-03 Barbour Alabama 1005 178 1
200596 2020-06-03 Bibb Alabama 1007 79 1
200597 2020-06-03 Blount Alabama 1009 65 1
200598 2020-06-03 Bullock Alabama 1011 216 6
200599 2020-06-03 Butler Alabama 1013 421 18
200600 2020-06-03 Calhoun Alabama 1015 173 3
200601 2020-06-03 Chambers Alabama 1017 371 26
200602 2020-06-03 Cherokee Alabama 1019 39 3
200603 2020-06-03 Chilton Alabama 1021 109 1
200604 2020-06-03 Choctaw Alabama 1023 154 10
200605 2020-06-03 Clarke Alabama 1025 150 2
200606 2020-06-03 Clay Alabama 1027 28 2
200607 2020-06-03 Cleburne Alabama 1029 15 1
200608 2020-06-03 Coffee Alabama 1031 242 1
200609 2020-06-03 Colbert Alabama 1033 190 2
200610 2020-06-03 Conecuh Alabama 1035 41 1
200611 2020-06-03 Coosa Alabama 1037 40 1
200612 2020-06-03 Covington Alabama 1039 86 1
200613 2020-06-03 Crenshaw Alabama 1041 81 3
200614 2020-06-03 Cullman Alabama 1043 154 1
200615 2020-06-03 Dale Alabama 1045 125 0
200616 2020-06-03 Dallas Alabama 1047 287 3
200617 2020-06-03 DeKalb Alabama 1049 261 3
200618 2020-06-03 Elmore Alabama 1051 383 9
200619 2020-06-03 Escambia Alabama 1053 75 3
200620 2020-06-03 Etowah Alabama 1055 266 12
200621 2020-06-03 Fayette Alabama 1057 18 0
200622 2020-06-03 Franklin Alabama 1059 581 8
200623 2020-06-03 Geneva Alabama 1061 44 0
200624 2020-06-03 Greene Alabama 1063 95 4
200625 2020-06-03 Hale Alabama 1065 183 9
200626 2020-06-03 Henry Alabama 1067 81 2
200627 2020-06-03 Houston Alabama 1069 236 5
200628 2020-06-03 Jackson Alabama 1071 86 3
200629 2020-06-03 Jefferson Alabama 1073 1913 104
200630 2020-06-03 Lamar Alabama 1075 26 0
200631 2020-06-03 Lauderdale Alabama 1077 170 2
200632 2020-06-03 Lawrence Alabama 1079 52 0
200633 2020-06-03 Lee Alabama 1081 573 34
200634 2020-06-03 Limestone Alabama 1083 110 0
200635 2020-06-03 Lowndes Alabama 1085 261 12
200636 2020-06-03 Macon Alabama 1087 88 4
200637 2020-06-03 Madison Alabama 1089 367 4
200638 2020-06-03 Marengo Alabama 1091 175 6
200639 2020-06-03 Marion Alabama 1093 128 11
200640 2020-06-03 Marshall Alabama 1095 709 9
200641 2020-06-03 Mobile Alabama 1097 2293 118
200642 2020-06-03 Monroe Alabama 1099 45 2
200643 2020-06-03 Montgomery Alabama 1101 1845 44
200644 2020-06-03 Morgan Alabama 1103 303 1
200645 2020-06-03 Perry Alabama 1105 42 0
200646 2020-06-03 Pickens Alabama 1107 121 5
200647 2020-06-03 Pike Alabama 1109 209 0
200648 2020-06-03 Randolph Alabama 1111 131 7
200649 2020-06-03 Russell Alabama 1113 179 0
200650 2020-06-03 Shelby Alabama 1117 541 20
200651 2020-06-03 St. Clair Alabama 1115 138 1
200652 2020-06-03 Sumter Alabama 1119 229 7
200653 2020-06-03 Talladega Alabama 1121 122 5
200654 2020-06-03 Tallapoosa Alabama 1123 437 66
200655 2020-06-03 Tuscaloosa Alabama 1125 831 16
200656 2020-06-03 Walker Alabama 1127 391 2
200657 2020-06-03 Washington Alabama 1129 74 6
200658 2020-06-03 Wilcox Alabama 1131 155 7
200659 2020-06-03 Winston Alabama 1133 92 0
200660 2020-06-03 Anchorage Alaska 2020 258 4
200661 2020-06-03 Bethel Census Area Alaska 2050 3 0
200662 2020-06-03 Bristol Bay Borough Alaska 2060 1 0
200663 2020-06-03 Dillingham Census Area Alaska 2070 1 0
200664 2020-06-03 Fairbanks North Star Borough Alaska 2090 85 2
200665 2020-06-03 Juneau City and Borough Alaska 2110 33 0
200666 2020-06-03 Kenai Peninsula Borough Alaska 2122 63 1
200667 2020-06-03 Ketchikan Gateway Borough Alaska 2130 16 0
200668 2020-06-03 Kodiak Island Borough Alaska 2150 1 0
200669 2020-06-03 Matanuska-Susitna Borough Alaska 2170 34 1
200670 2020-06-03 Nome Census Area Alaska 2180 3 0
200671 2020-06-03 North Slope Borough Alaska 2185 1 0
200672 2020-06-03 Northwest Arctic Borough Alaska 2188 2 0
200673 2020-06-03 Petersburg Borough Alaska 2195 3 0
200674 2020-06-03 Prince of Wales-Hyder Census Area Alaska 2198 2 0
200675 2020-06-03 Sitka City and Borough Alaska 2220 2 0
200676 2020-06-03 Southeast Fairbanks Census Area Alaska 2240 3 0
200677 2020-06-03 Unknown Alaska   1 0
200678 2020-06-03 Valdez-Cordova Census Area Alaska 2261 3 0
200679 2020-06-03 Yukon-Koyukuk Census Area Alaska 2290 1 0
200680 2020-06-03 Apache Arizona 4001 1586 45
200681 2020-06-03 Cochise Arizona 4003 94 5
200682 2020-06-03 Coconino Arizona 4005 1186 85
200683 2020-06-03 Gila Arizona 4007 37 2
200684 2020-06-03 Graham Arizona 4009 41 2
200685 2020-06-03 Greenlee Arizona 4011 8 1
200686 2020-06-03 La Paz Arizona 4012 91 2
200687 2020-06-03 Maricopa Arizona 4013 11068 466
200688 2020-06-03 Mohave Arizona 4015 422 47
200689 2020-06-03 Navajo Arizona 4017 1994 67
200690 2020-06-03 Pima Arizona 4019 2627 196
200691 2020-06-03 Pinal Arizona 4021 940 39
200692 2020-06-03 Santa Cruz Arizona 4023 460 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1878.096ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette