ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
643 rows where county = "Lewis" and fips = 16061 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
306605 | 306605 | 2020-07-06 | Lewis | Idaho | 16061 | 1 | 0 |
309773 | 309773 | 2020-07-07 | Lewis | Idaho | 16061 | 1 | 0 |
312943 | 312943 | 2020-07-08 | Lewis | Idaho | 16061 | 1 | 0 |
425145 | 425145 | 2020-08-12 | Lewis | Idaho | 16061 | 1 | 0 |
428369 | 428369 | 2020-08-13 | Lewis | Idaho | 16061 | 4 | 0 |
431597 | 431597 | 2020-08-14 | Lewis | Idaho | 16061 | 4 | 0 |
434822 | 434822 | 2020-08-15 | Lewis | Idaho | 16061 | 4 | 0 |
438048 | 438048 | 2020-08-16 | Lewis | Idaho | 16061 | 4 | 0 |
441274 | 441274 | 2020-08-17 | Lewis | Idaho | 16061 | 6 | 0 |
444500 | 444500 | 2020-08-18 | Lewis | Idaho | 16061 | 6 | 0 |
447727 | 447727 | 2020-08-19 | Lewis | Idaho | 16061 | 6 | 0 |
450955 | 450955 | 2020-08-20 | Lewis | Idaho | 16061 | 6 | 0 |
454183 | 454183 | 2020-08-21 | Lewis | Idaho | 16061 | 6 | 0 |
457411 | 457411 | 2020-08-22 | Lewis | Idaho | 16061 | 6 | 0 |
460638 | 460638 | 2020-08-23 | Lewis | Idaho | 16061 | 6 | 0 |
463867 | 463867 | 2020-08-24 | Lewis | Idaho | 16061 | 8 | 0 |
467096 | 467096 | 2020-08-25 | Lewis | Idaho | 16061 | 9 | 0 |
470325 | 470325 | 2020-08-26 | Lewis | Idaho | 16061 | 9 | 0 |
473557 | 473557 | 2020-08-27 | Lewis | Idaho | 16061 | 9 | 0 |
476790 | 476790 | 2020-08-28 | Lewis | Idaho | 16061 | 9 | 0 |
480023 | 480023 | 2020-08-29 | Lewis | Idaho | 16061 | 9 | 0 |
483257 | 483257 | 2020-08-30 | Lewis | Idaho | 16061 | 9 | 0 |
486492 | 486492 | 2020-08-31 | Lewis | Idaho | 16061 | 9 | 0 |
489725 | 489725 | 2020-09-01 | Lewis | Idaho | 16061 | 9 | 0 |
492958 | 492958 | 2020-09-02 | Lewis | Idaho | 16061 | 9 | 0 |
496192 | 496192 | 2020-09-03 | Lewis | Idaho | 16061 | 9 | 0 |
499425 | 499425 | 2020-09-04 | Lewis | Idaho | 16061 | 9 | 0 |
502659 | 502659 | 2020-09-05 | Lewis | Idaho | 16061 | 9 | 0 |
505893 | 505893 | 2020-09-06 | Lewis | Idaho | 16061 | 9 | 0 |
509125 | 509125 | 2020-09-07 | Lewis | Idaho | 16061 | 9 | 0 |
512358 | 512358 | 2020-09-08 | Lewis | Idaho | 16061 | 9 | 0 |
515591 | 515591 | 2020-09-09 | Lewis | Idaho | 16061 | 11 | 0 |
518826 | 518826 | 2020-09-10 | Lewis | Idaho | 16061 | 11 | 0 |
522063 | 522063 | 2020-09-11 | Lewis | Idaho | 16061 | 12 | 0 |
525299 | 525299 | 2020-09-12 | Lewis | Idaho | 16061 | 12 | 0 |
528535 | 528535 | 2020-09-13 | Lewis | Idaho | 16061 | 12 | 0 |
531772 | 531772 | 2020-09-14 | Lewis | Idaho | 16061 | 12 | 0 |
535007 | 535007 | 2020-09-15 | Lewis | Idaho | 16061 | 12 | 0 |
538243 | 538243 | 2020-09-16 | Lewis | Idaho | 16061 | 12 | 0 |
541480 | 541480 | 2020-09-17 | Lewis | Idaho | 16061 | 12 | 0 |
544716 | 544716 | 2020-09-18 | Lewis | Idaho | 16061 | 12 | 0 |
547954 | 547954 | 2020-09-19 | Lewis | Idaho | 16061 | 12 | 0 |
551193 | 551193 | 2020-09-20 | Lewis | Idaho | 16061 | 12 | 0 |
554432 | 554432 | 2020-09-21 | Lewis | Idaho | 16061 | 12 | 0 |
557669 | 557669 | 2020-09-22 | Lewis | Idaho | 16061 | 14 | 0 |
560905 | 560905 | 2020-09-23 | Lewis | Idaho | 16061 | 14 | 0 |
564145 | 564145 | 2020-09-24 | Lewis | Idaho | 16061 | 14 | 0 |
567385 | 567385 | 2020-09-25 | Lewis | Idaho | 16061 | 15 | 0 |
570627 | 570627 | 2020-09-26 | Lewis | Idaho | 16061 | 15 | 0 |
573869 | 573869 | 2020-09-27 | Lewis | Idaho | 16061 | 15 | 0 |
577112 | 577112 | 2020-09-28 | Lewis | Idaho | 16061 | 22 | 0 |
580353 | 580353 | 2020-09-29 | Lewis | Idaho | 16061 | 35 | 0 |
583592 | 583592 | 2020-09-30 | Lewis | Idaho | 16061 | 35 | 0 |
586832 | 586832 | 2020-10-01 | Lewis | Idaho | 16061 | 35 | 1 |
590073 | 590073 | 2020-10-02 | Lewis | Idaho | 16061 | 36 | 1 |
593313 | 593313 | 2020-10-03 | Lewis | Idaho | 16061 | 36 | 1 |
596555 | 596555 | 2020-10-04 | Lewis | Idaho | 16061 | 36 | 1 |
599798 | 599798 | 2020-10-05 | Lewis | Idaho | 16061 | 39 | 1 |
603041 | 603041 | 2020-10-06 | Lewis | Idaho | 16061 | 41 | 1 |
606283 | 606283 | 2020-10-07 | Lewis | Idaho | 16061 | 44 | 2 |
609526 | 609526 | 2020-10-08 | Lewis | Idaho | 16061 | 51 | 2 |
612768 | 612768 | 2020-10-09 | Lewis | Idaho | 16061 | 50 | 2 |
616009 | 616009 | 2020-10-10 | Lewis | Idaho | 16061 | 50 | 2 |
619251 | 619251 | 2020-10-11 | Lewis | Idaho | 16061 | 50 | 2 |
622494 | 622494 | 2020-10-12 | Lewis | Idaho | 16061 | 50 | 2 |
625737 | 625737 | 2020-10-13 | Lewis | Idaho | 16061 | 52 | 2 |
628980 | 628980 | 2020-10-14 | Lewis | Idaho | 16061 | 54 | 2 |
632224 | 632224 | 2020-10-15 | Lewis | Idaho | 16061 | 60 | 2 |
635470 | 635470 | 2020-10-16 | Lewis | Idaho | 16061 | 63 | 2 |
638715 | 638715 | 2020-10-17 | Lewis | Idaho | 16061 | 63 | 2 |
641962 | 641962 | 2020-10-18 | Lewis | Idaho | 16061 | 63 | 2 |
645210 | 645210 | 2020-10-19 | Lewis | Idaho | 16061 | 72 | 2 |
648455 | 648455 | 2020-10-20 | Lewis | Idaho | 16061 | 72 | 2 |
651699 | 651699 | 2020-10-21 | Lewis | Idaho | 16061 | 73 | 3 |
654944 | 654944 | 2020-10-22 | Lewis | Idaho | 16061 | 74 | 3 |
658189 | 658189 | 2020-10-23 | Lewis | Idaho | 16061 | 75 | 3 |
661433 | 661433 | 2020-10-24 | Lewis | Idaho | 16061 | 76 | 3 |
664677 | 664677 | 2020-10-25 | Lewis | Idaho | 16061 | 76 | 3 |
667922 | 667922 | 2020-10-26 | Lewis | Idaho | 16061 | 79 | 3 |
671165 | 671165 | 2020-10-27 | Lewis | Idaho | 16061 | 81 | 3 |
674407 | 674407 | 2020-10-28 | Lewis | Idaho | 16061 | 81 | 3 |
677650 | 677650 | 2020-10-29 | Lewis | Idaho | 16061 | 84 | 3 |
680893 | 680893 | 2020-10-30 | Lewis | Idaho | 16061 | 85 | 3 |
684136 | 684136 | 2020-10-31 | Lewis | Idaho | 16061 | 85 | 3 |
687380 | 687380 | 2020-11-01 | Lewis | Idaho | 16061 | 85 | 3 |
690625 | 690625 | 2020-11-02 | Lewis | Idaho | 16061 | 90 | 3 |
693868 | 693868 | 2020-11-03 | Lewis | Idaho | 16061 | 97 | 3 |
697110 | 697110 | 2020-11-04 | Lewis | Idaho | 16061 | 97 | 3 |
700354 | 700354 | 2020-11-05 | Lewis | Idaho | 16061 | 103 | 3 |
703597 | 703597 | 2020-11-06 | Lewis | Idaho | 16061 | 111 | 3 |
706840 | 706840 | 2020-11-07 | Lewis | Idaho | 16061 | 111 | 3 |
710084 | 710084 | 2020-11-08 | Lewis | Idaho | 16061 | 111 | 3 |
713328 | 713328 | 2020-11-09 | Lewis | Idaho | 16061 | 117 | 3 |
716572 | 716572 | 2020-11-10 | Lewis | Idaho | 16061 | 121 | 3 |
719815 | 719815 | 2020-11-11 | Lewis | Idaho | 16061 | 121 | 3 |
723058 | 723058 | 2020-11-12 | Lewis | Idaho | 16061 | 133 | 3 |
726301 | 726301 | 2020-11-13 | Lewis | Idaho | 16061 | 145 | 3 |
729544 | 729544 | 2020-11-14 | Lewis | Idaho | 16061 | 145 | 3 |
732789 | 732789 | 2020-11-15 | Lewis | Idaho | 16061 | 145 | 3 |
736035 | 736035 | 2020-11-16 | Lewis | Idaho | 16061 | 152 | 3 |
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);