ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Yavapai" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174304 | 2174304 | 2022-02-02 | Yavapai | Arizona | 4025 | 45182 | 1074 |
2171051 | 2171051 | 2022-02-01 | Yavapai | Arizona | 4025 | 44995 | 1072 |
2167798 | 2167798 | 2022-01-31 | Yavapai | Arizona | 4025 | 44894 | 1069 |
2164543 | 2164543 | 2022-01-30 | Yavapai | Arizona | 4025 | 44647 | 1069 |
2161288 | 2161288 | 2022-01-29 | Yavapai | Arizona | 4025 | 44337 | 1069 |
2158032 | 2158032 | 2022-01-28 | Yavapai | Arizona | 4025 | 43958 | 1060 |
2154779 | 2154779 | 2022-01-27 | Yavapai | Arizona | 4025 | 43582 | 1058 |
2151526 | 2151526 | 2022-01-26 | Yavapai | Arizona | 4025 | 43210 | 1050 |
2148274 | 2148274 | 2022-01-25 | Yavapai | Arizona | 4025 | 42749 | 1040 |
2145022 | 2145022 | 2022-01-24 | Yavapai | Arizona | 4025 | 42448 | 1040 |
2141767 | 2141767 | 2022-01-23 | Yavapai | Arizona | 4025 | 42269 | 1039 |
2138512 | 2138512 | 2022-01-22 | Yavapai | Arizona | 4025 | 41871 | 1034 |
2135256 | 2135256 | 2022-01-21 | Yavapai | Arizona | 4025 | 41515 | 1032 |
2132004 | 2132004 | 2022-01-20 | Yavapai | Arizona | 4025 | 41185 | 1027 |
2128751 | 2128751 | 2022-01-19 | Yavapai | Arizona | 4025 | 40736 | 1026 |
2125497 | 2125497 | 2022-01-18 | Yavapai | Arizona | 4025 | 40408 | 1020 |
2122245 | 2122245 | 2022-01-17 | Yavapai | Arizona | 4025 | 40145 | 1012 |
2118993 | 2118993 | 2022-01-16 | Yavapai | Arizona | 4025 | 39871 | 1011 |
2115741 | 2115741 | 2022-01-15 | Yavapai | Arizona | 4025 | 39530 | 1011 |
2112490 | 2112490 | 2022-01-14 | Yavapai | Arizona | 4025 | 39143 | 1008 |
2109238 | 2109238 | 2022-01-13 | Yavapai | Arizona | 4025 | 38885 | 1007 |
2105987 | 2105987 | 2022-01-12 | Yavapai | Arizona | 4025 | 38585 | 1007 |
2102736 | 2102736 | 2022-01-11 | Yavapai | Arizona | 4025 | 38275 | 1007 |
2099485 | 2099485 | 2022-01-10 | Yavapai | Arizona | 4025 | 38026 | 995 |
2096234 | 2096234 | 2022-01-09 | Yavapai | Arizona | 4025 | 37855 | 995 |
2092982 | 2092982 | 2022-01-08 | Yavapai | Arizona | 4025 | 37744 | 993 |
2089730 | 2089730 | 2022-01-07 | Yavapai | Arizona | 4025 | 37499 | 983 |
2086479 | 2086479 | 2022-01-06 | Yavapai | Arizona | 4025 | 37245 | 981 |
2083227 | 2083227 | 2022-01-05 | Yavapai | Arizona | 4025 | 37046 | 979 |
2079975 | 2079975 | 2022-01-04 | Yavapai | Arizona | 4025 | 36857 | 975 |
2076723 | 2076723 | 2022-01-03 | Yavapai | Arizona | 4025 | 36729 | 964 |
2073472 | 2073472 | 2022-01-02 | Yavapai | Arizona | 4025 | 36532 | 964 |
2070221 | 2070221 | 2022-01-01 | Yavapai | Arizona | 4025 | 36531 | 964 |
2066970 | 2066970 | 2021-12-31 | Yavapai | Arizona | 4025 | 36447 | 956 |
2063719 | 2063719 | 2021-12-30 | Yavapai | Arizona | 4025 | 36284 | 951 |
2060469 | 2060469 | 2021-12-29 | Yavapai | Arizona | 4025 | 36081 | 948 |
2057220 | 2057220 | 2021-12-28 | Yavapai | Arizona | 4025 | 35946 | 945 |
2053971 | 2053971 | 2021-12-27 | Yavapai | Arizona | 4025 | 35891 | 936 |
2050721 | 2050721 | 2021-12-26 | Yavapai | Arizona | 4025 | 35761 | 936 |
2047471 | 2047471 | 2021-12-25 | Yavapai | Arizona | 4025 | 35761 | 936 |
2044221 | 2044221 | 2021-12-24 | Yavapai | Arizona | 4025 | 35719 | 934 |
2040972 | 2040972 | 2021-12-23 | Yavapai | Arizona | 4025 | 35647 | 929 |
2037722 | 2037722 | 2021-12-22 | Yavapai | Arizona | 4025 | 35540 | 929 |
2034472 | 2034472 | 2021-12-21 | Yavapai | Arizona | 4025 | 35470 | 918 |
2031222 | 2031222 | 2021-12-20 | Yavapai | Arizona | 4025 | 35384 | 908 |
2027971 | 2027971 | 2021-12-19 | Yavapai | Arizona | 4025 | 35320 | 908 |
2024720 | 2024720 | 2021-12-18 | Yavapai | Arizona | 4025 | 35259 | 907 |
2021469 | 2021469 | 2021-12-17 | Yavapai | Arizona | 4025 | 35117 | 902 |
2018218 | 2018218 | 2021-12-16 | Yavapai | Arizona | 4025 | 34998 | 896 |
2014968 | 2014968 | 2021-12-15 | Yavapai | Arizona | 4025 | 34859 | 895 |
2011717 | 2011717 | 2021-12-14 | Yavapai | Arizona | 4025 | 34702 | 886 |
2008466 | 2008466 | 2021-12-13 | Yavapai | Arizona | 4025 | 34578 | 867 |
2005215 | 2005215 | 2021-12-12 | Yavapai | Arizona | 4025 | 34500 | 867 |
2001964 | 2001964 | 2021-12-11 | Yavapai | Arizona | 4025 | 34434 | 867 |
1998714 | 1998714 | 2021-12-10 | Yavapai | Arizona | 4025 | 34259 | 866 |
1995463 | 1995463 | 2021-12-09 | Yavapai | Arizona | 4025 | 34057 | 858 |
1992212 | 1992212 | 2021-12-08 | Yavapai | Arizona | 4025 | 33924 | 850 |
1988961 | 1988961 | 2021-12-07 | Yavapai | Arizona | 4025 | 33772 | 840 |
1985711 | 1985711 | 2021-12-06 | Yavapai | Arizona | 4025 | 33627 | 827 |
1982461 | 1982461 | 2021-12-05 | Yavapai | Arizona | 4025 | 33498 | 827 |
1979211 | 1979211 | 2021-12-04 | Yavapai | Arizona | 4025 | 33416 | 826 |
1975961 | 1975961 | 2021-12-03 | Yavapai | Arizona | 4025 | 33180 | 812 |
1972712 | 1972712 | 2021-12-02 | Yavapai | Arizona | 4025 | 32974 | 812 |
1969462 | 1969462 | 2021-12-01 | Yavapai | Arizona | 4025 | 32734 | 804 |
1966212 | 1966212 | 2021-11-30 | Yavapai | Arizona | 4025 | 32544 | 791 |
1962960 | 1962960 | 2021-11-29 | Yavapai | Arizona | 4025 | 32411 | 787 |
1959709 | 1959709 | 2021-11-28 | Yavapai | Arizona | 4025 | 32381 | 787 |
1956458 | 1956458 | 2021-11-27 | Yavapai | Arizona | 4025 | 32225 | 785 |
1953207 | 1953207 | 2021-11-26 | Yavapai | Arizona | 4025 | 32103 | 785 |
1949956 | 1949956 | 2021-11-25 | Yavapai | Arizona | 4025 | 32039 | 784 |
1946705 | 1946705 | 2021-11-24 | Yavapai | Arizona | 4025 | 31816 | 780 |
1943454 | 1943454 | 2021-11-23 | Yavapai | Arizona | 4025 | 31654 | 777 |
1940204 | 1940204 | 2021-11-22 | Yavapai | Arizona | 4025 | 31561 | 767 |
1936954 | 1936954 | 2021-11-21 | Yavapai | Arizona | 4025 | 31369 | 767 |
1933704 | 1933704 | 2021-11-20 | Yavapai | Arizona | 4025 | 31248 | 767 |
1930452 | 1930452 | 2021-11-19 | Yavapai | Arizona | 4025 | 31075 | 761 |
1927202 | 1927202 | 2021-11-18 | Yavapai | Arizona | 4025 | 30872 | 756 |
1923952 | 1923952 | 2021-11-17 | Yavapai | Arizona | 4025 | 30642 | 754 |
1920703 | 1920703 | 2021-11-16 | Yavapai | Arizona | 4025 | 30488 | 750 |
1917453 | 1917453 | 2021-11-15 | Yavapai | Arizona | 4025 | 30301 | 740 |
1914203 | 1914203 | 2021-11-14 | Yavapai | Arizona | 4025 | 30188 | 740 |
1910953 | 1910953 | 2021-11-13 | Yavapai | Arizona | 4025 | 30116 | 739 |
1907704 | 1907704 | 2021-11-12 | Yavapai | Arizona | 4025 | 29896 | 734 |
1904455 | 1904455 | 2021-11-11 | Yavapai | Arizona | 4025 | 29802 | 728 |
1901205 | 1901205 | 2021-11-10 | Yavapai | Arizona | 4025 | 29646 | 727 |
1897955 | 1897955 | 2021-11-09 | Yavapai | Arizona | 4025 | 29498 | 722 |
1894705 | 1894705 | 2021-11-08 | Yavapai | Arizona | 4025 | 29374 | 713 |
1891455 | 1891455 | 2021-11-07 | Yavapai | Arizona | 4025 | 29290 | 713 |
1888205 | 1888205 | 2021-11-06 | Yavapai | Arizona | 4025 | 29222 | 714 |
1884955 | 1884955 | 2021-11-05 | Yavapai | Arizona | 4025 | 29101 | 708 |
1881706 | 1881706 | 2021-11-04 | Yavapai | Arizona | 4025 | 28944 | 706 |
1878457 | 1878457 | 2021-11-03 | Yavapai | Arizona | 4025 | 28810 | 704 |
1875208 | 1875208 | 2021-11-02 | Yavapai | Arizona | 4025 | 28709 | 698 |
1871959 | 1871959 | 2021-11-01 | Yavapai | Arizona | 4025 | 28619 | 695 |
1868710 | 1868710 | 2021-10-31 | Yavapai | Arizona | 4025 | 28535 | 695 |
1865461 | 1865461 | 2021-10-30 | Yavapai | Arizona | 4025 | 28481 | 693 |
1862212 | 1862212 | 2021-10-29 | Yavapai | Arizona | 4025 | 28355 | 689 |
1858963 | 1858963 | 2021-10-28 | Yavapai | Arizona | 4025 | 28243 | 689 |
1855714 | 1855714 | 2021-10-27 | Yavapai | Arizona | 4025 | 28115 | 688 |
1852465 | 1852465 | 2021-10-26 | Yavapai | Arizona | 4025 | 27958 | 687 |
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);