ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
308 rows where deaths = 92 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Decatur 33
- Montgomery 22
- Starke 21
- Orange 18
- DeKalb 15
- Steuben 15
- White 15
- Gibson 13
- Jasper 13
- Noble 13
- Wabash 13
- Warrick 11
- LaGrange 10
- Harrison 8
- Jefferson 8
- Jackson 7
- Knox 7
- Shelby 7
- Clinton 6
- Fulton 6
- Miami 6
- Wells 5
- Boone 4
- Fayette 4
- Fountain 4
- Monroe 4
- St. Joseph 4
- Howard 3
- Huntington 2
- Daviess 1
- …
state 1
- Indiana · 308 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2308319 | 2308319 | 2022-03-15 | White | Indiana | 18181 | 6831 | 92 |
2305068 | 2305068 | 2022-03-14 | White | Indiana | 18181 | 6825 | 92 |
2301816 | 2301816 | 2022-03-13 | White | Indiana | 18181 | 6822 | 92 |
2298564 | 2298564 | 2022-03-12 | White | Indiana | 18181 | 6822 | 92 |
2295312 | 2295312 | 2022-03-11 | White | Indiana | 18181 | 6822 | 92 |
2292060 | 2292060 | 2022-03-10 | White | Indiana | 18181 | 6821 | 92 |
2288808 | 2288808 | 2022-03-09 | White | Indiana | 18181 | 6818 | 92 |
2285557 | 2285557 | 2022-03-08 | White | Indiana | 18181 | 6814 | 92 |
2282305 | 2282305 | 2022-03-07 | White | Indiana | 18181 | 6811 | 92 |
2279052 | 2279052 | 2022-03-06 | White | Indiana | 18181 | 6803 | 92 |
2275799 | 2275799 | 2022-03-05 | White | Indiana | 18181 | 6803 | 92 |
2272546 | 2272546 | 2022-03-04 | White | Indiana | 18181 | 6803 | 92 |
2269294 | 2269294 | 2022-03-03 | White | Indiana | 18181 | 6799 | 92 |
2266041 | 2266041 | 2022-03-02 | White | Indiana | 18181 | 6793 | 92 |
2262790 | 2262790 | 2022-03-01 | White | Indiana | 18181 | 6788 | 92 |
2246503 | 2246503 | 2022-02-24 | Orange | Indiana | 18117 | 5012 | 92 |
2243252 | 2243252 | 2022-02-23 | Orange | Indiana | 18117 | 5008 | 92 |
2240001 | 2240001 | 2022-02-22 | Orange | Indiana | 18117 | 5005 | 92 |
2236750 | 2236750 | 2022-02-21 | Orange | Indiana | 18117 | 5003 | 92 |
2233499 | 2233499 | 2022-02-20 | Orange | Indiana | 18117 | 4994 | 92 |
2230248 | 2230248 | 2022-02-19 | Orange | Indiana | 18117 | 4994 | 92 |
2226997 | 2226997 | 2022-02-18 | Orange | Indiana | 18117 | 4994 | 92 |
2223746 | 2223746 | 2022-02-17 | Orange | Indiana | 18117 | 4987 | 92 |
2223762 | 2223762 | 2022-02-17 | Starke | Indiana | 18149 | 4681 | 92 |
2220495 | 2220495 | 2022-02-16 | Orange | Indiana | 18117 | 4979 | 92 |
2220511 | 2220511 | 2022-02-16 | Starke | Indiana | 18149 | 4679 | 92 |
2217244 | 2217244 | 2022-02-15 | Orange | Indiana | 18117 | 4974 | 92 |
2217260 | 2217260 | 2022-02-15 | Starke | Indiana | 18149 | 4677 | 92 |
2213993 | 2213993 | 2022-02-14 | Orange | Indiana | 18117 | 4972 | 92 |
2214009 | 2214009 | 2022-02-14 | Starke | Indiana | 18149 | 4674 | 92 |
2210741 | 2210741 | 2022-02-13 | Orange | Indiana | 18117 | 4955 | 92 |
2210757 | 2210757 | 2022-02-13 | Starke | Indiana | 18149 | 4666 | 92 |
2207488 | 2207488 | 2022-02-12 | Orange | Indiana | 18117 | 4955 | 92 |
2207504 | 2207504 | 2022-02-12 | Starke | Indiana | 18149 | 4666 | 92 |
2204235 | 2204235 | 2022-02-11 | Orange | Indiana | 18117 | 4955 | 92 |
2204251 | 2204251 | 2022-02-11 | Starke | Indiana | 18149 | 4666 | 92 |
2200982 | 2200982 | 2022-02-10 | Orange | Indiana | 18117 | 4939 | 92 |
2200998 | 2200998 | 2022-02-10 | Starke | Indiana | 18149 | 4663 | 92 |
2197728 | 2197728 | 2022-02-09 | Orange | Indiana | 18117 | 4910 | 92 |
2197744 | 2197744 | 2022-02-09 | Starke | Indiana | 18149 | 4646 | 92 |
2194474 | 2194474 | 2022-02-08 | Orange | Indiana | 18117 | 4910 | 92 |
2194490 | 2194490 | 2022-02-08 | Starke | Indiana | 18149 | 4646 | 92 |
2191220 | 2191220 | 2022-02-07 | Orange | Indiana | 18117 | 4898 | 92 |
2191236 | 2191236 | 2022-02-07 | Starke | Indiana | 18149 | 4641 | 92 |
2187931 | 2187931 | 2022-02-06 | Fountain | Indiana | 18045 | 5216 | 92 |
2187983 | 2187983 | 2022-02-06 | Starke | Indiana | 18149 | 4631 | 92 |
2184678 | 2184678 | 2022-02-05 | Fountain | Indiana | 18045 | 5216 | 92 |
2184730 | 2184730 | 2022-02-05 | Starke | Indiana | 18149 | 4631 | 92 |
2181426 | 2181426 | 2022-02-04 | Fountain | Indiana | 18045 | 5216 | 92 |
2181478 | 2181478 | 2022-02-04 | Starke | Indiana | 18149 | 4631 | 92 |
2178175 | 2178175 | 2022-02-03 | Fountain | Indiana | 18045 | 5213 | 92 |
2178227 | 2178227 | 2022-02-03 | Starke | Indiana | 18149 | 4627 | 92 |
2174974 | 2174974 | 2022-02-02 | Starke | Indiana | 18149 | 4615 | 92 |
2171721 | 2171721 | 2022-02-01 | Starke | Indiana | 18149 | 4599 | 92 |
2168468 | 2168468 | 2022-01-31 | Starke | Indiana | 18149 | 4594 | 92 |
2165213 | 2165213 | 2022-01-30 | Starke | Indiana | 18149 | 4565 | 92 |
2161958 | 2161958 | 2022-01-29 | Starke | Indiana | 18149 | 4565 | 92 |
2158703 | 2158703 | 2022-01-28 | Starke | Indiana | 18149 | 4565 | 92 |
2126117 | 2126117 | 2022-01-18 | Fulton | Indiana | 18049 | 4285 | 92 |
2122865 | 2122865 | 2022-01-17 | Fulton | Indiana | 18049 | 4270 | 92 |
2119613 | 2119613 | 2022-01-16 | Fulton | Indiana | 18049 | 4205 | 92 |
2116361 | 2116361 | 2022-01-15 | Fulton | Indiana | 18049 | 4205 | 92 |
2113110 | 2113110 | 2022-01-14 | Fulton | Indiana | 18049 | 4205 | 92 |
2109858 | 2109858 | 2022-01-13 | Fulton | Indiana | 18049 | 4174 | 92 |
2077330 | 2077330 | 2022-01-03 | Clinton | Indiana | 18023 | 7118 | 92 |
2074079 | 2074079 | 2022-01-02 | Clinton | Indiana | 18023 | 6965 | 92 |
2070828 | 2070828 | 2022-01-01 | Clinton | Indiana | 18023 | 6965 | 92 |
2067577 | 2067577 | 2021-12-31 | Clinton | Indiana | 18023 | 6965 | 92 |
2064326 | 2064326 | 2021-12-30 | Clinton | Indiana | 18023 | 6965 | 92 |
2061076 | 2061076 | 2021-12-29 | Clinton | Indiana | 18023 | 6930 | 92 |
2031884 | 2031884 | 2021-12-20 | Putnam | Indiana | 18133 | 6821 | 92 |
2018889 | 2018889 | 2021-12-16 | Steuben | Indiana | 18151 | 7120 | 92 |
2015639 | 2015639 | 2021-12-15 | Steuben | Indiana | 18151 | 7080 | 92 |
2012388 | 2012388 | 2021-12-14 | Steuben | Indiana | 18151 | 7039 | 92 |
2009137 | 2009137 | 2021-12-13 | Steuben | Indiana | 18151 | 7013 | 92 |
2005886 | 2005886 | 2021-12-12 | Steuben | Indiana | 18151 | 6940 | 92 |
2002635 | 2002635 | 2021-12-11 | Steuben | Indiana | 18151 | 6940 | 92 |
1999385 | 1999385 | 2021-12-10 | Steuben | Indiana | 18151 | 6940 | 92 |
1996134 | 1996134 | 2021-12-09 | Steuben | Indiana | 18151 | 6903 | 92 |
1992883 | 1992883 | 2021-12-08 | Steuben | Indiana | 18151 | 6857 | 92 |
1989632 | 1989632 | 2021-12-07 | Steuben | Indiana | 18151 | 6809 | 92 |
1986382 | 1986382 | 2021-12-06 | Steuben | Indiana | 18151 | 6773 | 92 |
1983132 | 1983132 | 2021-12-05 | Steuben | Indiana | 18151 | 6698 | 92 |
1979882 | 1979882 | 2021-12-04 | Steuben | Indiana | 18151 | 6698 | 92 |
1976632 | 1976632 | 2021-12-03 | Steuben | Indiana | 18151 | 6698 | 92 |
1973351 | 1973351 | 2021-12-02 | LaGrange | Indiana | 18087 | 4265 | 92 |
1973383 | 1973383 | 2021-12-02 | Steuben | Indiana | 18151 | 6666 | 92 |
1970101 | 1970101 | 2021-12-01 | LaGrange | Indiana | 18087 | 4237 | 92 |
1966851 | 1966851 | 2021-11-30 | LaGrange | Indiana | 18087 | 4218 | 92 |
1963599 | 1963599 | 2021-11-29 | LaGrange | Indiana | 18087 | 4198 | 92 |
1960348 | 1960348 | 2021-11-28 | LaGrange | Indiana | 18087 | 4144 | 92 |
1957097 | 1957097 | 2021-11-27 | LaGrange | Indiana | 18087 | 4144 | 92 |
1953846 | 1953846 | 2021-11-26 | LaGrange | Indiana | 18087 | 4144 | 92 |
1950595 | 1950595 | 2021-11-25 | LaGrange | Indiana | 18087 | 4144 | 92 |
1947344 | 1947344 | 2021-11-24 | LaGrange | Indiana | 18087 | 4144 | 92 |
1944093 | 1944093 | 2021-11-23 | LaGrange | Indiana | 18087 | 4116 | 92 |
1918085 | 1918085 | 2021-11-15 | Jasper | Indiana | 18073 | 5745 | 92 |
1914835 | 1914835 | 2021-11-14 | Jasper | Indiana | 18073 | 5699 | 92 |
1911585 | 1911585 | 2021-11-13 | Jasper | Indiana | 18073 | 5699 | 92 |
1908336 | 1908336 | 2021-11-12 | Jasper | Indiana | 18073 | 5699 | 92 |
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);