ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Jackson" and fips = 19097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054349 | 1054349 | 2021-02-22 | Jackson | Iowa | 19097 | 2075 | 38 |
1051102 | 1051102 | 2021-02-21 | Jackson | Iowa | 19097 | 2075 | 37 |
1047855 | 1047855 | 2021-02-20 | Jackson | Iowa | 19097 | 2075 | 37 |
1044610 | 1044610 | 2021-02-19 | Jackson | Iowa | 19097 | 2075 | 37 |
1041365 | 1041365 | 2021-02-18 | Jackson | Iowa | 19097 | 2074 | 37 |
1038120 | 1038120 | 2021-02-17 | Jackson | Iowa | 19097 | 2074 | 37 |
1034875 | 1034875 | 2021-02-16 | Jackson | Iowa | 19097 | 2073 | 37 |
1031629 | 1031629 | 2021-02-15 | Jackson | Iowa | 19097 | 2068 | 37 |
1028382 | 1028382 | 2021-02-14 | Jackson | Iowa | 19097 | 2059 | 37 |
1025137 | 1025137 | 2021-02-13 | Jackson | Iowa | 19097 | 2058 | 37 |
1021892 | 1021892 | 2021-02-12 | Jackson | Iowa | 19097 | 2054 | 37 |
1018647 | 1018647 | 2021-02-11 | Jackson | Iowa | 19097 | 2045 | 37 |
1015402 | 1015402 | 2021-02-10 | Jackson | Iowa | 19097 | 2043 | 37 |
1012157 | 1012157 | 2021-02-09 | Jackson | Iowa | 19097 | 2037 | 37 |
1008911 | 1008911 | 2021-02-08 | Jackson | Iowa | 19097 | 2028 | 37 |
1005665 | 1005665 | 2021-02-07 | Jackson | Iowa | 19097 | 2026 | 37 |
1002419 | 1002419 | 2021-02-06 | Jackson | Iowa | 19097 | 2026 | 37 |
999173 | 999173 | 2021-02-05 | Jackson | Iowa | 19097 | 2023 | 37 |
995927 | 995927 | 2021-02-04 | Jackson | Iowa | 19097 | 2018 | 37 |
992681 | 992681 | 2021-02-03 | Jackson | Iowa | 19097 | 2011 | 36 |
989435 | 989435 | 2021-02-02 | Jackson | Iowa | 19097 | 2000 | 35 |
986188 | 986188 | 2021-02-01 | Jackson | Iowa | 19097 | 1993 | 35 |
982941 | 982941 | 2021-01-31 | Jackson | Iowa | 19097 | 1993 | 35 |
979695 | 979695 | 2021-01-30 | Jackson | Iowa | 19097 | 1992 | 34 |
976449 | 976449 | 2021-01-29 | Jackson | Iowa | 19097 | 1983 | 32 |
973204 | 973204 | 2021-01-28 | Jackson | Iowa | 19097 | 1976 | 32 |
969959 | 969959 | 2021-01-27 | Jackson | Iowa | 19097 | 1969 | 32 |
966715 | 966715 | 2021-01-26 | Jackson | Iowa | 19097 | 1965 | 32 |
963470 | 963470 | 2021-01-25 | Jackson | Iowa | 19097 | 1953 | 32 |
960225 | 960225 | 2021-01-24 | Jackson | Iowa | 19097 | 1950 | 32 |
956979 | 956979 | 2021-01-23 | Jackson | Iowa | 19097 | 1949 | 32 |
953734 | 953734 | 2021-01-22 | Jackson | Iowa | 19097 | 1943 | 31 |
950489 | 950489 | 2021-01-21 | Jackson | Iowa | 19097 | 1939 | 31 |
947243 | 947243 | 2021-01-20 | Jackson | Iowa | 19097 | 1930 | 31 |
943996 | 943996 | 2021-01-19 | Jackson | Iowa | 19097 | 1920 | 31 |
940751 | 940751 | 2021-01-18 | Jackson | Iowa | 19097 | 1914 | 31 |
937506 | 937506 | 2021-01-17 | Jackson | Iowa | 19097 | 1911 | 31 |
934261 | 934261 | 2021-01-16 | Jackson | Iowa | 19097 | 1908 | 31 |
931016 | 931016 | 2021-01-15 | Jackson | Iowa | 19097 | 1905 | 31 |
927771 | 927771 | 2021-01-14 | Jackson | Iowa | 19097 | 1896 | 31 |
924525 | 924525 | 2021-01-13 | Jackson | Iowa | 19097 | 1888 | 31 |
921280 | 921280 | 2021-01-12 | Jackson | Iowa | 19097 | 1879 | 31 |
918035 | 918035 | 2021-01-11 | Jackson | Iowa | 19097 | 1863 | 31 |
914790 | 914790 | 2021-01-10 | Jackson | Iowa | 19097 | 1856 | 31 |
911545 | 911545 | 2021-01-09 | Jackson | Iowa | 19097 | 1853 | 31 |
908300 | 908300 | 2021-01-08 | Jackson | Iowa | 19097 | 1842 | 31 |
905054 | 905054 | 2021-01-07 | Jackson | Iowa | 19097 | 1833 | 30 |
901809 | 901809 | 2021-01-06 | Jackson | Iowa | 19097 | 1820 | 30 |
898564 | 898564 | 2021-01-05 | Jackson | Iowa | 19097 | 1811 | 29 |
895319 | 895319 | 2021-01-04 | Jackson | Iowa | 19097 | 1791 | 29 |
892072 | 892072 | 2021-01-03 | Jackson | Iowa | 19097 | 1788 | 29 |
888826 | 888826 | 2021-01-02 | Jackson | Iowa | 19097 | 1788 | 29 |
885580 | 885580 | 2021-01-01 | Jackson | Iowa | 19097 | 1785 | 29 |
882335 | 882335 | 2020-12-31 | Jackson | Iowa | 19097 | 1779 | 29 |
879090 | 879090 | 2020-12-30 | Jackson | Iowa | 19097 | 1768 | 29 |
875845 | 875845 | 2020-12-29 | Jackson | Iowa | 19097 | 1760 | 29 |
872600 | 872600 | 2020-12-28 | Jackson | Iowa | 19097 | 1752 | 29 |
869355 | 869355 | 2020-12-27 | Jackson | Iowa | 19097 | 1752 | 29 |
866110 | 866110 | 2020-12-26 | Jackson | Iowa | 19097 | 1752 | 29 |
862865 | 862865 | 2020-12-25 | Jackson | Iowa | 19097 | 1751 | 29 |
859620 | 859620 | 2020-12-24 | Jackson | Iowa | 19097 | 1744 | 29 |
856375 | 856375 | 2020-12-23 | Jackson | Iowa | 19097 | 1735 | 29 |
853130 | 853130 | 2020-12-22 | Jackson | Iowa | 19097 | 1725 | 29 |
849885 | 849885 | 2020-12-21 | Jackson | Iowa | 19097 | 1719 | 29 |
846640 | 846640 | 2020-12-20 | Jackson | Iowa | 19097 | 1719 | 29 |
843394 | 843394 | 2020-12-19 | Jackson | Iowa | 19097 | 1715 | 29 |
840149 | 840149 | 2020-12-18 | Jackson | Iowa | 19097 | 1706 | 25 |
836904 | 836904 | 2020-12-17 | Jackson | Iowa | 19097 | 1697 | 25 |
833658 | 833658 | 2020-12-16 | Jackson | Iowa | 19097 | 1692 | 23 |
830411 | 830411 | 2020-12-15 | Jackson | Iowa | 19097 | 1685 | 23 |
827165 | 827165 | 2020-12-14 | Jackson | Iowa | 19097 | 1673 | 23 |
823918 | 823918 | 2020-12-13 | Jackson | Iowa | 19097 | 1670 | 23 |
820672 | 820672 | 2020-12-12 | Jackson | Iowa | 19097 | 1662 | 23 |
817426 | 817426 | 2020-12-11 | Jackson | Iowa | 19097 | 1609 | 23 |
814180 | 814180 | 2020-12-10 | Jackson | Iowa | 19097 | 1595 | 23 |
810935 | 810935 | 2020-12-09 | Jackson | Iowa | 19097 | 1579 | 21 |
807690 | 807690 | 2020-12-08 | Jackson | Iowa | 19097 | 1555 | 18 |
804445 | 804445 | 2020-12-07 | Jackson | Iowa | 19097 | 1554 | 17 |
801200 | 801200 | 2020-12-06 | Jackson | Iowa | 19097 | 1548 | 17 |
797955 | 797955 | 2020-12-05 | Jackson | Iowa | 19097 | 1541 | 17 |
794710 | 794710 | 2020-12-04 | Jackson | Iowa | 19097 | 1527 | 17 |
791465 | 791465 | 2020-12-03 | Jackson | Iowa | 19097 | 1511 | 17 |
788220 | 788220 | 2020-12-02 | Jackson | Iowa | 19097 | 1488 | 14 |
784976 | 784976 | 2020-12-01 | Jackson | Iowa | 19097 | 1474 | 13 |
781731 | 781731 | 2020-11-30 | Jackson | Iowa | 19097 | 1465 | 13 |
778485 | 778485 | 2020-11-29 | Jackson | Iowa | 19097 | 1446 | 13 |
775240 | 775240 | 2020-11-28 | Jackson | Iowa | 19097 | 1443 | 13 |
771995 | 771995 | 2020-11-27 | Jackson | Iowa | 19097 | 1430 | 13 |
768750 | 768750 | 2020-11-26 | Jackson | Iowa | 19097 | 1421 | 13 |
765504 | 765504 | 2020-11-25 | Jackson | Iowa | 19097 | 1407 | 12 |
762259 | 762259 | 2020-11-24 | Jackson | Iowa | 19097 | 1385 | 11 |
759014 | 759014 | 2020-11-23 | Jackson | Iowa | 19097 | 1375 | 8 |
755767 | 755767 | 2020-11-22 | Jackson | Iowa | 19097 | 1360 | 8 |
752521 | 752521 | 2020-11-21 | Jackson | Iowa | 19097 | 1333 | 8 |
749275 | 749275 | 2020-11-20 | Jackson | Iowa | 19097 | 1308 | 8 |
746029 | 746029 | 2020-11-19 | Jackson | Iowa | 19097 | 1284 | 8 |
742782 | 742782 | 2020-11-18 | Jackson | Iowa | 19097 | 1270 | 8 |
739535 | 739535 | 2020-11-17 | Jackson | Iowa | 19097 | 1244 | 7 |
736291 | 736291 | 2020-11-16 | Jackson | Iowa | 19097 | 1216 | 6 |
733045 | 733045 | 2020-11-15 | Jackson | Iowa | 19097 | 1212 | 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);