ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 29189 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194707 | 1194707 | 2021-04-06 | St. Louis | Missouri | 29189 | 93620 | 2105 |
1191458 | 1191458 | 2021-04-05 | St. Louis | Missouri | 29189 | 93430 | 2103 |
1188210 | 1188210 | 2021-04-04 | St. Louis | Missouri | 29189 | 93344 | 2103 |
1184963 | 1184963 | 2021-04-03 | St. Louis | Missouri | 29189 | 93187 | 2103 |
1181717 | 1181717 | 2021-04-02 | St. Louis | Missouri | 29189 | 93062 | 2102 |
1178470 | 1178470 | 2021-04-01 | St. Louis | Missouri | 29189 | 92892 | 2102 |
1175223 | 1175223 | 2021-03-31 | St. Louis | Missouri | 29189 | 92739 | 2099 |
1171976 | 1171976 | 2021-03-30 | St. Louis | Missouri | 29189 | 92570 | 2097 |
1168728 | 1168728 | 2021-03-29 | St. Louis | Missouri | 29189 | 92390 | 2082 |
1165480 | 1165480 | 2021-03-28 | St. Louis | Missouri | 29189 | 92298 | 2082 |
1162232 | 1162232 | 2021-03-27 | St. Louis | Missouri | 29189 | 92216 | 2082 |
1158984 | 1158984 | 2021-03-26 | St. Louis | Missouri | 29189 | 92086 | 2082 |
1155737 | 1155737 | 2021-03-25 | St. Louis | Missouri | 29189 | 91903 | 2081 |
1152490 | 1152490 | 2021-03-24 | St. Louis | Missouri | 29189 | 91760 | 2079 |
1149243 | 1149243 | 2021-03-23 | St. Louis | Missouri | 29189 | 91506 | 2075 |
1145996 | 1145996 | 2021-03-22 | St. Louis | Missouri | 29189 | 91426 | 2063 |
1142749 | 1142749 | 2021-03-21 | St. Louis | Missouri | 29189 | 91314 | 2063 |
1139502 | 1139502 | 2021-03-20 | St. Louis | Missouri | 29189 | 91224 | 2063 |
1136256 | 1136256 | 2021-03-19 | St. Louis | Missouri | 29189 | 91086 | 2062 |
1133010 | 1133010 | 2021-03-18 | St. Louis | Missouri | 29189 | 90956 | 2062 |
1129762 | 1129762 | 2021-03-17 | St. Louis | Missouri | 29189 | 90819 | 2062 |
1126515 | 1126515 | 2021-03-16 | St. Louis | Missouri | 29189 | 90641 | 2062 |
1123269 | 1123269 | 2021-03-15 | St. Louis | Missouri | 29189 | 90479 | 2059 |
1120022 | 1120022 | 2021-03-14 | St. Louis | Missouri | 29189 | 90398 | 2059 |
1116775 | 1116775 | 2021-03-13 | St. Louis | Missouri | 29189 | 90287 | 2059 |
1113529 | 1113529 | 2021-03-12 | St. Louis | Missouri | 29189 | 90113 | 2057 |
1110283 | 1110283 | 2021-03-11 | St. Louis | Missouri | 29189 | 89929 | 2055 |
1107037 | 1107037 | 2021-03-10 | St. Louis | Missouri | 29189 | 89767 | 2044 |
1103791 | 1103791 | 2021-03-09 | St. Louis | Missouri | 29189 | 89599 | 2039 |
1100545 | 1100545 | 2021-03-08 | St. Louis | Missouri | 29189 | 89452 | 2019 |
1097298 | 1097298 | 2021-03-07 | St. Louis | Missouri | 29189 | 89373 | 2019 |
1094051 | 1094051 | 2021-03-06 | St. Louis | Missouri | 29189 | 89278 | 2019 |
1090805 | 1090805 | 2021-03-05 | St. Louis | Missouri | 29189 | 89030 | 2018 |
1087560 | 1087560 | 2021-03-04 | St. Louis | Missouri | 29189 | 88954 | 2012 |
1084315 | 1084315 | 2021-03-03 | St. Louis | Missouri | 29189 | 88778 | 2007 |
1081069 | 1081069 | 2021-03-02 | St. Louis | Missouri | 29189 | 88643 | 1974 |
1077823 | 1077823 | 2021-03-01 | St. Louis | Missouri | 29189 | 88485 | 1970 |
1074577 | 1074577 | 2021-02-28 | St. Louis | Missouri | 29189 | 88419 | 1970 |
1071331 | 1071331 | 2021-02-27 | St. Louis | Missouri | 29189 | 88294 | 1969 |
1068086 | 1068086 | 2021-02-26 | St. Louis | Missouri | 29189 | 88203 | 1965 |
1064841 | 1064841 | 2021-02-25 | St. Louis | Missouri | 29189 | 88027 | 1960 |
1061597 | 1061597 | 2021-02-24 | St. Louis | Missouri | 29189 | 87931 | 1940 |
1058351 | 1058351 | 2021-02-23 | St. Louis | Missouri | 29189 | 87744 | 1932 |
1055105 | 1055105 | 2021-02-22 | St. Louis | Missouri | 29189 | 87557 | 1917 |
1051858 | 1051858 | 2021-02-21 | St. Louis | Missouri | 29189 | 87465 | 1917 |
1048611 | 1048611 | 2021-02-20 | St. Louis | Missouri | 29189 | 87345 | 1917 |
1045365 | 1045365 | 2021-02-19 | St. Louis | Missouri | 29189 | 87177 | 1915 |
1042120 | 1042120 | 2021-02-18 | St. Louis | Missouri | 29189 | 86981 | 1881 |
1038875 | 1038875 | 2021-02-17 | St. Louis | Missouri | 29189 | 86846 | 1873 |
1035630 | 1035630 | 2021-02-16 | St. Louis | Missouri | 29189 | 86694 | 1852 |
1032385 | 1032385 | 2021-02-15 | St. Louis | Missouri | 29189 | 86575 | 1851 |
1029138 | 1029138 | 2021-02-14 | St. Louis | Missouri | 29189 | 86487 | 1851 |
1025892 | 1025892 | 2021-02-13 | St. Louis | Missouri | 29189 | 86374 | 1851 |
1022647 | 1022647 | 2021-02-12 | St. Louis | Missouri | 29189 | 86196 | 1831 |
1019402 | 1019402 | 2021-02-11 | St. Louis | Missouri | 29189 | 85990 | 1810 |
1016157 | 1016157 | 2021-02-10 | St. Louis | Missouri | 29189 | 85740 | 1776 |
1012912 | 1012912 | 2021-02-09 | St. Louis | Missouri | 29189 | 85342 | 1776 |
1009667 | 1009667 | 2021-02-08 | St. Louis | Missouri | 29189 | 85265 | 1773 |
1006420 | 1006420 | 2021-02-07 | St. Louis | Missouri | 29189 | 85160 | 1773 |
1003174 | 1003174 | 2021-02-06 | St. Louis | Missouri | 29189 | 85062 | 1773 |
999929 | 999929 | 2021-02-05 | St. Louis | Missouri | 29189 | 84861 | 1770 |
996683 | 996683 | 2021-02-04 | St. Louis | Missouri | 29189 | 84532 | 1769 |
993437 | 993437 | 2021-02-03 | St. Louis | Missouri | 29189 | 84254 | 1764 |
990191 | 990191 | 2021-02-02 | St. Louis | Missouri | 29189 | 84001 | 1705 |
986944 | 986944 | 2021-02-01 | St. Louis | Missouri | 29189 | 83642 | 1689 |
983697 | 983697 | 2021-01-31 | St. Louis | Missouri | 29189 | 83508 | 1686 |
980451 | 980451 | 2021-01-30 | St. Louis | Missouri | 29189 | 83346 | 1686 |
977205 | 977205 | 2021-01-29 | St. Louis | Missouri | 29189 | 83094 | 1681 |
973960 | 973960 | 2021-01-28 | St. Louis | Missouri | 29189 | 82831 | 1675 |
970715 | 970715 | 2021-01-27 | St. Louis | Missouri | 29189 | 82071 | 1664 |
967470 | 967470 | 2021-01-26 | St. Louis | Missouri | 29189 | 81758 | 1655 |
964226 | 964226 | 2021-01-25 | St. Louis | Missouri | 29189 | 81279 | 1628 |
960981 | 960981 | 2021-01-24 | St. Louis | Missouri | 29189 | 81147 | 1628 |
957735 | 957735 | 2021-01-23 | St. Louis | Missouri | 29189 | 80771 | 1628 |
954490 | 954490 | 2021-01-22 | St. Louis | Missouri | 29189 | 80285 | 1620 |
951245 | 951245 | 2021-01-21 | St. Louis | Missouri | 29189 | 79875 | 1619 |
947999 | 947999 | 2021-01-20 | St. Louis | Missouri | 29189 | 79512 | 1604 |
944752 | 944752 | 2021-01-19 | St. Louis | Missouri | 29189 | 79030 | 1564 |
941507 | 941507 | 2021-01-18 | St. Louis | Missouri | 29189 | 78781 | 1563 |
938262 | 938262 | 2021-01-17 | St. Louis | Missouri | 29189 | 78438 | 1563 |
935017 | 935017 | 2021-01-16 | St. Louis | Missouri | 29189 | 78024 | 1563 |
931772 | 931772 | 2021-01-15 | St. Louis | Missouri | 29189 | 77487 | 1554 |
928527 | 928527 | 2021-01-14 | St. Louis | Missouri | 29189 | 77057 | 1547 |
925281 | 925281 | 2021-01-13 | St. Louis | Missouri | 29189 | 76601 | 1530 |
922036 | 922036 | 2021-01-12 | St. Louis | Missouri | 29189 | 76107 | 1514 |
918791 | 918791 | 2021-01-11 | St. Louis | Missouri | 29189 | 75623 | 1476 |
915546 | 915546 | 2021-01-10 | St. Louis | Missouri | 29189 | 75200 | 1475 |
912301 | 912301 | 2021-01-09 | St. Louis | Missouri | 29189 | 74745 | 1475 |
909056 | 909056 | 2021-01-08 | St. Louis | Missouri | 29189 | 73847 | 1466 |
905810 | 905810 | 2021-01-07 | St. Louis | Missouri | 29189 | 73293 | 1456 |
902565 | 902565 | 2021-01-06 | St. Louis | Missouri | 29189 | 71901 | 1408 |
899320 | 899320 | 2021-01-05 | St. Louis | Missouri | 29189 | 71901 | 1406 |
896075 | 896075 | 2021-01-04 | St. Louis | Missouri | 29189 | 71447 | 1392 |
892828 | 892828 | 2021-01-03 | St. Louis | Missouri | 29189 | 70999 | 1392 |
889582 | 889582 | 2021-01-02 | St. Louis | Missouri | 29189 | 70402 | 1392 |
886336 | 886336 | 2021-01-01 | St. Louis | Missouri | 29189 | 69480 | 1391 |
883091 | 883091 | 2020-12-31 | St. Louis | Missouri | 29189 | 69480 | 1391 |
879846 | 879846 | 2020-12-30 | St. Louis | Missouri | 29189 | 68821 | 1384 |
876601 | 876601 | 2020-12-29 | St. Louis | Missouri | 29189 | 68226 | 1356 |
873356 | 873356 | 2020-12-28 | St. Louis | Missouri | 29189 | 67459 | 1342 |
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);