ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 86 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
714332 | 714332 | 2020-11-09 | Schuyler | Missouri | 29197 | 86 | 0 |
688293 | 688293 | 2020-11-01 | Atchison | Missouri | 29005 | 86 | 1 |
626744 | 626744 | 2020-10-13 | Shelby | Missouri | 29205 | 86 | 1 |
623502 | 623502 | 2020-10-12 | Shelby | Missouri | 29205 | 86 | 1 |
620259 | 620259 | 2020-10-11 | Shelby | Missouri | 29205 | 86 | 1 |
617017 | 617017 | 2020-10-10 | Shelby | Missouri | 29205 | 86 | 1 |
613778 | 613778 | 2020-10-09 | St. Clair | Missouri | 29185 | 86 | 0 |
607237 | 607237 | 2020-10-07 | Holt | Missouri | 29087 | 86 | 1 |
603994 | 603994 | 2020-10-06 | Holt | Missouri | 29087 | 86 | 1 |
600752 | 600752 | 2020-10-05 | Holt | Missouri | 29087 | 86 | 1 |
597509 | 597509 | 2020-10-04 | Holt | Missouri | 29087 | 86 | 1 |
584566 | 584566 | 2020-09-30 | Maries | Missouri | 29125 | 86 | 0 |
584573 | 584573 | 2020-09-30 | Monroe | Missouri | 29137 | 86 | 1 |
561885 | 561885 | 2020-09-23 | Monroe | Missouri | 29137 | 86 | 0 |
558648 | 558648 | 2020-09-22 | Monroe | Missouri | 29137 | 86 | 0 |
555411 | 555411 | 2020-09-21 | Monroe | Missouri | 29137 | 86 | 0 |
555438 | 555438 | 2020-09-21 | Shannon | Missouri | 29203 | 86 | 1 |
552133 | 552133 | 2020-09-20 | Daviess | Missouri | 29061 | 86 | 0 |
552173 | 552173 | 2020-09-20 | Monroe | Missouri | 29137 | 86 | 0 |
548906 | 548906 | 2020-09-19 | Hickory | Missouri | 29085 | 86 | 2 |
548934 | 548934 | 2020-09-19 | Monroe | Missouri | 29137 | 86 | 0 |
516541 | 516541 | 2020-09-09 | Harrison | Missouri | 29081 | 86 | 1 |
513307 | 513307 | 2020-09-08 | Harrison | Missouri | 29081 | 86 | 1 |
510075 | 510075 | 2020-09-07 | Harrison | Missouri | 29081 | 86 | 1 |
481024 | 481024 | 2020-08-29 | Ripley | Missouri | 29181 | 86 | 0 |
464820 | 464820 | 2020-08-24 | Howard | Missouri | 29089 | 86 | 0 |
455119 | 455119 | 2020-08-21 | Dallas | Missouri | 29059 | 86 | 1 |
432541 | 432541 | 2020-08-14 | Gentry | Missouri | 29075 | 86 | 9 |
429314 | 429314 | 2020-08-13 | Gentry | Missouri | 29075 | 86 | 9 |
406811 | 406811 | 2020-08-06 | Pike | Missouri | 29163 | 86 | 1 |
393969 | 393969 | 2020-08-02 | Stone | Missouri | 29209 | 86 | 1 |
387455 | 387455 | 2020-07-31 | Cooper | Missouri | 29053 | 86 | 0 |
358634 | 358634 | 2020-07-22 | Webster | Missouri | 29225 | 86 | 1 |
342570 | 342570 | 2020-07-17 | Lawrence | Missouri | 29109 | 86 | 2 |
326667 | 326667 | 2020-07-12 | Warren | Missouri | 29219 | 86 | 0 |
313849 | 313849 | 2020-07-08 | Barry | Missouri | 29009 | 86 | 0 |
269731 | 269731 | 2020-06-24 | Lafayette | Missouri | 29107 | 86 | 2 |
266545 | 266545 | 2020-06-23 | Adair | Missouri | 29001 | 86 | 0 |
266598 | 266598 | 2020-06-23 | Lafayette | Missouri | 29107 | 86 | 2 |
263419 | 263419 | 2020-06-22 | Adair | Missouri | 29001 | 86 | 0 |
263472 | 263472 | 2020-06-22 | Lafayette | Missouri | 29107 | 86 | 2 |
260344 | 260344 | 2020-06-21 | Lafayette | Missouri | 29107 | 86 | 2 |
257218 | 257218 | 2020-06-20 | Lafayette | Missouri | 29107 | 86 | 2 |
254098 | 254098 | 2020-06-19 | Lafayette | Missouri | 29107 | 86 | 2 |
250983 | 250983 | 2020-06-18 | Lafayette | Missouri | 29107 | 86 | 2 |
247870 | 247870 | 2020-06-17 | Lafayette | Missouri | 29107 | 86 | 2 |
244781 | 244781 | 2020-06-16 | Perry | Missouri | 29157 | 86 | 0 |
241671 | 241671 | 2020-06-15 | Pettis | Missouri | 29159 | 86 | 1 |
222981 | 222981 | 2020-06-09 | Cape Girardeau | Missouri | 29031 | 86 | 3 |
213745 | 213745 | 2020-06-06 | Lincoln | Missouri | 29113 | 86 | 1 |
210661 | 210661 | 2020-06-05 | Lincoln | Missouri | 29113 | 86 | 1 |
189110 | 189110 | 2020-05-29 | Cass | Missouri | 29037 | 86 | 8 |
158760 | 158760 | 2020-05-19 | Scott | Missouri | 29201 | 86 | 7 |
149717 | 149717 | 2020-05-16 | Scott | Missouri | 29201 | 86 | 6 |
116786 | 116786 | 2020-05-05 | Clay | Missouri | 29047 | 86 | 1 |
105301 | 105301 | 2020-05-01 | Greene | Missouri | 29077 | 86 | 8 |
25030 | 25030 | 2020-04-01 | Jackson | Missouri | 29095 | 86 | 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);