ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 75 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
788989 | 788989 | 2020-12-02 | Worth | Missouri | 29227 | 75 | 0 |
691556 | 691556 | 2020-11-02 | Chariton | Missouri | 29041 | 75 | 0 |
688311 | 688311 | 2020-11-01 | Chariton | Missouri | 29041 | 75 | 0 |
662346 | 662346 | 2020-10-24 | Atchison | Missouri | 29005 | 75 | 1 |
659102 | 659102 | 2020-10-23 | Atchison | Missouri | 29005 | 75 | 1 |
587771 | 587771 | 2020-10-01 | Dade | Missouri | 29057 | 75 | 0 |
568338 | 568338 | 2020-09-25 | Holt | Missouri | 29087 | 75 | 1 |
565098 | 565098 | 2020-09-24 | Holt | Missouri | 29087 | 75 | 1 |
565118 | 565118 | 2020-09-24 | Maries | Missouri | 29125 | 75 | 0 |
561858 | 561858 | 2020-09-23 | Holt | Missouri | 29087 | 75 | 1 |
558621 | 558621 | 2020-09-22 | Holt | Missouri | 29087 | 75 | 0 |
555384 | 555384 | 2020-09-21 | Holt | Missouri | 29087 | 75 | 0 |
555398 | 555398 | 2020-09-21 | Lewis | Missouri | 29111 | 75 | 2 |
552146 | 552146 | 2020-09-20 | Holt | Missouri | 29087 | 75 | 0 |
548907 | 548907 | 2020-09-19 | Holt | Missouri | 29087 | 75 | 0 |
545697 | 545697 | 2020-09-18 | Montgomery | Missouri | 29139 | 75 | 1 |
545723 | 545723 | 2020-09-18 | Shannon | Missouri | 29203 | 75 | 1 |
542460 | 542460 | 2020-09-17 | Montgomery | Missouri | 29139 | 75 | 1 |
526285 | 526285 | 2020-09-12 | Oregon | Missouri | 29149 | 75 | 0 |
523051 | 523051 | 2020-09-11 | Ozark | Missouri | 29153 | 75 | 0 |
503639 | 503639 | 2020-09-05 | Monroe | Missouri | 29137 | 75 | 0 |
500366 | 500366 | 2020-09-04 | DeKalb | Missouri | 29063 | 75 | 1 |
480993 | 480993 | 2020-08-29 | Macon | Missouri | 29121 | 75 | 0 |
477761 | 477761 | 2020-08-28 | Macon | Missouri | 29121 | 75 | 0 |
477777 | 477777 | 2020-08-28 | Osage | Missouri | 29151 | 75 | 1 |
474544 | 474544 | 2020-08-27 | Osage | Missouri | 29151 | 75 | 1 |
455199 | 455199 | 2020-08-21 | Texas | Missouri | 29215 | 75 | 1 |
451867 | 451867 | 2020-08-20 | Barton | Missouri | 29011 | 75 | 0 |
448678 | 448678 | 2020-08-19 | Howard | Missouri | 29089 | 75 | 0 |
445512 | 445512 | 2020-08-18 | Ste. Genevieve | Missouri | 29186 | 75 | 1 |
439047 | 439047 | 2020-08-16 | Ripley | Missouri | 29181 | 75 | 0 |
435759 | 435759 | 2020-08-15 | Dallas | Missouri | 29059 | 75 | 1 |
429366 | 429366 | 2020-08-13 | Randolph | Missouri | 29175 | 75 | 1 |
426061 | 426061 | 2020-08-12 | Bollinger | Missouri | 29017 | 75 | 1 |
400300 | 400300 | 2020-08-04 | Benton | Missouri | 29015 | 75 | 1 |
397086 | 397086 | 2020-08-03 | Benton | Missouri | 29015 | 75 | 1 |
393945 | 393945 | 2020-08-02 | Phelps | Missouri | 29161 | 75 | 0 |
390728 | 390728 | 2020-08-01 | Phelps | Missouri | 29161 | 75 | 0 |
374564 | 374564 | 2020-07-27 | Andrew | Missouri | 29003 | 75 | 1 |
364996 | 364996 | 2020-07-24 | Marion | Missouri | 29127 | 75 | 1 |
282266 | 282266 | 2020-06-28 | Butler | Missouri | 29023 | 75 | 0 |
279118 | 279118 | 2020-06-27 | Butler | Missouri | 29023 | 75 | 0 |
275970 | 275970 | 2020-06-26 | Butler | Missouri | 29023 | 75 | 0 |
247883 | 247883 | 2020-06-17 | Mississippi | Missouri | 29133 | 75 | 0 |
244770 | 244770 | 2020-06-16 | Mississippi | Missouri | 29133 | 75 | 0 |
232271 | 232271 | 2020-06-12 | Adair | Missouri | 29001 | 75 | 0 |
226140 | 226140 | 2020-06-10 | Perry | Missouri | 29157 | 75 | 0 |
223041 | 223041 | 2020-06-09 | Perry | Missouri | 29157 | 75 | 0 |
204524 | 204524 | 2020-06-03 | Platte | Missouri | 29165 | 75 | 2 |
201419 | 201419 | 2020-06-02 | Lafayette | Missouri | 29107 | 75 | 2 |
158692 | 158692 | 2020-05-19 | Cass | Missouri | 29037 | 75 | 8 |
155674 | 155674 | 2020-05-18 | Cass | Missouri | 29037 | 75 | 8 |
128717 | 128717 | 2020-05-09 | Lincoln | Missouri | 29113 | 75 | 1 |
116846 | 116846 | 2020-05-05 | Scott | Missouri | 29201 | 75 | 2 |
49770 | 49770 | 2020-04-11 | Franklin | Missouri | 29071 | 75 | 3 |
31960 | 31960 | 2020-04-04 | Boone | Missouri | 29019 | 75 | 1 |
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);