ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Kossuth" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054355 | 1054355 | 2021-02-22 | Kossuth | Iowa | 19109 | 1941 | 54 |
1051108 | 1051108 | 2021-02-21 | Kossuth | Iowa | 19109 | 1941 | 54 |
1047861 | 1047861 | 2021-02-20 | Kossuth | Iowa | 19109 | 1941 | 54 |
1044616 | 1044616 | 2021-02-19 | Kossuth | Iowa | 19109 | 1941 | 54 |
1041371 | 1041371 | 2021-02-18 | Kossuth | Iowa | 19109 | 1940 | 54 |
1038126 | 1038126 | 2021-02-17 | Kossuth | Iowa | 19109 | 1937 | 54 |
1034881 | 1034881 | 2021-02-16 | Kossuth | Iowa | 19109 | 1932 | 54 |
1031635 | 1031635 | 2021-02-15 | Kossuth | Iowa | 19109 | 1930 | 52 |
1028388 | 1028388 | 2021-02-14 | Kossuth | Iowa | 19109 | 1925 | 52 |
1025143 | 1025143 | 2021-02-13 | Kossuth | Iowa | 19109 | 1922 | 52 |
1021898 | 1021898 | 2021-02-12 | Kossuth | Iowa | 19109 | 1921 | 52 |
1018653 | 1018653 | 2021-02-11 | Kossuth | Iowa | 19109 | 1915 | 52 |
1015408 | 1015408 | 2021-02-10 | Kossuth | Iowa | 19109 | 1908 | 52 |
1012163 | 1012163 | 2021-02-09 | Kossuth | Iowa | 19109 | 1906 | 52 |
1008917 | 1008917 | 2021-02-08 | Kossuth | Iowa | 19109 | 1904 | 52 |
1005671 | 1005671 | 2021-02-07 | Kossuth | Iowa | 19109 | 1899 | 52 |
1002425 | 1002425 | 2021-02-06 | Kossuth | Iowa | 19109 | 1897 | 52 |
999179 | 999179 | 2021-02-05 | Kossuth | Iowa | 19109 | 1893 | 51 |
995933 | 995933 | 2021-02-04 | Kossuth | Iowa | 19109 | 1892 | 51 |
992687 | 992687 | 2021-02-03 | Kossuth | Iowa | 19109 | 1889 | 51 |
989441 | 989441 | 2021-02-02 | Kossuth | Iowa | 19109 | 1880 | 49 |
986194 | 986194 | 2021-02-01 | Kossuth | Iowa | 19109 | 1861 | 49 |
982947 | 982947 | 2021-01-31 | Kossuth | Iowa | 19109 | 1854 | 49 |
979701 | 979701 | 2021-01-30 | Kossuth | Iowa | 19109 | 1854 | 45 |
976455 | 976455 | 2021-01-29 | Kossuth | Iowa | 19109 | 1845 | 45 |
973210 | 973210 | 2021-01-28 | Kossuth | Iowa | 19109 | 1838 | 44 |
969965 | 969965 | 2021-01-27 | Kossuth | Iowa | 19109 | 1822 | 44 |
966721 | 966721 | 2021-01-26 | Kossuth | Iowa | 19109 | 1822 | 44 |
963476 | 963476 | 2021-01-25 | Kossuth | Iowa | 19109 | 1809 | 44 |
960231 | 960231 | 2021-01-24 | Kossuth | Iowa | 19109 | 1806 | 44 |
956985 | 956985 | 2021-01-23 | Kossuth | Iowa | 19109 | 1785 | 44 |
953740 | 953740 | 2021-01-22 | Kossuth | Iowa | 19109 | 1785 | 44 |
950495 | 950495 | 2021-01-21 | Kossuth | Iowa | 19109 | 1777 | 44 |
947249 | 947249 | 2021-01-20 | Kossuth | Iowa | 19109 | 1748 | 44 |
944002 | 944002 | 2021-01-19 | Kossuth | Iowa | 19109 | 1736 | 44 |
940757 | 940757 | 2021-01-18 | Kossuth | Iowa | 19109 | 1721 | 43 |
937512 | 937512 | 2021-01-17 | Kossuth | Iowa | 19109 | 1714 | 43 |
934267 | 934267 | 2021-01-16 | Kossuth | Iowa | 19109 | 1704 | 43 |
931022 | 931022 | 2021-01-15 | Kossuth | Iowa | 19109 | 1701 | 41 |
927777 | 927777 | 2021-01-14 | Kossuth | Iowa | 19109 | 1692 | 41 |
924531 | 924531 | 2021-01-13 | Kossuth | Iowa | 19109 | 1683 | 41 |
921286 | 921286 | 2021-01-12 | Kossuth | Iowa | 19109 | 1661 | 41 |
918041 | 918041 | 2021-01-11 | Kossuth | Iowa | 19109 | 1652 | 35 |
914796 | 914796 | 2021-01-10 | Kossuth | Iowa | 19109 | 1636 | 35 |
911551 | 911551 | 2021-01-09 | Kossuth | Iowa | 19109 | 1629 | 35 |
908306 | 908306 | 2021-01-08 | Kossuth | Iowa | 19109 | 1619 | 35 |
905060 | 905060 | 2021-01-07 | Kossuth | Iowa | 19109 | 1607 | 35 |
901815 | 901815 | 2021-01-06 | Kossuth | Iowa | 19109 | 1584 | 35 |
898570 | 898570 | 2021-01-05 | Kossuth | Iowa | 19109 | 1575 | 32 |
895325 | 895325 | 2021-01-04 | Kossuth | Iowa | 19109 | 1572 | 32 |
892078 | 892078 | 2021-01-03 | Kossuth | Iowa | 19109 | 1566 | 32 |
888832 | 888832 | 2021-01-02 | Kossuth | Iowa | 19109 | 1566 | 32 |
885586 | 885586 | 2021-01-01 | Kossuth | Iowa | 19109 | 1559 | 32 |
882341 | 882341 | 2020-12-31 | Kossuth | Iowa | 19109 | 1555 | 32 |
879096 | 879096 | 2020-12-30 | Kossuth | Iowa | 19109 | 1550 | 29 |
875851 | 875851 | 2020-12-29 | Kossuth | Iowa | 19109 | 1535 | 29 |
872606 | 872606 | 2020-12-28 | Kossuth | Iowa | 19109 | 1479 | 28 |
869361 | 869361 | 2020-12-27 | Kossuth | Iowa | 19109 | 1474 | 28 |
866116 | 866116 | 2020-12-26 | Kossuth | Iowa | 19109 | 1472 | 28 |
862871 | 862871 | 2020-12-25 | Kossuth | Iowa | 19109 | 1470 | 28 |
859626 | 859626 | 2020-12-24 | Kossuth | Iowa | 19109 | 1468 | 27 |
856381 | 856381 | 2020-12-23 | Kossuth | Iowa | 19109 | 1465 | 26 |
853136 | 853136 | 2020-12-22 | Kossuth | Iowa | 19109 | 1457 | 26 |
849891 | 849891 | 2020-12-21 | Kossuth | Iowa | 19109 | 1447 | 25 |
846646 | 846646 | 2020-12-20 | Kossuth | Iowa | 19109 | 1440 | 25 |
843400 | 843400 | 2020-12-19 | Kossuth | Iowa | 19109 | 1437 | 25 |
840155 | 840155 | 2020-12-18 | Kossuth | Iowa | 19109 | 1423 | 24 |
836910 | 836910 | 2020-12-17 | Kossuth | Iowa | 19109 | 1410 | 24 |
833664 | 833664 | 2020-12-16 | Kossuth | Iowa | 19109 | 1402 | 23 |
830417 | 830417 | 2020-12-15 | Kossuth | Iowa | 19109 | 1383 | 23 |
827171 | 827171 | 2020-12-14 | Kossuth | Iowa | 19109 | 1369 | 23 |
823924 | 823924 | 2020-12-13 | Kossuth | Iowa | 19109 | 1361 | 22 |
820678 | 820678 | 2020-12-12 | Kossuth | Iowa | 19109 | 1357 | 22 |
817432 | 817432 | 2020-12-11 | Kossuth | Iowa | 19109 | 1351 | 22 |
814186 | 814186 | 2020-12-10 | Kossuth | Iowa | 19109 | 1332 | 21 |
810941 | 810941 | 2020-12-09 | Kossuth | Iowa | 19109 | 1326 | 21 |
807696 | 807696 | 2020-12-08 | Kossuth | Iowa | 19109 | 1246 | 20 |
804451 | 804451 | 2020-12-07 | Kossuth | Iowa | 19109 | 1245 | 9 |
801206 | 801206 | 2020-12-06 | Kossuth | Iowa | 19109 | 1230 | 9 |
797961 | 797961 | 2020-12-05 | Kossuth | Iowa | 19109 | 1213 | 9 |
794716 | 794716 | 2020-12-04 | Kossuth | Iowa | 19109 | 1200 | 9 |
791471 | 791471 | 2020-12-03 | Kossuth | Iowa | 19109 | 1175 | 8 |
788226 | 788226 | 2020-12-02 | Kossuth | Iowa | 19109 | 1160 | 8 |
784982 | 784982 | 2020-12-01 | Kossuth | Iowa | 19109 | 1102 | 7 |
781737 | 781737 | 2020-11-30 | Kossuth | Iowa | 19109 | 1084 | 7 |
778491 | 778491 | 2020-11-29 | Kossuth | Iowa | 19109 | 1066 | 7 |
775246 | 775246 | 2020-11-28 | Kossuth | Iowa | 19109 | 1057 | 6 |
772001 | 772001 | 2020-11-27 | Kossuth | Iowa | 19109 | 1042 | 6 |
768756 | 768756 | 2020-11-26 | Kossuth | Iowa | 19109 | 1023 | 6 |
765510 | 765510 | 2020-11-25 | Kossuth | Iowa | 19109 | 1007 | 6 |
762265 | 762265 | 2020-11-24 | Kossuth | Iowa | 19109 | 967 | 5 |
759020 | 759020 | 2020-11-23 | Kossuth | Iowa | 19109 | 946 | 4 |
755773 | 755773 | 2020-11-22 | Kossuth | Iowa | 19109 | 921 | 4 |
752527 | 752527 | 2020-11-21 | Kossuth | Iowa | 19109 | 919 | 4 |
749281 | 749281 | 2020-11-20 | Kossuth | Iowa | 19109 | 896 | 4 |
746035 | 746035 | 2020-11-19 | Kossuth | Iowa | 19109 | 878 | 3 |
742788 | 742788 | 2020-11-18 | Kossuth | Iowa | 19109 | 831 | 3 |
739541 | 739541 | 2020-11-17 | Kossuth | Iowa | 19109 | 803 | 3 |
736297 | 736297 | 2020-11-16 | Kossuth | Iowa | 19109 | 796 | 3 |
733051 | 733051 | 2020-11-15 | Kossuth | Iowa | 19109 | 778 | 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);