ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15,570 rows where county = "Madison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1176915 | 1176915 | 2021-04-01 | Madison | Alabama | 1089 | 33577 | 489 |
1177024 | 1177024 | 2021-04-01 | Madison | Arkansas | 5087 | 1437 | 22 |
1177231 | 1177231 | 2021-04-01 | Madison | Florida | 12079 | 2034 | 44 |
1177355 | 1177355 | 2021-04-01 | Madison | Georgia | 13195 | 3166 | 54 |
1177459 | 1177459 | 2021-04-01 | Madison | Idaho | 16065 | 6890 | 23 |
1177527 | 1177527 | 2021-04-01 | Madison | Illinois | 17119 | 29259 | 578 |
1177621 | 1177621 | 2021-04-01 | Madison | Indiana | 18095 | 12114 | 353 |
1177726 | 1177726 | 2021-04-01 | Madison | Iowa | 19121 | 1506 | 19 |
1177944 | 1177944 | 2021-04-01 | Madison | Kentucky | 21151 | 9021 | 107 |
1178024 | 1178024 | 2021-04-01 | Madison | Louisiana | 22065 | 1560 | 37 |
1178330 | 1178330 | 2021-04-01 | Madison | Mississippi | 28089 | 9826 | 208 |
1178430 | 1178430 | 2021-04-01 | Madison | Missouri | 29123 | 1614 | 16 |
1178512 | 1178512 | 2021-04-01 | Madison | Montana | 30057 | 726 | 8 |
1178599 | 1178599 | 2021-04-01 | Madison | Nebraska | 31119 | 4137 | 42 |
1178741 | 1178741 | 2021-04-01 | Madison | New York | 36053 | 4116 | 85 |
1178831 | 1178831 | 2021-04-01 | Madison | North Carolina | 37115 | 1457 | 40 |
1178979 | 1178979 | 2021-04-01 | Madison | Ohio | 39097 | 4082 | 57 |
1179452 | 1179452 | 2021-04-01 | Madison | Tennessee | 47113 | 10508 | 238 |
1179647 | 1179647 | 2021-04-01 | Madison | Texas | 48313 | 1925 | 28 |
1179870 | 1179870 | 2021-04-01 | Madison | Virginia | 51113 | 563 | 15 |
1173668 | 1173668 | 2021-03-31 | Madison | Alabama | 1089 | 33533 | 489 |
1173777 | 1173777 | 2021-03-31 | Madison | Arkansas | 5087 | 1436 | 22 |
1173984 | 1173984 | 2021-03-31 | Madison | Florida | 12079 | 2032 | 44 |
1174108 | 1174108 | 2021-03-31 | Madison | Georgia | 13195 | 3163 | 54 |
1174212 | 1174212 | 2021-03-31 | Madison | Idaho | 16065 | 6867 | 23 |
1174280 | 1174280 | 2021-03-31 | Madison | Illinois | 17119 | 29202 | 575 |
1174374 | 1174374 | 2021-03-31 | Madison | Indiana | 18095 | 12096 | 353 |
1174479 | 1174479 | 2021-03-31 | Madison | Iowa | 19121 | 1505 | 19 |
1174697 | 1174697 | 2021-03-31 | Madison | Kentucky | 21151 | 9003 | 107 |
1174777 | 1174777 | 2021-03-31 | Madison | Louisiana | 22065 | 1562 | 37 |
1175083 | 1175083 | 2021-03-31 | Madison | Mississippi | 28089 | 9816 | 208 |
1175183 | 1175183 | 2021-03-31 | Madison | Missouri | 29123 | 1614 | 16 |
1175265 | 1175265 | 2021-03-31 | Madison | Montana | 30057 | 727 | 8 |
1175352 | 1175352 | 2021-03-31 | Madison | Nebraska | 31119 | 4127 | 42 |
1175494 | 1175494 | 2021-03-31 | Madison | New York | 36053 | 4105 | 85 |
1175584 | 1175584 | 2021-03-31 | Madison | North Carolina | 37115 | 1457 | 40 |
1175732 | 1175732 | 2021-03-31 | Madison | Ohio | 39097 | 4076 | 57 |
1176205 | 1176205 | 2021-03-31 | Madison | Tennessee | 47113 | 10482 | 238 |
1176400 | 1176400 | 2021-03-31 | Madison | Texas | 48313 | 1925 | 28 |
1176623 | 1176623 | 2021-03-31 | Madison | Virginia | 51113 | 563 | 15 |
1170421 | 1170421 | 2021-03-30 | Madison | Alabama | 1089 | 33508 | 488 |
1170530 | 1170530 | 2021-03-30 | Madison | Arkansas | 5087 | 1436 | 22 |
1170737 | 1170737 | 2021-03-30 | Madison | Florida | 12079 | 2031 | 44 |
1170861 | 1170861 | 2021-03-30 | Madison | Georgia | 13195 | 3161 | 54 |
1170965 | 1170965 | 2021-03-30 | Madison | Idaho | 16065 | 6840 | 23 |
1171033 | 1171033 | 2021-03-30 | Madison | Illinois | 17119 | 29168 | 575 |
1171127 | 1171127 | 2021-03-30 | Madison | Indiana | 18095 | 12088 | 353 |
1171232 | 1171232 | 2021-03-30 | Madison | Iowa | 19121 | 1503 | 19 |
1171450 | 1171450 | 2021-03-30 | Madison | Kentucky | 21151 | 8994 | 107 |
1171530 | 1171530 | 2021-03-30 | Madison | Louisiana | 22065 | 1561 | 37 |
1171836 | 1171836 | 2021-03-30 | Madison | Mississippi | 28089 | 9805 | 208 |
1171936 | 1171936 | 2021-03-30 | Madison | Missouri | 29123 | 1614 | 16 |
1172018 | 1172018 | 2021-03-30 | Madison | Montana | 30057 | 725 | 8 |
1172105 | 1172105 | 2021-03-30 | Madison | Nebraska | 31119 | 4126 | 42 |
1172247 | 1172247 | 2021-03-30 | Madison | New York | 36053 | 4094 | 85 |
1172337 | 1172337 | 2021-03-30 | Madison | North Carolina | 37115 | 1455 | 40 |
1172485 | 1172485 | 2021-03-30 | Madison | Ohio | 39097 | 4071 | 57 |
1172958 | 1172958 | 2021-03-30 | Madison | Tennessee | 47113 | 10438 | 238 |
1173153 | 1173153 | 2021-03-30 | Madison | Texas | 48313 | 1922 | 28 |
1173376 | 1173376 | 2021-03-30 | Madison | Virginia | 51113 | 560 | 15 |
1167173 | 1167173 | 2021-03-29 | Madison | Alabama | 1089 | 33480 | 488 |
1167282 | 1167282 | 2021-03-29 | Madison | Arkansas | 5087 | 1435 | 22 |
1167489 | 1167489 | 2021-03-29 | Madison | Florida | 12079 | 2031 | 44 |
1167613 | 1167613 | 2021-03-29 | Madison | Georgia | 13195 | 3159 | 54 |
1167717 | 1167717 | 2021-03-29 | Madison | Idaho | 16065 | 6825 | 23 |
1167785 | 1167785 | 2021-03-29 | Madison | Illinois | 17119 | 29129 | 575 |
1167879 | 1167879 | 2021-03-29 | Madison | Indiana | 18095 | 12066 | 353 |
1167984 | 1167984 | 2021-03-29 | Madison | Iowa | 19121 | 1502 | 19 |
1168202 | 1168202 | 2021-03-29 | Madison | Kentucky | 21151 | 8984 | 107 |
1168282 | 1168282 | 2021-03-29 | Madison | Louisiana | 22065 | 1562 | 37 |
1168588 | 1168588 | 2021-03-29 | Madison | Mississippi | 28089 | 9803 | 207 |
1168688 | 1168688 | 2021-03-29 | Madison | Missouri | 29123 | 1614 | 16 |
1168770 | 1168770 | 2021-03-29 | Madison | Montana | 30057 | 723 | 8 |
1168857 | 1168857 | 2021-03-29 | Madison | Nebraska | 31119 | 4125 | 42 |
1169000 | 1169000 | 2021-03-29 | Madison | New York | 36053 | 4086 | 85 |
1169090 | 1169090 | 2021-03-29 | Madison | North Carolina | 37115 | 1450 | 40 |
1169238 | 1169238 | 2021-03-29 | Madison | Ohio | 39097 | 4064 | 57 |
1169711 | 1169711 | 2021-03-29 | Madison | Tennessee | 47113 | 10406 | 238 |
1169906 | 1169906 | 2021-03-29 | Madison | Texas | 48313 | 1924 | 28 |
1170129 | 1170129 | 2021-03-29 | Madison | Virginia | 51113 | 560 | 15 |
1163925 | 1163925 | 2021-03-28 | Madison | Alabama | 1089 | 33463 | 488 |
1164034 | 1164034 | 2021-03-28 | Madison | Arkansas | 5087 | 1435 | 22 |
1164241 | 1164241 | 2021-03-28 | Madison | Florida | 12079 | 2030 | 43 |
1164365 | 1164365 | 2021-03-28 | Madison | Georgia | 13195 | 3157 | 54 |
1164469 | 1164469 | 2021-03-28 | Madison | Idaho | 16065 | 6806 | 23 |
1164537 | 1164537 | 2021-03-28 | Madison | Illinois | 17119 | 29099 | 575 |
1164631 | 1164631 | 2021-03-28 | Madison | Indiana | 18095 | 12051 | 353 |
1164736 | 1164736 | 2021-03-28 | Madison | Iowa | 19121 | 1500 | 19 |
1164954 | 1164954 | 2021-03-28 | Madison | Kentucky | 21151 | 8975 | 107 |
1165034 | 1165034 | 2021-03-28 | Madison | Louisiana | 22065 | 1560 | 37 |
1165340 | 1165340 | 2021-03-28 | Madison | Mississippi | 28089 | 9799 | 207 |
1165440 | 1165440 | 2021-03-28 | Madison | Missouri | 29123 | 1614 | 16 |
1165522 | 1165522 | 2021-03-28 | Madison | Montana | 30057 | 725 | 8 |
1165609 | 1165609 | 2021-03-28 | Madison | Nebraska | 31119 | 4437 | 44 |
1165752 | 1165752 | 2021-03-28 | Madison | New York | 36053 | 4081 | 85 |
1165842 | 1165842 | 2021-03-28 | Madison | North Carolina | 37115 | 1441 | 40 |
1165990 | 1165990 | 2021-03-28 | Madison | Ohio | 39097 | 4062 | 57 |
1166463 | 1166463 | 2021-03-28 | Madison | Tennessee | 47113 | 10384 | 237 |
1166658 | 1166658 | 2021-03-28 | Madison | Texas | 48313 | 1919 | 28 |
1166881 | 1166881 | 2021-03-28 | Madison | Virginia | 51113 | 559 | 15 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);