ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Boone" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934924 | 934924 | 2021-01-16 | Boone | Missouri | 29019 | 15395 | 65 |
931679 | 931679 | 2021-01-15 | Boone | Missouri | 29019 | 15395 | 65 |
928434 | 928434 | 2021-01-14 | Boone | Missouri | 29019 | 15300 | 64 |
925188 | 925188 | 2021-01-13 | Boone | Missouri | 29019 | 15204 | 63 |
921943 | 921943 | 2021-01-12 | Boone | Missouri | 29019 | 15102 | 63 |
918698 | 918698 | 2021-01-11 | Boone | Missouri | 29019 | 15015 | 62 |
915453 | 915453 | 2021-01-10 | Boone | Missouri | 29019 | 14736 | 61 |
912208 | 912208 | 2021-01-09 | Boone | Missouri | 29019 | 14736 | 61 |
908963 | 908963 | 2021-01-08 | Boone | Missouri | 29019 | 14736 | 61 |
905717 | 905717 | 2021-01-07 | Boone | Missouri | 29019 | 14613 | 60 |
902472 | 902472 | 2021-01-06 | Boone | Missouri | 29019 | 14466 | 60 |
899227 | 899227 | 2021-01-05 | Boone | Missouri | 29019 | 14295 | 59 |
895982 | 895982 | 2021-01-04 | Boone | Missouri | 29019 | 14186 | 58 |
892735 | 892735 | 2021-01-03 | Boone | Missouri | 29019 | 13835 | 58 |
889489 | 889489 | 2021-01-02 | Boone | Missouri | 29019 | 13835 | 58 |
886243 | 886243 | 2021-01-01 | Boone | Missouri | 29019 | 13835 | 58 |
882998 | 882998 | 2020-12-31 | Boone | Missouri | 29019 | 13835 | 58 |
879753 | 879753 | 2020-12-30 | Boone | Missouri | 29019 | 13705 | 57 |
876508 | 876508 | 2020-12-29 | Boone | Missouri | 29019 | 13588 | 56 |
873263 | 873263 | 2020-12-28 | Boone | Missouri | 29019 | 13470 | 53 |
870018 | 870018 | 2020-12-27 | Boone | Missouri | 29019 | 13222 | 52 |
866773 | 866773 | 2020-12-26 | Boone | Missouri | 29019 | 13222 | 52 |
863528 | 863528 | 2020-12-25 | Boone | Missouri | 29019 | 13222 | 52 |
860283 | 860283 | 2020-12-24 | Boone | Missouri | 29019 | 13222 | 52 |
857038 | 857038 | 2020-12-23 | Boone | Missouri | 29019 | 13060 | 52 |
853793 | 853793 | 2020-12-22 | Boone | Missouri | 29019 | 12914 | 50 |
850548 | 850548 | 2020-12-21 | Boone | Missouri | 29019 | 12812 | 46 |
847303 | 847303 | 2020-12-20 | Boone | Missouri | 29019 | 12580 | 43 |
844057 | 844057 | 2020-12-19 | Boone | Missouri | 29019 | 12580 | 43 |
840812 | 840812 | 2020-12-18 | Boone | Missouri | 29019 | 12580 | 43 |
837567 | 837567 | 2020-12-17 | Boone | Missouri | 29019 | 12427 | 43 |
834321 | 834321 | 2020-12-16 | Boone | Missouri | 29019 | 12254 | 40 |
831074 | 831074 | 2020-12-15 | Boone | Missouri | 29019 | 12130 | 40 |
827828 | 827828 | 2020-12-14 | Boone | Missouri | 29019 | 12050 | 38 |
824581 | 824581 | 2020-12-13 | Boone | Missouri | 29019 | 11776 | 35 |
821335 | 821335 | 2020-12-12 | Boone | Missouri | 29019 | 11716 | 35 |
818089 | 818089 | 2020-12-11 | Boone | Missouri | 29019 | 11716 | 35 |
814843 | 814843 | 2020-12-10 | Boone | Missouri | 29019 | 11597 | 35 |
811598 | 811598 | 2020-12-09 | Boone | Missouri | 29019 | 11493 | 34 |
808353 | 808353 | 2020-12-08 | Boone | Missouri | 29019 | 11287 | 32 |
805108 | 805108 | 2020-12-07 | Boone | Missouri | 29019 | 11209 | 32 |
801863 | 801863 | 2020-12-06 | Boone | Missouri | 29019 | 11046 | 30 |
798618 | 798618 | 2020-12-05 | Boone | Missouri | 29019 | 10944 | 30 |
795373 | 795373 | 2020-12-04 | Boone | Missouri | 29019 | 10857 | 30 |
792128 | 792128 | 2020-12-03 | Boone | Missouri | 29019 | 10711 | 30 |
788883 | 788883 | 2020-12-02 | Boone | Missouri | 29019 | 10577 | 29 |
785638 | 785638 | 2020-12-01 | Boone | Missouri | 29019 | 10389 | 28 |
782394 | 782394 | 2020-11-30 | Boone | Missouri | 29019 | 10349 | 27 |
779148 | 779148 | 2020-11-29 | Boone | Missouri | 29019 | 10311 | 26 |
775903 | 775903 | 2020-11-28 | Boone | Missouri | 29019 | 10193 | 26 |
772658 | 772658 | 2020-11-27 | Boone | Missouri | 29019 | 10184 | 26 |
769413 | 769413 | 2020-11-26 | Boone | Missouri | 29019 | 10100 | 26 |
766167 | 766167 | 2020-11-25 | Boone | Missouri | 29019 | 9979 | 26 |
762922 | 762922 | 2020-11-24 | Boone | Missouri | 29019 | 9772 | 24 |
759677 | 759677 | 2020-11-23 | Boone | Missouri | 29019 | 9720 | 23 |
756430 | 756430 | 2020-11-22 | Boone | Missouri | 29019 | 9651 | 23 |
753184 | 753184 | 2020-11-21 | Boone | Missouri | 29019 | 9516 | 23 |
749938 | 749938 | 2020-11-20 | Boone | Missouri | 29019 | 9379 | 23 |
746692 | 746692 | 2020-11-19 | Boone | Missouri | 29019 | 9217 | 23 |
743445 | 743445 | 2020-11-18 | Boone | Missouri | 29019 | 9029 | 21 |
740198 | 740198 | 2020-11-17 | Boone | Missouri | 29019 | 8823 | 21 |
736954 | 736954 | 2020-11-16 | Boone | Missouri | 29019 | 8743 | 19 |
733708 | 733708 | 2020-11-15 | Boone | Missouri | 29019 | 8650 | 18 |
730463 | 730463 | 2020-11-14 | Boone | Missouri | 29019 | 8650 | 18 |
727220 | 727220 | 2020-11-13 | Boone | Missouri | 29019 | 8227 | 18 |
723977 | 723977 | 2020-11-12 | Boone | Missouri | 29019 | 8040 | 18 |
720734 | 720734 | 2020-11-11 | Boone | Missouri | 29019 | 7819 | 18 |
717491 | 717491 | 2020-11-10 | Boone | Missouri | 29019 | 7629 | 18 |
714247 | 714247 | 2020-11-09 | Boone | Missouri | 29019 | 7541 | 18 |
711003 | 711003 | 2020-11-08 | Boone | Missouri | 29019 | 7446 | 18 |
707759 | 707759 | 2020-11-07 | Boone | Missouri | 29019 | 7291 | 18 |
704516 | 704516 | 2020-11-06 | Boone | Missouri | 29019 | 7101 | 18 |
701274 | 701274 | 2020-11-05 | Boone | Missouri | 29019 | 6934 | 18 |
698030 | 698030 | 2020-11-04 | Boone | Missouri | 29019 | 6712 | 17 |
694787 | 694787 | 2020-11-03 | Boone | Missouri | 29019 | 6531 | 17 |
691545 | 691545 | 2020-11-02 | Boone | Missouri | 29019 | 6462 | 16 |
688300 | 688300 | 2020-11-01 | Boone | Missouri | 29019 | 6443 | 16 |
685056 | 685056 | 2020-10-31 | Boone | Missouri | 29019 | 6373 | 16 |
681813 | 681813 | 2020-10-30 | Boone | Missouri | 29019 | 6256 | 16 |
678569 | 678569 | 2020-10-29 | Boone | Missouri | 29019 | 6174 | 16 |
675327 | 675327 | 2020-10-28 | Boone | Missouri | 29019 | 6104 | 16 |
672084 | 672084 | 2020-10-27 | Boone | Missouri | 29019 | 6060 | 16 |
668842 | 668842 | 2020-10-26 | Boone | Missouri | 29019 | 5961 | 16 |
665598 | 665598 | 2020-10-25 | Boone | Missouri | 29019 | 5938 | 16 |
662353 | 662353 | 2020-10-24 | Boone | Missouri | 29019 | 5889 | 16 |
659109 | 659109 | 2020-10-23 | Boone | Missouri | 29019 | 5849 | 16 |
655864 | 655864 | 2020-10-22 | Boone | Missouri | 29019 | 5777 | 16 |
652619 | 652619 | 2020-10-21 | Boone | Missouri | 29019 | 5739 | 16 |
649374 | 649374 | 2020-10-20 | Boone | Missouri | 29019 | 5627 | 15 |
646130 | 646130 | 2020-10-19 | Boone | Missouri | 29019 | 5625 | 15 |
642884 | 642884 | 2020-10-18 | Boone | Missouri | 29019 | 5612 | 14 |
639636 | 639636 | 2020-10-17 | Boone | Missouri | 29019 | 5582 | 14 |
636390 | 636390 | 2020-10-16 | Boone | Missouri | 29019 | 5522 | 14 |
633144 | 633144 | 2020-10-15 | Boone | Missouri | 29019 | 5482 | 14 |
629899 | 629899 | 2020-10-14 | Boone | Missouri | 29019 | 5399 | 19 |
626655 | 626655 | 2020-10-13 | Boone | Missouri | 29019 | 5299 | 14 |
623413 | 623413 | 2020-10-12 | Boone | Missouri | 29019 | 5244 | 14 |
620170 | 620170 | 2020-10-11 | Boone | Missouri | 29019 | 5244 | 14 |
616928 | 616928 | 2020-10-10 | Boone | Missouri | 29019 | 5244 | 14 |
613687 | 613687 | 2020-10-09 | Boone | Missouri | 29019 | 5132 | 14 |
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);