ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 23005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175384 | 2175384 | 2022-02-02 | Cumberland | Maine | 23005 | 36607 | 298 |
2172131 | 2172131 | 2022-02-01 | Cumberland | Maine | 23005 | 36106 | 295 |
2168878 | 2168878 | 2022-01-31 | Cumberland | Maine | 23005 | 35577 | 295 |
2165623 | 2165623 | 2022-01-30 | Cumberland | Maine | 23005 | 35577 | 295 |
2162368 | 2162368 | 2022-01-29 | Cumberland | Maine | 23005 | 35577 | 295 |
2159113 | 2159113 | 2022-01-28 | Cumberland | Maine | 23005 | 35214 | 295 |
2155859 | 2155859 | 2022-01-27 | Cumberland | Maine | 23005 | 34769 | 295 |
2152606 | 2152606 | 2022-01-26 | Cumberland | Maine | 23005 | 34392 | 294 |
2149354 | 2149354 | 2022-01-25 | Cumberland | Maine | 23005 | 33989 | 293 |
2146102 | 2146102 | 2022-01-24 | Cumberland | Maine | 23005 | 33623 | 287 |
2142847 | 2142847 | 2022-01-23 | Cumberland | Maine | 23005 | 33623 | 287 |
2139592 | 2139592 | 2022-01-22 | Cumberland | Maine | 23005 | 33622 | 287 |
2136336 | 2136336 | 2022-01-21 | Cumberland | Maine | 23005 | 33207 | 286 |
2133084 | 2133084 | 2022-01-20 | Cumberland | Maine | 23005 | 32887 | 286 |
2129831 | 2129831 | 2022-01-19 | Cumberland | Maine | 23005 | 32464 | 285 |
2126577 | 2126577 | 2022-01-18 | Cumberland | Maine | 23005 | 32017 | 281 |
2123325 | 2123325 | 2022-01-17 | Cumberland | Maine | 23005 | 31865 | 281 |
2120073 | 2120073 | 2022-01-16 | Cumberland | Maine | 23005 | 31865 | 281 |
2116821 | 2116821 | 2022-01-15 | Cumberland | Maine | 23005 | 31865 | 281 |
2113570 | 2113570 | 2022-01-14 | Cumberland | Maine | 23005 | 31482 | 280 |
2110318 | 2110318 | 2022-01-13 | Cumberland | Maine | 23005 | 31064 | 278 |
2107067 | 2107067 | 2022-01-12 | Cumberland | Maine | 23005 | 30688 | 277 |
2103816 | 2103816 | 2022-01-11 | Cumberland | Maine | 23005 | 30249 | 277 |
2100565 | 2100565 | 2022-01-10 | Cumberland | Maine | 23005 | 29844 | 274 |
2097314 | 2097314 | 2022-01-09 | Cumberland | Maine | 23005 | 29844 | 274 |
2094062 | 2094062 | 2022-01-08 | Cumberland | Maine | 23005 | 29844 | 274 |
2090810 | 2090810 | 2022-01-07 | Cumberland | Maine | 23005 | 29488 | 274 |
2087559 | 2087559 | 2022-01-06 | Cumberland | Maine | 23005 | 29159 | 274 |
2084307 | 2084307 | 2022-01-05 | Cumberland | Maine | 23005 | 28734 | 274 |
2081055 | 2081055 | 2022-01-04 | Cumberland | Maine | 23005 | 28394 | 274 |
2077803 | 2077803 | 2022-01-03 | Cumberland | Maine | 23005 | 28182 | 274 |
2074552 | 2074552 | 2022-01-02 | Cumberland | Maine | 23005 | 28182 | 274 |
2071301 | 2071301 | 2022-01-01 | Cumberland | Maine | 23005 | 28182 | 274 |
2068050 | 2068050 | 2021-12-31 | Cumberland | Maine | 23005 | 28182 | 274 |
2064799 | 2064799 | 2021-12-30 | Cumberland | Maine | 23005 | 28016 | 274 |
2061549 | 2061549 | 2021-12-29 | Cumberland | Maine | 23005 | 27868 | 271 |
2058300 | 2058300 | 2021-12-28 | Cumberland | Maine | 23005 | 27681 | 268 |
2055051 | 2055051 | 2021-12-27 | Cumberland | Maine | 23005 | 27425 | 265 |
2051801 | 2051801 | 2021-12-26 | Cumberland | Maine | 23005 | 27423 | 265 |
2048551 | 2048551 | 2021-12-25 | Cumberland | Maine | 23005 | 27423 | 265 |
2045301 | 2045301 | 2021-12-24 | Cumberland | Maine | 23005 | 27423 | 265 |
2042052 | 2042052 | 2021-12-23 | Cumberland | Maine | 23005 | 27270 | 265 |
2038802 | 2038802 | 2021-12-22 | Cumberland | Maine | 23005 | 27074 | 265 |
2035552 | 2035552 | 2021-12-21 | Cumberland | Maine | 23005 | 26821 | 265 |
2032302 | 2032302 | 2021-12-20 | Cumberland | Maine | 23005 | 26665 | 265 |
2029051 | 2029051 | 2021-12-19 | Cumberland | Maine | 23005 | 26665 | 265 |
2025800 | 2025800 | 2021-12-18 | Cumberland | Maine | 23005 | 26665 | 265 |
2022549 | 2022549 | 2021-12-17 | Cumberland | Maine | 23005 | 26527 | 262 |
2019298 | 2019298 | 2021-12-16 | Cumberland | Maine | 23005 | 26341 | 260 |
2016048 | 2016048 | 2021-12-15 | Cumberland | Maine | 23005 | 26051 | 259 |
2012797 | 2012797 | 2021-12-14 | Cumberland | Maine | 23005 | 25770 | 259 |
2009546 | 2009546 | 2021-12-13 | Cumberland | Maine | 23005 | 25616 | 257 |
2006295 | 2006295 | 2021-12-12 | Cumberland | Maine | 23005 | 25616 | 257 |
2003044 | 2003044 | 2021-12-11 | Cumberland | Maine | 23005 | 25616 | 257 |
1999794 | 1999794 | 2021-12-10 | Cumberland | Maine | 23005 | 25496 | 256 |
1996543 | 1996543 | 2021-12-09 | Cumberland | Maine | 23005 | 25259 | 254 |
1993292 | 1993292 | 2021-12-08 | Cumberland | Maine | 23005 | 25031 | 254 |
1990041 | 1990041 | 2021-12-07 | Cumberland | Maine | 23005 | 24846 | 254 |
1986791 | 1986791 | 2021-12-06 | Cumberland | Maine | 23005 | 24717 | 254 |
1983541 | 1983541 | 2021-12-05 | Cumberland | Maine | 23005 | 24717 | 254 |
1980291 | 1980291 | 2021-12-04 | Cumberland | Maine | 23005 | 24717 | 254 |
1977041 | 1977041 | 2021-12-03 | Cumberland | Maine | 23005 | 24609 | 254 |
1973792 | 1973792 | 2021-12-02 | Cumberland | Maine | 23005 | 24512 | 254 |
1970542 | 1970542 | 2021-12-01 | Cumberland | Maine | 23005 | 24384 | 254 |
1967292 | 1967292 | 2021-11-30 | Cumberland | Maine | 23005 | 24267 | 254 |
1964040 | 1964040 | 2021-11-29 | Cumberland | Maine | 23005 | 24122 | 252 |
1960789 | 1960789 | 2021-11-28 | Cumberland | Maine | 23005 | 24100 | 250 |
1957538 | 1957538 | 2021-11-27 | Cumberland | Maine | 23005 | 24100 | 250 |
1954287 | 1954287 | 2021-11-26 | Cumberland | Maine | 23005 | 24100 | 250 |
1951036 | 1951036 | 2021-11-25 | Cumberland | Maine | 23005 | 24100 | 250 |
1947785 | 1947785 | 2021-11-24 | Cumberland | Maine | 23005 | 24053 | 250 |
1944534 | 1944534 | 2021-11-23 | Cumberland | Maine | 23005 | 23932 | 250 |
1941284 | 1941284 | 2021-11-22 | Cumberland | Maine | 23005 | 23759 | 248 |
1938034 | 1938034 | 2021-11-21 | Cumberland | Maine | 23005 | 23759 | 248 |
1934784 | 1934784 | 2021-11-20 | Cumberland | Maine | 23005 | 23759 | 248 |
1931533 | 1931533 | 2021-11-19 | Cumberland | Maine | 23005 | 23665 | 248 |
1928282 | 1928282 | 2021-11-18 | Cumberland | Maine | 23005 | 23472 | 246 |
1925032 | 1925032 | 2021-11-17 | Cumberland | Maine | 23005 | 23348 | 245 |
1921783 | 1921783 | 2021-11-16 | Cumberland | Maine | 23005 | 23171 | 245 |
1918533 | 1918533 | 2021-11-15 | Cumberland | Maine | 23005 | 23016 | 243 |
1915283 | 1915283 | 2021-11-14 | Cumberland | Maine | 23005 | 23017 | 243 |
1912033 | 1912033 | 2021-11-13 | Cumberland | Maine | 23005 | 23017 | 243 |
1908784 | 1908784 | 2021-11-12 | Cumberland | Maine | 23005 | 22941 | 236 |
1905535 | 1905535 | 2021-11-11 | Cumberland | Maine | 23005 | 22941 | 236 |
1902285 | 1902285 | 2021-11-10 | Cumberland | Maine | 23005 | 22820 | 236 |
1899035 | 1899035 | 2021-11-09 | Cumberland | Maine | 23005 | 22691 | 236 |
1895785 | 1895785 | 2021-11-08 | Cumberland | Maine | 23005 | 22596 | 236 |
1892535 | 1892535 | 2021-11-07 | Cumberland | Maine | 23005 | 22596 | 236 |
1889285 | 1889285 | 2021-11-06 | Cumberland | Maine | 23005 | 22596 | 236 |
1886035 | 1886035 | 2021-11-05 | Cumberland | Maine | 23005 | 22516 | 236 |
1882786 | 1882786 | 2021-11-04 | Cumberland | Maine | 23005 | 22427 | 236 |
1879537 | 1879537 | 2021-11-03 | Cumberland | Maine | 23005 | 22340 | 234 |
1876288 | 1876288 | 2021-11-02 | Cumberland | Maine | 23005 | 22243 | 234 |
1873039 | 1873039 | 2021-11-01 | Cumberland | Maine | 23005 | 22138 | 234 |
1869790 | 1869790 | 2021-10-31 | Cumberland | Maine | 23005 | 22138 | 234 |
1866541 | 1866541 | 2021-10-30 | Cumberland | Maine | 23005 | 22138 | 234 |
1863292 | 1863292 | 2021-10-29 | Cumberland | Maine | 23005 | 22078 | 232 |
1860043 | 1860043 | 2021-10-28 | Cumberland | Maine | 23005 | 22015 | 232 |
1856794 | 1856794 | 2021-10-27 | Cumberland | Maine | 23005 | 21890 | 231 |
1853545 | 1853545 | 2021-10-26 | Cumberland | Maine | 23005 | 21782 | 230 |
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);