ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 83 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
798724 | 798724 | 2020-12-05 | Worth | Missouri | 29227 | 83 | 0 |
775960 | 775960 | 2020-11-28 | Mercer | Missouri | 29129 | 83 | 1 |
772715 | 772715 | 2020-11-27 | Mercer | Missouri | 29129 | 83 | 1 |
769470 | 769470 | 2020-11-26 | Mercer | Missouri | 29129 | 83 | 1 |
724055 | 724055 | 2020-11-12 | Putnam | Missouri | 29171 | 83 | 1 |
711088 | 711088 | 2020-11-08 | Schuyler | Missouri | 29197 | 83 | 0 |
675409 | 675409 | 2020-10-28 | Reynolds | Missouri | 29179 | 83 | 1 |
603979 | 603979 | 2020-10-06 | Dade | Missouri | 29057 | 83 | 0 |
600737 | 600737 | 2020-10-05 | Dade | Missouri | 29057 | 83 | 0 |
591027 | 591027 | 2020-10-02 | Holt | Missouri | 29087 | 83 | 1 |
574839 | 574839 | 2020-09-27 | Linn | Missouri | 29115 | 83 | 1 |
571600 | 571600 | 2020-09-26 | Maries | Missouri | 29125 | 83 | 0 |
568366 | 568366 | 2020-09-25 | Montgomery | Missouri | 29139 | 83 | 1 |
558595 | 558595 | 2020-09-22 | Carter | Missouri | 29035 | 83 | 1 |
558649 | 558649 | 2020-09-22 | Montgomery | Missouri | 29139 | 83 | 1 |
548894 | 548894 | 2020-09-19 | Daviess | Missouri | 29061 | 83 | 0 |
539229 | 539229 | 2020-09-16 | Oregon | Missouri | 29149 | 83 | 0 |
532687 | 532687 | 2020-09-14 | Bates | Missouri | 29013 | 83 | 1 |
490744 | 490744 | 2020-09-01 | Vernon | Missouri | 29217 | 83 | 0 |
468097 | 468097 | 2020-08-25 | Ripley | Missouri | 29181 | 83 | 0 |
464781 | 464781 | 2020-08-24 | Barton | Missouri | 29011 | 83 | 0 |
464868 | 464868 | 2020-08-24 | Ripley | Missouri | 29181 | 83 | 0 |
448663 | 448663 | 2020-08-19 | Dallas | Missouri | 29059 | 83 | 1 |
426080 | 426080 | 2020-08-12 | Crawford | Missouri | 29055 | 83 | 0 |
419681 | 419681 | 2020-08-10 | Morgan | Missouri | 29141 | 83 | 0 |
416425 | 416425 | 2020-08-09 | Gentry | Missouri | 29075 | 83 | 9 |
413201 | 413201 | 2020-08-08 | Douglas | Missouri | 29067 | 83 | 2 |
413205 | 413205 | 2020-08-08 | Gentry | Missouri | 29075 | 83 | 9 |
409981 | 409981 | 2020-08-07 | Douglas | Missouri | 29067 | 83 | 2 |
409985 | 409985 | 2020-08-07 | Gentry | Missouri | 29075 | 83 | 9 |
406765 | 406765 | 2020-08-06 | Gentry | Missouri | 29075 | 83 | 9 |
403543 | 403543 | 2020-08-05 | Douglas | Missouri | 29067 | 83 | 2 |
400326 | 400326 | 2020-08-04 | Douglas | Missouri | 29067 | 83 | 2 |
390647 | 390647 | 2020-08-01 | Andrew | Missouri | 29003 | 83 | 1 |
358533 | 358533 | 2020-07-22 | Callaway | Missouri | 29027 | 83 | 1 |
323387 | 323387 | 2020-07-11 | Camden | Missouri | 29029 | 83 | 2 |
301283 | 301283 | 2020-07-04 | Taney | Missouri | 29213 | 83 | 2 |
241593 | 241593 | 2020-06-15 | Adair | Missouri | 29001 | 83 | 0 |
229219 | 229219 | 2020-06-11 | Lafayette | Missouri | 29107 | 83 | 2 |
226116 | 226116 | 2020-06-10 | Lafayette | Missouri | 29107 | 83 | 2 |
223017 | 223017 | 2020-06-09 | Lafayette | Missouri | 29107 | 83 | 2 |
210622 | 210622 | 2020-06-05 | Cape Girardeau | Missouri | 29031 | 83 | 3 |
195298 | 195298 | 2020-05-31 | Pemiscot | Missouri | 29155 | 83 | 4 |
182996 | 182996 | 2020-05-27 | Cass | Missouri | 29037 | 83 | 8 |
140715 | 140715 | 2020-05-13 | Scott | Missouri | 29201 | 83 | 6 |
99588 | 99588 | 2020-04-29 | Greene | Missouri | 29077 | 83 | 8 |
93906 | 93906 | 2020-04-27 | Greene | Missouri | 29077 | 83 | 8 |
91085 | 91085 | 2020-04-26 | Greene | Missouri | 29077 | 83 | 8 |
88269 | 88269 | 2020-04-25 | Greene | Missouri | 29077 | 83 | 8 |
79859 | 79859 | 2020-04-22 | Greene | Missouri | 29077 | 83 | 8 |
66000 | 66000 | 2020-04-17 | Greene | Missouri | 29077 | 83 | 8 |
60535 | 60535 | 2020-04-15 | Franklin | Missouri | 29071 | 83 | 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);