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 |
---|---|---|---|---|---|---|---|
635245 | 635245 | 2020-10-16 | Madison | Florida | 12079 | 1052 | 24 |
635369 | 635369 | 2020-10-16 | Madison | Georgia | 13195 | 813 | 11 |
635472 | 635472 | 2020-10-16 | Madison | Idaho | 16065 | 1903 | 2 |
635540 | 635540 | 2020-10-16 | Madison | Illinois | 17119 | 6714 | 152 |
635634 | 635634 | 2020-10-16 | Madison | Indiana | 18095 | 2175 | 97 |
635739 | 635739 | 2020-10-16 | Madison | Iowa | 19121 | 333 | 2 |
635957 | 635957 | 2020-10-16 | Madison | Kentucky | 21151 | 2116 | 11 |
636037 | 636037 | 2020-10-16 | Madison | Louisiana | 22065 | 889 | 8 |
636343 | 636343 | 2020-10-16 | Madison | Mississippi | 28089 | 3683 | 92 |
636443 | 636443 | 2020-10-16 | Madison | Missouri | 29123 | 415 | 2 |
636525 | 636525 | 2020-10-16 | Madison | Montana | 30057 | 127 | 1 |
636612 | 636612 | 2020-10-16 | Madison | Nebraska | 31119 | 1105 | 8 |
636754 | 636754 | 2020-10-16 | Madison | New York | 36053 | 528 | 9 |
636844 | 636844 | 2020-10-16 | Madison | North Carolina | 37115 | 135 | 1 |
636992 | 636992 | 2020-10-16 | Madison | Ohio | 39097 | 1000 | 14 |
637464 | 637464 | 2020-10-16 | Madison | Tennessee | 47113 | 3495 | 78 |
637657 | 637657 | 2020-10-16 | Madison | Texas | 48313 | 741 | 6 |
637880 | 637880 | 2020-10-16 | Madison | Virginia | 51113 | 122 | 3 |
631684 | 631684 | 2020-10-15 | Madison | Alabama | 1089 | 8742 | 88 |
631792 | 631792 | 2020-10-15 | Madison | Arkansas | 5087 | 408 | 6 |
631999 | 631999 | 2020-10-15 | Madison | Florida | 12079 | 1049 | 24 |
632123 | 632123 | 2020-10-15 | Madison | Georgia | 13195 | 808 | 11 |
632226 | 632226 | 2020-10-15 | Madison | Idaho | 16065 | 1810 | 2 |
632294 | 632294 | 2020-10-15 | Madison | Illinois | 17119 | 6618 | 151 |
632388 | 632388 | 2020-10-15 | Madison | Indiana | 18095 | 2128 | 95 |
632493 | 632493 | 2020-10-15 | Madison | Iowa | 19121 | 329 | 2 |
632711 | 632711 | 2020-10-15 | Madison | Kentucky | 21151 | 2105 | 9 |
632791 | 632791 | 2020-10-15 | Madison | Louisiana | 22065 | 891 | 8 |
633097 | 633097 | 2020-10-15 | Madison | Mississippi | 28089 | 3623 | 92 |
633197 | 633197 | 2020-10-15 | Madison | Missouri | 29123 | 406 | 2 |
633279 | 633279 | 2020-10-15 | Madison | Montana | 30057 | 127 | 1 |
633366 | 633366 | 2020-10-15 | Madison | Nebraska | 31119 | 1105 | 8 |
633508 | 633508 | 2020-10-15 | Madison | New York | 36053 | 521 | 9 |
633598 | 633598 | 2020-10-15 | Madison | North Carolina | 37115 | 134 | 1 |
633746 | 633746 | 2020-10-15 | Madison | Ohio | 39097 | 996 | 14 |
634218 | 634218 | 2020-10-15 | Madison | Tennessee | 47113 | 3468 | 78 |
634412 | 634412 | 2020-10-15 | Madison | Texas | 48313 | 736 | 6 |
634635 | 634635 | 2020-10-15 | Madison | Virginia | 51113 | 118 | 3 |
628440 | 628440 | 2020-10-14 | Madison | Alabama | 1089 | 8678 | 83 |
628548 | 628548 | 2020-10-14 | Madison | Arkansas | 5087 | 404 | 6 |
628755 | 628755 | 2020-10-14 | Madison | Florida | 12079 | 1047 | 24 |
628879 | 628879 | 2020-10-14 | Madison | Georgia | 13195 | 806 | 11 |
628982 | 628982 | 2020-10-14 | Madison | Idaho | 16065 | 1759 | 2 |
629050 | 629050 | 2020-10-14 | Madison | Illinois | 17119 | 6562 | 150 |
629144 | 629144 | 2020-10-14 | Madison | Indiana | 18095 | 2101 | 95 |
629249 | 629249 | 2020-10-14 | Madison | Iowa | 19121 | 321 | 2 |
629467 | 629467 | 2020-10-14 | Madison | Kentucky | 21151 | 2091 | 9 |
629547 | 629547 | 2020-10-14 | Madison | Louisiana | 22065 | 891 | 8 |
629852 | 629852 | 2020-10-14 | Madison | Mississippi | 28089 | 3552 | 92 |
629952 | 629952 | 2020-10-14 | Madison | Missouri | 29123 | 398 | 1 |
630034 | 630034 | 2020-10-14 | Madison | Montana | 30057 | 126 | 1 |
630121 | 630121 | 2020-10-14 | Madison | Nebraska | 31119 | 1105 | 7 |
630263 | 630263 | 2020-10-14 | Madison | New York | 36053 | 517 | 9 |
630353 | 630353 | 2020-10-14 | Madison | North Carolina | 37115 | 131 | 1 |
630501 | 630501 | 2020-10-14 | Madison | Ohio | 39097 | 981 | 14 |
630973 | 630973 | 2020-10-14 | Madison | Tennessee | 47113 | 3432 | 76 |
631167 | 631167 | 2020-10-14 | Madison | Texas | 48313 | 739 | 6 |
631390 | 631390 | 2020-10-14 | Madison | Virginia | 51113 | 117 | 3 |
625197 | 625197 | 2020-10-13 | Madison | Alabama | 1089 | 8646 | 83 |
625305 | 625305 | 2020-10-13 | Madison | Arkansas | 5087 | 399 | 6 |
625512 | 625512 | 2020-10-13 | Madison | Florida | 12079 | 1043 | 24 |
625636 | 625636 | 2020-10-13 | Madison | Georgia | 13195 | 802 | 10 |
625739 | 625739 | 2020-10-13 | Madison | Idaho | 16065 | 1724 | 2 |
625807 | 625807 | 2020-10-13 | Madison | Illinois | 17119 | 6491 | 149 |
625901 | 625901 | 2020-10-13 | Madison | Indiana | 18095 | 2084 | 95 |
626006 | 626006 | 2020-10-13 | Madison | Iowa | 19121 | 317 | 2 |
626223 | 626223 | 2020-10-13 | Madison | Kentucky | 21151 | 2069 | 9 |
626303 | 626303 | 2020-10-13 | Madison | Louisiana | 22065 | 889 | 8 |
626608 | 626608 | 2020-10-13 | Madison | Mississippi | 28089 | 3526 | 92 |
626708 | 626708 | 2020-10-13 | Madison | Missouri | 29123 | 367 | 1 |
626790 | 626790 | 2020-10-13 | Madison | Montana | 30057 | 126 | 1 |
626877 | 626877 | 2020-10-13 | Madison | Nebraska | 31119 | 1022 | 7 |
627019 | 627019 | 2020-10-13 | Madison | New York | 36053 | 515 | 9 |
627109 | 627109 | 2020-10-13 | Madison | North Carolina | 37115 | 130 | 1 |
627257 | 627257 | 2020-10-13 | Madison | Ohio | 39097 | 970 | 14 |
627729 | 627729 | 2020-10-13 | Madison | Tennessee | 47113 | 3415 | 76 |
627923 | 627923 | 2020-10-13 | Madison | Texas | 48313 | 737 | 6 |
628146 | 628146 | 2020-10-13 | Madison | Virginia | 51113 | 117 | 3 |
621954 | 621954 | 2020-10-12 | Madison | Alabama | 1089 | 8605 | 83 |
622062 | 622062 | 2020-10-12 | Madison | Arkansas | 5087 | 394 | 5 |
622269 | 622269 | 2020-10-12 | Madison | Florida | 12079 | 1042 | 24 |
622393 | 622393 | 2020-10-12 | Madison | Georgia | 13195 | 801 | 10 |
622496 | 622496 | 2020-10-12 | Madison | Idaho | 16065 | 1638 | 2 |
622565 | 622565 | 2020-10-12 | Madison | Illinois | 17119 | 6436 | 148 |
622659 | 622659 | 2020-10-12 | Madison | Indiana | 18095 | 2067 | 93 |
622764 | 622764 | 2020-10-12 | Madison | Iowa | 19121 | 312 | 2 |
622981 | 622981 | 2020-10-12 | Madison | Kentucky | 21151 | 2037 | 7 |
623061 | 623061 | 2020-10-12 | Madison | Louisiana | 22065 | 889 | 8 |
623366 | 623366 | 2020-10-12 | Madison | Mississippi | 28089 | 3511 | 92 |
623466 | 623466 | 2020-10-12 | Madison | Missouri | 29123 | 367 | 1 |
623548 | 623548 | 2020-10-12 | Madison | Montana | 30057 | 126 | 1 |
623635 | 623635 | 2020-10-12 | Madison | Nebraska | 31119 | 1022 | 7 |
623777 | 623777 | 2020-10-12 | Madison | New York | 36053 | 511 | 9 |
623867 | 623867 | 2020-10-12 | Madison | North Carolina | 37115 | 130 | 1 |
624015 | 624015 | 2020-10-12 | Madison | Ohio | 39097 | 970 | 14 |
624487 | 624487 | 2020-10-12 | Madison | Tennessee | 47113 | 3396 | 76 |
624680 | 624680 | 2020-10-12 | Madison | Texas | 48313 | 735 | 6 |
624903 | 624903 | 2020-10-12 | Madison | Virginia | 51113 | 117 | 3 |
618711 | 618711 | 2020-10-11 | Madison | Alabama | 1089 | 8557 | 83 |
618819 | 618819 | 2020-10-11 | Madison | Arkansas | 5087 | 394 | 5 |
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);