ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 54 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 |
---|---|---|---|---|---|---|---|
746798 | 746798 | 2020-11-19 | Worth | Missouri | 29227 | 54 | 0 |
639647 | 639647 | 2020-10-17 | Chariton | Missouri | 29041 | 54 | 1 |
639718 | 639718 | 2020-10-17 | Reynolds | Missouri | 29179 | 54 | 0 |
636401 | 636401 | 2020-10-16 | Chariton | Missouri | 29041 | 54 | 1 |
636472 | 636472 | 2020-10-16 | Reynolds | Missouri | 29179 | 54 | 0 |
636476 | 636476 | 2020-10-16 | Scotland | Missouri | 29199 | 54 | 1 |
633155 | 633155 | 2020-10-15 | Chariton | Missouri | 29041 | 54 | 1 |
629910 | 629910 | 2020-10-14 | Chariton | Missouri | 29041 | 54 | 1 |
626666 | 626666 | 2020-10-13 | Chariton | Missouri | 29041 | 54 | 1 |
623424 | 623424 | 2020-10-12 | Chariton | Missouri | 29041 | 54 | 1 |
620181 | 620181 | 2020-10-11 | Chariton | Missouri | 29041 | 54 | 1 |
616939 | 616939 | 2020-10-10 | Chariton | Missouri | 29041 | 54 | 1 |
581264 | 581264 | 2020-09-29 | Atchison | Missouri | 29005 | 54 | 0 |
578023 | 578023 | 2020-09-28 | Atchison | Missouri | 29005 | 54 | 0 |
561843 | 561843 | 2020-09-23 | Dade | Missouri | 29057 | 54 | 0 |
558624 | 558624 | 2020-09-22 | Iron | Missouri | 29093 | 54 | 0 |
555387 | 555387 | 2020-09-21 | Iron | Missouri | 29093 | 54 | 0 |
529467 | 529467 | 2020-09-13 | Clark | Missouri | 29045 | 54 | 0 |
526231 | 526231 | 2020-09-12 | Clark | Missouri | 29045 | 54 | 0 |
497198 | 497198 | 2020-09-03 | Shannon | Missouri | 29203 | 54 | 1 |
493887 | 493887 | 2020-09-02 | Cedar | Missouri | 29039 | 54 | 0 |
493965 | 493965 | 2020-09-02 | Shannon | Missouri | 29203 | 54 | 1 |
471266 | 471266 | 2020-08-26 | DeKalb | Missouri | 29063 | 54 | 1 |
471292 | 471292 | 2020-08-26 | Lewis | Missouri | 29111 | 54 | 2 |
468062 | 468062 | 2020-08-25 | Lewis | Missouri | 29111 | 54 | 1 |
464833 | 464833 | 2020-08-24 | Lewis | Missouri | 29111 | 54 | 1 |
458361 | 458361 | 2020-08-22 | Holt | Missouri | 29087 | 54 | 0 |
455152 | 455152 | 2020-08-21 | Madison | Missouri | 29123 | 54 | 0 |
442188 | 442188 | 2020-08-17 | Bates | Missouri | 29013 | 54 | 1 |
442239 | 442239 | 2020-08-17 | Lewis | Missouri | 29111 | 54 | 1 |
438961 | 438961 | 2020-08-16 | Bates | Missouri | 29013 | 54 | 1 |
439012 | 439012 | 2020-08-16 | Lewis | Missouri | 29111 | 54 | 1 |
435736 | 435736 | 2020-08-15 | Bates | Missouri | 29013 | 54 | 1 |
435787 | 435787 | 2020-08-15 | Lewis | Missouri | 29111 | 54 | 1 |
435818 | 435818 | 2020-08-15 | Ralls | Missouri | 29173 | 54 | 0 |
432510 | 432510 | 2020-08-14 | Bates | Missouri | 29013 | 54 | 1 |
432561 | 432561 | 2020-08-14 | Lewis | Missouri | 29111 | 54 | 1 |
429354 | 429354 | 2020-08-13 | Osage | Missouri | 29151 | 54 | 1 |
422923 | 422923 | 2020-08-11 | Ripley | Missouri | 29181 | 54 | 0 |
422941 | 422941 | 2020-08-11 | Vernon | Missouri | 29217 | 54 | 0 |
406788 | 406788 | 2020-08-06 | Livingston | Missouri | 29117 | 54 | 0 |
400354 | 400354 | 2020-08-04 | Macon | Missouri | 29121 | 54 | 0 |
390758 | 390758 | 2020-08-01 | Washington | Missouri | 29221 | 54 | 1 |
384323 | 384323 | 2020-07-30 | Washington | Missouri | 29221 | 54 | 1 |
384327 | 384327 | 2020-07-30 | Wright | Missouri | 29229 | 54 | 0 |
377894 | 377894 | 2020-07-28 | Wright | Missouri | 29229 | 54 | 0 |
374604 | 374604 | 2020-07-27 | Henry | Missouri | 29083 | 54 | 3 |
374679 | 374679 | 2020-07-27 | Wright | Missouri | 29229 | 54 | 0 |
371434 | 371434 | 2020-07-26 | Pike | Missouri | 29163 | 54 | 1 |
371467 | 371467 | 2020-07-26 | Wright | Missouri | 29229 | 54 | 0 |
368223 | 368223 | 2020-07-25 | Pike | Missouri | 29163 | 54 | 1 |
365015 | 365015 | 2020-07-24 | Pike | Missouri | 29163 | 54 | 1 |
361741 | 361741 | 2020-07-23 | Carroll | Missouri | 29033 | 54 | 0 |
361808 | 361808 | 2020-07-23 | Pike | Missouri | 29163 | 54 | 1 |
336167 | 336167 | 2020-07-15 | Howell | Missouri | 29091 | 54 | 0 |
329856 | 329856 | 2020-07-13 | Webster | Missouri | 29225 | 54 | 1 |
320250 | 320250 | 2020-07-10 | Lawrence | Missouri | 29109 | 54 | 1 |
304361 | 304361 | 2020-07-05 | Christian | Missouri | 29043 | 54 | 1 |
301197 | 301197 | 2020-07-04 | Christian | Missouri | 29043 | 54 | 1 |
298034 | 298034 | 2020-07-03 | Christian | Missouri | 29043 | 54 | 1 |
294856 | 294856 | 2020-07-02 | Andrew | Missouri | 29003 | 54 | 0 |
294876 | 294876 | 2020-07-02 | Christian | Missouri | 29043 | 54 | 1 |
266559 | 266559 | 2020-06-23 | Camden | Missouri | 29029 | 54 | 1 |
257202 | 257202 | 2020-06-20 | Gentry | Missouri | 29075 | 54 | 9 |
254082 | 254082 | 2020-06-19 | Gentry | Missouri | 29075 | 54 | 9 |
250967 | 250967 | 2020-06-18 | Gentry | Missouri | 29075 | 54 | 9 |
247854 | 247854 | 2020-06-17 | Gentry | Missouri | 29075 | 54 | 8 |
244741 | 244741 | 2020-06-16 | Gentry | Missouri | 29075 | 54 | 8 |
241630 | 241630 | 2020-06-15 | Gentry | Missouri | 29075 | 54 | 8 |
238520 | 238520 | 2020-06-14 | Gentry | Missouri | 29075 | 54 | 6 |
235413 | 235413 | 2020-06-13 | Gentry | Missouri | 29075 | 54 | 6 |
232304 | 232304 | 2020-06-12 | Dunklin | Missouri | 29069 | 54 | 3 |
232307 | 232307 | 2020-06-12 | Gentry | Missouri | 29075 | 54 | 6 |
229200 | 229200 | 2020-06-11 | Dunklin | Missouri | 29069 | 54 | 3 |
229203 | 229203 | 2020-06-11 | Gentry | Missouri | 29075 | 54 | 4 |
226100 | 226100 | 2020-06-10 | Gentry | Missouri | 29075 | 54 | 4 |
223002 | 223002 | 2020-06-09 | Gentry | Missouri | 29075 | 54 | 4 |
219907 | 219907 | 2020-06-08 | Gentry | Missouri | 29075 | 54 | 4 |
186133 | 186133 | 2020-05-28 | Sullivan | Missouri | 29211 | 54 | 0 |
183040 | 183040 | 2020-05-27 | Mississippi | Missouri | 29133 | 54 | 0 |
170865 | 170865 | 2020-05-23 | Mississippi | Missouri | 29133 | 54 | 0 |
158689 | 158689 | 2020-05-19 | Cape Girardeau | Missouri | 29031 | 54 | 2 |
155671 | 155671 | 2020-05-18 | Cape Girardeau | Missouri | 29031 | 54 | 2 |
149646 | 149646 | 2020-05-16 | Cape Girardeau | Missouri | 29031 | 54 | 2 |
146701 | 146701 | 2020-05-15 | Platte | Missouri | 29165 | 54 | 0 |
128691 | 128691 | 2020-05-09 | Cole | Missouri | 29051 | 54 | 1 |
125704 | 125704 | 2020-05-08 | Cole | Missouri | 29051 | 54 | 1 |
125729 | 125729 | 2020-05-08 | Lincoln | Missouri | 29113 | 54 | 1 |
113906 | 113906 | 2020-05-04 | Cole | Missouri | 29051 | 54 | 1 |
111027 | 111027 | 2020-05-03 | Cole | Missouri | 29051 | 54 | 1 |
102450 | 102450 | 2020-04-30 | Johnson | Missouri | 29101 | 54 | 0 |
99598 | 99598 | 2020-04-29 | Johnson | Missouri | 29101 | 54 | 0 |
96752 | 96752 | 2020-04-28 | Johnson | Missouri | 29101 | 54 | 0 |
93916 | 93916 | 2020-04-27 | Johnson | Missouri | 29101 | 54 | 0 |
77056 | 77056 | 2020-04-21 | Cass | Missouri | 29037 | 54 | 6 |
77117 | 77117 | 2020-04-21 | Saline | Missouri | 29195 | 54 | 0 |
74336 | 74336 | 2020-04-20 | Saline | Missouri | 29195 | 54 | 0 |
71563 | 71563 | 2020-04-19 | Saline | Missouri | 29195 | 54 | 0 |
27282 | 27282 | 2020-04-02 | Greene | Missouri | 29077 | 54 | 6 |
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);