ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
215 rows where cases = 13 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Taney 18
- Washington 12
- Putnam 11
- Schuyler 10
- Gasconade 8
- Chariton 7
- Webster 7
- Benton 6
- Morgan 6
- Linn 5
- Montgomery 5
- Newton 5
- Pike 5
- Dallas 4
- Daviess 4
- New Madrid 4
- Polk 4
- Atchison 3
- Bates 3
- Caldwell 3
- Cooper 3
- Harrison 3
- Jasper 3
- Lewis 3
- Nodaway 3
- Oregon 3
- Pemiscot 3
- Pettis 3
- Ste. Genevieve 3
- Vernon 3
- …
state 1
- Missouri · 215 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
500450 | 500450 | 2020-09-04 | Worth | Missouri | 29227 | 13 | 0 |
497216 | 497216 | 2020-09-03 | Worth | Missouri | 29227 | 13 | 0 |
493983 | 493983 | 2020-09-02 | Worth | Missouri | 29227 | 13 | 0 |
468099 | 468099 | 2020-08-25 | Schuyler | Missouri | 29197 | 13 | 0 |
464870 | 464870 | 2020-08-24 | Schuyler | Missouri | 29197 | 13 | 0 |
461639 | 461639 | 2020-08-23 | Schuyler | Missouri | 29197 | 13 | 0 |
458412 | 458412 | 2020-08-22 | Schuyler | Missouri | 29197 | 13 | 0 |
455184 | 455184 | 2020-08-21 | Schuyler | Missouri | 29197 | 13 | 0 |
451956 | 451956 | 2020-08-20 | Schuyler | Missouri | 29197 | 13 | 0 |
448728 | 448728 | 2020-08-19 | Schuyler | Missouri | 29197 | 13 | 0 |
445502 | 445502 | 2020-08-18 | Schuyler | Missouri | 29197 | 13 | 0 |
442276 | 442276 | 2020-08-17 | Schuyler | Missouri | 29197 | 13 | 0 |
439049 | 439049 | 2020-08-16 | Schuyler | Missouri | 29197 | 13 | 0 |
435817 | 435817 | 2020-08-15 | Putnam | Missouri | 29171 | 13 | 1 |
432591 | 432591 | 2020-08-14 | Putnam | Missouri | 29171 | 13 | 1 |
429343 | 429343 | 2020-08-13 | Mercer | Missouri | 29129 | 13 | 0 |
429364 | 429364 | 2020-08-13 | Putnam | Missouri | 29171 | 13 | 1 |
426119 | 426119 | 2020-08-12 | Mercer | Missouri | 29129 | 13 | 0 |
426140 | 426140 | 2020-08-12 | Putnam | Missouri | 29171 | 13 | 1 |
422918 | 422918 | 2020-08-11 | Putnam | Missouri | 29171 | 13 | 1 |
419696 | 419696 | 2020-08-10 | Putnam | Missouri | 29171 | 13 | 1 |
416475 | 416475 | 2020-08-09 | Putnam | Missouri | 29171 | 13 | 1 |
413255 | 413255 | 2020-08-08 | Putnam | Missouri | 29171 | 13 | 1 |
410035 | 410035 | 2020-08-07 | Putnam | Missouri | 29171 | 13 | 1 |
406815 | 406815 | 2020-08-06 | Putnam | Missouri | 29171 | 13 | 1 |
403597 | 403597 | 2020-08-05 | Putnam | Missouri | 29171 | 13 | 1 |
390668 | 390668 | 2020-08-01 | Clark | Missouri | 29045 | 13 | 0 |
390722 | 390722 | 2020-08-01 | Oregon | Missouri | 29149 | 13 | 0 |
387505 | 387505 | 2020-07-31 | Oregon | Missouri | 29149 | 13 | 0 |
384281 | 384281 | 2020-07-30 | Monroe | Missouri | 29137 | 13 | 0 |
384287 | 384287 | 2020-07-30 | Oregon | Missouri | 29149 | 13 | 0 |
374565 | 374565 | 2020-07-27 | Atchison | Missouri | 29005 | 13 | 0 |
374599 | 374599 | 2020-07-27 | Gasconade | Missouri | 29073 | 13 | 0 |
371353 | 371353 | 2020-07-26 | Atchison | Missouri | 29005 | 13 | 0 |
371371 | 371371 | 2020-07-26 | Chariton | Missouri | 29041 | 13 | 0 |
371387 | 371387 | 2020-07-26 | Gasconade | Missouri | 29073 | 13 | 0 |
371451 | 371451 | 2020-07-26 | St. Clair | Missouri | 29185 | 13 | 0 |
368142 | 368142 | 2020-07-25 | Atchison | Missouri | 29005 | 13 | 0 |
368160 | 368160 | 2020-07-25 | Chariton | Missouri | 29041 | 13 | 0 |
368176 | 368176 | 2020-07-25 | Gasconade | Missouri | 29073 | 13 | 0 |
364952 | 364952 | 2020-07-24 | Chariton | Missouri | 29041 | 13 | 0 |
364968 | 364968 | 2020-07-24 | Gasconade | Missouri | 29073 | 13 | 0 |
364989 | 364989 | 2020-07-24 | Lewis | Missouri | 29111 | 13 | 1 |
361745 | 361745 | 2020-07-23 | Chariton | Missouri | 29041 | 13 | 0 |
361782 | 361782 | 2020-07-23 | Lewis | Missouri | 29111 | 13 | 1 |
361787 | 361787 | 2020-07-23 | Madison | Missouri | 29123 | 13 | 0 |
358577 | 358577 | 2020-07-22 | Lewis | Missouri | 29111 | 13 | 1 |
358582 | 358582 | 2020-07-22 | Madison | Missouri | 29123 | 13 | 0 |
352135 | 352135 | 2020-07-20 | Chariton | Missouri | 29041 | 13 | 0 |
352145 | 352145 | 2020-07-20 | Daviess | Missouri | 29061 | 13 | 0 |
348935 | 348935 | 2020-07-19 | Chariton | Missouri | 29041 | 13 | 0 |
348945 | 348945 | 2020-07-19 | Daviess | Missouri | 29061 | 13 | 0 |
345734 | 345734 | 2020-07-18 | Chariton | Missouri | 29041 | 13 | 0 |
345744 | 345744 | 2020-07-18 | Daviess | Missouri | 29061 | 13 | 0 |
342544 | 342544 | 2020-07-17 | Daviess | Missouri | 29061 | 13 | 0 |
339427 | 339427 | 2020-07-16 | Texas | Missouri | 29215 | 13 | 0 |
333038 | 333038 | 2020-07-14 | Texas | Missouri | 29215 | 13 | 0 |
329775 | 329775 | 2020-07-13 | Douglas | Missouri | 29067 | 13 | 0 |
326562 | 326562 | 2020-07-12 | Bates | Missouri | 29013 | 13 | 1 |
326633 | 326633 | 2020-07-12 | Osage | Missouri | 29151 | 13 | 0 |
323379 | 323379 | 2020-07-11 | Bates | Missouri | 29013 | 13 | 1 |
323450 | 323450 | 2020-07-11 | Osage | Missouri | 29151 | 13 | 0 |
320200 | 320200 | 2020-07-10 | Bates | Missouri | 29013 | 13 | 1 |
317055 | 317055 | 2020-07-09 | Gasconade | Missouri | 29073 | 13 | 0 |
313881 | 313881 | 2020-07-08 | Gasconade | Missouri | 29073 | 13 | 0 |
310763 | 310763 | 2020-07-07 | Randolph | Missouri | 29175 | 13 | 0 |
307519 | 307519 | 2020-07-06 | Caldwell | Missouri | 29025 | 13 | 0 |
307595 | 307595 | 2020-07-06 | Randolph | Missouri | 29175 | 13 | 0 |
304352 | 304352 | 2020-07-05 | Caldwell | Missouri | 29025 | 13 | 0 |
301188 | 301188 | 2020-07-04 | Caldwell | Missouri | 29025 | 13 | 0 |
298109 | 298109 | 2020-07-03 | Shannon | Missouri | 29203 | 13 | 0 |
294882 | 294882 | 2020-07-02 | Crawford | Missouri | 29055 | 13 | 0 |
294886 | 294886 | 2020-07-02 | DeKalb | Missouri | 29063 | 13 | 0 |
294914 | 294914 | 2020-07-02 | Livingston | Missouri | 29117 | 13 | 0 |
291730 | 291730 | 2020-07-01 | Dallas | Missouri | 29059 | 13 | 1 |
291732 | 291732 | 2020-07-01 | DeKalb | Missouri | 29063 | 13 | 0 |
291737 | 291737 | 2020-07-01 | Gasconade | Missouri | 29073 | 13 | 0 |
291760 | 291760 | 2020-07-01 | Livingston | Missouri | 29117 | 13 | 0 |
288579 | 288579 | 2020-06-30 | Dallas | Missouri | 29059 | 13 | 1 |
288586 | 288586 | 2020-06-30 | Gasconade | Missouri | 29073 | 13 | 0 |
285429 | 285429 | 2020-06-29 | Dallas | Missouri | 29059 | 13 | 1 |
285440 | 285440 | 2020-06-29 | Harrison | Missouri | 29081 | 13 | 0 |
285471 | 285471 | 2020-06-29 | Morgan | Missouri | 29141 | 13 | 0 |
285484 | 285484 | 2020-06-29 | Polk | Missouri | 29167 | 13 | 0 |
282284 | 282284 | 2020-06-28 | Dallas | Missouri | 29059 | 13 | 1 |
282295 | 282295 | 2020-06-28 | Harrison | Missouri | 29081 | 13 | 0 |
282326 | 282326 | 2020-06-28 | Morgan | Missouri | 29141 | 13 | 0 |
282339 | 282339 | 2020-06-28 | Polk | Missouri | 29167 | 13 | 0 |
282360 | 282360 | 2020-06-28 | Stone | Missouri | 29209 | 13 | 0 |
279147 | 279147 | 2020-06-27 | Harrison | Missouri | 29081 | 13 | 0 |
279178 | 279178 | 2020-06-27 | Morgan | Missouri | 29141 | 13 | 0 |
279191 | 279191 | 2020-06-27 | Polk | Missouri | 29167 | 13 | 0 |
275967 | 275967 | 2020-06-26 | Bollinger | Missouri | 29017 | 13 | 0 |
276030 | 276030 | 2020-06-26 | Morgan | Missouri | 29141 | 13 | 0 |
276043 | 276043 | 2020-06-26 | Polk | Missouri | 29167 | 13 | 0 |
272887 | 272887 | 2020-06-25 | Morgan | Missouri | 29141 | 13 | 0 |
269704 | 269704 | 2020-06-24 | Cooper | Missouri | 29053 | 13 | 0 |
269740 | 269740 | 2020-06-24 | Marion | Missouri | 29127 | 13 | 0 |
269748 | 269748 | 2020-06-24 | Morgan | Missouri | 29141 | 13 | 0 |
269787 | 269787 | 2020-06-24 | Vernon | Missouri | 29217 | 13 | 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);