ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 51059 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112095 | 2112095 | 2022-01-13 | Fairfax | Virginia | 51059 | 145736 | 1217 |
2108843 | 2108843 | 2022-01-12 | Fairfax | Virginia | 51059 | 143380 | 1215 |
2105592 | 2105592 | 2022-01-11 | Fairfax | Virginia | 51059 | 140700 | 1213 |
2102341 | 2102341 | 2022-01-10 | Fairfax | Virginia | 51059 | 138390 | 1210 |
2099090 | 2099090 | 2022-01-09 | Fairfax | Virginia | 51059 | 130735 | 1210 |
2095839 | 2095839 | 2022-01-08 | Fairfax | Virginia | 51059 | 130735 | 1210 |
2092587 | 2092587 | 2022-01-07 | Fairfax | Virginia | 51059 | 130735 | 1210 |
2089335 | 2089335 | 2022-01-06 | Fairfax | Virginia | 51059 | 128094 | 1210 |
2086084 | 2086084 | 2022-01-05 | Fairfax | Virginia | 51059 | 126161 | 1210 |
2082832 | 2082832 | 2022-01-04 | Fairfax | Virginia | 51059 | 124776 | 1210 |
2079580 | 2079580 | 2022-01-03 | Fairfax | Virginia | 51059 | 123216 | 1210 |
2076328 | 2076328 | 2022-01-02 | Fairfax | Virginia | 51059 | 116752 | 1210 |
2073077 | 2073077 | 2022-01-01 | Fairfax | Virginia | 51059 | 116752 | 1210 |
2069826 | 2069826 | 2021-12-31 | Fairfax | Virginia | 51059 | 116752 | 1210 |
2066575 | 2066575 | 2021-12-30 | Fairfax | Virginia | 51059 | 113641 | 1209 |
2063325 | 2063325 | 2021-12-29 | Fairfax | Virginia | 51059 | 111579 | 1208 |
2060075 | 2060075 | 2021-12-28 | Fairfax | Virginia | 51059 | 109754 | 1208 |
2056826 | 2056826 | 2021-12-27 | Fairfax | Virginia | 51059 | 108291 | 1194 |
2053577 | 2053577 | 2021-12-26 | Fairfax | Virginia | 51059 | 105063 | 1193 |
2050327 | 2050327 | 2021-12-25 | Fairfax | Virginia | 51059 | 105063 | 1193 |
2047077 | 2047077 | 2021-12-24 | Fairfax | Virginia | 51059 | 105063 | 1193 |
2043827 | 2043827 | 2021-12-23 | Fairfax | Virginia | 51059 | 103513 | 1192 |
2040578 | 2040578 | 2021-12-22 | Fairfax | Virginia | 51059 | 102304 | 1189 |
2037328 | 2037328 | 2021-12-21 | Fairfax | Virginia | 51059 | 101141 | 1189 |
2034078 | 2034078 | 2021-12-20 | Fairfax | Virginia | 51059 | 100422 | 1189 |
2030828 | 2030828 | 2021-12-19 | Fairfax | Virginia | 51059 | 98953 | 1187 |
2027577 | 2027577 | 2021-12-18 | Fairfax | Virginia | 51059 | 98953 | 1187 |
2024326 | 2024326 | 2021-12-17 | Fairfax | Virginia | 51059 | 98953 | 1187 |
2021075 | 2021075 | 2021-12-16 | Fairfax | Virginia | 51059 | 98517 | 1185 |
2017824 | 2017824 | 2021-12-15 | Fairfax | Virginia | 51059 | 98198 | 1184 |
2014574 | 2014574 | 2021-12-14 | Fairfax | Virginia | 51059 | 97873 | 1183 |
2011323 | 2011323 | 2021-12-13 | Fairfax | Virginia | 51059 | 97678 | 1179 |
2008072 | 2008072 | 2021-12-12 | Fairfax | Virginia | 51059 | 97108 | 1178 |
2004821 | 2004821 | 2021-12-11 | Fairfax | Virginia | 51059 | 97108 | 1178 |
2001570 | 2001570 | 2021-12-10 | Fairfax | Virginia | 51059 | 97108 | 1178 |
1998320 | 1998320 | 2021-12-09 | Fairfax | Virginia | 51059 | 96870 | 1178 |
1995069 | 1995069 | 2021-12-08 | Fairfax | Virginia | 51059 | 96647 | 1179 |
1991818 | 1991818 | 2021-12-07 | Fairfax | Virginia | 51059 | 96309 | 1178 |
1988567 | 1988567 | 2021-12-06 | Fairfax | Virginia | 51059 | 96161 | 1178 |
1985317 | 1985317 | 2021-12-05 | Fairfax | Virginia | 51059 | 95666 | 1178 |
1982067 | 1982067 | 2021-12-04 | Fairfax | Virginia | 51059 | 95666 | 1178 |
1978817 | 1978817 | 2021-12-03 | Fairfax | Virginia | 51059 | 95666 | 1178 |
1975567 | 1975567 | 2021-12-02 | Fairfax | Virginia | 51059 | 95470 | 1178 |
1972318 | 1972318 | 2021-12-01 | Fairfax | Virginia | 51059 | 95238 | 1178 |
1969068 | 1969068 | 2021-11-30 | Fairfax | Virginia | 51059 | 94982 | 1177 |
1965818 | 1965818 | 2021-11-29 | Fairfax | Virginia | 51059 | 94835 | 1177 |
1962566 | 1962566 | 2021-11-28 | Fairfax | Virginia | 51059 | 94555 | 1177 |
1959315 | 1959315 | 2021-11-27 | Fairfax | Virginia | 51059 | 94555 | 1177 |
1956064 | 1956064 | 2021-11-26 | Fairfax | Virginia | 51059 | 94555 | 1177 |
1952813 | 1952813 | 2021-11-25 | Fairfax | Virginia | 51059 | 94453 | 1176 |
1949562 | 1949562 | 2021-11-24 | Fairfax | Virginia | 51059 | 94292 | 1176 |
1946311 | 1946311 | 2021-11-23 | Fairfax | Virginia | 51059 | 94121 | 1176 |
1943060 | 1943060 | 2021-11-22 | Fairfax | Virginia | 51059 | 93998 | 1176 |
1939810 | 1939810 | 2021-11-21 | Fairfax | Virginia | 51059 | 93639 | 1176 |
1936560 | 1936560 | 2021-11-20 | Fairfax | Virginia | 51059 | 93639 | 1176 |
1933310 | 1933310 | 2021-11-19 | Fairfax | Virginia | 51059 | 93639 | 1176 |
1930058 | 1930058 | 2021-11-18 | Fairfax | Virginia | 51059 | 93462 | 1175 |
1926808 | 1926808 | 2021-11-17 | Fairfax | Virginia | 51059 | 93355 | 1173 |
1923558 | 1923558 | 2021-11-16 | Fairfax | Virginia | 51059 | 93142 | 1172 |
1920309 | 1920309 | 2021-11-15 | Fairfax | Virginia | 51059 | 93134 | 1171 |
1917059 | 1917059 | 2021-11-14 | Fairfax | Virginia | 51059 | 92907 | 1168 |
1913809 | 1913809 | 2021-11-13 | Fairfax | Virginia | 51059 | 92907 | 1168 |
1910559 | 1910559 | 2021-11-12 | Fairfax | Virginia | 51059 | 92907 | 1168 |
1907310 | 1907310 | 2021-11-11 | Fairfax | Virginia | 51059 | 92793 | 1166 |
1904061 | 1904061 | 2021-11-10 | Fairfax | Virginia | 51059 | 92723 | 1171 |
1900811 | 1900811 | 2021-11-09 | Fairfax | Virginia | 51059 | 92658 | 1172 |
1897561 | 1897561 | 2021-11-08 | Fairfax | Virginia | 51059 | 92594 | 1172 |
1894311 | 1894311 | 2021-11-07 | Fairfax | Virginia | 51059 | 92427 | 1177 |
1891061 | 1891061 | 2021-11-06 | Fairfax | Virginia | 51059 | 92427 | 1177 |
1887811 | 1887811 | 2021-11-05 | Fairfax | Virginia | 51059 | 92427 | 1177 |
1884561 | 1884561 | 2021-11-04 | Fairfax | Virginia | 51059 | 92377 | 1178 |
1881312 | 1881312 | 2021-11-03 | Fairfax | Virginia | 51059 | 92312 | 1177 |
1878063 | 1878063 | 2021-11-02 | Fairfax | Virginia | 51059 | 92182 | 1177 |
1874814 | 1874814 | 2021-11-01 | Fairfax | Virginia | 51059 | 92128 | 1180 |
1871565 | 1871565 | 2021-10-31 | Fairfax | Virginia | 51059 | 91963 | 1183 |
1868316 | 1868316 | 2021-10-30 | Fairfax | Virginia | 51059 | 91963 | 1183 |
1865067 | 1865067 | 2021-10-29 | Fairfax | Virginia | 51059 | 91963 | 1183 |
1861818 | 1861818 | 2021-10-28 | Fairfax | Virginia | 51059 | 91844 | 1183 |
1858569 | 1858569 | 2021-10-27 | Fairfax | Virginia | 51059 | 91747 | 1182 |
1855320 | 1855320 | 2021-10-26 | Fairfax | Virginia | 51059 | 91628 | 1181 |
1852071 | 1852071 | 2021-10-25 | Fairfax | Virginia | 51059 | 91545 | 1181 |
1848821 | 1848821 | 2021-10-24 | Fairfax | Virginia | 51059 | 91314 | 1178 |
1845571 | 1845571 | 2021-10-23 | Fairfax | Virginia | 51059 | 91314 | 1178 |
1842321 | 1842321 | 2021-10-22 | Fairfax | Virginia | 51059 | 91314 | 1178 |
1839072 | 1839072 | 2021-10-21 | Fairfax | Virginia | 51059 | 91190 | 1177 |
1835823 | 1835823 | 2021-10-20 | Fairfax | Virginia | 51059 | 91057 | 1177 |
1832574 | 1832574 | 2021-10-19 | Fairfax | Virginia | 51059 | 90936 | 1176 |
1829325 | 1829325 | 2021-10-18 | Fairfax | Virginia | 51059 | 90793 | 1173 |
1826076 | 1826076 | 2021-10-17 | Fairfax | Virginia | 51059 | 90382 | 1170 |
1822827 | 1822827 | 2021-10-16 | Fairfax | Virginia | 51059 | 90382 | 1170 |
1819578 | 1819578 | 2021-10-15 | Fairfax | Virginia | 51059 | 90382 | 1170 |
1816329 | 1816329 | 2021-10-14 | Fairfax | Virginia | 51059 | 90234 | 1166 |
1813081 | 1813081 | 2021-10-13 | Fairfax | Virginia | 51059 | 90083 | 1165 |
1809832 | 1809832 | 2021-10-12 | Fairfax | Virginia | 51059 | 89944 | 1165 |
1806582 | 1806582 | 2021-10-11 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1803332 | 1803332 | 2021-10-10 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1800083 | 1800083 | 2021-10-09 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1796834 | 1796834 | 2021-10-08 | Fairfax | Virginia | 51059 | 89473 | 1158 |
1793585 | 1793585 | 2021-10-07 | Fairfax | Virginia | 51059 | 89287 | 1158 |
1790336 | 1790336 | 2021-10-06 | Fairfax | Virginia | 51059 | 89102 | 1155 |
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);