ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 35013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176017 | 2176017 | 2022-02-02 | Doña Ana | New Mexico | 35013 | 58840 | 667 |
2172764 | 2172764 | 2022-02-01 | Doña Ana | New Mexico | 35013 | 58482 | 667 |
2169511 | 2169511 | 2022-01-31 | Doña Ana | New Mexico | 35013 | 58314 | 666 |
2166256 | 2166256 | 2022-01-30 | Doña Ana | New Mexico | 35013 | 56964 | 663 |
2163001 | 2163001 | 2022-01-29 | Doña Ana | New Mexico | 35013 | 56964 | 663 |
2159746 | 2159746 | 2022-01-28 | Doña Ana | New Mexico | 35013 | 56964 | 663 |
2156492 | 2156492 | 2022-01-27 | Doña Ana | New Mexico | 35013 | 56294 | 660 |
2153239 | 2153239 | 2022-01-26 | Doña Ana | New Mexico | 35013 | 55295 | 657 |
2149987 | 2149987 | 2022-01-25 | Doña Ana | New Mexico | 35013 | 54912 | 654 |
2146735 | 2146735 | 2022-01-24 | Doña Ana | New Mexico | 35013 | 54495 | 652 |
2143480 | 2143480 | 2022-01-23 | Doña Ana | New Mexico | 35013 | 52476 | 650 |
2140225 | 2140225 | 2022-01-22 | Doña Ana | New Mexico | 35013 | 52476 | 650 |
2136969 | 2136969 | 2022-01-21 | Doña Ana | New Mexico | 35013 | 52476 | 650 |
2133717 | 2133717 | 2022-01-20 | Doña Ana | New Mexico | 35013 | 51544 | 643 |
2130464 | 2130464 | 2022-01-19 | Doña Ana | New Mexico | 35013 | 50955 | 641 |
2127210 | 2127210 | 2022-01-18 | Doña Ana | New Mexico | 35013 | 50111 | 637 |
2123958 | 2123958 | 2022-01-17 | Doña Ana | New Mexico | 35013 | 47253 | 635 |
2120706 | 2120706 | 2022-01-16 | Doña Ana | New Mexico | 35013 | 47253 | 635 |
2117454 | 2117454 | 2022-01-15 | Doña Ana | New Mexico | 35013 | 47253 | 635 |
2114203 | 2114203 | 2022-01-14 | Doña Ana | New Mexico | 35013 | 47253 | 635 |
2110951 | 2110951 | 2022-01-13 | Doña Ana | New Mexico | 35013 | 46617 | 630 |
2107700 | 2107700 | 2022-01-12 | Doña Ana | New Mexico | 35013 | 45623 | 623 |
2104449 | 2104449 | 2022-01-11 | Doña Ana | New Mexico | 35013 | 44610 | 621 |
2101198 | 2101198 | 2022-01-10 | Doña Ana | New Mexico | 35013 | 44307 | 619 |
2097947 | 2097947 | 2022-01-09 | Doña Ana | New Mexico | 35013 | 43274 | 614 |
2094695 | 2094695 | 2022-01-08 | Doña Ana | New Mexico | 35013 | 43274 | 614 |
2091443 | 2091443 | 2022-01-07 | Doña Ana | New Mexico | 35013 | 43274 | 614 |
2088192 | 2088192 | 2022-01-06 | Doña Ana | New Mexico | 35013 | 42566 | 613 |
2084940 | 2084940 | 2022-01-05 | Doña Ana | New Mexico | 35013 | 42319 | 609 |
2081688 | 2081688 | 2022-01-04 | Doña Ana | New Mexico | 35013 | 42173 | 605 |
2078436 | 2078436 | 2022-01-03 | Doña Ana | New Mexico | 35013 | 42010 | 604 |
2075185 | 2075185 | 2022-01-02 | Doña Ana | New Mexico | 35013 | 41044 | 603 |
2071934 | 2071934 | 2022-01-01 | Doña Ana | New Mexico | 35013 | 41044 | 603 |
2068683 | 2068683 | 2021-12-31 | Doña Ana | New Mexico | 35013 | 41044 | 603 |
2065432 | 2065432 | 2021-12-30 | Doña Ana | New Mexico | 35013 | 41044 | 603 |
2062182 | 2062182 | 2021-12-29 | Doña Ana | New Mexico | 35013 | 40785 | 601 |
2058933 | 2058933 | 2021-12-28 | Doña Ana | New Mexico | 35013 | 40580 | 598 |
2055684 | 2055684 | 2021-12-27 | Doña Ana | New Mexico | 35013 | 40548 | 595 |
2052434 | 2052434 | 2021-12-26 | Doña Ana | New Mexico | 35013 | 40274 | 593 |
2049184 | 2049184 | 2021-12-25 | Doña Ana | New Mexico | 35013 | 40274 | 593 |
2045934 | 2045934 | 2021-12-24 | Doña Ana | New Mexico | 35013 | 40274 | 593 |
2042684 | 2042684 | 2021-12-23 | Doña Ana | New Mexico | 35013 | 40274 | 593 |
2039435 | 2039435 | 2021-12-22 | Doña Ana | New Mexico | 35013 | 40153 | 590 |
2036185 | 2036185 | 2021-12-21 | Doña Ana | New Mexico | 35013 | 40061 | 585 |
2032935 | 2032935 | 2021-12-20 | Doña Ana | New Mexico | 35013 | 39999 | 581 |
2029684 | 2029684 | 2021-12-19 | Doña Ana | New Mexico | 35013 | 39621 | 577 |
2026433 | 2026433 | 2021-12-18 | Doña Ana | New Mexico | 35013 | 39621 | 577 |
2023182 | 2023182 | 2021-12-17 | Doña Ana | New Mexico | 35013 | 39621 | 577 |
2019931 | 2019931 | 2021-12-16 | Doña Ana | New Mexico | 35013 | 39481 | 574 |
2016681 | 2016681 | 2021-12-15 | Doña Ana | New Mexico | 35013 | 39295 | 572 |
2013430 | 2013430 | 2021-12-14 | Doña Ana | New Mexico | 35013 | 39122 | 570 |
2010179 | 2010179 | 2021-12-13 | Doña Ana | New Mexico | 35013 | 39029 | 569 |
2006928 | 2006928 | 2021-12-12 | Doña Ana | New Mexico | 35013 | 38784 | 567 |
2003677 | 2003677 | 2021-12-11 | Doña Ana | New Mexico | 35013 | 38784 | 567 |
2000427 | 2000427 | 2021-12-10 | Doña Ana | New Mexico | 35013 | 38784 | 567 |
1997176 | 1997176 | 2021-12-09 | Doña Ana | New Mexico | 35013 | 38599 | 566 |
1993925 | 1993925 | 2021-12-08 | Doña Ana | New Mexico | 35013 | 38383 | 565 |
1990674 | 1990674 | 2021-12-07 | Doña Ana | New Mexico | 35013 | 38170 | 562 |
1987424 | 1987424 | 2021-12-06 | Doña Ana | New Mexico | 35013 | 38073 | 561 |
1984174 | 1984174 | 2021-12-05 | Doña Ana | New Mexico | 35013 | 37469 | 560 |
1980924 | 1980924 | 2021-12-04 | Doña Ana | New Mexico | 35013 | 37469 | 560 |
1977674 | 1977674 | 2021-12-03 | Doña Ana | New Mexico | 35013 | 37469 | 560 |
1974424 | 1974424 | 2021-12-02 | Doña Ana | New Mexico | 35013 | 37147 | 560 |
1971175 | 1971175 | 2021-12-01 | Doña Ana | New Mexico | 35013 | 36854 | 558 |
1967925 | 1967925 | 2021-11-30 | Doña Ana | New Mexico | 35013 | 36542 | 558 |
1964673 | 1964673 | 2021-11-29 | Doña Ana | New Mexico | 35013 | 36386 | 558 |
1961422 | 1961422 | 2021-11-28 | Doña Ana | New Mexico | 35013 | 35598 | 551 |
1958171 | 1958171 | 2021-11-27 | Doña Ana | New Mexico | 35013 | 35598 | 551 |
1954920 | 1954920 | 2021-11-26 | Doña Ana | New Mexico | 35013 | 35598 | 551 |
1951669 | 1951669 | 2021-11-25 | Doña Ana | New Mexico | 35013 | 35598 | 551 |
1948418 | 1948418 | 2021-11-24 | Doña Ana | New Mexico | 35013 | 35598 | 551 |
1945167 | 1945167 | 2021-11-23 | Doña Ana | New Mexico | 35013 | 35369 | 547 |
1941916 | 1941916 | 2021-11-22 | Doña Ana | New Mexico | 35013 | 35194 | 544 |
1938666 | 1938666 | 2021-11-21 | Doña Ana | New Mexico | 35013 | 34459 | 544 |
1935416 | 1935416 | 2021-11-20 | Doña Ana | New Mexico | 35013 | 34459 | 544 |
1932166 | 1932166 | 2021-11-19 | Doña Ana | New Mexico | 35013 | 34459 | 544 |
1928915 | 1928915 | 2021-11-18 | Doña Ana | New Mexico | 35013 | 34238 | 543 |
1925665 | 1925665 | 2021-11-17 | Doña Ana | New Mexico | 35013 | 33934 | 542 |
1922416 | 1922416 | 2021-11-16 | Doña Ana | New Mexico | 35013 | 33699 | 542 |
1919166 | 1919166 | 2021-11-15 | Doña Ana | New Mexico | 35013 | 33526 | 542 |
1915916 | 1915916 | 2021-11-14 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1912666 | 1912666 | 2021-11-13 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1909416 | 1909416 | 2021-11-12 | Doña Ana | New Mexico | 35013 | 32966 | 542 |
1906167 | 1906167 | 2021-11-11 | Doña Ana | New Mexico | 35013 | 32507 | 540 |
1902918 | 1902918 | 2021-11-10 | Doña Ana | New Mexico | 35013 | 32507 | 540 |
1899668 | 1899668 | 2021-11-09 | Doña Ana | New Mexico | 35013 | 32295 | 540 |
1896418 | 1896418 | 2021-11-08 | Doña Ana | New Mexico | 35013 | 32208 | 540 |
1893168 | 1893168 | 2021-11-07 | Doña Ana | New Mexico | 35013 | 31649 | 540 |
1889918 | 1889918 | 2021-11-06 | Doña Ana | New Mexico | 35013 | 31649 | 540 |
1886668 | 1886668 | 2021-11-05 | Doña Ana | New Mexico | 35013 | 31649 | 540 |
1883419 | 1883419 | 2021-11-04 | Doña Ana | New Mexico | 35013 | 31437 | 540 |
1880170 | 1880170 | 2021-11-03 | Doña Ana | New Mexico | 35013 | 31215 | 538 |
1876921 | 1876921 | 2021-11-02 | Doña Ana | New Mexico | 35013 | 31115 | 538 |
1873672 | 1873672 | 2021-11-01 | Doña Ana | New Mexico | 35013 | 31033 | 538 |
1870423 | 1870423 | 2021-10-31 | Doña Ana | New Mexico | 35013 | 30704 | 536 |
1867174 | 1867174 | 2021-10-30 | Doña Ana | New Mexico | 35013 | 30704 | 536 |
1863925 | 1863925 | 2021-10-29 | Doña Ana | New Mexico | 35013 | 30704 | 536 |
1860676 | 1860676 | 2021-10-28 | Doña Ana | New Mexico | 35013 | 30591 | 536 |
1857427 | 1857427 | 2021-10-27 | Doña Ana | New Mexico | 35013 | 30395 | 533 |
1854178 | 1854178 | 2021-10-26 | Doña Ana | New Mexico | 35013 | 30346 | 533 |
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);