ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Fayette" and state = "Illinois" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
306644 | 306644 | 2020-07-06 | Fayette | Illinois | 17051 | 23 | 3 |
309812 | 309812 | 2020-07-07 | Fayette | Illinois | 17051 | 23 | 3 |
312982 | 312982 | 2020-07-08 | Fayette | Illinois | 17051 | 24 | 3 |
316156 | 316156 | 2020-07-09 | Fayette | Illinois | 17051 | 23 | 3 |
319329 | 319329 | 2020-07-10 | Fayette | Illinois | 17051 | 23 | 3 |
322508 | 322508 | 2020-07-11 | Fayette | Illinois | 17051 | 24 | 3 |
325689 | 325689 | 2020-07-12 | Fayette | Illinois | 17051 | 24 | 3 |
328875 | 328875 | 2020-07-13 | Fayette | Illinois | 17051 | 25 | 3 |
332062 | 332062 | 2020-07-14 | Fayette | Illinois | 17051 | 26 | 3 |
335255 | 335255 | 2020-07-15 | Fayette | Illinois | 17051 | 28 | 3 |
338451 | 338451 | 2020-07-16 | Fayette | Illinois | 17051 | 30 | 3 |
341647 | 341647 | 2020-07-17 | Fayette | Illinois | 17051 | 32 | 3 |
344847 | 344847 | 2020-07-18 | Fayette | Illinois | 17051 | 34 | 3 |
348048 | 348048 | 2020-07-19 | Fayette | Illinois | 17051 | 35 | 3 |
351248 | 351248 | 2020-07-20 | Fayette | Illinois | 17051 | 38 | 3 |
354450 | 354450 | 2020-07-21 | Fayette | Illinois | 17051 | 39 | 3 |
357652 | 357652 | 2020-07-22 | Fayette | Illinois | 17051 | 39 | 3 |
360857 | 360857 | 2020-07-23 | Fayette | Illinois | 17051 | 40 | 3 |
364064 | 364064 | 2020-07-24 | Fayette | Illinois | 17051 | 41 | 3 |
367271 | 367271 | 2020-07-25 | Fayette | Illinois | 17051 | 41 | 3 |
370481 | 370481 | 2020-07-26 | Fayette | Illinois | 17051 | 43 | 3 |
373693 | 373693 | 2020-07-27 | Fayette | Illinois | 17051 | 43 | 3 |
376908 | 376908 | 2020-07-28 | Fayette | Illinois | 17051 | 44 | 3 |
380125 | 380125 | 2020-07-29 | Fayette | Illinois | 17051 | 51 | 3 |
383342 | 383342 | 2020-07-30 | Fayette | Illinois | 17051 | 52 | 3 |
386560 | 386560 | 2020-07-31 | Fayette | Illinois | 17051 | 53 | 3 |
389777 | 389777 | 2020-08-01 | Fayette | Illinois | 17051 | 54 | 3 |
392994 | 392994 | 2020-08-02 | Fayette | Illinois | 17051 | 55 | 3 |
396210 | 396210 | 2020-08-03 | Fayette | Illinois | 17051 | 58 | 3 |
399426 | 399426 | 2020-08-04 | Fayette | Illinois | 17051 | 58 | 3 |
402642 | 402642 | 2020-08-05 | Fayette | Illinois | 17051 | 58 | 3 |
405860 | 405860 | 2020-08-06 | Fayette | Illinois | 17051 | 60 | 3 |
409080 | 409080 | 2020-08-07 | Fayette | Illinois | 17051 | 60 | 3 |
412299 | 412299 | 2020-08-08 | Fayette | Illinois | 17051 | 65 | 3 |
415519 | 415519 | 2020-08-09 | Fayette | Illinois | 17051 | 66 | 3 |
418740 | 418740 | 2020-08-10 | Fayette | Illinois | 17051 | 67 | 3 |
421963 | 421963 | 2020-08-11 | Fayette | Illinois | 17051 | 69 | 3 |
425184 | 425184 | 2020-08-12 | Fayette | Illinois | 17051 | 71 | 3 |
428408 | 428408 | 2020-08-13 | Fayette | Illinois | 17051 | 73 | 3 |
431636 | 431636 | 2020-08-14 | Fayette | Illinois | 17051 | 73 | 3 |
434861 | 434861 | 2020-08-15 | Fayette | Illinois | 17051 | 78 | 3 |
438087 | 438087 | 2020-08-16 | Fayette | Illinois | 17051 | 78 | 3 |
441313 | 441313 | 2020-08-17 | Fayette | Illinois | 17051 | 80 | 3 |
444539 | 444539 | 2020-08-18 | Fayette | Illinois | 17051 | 81 | 3 |
447766 | 447766 | 2020-08-19 | Fayette | Illinois | 17051 | 87 | 3 |
450994 | 450994 | 2020-08-20 | Fayette | Illinois | 17051 | 97 | 3 |
454222 | 454222 | 2020-08-21 | Fayette | Illinois | 17051 | 103 | 3 |
457450 | 457450 | 2020-08-22 | Fayette | Illinois | 17051 | 108 | 3 |
460677 | 460677 | 2020-08-23 | Fayette | Illinois | 17051 | 115 | 3 |
463906 | 463906 | 2020-08-24 | Fayette | Illinois | 17051 | 120 | 3 |
467135 | 467135 | 2020-08-25 | Fayette | Illinois | 17051 | 127 | 3 |
470364 | 470364 | 2020-08-26 | Fayette | Illinois | 17051 | 140 | 3 |
473596 | 473596 | 2020-08-27 | Fayette | Illinois | 17051 | 144 | 3 |
476829 | 476829 | 2020-08-28 | Fayette | Illinois | 17051 | 153 | 3 |
480062 | 480062 | 2020-08-29 | Fayette | Illinois | 17051 | 163 | 3 |
483296 | 483296 | 2020-08-30 | Fayette | Illinois | 17051 | 165 | 3 |
486531 | 486531 | 2020-08-31 | Fayette | Illinois | 17051 | 169 | 3 |
489764 | 489764 | 2020-09-01 | Fayette | Illinois | 17051 | 172 | 3 |
492997 | 492997 | 2020-09-02 | Fayette | Illinois | 17051 | 176 | 3 |
496231 | 496231 | 2020-09-03 | Fayette | Illinois | 17051 | 183 | 3 |
499464 | 499464 | 2020-09-04 | Fayette | Illinois | 17051 | 196 | 3 |
502698 | 502698 | 2020-09-05 | Fayette | Illinois | 17051 | 202 | 3 |
505932 | 505932 | 2020-09-06 | Fayette | Illinois | 17051 | 212 | 3 |
509164 | 509164 | 2020-09-07 | Fayette | Illinois | 17051 | 214 | 3 |
512397 | 512397 | 2020-09-08 | Fayette | Illinois | 17051 | 217 | 3 |
515630 | 515630 | 2020-09-09 | Fayette | Illinois | 17051 | 217 | 3 |
518865 | 518865 | 2020-09-10 | Fayette | Illinois | 17051 | 227 | 3 |
522102 | 522102 | 2020-09-11 | Fayette | Illinois | 17051 | 243 | 3 |
525338 | 525338 | 2020-09-12 | Fayette | Illinois | 17051 | 246 | 3 |
528574 | 528574 | 2020-09-13 | Fayette | Illinois | 17051 | 255 | 3 |
531811 | 531811 | 2020-09-14 | Fayette | Illinois | 17051 | 260 | 3 |
535046 | 535046 | 2020-09-15 | Fayette | Illinois | 17051 | 266 | 3 |
538282 | 538282 | 2020-09-16 | Fayette | Illinois | 17051 | 285 | 3 |
541519 | 541519 | 2020-09-17 | Fayette | Illinois | 17051 | 300 | 3 |
544755 | 544755 | 2020-09-18 | Fayette | Illinois | 17051 | 300 | 3 |
547993 | 547993 | 2020-09-19 | Fayette | Illinois | 17051 | 306 | 3 |
551232 | 551232 | 2020-09-20 | Fayette | Illinois | 17051 | 339 | 3 |
554471 | 554471 | 2020-09-21 | Fayette | Illinois | 17051 | 346 | 3 |
557708 | 557708 | 2020-09-22 | Fayette | Illinois | 17051 | 351 | 3 |
560944 | 560944 | 2020-09-23 | Fayette | Illinois | 17051 | 373 | 3 |
564184 | 564184 | 2020-09-24 | Fayette | Illinois | 17051 | 389 | 3 |
567424 | 567424 | 2020-09-25 | Fayette | Illinois | 17051 | 402 | 3 |
570666 | 570666 | 2020-09-26 | Fayette | Illinois | 17051 | 406 | 3 |
573909 | 573909 | 2020-09-27 | Fayette | Illinois | 17051 | 418 | 3 |
577151 | 577151 | 2020-09-28 | Fayette | Illinois | 17051 | 418 | 3 |
580392 | 580392 | 2020-09-29 | Fayette | Illinois | 17051 | 424 | 3 |
583631 | 583631 | 2020-09-30 | Fayette | Illinois | 17051 | 437 | 6 |
586871 | 586871 | 2020-10-01 | Fayette | Illinois | 17051 | 449 | 7 |
590112 | 590112 | 2020-10-02 | Fayette | Illinois | 17051 | 453 | 8 |
593353 | 593353 | 2020-10-03 | Fayette | Illinois | 17051 | 460 | 8 |
596595 | 596595 | 2020-10-04 | Fayette | Illinois | 17051 | 463 | 8 |
599837 | 599837 | 2020-10-05 | Fayette | Illinois | 17051 | 471 | 9 |
603080 | 603080 | 2020-10-06 | Fayette | Illinois | 17051 | 480 | 9 |
606322 | 606322 | 2020-10-07 | Fayette | Illinois | 17051 | 483 | 9 |
609565 | 609565 | 2020-10-08 | Fayette | Illinois | 17051 | 489 | 10 |
612807 | 612807 | 2020-10-09 | Fayette | Illinois | 17051 | 501 | 10 |
616048 | 616048 | 2020-10-10 | Fayette | Illinois | 17051 | 507 | 12 |
619290 | 619290 | 2020-10-11 | Fayette | Illinois | 17051 | 525 | 13 |
622534 | 622534 | 2020-10-12 | Fayette | Illinois | 17051 | 547 | 14 |
625776 | 625776 | 2020-10-13 | Fayette | Illinois | 17051 | 550 | 15 |
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);