ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 4021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174301 | 2174301 | 2022-02-02 | Pinal | Arizona | 4021 | 122455 | 1448 |
2171049 | 2171049 | 2022-02-01 | Pinal | Arizona | 4021 | 121934 | 1447 |
2167796 | 2167796 | 2022-01-31 | Pinal | Arizona | 4021 | 121256 | 1441 |
2164541 | 2164541 | 2022-01-30 | Pinal | Arizona | 4021 | 120459 | 1441 |
2161286 | 2161286 | 2022-01-29 | Pinal | Arizona | 4021 | 119365 | 1440 |
2158030 | 2158030 | 2022-01-28 | Pinal | Arizona | 4021 | 118081 | 1432 |
2154777 | 2154777 | 2022-01-27 | Pinal | Arizona | 4021 | 116789 | 1425 |
2151524 | 2151524 | 2022-01-26 | Pinal | Arizona | 4021 | 115779 | 1422 |
2148272 | 2148272 | 2022-01-25 | Pinal | Arizona | 4021 | 114642 | 1409 |
2145020 | 2145020 | 2022-01-24 | Pinal | Arizona | 4021 | 113414 | 1409 |
2141765 | 2141765 | 2022-01-23 | Pinal | Arizona | 4021 | 112183 | 1409 |
2138509 | 2138509 | 2022-01-22 | Pinal | Arizona | 4021 | 110866 | 1408 |
2135254 | 2135254 | 2022-01-21 | Pinal | Arizona | 4021 | 108340 | 1403 |
2132002 | 2132002 | 2022-01-20 | Pinal | Arizona | 4021 | 107368 | 1399 |
2128748 | 2128748 | 2022-01-19 | Pinal | Arizona | 4021 | 106380 | 1399 |
2125495 | 2125495 | 2022-01-18 | Pinal | Arizona | 4021 | 104898 | 1398 |
2122243 | 2122243 | 2022-01-17 | Pinal | Arizona | 4021 | 102823 | 1385 |
2118991 | 2118991 | 2022-01-16 | Pinal | Arizona | 4021 | 102326 | 1385 |
2115739 | 2115739 | 2022-01-15 | Pinal | Arizona | 4021 | 101392 | 1381 |
2112487 | 2112487 | 2022-01-14 | Pinal | Arizona | 4021 | 99389 | 1367 |
2109235 | 2109235 | 2022-01-13 | Pinal | Arizona | 4021 | 97878 | 1361 |
2105984 | 2105984 | 2022-01-12 | Pinal | Arizona | 4021 | 96738 | 1360 |
2102733 | 2102733 | 2022-01-11 | Pinal | Arizona | 4021 | 95010 | 1361 |
2099482 | 2099482 | 2022-01-10 | Pinal | Arizona | 4021 | 94335 | 1348 |
2096231 | 2096231 | 2022-01-09 | Pinal | Arizona | 4021 | 94189 | 1348 |
2092979 | 2092979 | 2022-01-08 | Pinal | Arizona | 4021 | 93541 | 1344 |
2089727 | 2089727 | 2022-01-07 | Pinal | Arizona | 4021 | 92729 | 1339 |
2086476 | 2086476 | 2022-01-06 | Pinal | Arizona | 4021 | 91800 | 1339 |
2083224 | 2083224 | 2022-01-05 | Pinal | Arizona | 4021 | 91535 | 1333 |
2079972 | 2079972 | 2022-01-04 | Pinal | Arizona | 4021 | 91021 | 1332 |
2076720 | 2076720 | 2022-01-03 | Pinal | Arizona | 4021 | 90389 | 1320 |
2073469 | 2073469 | 2022-01-02 | Pinal | Arizona | 4021 | 89691 | 1320 |
2070218 | 2070218 | 2022-01-01 | Pinal | Arizona | 4021 | 89312 | 1320 |
2066967 | 2066967 | 2021-12-31 | Pinal | Arizona | 4021 | 89280 | 1308 |
2063717 | 2063717 | 2021-12-30 | Pinal | Arizona | 4021 | 88597 | 1306 |
2060467 | 2060467 | 2021-12-29 | Pinal | Arizona | 4021 | 88354 | 1305 |
2057218 | 2057218 | 2021-12-28 | Pinal | Arizona | 4021 | 88173 | 1301 |
2053969 | 2053969 | 2021-12-27 | Pinal | Arizona | 4021 | 87931 | 1294 |
2050719 | 2050719 | 2021-12-26 | Pinal | Arizona | 4021 | 87705 | 1294 |
2047469 | 2047469 | 2021-12-25 | Pinal | Arizona | 4021 | 87501 | 1294 |
2044219 | 2044219 | 2021-12-24 | Pinal | Arizona | 4021 | 87384 | 1289 |
2040970 | 2040970 | 2021-12-23 | Pinal | Arizona | 4021 | 87172 | 1282 |
2037720 | 2037720 | 2021-12-22 | Pinal | Arizona | 4021 | 86770 | 1278 |
2034470 | 2034470 | 2021-12-21 | Pinal | Arizona | 4021 | 86472 | 1273 |
2031220 | 2031220 | 2021-12-20 | Pinal | Arizona | 4021 | 86345 | 1259 |
2027969 | 2027969 | 2021-12-19 | Pinal | Arizona | 4021 | 86291 | 1259 |
2024718 | 2024718 | 2021-12-18 | Pinal | Arizona | 4021 | 86270 | 1260 |
2021467 | 2021467 | 2021-12-17 | Pinal | Arizona | 4021 | 85942 | 1259 |
2018216 | 2018216 | 2021-12-16 | Pinal | Arizona | 4021 | 85709 | 1256 |
2014966 | 2014966 | 2021-12-15 | Pinal | Arizona | 4021 | 85571 | 1253 |
2011715 | 2011715 | 2021-12-14 | Pinal | Arizona | 4021 | 84980 | 1240 |
2008464 | 2008464 | 2021-12-13 | Pinal | Arizona | 4021 | 84692 | 1221 |
2005213 | 2005213 | 2021-12-12 | Pinal | Arizona | 4021 | 84682 | 1221 |
2001962 | 2001962 | 2021-12-11 | Pinal | Arizona | 4021 | 84661 | 1218 |
1998712 | 1998712 | 2021-12-10 | Pinal | Arizona | 4021 | 84210 | 1214 |
1995461 | 1995461 | 2021-12-09 | Pinal | Arizona | 4021 | 84130 | 1209 |
1992210 | 1992210 | 2021-12-08 | Pinal | Arizona | 4021 | 83861 | 1204 |
1988959 | 1988959 | 2021-12-07 | Pinal | Arizona | 4021 | 83382 | 1204 |
1985709 | 1985709 | 2021-12-06 | Pinal | Arizona | 4021 | 82910 | 1190 |
1982459 | 1982459 | 2021-12-05 | Pinal | Arizona | 4021 | 82907 | 1190 |
1979209 | 1979209 | 2021-12-04 | Pinal | Arizona | 4021 | 82884 | 1188 |
1975959 | 1975959 | 2021-12-03 | Pinal | Arizona | 4021 | 82423 | 1176 |
1972710 | 1972710 | 2021-12-02 | Pinal | Arizona | 4021 | 81996 | 1176 |
1969460 | 1969460 | 2021-12-01 | Pinal | Arizona | 4021 | 81466 | 1173 |
1966210 | 1966210 | 2021-11-30 | Pinal | Arizona | 4021 | 80703 | 1171 |
1962958 | 1962958 | 2021-11-29 | Pinal | Arizona | 4021 | 80399 | 1163 |
1959707 | 1959707 | 2021-11-28 | Pinal | Arizona | 4021 | 80395 | 1163 |
1956456 | 1956456 | 2021-11-27 | Pinal | Arizona | 4021 | 80383 | 1163 |
1953205 | 1953205 | 2021-11-26 | Pinal | Arizona | 4021 | 80383 | 1155 |
1949954 | 1949954 | 2021-11-25 | Pinal | Arizona | 4021 | 80354 | 1155 |
1946703 | 1946703 | 2021-11-24 | Pinal | Arizona | 4021 | 79985 | 1153 |
1943452 | 1943452 | 2021-11-23 | Pinal | Arizona | 4021 | 79470 | 1150 |
1940202 | 1940202 | 2021-11-22 | Pinal | Arizona | 4021 | 78978 | 1146 |
1936952 | 1936952 | 2021-11-21 | Pinal | Arizona | 4021 | 78971 | 1146 |
1933702 | 1933702 | 2021-11-20 | Pinal | Arizona | 4021 | 78951 | 1146 |
1930450 | 1930450 | 2021-11-19 | Pinal | Arizona | 4021 | 78568 | 1144 |
1927200 | 1927200 | 2021-11-18 | Pinal | Arizona | 4021 | 78275 | 1141 |
1923950 | 1923950 | 2021-11-17 | Pinal | Arizona | 4021 | 77895 | 1140 |
1920701 | 1920701 | 2021-11-16 | Pinal | Arizona | 4021 | 77467 | 1141 |
1917451 | 1917451 | 2021-11-15 | Pinal | Arizona | 4021 | 76977 | 1134 |
1914201 | 1914201 | 2021-11-14 | Pinal | Arizona | 4021 | 76973 | 1134 |
1910951 | 1910951 | 2021-11-13 | Pinal | Arizona | 4021 | 76843 | 1133 |
1907702 | 1907702 | 2021-11-12 | Pinal | Arizona | 4021 | 76398 | 1128 |
1904453 | 1904453 | 2021-11-11 | Pinal | Arizona | 4021 | 76260 | 1123 |
1901203 | 1901203 | 2021-11-10 | Pinal | Arizona | 4021 | 76035 | 1121 |
1897953 | 1897953 | 2021-11-09 | Pinal | Arizona | 4021 | 75889 | 1118 |
1894703 | 1894703 | 2021-11-08 | Pinal | Arizona | 4021 | 75293 | 1109 |
1891453 | 1891453 | 2021-11-07 | Pinal | Arizona | 4021 | 75289 | 1109 |
1888203 | 1888203 | 2021-11-06 | Pinal | Arizona | 4021 | 75259 | 1109 |
1884953 | 1884953 | 2021-11-05 | Pinal | Arizona | 4021 | 74997 | 1102 |
1881704 | 1881704 | 2021-11-04 | Pinal | Arizona | 4021 | 74734 | 1100 |
1878455 | 1878455 | 2021-11-03 | Pinal | Arizona | 4021 | 74434 | 1099 |
1875206 | 1875206 | 2021-11-02 | Pinal | Arizona | 4021 | 74286 | 1087 |
1871957 | 1871957 | 2021-11-01 | Pinal | Arizona | 4021 | 73791 | 1087 |
1868708 | 1868708 | 2021-10-31 | Pinal | Arizona | 4021 | 73784 | 1087 |
1865459 | 1865459 | 2021-10-30 | Pinal | Arizona | 4021 | 73731 | 1086 |
1862210 | 1862210 | 2021-10-29 | Pinal | Arizona | 4021 | 73511 | 1083 |
1858961 | 1858961 | 2021-10-28 | Pinal | Arizona | 4021 | 73331 | 1075 |
1855712 | 1855712 | 2021-10-27 | Pinal | Arizona | 4021 | 73073 | 1079 |
1852463 | 1852463 | 2021-10-26 | Pinal | Arizona | 4021 | 72609 | 1076 |
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);