ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 54019 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 |
---|---|---|---|---|---|---|---|
1420234 | 1420234 | 2021-06-14 | Fayette | West Virginia | 54019 | 3542 | 79 |
1416989 | 1416989 | 2021-06-13 | Fayette | West Virginia | 54019 | 3536 | 79 |
1413743 | 1413743 | 2021-06-12 | Fayette | West Virginia | 54019 | 3536 | 79 |
1410498 | 1410498 | 2021-06-11 | Fayette | West Virginia | 54019 | 3536 | 79 |
1407253 | 1407253 | 2021-06-10 | Fayette | West Virginia | 54019 | 3535 | 79 |
1404007 | 1404007 | 2021-06-09 | Fayette | West Virginia | 54019 | 3532 | 79 |
1400762 | 1400762 | 2021-06-08 | Fayette | West Virginia | 54019 | 3529 | 79 |
1397517 | 1397517 | 2021-06-07 | Fayette | West Virginia | 54019 | 3528 | 79 |
1394270 | 1394270 | 2021-06-06 | Fayette | West Virginia | 54019 | 3524 | 79 |
1391025 | 1391025 | 2021-06-05 | Fayette | West Virginia | 54019 | 3524 | 79 |
1387780 | 1387780 | 2021-06-04 | Fayette | West Virginia | 54019 | 3524 | 79 |
1384535 | 1384535 | 2021-06-03 | Fayette | West Virginia | 54019 | 3523 | 79 |
1381289 | 1381289 | 2021-06-02 | Fayette | West Virginia | 54019 | 3519 | 79 |
1378044 | 1378044 | 2021-06-01 | Fayette | West Virginia | 54019 | 3516 | 79 |
1374798 | 1374798 | 2021-05-31 | Fayette | West Virginia | 54019 | 3510 | 79 |
1371553 | 1371553 | 2021-05-30 | Fayette | West Virginia | 54019 | 3510 | 79 |
1368307 | 1368307 | 2021-05-29 | Fayette | West Virginia | 54019 | 3510 | 79 |
1365061 | 1365061 | 2021-05-28 | Fayette | West Virginia | 54019 | 3510 | 79 |
1361815 | 1361815 | 2021-05-27 | Fayette | West Virginia | 54019 | 3507 | 79 |
1358569 | 1358569 | 2021-05-26 | Fayette | West Virginia | 54019 | 3504 | 79 |
1355323 | 1355323 | 2021-05-25 | Fayette | West Virginia | 54019 | 3497 | 78 |
1352077 | 1352077 | 2021-05-24 | Fayette | West Virginia | 54019 | 3494 | 77 |
1348831 | 1348831 | 2021-05-23 | Fayette | West Virginia | 54019 | 3482 | 77 |
1345583 | 1345583 | 2021-05-22 | Fayette | West Virginia | 54019 | 3482 | 77 |
1342335 | 1342335 | 2021-05-21 | Fayette | West Virginia | 54019 | 3482 | 77 |
1339087 | 1339087 | 2021-05-20 | Fayette | West Virginia | 54019 | 3476 | 76 |
1335840 | 1335840 | 2021-05-19 | Fayette | West Virginia | 54019 | 3467 | 76 |
1332593 | 1332593 | 2021-05-18 | Fayette | West Virginia | 54019 | 3463 | 76 |
1329346 | 1329346 | 2021-05-17 | Fayette | West Virginia | 54019 | 3458 | 76 |
1326100 | 1326100 | 2021-05-16 | Fayette | West Virginia | 54019 | 3457 | 76 |
1322854 | 1322854 | 2021-05-15 | Fayette | West Virginia | 54019 | 3455 | 76 |
1319608 | 1319608 | 2021-05-14 | Fayette | West Virginia | 54019 | 3454 | 76 |
1316360 | 1316360 | 2021-05-13 | Fayette | West Virginia | 54019 | 3448 | 76 |
1313114 | 1313114 | 2021-05-12 | Fayette | West Virginia | 54019 | 3438 | 76 |
1309867 | 1309867 | 2021-05-11 | Fayette | West Virginia | 54019 | 3437 | 76 |
1306621 | 1306621 | 2021-05-10 | Fayette | West Virginia | 54019 | 3437 | 75 |
1303375 | 1303375 | 2021-05-09 | Fayette | West Virginia | 54019 | 3435 | 75 |
1300128 | 1300128 | 2021-05-08 | Fayette | West Virginia | 54019 | 3426 | 75 |
1296881 | 1296881 | 2021-05-07 | Fayette | West Virginia | 54019 | 3416 | 75 |
1293635 | 1293635 | 2021-05-06 | Fayette | West Virginia | 54019 | 3409 | 75 |
1290389 | 1290389 | 2021-05-05 | Fayette | West Virginia | 54019 | 3406 | 75 |
1287143 | 1287143 | 2021-05-04 | Fayette | West Virginia | 54019 | 3393 | 75 |
1283897 | 1283897 | 2021-05-03 | Fayette | West Virginia | 54019 | 3380 | 75 |
1280650 | 1280650 | 2021-05-02 | Fayette | West Virginia | 54019 | 3375 | 75 |
1277403 | 1277403 | 2021-05-01 | Fayette | West Virginia | 54019 | 3361 | 75 |
1274156 | 1274156 | 2021-04-30 | Fayette | West Virginia | 54019 | 3353 | 75 |
1270909 | 1270909 | 2021-04-29 | Fayette | West Virginia | 54019 | 3348 | 75 |
1267662 | 1267662 | 2021-04-28 | Fayette | West Virginia | 54019 | 3352 | 76 |
1264415 | 1264415 | 2021-04-27 | Fayette | West Virginia | 54019 | 3345 | 76 |
1261168 | 1261168 | 2021-04-26 | Fayette | West Virginia | 54019 | 3340 | 79 |
1257921 | 1257921 | 2021-04-25 | Fayette | West Virginia | 54019 | 3328 | 79 |
1254674 | 1254674 | 2021-04-24 | Fayette | West Virginia | 54019 | 3324 | 79 |
1251427 | 1251427 | 2021-04-23 | Fayette | West Virginia | 54019 | 3311 | 79 |
1248180 | 1248180 | 2021-04-22 | Fayette | West Virginia | 54019 | 3301 | 78 |
1244933 | 1244933 | 2021-04-21 | Fayette | West Virginia | 54019 | 3293 | 78 |
1241686 | 1241686 | 2021-04-20 | Fayette | West Virginia | 54019 | 3284 | 78 |
1238439 | 1238439 | 2021-04-19 | Fayette | West Virginia | 54019 | 3275 | 78 |
1235192 | 1235192 | 2021-04-18 | Fayette | West Virginia | 54019 | 3260 | 78 |
1231944 | 1231944 | 2021-04-17 | Fayette | West Virginia | 54019 | 3253 | 78 |
1228696 | 1228696 | 2021-04-16 | Fayette | West Virginia | 54019 | 3240 | 78 |
1225448 | 1225448 | 2021-04-15 | Fayette | West Virginia | 54019 | 3228 | 78 |
1222201 | 1222201 | 2021-04-14 | Fayette | West Virginia | 54019 | 3210 | 78 |
1218953 | 1218953 | 2021-04-13 | Fayette | West Virginia | 54019 | 3199 | 78 |
1215705 | 1215705 | 2021-04-12 | Fayette | West Virginia | 54019 | 3193 | 78 |
1212458 | 1212458 | 2021-04-11 | Fayette | West Virginia | 54019 | 3179 | 78 |
1209209 | 1209209 | 2021-04-10 | Fayette | West Virginia | 54019 | 3166 | 78 |
1205961 | 1205961 | 2021-04-09 | Fayette | West Virginia | 54019 | 3143 | 78 |
1202713 | 1202713 | 2021-04-08 | Fayette | West Virginia | 54019 | 3124 | 78 |
1199465 | 1199465 | 2021-04-07 | Fayette | West Virginia | 54019 | 3111 | 78 |
1196216 | 1196216 | 2021-04-06 | Fayette | West Virginia | 54019 | 3102 | 77 |
1192968 | 1192968 | 2021-04-05 | Fayette | West Virginia | 54019 | 3095 | 77 |
1189718 | 1189718 | 2021-04-04 | Fayette | West Virginia | 54019 | 3087 | 76 |
1186471 | 1186471 | 2021-04-03 | Fayette | West Virginia | 54019 | 3064 | 76 |
1183224 | 1183224 | 2021-04-02 | Fayette | West Virginia | 54019 | 3050 | 75 |
1179977 | 1179977 | 2021-04-01 | Fayette | West Virginia | 54019 | 3023 | 74 |
1176730 | 1176730 | 2021-03-31 | Fayette | West Virginia | 54019 | 2994 | 74 |
1173483 | 1173483 | 2021-03-30 | Fayette | West Virginia | 54019 | 2981 | 74 |
1170236 | 1170236 | 2021-03-29 | Fayette | West Virginia | 54019 | 2974 | 74 |
1166988 | 1166988 | 2021-03-28 | Fayette | West Virginia | 54019 | 2953 | 74 |
1163740 | 1163740 | 2021-03-27 | Fayette | West Virginia | 54019 | 2941 | 74 |
1160492 | 1160492 | 2021-03-26 | Fayette | West Virginia | 54019 | 2929 | 74 |
1157244 | 1157244 | 2021-03-25 | Fayette | West Virginia | 54019 | 2912 | 74 |
1153997 | 1153997 | 2021-03-24 | Fayette | West Virginia | 54019 | 2901 | 73 |
1150750 | 1150750 | 2021-03-23 | Fayette | West Virginia | 54019 | 2893 | 73 |
1147503 | 1147503 | 2021-03-22 | Fayette | West Virginia | 54019 | 2882 | 73 |
1144256 | 1144256 | 2021-03-21 | Fayette | West Virginia | 54019 | 2863 | 73 |
1141009 | 1141009 | 2021-03-20 | Fayette | West Virginia | 54019 | 2857 | 73 |
1137763 | 1137763 | 2021-03-19 | Fayette | West Virginia | 54019 | 2849 | 73 |
1134517 | 1134517 | 2021-03-18 | Fayette | West Virginia | 54019 | 2829 | 73 |
1131269 | 1131269 | 2021-03-17 | Fayette | West Virginia | 54019 | 2811 | 73 |
1128022 | 1128022 | 2021-03-16 | Fayette | West Virginia | 54019 | 2793 | 73 |
1124776 | 1124776 | 2021-03-15 | Fayette | West Virginia | 54019 | 2784 | 73 |
1121530 | 1121530 | 2021-03-14 | Fayette | West Virginia | 54019 | 2777 | 73 |
1118283 | 1118283 | 2021-03-13 | Fayette | West Virginia | 54019 | 2773 | 73 |
1115036 | 1115036 | 2021-03-12 | Fayette | West Virginia | 54019 | 2760 | 72 |
1111790 | 1111790 | 2021-03-11 | Fayette | West Virginia | 54019 | 2743 | 70 |
1108544 | 1108544 | 2021-03-10 | Fayette | West Virginia | 54019 | 2732 | 70 |
1105298 | 1105298 | 2021-03-09 | Fayette | West Virginia | 54019 | 2731 | 70 |
1102052 | 1102052 | 2021-03-08 | Fayette | West Virginia | 54019 | 2726 | 70 |
1098806 | 1098806 | 2021-03-07 | Fayette | West Virginia | 54019 | 2719 | 70 |
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);