ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Mecklenburg" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112137 | 2112137 | 2022-01-13 | Mecklenburg | Virginia | 51117 | 4261 | 99 |
2108885 | 2108885 | 2022-01-12 | Mecklenburg | Virginia | 51117 | 4194 | 99 |
2105634 | 2105634 | 2022-01-11 | Mecklenburg | Virginia | 51117 | 4150 | 98 |
2102383 | 2102383 | 2022-01-10 | Mecklenburg | Virginia | 51117 | 4131 | 98 |
2099132 | 2099132 | 2022-01-09 | Mecklenburg | Virginia | 51117 | 4002 | 98 |
2095881 | 2095881 | 2022-01-08 | Mecklenburg | Virginia | 51117 | 4002 | 98 |
2092629 | 2092629 | 2022-01-07 | Mecklenburg | Virginia | 51117 | 4002 | 98 |
2089377 | 2089377 | 2022-01-06 | Mecklenburg | Virginia | 51117 | 3972 | 98 |
2086126 | 2086126 | 2022-01-05 | Mecklenburg | Virginia | 51117 | 3941 | 98 |
2082874 | 2082874 | 2022-01-04 | Mecklenburg | Virginia | 51117 | 3929 | 98 |
2079622 | 2079622 | 2022-01-03 | Mecklenburg | Virginia | 51117 | 3896 | 98 |
2076370 | 2076370 | 2022-01-02 | Mecklenburg | Virginia | 51117 | 3827 | 98 |
2073119 | 2073119 | 2022-01-01 | Mecklenburg | Virginia | 51117 | 3827 | 98 |
2069868 | 2069868 | 2021-12-31 | Mecklenburg | Virginia | 51117 | 3827 | 98 |
2066617 | 2066617 | 2021-12-30 | Mecklenburg | Virginia | 51117 | 3771 | 98 |
2063367 | 2063367 | 2021-12-29 | Mecklenburg | Virginia | 51117 | 3749 | 97 |
2060117 | 2060117 | 2021-12-28 | Mecklenburg | Virginia | 51117 | 3745 | 97 |
2056868 | 2056868 | 2021-12-27 | Mecklenburg | Virginia | 51117 | 3745 | 95 |
2053619 | 2053619 | 2021-12-26 | Mecklenburg | Virginia | 51117 | 3739 | 95 |
2050369 | 2050369 | 2021-12-25 | Mecklenburg | Virginia | 51117 | 3739 | 95 |
2047119 | 2047119 | 2021-12-24 | Mecklenburg | Virginia | 51117 | 3739 | 95 |
2043869 | 2043869 | 2021-12-23 | Mecklenburg | Virginia | 51117 | 3727 | 95 |
2040620 | 2040620 | 2021-12-22 | Mecklenburg | Virginia | 51117 | 3716 | 94 |
2037370 | 2037370 | 2021-12-21 | Mecklenburg | Virginia | 51117 | 3710 | 94 |
2034120 | 2034120 | 2021-12-20 | Mecklenburg | Virginia | 51117 | 3698 | 94 |
2030870 | 2030870 | 2021-12-19 | Mecklenburg | Virginia | 51117 | 3686 | 93 |
2027619 | 2027619 | 2021-12-18 | Mecklenburg | Virginia | 51117 | 3686 | 93 |
2024368 | 2024368 | 2021-12-17 | Mecklenburg | Virginia | 51117 | 3686 | 93 |
2021117 | 2021117 | 2021-12-16 | Mecklenburg | Virginia | 51117 | 3682 | 93 |
2017866 | 2017866 | 2021-12-15 | Mecklenburg | Virginia | 51117 | 3671 | 93 |
2014616 | 2014616 | 2021-12-14 | Mecklenburg | Virginia | 51117 | 3675 | 93 |
2011365 | 2011365 | 2021-12-13 | Mecklenburg | Virginia | 51117 | 3665 | 93 |
2008114 | 2008114 | 2021-12-12 | Mecklenburg | Virginia | 51117 | 3656 | 91 |
2004863 | 2004863 | 2021-12-11 | Mecklenburg | Virginia | 51117 | 3656 | 91 |
2001612 | 2001612 | 2021-12-10 | Mecklenburg | Virginia | 51117 | 3656 | 91 |
1998362 | 1998362 | 2021-12-09 | Mecklenburg | Virginia | 51117 | 3650 | 91 |
1995111 | 1995111 | 2021-12-08 | Mecklenburg | Virginia | 51117 | 3643 | 91 |
1991860 | 1991860 | 2021-12-07 | Mecklenburg | Virginia | 51117 | 3626 | 91 |
1988609 | 1988609 | 2021-12-06 | Mecklenburg | Virginia | 51117 | 3625 | 90 |
1985359 | 1985359 | 2021-12-05 | Mecklenburg | Virginia | 51117 | 3606 | 89 |
1982109 | 1982109 | 2021-12-04 | Mecklenburg | Virginia | 51117 | 3606 | 89 |
1978859 | 1978859 | 2021-12-03 | Mecklenburg | Virginia | 51117 | 3606 | 89 |
1975609 | 1975609 | 2021-12-02 | Mecklenburg | Virginia | 51117 | 3599 | 89 |
1972360 | 1972360 | 2021-12-01 | Mecklenburg | Virginia | 51117 | 3595 | 89 |
1969110 | 1969110 | 2021-11-30 | Mecklenburg | Virginia | 51117 | 3577 | 89 |
1965860 | 1965860 | 2021-11-29 | Mecklenburg | Virginia | 51117 | 3575 | 89 |
1962608 | 1962608 | 2021-11-28 | Mecklenburg | Virginia | 51117 | 3565 | 88 |
1959357 | 1959357 | 2021-11-27 | Mecklenburg | Virginia | 51117 | 3565 | 88 |
1956106 | 1956106 | 2021-11-26 | Mecklenburg | Virginia | 51117 | 3565 | 88 |
1952855 | 1952855 | 2021-11-25 | Mecklenburg | Virginia | 51117 | 3560 | 88 |
1949604 | 1949604 | 2021-11-24 | Mecklenburg | Virginia | 51117 | 3557 | 87 |
1946353 | 1946353 | 2021-11-23 | Mecklenburg | Virginia | 51117 | 3556 | 87 |
1943102 | 1943102 | 2021-11-22 | Mecklenburg | Virginia | 51117 | 3547 | 87 |
1939852 | 1939852 | 2021-11-21 | Mecklenburg | Virginia | 51117 | 3537 | 86 |
1936602 | 1936602 | 2021-11-20 | Mecklenburg | Virginia | 51117 | 3537 | 86 |
1933352 | 1933352 | 2021-11-19 | Mecklenburg | Virginia | 51117 | 3537 | 86 |
1930100 | 1930100 | 2021-11-18 | Mecklenburg | Virginia | 51117 | 3530 | 86 |
1926850 | 1926850 | 2021-11-17 | Mecklenburg | Virginia | 51117 | 3529 | 86 |
1923600 | 1923600 | 2021-11-16 | Mecklenburg | Virginia | 51117 | 3523 | 86 |
1920351 | 1920351 | 2021-11-15 | Mecklenburg | Virginia | 51117 | 3514 | 86 |
1917101 | 1917101 | 2021-11-14 | Mecklenburg | Virginia | 51117 | 3511 | 86 |
1913851 | 1913851 | 2021-11-13 | Mecklenburg | Virginia | 51117 | 3511 | 86 |
1910601 | 1910601 | 2021-11-12 | Mecklenburg | Virginia | 51117 | 3511 | 86 |
1907352 | 1907352 | 2021-11-11 | Mecklenburg | Virginia | 51117 | 3490 | 86 |
1904103 | 1904103 | 2021-11-10 | Mecklenburg | Virginia | 51117 | 3470 | 86 |
1900853 | 1900853 | 2021-11-09 | Mecklenburg | Virginia | 51117 | 3464 | 86 |
1897603 | 1897603 | 2021-11-08 | Mecklenburg | Virginia | 51117 | 3455 | 86 |
1894353 | 1894353 | 2021-11-07 | Mecklenburg | Virginia | 51117 | 3442 | 84 |
1891103 | 1891103 | 2021-11-06 | Mecklenburg | Virginia | 51117 | 3442 | 84 |
1887853 | 1887853 | 2021-11-05 | Mecklenburg | Virginia | 51117 | 3442 | 84 |
1884603 | 1884603 | 2021-11-04 | Mecklenburg | Virginia | 51117 | 3441 | 84 |
1881354 | 1881354 | 2021-11-03 | Mecklenburg | Virginia | 51117 | 3440 | 84 |
1878105 | 1878105 | 2021-11-02 | Mecklenburg | Virginia | 51117 | 3438 | 84 |
1874856 | 1874856 | 2021-11-01 | Mecklenburg | Virginia | 51117 | 3432 | 84 |
1871607 | 1871607 | 2021-10-31 | Mecklenburg | Virginia | 51117 | 3417 | 83 |
1868358 | 1868358 | 2021-10-30 | Mecklenburg | Virginia | 51117 | 3417 | 83 |
1865109 | 1865109 | 2021-10-29 | Mecklenburg | Virginia | 51117 | 3417 | 83 |
1861860 | 1861860 | 2021-10-28 | Mecklenburg | Virginia | 51117 | 3413 | 83 |
1858611 | 1858611 | 2021-10-27 | Mecklenburg | Virginia | 51117 | 3407 | 83 |
1855362 | 1855362 | 2021-10-26 | Mecklenburg | Virginia | 51117 | 3393 | 83 |
1852113 | 1852113 | 2021-10-25 | Mecklenburg | Virginia | 51117 | 3387 | 82 |
1848863 | 1848863 | 2021-10-24 | Mecklenburg | Virginia | 51117 | 3378 | 82 |
1845613 | 1845613 | 2021-10-23 | Mecklenburg | Virginia | 51117 | 3378 | 82 |
1842363 | 1842363 | 2021-10-22 | Mecklenburg | Virginia | 51117 | 3378 | 82 |
1839114 | 1839114 | 2021-10-21 | Mecklenburg | Virginia | 51117 | 3366 | 81 |
1835865 | 1835865 | 2021-10-20 | Mecklenburg | Virginia | 51117 | 3357 | 81 |
1832616 | 1832616 | 2021-10-19 | Mecklenburg | Virginia | 51117 | 3341 | 81 |
1829367 | 1829367 | 2021-10-18 | Mecklenburg | Virginia | 51117 | 3334 | 81 |
1826118 | 1826118 | 2021-10-17 | Mecklenburg | Virginia | 51117 | 3320 | 81 |
1822869 | 1822869 | 2021-10-16 | Mecklenburg | Virginia | 51117 | 3320 | 81 |
1819620 | 1819620 | 2021-10-15 | Mecklenburg | Virginia | 51117 | 3320 | 81 |
1816371 | 1816371 | 2021-10-14 | Mecklenburg | Virginia | 51117 | 3317 | 81 |
1813123 | 1813123 | 2021-10-13 | Mecklenburg | Virginia | 51117 | 3302 | 80 |
1809874 | 1809874 | 2021-10-12 | Mecklenburg | Virginia | 51117 | 3297 | 79 |
1806624 | 1806624 | 2021-10-11 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1803374 | 1803374 | 2021-10-10 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1800125 | 1800125 | 2021-10-09 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1796876 | 1796876 | 2021-10-08 | Mecklenburg | Virginia | 51117 | 3260 | 78 |
1793627 | 1793627 | 2021-10-07 | Mecklenburg | Virginia | 51117 | 3241 | 78 |
1790378 | 1790378 | 2021-10-06 | Mecklenburg | Virginia | 51117 | 3228 | 77 |
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);