ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Washington" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175397 | 2175397 | 2022-02-02 | Washington | Maine | 23029 | 3128 | 45 |
2172144 | 2172144 | 2022-02-01 | Washington | Maine | 23029 | 3125 | 45 |
2168891 | 2168891 | 2022-01-31 | Washington | Maine | 23029 | 3091 | 45 |
2165636 | 2165636 | 2022-01-30 | Washington | Maine | 23029 | 3091 | 45 |
2162381 | 2162381 | 2022-01-29 | Washington | Maine | 23029 | 3091 | 45 |
2159126 | 2159126 | 2022-01-28 | Washington | Maine | 23029 | 3069 | 45 |
2155872 | 2155872 | 2022-01-27 | Washington | Maine | 23029 | 3051 | 45 |
2152619 | 2152619 | 2022-01-26 | Washington | Maine | 23029 | 3048 | 45 |
2149367 | 2149367 | 2022-01-25 | Washington | Maine | 23029 | 3032 | 45 |
2146115 | 2146115 | 2022-01-24 | Washington | Maine | 23029 | 3006 | 44 |
2142860 | 2142860 | 2022-01-23 | Washington | Maine | 23029 | 3006 | 44 |
2139605 | 2139605 | 2022-01-22 | Washington | Maine | 23029 | 3006 | 44 |
2136349 | 2136349 | 2022-01-21 | Washington | Maine | 23029 | 3000 | 44 |
2133097 | 2133097 | 2022-01-20 | Washington | Maine | 23029 | 2981 | 44 |
2129844 | 2129844 | 2022-01-19 | Washington | Maine | 23029 | 2976 | 44 |
2126590 | 2126590 | 2022-01-18 | Washington | Maine | 23029 | 2946 | 43 |
2123338 | 2123338 | 2022-01-17 | Washington | Maine | 23029 | 2945 | 43 |
2120086 | 2120086 | 2022-01-16 | Washington | Maine | 23029 | 2945 | 43 |
2116834 | 2116834 | 2022-01-15 | Washington | Maine | 23029 | 2945 | 43 |
2113583 | 2113583 | 2022-01-14 | Washington | Maine | 23029 | 2914 | 42 |
2110331 | 2110331 | 2022-01-13 | Washington | Maine | 23029 | 2886 | 41 |
2107080 | 2107080 | 2022-01-12 | Washington | Maine | 23029 | 2874 | 41 |
2103829 | 2103829 | 2022-01-11 | Washington | Maine | 23029 | 2868 | 41 |
2100578 | 2100578 | 2022-01-10 | Washington | Maine | 23029 | 2861 | 41 |
2097327 | 2097327 | 2022-01-09 | Washington | Maine | 23029 | 2861 | 41 |
2094075 | 2094075 | 2022-01-08 | Washington | Maine | 23029 | 2861 | 41 |
2090823 | 2090823 | 2022-01-07 | Washington | Maine | 23029 | 2843 | 41 |
2087572 | 2087572 | 2022-01-06 | Washington | Maine | 23029 | 2829 | 41 |
2084320 | 2084320 | 2022-01-05 | Washington | Maine | 23029 | 2815 | 41 |
2081068 | 2081068 | 2022-01-04 | Washington | Maine | 23029 | 2810 | 40 |
2077816 | 2077816 | 2022-01-03 | Washington | Maine | 23029 | 2790 | 39 |
2074565 | 2074565 | 2022-01-02 | Washington | Maine | 23029 | 2790 | 39 |
2071314 | 2071314 | 2022-01-01 | Washington | Maine | 23029 | 2790 | 39 |
2068063 | 2068063 | 2021-12-31 | Washington | Maine | 23029 | 2790 | 39 |
2064812 | 2064812 | 2021-12-30 | Washington | Maine | 23029 | 2785 | 39 |
2061562 | 2061562 | 2021-12-29 | Washington | Maine | 23029 | 2781 | 39 |
2058313 | 2058313 | 2021-12-28 | Washington | Maine | 23029 | 2740 | 38 |
2055064 | 2055064 | 2021-12-27 | Washington | Maine | 23029 | 2708 | 38 |
2051814 | 2051814 | 2021-12-26 | Washington | Maine | 23029 | 2708 | 38 |
2048564 | 2048564 | 2021-12-25 | Washington | Maine | 23029 | 2708 | 38 |
2045314 | 2045314 | 2021-12-24 | Washington | Maine | 23029 | 2708 | 38 |
2042064 | 2042064 | 2021-12-23 | Washington | Maine | 23029 | 2701 | 38 |
2038815 | 2038815 | 2021-12-22 | Washington | Maine | 23029 | 2699 | 38 |
2035565 | 2035565 | 2021-12-21 | Washington | Maine | 23029 | 2667 | 38 |
2032315 | 2032315 | 2021-12-20 | Washington | Maine | 23029 | 2655 | 38 |
2029064 | 2029064 | 2021-12-19 | Washington | Maine | 23029 | 2655 | 38 |
2025813 | 2025813 | 2021-12-18 | Washington | Maine | 23029 | 2655 | 38 |
2022562 | 2022562 | 2021-12-17 | Washington | Maine | 23029 | 2635 | 38 |
2019311 | 2019311 | 2021-12-16 | Washington | Maine | 23029 | 2625 | 38 |
2016061 | 2016061 | 2021-12-15 | Washington | Maine | 23029 | 2614 | 37 |
2012810 | 2012810 | 2021-12-14 | Washington | Maine | 23029 | 2603 | 37 |
2009559 | 2009559 | 2021-12-13 | Washington | Maine | 23029 | 2537 | 37 |
2006308 | 2006308 | 2021-12-12 | Washington | Maine | 23029 | 2537 | 37 |
2003057 | 2003057 | 2021-12-11 | Washington | Maine | 23029 | 2536 | 37 |
1999807 | 1999807 | 2021-12-10 | Washington | Maine | 23029 | 2499 | 36 |
1996556 | 1996556 | 2021-12-09 | Washington | Maine | 23029 | 2458 | 36 |
1993305 | 1993305 | 2021-12-08 | Washington | Maine | 23029 | 2452 | 36 |
1990054 | 1990054 | 2021-12-07 | Washington | Maine | 23029 | 2422 | 35 |
1986804 | 1986804 | 2021-12-06 | Washington | Maine | 23029 | 2415 | 32 |
1983554 | 1983554 | 2021-12-05 | Washington | Maine | 23029 | 2415 | 32 |
1980304 | 1980304 | 2021-12-04 | Washington | Maine | 23029 | 2415 | 32 |
1977054 | 1977054 | 2021-12-03 | Washington | Maine | 23029 | 2397 | 31 |
1973804 | 1973804 | 2021-12-02 | Washington | Maine | 23029 | 2390 | 31 |
1970555 | 1970555 | 2021-12-01 | Washington | Maine | 23029 | 2368 | 30 |
1967305 | 1967305 | 2021-11-30 | Washington | Maine | 23029 | 2354 | 30 |
1964053 | 1964053 | 2021-11-29 | Washington | Maine | 23029 | 2355 | 29 |
1960802 | 1960802 | 2021-11-28 | Washington | Maine | 23029 | 2355 | 28 |
1957551 | 1957551 | 2021-11-27 | Washington | Maine | 23029 | 2355 | 28 |
1954300 | 1954300 | 2021-11-26 | Washington | Maine | 23029 | 2355 | 28 |
1951049 | 1951049 | 2021-11-25 | Washington | Maine | 23029 | 2355 | 28 |
1947798 | 1947798 | 2021-11-24 | Washington | Maine | 23029 | 2350 | 28 |
1944547 | 1944547 | 2021-11-23 | Washington | Maine | 23029 | 2317 | 28 |
1941296 | 1941296 | 2021-11-22 | Washington | Maine | 23029 | 2293 | 28 |
1938046 | 1938046 | 2021-11-21 | Washington | Maine | 23029 | 2293 | 28 |
1934796 | 1934796 | 2021-11-20 | Washington | Maine | 23029 | 2293 | 28 |
1931546 | 1931546 | 2021-11-19 | Washington | Maine | 23029 | 2272 | 27 |
1928295 | 1928295 | 2021-11-18 | Washington | Maine | 23029 | 2238 | 27 |
1925045 | 1925045 | 2021-11-17 | Washington | Maine | 23029 | 2180 | 26 |
1921796 | 1921796 | 2021-11-16 | Washington | Maine | 23029 | 2166 | 26 |
1918546 | 1918546 | 2021-11-15 | Washington | Maine | 23029 | 2142 | 26 |
1915296 | 1915296 | 2021-11-14 | Washington | Maine | 23029 | 2142 | 26 |
1912046 | 1912046 | 2021-11-13 | Washington | Maine | 23029 | 2142 | 26 |
1908796 | 1908796 | 2021-11-12 | Washington | Maine | 23029 | 2126 | 26 |
1905547 | 1905547 | 2021-11-11 | Washington | Maine | 23029 | 2126 | 26 |
1902298 | 1902298 | 2021-11-10 | Washington | Maine | 23029 | 2099 | 25 |
1899048 | 1899048 | 2021-11-09 | Washington | Maine | 23029 | 2085 | 25 |
1895798 | 1895798 | 2021-11-08 | Washington | Maine | 23029 | 2058 | 23 |
1892548 | 1892548 | 2021-11-07 | Washington | Maine | 23029 | 2058 | 23 |
1889298 | 1889298 | 2021-11-06 | Washington | Maine | 23029 | 2058 | 23 |
1886048 | 1886048 | 2021-11-05 | Washington | Maine | 23029 | 2035 | 23 |
1882799 | 1882799 | 2021-11-04 | Washington | Maine | 23029 | 2014 | 21 |
1879550 | 1879550 | 2021-11-03 | Washington | Maine | 23029 | 1992 | 21 |
1876301 | 1876301 | 2021-11-02 | Washington | Maine | 23029 | 1952 | 20 |
1873052 | 1873052 | 2021-11-01 | Washington | Maine | 23029 | 1928 | 20 |
1869803 | 1869803 | 2021-10-31 | Washington | Maine | 23029 | 1928 | 20 |
1866554 | 1866554 | 2021-10-30 | Washington | Maine | 23029 | 1928 | 20 |
1863305 | 1863305 | 2021-10-29 | Washington | Maine | 23029 | 1907 | 20 |
1860056 | 1860056 | 2021-10-28 | Washington | Maine | 23029 | 1889 | 20 |
1856807 | 1856807 | 2021-10-27 | Washington | Maine | 23029 | 1854 | 20 |
1853558 | 1853558 | 2021-10-26 | Washington | Maine | 23029 | 1844 | 20 |
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);