ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where cases = 24 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Grundy 13
- Dunklin 9
- Jasper 9
- Warren 9
- Montgomery 4
- Ray 4
- St. Clair 4
- Butler 3
- Caldwell 3
- Camden 3
- Madison 3
- Maries 3
- St. Francois 3
- Ste. Genevieve 3
- Stoddard 3
- Andrew 2
- Bates 2
- Callaway 2
- Carter 2
- Christian 2
- Gasconade 2
- Iron 2
- Livingston 2
- Miller 2
- Newton 2
- Nodaway 2
- Schuyler 2
- Barton 1
- Cape Girardeau 1
- Chariton 1
- …
state 1
- Missouri · 126 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630005 | 630005 | 2020-10-14 | Worth | Missouri | 29227 | 24 | 0 |
581356 | 581356 | 2020-09-29 | Schuyler | Missouri | 29197 | 24 | 0 |
578115 | 578115 | 2020-09-28 | Schuyler | Missouri | 29197 | 24 | 0 |
536011 | 536011 | 2020-09-15 | Scotland | Missouri | 29199 | 24 | 1 |
506868 | 506868 | 2020-09-06 | Mercer | Missouri | 29129 | 24 | 0 |
490721 | 490721 | 2020-09-01 | Putnam | Missouri | 29171 | 24 | 1 |
484197 | 484197 | 2020-08-30 | Daviess | Missouri | 29061 | 24 | 0 |
477728 | 477728 | 2020-08-28 | Dade | Missouri | 29057 | 24 | 0 |
471255 | 471255 | 2020-08-26 | Chariton | Missouri | 29041 | 24 | 0 |
455107 | 455107 | 2020-08-21 | Carter | Missouri | 29035 | 24 | 1 |
451879 | 451879 | 2020-08-20 | Carter | Missouri | 29035 | 24 | 1 |
448734 | 448734 | 2020-08-19 | St. Clair | Missouri | 29185 | 24 | 0 |
445508 | 445508 | 2020-08-18 | St. Clair | Missouri | 29185 | 24 | 0 |
435776 | 435776 | 2020-08-15 | Iron | Missouri | 29093 | 24 | 0 |
429299 | 429299 | 2020-08-13 | Clark | Missouri | 29045 | 24 | 0 |
429323 | 429323 | 2020-08-13 | Iron | Missouri | 29093 | 24 | 0 |
426116 | 426116 | 2020-08-12 | Maries | Missouri | 29125 | 24 | 0 |
426153 | 426153 | 2020-08-12 | St. Clair | Missouri | 29185 | 24 | 0 |
422894 | 422894 | 2020-08-11 | Maries | Missouri | 29125 | 24 | 0 |
422931 | 422931 | 2020-08-11 | St. Clair | Missouri | 29185 | 24 | 0 |
419645 | 419645 | 2020-08-10 | Gasconade | Missouri | 29073 | 24 | 0 |
419672 | 419672 | 2020-08-10 | Maries | Missouri | 29125 | 24 | 0 |
416424 | 416424 | 2020-08-09 | Gasconade | Missouri | 29073 | 24 | 0 |
413230 | 413230 | 2020-08-08 | Madison | Missouri | 29123 | 24 | 0 |
410010 | 410010 | 2020-08-07 | Madison | Missouri | 29123 | 24 | 0 |
406790 | 406790 | 2020-08-06 | Madison | Missouri | 29123 | 24 | 0 |
403563 | 403563 | 2020-08-05 | Knox | Missouri | 29103 | 24 | 0 |
403580 | 403580 | 2020-08-05 | Monroe | Missouri | 29137 | 24 | 0 |
397118 | 397118 | 2020-08-03 | Grundy | Missouri | 29079 | 24 | 1 |
393902 | 393902 | 2020-08-02 | Grundy | Missouri | 29079 | 24 | 1 |
390685 | 390685 | 2020-08-01 | Grundy | Missouri | 29079 | 24 | 1 |
387468 | 387468 | 2020-07-31 | Grundy | Missouri | 29079 | 24 | 1 |
384250 | 384250 | 2020-07-30 | Grundy | Missouri | 29079 | 24 | 1 |
384299 | 384299 | 2020-07-30 | Ralls | Missouri | 29173 | 24 | 0 |
384324 | 384324 | 2020-07-30 | Wayne | Missouri | 29223 | 24 | 0 |
381034 | 381034 | 2020-07-29 | Grundy | Missouri | 29079 | 24 | 1 |
377817 | 377817 | 2020-07-28 | Grundy | Missouri | 29079 | 24 | 1 |
374602 | 374602 | 2020-07-27 | Grundy | Missouri | 29079 | 24 | 1 |
371390 | 371390 | 2020-07-26 | Grundy | Missouri | 29079 | 24 | 1 |
368179 | 368179 | 2020-07-25 | Grundy | Missouri | 29079 | 24 | 1 |
364971 | 364971 | 2020-07-24 | Grundy | Missouri | 29079 | 24 | 1 |
361731 | 361731 | 2020-07-23 | Bates | Missouri | 29013 | 24 | 1 |
361737 | 361737 | 2020-07-23 | Caldwell | Missouri | 29025 | 24 | 1 |
361764 | 361764 | 2020-07-23 | Grundy | Missouri | 29079 | 24 | 1 |
358526 | 358526 | 2020-07-22 | Bates | Missouri | 29013 | 24 | 1 |
358532 | 358532 | 2020-07-22 | Caldwell | Missouri | 29025 | 24 | 1 |
358559 | 358559 | 2020-07-22 | Grundy | Missouri | 29079 | 24 | 1 |
358591 | 358591 | 2020-07-22 | Montgomery | Missouri | 29139 | 24 | 0 |
355329 | 355329 | 2020-07-21 | Caldwell | Missouri | 29025 | 24 | 1 |
355361 | 355361 | 2020-07-21 | Howard | Missouri | 29089 | 24 | 0 |
355376 | 355376 | 2020-07-21 | Linn | Missouri | 29115 | 24 | 1 |
355388 | 355388 | 2020-07-21 | Montgomery | Missouri | 29139 | 24 | 0 |
352186 | 352186 | 2020-07-20 | Montgomery | Missouri | 29139 | 24 | 0 |
348986 | 348986 | 2020-07-19 | Montgomery | Missouri | 29139 | 24 | 0 |
345806 | 345806 | 2020-07-18 | Ripley | Missouri | 29181 | 24 | 0 |
336149 | 336149 | 2020-07-15 | Crawford | Missouri | 29055 | 24 | 0 |
329846 | 329846 | 2020-07-13 | Ste. Genevieve | Missouri | 29186 | 24 | 1 |
326623 | 326623 | 2020-07-12 | Miller | Missouri | 29131 | 24 | 0 |
326660 | 326660 | 2020-07-12 | Ste. Genevieve | Missouri | 29186 | 24 | 1 |
323434 | 323434 | 2020-07-11 | Macon | Missouri | 29121 | 24 | 0 |
323440 | 323440 | 2020-07-11 | Miller | Missouri | 29131 | 24 | 0 |
323477 | 323477 | 2020-07-11 | Ste. Genevieve | Missouri | 29186 | 24 | 1 |
320254 | 320254 | 2020-07-10 | Livingston | Missouri | 29117 | 24 | 0 |
320291 | 320291 | 2020-07-10 | Shannon | Missouri | 29203 | 24 | 0 |
317079 | 317079 | 2020-07-09 | Livingston | Missouri | 29117 | 24 | 0 |
313920 | 313920 | 2020-07-08 | Nodaway | Missouri | 29147 | 24 | 0 |
310749 | 310749 | 2020-07-07 | Nodaway | Missouri | 29147 | 24 | 0 |
285405 | 285405 | 2020-06-29 | Barton | Missouri | 29011 | 24 | 0 |
272929 | 272929 | 2020-06-25 | Webster | Missouri | 29225 | 24 | 1 |
241698 | 241698 | 2020-06-15 | Taney | Missouri | 29213 | 24 | 2 |
232357 | 232357 | 2020-06-12 | Ray | Missouri | 29177 | 24 | 0 |
229253 | 229253 | 2020-06-11 | Ray | Missouri | 29177 | 24 | 0 |
226134 | 226134 | 2020-06-10 | New Madrid | Missouri | 29143 | 24 | 1 |
226150 | 226150 | 2020-06-10 | Ray | Missouri | 29177 | 24 | 0 |
223051 | 223051 | 2020-06-09 | Ray | Missouri | 29177 | 24 | 0 |
207596 | 207596 | 2020-06-04 | Newton | Missouri | 29145 | 24 | 1 |
204515 | 204515 | 2020-06-03 | Newton | Missouri | 29145 | 24 | 1 |
201389 | 201389 | 2020-06-02 | Christian | Missouri | 29043 | 24 | 0 |
198316 | 198316 | 2020-06-01 | Christian | Missouri | 29043 | 24 | 0 |
179934 | 179934 | 2020-05-26 | Andrew | Missouri | 29003 | 24 | 0 |
176890 | 176890 | 2020-05-25 | Andrew | Missouri | 29003 | 24 | 0 |
173858 | 173858 | 2020-05-24 | Callaway | Missouri | 29027 | 24 | 1 |
170816 | 170816 | 2020-05-23 | Callaway | Missouri | 29027 | 24 | 1 |
149730 | 149730 | 2020-05-16 | Warren | Missouri | 29219 | 24 | 0 |
146658 | 146658 | 2020-05-15 | Dunklin | Missouri | 29069 | 24 | 2 |
146724 | 146724 | 2020-05-15 | Warren | Missouri | 29219 | 24 | 0 |
143657 | 143657 | 2020-05-14 | Dunklin | Missouri | 29069 | 24 | 2 |
143723 | 143723 | 2020-05-14 | Warren | Missouri | 29219 | 24 | 0 |
140662 | 140662 | 2020-05-13 | Dunklin | Missouri | 29069 | 24 | 2 |
140728 | 140728 | 2020-05-13 | Warren | Missouri | 29219 | 24 | 0 |
137668 | 137668 | 2020-05-12 | Dunklin | Missouri | 29069 | 24 | 2 |
137734 | 137734 | 2020-05-12 | Warren | Missouri | 29219 | 24 | 0 |
134678 | 134678 | 2020-05-11 | Dunklin | Missouri | 29069 | 24 | 2 |
134744 | 134744 | 2020-05-11 | Warren | Missouri | 29219 | 24 | 0 |
131687 | 131687 | 2020-05-10 | Dunklin | Missouri | 29069 | 24 | 2 |
131753 | 131753 | 2020-05-10 | Warren | Missouri | 29219 | 24 | 0 |
128697 | 128697 | 2020-05-09 | Dunklin | Missouri | 29069 | 24 | 2 |
128763 | 128763 | 2020-05-09 | Warren | Missouri | 29219 | 24 | 0 |
125710 | 125710 | 2020-05-08 | Dunklin | Missouri | 29069 | 24 | 2 |
125722 | 125722 | 2020-05-08 | Jasper | Missouri | 29097 | 24 | 0 |
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);