ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 54061 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 |
---|---|---|---|---|---|---|---|
933299 | 933299 | 2021-01-15 | Monongalia | West Virginia | 54061 | 6311 | 52 |
930054 | 930054 | 2021-01-14 | Monongalia | West Virginia | 54061 | 6244 | 51 |
926809 | 926809 | 2021-01-13 | Monongalia | West Virginia | 54061 | 6217 | 49 |
923563 | 923563 | 2021-01-12 | Monongalia | West Virginia | 54061 | 6157 | 49 |
920318 | 920318 | 2021-01-11 | Monongalia | West Virginia | 54061 | 6110 | 45 |
917073 | 917073 | 2021-01-10 | Monongalia | West Virginia | 54061 | 6049 | 45 |
913828 | 913828 | 2021-01-09 | Monongalia | West Virginia | 54061 | 5989 | 45 |
910583 | 910583 | 2021-01-08 | Monongalia | West Virginia | 54061 | 5925 | 44 |
907338 | 907338 | 2021-01-07 | Monongalia | West Virginia | 54061 | 5823 | 44 |
904092 | 904092 | 2021-01-06 | Monongalia | West Virginia | 54061 | 5754 | 42 |
900847 | 900847 | 2021-01-05 | Monongalia | West Virginia | 54061 | 5698 | 40 |
897602 | 897602 | 2021-01-04 | Monongalia | West Virginia | 54061 | 5635 | 32 |
894356 | 894356 | 2021-01-03 | Monongalia | West Virginia | 54061 | 5578 | 31 |
891110 | 891110 | 2021-01-02 | Monongalia | West Virginia | 54061 | 5494 | 31 |
887863 | 887863 | 2021-01-01 | Monongalia | West Virginia | 54061 | 5427 | 31 |
884618 | 884618 | 2020-12-31 | Monongalia | West Virginia | 54061 | 5284 | 31 |
881373 | 881373 | 2020-12-30 | Monongalia | West Virginia | 54061 | 5269 | 30 |
878128 | 878128 | 2020-12-29 | Monongalia | West Virginia | 54061 | 5173 | 29 |
874883 | 874883 | 2020-12-28 | Monongalia | West Virginia | 54061 | 5110 | 26 |
871638 | 871638 | 2020-12-27 | Monongalia | West Virginia | 54061 | 5076 | 25 |
868393 | 868393 | 2020-12-26 | Monongalia | West Virginia | 54061 | 5034 | 25 |
865148 | 865148 | 2020-12-25 | Monongalia | West Virginia | 54061 | 4989 | 25 |
861903 | 861903 | 2020-12-24 | Monongalia | West Virginia | 54061 | 4915 | 25 |
858658 | 858658 | 2020-12-23 | Monongalia | West Virginia | 54061 | 4826 | 23 |
855413 | 855413 | 2020-12-22 | Monongalia | West Virginia | 54061 | 4778 | 22 |
852168 | 852168 | 2020-12-21 | Monongalia | West Virginia | 54061 | 4718 | 13 |
848923 | 848923 | 2020-12-20 | Monongalia | West Virginia | 54061 | 4668 | 13 |
845678 | 845678 | 2020-12-19 | Monongalia | West Virginia | 54061 | 4596 | 16 |
842432 | 842432 | 2020-12-18 | Monongalia | West Virginia | 54061 | 4512 | 11 |
839187 | 839187 | 2020-12-17 | Monongalia | West Virginia | 54061 | 4422 | 11 |
835942 | 835942 | 2020-12-16 | Monongalia | West Virginia | 54061 | 4319 | 9 |
832696 | 832696 | 2020-12-15 | Monongalia | West Virginia | 54061 | 4256 | 9 |
829449 | 829449 | 2020-12-14 | Monongalia | West Virginia | 54061 | 4171 | 8 |
826203 | 826203 | 2020-12-13 | Monongalia | West Virginia | 54061 | 4091 | 8 |
822956 | 822956 | 2020-12-12 | Monongalia | West Virginia | 54061 | 3995 | 7 |
819710 | 819710 | 2020-12-11 | Monongalia | West Virginia | 54061 | 3897 | 7 |
816464 | 816464 | 2020-12-10 | Monongalia | West Virginia | 54061 | 3851 | 7 |
813218 | 813218 | 2020-12-09 | Monongalia | West Virginia | 54061 | 3796 | 8 |
809974 | 809974 | 2020-12-08 | Monongalia | West Virginia | 54061 | 3738 | 7 |
806729 | 806729 | 2020-12-07 | Monongalia | West Virginia | 54061 | 3691 | 7 |
803484 | 803484 | 2020-12-06 | Monongalia | West Virginia | 54061 | 3626 | 7 |
800239 | 800239 | 2020-12-05 | Monongalia | West Virginia | 54061 | 3561 | 7 |
796994 | 796994 | 2020-12-04 | Monongalia | West Virginia | 54061 | 3490 | 7 |
793749 | 793749 | 2020-12-03 | Monongalia | West Virginia | 54061 | 3459 | 7 |
790504 | 790504 | 2020-12-02 | Monongalia | West Virginia | 54061 | 3400 | 7 |
787259 | 787259 | 2020-12-01 | Monongalia | West Virginia | 54061 | 3373 | 7 |
784015 | 784015 | 2020-11-30 | Monongalia | West Virginia | 54061 | 3341 | 7 |
780770 | 780770 | 2020-11-29 | Monongalia | West Virginia | 54061 | 3307 | 7 |
777524 | 777524 | 2020-11-28 | Monongalia | West Virginia | 54061 | 3284 | 7 |
774279 | 774279 | 2020-11-27 | Monongalia | West Virginia | 54061 | 3253 | 7 |
771034 | 771034 | 2020-11-26 | Monongalia | West Virginia | 54061 | 3202 | 7 |
767788 | 767788 | 2020-11-25 | Monongalia | West Virginia | 54061 | 3143 | 7 |
764543 | 764543 | 2020-11-24 | Monongalia | West Virginia | 54061 | 3107 | 7 |
761298 | 761298 | 2020-11-23 | Monongalia | West Virginia | 54061 | 3058 | 7 |
758053 | 758053 | 2020-11-22 | Monongalia | West Virginia | 54061 | 3018 | 7 |
754806 | 754806 | 2020-11-21 | Monongalia | West Virginia | 54061 | 2985 | 7 |
751560 | 751560 | 2020-11-20 | Monongalia | West Virginia | 54061 | 2948 | 7 |
748314 | 748314 | 2020-11-19 | Monongalia | West Virginia | 54061 | 2905 | 7 |
745068 | 745068 | 2020-11-18 | Monongalia | West Virginia | 54061 | 2863 | 7 |
741821 | 741821 | 2020-11-17 | Monongalia | West Virginia | 54061 | 2835 | 7 |
738574 | 738574 | 2020-11-16 | Monongalia | West Virginia | 54061 | 2786 | 7 |
735330 | 735330 | 2020-11-15 | Monongalia | West Virginia | 54061 | 2754 | 7 |
732084 | 732084 | 2020-11-14 | Monongalia | West Virginia | 54061 | 2706 | 7 |
728839 | 728839 | 2020-11-13 | Monongalia | West Virginia | 54061 | 2655 | 7 |
725596 | 725596 | 2020-11-12 | Monongalia | West Virginia | 54061 | 2625 | 7 |
722353 | 722353 | 2020-11-11 | Monongalia | West Virginia | 54061 | 2595 | 7 |
719110 | 719110 | 2020-11-10 | Monongalia | West Virginia | 54061 | 2566 | 7 |
715867 | 715867 | 2020-11-09 | Monongalia | West Virginia | 54061 | 2532 | 8 |
712623 | 712623 | 2020-11-08 | Monongalia | West Virginia | 54061 | 2513 | 7 |
709379 | 709379 | 2020-11-07 | Monongalia | West Virginia | 54061 | 2471 | 7 |
706135 | 706135 | 2020-11-06 | Monongalia | West Virginia | 54061 | 2447 | 7 |
702892 | 702892 | 2020-11-05 | Monongalia | West Virginia | 54061 | 2434 | 7 |
699649 | 699649 | 2020-11-04 | Monongalia | West Virginia | 54061 | 2417 | 7 |
696405 | 696405 | 2020-11-03 | Monongalia | West Virginia | 54061 | 2409 | 7 |
693163 | 693163 | 2020-11-02 | Monongalia | West Virginia | 54061 | 2378 | 7 |
689919 | 689919 | 2020-11-01 | Monongalia | West Virginia | 54061 | 2363 | 7 |
686674 | 686674 | 2020-10-31 | Monongalia | West Virginia | 54061 | 2348 | 7 |
683431 | 683431 | 2020-10-30 | Monongalia | West Virginia | 54061 | 2329 | 7 |
680188 | 680188 | 2020-10-29 | Monongalia | West Virginia | 54061 | 2316 | 5 |
676945 | 676945 | 2020-10-28 | Monongalia | West Virginia | 54061 | 2307 | 5 |
673702 | 673702 | 2020-10-27 | Monongalia | West Virginia | 54061 | 2298 | 5 |
670460 | 670460 | 2020-10-26 | Monongalia | West Virginia | 54061 | 2290 | 5 |
667217 | 667217 | 2020-10-25 | Monongalia | West Virginia | 54061 | 2277 | 5 |
663972 | 663972 | 2020-10-24 | Monongalia | West Virginia | 54061 | 2269 | 5 |
660728 | 660728 | 2020-10-23 | Monongalia | West Virginia | 54061 | 2259 | 5 |
657484 | 657484 | 2020-10-22 | Monongalia | West Virginia | 54061 | 2248 | 5 |
654239 | 654239 | 2020-10-21 | Monongalia | West Virginia | 54061 | 2239 | 5 |
650994 | 650994 | 2020-10-20 | Monongalia | West Virginia | 54061 | 2236 | 5 |
647750 | 647750 | 2020-10-19 | Monongalia | West Virginia | 54061 | 2228 | 5 |
644504 | 644504 | 2020-10-18 | Monongalia | West Virginia | 54061 | 2224 | 5 |
641256 | 641256 | 2020-10-17 | Monongalia | West Virginia | 54061 | 2214 | 5 |
638009 | 638009 | 2020-10-16 | Monongalia | West Virginia | 54061 | 2205 | 5 |
634764 | 634764 | 2020-10-15 | Monongalia | West Virginia | 54061 | 2190 | 5 |
631519 | 631519 | 2020-10-14 | Monongalia | West Virginia | 54061 | 2183 | 5 |
628275 | 628275 | 2020-10-13 | Monongalia | West Virginia | 54061 | 2169 | 5 |
625032 | 625032 | 2020-10-12 | Monongalia | West Virginia | 54061 | 2166 | 5 |
621789 | 621789 | 2020-10-11 | Monongalia | West Virginia | 54061 | 2157 | 5 |
618546 | 618546 | 2020-10-10 | Monongalia | West Virginia | 54061 | 2142 | 5 |
615304 | 615304 | 2020-10-09 | Monongalia | West Virginia | 54061 | 2135 | 5 |
612063 | 612063 | 2020-10-08 | Monongalia | West Virginia | 54061 | 2124 | 5 |
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);