ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 18001 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1849812 | 1849812 | 2021-10-25 | Adams | Indiana | 18001 | 4907 | 78 |
1846562 | 1846562 | 2021-10-24 | Adams | Indiana | 18001 | 4895 | 77 |
1843312 | 1843312 | 2021-10-23 | Adams | Indiana | 18001 | 4895 | 77 |
1840062 | 1840062 | 2021-10-22 | Adams | Indiana | 18001 | 4895 | 77 |
1836813 | 1836813 | 2021-10-21 | Adams | Indiana | 18001 | 4885 | 77 |
1833564 | 1833564 | 2021-10-20 | Adams | Indiana | 18001 | 4867 | 76 |
1830315 | 1830315 | 2021-10-19 | Adams | Indiana | 18001 | 4838 | 76 |
1827066 | 1827066 | 2021-10-18 | Adams | Indiana | 18001 | 4831 | 74 |
1823817 | 1823817 | 2021-10-17 | Adams | Indiana | 18001 | 4798 | 74 |
1820568 | 1820568 | 2021-10-16 | Adams | Indiana | 18001 | 4798 | 74 |
1817319 | 1817319 | 2021-10-15 | Adams | Indiana | 18001 | 4798 | 74 |
1814071 | 1814071 | 2021-10-14 | Adams | Indiana | 18001 | 4784 | 74 |
1810822 | 1810822 | 2021-10-13 | Adams | Indiana | 18001 | 4772 | 74 |
1807573 | 1807573 | 2021-10-12 | Adams | Indiana | 18001 | 4735 | 74 |
1804322 | 1804322 | 2021-10-11 | Adams | Indiana | 18001 | 4731 | 73 |
1801073 | 1801073 | 2021-10-10 | Adams | Indiana | 18001 | 4706 | 72 |
1797824 | 1797824 | 2021-10-09 | Adams | Indiana | 18001 | 4706 | 72 |
1794575 | 1794575 | 2021-10-08 | Adams | Indiana | 18001 | 4706 | 72 |
1791327 | 1791327 | 2021-10-07 | Adams | Indiana | 18001 | 4688 | 71 |
1788078 | 1788078 | 2021-10-06 | Adams | Indiana | 18001 | 4680 | 71 |
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);