ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 196 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
876593 | 876593 | 2020-12-29 | Schuyler | Missouri | 29197 | 196 | 1 |
873348 | 873348 | 2020-12-28 | Schuyler | Missouri | 29197 | 196 | 1 |
870096 | 870096 | 2020-12-27 | Putnam | Missouri | 29171 | 196 | 1 |
769502 | 769502 | 2020-11-26 | Shelby | Missouri | 29205 | 196 | 1 |
762915 | 762915 | 2020-11-24 | Atchison | Missouri | 29005 | 196 | 1 |
704566 | 704566 | 2020-11-06 | Linn | Missouri | 29115 | 196 | 7 |
691606 | 691606 | 2020-11-02 | Monroe | Missouri | 29137 | 196 | 2 |
642972 | 642972 | 2020-10-18 | Shannon | Missouri | 29203 | 196 | 3 |
629909 | 629909 | 2020-10-14 | Cedar | Missouri | 29039 | 196 | 3 |
613722 | 613722 | 2020-10-09 | Howard | Missouri | 29089 | 196 | 2 |
610480 | 610480 | 2020-10-08 | Howard | Missouri | 29089 | 196 | 2 |
571578 | 571578 | 2020-09-26 | Henry | Missouri | 29083 | 196 | 5 |
552127 | 552127 | 2020-09-20 | Clinton | Missouri | 29049 | 196 | 0 |
542478 | 542478 | 2020-09-17 | Randolph | Missouri | 29175 | 196 | 2 |
497170 | 497170 | 2020-09-03 | Moniteau | Missouri | 29135 | 196 | 4 |
455135 | 455135 | 2020-08-21 | Howell | Missouri | 29091 | 196 | 2 |
442288 | 442288 | 2020-08-17 | Stone | Missouri | 29209 | 196 | 1 |
403595 | 403595 | 2020-08-05 | Polk | Missouri | 29167 | 196 | 0 |
352140 | 352140 | 2020-07-20 | Cole | Missouri | 29051 | 196 | 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);