ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 79 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
762979 | 762979 | 2020-11-24 | Mercer | Missouri | 29129 | 79 | 0 |
759734 | 759734 | 2020-11-23 | Mercer | Missouri | 29129 | 79 | 0 |
707844 | 707844 | 2020-11-07 | Schuyler | Missouri | 29197 | 79 | 0 |
704560 | 704560 | 2020-11-06 | Knox | Missouri | 29103 | 79 | 1 |
610458 | 610458 | 2020-10-08 | Clark | Missouri | 29045 | 79 | 0 |
600809 | 600809 | 2020-10-05 | St. Clair | Missouri | 29185 | 79 | 0 |
581305 | 581305 | 2020-09-29 | Holt | Missouri | 29087 | 79 | 1 |
578064 | 578064 | 2020-09-28 | Holt | Missouri | 29087 | 79 | 1 |
574823 | 574823 | 2020-09-27 | Holt | Missouri | 29087 | 79 | 1 |
561827 | 561827 | 2020-09-23 | Caldwell | Missouri | 29025 | 79 | 1 |
552174 | 552174 | 2020-09-20 | Montgomery | Missouri | 29139 | 79 | 1 |
503600 | 503600 | 2020-09-05 | DeKalb | Missouri | 29063 | 79 | 1 |
487462 | 487462 | 2020-08-31 | Macon | Missouri | 29121 | 79 | 0 |
477813 | 477813 | 2020-08-28 | Wayne | Missouri | 29223 | 79 | 0 |
468114 | 468114 | 2020-08-25 | Texas | Missouri | 29215 | 79 | 1 |
468121 | 468121 | 2020-08-25 | Wright | Missouri | 29229 | 79 | 0 |
461550 | 461550 | 2020-08-23 | Barton | Missouri | 29011 | 79 | 0 |
461637 | 461637 | 2020-08-23 | Ripley | Missouri | 29181 | 79 | 0 |
458410 | 458410 | 2020-08-22 | Ripley | Missouri | 29181 | 79 | 0 |
455134 | 455134 | 2020-08-21 | Howard | Missouri | 29089 | 79 | 0 |
451966 | 451966 | 2020-08-20 | Ste. Genevieve | Missouri | 29186 | 79 | 1 |
448738 | 448738 | 2020-08-19 | Ste. Genevieve | Missouri | 29186 | 79 | 1 |
422858 | 422858 | 2020-08-11 | Crawford | Missouri | 29055 | 79 | 0 |
416429 | 416429 | 2020-08-09 | Henry | Missouri | 29083 | 79 | 3 |
413192 | 413192 | 2020-08-08 | Clinton | Missouri | 29049 | 79 | 0 |
409972 | 409972 | 2020-08-07 | Clinton | Missouri | 29049 | 79 | 0 |
403592 | 403592 | 2020-08-05 | Phelps | Missouri | 29161 | 79 | 0 |
403593 | 403593 | 2020-08-05 | Pike | Missouri | 29163 | 79 | 1 |
393900 | 393900 | 2020-08-02 | Gentry | Missouri | 29075 | 79 | 9 |
390683 | 390683 | 2020-08-01 | Gentry | Missouri | 29075 | 79 | 9 |
387466 | 387466 | 2020-07-31 | Gentry | Missouri | 29075 | 79 | 9 |
384301 | 384301 | 2020-07-30 | Ray | Missouri | 29177 | 79 | 0 |
384317 | 384317 | 2020-07-30 | Stone | Missouri | 29209 | 79 | 1 |
377794 | 377794 | 2020-07-28 | Carroll | Missouri | 29033 | 79 | 0 |
336195 | 336195 | 2020-07-15 | New Madrid | Missouri | 29143 | 79 | 1 |
294880 | 294880 | 2020-07-02 | Cole | Missouri | 29051 | 79 | 2 |
263453 | 263453 | 2020-06-22 | Dunklin | Missouri | 29069 | 79 | 3 |
263485 | 263485 | 2020-06-22 | Mississippi | Missouri | 29133 | 79 | 0 |
260325 | 260325 | 2020-06-21 | Dunklin | Missouri | 29069 | 79 | 3 |
257199 | 257199 | 2020-06-20 | Dunklin | Missouri | 29069 | 79 | 3 |
232319 | 232319 | 2020-06-12 | Johnson | Missouri | 29101 | 79 | 0 |
229215 | 229215 | 2020-06-11 | Johnson | Missouri | 29101 | 79 | 0 |
229243 | 229243 | 2020-06-11 | Perry | Missouri | 29157 | 79 | 0 |
213767 | 213767 | 2020-06-06 | Pettis | Missouri | 29159 | 79 | 1 |
192160 | 192160 | 2020-05-30 | Audrain | Missouri | 29007 | 79 | 0 |
192253 | 192253 | 2020-05-30 | Stoddard | Missouri | 29207 | 79 | 5 |
173863 | 173863 | 2020-05-24 | Cass | Missouri | 29037 | 79 | 8 |
173898 | 173898 | 2020-05-24 | Lincoln | Missouri | 29113 | 79 | 1 |
170856 | 170856 | 2020-05-23 | Lincoln | Missouri | 29113 | 79 | 1 |
128750 | 128750 | 2020-05-09 | Scott | Missouri | 29201 | 79 | 5 |
49749 | 49749 | 2020-04-11 | Boone | Missouri | 29019 | 79 | 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);