ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Grant" and fips = 35017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176019 | 2176019 | 2022-02-02 | Grant | New Mexico | 35017 | 6022 | 71 |
2172766 | 2172766 | 2022-02-01 | Grant | New Mexico | 35017 | 5974 | 71 |
2169513 | 2169513 | 2022-01-31 | Grant | New Mexico | 35017 | 5948 | 70 |
2166258 | 2166258 | 2022-01-30 | Grant | New Mexico | 35017 | 5810 | 70 |
2163003 | 2163003 | 2022-01-29 | Grant | New Mexico | 35017 | 5810 | 70 |
2159748 | 2159748 | 2022-01-28 | Grant | New Mexico | 35017 | 5810 | 70 |
2156494 | 2156494 | 2022-01-27 | Grant | New Mexico | 35017 | 5719 | 70 |
2153241 | 2153241 | 2022-01-26 | Grant | New Mexico | 35017 | 5673 | 70 |
2149989 | 2149989 | 2022-01-25 | Grant | New Mexico | 35017 | 5630 | 70 |
2146737 | 2146737 | 2022-01-24 | Grant | New Mexico | 35017 | 5601 | 70 |
2143482 | 2143482 | 2022-01-23 | Grant | New Mexico | 35017 | 5498 | 70 |
2140227 | 2140227 | 2022-01-22 | Grant | New Mexico | 35017 | 5498 | 70 |
2136971 | 2136971 | 2022-01-21 | Grant | New Mexico | 35017 | 5498 | 70 |
2133719 | 2133719 | 2022-01-20 | Grant | New Mexico | 35017 | 5447 | 70 |
2130466 | 2130466 | 2022-01-19 | Grant | New Mexico | 35017 | 5396 | 70 |
2127212 | 2127212 | 2022-01-18 | Grant | New Mexico | 35017 | 5267 | 70 |
2123960 | 2123960 | 2022-01-17 | Grant | New Mexico | 35017 | 5065 | 70 |
2120708 | 2120708 | 2022-01-16 | Grant | New Mexico | 35017 | 5065 | 70 |
2117456 | 2117456 | 2022-01-15 | Grant | New Mexico | 35017 | 5065 | 70 |
2114205 | 2114205 | 2022-01-14 | Grant | New Mexico | 35017 | 5065 | 70 |
2110953 | 2110953 | 2022-01-13 | Grant | New Mexico | 35017 | 4986 | 70 |
2107702 | 2107702 | 2022-01-12 | Grant | New Mexico | 35017 | 4922 | 68 |
2104451 | 2104451 | 2022-01-11 | Grant | New Mexico | 35017 | 4855 | 65 |
2101200 | 2101200 | 2022-01-10 | Grant | New Mexico | 35017 | 4848 | 65 |
2097949 | 2097949 | 2022-01-09 | Grant | New Mexico | 35017 | 4738 | 65 |
2094697 | 2094697 | 2022-01-08 | Grant | New Mexico | 35017 | 4738 | 65 |
2091445 | 2091445 | 2022-01-07 | Grant | New Mexico | 35017 | 4738 | 65 |
2088194 | 2088194 | 2022-01-06 | Grant | New Mexico | 35017 | 4667 | 65 |
2084942 | 2084942 | 2022-01-05 | Grant | New Mexico | 35017 | 4581 | 65 |
2081690 | 2081690 | 2022-01-04 | Grant | New Mexico | 35017 | 4517 | 64 |
2078438 | 2078438 | 2022-01-03 | Grant | New Mexico | 35017 | 4500 | 64 |
2075187 | 2075187 | 2022-01-02 | Grant | New Mexico | 35017 | 4366 | 64 |
2071936 | 2071936 | 2022-01-01 | Grant | New Mexico | 35017 | 4366 | 64 |
2068685 | 2068685 | 2021-12-31 | Grant | New Mexico | 35017 | 4366 | 64 |
2065434 | 2065434 | 2021-12-30 | Grant | New Mexico | 35017 | 4366 | 64 |
2062184 | 2062184 | 2021-12-29 | Grant | New Mexico | 35017 | 4302 | 62 |
2058935 | 2058935 | 2021-12-28 | Grant | New Mexico | 35017 | 4229 | 61 |
2055686 | 2055686 | 2021-12-27 | Grant | New Mexico | 35017 | 4226 | 60 |
2052436 | 2052436 | 2021-12-26 | Grant | New Mexico | 35017 | 4178 | 59 |
2049186 | 2049186 | 2021-12-25 | Grant | New Mexico | 35017 | 4178 | 59 |
2045936 | 2045936 | 2021-12-24 | Grant | New Mexico | 35017 | 4178 | 59 |
2042686 | 2042686 | 2021-12-23 | Grant | New Mexico | 35017 | 4178 | 59 |
2039437 | 2039437 | 2021-12-22 | Grant | New Mexico | 35017 | 4150 | 59 |
2036187 | 2036187 | 2021-12-21 | Grant | New Mexico | 35017 | 4103 | 59 |
2032937 | 2032937 | 2021-12-20 | Grant | New Mexico | 35017 | 4090 | 59 |
2029686 | 2029686 | 2021-12-19 | Grant | New Mexico | 35017 | 4041 | 58 |
2026435 | 2026435 | 2021-12-18 | Grant | New Mexico | 35017 | 4041 | 58 |
2023184 | 2023184 | 2021-12-17 | Grant | New Mexico | 35017 | 4041 | 58 |
2019933 | 2019933 | 2021-12-16 | Grant | New Mexico | 35017 | 4018 | 58 |
2016683 | 2016683 | 2021-12-15 | Grant | New Mexico | 35017 | 3987 | 57 |
2013432 | 2013432 | 2021-12-14 | Grant | New Mexico | 35017 | 3959 | 57 |
2010181 | 2010181 | 2021-12-13 | Grant | New Mexico | 35017 | 3958 | 57 |
2006930 | 2006930 | 2021-12-12 | Grant | New Mexico | 35017 | 3929 | 56 |
2003679 | 2003679 | 2021-12-11 | Grant | New Mexico | 35017 | 3929 | 56 |
2000429 | 2000429 | 2021-12-10 | Grant | New Mexico | 35017 | 3929 | 56 |
1997178 | 1997178 | 2021-12-09 | Grant | New Mexico | 35017 | 3912 | 56 |
1993927 | 1993927 | 2021-12-08 | Grant | New Mexico | 35017 | 3890 | 56 |
1990676 | 1990676 | 2021-12-07 | Grant | New Mexico | 35017 | 3870 | 56 |
1987426 | 1987426 | 2021-12-06 | Grant | New Mexico | 35017 | 3864 | 56 |
1984176 | 1984176 | 2021-12-05 | Grant | New Mexico | 35017 | 3835 | 56 |
1980926 | 1980926 | 2021-12-04 | Grant | New Mexico | 35017 | 3835 | 56 |
1977676 | 1977676 | 2021-12-03 | Grant | New Mexico | 35017 | 3835 | 56 |
1974426 | 1974426 | 2021-12-02 | Grant | New Mexico | 35017 | 3788 | 56 |
1971177 | 1971177 | 2021-12-01 | Grant | New Mexico | 35017 | 3761 | 56 |
1967927 | 1967927 | 2021-11-30 | Grant | New Mexico | 35017 | 3737 | 55 |
1964675 | 1964675 | 2021-11-29 | Grant | New Mexico | 35017 | 3725 | 54 |
1961424 | 1961424 | 2021-11-28 | Grant | New Mexico | 35017 | 3610 | 54 |
1958173 | 1958173 | 2021-11-27 | Grant | New Mexico | 35017 | 3610 | 54 |
1954922 | 1954922 | 2021-11-26 | Grant | New Mexico | 35017 | 3610 | 54 |
1951671 | 1951671 | 2021-11-25 | Grant | New Mexico | 35017 | 3610 | 54 |
1948420 | 1948420 | 2021-11-24 | Grant | New Mexico | 35017 | 3610 | 54 |
1945169 | 1945169 | 2021-11-23 | Grant | New Mexico | 35017 | 3583 | 54 |
1941918 | 1941918 | 2021-11-22 | Grant | New Mexico | 35017 | 3558 | 54 |
1938668 | 1938668 | 2021-11-21 | Grant | New Mexico | 35017 | 3486 | 54 |
1935418 | 1935418 | 2021-11-20 | Grant | New Mexico | 35017 | 3486 | 54 |
1932168 | 1932168 | 2021-11-19 | Grant | New Mexico | 35017 | 3486 | 54 |
1928917 | 1928917 | 2021-11-18 | Grant | New Mexico | 35017 | 3462 | 54 |
1925667 | 1925667 | 2021-11-17 | Grant | New Mexico | 35017 | 3432 | 54 |
1922418 | 1922418 | 2021-11-16 | Grant | New Mexico | 35017 | 3361 | 54 |
1919168 | 1919168 | 2021-11-15 | Grant | New Mexico | 35017 | 3356 | 54 |
1915918 | 1915918 | 2021-11-14 | Grant | New Mexico | 35017 | 3288 | 54 |
1912668 | 1912668 | 2021-11-13 | Grant | New Mexico | 35017 | 3288 | 54 |
1909418 | 1909418 | 2021-11-12 | Grant | New Mexico | 35017 | 3288 | 54 |
1906169 | 1906169 | 2021-11-11 | Grant | New Mexico | 35017 | 3154 | 54 |
1902920 | 1902920 | 2021-11-10 | Grant | New Mexico | 35017 | 3154 | 54 |
1899670 | 1899670 | 2021-11-09 | Grant | New Mexico | 35017 | 3084 | 53 |
1896420 | 1896420 | 2021-11-08 | Grant | New Mexico | 35017 | 3070 | 52 |
1893170 | 1893170 | 2021-11-07 | Grant | New Mexico | 35017 | 2987 | 52 |
1889920 | 1889920 | 2021-11-06 | Grant | New Mexico | 35017 | 2987 | 52 |
1886670 | 1886670 | 2021-11-05 | Grant | New Mexico | 35017 | 2987 | 52 |
1883421 | 1883421 | 2021-11-04 | Grant | New Mexico | 35017 | 2923 | 52 |
1880172 | 1880172 | 2021-11-03 | Grant | New Mexico | 35017 | 2856 | 52 |
1876923 | 1876923 | 2021-11-02 | Grant | New Mexico | 35017 | 2792 | 52 |
1873674 | 1873674 | 2021-11-01 | Grant | New Mexico | 35017 | 2778 | 51 |
1870425 | 1870425 | 2021-10-31 | Grant | New Mexico | 35017 | 2709 | 51 |
1867176 | 1867176 | 2021-10-30 | Grant | New Mexico | 35017 | 2709 | 51 |
1863927 | 1863927 | 2021-10-29 | Grant | New Mexico | 35017 | 2709 | 51 |
1860678 | 1860678 | 2021-10-28 | Grant | New Mexico | 35017 | 2671 | 51 |
1857429 | 1857429 | 2021-10-27 | Grant | New Mexico | 35017 | 2617 | 51 |
1854180 | 1854180 | 2021-10-26 | Grant | New Mexico | 35017 | 2548 | 50 |
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);