ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 312 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
551349 | 551349 | 2020-09-20 | Jennings | Indiana | 18079 | 312 | 14 |
512551 | 512551 | 2020-09-08 | Sullivan | Indiana | 18153 | 312 | 11 |
509318 | 509318 | 2020-09-07 | Sullivan | Indiana | 18153 | 312 | 11 |
506086 | 506086 | 2020-09-06 | Sullivan | Indiana | 18153 | 312 | 10 |
502851 | 502851 | 2020-09-05 | Steuben | Indiana | 18151 | 312 | 6 |
480165 | 480165 | 2020-08-29 | Gibson | Indiana | 18051 | 312 | 4 |
473715 | 473715 | 2020-08-27 | Knox | Indiana | 18083 | 312 | 3 |
473744 | 473744 | 2020-08-27 | Scott | Indiana | 18143 | 312 | 12 |
470493 | 470493 | 2020-08-26 | Miami | Indiana | 18103 | 312 | 2 |
383466 | 383466 | 2020-07-30 | Lawrence | Indiana | 18093 | 312 | 28 |
380219 | 380219 | 2020-07-29 | Decatur | Indiana | 18031 | 312 | 35 |
364195 | 364195 | 2020-07-24 | Montgomery | Indiana | 18107 | 312 | 22 |
354539 | 354539 | 2020-07-21 | Clinton | Indiana | 18023 | 312 | 4 |
344940 | 344940 | 2020-07-18 | Dearborn | Indiana | 18029 | 312 | 26 |
332172 | 332172 | 2020-07-14 | Henry | Indiana | 18065 | 312 | 18 |
297319 | 297319 | 2020-07-03 | Wayne | Indiana | 18177 | 312 | 6 |
225348 | 225348 | 2020-06-10 | Noble | Indiana | 18113 | 312 | 26 |
182219 | 182219 | 2020-05-27 | Boone | Indiana | 18011 | 312 | 38 |
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);