ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
675 rows where fips = 29085 and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
313887 | 313887 | 2020-07-08 | Hickory | Missouri | 29085 | 1 | 0 |
317061 | 317061 | 2020-07-09 | Hickory | Missouri | 29085 | 1 | 0 |
320236 | 320236 | 2020-07-10 | Hickory | Missouri | 29085 | 1 | 0 |
323415 | 323415 | 2020-07-11 | Hickory | Missouri | 29085 | 1 | 0 |
326598 | 326598 | 2020-07-12 | Hickory | Missouri | 29085 | 1 | 0 |
329784 | 329784 | 2020-07-13 | Hickory | Missouri | 29085 | 1 | 0 |
332971 | 332971 | 2020-07-14 | Hickory | Missouri | 29085 | 1 | 0 |
336164 | 336164 | 2020-07-15 | Hickory | Missouri | 29085 | 1 | 0 |
339360 | 339360 | 2020-07-16 | Hickory | Missouri | 29085 | 2 | 0 |
342556 | 342556 | 2020-07-17 | Hickory | Missouri | 29085 | 2 | 0 |
345756 | 345756 | 2020-07-18 | Hickory | Missouri | 29085 | 2 | 0 |
348957 | 348957 | 2020-07-19 | Hickory | Missouri | 29085 | 2 | 0 |
352157 | 352157 | 2020-07-20 | Hickory | Missouri | 29085 | 2 | 0 |
355359 | 355359 | 2020-07-21 | Hickory | Missouri | 29085 | 2 | 0 |
358562 | 358562 | 2020-07-22 | Hickory | Missouri | 29085 | 3 | 0 |
361767 | 361767 | 2020-07-23 | Hickory | Missouri | 29085 | 7 | 0 |
364974 | 364974 | 2020-07-24 | Hickory | Missouri | 29085 | 8 | 0 |
368182 | 368182 | 2020-07-25 | Hickory | Missouri | 29085 | 8 | 0 |
371393 | 371393 | 2020-07-26 | Hickory | Missouri | 29085 | 8 | 0 |
374605 | 374605 | 2020-07-27 | Hickory | Missouri | 29085 | 8 | 0 |
377820 | 377820 | 2020-07-28 | Hickory | Missouri | 29085 | 14 | 0 |
381037 | 381037 | 2020-07-29 | Hickory | Missouri | 29085 | 15 | 0 |
384253 | 384253 | 2020-07-30 | Hickory | Missouri | 29085 | 16 | 0 |
387471 | 387471 | 2020-07-31 | Hickory | Missouri | 29085 | 16 | 0 |
390688 | 390688 | 2020-08-01 | Hickory | Missouri | 29085 | 16 | 0 |
393905 | 393905 | 2020-08-02 | Hickory | Missouri | 29085 | 17 | 0 |
397121 | 397121 | 2020-08-03 | Hickory | Missouri | 29085 | 17 | 0 |
400335 | 400335 | 2020-08-04 | Hickory | Missouri | 29085 | 17 | 0 |
403552 | 403552 | 2020-08-05 | Hickory | Missouri | 29085 | 21 | 0 |
406770 | 406770 | 2020-08-06 | Hickory | Missouri | 29085 | 25 | 0 |
409990 | 409990 | 2020-08-07 | Hickory | Missouri | 29085 | 28 | 0 |
413210 | 413210 | 2020-08-08 | Hickory | Missouri | 29085 | 28 | 0 |
416430 | 416430 | 2020-08-09 | Hickory | Missouri | 29085 | 31 | 0 |
419651 | 419651 | 2020-08-10 | Hickory | Missouri | 29085 | 33 | 0 |
422873 | 422873 | 2020-08-11 | Hickory | Missouri | 29085 | 34 | 0 |
426095 | 426095 | 2020-08-12 | Hickory | Missouri | 29085 | 35 | 0 |
429319 | 429319 | 2020-08-13 | Hickory | Missouri | 29085 | 36 | 0 |
432546 | 432546 | 2020-08-14 | Hickory | Missouri | 29085 | 37 | 0 |
435772 | 435772 | 2020-08-15 | Hickory | Missouri | 29085 | 40 | 0 |
438997 | 438997 | 2020-08-16 | Hickory | Missouri | 29085 | 40 | 0 |
442224 | 442224 | 2020-08-17 | Hickory | Missouri | 29085 | 43 | 0 |
445450 | 445450 | 2020-08-18 | Hickory | Missouri | 29085 | 45 | 0 |
448676 | 448676 | 2020-08-19 | Hickory | Missouri | 29085 | 48 | 0 |
451904 | 451904 | 2020-08-20 | Hickory | Missouri | 29085 | 49 | 0 |
455132 | 455132 | 2020-08-21 | Hickory | Missouri | 29085 | 49 | 0 |
458360 | 458360 | 2020-08-22 | Hickory | Missouri | 29085 | 51 | 0 |
461587 | 461587 | 2020-08-23 | Hickory | Missouri | 29085 | 51 | 0 |
464818 | 464818 | 2020-08-24 | Hickory | Missouri | 29085 | 53 | 0 |
468047 | 468047 | 2020-08-25 | Hickory | Missouri | 29085 | 53 | 0 |
471277 | 471277 | 2020-08-26 | Hickory | Missouri | 29085 | 53 | 0 |
474509 | 474509 | 2020-08-27 | Hickory | Missouri | 29085 | 59 | 0 |
477742 | 477742 | 2020-08-28 | Hickory | Missouri | 29085 | 62 | 0 |
480974 | 480974 | 2020-08-29 | Hickory | Missouri | 29085 | 63 | 0 |
484209 | 484209 | 2020-08-30 | Hickory | Missouri | 29085 | 63 | 0 |
487443 | 487443 | 2020-08-31 | Hickory | Missouri | 29085 | 64 | 0 |
490676 | 490676 | 2020-09-01 | Hickory | Missouri | 29085 | 64 | 0 |
493910 | 493910 | 2020-09-02 | Hickory | Missouri | 29085 | 64 | 0 |
497143 | 497143 | 2020-09-03 | Hickory | Missouri | 29085 | 66 | 0 |
500377 | 500377 | 2020-09-04 | Hickory | Missouri | 29085 | 66 | 1 |
503611 | 503611 | 2020-09-05 | Hickory | Missouri | 29085 | 67 | 1 |
506844 | 506844 | 2020-09-06 | Hickory | Missouri | 29085 | 67 | 1 |
510077 | 510077 | 2020-09-07 | Hickory | Missouri | 29085 | 66 | 1 |
513309 | 513309 | 2020-09-08 | Hickory | Missouri | 29085 | 68 | 1 |
516543 | 516543 | 2020-09-09 | Hickory | Missouri | 29085 | 68 | 1 |
519778 | 519778 | 2020-09-10 | Hickory | Missouri | 29085 | 69 | 1 |
523015 | 523015 | 2020-09-11 | Hickory | Missouri | 29085 | 70 | 2 |
526251 | 526251 | 2020-09-12 | Hickory | Missouri | 29085 | 72 | 2 |
529487 | 529487 | 2020-09-13 | Hickory | Missouri | 29085 | 72 | 2 |
532723 | 532723 | 2020-09-14 | Hickory | Missouri | 29085 | 74 | 2 |
535958 | 535958 | 2020-09-15 | Hickory | Missouri | 29085 | 74 | 2 |
539195 | 539195 | 2020-09-16 | Hickory | Missouri | 29085 | 78 | 2 |
542431 | 542431 | 2020-09-17 | Hickory | Missouri | 29085 | 78 | 2 |
545668 | 545668 | 2020-09-18 | Hickory | Missouri | 29085 | 85 | 2 |
548906 | 548906 | 2020-09-19 | Hickory | Missouri | 29085 | 86 | 2 |
552145 | 552145 | 2020-09-20 | Hickory | Missouri | 29085 | 87 | 2 |
555383 | 555383 | 2020-09-21 | Hickory | Missouri | 29085 | 88 | 2 |
558620 | 558620 | 2020-09-22 | Hickory | Missouri | 29085 | 88 | 2 |
561857 | 561857 | 2020-09-23 | Hickory | Missouri | 29085 | 88 | 2 |
565097 | 565097 | 2020-09-24 | Hickory | Missouri | 29085 | 89 | 2 |
568337 | 568337 | 2020-09-25 | Hickory | Missouri | 29085 | 90 | 2 |
571579 | 571579 | 2020-09-26 | Hickory | Missouri | 29085 | 101 | 3 |
574822 | 574822 | 2020-09-27 | Hickory | Missouri | 29085 | 108 | 3 |
578063 | 578063 | 2020-09-28 | Hickory | Missouri | 29085 | 109 | 3 |
581304 | 581304 | 2020-09-29 | Hickory | Missouri | 29085 | 109 | 3 |
584545 | 584545 | 2020-09-30 | Hickory | Missouri | 29085 | 110 | 3 |
587785 | 587785 | 2020-10-01 | Hickory | Missouri | 29085 | 113 | 3 |
591026 | 591026 | 2020-10-02 | Hickory | Missouri | 29085 | 113 | 3 |
594267 | 594267 | 2020-10-03 | Hickory | Missouri | 29085 | 117 | 3 |
597508 | 597508 | 2020-10-04 | Hickory | Missouri | 29085 | 122 | 3 |
600751 | 600751 | 2020-10-05 | Hickory | Missouri | 29085 | 128 | 3 |
603993 | 603993 | 2020-10-06 | Hickory | Missouri | 29085 | 132 | 3 |
607236 | 607236 | 2020-10-07 | Hickory | Missouri | 29085 | 133 | 3 |
610478 | 610478 | 2020-10-08 | Hickory | Missouri | 29085 | 135 | 3 |
613720 | 613720 | 2020-10-09 | Hickory | Missouri | 29085 | 143 | 3 |
616961 | 616961 | 2020-10-10 | Hickory | Missouri | 29085 | 150 | 3 |
620203 | 620203 | 2020-10-11 | Hickory | Missouri | 29085 | 150 | 3 |
623446 | 623446 | 2020-10-12 | Hickory | Missouri | 29085 | 150 | 3 |
626688 | 626688 | 2020-10-13 | Hickory | Missouri | 29085 | 150 | 3 |
629932 | 629932 | 2020-10-14 | Hickory | Missouri | 29085 | 161 | 3 |
633177 | 633177 | 2020-10-15 | Hickory | Missouri | 29085 | 168 | 3 |
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);