ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18005 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109836 | 2109836 | 2022-01-13 | Bartholomew | Indiana | 18005 | 16648 | 216 |
2106585 | 2106585 | 2022-01-12 | Bartholomew | Indiana | 18005 | 16362 | 216 |
2103334 | 2103334 | 2022-01-11 | Bartholomew | Indiana | 18005 | 16136 | 215 |
2100083 | 2100083 | 2022-01-10 | Bartholomew | Indiana | 18005 | 15938 | 215 |
2096832 | 2096832 | 2022-01-09 | Bartholomew | Indiana | 18005 | 15460 | 214 |
2093580 | 2093580 | 2022-01-08 | Bartholomew | Indiana | 18005 | 15460 | 214 |
2090328 | 2090328 | 2022-01-07 | Bartholomew | Indiana | 18005 | 15460 | 214 |
2087077 | 2087077 | 2022-01-06 | Bartholomew | Indiana | 18005 | 15275 | 213 |
2083825 | 2083825 | 2022-01-05 | Bartholomew | Indiana | 18005 | 15107 | 212 |
2080573 | 2080573 | 2022-01-04 | Bartholomew | Indiana | 18005 | 14964 | 208 |
2077321 | 2077321 | 2022-01-03 | Bartholomew | Indiana | 18005 | 14905 | 208 |
2074070 | 2074070 | 2022-01-02 | Bartholomew | Indiana | 18005 | 14569 | 208 |
2070819 | 2070819 | 2022-01-01 | Bartholomew | Indiana | 18005 | 14569 | 208 |
2067568 | 2067568 | 2021-12-31 | Bartholomew | Indiana | 18005 | 14569 | 208 |
2064317 | 2064317 | 2021-12-30 | Bartholomew | Indiana | 18005 | 14569 | 208 |
2061067 | 2061067 | 2021-12-29 | Bartholomew | Indiana | 18005 | 14463 | 208 |
2057818 | 2057818 | 2021-12-28 | Bartholomew | Indiana | 18005 | 14367 | 208 |
2054569 | 2054569 | 2021-12-27 | Bartholomew | Indiana | 18005 | 14337 | 207 |
2051319 | 2051319 | 2021-12-26 | Bartholomew | Indiana | 18005 | 14100 | 206 |
2048069 | 2048069 | 2021-12-25 | Bartholomew | Indiana | 18005 | 14100 | 206 |
2044819 | 2044819 | 2021-12-24 | Bartholomew | Indiana | 18005 | 14100 | 206 |
2041570 | 2041570 | 2021-12-23 | Bartholomew | Indiana | 18005 | 14100 | 206 |
2038320 | 2038320 | 2021-12-22 | Bartholomew | Indiana | 18005 | 14100 | 206 |
2035070 | 2035070 | 2021-12-21 | Bartholomew | Indiana | 18005 | 14049 | 205 |
2031820 | 2031820 | 2021-12-20 | Bartholomew | Indiana | 18005 | 14000 | 203 |
2028569 | 2028569 | 2021-12-19 | Bartholomew | Indiana | 18005 | 13876 | 202 |
2025318 | 2025318 | 2021-12-18 | Bartholomew | Indiana | 18005 | 13876 | 202 |
2022067 | 2022067 | 2021-12-17 | Bartholomew | Indiana | 18005 | 13876 | 202 |
2018816 | 2018816 | 2021-12-16 | Bartholomew | Indiana | 18005 | 13800 | 202 |
2015566 | 2015566 | 2021-12-15 | Bartholomew | Indiana | 18005 | 13725 | 202 |
2012315 | 2012315 | 2021-12-14 | Bartholomew | Indiana | 18005 | 13668 | 201 |
2009064 | 2009064 | 2021-12-13 | Bartholomew | Indiana | 18005 | 13608 | 201 |
2005813 | 2005813 | 2021-12-12 | Bartholomew | Indiana | 18005 | 13461 | 201 |
2002562 | 2002562 | 2021-12-11 | Bartholomew | Indiana | 18005 | 13461 | 201 |
1999312 | 1999312 | 2021-12-10 | Bartholomew | Indiana | 18005 | 13461 | 201 |
1996061 | 1996061 | 2021-12-09 | Bartholomew | Indiana | 18005 | 13397 | 200 |
1992810 | 1992810 | 2021-12-08 | Bartholomew | Indiana | 18005 | 13312 | 199 |
1989559 | 1989559 | 2021-12-07 | Bartholomew | Indiana | 18005 | 13253 | 197 |
1986309 | 1986309 | 2021-12-06 | Bartholomew | Indiana | 18005 | 13204 | 197 |
1983059 | 1983059 | 2021-12-05 | Bartholomew | Indiana | 18005 | 13007 | 196 |
1979809 | 1979809 | 2021-12-04 | Bartholomew | Indiana | 18005 | 13007 | 196 |
1976559 | 1976559 | 2021-12-03 | Bartholomew | Indiana | 18005 | 13007 | 196 |
1973310 | 1973310 | 2021-12-02 | Bartholomew | Indiana | 18005 | 12918 | 196 |
1970060 | 1970060 | 2021-12-01 | Bartholomew | Indiana | 18005 | 12837 | 196 |
1966810 | 1966810 | 2021-11-30 | Bartholomew | Indiana | 18005 | 12753 | 195 |
1963558 | 1963558 | 2021-11-29 | Bartholomew | Indiana | 18005 | 12710 | 194 |
1960307 | 1960307 | 2021-11-28 | Bartholomew | Indiana | 18005 | 12568 | 194 |
1957056 | 1957056 | 2021-11-27 | Bartholomew | Indiana | 18005 | 12568 | 194 |
1953805 | 1953805 | 2021-11-26 | Bartholomew | Indiana | 18005 | 12568 | 194 |
1950554 | 1950554 | 2021-11-25 | Bartholomew | Indiana | 18005 | 12568 | 194 |
1947303 | 1947303 | 2021-11-24 | Bartholomew | Indiana | 18005 | 12568 | 194 |
1944052 | 1944052 | 2021-11-23 | Bartholomew | Indiana | 18005 | 12519 | 194 |
1940802 | 1940802 | 2021-11-22 | Bartholomew | Indiana | 18005 | 12490 | 193 |
1937552 | 1937552 | 2021-11-21 | Bartholomew | Indiana | 18005 | 12383 | 192 |
1934302 | 1934302 | 2021-11-20 | Bartholomew | Indiana | 18005 | 12383 | 192 |
1931051 | 1931051 | 2021-11-19 | Bartholomew | Indiana | 18005 | 12383 | 192 |
1927800 | 1927800 | 2021-11-18 | Bartholomew | Indiana | 18005 | 12350 | 192 |
1924550 | 1924550 | 2021-11-17 | Bartholomew | Indiana | 18005 | 12317 | 192 |
1921301 | 1921301 | 2021-11-16 | Bartholomew | Indiana | 18005 | 12266 | 192 |
1918051 | 1918051 | 2021-11-15 | Bartholomew | Indiana | 18005 | 12243 | 191 |
1914801 | 1914801 | 2021-11-14 | Bartholomew | Indiana | 18005 | 12172 | 191 |
1911551 | 1911551 | 2021-11-13 | Bartholomew | Indiana | 18005 | 12172 | 191 |
1908302 | 1908302 | 2021-11-12 | Bartholomew | Indiana | 18005 | 12172 | 191 |
1905053 | 1905053 | 2021-11-11 | Bartholomew | Indiana | 18005 | 12129 | 190 |
1901803 | 1901803 | 2021-11-10 | Bartholomew | Indiana | 18005 | 12054 | 190 |
1898553 | 1898553 | 2021-11-09 | Bartholomew | Indiana | 18005 | 12013 | 189 |
1895303 | 1895303 | 2021-11-08 | Bartholomew | Indiana | 18005 | 11996 | 188 |
1892053 | 1892053 | 2021-11-07 | Bartholomew | Indiana | 18005 | 11932 | 188 |
1888803 | 1888803 | 2021-11-06 | Bartholomew | Indiana | 18005 | 11932 | 188 |
1885553 | 1885553 | 2021-11-05 | Bartholomew | Indiana | 18005 | 11932 | 188 |
1882304 | 1882304 | 2021-11-04 | Bartholomew | Indiana | 18005 | 11905 | 188 |
1879055 | 1879055 | 2021-11-03 | Bartholomew | Indiana | 18005 | 11881 | 188 |
1875806 | 1875806 | 2021-11-02 | Bartholomew | Indiana | 18005 | 11865 | 188 |
1872557 | 1872557 | 2021-11-01 | Bartholomew | Indiana | 18005 | 11852 | 187 |
1869308 | 1869308 | 2021-10-31 | Bartholomew | Indiana | 18005 | 11811 | 187 |
1866059 | 1866059 | 2021-10-30 | Bartholomew | Indiana | 18005 | 11811 | 187 |
1862810 | 1862810 | 2021-10-29 | Bartholomew | Indiana | 18005 | 11811 | 187 |
1859561 | 1859561 | 2021-10-28 | Bartholomew | Indiana | 18005 | 11789 | 187 |
1856312 | 1856312 | 2021-10-27 | Bartholomew | Indiana | 18005 | 11754 | 187 |
1853063 | 1853063 | 2021-10-26 | Bartholomew | Indiana | 18005 | 11736 | 186 |
1849814 | 1849814 | 2021-10-25 | Bartholomew | Indiana | 18005 | 11719 | 186 |
1846564 | 1846564 | 2021-10-24 | Bartholomew | Indiana | 18005 | 11663 | 186 |
1843314 | 1843314 | 2021-10-23 | Bartholomew | Indiana | 18005 | 11663 | 186 |
1840064 | 1840064 | 2021-10-22 | Bartholomew | Indiana | 18005 | 11663 | 186 |
1836815 | 1836815 | 2021-10-21 | Bartholomew | Indiana | 18005 | 11626 | 186 |
1833566 | 1833566 | 2021-10-20 | Bartholomew | Indiana | 18005 | 11572 | 186 |
1830317 | 1830317 | 2021-10-19 | Bartholomew | Indiana | 18005 | 11541 | 185 |
1827068 | 1827068 | 2021-10-18 | Bartholomew | Indiana | 18005 | 11529 | 185 |
1823819 | 1823819 | 2021-10-17 | Bartholomew | Indiana | 18005 | 11471 | 185 |
1820570 | 1820570 | 2021-10-16 | Bartholomew | Indiana | 18005 | 11471 | 185 |
1817321 | 1817321 | 2021-10-15 | Bartholomew | Indiana | 18005 | 11471 | 185 |
1814073 | 1814073 | 2021-10-14 | Bartholomew | Indiana | 18005 | 11437 | 185 |
1810824 | 1810824 | 2021-10-13 | Bartholomew | Indiana | 18005 | 11395 | 183 |
1807575 | 1807575 | 2021-10-12 | Bartholomew | Indiana | 18005 | 11362 | 183 |
1804324 | 1804324 | 2021-10-11 | Bartholomew | Indiana | 18005 | 11331 | 182 |
1801075 | 1801075 | 2021-10-10 | Bartholomew | Indiana | 18005 | 11258 | 182 |
1797826 | 1797826 | 2021-10-09 | Bartholomew | Indiana | 18005 | 11258 | 182 |
1794577 | 1794577 | 2021-10-08 | Bartholomew | Indiana | 18005 | 11258 | 182 |
1791329 | 1791329 | 2021-10-07 | Bartholomew | Indiana | 18005 | 11204 | 182 |
1788080 | 1788080 | 2021-10-06 | Bartholomew | Indiana | 18005 | 11165 | 182 |
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);