ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Pima" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174300 | 2174300 | 2022-02-02 | Pima | Arizona | 4019 | 236031 | 3467 |
2171048 | 2171048 | 2022-02-01 | Pima | Arizona | 4019 | 234984 | 3461 |
2167795 | 2167795 | 2022-01-31 | Pima | Arizona | 4019 | 234028 | 3441 |
2164540 | 2164540 | 2022-01-30 | Pima | Arizona | 4019 | 232149 | 3441 |
2161285 | 2161285 | 2022-01-29 | Pima | Arizona | 4019 | 230684 | 3437 |
2158029 | 2158029 | 2022-01-28 | Pima | Arizona | 4019 | 228223 | 3410 |
2154776 | 2154776 | 2022-01-27 | Pima | Arizona | 4019 | 226092 | 3397 |
2151523 | 2151523 | 2022-01-26 | Pima | Arizona | 4019 | 224370 | 3395 |
2148271 | 2148271 | 2022-01-25 | Pima | Arizona | 4019 | 221920 | 3369 |
2145019 | 2145019 | 2022-01-24 | Pima | Arizona | 4019 | 220411 | 3369 |
2141764 | 2141764 | 2022-01-23 | Pima | Arizona | 4019 | 218414 | 3369 |
2138508 | 2138508 | 2022-01-22 | Pima | Arizona | 4019 | 215256 | 3353 |
2135253 | 2135253 | 2022-01-21 | Pima | Arizona | 4019 | 211888 | 3349 |
2132001 | 2132001 | 2022-01-20 | Pima | Arizona | 4019 | 209201 | 3345 |
2128747 | 2128747 | 2022-01-19 | Pima | Arizona | 4019 | 206904 | 3344 |
2125494 | 2125494 | 2022-01-18 | Pima | Arizona | 4019 | 204501 | 3342 |
2122242 | 2122242 | 2022-01-17 | Pima | Arizona | 4019 | 202118 | 3304 |
2118990 | 2118990 | 2022-01-16 | Pima | Arizona | 4019 | 200106 | 3304 |
2115738 | 2115738 | 2022-01-15 | Pima | Arizona | 4019 | 196935 | 3300 |
2112486 | 2112486 | 2022-01-14 | Pima | Arizona | 4019 | 194215 | 3288 |
2109234 | 2109234 | 2022-01-13 | Pima | Arizona | 4019 | 191727 | 3273 |
2105983 | 2105983 | 2022-01-12 | Pima | Arizona | 4019 | 189543 | 3273 |
2102732 | 2102732 | 2022-01-11 | Pima | Arizona | 4019 | 187543 | 3270 |
2099481 | 2099481 | 2022-01-10 | Pima | Arizona | 4019 | 186609 | 3242 |
2096230 | 2096230 | 2022-01-09 | Pima | Arizona | 4019 | 184634 | 3242 |
2092978 | 2092978 | 2022-01-08 | Pima | Arizona | 4019 | 182236 | 3230 |
2089726 | 2089726 | 2022-01-07 | Pima | Arizona | 4019 | 180332 | 3216 |
2086475 | 2086475 | 2022-01-06 | Pima | Arizona | 4019 | 178631 | 3210 |
2083223 | 2083223 | 2022-01-05 | Pima | Arizona | 4019 | 177304 | 3210 |
2079971 | 2079971 | 2022-01-04 | Pima | Arizona | 4019 | 176183 | 3206 |
2076719 | 2076719 | 2022-01-03 | Pima | Arizona | 4019 | 175748 | 3177 |
2073468 | 2073468 | 2022-01-02 | Pima | Arizona | 4019 | 174201 | 3177 |
2070217 | 2070217 | 2022-01-01 | Pima | Arizona | 4019 | 174066 | 3177 |
2066966 | 2066966 | 2021-12-31 | Pima | Arizona | 4019 | 173038 | 3154 |
2063716 | 2063716 | 2021-12-30 | Pima | Arizona | 4019 | 172153 | 3153 |
2060466 | 2060466 | 2021-12-29 | Pima | Arizona | 4019 | 171383 | 3151 |
2057217 | 2057217 | 2021-12-28 | Pima | Arizona | 4019 | 170831 | 3150 |
2053968 | 2053968 | 2021-12-27 | Pima | Arizona | 4019 | 170703 | 3121 |
2050718 | 2050718 | 2021-12-26 | Pima | Arizona | 4019 | 169972 | 3121 |
2047468 | 2047468 | 2021-12-25 | Pima | Arizona | 4019 | 169972 | 3121 |
2044218 | 2044218 | 2021-12-24 | Pima | Arizona | 4019 | 169560 | 3112 |
2040969 | 2040969 | 2021-12-23 | Pima | Arizona | 4019 | 169140 | 3099 |
2037719 | 2037719 | 2021-12-22 | Pima | Arizona | 4019 | 168752 | 3098 |
2034469 | 2034469 | 2021-12-21 | Pima | Arizona | 4019 | 168481 | 3094 |
2031219 | 2031219 | 2021-12-20 | Pima | Arizona | 4019 | 168138 | 3052 |
2027968 | 2027968 | 2021-12-19 | Pima | Arizona | 4019 | 167950 | 3052 |
2024717 | 2024717 | 2021-12-18 | Pima | Arizona | 4019 | 167569 | 3052 |
2021466 | 2021466 | 2021-12-17 | Pima | Arizona | 4019 | 167227 | 3050 |
2018215 | 2018215 | 2021-12-16 | Pima | Arizona | 4019 | 166791 | 3022 |
2014965 | 2014965 | 2021-12-15 | Pima | Arizona | 4019 | 166437 | 3022 |
2011714 | 2011714 | 2021-12-14 | Pima | Arizona | 4019 | 166096 | 3020 |
2008463 | 2008463 | 2021-12-13 | Pima | Arizona | 4019 | 165803 | 2984 |
2005212 | 2005212 | 2021-12-12 | Pima | Arizona | 4019 | 165457 | 2984 |
2001961 | 2001961 | 2021-12-11 | Pima | Arizona | 4019 | 165066 | 2983 |
1998711 | 1998711 | 2021-12-10 | Pima | Arizona | 4019 | 164693 | 2972 |
1995460 | 1995460 | 2021-12-09 | Pima | Arizona | 4019 | 164190 | 2961 |
1992209 | 1992209 | 2021-12-08 | Pima | Arizona | 4019 | 163655 | 2951 |
1988958 | 1988958 | 2021-12-07 | Pima | Arizona | 4019 | 163219 | 2949 |
1985708 | 1985708 | 2021-12-06 | Pima | Arizona | 4019 | 162926 | 2928 |
1982458 | 1982458 | 2021-12-05 | Pima | Arizona | 4019 | 162492 | 2928 |
1979208 | 1979208 | 2021-12-04 | Pima | Arizona | 4019 | 161873 | 2928 |
1975958 | 1975958 | 2021-12-03 | Pima | Arizona | 4019 | 161067 | 2903 |
1972709 | 1972709 | 2021-12-02 | Pima | Arizona | 4019 | 160397 | 2901 |
1969459 | 1969459 | 2021-12-01 | Pima | Arizona | 4019 | 159859 | 2900 |
1966209 | 1966209 | 2021-11-30 | Pima | Arizona | 4019 | 159621 | 2899 |
1962957 | 1962957 | 2021-11-29 | Pima | Arizona | 4019 | 159242 | 2883 |
1959706 | 1959706 | 2021-11-28 | Pima | Arizona | 4019 | 158853 | 2883 |
1956455 | 1956455 | 2021-11-27 | Pima | Arizona | 4019 | 158624 | 2883 |
1953204 | 1953204 | 2021-11-26 | Pima | Arizona | 4019 | 157966 | 2878 |
1949953 | 1949953 | 2021-11-25 | Pima | Arizona | 4019 | 157277 | 2877 |
1946702 | 1946702 | 2021-11-24 | Pima | Arizona | 4019 | 156766 | 2865 |
1943451 | 1943451 | 2021-11-23 | Pima | Arizona | 4019 | 156373 | 2863 |
1940201 | 1940201 | 2021-11-22 | Pima | Arizona | 4019 | 155858 | 2844 |
1936951 | 1936951 | 2021-11-21 | Pima | Arizona | 4019 | 155421 | 2844 |
1933701 | 1933701 | 2021-11-20 | Pima | Arizona | 4019 | 154810 | 2844 |
1930449 | 1930449 | 2021-11-19 | Pima | Arizona | 4019 | 154017 | 2838 |
1927199 | 1927199 | 2021-11-18 | Pima | Arizona | 4019 | 153203 | 2831 |
1923949 | 1923949 | 2021-11-17 | Pima | Arizona | 4019 | 152509 | 2829 |
1920700 | 1920700 | 2021-11-16 | Pima | Arizona | 4019 | 152075 | 2827 |
1917450 | 1917450 | 2021-11-15 | Pima | Arizona | 4019 | 151584 | 2807 |
1914200 | 1914200 | 2021-11-14 | Pima | Arizona | 4019 | 151068 | 2807 |
1910950 | 1910950 | 2021-11-13 | Pima | Arizona | 4019 | 150623 | 2807 |
1907701 | 1907701 | 2021-11-12 | Pima | Arizona | 4019 | 150056 | 2792 |
1904452 | 1904452 | 2021-11-11 | Pima | Arizona | 4019 | 149413 | 2786 |
1901202 | 1901202 | 2021-11-10 | Pima | Arizona | 4019 | 148962 | 2789 |
1897952 | 1897952 | 2021-11-09 | Pima | Arizona | 4019 | 148411 | 2790 |
1894702 | 1894702 | 2021-11-08 | Pima | Arizona | 4019 | 147945 | 2769 |
1891452 | 1891452 | 2021-11-07 | Pima | Arizona | 4019 | 147471 | 2769 |
1888202 | 1888202 | 2021-11-06 | Pima | Arizona | 4019 | 146926 | 2769 |
1884952 | 1884952 | 2021-11-05 | Pima | Arizona | 4019 | 146437 | 2766 |
1881703 | 1881703 | 2021-11-04 | Pima | Arizona | 4019 | 146005 | 2757 |
1878454 | 1878454 | 2021-11-03 | Pima | Arizona | 4019 | 145535 | 2756 |
1875205 | 1875205 | 2021-11-02 | Pima | Arizona | 4019 | 145218 | 2736 |
1871956 | 1871956 | 2021-11-01 | Pima | Arizona | 4019 | 144959 | 2736 |
1868707 | 1868707 | 2021-10-31 | Pima | Arizona | 4019 | 144615 | 2736 |
1865458 | 1865458 | 2021-10-30 | Pima | Arizona | 4019 | 144130 | 2736 |
1862209 | 1862209 | 2021-10-29 | Pima | Arizona | 4019 | 143800 | 2733 |
1858960 | 1858960 | 2021-10-28 | Pima | Arizona | 4019 | 143208 | 2733 |
1855711 | 1855711 | 2021-10-27 | Pima | Arizona | 4019 | 142863 | 2730 |
1852462 | 1852462 | 2021-10-26 | Pima | Arizona | 4019 | 141921 | 2726 |
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);