ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 70 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
776009 | 776009 | 2020-11-28 | Worth | Missouri | 29227 | 70 | 0 |
698074 | 698074 | 2020-11-04 | Knox | Missouri | 29103 | 70 | 1 |
694831 | 694831 | 2020-11-03 | Knox | Missouri | 29103 | 70 | 1 |
681824 | 681824 | 2020-10-30 | Chariton | Missouri | 29041 | 70 | 0 |
665680 | 665680 | 2020-10-25 | Reynolds | Missouri | 29179 | 70 | 1 |
639629 | 639629 | 2020-10-17 | Atchison | Missouri | 29005 | 70 | 1 |
636383 | 636383 | 2020-10-16 | Atchison | Missouri | 29005 | 70 | 1 |
633137 | 633137 | 2020-10-15 | Atchison | Missouri | 29005 | 70 | 1 |
629892 | 629892 | 2020-10-14 | Atchison | Missouri | 29005 | 70 | 1 |
591082 | 591082 | 2020-10-02 | Shelby | Missouri | 29205 | 70 | 1 |
587841 | 587841 | 2020-10-01 | Shelby | Missouri | 29205 | 70 | 1 |
581290 | 581290 | 2020-09-29 | Dade | Missouri | 29057 | 70 | 0 |
578049 | 578049 | 2020-09-28 | Dade | Missouri | 29057 | 70 | 0 |
571637 | 571637 | 2020-09-26 | St. Clair | Missouri | 29185 | 70 | 0 |
539183 | 539183 | 2020-09-16 | Daviess | Missouri | 29061 | 70 | 0 |
539250 | 539250 | 2020-09-16 | Shannon | Missouri | 29203 | 70 | 1 |
535935 | 535935 | 2020-09-15 | Cedar | Missouri | 29039 | 70 | 0 |
532700 | 532700 | 2020-09-14 | Cedar | Missouri | 29039 | 70 | 0 |
529464 | 529464 | 2020-09-13 | Cedar | Missouri | 29039 | 70 | 0 |
523015 | 523015 | 2020-09-11 | Hickory | Missouri | 29085 | 70 | 2 |
519814 | 519814 | 2020-09-10 | Ozark | Missouri | 29153 | 70 | 0 |
516579 | 516579 | 2020-09-09 | Ozark | Missouri | 29153 | 70 | 0 |
513310 | 513310 | 2020-09-08 | Holt | Missouri | 29087 | 70 | 0 |
510078 | 510078 | 2020-09-07 | Holt | Missouri | 29087 | 70 | 0 |
506845 | 506845 | 2020-09-06 | Holt | Missouri | 29087 | 70 | 0 |
490704 | 490704 | 2020-09-01 | Monroe | Missouri | 29137 | 70 | 0 |
480938 | 480938 | 2020-08-29 | Bates | Missouri | 29013 | 70 | 1 |
480972 | 480972 | 2020-08-29 | Harrison | Missouri | 29081 | 70 | 1 |
464853 | 464853 | 2020-08-24 | Osage | Missouri | 29151 | 70 | 1 |
461622 | 461622 | 2020-08-23 | Osage | Missouri | 29151 | 70 | 1 |
461655 | 461655 | 2020-08-23 | Vernon | Missouri | 29217 | 70 | 0 |
458395 | 458395 | 2020-08-22 | Osage | Missouri | 29151 | 70 | 1 |
451923 | 451923 | 2020-08-20 | Macon | Missouri | 29121 | 70 | 0 |
448747 | 448747 | 2020-08-19 | Wayne | Missouri | 29223 | 70 | 0 |
432620 | 432620 | 2020-08-14 | Wright | Missouri | 29229 | 70 | 0 |
426058 | 426058 | 2020-08-12 | Barton | Missouri | 29011 | 70 | 0 |
422836 | 422836 | 2020-08-11 | Barton | Missouri | 29011 | 70 | 0 |
377884 | 377884 | 2020-07-28 | Stone | Missouri | 29209 | 70 | 1 |
355354 | 355354 | 2020-07-21 | Gentry | Missouri | 29075 | 70 | 9 |
352152 | 352152 | 2020-07-20 | Gentry | Missouri | 29075 | 70 | 9 |
348952 | 348952 | 2020-07-19 | Gentry | Missouri | 29075 | 70 | 9 |
345751 | 345751 | 2020-07-18 | Gentry | Missouri | 29075 | 70 | 9 |
313899 | 313899 | 2020-07-08 | Laclede | Missouri | 29105 | 70 | 0 |
304354 | 304354 | 2020-07-05 | Camden | Missouri | 29029 | 70 | 1 |
238546 | 238546 | 2020-06-14 | McDonald | Missouri | 29119 | 70 | 0 |
235439 | 235439 | 2020-06-13 | McDonald | Missouri | 29119 | 70 | 0 |
232336 | 232336 | 2020-06-12 | Mississippi | Missouri | 29133 | 70 | 0 |
216854 | 216854 | 2020-06-07 | Perry | Missouri | 29157 | 70 | 0 |
198374 | 198374 | 2020-06-01 | Platte | Missouri | 29165 | 70 | 2 |
195303 | 195303 | 2020-05-31 | Platte | Missouri | 29165 | 70 | 2 |
192233 | 192233 | 2020-05-30 | Platte | Missouri | 29165 | 70 | 2 |
189169 | 189169 | 2020-05-29 | Platte | Missouri | 29165 | 70 | 3 |
186049 | 186049 | 2020-05-28 | Cape Girardeau | Missouri | 29031 | 70 | 2 |
180005 | 180005 | 2020-05-26 | Pettis | Missouri | 29159 | 70 | 1 |
176938 | 176938 | 2020-05-25 | Lafayette | Missouri | 29107 | 70 | 2 |
173940 | 173940 | 2020-05-24 | Stoddard | Missouri | 29207 | 70 | 3 |
170898 | 170898 | 2020-05-23 | Stoddard | Missouri | 29207 | 70 | 3 |
164799 | 164799 | 2020-05-21 | Pemiscot | Missouri | 29155 | 70 | 3 |
161770 | 161770 | 2020-05-20 | Pemiscot | Missouri | 29155 | 70 | 3 |
158744 | 158744 | 2020-05-19 | Pemiscot | Missouri | 29155 | 70 | 3 |
143697 | 143697 | 2020-05-14 | Pettis | Missouri | 29159 | 70 | 1 |
140649 | 140649 | 2020-05-13 | Cass | Missouri | 29037 | 70 | 8 |
137655 | 137655 | 2020-05-12 | Cass | Missouri | 29037 | 70 | 8 |
134665 | 134665 | 2020-05-11 | Cass | Missouri | 29037 | 70 | 8 |
131674 | 131674 | 2020-05-10 | Cass | Missouri | 29037 | 70 | 8 |
105348 | 105348 | 2020-05-01 | Scott | Missouri | 29201 | 70 | 2 |
102428 | 102428 | 2020-04-30 | Clay | Missouri | 29047 | 70 | 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);