ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Adams" and fips = 18001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174900 | 2174900 | 2022-02-02 | Adams | Indiana | 18001 | 7168 | 106 |
2171647 | 2171647 | 2022-02-01 | Adams | Indiana | 18001 | 7144 | 106 |
2168394 | 2168394 | 2022-01-31 | Adams | Indiana | 18001 | 7127 | 105 |
2165139 | 2165139 | 2022-01-30 | Adams | Indiana | 18001 | 7066 | 105 |
2161884 | 2161884 | 2022-01-29 | Adams | Indiana | 18001 | 7066 | 105 |
2158629 | 2158629 | 2022-01-28 | Adams | Indiana | 18001 | 7066 | 105 |
2155375 | 2155375 | 2022-01-27 | Adams | Indiana | 18001 | 7003 | 104 |
2152122 | 2152122 | 2022-01-26 | Adams | Indiana | 18001 | 6958 | 104 |
2148870 | 2148870 | 2022-01-25 | Adams | Indiana | 18001 | 6936 | 104 |
2145618 | 2145618 | 2022-01-24 | Adams | Indiana | 18001 | 6902 | 104 |
2142363 | 2142363 | 2022-01-23 | Adams | Indiana | 18001 | 6786 | 104 |
2139108 | 2139108 | 2022-01-22 | Adams | Indiana | 18001 | 6786 | 104 |
2135852 | 2135852 | 2022-01-21 | Adams | Indiana | 18001 | 6786 | 104 |
2132600 | 2132600 | 2022-01-20 | Adams | Indiana | 18001 | 6731 | 103 |
2129347 | 2129347 | 2022-01-19 | Adams | Indiana | 18001 | 6668 | 102 |
2126093 | 2126093 | 2022-01-18 | Adams | Indiana | 18001 | 6627 | 102 |
2122841 | 2122841 | 2022-01-17 | Adams | Indiana | 18001 | 6580 | 102 |
2119589 | 2119589 | 2022-01-16 | Adams | Indiana | 18001 | 6454 | 102 |
2116337 | 2116337 | 2022-01-15 | Adams | Indiana | 18001 | 6454 | 102 |
2113086 | 2113086 | 2022-01-14 | Adams | Indiana | 18001 | 6454 | 102 |
2109834 | 2109834 | 2022-01-13 | Adams | Indiana | 18001 | 6395 | 101 |
2106583 | 2106583 | 2022-01-12 | Adams | Indiana | 18001 | 6362 | 101 |
2103332 | 2103332 | 2022-01-11 | Adams | Indiana | 18001 | 6304 | 100 |
2100081 | 2100081 | 2022-01-10 | Adams | Indiana | 18001 | 6245 | 98 |
2096830 | 2096830 | 2022-01-09 | Adams | Indiana | 18001 | 6164 | 97 |
2093578 | 2093578 | 2022-01-08 | Adams | Indiana | 18001 | 6164 | 97 |
2090326 | 2090326 | 2022-01-07 | Adams | Indiana | 18001 | 6164 | 97 |
2087075 | 2087075 | 2022-01-06 | Adams | Indiana | 18001 | 6136 | 95 |
2083823 | 2083823 | 2022-01-05 | Adams | Indiana | 18001 | 6103 | 95 |
2080571 | 2080571 | 2022-01-04 | Adams | Indiana | 18001 | 6074 | 95 |
2077319 | 2077319 | 2022-01-03 | Adams | Indiana | 18001 | 6055 | 94 |
2074068 | 2074068 | 2022-01-02 | Adams | Indiana | 18001 | 5987 | 94 |
2070817 | 2070817 | 2022-01-01 | Adams | Indiana | 18001 | 5987 | 94 |
2067566 | 2067566 | 2021-12-31 | Adams | Indiana | 18001 | 5987 | 94 |
2064315 | 2064315 | 2021-12-30 | Adams | Indiana | 18001 | 5987 | 94 |
2061065 | 2061065 | 2021-12-29 | Adams | Indiana | 18001 | 5955 | 93 |
2057816 | 2057816 | 2021-12-28 | Adams | Indiana | 18001 | 5934 | 93 |
2054567 | 2054567 | 2021-12-27 | Adams | Indiana | 18001 | 5925 | 93 |
2051317 | 2051317 | 2021-12-26 | Adams | Indiana | 18001 | 5859 | 91 |
2048067 | 2048067 | 2021-12-25 | Adams | Indiana | 18001 | 5859 | 91 |
2044817 | 2044817 | 2021-12-24 | Adams | Indiana | 18001 | 5859 | 91 |
2041568 | 2041568 | 2021-12-23 | Adams | Indiana | 18001 | 5859 | 91 |
2038318 | 2038318 | 2021-12-22 | Adams | Indiana | 18001 | 5859 | 91 |
2035068 | 2035068 | 2021-12-21 | Adams | Indiana | 18001 | 5843 | 90 |
2031818 | 2031818 | 2021-12-20 | Adams | Indiana | 18001 | 5835 | 88 |
2028567 | 2028567 | 2021-12-19 | Adams | Indiana | 18001 | 5806 | 87 |
2025316 | 2025316 | 2021-12-18 | Adams | Indiana | 18001 | 5806 | 87 |
2022065 | 2022065 | 2021-12-17 | Adams | Indiana | 18001 | 5806 | 87 |
2018814 | 2018814 | 2021-12-16 | Adams | Indiana | 18001 | 5792 | 87 |
2015564 | 2015564 | 2021-12-15 | Adams | Indiana | 18001 | 5764 | 86 |
2012313 | 2012313 | 2021-12-14 | Adams | Indiana | 18001 | 5726 | 85 |
2009062 | 2009062 | 2021-12-13 | Adams | Indiana | 18001 | 5716 | 83 |
2005811 | 2005811 | 2021-12-12 | Adams | Indiana | 18001 | 5659 | 82 |
2002560 | 2002560 | 2021-12-11 | Adams | Indiana | 18001 | 5659 | 82 |
1999310 | 1999310 | 2021-12-10 | Adams | Indiana | 18001 | 5659 | 82 |
1996059 | 1996059 | 2021-12-09 | Adams | Indiana | 18001 | 5629 | 82 |
1992808 | 1992808 | 2021-12-08 | Adams | Indiana | 18001 | 5592 | 82 |
1989557 | 1989557 | 2021-12-07 | Adams | Indiana | 18001 | 5560 | 82 |
1986307 | 1986307 | 2021-12-06 | Adams | Indiana | 18001 | 5552 | 82 |
1983057 | 1983057 | 2021-12-05 | Adams | Indiana | 18001 | 5495 | 82 |
1979807 | 1979807 | 2021-12-04 | Adams | Indiana | 18001 | 5495 | 82 |
1976557 | 1976557 | 2021-12-03 | Adams | Indiana | 18001 | 5495 | 82 |
1973308 | 1973308 | 2021-12-02 | Adams | Indiana | 18001 | 5478 | 82 |
1970058 | 1970058 | 2021-12-01 | Adams | Indiana | 18001 | 5452 | 82 |
1966808 | 1966808 | 2021-11-30 | Adams | Indiana | 18001 | 5410 | 82 |
1963556 | 1963556 | 2021-11-29 | Adams | Indiana | 18001 | 5396 | 82 |
1960305 | 1960305 | 2021-11-28 | Adams | Indiana | 18001 | 5350 | 82 |
1957054 | 1957054 | 2021-11-27 | Adams | Indiana | 18001 | 5350 | 82 |
1953803 | 1953803 | 2021-11-26 | Adams | Indiana | 18001 | 5350 | 82 |
1950552 | 1950552 | 2021-11-25 | Adams | Indiana | 18001 | 5350 | 82 |
1947301 | 1947301 | 2021-11-24 | Adams | Indiana | 18001 | 5350 | 82 |
1944050 | 1944050 | 2021-11-23 | Adams | Indiana | 18001 | 5327 | 82 |
1940800 | 1940800 | 2021-11-22 | Adams | Indiana | 18001 | 5317 | 82 |
1937550 | 1937550 | 2021-11-21 | Adams | Indiana | 18001 | 5290 | 81 |
1934300 | 1934300 | 2021-11-20 | Adams | Indiana | 18001 | 5290 | 81 |
1931049 | 1931049 | 2021-11-19 | Adams | Indiana | 18001 | 5290 | 81 |
1927798 | 1927798 | 2021-11-18 | Adams | Indiana | 18001 | 5270 | 81 |
1924548 | 1924548 | 2021-11-17 | Adams | Indiana | 18001 | 5239 | 80 |
1921299 | 1921299 | 2021-11-16 | Adams | Indiana | 18001 | 5221 | 80 |
1918049 | 1918049 | 2021-11-15 | Adams | Indiana | 18001 | 5214 | 80 |
1914799 | 1914799 | 2021-11-14 | Adams | Indiana | 18001 | 5190 | 80 |
1911549 | 1911549 | 2021-11-13 | Adams | Indiana | 18001 | 5190 | 80 |
1908300 | 1908300 | 2021-11-12 | Adams | Indiana | 18001 | 5190 | 80 |
1905051 | 1905051 | 2021-11-11 | Adams | Indiana | 18001 | 5181 | 80 |
1901801 | 1901801 | 2021-11-10 | Adams | Indiana | 18001 | 5123 | 80 |
1898551 | 1898551 | 2021-11-09 | Adams | Indiana | 18001 | 5095 | 80 |
1895301 | 1895301 | 2021-11-08 | Adams | Indiana | 18001 | 5082 | 80 |
1892051 | 1892051 | 2021-11-07 | Adams | Indiana | 18001 | 5055 | 80 |
1888801 | 1888801 | 2021-11-06 | Adams | Indiana | 18001 | 5055 | 80 |
1885551 | 1885551 | 2021-11-05 | Adams | Indiana | 18001 | 5055 | 80 |
1882302 | 1882302 | 2021-11-04 | Adams | Indiana | 18001 | 5039 | 80 |
1879053 | 1879053 | 2021-11-03 | Adams | Indiana | 18001 | 5023 | 79 |
1875804 | 1875804 | 2021-11-02 | Adams | Indiana | 18001 | 5009 | 79 |
1872555 | 1872555 | 2021-11-01 | Adams | Indiana | 18001 | 4994 | 79 |
1869306 | 1869306 | 2021-10-31 | Adams | Indiana | 18001 | 4973 | 78 |
1866057 | 1866057 | 2021-10-30 | Adams | Indiana | 18001 | 4973 | 78 |
1862808 | 1862808 | 2021-10-29 | Adams | Indiana | 18001 | 4973 | 78 |
1859559 | 1859559 | 2021-10-28 | Adams | Indiana | 18001 | 4958 | 78 |
1856310 | 1856310 | 2021-10-27 | Adams | Indiana | 18001 | 4943 | 77 |
1853061 | 1853061 | 2021-10-26 | Adams | Indiana | 18001 | 4919 | 77 |
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);