ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 85 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
779205 | 779205 | 2020-11-29 | Mercer | Missouri | 29129 | 85 | 1 |
717535 | 717535 | 2020-11-10 | Knox | Missouri | 29103 | 85 | 1 |
678651 | 678651 | 2020-10-29 | Reynolds | Missouri | 29179 | 85 | 1 |
626668 | 626668 | 2020-10-13 | Clark | Missouri | 29045 | 85 | 0 |
623426 | 623426 | 2020-10-12 | Clark | Missouri | 29045 | 85 | 0 |
620183 | 620183 | 2020-10-11 | Clark | Missouri | 29045 | 85 | 0 |
616941 | 616941 | 2020-10-10 | Clark | Missouri | 29045 | 85 | 0 |
581321 | 581321 | 2020-09-29 | Linn | Missouri | 29115 | 85 | 1 |
581333 | 581333 | 2020-09-29 | Montgomery | Missouri | 29139 | 85 | 1 |
578080 | 578080 | 2020-09-28 | Linn | Missouri | 29115 | 85 | 1 |
578092 | 578092 | 2020-09-28 | Montgomery | Missouri | 29139 | 85 | 1 |
571596 | 571596 | 2020-09-26 | Linn | Missouri | 29115 | 85 | 2 |
545668 | 545668 | 2020-09-18 | Hickory | Missouri | 29085 | 85 | 2 |
545696 | 545696 | 2020-09-18 | Monroe | Missouri | 29137 | 85 | 0 |
519767 | 519767 | 2020-09-10 | DeKalb | Missouri | 29063 | 85 | 2 |
510096 | 510096 | 2020-09-07 | Macon | Missouri | 29121 | 85 | 0 |
506842 | 506842 | 2020-09-06 | Harrison | Missouri | 29081 | 85 | 1 |
506863 | 506863 | 2020-09-06 | Macon | Missouri | 29121 | 85 | 0 |
503609 | 503609 | 2020-09-05 | Harrison | Missouri | 29081 | 85 | 1 |
493945 | 493945 | 2020-09-02 | Osage | Missouri | 29151 | 85 | 1 |
487514 | 487514 | 2020-08-31 | Wayne | Missouri | 29223 | 85 | 0 |
477792 | 477792 | 2020-08-28 | Ripley | Missouri | 29181 | 85 | 0 |
474559 | 474559 | 2020-08-27 | Ripley | Missouri | 29181 | 85 | 0 |
471344 | 471344 | 2020-08-26 | Texas | Missouri | 29215 | 85 | 1 |
471351 | 471351 | 2020-08-26 | Wright | Missouri | 29229 | 85 | 0 |
461589 | 461589 | 2020-08-23 | Howard | Missouri | 29089 | 85 | 0 |
461633 | 461633 | 2020-08-23 | Ralls | Missouri | 29173 | 85 | 0 |
451891 | 451891 | 2020-08-20 | Dallas | Missouri | 29059 | 85 | 1 |
426090 | 426090 | 2020-08-12 | Gentry | Missouri | 29075 | 85 | 9 |
422855 | 422855 | 2020-08-11 | Clinton | Missouri | 29049 | 85 | 0 |
422868 | 422868 | 2020-08-11 | Gentry | Missouri | 29075 | 85 | 9 |
419646 | 419646 | 2020-08-10 | Gentry | Missouri | 29075 | 85 | 9 |
400294 | 400294 | 2020-08-04 | Andrew | Missouri | 29003 | 85 | 1 |
371415 | 371415 | 2020-07-26 | Marion | Missouri | 29127 | 85 | 1 |
349000 | 349000 | 2020-07-19 | Polk | Missouri | 29167 | 85 | 0 |
326570 | 326570 | 2020-07-12 | Camden | Missouri | 29029 | 85 | 2 |
326577 | 326577 | 2020-07-12 | Christian | Missouri | 29043 | 85 | 1 |
323394 | 323394 | 2020-07-11 | Christian | Missouri | 29043 | 85 | 1 |
323427 | 323427 | 2020-07-11 | Laclede | Missouri | 29105 | 85 | 1 |
320215 | 320215 | 2020-07-10 | Christian | Missouri | 29043 | 85 | 1 |
317040 | 317040 | 2020-07-09 | Christian | Missouri | 29043 | 85 | 1 |
260291 | 260291 | 2020-06-21 | Adair | Missouri | 29001 | 85 | 0 |
254045 | 254045 | 2020-06-19 | Adair | Missouri | 29001 | 85 | 0 |
250930 | 250930 | 2020-06-18 | Adair | Missouri | 29001 | 85 | 0 |
247817 | 247817 | 2020-06-17 | Adair | Missouri | 29001 | 85 | 0 |
244757 | 244757 | 2020-06-16 | Lafayette | Missouri | 29107 | 85 | 2 |
241646 | 241646 | 2020-06-15 | Lafayette | Missouri | 29107 | 85 | 2 |
241670 | 241670 | 2020-06-15 | Perry | Missouri | 29157 | 85 | 0 |
238536 | 238536 | 2020-06-14 | Lafayette | Missouri | 29107 | 85 | 2 |
238561 | 238561 | 2020-06-14 | Pettis | Missouri | 29159 | 85 | 1 |
235429 | 235429 | 2020-06-13 | Lafayette | Missouri | 29107 | 85 | 2 |
235454 | 235454 | 2020-06-13 | Pettis | Missouri | 29159 | 85 | 1 |
216794 | 216794 | 2020-06-07 | Cape Girardeau | Missouri | 29031 | 85 | 3 |
213706 | 213706 | 2020-06-06 | Cape Girardeau | Missouri | 29031 | 85 | 3 |
207580 | 207580 | 2020-06-04 | Lincoln | Missouri | 29113 | 85 | 1 |
201422 | 201422 | 2020-06-02 | Lincoln | Missouri | 29113 | 85 | 1 |
198299 | 198299 | 2020-06-01 | Audrain | Missouri | 29007 | 85 | 0 |
186052 | 186052 | 2020-05-28 | Cass | Missouri | 29037 | 85 | 8 |
146711 | 146711 | 2020-05-15 | Scott | Missouri | 29201 | 85 | 6 |
102440 | 102440 | 2020-04-30 | Greene | Missouri | 29077 | 85 | 8 |
74292 | 74292 | 2020-04-20 | Greene | Missouri | 29077 | 85 | 8 |
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);