ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 28 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Mercer 16
- Butler 9
- Christian 6
- Morgan 6
- Putnam 6
- Pike 5
- Cooper 4
- Harrison 4
- Lafayette 4
- Linn 4
- Atchison 3
- Crawford 3
- Schuyler 3
- Scotland 3
- Barton 2
- Cape Girardeau 2
- Clinton 2
- Dallas 2
- Dunklin 2
- Hickory 2
- Livingston 2
- Osage 2
- Perry 2
- Reynolds 2
- Shelby 2
- St. Clair 2
- St. Francois 2
- Barry 1
- Bates 1
- Buchanan 1
- …
state 1
- Missouri · 133 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607288 | 607288 | 2020-10-07 | Schuyler | Missouri | 29197 | 28 | 0 |
604045 | 604045 | 2020-10-06 | Schuyler | Missouri | 29197 | 28 | 0 |
600803 | 600803 | 2020-10-05 | Schuyler | Missouri | 29197 | 28 | 0 |
584569 | 584569 | 2020-09-30 | Mercer | Missouri | 29129 | 28 | 0 |
581328 | 581328 | 2020-09-29 | Mercer | Missouri | 29129 | 28 | 0 |
578087 | 578087 | 2020-09-28 | Mercer | Missouri | 29129 | 28 | 0 |
574846 | 574846 | 2020-09-27 | Mercer | Missouri | 29129 | 28 | 0 |
571603 | 571603 | 2020-09-26 | Mercer | Missouri | 29129 | 28 | 0 |
568361 | 568361 | 2020-09-25 | Mercer | Missouri | 29129 | 28 | 0 |
565121 | 565121 | 2020-09-24 | Mercer | Missouri | 29129 | 28 | 0 |
561881 | 561881 | 2020-09-23 | Mercer | Missouri | 29129 | 28 | 0 |
558644 | 558644 | 2020-09-22 | Mercer | Missouri | 29129 | 28 | 0 |
555407 | 555407 | 2020-09-21 | Mercer | Missouri | 29129 | 28 | 0 |
555436 | 555436 | 2020-09-21 | Scotland | Missouri | 29199 | 28 | 1 |
552169 | 552169 | 2020-09-20 | Mercer | Missouri | 29129 | 28 | 0 |
552198 | 552198 | 2020-09-20 | Scotland | Missouri | 29199 | 28 | 1 |
548930 | 548930 | 2020-09-19 | Mercer | Missouri | 29129 | 28 | 0 |
548959 | 548959 | 2020-09-19 | Scotland | Missouri | 29199 | 28 | 1 |
545692 | 545692 | 2020-09-18 | Mercer | Missouri | 29129 | 28 | 0 |
542455 | 542455 | 2020-09-17 | Mercer | Missouri | 29129 | 28 | 0 |
542480 | 542480 | 2020-09-17 | Reynolds | Missouri | 29179 | 28 | 0 |
539219 | 539219 | 2020-09-16 | Mercer | Missouri | 29129 | 28 | 0 |
535982 | 535982 | 2020-09-15 | Mercer | Missouri | 29129 | 28 | 0 |
529536 | 529536 | 2020-09-13 | Reynolds | Missouri | 29179 | 28 | 0 |
516588 | 516588 | 2020-09-09 | Putnam | Missouri | 29171 | 28 | 1 |
513354 | 513354 | 2020-09-08 | Putnam | Missouri | 29171 | 28 | 1 |
510122 | 510122 | 2020-09-07 | Putnam | Missouri | 29171 | 28 | 1 |
506889 | 506889 | 2020-09-06 | Putnam | Missouri | 29171 | 28 | 1 |
503656 | 503656 | 2020-09-05 | Putnam | Missouri | 29171 | 28 | 1 |
500422 | 500422 | 2020-09-04 | Putnam | Missouri | 29171 | 28 | 1 |
500435 | 500435 | 2020-09-04 | St. Clair | Missouri | 29185 | 28 | 0 |
487403 | 487403 | 2020-08-31 | Atchison | Missouri | 29005 | 28 | 0 |
487421 | 487421 | 2020-08-31 | Chariton | Missouri | 29041 | 28 | 0 |
484169 | 484169 | 2020-08-30 | Atchison | Missouri | 29005 | 28 | 0 |
480934 | 480934 | 2020-08-29 | Atchison | Missouri | 29005 | 28 | 0 |
481032 | 481032 | 2020-08-29 | St. Clair | Missouri | 29185 | 28 | 0 |
458394 | 458394 | 2020-08-22 | Oregon | Missouri | 29149 | 28 | 0 |
439018 | 439018 | 2020-08-16 | Maries | Missouri | 29125 | 28 | 0 |
435752 | 435752 | 2020-08-15 | Clark | Missouri | 29045 | 28 | 0 |
426115 | 426115 | 2020-08-12 | Madison | Missouri | 29123 | 28 | 0 |
413210 | 413210 | 2020-08-08 | Hickory | Missouri | 29085 | 28 | 0 |
409990 | 409990 | 2020-08-07 | Hickory | Missouri | 29085 | 28 | 0 |
393961 | 393961 | 2020-08-02 | Shelby | Missouri | 29205 | 28 | 0 |
390744 | 390744 | 2020-08-01 | Shelby | Missouri | 29205 | 28 | 0 |
381052 | 381052 | 2020-07-29 | Lewis | Missouri | 29111 | 28 | 1 |
377837 | 377837 | 2020-07-28 | Linn | Missouri | 29115 | 28 | 1 |
374575 | 374575 | 2020-07-27 | Caldwell | Missouri | 29025 | 28 | 1 |
374594 | 374594 | 2020-07-27 | DeKalb | Missouri | 29063 | 28 | 1 |
374622 | 374622 | 2020-07-27 | Linn | Missouri | 29115 | 28 | 1 |
371410 | 371410 | 2020-07-26 | Linn | Missouri | 29115 | 28 | 1 |
368199 | 368199 | 2020-07-25 | Linn | Missouri | 29115 | 28 | 1 |
364938 | 364938 | 2020-07-24 | Bates | Missouri | 29013 | 28 | 1 |
361802 | 361802 | 2020-07-23 | Osage | Missouri | 29151 | 28 | 0 |
355394 | 355394 | 2020-07-21 | Osage | Missouri | 29151 | 28 | 0 |
352142 | 352142 | 2020-07-20 | Crawford | Missouri | 29055 | 28 | 0 |
352144 | 352144 | 2020-07-20 | Dallas | Missouri | 29059 | 28 | 1 |
352148 | 352148 | 2020-07-20 | Douglas | Missouri | 29067 | 28 | 1 |
348942 | 348942 | 2020-07-19 | Crawford | Missouri | 29055 | 28 | 0 |
348944 | 348944 | 2020-07-19 | Dallas | Missouri | 29059 | 28 | 1 |
345741 | 345741 | 2020-07-18 | Crawford | Missouri | 29055 | 28 | 0 |
342574 | 342574 | 2020-07-17 | Livingston | Missouri | 29117 | 28 | 0 |
342586 | 342586 | 2020-07-17 | Morgan | Missouri | 29141 | 28 | 0 |
339378 | 339378 | 2020-07-16 | Livingston | Missouri | 29117 | 28 | 0 |
339390 | 339390 | 2020-07-16 | Morgan | Missouri | 29141 | 28 | 0 |
336194 | 336194 | 2020-07-15 | Morgan | Missouri | 29141 | 28 | 0 |
336234 | 336234 | 2020-07-15 | Washington | Missouri | 29221 | 28 | 1 |
332990 | 332990 | 2020-07-14 | Macon | Missouri | 29121 | 28 | 0 |
332996 | 332996 | 2020-07-14 | Miller | Missouri | 29131 | 28 | 0 |
333001 | 333001 | 2020-07-14 | Morgan | Missouri | 29141 | 28 | 0 |
329768 | 329768 | 2020-07-13 | Cooper | Missouri | 29053 | 28 | 0 |
329814 | 329814 | 2020-07-13 | Morgan | Missouri | 29141 | 28 | 0 |
329839 | 329839 | 2020-07-13 | Shannon | Missouri | 29203 | 28 | 0 |
326582 | 326582 | 2020-07-12 | Cooper | Missouri | 29053 | 28 | 0 |
326596 | 326596 | 2020-07-12 | Harrison | Missouri | 29081 | 28 | 0 |
326628 | 326628 | 2020-07-12 | Morgan | Missouri | 29141 | 28 | 0 |
323399 | 323399 | 2020-07-11 | Cooper | Missouri | 29053 | 28 | 0 |
323413 | 323413 | 2020-07-11 | Harrison | Missouri | 29081 | 28 | 0 |
320220 | 320220 | 2020-07-10 | Cooper | Missouri | 29053 | 28 | 0 |
320234 | 320234 | 2020-07-10 | Harrison | Missouri | 29081 | 28 | 0 |
317059 | 317059 | 2020-07-09 | Harrison | Missouri | 29081 | 28 | 0 |
317129 | 317129 | 2020-07-09 | Vernon | Missouri | 29217 | 28 | 0 |
307531 | 307531 | 2020-07-06 | Clinton | Missouri | 29049 | 28 | 0 |
307596 | 307596 | 2020-07-06 | Ray | Missouri | 29177 | 28 | 0 |
307622 | 307622 | 2020-07-06 | Wright | Missouri | 29229 | 28 | 0 |
304345 | 304345 | 2020-07-05 | Barton | Missouri | 29011 | 28 | 0 |
301181 | 301181 | 2020-07-04 | Barton | Missouri | 29011 | 28 | 0 |
298037 | 298037 | 2020-07-03 | Clinton | Missouri | 29049 | 28 | 0 |
285513 | 285513 | 2020-06-29 | Webster | Missouri | 29225 | 28 | 1 |
276014 | 276014 | 2020-06-26 | Lawrence | Missouri | 29109 | 28 | 0 |
254049 | 254049 | 2020-06-19 | Barry | Missouri | 29009 | 28 | 0 |
247861 | 247861 | 2020-06-17 | Howell | Missouri | 29091 | 28 | 0 |
229188 | 229188 | 2020-06-11 | Christian | Missouri | 29043 | 28 | 0 |
229237 | 229237 | 2020-06-11 | New Madrid | Missouri | 29143 | 28 | 1 |
226085 | 226085 | 2020-06-10 | Christian | Missouri | 29043 | 28 | 0 |
222987 | 222987 | 2020-06-09 | Christian | Missouri | 29043 | 28 | 0 |
223044 | 223044 | 2020-06-09 | Pike | Missouri | 29163 | 28 | 1 |
219892 | 219892 | 2020-06-08 | Christian | Missouri | 29043 | 28 | 0 |
219949 | 219949 | 2020-06-08 | Pike | Missouri | 29163 | 28 | 1 |
216800 | 216800 | 2020-06-07 | Christian | Missouri | 29043 | 28 | 0 |
216857 | 216857 | 2020-06-07 | Pike | Missouri | 29163 | 28 | 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);