ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
731 rows where county = "Edwards" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535044 | 535044 | 2020-09-15 | Edwards | Illinois | 17047 | 55 | 0 |
531809 | 531809 | 2020-09-14 | Edwards | Illinois | 17047 | 55 | 0 |
528572 | 528572 | 2020-09-13 | Edwards | Illinois | 17047 | 55 | 0 |
525336 | 525336 | 2020-09-12 | Edwards | Illinois | 17047 | 53 | 0 |
522100 | 522100 | 2020-09-11 | Edwards | Illinois | 17047 | 52 | 0 |
518863 | 518863 | 2020-09-10 | Edwards | Illinois | 17047 | 50 | 0 |
515628 | 515628 | 2020-09-09 | Edwards | Illinois | 17047 | 48 | 0 |
512395 | 512395 | 2020-09-08 | Edwards | Illinois | 17047 | 48 | 0 |
509162 | 509162 | 2020-09-07 | Edwards | Illinois | 17047 | 47 | 0 |
505930 | 505930 | 2020-09-06 | Edwards | Illinois | 17047 | 45 | 0 |
502696 | 502696 | 2020-09-05 | Edwards | Illinois | 17047 | 45 | 0 |
499462 | 499462 | 2020-09-04 | Edwards | Illinois | 17047 | 45 | 0 |
496229 | 496229 | 2020-09-03 | Edwards | Illinois | 17047 | 43 | 0 |
492995 | 492995 | 2020-09-02 | Edwards | Illinois | 17047 | 42 | 0 |
489762 | 489762 | 2020-09-01 | Edwards | Illinois | 17047 | 42 | 0 |
486529 | 486529 | 2020-08-31 | Edwards | Illinois | 17047 | 39 | 0 |
483294 | 483294 | 2020-08-30 | Edwards | Illinois | 17047 | 39 | 0 |
480060 | 480060 | 2020-08-29 | Edwards | Illinois | 17047 | 38 | 0 |
476827 | 476827 | 2020-08-28 | Edwards | Illinois | 17047 | 36 | 0 |
473594 | 473594 | 2020-08-27 | Edwards | Illinois | 17047 | 34 | 0 |
470362 | 470362 | 2020-08-26 | Edwards | Illinois | 17047 | 33 | 0 |
467133 | 467133 | 2020-08-25 | Edwards | Illinois | 17047 | 31 | 0 |
463904 | 463904 | 2020-08-24 | Edwards | Illinois | 17047 | 31 | 0 |
460675 | 460675 | 2020-08-23 | Edwards | Illinois | 17047 | 31 | 0 |
457448 | 457448 | 2020-08-22 | Edwards | Illinois | 17047 | 31 | 0 |
454220 | 454220 | 2020-08-21 | Edwards | Illinois | 17047 | 29 | 0 |
450992 | 450992 | 2020-08-20 | Edwards | Illinois | 17047 | 28 | 0 |
447764 | 447764 | 2020-08-19 | Edwards | Illinois | 17047 | 29 | 0 |
444537 | 444537 | 2020-08-18 | Edwards | Illinois | 17047 | 28 | 0 |
441311 | 441311 | 2020-08-17 | Edwards | Illinois | 17047 | 27 | 0 |
438085 | 438085 | 2020-08-16 | Edwards | Illinois | 17047 | 25 | 0 |
434859 | 434859 | 2020-08-15 | Edwards | Illinois | 17047 | 25 | 0 |
431634 | 431634 | 2020-08-14 | Edwards | Illinois | 17047 | 24 | 0 |
428406 | 428406 | 2020-08-13 | Edwards | Illinois | 17047 | 24 | 0 |
425182 | 425182 | 2020-08-12 | Edwards | Illinois | 17047 | 24 | 0 |
421961 | 421961 | 2020-08-11 | Edwards | Illinois | 17047 | 20 | 0 |
418738 | 418738 | 2020-08-10 | Edwards | Illinois | 17047 | 18 | 0 |
415517 | 415517 | 2020-08-09 | Edwards | Illinois | 17047 | 18 | 0 |
412297 | 412297 | 2020-08-08 | Edwards | Illinois | 17047 | 17 | 0 |
409078 | 409078 | 2020-08-07 | Edwards | Illinois | 17047 | 17 | 0 |
405858 | 405858 | 2020-08-06 | Edwards | Illinois | 17047 | 17 | 0 |
402640 | 402640 | 2020-08-05 | Edwards | Illinois | 17047 | 16 | 0 |
399424 | 399424 | 2020-08-04 | Edwards | Illinois | 17047 | 14 | 0 |
396208 | 396208 | 2020-08-03 | Edwards | Illinois | 17047 | 13 | 0 |
392992 | 392992 | 2020-08-02 | Edwards | Illinois | 17047 | 13 | 0 |
389775 | 389775 | 2020-08-01 | Edwards | Illinois | 17047 | 13 | 0 |
386558 | 386558 | 2020-07-31 | Edwards | Illinois | 17047 | 12 | 0 |
383340 | 383340 | 2020-07-30 | Edwards | Illinois | 17047 | 12 | 0 |
380123 | 380123 | 2020-07-29 | Edwards | Illinois | 17047 | 10 | 0 |
376906 | 376906 | 2020-07-28 | Edwards | Illinois | 17047 | 7 | 0 |
373691 | 373691 | 2020-07-27 | Edwards | Illinois | 17047 | 6 | 0 |
370479 | 370479 | 2020-07-26 | Edwards | Illinois | 17047 | 6 | 0 |
367269 | 367269 | 2020-07-25 | Edwards | Illinois | 17047 | 6 | 0 |
364062 | 364062 | 2020-07-24 | Edwards | Illinois | 17047 | 6 | 0 |
360855 | 360855 | 2020-07-23 | Edwards | Illinois | 17047 | 6 | 0 |
357650 | 357650 | 2020-07-22 | Edwards | Illinois | 17047 | 6 | 0 |
354448 | 354448 | 2020-07-21 | Edwards | Illinois | 17047 | 6 | 0 |
351246 | 351246 | 2020-07-20 | Edwards | Illinois | 17047 | 5 | 0 |
348046 | 348046 | 2020-07-19 | Edwards | Illinois | 17047 | 5 | 0 |
344845 | 344845 | 2020-07-18 | Edwards | Illinois | 17047 | 5 | 0 |
341645 | 341645 | 2020-07-17 | Edwards | Illinois | 17047 | 5 | 0 |
338449 | 338449 | 2020-07-16 | Edwards | Illinois | 17047 | 5 | 0 |
335253 | 335253 | 2020-07-15 | Edwards | Illinois | 17047 | 5 | 0 |
332060 | 332060 | 2020-07-14 | Edwards | Illinois | 17047 | 5 | 0 |
328873 | 328873 | 2020-07-13 | Edwards | Illinois | 17047 | 5 | 0 |
325687 | 325687 | 2020-07-12 | Edwards | Illinois | 17047 | 5 | 0 |
322506 | 322506 | 2020-07-11 | Edwards | Illinois | 17047 | 5 | 0 |
319327 | 319327 | 2020-07-10 | Edwards | Illinois | 17047 | 3 | 0 |
316154 | 316154 | 2020-07-09 | Edwards | Illinois | 17047 | 2 | 0 |
312980 | 312980 | 2020-07-08 | Edwards | Illinois | 17047 | 2 | 0 |
309810 | 309810 | 2020-07-07 | Edwards | Illinois | 17047 | 2 | 0 |
306642 | 306642 | 2020-07-06 | Edwards | Illinois | 17047 | 2 | 0 |
303477 | 303477 | 2020-07-05 | Edwards | Illinois | 17047 | 2 | 0 |
300313 | 300313 | 2020-07-04 | Edwards | Illinois | 17047 | 2 | 0 |
297151 | 297151 | 2020-07-03 | Edwards | Illinois | 17047 | 2 | 0 |
293994 | 293994 | 2020-07-02 | Edwards | Illinois | 17047 | 2 | 0 |
290840 | 290840 | 2020-07-01 | Edwards | Illinois | 17047 | 2 | 0 |
287690 | 287690 | 2020-06-30 | Edwards | Illinois | 17047 | 2 | 0 |
284541 | 284541 | 2020-06-29 | Edwards | Illinois | 17047 | 2 | 0 |
281396 | 281396 | 2020-06-28 | Edwards | Illinois | 17047 | 2 | 0 |
278248 | 278248 | 2020-06-27 | Edwards | Illinois | 17047 | 2 | 0 |
275100 | 275100 | 2020-06-26 | Edwards | Illinois | 17047 | 2 | 0 |
271958 | 271958 | 2020-06-25 | Edwards | Illinois | 17047 | 2 | 0 |
268821 | 268821 | 2020-06-24 | Edwards | Illinois | 17047 | 2 | 0 |
265691 | 265691 | 2020-06-23 | Edwards | Illinois | 17047 | 2 | 0 |
262563 | 262563 | 2020-06-22 | Edwards | Illinois | 17047 | 2 | 0 |
259436 | 259436 | 2020-06-21 | Edwards | Illinois | 17047 | 2 | 0 |
256310 | 256310 | 2020-06-20 | Edwards | Illinois | 17047 | 2 | 0 |
253190 | 253190 | 2020-06-19 | Edwards | Illinois | 17047 | 2 | 0 |
250075 | 250075 | 2020-06-18 | Edwards | Illinois | 17047 | 2 | 0 |
246963 | 246963 | 2020-06-17 | Edwards | Illinois | 17047 | 2 | 0 |
243850 | 243850 | 2020-06-16 | Edwards | Illinois | 17047 | 2 | 0 |
240739 | 240739 | 2020-06-15 | Edwards | Illinois | 17047 | 2 | 0 |
237631 | 237631 | 2020-06-14 | Edwards | Illinois | 17047 | 2 | 0 |
234524 | 234524 | 2020-06-13 | Edwards | Illinois | 17047 | 2 | 0 |
231418 | 231418 | 2020-06-12 | Edwards | Illinois | 17047 | 2 | 0 |
228315 | 228315 | 2020-06-11 | Edwards | Illinois | 17047 | 2 | 0 |
225213 | 225213 | 2020-06-10 | Edwards | Illinois | 17047 | 2 | 0 |
222118 | 222118 | 2020-06-09 | Edwards | Illinois | 17047 | 2 | 0 |
219023 | 219023 | 2020-06-08 | Edwards | Illinois | 17047 | 2 | 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);