ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 54053 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 |
---|---|---|---|---|---|---|---|
1196232 | 1196232 | 2021-04-06 | Mason | West Virginia | 54053 | 1891 | 40 |
1192984 | 1192984 | 2021-04-05 | Mason | West Virginia | 54053 | 1890 | 40 |
1189734 | 1189734 | 2021-04-04 | Mason | West Virginia | 54053 | 1887 | 40 |
1186487 | 1186487 | 2021-04-03 | Mason | West Virginia | 54053 | 1886 | 40 |
1183240 | 1183240 | 2021-04-02 | Mason | West Virginia | 54053 | 1882 | 40 |
1179993 | 1179993 | 2021-04-01 | Mason | West Virginia | 54053 | 1878 | 40 |
1176746 | 1176746 | 2021-03-31 | Mason | West Virginia | 54053 | 1872 | 40 |
1173499 | 1173499 | 2021-03-30 | Mason | West Virginia | 54053 | 1868 | 40 |
1170252 | 1170252 | 2021-03-29 | Mason | West Virginia | 54053 | 1865 | 40 |
1167004 | 1167004 | 2021-03-28 | Mason | West Virginia | 54053 | 1859 | 40 |
1163756 | 1163756 | 2021-03-27 | Mason | West Virginia | 54053 | 1856 | 40 |
1160508 | 1160508 | 2021-03-26 | Mason | West Virginia | 54053 | 1853 | 40 |
1157260 | 1157260 | 2021-03-25 | Mason | West Virginia | 54053 | 1848 | 40 |
1154013 | 1154013 | 2021-03-24 | Mason | West Virginia | 54053 | 1843 | 40 |
1150766 | 1150766 | 2021-03-23 | Mason | West Virginia | 54053 | 1839 | 40 |
1147519 | 1147519 | 2021-03-22 | Mason | West Virginia | 54053 | 1835 | 40 |
1144272 | 1144272 | 2021-03-21 | Mason | West Virginia | 54053 | 1831 | 40 |
1141025 | 1141025 | 2021-03-20 | Mason | West Virginia | 54053 | 1828 | 40 |
1137779 | 1137779 | 2021-03-19 | Mason | West Virginia | 54053 | 1825 | 40 |
1134533 | 1134533 | 2021-03-18 | Mason | West Virginia | 54053 | 1825 | 41 |
1131285 | 1131285 | 2021-03-17 | Mason | West Virginia | 54053 | 1824 | 41 |
1128038 | 1128038 | 2021-03-16 | Mason | West Virginia | 54053 | 1818 | 40 |
1124792 | 1124792 | 2021-03-15 | Mason | West Virginia | 54053 | 1815 | 40 |
1121546 | 1121546 | 2021-03-14 | Mason | West Virginia | 54053 | 1809 | 40 |
1118299 | 1118299 | 2021-03-13 | Mason | West Virginia | 54053 | 1808 | 40 |
1115052 | 1115052 | 2021-03-12 | Mason | West Virginia | 54053 | 1805 | 40 |
1111806 | 1111806 | 2021-03-11 | Mason | West Virginia | 54053 | 1800 | 39 |
1108560 | 1108560 | 2021-03-10 | Mason | West Virginia | 54053 | 1798 | 38 |
1105314 | 1105314 | 2021-03-09 | Mason | West Virginia | 54053 | 1797 | 38 |
1102068 | 1102068 | 2021-03-08 | Mason | West Virginia | 54053 | 1795 | 38 |
1098822 | 1098822 | 2021-03-07 | Mason | West Virginia | 54053 | 1792 | 38 |
1095574 | 1095574 | 2021-03-06 | Mason | West Virginia | 54053 | 1782 | 37 |
1092328 | 1092328 | 2021-03-05 | Mason | West Virginia | 54053 | 1780 | 37 |
1089082 | 1089082 | 2021-03-04 | Mason | West Virginia | 54053 | 1778 | 37 |
1085837 | 1085837 | 2021-03-03 | Mason | West Virginia | 54053 | 1775 | 37 |
1082591 | 1082591 | 2021-03-02 | Mason | West Virginia | 54053 | 1770 | 36 |
1079345 | 1079345 | 2021-03-01 | Mason | West Virginia | 54053 | 1766 | 36 |
1076100 | 1076100 | 2021-02-28 | Mason | West Virginia | 54053 | 1767 | 36 |
1072854 | 1072854 | 2021-02-27 | Mason | West Virginia | 54053 | 1767 | 36 |
1069608 | 1069608 | 2021-02-26 | Mason | West Virginia | 54053 | 1766 | 36 |
1066363 | 1066363 | 2021-02-25 | Mason | West Virginia | 54053 | 1763 | 36 |
1063118 | 1063118 | 2021-02-24 | Mason | West Virginia | 54053 | 1758 | 36 |
1059873 | 1059873 | 2021-02-23 | Mason | West Virginia | 54053 | 1757 | 36 |
1056627 | 1056627 | 2021-02-22 | Mason | West Virginia | 54053 | 1757 | 36 |
1053381 | 1053381 | 2021-02-21 | Mason | West Virginia | 54053 | 1756 | 36 |
1050134 | 1050134 | 2021-02-20 | Mason | West Virginia | 54053 | 1753 | 36 |
1046887 | 1046887 | 2021-02-19 | Mason | West Virginia | 54053 | 1746 | 36 |
1043642 | 1043642 | 2021-02-18 | Mason | West Virginia | 54053 | 1746 | 36 |
1040397 | 1040397 | 2021-02-17 | Mason | West Virginia | 54053 | 1742 | 36 |
1037152 | 1037152 | 2021-02-16 | Mason | West Virginia | 54053 | 1742 | 36 |
1033907 | 1033907 | 2021-02-15 | Mason | West Virginia | 54053 | 1741 | 36 |
1030661 | 1030661 | 2021-02-14 | Mason | West Virginia | 54053 | 1739 | 36 |
1027414 | 1027414 | 2021-02-13 | Mason | West Virginia | 54053 | 1735 | 36 |
1024169 | 1024169 | 2021-02-12 | Mason | West Virginia | 54053 | 1725 | 36 |
1020924 | 1020924 | 2021-02-11 | Mason | West Virginia | 54053 | 1720 | 36 |
1017679 | 1017679 | 2021-02-10 | Mason | West Virginia | 54053 | 1717 | 36 |
1014434 | 1014434 | 2021-02-09 | Mason | West Virginia | 54053 | 1714 | 35 |
1011189 | 1011189 | 2021-02-08 | Mason | West Virginia | 54053 | 1709 | 35 |
1007943 | 1007943 | 2021-02-07 | Mason | West Virginia | 54053 | 1705 | 35 |
1004697 | 1004697 | 2021-02-06 | Mason | West Virginia | 54053 | 1701 | 35 |
1001451 | 1001451 | 2021-02-05 | Mason | West Virginia | 54053 | 1700 | 34 |
998205 | 998205 | 2021-02-04 | Mason | West Virginia | 54053 | 1688 | 32 |
994959 | 994959 | 2021-02-03 | Mason | West Virginia | 54053 | 1678 | 31 |
991713 | 991713 | 2021-02-02 | Mason | West Virginia | 54053 | 1671 | 31 |
988467 | 988467 | 2021-02-01 | Mason | West Virginia | 54053 | 1648 | 31 |
985220 | 985220 | 2021-01-31 | Mason | West Virginia | 54053 | 1634 | 31 |
981973 | 981973 | 2021-01-30 | Mason | West Virginia | 54053 | 1586 | 31 |
978727 | 978727 | 2021-01-29 | Mason | West Virginia | 54053 | 1528 | 31 |
975482 | 975482 | 2021-01-28 | Mason | West Virginia | 54053 | 1519 | 31 |
972237 | 972237 | 2021-01-27 | Mason | West Virginia | 54053 | 1509 | 30 |
968992 | 968992 | 2021-01-26 | Mason | West Virginia | 54053 | 1499 | 28 |
965748 | 965748 | 2021-01-25 | Mason | West Virginia | 54053 | 1488 | 28 |
962503 | 962503 | 2021-01-24 | Mason | West Virginia | 54053 | 1478 | 28 |
959258 | 959258 | 2021-01-23 | Mason | West Virginia | 54053 | 1470 | 26 |
956012 | 956012 | 2021-01-22 | Mason | West Virginia | 54053 | 1452 | 26 |
952767 | 952767 | 2021-01-21 | Mason | West Virginia | 54053 | 1432 | 26 |
949522 | 949522 | 2021-01-20 | Mason | West Virginia | 54053 | 1405 | 26 |
946276 | 946276 | 2021-01-19 | Mason | West Virginia | 54053 | 1388 | 26 |
943029 | 943029 | 2021-01-18 | Mason | West Virginia | 54053 | 1366 | 26 |
939784 | 939784 | 2021-01-17 | Mason | West Virginia | 54053 | 1325 | 26 |
936539 | 936539 | 2021-01-16 | Mason | West Virginia | 54053 | 1316 | 26 |
933294 | 933294 | 2021-01-15 | Mason | West Virginia | 54053 | 1307 | 26 |
930049 | 930049 | 2021-01-14 | Mason | West Virginia | 54053 | 1265 | 26 |
926804 | 926804 | 2021-01-13 | Mason | West Virginia | 54053 | 1250 | 25 |
923558 | 923558 | 2021-01-12 | Mason | West Virginia | 54053 | 1232 | 24 |
920313 | 920313 | 2021-01-11 | Mason | West Virginia | 54053 | 1218 | 22 |
917068 | 917068 | 2021-01-10 | Mason | West Virginia | 54053 | 1203 | 22 |
913823 | 913823 | 2021-01-09 | Mason | West Virginia | 54053 | 1190 | 22 |
910578 | 910578 | 2021-01-08 | Mason | West Virginia | 54053 | 1164 | 21 |
907333 | 907333 | 2021-01-07 | Mason | West Virginia | 54053 | 1145 | 20 |
904087 | 904087 | 2021-01-06 | Mason | West Virginia | 54053 | 1120 | 17 |
900842 | 900842 | 2021-01-05 | Mason | West Virginia | 54053 | 1108 | 17 |
897597 | 897597 | 2021-01-04 | Mason | West Virginia | 54053 | 1091 | 17 |
894351 | 894351 | 2021-01-03 | Mason | West Virginia | 54053 | 1084 | 17 |
891105 | 891105 | 2021-01-02 | Mason | West Virginia | 54053 | 1071 | 17 |
887858 | 887858 | 2021-01-01 | Mason | West Virginia | 54053 | 1059 | 15 |
884613 | 884613 | 2020-12-31 | Mason | West Virginia | 54053 | 1031 | 15 |
881368 | 881368 | 2020-12-30 | Mason | West Virginia | 54053 | 1014 | 15 |
878123 | 878123 | 2020-12-29 | Mason | West Virginia | 54053 | 992 | 14 |
874878 | 874878 | 2020-12-28 | Mason | West Virginia | 54053 | 980 | 14 |
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);