ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 667 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2211571 | 2211571 | 2022-02-13 | Scotland | Missouri | 29199 | 667 | 17 |
2208318 | 2208318 | 2022-02-12 | Scotland | Missouri | 29199 | 667 | 17 |
2205065 | 2205065 | 2022-02-11 | Scotland | Missouri | 29199 | 667 | 17 |
2201812 | 2201812 | 2022-02-10 | Scotland | Missouri | 29199 | 667 | 17 |
2175787 | 2175787 | 2022-02-02 | Schuyler | Missouri | 29197 | 667 | 24 |
2013159 | 2013159 | 2021-12-14 | Knox | Missouri | 29103 | 667 | 8 |
1535585 | 1535585 | 2021-07-20 | Shannon | Missouri | 29203 | 667 | 12 |
1441426 | 1441426 | 2021-06-21 | Ozark | Missouri | 29153 | 667 | 21 |
1428405 | 1428405 | 2021-06-17 | Hickory | Missouri | 29085 | 667 | 15 |
1402496 | 1402496 | 2021-06-09 | Shelby | Missouri | 29205 | 667 | 7 |
1399251 | 1399251 | 2021-06-08 | Shelby | Missouri | 29205 | 667 | 7 |
1396005 | 1396005 | 2021-06-07 | Shelby | Missouri | 29205 | 667 | 7 |
1392759 | 1392759 | 2021-06-06 | Shelby | Missouri | 29205 | 667 | 7 |
1389514 | 1389514 | 2021-06-05 | Shelby | Missouri | 29205 | 667 | 7 |
1253084 | 1253084 | 2021-04-24 | Chariton | Missouri | 29041 | 667 | 7 |
1175141 | 1175141 | 2021-03-31 | Chariton | Missouri | 29041 | 667 | 6 |
1107013 | 1107013 | 2021-03-10 | Ozark | Missouri | 29153 | 667 | 16 |
1103767 | 1103767 | 2021-03-09 | Ozark | Missouri | 29153 | 667 | 16 |
1100521 | 1100521 | 2021-03-08 | Ozark | Missouri | 29153 | 667 | 16 |
1055022 | 1055022 | 2021-02-22 | Cedar | Missouri | 29039 | 667 | 17 |
889496 | 889496 | 2021-01-02 | Carroll | Missouri | 29033 | 667 | 18 |
886322 | 886322 | 2021-01-01 | Ralls | Missouri | 29173 | 667 | 7 |
879780 | 879780 | 2020-12-30 | Gasconade | Missouri | 29073 | 667 | 29 |
720749 | 720749 | 2020-11-11 | Clinton | Missouri | 29049 | 667 | 33 |
672187 | 672187 | 2020-10-27 | Washington | Missouri | 29221 | 667 | 18 |
642954 | 642954 | 2020-10-18 | Pemiscot | Missouri | 29155 | 667 | 12 |
633208 | 633208 | 2020-10-15 | New Madrid | Missouri | 29143 | 667 | 17 |
393881 | 393881 | 2020-08-02 | Cass | Missouri | 29037 | 667 | 12 |
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);