ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where county = "Jennings", deaths = 6 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
253308 | 253308 | 2020-06-19 | Jennings | Indiana | 18079 | 160 | 6 |
250193 | 250193 | 2020-06-18 | Jennings | Indiana | 18079 | 147 | 6 |
247081 | 247081 | 2020-06-17 | Jennings | Indiana | 18079 | 144 | 6 |
243968 | 243968 | 2020-06-16 | Jennings | Indiana | 18079 | 144 | 6 |
240857 | 240857 | 2020-06-15 | Jennings | Indiana | 18079 | 144 | 6 |
237749 | 237749 | 2020-06-14 | Jennings | Indiana | 18079 | 144 | 6 |
234642 | 234642 | 2020-06-13 | Jennings | Indiana | 18079 | 142 | 6 |
231536 | 231536 | 2020-06-12 | Jennings | Indiana | 18079 | 141 | 6 |
228433 | 228433 | 2020-06-11 | Jennings | Indiana | 18079 | 138 | 6 |
225331 | 225331 | 2020-06-10 | Jennings | Indiana | 18079 | 137 | 6 |
222236 | 222236 | 2020-06-09 | Jennings | Indiana | 18079 | 135 | 6 |
219141 | 219141 | 2020-06-08 | Jennings | Indiana | 18079 | 135 | 6 |
216049 | 216049 | 2020-06-07 | Jennings | Indiana | 18079 | 134 | 6 |
212962 | 212962 | 2020-06-06 | Jennings | Indiana | 18079 | 134 | 6 |
209877 | 209877 | 2020-06-05 | Jennings | Indiana | 18079 | 134 | 6 |
206796 | 206796 | 2020-06-04 | Jennings | Indiana | 18079 | 134 | 6 |
203716 | 203716 | 2020-06-03 | Jennings | Indiana | 18079 | 133 | 6 |
200640 | 200640 | 2020-06-02 | Jennings | Indiana | 18079 | 133 | 6 |
197567 | 197567 | 2020-06-01 | Jennings | Indiana | 18079 | 132 | 6 |
194497 | 194497 | 2020-05-31 | Jennings | Indiana | 18079 | 132 | 6 |
191430 | 191430 | 2020-05-30 | Jennings | Indiana | 18079 | 132 | 6 |
188365 | 188365 | 2020-05-29 | Jennings | Indiana | 18079 | 132 | 6 |
185307 | 185307 | 2020-05-28 | Jennings | Indiana | 18079 | 131 | 6 |
182253 | 182253 | 2020-05-27 | Jennings | Indiana | 18079 | 130 | 6 |
179209 | 179209 | 2020-05-26 | Jennings | Indiana | 18079 | 129 | 6 |
176165 | 176165 | 2020-05-25 | Jennings | Indiana | 18079 | 129 | 6 |
173121 | 173121 | 2020-05-24 | Jennings | Indiana | 18079 | 128 | 6 |
170080 | 170080 | 2020-05-23 | Jennings | Indiana | 18079 | 128 | 6 |
167043 | 167043 | 2020-05-22 | Jennings | Indiana | 18079 | 127 | 6 |
164010 | 164010 | 2020-05-21 | Jennings | Indiana | 18079 | 125 | 6 |
160982 | 160982 | 2020-05-20 | Jennings | Indiana | 18079 | 123 | 6 |
157956 | 157956 | 2020-05-19 | Jennings | Indiana | 18079 | 119 | 6 |
154940 | 154940 | 2020-05-18 | Jennings | Indiana | 18079 | 118 | 6 |
151928 | 151928 | 2020-05-17 | Jennings | Indiana | 18079 | 118 | 6 |
148919 | 148919 | 2020-05-16 | Jennings | Indiana | 18079 | 114 | 6 |
145915 | 145915 | 2020-05-15 | Jennings | Indiana | 18079 | 113 | 6 |
142915 | 142915 | 2020-05-14 | Jennings | Indiana | 18079 | 111 | 6 |
139919 | 139919 | 2020-05-13 | Jennings | Indiana | 18079 | 110 | 6 |
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);