ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "La Paz" and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174296 | 2174296 | 2022-02-02 | La Paz | Arizona | 4012 | 4827 | 117 |
2171044 | 2171044 | 2022-02-01 | La Paz | Arizona | 4012 | 4815 | 117 |
2167791 | 2167791 | 2022-01-31 | La Paz | Arizona | 4012 | 4794 | 116 |
2164536 | 2164536 | 2022-01-30 | La Paz | Arizona | 4012 | 4784 | 116 |
2161281 | 2161281 | 2022-01-29 | La Paz | Arizona | 4012 | 4755 | 116 |
2158025 | 2158025 | 2022-01-28 | La Paz | Arizona | 4012 | 4711 | 116 |
2154772 | 2154772 | 2022-01-27 | La Paz | Arizona | 4012 | 4667 | 116 |
2151519 | 2151519 | 2022-01-26 | La Paz | Arizona | 4012 | 4577 | 115 |
2148267 | 2148267 | 2022-01-25 | La Paz | Arizona | 4012 | 4552 | 114 |
2145015 | 2145015 | 2022-01-24 | La Paz | Arizona | 4012 | 4530 | 114 |
2141760 | 2141760 | 2022-01-23 | La Paz | Arizona | 4012 | 4495 | 114 |
2138504 | 2138504 | 2022-01-22 | La Paz | Arizona | 4012 | 4457 | 114 |
2135249 | 2135249 | 2022-01-21 | La Paz | Arizona | 4012 | 4383 | 114 |
2131997 | 2131997 | 2022-01-20 | La Paz | Arizona | 4012 | 4289 | 113 |
2128743 | 2128743 | 2022-01-19 | La Paz | Arizona | 4012 | 4248 | 113 |
2125490 | 2125490 | 2022-01-18 | La Paz | Arizona | 4012 | 4214 | 112 |
2122238 | 2122238 | 2022-01-17 | La Paz | Arizona | 4012 | 4190 | 112 |
2118986 | 2118986 | 2022-01-16 | La Paz | Arizona | 4012 | 4142 | 112 |
2115734 | 2115734 | 2022-01-15 | La Paz | Arizona | 4012 | 4081 | 112 |
2112482 | 2112482 | 2022-01-14 | La Paz | Arizona | 4012 | 3996 | 112 |
2109230 | 2109230 | 2022-01-13 | La Paz | Arizona | 4012 | 3945 | 112 |
2105979 | 2105979 | 2022-01-12 | La Paz | Arizona | 4012 | 3904 | 112 |
2102728 | 2102728 | 2022-01-11 | La Paz | Arizona | 4012 | 3866 | 112 |
2099477 | 2099477 | 2022-01-10 | La Paz | Arizona | 4012 | 3833 | 111 |
2096226 | 2096226 | 2022-01-09 | La Paz | Arizona | 4012 | 3819 | 111 |
2092974 | 2092974 | 2022-01-08 | La Paz | Arizona | 4012 | 3800 | 110 |
2089722 | 2089722 | 2022-01-07 | La Paz | Arizona | 4012 | 3772 | 110 |
2086471 | 2086471 | 2022-01-06 | La Paz | Arizona | 4012 | 3743 | 110 |
2083219 | 2083219 | 2022-01-05 | La Paz | Arizona | 4012 | 3705 | 110 |
2079967 | 2079967 | 2022-01-04 | La Paz | Arizona | 4012 | 3682 | 110 |
2076715 | 2076715 | 2022-01-03 | La Paz | Arizona | 4012 | 3679 | 109 |
2073464 | 2073464 | 2022-01-02 | La Paz | Arizona | 4012 | 3664 | 109 |
2070213 | 2070213 | 2022-01-01 | La Paz | Arizona | 4012 | 3664 | 109 |
2066962 | 2066962 | 2021-12-31 | La Paz | Arizona | 4012 | 3652 | 108 |
2063712 | 2063712 | 2021-12-30 | La Paz | Arizona | 4012 | 3638 | 107 |
2060462 | 2060462 | 2021-12-29 | La Paz | Arizona | 4012 | 3618 | 107 |
2057213 | 2057213 | 2021-12-28 | La Paz | Arizona | 4012 | 3608 | 107 |
2053964 | 2053964 | 2021-12-27 | La Paz | Arizona | 4012 | 3603 | 107 |
2050714 | 2050714 | 2021-12-26 | La Paz | Arizona | 4012 | 3600 | 107 |
2047464 | 2047464 | 2021-12-25 | La Paz | Arizona | 4012 | 3599 | 107 |
2044214 | 2044214 | 2021-12-24 | La Paz | Arizona | 4012 | 3595 | 106 |
2040965 | 2040965 | 2021-12-23 | La Paz | Arizona | 4012 | 3585 | 105 |
2037715 | 2037715 | 2021-12-22 | La Paz | Arizona | 4012 | 3577 | 105 |
2034465 | 2034465 | 2021-12-21 | La Paz | Arizona | 4012 | 3566 | 105 |
2031215 | 2031215 | 2021-12-20 | La Paz | Arizona | 4012 | 3566 | 105 |
2027964 | 2027964 | 2021-12-19 | La Paz | Arizona | 4012 | 3563 | 105 |
2024713 | 2024713 | 2021-12-18 | La Paz | Arizona | 4012 | 3555 | 105 |
2021462 | 2021462 | 2021-12-17 | La Paz | Arizona | 4012 | 3547 | 105 |
2018211 | 2018211 | 2021-12-16 | La Paz | Arizona | 4012 | 3539 | 105 |
2014961 | 2014961 | 2021-12-15 | La Paz | Arizona | 4012 | 3531 | 105 |
2011710 | 2011710 | 2021-12-14 | La Paz | Arizona | 4012 | 3520 | 105 |
2008459 | 2008459 | 2021-12-13 | La Paz | Arizona | 4012 | 3516 | 105 |
2005208 | 2005208 | 2021-12-12 | La Paz | Arizona | 4012 | 3515 | 105 |
2001957 | 2001957 | 2021-12-11 | La Paz | Arizona | 4012 | 3501 | 105 |
1998707 | 1998707 | 2021-12-10 | La Paz | Arizona | 4012 | 3497 | 105 |
1995456 | 1995456 | 2021-12-09 | La Paz | Arizona | 4012 | 3482 | 105 |
1992205 | 1992205 | 2021-12-08 | La Paz | Arizona | 4012 | 3466 | 105 |
1988954 | 1988954 | 2021-12-07 | La Paz | Arizona | 4012 | 3456 | 105 |
1985704 | 1985704 | 2021-12-06 | La Paz | Arizona | 4012 | 3452 | 102 |
1982454 | 1982454 | 2021-12-05 | La Paz | Arizona | 4012 | 3451 | 102 |
1979204 | 1979204 | 2021-12-04 | La Paz | Arizona | 4012 | 3445 | 102 |
1975954 | 1975954 | 2021-12-03 | La Paz | Arizona | 4012 | 3432 | 102 |
1972705 | 1972705 | 2021-12-02 | La Paz | Arizona | 4012 | 3414 | 102 |
1969455 | 1969455 | 2021-12-01 | La Paz | Arizona | 4012 | 3407 | 102 |
1966205 | 1966205 | 2021-11-30 | La Paz | Arizona | 4012 | 3396 | 102 |
1962953 | 1962953 | 2021-11-29 | La Paz | Arizona | 4012 | 3390 | 102 |
1959702 | 1959702 | 2021-11-28 | La Paz | Arizona | 4012 | 3386 | 102 |
1956451 | 1956451 | 2021-11-27 | La Paz | Arizona | 4012 | 3385 | 102 |
1953200 | 1953200 | 2021-11-26 | La Paz | Arizona | 4012 | 3375 | 102 |
1949949 | 1949949 | 2021-11-25 | La Paz | Arizona | 4012 | 3370 | 102 |
1946698 | 1946698 | 2021-11-24 | La Paz | Arizona | 4012 | 3369 | 102 |
1943447 | 1943447 | 2021-11-23 | La Paz | Arizona | 4012 | 3359 | 102 |
1940197 | 1940197 | 2021-11-22 | La Paz | Arizona | 4012 | 3358 | 102 |
1936947 | 1936947 | 2021-11-21 | La Paz | Arizona | 4012 | 3346 | 102 |
1933697 | 1933697 | 2021-11-20 | La Paz | Arizona | 4012 | 3336 | 102 |
1930445 | 1930445 | 2021-11-19 | La Paz | Arizona | 4012 | 3325 | 102 |
1927195 | 1927195 | 2021-11-18 | La Paz | Arizona | 4012 | 3318 | 102 |
1923945 | 1923945 | 2021-11-17 | La Paz | Arizona | 4012 | 3310 | 102 |
1920696 | 1920696 | 2021-11-16 | La Paz | Arizona | 4012 | 3308 | 102 |
1917446 | 1917446 | 2021-11-15 | La Paz | Arizona | 4012 | 3303 | 102 |
1914196 | 1914196 | 2021-11-14 | La Paz | Arizona | 4012 | 3296 | 102 |
1910946 | 1910946 | 2021-11-13 | La Paz | Arizona | 4012 | 3287 | 102 |
1907697 | 1907697 | 2021-11-12 | La Paz | Arizona | 4012 | 3283 | 101 |
1904448 | 1904448 | 2021-11-11 | La Paz | Arizona | 4012 | 3266 | 101 |
1901198 | 1901198 | 2021-11-10 | La Paz | Arizona | 4012 | 3259 | 100 |
1897948 | 1897948 | 2021-11-09 | La Paz | Arizona | 4012 | 3255 | 100 |
1894698 | 1894698 | 2021-11-08 | La Paz | Arizona | 4012 | 3253 | 100 |
1891448 | 1891448 | 2021-11-07 | La Paz | Arizona | 4012 | 3250 | 100 |
1888198 | 1888198 | 2021-11-06 | La Paz | Arizona | 4012 | 3244 | 100 |
1884948 | 1884948 | 2021-11-05 | La Paz | Arizona | 4012 | 3241 | 99 |
1881699 | 1881699 | 2021-11-04 | La Paz | Arizona | 4012 | 3232 | 99 |
1878450 | 1878450 | 2021-11-03 | La Paz | Arizona | 4012 | 3220 | 99 |
1875201 | 1875201 | 2021-11-02 | La Paz | Arizona | 4012 | 3218 | 99 |
1871952 | 1871952 | 2021-11-01 | La Paz | Arizona | 4012 | 3213 | 99 |
1868703 | 1868703 | 2021-10-31 | La Paz | Arizona | 4012 | 3208 | 99 |
1865454 | 1865454 | 2021-10-30 | La Paz | Arizona | 4012 | 3196 | 99 |
1862205 | 1862205 | 2021-10-29 | La Paz | Arizona | 4012 | 3194 | 98 |
1858956 | 1858956 | 2021-10-28 | La Paz | Arizona | 4012 | 3178 | 98 |
1855707 | 1855707 | 2021-10-27 | La Paz | Arizona | 4012 | 3174 | 98 |
1852458 | 1852458 | 2021-10-26 | La Paz | Arizona | 4012 | 3158 | 98 |
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);