ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29157 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279120 | 1279120 | 2021-05-02 | Perry | Missouri | 29157 | 2213 | 30 |
1275873 | 1275873 | 2021-05-01 | Perry | Missouri | 29157 | 2209 | 30 |
1272626 | 1272626 | 2021-04-30 | Perry | Missouri | 29157 | 2207 | 30 |
1269379 | 1269379 | 2021-04-29 | Perry | Missouri | 29157 | 2203 | 30 |
1266132 | 1266132 | 2021-04-28 | Perry | Missouri | 29157 | 2195 | 30 |
1262885 | 1262885 | 2021-04-27 | Perry | Missouri | 29157 | 2191 | 30 |
1259638 | 1259638 | 2021-04-26 | Perry | Missouri | 29157 | 2188 | 30 |
1256391 | 1256391 | 2021-04-25 | Perry | Missouri | 29157 | 2188 | 30 |
1253144 | 1253144 | 2021-04-24 | Perry | Missouri | 29157 | 2186 | 30 |
1249897 | 1249897 | 2021-04-23 | Perry | Missouri | 29157 | 2181 | 30 |
1246650 | 1246650 | 2021-04-22 | Perry | Missouri | 29157 | 2176 | 30 |
1243403 | 1243403 | 2021-04-21 | Perry | Missouri | 29157 | 2172 | 30 |
1240156 | 1240156 | 2021-04-20 | Perry | Missouri | 29157 | 2168 | 30 |
1236909 | 1236909 | 2021-04-19 | Perry | Missouri | 29157 | 2165 | 30 |
1233662 | 1233662 | 2021-04-18 | Perry | Missouri | 29157 | 2165 | 30 |
1230414 | 1230414 | 2021-04-17 | Perry | Missouri | 29157 | 2164 | 30 |
1227166 | 1227166 | 2021-04-16 | Perry | Missouri | 29157 | 2182 | 30 |
1223918 | 1223918 | 2021-04-15 | Perry | Missouri | 29157 | 2182 | 30 |
1220671 | 1220671 | 2021-04-14 | Perry | Missouri | 29157 | 2178 | 30 |
1217423 | 1217423 | 2021-04-13 | Perry | Missouri | 29157 | 2177 | 30 |
1214176 | 1214176 | 2021-04-12 | Perry | Missouri | 29157 | 2176 | 29 |
1210928 | 1210928 | 2021-04-11 | Perry | Missouri | 29157 | 2176 | 29 |
1207679 | 1207679 | 2021-04-10 | Perry | Missouri | 29157 | 2174 | 29 |
1204431 | 1204431 | 2021-04-09 | Perry | Missouri | 29157 | 2174 | 29 |
1201183 | 1201183 | 2021-04-08 | Perry | Missouri | 29157 | 2174 | 29 |
1197934 | 1197934 | 2021-04-07 | Perry | Missouri | 29157 | 2172 | 29 |
1194685 | 1194685 | 2021-04-06 | Perry | Missouri | 29157 | 2172 | 29 |
1191436 | 1191436 | 2021-04-05 | Perry | Missouri | 29157 | 2169 | 29 |
1188188 | 1188188 | 2021-04-04 | Perry | Missouri | 29157 | 2169 | 29 |
1184941 | 1184941 | 2021-04-03 | Perry | Missouri | 29157 | 2167 | 29 |
1181695 | 1181695 | 2021-04-02 | Perry | Missouri | 29157 | 2167 | 29 |
1178448 | 1178448 | 2021-04-01 | Perry | Missouri | 29157 | 2163 | 29 |
1175201 | 1175201 | 2021-03-31 | Perry | Missouri | 29157 | 2161 | 29 |
1171954 | 1171954 | 2021-03-30 | Perry | Missouri | 29157 | 2160 | 29 |
1168706 | 1168706 | 2021-03-29 | Perry | Missouri | 29157 | 2158 | 29 |
1165458 | 1165458 | 2021-03-28 | Perry | Missouri | 29157 | 2156 | 29 |
1162210 | 1162210 | 2021-03-27 | Perry | Missouri | 29157 | 2156 | 29 |
1158962 | 1158962 | 2021-03-26 | Perry | Missouri | 29157 | 2153 | 29 |
1155715 | 1155715 | 2021-03-25 | Perry | Missouri | 29157 | 2153 | 29 |
1152468 | 1152468 | 2021-03-24 | Perry | Missouri | 29157 | 2152 | 29 |
1149221 | 1149221 | 2021-03-23 | Perry | Missouri | 29157 | 2149 | 29 |
1145974 | 1145974 | 2021-03-22 | Perry | Missouri | 29157 | 2149 | 29 |
1142727 | 1142727 | 2021-03-21 | Perry | Missouri | 29157 | 2149 | 29 |
1139480 | 1139480 | 2021-03-20 | Perry | Missouri | 29157 | 2149 | 29 |
1136234 | 1136234 | 2021-03-19 | Perry | Missouri | 29157 | 2146 | 29 |
1132988 | 1132988 | 2021-03-18 | Perry | Missouri | 29157 | 2142 | 27 |
1129740 | 1129740 | 2021-03-17 | Perry | Missouri | 29157 | 2139 | 27 |
1126493 | 1126493 | 2021-03-16 | Perry | Missouri | 29157 | 2138 | 27 |
1123247 | 1123247 | 2021-03-15 | Perry | Missouri | 29157 | 2137 | 27 |
1120000 | 1120000 | 2021-03-14 | Perry | Missouri | 29157 | 2137 | 27 |
1116753 | 1116753 | 2021-03-13 | Perry | Missouri | 29157 | 2136 | 27 |
1113507 | 1113507 | 2021-03-12 | Perry | Missouri | 29157 | 2134 | 27 |
1110261 | 1110261 | 2021-03-11 | Perry | Missouri | 29157 | 2134 | 27 |
1107015 | 1107015 | 2021-03-10 | Perry | Missouri | 29157 | 2132 | 27 |
1103769 | 1103769 | 2021-03-09 | Perry | Missouri | 29157 | 2132 | 27 |
1100523 | 1100523 | 2021-03-08 | Perry | Missouri | 29157 | 2129 | 27 |
1097276 | 1097276 | 2021-03-07 | Perry | Missouri | 29157 | 2054 | 27 |
1094029 | 1094029 | 2021-03-06 | Perry | Missouri | 29157 | 2054 | 27 |
1090783 | 1090783 | 2021-03-05 | Perry | Missouri | 29157 | 2052 | 27 |
1087538 | 1087538 | 2021-03-04 | Perry | Missouri | 29157 | 2049 | 27 |
1084293 | 1084293 | 2021-03-03 | Perry | Missouri | 29157 | 2049 | 27 |
1081047 | 1081047 | 2021-03-02 | Perry | Missouri | 29157 | 2049 | 26 |
1077801 | 1077801 | 2021-03-01 | Perry | Missouri | 29157 | 2051 | 26 |
1074555 | 1074555 | 2021-02-28 | Perry | Missouri | 29157 | 2051 | 26 |
1071309 | 1071309 | 2021-02-27 | Perry | Missouri | 29157 | 2049 | 26 |
1068064 | 1068064 | 2021-02-26 | Perry | Missouri | 29157 | 2046 | 26 |
1064819 | 1064819 | 2021-02-25 | Perry | Missouri | 29157 | 2044 | 26 |
1061575 | 1061575 | 2021-02-24 | Perry | Missouri | 29157 | 2041 | 26 |
1058329 | 1058329 | 2021-02-23 | Perry | Missouri | 29157 | 2039 | 26 |
1055083 | 1055083 | 2021-02-22 | Perry | Missouri | 29157 | 2039 | 24 |
1051836 | 1051836 | 2021-02-21 | Perry | Missouri | 29157 | 2038 | 24 |
1048589 | 1048589 | 2021-02-20 | Perry | Missouri | 29157 | 2037 | 24 |
1045343 | 1045343 | 2021-02-19 | Perry | Missouri | 29157 | 2036 | 24 |
1042098 | 1042098 | 2021-02-18 | Perry | Missouri | 29157 | 2035 | 24 |
1038853 | 1038853 | 2021-02-17 | Perry | Missouri | 29157 | 2030 | 23 |
1035608 | 1035608 | 2021-02-16 | Perry | Missouri | 29157 | 2028 | 23 |
1032363 | 1032363 | 2021-02-15 | Perry | Missouri | 29157 | 2025 | 23 |
1029116 | 1029116 | 2021-02-14 | Perry | Missouri | 29157 | 2021 | 23 |
1025870 | 1025870 | 2021-02-13 | Perry | Missouri | 29157 | 2019 | 23 |
1022625 | 1022625 | 2021-02-12 | Perry | Missouri | 29157 | 2019 | 23 |
1019380 | 1019380 | 2021-02-11 | Perry | Missouri | 29157 | 2019 | 23 |
1016135 | 1016135 | 2021-02-10 | Perry | Missouri | 29157 | 2016 | 22 |
1012890 | 1012890 | 2021-02-09 | Perry | Missouri | 29157 | 2015 | 22 |
1009645 | 1009645 | 2021-02-08 | Perry | Missouri | 29157 | 2014 | 22 |
1006398 | 1006398 | 2021-02-07 | Perry | Missouri | 29157 | 2012 | 22 |
1003152 | 1003152 | 2021-02-06 | Perry | Missouri | 29157 | 2011 | 22 |
999907 | 999907 | 2021-02-05 | Perry | Missouri | 29157 | 2010 | 22 |
996661 | 996661 | 2021-02-04 | Perry | Missouri | 29157 | 2007 | 22 |
993415 | 993415 | 2021-02-03 | Perry | Missouri | 29157 | 2003 | 22 |
990169 | 990169 | 2021-02-02 | Perry | Missouri | 29157 | 1997 | 22 |
986922 | 986922 | 2021-02-01 | Perry | Missouri | 29157 | 1994 | 22 |
983675 | 983675 | 2021-01-31 | Perry | Missouri | 29157 | 1992 | 22 |
980429 | 980429 | 2021-01-30 | Perry | Missouri | 29157 | 1992 | 22 |
977183 | 977183 | 2021-01-29 | Perry | Missouri | 29157 | 1991 | 22 |
973938 | 973938 | 2021-01-28 | Perry | Missouri | 29157 | 1990 | 22 |
970693 | 970693 | 2021-01-27 | Perry | Missouri | 29157 | 1983 | 22 |
967448 | 967448 | 2021-01-26 | Perry | Missouri | 29157 | 1982 | 22 |
964204 | 964204 | 2021-01-25 | Perry | Missouri | 29157 | 1979 | 22 |
960959 | 960959 | 2021-01-24 | Perry | Missouri | 29157 | 1974 | 22 |
957713 | 957713 | 2021-01-23 | Perry | Missouri | 29157 | 1974 | 22 |
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);