ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Mason" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949722 | 1949722 | 2021-11-24 | Mason | West Virginia | 54053 | 3888 | 61 |
1946471 | 1946471 | 2021-11-23 | Mason | West Virginia | 54053 | 3874 | 61 |
1943220 | 1943220 | 2021-11-22 | Mason | West Virginia | 54053 | 3861 | 61 |
1939970 | 1939970 | 2021-11-21 | Mason | West Virginia | 54053 | 3855 | 61 |
1936720 | 1936720 | 2021-11-20 | Mason | West Virginia | 54053 | 3843 | 61 |
1933470 | 1933470 | 2021-11-19 | Mason | West Virginia | 54053 | 3822 | 61 |
1930218 | 1930218 | 2021-11-18 | Mason | West Virginia | 54053 | 3807 | 61 |
1926968 | 1926968 | 2021-11-17 | Mason | West Virginia | 54053 | 3792 | 61 |
1923718 | 1923718 | 2021-11-16 | Mason | West Virginia | 54053 | 3774 | 60 |
1920469 | 1920469 | 2021-11-15 | Mason | West Virginia | 54053 | 3758 | 59 |
1917219 | 1917219 | 2021-11-14 | Mason | West Virginia | 54053 | 3755 | 59 |
1913969 | 1913969 | 2021-11-13 | Mason | West Virginia | 54053 | 3751 | 59 |
1910719 | 1910719 | 2021-11-12 | Mason | West Virginia | 54053 | 3748 | 59 |
1907470 | 1907470 | 2021-11-11 | Mason | West Virginia | 54053 | 3737 | 59 |
1904221 | 1904221 | 2021-11-10 | Mason | West Virginia | 54053 | 3724 | 59 |
1900971 | 1900971 | 2021-11-09 | Mason | West Virginia | 54053 | 3721 | 58 |
1897721 | 1897721 | 2021-11-08 | Mason | West Virginia | 54053 | 3709 | 57 |
1894471 | 1894471 | 2021-11-07 | Mason | West Virginia | 54053 | 3702 | 57 |
1891221 | 1891221 | 2021-11-06 | Mason | West Virginia | 54053 | 3696 | 57 |
1887971 | 1887971 | 2021-11-05 | Mason | West Virginia | 54053 | 3687 | 57 |
1884721 | 1884721 | 2021-11-04 | Mason | West Virginia | 54053 | 3675 | 57 |
1881472 | 1881472 | 2021-11-03 | Mason | West Virginia | 54053 | 3662 | 57 |
1878223 | 1878223 | 2021-11-02 | Mason | West Virginia | 54053 | 3644 | 56 |
1874974 | 1874974 | 2021-11-01 | Mason | West Virginia | 54053 | 3633 | 55 |
1871725 | 1871725 | 2021-10-31 | Mason | West Virginia | 54053 | 3633 | 55 |
1868476 | 1868476 | 2021-10-30 | Mason | West Virginia | 54053 | 3629 | 55 |
1865227 | 1865227 | 2021-10-29 | Mason | West Virginia | 54053 | 3622 | 55 |
1861978 | 1861978 | 2021-10-28 | Mason | West Virginia | 54053 | 3614 | 55 |
1858729 | 1858729 | 2021-10-27 | Mason | West Virginia | 54053 | 3605 | 54 |
1855480 | 1855480 | 2021-10-26 | Mason | West Virginia | 54053 | 3595 | 54 |
1852231 | 1852231 | 2021-10-25 | Mason | West Virginia | 54053 | 3590 | 54 |
1848981 | 1848981 | 2021-10-24 | Mason | West Virginia | 54053 | 3587 | 53 |
1845731 | 1845731 | 2021-10-23 | Mason | West Virginia | 54053 | 3587 | 53 |
1842481 | 1842481 | 2021-10-22 | Mason | West Virginia | 54053 | 3586 | 53 |
1839232 | 1839232 | 2021-10-21 | Mason | West Virginia | 54053 | 3578 | 53 |
1835983 | 1835983 | 2021-10-20 | Mason | West Virginia | 54053 | 3564 | 53 |
1832734 | 1832734 | 2021-10-19 | Mason | West Virginia | 54053 | 3548 | 51 |
1829485 | 1829485 | 2021-10-18 | Mason | West Virginia | 54053 | 3537 | 51 |
1826236 | 1826236 | 2021-10-17 | Mason | West Virginia | 54053 | 3535 | 51 |
1822987 | 1822987 | 2021-10-16 | Mason | West Virginia | 54053 | 3528 | 51 |
1819738 | 1819738 | 2021-10-15 | Mason | West Virginia | 54053 | 3518 | 51 |
1816489 | 1816489 | 2021-10-14 | Mason | West Virginia | 54053 | 3504 | 50 |
1813241 | 1813241 | 2021-10-13 | Mason | West Virginia | 54053 | 3490 | 50 |
1809992 | 1809992 | 2021-10-12 | Mason | West Virginia | 54053 | 3471 | 50 |
1806743 | 1806743 | 2021-10-11 | Mason | West Virginia | 54053 | 3454 | 50 |
1803492 | 1803492 | 2021-10-10 | Mason | West Virginia | 54053 | 3451 | 49 |
1800243 | 1800243 | 2021-10-09 | Mason | West Virginia | 54053 | 3437 | 49 |
1796994 | 1796994 | 2021-10-08 | Mason | West Virginia | 54053 | 3420 | 49 |
1793745 | 1793745 | 2021-10-07 | Mason | West Virginia | 54053 | 3394 | 49 |
1790496 | 1790496 | 2021-10-06 | Mason | West Virginia | 54053 | 3371 | 49 |
1787248 | 1787248 | 2021-10-05 | Mason | West Virginia | 54053 | 3352 | 49 |
1783999 | 1783999 | 2021-10-04 | Mason | West Virginia | 54053 | 3329 | 49 |
1780750 | 1780750 | 2021-10-03 | Mason | West Virginia | 54053 | 3323 | 49 |
1777500 | 1777500 | 2021-10-02 | Mason | West Virginia | 54053 | 3315 | 49 |
1774250 | 1774250 | 2021-10-01 | Mason | West Virginia | 54053 | 3296 | 49 |
1771000 | 1771000 | 2021-09-30 | Mason | West Virginia | 54053 | 3271 | 48 |
1767751 | 1767751 | 2021-09-29 | Mason | West Virginia | 54053 | 3241 | 47 |
1764502 | 1764502 | 2021-09-28 | Mason | West Virginia | 54053 | 3211 | 47 |
1761253 | 1761253 | 2021-09-27 | Mason | West Virginia | 54053 | 3183 | 47 |
1758005 | 1758005 | 2021-09-26 | Mason | West Virginia | 54053 | 3170 | 47 |
1754757 | 1754757 | 2021-09-25 | Mason | West Virginia | 54053 | 3157 | 47 |
1751509 | 1751509 | 2021-09-24 | Mason | West Virginia | 54053 | 3148 | 47 |
1748260 | 1748260 | 2021-09-23 | Mason | West Virginia | 54053 | 3105 | 47 |
1745010 | 1745010 | 2021-09-22 | Mason | West Virginia | 54053 | 3066 | 45 |
1741761 | 1741761 | 2021-09-21 | Mason | West Virginia | 54053 | 3033 | 45 |
1738512 | 1738512 | 2021-09-20 | Mason | West Virginia | 54053 | 3010 | 45 |
1735263 | 1735263 | 2021-09-19 | Mason | West Virginia | 54053 | 3003 | 45 |
1732013 | 1732013 | 2021-09-18 | Mason | West Virginia | 54053 | 2985 | 45 |
1728763 | 1728763 | 2021-09-17 | Mason | West Virginia | 54053 | 2961 | 45 |
1725513 | 1725513 | 2021-09-16 | Mason | West Virginia | 54053 | 2930 | 43 |
1722264 | 1722264 | 2021-09-15 | Mason | West Virginia | 54053 | 2906 | 43 |
1719016 | 1719016 | 2021-09-14 | Mason | West Virginia | 54053 | 2877 | 43 |
1715768 | 1715768 | 2021-09-13 | Mason | West Virginia | 54053 | 2854 | 42 |
1712522 | 1712522 | 2021-09-12 | Mason | West Virginia | 54053 | 2841 | 41 |
1709275 | 1709275 | 2021-09-11 | Mason | West Virginia | 54053 | 2807 | 41 |
1706028 | 1706028 | 2021-09-10 | Mason | West Virginia | 54053 | 2760 | 41 |
1702778 | 1702778 | 2021-09-09 | Mason | West Virginia | 54053 | 2715 | 41 |
1699529 | 1699529 | 2021-09-08 | Mason | West Virginia | 54053 | 2691 | 41 |
1696281 | 1696281 | 2021-09-07 | Mason | West Virginia | 54053 | 2664 | 41 |
1693033 | 1693033 | 2021-09-06 | Mason | West Virginia | 54053 | 2642 | 41 |
1689784 | 1689784 | 2021-09-05 | Mason | West Virginia | 54053 | 2624 | 40 |
1686534 | 1686534 | 2021-09-04 | Mason | West Virginia | 54053 | 2595 | 40 |
1683283 | 1683283 | 2021-09-03 | Mason | West Virginia | 54053 | 2553 | 40 |
1680033 | 1680033 | 2021-09-02 | Mason | West Virginia | 54053 | 2518 | 40 |
1676785 | 1676785 | 2021-09-01 | Mason | West Virginia | 54053 | 2504 | 40 |
1673538 | 1673538 | 2021-08-31 | Mason | West Virginia | 54053 | 2478 | 40 |
1670290 | 1670290 | 2021-08-30 | Mason | West Virginia | 54053 | 2463 | 40 |
1667043 | 1667043 | 2021-08-29 | Mason | West Virginia | 54053 | 2439 | 40 |
1663795 | 1663795 | 2021-08-28 | Mason | West Virginia | 54053 | 2398 | 40 |
1660547 | 1660547 | 2021-08-27 | Mason | West Virginia | 54053 | 2398 | 40 |
1657299 | 1657299 | 2021-08-26 | Mason | West Virginia | 54053 | 2385 | 40 |
1654051 | 1654051 | 2021-08-25 | Mason | West Virginia | 54053 | 2362 | 40 |
1650805 | 1650805 | 2021-08-24 | Mason | West Virginia | 54053 | 2343 | 40 |
1647556 | 1647556 | 2021-08-23 | Mason | West Virginia | 54053 | 2335 | 40 |
1644307 | 1644307 | 2021-08-22 | Mason | West Virginia | 54053 | 2298 | 40 |
1641057 | 1641057 | 2021-08-21 | Mason | West Virginia | 54053 | 2298 | 40 |
1637807 | 1637807 | 2021-08-20 | Mason | West Virginia | 54053 | 2298 | 40 |
1634557 | 1634557 | 2021-08-19 | Mason | West Virginia | 54053 | 2288 | 40 |
1631309 | 1631309 | 2021-08-18 | Mason | West Virginia | 54053 | 2278 | 40 |
1628062 | 1628062 | 2021-08-17 | Mason | West Virginia | 54053 | 2261 | 39 |
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);