ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 251 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
745901 | 745901 | 2020-11-19 | Crawford | Indiana | 18025 | 251 | 2 |
732985 | 732985 | 2020-11-15 | Union | Indiana | 18161 | 251 | 1 |
606479 | 606479 | 2020-10-07 | Tipton | Indiana | 18159 | 251 | 26 |
599976 | 599976 | 2020-10-05 | Perry | Indiana | 18123 | 251 | 14 |
577267 | 577267 | 2020-09-28 | Jefferson | Indiana | 18077 | 251 | 3 |
544920 | 544920 | 2020-09-18 | Washington | Indiana | 18175 | 251 | 1 |
531978 | 531978 | 2020-09-14 | Wells | Indiana | 18179 | 251 | 2 |
509252 | 509252 | 2020-09-07 | Clay | Indiana | 18021 | 251 | 5 |
502844 | 502844 | 2020-09-05 | Ripley | Indiana | 18137 | 251 | 8 |
451113 | 451113 | 2020-08-20 | Knox | Indiana | 18083 | 251 | 3 |
434953 | 434953 | 2020-08-15 | DeKalb | Indiana | 18033 | 251 | 5 |
412400 | 412400 | 2020-08-08 | Franklin | Indiana | 18047 | 251 | 15 |
412404 | 412404 | 2020-08-08 | Greene | Indiana | 18055 | 251 | 37 |
409185 | 409185 | 2020-08-07 | Greene | Indiana | 18055 | 251 | 37 |
399517 | 399517 | 2020-08-04 | Daviess | Indiana | 18027 | 251 | 21 |
393142 | 393142 | 2020-08-02 | Scott | Indiana | 18143 | 251 | 11 |
265788 | 265788 | 2020-06-23 | Dubois | Indiana | 18037 | 251 | 6 |
259533 | 259533 | 2020-06-21 | Dubois | Indiana | 18037 | 251 | 6 |
234619 | 234619 | 2020-06-13 | Decatur | Indiana | 18031 | 251 | 35 |
225380 | 225380 | 2020-06-10 | Wayne | Indiana | 18177 | 251 | 6 |
222208 | 222208 | 2020-06-09 | Clinton | Indiana | 18023 | 251 | 2 |
209891 | 209891 | 2020-06-05 | Montgomery | Indiana | 18107 | 251 | 18 |
179251 | 179251 | 2020-05-26 | Vanderburgh | Indiana | 18163 | 251 | 2 |
176207 | 176207 | 2020-05-25 | Vanderburgh | Indiana | 18163 | 251 | 2 |
151943 | 151943 | 2020-05-17 | Morgan | Indiana | 18109 | 251 | 21 |
142897 | 142897 | 2020-05-14 | Floyd | Indiana | 18043 | 251 | 33 |
110307 | 110307 | 2020-05-03 | LaPorte | Indiana | 18091 | 251 | 8 |
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);