ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51147 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280567 | 1280567 | 2021-05-02 | Prince Edward | Virginia | 51147 | 2125 | 34 |
1277320 | 1277320 | 2021-05-01 | Prince Edward | Virginia | 51147 | 2123 | 34 |
1274073 | 1274073 | 2021-04-30 | Prince Edward | Virginia | 51147 | 2119 | 34 |
1270826 | 1270826 | 2021-04-29 | Prince Edward | Virginia | 51147 | 2114 | 34 |
1267579 | 1267579 | 2021-04-28 | Prince Edward | Virginia | 51147 | 2111 | 34 |
1264332 | 1264332 | 2021-04-27 | Prince Edward | Virginia | 51147 | 2110 | 34 |
1261085 | 1261085 | 2021-04-26 | Prince Edward | Virginia | 51147 | 2107 | 34 |
1257838 | 1257838 | 2021-04-25 | Prince Edward | Virginia | 51147 | 2106 | 34 |
1254591 | 1254591 | 2021-04-24 | Prince Edward | Virginia | 51147 | 2103 | 34 |
1251344 | 1251344 | 2021-04-23 | Prince Edward | Virginia | 51147 | 2102 | 34 |
1248097 | 1248097 | 2021-04-22 | Prince Edward | Virginia | 51147 | 2098 | 34 |
1244850 | 1244850 | 2021-04-21 | Prince Edward | Virginia | 51147 | 2091 | 34 |
1241603 | 1241603 | 2021-04-20 | Prince Edward | Virginia | 51147 | 2087 | 33 |
1238356 | 1238356 | 2021-04-19 | Prince Edward | Virginia | 51147 | 2085 | 33 |
1235109 | 1235109 | 2021-04-18 | Prince Edward | Virginia | 51147 | 2081 | 33 |
1231861 | 1231861 | 2021-04-17 | Prince Edward | Virginia | 51147 | 2077 | 33 |
1228613 | 1228613 | 2021-04-16 | Prince Edward | Virginia | 51147 | 2074 | 33 |
1225365 | 1225365 | 2021-04-15 | Prince Edward | Virginia | 51147 | 2072 | 33 |
1222118 | 1222118 | 2021-04-14 | Prince Edward | Virginia | 51147 | 2066 | 33 |
1218870 | 1218870 | 2021-04-13 | Prince Edward | Virginia | 51147 | 2055 | 33 |
1215622 | 1215622 | 2021-04-12 | Prince Edward | Virginia | 51147 | 2047 | 33 |
1212375 | 1212375 | 2021-04-11 | Prince Edward | Virginia | 51147 | 2044 | 33 |
1209126 | 1209126 | 2021-04-10 | Prince Edward | Virginia | 51147 | 2039 | 33 |
1205878 | 1205878 | 2021-04-09 | Prince Edward | Virginia | 51147 | 2036 | 33 |
1202630 | 1202630 | 2021-04-08 | Prince Edward | Virginia | 51147 | 2032 | 32 |
1199382 | 1199382 | 2021-04-07 | Prince Edward | Virginia | 51147 | 2025 | 32 |
1196133 | 1196133 | 2021-04-06 | Prince Edward | Virginia | 51147 | 2025 | 32 |
1192885 | 1192885 | 2021-04-05 | Prince Edward | Virginia | 51147 | 2022 | 32 |
1189635 | 1189635 | 2021-04-04 | Prince Edward | Virginia | 51147 | 2020 | 32 |
1186388 | 1186388 | 2021-04-03 | Prince Edward | Virginia | 51147 | 2017 | 32 |
1183141 | 1183141 | 2021-04-02 | Prince Edward | Virginia | 51147 | 2016 | 32 |
1179894 | 1179894 | 2021-04-01 | Prince Edward | Virginia | 51147 | 2009 | 32 |
1176647 | 1176647 | 2021-03-31 | Prince Edward | Virginia | 51147 | 2006 | 32 |
1173400 | 1173400 | 2021-03-30 | Prince Edward | Virginia | 51147 | 2004 | 32 |
1170153 | 1170153 | 2021-03-29 | Prince Edward | Virginia | 51147 | 2004 | 32 |
1166905 | 1166905 | 2021-03-28 | Prince Edward | Virginia | 51147 | 2003 | 31 |
1163657 | 1163657 | 2021-03-27 | Prince Edward | Virginia | 51147 | 2003 | 31 |
1160409 | 1160409 | 2021-03-26 | Prince Edward | Virginia | 51147 | 2002 | 31 |
1157161 | 1157161 | 2021-03-25 | Prince Edward | Virginia | 51147 | 2000 | 31 |
1153914 | 1153914 | 2021-03-24 | Prince Edward | Virginia | 51147 | 2001 | 31 |
1150667 | 1150667 | 2021-03-23 | Prince Edward | Virginia | 51147 | 1998 | 31 |
1147420 | 1147420 | 2021-03-22 | Prince Edward | Virginia | 51147 | 1997 | 31 |
1144173 | 1144173 | 2021-03-21 | Prince Edward | Virginia | 51147 | 1997 | 31 |
1140926 | 1140926 | 2021-03-20 | Prince Edward | Virginia | 51147 | 1996 | 31 |
1137680 | 1137680 | 2021-03-19 | Prince Edward | Virginia | 51147 | 1993 | 31 |
1134434 | 1134434 | 2021-03-18 | Prince Edward | Virginia | 51147 | 1992 | 33 |
1131186 | 1131186 | 2021-03-17 | Prince Edward | Virginia | 51147 | 1992 | 33 |
1127939 | 1127939 | 2021-03-16 | Prince Edward | Virginia | 51147 | 1988 | 33 |
1124693 | 1124693 | 2021-03-15 | Prince Edward | Virginia | 51147 | 1987 | 33 |
1121447 | 1121447 | 2021-03-14 | Prince Edward | Virginia | 51147 | 1986 | 33 |
1118200 | 1118200 | 2021-03-13 | Prince Edward | Virginia | 51147 | 1984 | 33 |
1114953 | 1114953 | 2021-03-12 | Prince Edward | Virginia | 51147 | 1984 | 33 |
1111707 | 1111707 | 2021-03-11 | Prince Edward | Virginia | 51147 | 1981 | 31 |
1108461 | 1108461 | 2021-03-10 | Prince Edward | Virginia | 51147 | 1979 | 31 |
1105215 | 1105215 | 2021-03-09 | Prince Edward | Virginia | 51147 | 1979 | 31 |
1101969 | 1101969 | 2021-03-08 | Prince Edward | Virginia | 51147 | 1975 | 30 |
1098723 | 1098723 | 2021-03-07 | Prince Edward | Virginia | 51147 | 1974 | 29 |
1095475 | 1095475 | 2021-03-06 | Prince Edward | Virginia | 51147 | 1972 | 29 |
1092229 | 1092229 | 2021-03-05 | Prince Edward | Virginia | 51147 | 1971 | 29 |
1088983 | 1088983 | 2021-03-04 | Prince Edward | Virginia | 51147 | 1964 | 28 |
1085738 | 1085738 | 2021-03-03 | Prince Edward | Virginia | 51147 | 1962 | 28 |
1082492 | 1082492 | 2021-03-02 | Prince Edward | Virginia | 51147 | 1960 | 27 |
1079246 | 1079246 | 2021-03-01 | Prince Edward | Virginia | 51147 | 1960 | 27 |
1076001 | 1076001 | 2021-02-28 | Prince Edward | Virginia | 51147 | 1953 | 26 |
1072755 | 1072755 | 2021-02-27 | Prince Edward | Virginia | 51147 | 1950 | 26 |
1069509 | 1069509 | 2021-02-26 | Prince Edward | Virginia | 51147 | 1944 | 25 |
1066264 | 1066264 | 2021-02-25 | Prince Edward | Virginia | 51147 | 1941 | 24 |
1063019 | 1063019 | 2021-02-24 | Prince Edward | Virginia | 51147 | 1929 | 23 |
1059774 | 1059774 | 2021-02-23 | Prince Edward | Virginia | 51147 | 1925 | 23 |
1056528 | 1056528 | 2021-02-22 | Prince Edward | Virginia | 51147 | 1922 | 22 |
1053282 | 1053282 | 2021-02-21 | Prince Edward | Virginia | 51147 | 1923 | 21 |
1050035 | 1050035 | 2021-02-20 | Prince Edward | Virginia | 51147 | 1918 | 21 |
1046788 | 1046788 | 2021-02-19 | Prince Edward | Virginia | 51147 | 1911 | 21 |
1043543 | 1043543 | 2021-02-18 | Prince Edward | Virginia | 51147 | 1907 | 21 |
1040298 | 1040298 | 2021-02-17 | Prince Edward | Virginia | 51147 | 1899 | 21 |
1037053 | 1037053 | 2021-02-16 | Prince Edward | Virginia | 51147 | 1901 | 21 |
1033808 | 1033808 | 2021-02-15 | Prince Edward | Virginia | 51147 | 1906 | 20 |
1030562 | 1030562 | 2021-02-14 | Prince Edward | Virginia | 51147 | 1907 | 20 |
1027315 | 1027315 | 2021-02-13 | Prince Edward | Virginia | 51147 | 1906 | 20 |
1024070 | 1024070 | 2021-02-12 | Prince Edward | Virginia | 51147 | 1892 | 20 |
1020825 | 1020825 | 2021-02-11 | Prince Edward | Virginia | 51147 | 1880 | 20 |
1017580 | 1017580 | 2021-02-10 | Prince Edward | Virginia | 51147 | 1861 | 20 |
1014335 | 1014335 | 2021-02-09 | Prince Edward | Virginia | 51147 | 1846 | 20 |
1011090 | 1011090 | 2021-02-08 | Prince Edward | Virginia | 51147 | 1840 | 20 |
1007844 | 1007844 | 2021-02-07 | Prince Edward | Virginia | 51147 | 1838 | 20 |
1004598 | 1004598 | 2021-02-06 | Prince Edward | Virginia | 51147 | 1818 | 20 |
1001352 | 1001352 | 2021-02-05 | Prince Edward | Virginia | 51147 | 1801 | 20 |
998106 | 998106 | 2021-02-04 | Prince Edward | Virginia | 51147 | 1767 | 20 |
994860 | 994860 | 2021-02-03 | Prince Edward | Virginia | 51147 | 1744 | 20 |
991614 | 991614 | 2021-02-02 | Prince Edward | Virginia | 51147 | 1741 | 20 |
988368 | 988368 | 2021-02-01 | Prince Edward | Virginia | 51147 | 1734 | 20 |
985121 | 985121 | 2021-01-31 | Prince Edward | Virginia | 51147 | 1709 | 20 |
981874 | 981874 | 2021-01-30 | Prince Edward | Virginia | 51147 | 1689 | 20 |
978628 | 978628 | 2021-01-29 | Prince Edward | Virginia | 51147 | 1663 | 20 |
975383 | 975383 | 2021-01-28 | Prince Edward | Virginia | 51147 | 1635 | 20 |
972138 | 972138 | 2021-01-27 | Prince Edward | Virginia | 51147 | 1611 | 19 |
968893 | 968893 | 2021-01-26 | Prince Edward | Virginia | 51147 | 1576 | 19 |
965649 | 965649 | 2021-01-25 | Prince Edward | Virginia | 51147 | 1562 | 19 |
962404 | 962404 | 2021-01-24 | Prince Edward | Virginia | 51147 | 1537 | 19 |
959159 | 959159 | 2021-01-23 | Prince Edward | Virginia | 51147 | 1524 | 19 |
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);