ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 82 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
766224 | 766224 | 2020-11-25 | Mercer | Missouri | 29129 | 82 | 0 |
711047 | 711047 | 2020-11-08 | Knox | Missouri | 29103 | 82 | 1 |
691631 | 691631 | 2020-11-02 | Scotland | Missouri | 29199 | 82 | 1 |
681806 | 681806 | 2020-10-30 | Atchison | Missouri | 29005 | 82 | 1 |
633181 | 633181 | 2020-10-15 | Iron | Missouri | 29093 | 82 | 0 |
613700 | 613700 | 2020-10-09 | Clark | Missouri | 29045 | 82 | 0 |
610536 | 610536 | 2020-10-08 | St. Clair | Missouri | 29185 | 82 | 0 |
587786 | 587786 | 2020-10-01 | Holt | Missouri | 29087 | 82 | 1 |
574843 | 574843 | 2020-09-27 | Maries | Missouri | 29125 | 82 | 0 |
565067 | 565067 | 2020-09-24 | Caldwell | Missouri | 29025 | 82 | 1 |
565112 | 565112 | 2020-09-24 | Lewis | Missouri | 29111 | 82 | 2 |
565126 | 565126 | 2020-09-24 | Montgomery | Missouri | 29139 | 82 | 1 |
561886 | 561886 | 2020-09-23 | Montgomery | Missouri | 29139 | 82 | 1 |
555358 | 555358 | 2020-09-21 | Carter | Missouri | 29035 | 82 | 1 |
539223 | 539223 | 2020-09-16 | Monroe | Missouri | 29137 | 82 | 0 |
535986 | 535986 | 2020-09-15 | Monroe | Missouri | 29137 | 82 | 0 |
535992 | 535992 | 2020-09-15 | Oregon | Missouri | 29149 | 82 | 0 |
532751 | 532751 | 2020-09-14 | Monroe | Missouri | 29137 | 82 | 0 |
529451 | 529451 | 2020-09-13 | Bates | Missouri | 29013 | 82 | 1 |
529515 | 529515 | 2020-09-13 | Monroe | Missouri | 29137 | 82 | 0 |
529523 | 529523 | 2020-09-13 | Ozark | Missouri | 29153 | 82 | 0 |
526215 | 526215 | 2020-09-12 | Bates | Missouri | 29013 | 82 | 1 |
526279 | 526279 | 2020-09-12 | Monroe | Missouri | 29137 | 82 | 0 |
503630 | 503630 | 2020-09-05 | Macon | Missouri | 29121 | 82 | 0 |
500396 | 500396 | 2020-09-04 | Macon | Missouri | 29121 | 82 | 0 |
493929 | 493929 | 2020-09-02 | Macon | Missouri | 29121 | 82 | 0 |
490711 | 490711 | 2020-09-01 | Osage | Missouri | 29151 | 82 | 1 |
487511 | 487511 | 2020-08-31 | Vernon | Missouri | 29217 | 82 | 0 |
484277 | 484277 | 2020-08-30 | Vernon | Missouri | 29217 | 82 | 0 |
481045 | 481045 | 2020-08-29 | Wayne | Missouri | 29223 | 82 | 0 |
458362 | 458362 | 2020-08-22 | Howard | Missouri | 29089 | 82 | 0 |
455194 | 455194 | 2020-08-21 | Ste. Genevieve | Missouri | 29186 | 82 | 1 |
442190 | 442190 | 2020-08-17 | Bollinger | Missouri | 29017 | 82 | 1 |
439044 | 439044 | 2020-08-16 | Randolph | Missouri | 29175 | 82 | 1 |
435819 | 435819 | 2020-08-15 | Randolph | Missouri | 29175 | 82 | 1 |
419650 | 419650 | 2020-08-10 | Henry | Missouri | 29083 | 82 | 3 |
419721 | 419721 | 2020-08-10 | Washington | Missouri | 29221 | 82 | 1 |
416412 | 416412 | 2020-08-09 | Clinton | Missouri | 29049 | 82 | 0 |
416421 | 416421 | 2020-08-09 | Douglas | Missouri | 29067 | 82 | 2 |
403547 | 403547 | 2020-08-05 | Gentry | Missouri | 29075 | 82 | 9 |
400330 | 400330 | 2020-08-04 | Gentry | Missouri | 29075 | 82 | 9 |
397116 | 397116 | 2020-08-03 | Gentry | Missouri | 29075 | 82 | 9 |
390752 | 390752 | 2020-08-01 | Stone | Missouri | 29209 | 82 | 1 |
384248 | 384248 | 2020-07-30 | Gentry | Missouri | 29075 | 82 | 9 |
384278 | 384278 | 2020-07-30 | Miller | Missouri | 29131 | 82 | 0 |
368204 | 368204 | 2020-07-25 | Marion | Missouri | 29127 | 82 | 1 |
301201 | 301201 | 2020-07-04 | Cole | Missouri | 29051 | 82 | 2 |
272883 | 272883 | 2020-06-25 | Mississippi | Missouri | 29133 | 82 | 0 |
269712 | 269712 | 2020-06-24 | Dunklin | Missouri | 29069 | 82 | 3 |
223042 | 223042 | 2020-06-09 | Pettis | Missouri | 29159 | 82 | 1 |
195228 | 195228 | 2020-05-31 | Audrain | Missouri | 29007 | 82 | 0 |
195278 | 195278 | 2020-05-31 | Lincoln | Missouri | 29113 | 82 | 1 |
179950 | 179950 | 2020-05-26 | Cass | Missouri | 29037 | 82 | 8 |
137721 | 137721 | 2020-05-12 | Scott | Missouri | 29201 | 82 | 6 |
96742 | 96742 | 2020-04-28 | Greene | Missouri | 29077 | 82 | 8 |
82655 | 82655 | 2020-04-23 | Greene | Missouri | 29077 | 82 | 8 |
55104 | 55104 | 2020-04-13 | Boone | Missouri | 29019 | 82 | 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);