ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 77 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
675320 | 675320 | 2020-10-28 | Atchison | Missouri | 29005 | 77 | 1 |
672077 | 672077 | 2020-10-27 | Atchison | Missouri | 29005 | 77 | 1 |
668835 | 668835 | 2020-10-26 | Atchison | Missouri | 29005 | 77 | 1 |
610534 | 610534 | 2020-10-08 | Shelby | Missouri | 29205 | 77 | 1 |
597566 | 597566 | 2020-10-04 | St. Clair | Missouri | 29185 | 77 | 0 |
558635 | 558635 | 2020-09-22 | Lewis | Missouri | 29111 | 77 | 2 |
552120 | 552120 | 2020-09-20 | Carter | Missouri | 29035 | 77 | 1 |
542408 | 542408 | 2020-09-17 | Cedar | Missouri | 29039 | 77 | 0 |
497161 | 497161 | 2020-09-03 | Livingston | Missouri | 29117 | 77 | 1 |
493874 | 493874 | 2020-09-02 | Bates | Missouri | 29013 | 77 | 1 |
490640 | 490640 | 2020-09-01 | Bates | Missouri | 29013 | 77 | 1 |
487407 | 487407 | 2020-08-31 | Bates | Missouri | 29013 | 77 | 1 |
471345 | 471345 | 2020-08-26 | Vernon | Missouri | 29217 | 77 | 0 |
468067 | 468067 | 2020-08-25 | Madison | Missouri | 29123 | 77 | 0 |
464838 | 464838 | 2020-08-24 | Madison | Missouri | 29123 | 77 | 0 |
458434 | 458434 | 2020-08-22 | Wright | Missouri | 29229 | 77 | 0 |
451906 | 451906 | 2020-08-20 | Howard | Missouri | 29089 | 77 | 0 |
451954 | 451954 | 2020-08-20 | Ripley | Missouri | 29181 | 77 | 0 |
451978 | 451978 | 2020-08-20 | Wright | Missouri | 29229 | 77 | 0 |
448726 | 448726 | 2020-08-19 | Ripley | Missouri | 29181 | 77 | 0 |
429285 | 429285 | 2020-08-13 | Bollinger | Missouri | 29017 | 77 | 1 |
416500 | 416500 | 2020-08-09 | Washington | Missouri | 29221 | 77 | 1 |
384237 | 384237 | 2020-07-30 | Cooper | Missouri | 29053 | 77 | 0 |
317033 | 317033 | 2020-07-09 | Camden | Missouri | 29029 | 77 | 2 |
288575 | 288575 | 2020-06-30 | Cole | Missouri | 29051 | 77 | 2 |
260357 | 260357 | 2020-06-21 | Mississippi | Missouri | 29133 | 77 | 0 |
257231 | 257231 | 2020-06-20 | Mississippi | Missouri | 29133 | 77 | 0 |
254111 | 254111 | 2020-06-19 | Mississippi | Missouri | 29133 | 77 | 0 |
250996 | 250996 | 2020-06-18 | Mississippi | Missouri | 29133 | 77 | 0 |
241697 | 241697 | 2020-06-15 | Sullivan | Missouri | 29211 | 77 | 0 |
238587 | 238587 | 2020-06-14 | Sullivan | Missouri | 29211 | 77 | 0 |
235480 | 235480 | 2020-06-13 | Sullivan | Missouri | 29211 | 77 | 0 |
216827 | 216827 | 2020-06-07 | Johnson | Missouri | 29101 | 77 | 0 |
213739 | 213739 | 2020-06-06 | Johnson | Missouri | 29101 | 77 | 0 |
210655 | 210655 | 2020-06-05 | Johnson | Missouri | 29101 | 77 | 0 |
207541 | 207541 | 2020-06-04 | Cape Girardeau | Missouri | 29031 | 77 | 2 |
207574 | 207574 | 2020-06-04 | Johnson | Missouri | 29101 | 77 | 0 |
207605 | 207605 | 2020-06-04 | Platte | Missouri | 29165 | 77 | 2 |
204493 | 204493 | 2020-06-03 | Johnson | Missouri | 29101 | 77 | 0 |
201444 | 201444 | 2020-06-02 | Pettis | Missouri | 29159 | 77 | 1 |
198371 | 198371 | 2020-06-01 | Pettis | Missouri | 29159 | 77 | 1 |
195300 | 195300 | 2020-05-31 | Pettis | Missouri | 29159 | 77 | 1 |
192230 | 192230 | 2020-05-30 | Pettis | Missouri | 29159 | 77 | 1 |
189166 | 189166 | 2020-05-29 | Pettis | Missouri | 29159 | 77 | 1 |
186108 | 186108 | 2020-05-28 | Pettis | Missouri | 29159 | 77 | 1 |
170821 | 170821 | 2020-05-23 | Cass | Missouri | 29037 | 77 | 8 |
167783 | 167783 | 2020-05-22 | Cass | Missouri | 29037 | 77 | 8 |
164747 | 164747 | 2020-05-21 | Cass | Missouri | 29037 | 77 | 8 |
161718 | 161718 | 2020-05-20 | Cass | Missouri | 29037 | 77 | 8 |
146678 | 146678 | 2020-05-15 | Lincoln | Missouri | 29113 | 77 | 1 |
134698 | 134698 | 2020-05-11 | Lincoln | Missouri | 29113 | 77 | 1 |
122780 | 122780 | 2020-05-07 | Scott | Missouri | 29201 | 77 | 2 |
111025 | 111025 | 2020-05-03 | Clay | Missouri | 29047 | 77 | 1 |
108154 | 108154 | 2020-05-02 | Clay | Missouri | 29047 | 77 | 1 |
105289 | 105289 | 2020-05-01 | Clay | Missouri | 29047 | 77 | 1 |
47102 | 47102 | 2020-04-10 | Boone | Missouri | 29019 | 77 | 1 |
39362 | 39362 | 2020-04-07 | Boone | Missouri | 29019 | 77 | 1 |
22842 | 22842 | 2020-03-31 | Jackson | Missouri | 29095 | 77 | 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);