ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 4013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174297 | 2174297 | 2022-02-02 | Maricopa | Arizona | 4013 | 1193786 | 14832 |
2171045 | 2171045 | 2022-02-01 | Maricopa | Arizona | 4013 | 1188443 | 14819 |
2167792 | 2167792 | 2022-01-31 | Maricopa | Arizona | 4013 | 1183959 | 14735 |
2164537 | 2164537 | 2022-01-30 | Maricopa | Arizona | 4013 | 1176820 | 14735 |
2161282 | 2161282 | 2022-01-29 | Maricopa | Arizona | 4013 | 1168101 | 14719 |
2158026 | 2158026 | 2022-01-28 | Maricopa | Arizona | 4013 | 1159574 | 14614 |
2154773 | 2154773 | 2022-01-27 | Maricopa | Arizona | 4013 | 1150653 | 14585 |
2151520 | 2151520 | 2022-01-26 | Maricopa | Arizona | 4013 | 1142432 | 14574 |
2148268 | 2148268 | 2022-01-25 | Maricopa | Arizona | 4013 | 1131309 | 14394 |
2145016 | 2145016 | 2022-01-24 | Maricopa | Arizona | 4013 | 1122599 | 14394 |
2141761 | 2141761 | 2022-01-23 | Maricopa | Arizona | 4013 | 1113529 | 14394 |
2138505 | 2138505 | 2022-01-22 | Maricopa | Arizona | 4013 | 1099621 | 14363 |
2135250 | 2135250 | 2022-01-21 | Maricopa | Arizona | 4013 | 1082411 | 14332 |
2131998 | 2131998 | 2022-01-20 | Maricopa | Arizona | 4013 | 1071176 | 14290 |
2128744 | 2128744 | 2022-01-19 | Maricopa | Arizona | 4013 | 1060695 | 14283 |
2125491 | 2125491 | 2022-01-18 | Maricopa | Arizona | 4013 | 1047617 | 14274 |
2122239 | 2122239 | 2022-01-17 | Maricopa | Arizona | 4013 | 1031971 | 14179 |
2118987 | 2118987 | 2022-01-16 | Maricopa | Arizona | 4013 | 1025184 | 14179 |
2115735 | 2115735 | 2022-01-15 | Maricopa | Arizona | 4013 | 1011221 | 14154 |
2112483 | 2112483 | 2022-01-14 | Maricopa | Arizona | 4013 | 995019 | 14097 |
2109231 | 2109231 | 2022-01-13 | Maricopa | Arizona | 4013 | 982065 | 14064 |
2105980 | 2105980 | 2022-01-12 | Maricopa | Arizona | 4013 | 969741 | 14064 |
2102729 | 2102729 | 2022-01-11 | Maricopa | Arizona | 4013 | 957760 | 14060 |
2099478 | 2099478 | 2022-01-10 | Maricopa | Arizona | 4013 | 947357 | 13952 |
2096227 | 2096227 | 2022-01-09 | Maricopa | Arizona | 4013 | 937211 | 13952 |
2092975 | 2092975 | 2022-01-08 | Maricopa | Arizona | 4013 | 926432 | 13914 |
2089723 | 2089723 | 2022-01-07 | Maricopa | Arizona | 4013 | 914958 | 13867 |
2086472 | 2086472 | 2022-01-06 | Maricopa | Arizona | 4013 | 904822 | 13849 |
2083220 | 2083220 | 2022-01-05 | Maricopa | Arizona | 4013 | 897529 | 13849 |
2079968 | 2079968 | 2022-01-04 | Maricopa | Arizona | 4013 | 892504 | 13813 |
2076716 | 2076716 | 2022-01-03 | Maricopa | Arizona | 4013 | 887308 | 13737 |
2073465 | 2073465 | 2022-01-02 | Maricopa | Arizona | 4013 | 877144 | 13737 |
2070214 | 2070214 | 2022-01-01 | Maricopa | Arizona | 4013 | 877142 | 13737 |
2066963 | 2066963 | 2021-12-31 | Maricopa | Arizona | 4013 | 870996 | 13675 |
2063713 | 2063713 | 2021-12-30 | Maricopa | Arizona | 4013 | 866014 | 13670 |
2060463 | 2060463 | 2021-12-29 | Maricopa | Arizona | 4013 | 862457 | 13641 |
2057214 | 2057214 | 2021-12-28 | Maricopa | Arizona | 4013 | 860428 | 13629 |
2053965 | 2053965 | 2021-12-27 | Maricopa | Arizona | 4013 | 859062 | 13552 |
2050715 | 2050715 | 2021-12-26 | Maricopa | Arizona | 4013 | 853298 | 13552 |
2047465 | 2047465 | 2021-12-25 | Maricopa | Arizona | 4013 | 853296 | 13552 |
2044215 | 2044215 | 2021-12-24 | Maricopa | Arizona | 4013 | 850653 | 13519 |
2040966 | 2040966 | 2021-12-23 | Maricopa | Arizona | 4013 | 848132 | 13492 |
2037716 | 2037716 | 2021-12-22 | Maricopa | Arizona | 4013 | 846298 | 13482 |
2034466 | 2034466 | 2021-12-21 | Maricopa | Arizona | 4013 | 844498 | 13457 |
2031216 | 2031216 | 2021-12-20 | Maricopa | Arizona | 4013 | 842993 | 13343 |
2027965 | 2027965 | 2021-12-19 | Maricopa | Arizona | 4013 | 841448 | 13343 |
2024714 | 2024714 | 2021-12-18 | Maricopa | Arizona | 4013 | 839480 | 13341 |
2021463 | 2021463 | 2021-12-17 | Maricopa | Arizona | 4013 | 837314 | 13324 |
2018212 | 2018212 | 2021-12-16 | Maricopa | Arizona | 4013 | 834891 | 13257 |
2014962 | 2014962 | 2021-12-15 | Maricopa | Arizona | 4013 | 833090 | 13251 |
2011711 | 2011711 | 2021-12-14 | Maricopa | Arizona | 4013 | 831365 | 13222 |
2008460 | 2008460 | 2021-12-13 | Maricopa | Arizona | 4013 | 830216 | 13130 |
2005209 | 2005209 | 2021-12-12 | Maricopa | Arizona | 4013 | 828549 | 13130 |
2001958 | 2001958 | 2021-12-11 | Maricopa | Arizona | 4013 | 826257 | 13120 |
1998708 | 1998708 | 2021-12-10 | Maricopa | Arizona | 4013 | 824044 | 13085 |
1995457 | 1995457 | 2021-12-09 | Maricopa | Arizona | 4013 | 821487 | 13043 |
1992206 | 1992206 | 2021-12-08 | Maricopa | Arizona | 4013 | 819354 | 12999 |
1988955 | 1988955 | 2021-12-07 | Maricopa | Arizona | 4013 | 817303 | 12999 |
1985705 | 1985705 | 2021-12-06 | Maricopa | Arizona | 4013 | 815557 | 12920 |
1982455 | 1982455 | 2021-12-05 | Maricopa | Arizona | 4013 | 813527 | 12920 |
1979205 | 1979205 | 2021-12-04 | Maricopa | Arizona | 4013 | 810904 | 12895 |
1975955 | 1975955 | 2021-12-03 | Maricopa | Arizona | 4013 | 807353 | 12819 |
1972706 | 1972706 | 2021-12-02 | Maricopa | Arizona | 4013 | 804278 | 12814 |
1969456 | 1969456 | 2021-12-01 | Maricopa | Arizona | 4013 | 802164 | 12801 |
1966206 | 1966206 | 2021-11-30 | Maricopa | Arizona | 4013 | 800696 | 12782 |
1962954 | 1962954 | 2021-11-29 | Maricopa | Arizona | 4013 | 798982 | 12742 |
1959703 | 1959703 | 2021-11-28 | Maricopa | Arizona | 4013 | 797681 | 12742 |
1956452 | 1956452 | 2021-11-27 | Maricopa | Arizona | 4013 | 796091 | 12740 |
1953201 | 1953201 | 2021-11-26 | Maricopa | Arizona | 4013 | 793788 | 12713 |
1949950 | 1949950 | 2021-11-25 | Maricopa | Arizona | 4013 | 791573 | 12713 |
1946699 | 1946699 | 2021-11-24 | Maricopa | Arizona | 4013 | 789760 | 12671 |
1943448 | 1943448 | 2021-11-23 | Maricopa | Arizona | 4013 | 787377 | 12662 |
1940198 | 1940198 | 2021-11-22 | Maricopa | Arizona | 4013 | 785777 | 12603 |
1936948 | 1936948 | 2021-11-21 | Maricopa | Arizona | 4013 | 783578 | 12603 |
1933698 | 1933698 | 2021-11-20 | Maricopa | Arizona | 4013 | 781147 | 12603 |
1930446 | 1930446 | 2021-11-19 | Maricopa | Arizona | 4013 | 778107 | 12580 |
1927196 | 1927196 | 2021-11-18 | Maricopa | Arizona | 4013 | 775124 | 12536 |
1923946 | 1923946 | 2021-11-17 | Maricopa | Arizona | 4013 | 772929 | 12498 |
1920697 | 1920697 | 2021-11-16 | Maricopa | Arizona | 4013 | 771037 | 12490 |
1917447 | 1917447 | 2021-11-15 | Maricopa | Arizona | 4013 | 769375 | 12459 |
1914197 | 1914197 | 2021-11-14 | Maricopa | Arizona | 4013 | 767759 | 12459 |
1910947 | 1910947 | 2021-11-13 | Maricopa | Arizona | 4013 | 765678 | 12459 |
1907698 | 1907698 | 2021-11-12 | Maricopa | Arizona | 4013 | 763698 | 12439 |
1904449 | 1904449 | 2021-11-11 | Maricopa | Arizona | 4013 | 760613 | 12419 |
1901199 | 1901199 | 2021-11-10 | Maricopa | Arizona | 4013 | 758552 | 12397 |
1897949 | 1897949 | 2021-11-09 | Maricopa | Arizona | 4013 | 756169 | 12367 |
1894699 | 1894699 | 2021-11-08 | Maricopa | Arizona | 4013 | 754747 | 12352 |
1891449 | 1891449 | 2021-11-07 | Maricopa | Arizona | 4013 | 752986 | 12352 |
1888199 | 1888199 | 2021-11-06 | Maricopa | Arizona | 4013 | 750885 | 12351 |
1884949 | 1884949 | 2021-11-05 | Maricopa | Arizona | 4013 | 748703 | 12318 |
1881700 | 1881700 | 2021-11-04 | Maricopa | Arizona | 4013 | 746380 | 12286 |
1878451 | 1878451 | 2021-11-03 | Maricopa | Arizona | 4013 | 744385 | 12277 |
1875202 | 1875202 | 2021-11-02 | Maricopa | Arizona | 4013 | 743175 | 12223 |
1871953 | 1871953 | 2021-11-01 | Maricopa | Arizona | 4013 | 741940 | 12230 |
1868704 | 1868704 | 2021-10-31 | Maricopa | Arizona | 4013 | 740666 | 12230 |
1865455 | 1865455 | 2021-10-30 | Maricopa | Arizona | 4013 | 738763 | 12232 |
1862206 | 1862206 | 2021-10-29 | Maricopa | Arizona | 4013 | 737103 | 12197 |
1858957 | 1858957 | 2021-10-28 | Maricopa | Arizona | 4013 | 734868 | 12147 |
1855708 | 1855708 | 2021-10-27 | Maricopa | Arizona | 4013 | 733316 | 12160 |
1852459 | 1852459 | 2021-10-26 | Maricopa | Arizona | 4013 | 729597 | 12092 |
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);