ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

765 rows where county = "Middlesex", fips = 51119 and state = "Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Virginia · 765 ✖

fips 1

  • 51119 · 765 ✖

county 1

  • Middlesex · 765 ✖
Link rowid date ▲ county state fips cases deaths
2502590 2502590 2022-05-13 Middlesex Virginia 51119 1874 48
2499332 2499332 2022-05-12 Middlesex Virginia 51119 1872 48
2496074 2496074 2022-05-11 Middlesex Virginia 51119 1868 48
2492816 2492816 2022-05-10 Middlesex Virginia 51119 1865 48
2489558 2489558 2022-05-09 Middlesex Virginia 51119 1861 48
2486301 2486301 2022-05-08 Middlesex Virginia 51119 1858 48
2483043 2483043 2022-05-07 Middlesex Virginia 51119 1858 48
2479785 2479785 2022-05-06 Middlesex Virginia 51119 1858 48
2476527 2476527 2022-05-05 Middlesex Virginia 51119 1855 48
2473269 2473269 2022-05-04 Middlesex Virginia 51119 1854 48
2470013 2470013 2022-05-03 Middlesex Virginia 51119 1849 48
2466757 2466757 2022-05-02 Middlesex Virginia 51119 1847 48
2463502 2463502 2022-05-01 Middlesex Virginia 51119 1842 48
2460246 2460246 2022-04-30 Middlesex Virginia 51119 1842 48
2456990 2456990 2022-04-29 Middlesex Virginia 51119 1842 48
2453734 2453734 2022-04-28 Middlesex Virginia 51119 1841 48
2450478 2450478 2022-04-27 Middlesex Virginia 51119 1839 48
2447221 2447221 2022-04-26 Middlesex Virginia 51119 1838 48
2443966 2443966 2022-04-25 Middlesex Virginia 51119 1836 48
2440710 2440710 2022-04-24 Middlesex Virginia 51119 1831 47
2437454 2437454 2022-04-23 Middlesex Virginia 51119 1831 47
2434198 2434198 2022-04-22 Middlesex Virginia 51119 1831 47
2430942 2430942 2022-04-21 Middlesex Virginia 51119 1831 47
2427686 2427686 2022-04-20 Middlesex Virginia 51119 1830 46
2424430 2424430 2022-04-19 Middlesex Virginia 51119 1830 46
2421174 2421174 2022-04-18 Middlesex Virginia 51119 1831 46
2417918 2417918 2022-04-17 Middlesex Virginia 51119 1830 46
2414662 2414662 2022-04-16 Middlesex Virginia 51119 1830 46
2411406 2411406 2022-04-15 Middlesex Virginia 51119 1830 46
2408150 2408150 2022-04-14 Middlesex Virginia 51119 1830 46
2404894 2404894 2022-04-13 Middlesex Virginia 51119 1825 46
2401639 2401639 2022-04-12 Middlesex Virginia 51119 1826 46
2398384 2398384 2022-04-11 Middlesex Virginia 51119 1826 46
2395129 2395129 2022-04-10 Middlesex Virginia 51119 1822 46
2391873 2391873 2022-04-09 Middlesex Virginia 51119 1822 46
2388617 2388617 2022-04-08 Middlesex Virginia 51119 1822 46
2385362 2385362 2022-04-07 Middlesex Virginia 51119 1822 46
2382107 2382107 2022-04-06 Middlesex Virginia 51119 1822 46
2378852 2378852 2022-04-05 Middlesex Virginia 51119 1821 46
2375598 2375598 2022-04-04 Middlesex Virginia 51119 1820 46
2372346 2372346 2022-04-03 Middlesex Virginia 51119 1814 45
2369093 2369093 2022-04-02 Middlesex Virginia 51119 1814 45
2365840 2365840 2022-04-01 Middlesex Virginia 51119 1814 45
2362587 2362587 2022-03-31 Middlesex Virginia 51119 1814 45
2359333 2359333 2022-03-30 Middlesex Virginia 51119 1813 45
2356079 2356079 2022-03-29 Middlesex Virginia 51119 1813 45
2352826 2352826 2022-03-28 Middlesex Virginia 51119 1813 45
2349574 2349574 2022-03-27 Middlesex Virginia 51119 1810 45
2346321 2346321 2022-03-26 Middlesex Virginia 51119 1810 45
2343068 2343068 2022-03-25 Middlesex Virginia 51119 1810 45
2339815 2339815 2022-03-24 Middlesex Virginia 51119 1810 45
2336561 2336561 2022-03-23 Middlesex Virginia 51119 1808 45
2333307 2333307 2022-03-22 Middlesex Virginia 51119 1805 45
2330054 2330054 2022-03-21 Middlesex Virginia 51119 1805 45
2326802 2326802 2022-03-20 Middlesex Virginia 51119 1803 45
2323549 2323549 2022-03-19 Middlesex Virginia 51119 1803 45
2320295 2320295 2022-03-18 Middlesex Virginia 51119 1803 45
2317041 2317041 2022-03-17 Middlesex Virginia 51119 1802 45
2313788 2313788 2022-03-16 Middlesex Virginia 51119 1800 45
2310535 2310535 2022-03-15 Middlesex Virginia 51119 1798 45
2307282 2307282 2022-03-14 Middlesex Virginia 51119 1798 45
2304031 2304031 2022-03-13 Middlesex Virginia 51119 1796 45
2300779 2300779 2022-03-12 Middlesex Virginia 51119 1796 45
2297527 2297527 2022-03-11 Middlesex Virginia 51119 1796 45
2294275 2294275 2022-03-10 Middlesex Virginia 51119 1796 45
2291023 2291023 2022-03-09 Middlesex Virginia 51119 1796 45
2287771 2287771 2022-03-08 Middlesex Virginia 51119 1794 45
2284519 2284519 2022-03-07 Middlesex Virginia 51119 1791 45
2281267 2281267 2022-03-06 Middlesex Virginia 51119 1791 46
2278014 2278014 2022-03-05 Middlesex Virginia 51119 1791 46
2274761 2274761 2022-03-04 Middlesex Virginia 51119 1791 46
2271508 2271508 2022-03-03 Middlesex Virginia 51119 1791 46
2268256 2268256 2022-03-02 Middlesex Virginia 51119 1790 46
2265003 2265003 2022-03-01 Middlesex Virginia 51119 1787 46
2261753 2261753 2022-02-28 Middlesex Virginia 51119 1786 46
2258502 2258502 2022-02-27 Middlesex Virginia 51119 1784 43
2255251 2255251 2022-02-26 Middlesex Virginia 51119 1784 43
2252000 2252000 2022-02-25 Middlesex Virginia 51119 1784 43
2248749 2248749 2022-02-24 Middlesex Virginia 51119 1783 43
2245498 2245498 2022-02-23 Middlesex Virginia 51119 1781 42
2242247 2242247 2022-02-22 Middlesex Virginia 51119 1779 42
2238996 2238996 2022-02-21 Middlesex Virginia 51119 1778 42
2235745 2235745 2022-02-20 Middlesex Virginia 51119 1770 42
2232494 2232494 2022-02-19 Middlesex Virginia 51119 1770 42
2229243 2229243 2022-02-18 Middlesex Virginia 51119 1770 42
2225992 2225992 2022-02-17 Middlesex Virginia 51119 1767 42
2222741 2222741 2022-02-16 Middlesex Virginia 51119 1763 42
2219490 2219490 2022-02-15 Middlesex Virginia 51119 1762 42
2216240 2216240 2022-02-14 Middlesex Virginia 51119 1761 42
2212989 2212989 2022-02-13 Middlesex Virginia 51119 1756 42
2209736 2209736 2022-02-12 Middlesex Virginia 51119 1756 42
2206483 2206483 2022-02-11 Middlesex Virginia 51119 1756 42
2203230 2203230 2022-02-10 Middlesex Virginia 51119 1746 42
2199976 2199976 2022-02-09 Middlesex Virginia 51119 1733 41
2196722 2196722 2022-02-08 Middlesex Virginia 51119 1732 41
2193467 2193467 2022-02-07 Middlesex Virginia 51119 1729 41
2190214 2190214 2022-02-06 Middlesex Virginia 51119 1716 40
2186961 2186961 2022-02-05 Middlesex Virginia 51119 1716 40
2183708 2183708 2022-02-04 Middlesex Virginia 51119 1716 40
2180456 2180456 2022-02-03 Middlesex Virginia 51119 1710 40

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);