ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 29099 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418674 | 1418674 | 2021-06-14 | Jefferson | Missouri | 29099 | 23618 | 253 |
1415429 | 1415429 | 2021-06-13 | Jefferson | Missouri | 29099 | 23613 | 253 |
1412183 | 1412183 | 2021-06-12 | Jefferson | Missouri | 29099 | 23611 | 253 |
1408938 | 1408938 | 2021-06-11 | Jefferson | Missouri | 29099 | 23597 | 253 |
1405693 | 1405693 | 2021-06-10 | Jefferson | Missouri | 29099 | 23588 | 253 |
1402447 | 1402447 | 2021-06-09 | Jefferson | Missouri | 29099 | 23585 | 253 |
1399202 | 1399202 | 2021-06-08 | Jefferson | Missouri | 29099 | 23577 | 253 |
1395956 | 1395956 | 2021-06-07 | Jefferson | Missouri | 29099 | 23567 | 249 |
1392710 | 1392710 | 2021-06-06 | Jefferson | Missouri | 29099 | 23556 | 249 |
1389465 | 1389465 | 2021-06-05 | Jefferson | Missouri | 29099 | 23556 | 249 |
1386220 | 1386220 | 2021-06-04 | Jefferson | Missouri | 29099 | 23548 | 249 |
1382975 | 1382975 | 2021-06-03 | Jefferson | Missouri | 29099 | 23541 | 249 |
1379729 | 1379729 | 2021-06-02 | Jefferson | Missouri | 29099 | 23536 | 249 |
1376484 | 1376484 | 2021-06-01 | Jefferson | Missouri | 29099 | 23528 | 248 |
1373238 | 1373238 | 2021-05-31 | Jefferson | Missouri | 29099 | 23518 | 248 |
1369993 | 1369993 | 2021-05-30 | Jefferson | Missouri | 29099 | 23513 | 248 |
1366747 | 1366747 | 2021-05-29 | Jefferson | Missouri | 29099 | 23504 | 248 |
1363501 | 1363501 | 2021-05-28 | Jefferson | Missouri | 29099 | 23496 | 248 |
1360254 | 1360254 | 2021-05-27 | Jefferson | Missouri | 29099 | 23484 | 248 |
1357008 | 1357008 | 2021-05-26 | Jefferson | Missouri | 29099 | 23474 | 248 |
1353762 | 1353762 | 2021-05-25 | Jefferson | Missouri | 29099 | 23467 | 248 |
1350516 | 1350516 | 2021-05-24 | Jefferson | Missouri | 29099 | 23462 | 248 |
1347270 | 1347270 | 2021-05-23 | Jefferson | Missouri | 29099 | 23461 | 248 |
1344022 | 1344022 | 2021-05-22 | Jefferson | Missouri | 29099 | 23454 | 248 |
1340773 | 1340773 | 2021-05-21 | Jefferson | Missouri | 29099 | 23443 | 248 |
1337526 | 1337526 | 2021-05-20 | Jefferson | Missouri | 29099 | 23424 | 248 |
1334279 | 1334279 | 2021-05-19 | Jefferson | Missouri | 29099 | 23414 | 248 |
1331032 | 1331032 | 2021-05-18 | Jefferson | Missouri | 29099 | 23405 | 248 |
1327785 | 1327785 | 2021-05-17 | Jefferson | Missouri | 29099 | 23396 | 247 |
1324539 | 1324539 | 2021-05-16 | Jefferson | Missouri | 29099 | 23390 | 247 |
1321293 | 1321293 | 2021-05-15 | Jefferson | Missouri | 29099 | 23378 | 247 |
1318047 | 1318047 | 2021-05-14 | Jefferson | Missouri | 29099 | 23367 | 247 |
1314799 | 1314799 | 2021-05-13 | Jefferson | Missouri | 29099 | 23350 | 246 |
1311553 | 1311553 | 2021-05-12 | Jefferson | Missouri | 29099 | 23329 | 246 |
1308306 | 1308306 | 2021-05-11 | Jefferson | Missouri | 29099 | 23308 | 246 |
1305060 | 1305060 | 2021-05-10 | Jefferson | Missouri | 29099 | 23284 | 245 |
1301814 | 1301814 | 2021-05-09 | Jefferson | Missouri | 29099 | 23272 | 245 |
1298566 | 1298566 | 2021-05-08 | Jefferson | Missouri | 29099 | 23259 | 245 |
1295320 | 1295320 | 2021-05-07 | Jefferson | Missouri | 29099 | 23239 | 245 |
1292074 | 1292074 | 2021-05-06 | Jefferson | Missouri | 29099 | 23217 | 245 |
1288828 | 1288828 | 2021-05-05 | Jefferson | Missouri | 29099 | 23194 | 245 |
1285582 | 1285582 | 2021-05-04 | Jefferson | Missouri | 29099 | 23162 | 245 |
1282336 | 1282336 | 2021-05-03 | Jefferson | Missouri | 29099 | 23150 | 241 |
1279089 | 1279089 | 2021-05-02 | Jefferson | Missouri | 29099 | 23129 | 241 |
1275842 | 1275842 | 2021-05-01 | Jefferson | Missouri | 29099 | 23037 | 241 |
1272595 | 1272595 | 2021-04-30 | Jefferson | Missouri | 29099 | 22971 | 241 |
1269348 | 1269348 | 2021-04-29 | Jefferson | Missouri | 29099 | 22945 | 241 |
1266101 | 1266101 | 2021-04-28 | Jefferson | Missouri | 29099 | 22929 | 241 |
1262854 | 1262854 | 2021-04-27 | Jefferson | Missouri | 29099 | 22905 | 241 |
1259607 | 1259607 | 2021-04-26 | Jefferson | Missouri | 29099 | 22895 | 240 |
1256360 | 1256360 | 2021-04-25 | Jefferson | Missouri | 29099 | 22881 | 240 |
1253113 | 1253113 | 2021-04-24 | Jefferson | Missouri | 29099 | 22863 | 240 |
1249866 | 1249866 | 2021-04-23 | Jefferson | Missouri | 29099 | 22823 | 240 |
1246619 | 1246619 | 2021-04-22 | Jefferson | Missouri | 29099 | 22772 | 240 |
1243372 | 1243372 | 2021-04-21 | Jefferson | Missouri | 29099 | 22720 | 240 |
1240125 | 1240125 | 2021-04-20 | Jefferson | Missouri | 29099 | 22673 | 240 |
1236878 | 1236878 | 2021-04-19 | Jefferson | Missouri | 29099 | 22637 | 238 |
1233631 | 1233631 | 2021-04-18 | Jefferson | Missouri | 29099 | 22620 | 238 |
1230383 | 1230383 | 2021-04-17 | Jefferson | Missouri | 29099 | 22596 | 238 |
1227135 | 1227135 | 2021-04-16 | Jefferson | Missouri | 29099 | 22858 | 238 |
1223887 | 1223887 | 2021-04-15 | Jefferson | Missouri | 29099 | 22818 | 238 |
1220640 | 1220640 | 2021-04-14 | Jefferson | Missouri | 29099 | 22760 | 238 |
1217392 | 1217392 | 2021-04-13 | Jefferson | Missouri | 29099 | 22698 | 237 |
1214145 | 1214145 | 2021-04-12 | Jefferson | Missouri | 29099 | 22659 | 234 |
1210897 | 1210897 | 2021-04-11 | Jefferson | Missouri | 29099 | 22627 | 234 |
1207648 | 1207648 | 2021-04-10 | Jefferson | Missouri | 29099 | 22573 | 234 |
1204400 | 1204400 | 2021-04-09 | Jefferson | Missouri | 29099 | 22521 | 234 |
1201152 | 1201152 | 2021-04-08 | Jefferson | Missouri | 29099 | 22469 | 234 |
1197903 | 1197903 | 2021-04-07 | Jefferson | Missouri | 29099 | 22412 | 234 |
1194654 | 1194654 | 2021-04-06 | Jefferson | Missouri | 29099 | 22354 | 234 |
1191405 | 1191405 | 2021-04-05 | Jefferson | Missouri | 29099 | 22316 | 234 |
1188157 | 1188157 | 2021-04-04 | Jefferson | Missouri | 29099 | 22294 | 234 |
1184910 | 1184910 | 2021-04-03 | Jefferson | Missouri | 29099 | 22239 | 234 |
1181664 | 1181664 | 2021-04-02 | Jefferson | Missouri | 29099 | 22206 | 234 |
1178417 | 1178417 | 2021-04-01 | Jefferson | Missouri | 29099 | 22154 | 234 |
1175170 | 1175170 | 2021-03-31 | Jefferson | Missouri | 29099 | 22099 | 234 |
1171923 | 1171923 | 2021-03-30 | Jefferson | Missouri | 29099 | 22044 | 234 |
1168675 | 1168675 | 2021-03-29 | Jefferson | Missouri | 29099 | 22010 | 232 |
1165427 | 1165427 | 2021-03-28 | Jefferson | Missouri | 29099 | 21978 | 232 |
1162179 | 1162179 | 2021-03-27 | Jefferson | Missouri | 29099 | 21942 | 232 |
1158931 | 1158931 | 2021-03-26 | Jefferson | Missouri | 29099 | 21901 | 232 |
1155684 | 1155684 | 2021-03-25 | Jefferson | Missouri | 29099 | 21864 | 232 |
1152437 | 1152437 | 2021-03-24 | Jefferson | Missouri | 29099 | 21822 | 232 |
1149190 | 1149190 | 2021-03-23 | Jefferson | Missouri | 29099 | 21792 | 232 |
1145943 | 1145943 | 2021-03-22 | Jefferson | Missouri | 29099 | 21742 | 230 |
1142696 | 1142696 | 2021-03-21 | Jefferson | Missouri | 29099 | 21719 | 230 |
1139449 | 1139449 | 2021-03-20 | Jefferson | Missouri | 29099 | 21693 | 230 |
1136203 | 1136203 | 2021-03-19 | Jefferson | Missouri | 29099 | 21681 | 230 |
1132957 | 1132957 | 2021-03-18 | Jefferson | Missouri | 29099 | 21645 | 230 |
1129709 | 1129709 | 2021-03-17 | Jefferson | Missouri | 29099 | 21603 | 230 |
1126462 | 1126462 | 2021-03-16 | Jefferson | Missouri | 29099 | 21571 | 230 |
1123216 | 1123216 | 2021-03-15 | Jefferson | Missouri | 29099 | 21532 | 229 |
1119969 | 1119969 | 2021-03-14 | Jefferson | Missouri | 29099 | 21841 | 229 |
1116722 | 1116722 | 2021-03-13 | Jefferson | Missouri | 29099 | 21841 | 229 |
1113476 | 1113476 | 2021-03-12 | Jefferson | Missouri | 29099 | 21841 | 229 |
1110230 | 1110230 | 2021-03-11 | Jefferson | Missouri | 29099 | 21841 | 229 |
1106984 | 1106984 | 2021-03-10 | Jefferson | Missouri | 29099 | 21841 | 229 |
1103738 | 1103738 | 2021-03-09 | Jefferson | Missouri | 29099 | 21841 | 229 |
1100492 | 1100492 | 2021-03-08 | Jefferson | Missouri | 29099 | 21769 | 223 |
1097245 | 1097245 | 2021-03-07 | Jefferson | Missouri | 29099 | 21769 | 223 |
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);