ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 86 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 |
---|---|---|---|---|---|---|---|
645404 | 645404 | 2020-10-19 | Switzerland | Indiana | 18155 | 86 | 0 |
642157 | 642157 | 2020-10-18 | Switzerland | Indiana | 18155 | 86 | 0 |
580473 | 580473 | 2020-09-29 | Benton | Indiana | 18007 | 86 | 0 |
496369 | 496369 | 2020-09-03 | Parke | Indiana | 18121 | 86 | 2 |
493135 | 493135 | 2020-09-02 | Parke | Indiana | 18121 | 86 | 2 |
486689 | 486689 | 2020-08-31 | Union | Indiana | 18161 | 86 | 0 |
483434 | 483434 | 2020-08-30 | Parke | Indiana | 18121 | 86 | 2 |
473680 | 473680 | 2020-08-27 | Brown | Indiana | 18013 | 86 | 2 |
431779 | 431779 | 2020-08-14 | Pulaski | Indiana | 18131 | 86 | 1 |
428551 | 428551 | 2020-08-13 | Pulaski | Indiana | 18131 | 86 | 1 |
399541 | 399541 | 2020-08-04 | Jay | Indiana | 18075 | 86 | 0 |
389892 | 389892 | 2020-08-01 | Jay | Indiana | 18075 | 86 | 0 |
344949 | 344949 | 2020-07-18 | Fulton | Indiana | 18049 | 86 | 1 |
341789 | 341789 | 2020-07-17 | Posey | Indiana | 18129 | 86 | 0 |
322655 | 322655 | 2020-07-11 | Rush | Indiana | 18139 | 86 | 3 |
319476 | 319476 | 2020-07-10 | Rush | Indiana | 18139 | 86 | 3 |
243965 | 243965 | 2020-06-16 | Jasper | Indiana | 18073 | 86 | 1 |
185281 | 185281 | 2020-05-28 | Daviess | Indiana | 18027 | 86 | 18 |
182227 | 182227 | 2020-05-27 | Daviess | Indiana | 18027 | 86 | 18 |
127929 | 127929 | 2020-05-09 | Clinton | Indiana | 18023 | 86 | 2 |
79175 | 79175 | 2020-04-22 | Ripley | Indiana | 18137 | 86 | 3 |
54476 | 54476 | 2020-04-13 | Ripley | Indiana | 18137 | 86 | 3 |
41311 | 41311 | 2020-04-08 | Porter | Indiana | 18127 | 86 | 1 |
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);