ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Wayne" and state = "Illinois" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
370552 | 370552 | 2020-07-26 | Wayne | Illinois | 17191 | 29 | 1 |
373764 | 373764 | 2020-07-27 | Wayne | Illinois | 17191 | 32 | 1 |
376979 | 376979 | 2020-07-28 | Wayne | Illinois | 17191 | 32 | 1 |
380196 | 380196 | 2020-07-29 | Wayne | Illinois | 17191 | 34 | 1 |
383413 | 383413 | 2020-07-30 | Wayne | Illinois | 17191 | 35 | 1 |
386631 | 386631 | 2020-07-31 | Wayne | Illinois | 17191 | 40 | 1 |
389848 | 389848 | 2020-08-01 | Wayne | Illinois | 17191 | 43 | 1 |
393065 | 393065 | 2020-08-02 | Wayne | Illinois | 17191 | 44 | 1 |
396281 | 396281 | 2020-08-03 | Wayne | Illinois | 17191 | 50 | 1 |
399497 | 399497 | 2020-08-04 | Wayne | Illinois | 17191 | 50 | 1 |
402713 | 402713 | 2020-08-05 | Wayne | Illinois | 17191 | 54 | 1 |
405931 | 405931 | 2020-08-06 | Wayne | Illinois | 17191 | 55 | 1 |
409151 | 409151 | 2020-08-07 | Wayne | Illinois | 17191 | 59 | 1 |
412370 | 412370 | 2020-08-08 | Wayne | Illinois | 17191 | 61 | 1 |
415590 | 415590 | 2020-08-09 | Wayne | Illinois | 17191 | 61 | 1 |
418811 | 418811 | 2020-08-10 | Wayne | Illinois | 17191 | 62 | 1 |
422034 | 422034 | 2020-08-11 | Wayne | Illinois | 17191 | 66 | 2 |
425255 | 425255 | 2020-08-12 | Wayne | Illinois | 17191 | 66 | 2 |
428479 | 428479 | 2020-08-13 | Wayne | Illinois | 17191 | 67 | 2 |
431707 | 431707 | 2020-08-14 | Wayne | Illinois | 17191 | 72 | 2 |
438158 | 438158 | 2020-08-16 | Wayne | Illinois | 17191 | 72 | 2 |
434932 | 434932 | 2020-08-15 | Wayne | Illinois | 17191 | 73 | 2 |
441384 | 441384 | 2020-08-17 | Wayne | Illinois | 17191 | 75 | 2 |
444610 | 444610 | 2020-08-18 | Wayne | Illinois | 17191 | 77 | 2 |
447837 | 447837 | 2020-08-19 | Wayne | Illinois | 17191 | 80 | 2 |
451065 | 451065 | 2020-08-20 | Wayne | Illinois | 17191 | 82 | 2 |
454293 | 454293 | 2020-08-21 | Wayne | Illinois | 17191 | 84 | 2 |
457521 | 457521 | 2020-08-22 | Wayne | Illinois | 17191 | 85 | 2 |
460748 | 460748 | 2020-08-23 | Wayne | Illinois | 17191 | 86 | 2 |
463977 | 463977 | 2020-08-24 | Wayne | Illinois | 17191 | 86 | 2 |
467206 | 467206 | 2020-08-25 | Wayne | Illinois | 17191 | 88 | 2 |
470435 | 470435 | 2020-08-26 | Wayne | Illinois | 17191 | 90 | 2 |
473667 | 473667 | 2020-08-27 | Wayne | Illinois | 17191 | 90 | 2 |
476900 | 476900 | 2020-08-28 | Wayne | Illinois | 17191 | 92 | 2 |
480133 | 480133 | 2020-08-29 | Wayne | Illinois | 17191 | 96 | 2 |
483367 | 483367 | 2020-08-30 | Wayne | Illinois | 17191 | 101 | 2 |
486602 | 486602 | 2020-08-31 | Wayne | Illinois | 17191 | 111 | 2 |
489835 | 489835 | 2020-09-01 | Wayne | Illinois | 17191 | 112 | 2 |
493068 | 493068 | 2020-09-02 | Wayne | Illinois | 17191 | 117 | 2 |
496302 | 496302 | 2020-09-03 | Wayne | Illinois | 17191 | 118 | 2 |
499535 | 499535 | 2020-09-04 | Wayne | Illinois | 17191 | 125 | 2 |
502769 | 502769 | 2020-09-05 | Wayne | Illinois | 17191 | 131 | 2 |
506003 | 506003 | 2020-09-06 | Wayne | Illinois | 17191 | 136 | 2 |
509235 | 509235 | 2020-09-07 | Wayne | Illinois | 17191 | 142 | 2 |
512468 | 512468 | 2020-09-08 | Wayne | Illinois | 17191 | 145 | 2 |
515701 | 515701 | 2020-09-09 | Wayne | Illinois | 17191 | 152 | 2 |
518936 | 518936 | 2020-09-10 | Wayne | Illinois | 17191 | 164 | 2 |
522173 | 522173 | 2020-09-11 | Wayne | Illinois | 17191 | 171 | 3 |
525409 | 525409 | 2020-09-12 | Wayne | Illinois | 17191 | 177 | 4 |
528645 | 528645 | 2020-09-13 | Wayne | Illinois | 17191 | 218 | 4 |
531882 | 531882 | 2020-09-14 | Wayne | Illinois | 17191 | 219 | 4 |
535117 | 535117 | 2020-09-15 | Wayne | Illinois | 17191 | 224 | 4 |
538353 | 538353 | 2020-09-16 | Wayne | Illinois | 17191 | 225 | 5 |
541590 | 541590 | 2020-09-17 | Wayne | Illinois | 17191 | 230 | 5 |
544826 | 544826 | 2020-09-18 | Wayne | Illinois | 17191 | 234 | 5 |
548064 | 548064 | 2020-09-19 | Wayne | Illinois | 17191 | 240 | 5 |
551303 | 551303 | 2020-09-20 | Wayne | Illinois | 17191 | 240 | 5 |
554542 | 554542 | 2020-09-21 | Wayne | Illinois | 17191 | 245 | 5 |
557779 | 557779 | 2020-09-22 | Wayne | Illinois | 17191 | 249 | 5 |
561015 | 561015 | 2020-09-23 | Wayne | Illinois | 17191 | 256 | 5 |
564255 | 564255 | 2020-09-24 | Wayne | Illinois | 17191 | 264 | 5 |
567495 | 567495 | 2020-09-25 | Wayne | Illinois | 17191 | 269 | 5 |
570737 | 570737 | 2020-09-26 | Wayne | Illinois | 17191 | 278 | 5 |
573980 | 573980 | 2020-09-27 | Wayne | Illinois | 17191 | 280 | 5 |
577222 | 577222 | 2020-09-28 | Wayne | Illinois | 17191 | 280 | 5 |
580463 | 580463 | 2020-09-29 | Wayne | Illinois | 17191 | 293 | 5 |
583702 | 583702 | 2020-09-30 | Wayne | Illinois | 17191 | 300 | 5 |
586942 | 586942 | 2020-10-01 | Wayne | Illinois | 17191 | 310 | 5 |
590183 | 590183 | 2020-10-02 | Wayne | Illinois | 17191 | 317 | 5 |
593424 | 593424 | 2020-10-03 | Wayne | Illinois | 17191 | 317 | 5 |
596666 | 596666 | 2020-10-04 | Wayne | Illinois | 17191 | 317 | 5 |
599908 | 599908 | 2020-10-05 | Wayne | Illinois | 17191 | 325 | 6 |
603151 | 603151 | 2020-10-06 | Wayne | Illinois | 17191 | 328 | 6 |
606393 | 606393 | 2020-10-07 | Wayne | Illinois | 17191 | 336 | 6 |
609636 | 609636 | 2020-10-08 | Wayne | Illinois | 17191 | 343 | 6 |
612878 | 612878 | 2020-10-09 | Wayne | Illinois | 17191 | 345 | 7 |
616119 | 616119 | 2020-10-10 | Wayne | Illinois | 17191 | 360 | 7 |
619361 | 619361 | 2020-10-11 | Wayne | Illinois | 17191 | 381 | 7 |
622605 | 622605 | 2020-10-12 | Wayne | Illinois | 17191 | 389 | 7 |
625847 | 625847 | 2020-10-13 | Wayne | Illinois | 17191 | 390 | 7 |
629090 | 629090 | 2020-10-14 | Wayne | Illinois | 17191 | 397 | 7 |
632334 | 632334 | 2020-10-15 | Wayne | Illinois | 17191 | 411 | 8 |
635580 | 635580 | 2020-10-16 | Wayne | Illinois | 17191 | 422 | 9 |
638826 | 638826 | 2020-10-17 | Wayne | Illinois | 17191 | 429 | 9 |
642073 | 642073 | 2020-10-18 | Wayne | Illinois | 17191 | 432 | 9 |
645320 | 645320 | 2020-10-19 | Wayne | Illinois | 17191 | 434 | 10 |
648565 | 648565 | 2020-10-20 | Wayne | Illinois | 17191 | 440 | 11 |
651809 | 651809 | 2020-10-21 | Wayne | Illinois | 17191 | 461 | 11 |
655054 | 655054 | 2020-10-22 | Wayne | Illinois | 17191 | 473 | 12 |
658299 | 658299 | 2020-10-23 | Wayne | Illinois | 17191 | 473 | 12 |
661543 | 661543 | 2020-10-24 | Wayne | Illinois | 17191 | 481 | 12 |
664788 | 664788 | 2020-10-25 | Wayne | Illinois | 17191 | 482 | 12 |
668032 | 668032 | 2020-10-26 | Wayne | Illinois | 17191 | 486 | 12 |
671275 | 671275 | 2020-10-27 | Wayne | Illinois | 17191 | 502 | 13 |
674517 | 674517 | 2020-10-28 | Wayne | Illinois | 17191 | 509 | 14 |
677760 | 677760 | 2020-10-29 | Wayne | Illinois | 17191 | 519 | 15 |
681003 | 681003 | 2020-10-30 | Wayne | Illinois | 17191 | 532 | 17 |
684246 | 684246 | 2020-10-31 | Wayne | Illinois | 17191 | 532 | 17 |
687490 | 687490 | 2020-11-01 | Wayne | Illinois | 17191 | 546 | 18 |
690735 | 690735 | 2020-11-02 | Wayne | Illinois | 17191 | 546 | 18 |
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);