ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,171 rows where county = "Edwards" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Edwards · 2,171 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
139803 | 139803 | 2020-05-13 | Edwards | Illinois | 17047 | 2 | 0 |
142799 | 142799 | 2020-05-14 | Edwards | Illinois | 17047 | 2 | 0 |
145799 | 145799 | 2020-05-15 | Edwards | Illinois | 17047 | 2 | 0 |
148802 | 148802 | 2020-05-16 | Edwards | Illinois | 17047 | 2 | 0 |
151811 | 151811 | 2020-05-17 | Edwards | Illinois | 17047 | 2 | 0 |
154823 | 154823 | 2020-05-18 | Edwards | Illinois | 17047 | 2 | 0 |
157839 | 157839 | 2020-05-19 | Edwards | Illinois | 17047 | 2 | 0 |
160865 | 160865 | 2020-05-20 | Edwards | Illinois | 17047 | 2 | 0 |
163893 | 163893 | 2020-05-21 | Edwards | Illinois | 17047 | 2 | 0 |
166926 | 166926 | 2020-05-22 | Edwards | Illinois | 17047 | 2 | 0 |
169963 | 169963 | 2020-05-23 | Edwards | Illinois | 17047 | 2 | 0 |
173004 | 173004 | 2020-05-24 | Edwards | Illinois | 17047 | 2 | 0 |
176048 | 176048 | 2020-05-25 | Edwards | Illinois | 17047 | 2 | 0 |
179092 | 179092 | 2020-05-26 | Edwards | Illinois | 17047 | 2 | 0 |
182136 | 182136 | 2020-05-27 | Edwards | Illinois | 17047 | 2 | 0 |
185190 | 185190 | 2020-05-28 | Edwards | Illinois | 17047 | 2 | 0 |
188248 | 188248 | 2020-05-29 | Edwards | Illinois | 17047 | 2 | 0 |
191313 | 191313 | 2020-05-30 | Edwards | Illinois | 17047 | 2 | 0 |
194380 | 194380 | 2020-05-31 | Edwards | Illinois | 17047 | 2 | 0 |
197450 | 197450 | 2020-06-01 | Edwards | Illinois | 17047 | 2 | 0 |
200523 | 200523 | 2020-06-02 | Edwards | Illinois | 17047 | 2 | 0 |
203599 | 203599 | 2020-06-03 | Edwards | Illinois | 17047 | 2 | 0 |
206679 | 206679 | 2020-06-04 | Edwards | Illinois | 17047 | 2 | 0 |
209760 | 209760 | 2020-06-05 | Edwards | Illinois | 17047 | 2 | 0 |
212845 | 212845 | 2020-06-06 | Edwards | Illinois | 17047 | 2 | 0 |
215932 | 215932 | 2020-06-07 | Edwards | Illinois | 17047 | 2 | 0 |
219023 | 219023 | 2020-06-08 | Edwards | Illinois | 17047 | 2 | 0 |
222118 | 222118 | 2020-06-09 | Edwards | Illinois | 17047 | 2 | 0 |
225213 | 225213 | 2020-06-10 | Edwards | Illinois | 17047 | 2 | 0 |
228315 | 228315 | 2020-06-11 | Edwards | Illinois | 17047 | 2 | 0 |
231418 | 231418 | 2020-06-12 | Edwards | Illinois | 17047 | 2 | 0 |
234524 | 234524 | 2020-06-13 | Edwards | Illinois | 17047 | 2 | 0 |
237631 | 237631 | 2020-06-14 | Edwards | Illinois | 17047 | 2 | 0 |
240739 | 240739 | 2020-06-15 | Edwards | Illinois | 17047 | 2 | 0 |
243850 | 243850 | 2020-06-16 | Edwards | Illinois | 17047 | 2 | 0 |
246963 | 246963 | 2020-06-17 | Edwards | Illinois | 17047 | 2 | 0 |
250075 | 250075 | 2020-06-18 | Edwards | Illinois | 17047 | 2 | 0 |
253190 | 253190 | 2020-06-19 | Edwards | Illinois | 17047 | 2 | 0 |
256310 | 256310 | 2020-06-20 | Edwards | Illinois | 17047 | 2 | 0 |
259436 | 259436 | 2020-06-21 | Edwards | Illinois | 17047 | 2 | 0 |
262563 | 262563 | 2020-06-22 | Edwards | Illinois | 17047 | 2 | 0 |
265691 | 265691 | 2020-06-23 | Edwards | Illinois | 17047 | 2 | 0 |
268821 | 268821 | 2020-06-24 | Edwards | Illinois | 17047 | 2 | 0 |
271958 | 271958 | 2020-06-25 | Edwards | Illinois | 17047 | 2 | 0 |
275100 | 275100 | 2020-06-26 | Edwards | Illinois | 17047 | 2 | 0 |
278248 | 278248 | 2020-06-27 | Edwards | Illinois | 17047 | 2 | 0 |
281396 | 281396 | 2020-06-28 | Edwards | Illinois | 17047 | 2 | 0 |
284541 | 284541 | 2020-06-29 | Edwards | Illinois | 17047 | 2 | 0 |
287690 | 287690 | 2020-06-30 | Edwards | Illinois | 17047 | 2 | 0 |
290840 | 290840 | 2020-07-01 | Edwards | Illinois | 17047 | 2 | 0 |
293994 | 293994 | 2020-07-02 | Edwards | Illinois | 17047 | 2 | 0 |
297151 | 297151 | 2020-07-03 | Edwards | Illinois | 17047 | 2 | 0 |
300313 | 300313 | 2020-07-04 | Edwards | Illinois | 17047 | 2 | 0 |
303477 | 303477 | 2020-07-05 | Edwards | Illinois | 17047 | 2 | 0 |
306642 | 306642 | 2020-07-06 | Edwards | Illinois | 17047 | 2 | 0 |
309810 | 309810 | 2020-07-07 | Edwards | Illinois | 17047 | 2 | 0 |
312980 | 312980 | 2020-07-08 | Edwards | Illinois | 17047 | 2 | 0 |
316154 | 316154 | 2020-07-09 | Edwards | Illinois | 17047 | 2 | 0 |
319327 | 319327 | 2020-07-10 | Edwards | Illinois | 17047 | 3 | 0 |
322506 | 322506 | 2020-07-11 | Edwards | Illinois | 17047 | 5 | 0 |
325687 | 325687 | 2020-07-12 | Edwards | Illinois | 17047 | 5 | 0 |
328873 | 328873 | 2020-07-13 | Edwards | Illinois | 17047 | 5 | 0 |
332060 | 332060 | 2020-07-14 | Edwards | Illinois | 17047 | 5 | 0 |
335253 | 335253 | 2020-07-15 | Edwards | Illinois | 17047 | 5 | 0 |
338449 | 338449 | 2020-07-16 | Edwards | Illinois | 17047 | 5 | 0 |
341645 | 341645 | 2020-07-17 | Edwards | Illinois | 17047 | 5 | 0 |
344845 | 344845 | 2020-07-18 | Edwards | Illinois | 17047 | 5 | 0 |
348046 | 348046 | 2020-07-19 | Edwards | Illinois | 17047 | 5 | 0 |
351246 | 351246 | 2020-07-20 | Edwards | Illinois | 17047 | 5 | 0 |
354448 | 354448 | 2020-07-21 | Edwards | Illinois | 17047 | 6 | 0 |
357650 | 357650 | 2020-07-22 | Edwards | Illinois | 17047 | 6 | 0 |
360855 | 360855 | 2020-07-23 | Edwards | Illinois | 17047 | 6 | 0 |
364062 | 364062 | 2020-07-24 | Edwards | Illinois | 17047 | 6 | 0 |
367269 | 367269 | 2020-07-25 | Edwards | Illinois | 17047 | 6 | 0 |
370479 | 370479 | 2020-07-26 | Edwards | Illinois | 17047 | 6 | 0 |
373691 | 373691 | 2020-07-27 | Edwards | Illinois | 17047 | 6 | 0 |
376906 | 376906 | 2020-07-28 | Edwards | Illinois | 17047 | 7 | 0 |
380123 | 380123 | 2020-07-29 | Edwards | Illinois | 17047 | 10 | 0 |
383340 | 383340 | 2020-07-30 | Edwards | Illinois | 17047 | 12 | 0 |
386558 | 386558 | 2020-07-31 | Edwards | Illinois | 17047 | 12 | 0 |
389775 | 389775 | 2020-08-01 | Edwards | Illinois | 17047 | 13 | 0 |
392992 | 392992 | 2020-08-02 | Edwards | Illinois | 17047 | 13 | 0 |
396208 | 396208 | 2020-08-03 | Edwards | Illinois | 17047 | 13 | 0 |
399424 | 399424 | 2020-08-04 | Edwards | Illinois | 17047 | 14 | 0 |
402640 | 402640 | 2020-08-05 | Edwards | Illinois | 17047 | 16 | 0 |
405858 | 405858 | 2020-08-06 | Edwards | Illinois | 17047 | 17 | 0 |
409078 | 409078 | 2020-08-07 | Edwards | Illinois | 17047 | 17 | 0 |
412297 | 412297 | 2020-08-08 | Edwards | Illinois | 17047 | 17 | 0 |
415517 | 415517 | 2020-08-09 | Edwards | Illinois | 17047 | 18 | 0 |
418738 | 418738 | 2020-08-10 | Edwards | Illinois | 17047 | 18 | 0 |
421961 | 421961 | 2020-08-11 | Edwards | Illinois | 17047 | 20 | 0 |
425182 | 425182 | 2020-08-12 | Edwards | Illinois | 17047 | 24 | 0 |
428406 | 428406 | 2020-08-13 | Edwards | Illinois | 17047 | 24 | 0 |
431634 | 431634 | 2020-08-14 | Edwards | Illinois | 17047 | 24 | 0 |
434859 | 434859 | 2020-08-15 | Edwards | Illinois | 17047 | 25 | 0 |
438085 | 438085 | 2020-08-16 | Edwards | Illinois | 17047 | 25 | 0 |
441311 | 441311 | 2020-08-17 | Edwards | Illinois | 17047 | 27 | 0 |
444537 | 444537 | 2020-08-18 | Edwards | Illinois | 17047 | 28 | 0 |
447764 | 447764 | 2020-08-19 | Edwards | Illinois | 17047 | 29 | 0 |
450992 | 450992 | 2020-08-20 | Edwards | Illinois | 17047 | 28 | 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);