ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and fips = 18143 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174970 | 2174970 | 2022-02-02 | Scott | Indiana | 18143 | 7459 | 93 |
2171717 | 2171717 | 2022-02-01 | Scott | Indiana | 18143 | 7415 | 91 |
2168464 | 2168464 | 2022-01-31 | Scott | Indiana | 18143 | 7369 | 91 |
2165209 | 2165209 | 2022-01-30 | Scott | Indiana | 18143 | 7241 | 91 |
2161954 | 2161954 | 2022-01-29 | Scott | Indiana | 18143 | 7241 | 91 |
2158699 | 2158699 | 2022-01-28 | Scott | Indiana | 18143 | 7241 | 91 |
2155445 | 2155445 | 2022-01-27 | Scott | Indiana | 18143 | 7094 | 91 |
2152192 | 2152192 | 2022-01-26 | Scott | Indiana | 18143 | 7005 | 91 |
2148940 | 2148940 | 2022-01-25 | Scott | Indiana | 18143 | 6971 | 91 |
2145688 | 2145688 | 2022-01-24 | Scott | Indiana | 18143 | 6866 | 91 |
2142433 | 2142433 | 2022-01-23 | Scott | Indiana | 18143 | 6644 | 90 |
2139178 | 2139178 | 2022-01-22 | Scott | Indiana | 18143 | 6644 | 90 |
2135922 | 2135922 | 2022-01-21 | Scott | Indiana | 18143 | 6644 | 90 |
2132670 | 2132670 | 2022-01-20 | Scott | Indiana | 18143 | 6459 | 89 |
2129417 | 2129417 | 2022-01-19 | Scott | Indiana | 18143 | 6393 | 89 |
2126163 | 2126163 | 2022-01-18 | Scott | Indiana | 18143 | 6334 | 89 |
2122911 | 2122911 | 2022-01-17 | Scott | Indiana | 18143 | 6298 | 89 |
2119659 | 2119659 | 2022-01-16 | Scott | Indiana | 18143 | 6135 | 89 |
2116407 | 2116407 | 2022-01-15 | Scott | Indiana | 18143 | 6135 | 89 |
2113156 | 2113156 | 2022-01-14 | Scott | Indiana | 18143 | 6135 | 89 |
2109904 | 2109904 | 2022-01-13 | Scott | Indiana | 18143 | 6057 | 88 |
2106653 | 2106653 | 2022-01-12 | Scott | Indiana | 18143 | 5984 | 88 |
2103402 | 2103402 | 2022-01-11 | Scott | Indiana | 18143 | 5926 | 88 |
2100151 | 2100151 | 2022-01-10 | Scott | Indiana | 18143 | 5883 | 88 |
2096900 | 2096900 | 2022-01-09 | Scott | Indiana | 18143 | 5770 | 88 |
2093648 | 2093648 | 2022-01-08 | Scott | Indiana | 18143 | 5770 | 88 |
2090396 | 2090396 | 2022-01-07 | Scott | Indiana | 18143 | 5770 | 88 |
2087145 | 2087145 | 2022-01-06 | Scott | Indiana | 18143 | 5715 | 87 |
2083893 | 2083893 | 2022-01-05 | Scott | Indiana | 18143 | 5673 | 85 |
2080641 | 2080641 | 2022-01-04 | Scott | Indiana | 18143 | 5613 | 85 |
2077389 | 2077389 | 2022-01-03 | Scott | Indiana | 18143 | 5589 | 85 |
2074138 | 2074138 | 2022-01-02 | Scott | Indiana | 18143 | 5514 | 85 |
2070887 | 2070887 | 2022-01-01 | Scott | Indiana | 18143 | 5514 | 85 |
2067636 | 2067636 | 2021-12-31 | Scott | Indiana | 18143 | 5514 | 85 |
2064385 | 2064385 | 2021-12-30 | Scott | Indiana | 18143 | 5514 | 85 |
2061135 | 2061135 | 2021-12-29 | Scott | Indiana | 18143 | 5476 | 85 |
2057886 | 2057886 | 2021-12-28 | Scott | Indiana | 18143 | 5427 | 85 |
2054637 | 2054637 | 2021-12-27 | Scott | Indiana | 18143 | 5405 | 85 |
2051387 | 2051387 | 2021-12-26 | Scott | Indiana | 18143 | 5332 | 85 |
2048137 | 2048137 | 2021-12-25 | Scott | Indiana | 18143 | 5332 | 85 |
2044887 | 2044887 | 2021-12-24 | Scott | Indiana | 18143 | 5332 | 85 |
2041638 | 2041638 | 2021-12-23 | Scott | Indiana | 18143 | 5332 | 85 |
2038388 | 2038388 | 2021-12-22 | Scott | Indiana | 18143 | 5332 | 85 |
2035138 | 2035138 | 2021-12-21 | Scott | Indiana | 18143 | 5309 | 85 |
2031888 | 2031888 | 2021-12-20 | Scott | Indiana | 18143 | 5297 | 85 |
2028637 | 2028637 | 2021-12-19 | Scott | Indiana | 18143 | 5249 | 85 |
2025386 | 2025386 | 2021-12-18 | Scott | Indiana | 18143 | 5249 | 85 |
2022135 | 2022135 | 2021-12-17 | Scott | Indiana | 18143 | 5249 | 85 |
2018884 | 2018884 | 2021-12-16 | Scott | Indiana | 18143 | 5218 | 85 |
2015634 | 2015634 | 2021-12-15 | Scott | Indiana | 18143 | 5188 | 84 |
2012383 | 2012383 | 2021-12-14 | Scott | Indiana | 18143 | 5161 | 83 |
2009132 | 2009132 | 2021-12-13 | Scott | Indiana | 18143 | 5143 | 83 |
2005881 | 2005881 | 2021-12-12 | Scott | Indiana | 18143 | 5077 | 82 |
2002630 | 2002630 | 2021-12-11 | Scott | Indiana | 18143 | 5077 | 82 |
1999380 | 1999380 | 2021-12-10 | Scott | Indiana | 18143 | 5077 | 82 |
1996129 | 1996129 | 2021-12-09 | Scott | Indiana | 18143 | 5049 | 82 |
1992878 | 1992878 | 2021-12-08 | Scott | Indiana | 18143 | 5030 | 82 |
1989627 | 1989627 | 2021-12-07 | Scott | Indiana | 18143 | 5002 | 82 |
1986377 | 1986377 | 2021-12-06 | Scott | Indiana | 18143 | 4995 | 82 |
1983127 | 1983127 | 2021-12-05 | Scott | Indiana | 18143 | 4921 | 82 |
1979877 | 1979877 | 2021-12-04 | Scott | Indiana | 18143 | 4921 | 82 |
1976627 | 1976627 | 2021-12-03 | Scott | Indiana | 18143 | 4921 | 82 |
1973378 | 1973378 | 2021-12-02 | Scott | Indiana | 18143 | 4888 | 82 |
1970128 | 1970128 | 2021-12-01 | Scott | Indiana | 18143 | 4863 | 82 |
1966878 | 1966878 | 2021-11-30 | Scott | Indiana | 18143 | 4834 | 82 |
1963626 | 1963626 | 2021-11-29 | Scott | Indiana | 18143 | 4809 | 80 |
1960375 | 1960375 | 2021-11-28 | Scott | Indiana | 18143 | 4765 | 80 |
1957124 | 1957124 | 2021-11-27 | Scott | Indiana | 18143 | 4765 | 80 |
1953873 | 1953873 | 2021-11-26 | Scott | Indiana | 18143 | 4765 | 80 |
1950622 | 1950622 | 2021-11-25 | Scott | Indiana | 18143 | 4765 | 80 |
1947371 | 1947371 | 2021-11-24 | Scott | Indiana | 18143 | 4765 | 80 |
1944120 | 1944120 | 2021-11-23 | Scott | Indiana | 18143 | 4740 | 80 |
1940870 | 1940870 | 2021-11-22 | Scott | Indiana | 18143 | 4733 | 80 |
1937620 | 1937620 | 2021-11-21 | Scott | Indiana | 18143 | 4695 | 80 |
1934370 | 1934370 | 2021-11-20 | Scott | Indiana | 18143 | 4695 | 80 |
1931119 | 1931119 | 2021-11-19 | Scott | Indiana | 18143 | 4695 | 80 |
1927868 | 1927868 | 2021-11-18 | Scott | Indiana | 18143 | 4685 | 80 |
1924618 | 1924618 | 2021-11-17 | Scott | Indiana | 18143 | 4659 | 80 |
1921369 | 1921369 | 2021-11-16 | Scott | Indiana | 18143 | 4641 | 80 |
1918119 | 1918119 | 2021-11-15 | Scott | Indiana | 18143 | 4630 | 80 |
1914869 | 1914869 | 2021-11-14 | Scott | Indiana | 18143 | 4603 | 79 |
1911619 | 1911619 | 2021-11-13 | Scott | Indiana | 18143 | 4603 | 79 |
1908370 | 1908370 | 2021-11-12 | Scott | Indiana | 18143 | 4603 | 79 |
1905121 | 1905121 | 2021-11-11 | Scott | Indiana | 18143 | 4590 | 79 |
1901871 | 1901871 | 2021-11-10 | Scott | Indiana | 18143 | 4549 | 79 |
1898621 | 1898621 | 2021-11-09 | Scott | Indiana | 18143 | 4530 | 79 |
1895371 | 1895371 | 2021-11-08 | Scott | Indiana | 18143 | 4528 | 78 |
1892121 | 1892121 | 2021-11-07 | Scott | Indiana | 18143 | 4507 | 78 |
1888871 | 1888871 | 2021-11-06 | Scott | Indiana | 18143 | 4507 | 78 |
1885621 | 1885621 | 2021-11-05 | Scott | Indiana | 18143 | 4507 | 78 |
1882372 | 1882372 | 2021-11-04 | Scott | Indiana | 18143 | 4491 | 78 |
1879123 | 1879123 | 2021-11-03 | Scott | Indiana | 18143 | 4479 | 78 |
1875874 | 1875874 | 2021-11-02 | Scott | Indiana | 18143 | 4467 | 78 |
1872625 | 1872625 | 2021-11-01 | Scott | Indiana | 18143 | 4460 | 78 |
1869376 | 1869376 | 2021-10-31 | Scott | Indiana | 18143 | 4442 | 78 |
1866127 | 1866127 | 2021-10-30 | Scott | Indiana | 18143 | 4442 | 78 |
1862878 | 1862878 | 2021-10-29 | Scott | Indiana | 18143 | 4442 | 78 |
1859629 | 1859629 | 2021-10-28 | Scott | Indiana | 18143 | 4432 | 78 |
1856380 | 1856380 | 2021-10-27 | Scott | Indiana | 18143 | 4425 | 78 |
1853131 | 1853131 | 2021-10-26 | Scott | Indiana | 18143 | 4412 | 78 |
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);