ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 51139 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420144 | 1420144 | 2021-06-14 | Page | Virginia | 51139 | 2119 | 58 |
1416899 | 1416899 | 2021-06-13 | Page | Virginia | 51139 | 2119 | 58 |
1413653 | 1413653 | 2021-06-12 | Page | Virginia | 51139 | 2119 | 58 |
1410408 | 1410408 | 2021-06-11 | Page | Virginia | 51139 | 2114 | 57 |
1407163 | 1407163 | 2021-06-10 | Page | Virginia | 51139 | 2115 | 57 |
1403917 | 1403917 | 2021-06-09 | Page | Virginia | 51139 | 2114 | 57 |
1400672 | 1400672 | 2021-06-08 | Page | Virginia | 51139 | 2113 | 57 |
1397427 | 1397427 | 2021-06-07 | Page | Virginia | 51139 | 2113 | 57 |
1394180 | 1394180 | 2021-06-06 | Page | Virginia | 51139 | 2111 | 57 |
1390935 | 1390935 | 2021-06-05 | Page | Virginia | 51139 | 2109 | 57 |
1387690 | 1387690 | 2021-06-04 | Page | Virginia | 51139 | 2106 | 57 |
1384445 | 1384445 | 2021-06-03 | Page | Virginia | 51139 | 2107 | 57 |
1381199 | 1381199 | 2021-06-02 | Page | Virginia | 51139 | 2103 | 57 |
1377954 | 1377954 | 2021-06-01 | Page | Virginia | 51139 | 2092 | 57 |
1374708 | 1374708 | 2021-05-31 | Page | Virginia | 51139 | 2073 | 56 |
1371463 | 1371463 | 2021-05-30 | Page | Virginia | 51139 | 2073 | 56 |
1368217 | 1368217 | 2021-05-29 | Page | Virginia | 51139 | 2073 | 56 |
1364971 | 1364971 | 2021-05-28 | Page | Virginia | 51139 | 2069 | 56 |
1361725 | 1361725 | 2021-05-27 | Page | Virginia | 51139 | 2067 | 56 |
1358479 | 1358479 | 2021-05-26 | Page | Virginia | 51139 | 2064 | 56 |
1355233 | 1355233 | 2021-05-25 | Page | Virginia | 51139 | 2060 | 56 |
1351987 | 1351987 | 2021-05-24 | Page | Virginia | 51139 | 2058 | 56 |
1348741 | 1348741 | 2021-05-23 | Page | Virginia | 51139 | 2057 | 56 |
1345493 | 1345493 | 2021-05-22 | Page | Virginia | 51139 | 2055 | 56 |
1342245 | 1342245 | 2021-05-21 | Page | Virginia | 51139 | 2055 | 56 |
1338997 | 1338997 | 2021-05-20 | Page | Virginia | 51139 | 2052 | 56 |
1335750 | 1335750 | 2021-05-19 | Page | Virginia | 51139 | 2045 | 56 |
1332503 | 1332503 | 2021-05-18 | Page | Virginia | 51139 | 2043 | 56 |
1329256 | 1329256 | 2021-05-17 | Page | Virginia | 51139 | 2042 | 56 |
1326010 | 1326010 | 2021-05-16 | Page | Virginia | 51139 | 2040 | 56 |
1322764 | 1322764 | 2021-05-15 | Page | Virginia | 51139 | 2040 | 56 |
1319518 | 1319518 | 2021-05-14 | Page | Virginia | 51139 | 2035 | 56 |
1316270 | 1316270 | 2021-05-13 | Page | Virginia | 51139 | 2034 | 56 |
1313024 | 1313024 | 2021-05-12 | Page | Virginia | 51139 | 2033 | 56 |
1309777 | 1309777 | 2021-05-11 | Page | Virginia | 51139 | 2035 | 57 |
1306531 | 1306531 | 2021-05-10 | Page | Virginia | 51139 | 2033 | 57 |
1303285 | 1303285 | 2021-05-09 | Page | Virginia | 51139 | 2031 | 57 |
1300038 | 1300038 | 2021-05-08 | Page | Virginia | 51139 | 2028 | 57 |
1296791 | 1296791 | 2021-05-07 | Page | Virginia | 51139 | 2027 | 57 |
1293545 | 1293545 | 2021-05-06 | Page | Virginia | 51139 | 2026 | 57 |
1290299 | 1290299 | 2021-05-05 | Page | Virginia | 51139 | 2020 | 57 |
1287053 | 1287053 | 2021-05-04 | Page | Virginia | 51139 | 2015 | 57 |
1283807 | 1283807 | 2021-05-03 | Page | Virginia | 51139 | 2015 | 57 |
1280560 | 1280560 | 2021-05-02 | Page | Virginia | 51139 | 2011 | 57 |
1277313 | 1277313 | 2021-05-01 | Page | Virginia | 51139 | 2010 | 57 |
1274066 | 1274066 | 2021-04-30 | Page | Virginia | 51139 | 2005 | 57 |
1270819 | 1270819 | 2021-04-29 | Page | Virginia | 51139 | 2000 | 57 |
1267572 | 1267572 | 2021-04-28 | Page | Virginia | 51139 | 1998 | 57 |
1264325 | 1264325 | 2021-04-27 | Page | Virginia | 51139 | 1995 | 57 |
1261078 | 1261078 | 2021-04-26 | Page | Virginia | 51139 | 1993 | 57 |
1257831 | 1257831 | 2021-04-25 | Page | Virginia | 51139 | 1991 | 57 |
1254584 | 1254584 | 2021-04-24 | Page | Virginia | 51139 | 1987 | 57 |
1251337 | 1251337 | 2021-04-23 | Page | Virginia | 51139 | 1979 | 57 |
1248090 | 1248090 | 2021-04-22 | Page | Virginia | 51139 | 1974 | 57 |
1244843 | 1244843 | 2021-04-21 | Page | Virginia | 51139 | 1967 | 57 |
1241596 | 1241596 | 2021-04-20 | Page | Virginia | 51139 | 1963 | 57 |
1238349 | 1238349 | 2021-04-19 | Page | Virginia | 51139 | 1960 | 57 |
1235102 | 1235102 | 2021-04-18 | Page | Virginia | 51139 | 1956 | 57 |
1231854 | 1231854 | 2021-04-17 | Page | Virginia | 51139 | 1952 | 57 |
1228606 | 1228606 | 2021-04-16 | Page | Virginia | 51139 | 1950 | 57 |
1225358 | 1225358 | 2021-04-15 | Page | Virginia | 51139 | 1946 | 57 |
1222111 | 1222111 | 2021-04-14 | Page | Virginia | 51139 | 1941 | 57 |
1218863 | 1218863 | 2021-04-13 | Page | Virginia | 51139 | 1938 | 57 |
1215615 | 1215615 | 2021-04-12 | Page | Virginia | 51139 | 1931 | 57 |
1212368 | 1212368 | 2021-04-11 | Page | Virginia | 51139 | 1931 | 57 |
1209119 | 1209119 | 2021-04-10 | Page | Virginia | 51139 | 1927 | 57 |
1205871 | 1205871 | 2021-04-09 | Page | Virginia | 51139 | 1923 | 57 |
1202623 | 1202623 | 2021-04-08 | Page | Virginia | 51139 | 1923 | 57 |
1199375 | 1199375 | 2021-04-07 | Page | Virginia | 51139 | 1921 | 57 |
1196126 | 1196126 | 2021-04-06 | Page | Virginia | 51139 | 1917 | 57 |
1192878 | 1192878 | 2021-04-05 | Page | Virginia | 51139 | 1917 | 57 |
1189628 | 1189628 | 2021-04-04 | Page | Virginia | 51139 | 1917 | 57 |
1186381 | 1186381 | 2021-04-03 | Page | Virginia | 51139 | 1917 | 57 |
1183134 | 1183134 | 2021-04-02 | Page | Virginia | 51139 | 1908 | 57 |
1179887 | 1179887 | 2021-04-01 | Page | Virginia | 51139 | 1906 | 57 |
1176640 | 1176640 | 2021-03-31 | Page | Virginia | 51139 | 1907 | 57 |
1173393 | 1173393 | 2021-03-30 | Page | Virginia | 51139 | 1907 | 57 |
1170146 | 1170146 | 2021-03-29 | Page | Virginia | 51139 | 1905 | 57 |
1166898 | 1166898 | 2021-03-28 | Page | Virginia | 51139 | 1905 | 57 |
1163650 | 1163650 | 2021-03-27 | Page | Virginia | 51139 | 1904 | 57 |
1160402 | 1160402 | 2021-03-26 | Page | Virginia | 51139 | 1897 | 57 |
1157154 | 1157154 | 2021-03-25 | Page | Virginia | 51139 | 1890 | 57 |
1153907 | 1153907 | 2021-03-24 | Page | Virginia | 51139 | 1883 | 57 |
1150660 | 1150660 | 2021-03-23 | Page | Virginia | 51139 | 1882 | 57 |
1147413 | 1147413 | 2021-03-22 | Page | Virginia | 51139 | 1881 | 57 |
1144166 | 1144166 | 2021-03-21 | Page | Virginia | 51139 | 1881 | 57 |
1140919 | 1140919 | 2021-03-20 | Page | Virginia | 51139 | 1879 | 57 |
1137673 | 1137673 | 2021-03-19 | Page | Virginia | 51139 | 1876 | 57 |
1134427 | 1134427 | 2021-03-18 | Page | Virginia | 51139 | 1869 | 57 |
1131179 | 1131179 | 2021-03-17 | Page | Virginia | 51139 | 1866 | 57 |
1127932 | 1127932 | 2021-03-16 | Page | Virginia | 51139 | 1864 | 56 |
1124686 | 1124686 | 2021-03-15 | Page | Virginia | 51139 | 1861 | 56 |
1121440 | 1121440 | 2021-03-14 | Page | Virginia | 51139 | 1860 | 56 |
1118193 | 1118193 | 2021-03-13 | Page | Virginia | 51139 | 1856 | 55 |
1114946 | 1114946 | 2021-03-12 | Page | Virginia | 51139 | 1853 | 55 |
1111700 | 1111700 | 2021-03-11 | Page | Virginia | 51139 | 1848 | 55 |
1108454 | 1108454 | 2021-03-10 | Page | Virginia | 51139 | 1847 | 53 |
1105208 | 1105208 | 2021-03-09 | Page | Virginia | 51139 | 1848 | 53 |
1101962 | 1101962 | 2021-03-08 | Page | Virginia | 51139 | 1845 | 53 |
1098716 | 1098716 | 2021-03-07 | Page | Virginia | 51139 | 1842 | 53 |
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);