ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where cases = 32 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
633229 | 633229 | 2020-10-15 | Schuyler | Missouri | 29197 | 32 | 0 |
629984 | 629984 | 2020-10-14 | Schuyler | Missouri | 29197 | 32 | 0 |
626712 | 626712 | 2020-10-13 | Mercer | Missouri | 29129 | 32 | 0 |
623470 | 623470 | 2020-10-12 | Mercer | Missouri | 29129 | 32 | 0 |
620227 | 620227 | 2020-10-11 | Mercer | Missouri | 29129 | 32 | 0 |
616985 | 616985 | 2020-10-10 | Mercer | Missouri | 29129 | 32 | 0 |
607281 | 607281 | 2020-10-07 | Putnam | Missouri | 29171 | 32 | 1 |
604038 | 604038 | 2020-10-06 | Putnam | Missouri | 29171 | 32 | 1 |
600796 | 600796 | 2020-10-05 | Putnam | Missouri | 29171 | 32 | 1 |
597553 | 597553 | 2020-10-04 | Putnam | Missouri | 29171 | 32 | 1 |
594312 | 594312 | 2020-10-03 | Putnam | Missouri | 29171 | 32 | 1 |
558665 | 558665 | 2020-09-22 | Putnam | Missouri | 29171 | 32 | 1 |
555428 | 555428 | 2020-09-21 | Putnam | Missouri | 29171 | 32 | 1 |
552190 | 552190 | 2020-09-20 | Putnam | Missouri | 29171 | 32 | 1 |
552194 | 552194 | 2020-09-20 | Reynolds | Missouri | 29179 | 32 | 0 |
523073 | 523073 | 2020-09-11 | St. Clair | Missouri | 29185 | 32 | 0 |
500363 | 500363 | 2020-09-04 | Dade | Missouri | 29057 | 32 | 0 |
497129 | 497129 | 2020-09-03 | Dade | Missouri | 29057 | 32 | 0 |
474484 | 474484 | 2020-08-27 | Carter | Missouri | 29035 | 32 | 1 |
468081 | 468081 | 2020-08-25 | Oregon | Missouri | 29149 | 32 | 0 |
464808 | 464808 | 2020-08-24 | Dent | Missouri | 29065 | 32 | 0 |
461584 | 461584 | 2020-08-23 | Grundy | Missouri | 29079 | 32 | 1 |
458357 | 458357 | 2020-08-22 | Grundy | Missouri | 29079 | 32 | 1 |
448680 | 448680 | 2020-08-19 | Iron | Missouri | 29093 | 32 | 0 |
426106 | 426106 | 2020-08-12 | Knox | Missouri | 29103 | 32 | 0 |
416447 | 416447 | 2020-08-09 | Linn | Missouri | 29115 | 32 | 1 |
416476 | 416476 | 2020-08-09 | Ralls | Missouri | 29173 | 32 | 0 |
397110 | 397110 | 2020-08-03 | DeKalb | Missouri | 29063 | 32 | 1 |
393894 | 393894 | 2020-08-02 | DeKalb | Missouri | 29063 | 32 | 1 |
390677 | 390677 | 2020-08-01 | DeKalb | Missouri | 29063 | 32 | 1 |
390703 | 390703 | 2020-08-01 | Lewis | Missouri | 29111 | 32 | 1 |
387460 | 387460 | 2020-07-31 | DeKalb | Missouri | 29063 | 32 | 1 |
387538 | 387538 | 2020-07-31 | Texas | Missouri | 29215 | 32 | 0 |
384288 | 384288 | 2020-07-30 | Osage | Missouri | 29151 | 32 | 0 |
381001 | 381001 | 2020-07-29 | Bates | Missouri | 29013 | 32 | 1 |
381014 | 381014 | 2020-07-29 | Cedar | Missouri | 29039 | 32 | 0 |
381072 | 381072 | 2020-07-29 | Osage | Missouri | 29151 | 32 | 0 |
377784 | 377784 | 2020-07-28 | Bates | Missouri | 29013 | 32 | 1 |
377797 | 377797 | 2020-07-28 | Cedar | Missouri | 29039 | 32 | 0 |
377855 | 377855 | 2020-07-28 | Osage | Missouri | 29151 | 32 | 0 |
374569 | 374569 | 2020-07-27 | Bates | Missouri | 29013 | 32 | 1 |
374640 | 374640 | 2020-07-27 | Osage | Missouri | 29151 | 32 | 0 |
374652 | 374652 | 2020-07-27 | Randolph | Missouri | 29175 | 32 | 1 |
371428 | 371428 | 2020-07-26 | Osage | Missouri | 29151 | 32 | 0 |
364959 | 364959 | 2020-07-24 | Crawford | Missouri | 29055 | 32 | 0 |
361752 | 361752 | 2020-07-23 | Crawford | Missouri | 29055 | 32 | 0 |
358549 | 358549 | 2020-07-22 | Dallas | Missouri | 29059 | 32 | 1 |
358553 | 358553 | 2020-07-22 | Douglas | Missouri | 29067 | 32 | 1 |
352122 | 352122 | 2020-07-20 | Benton | Missouri | 29015 | 32 | 0 |
348922 | 348922 | 2020-07-19 | Benton | Missouri | 29015 | 32 | 0 |
345721 | 345721 | 2020-07-18 | Benton | Missouri | 29015 | 32 | 0 |
342540 | 342540 | 2020-07-17 | Cooper | Missouri | 29053 | 32 | 0 |
339326 | 339326 | 2020-07-16 | Bollinger | Missouri | 29017 | 32 | 1 |
339344 | 339344 | 2020-07-16 | Cooper | Missouri | 29053 | 32 | 0 |
339379 | 339379 | 2020-07-16 | Macon | Missouri | 29121 | 32 | 0 |
339408 | 339408 | 2020-07-16 | Ray | Missouri | 29177 | 32 | 0 |
339424 | 339424 | 2020-07-16 | Stone | Missouri | 29209 | 32 | 0 |
336148 | 336148 | 2020-07-15 | Cooper | Missouri | 29053 | 32 | 0 |
336183 | 336183 | 2020-07-15 | Macon | Missouri | 29121 | 32 | 0 |
336228 | 336228 | 2020-07-15 | Stone | Missouri | 29209 | 32 | 0 |
326666 | 326666 | 2020-07-12 | Vernon | Missouri | 29217 | 32 | 0 |
323483 | 323483 | 2020-07-11 | Vernon | Missouri | 29217 | 32 | 0 |
285455 | 285455 | 2020-06-29 | Lawrence | Missouri | 29109 | 32 | 1 |
269682 | 269682 | 2020-06-24 | Barry | Missouri | 29009 | 32 | 0 |
263440 | 263440 | 2020-06-22 | Christian | Missouri | 29043 | 32 | 0 |
263525 | 263525 | 2020-06-22 | Taney | Missouri | 29213 | 32 | 2 |
260312 | 260312 | 2020-06-21 | Christian | Missouri | 29043 | 32 | 0 |
257186 | 257186 | 2020-06-20 | Christian | Missouri | 29043 | 32 | 0 |
254153 | 254153 | 2020-06-19 | Warren | Missouri | 29219 | 32 | 0 |
251038 | 251038 | 2020-06-18 | Warren | Missouri | 29219 | 32 | 0 |
247925 | 247925 | 2020-06-17 | Warren | Missouri | 29219 | 32 | 0 |
244812 | 244812 | 2020-06-16 | Warren | Missouri | 29219 | 32 | 0 |
241673 | 241673 | 2020-06-15 | Pike | Missouri | 29163 | 32 | 1 |
232341 | 232341 | 2020-06-12 | New Madrid | Missouri | 29143 | 32 | 1 |
226077 | 226077 | 2020-06-10 | Callaway | Missouri | 29027 | 32 | 1 |
222979 | 222979 | 2020-06-09 | Callaway | Missouri | 29027 | 32 | 1 |
216849 | 216849 | 2020-06-07 | Newton | Missouri | 29145 | 32 | 1 |
213704 | 213704 | 2020-06-06 | Callaway | Missouri | 29027 | 32 | 1 |
213761 | 213761 | 2020-06-06 | Newton | Missouri | 29145 | 32 | 1 |
210609 | 210609 | 2020-06-05 | Andrew | Missouri | 29003 | 32 | 0 |
210620 | 210620 | 2020-06-05 | Callaway | Missouri | 29027 | 32 | 1 |
207539 | 207539 | 2020-06-04 | Callaway | Missouri | 29027 | 32 | 1 |
198341 | 198341 | 2020-06-01 | Jasper | Missouri | 29097 | 32 | 0 |
195270 | 195270 | 2020-05-31 | Jasper | Missouri | 29097 | 32 | 0 |
192167 | 192167 | 2020-05-30 | Butler | Missouri | 29023 | 32 | 0 |
192201 | 192201 | 2020-05-30 | Jasper | Missouri | 29097 | 32 | 0 |
189103 | 189103 | 2020-05-29 | Butler | Missouri | 29023 | 32 | 0 |
189137 | 189137 | 2020-05-29 | Jasper | Missouri | 29097 | 32 | 0 |
186066 | 186066 | 2020-05-28 | Dunklin | Missouri | 29069 | 32 | 2 |
183071 | 183071 | 2020-05-27 | St. Francois | Missouri | 29187 | 32 | 2 |
180023 | 180023 | 2020-05-26 | St. Francois | Missouri | 29187 | 32 | 2 |
158685 | 158685 | 2020-05-19 | Butler | Missouri | 29023 | 32 | 0 |
119782 | 119782 | 2020-05-06 | Mississippi | Missouri | 29133 | 32 | 0 |
111070 | 111070 | 2020-05-03 | Pemiscot | Missouri | 29155 | 32 | 1 |
108198 | 108198 | 2020-05-02 | Pemiscot | Missouri | 29155 | 32 | 1 |
105333 | 105333 | 2020-05-01 | Pemiscot | Missouri | 29155 | 32 | 1 |
105338 | 105338 | 2020-05-01 | Platte | Missouri | 29165 | 32 | 0 |
102477 | 102477 | 2020-04-30 | Platte | Missouri | 29165 | 32 | 0 |
99625 | 99625 | 2020-04-29 | Platte | Missouri | 29165 | 32 | 0 |
85471 | 85471 | 2020-04-24 | Lafayette | Missouri | 29107 | 32 | 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);