ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Delaware" and state = "Iowa" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
38815 | 38815 | 2020-04-07 | Delaware | Iowa | 19055 | 1 | 0 |
41361 | 41361 | 2020-04-08 | Delaware | Iowa | 19055 | 1 | 0 |
43937 | 43937 | 2020-04-09 | Delaware | Iowa | 19055 | 1 | 0 |
46542 | 46542 | 2020-04-10 | Delaware | Iowa | 19055 | 1 | 0 |
49176 | 49176 | 2020-04-11 | Delaware | Iowa | 19055 | 2 | 0 |
51840 | 51840 | 2020-04-12 | Delaware | Iowa | 19055 | 2 | 0 |
54522 | 54522 | 2020-04-13 | Delaware | Iowa | 19055 | 2 | 0 |
57215 | 57215 | 2020-04-14 | Delaware | Iowa | 19055 | 2 | 0 |
59923 | 59923 | 2020-04-15 | Delaware | Iowa | 19055 | 2 | 0 |
62644 | 62644 | 2020-04-16 | Delaware | Iowa | 19055 | 2 | 0 |
65378 | 65378 | 2020-04-17 | Delaware | Iowa | 19055 | 2 | 0 |
68127 | 68127 | 2020-04-18 | Delaware | Iowa | 19055 | 2 | 0 |
70889 | 70889 | 2020-04-19 | Delaware | Iowa | 19055 | 2 | 0 |
73660 | 73660 | 2020-04-20 | Delaware | Iowa | 19055 | 2 | 0 |
76438 | 76438 | 2020-04-21 | Delaware | Iowa | 19055 | 3 | 0 |
79222 | 79222 | 2020-04-22 | Delaware | Iowa | 19055 | 3 | 0 |
82015 | 82015 | 2020-04-23 | Delaware | Iowa | 19055 | 3 | 0 |
84815 | 84815 | 2020-04-24 | Delaware | Iowa | 19055 | 3 | 0 |
87625 | 87625 | 2020-04-25 | Delaware | Iowa | 19055 | 4 | 0 |
90441 | 90441 | 2020-04-26 | Delaware | Iowa | 19055 | 4 | 0 |
93260 | 93260 | 2020-04-27 | Delaware | Iowa | 19055 | 4 | 0 |
96092 | 96092 | 2020-04-28 | Delaware | Iowa | 19055 | 4 | 0 |
98937 | 98937 | 2020-04-29 | Delaware | Iowa | 19055 | 4 | 0 |
101788 | 101788 | 2020-04-30 | Delaware | Iowa | 19055 | 8 | 0 |
104645 | 104645 | 2020-05-01 | Delaware | Iowa | 19055 | 8 | 0 |
107510 | 107510 | 2020-05-02 | Delaware | Iowa | 19055 | 10 | 0 |
110380 | 110380 | 2020-05-03 | Delaware | Iowa | 19055 | 5 | 1 |
113255 | 113255 | 2020-05-04 | Delaware | Iowa | 19055 | 5 | 1 |
116138 | 116138 | 2020-05-05 | Delaware | Iowa | 19055 | 8 | 1 |
119098 | 119098 | 2020-05-06 | Delaware | Iowa | 19055 | 8 | 1 |
122068 | 122068 | 2020-05-07 | Delaware | Iowa | 19055 | 8 | 1 |
125048 | 125048 | 2020-05-08 | Delaware | Iowa | 19055 | 7 | 1 |
128035 | 128035 | 2020-05-09 | Delaware | Iowa | 19055 | 7 | 1 |
131026 | 131026 | 2020-05-10 | Delaware | Iowa | 19055 | 9 | 1 |
134016 | 134016 | 2020-05-11 | Delaware | Iowa | 19055 | 9 | 1 |
137005 | 137005 | 2020-05-12 | Delaware | Iowa | 19055 | 10 | 1 |
139997 | 139997 | 2020-05-13 | Delaware | Iowa | 19055 | 10 | 0 |
142993 | 142993 | 2020-05-14 | Delaware | Iowa | 19055 | 11 | 0 |
145993 | 145993 | 2020-05-15 | Delaware | Iowa | 19055 | 11 | 0 |
148997 | 148997 | 2020-05-16 | Delaware | Iowa | 19055 | 12 | 0 |
152007 | 152007 | 2020-05-17 | Delaware | Iowa | 19055 | 12 | 0 |
155019 | 155019 | 2020-05-18 | Delaware | Iowa | 19055 | 12 | 0 |
158035 | 158035 | 2020-05-19 | Delaware | Iowa | 19055 | 12 | 0 |
161061 | 161061 | 2020-05-20 | Delaware | Iowa | 19055 | 13 | 0 |
164089 | 164089 | 2020-05-21 | Delaware | Iowa | 19055 | 13 | 0 |
167122 | 167122 | 2020-05-22 | Delaware | Iowa | 19055 | 14 | 0 |
170159 | 170159 | 2020-05-23 | Delaware | Iowa | 19055 | 14 | 0 |
173200 | 173200 | 2020-05-24 | Delaware | Iowa | 19055 | 15 | 0 |
176244 | 176244 | 2020-05-25 | Delaware | Iowa | 19055 | 15 | 0 |
179288 | 179288 | 2020-05-26 | Delaware | Iowa | 19055 | 15 | 0 |
182333 | 182333 | 2020-05-27 | Delaware | Iowa | 19055 | 15 | 0 |
185387 | 185387 | 2020-05-28 | Delaware | Iowa | 19055 | 15 | 0 |
188445 | 188445 | 2020-05-29 | Delaware | Iowa | 19055 | 15 | 0 |
191510 | 191510 | 2020-05-30 | Delaware | Iowa | 19055 | 15 | 0 |
194577 | 194577 | 2020-05-31 | Delaware | Iowa | 19055 | 15 | 0 |
197647 | 197647 | 2020-06-01 | Delaware | Iowa | 19055 | 17 | 1 |
200720 | 200720 | 2020-06-02 | Delaware | Iowa | 19055 | 18 | 1 |
203796 | 203796 | 2020-06-03 | Delaware | Iowa | 19055 | 19 | 1 |
206876 | 206876 | 2020-06-04 | Delaware | Iowa | 19055 | 19 | 1 |
209957 | 209957 | 2020-06-05 | Delaware | Iowa | 19055 | 19 | 1 |
213042 | 213042 | 2020-06-06 | Delaware | Iowa | 19055 | 19 | 1 |
216129 | 216129 | 2020-06-07 | Delaware | Iowa | 19055 | 20 | 1 |
219221 | 219221 | 2020-06-08 | Delaware | Iowa | 19055 | 20 | 1 |
222316 | 222316 | 2020-06-09 | Delaware | Iowa | 19055 | 20 | 1 |
225411 | 225411 | 2020-06-10 | Delaware | Iowa | 19055 | 25 | 1 |
228513 | 228513 | 2020-06-11 | Delaware | Iowa | 19055 | 26 | 1 |
231616 | 231616 | 2020-06-12 | Delaware | Iowa | 19055 | 27 | 1 |
234722 | 234722 | 2020-06-13 | Delaware | Iowa | 19055 | 27 | 1 |
237829 | 237829 | 2020-06-14 | Delaware | Iowa | 19055 | 27 | 1 |
240937 | 240937 | 2020-06-15 | Delaware | Iowa | 19055 | 27 | 1 |
244048 | 244048 | 2020-06-16 | Delaware | Iowa | 19055 | 28 | 1 |
247161 | 247161 | 2020-06-17 | Delaware | Iowa | 19055 | 29 | 1 |
250273 | 250273 | 2020-06-18 | Delaware | Iowa | 19055 | 29 | 1 |
253388 | 253388 | 2020-06-19 | Delaware | Iowa | 19055 | 32 | 1 |
256508 | 256508 | 2020-06-20 | Delaware | Iowa | 19055 | 32 | 1 |
259634 | 259634 | 2020-06-21 | Delaware | Iowa | 19055 | 33 | 1 |
262761 | 262761 | 2020-06-22 | Delaware | Iowa | 19055 | 33 | 1 |
265889 | 265889 | 2020-06-23 | Delaware | Iowa | 19055 | 34 | 1 |
269019 | 269019 | 2020-06-24 | Delaware | Iowa | 19055 | 36 | 1 |
272156 | 272156 | 2020-06-25 | Delaware | Iowa | 19055 | 36 | 1 |
275298 | 275298 | 2020-06-26 | Delaware | Iowa | 19055 | 38 | 1 |
278446 | 278446 | 2020-06-27 | Delaware | Iowa | 19055 | 40 | 1 |
281594 | 281594 | 2020-06-28 | Delaware | Iowa | 19055 | 41 | 1 |
284739 | 284739 | 2020-06-29 | Delaware | Iowa | 19055 | 40 | 1 |
287888 | 287888 | 2020-06-30 | Delaware | Iowa | 19055 | 41 | 1 |
291038 | 291038 | 2020-07-01 | Delaware | Iowa | 19055 | 46 | 1 |
294192 | 294192 | 2020-07-02 | Delaware | Iowa | 19055 | 48 | 1 |
297350 | 297350 | 2020-07-03 | Delaware | Iowa | 19055 | 48 | 1 |
300512 | 300512 | 2020-07-04 | Delaware | Iowa | 19055 | 50 | 1 |
303676 | 303676 | 2020-07-05 | Delaware | Iowa | 19055 | 51 | 1 |
306841 | 306841 | 2020-07-06 | Delaware | Iowa | 19055 | 51 | 1 |
310009 | 310009 | 2020-07-07 | Delaware | Iowa | 19055 | 51 | 1 |
313179 | 313179 | 2020-07-08 | Delaware | Iowa | 19055 | 53 | 1 |
316353 | 316353 | 2020-07-09 | Delaware | Iowa | 19055 | 54 | 1 |
319526 | 319526 | 2020-07-10 | Delaware | Iowa | 19055 | 56 | 1 |
322705 | 322705 | 2020-07-11 | Delaware | Iowa | 19055 | 56 | 1 |
325886 | 325886 | 2020-07-12 | Delaware | Iowa | 19055 | 56 | 1 |
329072 | 329072 | 2020-07-13 | Delaware | Iowa | 19055 | 58 | 1 |
332259 | 332259 | 2020-07-14 | Delaware | Iowa | 19055 | 57 | 1 |
335452 | 335452 | 2020-07-15 | Delaware | Iowa | 19055 | 57 | 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);