ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29049 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194629 | 1194629 | 2021-04-06 | Clinton | Missouri | 29049 | 2036 | 65 |
1191380 | 1191380 | 2021-04-05 | Clinton | Missouri | 29049 | 2036 | 65 |
1188132 | 1188132 | 2021-04-04 | Clinton | Missouri | 29049 | 2036 | 65 |
1184885 | 1184885 | 2021-04-03 | Clinton | Missouri | 29049 | 2035 | 65 |
1181639 | 1181639 | 2021-04-02 | Clinton | Missouri | 29049 | 2036 | 65 |
1178392 | 1178392 | 2021-04-01 | Clinton | Missouri | 29049 | 2036 | 65 |
1175145 | 1175145 | 2021-03-31 | Clinton | Missouri | 29049 | 2036 | 65 |
1171898 | 1171898 | 2021-03-30 | Clinton | Missouri | 29049 | 2036 | 65 |
1168650 | 1168650 | 2021-03-29 | Clinton | Missouri | 29049 | 2035 | 65 |
1165402 | 1165402 | 2021-03-28 | Clinton | Missouri | 29049 | 2035 | 65 |
1162154 | 1162154 | 2021-03-27 | Clinton | Missouri | 29049 | 2033 | 65 |
1158906 | 1158906 | 2021-03-26 | Clinton | Missouri | 29049 | 2031 | 65 |
1155659 | 1155659 | 2021-03-25 | Clinton | Missouri | 29049 | 2031 | 65 |
1152412 | 1152412 | 2021-03-24 | Clinton | Missouri | 29049 | 2030 | 65 |
1149165 | 1149165 | 2021-03-23 | Clinton | Missouri | 29049 | 2030 | 65 |
1145918 | 1145918 | 2021-03-22 | Clinton | Missouri | 29049 | 2029 | 65 |
1142671 | 1142671 | 2021-03-21 | Clinton | Missouri | 29049 | 2029 | 65 |
1139424 | 1139424 | 2021-03-20 | Clinton | Missouri | 29049 | 2028 | 65 |
1136178 | 1136178 | 2021-03-19 | Clinton | Missouri | 29049 | 2027 | 65 |
1132932 | 1132932 | 2021-03-18 | Clinton | Missouri | 29049 | 2026 | 65 |
1129684 | 1129684 | 2021-03-17 | Clinton | Missouri | 29049 | 2024 | 65 |
1126437 | 1126437 | 2021-03-16 | Clinton | Missouri | 29049 | 2024 | 65 |
1123191 | 1123191 | 2021-03-15 | Clinton | Missouri | 29049 | 2024 | 65 |
1119944 | 1119944 | 2021-03-14 | Clinton | Missouri | 29049 | 2024 | 65 |
1116697 | 1116697 | 2021-03-13 | Clinton | Missouri | 29049 | 2023 | 65 |
1113451 | 1113451 | 2021-03-12 | Clinton | Missouri | 29049 | 2022 | 65 |
1110205 | 1110205 | 2021-03-11 | Clinton | Missouri | 29049 | 2021 | 65 |
1106959 | 1106959 | 2021-03-10 | Clinton | Missouri | 29049 | 2021 | 65 |
1103713 | 1103713 | 2021-03-09 | Clinton | Missouri | 29049 | 2019 | 65 |
1100467 | 1100467 | 2021-03-08 | Clinton | Missouri | 29049 | 2019 | 65 |
1097220 | 1097220 | 2021-03-07 | Clinton | Missouri | 29049 | 1529 | 65 |
1093973 | 1093973 | 2021-03-06 | Clinton | Missouri | 29049 | 1528 | 65 |
1090727 | 1090727 | 2021-03-05 | Clinton | Missouri | 29049 | 1529 | 65 |
1087482 | 1087482 | 2021-03-04 | Clinton | Missouri | 29049 | 1527 | 65 |
1084237 | 1084237 | 2021-03-03 | Clinton | Missouri | 29049 | 1525 | 65 |
1080991 | 1080991 | 2021-03-02 | Clinton | Missouri | 29049 | 1525 | 64 |
1077745 | 1077745 | 2021-03-01 | Clinton | Missouri | 29049 | 1525 | 64 |
1074499 | 1074499 | 2021-02-28 | Clinton | Missouri | 29049 | 1525 | 64 |
1071253 | 1071253 | 2021-02-27 | Clinton | Missouri | 29049 | 1525 | 64 |
1068008 | 1068008 | 2021-02-26 | Clinton | Missouri | 29049 | 1525 | 64 |
1064763 | 1064763 | 2021-02-25 | Clinton | Missouri | 29049 | 1525 | 64 |
1061519 | 1061519 | 2021-02-24 | Clinton | Missouri | 29049 | 1524 | 64 |
1058273 | 1058273 | 2021-02-23 | Clinton | Missouri | 29049 | 1522 | 64 |
1055027 | 1055027 | 2021-02-22 | Clinton | Missouri | 29049 | 1519 | 64 |
1051780 | 1051780 | 2021-02-21 | Clinton | Missouri | 29049 | 1519 | 64 |
1048533 | 1048533 | 2021-02-20 | Clinton | Missouri | 29049 | 1519 | 64 |
1045287 | 1045287 | 2021-02-19 | Clinton | Missouri | 29049 | 1518 | 64 |
1042042 | 1042042 | 2021-02-18 | Clinton | Missouri | 29049 | 1515 | 63 |
1038797 | 1038797 | 2021-02-17 | Clinton | Missouri | 29049 | 1512 | 61 |
1035552 | 1035552 | 2021-02-16 | Clinton | Missouri | 29049 | 1510 | 61 |
1032307 | 1032307 | 2021-02-15 | Clinton | Missouri | 29049 | 1511 | 61 |
1029060 | 1029060 | 2021-02-14 | Clinton | Missouri | 29049 | 1510 | 61 |
1025814 | 1025814 | 2021-02-13 | Clinton | Missouri | 29049 | 1509 | 61 |
1022569 | 1022569 | 2021-02-12 | Clinton | Missouri | 29049 | 1507 | 61 |
1019324 | 1019324 | 2021-02-11 | Clinton | Missouri | 29049 | 1504 | 61 |
1016079 | 1016079 | 2021-02-10 | Clinton | Missouri | 29049 | 1503 | 60 |
1012834 | 1012834 | 2021-02-09 | Clinton | Missouri | 29049 | 1502 | 60 |
1009589 | 1009589 | 2021-02-08 | Clinton | Missouri | 29049 | 1499 | 60 |
1006342 | 1006342 | 2021-02-07 | Clinton | Missouri | 29049 | 1497 | 60 |
1003096 | 1003096 | 2021-02-06 | Clinton | Missouri | 29049 | 1493 | 60 |
999851 | 999851 | 2021-02-05 | Clinton | Missouri | 29049 | 1489 | 60 |
996605 | 996605 | 2021-02-04 | Clinton | Missouri | 29049 | 1487 | 60 |
993359 | 993359 | 2021-02-03 | Clinton | Missouri | 29049 | 1478 | 60 |
990113 | 990113 | 2021-02-02 | Clinton | Missouri | 29049 | 1478 | 60 |
986866 | 986866 | 2021-02-01 | Clinton | Missouri | 29049 | 1479 | 60 |
983619 | 983619 | 2021-01-31 | Clinton | Missouri | 29049 | 1474 | 60 |
980373 | 980373 | 2021-01-30 | Clinton | Missouri | 29049 | 1468 | 60 |
977127 | 977127 | 2021-01-29 | Clinton | Missouri | 29049 | 1464 | 60 |
973882 | 973882 | 2021-01-28 | Clinton | Missouri | 29049 | 1460 | 60 |
970637 | 970637 | 2021-01-27 | Clinton | Missouri | 29049 | 1450 | 60 |
967392 | 967392 | 2021-01-26 | Clinton | Missouri | 29049 | 1450 | 60 |
964148 | 964148 | 2021-01-25 | Clinton | Missouri | 29049 | 1450 | 60 |
960903 | 960903 | 2021-01-24 | Clinton | Missouri | 29049 | 1445 | 60 |
957657 | 957657 | 2021-01-23 | Clinton | Missouri | 29049 | 1437 | 60 |
954412 | 954412 | 2021-01-22 | Clinton | Missouri | 29049 | 1433 | 60 |
951167 | 951167 | 2021-01-21 | Clinton | Missouri | 29049 | 1432 | 60 |
947921 | 947921 | 2021-01-20 | Clinton | Missouri | 29049 | 1426 | 60 |
944674 | 944674 | 2021-01-19 | Clinton | Missouri | 29049 | 1421 | 60 |
941429 | 941429 | 2021-01-18 | Clinton | Missouri | 29049 | 1419 | 60 |
938184 | 938184 | 2021-01-17 | Clinton | Missouri | 29049 | 1417 | 60 |
934939 | 934939 | 2021-01-16 | Clinton | Missouri | 29049 | 1412 | 60 |
931694 | 931694 | 2021-01-15 | Clinton | Missouri | 29049 | 1405 | 60 |
928449 | 928449 | 2021-01-14 | Clinton | Missouri | 29049 | 1392 | 60 |
925203 | 925203 | 2021-01-13 | Clinton | Missouri | 29049 | 1385 | 60 |
921958 | 921958 | 2021-01-12 | Clinton | Missouri | 29049 | 1381 | 60 |
918713 | 918713 | 2021-01-11 | Clinton | Missouri | 29049 | 1369 | 59 |
915468 | 915468 | 2021-01-10 | Clinton | Missouri | 29049 | 1366 | 59 |
912223 | 912223 | 2021-01-09 | Clinton | Missouri | 29049 | 1360 | 59 |
908978 | 908978 | 2021-01-08 | Clinton | Missouri | 29049 | 1348 | 59 |
905732 | 905732 | 2021-01-07 | Clinton | Missouri | 29049 | 1321 | 59 |
902487 | 902487 | 2021-01-06 | Clinton | Missouri | 29049 | 1302 | 59 |
899242 | 899242 | 2021-01-05 | Clinton | Missouri | 29049 | 1297 | 59 |
895997 | 895997 | 2021-01-04 | Clinton | Missouri | 29049 | 1295 | 56 |
892750 | 892750 | 2021-01-03 | Clinton | Missouri | 29049 | 1295 | 56 |
889504 | 889504 | 2021-01-02 | Clinton | Missouri | 29049 | 1281 | 56 |
886258 | 886258 | 2021-01-01 | Clinton | Missouri | 29049 | 1272 | 56 |
883013 | 883013 | 2020-12-31 | Clinton | Missouri | 29049 | 1248 | 56 |
879768 | 879768 | 2020-12-30 | Clinton | Missouri | 29049 | 1241 | 56 |
876523 | 876523 | 2020-12-29 | Clinton | Missouri | 29049 | 1223 | 56 |
873278 | 873278 | 2020-12-28 | Clinton | Missouri | 29049 | 1211 | 56 |
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);