ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Warren" and state = "Indiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
12840 | 12840 | 2020-03-26 | Warren | Indiana | 18171 | 1 | 0 |
14526 | 14526 | 2020-03-27 | Warren | Indiana | 18171 | 1 | 0 |
16328 | 16328 | 2020-03-28 | Warren | Indiana | 18171 | 1 | 0 |
18233 | 18233 | 2020-03-29 | Warren | Indiana | 18171 | 2 | 0 |
20239 | 20239 | 2020-03-30 | Warren | Indiana | 18171 | 2 | 0 |
22334 | 22334 | 2020-03-31 | Warren | Indiana | 18171 | 2 | 1 |
24506 | 24506 | 2020-04-01 | Warren | Indiana | 18171 | 2 | 1 |
26746 | 26746 | 2020-04-02 | Warren | Indiana | 18171 | 2 | 1 |
29057 | 29057 | 2020-04-03 | Warren | Indiana | 18171 | 2 | 1 |
31425 | 31425 | 2020-04-04 | Warren | Indiana | 18171 | 2 | 1 |
33836 | 33836 | 2020-04-05 | Warren | Indiana | 18171 | 2 | 1 |
36289 | 36289 | 2020-04-06 | Warren | Indiana | 18171 | 2 | 1 |
38787 | 38787 | 2020-04-07 | Warren | Indiana | 18171 | 2 | 1 |
41333 | 41333 | 2020-04-08 | Warren | Indiana | 18171 | 2 | 1 |
43909 | 43909 | 2020-04-09 | Warren | Indiana | 18171 | 2 | 1 |
46514 | 46514 | 2020-04-10 | Warren | Indiana | 18171 | 2 | 1 |
49148 | 49148 | 2020-04-11 | Warren | Indiana | 18171 | 2 | 1 |
51812 | 51812 | 2020-04-12 | Warren | Indiana | 18171 | 3 | 1 |
54493 | 54493 | 2020-04-13 | Warren | Indiana | 18171 | 3 | 1 |
57186 | 57186 | 2020-04-14 | Warren | Indiana | 18171 | 3 | 1 |
59894 | 59894 | 2020-04-15 | Warren | Indiana | 18171 | 3 | 1 |
62615 | 62615 | 2020-04-16 | Warren | Indiana | 18171 | 5 | 1 |
65349 | 65349 | 2020-04-17 | Warren | Indiana | 18171 | 5 | 1 |
68098 | 68098 | 2020-04-18 | Warren | Indiana | 18171 | 6 | 1 |
70860 | 70860 | 2020-04-19 | Warren | Indiana | 18171 | 7 | 1 |
73631 | 73631 | 2020-04-20 | Warren | Indiana | 18171 | 7 | 1 |
76408 | 76408 | 2020-04-21 | Warren | Indiana | 18171 | 7 | 1 |
79192 | 79192 | 2020-04-22 | Warren | Indiana | 18171 | 7 | 1 |
81985 | 81985 | 2020-04-23 | Warren | Indiana | 18171 | 8 | 1 |
84785 | 84785 | 2020-04-24 | Warren | Indiana | 18171 | 11 | 1 |
87595 | 87595 | 2020-04-25 | Warren | Indiana | 18171 | 11 | 1 |
90411 | 90411 | 2020-04-26 | Warren | Indiana | 18171 | 11 | 1 |
93230 | 93230 | 2020-04-27 | Warren | Indiana | 18171 | 11 | 1 |
96062 | 96062 | 2020-04-28 | Warren | Indiana | 18171 | 11 | 1 |
98906 | 98906 | 2020-04-29 | Warren | Indiana | 18171 | 11 | 1 |
101757 | 101757 | 2020-04-30 | Warren | Indiana | 18171 | 11 | 1 |
104613 | 104613 | 2020-05-01 | Warren | Indiana | 18171 | 11 | 1 |
107478 | 107478 | 2020-05-02 | Warren | Indiana | 18171 | 12 | 1 |
110348 | 110348 | 2020-05-03 | Warren | Indiana | 18171 | 12 | 1 |
113223 | 113223 | 2020-05-04 | Warren | Indiana | 18171 | 12 | 1 |
116106 | 116106 | 2020-05-05 | Warren | Indiana | 18171 | 13 | 1 |
119066 | 119066 | 2020-05-06 | Warren | Indiana | 18171 | 13 | 1 |
122036 | 122036 | 2020-05-07 | Warren | Indiana | 18171 | 13 | 1 |
125016 | 125016 | 2020-05-08 | Warren | Indiana | 18171 | 13 | 1 |
128003 | 128003 | 2020-05-09 | Warren | Indiana | 18171 | 13 | 1 |
130994 | 130994 | 2020-05-10 | Warren | Indiana | 18171 | 13 | 1 |
133984 | 133984 | 2020-05-11 | Warren | Indiana | 18171 | 13 | 1 |
136973 | 136973 | 2020-05-12 | Warren | Indiana | 18171 | 13 | 1 |
139965 | 139965 | 2020-05-13 | Warren | Indiana | 18171 | 13 | 1 |
142961 | 142961 | 2020-05-14 | Warren | Indiana | 18171 | 13 | 1 |
145961 | 145961 | 2020-05-15 | Warren | Indiana | 18171 | 13 | 1 |
148965 | 148965 | 2020-05-16 | Warren | Indiana | 18171 | 13 | 1 |
151974 | 151974 | 2020-05-17 | Warren | Indiana | 18171 | 13 | 1 |
154986 | 154986 | 2020-05-18 | Warren | Indiana | 18171 | 13 | 1 |
158002 | 158002 | 2020-05-19 | Warren | Indiana | 18171 | 13 | 1 |
161028 | 161028 | 2020-05-20 | Warren | Indiana | 18171 | 13 | 1 |
164056 | 164056 | 2020-05-21 | Warren | Indiana | 18171 | 13 | 1 |
167089 | 167089 | 2020-05-22 | Warren | Indiana | 18171 | 13 | 1 |
170126 | 170126 | 2020-05-23 | Warren | Indiana | 18171 | 13 | 1 |
173167 | 173167 | 2020-05-24 | Warren | Indiana | 18171 | 13 | 1 |
176211 | 176211 | 2020-05-25 | Warren | Indiana | 18171 | 13 | 1 |
179255 | 179255 | 2020-05-26 | Warren | Indiana | 18171 | 13 | 1 |
182299 | 182299 | 2020-05-27 | Warren | Indiana | 18171 | 13 | 1 |
185353 | 185353 | 2020-05-28 | Warren | Indiana | 18171 | 13 | 1 |
188411 | 188411 | 2020-05-29 | Warren | Indiana | 18171 | 13 | 1 |
191476 | 191476 | 2020-05-30 | Warren | Indiana | 18171 | 13 | 1 |
194543 | 194543 | 2020-05-31 | Warren | Indiana | 18171 | 13 | 1 |
197613 | 197613 | 2020-06-01 | Warren | Indiana | 18171 | 13 | 1 |
200686 | 200686 | 2020-06-02 | Warren | Indiana | 18171 | 13 | 1 |
203762 | 203762 | 2020-06-03 | Warren | Indiana | 18171 | 13 | 1 |
206842 | 206842 | 2020-06-04 | Warren | Indiana | 18171 | 13 | 1 |
209923 | 209923 | 2020-06-05 | Warren | Indiana | 18171 | 14 | 1 |
213008 | 213008 | 2020-06-06 | Warren | Indiana | 18171 | 14 | 1 |
216095 | 216095 | 2020-06-07 | Warren | Indiana | 18171 | 14 | 1 |
219187 | 219187 | 2020-06-08 | Warren | Indiana | 18171 | 14 | 1 |
222282 | 222282 | 2020-06-09 | Warren | Indiana | 18171 | 14 | 1 |
225377 | 225377 | 2020-06-10 | Warren | Indiana | 18171 | 14 | 1 |
228479 | 228479 | 2020-06-11 | Warren | Indiana | 18171 | 15 | 1 |
231582 | 231582 | 2020-06-12 | Warren | Indiana | 18171 | 15 | 1 |
234688 | 234688 | 2020-06-13 | Warren | Indiana | 18171 | 15 | 1 |
237795 | 237795 | 2020-06-14 | Warren | Indiana | 18171 | 15 | 1 |
240903 | 240903 | 2020-06-15 | Warren | Indiana | 18171 | 15 | 1 |
244014 | 244014 | 2020-06-16 | Warren | Indiana | 18171 | 15 | 1 |
247127 | 247127 | 2020-06-17 | Warren | Indiana | 18171 | 16 | 1 |
250239 | 250239 | 2020-06-18 | Warren | Indiana | 18171 | 15 | 1 |
253354 | 253354 | 2020-06-19 | Warren | Indiana | 18171 | 15 | 1 |
256474 | 256474 | 2020-06-20 | Warren | Indiana | 18171 | 15 | 1 |
259600 | 259600 | 2020-06-21 | Warren | Indiana | 18171 | 15 | 1 |
262727 | 262727 | 2020-06-22 | Warren | Indiana | 18171 | 15 | 1 |
265855 | 265855 | 2020-06-23 | Warren | Indiana | 18171 | 15 | 1 |
268985 | 268985 | 2020-06-24 | Warren | Indiana | 18171 | 15 | 1 |
272122 | 272122 | 2020-06-25 | Warren | Indiana | 18171 | 15 | 1 |
275264 | 275264 | 2020-06-26 | Warren | Indiana | 18171 | 15 | 1 |
278412 | 278412 | 2020-06-27 | Warren | Indiana | 18171 | 15 | 1 |
281560 | 281560 | 2020-06-28 | Warren | Indiana | 18171 | 15 | 1 |
284705 | 284705 | 2020-06-29 | Warren | Indiana | 18171 | 15 | 1 |
287854 | 287854 | 2020-06-30 | Warren | Indiana | 18171 | 15 | 1 |
291004 | 291004 | 2020-07-01 | Warren | Indiana | 18171 | 15 | 1 |
294158 | 294158 | 2020-07-02 | Warren | Indiana | 18171 | 15 | 1 |
297316 | 297316 | 2020-07-03 | Warren | Indiana | 18171 | 15 | 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);