ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 54025 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 |
---|---|---|---|---|---|---|---|
1624802 | 1624802 | 2021-08-16 | Greenbrier | West Virginia | 54025 | 2977 | 66 |
1621555 | 1621555 | 2021-08-15 | Greenbrier | West Virginia | 54025 | 2970 | 66 |
1618307 | 1618307 | 2021-08-14 | Greenbrier | West Virginia | 54025 | 2970 | 66 |
1615059 | 1615059 | 2021-08-13 | Greenbrier | West Virginia | 54025 | 2970 | 66 |
1611810 | 1611810 | 2021-08-12 | Greenbrier | West Virginia | 54025 | 2970 | 66 |
1608563 | 1608563 | 2021-08-11 | Greenbrier | West Virginia | 54025 | 2961 | 66 |
1605314 | 1605314 | 2021-08-10 | Greenbrier | West Virginia | 54025 | 2958 | 66 |
1602064 | 1602064 | 2021-08-09 | Greenbrier | West Virginia | 54025 | 2956 | 66 |
1598816 | 1598816 | 2021-08-08 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1595567 | 1595567 | 2021-08-07 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1592318 | 1592318 | 2021-08-06 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1589069 | 1589069 | 2021-08-05 | Greenbrier | West Virginia | 54025 | 2940 | 65 |
1585820 | 1585820 | 2021-08-04 | Greenbrier | West Virginia | 54025 | 2938 | 65 |
1582570 | 1582570 | 2021-08-03 | Greenbrier | West Virginia | 54025 | 2932 | 65 |
1579320 | 1579320 | 2021-08-02 | Greenbrier | West Virginia | 54025 | 2930 | 65 |
1576072 | 1576072 | 2021-08-01 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1572824 | 1572824 | 2021-07-31 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1569576 | 1569576 | 2021-07-30 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1566328 | 1566328 | 2021-07-29 | Greenbrier | West Virginia | 54025 | 2922 | 65 |
1563080 | 1563080 | 2021-07-28 | Greenbrier | West Virginia | 54025 | 2921 | 65 |
1559832 | 1559832 | 2021-07-27 | Greenbrier | West Virginia | 54025 | 2921 | 65 |
1556585 | 1556585 | 2021-07-26 | Greenbrier | West Virginia | 54025 | 2920 | 65 |
1553338 | 1553338 | 2021-07-25 | Greenbrier | West Virginia | 54025 | 2919 | 65 |
1550091 | 1550091 | 2021-07-24 | Greenbrier | West Virginia | 54025 | 2919 | 65 |
1546844 | 1546844 | 2021-07-23 | Greenbrier | West Virginia | 54025 | 2919 | 65 |
1543597 | 1543597 | 2021-07-22 | Greenbrier | West Virginia | 54025 | 2916 | 65 |
1540349 | 1540349 | 2021-07-21 | Greenbrier | West Virginia | 54025 | 2915 | 65 |
1537102 | 1537102 | 2021-07-20 | Greenbrier | West Virginia | 54025 | 2915 | 65 |
1533854 | 1533854 | 2021-07-19 | Greenbrier | West Virginia | 54025 | 2915 | 65 |
1530607 | 1530607 | 2021-07-18 | Greenbrier | West Virginia | 54025 | 2913 | 65 |
1527360 | 1527360 | 2021-07-17 | Greenbrier | West Virginia | 54025 | 2913 | 65 |
1524113 | 1524113 | 2021-07-16 | Greenbrier | West Virginia | 54025 | 2913 | 65 |
1520865 | 1520865 | 2021-07-15 | Greenbrier | West Virginia | 54025 | 2913 | 64 |
1517617 | 1517617 | 2021-07-14 | Greenbrier | West Virginia | 54025 | 2913 | 64 |
1514370 | 1514370 | 2021-07-13 | Greenbrier | West Virginia | 54025 | 2913 | 64 |
1511124 | 1511124 | 2021-07-12 | Greenbrier | West Virginia | 54025 | 2911 | 64 |
1507877 | 1507877 | 2021-07-11 | Greenbrier | West Virginia | 54025 | 2906 | 64 |
1504631 | 1504631 | 2021-07-10 | Greenbrier | West Virginia | 54025 | 2906 | 64 |
1501385 | 1501385 | 2021-07-09 | Greenbrier | West Virginia | 54025 | 2906 | 64 |
1498139 | 1498139 | 2021-07-08 | Greenbrier | West Virginia | 54025 | 2905 | 64 |
1494892 | 1494892 | 2021-07-07 | Greenbrier | West Virginia | 54025 | 2903 | 64 |
1491645 | 1491645 | 2021-07-06 | Greenbrier | West Virginia | 54025 | 2902 | 64 |
1488398 | 1488398 | 2021-07-05 | Greenbrier | West Virginia | 54025 | 2900 | 64 |
1485151 | 1485151 | 2021-07-04 | Greenbrier | West Virginia | 54025 | 2900 | 64 |
1481905 | 1481905 | 2021-07-03 | Greenbrier | West Virginia | 54025 | 2900 | 64 |
1478658 | 1478658 | 2021-07-02 | Greenbrier | West Virginia | 54025 | 2900 | 64 |
1475412 | 1475412 | 2021-07-01 | Greenbrier | West Virginia | 54025 | 2897 | 64 |
1472166 | 1472166 | 2021-06-30 | Greenbrier | West Virginia | 54025 | 2894 | 64 |
1468921 | 1468921 | 2021-06-29 | Greenbrier | West Virginia | 54025 | 2892 | 64 |
1465676 | 1465676 | 2021-06-28 | Greenbrier | West Virginia | 54025 | 2892 | 64 |
1462431 | 1462431 | 2021-06-27 | Greenbrier | West Virginia | 54025 | 2890 | 64 |
1459186 | 1459186 | 2021-06-26 | Greenbrier | West Virginia | 54025 | 2890 | 64 |
1455941 | 1455941 | 2021-06-25 | Greenbrier | West Virginia | 54025 | 2890 | 64 |
1452696 | 1452696 | 2021-06-24 | Greenbrier | West Virginia | 54025 | 2889 | 64 |
1449450 | 1449450 | 2021-06-23 | Greenbrier | West Virginia | 54025 | 2886 | 64 |
1446205 | 1446205 | 2021-06-22 | Greenbrier | West Virginia | 54025 | 2886 | 64 |
1442960 | 1442960 | 2021-06-21 | Greenbrier | West Virginia | 54025 | 2883 | 64 |
1439715 | 1439715 | 2021-06-20 | Greenbrier | West Virginia | 54025 | 2883 | 64 |
1436468 | 1436468 | 2021-06-19 | Greenbrier | West Virginia | 54025 | 2883 | 64 |
1433221 | 1433221 | 2021-06-18 | Greenbrier | West Virginia | 54025 | 2883 | 64 |
1429975 | 1429975 | 2021-06-17 | Greenbrier | West Virginia | 54025 | 2883 | 64 |
1426730 | 1426730 | 2021-06-16 | Greenbrier | West Virginia | 54025 | 2882 | 64 |
1423484 | 1423484 | 2021-06-15 | Greenbrier | West Virginia | 54025 | 2882 | 62 |
1420237 | 1420237 | 2021-06-14 | Greenbrier | West Virginia | 54025 | 2882 | 62 |
1416992 | 1416992 | 2021-06-13 | Greenbrier | West Virginia | 54025 | 2875 | 61 |
1413746 | 1413746 | 2021-06-12 | Greenbrier | West Virginia | 54025 | 2875 | 61 |
1410501 | 1410501 | 2021-06-11 | Greenbrier | West Virginia | 54025 | 2875 | 61 |
1407256 | 1407256 | 2021-06-10 | Greenbrier | West Virginia | 54025 | 2875 | 61 |
1404010 | 1404010 | 2021-06-09 | Greenbrier | West Virginia | 54025 | 2872 | 61 |
1400765 | 1400765 | 2021-06-08 | Greenbrier | West Virginia | 54025 | 2872 | 61 |
1397520 | 1397520 | 2021-06-07 | Greenbrier | West Virginia | 54025 | 2872 | 61 |
1394273 | 1394273 | 2021-06-06 | Greenbrier | West Virginia | 54025 | 2863 | 61 |
1391028 | 1391028 | 2021-06-05 | Greenbrier | West Virginia | 54025 | 2863 | 61 |
1387783 | 1387783 | 2021-06-04 | Greenbrier | West Virginia | 54025 | 2863 | 61 |
1384538 | 1384538 | 2021-06-03 | Greenbrier | West Virginia | 54025 | 2863 | 61 |
1381292 | 1381292 | 2021-06-02 | Greenbrier | West Virginia | 54025 | 2861 | 61 |
1378047 | 1378047 | 2021-06-01 | Greenbrier | West Virginia | 54025 | 2860 | 61 |
1374801 | 1374801 | 2021-05-31 | Greenbrier | West Virginia | 54025 | 2852 | 61 |
1371556 | 1371556 | 2021-05-30 | Greenbrier | West Virginia | 54025 | 2852 | 61 |
1368310 | 1368310 | 2021-05-29 | Greenbrier | West Virginia | 54025 | 2852 | 61 |
1365064 | 1365064 | 2021-05-28 | Greenbrier | West Virginia | 54025 | 2852 | 61 |
1361818 | 1361818 | 2021-05-27 | Greenbrier | West Virginia | 54025 | 2848 | 61 |
1358572 | 1358572 | 2021-05-26 | Greenbrier | West Virginia | 54025 | 2848 | 61 |
1355326 | 1355326 | 2021-05-25 | Greenbrier | West Virginia | 54025 | 2848 | 61 |
1352080 | 1352080 | 2021-05-24 | Greenbrier | West Virginia | 54025 | 2845 | 61 |
1348834 | 1348834 | 2021-05-23 | Greenbrier | West Virginia | 54025 | 2841 | 61 |
1345586 | 1345586 | 2021-05-22 | Greenbrier | West Virginia | 54025 | 2841 | 61 |
1342338 | 1342338 | 2021-05-21 | Greenbrier | West Virginia | 54025 | 2841 | 61 |
1339090 | 1339090 | 2021-05-20 | Greenbrier | West Virginia | 54025 | 2839 | 61 |
1335843 | 1335843 | 2021-05-19 | Greenbrier | West Virginia | 54025 | 2835 | 61 |
1332596 | 1332596 | 2021-05-18 | Greenbrier | West Virginia | 54025 | 2833 | 61 |
1329349 | 1329349 | 2021-05-17 | Greenbrier | West Virginia | 54025 | 2831 | 61 |
1326103 | 1326103 | 2021-05-16 | Greenbrier | West Virginia | 54025 | 2826 | 61 |
1322857 | 1322857 | 2021-05-15 | Greenbrier | West Virginia | 54025 | 2818 | 61 |
1319611 | 1319611 | 2021-05-14 | Greenbrier | West Virginia | 54025 | 2814 | 61 |
1316363 | 1316363 | 2021-05-13 | Greenbrier | West Virginia | 54025 | 2806 | 61 |
1313117 | 1313117 | 2021-05-12 | Greenbrier | West Virginia | 54025 | 2801 | 61 |
1309870 | 1309870 | 2021-05-11 | Greenbrier | West Virginia | 54025 | 2798 | 61 |
1306624 | 1306624 | 2021-05-10 | Greenbrier | West Virginia | 54025 | 2791 | 61 |
1303378 | 1303378 | 2021-05-09 | Greenbrier | West Virginia | 54025 | 2785 | 61 |
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);