ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Coconino" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174292 | 2174292 | 2022-02-02 | Coconino | Arizona | 4005 | 40854 | 441 |
2171040 | 2171040 | 2022-02-01 | Coconino | Arizona | 4005 | 40781 | 441 |
2167787 | 2167787 | 2022-01-31 | Coconino | Arizona | 4005 | 40683 | 438 |
2164532 | 2164532 | 2022-01-30 | Coconino | Arizona | 4005 | 40484 | 438 |
2161277 | 2161277 | 2022-01-29 | Coconino | Arizona | 4005 | 40196 | 438 |
2158021 | 2158021 | 2022-01-28 | Coconino | Arizona | 4005 | 39877 | 438 |
2154768 | 2154768 | 2022-01-27 | Coconino | Arizona | 4005 | 39543 | 435 |
2151515 | 2151515 | 2022-01-26 | Coconino | Arizona | 4005 | 39068 | 433 |
2148263 | 2148263 | 2022-01-25 | Coconino | Arizona | 4005 | 38323 | 433 |
2145011 | 2145011 | 2022-01-24 | Coconino | Arizona | 4005 | 37899 | 433 |
2141756 | 2141756 | 2022-01-23 | Coconino | Arizona | 4005 | 37760 | 433 |
2138500 | 2138500 | 2022-01-22 | Coconino | Arizona | 4005 | 37044 | 432 |
2135245 | 2135245 | 2022-01-21 | Coconino | Arizona | 4005 | 36646 | 430 |
2131993 | 2131993 | 2022-01-20 | Coconino | Arizona | 4005 | 36318 | 429 |
2128739 | 2128739 | 2022-01-19 | Coconino | Arizona | 4005 | 35545 | 428 |
2125486 | 2125486 | 2022-01-18 | Coconino | Arizona | 4005 | 35135 | 427 |
2122234 | 2122234 | 2022-01-17 | Coconino | Arizona | 4005 | 34969 | 426 |
2118982 | 2118982 | 2022-01-16 | Coconino | Arizona | 4005 | 34387 | 426 |
2115730 | 2115730 | 2022-01-15 | Coconino | Arizona | 4005 | 33873 | 426 |
2112478 | 2112478 | 2022-01-14 | Coconino | Arizona | 4005 | 33319 | 426 |
2109226 | 2109226 | 2022-01-13 | Coconino | Arizona | 4005 | 32490 | 423 |
2105975 | 2105975 | 2022-01-12 | Coconino | Arizona | 4005 | 31885 | 423 |
2102724 | 2102724 | 2022-01-11 | Coconino | Arizona | 4005 | 31240 | 422 |
2099473 | 2099473 | 2022-01-10 | Coconino | Arizona | 4005 | 30954 | 421 |
2096222 | 2096222 | 2022-01-09 | Coconino | Arizona | 4005 | 30807 | 421 |
2092970 | 2092970 | 2022-01-08 | Coconino | Arizona | 4005 | 30294 | 421 |
2089718 | 2089718 | 2022-01-07 | Coconino | Arizona | 4005 | 29888 | 420 |
2086467 | 2086467 | 2022-01-06 | Coconino | Arizona | 4005 | 29386 | 420 |
2083215 | 2083215 | 2022-01-05 | Coconino | Arizona | 4005 | 29116 | 420 |
2079963 | 2079963 | 2022-01-04 | Coconino | Arizona | 4005 | 28924 | 418 |
2076711 | 2076711 | 2022-01-03 | Coconino | Arizona | 4005 | 28731 | 416 |
2073460 | 2073460 | 2022-01-02 | Coconino | Arizona | 4005 | 28255 | 416 |
2070209 | 2070209 | 2022-01-01 | Coconino | Arizona | 4005 | 28256 | 416 |
2066958 | 2066958 | 2021-12-31 | Coconino | Arizona | 4005 | 28085 | 416 |
2063708 | 2063708 | 2021-12-30 | Coconino | Arizona | 4005 | 27717 | 416 |
2060458 | 2060458 | 2021-12-29 | Coconino | Arizona | 4005 | 27568 | 416 |
2057209 | 2057209 | 2021-12-28 | Coconino | Arizona | 4005 | 27472 | 416 |
2053960 | 2053960 | 2021-12-27 | Coconino | Arizona | 4005 | 27453 | 412 |
2050710 | 2050710 | 2021-12-26 | Coconino | Arizona | 4005 | 27131 | 412 |
2047460 | 2047460 | 2021-12-25 | Coconino | Arizona | 4005 | 27131 | 412 |
2044210 | 2044210 | 2021-12-24 | Coconino | Arizona | 4005 | 27108 | 411 |
2040961 | 2040961 | 2021-12-23 | Coconino | Arizona | 4005 | 26958 | 408 |
2037711 | 2037711 | 2021-12-22 | Coconino | Arizona | 4005 | 26862 | 407 |
2034461 | 2034461 | 2021-12-21 | Coconino | Arizona | 4005 | 26808 | 405 |
2031211 | 2031211 | 2021-12-20 | Coconino | Arizona | 4005 | 26750 | 404 |
2027960 | 2027960 | 2021-12-19 | Coconino | Arizona | 4005 | 26684 | 404 |
2024709 | 2024709 | 2021-12-18 | Coconino | Arizona | 4005 | 26596 | 404 |
2021458 | 2021458 | 2021-12-17 | Coconino | Arizona | 4005 | 26551 | 404 |
2018207 | 2018207 | 2021-12-16 | Coconino | Arizona | 4005 | 26480 | 400 |
2014957 | 2014957 | 2021-12-15 | Coconino | Arizona | 4005 | 26420 | 401 |
2011706 | 2011706 | 2021-12-14 | Coconino | Arizona | 4005 | 26387 | 400 |
2008455 | 2008455 | 2021-12-13 | Coconino | Arizona | 4005 | 26353 | 395 |
2005204 | 2005204 | 2021-12-12 | Coconino | Arizona | 4005 | 26321 | 395 |
2001953 | 2001953 | 2021-12-11 | Coconino | Arizona | 4005 | 26235 | 394 |
1998703 | 1998703 | 2021-12-10 | Coconino | Arizona | 4005 | 26167 | 394 |
1995452 | 1995452 | 2021-12-09 | Coconino | Arizona | 4005 | 26092 | 393 |
1992201 | 1992201 | 2021-12-08 | Coconino | Arizona | 4005 | 26020 | 393 |
1988950 | 1988950 | 2021-12-07 | Coconino | Arizona | 4005 | 26000 | 393 |
1985700 | 1985700 | 2021-12-06 | Coconino | Arizona | 4005 | 25949 | 390 |
1982450 | 1982450 | 2021-12-05 | Coconino | Arizona | 4005 | 25877 | 390 |
1979200 | 1979200 | 2021-12-04 | Coconino | Arizona | 4005 | 25783 | 390 |
1975950 | 1975950 | 2021-12-03 | Coconino | Arizona | 4005 | 25584 | 386 |
1972701 | 1972701 | 2021-12-02 | Coconino | Arizona | 4005 | 25463 | 386 |
1969451 | 1969451 | 2021-12-01 | Coconino | Arizona | 4005 | 25395 | 385 |
1966201 | 1966201 | 2021-11-30 | Coconino | Arizona | 4005 | 25351 | 384 |
1962949 | 1962949 | 2021-11-29 | Coconino | Arizona | 4005 | 25300 | 383 |
1959698 | 1959698 | 2021-11-28 | Coconino | Arizona | 4005 | 25268 | 383 |
1956447 | 1956447 | 2021-11-27 | Coconino | Arizona | 4005 | 25216 | 383 |
1953196 | 1953196 | 2021-11-26 | Coconino | Arizona | 4005 | 25129 | 383 |
1949945 | 1949945 | 2021-11-25 | Coconino | Arizona | 4005 | 25136 | 383 |
1946694 | 1946694 | 2021-11-24 | Coconino | Arizona | 4005 | 25077 | 382 |
1943443 | 1943443 | 2021-11-23 | Coconino | Arizona | 4005 | 25010 | 380 |
1940193 | 1940193 | 2021-11-22 | Coconino | Arizona | 4005 | 24970 | 379 |
1936943 | 1936943 | 2021-11-21 | Coconino | Arizona | 4005 | 24901 | 379 |
1933693 | 1933693 | 2021-11-20 | Coconino | Arizona | 4005 | 24840 | 378 |
1930441 | 1930441 | 2021-11-19 | Coconino | Arizona | 4005 | 24727 | 376 |
1927191 | 1927191 | 2021-11-18 | Coconino | Arizona | 4005 | 24617 | 375 |
1923941 | 1923941 | 2021-11-17 | Coconino | Arizona | 4005 | 24547 | 375 |
1920692 | 1920692 | 2021-11-16 | Coconino | Arizona | 4005 | 24478 | 374 |
1917442 | 1917442 | 2021-11-15 | Coconino | Arizona | 4005 | 24417 | 373 |
1914192 | 1914192 | 2021-11-14 | Coconino | Arizona | 4005 | 24367 | 373 |
1910942 | 1910942 | 2021-11-13 | Coconino | Arizona | 4005 | 24300 | 373 |
1907693 | 1907693 | 2021-11-12 | Coconino | Arizona | 4005 | 24130 | 372 |
1904444 | 1904444 | 2021-11-11 | Coconino | Arizona | 4005 | 24088 | 371 |
1901194 | 1901194 | 2021-11-10 | Coconino | Arizona | 4005 | 24003 | 371 |
1897944 | 1897944 | 2021-11-09 | Coconino | Arizona | 4005 | 23920 | 371 |
1894694 | 1894694 | 2021-11-08 | Coconino | Arizona | 4005 | 23774 | 369 |
1891444 | 1891444 | 2021-11-07 | Coconino | Arizona | 4005 | 23720 | 369 |
1888194 | 1888194 | 2021-11-06 | Coconino | Arizona | 4005 | 23667 | 369 |
1884944 | 1884944 | 2021-11-05 | Coconino | Arizona | 4005 | 23609 | 367 |
1881695 | 1881695 | 2021-11-04 | Coconino | Arizona | 4005 | 23533 | 365 |
1878446 | 1878446 | 2021-11-03 | Coconino | Arizona | 4005 | 23489 | 365 |
1875197 | 1875197 | 2021-11-02 | Coconino | Arizona | 4005 | 23420 | 361 |
1871948 | 1871948 | 2021-11-01 | Coconino | Arizona | 4005 | 23391 | 362 |
1868699 | 1868699 | 2021-10-31 | Coconino | Arizona | 4005 | 23335 | 362 |
1865450 | 1865450 | 2021-10-30 | Coconino | Arizona | 4005 | 23260 | 362 |
1862201 | 1862201 | 2021-10-29 | Coconino | Arizona | 4005 | 23206 | 361 |
1858952 | 1858952 | 2021-10-28 | Coconino | Arizona | 4005 | 23091 | 360 |
1855703 | 1855703 | 2021-10-27 | Coconino | Arizona | 4005 | 23026 | 361 |
1852454 | 1852454 | 2021-10-26 | Coconino | Arizona | 4005 | 22782 | 360 |
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);