ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Jennings" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193851 | 1193851 | 2021-04-06 | Jennings | Indiana | 18079 | 2234 | 48 |
1190601 | 1190601 | 2021-04-05 | Jennings | Indiana | 18079 | 2233 | 48 |
1187354 | 1187354 | 2021-04-04 | Jennings | Indiana | 18079 | 2233 | 48 |
1184107 | 1184107 | 2021-04-03 | Jennings | Indiana | 18079 | 2232 | 48 |
1180860 | 1180860 | 2021-04-02 | Jennings | Indiana | 18079 | 2233 | 48 |
1177613 | 1177613 | 2021-04-01 | Jennings | Indiana | 18079 | 2232 | 48 |
1174366 | 1174366 | 2021-03-31 | Jennings | Indiana | 18079 | 2229 | 48 |
1171119 | 1171119 | 2021-03-30 | Jennings | Indiana | 18079 | 2226 | 48 |
1167871 | 1167871 | 2021-03-29 | Jennings | Indiana | 18079 | 2224 | 48 |
1164623 | 1164623 | 2021-03-28 | Jennings | Indiana | 18079 | 2223 | 48 |
1161375 | 1161375 | 2021-03-27 | Jennings | Indiana | 18079 | 2221 | 48 |
1158127 | 1158127 | 2021-03-26 | Jennings | Indiana | 18079 | 2219 | 48 |
1154880 | 1154880 | 2021-03-25 | Jennings | Indiana | 18079 | 2218 | 48 |
1151633 | 1151633 | 2021-03-24 | Jennings | Indiana | 18079 | 2214 | 48 |
1148386 | 1148386 | 2021-03-23 | Jennings | Indiana | 18079 | 2212 | 48 |
1145139 | 1145139 | 2021-03-22 | Jennings | Indiana | 18079 | 2211 | 48 |
1141892 | 1141892 | 2021-03-21 | Jennings | Indiana | 18079 | 2210 | 48 |
1138646 | 1138646 | 2021-03-20 | Jennings | Indiana | 18079 | 2209 | 47 |
1135400 | 1135400 | 2021-03-19 | Jennings | Indiana | 18079 | 2207 | 47 |
1132153 | 1132153 | 2021-03-18 | Jennings | Indiana | 18079 | 2205 | 47 |
1128905 | 1128905 | 2021-03-17 | Jennings | Indiana | 18079 | 2203 | 47 |
1125659 | 1125659 | 2021-03-16 | Jennings | Indiana | 18079 | 2202 | 47 |
1122413 | 1122413 | 2021-03-15 | Jennings | Indiana | 18079 | 2202 | 47 |
1119166 | 1119166 | 2021-03-14 | Jennings | Indiana | 18079 | 2200 | 47 |
1115919 | 1115919 | 2021-03-13 | Jennings | Indiana | 18079 | 2199 | 47 |
1112673 | 1112673 | 2021-03-12 | Jennings | Indiana | 18079 | 2196 | 47 |
1109427 | 1109427 | 2021-03-11 | Jennings | Indiana | 18079 | 2191 | 47 |
1106181 | 1106181 | 2021-03-10 | Jennings | Indiana | 18079 | 2184 | 47 |
1102935 | 1102935 | 2021-03-09 | Jennings | Indiana | 18079 | 2183 | 47 |
1099689 | 1099689 | 2021-03-08 | Jennings | Indiana | 18079 | 2174 | 46 |
1096441 | 1096441 | 2021-03-07 | Jennings | Indiana | 18079 | 2173 | 46 |
1093195 | 1093195 | 2021-03-06 | Jennings | Indiana | 18079 | 2171 | 46 |
1089949 | 1089949 | 2021-03-05 | Jennings | Indiana | 18079 | 2167 | 46 |
1086704 | 1086704 | 2021-03-04 | Jennings | Indiana | 18079 | 2167 | 46 |
1083458 | 1083458 | 2021-03-03 | Jennings | Indiana | 18079 | 2161 | 46 |
1080212 | 1080212 | 2021-03-02 | Jennings | Indiana | 18079 | 2157 | 46 |
1076967 | 1076967 | 2021-03-01 | Jennings | Indiana | 18079 | 2156 | 46 |
1073721 | 1073721 | 2021-02-28 | Jennings | Indiana | 18079 | 2154 | 46 |
1070475 | 1070475 | 2021-02-27 | Jennings | Indiana | 18079 | 2151 | 46 |
1067230 | 1067230 | 2021-02-26 | Jennings | Indiana | 18079 | 2147 | 46 |
1063985 | 1063985 | 2021-02-25 | Jennings | Indiana | 18079 | 2145 | 46 |
1060740 | 1060740 | 2021-02-24 | Jennings | Indiana | 18079 | 2144 | 46 |
1057494 | 1057494 | 2021-02-23 | Jennings | Indiana | 18079 | 2139 | 46 |
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 |
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);