ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 55 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
451084 | 451084 | 2020-08-20 | Crawford | Indiana | 18025 | 55 | 1 |
444667 | 444667 | 2020-08-18 | Martin | Indiana | 18101 | 55 | 0 |
425339 | 425339 | 2020-08-12 | Switzerland | Indiana | 18155 | 55 | 0 |
422118 | 422118 | 2020-08-11 | Switzerland | Indiana | 18155 | 55 | 0 |
405998 | 405998 | 2020-08-06 | Parke | Indiana | 18121 | 55 | 1 |
402800 | 402800 | 2020-08-05 | Union | Indiana | 18161 | 55 | 0 |
399584 | 399584 | 2020-08-04 | Union | Indiana | 18161 | 55 | 0 |
373793 | 373793 | 2020-07-27 | Fountain | Indiana | 18045 | 55 | 2 |
364145 | 364145 | 2020-07-24 | Benton | Indiana | 18007 | 55 | 0 |
354534 | 354534 | 2020-07-21 | Brown | Indiana | 18013 | 55 | 1 |
344984 | 344984 | 2020-07-18 | Owen | Indiana | 18119 | 55 | 1 |
341725 | 341725 | 2020-07-17 | Adams | Indiana | 18001 | 55 | 2 |
341784 | 341784 | 2020-07-17 | Owen | Indiana | 18119 | 55 | 1 |
319471 | 319471 | 2020-07-10 | Posey | Indiana | 18129 | 55 | 0 |
272078 | 272078 | 2020-06-25 | Knox | Indiana | 18083 | 55 | 0 |
272102 | 272102 | 2020-06-25 | Pulaski | Indiana | 18131 | 55 | 1 |
268965 | 268965 | 2020-06-24 | Pulaski | Indiana | 18131 | 55 | 1 |
265835 | 265835 | 2020-06-23 | Pulaski | Indiana | 18131 | 55 | 1 |
262707 | 262707 | 2020-06-22 | Pulaski | Indiana | 18131 | 55 | 1 |
259580 | 259580 | 2020-06-21 | Pulaski | Indiana | 18131 | 55 | 1 |
256454 | 256454 | 2020-06-20 | Pulaski | Indiana | 18131 | 55 | 1 |
247076 | 247076 | 2020-06-17 | Huntington | Indiana | 18069 | 55 | 2 |
247080 | 247080 | 2020-06-17 | Jefferson | Indiana | 18077 | 55 | 1 |
243963 | 243963 | 2020-06-16 | Huntington | Indiana | 18069 | 55 | 2 |
244003 | 244003 | 2020-06-16 | Starke | Indiana | 18149 | 55 | 3 |
240842 | 240842 | 2020-06-15 | Fulton | Indiana | 18049 | 55 | 1 |
237734 | 237734 | 2020-06-14 | Fulton | Indiana | 18049 | 55 | 1 |
222207 | 222207 | 2020-06-09 | Clay | Indiana | 18021 | 55 | 3 |
222288 | 222288 | 2020-06-09 | Whitley | Indiana | 18183 | 55 | 3 |
219163 | 219163 | 2020-06-08 | Perry | Indiana | 18123 | 55 | 2 |
203714 | 203714 | 2020-06-03 | Jay | Indiana | 18075 | 55 | 0 |
200638 | 200638 | 2020-06-02 | Jay | Indiana | 18075 | 55 | 0 |
197565 | 197565 | 2020-06-01 | Jay | Indiana | 18075 | 55 | 0 |
173118 | 173118 | 2020-05-24 | Jasper | Indiana | 18073 | 55 | 1 |
161012 | 161012 | 2020-05-20 | Rush | Indiana | 18139 | 55 | 2 |
157986 | 157986 | 2020-05-19 | Rush | Indiana | 18139 | 55 | 2 |
154970 | 154970 | 2020-05-18 | Rush | Indiana | 18139 | 55 | 2 |
107477 | 107477 | 2020-05-02 | Wabash | Indiana | 18169 | 55 | 1 |
90382 | 90382 | 2020-04-26 | Noble | Indiana | 18113 | 55 | 8 |
81966 | 81966 | 2020-04-23 | Putnam | Indiana | 18133 | 55 | 4 |
68091 | 68091 | 2020-04-18 | Tippecanoe | Indiana | 18157 | 55 | 2 |
51757 | 51757 | 2020-04-12 | Harrison | Indiana | 18061 | 55 | 2 |
36209 | 36209 | 2020-04-06 | Bartholomew | Indiana | 18005 | 55 | 2 |
36229 | 36229 | 2020-04-06 | Franklin | Indiana | 18047 | 55 | 6 |
28986 | 28986 | 2020-04-03 | Clark | Indiana | 18019 | 55 | 2 |
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);