ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Marshall" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933293 | 933293 | 2021-01-15 | Marshall | West Virginia | 54051 | 2492 | 57 |
930048 | 930048 | 2021-01-14 | Marshall | West Virginia | 54051 | 2465 | 57 |
926803 | 926803 | 2021-01-13 | Marshall | West Virginia | 54051 | 2454 | 57 |
923557 | 923557 | 2021-01-12 | Marshall | West Virginia | 54051 | 2433 | 57 |
920312 | 920312 | 2021-01-11 | Marshall | West Virginia | 54051 | 2421 | 57 |
917067 | 917067 | 2021-01-10 | Marshall | West Virginia | 54051 | 2391 | 57 |
913822 | 913822 | 2021-01-09 | Marshall | West Virginia | 54051 | 2347 | 57 |
910577 | 910577 | 2021-01-08 | Marshall | West Virginia | 54051 | 2318 | 56 |
907332 | 907332 | 2021-01-07 | Marshall | West Virginia | 54051 | 2290 | 55 |
904086 | 904086 | 2021-01-06 | Marshall | West Virginia | 54051 | 2273 | 54 |
900841 | 900841 | 2021-01-05 | Marshall | West Virginia | 54051 | 2245 | 54 |
897596 | 897596 | 2021-01-04 | Marshall | West Virginia | 54051 | 2219 | 53 |
894350 | 894350 | 2021-01-03 | Marshall | West Virginia | 54051 | 2201 | 53 |
891104 | 891104 | 2021-01-02 | Marshall | West Virginia | 54051 | 2166 | 53 |
887857 | 887857 | 2021-01-01 | Marshall | West Virginia | 54051 | 2139 | 53 |
884612 | 884612 | 2020-12-31 | Marshall | West Virginia | 54051 | 2100 | 53 |
881367 | 881367 | 2020-12-30 | Marshall | West Virginia | 54051 | 2027 | 53 |
878122 | 878122 | 2020-12-29 | Marshall | West Virginia | 54051 | 1960 | 53 |
874877 | 874877 | 2020-12-28 | Marshall | West Virginia | 54051 | 1891 | 51 |
871632 | 871632 | 2020-12-27 | Marshall | West Virginia | 54051 | 1874 | 51 |
868387 | 868387 | 2020-12-26 | Marshall | West Virginia | 54051 | 1869 | 51 |
865142 | 865142 | 2020-12-25 | Marshall | West Virginia | 54051 | 1848 | 51 |
861897 | 861897 | 2020-12-24 | Marshall | West Virginia | 54051 | 1829 | 50 |
858652 | 858652 | 2020-12-23 | Marshall | West Virginia | 54051 | 1810 | 50 |
855407 | 855407 | 2020-12-22 | Marshall | West Virginia | 54051 | 1801 | 48 |
852162 | 852162 | 2020-12-21 | Marshall | West Virginia | 54051 | 1790 | 48 |
848917 | 848917 | 2020-12-20 | Marshall | West Virginia | 54051 | 1781 | 48 |
845672 | 845672 | 2020-12-19 | Marshall | West Virginia | 54051 | 1767 | 47 |
842426 | 842426 | 2020-12-18 | Marshall | West Virginia | 54051 | 1741 | 44 |
839181 | 839181 | 2020-12-17 | Marshall | West Virginia | 54051 | 1724 | 44 |
835936 | 835936 | 2020-12-16 | Marshall | West Virginia | 54051 | 1711 | 40 |
832690 | 832690 | 2020-12-15 | Marshall | West Virginia | 54051 | 1693 | 38 |
829443 | 829443 | 2020-12-14 | Marshall | West Virginia | 54051 | 1660 | 37 |
826197 | 826197 | 2020-12-13 | Marshall | West Virginia | 54051 | 1643 | 37 |
822950 | 822950 | 2020-12-12 | Marshall | West Virginia | 54051 | 1625 | 37 |
819704 | 819704 | 2020-12-11 | Marshall | West Virginia | 54051 | 1614 | 36 |
816458 | 816458 | 2020-12-10 | Marshall | West Virginia | 54051 | 1600 | 35 |
813212 | 813212 | 2020-12-09 | Marshall | West Virginia | 54051 | 1570 | 35 |
809968 | 809968 | 2020-12-08 | Marshall | West Virginia | 54051 | 1538 | 34 |
806723 | 806723 | 2020-12-07 | Marshall | West Virginia | 54051 | 1531 | 32 |
803478 | 803478 | 2020-12-06 | Marshall | West Virginia | 54051 | 1508 | 32 |
800233 | 800233 | 2020-12-05 | Marshall | West Virginia | 54051 | 1468 | 32 |
796988 | 796988 | 2020-12-04 | Marshall | West Virginia | 54051 | 1396 | 32 |
793743 | 793743 | 2020-12-03 | Marshall | West Virginia | 54051 | 1329 | 31 |
790498 | 790498 | 2020-12-02 | Marshall | West Virginia | 54051 | 1298 | 29 |
787253 | 787253 | 2020-12-01 | Marshall | West Virginia | 54051 | 1276 | 25 |
784009 | 784009 | 2020-11-30 | Marshall | West Virginia | 54051 | 1235 | 24 |
780764 | 780764 | 2020-11-29 | Marshall | West Virginia | 54051 | 1214 | 24 |
777518 | 777518 | 2020-11-28 | Marshall | West Virginia | 54051 | 1154 | 24 |
774273 | 774273 | 2020-11-27 | Marshall | West Virginia | 54051 | 1137 | 24 |
771028 | 771028 | 2020-11-26 | Marshall | West Virginia | 54051 | 1104 | 23 |
767782 | 767782 | 2020-11-25 | Marshall | West Virginia | 54051 | 1080 | 21 |
764537 | 764537 | 2020-11-24 | Marshall | West Virginia | 54051 | 1070 | 14 |
761292 | 761292 | 2020-11-23 | Marshall | West Virginia | 54051 | 1047 | 14 |
758047 | 758047 | 2020-11-22 | Marshall | West Virginia | 54051 | 1011 | 14 |
754800 | 754800 | 2020-11-21 | Marshall | West Virginia | 54051 | 986 | 13 |
751554 | 751554 | 2020-11-20 | Marshall | West Virginia | 54051 | 961 | 12 |
748308 | 748308 | 2020-11-19 | Marshall | West Virginia | 54051 | 911 | 12 |
745062 | 745062 | 2020-11-18 | Marshall | West Virginia | 54051 | 864 | 10 |
741815 | 741815 | 2020-11-17 | Marshall | West Virginia | 54051 | 822 | 10 |
738568 | 738568 | 2020-11-16 | Marshall | West Virginia | 54051 | 806 | 9 |
735324 | 735324 | 2020-11-15 | Marshall | West Virginia | 54051 | 790 | 9 |
732078 | 732078 | 2020-11-14 | Marshall | West Virginia | 54051 | 747 | 8 |
728833 | 728833 | 2020-11-13 | Marshall | West Virginia | 54051 | 693 | 7 |
725590 | 725590 | 2020-11-12 | Marshall | West Virginia | 54051 | 659 | 7 |
722347 | 722347 | 2020-11-11 | Marshall | West Virginia | 54051 | 634 | 6 |
719104 | 719104 | 2020-11-10 | Marshall | West Virginia | 54051 | 619 | 6 |
715861 | 715861 | 2020-11-09 | Marshall | West Virginia | 54051 | 596 | 5 |
712617 | 712617 | 2020-11-08 | Marshall | West Virginia | 54051 | 571 | 5 |
709373 | 709373 | 2020-11-07 | Marshall | West Virginia | 54051 | 544 | 5 |
706129 | 706129 | 2020-11-06 | Marshall | West Virginia | 54051 | 536 | 4 |
702886 | 702886 | 2020-11-05 | Marshall | West Virginia | 54051 | 494 | 4 |
699643 | 699643 | 2020-11-04 | Marshall | West Virginia | 54051 | 478 | 4 |
696399 | 696399 | 2020-11-03 | Marshall | West Virginia | 54051 | 467 | 4 |
693157 | 693157 | 2020-11-02 | Marshall | West Virginia | 54051 | 451 | 4 |
689913 | 689913 | 2020-11-01 | Marshall | West Virginia | 54051 | 420 | 4 |
686668 | 686668 | 2020-10-31 | Marshall | West Virginia | 54051 | 404 | 4 |
683425 | 683425 | 2020-10-30 | Marshall | West Virginia | 54051 | 358 | 4 |
680182 | 680182 | 2020-10-29 | Marshall | West Virginia | 54051 | 341 | 4 |
676939 | 676939 | 2020-10-28 | Marshall | West Virginia | 54051 | 329 | 4 |
673696 | 673696 | 2020-10-27 | Marshall | West Virginia | 54051 | 316 | 4 |
670454 | 670454 | 2020-10-26 | Marshall | West Virginia | 54051 | 290 | 4 |
667211 | 667211 | 2020-10-25 | Marshall | West Virginia | 54051 | 281 | 3 |
663966 | 663966 | 2020-10-24 | Marshall | West Virginia | 54051 | 279 | 3 |
660722 | 660722 | 2020-10-23 | Marshall | West Virginia | 54051 | 274 | 3 |
657478 | 657478 | 2020-10-22 | Marshall | West Virginia | 54051 | 267 | 3 |
654233 | 654233 | 2020-10-21 | Marshall | West Virginia | 54051 | 262 | 2 |
650988 | 650988 | 2020-10-20 | Marshall | West Virginia | 54051 | 255 | 2 |
647744 | 647744 | 2020-10-19 | Marshall | West Virginia | 54051 | 250 | 1 |
644498 | 644498 | 2020-10-18 | Marshall | West Virginia | 54051 | 245 | 1 |
641250 | 641250 | 2020-10-17 | Marshall | West Virginia | 54051 | 241 | 1 |
638003 | 638003 | 2020-10-16 | Marshall | West Virginia | 54051 | 238 | 1 |
634758 | 634758 | 2020-10-15 | Marshall | West Virginia | 54051 | 231 | 1 |
631513 | 631513 | 2020-10-14 | Marshall | West Virginia | 54051 | 221 | 1 |
628269 | 628269 | 2020-10-13 | Marshall | West Virginia | 54051 | 218 | 1 |
625026 | 625026 | 2020-10-12 | Marshall | West Virginia | 54051 | 205 | 1 |
621783 | 621783 | 2020-10-11 | Marshall | West Virginia | 54051 | 205 | 1 |
618540 | 618540 | 2020-10-10 | Marshall | West Virginia | 54051 | 201 | 1 |
615298 | 615298 | 2020-10-09 | Marshall | West Virginia | 54051 | 196 | 1 |
612057 | 612057 | 2020-10-08 | Marshall | West Virginia | 54051 | 188 | 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);