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 |
---|---|---|---|---|---|---|---|
534782 | 534782 | 2020-09-15 | Madison | Florida | 12079 | 989 | 16 |
534906 | 534906 | 2020-09-15 | Madison | Georgia | 13195 | 631 | 8 |
535009 | 535009 | 2020-09-15 | Madison | Idaho | 16065 | 403 | 1 |
535077 | 535077 | 2020-09-15 | Madison | Illinois | 17119 | 5020 | 122 |
535171 | 535171 | 2020-09-15 | Madison | Indiana | 18095 | 1519 | 86 |
535276 | 535276 | 2020-09-15 | Madison | Iowa | 19121 | 186 | 2 |
535493 | 535493 | 2020-09-15 | Madison | Kentucky | 21151 | 1438 | 4 |
535573 | 535573 | 2020-09-15 | Madison | Louisiana | 22065 | 856 | 8 |
535878 | 535878 | 2020-09-15 | Madison | Mississippi | 28089 | 3146 | 85 |
535978 | 535978 | 2020-09-15 | Madison | Missouri | 29123 | 247 | 0 |
536059 | 536059 | 2020-09-15 | Madison | Montana | 30057 | 97 | 1 |
536142 | 536142 | 2020-09-15 | Madison | Nebraska | 31119 | 753 | 7 |
536285 | 536285 | 2020-09-15 | Madison | New York | 36053 | 480 | 9 |
536375 | 536375 | 2020-09-15 | Madison | North Carolina | 37115 | 87 | 1 |
536524 | 536524 | 2020-09-15 | Madison | Ohio | 39097 | 750 | 12 |
536995 | 536995 | 2020-09-15 | Madison | Tennessee | 47113 | 2467 | 54 |
537187 | 537187 | 2020-09-15 | Madison | Texas | 48313 | 717 | 6 |
537410 | 537410 | 2020-09-15 | Madison | Virginia | 51113 | 99 | 3 |
531233 | 531233 | 2020-09-14 | Madison | Alabama | 1089 | 7216 | 72 |
531341 | 531341 | 2020-09-14 | Madison | Arkansas | 5087 | 319 | 2 |
531547 | 531547 | 2020-09-14 | Madison | Florida | 12079 | 989 | 16 |
531671 | 531671 | 2020-09-14 | Madison | Georgia | 13195 | 619 | 8 |
531774 | 531774 | 2020-09-14 | Madison | Idaho | 16065 | 361 | 1 |
531842 | 531842 | 2020-09-14 | Madison | Illinois | 17119 | 4965 | 121 |
531936 | 531936 | 2020-09-14 | Madison | Indiana | 18095 | 1513 | 85 |
532041 | 532041 | 2020-09-14 | Madison | Iowa | 19121 | 184 | 2 |
532258 | 532258 | 2020-09-14 | Madison | Kentucky | 21151 | 1406 | 4 |
532338 | 532338 | 2020-09-14 | Madison | Louisiana | 22065 | 854 | 8 |
532643 | 532643 | 2020-09-14 | Madison | Mississippi | 28089 | 3136 | 85 |
532743 | 532743 | 2020-09-14 | Madison | Missouri | 29123 | 242 | 0 |
532824 | 532824 | 2020-09-14 | Madison | Montana | 30057 | 97 | 1 |
532907 | 532907 | 2020-09-14 | Madison | Nebraska | 31119 | 732 | 7 |
533049 | 533049 | 2020-09-14 | Madison | New York | 36053 | 478 | 9 |
533139 | 533139 | 2020-09-14 | Madison | North Carolina | 37115 | 85 | 1 |
533288 | 533288 | 2020-09-14 | Madison | Ohio | 39097 | 748 | 11 |
533759 | 533759 | 2020-09-14 | Madison | Tennessee | 47113 | 2390 | 54 |
533951 | 533951 | 2020-09-14 | Madison | Texas | 48313 | 709 | 5 |
534174 | 534174 | 2020-09-14 | Madison | Virginia | 51113 | 98 | 2 |
527996 | 527996 | 2020-09-13 | Madison | Alabama | 1089 | 7175 | 72 |
528104 | 528104 | 2020-09-13 | Madison | Arkansas | 5087 | 319 | 2 |
528310 | 528310 | 2020-09-13 | Madison | Florida | 12079 | 988 | 16 |
528434 | 528434 | 2020-09-13 | Madison | Georgia | 13195 | 616 | 8 |
528537 | 528537 | 2020-09-13 | Madison | Idaho | 16065 | 343 | 1 |
528605 | 528605 | 2020-09-13 | Madison | Illinois | 17119 | 4908 | 119 |
528699 | 528699 | 2020-09-13 | Madison | Indiana | 18095 | 1503 | 85 |
528804 | 528804 | 2020-09-13 | Madison | Iowa | 19121 | 184 | 2 |
529021 | 529021 | 2020-09-13 | Madison | Kentucky | 21151 | 1398 | 4 |
529101 | 529101 | 2020-09-13 | Madison | Louisiana | 22065 | 848 | 8 |
529407 | 529407 | 2020-09-13 | Madison | Mississippi | 28089 | 3134 | 84 |
529507 | 529507 | 2020-09-13 | Madison | Missouri | 29123 | 238 | 0 |
529588 | 529588 | 2020-09-13 | Madison | Montana | 30057 | 96 | 1 |
529671 | 529671 | 2020-09-13 | Madison | Nebraska | 31119 | 732 | 7 |
529814 | 529814 | 2020-09-13 | Madison | New York | 36053 | 478 | 9 |
529904 | 529904 | 2020-09-13 | Madison | North Carolina | 37115 | 84 | 1 |
530053 | 530053 | 2020-09-13 | Madison | Ohio | 39097 | 747 | 11 |
530524 | 530524 | 2020-09-13 | Madison | Tennessee | 47113 | 2301 | 54 |
530716 | 530716 | 2020-09-13 | Madison | Texas | 48313 | 709 | 5 |
530939 | 530939 | 2020-09-13 | Madison | Virginia | 51113 | 96 | 2 |
524760 | 524760 | 2020-09-12 | Madison | Alabama | 1089 | 7111 | 72 |
524868 | 524868 | 2020-09-12 | Madison | Arkansas | 5087 | 319 | 2 |
525074 | 525074 | 2020-09-12 | Madison | Florida | 12079 | 981 | 16 |
525198 | 525198 | 2020-09-12 | Madison | Georgia | 13195 | 613 | 8 |
525301 | 525301 | 2020-09-12 | Madison | Idaho | 16065 | 332 | 1 |
525369 | 525369 | 2020-09-12 | Madison | Illinois | 17119 | 4872 | 118 |
525463 | 525463 | 2020-09-12 | Madison | Indiana | 18095 | 1489 | 85 |
525568 | 525568 | 2020-09-12 | Madison | Iowa | 19121 | 183 | 2 |
525785 | 525785 | 2020-09-12 | Madison | Kentucky | 21151 | 1388 | 4 |
525865 | 525865 | 2020-09-12 | Madison | Louisiana | 22065 | 848 | 8 |
526171 | 526171 | 2020-09-12 | Madison | Mississippi | 28089 | 3123 | 84 |
526271 | 526271 | 2020-09-12 | Madison | Missouri | 29123 | 238 | 0 |
526352 | 526352 | 2020-09-12 | Madison | Montana | 30057 | 96 | 1 |
526435 | 526435 | 2020-09-12 | Madison | Nebraska | 31119 | 732 | 7 |
526577 | 526577 | 2020-09-12 | Madison | New York | 36053 | 478 | 9 |
526667 | 526667 | 2020-09-12 | Madison | North Carolina | 37115 | 83 | 1 |
526816 | 526816 | 2020-09-12 | Madison | Ohio | 39097 | 747 | 11 |
527287 | 527287 | 2020-09-12 | Madison | Tennessee | 47113 | 2272 | 54 |
527479 | 527479 | 2020-09-12 | Madison | Texas | 48313 | 709 | 5 |
527702 | 527702 | 2020-09-12 | Madison | Virginia | 51113 | 96 | 2 |
521524 | 521524 | 2020-09-11 | Madison | Alabama | 1089 | 7057 | 71 |
521632 | 521632 | 2020-09-11 | Madison | Arkansas | 5087 | 313 | 2 |
521838 | 521838 | 2020-09-11 | Madison | Florida | 12079 | 974 | 16 |
521962 | 521962 | 2020-09-11 | Madison | Georgia | 13195 | 604 | 8 |
522065 | 522065 | 2020-09-11 | Madison | Idaho | 16065 | 331 | 1 |
522133 | 522133 | 2020-09-11 | Madison | Illinois | 17119 | 4780 | 117 |
522227 | 522227 | 2020-09-11 | Madison | Indiana | 18095 | 1473 | 85 |
522332 | 522332 | 2020-09-11 | Madison | Iowa | 19121 | 179 | 2 |
522549 | 522549 | 2020-09-11 | Madison | Kentucky | 21151 | 1363 | 4 |
522629 | 522629 | 2020-09-11 | Madison | Louisiana | 22065 | 848 | 8 |
522935 | 522935 | 2020-09-11 | Madison | Mississippi | 28089 | 3115 | 84 |
523035 | 523035 | 2020-09-11 | Madison | Missouri | 29123 | 229 | 0 |
523116 | 523116 | 2020-09-11 | Madison | Montana | 30057 | 96 | 1 |
523199 | 523199 | 2020-09-11 | Madison | Nebraska | 31119 | 732 | 7 |
523341 | 523341 | 2020-09-11 | Madison | New York | 36053 | 476 | 9 |
523431 | 523431 | 2020-09-11 | Madison | North Carolina | 37115 | 82 | 1 |
523580 | 523580 | 2020-09-11 | Madison | Ohio | 39097 | 744 | 11 |
524051 | 524051 | 2020-09-11 | Madison | Tennessee | 47113 | 2227 | 52 |
524243 | 524243 | 2020-09-11 | Madison | Texas | 48313 | 702 | 5 |
524466 | 524466 | 2020-09-11 | Madison | Virginia | 51113 | 95 | 2 |
518287 | 518287 | 2020-09-10 | Madison | Alabama | 1089 | 6965 | 66 |
518395 | 518395 | 2020-09-10 | Madison | Arkansas | 5087 | 310 | 2 |
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);