ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where deaths = 127 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500291 | 2500291 | 2022-05-13 | Clinton | Indiana | 18023 | 9259 | 127 |
2497033 | 2497033 | 2022-05-12 | Clinton | Indiana | 18023 | 9247 | 127 |
2493775 | 2493775 | 2022-05-11 | Clinton | Indiana | 18023 | 9247 | 127 |
2490517 | 2490517 | 2022-05-10 | Clinton | Indiana | 18023 | 9245 | 127 |
2487260 | 2487260 | 2022-05-09 | Clinton | Indiana | 18023 | 9245 | 127 |
2360346 | 2360346 | 2022-03-31 | Putnam | Indiana | 18133 | 9308 | 127 |
2357092 | 2357092 | 2022-03-30 | Putnam | Indiana | 18133 | 9308 | 127 |
2353839 | 2353839 | 2022-03-29 | Putnam | Indiana | 18133 | 9323 | 127 |
2350587 | 2350587 | 2022-03-28 | Putnam | Indiana | 18133 | 9321 | 127 |
2347334 | 2347334 | 2022-03-27 | Putnam | Indiana | 18133 | 9318 | 127 |
2344081 | 2344081 | 2022-03-26 | Putnam | Indiana | 18133 | 9318 | 127 |
2340828 | 2340828 | 2022-03-25 | Putnam | Indiana | 18133 | 9318 | 127 |
2337575 | 2337575 | 2022-03-24 | Putnam | Indiana | 18133 | 9318 | 127 |
2308264 | 2308264 | 2022-03-15 | Jackson | Indiana | 18071 | 12500 | 127 |
2197738 | 2197738 | 2022-02-09 | Ripley | Indiana | 18137 | 8121 | 127 |
2194484 | 2194484 | 2022-02-08 | Ripley | Indiana | 18137 | 8121 | 127 |
2191251 | 2191251 | 2022-02-07 | Wells | Indiana | 18179 | 6416 | 127 |
2187998 | 2187998 | 2022-02-06 | Wells | Indiana | 18179 | 6397 | 127 |
2184745 | 2184745 | 2022-02-05 | Wells | Indiana | 18179 | 6397 | 127 |
2181493 | 2181493 | 2022-02-04 | Wells | Indiana | 18179 | 6397 | 127 |
2178242 | 2178242 | 2022-02-03 | Wells | Indiana | 18179 | 6382 | 127 |
2174989 | 2174989 | 2022-02-02 | Wells | Indiana | 18179 | 6359 | 127 |
2168430 | 2168430 | 2022-01-31 | Jasper | Indiana | 18073 | 8708 | 127 |
2152163 | 2152163 | 2022-01-26 | Knox | Indiana | 18083 | 9477 | 127 |
2148911 | 2148911 | 2022-01-25 | Knox | Indiana | 18083 | 9466 | 127 |
2129363 | 2129363 | 2022-01-19 | Decatur | Indiana | 18031 | 5949 | 127 |
2129367 | 2129367 | 2022-01-19 | Fayette | Indiana | 18041 | 5878 | 127 |
2129388 | 2129388 | 2022-01-19 | Knox | Indiana | 18083 | 8947 | 127 |
2126113 | 2126113 | 2022-01-18 | Fayette | Indiana | 18041 | 5830 | 127 |
2126134 | 2126134 | 2022-01-18 | Knox | Indiana | 18083 | 8844 | 127 |
2122861 | 2122861 | 2022-01-17 | Fayette | Indiana | 18041 | 5800 | 127 |
2122882 | 2122882 | 2022-01-17 | Knox | Indiana | 18083 | 8767 | 127 |
2119630 | 2119630 | 2022-01-16 | Knox | Indiana | 18083 | 8500 | 127 |
2116378 | 2116378 | 2022-01-15 | Knox | Indiana | 18083 | 8500 | 127 |
2113127 | 2113127 | 2022-01-14 | Knox | Indiana | 18083 | 8500 | 127 |
2109875 | 2109875 | 2022-01-13 | Knox | Indiana | 18083 | 8364 | 127 |
2106621 | 2106621 | 2022-01-12 | Jefferson | Indiana | 18077 | 7298 | 127 |
2106624 | 2106624 | 2022-01-12 | Knox | Indiana | 18083 | 8297 | 127 |
2103370 | 2103370 | 2022-01-11 | Jefferson | Indiana | 18077 | 7190 | 127 |
2100119 | 2100119 | 2022-01-10 | Jefferson | Indiana | 18077 | 7115 | 127 |
2096844 | 2096844 | 2022-01-09 | DeKalb | Indiana | 18033 | 9191 | 127 |
2093592 | 2093592 | 2022-01-08 | DeKalb | Indiana | 18033 | 9191 | 127 |
2090340 | 2090340 | 2022-01-07 | DeKalb | Indiana | 18033 | 9191 | 127 |
2087089 | 2087089 | 2022-01-06 | DeKalb | Indiana | 18033 | 9137 | 127 |
2080622 | 2080622 | 2022-01-04 | Miami | Indiana | 18103 | 7291 | 127 |
2028620 | 2028620 | 2021-12-19 | Montgomery | Indiana | 18107 | 7649 | 127 |
2025369 | 2025369 | 2021-12-18 | Montgomery | Indiana | 18107 | 7649 | 127 |
2022118 | 2022118 | 2021-12-17 | Montgomery | Indiana | 18107 | 7649 | 127 |
1992864 | 1992864 | 2021-12-08 | Noble | Indiana | 18113 | 9536 | 127 |
1989613 | 1989613 | 2021-12-07 | Noble | Indiana | 18113 | 9465 | 127 |
1986363 | 1986363 | 2021-12-06 | Noble | Indiana | 18113 | 9434 | 127 |
1963561 | 1963561 | 2021-11-29 | Boone | Indiana | 18011 | 9697 | 127 |
1960310 | 1960310 | 2021-11-28 | Boone | Indiana | 18011 | 9598 | 127 |
1957059 | 1957059 | 2021-11-27 | Boone | Indiana | 18011 | 9598 | 127 |
1953808 | 1953808 | 2021-11-26 | Boone | Indiana | 18011 | 9598 | 127 |
1950557 | 1950557 | 2021-11-25 | Boone | Indiana | 18011 | 9598 | 127 |
1947306 | 1947306 | 2021-11-24 | Boone | Indiana | 18011 | 9598 | 127 |
1944055 | 1944055 | 2021-11-23 | Boone | Indiana | 18011 | 9563 | 127 |
1940805 | 1940805 | 2021-11-22 | Boone | Indiana | 18011 | 9542 | 127 |
1937555 | 1937555 | 2021-11-21 | Boone | Indiana | 18011 | 9482 | 127 |
1934305 | 1934305 | 2021-11-20 | Boone | Indiana | 18011 | 9482 | 127 |
1931054 | 1931054 | 2021-11-19 | Boone | Indiana | 18011 | 9482 | 127 |
1927803 | 1927803 | 2021-11-18 | Boone | Indiana | 18011 | 9459 | 127 |
1921307 | 1921307 | 2021-11-16 | Cass | Indiana | 18017 | 7776 | 127 |
1918057 | 1918057 | 2021-11-15 | Cass | Indiana | 18017 | 7762 | 127 |
1914807 | 1914807 | 2021-11-14 | Cass | Indiana | 18017 | 7743 | 127 |
1911557 | 1911557 | 2021-11-13 | Cass | Indiana | 18017 | 7743 | 127 |
1908308 | 1908308 | 2021-11-12 | Cass | Indiana | 18017 | 7743 | 127 |
1905059 | 1905059 | 2021-11-11 | Cass | Indiana | 18017 | 7731 | 127 |
1901809 | 1901809 | 2021-11-10 | Cass | Indiana | 18017 | 7688 | 127 |
1898559 | 1898559 | 2021-11-09 | Cass | Indiana | 18017 | 7678 | 127 |
1895309 | 1895309 | 2021-11-08 | Cass | Indiana | 18017 | 7666 | 127 |
1892059 | 1892059 | 2021-11-07 | Cass | Indiana | 18017 | 7652 | 127 |
1888809 | 1888809 | 2021-11-06 | Cass | Indiana | 18017 | 7652 | 127 |
1885559 | 1885559 | 2021-11-05 | Cass | Indiana | 18017 | 7652 | 127 |
1882310 | 1882310 | 2021-11-04 | Cass | Indiana | 18017 | 7646 | 127 |
1791345 | 1791345 | 2021-10-07 | Dubois | Indiana | 18037 | 8062 | 127 |
1788096 | 1788096 | 2021-10-06 | Dubois | Indiana | 18037 | 8045 | 127 |
1784847 | 1784847 | 2021-10-05 | Dubois | Indiana | 18037 | 8031 | 127 |
1716629 | 1716629 | 2021-09-14 | Henry | Indiana | 18065 | 7374 | 127 |
1713383 | 1713383 | 2021-09-13 | Henry | Indiana | 18065 | 7330 | 127 |
1713400 | 1713400 | 2021-09-13 | Marshall | Indiana | 18099 | 7107 | 127 |
1710153 | 1710153 | 2021-09-12 | Marshall | Indiana | 18099 | 7054 | 127 |
1706906 | 1706906 | 2021-09-11 | Marshall | Indiana | 18099 | 7054 | 127 |
1703658 | 1703658 | 2021-09-10 | Marshall | Indiana | 18099 | 7054 | 127 |
1486039 | 1486039 | 2021-07-05 | Lawrence | Indiana | 18093 | 4785 | 127 |
1482793 | 1482793 | 2021-07-04 | Lawrence | Indiana | 18093 | 4785 | 127 |
1479546 | 1479546 | 2021-07-03 | Lawrence | Indiana | 18093 | 4785 | 127 |
1476300 | 1476300 | 2021-07-02 | Lawrence | Indiana | 18093 | 4785 | 127 |
999062 | 999062 | 2021-02-05 | Hancock | Indiana | 18059 | 7127 | 127 |
995816 | 995816 | 2021-02-04 | Hancock | Indiana | 18059 | 7107 | 127 |
904923 | 904923 | 2021-01-07 | Clark | Indiana | 18019 | 9253 | 127 |
901678 | 901678 | 2021-01-06 | Clark | Indiana | 18019 | 9104 | 127 |
859524 | 859524 | 2020-12-24 | LaPorte | Indiana | 18091 | 7049 | 127 |
836852 | 836852 | 2020-12-17 | Wayne | Indiana | 18177 | 5021 | 127 |
833581 | 833581 | 2020-12-16 | Porter | Indiana | 18127 | 11076 | 127 |
820615 | 820615 | 2020-12-12 | Vigo | Indiana | 18167 | 7773 | 127 |
464015 | 464015 | 2020-08-24 | Hendricks | Indiana | 18063 | 2199 | 127 |
460786 | 460786 | 2020-08-23 | Hendricks | Indiana | 18063 | 2180 | 127 |
457559 | 457559 | 2020-08-22 | Hendricks | Indiana | 18063 | 2152 | 127 |
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);