ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
466 rows where cases = 9 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
- Cedar 56
- Cooper 47
- Harrison 26
- Morgan 23
- Wright 20
- Barry 19
- Dent 18
- Washington 17
- Henry 16
- Worth 16
- Schuyler 14
- New Madrid 13
- Caldwell 11
- Carroll 9
- Oregon 9
- Newton 8
- Daviess 7
- Montgomery 7
- Vernon 7
- Ralls 6
- Randolph 6
- Ste. Genevieve 6
- Benton 5
- Crawford 5
- Laclede 5
- Monroe 5
- Scotland 5
- Taney 5
- DeKalb 4
- Linn 4
- …
state 1
- Missouri · 466 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
445523 | 445523 | 2020-08-18 | Worth | Missouri | 29227 | 9 | 0 |
442297 | 442297 | 2020-08-17 | Worth | Missouri | 29227 | 9 | 0 |
439070 | 439070 | 2020-08-16 | Worth | Missouri | 29227 | 9 | 0 |
435845 | 435845 | 2020-08-15 | Worth | Missouri | 29227 | 9 | 0 |
432619 | 432619 | 2020-08-14 | Worth | Missouri | 29227 | 9 | 0 |
429392 | 429392 | 2020-08-13 | Worth | Missouri | 29227 | 9 | 0 |
426168 | 426168 | 2020-08-12 | Worth | Missouri | 29227 | 9 | 0 |
422946 | 422946 | 2020-08-11 | Worth | Missouri | 29227 | 9 | 0 |
419724 | 419724 | 2020-08-10 | Worth | Missouri | 29227 | 9 | 0 |
416503 | 416503 | 2020-08-09 | Worth | Missouri | 29227 | 9 | 0 |
413283 | 413283 | 2020-08-08 | Worth | Missouri | 29227 | 9 | 0 |
410063 | 410063 | 2020-08-07 | Worth | Missouri | 29227 | 9 | 0 |
406806 | 406806 | 2020-08-06 | Ozark | Missouri | 29153 | 9 | 0 |
406843 | 406843 | 2020-08-06 | Worth | Missouri | 29227 | 9 | 0 |
403542 | 403542 | 2020-08-05 | Dent | Missouri | 29065 | 9 | 0 |
403604 | 403604 | 2020-08-05 | Schuyler | Missouri | 29197 | 9 | 0 |
403625 | 403625 | 2020-08-05 | Worth | Missouri | 29227 | 9 | 0 |
400325 | 400325 | 2020-08-04 | Dent | Missouri | 29065 | 9 | 0 |
400387 | 400387 | 2020-08-04 | Schuyler | Missouri | 29197 | 9 | 0 |
400408 | 400408 | 2020-08-04 | Worth | Missouri | 29227 | 9 | 0 |
397111 | 397111 | 2020-08-03 | Dent | Missouri | 29065 | 9 | 0 |
397145 | 397145 | 2020-08-03 | Mercer | Missouri | 29129 | 9 | 0 |
397173 | 397173 | 2020-08-03 | Schuyler | Missouri | 29197 | 9 | 0 |
397194 | 397194 | 2020-08-03 | Worth | Missouri | 29227 | 9 | 0 |
393895 | 393895 | 2020-08-02 | Dent | Missouri | 29065 | 9 | 0 |
393929 | 393929 | 2020-08-02 | Mercer | Missouri | 29129 | 9 | 0 |
393957 | 393957 | 2020-08-02 | Schuyler | Missouri | 29197 | 9 | 0 |
390678 | 390678 | 2020-08-01 | Dent | Missouri | 29065 | 9 | 0 |
390740 | 390740 | 2020-08-01 | Schuyler | Missouri | 29197 | 9 | 0 |
387461 | 387461 | 2020-07-31 | Dent | Missouri | 29065 | 9 | 0 |
387482 | 387482 | 2020-07-31 | Knox | Missouri | 29103 | 9 | 0 |
387523 | 387523 | 2020-07-31 | Schuyler | Missouri | 29197 | 9 | 0 |
384243 | 384243 | 2020-07-30 | Dent | Missouri | 29065 | 9 | 0 |
384264 | 384264 | 2020-07-30 | Knox | Missouri | 29103 | 9 | 0 |
384305 | 384305 | 2020-07-30 | Schuyler | Missouri | 29197 | 9 | 0 |
381027 | 381027 | 2020-07-29 | Dent | Missouri | 29065 | 9 | 0 |
381089 | 381089 | 2020-07-29 | Schuyler | Missouri | 29197 | 9 | 0 |
377810 | 377810 | 2020-07-28 | Dent | Missouri | 29065 | 9 | 0 |
377824 | 377824 | 2020-07-28 | Iron | Missouri | 29093 | 9 | 0 |
377872 | 377872 | 2020-07-28 | Schuyler | Missouri | 29197 | 9 | 0 |
374595 | 374595 | 2020-07-27 | Dent | Missouri | 29065 | 9 | 0 |
374609 | 374609 | 2020-07-27 | Iron | Missouri | 29093 | 9 | 0 |
374633 | 374633 | 2020-07-27 | Monroe | Missouri | 29137 | 9 | 0 |
374657 | 374657 | 2020-07-27 | Schuyler | Missouri | 29197 | 9 | 0 |
371383 | 371383 | 2020-07-26 | Dent | Missouri | 29065 | 9 | 0 |
371397 | 371397 | 2020-07-26 | Iron | Missouri | 29093 | 9 | 0 |
371421 | 371421 | 2020-07-26 | Monroe | Missouri | 29137 | 9 | 0 |
371445 | 371445 | 2020-07-26 | Schuyler | Missouri | 29197 | 9 | 0 |
368172 | 368172 | 2020-07-25 | Dent | Missouri | 29065 | 9 | 0 |
368210 | 368210 | 2020-07-25 | Monroe | Missouri | 29137 | 9 | 0 |
368234 | 368234 | 2020-07-25 | Schuyler | Missouri | 29197 | 9 | 0 |
368238 | 368238 | 2020-07-25 | Shelby | Missouri | 29205 | 9 | 0 |
364964 | 364964 | 2020-07-24 | Dent | Missouri | 29065 | 9 | 0 |
364995 | 364995 | 2020-07-24 | Maries | Missouri | 29125 | 9 | 0 |
365002 | 365002 | 2020-07-24 | Monroe | Missouri | 29137 | 9 | 0 |
365026 | 365026 | 2020-07-24 | Schuyler | Missouri | 29197 | 9 | 0 |
365030 | 365030 | 2020-07-24 | Shelby | Missouri | 29205 | 9 | 0 |
365045 | 365045 | 2020-07-24 | Wayne | Missouri | 29223 | 9 | 0 |
361727 | 361727 | 2020-07-23 | Atchison | Missouri | 29005 | 9 | 0 |
361757 | 361757 | 2020-07-23 | Dent | Missouri | 29065 | 9 | 0 |
361788 | 361788 | 2020-07-23 | Maries | Missouri | 29125 | 9 | 0 |
361795 | 361795 | 2020-07-23 | Monroe | Missouri | 29137 | 9 | 0 |
361819 | 361819 | 2020-07-23 | Schuyler | Missouri | 29197 | 9 | 0 |
361823 | 361823 | 2020-07-23 | Shelby | Missouri | 29205 | 9 | 0 |
358537 | 358537 | 2020-07-22 | Carter | Missouri | 29035 | 9 | 1 |
358548 | 358548 | 2020-07-22 | Dade | Missouri | 29057 | 9 | 0 |
355334 | 355334 | 2020-07-21 | Carter | Missouri | 29035 | 9 | 1 |
352132 | 352132 | 2020-07-20 | Carter | Missouri | 29035 | 9 | 1 |
348977 | 348977 | 2020-07-19 | Madison | Missouri | 29123 | 9 | 0 |
345776 | 345776 | 2020-07-18 | Madison | Missouri | 29123 | 9 | 0 |
342546 | 342546 | 2020-07-17 | Dent | Missouri | 29065 | 9 | 0 |
339350 | 339350 | 2020-07-16 | Dent | Missouri | 29065 | 9 | 0 |
339394 | 339394 | 2020-07-16 | Oregon | Missouri | 29149 | 9 | 0 |
336154 | 336154 | 2020-07-15 | Dent | Missouri | 29065 | 9 | 0 |
336198 | 336198 | 2020-07-15 | Oregon | Missouri | 29149 | 9 | 0 |
332961 | 332961 | 2020-07-14 | Dent | Missouri | 29065 | 9 | 0 |
332986 | 332986 | 2020-07-14 | Lewis | Missouri | 29111 | 9 | 1 |
333005 | 333005 | 2020-07-14 | Oregon | Missouri | 29149 | 9 | 0 |
329799 | 329799 | 2020-07-13 | Lewis | Missouri | 29111 | 9 | 1 |
329818 | 329818 | 2020-07-13 | Oregon | Missouri | 29149 | 9 | 0 |
326632 | 326632 | 2020-07-12 | Oregon | Missouri | 29149 | 9 | 0 |
323449 | 323449 | 2020-07-11 | Oregon | Missouri | 29149 | 9 | 0 |
320270 | 320270 | 2020-07-10 | Oregon | Missouri | 29149 | 9 | 0 |
317095 | 317095 | 2020-07-09 | Oregon | Missouri | 29149 | 9 | 0 |
313921 | 313921 | 2020-07-08 | Oregon | Missouri | 29149 | 9 | 0 |
313954 | 313954 | 2020-07-08 | Texas | Missouri | 29215 | 9 | 0 |
310783 | 310783 | 2020-07-07 | Texas | Missouri | 29215 | 9 | 0 |
307537 | 307537 | 2020-07-06 | Daviess | Missouri | 29061 | 9 | 0 |
307583 | 307583 | 2020-07-06 | Osage | Missouri | 29151 | 9 | 0 |
307615 | 307615 | 2020-07-06 | Texas | Missouri | 29215 | 9 | 0 |
304370 | 304370 | 2020-07-05 | Daviess | Missouri | 29061 | 9 | 0 |
304416 | 304416 | 2020-07-05 | Osage | Missouri | 29151 | 9 | 0 |
301206 | 301206 | 2020-07-04 | Daviess | Missouri | 29061 | 9 | 0 |
301252 | 301252 | 2020-07-04 | Osage | Missouri | 29151 | 9 | 0 |
298043 | 298043 | 2020-07-03 | Daviess | Missouri | 29061 | 9 | 0 |
294874 | 294874 | 2020-07-02 | Cedar | Missouri | 29039 | 9 | 0 |
294885 | 294885 | 2020-07-02 | Daviess | Missouri | 29061 | 9 | 0 |
291720 | 291720 | 2020-07-01 | Cedar | Missouri | 29039 | 9 | 0 |
291731 | 291731 | 2020-07-01 | Daviess | Missouri | 29061 | 9 | 0 |
288562 | 288562 | 2020-06-30 | Caldwell | Missouri | 29025 | 9 | 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);