ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Unknown" and state = "Delaware" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
46083 | 46083 | 2020-04-10 | Unknown | Delaware | 9 | 0 | |
48713 | 48713 | 2020-04-11 | Unknown | Delaware | 13 | 0 | |
54054 | 54054 | 2020-04-13 | Unknown | Delaware | 3 | 0 | |
56746 | 56746 | 2020-04-14 | Unknown | Delaware | 11 | 0 | |
59454 | 59454 | 2020-04-15 | Unknown | Delaware | 17 | 0 | |
62173 | 62173 | 2020-04-16 | Unknown | Delaware | 22 | 0 | |
64906 | 64906 | 2020-04-17 | Unknown | Delaware | 28 | 0 | |
67654 | 67654 | 2020-04-18 | Unknown | Delaware | 30 | 0 | |
70416 | 70416 | 2020-04-19 | Unknown | Delaware | 30 | 0 | |
73185 | 73185 | 2020-04-20 | Unknown | Delaware | 31 | 0 | |
75961 | 75961 | 2020-04-21 | Unknown | Delaware | 30 | 0 | |
78745 | 78745 | 2020-04-22 | Unknown | Delaware | 28 | 0 | |
81539 | 81539 | 2020-04-23 | Unknown | Delaware | 3 | 0 | |
84339 | 84339 | 2020-04-24 | Unknown | Delaware | 4 | 0 | |
87147 | 87147 | 2020-04-25 | Unknown | Delaware | 3 | 0 | |
89964 | 89964 | 2020-04-26 | Unknown | Delaware | 9 | 0 | |
92782 | 92782 | 2020-04-27 | Unknown | Delaware | 11 | 0 | |
95614 | 95614 | 2020-04-28 | Unknown | Delaware | 32 | 0 | |
98459 | 98459 | 2020-04-29 | Unknown | Delaware | 26 | 0 | |
101309 | 101309 | 2020-04-30 | Unknown | Delaware | 25 | 0 | |
104164 | 104164 | 2020-05-01 | Unknown | Delaware | 24 | 0 | |
107029 | 107029 | 2020-05-02 | Unknown | Delaware | 22 | 0 | |
109898 | 109898 | 2020-05-03 | Unknown | Delaware | 23 | 0 | |
112773 | 112773 | 2020-05-04 | Unknown | Delaware | 24 | 0 | |
115656 | 115656 | 2020-05-05 | Unknown | Delaware | 25 | 0 | |
118616 | 118616 | 2020-05-06 | Unknown | Delaware | 36 | 0 | |
121585 | 121585 | 2020-05-07 | Unknown | Delaware | 30 | 0 | |
127551 | 127551 | 2020-05-09 | Unknown | Delaware | 27 | 0 | |
130542 | 130542 | 2020-05-10 | Unknown | Delaware | 41 | 0 | |
133533 | 133533 | 2020-05-11 | Unknown | Delaware | 40 | 0 | |
136522 | 136522 | 2020-05-12 | Unknown | Delaware | 36 | 1 | |
139513 | 139513 | 2020-05-13 | Unknown | Delaware | 36 | 1 | |
142509 | 142509 | 2020-05-14 | Unknown | Delaware | 45 | 1 | |
145509 | 145509 | 2020-05-15 | Unknown | Delaware | 43 | 1 | |
148512 | 148512 | 2020-05-16 | Unknown | Delaware | 46 | 1 | |
151521 | 151521 | 2020-05-17 | Unknown | Delaware | 52 | 1 | |
154533 | 154533 | 2020-05-18 | Unknown | Delaware | 51 | 1 | |
157549 | 157549 | 2020-05-19 | Unknown | Delaware | 50 | 1 | |
160575 | 160575 | 2020-05-20 | Unknown | Delaware | 48 | 1 | |
163603 | 163603 | 2020-05-21 | Unknown | Delaware | 46 | 1 | |
166636 | 166636 | 2020-05-22 | Unknown | Delaware | 53 | 1 | |
169673 | 169673 | 2020-05-23 | Unknown | Delaware | 53 | 1 | |
172714 | 172714 | 2020-05-24 | Unknown | Delaware | 57 | 1 | |
175757 | 175757 | 2020-05-25 | Unknown | Delaware | 55 | 1 | |
178801 | 178801 | 2020-05-26 | Unknown | Delaware | 58 | 0 | |
181845 | 181845 | 2020-05-27 | Unknown | Delaware | 54 | 0 | |
184899 | 184899 | 2020-05-28 | Unknown | Delaware | 53 | 0 | |
187955 | 187955 | 2020-05-29 | Unknown | Delaware | 51 | 0 | |
191020 | 191020 | 2020-05-30 | Unknown | Delaware | 52 | 0 | |
194087 | 194087 | 2020-05-31 | Unknown | Delaware | 51 | 0 | |
197157 | 197157 | 2020-06-01 | Unknown | Delaware | 55 | 0 | |
200230 | 200230 | 2020-06-02 | Unknown | Delaware | 53 | 0 | |
203306 | 203306 | 2020-06-03 | Unknown | Delaware | 53 | 0 | |
206386 | 206386 | 2020-06-04 | Unknown | Delaware | 53 | 1 | |
209467 | 209467 | 2020-06-05 | Unknown | Delaware | 49 | 0 | |
212552 | 212552 | 2020-06-06 | Unknown | Delaware | 12 | 0 | |
215639 | 215639 | 2020-06-07 | Unknown | Delaware | 15 | 0 | |
218730 | 218730 | 2020-06-08 | Unknown | Delaware | 11 | 0 | |
221825 | 221825 | 2020-06-09 | Unknown | Delaware | 12 | 0 | |
224920 | 224920 | 2020-06-10 | Unknown | Delaware | 14 | 0 | |
228022 | 228022 | 2020-06-11 | Unknown | Delaware | 13 | 0 | |
231125 | 231125 | 2020-06-12 | Unknown | Delaware | 16 | 0 | |
234231 | 234231 | 2020-06-13 | Unknown | Delaware | 15 | 0 | |
237338 | 237338 | 2020-06-14 | Unknown | Delaware | 14 | 0 | |
240446 | 240446 | 2020-06-15 | Unknown | Delaware | 14 | 0 | |
243557 | 243557 | 2020-06-16 | Unknown | Delaware | 16 | 0 | |
246670 | 246670 | 2020-06-17 | Unknown | Delaware | 14 | 0 | |
249782 | 249782 | 2020-06-18 | Unknown | Delaware | 14 | 0 | |
252897 | 252897 | 2020-06-19 | Unknown | Delaware | 17 | 0 | |
256016 | 256016 | 2020-06-20 | Unknown | Delaware | 19 | 0 | |
259143 | 259143 | 2020-06-21 | Unknown | Delaware | 20 | 0 | |
262270 | 262270 | 2020-06-22 | Unknown | Delaware | 17 | 0 | |
265398 | 265398 | 2020-06-23 | Unknown | Delaware | 17 | 0 | |
268528 | 268528 | 2020-06-24 | Unknown | Delaware | 19 | 0 | |
271664 | 271664 | 2020-06-25 | Unknown | Delaware | 21 | 0 | |
274804 | 274804 | 2020-06-26 | Unknown | Delaware | 23 | 0 | |
277952 | 277952 | 2020-06-27 | Unknown | Delaware | 26 | 0 | |
281099 | 281099 | 2020-06-28 | Unknown | Delaware | 30 | 0 | |
284245 | 284245 | 2020-06-29 | Unknown | Delaware | 36 | 0 | |
287391 | 287391 | 2020-06-30 | Unknown | Delaware | 38 | 0 | |
290542 | 290542 | 2020-07-01 | Unknown | Delaware | 42 | 0 | |
293696 | 293696 | 2020-07-02 | Unknown | Delaware | 53 | 0 | |
296852 | 296852 | 2020-07-03 | Unknown | Delaware | 69 | 0 | |
300014 | 300014 | 2020-07-04 | Unknown | Delaware | 73 | 0 | |
303178 | 303178 | 2020-07-05 | Unknown | Delaware | 81 | 0 | |
306342 | 306342 | 2020-07-06 | Unknown | Delaware | 91 | 0 | |
309510 | 309510 | 2020-07-07 | Unknown | Delaware | 98 | 0 | |
312680 | 312680 | 2020-07-08 | Unknown | Delaware | 101 | 0 | |
315855 | 315855 | 2020-07-09 | Unknown | Delaware | 102 | 0 | |
319028 | 319028 | 2020-07-10 | Unknown | Delaware | 104 | 0 | |
322207 | 322207 | 2020-07-11 | Unknown | Delaware | 106 | 0 | |
325388 | 325388 | 2020-07-12 | Unknown | Delaware | 104 | 0 | |
328574 | 328574 | 2020-07-13 | Unknown | Delaware | 106 | 0 | |
331761 | 331761 | 2020-07-14 | Unknown | Delaware | 114 | 0 | |
334954 | 334954 | 2020-07-15 | Unknown | Delaware | 117 | 0 | |
338149 | 338149 | 2020-07-16 | Unknown | Delaware | 121 | 0 | |
341346 | 341346 | 2020-07-17 | Unknown | Delaware | 134 | 0 | |
344545 | 344545 | 2020-07-18 | Unknown | Delaware | 142 | 0 | |
347745 | 347745 | 2020-07-19 | Unknown | Delaware | 145 | 0 | |
350946 | 350946 | 2020-07-20 | Unknown | Delaware | 153 | 0 |
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);