ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 29083 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055044 | 1055044 | 2021-02-22 | Henry | Missouri | 29083 | 1732 | 36 |
1051797 | 1051797 | 2021-02-21 | Henry | Missouri | 29083 | 1729 | 36 |
1048550 | 1048550 | 2021-02-20 | Henry | Missouri | 29083 | 1726 | 36 |
1045304 | 1045304 | 2021-02-19 | Henry | Missouri | 29083 | 1725 | 36 |
1042059 | 1042059 | 2021-02-18 | Henry | Missouri | 29083 | 1719 | 36 |
1038814 | 1038814 | 2021-02-17 | Henry | Missouri | 29083 | 1718 | 34 |
1035569 | 1035569 | 2021-02-16 | Henry | Missouri | 29083 | 1716 | 34 |
1032324 | 1032324 | 2021-02-15 | Henry | Missouri | 29083 | 1715 | 33 |
1029077 | 1029077 | 2021-02-14 | Henry | Missouri | 29083 | 1713 | 33 |
1025831 | 1025831 | 2021-02-13 | Henry | Missouri | 29083 | 1709 | 33 |
1022586 | 1022586 | 2021-02-12 | Henry | Missouri | 29083 | 1701 | 33 |
1019341 | 1019341 | 2021-02-11 | Henry | Missouri | 29083 | 1695 | 33 |
1016096 | 1016096 | 2021-02-10 | Henry | Missouri | 29083 | 1686 | 30 |
1012851 | 1012851 | 2021-02-09 | Henry | Missouri | 29083 | 1686 | 30 |
1009606 | 1009606 | 2021-02-08 | Henry | Missouri | 29083 | 1684 | 30 |
1006359 | 1006359 | 2021-02-07 | Henry | Missouri | 29083 | 1683 | 30 |
1003113 | 1003113 | 2021-02-06 | Henry | Missouri | 29083 | 1682 | 30 |
999868 | 999868 | 2021-02-05 | Henry | Missouri | 29083 | 1678 | 30 |
996622 | 996622 | 2021-02-04 | Henry | Missouri | 29083 | 1673 | 30 |
993376 | 993376 | 2021-02-03 | Henry | Missouri | 29083 | 1669 | 30 |
990130 | 990130 | 2021-02-02 | Henry | Missouri | 29083 | 1657 | 30 |
986883 | 986883 | 2021-02-01 | Henry | Missouri | 29083 | 1657 | 28 |
983636 | 983636 | 2021-01-31 | Henry | Missouri | 29083 | 1653 | 28 |
980390 | 980390 | 2021-01-30 | Henry | Missouri | 29083 | 1650 | 28 |
977144 | 977144 | 2021-01-29 | Henry | Missouri | 29083 | 1648 | 28 |
973899 | 973899 | 2021-01-28 | Henry | Missouri | 29083 | 1641 | 28 |
970654 | 970654 | 2021-01-27 | Henry | Missouri | 29083 | 1626 | 28 |
967409 | 967409 | 2021-01-26 | Henry | Missouri | 29083 | 1621 | 28 |
964165 | 964165 | 2021-01-25 | Henry | Missouri | 29083 | 1620 | 27 |
960920 | 960920 | 2021-01-24 | Henry | Missouri | 29083 | 1614 | 27 |
957674 | 957674 | 2021-01-23 | Henry | Missouri | 29083 | 1603 | 26 |
954429 | 954429 | 2021-01-22 | Henry | Missouri | 29083 | 1595 | 26 |
951184 | 951184 | 2021-01-21 | Henry | Missouri | 29083 | 1594 | 26 |
947938 | 947938 | 2021-01-20 | Henry | Missouri | 29083 | 1586 | 26 |
944691 | 944691 | 2021-01-19 | Henry | Missouri | 29083 | 1586 | 25 |
941446 | 941446 | 2021-01-18 | Henry | Missouri | 29083 | 1585 | 25 |
938201 | 938201 | 2021-01-17 | Henry | Missouri | 29083 | 1579 | 25 |
934956 | 934956 | 2021-01-16 | Henry | Missouri | 29083 | 1575 | 25 |
931711 | 931711 | 2021-01-15 | Henry | Missouri | 29083 | 1572 | 25 |
928466 | 928466 | 2021-01-14 | Henry | Missouri | 29083 | 1565 | 25 |
925220 | 925220 | 2021-01-13 | Henry | Missouri | 29083 | 1548 | 25 |
921975 | 921975 | 2021-01-12 | Henry | Missouri | 29083 | 1540 | 25 |
918730 | 918730 | 2021-01-11 | Henry | Missouri | 29083 | 1535 | 24 |
915485 | 915485 | 2021-01-10 | Henry | Missouri | 29083 | 1529 | 24 |
912240 | 912240 | 2021-01-09 | Henry | Missouri | 29083 | 1518 | 24 |
908995 | 908995 | 2021-01-08 | Henry | Missouri | 29083 | 1503 | 24 |
905749 | 905749 | 2021-01-07 | Henry | Missouri | 29083 | 1498 | 24 |
902504 | 902504 | 2021-01-06 | Henry | Missouri | 29083 | 1470 | 24 |
899259 | 899259 | 2021-01-05 | Henry | Missouri | 29083 | 1466 | 24 |
896014 | 896014 | 2021-01-04 | Henry | Missouri | 29083 | 1462 | 22 |
892767 | 892767 | 2021-01-03 | Henry | Missouri | 29083 | 1462 | 22 |
889521 | 889521 | 2021-01-02 | Henry | Missouri | 29083 | 1460 | 22 |
886275 | 886275 | 2021-01-01 | Henry | Missouri | 29083 | 1453 | 22 |
883030 | 883030 | 2020-12-31 | Henry | Missouri | 29083 | 1432 | 22 |
879785 | 879785 | 2020-12-30 | Henry | Missouri | 29083 | 1415 | 21 |
876540 | 876540 | 2020-12-29 | Henry | Missouri | 29083 | 1407 | 21 |
873295 | 873295 | 2020-12-28 | Henry | Missouri | 29083 | 1400 | 21 |
870050 | 870050 | 2020-12-27 | Henry | Missouri | 29083 | 1398 | 21 |
866805 | 866805 | 2020-12-26 | Henry | Missouri | 29083 | 1395 | 21 |
863560 | 863560 | 2020-12-25 | Henry | Missouri | 29083 | 1392 | 21 |
860315 | 860315 | 2020-12-24 | Henry | Missouri | 29083 | 1388 | 21 |
857070 | 857070 | 2020-12-23 | Henry | Missouri | 29083 | 1373 | 21 |
853825 | 853825 | 2020-12-22 | Henry | Missouri | 29083 | 1365 | 21 |
850580 | 850580 | 2020-12-21 | Henry | Missouri | 29083 | 1360 | 19 |
847335 | 847335 | 2020-12-20 | Henry | Missouri | 29083 | 1349 | 19 |
844089 | 844089 | 2020-12-19 | Henry | Missouri | 29083 | 1347 | 18 |
840844 | 840844 | 2020-12-18 | Henry | Missouri | 29083 | 1333 | 18 |
837599 | 837599 | 2020-12-17 | Henry | Missouri | 29083 | 1289 | 18 |
834353 | 834353 | 2020-12-16 | Henry | Missouri | 29083 | 1282 | 18 |
831106 | 831106 | 2020-12-15 | Henry | Missouri | 29083 | 1274 | 18 |
827860 | 827860 | 2020-12-14 | Henry | Missouri | 29083 | 1267 | 16 |
824613 | 824613 | 2020-12-13 | Henry | Missouri | 29083 | 1264 | 16 |
821367 | 821367 | 2020-12-12 | Henry | Missouri | 29083 | 1263 | 16 |
818121 | 818121 | 2020-12-11 | Henry | Missouri | 29083 | 1230 | 16 |
814875 | 814875 | 2020-12-10 | Henry | Missouri | 29083 | 1230 | 16 |
811630 | 811630 | 2020-12-09 | Henry | Missouri | 29083 | 1214 | 15 |
808385 | 808385 | 2020-12-08 | Henry | Missouri | 29083 | 1199 | 14 |
805140 | 805140 | 2020-12-07 | Henry | Missouri | 29083 | 1193 | 12 |
801895 | 801895 | 2020-12-06 | Henry | Missouri | 29083 | 1187 | 12 |
798650 | 798650 | 2020-12-05 | Henry | Missouri | 29083 | 1181 | 12 |
795405 | 795405 | 2020-12-04 | Henry | Missouri | 29083 | 1153 | 12 |
792160 | 792160 | 2020-12-03 | Henry | Missouri | 29083 | 1138 | 12 |
788915 | 788915 | 2020-12-02 | Henry | Missouri | 29083 | 1119 | 11 |
785670 | 785670 | 2020-12-01 | Henry | Missouri | 29083 | 1112 | 11 |
782426 | 782426 | 2020-11-30 | Henry | Missouri | 29083 | 1102 | 10 |
779180 | 779180 | 2020-11-29 | Henry | Missouri | 29083 | 1085 | 10 |
775935 | 775935 | 2020-11-28 | Henry | Missouri | 29083 | 1068 | 10 |
772690 | 772690 | 2020-11-27 | Henry | Missouri | 29083 | 1068 | 10 |
769445 | 769445 | 2020-11-26 | Henry | Missouri | 29083 | 1055 | 10 |
766199 | 766199 | 2020-11-25 | Henry | Missouri | 29083 | 1032 | 10 |
762954 | 762954 | 2020-11-24 | Henry | Missouri | 29083 | 1020 | 10 |
759709 | 759709 | 2020-11-23 | Henry | Missouri | 29083 | 998 | 9 |
756462 | 756462 | 2020-11-22 | Henry | Missouri | 29083 | 981 | 9 |
753216 | 753216 | 2020-11-21 | Henry | Missouri | 29083 | 964 | 9 |
749970 | 749970 | 2020-11-20 | Henry | Missouri | 29083 | 933 | 9 |
746724 | 746724 | 2020-11-19 | Henry | Missouri | 29083 | 928 | 9 |
743477 | 743477 | 2020-11-18 | Henry | Missouri | 29083 | 878 | 9 |
740230 | 740230 | 2020-11-17 | Henry | Missouri | 29083 | 866 | 9 |
736986 | 736986 | 2020-11-16 | Henry | Missouri | 29083 | 824 | 8 |
733740 | 733740 | 2020-11-15 | Henry | Missouri | 29083 | 791 | 8 |
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);