ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
599 rows where county = "Unknown" and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2172142 | 2172142 | 2022-02-01 | Unknown | Maine | 2 | 0 | |
2168889 | 2168889 | 2022-01-31 | Unknown | Maine | 1 | 0 | |
2165634 | 2165634 | 2022-01-30 | Unknown | Maine | 1 | 0 | |
2162379 | 2162379 | 2022-01-29 | Unknown | Maine | 1 | 0 | |
2159124 | 2159124 | 2022-01-28 | Unknown | Maine | 1 | 0 | |
2155870 | 2155870 | 2022-01-27 | Unknown | Maine | 13 | 0 | |
2152617 | 2152617 | 2022-01-26 | Unknown | Maine | 1 | 0 | |
2149365 | 2149365 | 2022-01-25 | Unknown | Maine | 5 | 0 | |
2146113 | 2146113 | 2022-01-24 | Unknown | Maine | 5 | 0 | |
2142858 | 2142858 | 2022-01-23 | Unknown | Maine | 5 | 0 | |
2139603 | 2139603 | 2022-01-22 | Unknown | Maine | 5 | 0 | |
2136347 | 2136347 | 2022-01-21 | Unknown | Maine | 2 | 0 | |
2133095 | 2133095 | 2022-01-20 | Unknown | Maine | 2 | 0 | |
2129842 | 2129842 | 2022-01-19 | Unknown | Maine | 4 | 0 | |
2126588 | 2126588 | 2022-01-18 | Unknown | Maine | 14 | 0 | |
2123336 | 2123336 | 2022-01-17 | Unknown | Maine | 10 | 0 | |
2120084 | 2120084 | 2022-01-16 | Unknown | Maine | 10 | 0 | |
2116832 | 2116832 | 2022-01-15 | Unknown | Maine | 10 | 0 | |
2113581 | 2113581 | 2022-01-14 | Unknown | Maine | 20 | 0 | |
2110329 | 2110329 | 2022-01-13 | Unknown | Maine | 7 | 0 | |
2107078 | 2107078 | 2022-01-12 | Unknown | Maine | 18 | 0 | |
2103827 | 2103827 | 2022-01-11 | Unknown | Maine | 19 | 0 | |
2100576 | 2100576 | 2022-01-10 | Unknown | Maine | 6 | 0 | |
2097325 | 2097325 | 2022-01-09 | Unknown | Maine | 6 | 0 | |
2094073 | 2094073 | 2022-01-08 | Unknown | Maine | 6 | 0 | |
2090821 | 2090821 | 2022-01-07 | Unknown | Maine | 16 | 0 | |
2087570 | 2087570 | 2022-01-06 | Unknown | Maine | 6 | 0 | |
2084318 | 2084318 | 2022-01-05 | Unknown | Maine | 4 | 0 | |
2081066 | 2081066 | 2022-01-04 | Unknown | Maine | 4 | 0 | |
2077814 | 2077814 | 2022-01-03 | Unknown | Maine | 16 | 0 | |
2074563 | 2074563 | 2022-01-02 | Unknown | Maine | 16 | 0 | |
2071312 | 2071312 | 2022-01-01 | Unknown | Maine | 16 | 0 | |
2068061 | 2068061 | 2021-12-31 | Unknown | Maine | 16 | 0 | |
2064810 | 2064810 | 2021-12-30 | Unknown | Maine | 1 | 0 | |
2061560 | 2061560 | 2021-12-29 | Unknown | Maine | 3 | 0 | |
2058311 | 2058311 | 2021-12-28 | Unknown | Maine | 6 | 1 | |
2055062 | 2055062 | 2021-12-27 | Unknown | Maine | 21 | 1 | |
2051812 | 2051812 | 2021-12-26 | Unknown | Maine | 21 | 1 | |
2048562 | 2048562 | 2021-12-25 | Unknown | Maine | 21 | 1 | |
2045312 | 2045312 | 2021-12-24 | Unknown | Maine | 21 | 1 | |
2038813 | 2038813 | 2021-12-22 | Unknown | Maine | 1 | 0 | |
2035563 | 2035563 | 2021-12-21 | Unknown | Maine | 1 | 0 | |
2032313 | 2032313 | 2021-12-20 | Unknown | Maine | 4 | 0 | |
2029062 | 2029062 | 2021-12-19 | Unknown | Maine | 4 | 0 | |
2025811 | 2025811 | 2021-12-18 | Unknown | Maine | 4 | 0 | |
2022560 | 2022560 | 2021-12-17 | Unknown | Maine | 2 | 0 | |
2019309 | 2019309 | 2021-12-16 | Unknown | Maine | 3 | 0 | |
2016059 | 2016059 | 2021-12-15 | Unknown | Maine | 6 | 0 | |
2012808 | 2012808 | 2021-12-14 | Unknown | Maine | 19 | 0 | |
2009557 | 2009557 | 2021-12-13 | Unknown | Maine | 11 | 0 | |
2006306 | 2006306 | 2021-12-12 | Unknown | Maine | 17 | 0 | |
2003055 | 2003055 | 2021-12-11 | Unknown | Maine | 30 | 0 | |
1999805 | 1999805 | 2021-12-10 | Unknown | Maine | 4 | 0 | |
1996554 | 1996554 | 2021-12-09 | Unknown | Maine | 19 | 0 | |
1993303 | 1993303 | 2021-12-08 | Unknown | Maine | 1 | 0 | |
1990052 | 1990052 | 2021-12-07 | Unknown | Maine | 3 | 0 | |
1986802 | 1986802 | 2021-12-06 | Unknown | Maine | 1 | 0 | |
1983552 | 1983552 | 2021-12-05 | Unknown | Maine | 1 | 0 | |
1980302 | 1980302 | 2021-12-04 | Unknown | Maine | 1 | 0 | |
1977052 | 1977052 | 2021-12-03 | Unknown | Maine | 2 | 0 | |
1970553 | 1970553 | 2021-12-01 | Unknown | Maine | 5 | 0 | |
1967303 | 1967303 | 2021-11-30 | Unknown | Maine | 1 | 0 | |
1964051 | 1964051 | 2021-11-29 | Unknown | Maine | 25 | 0 | |
1960800 | 1960800 | 2021-11-28 | Unknown | Maine | 19 | 0 | |
1957549 | 1957549 | 2021-11-27 | Unknown | Maine | 19 | 0 | |
1954298 | 1954298 | 2021-11-26 | Unknown | Maine | 19 | 0 | |
1951047 | 1951047 | 2021-11-25 | Unknown | Maine | 19 | 0 | |
1947796 | 1947796 | 2021-11-24 | Unknown | Maine | 1 | 0 | |
1944545 | 1944545 | 2021-11-23 | Unknown | Maine | 1 | 0 | |
1931544 | 1931544 | 2021-11-19 | Unknown | Maine | 6 | 0 | |
1928293 | 1928293 | 2021-11-18 | Unknown | Maine | 6 | 0 | |
1925043 | 1925043 | 2021-11-17 | Unknown | Maine | 8 | 0 | |
1921794 | 1921794 | 2021-11-16 | Unknown | Maine | 10 | 0 | |
1918544 | 1918544 | 2021-11-15 | Unknown | Maine | 34 | 0 | |
1915294 | 1915294 | 2021-11-14 | Unknown | Maine | 34 | 0 | |
1912044 | 1912044 | 2021-11-13 | Unknown | Maine | 34 | 0 | |
1902296 | 1902296 | 2021-11-10 | Unknown | Maine | 1 | 0 | |
1899046 | 1899046 | 2021-11-09 | Unknown | Maine | 1 | 0 | |
1895796 | 1895796 | 2021-11-08 | Unknown | Maine | 2 | 0 | |
1892546 | 1892546 | 2021-11-07 | Unknown | Maine | 2 | 0 | |
1889296 | 1889296 | 2021-11-06 | Unknown | Maine | 2 | 0 | |
1886046 | 1886046 | 2021-11-05 | Unknown | Maine | 1 | 0 | |
1882797 | 1882797 | 2021-11-04 | Unknown | Maine | 1 | 0 | |
1879548 | 1879548 | 2021-11-03 | Unknown | Maine | 2 | 0 | |
1876299 | 1876299 | 2021-11-02 | Unknown | Maine | 3 | 0 | |
1873050 | 1873050 | 2021-11-01 | Unknown | Maine | 22 | 0 | |
1869801 | 1869801 | 2021-10-31 | Unknown | Maine | 22 | 0 | |
1866552 | 1866552 | 2021-10-30 | Unknown | Maine | 22 | 0 | |
1863303 | 1863303 | 2021-10-29 | Unknown | Maine | 1 | 0 | |
1860054 | 1860054 | 2021-10-28 | Unknown | Maine | 3 | 0 | |
1856805 | 1856805 | 2021-10-27 | Unknown | Maine | 2 | 0 | |
1853556 | 1853556 | 2021-10-26 | Unknown | Maine | 6 | 0 | |
1850307 | 1850307 | 2021-10-25 | Unknown | Maine | 2 | 0 | |
1847057 | 1847057 | 2021-10-24 | Unknown | Maine | 2 | 0 | |
1843807 | 1843807 | 2021-10-23 | Unknown | Maine | 2 | 0 | |
1840557 | 1840557 | 2021-10-22 | Unknown | Maine | 4 | 0 | |
1837308 | 1837308 | 2021-10-21 | Unknown | Maine | 1 | 0 | |
1834059 | 1834059 | 2021-10-20 | Unknown | Maine | 4 | 0 | |
1830810 | 1830810 | 2021-10-19 | Unknown | Maine | 4 | 0 | |
1827561 | 1827561 | 2021-10-18 | Unknown | Maine | 8 | 0 |
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);