ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
658 rows where county = "Doddridge" and state = "West Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
369720 | 369720 | 2020-07-25 | Doddridge | West Virginia | 54017 | 1 | 0 |
372932 | 372932 | 2020-07-26 | Doddridge | West Virginia | 54017 | 2 | 0 |
376146 | 376146 | 2020-07-27 | Doddridge | West Virginia | 54017 | 2 | 0 |
379362 | 379362 | 2020-07-28 | Doddridge | West Virginia | 54017 | 2 | 0 |
382579 | 382579 | 2020-07-29 | Doddridge | West Virginia | 54017 | 4 | 0 |
385797 | 385797 | 2020-07-30 | Doddridge | West Virginia | 54017 | 4 | 0 |
389014 | 389014 | 2020-07-31 | Doddridge | West Virginia | 54017 | 4 | 0 |
392231 | 392231 | 2020-08-01 | Doddridge | West Virginia | 54017 | 4 | 0 |
395447 | 395447 | 2020-08-02 | Doddridge | West Virginia | 54017 | 4 | 0 |
398663 | 398663 | 2020-08-03 | Doddridge | West Virginia | 54017 | 4 | 0 |
401879 | 401879 | 2020-08-04 | Doddridge | West Virginia | 54017 | 4 | 0 |
405097 | 405097 | 2020-08-05 | Doddridge | West Virginia | 54017 | 4 | 0 |
408317 | 408317 | 2020-08-06 | Doddridge | West Virginia | 54017 | 5 | 0 |
411536 | 411536 | 2020-08-07 | Doddridge | West Virginia | 54017 | 5 | 0 |
414756 | 414756 | 2020-08-08 | Doddridge | West Virginia | 54017 | 6 | 0 |
417977 | 417977 | 2020-08-09 | Doddridge | West Virginia | 54017 | 6 | 0 |
421198 | 421198 | 2020-08-10 | Doddridge | West Virginia | 54017 | 6 | 0 |
424419 | 424419 | 2020-08-11 | Doddridge | West Virginia | 54017 | 6 | 0 |
427643 | 427643 | 2020-08-12 | Doddridge | West Virginia | 54017 | 6 | 0 |
430871 | 430871 | 2020-08-13 | Doddridge | West Virginia | 54017 | 6 | 0 |
434096 | 434096 | 2020-08-14 | Doddridge | West Virginia | 54017 | 6 | 0 |
437322 | 437322 | 2020-08-15 | Doddridge | West Virginia | 54017 | 6 | 0 |
440548 | 440548 | 2020-08-16 | Doddridge | West Virginia | 54017 | 6 | 0 |
443774 | 443774 | 2020-08-17 | Doddridge | West Virginia | 54017 | 6 | 0 |
447001 | 447001 | 2020-08-18 | Doddridge | West Virginia | 54017 | 6 | 0 |
450229 | 450229 | 2020-08-19 | Doddridge | West Virginia | 54017 | 6 | 0 |
453457 | 453457 | 2020-08-20 | Doddridge | West Virginia | 54017 | 6 | 0 |
456685 | 456685 | 2020-08-21 | Doddridge | West Virginia | 54017 | 6 | 0 |
459912 | 459912 | 2020-08-22 | Doddridge | West Virginia | 54017 | 6 | 0 |
463141 | 463141 | 2020-08-23 | Doddridge | West Virginia | 54017 | 6 | 0 |
466370 | 466370 | 2020-08-24 | Doddridge | West Virginia | 54017 | 6 | 0 |
469599 | 469599 | 2020-08-25 | Doddridge | West Virginia | 54017 | 6 | 0 |
472831 | 472831 | 2020-08-26 | Doddridge | West Virginia | 54017 | 6 | 0 |
476064 | 476064 | 2020-08-27 | Doddridge | West Virginia | 54017 | 6 | 0 |
479297 | 479297 | 2020-08-28 | Doddridge | West Virginia | 54017 | 6 | 0 |
482531 | 482531 | 2020-08-29 | Doddridge | West Virginia | 54017 | 6 | 0 |
485766 | 485766 | 2020-08-30 | Doddridge | West Virginia | 54017 | 6 | 0 |
488999 | 488999 | 2020-08-31 | Doddridge | West Virginia | 54017 | 6 | 0 |
492232 | 492232 | 2020-09-01 | Doddridge | West Virginia | 54017 | 6 | 0 |
495466 | 495466 | 2020-09-02 | Doddridge | West Virginia | 54017 | 6 | 0 |
498699 | 498699 | 2020-09-03 | Doddridge | West Virginia | 54017 | 7 | 0 |
501933 | 501933 | 2020-09-04 | Doddridge | West Virginia | 54017 | 9 | 0 |
505167 | 505167 | 2020-09-05 | Doddridge | West Virginia | 54017 | 11 | 0 |
508399 | 508399 | 2020-09-06 | Doddridge | West Virginia | 54017 | 11 | 0 |
511632 | 511632 | 2020-09-07 | Doddridge | West Virginia | 54017 | 13 | 0 |
514865 | 514865 | 2020-09-08 | Doddridge | West Virginia | 54017 | 13 | 0 |
518100 | 518100 | 2020-09-09 | Doddridge | West Virginia | 54017 | 13 | 0 |
521337 | 521337 | 2020-09-10 | Doddridge | West Virginia | 54017 | 14 | 0 |
524573 | 524573 | 2020-09-11 | Doddridge | West Virginia | 54017 | 15 | 0 |
527809 | 527809 | 2020-09-12 | Doddridge | West Virginia | 54017 | 17 | 0 |
531046 | 531046 | 2020-09-13 | Doddridge | West Virginia | 54017 | 17 | 0 |
534281 | 534281 | 2020-09-14 | Doddridge | West Virginia | 54017 | 17 | 0 |
537517 | 537517 | 2020-09-15 | Doddridge | West Virginia | 54017 | 17 | 0 |
540754 | 540754 | 2020-09-16 | Doddridge | West Virginia | 54017 | 17 | 0 |
543990 | 543990 | 2020-09-17 | Doddridge | West Virginia | 54017 | 17 | 0 |
547227 | 547227 | 2020-09-18 | Doddridge | West Virginia | 54017 | 17 | 0 |
550466 | 550466 | 2020-09-19 | Doddridge | West Virginia | 54017 | 18 | 0 |
553705 | 553705 | 2020-09-20 | Doddridge | West Virginia | 54017 | 18 | 0 |
556942 | 556942 | 2020-09-21 | Doddridge | West Virginia | 54017 | 18 | 0 |
560178 | 560178 | 2020-09-22 | Doddridge | West Virginia | 54017 | 18 | 0 |
563417 | 563417 | 2020-09-23 | Doddridge | West Virginia | 54017 | 18 | 0 |
566658 | 566658 | 2020-09-24 | Doddridge | West Virginia | 54017 | 19 | 0 |
569899 | 569899 | 2020-09-25 | Doddridge | West Virginia | 54017 | 22 | 1 |
573141 | 573141 | 2020-09-26 | Doddridge | West Virginia | 54017 | 23 | 1 |
576385 | 576385 | 2020-09-27 | Doddridge | West Virginia | 54017 | 25 | 1 |
579626 | 579626 | 2020-09-28 | Doddridge | West Virginia | 54017 | 25 | 1 |
582865 | 582865 | 2020-09-29 | Doddridge | West Virginia | 54017 | 26 | 1 |
586105 | 586105 | 2020-09-30 | Doddridge | West Virginia | 54017 | 27 | 1 |
589346 | 589346 | 2020-10-01 | Doddridge | West Virginia | 54017 | 28 | 1 |
592586 | 592586 | 2020-10-02 | Doddridge | West Virginia | 54017 | 32 | 1 |
595828 | 595828 | 2020-10-03 | Doddridge | West Virginia | 54017 | 32 | 1 |
599071 | 599071 | 2020-10-04 | Doddridge | West Virginia | 54017 | 32 | 1 |
602314 | 602314 | 2020-10-05 | Doddridge | West Virginia | 54017 | 32 | 1 |
605556 | 605556 | 2020-10-06 | Doddridge | West Virginia | 54017 | 35 | 1 |
608799 | 608799 | 2020-10-07 | Doddridge | West Virginia | 54017 | 36 | 1 |
612041 | 612041 | 2020-10-08 | Doddridge | West Virginia | 54017 | 39 | 1 |
615282 | 615282 | 2020-10-09 | Doddridge | West Virginia | 54017 | 40 | 1 |
618524 | 618524 | 2020-10-10 | Doddridge | West Virginia | 54017 | 49 | 1 |
621767 | 621767 | 2020-10-11 | Doddridge | West Virginia | 54017 | 51 | 1 |
625010 | 625010 | 2020-10-12 | Doddridge | West Virginia | 54017 | 53 | 1 |
628253 | 628253 | 2020-10-13 | Doddridge | West Virginia | 54017 | 55 | 1 |
631497 | 631497 | 2020-10-14 | Doddridge | West Virginia | 54017 | 59 | 1 |
634742 | 634742 | 2020-10-15 | Doddridge | West Virginia | 54017 | 59 | 1 |
637987 | 637987 | 2020-10-16 | Doddridge | West Virginia | 54017 | 63 | 1 |
641234 | 641234 | 2020-10-17 | Doddridge | West Virginia | 54017 | 65 | 1 |
644482 | 644482 | 2020-10-18 | Doddridge | West Virginia | 54017 | 65 | 1 |
647728 | 647728 | 2020-10-19 | Doddridge | West Virginia | 54017 | 65 | 1 |
650972 | 650972 | 2020-10-20 | Doddridge | West Virginia | 54017 | 66 | 1 |
654217 | 654217 | 2020-10-21 | Doddridge | West Virginia | 54017 | 67 | 1 |
657462 | 657462 | 2020-10-22 | Doddridge | West Virginia | 54017 | 67 | 1 |
660706 | 660706 | 2020-10-23 | Doddridge | West Virginia | 54017 | 69 | 1 |
663950 | 663950 | 2020-10-24 | Doddridge | West Virginia | 54017 | 70 | 1 |
667195 | 667195 | 2020-10-25 | Doddridge | West Virginia | 54017 | 70 | 1 |
670438 | 670438 | 2020-10-26 | Doddridge | West Virginia | 54017 | 70 | 1 |
673680 | 673680 | 2020-10-27 | Doddridge | West Virginia | 54017 | 70 | 1 |
676923 | 676923 | 2020-10-28 | Doddridge | West Virginia | 54017 | 71 | 1 |
680166 | 680166 | 2020-10-29 | Doddridge | West Virginia | 54017 | 71 | 1 |
683409 | 683409 | 2020-10-30 | Doddridge | West Virginia | 54017 | 71 | 1 |
686652 | 686652 | 2020-10-31 | Doddridge | West Virginia | 54017 | 72 | 1 |
689897 | 689897 | 2020-11-01 | Doddridge | West Virginia | 54017 | 72 | 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);