ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 400 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1733730 | 1733730 | 2021-09-19 | Schuyler | Missouri | 29197 | 400 | 7 |
1730480 | 1730480 | 2021-09-18 | Schuyler | Missouri | 29197 | 400 | 7 |
1727230 | 1727230 | 2021-09-17 | Schuyler | Missouri | 29197 | 400 | 7 |
1723953 | 1723953 | 2021-09-16 | Mercer | Missouri | 29129 | 400 | 3 |
1723981 | 1723981 | 2021-09-16 | Schuyler | Missouri | 29197 | 400 | 7 |
1581008 | 1581008 | 2021-08-03 | Knox | Missouri | 29103 | 400 | 3 |
1577759 | 1577759 | 2021-08-02 | Knox | Missouri | 29103 | 400 | 3 |
1574511 | 1574511 | 2021-08-01 | Knox | Missouri | 29103 | 400 | 3 |
970633 | 970633 | 2021-01-27 | Chariton | Missouri | 29041 | 400 | 3 |
967388 | 967388 | 2021-01-26 | Chariton | Missouri | 29041 | 400 | 3 |
928447 | 928447 | 2021-01-14 | Clark | Missouri | 29045 | 400 | 5 |
925196 | 925196 | 2021-01-13 | Carter | Missouri | 29035 | 400 | 7 |
921951 | 921951 | 2021-01-12 | Carter | Missouri | 29035 | 400 | 7 |
857126 | 857126 | 2020-12-23 | Shannon | Missouri | 29203 | 400 | 9 |
808407 | 808407 | 2020-12-08 | Maries | Missouri | 29125 | 400 | 4 |
759696 | 759696 | 2020-11-23 | Dade | Missouri | 29057 | 400 | 26 |
753263 | 753263 | 2020-11-21 | Ralls | Missouri | 29173 | 400 | 1 |
610436 | 610436 | 2020-10-08 | Adair | Missouri | 29001 | 400 | 0 |
555447 | 555447 | 2020-09-21 | Stone | Missouri | 29209 | 400 | 4 |
493954 | 493954 | 2020-09-02 | Pulaski | Missouri | 29169 | 400 | 2 |
419705 | 419705 | 2020-08-10 | Scott | Missouri | 29201 | 400 | 13 |
339333 | 339333 | 2020-07-16 | Cape Girardeau | Missouri | 29031 | 400 | 3 |
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);