ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 18079 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054248 | 1054248 | 2021-02-22 | Jennings | Indiana | 18079 | 2137 | 46 |
1051001 | 1051001 | 2021-02-21 | Jennings | Indiana | 18079 | 2135 | 46 |
1047754 | 1047754 | 2021-02-20 | Jennings | Indiana | 18079 | 2131 | 46 |
1044509 | 1044509 | 2021-02-19 | Jennings | Indiana | 18079 | 2127 | 46 |
1041264 | 1041264 | 2021-02-18 | Jennings | Indiana | 18079 | 2125 | 46 |
1038019 | 1038019 | 2021-02-17 | Jennings | Indiana | 18079 | 2123 | 46 |
1034774 | 1034774 | 2021-02-16 | Jennings | Indiana | 18079 | 2121 | 46 |
1031528 | 1031528 | 2021-02-15 | Jennings | Indiana | 18079 | 2119 | 45 |
1028281 | 1028281 | 2021-02-14 | Jennings | Indiana | 18079 | 2118 | 45 |
1025036 | 1025036 | 2021-02-13 | Jennings | Indiana | 18079 | 2112 | 45 |
1021791 | 1021791 | 2021-02-12 | Jennings | Indiana | 18079 | 2109 | 45 |
1018546 | 1018546 | 2021-02-11 | Jennings | Indiana | 18079 | 2105 | 45 |
1015301 | 1015301 | 2021-02-10 | Jennings | Indiana | 18079 | 2100 | 45 |
1012056 | 1012056 | 2021-02-09 | Jennings | Indiana | 18079 | 2096 | 45 |
1008810 | 1008810 | 2021-02-08 | Jennings | Indiana | 18079 | 2095 | 45 |
1005564 | 1005564 | 2021-02-07 | Jennings | Indiana | 18079 | 2087 | 44 |
1002318 | 1002318 | 2021-02-06 | Jennings | Indiana | 18079 | 2081 | 44 |
999072 | 999072 | 2021-02-05 | Jennings | Indiana | 18079 | 2076 | 44 |
995826 | 995826 | 2021-02-04 | Jennings | Indiana | 18079 | 2067 | 44 |
992580 | 992580 | 2021-02-03 | Jennings | Indiana | 18079 | 2064 | 40 |
989334 | 989334 | 2021-02-02 | Jennings | Indiana | 18079 | 2062 | 40 |
986087 | 986087 | 2021-02-01 | Jennings | Indiana | 18079 | 2057 | 40 |
982840 | 982840 | 2021-01-31 | Jennings | Indiana | 18079 | 2048 | 40 |
979594 | 979594 | 2021-01-30 | Jennings | Indiana | 18079 | 2044 | 40 |
976348 | 976348 | 2021-01-29 | Jennings | Indiana | 18079 | 2040 | 40 |
973103 | 973103 | 2021-01-28 | Jennings | Indiana | 18079 | 2029 | 40 |
969858 | 969858 | 2021-01-27 | Jennings | Indiana | 18079 | 2018 | 39 |
966614 | 966614 | 2021-01-26 | Jennings | Indiana | 18079 | 2013 | 39 |
963369 | 963369 | 2021-01-25 | Jennings | Indiana | 18079 | 2010 | 38 |
960124 | 960124 | 2021-01-24 | Jennings | Indiana | 18079 | 1997 | 38 |
956878 | 956878 | 2021-01-23 | Jennings | Indiana | 18079 | 1993 | 38 |
953633 | 953633 | 2021-01-22 | Jennings | Indiana | 18079 | 1981 | 38 |
950388 | 950388 | 2021-01-21 | Jennings | Indiana | 18079 | 1962 | 38 |
947142 | 947142 | 2021-01-20 | Jennings | Indiana | 18079 | 1957 | 37 |
943895 | 943895 | 2021-01-19 | Jennings | Indiana | 18079 | 1943 | 37 |
940650 | 940650 | 2021-01-18 | Jennings | Indiana | 18079 | 1936 | 37 |
937405 | 937405 | 2021-01-17 | Jennings | Indiana | 18079 | 1929 | 37 |
934160 | 934160 | 2021-01-16 | Jennings | Indiana | 18079 | 1917 | 37 |
930915 | 930915 | 2021-01-15 | Jennings | Indiana | 18079 | 1910 | 37 |
927670 | 927670 | 2021-01-14 | Jennings | Indiana | 18079 | 1890 | 37 |
924424 | 924424 | 2021-01-13 | Jennings | Indiana | 18079 | 1875 | 37 |
921179 | 921179 | 2021-01-12 | Jennings | Indiana | 18079 | 1865 | 37 |
917934 | 917934 | 2021-01-11 | Jennings | Indiana | 18079 | 1859 | 36 |
914689 | 914689 | 2021-01-10 | Jennings | Indiana | 18079 | 1840 | 36 |
911444 | 911444 | 2021-01-09 | Jennings | Indiana | 18079 | 1823 | 36 |
908199 | 908199 | 2021-01-08 | Jennings | Indiana | 18079 | 1800 | 36 |
904953 | 904953 | 2021-01-07 | Jennings | Indiana | 18079 | 1779 | 36 |
901708 | 901708 | 2021-01-06 | Jennings | Indiana | 18079 | 1755 | 36 |
898463 | 898463 | 2021-01-05 | Jennings | Indiana | 18079 | 1746 | 36 |
895218 | 895218 | 2021-01-04 | Jennings | Indiana | 18079 | 1741 | 35 |
891971 | 891971 | 2021-01-03 | Jennings | Indiana | 18079 | 1729 | 35 |
888725 | 888725 | 2021-01-02 | Jennings | Indiana | 18079 | 1726 | 35 |
885479 | 885479 | 2021-01-01 | Jennings | Indiana | 18079 | 1712 | 34 |
882234 | 882234 | 2020-12-31 | Jennings | Indiana | 18079 | 1700 | 34 |
878989 | 878989 | 2020-12-30 | Jennings | Indiana | 18079 | 1683 | 32 |
875744 | 875744 | 2020-12-29 | Jennings | Indiana | 18079 | 1680 | 31 |
872499 | 872499 | 2020-12-28 | Jennings | Indiana | 18079 | 1671 | 30 |
869254 | 869254 | 2020-12-27 | Jennings | Indiana | 18079 | 1665 | 30 |
866009 | 866009 | 2020-12-26 | Jennings | Indiana | 18079 | 1662 | 30 |
862764 | 862764 | 2020-12-25 | Jennings | Indiana | 18079 | 1647 | 30 |
859519 | 859519 | 2020-12-24 | Jennings | Indiana | 18079 | 1635 | 30 |
856274 | 856274 | 2020-12-23 | Jennings | Indiana | 18079 | 1613 | 30 |
853029 | 853029 | 2020-12-22 | Jennings | Indiana | 18079 | 1591 | 30 |
849784 | 849784 | 2020-12-21 | Jennings | Indiana | 18079 | 1581 | 29 |
846539 | 846539 | 2020-12-20 | Jennings | Indiana | 18079 | 1564 | 29 |
843293 | 843293 | 2020-12-19 | Jennings | Indiana | 18079 | 1534 | 29 |
840048 | 840048 | 2020-12-18 | Jennings | Indiana | 18079 | 1517 | 27 |
836803 | 836803 | 2020-12-17 | Jennings | Indiana | 18079 | 1494 | 27 |
833557 | 833557 | 2020-12-16 | Jennings | Indiana | 18079 | 1459 | 27 |
830310 | 830310 | 2020-12-15 | Jennings | Indiana | 18079 | 1431 | 26 |
827064 | 827064 | 2020-12-14 | Jennings | Indiana | 18079 | 1421 | 25 |
823817 | 823817 | 2020-12-13 | Jennings | Indiana | 18079 | 1399 | 25 |
820571 | 820571 | 2020-12-12 | Jennings | Indiana | 18079 | 1377 | 25 |
817325 | 817325 | 2020-12-11 | Jennings | Indiana | 18079 | 1341 | 25 |
814079 | 814079 | 2020-12-10 | Jennings | Indiana | 18079 | 1300 | 25 |
810834 | 810834 | 2020-12-09 | Jennings | Indiana | 18079 | 1248 | 24 |
807589 | 807589 | 2020-12-08 | Jennings | Indiana | 18079 | 1217 | 20 |
804344 | 804344 | 2020-12-07 | Jennings | Indiana | 18079 | 1199 | 20 |
801099 | 801099 | 2020-12-06 | Jennings | Indiana | 18079 | 1180 | 20 |
797854 | 797854 | 2020-12-05 | Jennings | Indiana | 18079 | 1141 | 20 |
794609 | 794609 | 2020-12-04 | Jennings | Indiana | 18079 | 1100 | 19 |
791364 | 791364 | 2020-12-03 | Jennings | Indiana | 18079 | 1067 | 17 |
788119 | 788119 | 2020-12-02 | Jennings | Indiana | 18079 | 1028 | 17 |
784875 | 784875 | 2020-12-01 | Jennings | Indiana | 18079 | 1008 | 17 |
781630 | 781630 | 2020-11-30 | Jennings | Indiana | 18079 | 991 | 16 |
778384 | 778384 | 2020-11-29 | Jennings | Indiana | 18079 | 982 | 16 |
775139 | 775139 | 2020-11-28 | Jennings | Indiana | 18079 | 936 | 16 |
771894 | 771894 | 2020-11-27 | Jennings | Indiana | 18079 | 908 | 16 |
768649 | 768649 | 2020-11-26 | Jennings | Indiana | 18079 | 891 | 16 |
765403 | 765403 | 2020-11-25 | Jennings | Indiana | 18079 | 857 | 16 |
762158 | 762158 | 2020-11-24 | Jennings | Indiana | 18079 | 836 | 16 |
758913 | 758913 | 2020-11-23 | Jennings | Indiana | 18079 | 810 | 16 |
755666 | 755666 | 2020-11-22 | Jennings | Indiana | 18079 | 795 | 16 |
752420 | 752420 | 2020-11-21 | Jennings | Indiana | 18079 | 779 | 16 |
749174 | 749174 | 2020-11-20 | Jennings | Indiana | 18079 | 762 | 16 |
745928 | 745928 | 2020-11-19 | Jennings | Indiana | 18079 | 750 | 15 |
742681 | 742681 | 2020-11-18 | Jennings | Indiana | 18079 | 717 | 15 |
739434 | 739434 | 2020-11-17 | Jennings | Indiana | 18079 | 689 | 15 |
736190 | 736190 | 2020-11-16 | Jennings | Indiana | 18079 | 683 | 15 |
732944 | 732944 | 2020-11-15 | Jennings | Indiana | 18079 | 652 | 15 |
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);