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 |
---|---|---|---|---|---|---|---|
1064748 | 1064748 | 2021-02-25 | Boone | Missouri | 29019 | 17410 | 80 |
1061504 | 1061504 | 2021-02-24 | Boone | Missouri | 29019 | 17383 | 80 |
1058258 | 1058258 | 2021-02-23 | Boone | Missouri | 29019 | 17350 | 79 |
1055012 | 1055012 | 2021-02-22 | Boone | Missouri | 29019 | 17322 | 77 |
1051765 | 1051765 | 2021-02-21 | Boone | Missouri | 29019 | 17275 | 77 |
1048518 | 1048518 | 2021-02-20 | Boone | Missouri | 29019 | 17275 | 77 |
1045272 | 1045272 | 2021-02-19 | Boone | Missouri | 29019 | 17275 | 77 |
1042027 | 1042027 | 2021-02-18 | Boone | Missouri | 29019 | 17239 | 77 |
1038782 | 1038782 | 2021-02-17 | Boone | Missouri | 29019 | 17198 | 74 |
1035537 | 1035537 | 2021-02-16 | Boone | Missouri | 29019 | 17174 | 74 |
1032292 | 1032292 | 2021-02-15 | Boone | Missouri | 29019 | 17144 | 73 |
1029045 | 1029045 | 2021-02-14 | Boone | Missouri | 29019 | 17119 | 73 |
1025799 | 1025799 | 2021-02-13 | Boone | Missouri | 29019 | 17119 | 73 |
1022554 | 1022554 | 2021-02-12 | Boone | Missouri | 29019 | 17119 | 73 |
1019309 | 1019309 | 2021-02-11 | Boone | Missouri | 29019 | 17081 | 73 |
1016064 | 1016064 | 2021-02-10 | Boone | Missouri | 29019 | 17036 | 73 |
1012819 | 1012819 | 2021-02-09 | Boone | Missouri | 29019 | 17008 | 72 |
1009574 | 1009574 | 2021-02-08 | Boone | Missouri | 29019 | 16981 | 71 |
1006327 | 1006327 | 2021-02-07 | Boone | Missouri | 29019 | 16900 | 71 |
1003081 | 1003081 | 2021-02-06 | Boone | Missouri | 29019 | 16900 | 71 |
999836 | 999836 | 2021-02-05 | Boone | Missouri | 29019 | 16900 | 71 |
996590 | 996590 | 2021-02-04 | Boone | Missouri | 29019 | 16818 | 71 |
993344 | 993344 | 2021-02-03 | Boone | Missouri | 29019 | 16785 | 70 |
990098 | 990098 | 2021-02-02 | Boone | Missouri | 29019 | 16706 | 70 |
986851 | 986851 | 2021-02-01 | Boone | Missouri | 29019 | 16648 | 70 |
983604 | 983604 | 2021-01-31 | Boone | Missouri | 29019 | 16532 | 69 |
980358 | 980358 | 2021-01-30 | Boone | Missouri | 29019 | 16532 | 69 |
977112 | 977112 | 2021-01-29 | Boone | Missouri | 29019 | 16532 | 69 |
973867 | 973867 | 2021-01-28 | Boone | Missouri | 29019 | 16475 | 69 |
970622 | 970622 | 2021-01-27 | Boone | Missouri | 29019 | 16389 | 69 |
967377 | 967377 | 2021-01-26 | Boone | Missouri | 29019 | 16259 | 68 |
964133 | 964133 | 2021-01-25 | Boone | Missouri | 29019 | 16225 | 67 |
960888 | 960888 | 2021-01-24 | Boone | Missouri | 29019 | 16020 | 67 |
957642 | 957642 | 2021-01-23 | Boone | Missouri | 29019 | 16020 | 67 |
954397 | 954397 | 2021-01-22 | Boone | Missouri | 29019 | 16020 | 67 |
951152 | 951152 | 2021-01-21 | Boone | Missouri | 29019 | 15946 | 67 |
947906 | 947906 | 2021-01-20 | Boone | Missouri | 29019 | 15800 | 67 |
944659 | 944659 | 2021-01-19 | Boone | Missouri | 29019 | 15710 | 67 |
941414 | 941414 | 2021-01-18 | Boone | Missouri | 29019 | 15395 | 65 |
938169 | 938169 | 2021-01-17 | Boone | Missouri | 29019 | 15395 | 65 |
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 |
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);