ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 640 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175759 | 2175759 | 2022-02-02 | Mercer | Missouri | 29129 | 640 | 12 |
1360268 | 1360268 | 2021-05-27 | Maries | Missouri | 29125 | 640 | 8 |
1357022 | 1357022 | 2021-05-26 | Maries | Missouri | 29125 | 640 | 8 |
1353776 | 1353776 | 2021-05-25 | Maries | Missouri | 29125 | 640 | 8 |
1350530 | 1350530 | 2021-05-24 | Maries | Missouri | 29125 | 640 | 8 |
1347284 | 1347284 | 2021-05-23 | Maries | Missouri | 29125 | 640 | 8 |
1344036 | 1344036 | 2021-05-22 | Maries | Missouri | 29125 | 640 | 8 |
1340787 | 1340787 | 2021-05-21 | Maries | Missouri | 29125 | 640 | 8 |
1337540 | 1337540 | 2021-05-20 | Maries | Missouri | 29125 | 640 | 8 |
1334293 | 1334293 | 2021-05-19 | Maries | Missouri | 29125 | 640 | 8 |
1262847 | 1262847 | 2021-04-27 | Hickory | Missouri | 29085 | 640 | 15 |
1259600 | 1259600 | 2021-04-26 | Hickory | Missouri | 29085 | 640 | 15 |
1256353 | 1256353 | 2021-04-25 | Hickory | Missouri | 29085 | 640 | 15 |
1253106 | 1253106 | 2021-04-24 | Hickory | Missouri | 29085 | 640 | 15 |
1249859 | 1249859 | 2021-04-23 | Hickory | Missouri | 29085 | 640 | 15 |
1246612 | 1246612 | 2021-04-22 | Hickory | Missouri | 29085 | 640 | 15 |
1243365 | 1243365 | 2021-04-21 | Hickory | Missouri | 29085 | 640 | 15 |
1240118 | 1240118 | 2021-04-20 | Hickory | Missouri | 29085 | 640 | 15 |
1132950 | 1132950 | 2021-03-18 | Hickory | Missouri | 29085 | 640 | 14 |
1129702 | 1129702 | 2021-03-17 | Hickory | Missouri | 29085 | 640 | 14 |
1126455 | 1126455 | 2021-03-16 | Hickory | Missouri | 29085 | 640 | 14 |
1123209 | 1123209 | 2021-03-15 | Hickory | Missouri | 29085 | 640 | 14 |
1119962 | 1119962 | 2021-03-14 | Hickory | Missouri | 29085 | 640 | 14 |
1116715 | 1116715 | 2021-03-13 | Hickory | Missouri | 29085 | 640 | 14 |
1113469 | 1113469 | 2021-03-12 | Hickory | Missouri | 29085 | 640 | 14 |
1110223 | 1110223 | 2021-03-11 | Hickory | Missouri | 29085 | 640 | 14 |
1106977 | 1106977 | 2021-03-10 | Hickory | Missouri | 29085 | 640 | 14 |
1103731 | 1103731 | 2021-03-09 | Hickory | Missouri | 29085 | 640 | 14 |
1061507 | 1061507 | 2021-02-24 | Caldwell | Missouri | 29025 | 640 | 10 |
1058261 | 1058261 | 2021-02-23 | Caldwell | Missouri | 29025 | 640 | 10 |
928453 | 928453 | 2021-01-14 | Dade | Missouri | 29057 | 640 | 30 |
925207 | 925207 | 2021-01-13 | Dade | Missouri | 29057 | 640 | 30 |
921962 | 921962 | 2021-01-12 | Dade | Missouri | 29057 | 640 | 30 |
918717 | 918717 | 2021-01-11 | Dade | Missouri | 29057 | 640 | 30 |
860387 | 860387 | 2020-12-24 | Wayne | Missouri | 29223 | 640 | 6 |
801885 | 801885 | 2020-12-06 | DeKalb | Missouri | 29063 | 640 | 15 |
633214 | 633214 | 2020-10-15 | Pemiscot | Missouri | 29155 | 640 | 11 |
568306 | 568306 | 2020-09-25 | Butler | Missouri | 29023 | 640 | 6 |
455141 | 455141 | 2020-08-21 | Joplin | Missouri | 640 | 21 | |
276023 | 276023 | 2020-06-26 | McDonald | Missouri | 29119 | 640 | 1 |
179942 | 179942 | 2020-05-26 | Buchanan | Missouri | 29021 | 640 | 2 |
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);