ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 48 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
733814 | 733814 | 2020-11-15 | Worth | Missouri | 29227 | 48 | 0 |
730569 | 730569 | 2020-11-14 | Worth | Missouri | 29227 | 48 | 0 |
714304 | 714304 | 2020-11-09 | Mercer | Missouri | 29129 | 48 | 0 |
652697 | 652697 | 2020-10-21 | Putnam | Missouri | 29171 | 48 | 1 |
649452 | 649452 | 2020-10-20 | Putnam | Missouri | 29171 | 48 | 1 |
646208 | 646208 | 2020-10-19 | Putnam | Missouri | 29171 | 48 | 1 |
642962 | 642962 | 2020-10-18 | Putnam | Missouri | 29171 | 48 | 1 |
639714 | 639714 | 2020-10-17 | Putnam | Missouri | 29171 | 48 | 1 |
633230 | 633230 | 2020-10-15 | Scotland | Missouri | 29199 | 48 | 1 |
581282 | 581282 | 2020-09-29 | Chariton | Missouri | 29041 | 48 | 0 |
578041 | 578041 | 2020-09-28 | Chariton | Missouri | 29041 | 48 | 0 |
555394 | 555394 | 2020-09-21 | Knox | Missouri | 29103 | 48 | 1 |
552131 | 552131 | 2020-09-20 | Dade | Missouri | 29057 | 48 | 0 |
552156 | 552156 | 2020-09-20 | Knox | Missouri | 29103 | 48 | 1 |
548917 | 548917 | 2020-09-19 | Knox | Missouri | 29103 | 48 | 1 |
539199 | 539199 | 2020-09-16 | Iron | Missouri | 29093 | 48 | 0 |
529504 | 529504 | 2020-09-13 | Linn | Missouri | 29115 | 48 | 1 |
526268 | 526268 | 2020-09-12 | Linn | Missouri | 29115 | 48 | 1 |
510094 | 510094 | 2020-09-07 | Linn | Missouri | 29115 | 48 | 1 |
500357 | 500357 | 2020-09-04 | Clark | Missouri | 29045 | 48 | 0 |
500398 | 500398 | 2020-09-04 | Maries | Missouri | 29125 | 48 | 0 |
497123 | 497123 | 2020-09-03 | Clark | Missouri | 29045 | 48 | 0 |
493890 | 493890 | 2020-09-02 | Clark | Missouri | 29045 | 48 | 0 |
484213 | 484213 | 2020-08-30 | Iron | Missouri | 29093 | 48 | 0 |
480951 | 480951 | 2020-08-29 | Cedar | Missouri | 29039 | 48 | 0 |
477719 | 477719 | 2020-08-28 | Cedar | Missouri | 29039 | 48 | 0 |
461616 | 461616 | 2020-08-23 | Montgomery | Missouri | 29139 | 48 | 1 |
458389 | 458389 | 2020-08-22 | Montgomery | Missouri | 29139 | 48 | 1 |
455161 | 455161 | 2020-08-21 | Montgomery | Missouri | 29139 | 48 | 1 |
451893 | 451893 | 2020-08-20 | DeKalb | Missouri | 29063 | 48 | 1 |
448676 | 448676 | 2020-08-19 | Hickory | Missouri | 29085 | 48 | 0 |
422837 | 422837 | 2020-08-11 | Bates | Missouri | 29013 | 48 | 1 |
422888 | 422888 | 2020-08-11 | Lewis | Missouri | 29111 | 48 | 1 |
419615 | 419615 | 2020-08-10 | Bates | Missouri | 29013 | 48 | 1 |
416465 | 416465 | 2020-08-09 | Osage | Missouri | 29151 | 48 | 1 |
406820 | 406820 | 2020-08-06 | Ripley | Missouri | 29181 | 48 | 0 |
406838 | 406838 | 2020-08-06 | Vernon | Missouri | 29217 | 48 | 0 |
400397 | 400397 | 2020-08-04 | Ste. Genevieve | Missouri | 29186 | 48 | 1 |
390675 | 390675 | 2020-08-01 | Dallas | Missouri | 29059 | 48 | 1 |
381084 | 381084 | 2020-07-29 | Randolph | Missouri | 29175 | 48 | 1 |
371441 | 371441 | 2020-07-26 | Ray | Missouri | 29177 | 48 | 0 |
352131 | 352131 | 2020-07-20 | Carroll | Missouri | 29033 | 48 | 0 |
348920 | 348920 | 2020-07-19 | Barton | Missouri | 29011 | 48 | 0 |
348931 | 348931 | 2020-07-19 | Carroll | Missouri | 29033 | 48 | 0 |
348979 | 348979 | 2020-07-19 | Marion | Missouri | 29127 | 48 | 0 |
339434 | 339434 | 2020-07-16 | Wright | Missouri | 29229 | 48 | 0 |
317064 | 317064 | 2020-07-09 | Howell | Missouri | 29091 | 48 | 0 |
310730 | 310730 | 2020-07-07 | Lawrence | Missouri | 29109 | 48 | 1 |
310756 | 310756 | 2020-07-07 | Phelps | Missouri | 29161 | 48 | 0 |
310788 | 310788 | 2020-07-07 | Webster | Missouri | 29225 | 48 | 1 |
307560 | 307560 | 2020-07-06 | Laclede | Missouri | 29105 | 48 | 0 |
279214 | 279214 | 2020-06-27 | Taney | Missouri | 29213 | 48 | 2 |
260305 | 260305 | 2020-06-21 | Camden | Missouri | 29029 | 48 | 1 |
244715 | 244715 | 2020-06-16 | Butler | Missouri | 29023 | 48 | 0 |
222999 | 222999 | 2020-06-09 | Dunklin | Missouri | 29069 | 48 | 2 |
213724 | 213724 | 2020-06-06 | Dunklin | Missouri | 29069 | 48 | 2 |
210640 | 210640 | 2020-06-05 | Dunklin | Missouri | 29069 | 48 | 2 |
204510 | 204510 | 2020-06-03 | Moniteau | Missouri | 29135 | 48 | 1 |
201433 | 201433 | 2020-06-02 | Moniteau | Missouri | 29135 | 48 | 1 |
167836 | 167836 | 2020-05-22 | Perry | Missouri | 29157 | 48 | 0 |
164800 | 164800 | 2020-05-21 | Perry | Missouri | 29157 | 48 | 0 |
155717 | 155717 | 2020-05-18 | Mississippi | Missouri | 29133 | 48 | 0 |
119791 | 119791 | 2020-05-06 | Pemiscot | Missouri | 29155 | 48 | 3 |
113951 | 113951 | 2020-05-04 | Pettis | Missouri | 29159 | 48 | 0 |
111052 | 111052 | 2020-05-03 | Lincoln | Missouri | 29113 | 48 | 1 |
108180 | 108180 | 2020-05-02 | Lincoln | Missouri | 29113 | 48 | 1 |
96722 | 96722 | 2020-04-28 | Cape Girardeau | Missouri | 29031 | 48 | 1 |
93886 | 93886 | 2020-04-27 | Cape Girardeau | Missouri | 29031 | 48 | 1 |
88244 | 88244 | 2020-04-25 | Buchanan | Missouri | 29021 | 48 | 1 |
85434 | 85434 | 2020-04-24 | Buchanan | Missouri | 29021 | 48 | 1 |
71529 | 71529 | 2020-04-19 | Johnson | Missouri | 29101 | 48 | 0 |
68762 | 68762 | 2020-04-18 | Johnson | Missouri | 29101 | 48 | 0 |
66010 | 66010 | 2020-04-17 | Johnson | Missouri | 29101 | 48 | 0 |
52435 | 52435 | 2020-04-12 | Clay | Missouri | 29047 | 48 | 1 |
18697 | 18697 | 2020-03-29 | Jackson | Missouri | 29095 | 48 | 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);