ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 54029 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 |
---|---|---|---|---|---|---|---|
1420239 | 1420239 | 2021-06-14 | Hancock | West Virginia | 54029 | 2838 | 89 |
1416994 | 1416994 | 2021-06-13 | Hancock | West Virginia | 54029 | 2837 | 89 |
1413748 | 1413748 | 2021-06-12 | Hancock | West Virginia | 54029 | 2837 | 89 |
1410503 | 1410503 | 2021-06-11 | Hancock | West Virginia | 54029 | 2837 | 89 |
1407258 | 1407258 | 2021-06-10 | Hancock | West Virginia | 54029 | 2837 | 89 |
1404012 | 1404012 | 2021-06-09 | Hancock | West Virginia | 54029 | 2837 | 89 |
1400767 | 1400767 | 2021-06-08 | Hancock | West Virginia | 54029 | 2837 | 89 |
1397522 | 1397522 | 2021-06-07 | Hancock | West Virginia | 54029 | 2837 | 89 |
1394275 | 1394275 | 2021-06-06 | Hancock | West Virginia | 54029 | 2839 | 89 |
1391030 | 1391030 | 2021-06-05 | Hancock | West Virginia | 54029 | 2839 | 89 |
1387785 | 1387785 | 2021-06-04 | Hancock | West Virginia | 54029 | 2839 | 89 |
1384540 | 1384540 | 2021-06-03 | Hancock | West Virginia | 54029 | 2839 | 89 |
1381294 | 1381294 | 2021-06-02 | Hancock | West Virginia | 54029 | 2837 | 89 |
1378049 | 1378049 | 2021-06-01 | Hancock | West Virginia | 54029 | 2838 | 89 |
1374803 | 1374803 | 2021-05-31 | Hancock | West Virginia | 54029 | 2835 | 89 |
1371558 | 1371558 | 2021-05-30 | Hancock | West Virginia | 54029 | 2835 | 89 |
1368312 | 1368312 | 2021-05-29 | Hancock | West Virginia | 54029 | 2835 | 89 |
1365066 | 1365066 | 2021-05-28 | Hancock | West Virginia | 54029 | 2835 | 89 |
1361820 | 1361820 | 2021-05-27 | Hancock | West Virginia | 54029 | 2834 | 89 |
1358574 | 1358574 | 2021-05-26 | Hancock | West Virginia | 54029 | 2832 | 89 |
1355328 | 1355328 | 2021-05-25 | Hancock | West Virginia | 54029 | 2831 | 89 |
1352082 | 1352082 | 2021-05-24 | Hancock | West Virginia | 54029 | 2826 | 89 |
1348836 | 1348836 | 2021-05-23 | Hancock | West Virginia | 54029 | 2823 | 89 |
1345588 | 1345588 | 2021-05-22 | Hancock | West Virginia | 54029 | 2823 | 89 |
1342340 | 1342340 | 2021-05-21 | Hancock | West Virginia | 54029 | 2823 | 89 |
1339092 | 1339092 | 2021-05-20 | Hancock | West Virginia | 54029 | 2819 | 89 |
1335845 | 1335845 | 2021-05-19 | Hancock | West Virginia | 54029 | 2816 | 89 |
1332598 | 1332598 | 2021-05-18 | Hancock | West Virginia | 54029 | 2815 | 89 |
1329351 | 1329351 | 2021-05-17 | Hancock | West Virginia | 54029 | 2815 | 89 |
1326105 | 1326105 | 2021-05-16 | Hancock | West Virginia | 54029 | 2815 | 89 |
1322859 | 1322859 | 2021-05-15 | Hancock | West Virginia | 54029 | 2813 | 89 |
1319613 | 1319613 | 2021-05-14 | Hancock | West Virginia | 54029 | 2808 | 89 |
1316365 | 1316365 | 2021-05-13 | Hancock | West Virginia | 54029 | 2805 | 89 |
1313119 | 1313119 | 2021-05-12 | Hancock | West Virginia | 54029 | 2804 | 89 |
1309872 | 1309872 | 2021-05-11 | Hancock | West Virginia | 54029 | 2800 | 89 |
1306626 | 1306626 | 2021-05-10 | Hancock | West Virginia | 54029 | 2795 | 89 |
1303380 | 1303380 | 2021-05-09 | Hancock | West Virginia | 54029 | 2792 | 89 |
1300133 | 1300133 | 2021-05-08 | Hancock | West Virginia | 54029 | 2788 | 89 |
1296886 | 1296886 | 2021-05-07 | Hancock | West Virginia | 54029 | 2783 | 89 |
1293640 | 1293640 | 2021-05-06 | Hancock | West Virginia | 54029 | 2785 | 89 |
1290394 | 1290394 | 2021-05-05 | Hancock | West Virginia | 54029 | 2781 | 89 |
1287148 | 1287148 | 2021-05-04 | Hancock | West Virginia | 54029 | 2773 | 88 |
1283902 | 1283902 | 2021-05-03 | Hancock | West Virginia | 54029 | 2767 | 88 |
1280655 | 1280655 | 2021-05-02 | Hancock | West Virginia | 54029 | 2761 | 88 |
1277408 | 1277408 | 2021-05-01 | Hancock | West Virginia | 54029 | 2756 | 88 |
1274161 | 1274161 | 2021-04-30 | Hancock | West Virginia | 54029 | 2753 | 88 |
1270914 | 1270914 | 2021-04-29 | Hancock | West Virginia | 54029 | 2742 | 88 |
1267667 | 1267667 | 2021-04-28 | Hancock | West Virginia | 54029 | 2740 | 88 |
1264420 | 1264420 | 2021-04-27 | Hancock | West Virginia | 54029 | 2735 | 87 |
1261173 | 1261173 | 2021-04-26 | Hancock | West Virginia | 54029 | 2733 | 98 |
1257926 | 1257926 | 2021-04-25 | Hancock | West Virginia | 54029 | 2732 | 98 |
1254679 | 1254679 | 2021-04-24 | Hancock | West Virginia | 54029 | 2731 | 98 |
1251432 | 1251432 | 2021-04-23 | Hancock | West Virginia | 54029 | 2725 | 98 |
1248185 | 1248185 | 2021-04-22 | Hancock | West Virginia | 54029 | 2723 | 98 |
1244938 | 1244938 | 2021-04-21 | Hancock | West Virginia | 54029 | 2718 | 98 |
1241691 | 1241691 | 2021-04-20 | Hancock | West Virginia | 54029 | 2714 | 97 |
1238444 | 1238444 | 2021-04-19 | Hancock | West Virginia | 54029 | 2714 | 97 |
1235197 | 1235197 | 2021-04-18 | Hancock | West Virginia | 54029 | 2713 | 97 |
1231949 | 1231949 | 2021-04-17 | Hancock | West Virginia | 54029 | 2705 | 97 |
1228701 | 1228701 | 2021-04-16 | Hancock | West Virginia | 54029 | 2699 | 97 |
1225453 | 1225453 | 2021-04-15 | Hancock | West Virginia | 54029 | 2693 | 97 |
1222206 | 1222206 | 2021-04-14 | Hancock | West Virginia | 54029 | 2686 | 97 |
1218958 | 1218958 | 2021-04-13 | Hancock | West Virginia | 54029 | 2678 | 97 |
1215710 | 1215710 | 2021-04-12 | Hancock | West Virginia | 54029 | 2676 | 97 |
1212463 | 1212463 | 2021-04-11 | Hancock | West Virginia | 54029 | 2674 | 97 |
1209214 | 1209214 | 2021-04-10 | Hancock | West Virginia | 54029 | 2671 | 97 |
1205966 | 1205966 | 2021-04-09 | Hancock | West Virginia | 54029 | 2667 | 97 |
1202718 | 1202718 | 2021-04-08 | Hancock | West Virginia | 54029 | 2657 | 97 |
1199470 | 1199470 | 2021-04-07 | Hancock | West Virginia | 54029 | 2649 | 97 |
1196221 | 1196221 | 2021-04-06 | Hancock | West Virginia | 54029 | 2650 | 97 |
1192973 | 1192973 | 2021-04-05 | Hancock | West Virginia | 54029 | 2647 | 97 |
1189723 | 1189723 | 2021-04-04 | Hancock | West Virginia | 54029 | 2643 | 97 |
1186476 | 1186476 | 2021-04-03 | Hancock | West Virginia | 54029 | 2638 | 97 |
1183229 | 1183229 | 2021-04-02 | Hancock | West Virginia | 54029 | 2634 | 97 |
1179982 | 1179982 | 2021-04-01 | Hancock | West Virginia | 54029 | 2633 | 96 |
1176735 | 1176735 | 2021-03-31 | Hancock | West Virginia | 54029 | 2631 | 96 |
1173488 | 1173488 | 2021-03-30 | Hancock | West Virginia | 54029 | 2630 | 95 |
1170241 | 1170241 | 2021-03-29 | Hancock | West Virginia | 54029 | 2629 | 95 |
1166993 | 1166993 | 2021-03-28 | Hancock | West Virginia | 54029 | 2627 | 95 |
1163745 | 1163745 | 2021-03-27 | Hancock | West Virginia | 54029 | 2627 | 95 |
1160497 | 1160497 | 2021-03-26 | Hancock | West Virginia | 54029 | 2622 | 95 |
1157249 | 1157249 | 2021-03-25 | Hancock | West Virginia | 54029 | 2617 | 95 |
1154002 | 1154002 | 2021-03-24 | Hancock | West Virginia | 54029 | 2613 | 95 |
1150755 | 1150755 | 2021-03-23 | Hancock | West Virginia | 54029 | 2610 | 95 |
1147508 | 1147508 | 2021-03-22 | Hancock | West Virginia | 54029 | 2610 | 95 |
1144261 | 1144261 | 2021-03-21 | Hancock | West Virginia | 54029 | 2609 | 95 |
1141014 | 1141014 | 2021-03-20 | Hancock | West Virginia | 54029 | 2607 | 95 |
1137768 | 1137768 | 2021-03-19 | Hancock | West Virginia | 54029 | 2603 | 95 |
1134522 | 1134522 | 2021-03-18 | Hancock | West Virginia | 54029 | 2601 | 93 |
1131274 | 1131274 | 2021-03-17 | Hancock | West Virginia | 54029 | 2601 | 92 |
1128027 | 1128027 | 2021-03-16 | Hancock | West Virginia | 54029 | 2600 | 92 |
1124781 | 1124781 | 2021-03-15 | Hancock | West Virginia | 54029 | 2597 | 92 |
1121535 | 1121535 | 2021-03-14 | Hancock | West Virginia | 54029 | 2596 | 92 |
1118288 | 1118288 | 2021-03-13 | Hancock | West Virginia | 54029 | 2596 | 92 |
1115041 | 1115041 | 2021-03-12 | Hancock | West Virginia | 54029 | 2595 | 91 |
1111795 | 1111795 | 2021-03-11 | Hancock | West Virginia | 54029 | 2595 | 86 |
1108549 | 1108549 | 2021-03-10 | Hancock | West Virginia | 54029 | 2595 | 86 |
1105303 | 1105303 | 2021-03-09 | Hancock | West Virginia | 54029 | 2595 | 86 |
1102057 | 1102057 | 2021-03-08 | Hancock | West Virginia | 54029 | 2595 | 86 |
1098811 | 1098811 | 2021-03-07 | Hancock | West Virginia | 54029 | 2595 | 86 |
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);