ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 54083 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 |
---|---|---|---|---|---|---|---|
1196248 | 1196248 | 2021-04-06 | Randolph | West Virginia | 54083 | 2471 | 13 |
1193000 | 1193000 | 2021-04-05 | Randolph | West Virginia | 54083 | 2469 | 13 |
1189750 | 1189750 | 2021-04-04 | Randolph | West Virginia | 54083 | 2468 | 13 |
1186503 | 1186503 | 2021-04-03 | Randolph | West Virginia | 54083 | 2468 | 13 |
1183256 | 1183256 | 2021-04-02 | Randolph | West Virginia | 54083 | 2468 | 13 |
1180009 | 1180009 | 2021-04-01 | Randolph | West Virginia | 54083 | 2467 | 13 |
1176762 | 1176762 | 2021-03-31 | Randolph | West Virginia | 54083 | 2465 | 13 |
1173515 | 1173515 | 2021-03-30 | Randolph | West Virginia | 54083 | 2462 | 12 |
1170268 | 1170268 | 2021-03-29 | Randolph | West Virginia | 54083 | 2455 | 12 |
1167020 | 1167020 | 2021-03-28 | Randolph | West Virginia | 54083 | 2449 | 12 |
1163772 | 1163772 | 2021-03-27 | Randolph | West Virginia | 54083 | 2449 | 12 |
1160524 | 1160524 | 2021-03-26 | Randolph | West Virginia | 54083 | 2447 | 12 |
1157276 | 1157276 | 2021-03-25 | Randolph | West Virginia | 54083 | 2446 | 12 |
1154029 | 1154029 | 2021-03-24 | Randolph | West Virginia | 54083 | 2443 | 12 |
1150782 | 1150782 | 2021-03-23 | Randolph | West Virginia | 54083 | 2440 | 12 |
1147535 | 1147535 | 2021-03-22 | Randolph | West Virginia | 54083 | 2435 | 12 |
1144288 | 1144288 | 2021-03-21 | Randolph | West Virginia | 54083 | 2434 | 12 |
1141041 | 1141041 | 2021-03-20 | Randolph | West Virginia | 54083 | 2433 | 12 |
1137795 | 1137795 | 2021-03-19 | Randolph | West Virginia | 54083 | 2432 | 12 |
1134549 | 1134549 | 2021-03-18 | Randolph | West Virginia | 54083 | 2430 | 11 |
1131301 | 1131301 | 2021-03-17 | Randolph | West Virginia | 54083 | 2436 | 13 |
1128054 | 1128054 | 2021-03-16 | Randolph | West Virginia | 54083 | 2436 | 13 |
1124808 | 1124808 | 2021-03-15 | Randolph | West Virginia | 54083 | 2430 | 13 |
1121562 | 1121562 | 2021-03-14 | Randolph | West Virginia | 54083 | 2429 | 13 |
1118315 | 1118315 | 2021-03-13 | Randolph | West Virginia | 54083 | 2428 | 13 |
1115068 | 1115068 | 2021-03-12 | Randolph | West Virginia | 54083 | 2426 | 12 |
1111822 | 1111822 | 2021-03-11 | Randolph | West Virginia | 54083 | 2424 | 10 |
1108576 | 1108576 | 2021-03-10 | Randolph | West Virginia | 54083 | 2417 | 10 |
1105330 | 1105330 | 2021-03-09 | Randolph | West Virginia | 54083 | 2416 | 10 |
1102084 | 1102084 | 2021-03-08 | Randolph | West Virginia | 54083 | 2413 | 10 |
1098838 | 1098838 | 2021-03-07 | Randolph | West Virginia | 54083 | 2412 | 10 |
1095590 | 1095590 | 2021-03-06 | Randolph | West Virginia | 54083 | 2411 | 10 |
1092344 | 1092344 | 2021-03-05 | Randolph | West Virginia | 54083 | 2409 | 10 |
1089098 | 1089098 | 2021-03-04 | Randolph | West Virginia | 54083 | 2403 | 10 |
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 |
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);