ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Upshur" 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 |
---|---|---|---|---|---|---|---|
1199504 | 1199504 | 2021-04-07 | Upshur | West Virginia | 54097 | 1798 | 33 |
1196255 | 1196255 | 2021-04-06 | Upshur | West Virginia | 54097 | 1797 | 33 |
1193007 | 1193007 | 2021-04-05 | Upshur | West Virginia | 54097 | 1796 | 33 |
1189757 | 1189757 | 2021-04-04 | Upshur | West Virginia | 54097 | 1796 | 33 |
1186510 | 1186510 | 2021-04-03 | Upshur | West Virginia | 54097 | 1792 | 33 |
1183263 | 1183263 | 2021-04-02 | Upshur | West Virginia | 54097 | 1791 | 33 |
1180016 | 1180016 | 2021-04-01 | Upshur | West Virginia | 54097 | 1784 | 33 |
1176769 | 1176769 | 2021-03-31 | Upshur | West Virginia | 54097 | 1782 | 33 |
1173522 | 1173522 | 2021-03-30 | Upshur | West Virginia | 54097 | 1780 | 32 |
1170275 | 1170275 | 2021-03-29 | Upshur | West Virginia | 54097 | 1776 | 32 |
1167027 | 1167027 | 2021-03-28 | Upshur | West Virginia | 54097 | 1770 | 32 |
1163779 | 1163779 | 2021-03-27 | Upshur | West Virginia | 54097 | 1769 | 32 |
1160531 | 1160531 | 2021-03-26 | Upshur | West Virginia | 54097 | 1765 | 32 |
1157283 | 1157283 | 2021-03-25 | Upshur | West Virginia | 54097 | 1761 | 32 |
1154036 | 1154036 | 2021-03-24 | Upshur | West Virginia | 54097 | 1754 | 32 |
1150789 | 1150789 | 2021-03-23 | Upshur | West Virginia | 54097 | 1749 | 32 |
1147542 | 1147542 | 2021-03-22 | Upshur | West Virginia | 54097 | 1744 | 32 |
1144295 | 1144295 | 2021-03-21 | Upshur | West Virginia | 54097 | 1742 | 31 |
1141048 | 1141048 | 2021-03-20 | Upshur | West Virginia | 54097 | 1737 | 31 |
1137802 | 1137802 | 2021-03-19 | Upshur | West Virginia | 54097 | 1736 | 31 |
1134556 | 1134556 | 2021-03-18 | Upshur | West Virginia | 54097 | 1732 | 31 |
1131308 | 1131308 | 2021-03-17 | Upshur | West Virginia | 54097 | 1730 | 31 |
1128061 | 1128061 | 2021-03-16 | Upshur | West Virginia | 54097 | 1728 | 31 |
1124815 | 1124815 | 2021-03-15 | Upshur | West Virginia | 54097 | 1724 | 31 |
1121569 | 1121569 | 2021-03-14 | Upshur | West Virginia | 54097 | 1723 | 31 |
1118322 | 1118322 | 2021-03-13 | Upshur | West Virginia | 54097 | 1720 | 31 |
1115075 | 1115075 | 2021-03-12 | Upshur | West Virginia | 54097 | 1717 | 31 |
1111829 | 1111829 | 2021-03-11 | Upshur | West Virginia | 54097 | 1717 | 31 |
1108583 | 1108583 | 2021-03-10 | Upshur | West Virginia | 54097 | 1715 | 31 |
1105337 | 1105337 | 2021-03-09 | Upshur | West Virginia | 54097 | 1716 | 30 |
1102091 | 1102091 | 2021-03-08 | Upshur | West Virginia | 54097 | 1713 | 30 |
1098845 | 1098845 | 2021-03-07 | Upshur | West Virginia | 54097 | 1713 | 30 |
1095597 | 1095597 | 2021-03-06 | Upshur | West Virginia | 54097 | 1710 | 30 |
1092351 | 1092351 | 2021-03-05 | Upshur | West Virginia | 54097 | 1707 | 30 |
1089105 | 1089105 | 2021-03-04 | Upshur | West Virginia | 54097 | 1703 | 30 |
1085860 | 1085860 | 2021-03-03 | Upshur | West Virginia | 54097 | 1693 | 30 |
1082614 | 1082614 | 2021-03-02 | Upshur | West Virginia | 54097 | 1690 | 30 |
1079368 | 1079368 | 2021-03-01 | Upshur | West Virginia | 54097 | 1684 | 30 |
1076123 | 1076123 | 2021-02-28 | Upshur | West Virginia | 54097 | 1683 | 30 |
1072877 | 1072877 | 2021-02-27 | Upshur | West Virginia | 54097 | 1679 | 30 |
1069631 | 1069631 | 2021-02-26 | Upshur | West Virginia | 54097 | 1678 | 30 |
1066386 | 1066386 | 2021-02-25 | Upshur | West Virginia | 54097 | 1668 | 30 |
1063141 | 1063141 | 2021-02-24 | Upshur | West Virginia | 54097 | 1660 | 30 |
1059896 | 1059896 | 2021-02-23 | Upshur | West Virginia | 54097 | 1658 | 30 |
1056650 | 1056650 | 2021-02-22 | Upshur | West Virginia | 54097 | 1655 | 30 |
1053404 | 1053404 | 2021-02-21 | Upshur | West Virginia | 54097 | 1652 | 30 |
1050157 | 1050157 | 2021-02-20 | Upshur | West Virginia | 54097 | 1651 | 30 |
1046910 | 1046910 | 2021-02-19 | Upshur | West Virginia | 54097 | 1640 | 30 |
1043665 | 1043665 | 2021-02-18 | Upshur | West Virginia | 54097 | 1634 | 30 |
1040420 | 1040420 | 2021-02-17 | Upshur | West Virginia | 54097 | 1626 | 29 |
1037175 | 1037175 | 2021-02-16 | Upshur | West Virginia | 54097 | 1623 | 29 |
1033930 | 1033930 | 2021-02-15 | Upshur | West Virginia | 54097 | 1620 | 29 |
1030684 | 1030684 | 2021-02-14 | Upshur | West Virginia | 54097 | 1614 | 29 |
1027437 | 1027437 | 2021-02-13 | Upshur | West Virginia | 54097 | 1613 | 29 |
1024192 | 1024192 | 2021-02-12 | Upshur | West Virginia | 54097 | 1611 | 29 |
1020947 | 1020947 | 2021-02-11 | Upshur | West Virginia | 54097 | 1605 | 29 |
1017702 | 1017702 | 2021-02-10 | Upshur | West Virginia | 54097 | 1600 | 29 |
1014457 | 1014457 | 2021-02-09 | Upshur | West Virginia | 54097 | 1585 | 27 |
1011212 | 1011212 | 2021-02-08 | Upshur | West Virginia | 54097 | 1578 | 27 |
1007966 | 1007966 | 2021-02-07 | Upshur | West Virginia | 54097 | 1570 | 27 |
1004720 | 1004720 | 2021-02-06 | Upshur | West Virginia | 54097 | 1569 | 26 |
1001474 | 1001474 | 2021-02-05 | Upshur | West Virginia | 54097 | 1551 | 25 |
998228 | 998228 | 2021-02-04 | Upshur | West Virginia | 54097 | 1534 | 25 |
994982 | 994982 | 2021-02-03 | Upshur | West Virginia | 54097 | 1517 | 25 |
991736 | 991736 | 2021-02-02 | Upshur | West Virginia | 54097 | 1506 | 23 |
988490 | 988490 | 2021-02-01 | Upshur | West Virginia | 54097 | 1497 | 23 |
985243 | 985243 | 2021-01-31 | Upshur | West Virginia | 54097 | 1492 | 23 |
981996 | 981996 | 2021-01-30 | Upshur | West Virginia | 54097 | 1483 | 23 |
978750 | 978750 | 2021-01-29 | Upshur | West Virginia | 54097 | 1471 | 23 |
975505 | 975505 | 2021-01-28 | Upshur | West Virginia | 54097 | 1462 | 23 |
972260 | 972260 | 2021-01-27 | Upshur | West Virginia | 54097 | 1451 | 20 |
969015 | 969015 | 2021-01-26 | Upshur | West Virginia | 54097 | 1435 | 19 |
965771 | 965771 | 2021-01-25 | Upshur | West Virginia | 54097 | 1420 | 19 |
962526 | 962526 | 2021-01-24 | Upshur | West Virginia | 54097 | 1417 | 19 |
959281 | 959281 | 2021-01-23 | Upshur | West Virginia | 54097 | 1406 | 19 |
956035 | 956035 | 2021-01-22 | Upshur | West Virginia | 54097 | 1358 | 20 |
952790 | 952790 | 2021-01-21 | Upshur | West Virginia | 54097 | 1333 | 20 |
949545 | 949545 | 2021-01-20 | Upshur | West Virginia | 54097 | 1307 | 20 |
946299 | 946299 | 2021-01-19 | Upshur | West Virginia | 54097 | 1290 | 19 |
943052 | 943052 | 2021-01-18 | Upshur | West Virginia | 54097 | 1274 | 19 |
939807 | 939807 | 2021-01-17 | Upshur | West Virginia | 54097 | 1268 | 17 |
936562 | 936562 | 2021-01-16 | Upshur | West Virginia | 54097 | 1260 | 16 |
933317 | 933317 | 2021-01-15 | Upshur | West Virginia | 54097 | 1237 | 15 |
930072 | 930072 | 2021-01-14 | Upshur | West Virginia | 54097 | 1215 | 14 |
926827 | 926827 | 2021-01-13 | Upshur | West Virginia | 54097 | 1203 | 13 |
923581 | 923581 | 2021-01-12 | Upshur | West Virginia | 54097 | 1188 | 12 |
920336 | 920336 | 2021-01-11 | Upshur | West Virginia | 54097 | 1180 | 11 |
917091 | 917091 | 2021-01-10 | Upshur | West Virginia | 54097 | 1173 | 11 |
913846 | 913846 | 2021-01-09 | Upshur | West Virginia | 54097 | 1165 | 9 |
910601 | 910601 | 2021-01-08 | Upshur | West Virginia | 54097 | 1153 | 7 |
907356 | 907356 | 2021-01-07 | Upshur | West Virginia | 54097 | 1098 | 7 |
904110 | 904110 | 2021-01-06 | Upshur | West Virginia | 54097 | 1080 | 6 |
900865 | 900865 | 2021-01-05 | Upshur | West Virginia | 54097 | 1057 | 5 |
897620 | 897620 | 2021-01-04 | Upshur | West Virginia | 54097 | 1026 | 5 |
894374 | 894374 | 2021-01-03 | Upshur | West Virginia | 54097 | 999 | 5 |
891128 | 891128 | 2021-01-02 | Upshur | West Virginia | 54097 | 970 | 5 |
887881 | 887881 | 2021-01-01 | Upshur | West Virginia | 54097 | 964 | 4 |
884636 | 884636 | 2020-12-31 | Upshur | West Virginia | 54097 | 922 | 4 |
881391 | 881391 | 2020-12-30 | Upshur | West Virginia | 54097 | 900 | 4 |
878146 | 878146 | 2020-12-29 | Upshur | West Virginia | 54097 | 870 | 4 |
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);