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 |
---|---|---|---|---|---|---|---|
2177162 | 2177162 | 2022-02-02 | Fairfax | Virginia | 51059 | 166999 | 1242 |
2173909 | 2173909 | 2022-02-01 | Fairfax | Virginia | 51059 | 166375 | 1234 |
2170657 | 2170657 | 2022-01-31 | Fairfax | Virginia | 51059 | 165927 | 1230 |
2167404 | 2167404 | 2022-01-30 | Fairfax | Virginia | 51059 | 164197 | 1227 |
2164149 | 2164149 | 2022-01-29 | Fairfax | Virginia | 51059 | 164197 | 1227 |
2160894 | 2160894 | 2022-01-28 | Fairfax | Virginia | 51059 | 164197 | 1227 |
2157638 | 2157638 | 2022-01-27 | Fairfax | Virginia | 51059 | 163438 | 1227 |
2154385 | 2154385 | 2022-01-26 | Fairfax | Virginia | 51059 | 162661 | 1223 |
2151132 | 2151132 | 2022-01-25 | Fairfax | Virginia | 51059 | 161772 | 1223 |
2147880 | 2147880 | 2022-01-24 | Fairfax | Virginia | 51059 | 160656 | 1222 |
2144627 | 2144627 | 2022-01-23 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2141372 | 2141372 | 2022-01-22 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2138116 | 2138116 | 2022-01-21 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2134862 | 2134862 | 2022-01-20 | Fairfax | Virginia | 51059 | 156641 | 1218 |
2131610 | 2131610 | 2022-01-19 | Fairfax | Virginia | 51059 | 155488 | 1217 |
2128356 | 2128356 | 2022-01-18 | Fairfax | Virginia | 51059 | 154136 | 1217 |
2125103 | 2125103 | 2022-01-17 | Fairfax | Virginia | 51059 | 152606 | 1217 |
2121851 | 2121851 | 2022-01-16 | Fairfax | Virginia | 51059 | 147621 | 1217 |
2118599 | 2118599 | 2022-01-15 | Fairfax | Virginia | 51059 | 147621 | 1217 |
2115347 | 2115347 | 2022-01-14 | Fairfax | Virginia | 51059 | 147621 | 1217 |
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 |
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);