ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Arlington" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112065 | 2112065 | 2022-01-13 | Arlington | Virginia | 51013 | 33070 | 284 |
2108813 | 2108813 | 2022-01-12 | Arlington | Virginia | 51013 | 32518 | 285 |
2105562 | 2105562 | 2022-01-11 | Arlington | Virginia | 51013 | 31792 | 284 |
2102311 | 2102311 | 2022-01-10 | Arlington | Virginia | 51013 | 31308 | 283 |
2099060 | 2099060 | 2022-01-09 | Arlington | Virginia | 51013 | 29131 | 283 |
2095809 | 2095809 | 2022-01-08 | Arlington | Virginia | 51013 | 29131 | 283 |
2092557 | 2092557 | 2022-01-07 | Arlington | Virginia | 51013 | 29131 | 283 |
2089305 | 2089305 | 2022-01-06 | Arlington | Virginia | 51013 | 28681 | 283 |
2086054 | 2086054 | 2022-01-05 | Arlington | Virginia | 51013 | 27995 | 283 |
2082802 | 2082802 | 2022-01-04 | Arlington | Virginia | 51013 | 27795 | 283 |
2079550 | 2079550 | 2022-01-03 | Arlington | Virginia | 51013 | 27474 | 283 |
2076298 | 2076298 | 2022-01-02 | Arlington | Virginia | 51013 | 26170 | 283 |
2073047 | 2073047 | 2022-01-01 | Arlington | Virginia | 51013 | 26170 | 283 |
2069796 | 2069796 | 2021-12-31 | Arlington | Virginia | 51013 | 26170 | 283 |
2066545 | 2066545 | 2021-12-30 | Arlington | Virginia | 51013 | 25386 | 283 |
2063295 | 2063295 | 2021-12-29 | Arlington | Virginia | 51013 | 24753 | 283 |
2060045 | 2060045 | 2021-12-28 | Arlington | Virginia | 51013 | 24463 | 283 |
2056796 | 2056796 | 2021-12-27 | Arlington | Virginia | 51013 | 24041 | 278 |
2053547 | 2053547 | 2021-12-26 | Arlington | Virginia | 51013 | 23013 | 276 |
2050297 | 2050297 | 2021-12-25 | Arlington | Virginia | 51013 | 23013 | 276 |
2047047 | 2047047 | 2021-12-24 | Arlington | Virginia | 51013 | 23013 | 276 |
2043797 | 2043797 | 2021-12-23 | Arlington | Virginia | 51013 | 22421 | 276 |
2040548 | 2040548 | 2021-12-22 | Arlington | Virginia | 51013 | 22062 | 276 |
2037298 | 2037298 | 2021-12-21 | Arlington | Virginia | 51013 | 21755 | 276 |
2034048 | 2034048 | 2021-12-20 | Arlington | Virginia | 51013 | 21494 | 276 |
2030798 | 2030798 | 2021-12-19 | Arlington | Virginia | 51013 | 20801 | 276 |
2027547 | 2027547 | 2021-12-18 | Arlington | Virginia | 51013 | 20801 | 276 |
2024296 | 2024296 | 2021-12-17 | Arlington | Virginia | 51013 | 20801 | 276 |
2021045 | 2021045 | 2021-12-16 | Arlington | Virginia | 51013 | 20616 | 276 |
2017794 | 2017794 | 2021-12-15 | Arlington | Virginia | 51013 | 20448 | 276 |
2014544 | 2014544 | 2021-12-14 | Arlington | Virginia | 51013 | 20360 | 276 |
2011293 | 2011293 | 2021-12-13 | Arlington | Virginia | 51013 | 20292 | 276 |
2008042 | 2008042 | 2021-12-12 | Arlington | Virginia | 51013 | 20112 | 276 |
2004791 | 2004791 | 2021-12-11 | Arlington | Virginia | 51013 | 20112 | 276 |
2001540 | 2001540 | 2021-12-10 | Arlington | Virginia | 51013 | 20112 | 276 |
1998290 | 1998290 | 2021-12-09 | Arlington | Virginia | 51013 | 20037 | 276 |
1995039 | 1995039 | 2021-12-08 | Arlington | Virginia | 51013 | 19952 | 276 |
1991788 | 1991788 | 2021-12-07 | Arlington | Virginia | 51013 | 19893 | 276 |
1988537 | 1988537 | 2021-12-06 | Arlington | Virginia | 51013 | 19828 | 276 |
1985287 | 1985287 | 2021-12-05 | Arlington | Virginia | 51013 | 19673 | 276 |
1982037 | 1982037 | 2021-12-04 | Arlington | Virginia | 51013 | 19673 | 276 |
1978787 | 1978787 | 2021-12-03 | Arlington | Virginia | 51013 | 19673 | 276 |
1975537 | 1975537 | 2021-12-02 | Arlington | Virginia | 51013 | 19600 | 275 |
1972288 | 1972288 | 2021-12-01 | Arlington | Virginia | 51013 | 19543 | 275 |
1969038 | 1969038 | 2021-11-30 | Arlington | Virginia | 51013 | 19505 | 275 |
1965788 | 1965788 | 2021-11-29 | Arlington | Virginia | 51013 | 19470 | 275 |
1962536 | 1962536 | 2021-11-28 | Arlington | Virginia | 51013 | 19414 | 275 |
1959285 | 1959285 | 2021-11-27 | Arlington | Virginia | 51013 | 19414 | 275 |
1956034 | 1956034 | 2021-11-26 | Arlington | Virginia | 51013 | 19414 | 275 |
1952783 | 1952783 | 2021-11-25 | Arlington | Virginia | 51013 | 19389 | 275 |
1949532 | 1949532 | 2021-11-24 | Arlington | Virginia | 51013 | 19353 | 275 |
1946281 | 1946281 | 2021-11-23 | Arlington | Virginia | 51013 | 19324 | 275 |
1943030 | 1943030 | 2021-11-22 | Arlington | Virginia | 51013 | 19289 | 275 |
1939780 | 1939780 | 2021-11-21 | Arlington | Virginia | 51013 | 19221 | 274 |
1936530 | 1936530 | 2021-11-20 | Arlington | Virginia | 51013 | 19221 | 274 |
1933280 | 1933280 | 2021-11-19 | Arlington | Virginia | 51013 | 19221 | 274 |
1930028 | 1930028 | 2021-11-18 | Arlington | Virginia | 51013 | 19176 | 274 |
1926778 | 1926778 | 2021-11-17 | Arlington | Virginia | 51013 | 19143 | 274 |
1923528 | 1923528 | 2021-11-16 | Arlington | Virginia | 51013 | 19089 | 274 |
1920279 | 1920279 | 2021-11-15 | Arlington | Virginia | 51013 | 19063 | 274 |
1917029 | 1917029 | 2021-11-14 | Arlington | Virginia | 51013 | 18990 | 274 |
1913779 | 1913779 | 2021-11-13 | Arlington | Virginia | 51013 | 18990 | 274 |
1910529 | 1910529 | 2021-11-12 | Arlington | Virginia | 51013 | 18990 | 274 |
1907280 | 1907280 | 2021-11-11 | Arlington | Virginia | 51013 | 18960 | 274 |
1904031 | 1904031 | 2021-11-10 | Arlington | Virginia | 51013 | 18915 | 273 |
1900781 | 1900781 | 2021-11-09 | Arlington | Virginia | 51013 | 18892 | 273 |
1897531 | 1897531 | 2021-11-08 | Arlington | Virginia | 51013 | 18853 | 273 |
1894281 | 1894281 | 2021-11-07 | Arlington | Virginia | 51013 | 18766 | 272 |
1891031 | 1891031 | 2021-11-06 | Arlington | Virginia | 51013 | 18766 | 272 |
1887781 | 1887781 | 2021-11-05 | Arlington | Virginia | 51013 | 18766 | 272 |
1884531 | 1884531 | 2021-11-04 | Arlington | Virginia | 51013 | 18739 | 272 |
1881282 | 1881282 | 2021-11-03 | Arlington | Virginia | 51013 | 18722 | 272 |
1878033 | 1878033 | 2021-11-02 | Arlington | Virginia | 51013 | 18695 | 271 |
1874784 | 1874784 | 2021-11-01 | Arlington | Virginia | 51013 | 18674 | 271 |
1871535 | 1871535 | 2021-10-31 | Arlington | Virginia | 51013 | 18624 | 271 |
1868286 | 1868286 | 2021-10-30 | Arlington | Virginia | 51013 | 18624 | 271 |
1865037 | 1865037 | 2021-10-29 | Arlington | Virginia | 51013 | 18624 | 271 |
1861788 | 1861788 | 2021-10-28 | Arlington | Virginia | 51013 | 18594 | 271 |
1858539 | 1858539 | 2021-10-27 | Arlington | Virginia | 51013 | 18572 | 271 |
1855290 | 1855290 | 2021-10-26 | Arlington | Virginia | 51013 | 18539 | 270 |
1852041 | 1852041 | 2021-10-25 | Arlington | Virginia | 51013 | 18525 | 269 |
1848791 | 1848791 | 2021-10-24 | Arlington | Virginia | 51013 | 18449 | 269 |
1845541 | 1845541 | 2021-10-23 | Arlington | Virginia | 51013 | 18449 | 269 |
1842291 | 1842291 | 2021-10-22 | Arlington | Virginia | 51013 | 18449 | 269 |
1839042 | 1839042 | 2021-10-21 | Arlington | Virginia | 51013 | 18415 | 269 |
1835793 | 1835793 | 2021-10-20 | Arlington | Virginia | 51013 | 18392 | 269 |
1832544 | 1832544 | 2021-10-19 | Arlington | Virginia | 51013 | 18367 | 269 |
1829295 | 1829295 | 2021-10-18 | Arlington | Virginia | 51013 | 18354 | 269 |
1826046 | 1826046 | 2021-10-17 | Arlington | Virginia | 51013 | 18265 | 269 |
1822797 | 1822797 | 2021-10-16 | Arlington | Virginia | 51013 | 18265 | 269 |
1819548 | 1819548 | 2021-10-15 | Arlington | Virginia | 51013 | 18265 | 269 |
1816299 | 1816299 | 2021-10-14 | Arlington | Virginia | 51013 | 18235 | 269 |
1813051 | 1813051 | 2021-10-13 | Arlington | Virginia | 51013 | 18195 | 266 |
1809802 | 1809802 | 2021-10-12 | Arlington | Virginia | 51013 | 18161 | 266 |
1806552 | 1806552 | 2021-10-11 | Arlington | Virginia | 51013 | 18046 | 266 |
1803302 | 1803302 | 2021-10-10 | Arlington | Virginia | 51013 | 18046 | 266 |
1800053 | 1800053 | 2021-10-09 | Arlington | Virginia | 51013 | 18046 | 266 |
1796804 | 1796804 | 2021-10-08 | Arlington | Virginia | 51013 | 18046 | 266 |
1793555 | 1793555 | 2021-10-07 | Arlington | Virginia | 51013 | 18004 | 266 |
1790306 | 1790306 | 2021-10-06 | Arlington | Virginia | 51013 | 17967 | 265 |
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);