ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "McKinley" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176027 | 2176027 | 2022-02-02 | McKinley | New Mexico | 35031 | 24145 | 556 |
2172774 | 2172774 | 2022-02-01 | McKinley | New Mexico | 35031 | 24007 | 555 |
2169521 | 2169521 | 2022-01-31 | McKinley | New Mexico | 35031 | 23876 | 553 |
2166266 | 2166266 | 2022-01-30 | McKinley | New Mexico | 35031 | 23428 | 551 |
2163011 | 2163011 | 2022-01-29 | McKinley | New Mexico | 35031 | 23428 | 551 |
2159756 | 2159756 | 2022-01-28 | McKinley | New Mexico | 35031 | 23428 | 551 |
2156502 | 2156502 | 2022-01-27 | McKinley | New Mexico | 35031 | 23201 | 551 |
2153249 | 2153249 | 2022-01-26 | McKinley | New Mexico | 35031 | 22904 | 551 |
2149997 | 2149997 | 2022-01-25 | McKinley | New Mexico | 35031 | 22633 | 547 |
2146745 | 2146745 | 2022-01-24 | McKinley | New Mexico | 35031 | 22461 | 547 |
2143490 | 2143490 | 2022-01-23 | McKinley | New Mexico | 35031 | 21569 | 545 |
2140235 | 2140235 | 2022-01-22 | McKinley | New Mexico | 35031 | 21569 | 545 |
2136979 | 2136979 | 2022-01-21 | McKinley | New Mexico | 35031 | 21569 | 545 |
2133727 | 2133727 | 2022-01-20 | McKinley | New Mexico | 35031 | 21260 | 544 |
2130474 | 2130474 | 2022-01-19 | McKinley | New Mexico | 35031 | 21027 | 543 |
2127220 | 2127220 | 2022-01-18 | McKinley | New Mexico | 35031 | 20761 | 543 |
2123968 | 2123968 | 2022-01-17 | McKinley | New Mexico | 35031 | 19773 | 543 |
2120716 | 2120716 | 2022-01-16 | McKinley | New Mexico | 35031 | 19773 | 543 |
2117464 | 2117464 | 2022-01-15 | McKinley | New Mexico | 35031 | 19773 | 543 |
2114213 | 2114213 | 2022-01-14 | McKinley | New Mexico | 35031 | 19773 | 543 |
2110961 | 2110961 | 2022-01-13 | McKinley | New Mexico | 35031 | 19496 | 542 |
2107710 | 2107710 | 2022-01-12 | McKinley | New Mexico | 35031 | 19250 | 540 |
2104459 | 2104459 | 2022-01-11 | McKinley | New Mexico | 35031 | 18996 | 540 |
2101208 | 2101208 | 2022-01-10 | McKinley | New Mexico | 35031 | 18854 | 537 |
2097957 | 2097957 | 2022-01-09 | McKinley | New Mexico | 35031 | 18340 | 536 |
2094705 | 2094705 | 2022-01-08 | McKinley | New Mexico | 35031 | 18340 | 536 |
2091453 | 2091453 | 2022-01-07 | McKinley | New Mexico | 35031 | 18340 | 536 |
2088202 | 2088202 | 2022-01-06 | McKinley | New Mexico | 35031 | 18136 | 536 |
2084950 | 2084950 | 2022-01-05 | McKinley | New Mexico | 35031 | 17952 | 536 |
2081698 | 2081698 | 2022-01-04 | McKinley | New Mexico | 35031 | 17778 | 535 |
2078446 | 2078446 | 2022-01-03 | McKinley | New Mexico | 35031 | 17732 | 535 |
2075195 | 2075195 | 2022-01-02 | McKinley | New Mexico | 35031 | 17533 | 535 |
2071944 | 2071944 | 2022-01-01 | McKinley | New Mexico | 35031 | 17533 | 535 |
2068693 | 2068693 | 2021-12-31 | McKinley | New Mexico | 35031 | 17533 | 535 |
2065442 | 2065442 | 2021-12-30 | McKinley | New Mexico | 35031 | 17533 | 535 |
2062192 | 2062192 | 2021-12-29 | McKinley | New Mexico | 35031 | 17490 | 535 |
2058943 | 2058943 | 2021-12-28 | McKinley | New Mexico | 35031 | 17449 | 535 |
2055694 | 2055694 | 2021-12-27 | McKinley | New Mexico | 35031 | 17439 | 535 |
2052444 | 2052444 | 2021-12-26 | McKinley | New Mexico | 35031 | 17383 | 535 |
2049194 | 2049194 | 2021-12-25 | McKinley | New Mexico | 35031 | 17383 | 535 |
2045944 | 2045944 | 2021-12-24 | McKinley | New Mexico | 35031 | 17383 | 535 |
2042694 | 2042694 | 2021-12-23 | McKinley | New Mexico | 35031 | 17383 | 535 |
2039445 | 2039445 | 2021-12-22 | McKinley | New Mexico | 35031 | 17362 | 534 |
2036195 | 2036195 | 2021-12-21 | McKinley | New Mexico | 35031 | 17331 | 534 |
2032945 | 2032945 | 2021-12-20 | McKinley | New Mexico | 35031 | 17321 | 533 |
2029694 | 2029694 | 2021-12-19 | McKinley | New Mexico | 35031 | 17272 | 532 |
2026443 | 2026443 | 2021-12-18 | McKinley | New Mexico | 35031 | 17272 | 532 |
2023192 | 2023192 | 2021-12-17 | McKinley | New Mexico | 35031 | 17272 | 532 |
2019941 | 2019941 | 2021-12-16 | McKinley | New Mexico | 35031 | 17255 | 532 |
2016691 | 2016691 | 2021-12-15 | McKinley | New Mexico | 35031 | 17233 | 529 |
2013440 | 2013440 | 2021-12-14 | McKinley | New Mexico | 35031 | 17211 | 529 |
2010189 | 2010189 | 2021-12-13 | McKinley | New Mexico | 35031 | 17194 | 529 |
2006938 | 2006938 | 2021-12-12 | McKinley | New Mexico | 35031 | 17149 | 529 |
2003687 | 2003687 | 2021-12-11 | McKinley | New Mexico | 35031 | 17149 | 529 |
2000437 | 2000437 | 2021-12-10 | McKinley | New Mexico | 35031 | 17149 | 529 |
1997186 | 1997186 | 2021-12-09 | McKinley | New Mexico | 35031 | 17113 | 529 |
1993935 | 1993935 | 2021-12-08 | McKinley | New Mexico | 35031 | 17076 | 526 |
1990684 | 1990684 | 2021-12-07 | McKinley | New Mexico | 35031 | 17034 | 525 |
1987434 | 1987434 | 2021-12-06 | McKinley | New Mexico | 35031 | 17014 | 525 |
1984184 | 1984184 | 2021-12-05 | McKinley | New Mexico | 35031 | 16914 | 525 |
1980934 | 1980934 | 2021-12-04 | McKinley | New Mexico | 35031 | 16914 | 525 |
1977684 | 1977684 | 2021-12-03 | McKinley | New Mexico | 35031 | 16914 | 525 |
1974434 | 1974434 | 2021-12-02 | McKinley | New Mexico | 35031 | 16858 | 525 |
1971185 | 1971185 | 2021-12-01 | McKinley | New Mexico | 35031 | 16791 | 525 |
1967935 | 1967935 | 2021-11-30 | McKinley | New Mexico | 35031 | 16723 | 524 |
1964683 | 1964683 | 2021-11-29 | McKinley | New Mexico | 35031 | 16693 | 524 |
1961432 | 1961432 | 2021-11-28 | McKinley | New Mexico | 35031 | 16517 | 521 |
1958181 | 1958181 | 2021-11-27 | McKinley | New Mexico | 35031 | 16517 | 521 |
1954930 | 1954930 | 2021-11-26 | McKinley | New Mexico | 35031 | 16517 | 521 |
1951679 | 1951679 | 2021-11-25 | McKinley | New Mexico | 35031 | 16517 | 521 |
1948428 | 1948428 | 2021-11-24 | McKinley | New Mexico | 35031 | 16517 | 521 |
1945177 | 1945177 | 2021-11-23 | McKinley | New Mexico | 35031 | 16436 | 521 |
1941926 | 1941926 | 2021-11-22 | McKinley | New Mexico | 35031 | 16414 | 520 |
1938676 | 1938676 | 2021-11-21 | McKinley | New Mexico | 35031 | 16285 | 520 |
1935426 | 1935426 | 2021-11-20 | McKinley | New Mexico | 35031 | 16285 | 520 |
1932176 | 1932176 | 2021-11-19 | McKinley | New Mexico | 35031 | 16285 | 520 |
1928925 | 1928925 | 2021-11-18 | McKinley | New Mexico | 35031 | 16226 | 520 |
1925675 | 1925675 | 2021-11-17 | McKinley | New Mexico | 35031 | 16154 | 519 |
1922426 | 1922426 | 2021-11-16 | McKinley | New Mexico | 35031 | 16052 | 519 |
1919176 | 1919176 | 2021-11-15 | McKinley | New Mexico | 35031 | 16012 | 518 |
1915926 | 1915926 | 2021-11-14 | McKinley | New Mexico | 35031 | 15895 | 516 |
1912676 | 1912676 | 2021-11-13 | McKinley | New Mexico | 35031 | 15895 | 516 |
1909426 | 1909426 | 2021-11-12 | McKinley | New Mexico | 35031 | 15895 | 516 |
1906177 | 1906177 | 2021-11-11 | McKinley | New Mexico | 35031 | 15743 | 515 |
1902928 | 1902928 | 2021-11-10 | McKinley | New Mexico | 35031 | 15743 | 515 |
1899678 | 1899678 | 2021-11-09 | McKinley | New Mexico | 35031 | 15674 | 515 |
1896428 | 1896428 | 2021-11-08 | McKinley | New Mexico | 35031 | 15614 | 515 |
1893178 | 1893178 | 2021-11-07 | McKinley | New Mexico | 35031 | 15476 | 514 |
1889928 | 1889928 | 2021-11-06 | McKinley | New Mexico | 35031 | 15476 | 514 |
1886678 | 1886678 | 2021-11-05 | McKinley | New Mexico | 35031 | 15476 | 514 |
1883429 | 1883429 | 2021-11-04 | McKinley | New Mexico | 35031 | 15424 | 514 |
1880180 | 1880180 | 2021-11-03 | McKinley | New Mexico | 35031 | 15345 | 513 |
1876931 | 1876931 | 2021-11-02 | McKinley | New Mexico | 35031 | 15268 | 512 |
1873682 | 1873682 | 2021-11-01 | McKinley | New Mexico | 35031 | 15224 | 508 |
1870433 | 1870433 | 2021-10-31 | McKinley | New Mexico | 35031 | 15089 | 507 |
1867184 | 1867184 | 2021-10-30 | McKinley | New Mexico | 35031 | 15089 | 507 |
1863935 | 1863935 | 2021-10-29 | McKinley | New Mexico | 35031 | 15089 | 507 |
1860686 | 1860686 | 2021-10-28 | McKinley | New Mexico | 35031 | 15025 | 507 |
1857437 | 1857437 | 2021-10-27 | McKinley | New Mexico | 35031 | 14938 | 506 |
1854188 | 1854188 | 2021-10-26 | McKinley | New Mexico | 35031 | 14851 | 505 |
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);