ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Adair" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934915 | 934915 | 2021-01-16 | Adair | Missouri | 29001 | 1980 | 15 |
931670 | 931670 | 2021-01-15 | Adair | Missouri | 29001 | 1980 | 15 |
928425 | 928425 | 2021-01-14 | Adair | Missouri | 29001 | 1938 | 15 |
925179 | 925179 | 2021-01-13 | Adair | Missouri | 29001 | 1938 | 15 |
921934 | 921934 | 2021-01-12 | Adair | Missouri | 29001 | 1903 | 15 |
918689 | 918689 | 2021-01-11 | Adair | Missouri | 29001 | 1903 | 15 |
915444 | 915444 | 2021-01-10 | Adair | Missouri | 29001 | 1862 | 13 |
912199 | 912199 | 2021-01-09 | Adair | Missouri | 29001 | 1862 | 13 |
908954 | 908954 | 2021-01-08 | Adair | Missouri | 29001 | 1862 | 13 |
905708 | 905708 | 2021-01-07 | Adair | Missouri | 29001 | 1862 | 13 |
902463 | 902463 | 2021-01-06 | Adair | Missouri | 29001 | 1833 | 13 |
899218 | 899218 | 2021-01-05 | Adair | Missouri | 29001 | 1814 | 13 |
895973 | 895973 | 2021-01-04 | Adair | Missouri | 29001 | 1764 | 11 |
892726 | 892726 | 2021-01-03 | Adair | Missouri | 29001 | 1764 | 11 |
889480 | 889480 | 2021-01-02 | Adair | Missouri | 29001 | 1764 | 11 |
886234 | 886234 | 2021-01-01 | Adair | Missouri | 29001 | 1764 | 11 |
882989 | 882989 | 2020-12-31 | Adair | Missouri | 29001 | 1764 | 11 |
879744 | 879744 | 2020-12-30 | Adair | Missouri | 29001 | 1744 | 11 |
876499 | 876499 | 2020-12-29 | Adair | Missouri | 29001 | 1718 | 8 |
873254 | 873254 | 2020-12-28 | Adair | Missouri | 29001 | 1688 | 7 |
870009 | 870009 | 2020-12-27 | Adair | Missouri | 29001 | 1643 | 7 |
866764 | 866764 | 2020-12-26 | Adair | Missouri | 29001 | 1643 | 7 |
863519 | 863519 | 2020-12-25 | Adair | Missouri | 29001 | 1643 | 7 |
860274 | 860274 | 2020-12-24 | Adair | Missouri | 29001 | 1643 | 7 |
857029 | 857029 | 2020-12-23 | Adair | Missouri | 29001 | 1586 | 4 |
853784 | 853784 | 2020-12-22 | Adair | Missouri | 29001 | 1586 | 4 |
850539 | 850539 | 2020-12-21 | Adair | Missouri | 29001 | 1586 | 4 |
847294 | 847294 | 2020-12-20 | Adair | Missouri | 29001 | 1560 | 4 |
844048 | 844048 | 2020-12-19 | Adair | Missouri | 29001 | 1560 | 4 |
840803 | 840803 | 2020-12-18 | Adair | Missouri | 29001 | 1560 | 4 |
837558 | 837558 | 2020-12-17 | Adair | Missouri | 29001 | 1535 | 4 |
834312 | 834312 | 2020-12-16 | Adair | Missouri | 29001 | 1515 | 4 |
831065 | 831065 | 2020-12-15 | Adair | Missouri | 29001 | 1491 | 4 |
827819 | 827819 | 2020-12-14 | Adair | Missouri | 29001 | 1420 | 3 |
824572 | 824572 | 2020-12-13 | Adair | Missouri | 29001 | 1420 | 3 |
821326 | 821326 | 2020-12-12 | Adair | Missouri | 29001 | 1420 | 3 |
818080 | 818080 | 2020-12-11 | Adair | Missouri | 29001 | 1393 | 3 |
814834 | 814834 | 2020-12-10 | Adair | Missouri | 29001 | 1393 | 3 |
811589 | 811589 | 2020-12-09 | Adair | Missouri | 29001 | 1351 | 3 |
808344 | 808344 | 2020-12-08 | Adair | Missouri | 29001 | 1335 | 3 |
805099 | 805099 | 2020-12-07 | Adair | Missouri | 29001 | 1274 | 3 |
801854 | 801854 | 2020-12-06 | Adair | Missouri | 29001 | 1274 | 3 |
798609 | 798609 | 2020-12-05 | Adair | Missouri | 29001 | 1274 | 3 |
795364 | 795364 | 2020-12-04 | Adair | Missouri | 29001 | 1274 | 3 |
792119 | 792119 | 2020-12-03 | Adair | Missouri | 29001 | 1250 | 3 |
788874 | 788874 | 2020-12-02 | Adair | Missouri | 29001 | 1250 | 3 |
785629 | 785629 | 2020-12-01 | Adair | Missouri | 29001 | 1221 | 3 |
782385 | 782385 | 2020-11-30 | Adair | Missouri | 29001 | 1198 | 3 |
779139 | 779139 | 2020-11-29 | Adair | Missouri | 29001 | 1152 | 3 |
775894 | 775894 | 2020-11-28 | Adair | Missouri | 29001 | 1152 | 3 |
772649 | 772649 | 2020-11-27 | Adair | Missouri | 29001 | 1152 | 3 |
769404 | 769404 | 2020-11-26 | Adair | Missouri | 29001 | 1152 | 3 |
766158 | 766158 | 2020-11-25 | Adair | Missouri | 29001 | 1152 | 3 |
762913 | 762913 | 2020-11-24 | Adair | Missouri | 29001 | 1152 | 3 |
759668 | 759668 | 2020-11-23 | Adair | Missouri | 29001 | 1111 | 2 |
756421 | 756421 | 2020-11-22 | Adair | Missouri | 29001 | 1111 | 2 |
753175 | 753175 | 2020-11-21 | Adair | Missouri | 29001 | 1062 | 2 |
749929 | 749929 | 2020-11-20 | Adair | Missouri | 29001 | 1062 | 2 |
746683 | 746683 | 2020-11-19 | Adair | Missouri | 29001 | 1044 | 2 |
743436 | 743436 | 2020-11-18 | Adair | Missouri | 29001 | 1044 | 2 |
740189 | 740189 | 2020-11-17 | Adair | Missouri | 29001 | 1013 | 2 |
736945 | 736945 | 2020-11-16 | Adair | Missouri | 29001 | 966 | 1 |
733699 | 733699 | 2020-11-15 | Adair | Missouri | 29001 | 879 | 1 |
730454 | 730454 | 2020-11-14 | Adair | Missouri | 29001 | 879 | 1 |
727211 | 727211 | 2020-11-13 | Adair | Missouri | 29001 | 879 | 1 |
723968 | 723968 | 2020-11-12 | Adair | Missouri | 29001 | 879 | 1 |
720725 | 720725 | 2020-11-11 | Adair | Missouri | 29001 | 843 | 1 |
717482 | 717482 | 2020-11-10 | Adair | Missouri | 29001 | 807 | 1 |
714238 | 714238 | 2020-11-09 | Adair | Missouri | 29001 | 769 | 1 |
710994 | 710994 | 2020-11-08 | Adair | Missouri | 29001 | 681 | 1 |
707750 | 707750 | 2020-11-07 | Adair | Missouri | 29001 | 663 | 1 |
704507 | 704507 | 2020-11-06 | Adair | Missouri | 29001 | 660 | 1 |
701265 | 701265 | 2020-11-05 | Adair | Missouri | 29001 | 660 | 1 |
698021 | 698021 | 2020-11-04 | Adair | Missouri | 29001 | 660 | 0 |
694778 | 694778 | 2020-11-03 | Adair | Missouri | 29001 | 647 | 0 |
691536 | 691536 | 2020-11-02 | Adair | Missouri | 29001 | 604 | 0 |
688291 | 688291 | 2020-11-01 | Adair | Missouri | 29001 | 604 | 0 |
685047 | 685047 | 2020-10-31 | Adair | Missouri | 29001 | 604 | 0 |
681804 | 681804 | 2020-10-30 | Adair | Missouri | 29001 | 604 | 0 |
678560 | 678560 | 2020-10-29 | Adair | Missouri | 29001 | 594 | 0 |
675318 | 675318 | 2020-10-28 | Adair | Missouri | 29001 | 575 | 0 |
672075 | 672075 | 2020-10-27 | Adair | Missouri | 29001 | 550 | 0 |
668833 | 668833 | 2020-10-26 | Adair | Missouri | 29001 | 550 | 0 |
665589 | 665589 | 2020-10-25 | Adair | Missouri | 29001 | 538 | 0 |
662344 | 662344 | 2020-10-24 | Adair | Missouri | 29001 | 538 | 0 |
659100 | 659100 | 2020-10-23 | Adair | Missouri | 29001 | 538 | 0 |
655855 | 655855 | 2020-10-22 | Adair | Missouri | 29001 | 516 | 0 |
652610 | 652610 | 2020-10-21 | Adair | Missouri | 29001 | 497 | 0 |
649365 | 649365 | 2020-10-20 | Adair | Missouri | 29001 | 497 | 0 |
646121 | 646121 | 2020-10-19 | Adair | Missouri | 29001 | 465 | 0 |
642875 | 642875 | 2020-10-18 | Adair | Missouri | 29001 | 465 | 0 |
639627 | 639627 | 2020-10-17 | Adair | Missouri | 29001 | 465 | 0 |
636381 | 636381 | 2020-10-16 | Adair | Missouri | 29001 | 465 | 0 |
633135 | 633135 | 2020-10-15 | Adair | Missouri | 29001 | 453 | 0 |
629890 | 629890 | 2020-10-14 | Adair | Missouri | 29001 | 453 | 0 |
626646 | 626646 | 2020-10-13 | Adair | Missouri | 29001 | 436 | 0 |
623404 | 623404 | 2020-10-12 | Adair | Missouri | 29001 | 436 | 0 |
620161 | 620161 | 2020-10-11 | Adair | Missouri | 29001 | 416 | 0 |
616919 | 616919 | 2020-10-10 | Adair | Missouri | 29001 | 416 | 0 |
613678 | 613678 | 2020-10-09 | Adair | Missouri | 29001 | 416 | 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);