ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where cases = 71 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668924 | 668924 | 2020-10-26 | Reynolds | Missouri | 29179 | 71 | 1 |
662439 | 662439 | 2020-10-24 | Scotland | Missouri | 29199 | 71 | 1 |
649367 | 649367 | 2020-10-20 | Atchison | Missouri | 29005 | 71 | 1 |
646123 | 646123 | 2020-10-19 | Atchison | Missouri | 29005 | 71 | 1 |
642877 | 642877 | 2020-10-18 | Atchison | Missouri | 29005 | 71 | 1 |
587843 | 587843 | 2020-10-01 | St. Clair | Missouri | 29185 | 71 | 0 |
584531 | 584531 | 2020-09-30 | Dade | Missouri | 29057 | 71 | 0 |
584601 | 584601 | 2020-09-30 | Shelby | Missouri | 29205 | 71 | 1 |
555404 | 555404 | 2020-09-21 | Maries | Missouri | 29125 | 71 | 0 |
548881 | 548881 | 2020-09-19 | Carter | Missouri | 29035 | 71 | 1 |
548921 | 548921 | 2020-09-19 | Lewis | Missouri | 29111 | 71 | 2 |
545683 | 545683 | 2020-09-18 | Lewis | Missouri | 29111 | 71 | 2 |
542446 | 542446 | 2020-09-17 | Lewis | Missouri | 29111 | 71 | 2 |
539210 | 539210 | 2020-09-16 | Lewis | Missouri | 29111 | 71 | 2 |
523049 | 523049 | 2020-09-11 | Oregon | Missouri | 29149 | 71 | 0 |
519812 | 519812 | 2020-09-10 | Oregon | Missouri | 29149 | 71 | 0 |
493899 | 493899 | 2020-09-02 | DeKalb | Missouri | 29063 | 71 | 1 |
484207 | 484207 | 2020-08-30 | Harrison | Missouri | 29081 | 71 | 1 |
477760 | 477760 | 2020-08-28 | Livingston | Missouri | 29117 | 71 | 1 |
474527 | 474527 | 2020-08-27 | Livingston | Missouri | 29117 | 71 | 1 |
471295 | 471295 | 2020-08-26 | Livingston | Missouri | 29117 | 71 | 1 |
468082 | 468082 | 2020-08-25 | Osage | Missouri | 29151 | 71 | 1 |
468115 | 468115 | 2020-08-25 | Vernon | Missouri | 29217 | 71 | 0 |
464886 | 464886 | 2020-08-24 | Vernon | Missouri | 29217 | 71 | 0 |
461606 | 461606 | 2020-08-23 | Macon | Missouri | 29121 | 71 | 0 |
461607 | 461607 | 2020-08-23 | Madison | Missouri | 29123 | 71 | 0 |
458379 | 458379 | 2020-08-22 | Macon | Missouri | 29121 | 71 | 0 |
458431 | 458431 | 2020-08-22 | Wayne | Missouri | 29223 | 71 | 0 |
455151 | 455151 | 2020-08-21 | Macon | Missouri | 29121 | 71 | 0 |
455203 | 455203 | 2020-08-21 | Wayne | Missouri | 29223 | 71 | 0 |
451975 | 451975 | 2020-08-20 | Wayne | Missouri | 29223 | 71 | 0 |
445452 | 445452 | 2020-08-18 | Howard | Missouri | 29089 | 71 | 0 |
442226 | 442226 | 2020-08-17 | Howard | Missouri | 29089 | 71 | 0 |
435735 | 435735 | 2020-08-15 | Barton | Missouri | 29011 | 71 | 0 |
432509 | 432509 | 2020-08-14 | Barton | Missouri | 29011 | 71 | 0 |
429282 | 429282 | 2020-08-13 | Barton | Missouri | 29011 | 71 | 0 |
419698 | 419698 | 2020-08-10 | Randolph | Missouri | 29175 | 71 | 1 |
413195 | 413195 | 2020-08-08 | Crawford | Missouri | 29055 | 71 | 0 |
409975 | 409975 | 2020-08-07 | Crawford | Missouri | 29055 | 71 | 0 |
400365 | 400365 | 2020-08-04 | Morgan | Missouri | 29141 | 71 | 0 |
397151 | 397151 | 2020-08-03 | Morgan | Missouri | 29141 | 71 | 0 |
393870 | 393870 | 2020-08-02 | Benton | Missouri | 29015 | 71 | 1 |
390653 | 390653 | 2020-08-01 | Benton | Missouri | 29015 | 71 | 1 |
387436 | 387436 | 2020-07-31 | Benton | Missouri | 29015 | 71 | 1 |
381101 | 381101 | 2020-07-29 | Stone | Missouri | 29209 | 71 | 1 |
371367 | 371367 | 2020-07-26 | Carroll | Missouri | 29033 | 71 | 0 |
361762 | 361762 | 2020-07-23 | Gentry | Missouri | 29075 | 71 | 9 |
358557 | 358557 | 2020-07-22 | Gentry | Missouri | 29075 | 71 | 9 |
313866 | 313866 | 2020-07-08 | Christian | Missouri | 29043 | 71 | 1 |
310696 | 310696 | 2020-07-07 | Christian | Missouri | 29043 | 71 | 1 |
307521 | 307521 | 2020-07-06 | Camden | Missouri | 29029 | 71 | 1 |
298017 | 298017 | 2020-07-03 | Barry | Missouri | 29009 | 71 | 0 |
272827 | 272827 | 2020-06-25 | Butler | Missouri | 29023 | 71 | 0 |
238549 | 238549 | 2020-06-14 | Mississippi | Missouri | 29133 | 71 | 0 |
238555 | 238555 | 2020-06-14 | Newton | Missouri | 29145 | 71 | 1 |
235442 | 235442 | 2020-06-13 | Mississippi | Missouri | 29133 | 71 | 0 |
235448 | 235448 | 2020-06-13 | Newton | Missouri | 29145 | 71 | 1 |
229270 | 229270 | 2020-06-11 | Sullivan | Missouri | 29211 | 71 | 0 |
226167 | 226167 | 2020-06-10 | Sullivan | Missouri | 29211 | 71 | 0 |
219946 | 219946 | 2020-06-08 | Perry | Missouri | 29157 | 71 | 0 |
186038 | 186038 | 2020-05-28 | Audrain | Missouri | 29007 | 71 | 0 |
183052 | 183052 | 2020-05-27 | Pettis | Missouri | 29159 | 71 | 1 |
179982 | 179982 | 2020-05-26 | Lafayette | Missouri | 29107 | 71 | 2 |
167811 | 167811 | 2020-05-22 | Johnson | Missouri | 29101 | 71 | 0 |
152688 | 152688 | 2020-05-17 | Johnson | Missouri | 29101 | 71 | 0 |
149677 | 149677 | 2020-05-16 | Johnson | Missouri | 29101 | 71 | 0 |
146672 | 146672 | 2020-05-15 | Johnson | Missouri | 29101 | 71 | 0 |
55128 | 55128 | 2020-04-13 | Greene | Missouri | 29077 | 71 | 8 |
52446 | 52446 | 2020-04-12 | Greene | Missouri | 29077 | 71 | 8 |
49773 | 49773 | 2020-04-11 | Greene | Missouri | 29077 | 71 | 8 |
47126 | 47126 | 2020-04-10 | Greene | Missouri | 29077 | 71 | 8 |
41940 | 41940 | 2020-04-08 | Greene | Missouri | 29077 | 71 | 7 |
34416 | 34416 | 2020-04-05 | Jefferson | Missouri | 29099 | 71 | 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);