ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 76 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
792234 | 792234 | 2020-12-03 | Worth | Missouri | 29227 | 76 | 0 |
753241 | 753241 | 2020-11-21 | Mercer | Missouri | 29129 | 76 | 0 |
694798 | 694798 | 2020-11-03 | Chariton | Missouri | 29041 | 76 | 0 |
665591 | 665591 | 2020-10-25 | Atchison | Missouri | 29005 | 76 | 1 |
591012 | 591012 | 2020-10-02 | Dade | Missouri | 29057 | 76 | 0 |
581362 | 581362 | 2020-09-29 | St. Clair | Missouri | 29185 | 76 | 0 |
578121 | 578121 | 2020-09-28 | St. Clair | Missouri | 29185 | 76 | 0 |
574880 | 574880 | 2020-09-27 | St. Clair | Missouri | 29185 | 76 | 0 |
548876 | 548876 | 2020-09-19 | Caldwell | Missouri | 29025 | 76 | 1 |
545656 | 545656 | 2020-09-18 | Daviess | Missouri | 29061 | 76 | 0 |
513337 | 513337 | 2020-09-08 | Monroe | Missouri | 29137 | 76 | 0 |
510105 | 510105 | 2020-09-07 | Monroe | Missouri | 29137 | 76 | 0 |
506872 | 506872 | 2020-09-06 | Monroe | Missouri | 29137 | 76 | 0 |
500341 | 500341 | 2020-09-04 | Bates | Missouri | 29013 | 76 | 1 |
493928 | 493928 | 2020-09-02 | Livingston | Missouri | 29117 | 76 | 1 |
484228 | 484228 | 2020-08-30 | Macon | Missouri | 29121 | 76 | 0 |
471348 | 471348 | 2020-08-26 | Wayne | Missouri | 29223 | 76 | 0 |
455095 | 455095 | 2020-08-21 | Barton | Missouri | 29011 | 76 | 0 |
455206 | 455206 | 2020-08-21 | Wright | Missouri | 29229 | 76 | 0 |
448750 | 448750 | 2020-08-19 | Wright | Missouri | 29229 | 76 | 0 |
445500 | 445500 | 2020-08-18 | Ripley | Missouri | 29181 | 76 | 0 |
438984 | 438984 | 2020-08-16 | Dallas | Missouri | 29059 | 76 | 1 |
432593 | 432593 | 2020-08-14 | Randolph | Missouri | 29175 | 76 | 1 |
413209 | 413209 | 2020-08-08 | Henry | Missouri | 29083 | 76 | 3 |
409989 | 409989 | 2020-08-07 | Henry | Missouri | 29083 | 76 | 3 |
406769 | 406769 | 2020-08-06 | Henry | Missouri | 29083 | 76 | 3 |
406800 | 406800 | 2020-08-06 | Morgan | Missouri | 29141 | 76 | 0 |
400375 | 400375 | 2020-08-04 | Phelps | Missouri | 29161 | 76 | 0 |
374600 | 374600 | 2020-07-27 | Gentry | Missouri | 29075 | 76 | 9 |
361794 | 361794 | 2020-07-23 | Moniteau | Missouri | 29135 | 76 | 2 |
349029 | 349029 | 2020-07-19 | Webster | Missouri | 29225 | 76 | 1 |
317073 | 317073 | 2020-07-09 | Laclede | Missouri | 29105 | 76 | 0 |
313859 | 313859 | 2020-07-08 | Camden | Missouri | 29029 | 76 | 2 |
285425 | 285425 | 2020-06-29 | Cole | Missouri | 29051 | 76 | 2 |
204460 | 204460 | 2020-06-03 | Cape Girardeau | Missouri | 29031 | 76 | 2 |
204496 | 204496 | 2020-06-03 | Lafayette | Missouri | 29107 | 76 | 2 |
201383 | 201383 | 2020-06-02 | Cape Girardeau | Missouri | 29031 | 76 | 2 |
201416 | 201416 | 2020-06-02 | Johnson | Missouri | 29101 | 76 | 0 |
198343 | 198343 | 2020-06-01 | Johnson | Missouri | 29101 | 76 | 0 |
195272 | 195272 | 2020-05-31 | Johnson | Missouri | 29101 | 76 | 0 |
192203 | 192203 | 2020-05-30 | Johnson | Missouri | 29101 | 76 | 0 |
189139 | 189139 | 2020-05-29 | Johnson | Missouri | 29101 | 76 | 0 |
189164 | 189164 | 2020-05-29 | Pemiscot | Missouri | 29155 | 76 | 4 |
186106 | 186106 | 2020-05-28 | Pemiscot | Missouri | 29155 | 76 | 4 |
186131 | 186131 | 2020-05-28 | Stoddard | Missouri | 29207 | 76 | 5 |
183050 | 183050 | 2020-05-27 | Pemiscot | Missouri | 29155 | 76 | 4 |
180003 | 180003 | 2020-05-26 | Pemiscot | Missouri | 29155 | 76 | 4 |
143677 | 143677 | 2020-05-14 | Lincoln | Missouri | 29113 | 76 | 1 |
140682 | 140682 | 2020-05-13 | Lincoln | Missouri | 29113 | 76 | 1 |
137688 | 137688 | 2020-05-12 | Lincoln | Missouri | 29113 | 76 | 1 |
131707 | 131707 | 2020-05-10 | Lincoln | Missouri | 29113 | 76 | 1 |
119806 | 119806 | 2020-05-06 | Scott | Missouri | 29201 | 76 | 2 |
113964 | 113964 | 2020-05-04 | Scott | Missouri | 29201 | 76 | 2 |
111085 | 111085 | 2020-05-03 | Scott | Missouri | 29201 | 76 | 2 |
108213 | 108213 | 2020-05-02 | Scott | Missouri | 29201 | 76 | 2 |
99563 | 99563 | 2020-04-29 | Buchanan | Missouri | 29021 | 76 | 1 |
36851 | 36851 | 2020-04-06 | Boone | Missouri | 29019 | 76 | 1 |
34388 | 34388 | 2020-04-05 | Boone | Missouri | 29019 | 76 | 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);