ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Loudoun" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112128 | 2112128 | 2022-01-13 | Loudoun | Virginia | 51107 | 55231 | 315 |
2108876 | 2108876 | 2022-01-12 | Loudoun | Virginia | 51107 | 54613 | 315 |
2105625 | 2105625 | 2022-01-11 | Loudoun | Virginia | 51107 | 53685 | 315 |
2102374 | 2102374 | 2022-01-10 | Loudoun | Virginia | 51107 | 52772 | 314 |
2099123 | 2099123 | 2022-01-09 | Loudoun | Virginia | 51107 | 50276 | 314 |
2095872 | 2095872 | 2022-01-08 | Loudoun | Virginia | 51107 | 50276 | 314 |
2092620 | 2092620 | 2022-01-07 | Loudoun | Virginia | 51107 | 50276 | 314 |
2089368 | 2089368 | 2022-01-06 | Loudoun | Virginia | 51107 | 49295 | 314 |
2086117 | 2086117 | 2022-01-05 | Loudoun | Virginia | 51107 | 48419 | 314 |
2082865 | 2082865 | 2022-01-04 | Loudoun | Virginia | 51107 | 47513 | 314 |
2079613 | 2079613 | 2022-01-03 | Loudoun | Virginia | 51107 | 46772 | 314 |
2076361 | 2076361 | 2022-01-02 | Loudoun | Virginia | 51107 | 44607 | 314 |
2073110 | 2073110 | 2022-01-01 | Loudoun | Virginia | 51107 | 44607 | 314 |
2069859 | 2069859 | 2021-12-31 | Loudoun | Virginia | 51107 | 44607 | 314 |
2066608 | 2066608 | 2021-12-30 | Loudoun | Virginia | 51107 | 43392 | 314 |
2063358 | 2063358 | 2021-12-29 | Loudoun | Virginia | 51107 | 42751 | 312 |
2060108 | 2060108 | 2021-12-28 | Loudoun | Virginia | 51107 | 42080 | 312 |
2056859 | 2056859 | 2021-12-27 | Loudoun | Virginia | 51107 | 41565 | 309 |
2053610 | 2053610 | 2021-12-26 | Loudoun | Virginia | 51107 | 40503 | 309 |
2050360 | 2050360 | 2021-12-25 | Loudoun | Virginia | 51107 | 40503 | 309 |
2047110 | 2047110 | 2021-12-24 | Loudoun | Virginia | 51107 | 40503 | 309 |
2043860 | 2043860 | 2021-12-23 | Loudoun | Virginia | 51107 | 39898 | 307 |
2040611 | 2040611 | 2021-12-22 | Loudoun | Virginia | 51107 | 39481 | 307 |
2037361 | 2037361 | 2021-12-21 | Loudoun | Virginia | 51107 | 39045 | 307 |
2034111 | 2034111 | 2021-12-20 | Loudoun | Virginia | 51107 | 38699 | 308 |
2030861 | 2030861 | 2021-12-19 | Loudoun | Virginia | 51107 | 38086 | 308 |
2027610 | 2027610 | 2021-12-18 | Loudoun | Virginia | 51107 | 38086 | 308 |
2024359 | 2024359 | 2021-12-17 | Loudoun | Virginia | 51107 | 38086 | 308 |
2021108 | 2021108 | 2021-12-16 | Loudoun | Virginia | 51107 | 37893 | 306 |
2017857 | 2017857 | 2021-12-15 | Loudoun | Virginia | 51107 | 37708 | 307 |
2014607 | 2014607 | 2021-12-14 | Loudoun | Virginia | 51107 | 37530 | 305 |
2011356 | 2011356 | 2021-12-13 | Loudoun | Virginia | 51107 | 37384 | 305 |
2008105 | 2008105 | 2021-12-12 | Loudoun | Virginia | 51107 | 37054 | 304 |
2004854 | 2004854 | 2021-12-11 | Loudoun | Virginia | 51107 | 37054 | 304 |
2001603 | 2001603 | 2021-12-10 | Loudoun | Virginia | 51107 | 37054 | 304 |
1998353 | 1998353 | 2021-12-09 | Loudoun | Virginia | 51107 | 36928 | 304 |
1995102 | 1995102 | 2021-12-08 | Loudoun | Virginia | 51107 | 36816 | 304 |
1991851 | 1991851 | 2021-12-07 | Loudoun | Virginia | 51107 | 36677 | 304 |
1988600 | 1988600 | 2021-12-06 | Loudoun | Virginia | 51107 | 36571 | 304 |
1985350 | 1985350 | 2021-12-05 | Loudoun | Virginia | 51107 | 36292 | 304 |
1982100 | 1982100 | 2021-12-04 | Loudoun | Virginia | 51107 | 36292 | 304 |
1978850 | 1978850 | 2021-12-03 | Loudoun | Virginia | 51107 | 36292 | 304 |
1975600 | 1975600 | 2021-12-02 | Loudoun | Virginia | 51107 | 36186 | 304 |
1972351 | 1972351 | 2021-12-01 | Loudoun | Virginia | 51107 | 36064 | 304 |
1969101 | 1969101 | 2021-11-30 | Loudoun | Virginia | 51107 | 35934 | 303 |
1965851 | 1965851 | 2021-11-29 | Loudoun | Virginia | 51107 | 35847 | 303 |
1962599 | 1962599 | 2021-11-28 | Loudoun | Virginia | 51107 | 35699 | 303 |
1959348 | 1959348 | 2021-11-27 | Loudoun | Virginia | 51107 | 35699 | 303 |
1956097 | 1956097 | 2021-11-26 | Loudoun | Virginia | 51107 | 35699 | 303 |
1952846 | 1952846 | 2021-11-25 | Loudoun | Virginia | 51107 | 35641 | 303 |
1949595 | 1949595 | 2021-11-24 | Loudoun | Virginia | 51107 | 35585 | 303 |
1946344 | 1946344 | 2021-11-23 | Loudoun | Virginia | 51107 | 35514 | 303 |
1943093 | 1943093 | 2021-11-22 | Loudoun | Virginia | 51107 | 35455 | 303 |
1939843 | 1939843 | 2021-11-21 | Loudoun | Virginia | 51107 | 35260 | 303 |
1936593 | 1936593 | 2021-11-20 | Loudoun | Virginia | 51107 | 35260 | 303 |
1933343 | 1933343 | 2021-11-19 | Loudoun | Virginia | 51107 | 35260 | 303 |
1930091 | 1930091 | 2021-11-18 | Loudoun | Virginia | 51107 | 35191 | 303 |
1926841 | 1926841 | 2021-11-17 | Loudoun | Virginia | 51107 | 35094 | 302 |
1923591 | 1923591 | 2021-11-16 | Loudoun | Virginia | 51107 | 34980 | 302 |
1920342 | 1920342 | 2021-11-15 | Loudoun | Virginia | 51107 | 34928 | 302 |
1917092 | 1917092 | 2021-11-14 | Loudoun | Virginia | 51107 | 34782 | 301 |
1913842 | 1913842 | 2021-11-13 | Loudoun | Virginia | 51107 | 34782 | 301 |
1910592 | 1910592 | 2021-11-12 | Loudoun | Virginia | 51107 | 34782 | 301 |
1907343 | 1907343 | 2021-11-11 | Loudoun | Virginia | 51107 | 34732 | 301 |
1904094 | 1904094 | 2021-11-10 | Loudoun | Virginia | 51107 | 34655 | 301 |
1900844 | 1900844 | 2021-11-09 | Loudoun | Virginia | 51107 | 34594 | 301 |
1897594 | 1897594 | 2021-11-08 | Loudoun | Virginia | 51107 | 34544 | 301 |
1894344 | 1894344 | 2021-11-07 | Loudoun | Virginia | 51107 | 34455 | 300 |
1891094 | 1891094 | 2021-11-06 | Loudoun | Virginia | 51107 | 34455 | 300 |
1887844 | 1887844 | 2021-11-05 | Loudoun | Virginia | 51107 | 34455 | 300 |
1884594 | 1884594 | 2021-11-04 | Loudoun | Virginia | 51107 | 34408 | 300 |
1881345 | 1881345 | 2021-11-03 | Loudoun | Virginia | 51107 | 34355 | 300 |
1878096 | 1878096 | 2021-11-02 | Loudoun | Virginia | 51107 | 34300 | 300 |
1874847 | 1874847 | 2021-11-01 | Loudoun | Virginia | 51107 | 34266 | 300 |
1871598 | 1871598 | 2021-10-31 | Loudoun | Virginia | 51107 | 34176 | 300 |
1868349 | 1868349 | 2021-10-30 | Loudoun | Virginia | 51107 | 34176 | 300 |
1865100 | 1865100 | 2021-10-29 | Loudoun | Virginia | 51107 | 34176 | 300 |
1861851 | 1861851 | 2021-10-28 | Loudoun | Virginia | 51107 | 34125 | 300 |
1858602 | 1858602 | 2021-10-27 | Loudoun | Virginia | 51107 | 34074 | 298 |
1855353 | 1855353 | 2021-10-26 | Loudoun | Virginia | 51107 | 34035 | 297 |
1852104 | 1852104 | 2021-10-25 | Loudoun | Virginia | 51107 | 34005 | 296 |
1848854 | 1848854 | 2021-10-24 | Loudoun | Virginia | 51107 | 33870 | 295 |
1845604 | 1845604 | 2021-10-23 | Loudoun | Virginia | 51107 | 33870 | 295 |
1842354 | 1842354 | 2021-10-22 | Loudoun | Virginia | 51107 | 33870 | 295 |
1839105 | 1839105 | 2021-10-21 | Loudoun | Virginia | 51107 | 33816 | 295 |
1835856 | 1835856 | 2021-10-20 | Loudoun | Virginia | 51107 | 33766 | 295 |
1832607 | 1832607 | 2021-10-19 | Loudoun | Virginia | 51107 | 33715 | 294 |
1829358 | 1829358 | 2021-10-18 | Loudoun | Virginia | 51107 | 33659 | 294 |
1826109 | 1826109 | 2021-10-17 | Loudoun | Virginia | 51107 | 33536 | 294 |
1822860 | 1822860 | 2021-10-16 | Loudoun | Virginia | 51107 | 33536 | 294 |
1819611 | 1819611 | 2021-10-15 | Loudoun | Virginia | 51107 | 33536 | 294 |
1816362 | 1816362 | 2021-10-14 | Loudoun | Virginia | 51107 | 33482 | 294 |
1813114 | 1813114 | 2021-10-13 | Loudoun | Virginia | 51107 | 33414 | 293 |
1809865 | 1809865 | 2021-10-12 | Loudoun | Virginia | 51107 | 33350 | 293 |
1806615 | 1806615 | 2021-10-11 | Loudoun | Virginia | 51107 | 33175 | 292 |
1803365 | 1803365 | 2021-10-10 | Loudoun | Virginia | 51107 | 33175 | 292 |
1800116 | 1800116 | 2021-10-09 | Loudoun | Virginia | 51107 | 33175 | 292 |
1796867 | 1796867 | 2021-10-08 | Loudoun | Virginia | 51107 | 33175 | 292 |
1793618 | 1793618 | 2021-10-07 | Loudoun | Virginia | 51107 | 33122 | 292 |
1790369 | 1790369 | 2021-10-06 | Loudoun | Virginia | 51107 | 33084 | 292 |
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);