ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
502 rows where deaths = 48 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324558 | 2324558 | 2022-03-20 | Pike | Indiana | 18125 | 3723 | 48 |
2321304 | 2321304 | 2022-03-19 | Pike | Indiana | 18125 | 3723 | 48 |
2318050 | 2318050 | 2022-03-18 | Pike | Indiana | 18125 | 3723 | 48 |
2314797 | 2314797 | 2022-03-17 | Pike | Indiana | 18125 | 3723 | 48 |
2311544 | 2311544 | 2022-03-16 | Pike | Indiana | 18125 | 3722 | 48 |
2308291 | 2308291 | 2022-03-15 | Pike | Indiana | 18125 | 3722 | 48 |
2305040 | 2305040 | 2022-03-14 | Pike | Indiana | 18125 | 3720 | 48 |
2301788 | 2301788 | 2022-03-13 | Pike | Indiana | 18125 | 3720 | 48 |
2298536 | 2298536 | 2022-03-12 | Pike | Indiana | 18125 | 3720 | 48 |
2295284 | 2295284 | 2022-03-11 | Pike | Indiana | 18125 | 3720 | 48 |
2292032 | 2292032 | 2022-03-10 | Pike | Indiana | 18125 | 3719 | 48 |
2288780 | 2288780 | 2022-03-09 | Pike | Indiana | 18125 | 3718 | 48 |
2285527 | 2285527 | 2022-03-08 | Parke | Indiana | 18121 | 3605 | 48 |
2285529 | 2285529 | 2022-03-08 | Pike | Indiana | 18125 | 3718 | 48 |
2282275 | 2282275 | 2022-03-07 | Parke | Indiana | 18121 | 3604 | 48 |
2282277 | 2282277 | 2022-03-07 | Pike | Indiana | 18125 | 3717 | 48 |
2279022 | 2279022 | 2022-03-06 | Parke | Indiana | 18121 | 3604 | 48 |
2279024 | 2279024 | 2022-03-06 | Pike | Indiana | 18125 | 3717 | 48 |
2275769 | 2275769 | 2022-03-05 | Parke | Indiana | 18121 | 3604 | 48 |
2275771 | 2275771 | 2022-03-05 | Pike | Indiana | 18125 | 3717 | 48 |
2272516 | 2272516 | 2022-03-04 | Parke | Indiana | 18121 | 3604 | 48 |
2272518 | 2272518 | 2022-03-04 | Pike | Indiana | 18125 | 3717 | 48 |
2269264 | 2269264 | 2022-03-03 | Parke | Indiana | 18121 | 3603 | 48 |
2269266 | 2269266 | 2022-03-03 | Pike | Indiana | 18125 | 3715 | 48 |
2266011 | 2266011 | 2022-03-02 | Parke | Indiana | 18121 | 3601 | 48 |
2266013 | 2266013 | 2022-03-02 | Pike | Indiana | 18125 | 3714 | 48 |
2262760 | 2262760 | 2022-03-01 | Parke | Indiana | 18121 | 3601 | 48 |
2262762 | 2262762 | 2022-03-01 | Pike | Indiana | 18125 | 3713 | 48 |
2259509 | 2259509 | 2022-02-28 | Parke | Indiana | 18121 | 3598 | 48 |
2259511 | 2259511 | 2022-02-28 | Pike | Indiana | 18125 | 3711 | 48 |
2256258 | 2256258 | 2022-02-27 | Parke | Indiana | 18121 | 3597 | 48 |
2256260 | 2256260 | 2022-02-27 | Pike | Indiana | 18125 | 3708 | 48 |
2253007 | 2253007 | 2022-02-26 | Parke | Indiana | 18121 | 3597 | 48 |
2253009 | 2253009 | 2022-02-26 | Pike | Indiana | 18125 | 3708 | 48 |
2249756 | 2249756 | 2022-02-25 | Parke | Indiana | 18121 | 3597 | 48 |
2249758 | 2249758 | 2022-02-25 | Pike | Indiana | 18125 | 3708 | 48 |
2246505 | 2246505 | 2022-02-24 | Parke | Indiana | 18121 | 3596 | 48 |
2246507 | 2246507 | 2022-02-24 | Pike | Indiana | 18125 | 3707 | 48 |
2243256 | 2243256 | 2022-02-23 | Pike | Indiana | 18125 | 3704 | 48 |
2240005 | 2240005 | 2022-02-22 | Pike | Indiana | 18125 | 3702 | 48 |
2236754 | 2236754 | 2022-02-21 | Pike | Indiana | 18125 | 3700 | 48 |
2233503 | 2233503 | 2022-02-20 | Pike | Indiana | 18125 | 3686 | 48 |
2230252 | 2230252 | 2022-02-19 | Pike | Indiana | 18125 | 3686 | 48 |
2227001 | 2227001 | 2022-02-18 | Pike | Indiana | 18125 | 3686 | 48 |
2223750 | 2223750 | 2022-02-17 | Pike | Indiana | 18125 | 3685 | 48 |
2220499 | 2220499 | 2022-02-16 | Pike | Indiana | 18125 | 3683 | 48 |
2217248 | 2217248 | 2022-02-15 | Pike | Indiana | 18125 | 3677 | 48 |
2213997 | 2213997 | 2022-02-14 | Pike | Indiana | 18125 | 3675 | 48 |
2210745 | 2210745 | 2022-02-13 | Pike | Indiana | 18125 | 3659 | 48 |
2207492 | 2207492 | 2022-02-12 | Pike | Indiana | 18125 | 3659 | 48 |
2204239 | 2204239 | 2022-02-11 | Pike | Indiana | 18125 | 3659 | 48 |
2200986 | 2200986 | 2022-02-10 | Pike | Indiana | 18125 | 3652 | 48 |
2197732 | 2197732 | 2022-02-09 | Pike | Indiana | 18125 | 3632 | 48 |
2194478 | 2194478 | 2022-02-08 | Pike | Indiana | 18125 | 3632 | 48 |
2191224 | 2191224 | 2022-02-07 | Pike | Indiana | 18125 | 3629 | 48 |
2187971 | 2187971 | 2022-02-06 | Pike | Indiana | 18125 | 3616 | 48 |
2184718 | 2184718 | 2022-02-05 | Pike | Indiana | 18125 | 3616 | 48 |
2181466 | 2181466 | 2022-02-04 | Pike | Indiana | 18125 | 3616 | 48 |
2174962 | 2174962 | 2022-02-02 | Pike | Indiana | 18125 | 3574 | 48 |
2171709 | 2171709 | 2022-02-01 | Pike | Indiana | 18125 | 3554 | 48 |
2168456 | 2168456 | 2022-01-31 | Pike | Indiana | 18125 | 3547 | 48 |
2165201 | 2165201 | 2022-01-30 | Pike | Indiana | 18125 | 3490 | 48 |
2165203 | 2165203 | 2022-01-30 | Posey | Indiana | 18129 | 6084 | 48 |
2161946 | 2161946 | 2022-01-29 | Pike | Indiana | 18125 | 3490 | 48 |
2161948 | 2161948 | 2022-01-29 | Posey | Indiana | 18129 | 6084 | 48 |
2158691 | 2158691 | 2022-01-28 | Pike | Indiana | 18125 | 3490 | 48 |
2158693 | 2158693 | 2022-01-28 | Posey | Indiana | 18129 | 6084 | 48 |
2155439 | 2155439 | 2022-01-27 | Posey | Indiana | 18129 | 6001 | 48 |
2152186 | 2152186 | 2022-01-26 | Posey | Indiana | 18129 | 5915 | 48 |
2148934 | 2148934 | 2022-01-25 | Posey | Indiana | 18129 | 5878 | 48 |
2145682 | 2145682 | 2022-01-24 | Posey | Indiana | 18129 | 5801 | 48 |
2142427 | 2142427 | 2022-01-23 | Posey | Indiana | 18129 | 5616 | 48 |
2139172 | 2139172 | 2022-01-22 | Posey | Indiana | 18129 | 5616 | 48 |
2135916 | 2135916 | 2022-01-21 | Posey | Indiana | 18129 | 5616 | 48 |
2132664 | 2132664 | 2022-01-20 | Posey | Indiana | 18129 | 5526 | 48 |
2129411 | 2129411 | 2022-01-19 | Posey | Indiana | 18129 | 5434 | 48 |
2087082 | 2087082 | 2022-01-06 | Carroll | Indiana | 18015 | 3371 | 48 |
2083830 | 2083830 | 2022-01-05 | Carroll | Indiana | 18015 | 3340 | 48 |
2018818 | 2018818 | 2021-12-16 | Blackford | Indiana | 18009 | 2353 | 48 |
2015568 | 2015568 | 2021-12-15 | Blackford | Indiana | 18009 | 2349 | 48 |
1986379 | 1986379 | 2021-12-06 | Spencer | Indiana | 18147 | 3654 | 48 |
1983129 | 1983129 | 2021-12-05 | Spencer | Indiana | 18147 | 3625 | 48 |
1979879 | 1979879 | 2021-12-04 | Spencer | Indiana | 18147 | 3625 | 48 |
1976629 | 1976629 | 2021-12-03 | Spencer | Indiana | 18147 | 3625 | 48 |
1973380 | 1973380 | 2021-12-02 | Spencer | Indiana | 18147 | 3610 | 48 |
1970130 | 1970130 | 2021-12-01 | Spencer | Indiana | 18147 | 3595 | 48 |
1966880 | 1966880 | 2021-11-30 | Spencer | Indiana | 18147 | 3576 | 48 |
1937573 | 1937573 | 2021-11-21 | Franklin | Indiana | 18047 | 2826 | 48 |
1934323 | 1934323 | 2021-11-20 | Franklin | Indiana | 18047 | 2826 | 48 |
1931072 | 1931072 | 2021-11-19 | Franklin | Indiana | 18047 | 2826 | 48 |
1927821 | 1927821 | 2021-11-18 | Franklin | Indiana | 18047 | 2808 | 48 |
1924571 | 1924571 | 2021-11-17 | Franklin | Indiana | 18047 | 2797 | 48 |
1921322 | 1921322 | 2021-11-16 | Franklin | Indiana | 18047 | 2787 | 48 |
1918072 | 1918072 | 2021-11-15 | Franklin | Indiana | 18047 | 2781 | 48 |
1914822 | 1914822 | 2021-11-14 | Franklin | Indiana | 18047 | 2767 | 48 |
1911572 | 1911572 | 2021-11-13 | Franklin | Indiana | 18047 | 2767 | 48 |
1908323 | 1908323 | 2021-11-12 | Franklin | Indiana | 18047 | 2767 | 48 |
1869312 | 1869312 | 2021-10-31 | Brown | Indiana | 18013 | 1491 | 48 |
1866063 | 1866063 | 2021-10-30 | Brown | Indiana | 18013 | 1491 | 48 |
1862814 | 1862814 | 2021-10-29 | Brown | Indiana | 18013 | 1491 | 48 |
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);