ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 54003 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 |
---|---|---|---|---|---|---|---|
1514359 | 1514359 | 2021-07-13 | Berkeley | West Virginia | 54003 | 12909 | 134 |
1511113 | 1511113 | 2021-07-12 | Berkeley | West Virginia | 54003 | 12906 | 134 |
1507866 | 1507866 | 2021-07-11 | Berkeley | West Virginia | 54003 | 12883 | 133 |
1504620 | 1504620 | 2021-07-10 | Berkeley | West Virginia | 54003 | 12883 | 133 |
1501374 | 1501374 | 2021-07-09 | Berkeley | West Virginia | 54003 | 12883 | 133 |
1498128 | 1498128 | 2021-07-08 | Berkeley | West Virginia | 54003 | 12872 | 132 |
1494881 | 1494881 | 2021-07-07 | Berkeley | West Virginia | 54003 | 12864 | 132 |
1491634 | 1491634 | 2021-07-06 | Berkeley | West Virginia | 54003 | 12856 | 132 |
1488387 | 1488387 | 2021-07-05 | Berkeley | West Virginia | 54003 | 12847 | 132 |
1485140 | 1485140 | 2021-07-04 | Berkeley | West Virginia | 54003 | 12847 | 132 |
1481894 | 1481894 | 2021-07-03 | Berkeley | West Virginia | 54003 | 12847 | 132 |
1478647 | 1478647 | 2021-07-02 | Berkeley | West Virginia | 54003 | 12847 | 132 |
1475401 | 1475401 | 2021-07-01 | Berkeley | West Virginia | 54003 | 12842 | 132 |
1472155 | 1472155 | 2021-06-30 | Berkeley | West Virginia | 54003 | 12838 | 132 |
1468910 | 1468910 | 2021-06-29 | Berkeley | West Virginia | 54003 | 12837 | 131 |
1465665 | 1465665 | 2021-06-28 | Berkeley | West Virginia | 54003 | 12833 | 131 |
1462420 | 1462420 | 2021-06-27 | Berkeley | West Virginia | 54003 | 12828 | 131 |
1459175 | 1459175 | 2021-06-26 | Berkeley | West Virginia | 54003 | 12828 | 131 |
1455930 | 1455930 | 2021-06-25 | Berkeley | West Virginia | 54003 | 12828 | 131 |
1452685 | 1452685 | 2021-06-24 | Berkeley | West Virginia | 54003 | 12826 | 131 |
1449439 | 1449439 | 2021-06-23 | Berkeley | West Virginia | 54003 | 12823 | 131 |
1446194 | 1446194 | 2021-06-22 | Berkeley | West Virginia | 54003 | 12820 | 131 |
1442949 | 1442949 | 2021-06-21 | Berkeley | West Virginia | 54003 | 12802 | 130 |
1439704 | 1439704 | 2021-06-20 | Berkeley | West Virginia | 54003 | 12802 | 130 |
1436457 | 1436457 | 2021-06-19 | Berkeley | West Virginia | 54003 | 12802 | 130 |
1433210 | 1433210 | 2021-06-18 | Berkeley | West Virginia | 54003 | 12802 | 130 |
1429964 | 1429964 | 2021-06-17 | Berkeley | West Virginia | 54003 | 12802 | 130 |
1426719 | 1426719 | 2021-06-16 | Berkeley | West Virginia | 54003 | 12796 | 130 |
1423473 | 1423473 | 2021-06-15 | Berkeley | West Virginia | 54003 | 12791 | 130 |
1420226 | 1420226 | 2021-06-14 | Berkeley | West Virginia | 54003 | 12786 | 129 |
1416981 | 1416981 | 2021-06-13 | Berkeley | West Virginia | 54003 | 12775 | 129 |
1413735 | 1413735 | 2021-06-12 | Berkeley | West Virginia | 54003 | 12775 | 129 |
1410490 | 1410490 | 2021-06-11 | Berkeley | West Virginia | 54003 | 12775 | 129 |
1407245 | 1407245 | 2021-06-10 | Berkeley | West Virginia | 54003 | 12768 | 129 |
1403999 | 1403999 | 2021-06-09 | Berkeley | West Virginia | 54003 | 12763 | 129 |
1400754 | 1400754 | 2021-06-08 | Berkeley | West Virginia | 54003 | 12757 | 126 |
1397509 | 1397509 | 2021-06-07 | Berkeley | West Virginia | 54003 | 12752 | 126 |
1394262 | 1394262 | 2021-06-06 | Berkeley | West Virginia | 54003 | 12732 | 126 |
1391017 | 1391017 | 2021-06-05 | Berkeley | West Virginia | 54003 | 12732 | 126 |
1387772 | 1387772 | 2021-06-04 | Berkeley | West Virginia | 54003 | 12732 | 126 |
1384527 | 1384527 | 2021-06-03 | Berkeley | West Virginia | 54003 | 12719 | 126 |
1381281 | 1381281 | 2021-06-02 | Berkeley | West Virginia | 54003 | 12709 | 126 |
1378036 | 1378036 | 2021-06-01 | Berkeley | West Virginia | 54003 | 12694 | 126 |
1374790 | 1374790 | 2021-05-31 | Berkeley | West Virginia | 54003 | 12659 | 126 |
1371545 | 1371545 | 2021-05-30 | Berkeley | West Virginia | 54003 | 12659 | 126 |
1368299 | 1368299 | 2021-05-29 | Berkeley | West Virginia | 54003 | 12659 | 126 |
1365053 | 1365053 | 2021-05-28 | Berkeley | West Virginia | 54003 | 12659 | 126 |
1361807 | 1361807 | 2021-05-27 | Berkeley | West Virginia | 54003 | 12633 | 126 |
1358561 | 1358561 | 2021-05-26 | Berkeley | West Virginia | 54003 | 12615 | 126 |
1355315 | 1355315 | 2021-05-25 | Berkeley | West Virginia | 54003 | 12602 | 126 |
1352069 | 1352069 | 2021-05-24 | Berkeley | West Virginia | 54003 | 12584 | 126 |
1348823 | 1348823 | 2021-05-23 | Berkeley | West Virginia | 54003 | 12540 | 126 |
1345575 | 1345575 | 2021-05-22 | Berkeley | West Virginia | 54003 | 12540 | 126 |
1342327 | 1342327 | 2021-05-21 | Berkeley | West Virginia | 54003 | 12540 | 126 |
1339079 | 1339079 | 2021-05-20 | Berkeley | West Virginia | 54003 | 12523 | 126 |
1335832 | 1335832 | 2021-05-19 | Berkeley | West Virginia | 54003 | 12500 | 126 |
1332585 | 1332585 | 2021-05-18 | Berkeley | West Virginia | 54003 | 12483 | 125 |
1329338 | 1329338 | 2021-05-17 | Berkeley | West Virginia | 54003 | 12470 | 125 |
1326092 | 1326092 | 2021-05-16 | Berkeley | West Virginia | 54003 | 12461 | 125 |
1322846 | 1322846 | 2021-05-15 | Berkeley | West Virginia | 54003 | 12441 | 125 |
1319600 | 1319600 | 2021-05-14 | Berkeley | West Virginia | 54003 | 12425 | 125 |
1316352 | 1316352 | 2021-05-13 | Berkeley | West Virginia | 54003 | 12397 | 125 |
1313106 | 1313106 | 2021-05-12 | Berkeley | West Virginia | 54003 | 12375 | 124 |
1309859 | 1309859 | 2021-05-11 | Berkeley | West Virginia | 54003 | 12347 | 123 |
1306613 | 1306613 | 2021-05-10 | Berkeley | West Virginia | 54003 | 12334 | 123 |
1303367 | 1303367 | 2021-05-09 | Berkeley | West Virginia | 54003 | 12321 | 122 |
1300120 | 1300120 | 2021-05-08 | Berkeley | West Virginia | 54003 | 12279 | 122 |
1296873 | 1296873 | 2021-05-07 | Berkeley | West Virginia | 54003 | 12269 | 122 |
1293627 | 1293627 | 2021-05-06 | Berkeley | West Virginia | 54003 | 12248 | 122 |
1290381 | 1290381 | 2021-05-05 | Berkeley | West Virginia | 54003 | 12221 | 122 |
1287135 | 1287135 | 2021-05-04 | Berkeley | West Virginia | 54003 | 12184 | 121 |
1283889 | 1283889 | 2021-05-03 | Berkeley | West Virginia | 54003 | 12153 | 121 |
1280642 | 1280642 | 2021-05-02 | Berkeley | West Virginia | 54003 | 12122 | 121 |
1277395 | 1277395 | 2021-05-01 | Berkeley | West Virginia | 54003 | 12089 | 121 |
1274148 | 1274148 | 2021-04-30 | Berkeley | West Virginia | 54003 | 12046 | 121 |
1270901 | 1270901 | 2021-04-29 | Berkeley | West Virginia | 54003 | 12016 | 120 |
1267654 | 1267654 | 2021-04-28 | Berkeley | West Virginia | 54003 | 11978 | 120 |
1264407 | 1264407 | 2021-04-27 | Berkeley | West Virginia | 54003 | 11934 | 120 |
1261160 | 1261160 | 2021-04-26 | Berkeley | West Virginia | 54003 | 11914 | 126 |
1257913 | 1257913 | 2021-04-25 | Berkeley | West Virginia | 54003 | 11877 | 126 |
1254666 | 1254666 | 2021-04-24 | Berkeley | West Virginia | 54003 | 11849 | 126 |
1251419 | 1251419 | 2021-04-23 | Berkeley | West Virginia | 54003 | 11802 | 125 |
1248172 | 1248172 | 2021-04-22 | Berkeley | West Virginia | 54003 | 11768 | 124 |
1244925 | 1244925 | 2021-04-21 | Berkeley | West Virginia | 54003 | 11711 | 124 |
1241678 | 1241678 | 2021-04-20 | Berkeley | West Virginia | 54003 | 11667 | 123 |
1238431 | 1238431 | 2021-04-19 | Berkeley | West Virginia | 54003 | 11627 | 123 |
1235184 | 1235184 | 2021-04-18 | Berkeley | West Virginia | 54003 | 11601 | 123 |
1231936 | 1231936 | 2021-04-17 | Berkeley | West Virginia | 54003 | 11541 | 122 |
1228688 | 1228688 | 2021-04-16 | Berkeley | West Virginia | 54003 | 11499 | 122 |
1225440 | 1225440 | 2021-04-15 | Berkeley | West Virginia | 54003 | 11441 | 122 |
1222193 | 1222193 | 2021-04-14 | Berkeley | West Virginia | 54003 | 11391 | 122 |
1218945 | 1218945 | 2021-04-13 | Berkeley | West Virginia | 54003 | 11331 | 121 |
1215697 | 1215697 | 2021-04-12 | Berkeley | West Virginia | 54003 | 11287 | 121 |
1212450 | 1212450 | 2021-04-11 | Berkeley | West Virginia | 54003 | 11261 | 121 |
1209201 | 1209201 | 2021-04-10 | Berkeley | West Virginia | 54003 | 11196 | 121 |
1205953 | 1205953 | 2021-04-09 | Berkeley | West Virginia | 54003 | 11144 | 121 |
1202705 | 1202705 | 2021-04-08 | Berkeley | West Virginia | 54003 | 11094 | 121 |
1199457 | 1199457 | 2021-04-07 | Berkeley | West Virginia | 54003 | 11030 | 120 |
1196208 | 1196208 | 2021-04-06 | Berkeley | West Virginia | 54003 | 10978 | 119 |
1192960 | 1192960 | 2021-04-05 | Berkeley | West Virginia | 54003 | 10945 | 119 |
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);