ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
745 rows where county = "Davis" and state = "Iowa" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
98936 | 98936 | 2020-04-29 | Davis | Iowa | 19051 | 1 | 0 |
101787 | 101787 | 2020-04-30 | Davis | Iowa | 19051 | 1 | 0 |
104644 | 104644 | 2020-05-01 | Davis | Iowa | 19051 | 1 | 0 |
107509 | 107509 | 2020-05-02 | Davis | Iowa | 19051 | 1 | 0 |
110379 | 110379 | 2020-05-03 | Davis | Iowa | 19051 | 1 | 0 |
113254 | 113254 | 2020-05-04 | Davis | Iowa | 19051 | 2 | 0 |
116137 | 116137 | 2020-05-05 | Davis | Iowa | 19051 | 4 | 0 |
119097 | 119097 | 2020-05-06 | Davis | Iowa | 19051 | 5 | 0 |
122067 | 122067 | 2020-05-07 | Davis | Iowa | 19051 | 7 | 0 |
125047 | 125047 | 2020-05-08 | Davis | Iowa | 19051 | 8 | 0 |
128034 | 128034 | 2020-05-09 | Davis | Iowa | 19051 | 9 | 0 |
131025 | 131025 | 2020-05-10 | Davis | Iowa | 19051 | 9 | 0 |
134015 | 134015 | 2020-05-11 | Davis | Iowa | 19051 | 11 | 0 |
137004 | 137004 | 2020-05-12 | Davis | Iowa | 19051 | 11 | 0 |
139996 | 139996 | 2020-05-13 | Davis | Iowa | 19051 | 12 | 0 |
142992 | 142992 | 2020-05-14 | Davis | Iowa | 19051 | 13 | 0 |
145992 | 145992 | 2020-05-15 | Davis | Iowa | 19051 | 13 | 0 |
148996 | 148996 | 2020-05-16 | Davis | Iowa | 19051 | 13 | 0 |
152006 | 152006 | 2020-05-17 | Davis | Iowa | 19051 | 13 | 0 |
155018 | 155018 | 2020-05-18 | Davis | Iowa | 19051 | 13 | 0 |
158034 | 158034 | 2020-05-19 | Davis | Iowa | 19051 | 13 | 0 |
161060 | 161060 | 2020-05-20 | Davis | Iowa | 19051 | 14 | 0 |
164088 | 164088 | 2020-05-21 | Davis | Iowa | 19051 | 15 | 0 |
167121 | 167121 | 2020-05-22 | Davis | Iowa | 19051 | 17 | 0 |
170158 | 170158 | 2020-05-23 | Davis | Iowa | 19051 | 17 | 0 |
173199 | 173199 | 2020-05-24 | Davis | Iowa | 19051 | 20 | 0 |
176243 | 176243 | 2020-05-25 | Davis | Iowa | 19051 | 20 | 0 |
179287 | 179287 | 2020-05-26 | Davis | Iowa | 19051 | 20 | 0 |
182331 | 182331 | 2020-05-27 | Davis | Iowa | 19051 | 20 | 0 |
185385 | 185385 | 2020-05-28 | Davis | Iowa | 19051 | 20 | 0 |
188443 | 188443 | 2020-05-29 | Davis | Iowa | 19051 | 21 | 0 |
191508 | 191508 | 2020-05-30 | Davis | Iowa | 19051 | 21 | 0 |
194575 | 194575 | 2020-05-31 | Davis | Iowa | 19051 | 22 | 0 |
197645 | 197645 | 2020-06-01 | Davis | Iowa | 19051 | 24 | 0 |
200718 | 200718 | 2020-06-02 | Davis | Iowa | 19051 | 25 | 0 |
203794 | 203794 | 2020-06-03 | Davis | Iowa | 19051 | 27 | 0 |
206874 | 206874 | 2020-06-04 | Davis | Iowa | 19051 | 28 | 0 |
209955 | 209955 | 2020-06-05 | Davis | Iowa | 19051 | 28 | 0 |
213040 | 213040 | 2020-06-06 | Davis | Iowa | 19051 | 28 | 0 |
216127 | 216127 | 2020-06-07 | Davis | Iowa | 19051 | 29 | 0 |
219219 | 219219 | 2020-06-08 | Davis | Iowa | 19051 | 29 | 1 |
222314 | 222314 | 2020-06-09 | Davis | Iowa | 19051 | 29 | 1 |
225409 | 225409 | 2020-06-10 | Davis | Iowa | 19051 | 30 | 1 |
228511 | 228511 | 2020-06-11 | Davis | Iowa | 19051 | 31 | 1 |
231614 | 231614 | 2020-06-12 | Davis | Iowa | 19051 | 33 | 1 |
234720 | 234720 | 2020-06-13 | Davis | Iowa | 19051 | 33 | 1 |
237827 | 237827 | 2020-06-14 | Davis | Iowa | 19051 | 34 | 1 |
240935 | 240935 | 2020-06-15 | Davis | Iowa | 19051 | 34 | 1 |
244046 | 244046 | 2020-06-16 | Davis | Iowa | 19051 | 34 | 1 |
247159 | 247159 | 2020-06-17 | Davis | Iowa | 19051 | 34 | 1 |
250271 | 250271 | 2020-06-18 | Davis | Iowa | 19051 | 36 | 1 |
253386 | 253386 | 2020-06-19 | Davis | Iowa | 19051 | 36 | 1 |
256506 | 256506 | 2020-06-20 | Davis | Iowa | 19051 | 36 | 1 |
259632 | 259632 | 2020-06-21 | Davis | Iowa | 19051 | 36 | 1 |
262759 | 262759 | 2020-06-22 | Davis | Iowa | 19051 | 36 | 1 |
265887 | 265887 | 2020-06-23 | Davis | Iowa | 19051 | 36 | 1 |
269017 | 269017 | 2020-06-24 | Davis | Iowa | 19051 | 36 | 1 |
272154 | 272154 | 2020-06-25 | Davis | Iowa | 19051 | 36 | 1 |
275296 | 275296 | 2020-06-26 | Davis | Iowa | 19051 | 36 | 1 |
278444 | 278444 | 2020-06-27 | Davis | Iowa | 19051 | 37 | 1 |
281592 | 281592 | 2020-06-28 | Davis | Iowa | 19051 | 37 | 1 |
284737 | 284737 | 2020-06-29 | Davis | Iowa | 19051 | 37 | 1 |
287886 | 287886 | 2020-06-30 | Davis | Iowa | 19051 | 37 | 1 |
291036 | 291036 | 2020-07-01 | Davis | Iowa | 19051 | 38 | 1 |
294190 | 294190 | 2020-07-02 | Davis | Iowa | 19051 | 39 | 1 |
297348 | 297348 | 2020-07-03 | Davis | Iowa | 19051 | 39 | 1 |
300510 | 300510 | 2020-07-04 | Davis | Iowa | 19051 | 40 | 1 |
303674 | 303674 | 2020-07-05 | Davis | Iowa | 19051 | 40 | 1 |
306839 | 306839 | 2020-07-06 | Davis | Iowa | 19051 | 41 | 1 |
310007 | 310007 | 2020-07-07 | Davis | Iowa | 19051 | 41 | 1 |
313177 | 313177 | 2020-07-08 | Davis | Iowa | 19051 | 42 | 1 |
316351 | 316351 | 2020-07-09 | Davis | Iowa | 19051 | 42 | 1 |
319524 | 319524 | 2020-07-10 | Davis | Iowa | 19051 | 42 | 1 |
322703 | 322703 | 2020-07-11 | Davis | Iowa | 19051 | 42 | 1 |
325884 | 325884 | 2020-07-12 | Davis | Iowa | 19051 | 43 | 1 |
329070 | 329070 | 2020-07-13 | Davis | Iowa | 19051 | 43 | 1 |
332257 | 332257 | 2020-07-14 | Davis | Iowa | 19051 | 43 | 1 |
335450 | 335450 | 2020-07-15 | Davis | Iowa | 19051 | 43 | 1 |
338646 | 338646 | 2020-07-16 | Davis | Iowa | 19051 | 43 | 1 |
341842 | 341842 | 2020-07-17 | Davis | Iowa | 19051 | 44 | 1 |
345042 | 345042 | 2020-07-18 | Davis | Iowa | 19051 | 44 | 1 |
348243 | 348243 | 2020-07-19 | Davis | Iowa | 19051 | 45 | 1 |
351443 | 351443 | 2020-07-20 | Davis | Iowa | 19051 | 46 | 1 |
354645 | 354645 | 2020-07-21 | Davis | Iowa | 19051 | 46 | 1 |
357847 | 357847 | 2020-07-22 | Davis | Iowa | 19051 | 46 | 1 |
361052 | 361052 | 2020-07-23 | Davis | Iowa | 19051 | 47 | 1 |
364259 | 364259 | 2020-07-24 | Davis | Iowa | 19051 | 48 | 1 |
367466 | 367466 | 2020-07-25 | Davis | Iowa | 19051 | 48 | 1 |
370676 | 370676 | 2020-07-26 | Davis | Iowa | 19051 | 48 | 1 |
373888 | 373888 | 2020-07-27 | Davis | Iowa | 19051 | 48 | 1 |
377103 | 377103 | 2020-07-28 | Davis | Iowa | 19051 | 48 | 1 |
380320 | 380320 | 2020-07-29 | Davis | Iowa | 19051 | 49 | 1 |
383537 | 383537 | 2020-07-30 | Davis | Iowa | 19051 | 49 | 1 |
386755 | 386755 | 2020-07-31 | Davis | Iowa | 19051 | 49 | 1 |
389972 | 389972 | 2020-08-01 | Davis | Iowa | 19051 | 49 | 1 |
393189 | 393189 | 2020-08-02 | Davis | Iowa | 19051 | 49 | 1 |
396405 | 396405 | 2020-08-03 | Davis | Iowa | 19051 | 48 | 1 |
399621 | 399621 | 2020-08-04 | Davis | Iowa | 19051 | 50 | 1 |
402837 | 402837 | 2020-08-05 | Davis | Iowa | 19051 | 51 | 1 |
406055 | 406055 | 2020-08-06 | Davis | Iowa | 19051 | 52 | 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);