ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Madison" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063603 | 1063603 | 2021-02-25 | Madison | Florida | 12079 | 1980 | 42 |
1060358 | 1060358 | 2021-02-24 | Madison | Florida | 12079 | 1978 | 40 |
1057112 | 1057112 | 2021-02-23 | Madison | Florida | 12079 | 1969 | 40 |
1053866 | 1053866 | 2021-02-22 | Madison | Florida | 12079 | 1968 | 40 |
1050619 | 1050619 | 2021-02-21 | Madison | Florida | 12079 | 1963 | 40 |
1047372 | 1047372 | 2021-02-20 | Madison | Florida | 12079 | 1956 | 39 |
1044127 | 1044127 | 2021-02-19 | Madison | Florida | 12079 | 1950 | 39 |
1040882 | 1040882 | 2021-02-18 | Madison | Florida | 12079 | 1944 | 39 |
1037637 | 1037637 | 2021-02-17 | Madison | Florida | 12079 | 1938 | 39 |
1034392 | 1034392 | 2021-02-16 | Madison | Florida | 12079 | 1927 | 39 |
1031146 | 1031146 | 2021-02-15 | Madison | Florida | 12079 | 1923 | 39 |
1027899 | 1027899 | 2021-02-14 | Madison | Florida | 12079 | 1923 | 39 |
1024654 | 1024654 | 2021-02-13 | Madison | Florida | 12079 | 1912 | 39 |
1021409 | 1021409 | 2021-02-12 | Madison | Florida | 12079 | 1909 | 39 |
1018164 | 1018164 | 2021-02-11 | Madison | Florida | 12079 | 1901 | 39 |
1014919 | 1014919 | 2021-02-10 | Madison | Florida | 12079 | 1894 | 39 |
1011674 | 1011674 | 2021-02-09 | Madison | Florida | 12079 | 1885 | 39 |
1008428 | 1008428 | 2021-02-08 | Madison | Florida | 12079 | 1881 | 39 |
1005182 | 1005182 | 2021-02-07 | Madison | Florida | 12079 | 1881 | 39 |
1001936 | 1001936 | 2021-02-06 | Madison | Florida | 12079 | 1873 | 38 |
998690 | 998690 | 2021-02-05 | Madison | Florida | 12079 | 1864 | 37 |
995444 | 995444 | 2021-02-04 | Madison | Florida | 12079 | 1860 | 37 |
992198 | 992198 | 2021-02-03 | Madison | Florida | 12079 | 1851 | 37 |
988952 | 988952 | 2021-02-02 | Madison | Florida | 12079 | 1842 | 37 |
985705 | 985705 | 2021-02-01 | Madison | Florida | 12079 | 1836 | 37 |
982458 | 982458 | 2021-01-31 | Madison | Florida | 12079 | 1834 | 37 |
979212 | 979212 | 2021-01-30 | Madison | Florida | 12079 | 1829 | 37 |
975967 | 975967 | 2021-01-29 | Madison | Florida | 12079 | 1821 | 37 |
972722 | 972722 | 2021-01-28 | Madison | Florida | 12079 | 1807 | 37 |
969477 | 969477 | 2021-01-27 | Madison | Florida | 12079 | 1798 | 37 |
966233 | 966233 | 2021-01-26 | Madison | Florida | 12079 | 1791 | 37 |
962988 | 962988 | 2021-01-25 | Madison | Florida | 12079 | 1786 | 37 |
959743 | 959743 | 2021-01-24 | Madison | Florida | 12079 | 1784 | 37 |
956497 | 956497 | 2021-01-23 | Madison | Florida | 12079 | 1770 | 36 |
953252 | 953252 | 2021-01-22 | Madison | Florida | 12079 | 1756 | 36 |
950007 | 950007 | 2021-01-21 | Madison | Florida | 12079 | 1749 | 36 |
946761 | 946761 | 2021-01-20 | Madison | Florida | 12079 | 1729 | 36 |
943514 | 943514 | 2021-01-19 | Madison | Florida | 12079 | 1715 | 35 |
940269 | 940269 | 2021-01-18 | Madison | Florida | 12079 | 1712 | 35 |
937024 | 937024 | 2021-01-17 | Madison | Florida | 12079 | 1708 | 34 |
933779 | 933779 | 2021-01-16 | Madison | Florida | 12079 | 1697 | 34 |
930534 | 930534 | 2021-01-15 | Madison | Florida | 12079 | 1684 | 34 |
927289 | 927289 | 2021-01-14 | Madison | Florida | 12079 | 1667 | 34 |
924043 | 924043 | 2021-01-13 | Madison | Florida | 12079 | 1662 | 34 |
920798 | 920798 | 2021-01-12 | Madison | Florida | 12079 | 1654 | 34 |
917553 | 917553 | 2021-01-11 | Madison | Florida | 12079 | 1650 | 34 |
914308 | 914308 | 2021-01-10 | Madison | Florida | 12079 | 1647 | 34 |
911063 | 911063 | 2021-01-09 | Madison | Florida | 12079 | 1639 | 34 |
907818 | 907818 | 2021-01-08 | Madison | Florida | 12079 | 1624 | 33 |
904572 | 904572 | 2021-01-07 | Madison | Florida | 12079 | 1604 | 33 |
901327 | 901327 | 2021-01-06 | Madison | Florida | 12079 | 1597 | 33 |
898082 | 898082 | 2021-01-05 | Madison | Florida | 12079 | 1588 | 33 |
894837 | 894837 | 2021-01-04 | Madison | Florida | 12079 | 1577 | 33 |
891590 | 891590 | 2021-01-03 | Madison | Florida | 12079 | 1574 | 33 |
888343 | 888343 | 2021-01-02 | Madison | Florida | 12079 | 1573 | 33 |
885098 | 885098 | 2021-01-01 | Madison | Florida | 12079 | 1540 | 33 |
881853 | 881853 | 2020-12-31 | Madison | Florida | 12079 | 1540 | 33 |
878608 | 878608 | 2020-12-30 | Madison | Florida | 12079 | 1532 | 33 |
875363 | 875363 | 2020-12-29 | Madison | Florida | 12079 | 1522 | 33 |
872118 | 872118 | 2020-12-28 | Madison | Florida | 12079 | 1516 | 33 |
868873 | 868873 | 2020-12-27 | Madison | Florida | 12079 | 1514 | 33 |
865628 | 865628 | 2020-12-26 | Madison | Florida | 12079 | 1509 | 33 |
862383 | 862383 | 2020-12-25 | Madison | Florida | 12079 | 1495 | 33 |
859138 | 859138 | 2020-12-24 | Madison | Florida | 12079 | 1495 | 33 |
855893 | 855893 | 2020-12-23 | Madison | Florida | 12079 | 1483 | 33 |
852648 | 852648 | 2020-12-22 | Madison | Florida | 12079 | 1471 | 32 |
849403 | 849403 | 2020-12-21 | Madison | Florida | 12079 | 1469 | 32 |
846158 | 846158 | 2020-12-20 | Madison | Florida | 12079 | 1465 | 32 |
842912 | 842912 | 2020-12-19 | Madison | Florida | 12079 | 1463 | 32 |
839667 | 839667 | 2020-12-18 | Madison | Florida | 12079 | 1455 | 30 |
836422 | 836422 | 2020-12-17 | Madison | Florida | 12079 | 1448 | 30 |
833176 | 833176 | 2020-12-16 | Madison | Florida | 12079 | 1428 | 30 |
829929 | 829929 | 2020-12-15 | Madison | Florida | 12079 | 1418 | 30 |
826683 | 826683 | 2020-12-14 | Madison | Florida | 12079 | 1413 | 30 |
823436 | 823436 | 2020-12-13 | Madison | Florida | 12079 | 1408 | 30 |
820190 | 820190 | 2020-12-12 | Madison | Florida | 12079 | 1401 | 29 |
816944 | 816944 | 2020-12-11 | Madison | Florida | 12079 | 1392 | 28 |
813698 | 813698 | 2020-12-10 | Madison | Florida | 12079 | 1378 | 28 |
810454 | 810454 | 2020-12-09 | Madison | Florida | 12079 | 1365 | 28 |
807209 | 807209 | 2020-12-08 | Madison | Florida | 12079 | 1342 | 28 |
803964 | 803964 | 2020-12-07 | Madison | Florida | 12079 | 1332 | 27 |
800719 | 800719 | 2020-12-06 | Madison | Florida | 12079 | 1324 | 27 |
797474 | 797474 | 2020-12-05 | Madison | Florida | 12079 | 1319 | 27 |
794229 | 794229 | 2020-12-04 | Madison | Florida | 12079 | 1308 | 27 |
790984 | 790984 | 2020-12-03 | Madison | Florida | 12079 | 1296 | 27 |
787739 | 787739 | 2020-12-02 | Madison | Florida | 12079 | 1276 | 27 |
784495 | 784495 | 2020-12-01 | Madison | Florida | 12079 | 1271 | 27 |
781250 | 781250 | 2020-11-30 | Madison | Florida | 12079 | 1267 | 27 |
778004 | 778004 | 2020-11-29 | Madison | Florida | 12079 | 1267 | 27 |
774759 | 774759 | 2020-11-28 | Madison | Florida | 12079 | 1258 | 27 |
771514 | 771514 | 2020-11-27 | Madison | Florida | 12079 | 1254 | 27 |
768269 | 768269 | 2020-11-26 | Madison | Florida | 12079 | 1231 | 26 |
765023 | 765023 | 2020-11-25 | Madison | Florida | 12079 | 1231 | 26 |
761778 | 761778 | 2020-11-24 | Madison | Florida | 12079 | 1228 | 26 |
758533 | 758533 | 2020-11-23 | Madison | Florida | 12079 | 1226 | 26 |
755286 | 755286 | 2020-11-22 | Madison | Florida | 12079 | 1226 | 26 |
752040 | 752040 | 2020-11-21 | Madison | Florida | 12079 | 1221 | 25 |
748794 | 748794 | 2020-11-20 | Madison | Florida | 12079 | 1210 | 25 |
745548 | 745548 | 2020-11-19 | Madison | Florida | 12079 | 1201 | 25 |
742301 | 742301 | 2020-11-18 | Madison | Florida | 12079 | 1193 | 25 |
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);