ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 4027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174305 | 2174305 | 2022-02-02 | Yuma | Arizona | 4027 | 59654 | 1060 |
2171052 | 2171052 | 2022-02-01 | Yuma | Arizona | 4027 | 59509 | 1060 |
2167799 | 2167799 | 2022-01-31 | Yuma | Arizona | 4027 | 59258 | 1051 |
2164544 | 2164544 | 2022-01-30 | Yuma | Arizona | 4027 | 58723 | 1051 |
2161289 | 2161289 | 2022-01-29 | Yuma | Arizona | 4027 | 58369 | 1051 |
2158033 | 2158033 | 2022-01-28 | Yuma | Arizona | 4027 | 57792 | 1046 |
2154780 | 2154780 | 2022-01-27 | Yuma | Arizona | 4027 | 57238 | 1042 |
2151527 | 2151527 | 2022-01-26 | Yuma | Arizona | 4027 | 56639 | 1043 |
2148275 | 2148275 | 2022-01-25 | Yuma | Arizona | 4027 | 56107 | 1028 |
2145023 | 2145023 | 2022-01-24 | Yuma | Arizona | 4027 | 55820 | 1028 |
2141768 | 2141768 | 2022-01-23 | Yuma | Arizona | 4027 | 55176 | 1028 |
2138513 | 2138513 | 2022-01-22 | Yuma | Arizona | 4027 | 54419 | 1024 |
2135257 | 2135257 | 2022-01-21 | Yuma | Arizona | 4027 | 53601 | 1024 |
2132005 | 2132005 | 2022-01-20 | Yuma | Arizona | 4027 | 52968 | 1023 |
2128752 | 2128752 | 2022-01-19 | Yuma | Arizona | 4027 | 52275 | 1022 |
2125498 | 2125498 | 2022-01-18 | Yuma | Arizona | 4027 | 51583 | 1022 |
2122246 | 2122246 | 2022-01-17 | Yuma | Arizona | 4027 | 50582 | 1016 |
2118994 | 2118994 | 2022-01-16 | Yuma | Arizona | 4027 | 49891 | 1016 |
2115742 | 2115742 | 2022-01-15 | Yuma | Arizona | 4027 | 49104 | 1017 |
2112491 | 2112491 | 2022-01-14 | Yuma | Arizona | 4027 | 48145 | 1013 |
2109239 | 2109239 | 2022-01-13 | Yuma | Arizona | 4027 | 47851 | 1012 |
2105988 | 2105988 | 2022-01-12 | Yuma | Arizona | 4027 | 47434 | 1010 |
2102737 | 2102737 | 2022-01-11 | Yuma | Arizona | 4027 | 46958 | 1010 |
2099486 | 2099486 | 2022-01-10 | Yuma | Arizona | 4027 | 46633 | 998 |
2096235 | 2096235 | 2022-01-09 | Yuma | Arizona | 4027 | 46341 | 998 |
2092983 | 2092983 | 2022-01-08 | Yuma | Arizona | 4027 | 46043 | 995 |
2089731 | 2089731 | 2022-01-07 | Yuma | Arizona | 4027 | 45723 | 991 |
2086480 | 2086480 | 2022-01-06 | Yuma | Arizona | 4027 | 45489 | 989 |
2083228 | 2083228 | 2022-01-05 | Yuma | Arizona | 4027 | 45302 | 987 |
2079976 | 2079976 | 2022-01-04 | Yuma | Arizona | 4027 | 45229 | 987 |
2076724 | 2076724 | 2022-01-03 | Yuma | Arizona | 4027 | 45048 | 985 |
2073473 | 2073473 | 2022-01-02 | Yuma | Arizona | 4027 | 44644 | 985 |
2070222 | 2070222 | 2022-01-01 | Yuma | Arizona | 4027 | 44644 | 985 |
2066971 | 2066971 | 2021-12-31 | Yuma | Arizona | 4027 | 44378 | 982 |
2063720 | 2063720 | 2021-12-30 | Yuma | Arizona | 4027 | 44260 | 982 |
2060470 | 2060470 | 2021-12-29 | Yuma | Arizona | 4027 | 44176 | 982 |
2057221 | 2057221 | 2021-12-28 | Yuma | Arizona | 4027 | 44127 | 979 |
2053972 | 2053972 | 2021-12-27 | Yuma | Arizona | 4027 | 44105 | 969 |
2050722 | 2050722 | 2021-12-26 | Yuma | Arizona | 4027 | 44013 | 969 |
2047472 | 2047472 | 2021-12-25 | Yuma | Arizona | 4027 | 43992 | 970 |
2044222 | 2044222 | 2021-12-24 | Yuma | Arizona | 4027 | 43938 | 966 |
2040973 | 2040973 | 2021-12-23 | Yuma | Arizona | 4027 | 43873 | 965 |
2037723 | 2037723 | 2021-12-22 | Yuma | Arizona | 4027 | 43746 | 964 |
2034473 | 2034473 | 2021-12-21 | Yuma | Arizona | 4027 | 43718 | 962 |
2031223 | 2031223 | 2021-12-20 | Yuma | Arizona | 4027 | 43694 | 954 |
2027972 | 2027972 | 2021-12-19 | Yuma | Arizona | 4027 | 43663 | 954 |
2024721 | 2024721 | 2021-12-18 | Yuma | Arizona | 4027 | 43628 | 954 |
2021470 | 2021470 | 2021-12-17 | Yuma | Arizona | 4027 | 43571 | 954 |
2018219 | 2018219 | 2021-12-16 | Yuma | Arizona | 4027 | 43518 | 949 |
2014969 | 2014969 | 2021-12-15 | Yuma | Arizona | 4027 | 43487 | 948 |
2011718 | 2011718 | 2021-12-14 | Yuma | Arizona | 4027 | 43445 | 945 |
2008467 | 2008467 | 2021-12-13 | Yuma | Arizona | 4027 | 43424 | 942 |
2005216 | 2005216 | 2021-12-12 | Yuma | Arizona | 4027 | 43393 | 942 |
2001965 | 2001965 | 2021-12-11 | Yuma | Arizona | 4027 | 43291 | 942 |
1998715 | 1998715 | 2021-12-10 | Yuma | Arizona | 4027 | 43233 | 941 |
1995464 | 1995464 | 2021-12-09 | Yuma | Arizona | 4027 | 43184 | 939 |
1992213 | 1992213 | 2021-12-08 | Yuma | Arizona | 4027 | 43138 | 938 |
1988962 | 1988962 | 2021-12-07 | Yuma | Arizona | 4027 | 43107 | 938 |
1985712 | 1985712 | 2021-12-06 | Yuma | Arizona | 4027 | 43083 | 931 |
1982462 | 1982462 | 2021-12-05 | Yuma | Arizona | 4027 | 43033 | 931 |
1979212 | 1979212 | 2021-12-04 | Yuma | Arizona | 4027 | 42987 | 935 |
1975962 | 1975962 | 2021-12-03 | Yuma | Arizona | 4027 | 42897 | 930 |
1972713 | 1972713 | 2021-12-02 | Yuma | Arizona | 4027 | 42804 | 930 |
1969463 | 1969463 | 2021-12-01 | Yuma | Arizona | 4027 | 42770 | 928 |
1966213 | 1966213 | 2021-11-30 | Yuma | Arizona | 4027 | 42742 | 927 |
1962961 | 1962961 | 2021-11-29 | Yuma | Arizona | 4027 | 42724 | 927 |
1959710 | 1959710 | 2021-11-28 | Yuma | Arizona | 4027 | 42712 | 927 |
1956459 | 1956459 | 2021-11-27 | Yuma | Arizona | 4027 | 42691 | 927 |
1953208 | 1953208 | 2021-11-26 | Yuma | Arizona | 4027 | 42646 | 926 |
1949957 | 1949957 | 2021-11-25 | Yuma | Arizona | 4027 | 42586 | 926 |
1946706 | 1946706 | 2021-11-24 | Yuma | Arizona | 4027 | 42555 | 926 |
1943455 | 1943455 | 2021-11-23 | Yuma | Arizona | 4027 | 42529 | 925 |
1940205 | 1940205 | 2021-11-22 | Yuma | Arizona | 4027 | 42508 | 923 |
1936955 | 1936955 | 2021-11-21 | Yuma | Arizona | 4027 | 42469 | 923 |
1933705 | 1933705 | 2021-11-20 | Yuma | Arizona | 4027 | 42427 | 923 |
1930453 | 1930453 | 2021-11-19 | Yuma | Arizona | 4027 | 42370 | 923 |
1927203 | 1927203 | 2021-11-18 | Yuma | Arizona | 4027 | 42296 | 922 |
1923953 | 1923953 | 2021-11-17 | Yuma | Arizona | 4027 | 42246 | 922 |
1920704 | 1920704 | 2021-11-16 | Yuma | Arizona | 4027 | 42220 | 923 |
1917454 | 1917454 | 2021-11-15 | Yuma | Arizona | 4027 | 42200 | 921 |
1914204 | 1914204 | 2021-11-14 | Yuma | Arizona | 4027 | 42169 | 921 |
1910954 | 1910954 | 2021-11-13 | Yuma | Arizona | 4027 | 42127 | 921 |
1907705 | 1907705 | 2021-11-12 | Yuma | Arizona | 4027 | 42083 | 920 |
1904456 | 1904456 | 2021-11-11 | Yuma | Arizona | 4027 | 42029 | 919 |
1901206 | 1901206 | 2021-11-10 | Yuma | Arizona | 4027 | 41995 | 918 |
1897956 | 1897956 | 2021-11-09 | Yuma | Arizona | 4027 | 41975 | 918 |
1894706 | 1894706 | 2021-11-08 | Yuma | Arizona | 4027 | 41958 | 914 |
1891456 | 1891456 | 2021-11-07 | Yuma | Arizona | 4027 | 41924 | 914 |
1888206 | 1888206 | 2021-11-06 | Yuma | Arizona | 4027 | 41881 | 914 |
1884956 | 1884956 | 2021-11-05 | Yuma | Arizona | 4027 | 41843 | 912 |
1881707 | 1881707 | 2021-11-04 | Yuma | Arizona | 4027 | 41802 | 911 |
1878458 | 1878458 | 2021-11-03 | Yuma | Arizona | 4027 | 41725 | 911 |
1875209 | 1875209 | 2021-11-02 | Yuma | Arizona | 4027 | 41707 | 909 |
1871960 | 1871960 | 2021-11-01 | Yuma | Arizona | 4027 | 41680 | 909 |
1868711 | 1868711 | 2021-10-31 | Yuma | Arizona | 4027 | 41645 | 909 |
1865462 | 1865462 | 2021-10-30 | Yuma | Arizona | 4027 | 41588 | 909 |
1862213 | 1862213 | 2021-10-29 | Yuma | Arizona | 4027 | 41554 | 909 |
1858964 | 1858964 | 2021-10-28 | Yuma | Arizona | 4027 | 41498 | 908 |
1855715 | 1855715 | 2021-10-27 | Yuma | Arizona | 4027 | 41466 | 908 |
1852466 | 1852466 | 2021-10-26 | Yuma | Arizona | 4027 | 41378 | 908 |
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);