ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 54045 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 |
---|---|---|---|---|---|---|---|
1420247 | 1420247 | 2021-06-14 | Logan | West Virginia | 54045 | 3267 | 95 |
1417002 | 1417002 | 2021-06-13 | Logan | West Virginia | 54045 | 3263 | 95 |
1413756 | 1413756 | 2021-06-12 | Logan | West Virginia | 54045 | 3263 | 95 |
1410511 | 1410511 | 2021-06-11 | Logan | West Virginia | 54045 | 3263 | 95 |
1407266 | 1407266 | 2021-06-10 | Logan | West Virginia | 54045 | 3262 | 95 |
1404020 | 1404020 | 2021-06-09 | Logan | West Virginia | 54045 | 3255 | 95 |
1400775 | 1400775 | 2021-06-08 | Logan | West Virginia | 54045 | 3249 | 95 |
1397530 | 1397530 | 2021-06-07 | Logan | West Virginia | 54045 | 3246 | 95 |
1394283 | 1394283 | 2021-06-06 | Logan | West Virginia | 54045 | 3229 | 95 |
1391038 | 1391038 | 2021-06-05 | Logan | West Virginia | 54045 | 3229 | 95 |
1387793 | 1387793 | 2021-06-04 | Logan | West Virginia | 54045 | 3229 | 95 |
1384548 | 1384548 | 2021-06-03 | Logan | West Virginia | 54045 | 3228 | 95 |
1381302 | 1381302 | 2021-06-02 | Logan | West Virginia | 54045 | 3224 | 95 |
1378057 | 1378057 | 2021-06-01 | Logan | West Virginia | 54045 | 3220 | 95 |
1374811 | 1374811 | 2021-05-31 | Logan | West Virginia | 54045 | 3208 | 95 |
1371566 | 1371566 | 2021-05-30 | Logan | West Virginia | 54045 | 3208 | 95 |
1368320 | 1368320 | 2021-05-29 | Logan | West Virginia | 54045 | 3208 | 95 |
1365074 | 1365074 | 2021-05-28 | Logan | West Virginia | 54045 | 3208 | 95 |
1361828 | 1361828 | 2021-05-27 | Logan | West Virginia | 54045 | 3202 | 95 |
1358582 | 1358582 | 2021-05-26 | Logan | West Virginia | 54045 | 3199 | 95 |
1355336 | 1355336 | 2021-05-25 | Logan | West Virginia | 54045 | 3194 | 94 |
1352090 | 1352090 | 2021-05-24 | Logan | West Virginia | 54045 | 3192 | 94 |
1348844 | 1348844 | 2021-05-23 | Logan | West Virginia | 54045 | 3177 | 94 |
1345596 | 1345596 | 2021-05-22 | Logan | West Virginia | 54045 | 3177 | 94 |
1342348 | 1342348 | 2021-05-21 | Logan | West Virginia | 54045 | 3177 | 94 |
1339100 | 1339100 | 2021-05-20 | Logan | West Virginia | 54045 | 3171 | 94 |
1335853 | 1335853 | 2021-05-19 | Logan | West Virginia | 54045 | 3165 | 94 |
1332606 | 1332606 | 2021-05-18 | Logan | West Virginia | 54045 | 3165 | 94 |
1329359 | 1329359 | 2021-05-17 | Logan | West Virginia | 54045 | 3161 | 94 |
1326113 | 1326113 | 2021-05-16 | Logan | West Virginia | 54045 | 3159 | 94 |
1322867 | 1322867 | 2021-05-15 | Logan | West Virginia | 54045 | 3156 | 94 |
1319621 | 1319621 | 2021-05-14 | Logan | West Virginia | 54045 | 3152 | 94 |
1316373 | 1316373 | 2021-05-13 | Logan | West Virginia | 54045 | 3138 | 94 |
1313127 | 1313127 | 2021-05-12 | Logan | West Virginia | 54045 | 3123 | 94 |
1309880 | 1309880 | 2021-05-11 | Logan | West Virginia | 54045 | 3107 | 94 |
1306634 | 1306634 | 2021-05-10 | Logan | West Virginia | 54045 | 3100 | 94 |
1303388 | 1303388 | 2021-05-09 | Logan | West Virginia | 54045 | 3096 | 94 |
1300141 | 1300141 | 2021-05-08 | Logan | West Virginia | 54045 | 3083 | 94 |
1296894 | 1296894 | 2021-05-07 | Logan | West Virginia | 54045 | 3074 | 94 |
1293648 | 1293648 | 2021-05-06 | Logan | West Virginia | 54045 | 3067 | 94 |
1290402 | 1290402 | 2021-05-05 | Logan | West Virginia | 54045 | 3058 | 94 |
1287156 | 1287156 | 2021-05-04 | Logan | West Virginia | 54045 | 3055 | 93 |
1283910 | 1283910 | 2021-05-03 | Logan | West Virginia | 54045 | 3045 | 93 |
1280663 | 1280663 | 2021-05-02 | Logan | West Virginia | 54045 | 3034 | 93 |
1277416 | 1277416 | 2021-05-01 | Logan | West Virginia | 54045 | 3027 | 92 |
1274169 | 1274169 | 2021-04-30 | Logan | West Virginia | 54045 | 3019 | 92 |
1270922 | 1270922 | 2021-04-29 | Logan | West Virginia | 54045 | 3013 | 92 |
1267675 | 1267675 | 2021-04-28 | Logan | West Virginia | 54045 | 3005 | 92 |
1264428 | 1264428 | 2021-04-27 | Logan | West Virginia | 54045 | 2998 | 91 |
1261181 | 1261181 | 2021-04-26 | Logan | West Virginia | 54045 | 2996 | 91 |
1257934 | 1257934 | 2021-04-25 | Logan | West Virginia | 54045 | 2994 | 91 |
1254687 | 1254687 | 2021-04-24 | Logan | West Virginia | 54045 | 2991 | 91 |
1251440 | 1251440 | 2021-04-23 | Logan | West Virginia | 54045 | 3016 | 91 |
1248193 | 1248193 | 2021-04-22 | Logan | West Virginia | 54045 | 3011 | 91 |
1244946 | 1244946 | 2021-04-21 | Logan | West Virginia | 54045 | 3009 | 90 |
1241699 | 1241699 | 2021-04-20 | Logan | West Virginia | 54045 | 3007 | 90 |
1238452 | 1238452 | 2021-04-19 | Logan | West Virginia | 54045 | 3006 | 90 |
1235205 | 1235205 | 2021-04-18 | Logan | West Virginia | 54045 | 3003 | 90 |
1231957 | 1231957 | 2021-04-17 | Logan | West Virginia | 54045 | 3001 | 90 |
1228709 | 1228709 | 2021-04-16 | Logan | West Virginia | 54045 | 2990 | 90 |
1225461 | 1225461 | 2021-04-15 | Logan | West Virginia | 54045 | 2988 | 89 |
1222214 | 1222214 | 2021-04-14 | Logan | West Virginia | 54045 | 2987 | 89 |
1218966 | 1218966 | 2021-04-13 | Logan | West Virginia | 54045 | 2986 | 89 |
1215718 | 1215718 | 2021-04-12 | Logan | West Virginia | 54045 | 2983 | 89 |
1212471 | 1212471 | 2021-04-11 | Logan | West Virginia | 54045 | 2982 | 89 |
1209222 | 1209222 | 2021-04-10 | Logan | West Virginia | 54045 | 2976 | 89 |
1205974 | 1205974 | 2021-04-09 | Logan | West Virginia | 54045 | 2975 | 89 |
1202726 | 1202726 | 2021-04-08 | Logan | West Virginia | 54045 | 2973 | 89 |
1199478 | 1199478 | 2021-04-07 | Logan | West Virginia | 54045 | 2962 | 89 |
1196229 | 1196229 | 2021-04-06 | Logan | West Virginia | 54045 | 2957 | 89 |
1192981 | 1192981 | 2021-04-05 | Logan | West Virginia | 54045 | 2954 | 87 |
1189731 | 1189731 | 2021-04-04 | Logan | West Virginia | 54045 | 2953 | 87 |
1186484 | 1186484 | 2021-04-03 | Logan | West Virginia | 54045 | 2952 | 87 |
1183237 | 1183237 | 2021-04-02 | Logan | West Virginia | 54045 | 2951 | 86 |
1179990 | 1179990 | 2021-04-01 | Logan | West Virginia | 54045 | 2947 | 86 |
1176743 | 1176743 | 2021-03-31 | Logan | West Virginia | 54045 | 2943 | 86 |
1173496 | 1173496 | 2021-03-30 | Logan | West Virginia | 54045 | 2935 | 84 |
1170249 | 1170249 | 2021-03-29 | Logan | West Virginia | 54045 | 2933 | 84 |
1167001 | 1167001 | 2021-03-28 | Logan | West Virginia | 54045 | 2930 | 84 |
1163753 | 1163753 | 2021-03-27 | Logan | West Virginia | 54045 | 2924 | 83 |
1160505 | 1160505 | 2021-03-26 | Logan | West Virginia | 54045 | 2922 | 83 |
1157257 | 1157257 | 2021-03-25 | Logan | West Virginia | 54045 | 2917 | 82 |
1154010 | 1154010 | 2021-03-24 | Logan | West Virginia | 54045 | 2912 | 82 |
1150763 | 1150763 | 2021-03-23 | Logan | West Virginia | 54045 | 2906 | 82 |
1147516 | 1147516 | 2021-03-22 | Logan | West Virginia | 54045 | 2898 | 82 |
1144269 | 1144269 | 2021-03-21 | Logan | West Virginia | 54045 | 2892 | 82 |
1141022 | 1141022 | 2021-03-20 | Logan | West Virginia | 54045 | 2885 | 82 |
1137776 | 1137776 | 2021-03-19 | Logan | West Virginia | 54045 | 2878 | 82 |
1134530 | 1134530 | 2021-03-18 | Logan | West Virginia | 54045 | 2858 | 82 |
1131282 | 1131282 | 2021-03-17 | Logan | West Virginia | 54045 | 2845 | 82 |
1128035 | 1128035 | 2021-03-16 | Logan | West Virginia | 54045 | 2833 | 82 |
1124789 | 1124789 | 2021-03-15 | Logan | West Virginia | 54045 | 2812 | 80 |
1121543 | 1121543 | 2021-03-14 | Logan | West Virginia | 54045 | 2802 | 80 |
1118296 | 1118296 | 2021-03-13 | Logan | West Virginia | 54045 | 2778 | 79 |
1115049 | 1115049 | 2021-03-12 | Logan | West Virginia | 54045 | 2771 | 79 |
1111803 | 1111803 | 2021-03-11 | Logan | West Virginia | 54045 | 2764 | 78 |
1108557 | 1108557 | 2021-03-10 | Logan | West Virginia | 54045 | 2756 | 77 |
1105311 | 1105311 | 2021-03-09 | Logan | West Virginia | 54045 | 2748 | 77 |
1102065 | 1102065 | 2021-03-08 | Logan | West Virginia | 54045 | 2742 | 77 |
1098819 | 1098819 | 2021-03-07 | Logan | West Virginia | 54045 | 2731 | 77 |
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);