ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Randolph" 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 |
---|---|---|---|---|---|---|---|
1085853 | 1085853 | 2021-03-03 | Randolph | West Virginia | 54083 | 2398 | 10 |
1082607 | 1082607 | 2021-03-02 | Randolph | West Virginia | 54083 | 2395 | 10 |
1079361 | 1079361 | 2021-03-01 | Randolph | West Virginia | 54083 | 2392 | 10 |
1076116 | 1076116 | 2021-02-28 | Randolph | West Virginia | 54083 | 2390 | 10 |
1072870 | 1072870 | 2021-02-27 | Randolph | West Virginia | 54083 | 2390 | 10 |
1069624 | 1069624 | 2021-02-26 | Randolph | West Virginia | 54083 | 2383 | 10 |
1066379 | 1066379 | 2021-02-25 | Randolph | West Virginia | 54083 | 2381 | 10 |
1063134 | 1063134 | 2021-02-24 | Randolph | West Virginia | 54083 | 2375 | 10 |
1059889 | 1059889 | 2021-02-23 | Randolph | West Virginia | 54083 | 2371 | 10 |
1056643 | 1056643 | 2021-02-22 | Randolph | West Virginia | 54083 | 2364 | 9 |
1053397 | 1053397 | 2021-02-21 | Randolph | West Virginia | 54083 | 2362 | 9 |
1050150 | 1050150 | 2021-02-20 | Randolph | West Virginia | 54083 | 2362 | 9 |
1046903 | 1046903 | 2021-02-19 | Randolph | West Virginia | 54083 | 2356 | 9 |
1043658 | 1043658 | 2021-02-18 | Randolph | West Virginia | 54083 | 2349 | 9 |
1040413 | 1040413 | 2021-02-17 | Randolph | West Virginia | 54083 | 2349 | 9 |
1037168 | 1037168 | 2021-02-16 | Randolph | West Virginia | 54083 | 2342 | 9 |
1033923 | 1033923 | 2021-02-15 | Randolph | West Virginia | 54083 | 2333 | 9 |
1030677 | 1030677 | 2021-02-14 | Randolph | West Virginia | 54083 | 2329 | 9 |
1027430 | 1027430 | 2021-02-13 | Randolph | West Virginia | 54083 | 2325 | 9 |
1024185 | 1024185 | 2021-02-12 | Randolph | West Virginia | 54083 | 2323 | 9 |
1020940 | 1020940 | 2021-02-11 | Randolph | West Virginia | 54083 | 2309 | 9 |
1017695 | 1017695 | 2021-02-10 | Randolph | West Virginia | 54083 | 2299 | 9 |
1014450 | 1014450 | 2021-02-09 | Randolph | West Virginia | 54083 | 2289 | 9 |
1011205 | 1011205 | 2021-02-08 | Randolph | West Virginia | 54083 | 2283 | 9 |
1007959 | 1007959 | 2021-02-07 | Randolph | West Virginia | 54083 | 2268 | 9 |
1004713 | 1004713 | 2021-02-06 | Randolph | West Virginia | 54083 | 2264 | 9 |
1001467 | 1001467 | 2021-02-05 | Randolph | West Virginia | 54083 | 2252 | 9 |
998221 | 998221 | 2021-02-04 | Randolph | West Virginia | 54083 | 2250 | 9 |
994975 | 994975 | 2021-02-03 | Randolph | West Virginia | 54083 | 2245 | 9 |
991729 | 991729 | 2021-02-02 | Randolph | West Virginia | 54083 | 2230 | 9 |
988483 | 988483 | 2021-02-01 | Randolph | West Virginia | 54083 | 2214 | 9 |
985236 | 985236 | 2021-01-31 | Randolph | West Virginia | 54083 | 2209 | 9 |
981989 | 981989 | 2021-01-30 | Randolph | West Virginia | 54083 | 2210 | 9 |
978743 | 978743 | 2021-01-29 | Randolph | West Virginia | 54083 | 2196 | 9 |
975498 | 975498 | 2021-01-28 | Randolph | West Virginia | 54083 | 2173 | 8 |
972253 | 972253 | 2021-01-27 | Randolph | West Virginia | 54083 | 2155 | 8 |
969008 | 969008 | 2021-01-26 | Randolph | West Virginia | 54083 | 2132 | 8 |
965764 | 965764 | 2021-01-25 | Randolph | West Virginia | 54083 | 2106 | 8 |
962519 | 962519 | 2021-01-24 | Randolph | West Virginia | 54083 | 2095 | 8 |
959274 | 959274 | 2021-01-23 | Randolph | West Virginia | 54083 | 2085 | 8 |
956028 | 956028 | 2021-01-22 | Randolph | West Virginia | 54083 | 2026 | 8 |
952783 | 952783 | 2021-01-21 | Randolph | West Virginia | 54083 | 2032 | 8 |
949538 | 949538 | 2021-01-20 | Randolph | West Virginia | 54083 | 2008 | 8 |
946292 | 946292 | 2021-01-19 | Randolph | West Virginia | 54083 | 1967 | 8 |
943045 | 943045 | 2021-01-18 | Randolph | West Virginia | 54083 | 1933 | 8 |
939800 | 939800 | 2021-01-17 | Randolph | West Virginia | 54083 | 1929 | 8 |
936555 | 936555 | 2021-01-16 | Randolph | West Virginia | 54083 | 1921 | 8 |
933310 | 933310 | 2021-01-15 | Randolph | West Virginia | 54083 | 1844 | 8 |
930065 | 930065 | 2021-01-14 | Randolph | West Virginia | 54083 | 1677 | 8 |
926820 | 926820 | 2021-01-13 | Randolph | West Virginia | 54083 | 1639 | 8 |
923574 | 923574 | 2021-01-12 | Randolph | West Virginia | 54083 | 1589 | 8 |
920329 | 920329 | 2021-01-11 | Randolph | West Virginia | 54083 | 1565 | 6 |
917084 | 917084 | 2021-01-10 | Randolph | West Virginia | 54083 | 1516 | 6 |
913839 | 913839 | 2021-01-09 | Randolph | West Virginia | 54083 | 1393 | 6 |
910594 | 910594 | 2021-01-08 | Randolph | West Virginia | 54083 | 1365 | 6 |
907349 | 907349 | 2021-01-07 | Randolph | West Virginia | 54083 | 1328 | 6 |
904103 | 904103 | 2021-01-06 | Randolph | West Virginia | 54083 | 1313 | 6 |
900858 | 900858 | 2021-01-05 | Randolph | West Virginia | 54083 | 1263 | 6 |
897613 | 897613 | 2021-01-04 | Randolph | West Virginia | 54083 | 1233 | 6 |
894367 | 894367 | 2021-01-03 | Randolph | West Virginia | 54083 | 1224 | 6 |
891121 | 891121 | 2021-01-02 | Randolph | West Virginia | 54083 | 1211 | 6 |
887874 | 887874 | 2021-01-01 | Randolph | West Virginia | 54083 | 1205 | 6 |
884629 | 884629 | 2020-12-31 | Randolph | West Virginia | 54083 | 1138 | 6 |
881384 | 881384 | 2020-12-30 | Randolph | West Virginia | 54083 | 1131 | 6 |
878139 | 878139 | 2020-12-29 | Randolph | West Virginia | 54083 | 1104 | 6 |
874894 | 874894 | 2020-12-28 | Randolph | West Virginia | 54083 | 1054 | 6 |
871649 | 871649 | 2020-12-27 | Randolph | West Virginia | 54083 | 1059 | 6 |
868404 | 868404 | 2020-12-26 | Randolph | West Virginia | 54083 | 1060 | 6 |
865159 | 865159 | 2020-12-25 | Randolph | West Virginia | 54083 | 1055 | 6 |
861914 | 861914 | 2020-12-24 | Randolph | West Virginia | 54083 | 1035 | 6 |
858669 | 858669 | 2020-12-23 | Randolph | West Virginia | 54083 | 1028 | 5 |
855424 | 855424 | 2020-12-22 | Randolph | West Virginia | 54083 | 1007 | 4 |
852179 | 852179 | 2020-12-21 | Randolph | West Virginia | 54083 | 992 | 4 |
848934 | 848934 | 2020-12-20 | Randolph | West Virginia | 54083 | 983 | 4 |
845689 | 845689 | 2020-12-19 | Randolph | West Virginia | 54083 | 983 | 4 |
842443 | 842443 | 2020-12-18 | Randolph | West Virginia | 54083 | 977 | 4 |
839198 | 839198 | 2020-12-17 | Randolph | West Virginia | 54083 | 969 | 3 |
835953 | 835953 | 2020-12-16 | Randolph | West Virginia | 54083 | 947 | 3 |
832707 | 832707 | 2020-12-15 | Randolph | West Virginia | 54083 | 927 | 3 |
829460 | 829460 | 2020-12-14 | Randolph | West Virginia | 54083 | 905 | 3 |
826214 | 826214 | 2020-12-13 | Randolph | West Virginia | 54083 | 895 | 3 |
822967 | 822967 | 2020-12-12 | Randolph | West Virginia | 54083 | 892 | 3 |
819721 | 819721 | 2020-12-11 | Randolph | West Virginia | 54083 | 867 | 3 |
816475 | 816475 | 2020-12-10 | Randolph | West Virginia | 54083 | 852 | 3 |
813229 | 813229 | 2020-12-09 | Randolph | West Virginia | 54083 | 837 | 3 |
809985 | 809985 | 2020-12-08 | Randolph | West Virginia | 54083 | 808 | 3 |
806740 | 806740 | 2020-12-07 | Randolph | West Virginia | 54083 | 798 | 2 |
803495 | 803495 | 2020-12-06 | Randolph | West Virginia | 54083 | 785 | 2 |
800250 | 800250 | 2020-12-05 | Randolph | West Virginia | 54083 | 779 | 2 |
797005 | 797005 | 2020-12-04 | Randolph | West Virginia | 54083 | 777 | 2 |
793760 | 793760 | 2020-12-03 | Randolph | West Virginia | 54083 | 762 | 2 |
790515 | 790515 | 2020-12-02 | Randolph | West Virginia | 54083 | 751 | 2 |
787270 | 787270 | 2020-12-01 | Randolph | West Virginia | 54083 | 718 | 2 |
784026 | 784026 | 2020-11-30 | Randolph | West Virginia | 54083 | 693 | 2 |
780781 | 780781 | 2020-11-29 | Randolph | West Virginia | 54083 | 689 | 2 |
777535 | 777535 | 2020-11-28 | Randolph | West Virginia | 54083 | 682 | 2 |
774290 | 774290 | 2020-11-27 | Randolph | West Virginia | 54083 | 679 | 2 |
771045 | 771045 | 2020-11-26 | Randolph | West Virginia | 54083 | 677 | 2 |
767799 | 767799 | 2020-11-25 | Randolph | West Virginia | 54083 | 660 | 2 |
764554 | 764554 | 2020-11-24 | Randolph | West Virginia | 54083 | 646 | 2 |
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);