ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Grant" and fips = 40053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176375 | 2176375 | 2022-02-02 | Grant | Oklahoma | 40053 | 986 | 12 |
2173121 | 2173121 | 2022-02-01 | Grant | Oklahoma | 40053 | 931 | 12 |
2169869 | 2169869 | 2022-01-31 | Grant | Oklahoma | 40053 | 931 | 12 |
2166614 | 2166614 | 2022-01-30 | Grant | Oklahoma | 40053 | 931 | 12 |
2163359 | 2163359 | 2022-01-29 | Grant | Oklahoma | 40053 | 931 | 12 |
2160104 | 2160104 | 2022-01-28 | Grant | Oklahoma | 40053 | 931 | 12 |
2156849 | 2156849 | 2022-01-27 | Grant | Oklahoma | 40053 | 931 | 12 |
2153596 | 2153596 | 2022-01-26 | Grant | Oklahoma | 40053 | 931 | 12 |
2150344 | 2150344 | 2022-01-25 | Grant | Oklahoma | 40053 | 855 | 11 |
2147092 | 2147092 | 2022-01-24 | Grant | Oklahoma | 40053 | 855 | 11 |
2143838 | 2143838 | 2022-01-23 | Grant | Oklahoma | 40053 | 855 | 11 |
2140583 | 2140583 | 2022-01-22 | Grant | Oklahoma | 40053 | 855 | 11 |
2137327 | 2137327 | 2022-01-21 | Grant | Oklahoma | 40053 | 855 | 11 |
2134073 | 2134073 | 2022-01-20 | Grant | Oklahoma | 40053 | 855 | 11 |
2130821 | 2130821 | 2022-01-19 | Grant | Oklahoma | 40053 | 855 | 11 |
2127567 | 2127567 | 2022-01-18 | Grant | Oklahoma | 40053 | 785 | 8 |
2124315 | 2124315 | 2022-01-17 | Grant | Oklahoma | 40053 | 785 | 8 |
2121063 | 2121063 | 2022-01-16 | Grant | Oklahoma | 40053 | 785 | 8 |
2117811 | 2117811 | 2022-01-15 | Grant | Oklahoma | 40053 | 785 | 8 |
2114560 | 2114560 | 2022-01-14 | Grant | Oklahoma | 40053 | 785 | 8 |
2111308 | 2111308 | 2022-01-13 | Grant | Oklahoma | 40053 | 785 | 8 |
2108056 | 2108056 | 2022-01-12 | Grant | Oklahoma | 40053 | 785 | 8 |
2104805 | 2104805 | 2022-01-11 | Grant | Oklahoma | 40053 | 758 | 8 |
2101554 | 2101554 | 2022-01-10 | Grant | Oklahoma | 40053 | 758 | 8 |
2098303 | 2098303 | 2022-01-09 | Grant | Oklahoma | 40053 | 758 | 8 |
2095051 | 2095051 | 2022-01-08 | Grant | Oklahoma | 40053 | 758 | 8 |
2091799 | 2091799 | 2022-01-07 | Grant | Oklahoma | 40053 | 758 | 8 |
2088547 | 2088547 | 2022-01-06 | Grant | Oklahoma | 40053 | 758 | 8 |
2085296 | 2085296 | 2022-01-05 | Grant | Oklahoma | 40053 | 758 | 8 |
2082044 | 2082044 | 2022-01-04 | Grant | Oklahoma | 40053 | 741 | 8 |
2078792 | 2078792 | 2022-01-03 | Grant | Oklahoma | 40053 | 741 | 8 |
2075541 | 2075541 | 2022-01-02 | Grant | Oklahoma | 40053 | 741 | 8 |
2072290 | 2072290 | 2022-01-01 | Grant | Oklahoma | 40053 | 741 | 8 |
2069039 | 2069039 | 2021-12-31 | Grant | Oklahoma | 40053 | 741 | 8 |
2065788 | 2065788 | 2021-12-30 | Grant | Oklahoma | 40053 | 741 | 8 |
2062538 | 2062538 | 2021-12-29 | Grant | Oklahoma | 40053 | 741 | 8 |
2059288 | 2059288 | 2021-12-28 | Grant | Oklahoma | 40053 | 737 | 8 |
2056039 | 2056039 | 2021-12-27 | Grant | Oklahoma | 40053 | 737 | 8 |
2052790 | 2052790 | 2021-12-26 | Grant | Oklahoma | 40053 | 737 | 8 |
2049540 | 2049540 | 2021-12-25 | Grant | Oklahoma | 40053 | 737 | 8 |
2046290 | 2046290 | 2021-12-24 | Grant | Oklahoma | 40053 | 737 | 8 |
2043040 | 2043040 | 2021-12-23 | Grant | Oklahoma | 40053 | 737 | 8 |
2039791 | 2039791 | 2021-12-22 | Grant | Oklahoma | 40053 | 737 | 8 |
2036541 | 2036541 | 2021-12-21 | Grant | Oklahoma | 40053 | 736 | 8 |
2033291 | 2033291 | 2021-12-20 | Grant | Oklahoma | 40053 | 736 | 8 |
2030041 | 2030041 | 2021-12-19 | Grant | Oklahoma | 40053 | 736 | 8 |
2026790 | 2026790 | 2021-12-18 | Grant | Oklahoma | 40053 | 736 | 8 |
2023539 | 2023539 | 2021-12-17 | Grant | Oklahoma | 40053 | 736 | 8 |
2020288 | 2020288 | 2021-12-16 | Grant | Oklahoma | 40053 | 736 | 8 |
2017037 | 2017037 | 2021-12-15 | Grant | Oklahoma | 40053 | 736 | 8 |
2013787 | 2013787 | 2021-12-14 | Grant | Oklahoma | 40053 | 721 | 8 |
2010536 | 2010536 | 2021-12-13 | Grant | Oklahoma | 40053 | 721 | 8 |
2007285 | 2007285 | 2021-12-12 | Grant | Oklahoma | 40053 | 721 | 8 |
2004034 | 2004034 | 2021-12-11 | Grant | Oklahoma | 40053 | 721 | 8 |
2000783 | 2000783 | 2021-12-10 | Grant | Oklahoma | 40053 | 721 | 8 |
1997533 | 1997533 | 2021-12-09 | Grant | Oklahoma | 40053 | 721 | 8 |
1994282 | 1994282 | 2021-12-08 | Grant | Oklahoma | 40053 | 721 | 8 |
1991031 | 1991031 | 2021-12-07 | Grant | Oklahoma | 40053 | 717 | 8 |
1987780 | 1987780 | 2021-12-06 | Grant | Oklahoma | 40053 | 717 | 8 |
1984530 | 1984530 | 2021-12-05 | Grant | Oklahoma | 40053 | 717 | 8 |
1981280 | 1981280 | 2021-12-04 | Grant | Oklahoma | 40053 | 717 | 8 |
1978030 | 1978030 | 2021-12-03 | Grant | Oklahoma | 40053 | 717 | 8 |
1974780 | 1974780 | 2021-12-02 | Grant | Oklahoma | 40053 | 717 | 8 |
1971531 | 1971531 | 2021-12-01 | Grant | Oklahoma | 40053 | 717 | 8 |
1968281 | 1968281 | 2021-11-30 | Grant | Oklahoma | 40053 | 713 | 8 |
1965030 | 1965030 | 2021-11-29 | Grant | Oklahoma | 40053 | 713 | 8 |
1961778 | 1961778 | 2021-11-28 | Grant | Oklahoma | 40053 | 713 | 8 |
1958527 | 1958527 | 2021-11-27 | Grant | Oklahoma | 40053 | 713 | 8 |
1955276 | 1955276 | 2021-11-26 | Grant | Oklahoma | 40053 | 713 | 8 |
1952025 | 1952025 | 2021-11-25 | Grant | Oklahoma | 40053 | 713 | 8 |
1948774 | 1948774 | 2021-11-24 | Grant | Oklahoma | 40053 | 713 | 8 |
1945523 | 1945523 | 2021-11-23 | Grant | Oklahoma | 40053 | 709 | 8 |
1942272 | 1942272 | 2021-11-22 | Grant | Oklahoma | 40053 | 709 | 8 |
1939022 | 1939022 | 2021-11-21 | Grant | Oklahoma | 40053 | 709 | 8 |
1935772 | 1935772 | 2021-11-20 | Grant | Oklahoma | 40053 | 709 | 8 |
1932522 | 1932522 | 2021-11-19 | Grant | Oklahoma | 40053 | 709 | 8 |
1929271 | 1929271 | 2021-11-18 | Grant | Oklahoma | 40053 | 709 | 8 |
1926021 | 1926021 | 2021-11-17 | Grant | Oklahoma | 40053 | 709 | 8 |
1922771 | 1922771 | 2021-11-16 | Grant | Oklahoma | 40053 | 705 | 8 |
1919522 | 1919522 | 2021-11-15 | Grant | Oklahoma | 40053 | 705 | 8 |
1916272 | 1916272 | 2021-11-14 | Grant | Oklahoma | 40053 | 705 | 8 |
1913022 | 1913022 | 2021-11-13 | Grant | Oklahoma | 40053 | 705 | 8 |
1909772 | 1909772 | 2021-11-12 | Grant | Oklahoma | 40053 | 705 | 8 |
1906523 | 1906523 | 2021-11-11 | Grant | Oklahoma | 40053 | 705 | 8 |
1903274 | 1903274 | 2021-11-10 | Grant | Oklahoma | 40053 | 705 | 8 |
1900024 | 1900024 | 2021-11-09 | Grant | Oklahoma | 40053 | 701 | 8 |
1896774 | 1896774 | 2021-11-08 | Grant | Oklahoma | 40053 | 701 | 8 |
1893524 | 1893524 | 2021-11-07 | Grant | Oklahoma | 40053 | 701 | 8 |
1890274 | 1890274 | 2021-11-06 | Grant | Oklahoma | 40053 | 701 | 8 |
1887024 | 1887024 | 2021-11-05 | Grant | Oklahoma | 40053 | 701 | 8 |
1883774 | 1883774 | 2021-11-04 | Grant | Oklahoma | 40053 | 701 | 8 |
1880525 | 1880525 | 2021-11-03 | Grant | Oklahoma | 40053 | 701 | 8 |
1877276 | 1877276 | 2021-11-02 | Grant | Oklahoma | 40053 | 696 | 8 |
1874027 | 1874027 | 2021-11-01 | Grant | Oklahoma | 40053 | 696 | 8 |
1870778 | 1870778 | 2021-10-31 | Grant | Oklahoma | 40053 | 696 | 8 |
1867529 | 1867529 | 2021-10-30 | Grant | Oklahoma | 40053 | 696 | 8 |
1864280 | 1864280 | 2021-10-29 | Grant | Oklahoma | 40053 | 696 | 8 |
1861031 | 1861031 | 2021-10-28 | Grant | Oklahoma | 40053 | 696 | 8 |
1857782 | 1857782 | 2021-10-27 | Grant | Oklahoma | 40053 | 696 | 8 |
1854533 | 1854533 | 2021-10-26 | Grant | Oklahoma | 40053 | 692 | 8 |
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);