ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Marion" and fips = 18097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174948 | 2174948 | 2022-02-02 | Marion | Indiana | 18097 | 219200 | 2774 |
2171695 | 2171695 | 2022-02-01 | Marion | Indiana | 18097 | 218675 | 2760 |
2168442 | 2168442 | 2022-01-31 | Marion | Indiana | 18097 | 218128 | 2738 |
2165187 | 2165187 | 2022-01-30 | Marion | Indiana | 18097 | 216186 | 2733 |
2161932 | 2161932 | 2022-01-29 | Marion | Indiana | 18097 | 216186 | 2733 |
2158677 | 2158677 | 2022-01-28 | Marion | Indiana | 18097 | 216186 | 2733 |
2155423 | 2155423 | 2022-01-27 | Marion | Indiana | 18097 | 214491 | 2713 |
2152170 | 2152170 | 2022-01-26 | Marion | Indiana | 18097 | 213428 | 2691 |
2148918 | 2148918 | 2022-01-25 | Marion | Indiana | 18097 | 212978 | 2671 |
2145666 | 2145666 | 2022-01-24 | Marion | Indiana | 18097 | 212050 | 2655 |
2142411 | 2142411 | 2022-01-23 | Marion | Indiana | 18097 | 208002 | 2648 |
2139156 | 2139156 | 2022-01-22 | Marion | Indiana | 18097 | 208002 | 2648 |
2135900 | 2135900 | 2022-01-21 | Marion | Indiana | 18097 | 208002 | 2648 |
2132648 | 2132648 | 2022-01-20 | Marion | Indiana | 18097 | 205924 | 2634 |
2129395 | 2129395 | 2022-01-19 | Marion | Indiana | 18097 | 204153 | 2610 |
2126141 | 2126141 | 2022-01-18 | Marion | Indiana | 18097 | 202346 | 2592 |
2122889 | 2122889 | 2022-01-17 | Marion | Indiana | 18097 | 200826 | 2582 |
2119637 | 2119637 | 2022-01-16 | Marion | Indiana | 18097 | 195148 | 2572 |
2116385 | 2116385 | 2022-01-15 | Marion | Indiana | 18097 | 195148 | 2572 |
2113134 | 2113134 | 2022-01-14 | Marion | Indiana | 18097 | 195148 | 2572 |
2109882 | 2109882 | 2022-01-13 | Marion | Indiana | 18097 | 192862 | 2564 |
2106631 | 2106631 | 2022-01-12 | Marion | Indiana | 18097 | 190626 | 2556 |
2103380 | 2103380 | 2022-01-11 | Marion | Indiana | 18097 | 188437 | 2538 |
2100129 | 2100129 | 2022-01-10 | Marion | Indiana | 18097 | 186452 | 2526 |
2096878 | 2096878 | 2022-01-09 | Marion | Indiana | 18097 | 179388 | 2510 |
2093626 | 2093626 | 2022-01-08 | Marion | Indiana | 18097 | 179388 | 2510 |
2090374 | 2090374 | 2022-01-07 | Marion | Indiana | 18097 | 179388 | 2510 |
2087123 | 2087123 | 2022-01-06 | Marion | Indiana | 18097 | 176605 | 2491 |
2083871 | 2083871 | 2022-01-05 | Marion | Indiana | 18097 | 173869 | 2469 |
2080619 | 2080619 | 2022-01-04 | Marion | Indiana | 18097 | 171694 | 2466 |
2077367 | 2077367 | 2022-01-03 | Marion | Indiana | 18097 | 170045 | 2448 |
2074116 | 2074116 | 2022-01-02 | Marion | Indiana | 18097 | 163539 | 2445 |
2070865 | 2070865 | 2022-01-01 | Marion | Indiana | 18097 | 163539 | 2445 |
2067614 | 2067614 | 2021-12-31 | Marion | Indiana | 18097 | 163539 | 2445 |
2064363 | 2064363 | 2021-12-30 | Marion | Indiana | 18097 | 163539 | 2445 |
2061113 | 2061113 | 2021-12-29 | Marion | Indiana | 18097 | 160894 | 2440 |
2057864 | 2057864 | 2021-12-28 | Marion | Indiana | 18097 | 159458 | 2437 |
2054615 | 2054615 | 2021-12-27 | Marion | Indiana | 18097 | 158362 | 2421 |
2051365 | 2051365 | 2021-12-26 | Marion | Indiana | 18097 | 155043 | 2414 |
2048115 | 2048115 | 2021-12-25 | Marion | Indiana | 18097 | 155043 | 2414 |
2044865 | 2044865 | 2021-12-24 | Marion | Indiana | 18097 | 155043 | 2414 |
2041616 | 2041616 | 2021-12-23 | Marion | Indiana | 18097 | 155043 | 2414 |
2038366 | 2038366 | 2021-12-22 | Marion | Indiana | 18097 | 155043 | 2414 |
2035116 | 2035116 | 2021-12-21 | Marion | Indiana | 18097 | 154394 | 2406 |
2031866 | 2031866 | 2021-12-20 | Marion | Indiana | 18097 | 153892 | 2396 |
2028615 | 2028615 | 2021-12-19 | Marion | Indiana | 18097 | 152389 | 2386 |
2025364 | 2025364 | 2021-12-18 | Marion | Indiana | 18097 | 152389 | 2386 |
2022113 | 2022113 | 2021-12-17 | Marion | Indiana | 18097 | 152389 | 2386 |
2018862 | 2018862 | 2021-12-16 | Marion | Indiana | 18097 | 151794 | 2381 |
2015612 | 2015612 | 2021-12-15 | Marion | Indiana | 18097 | 151098 | 2377 |
2012361 | 2012361 | 2021-12-14 | Marion | Indiana | 18097 | 150706 | 2367 |
2009110 | 2009110 | 2021-12-13 | Marion | Indiana | 18097 | 150255 | 2360 |
2005859 | 2005859 | 2021-12-12 | Marion | Indiana | 18097 | 149028 | 2354 |
2002608 | 2002608 | 2021-12-11 | Marion | Indiana | 18097 | 149028 | 2354 |
1999358 | 1999358 | 2021-12-10 | Marion | Indiana | 18097 | 149028 | 2354 |
1996107 | 1996107 | 2021-12-09 | Marion | Indiana | 18097 | 148573 | 2350 |
1992856 | 1992856 | 2021-12-08 | Marion | Indiana | 18097 | 147986 | 2345 |
1989605 | 1989605 | 2021-12-07 | Marion | Indiana | 18097 | 147613 | 2336 |
1986355 | 1986355 | 2021-12-06 | Marion | Indiana | 18097 | 147098 | 2322 |
1983105 | 1983105 | 2021-12-05 | Marion | Indiana | 18097 | 145811 | 2320 |
1979855 | 1979855 | 2021-12-04 | Marion | Indiana | 18097 | 145811 | 2320 |
1976605 | 1976605 | 2021-12-03 | Marion | Indiana | 18097 | 145811 | 2320 |
1973356 | 1973356 | 2021-12-02 | Marion | Indiana | 18097 | 145305 | 2317 |
1970106 | 1970106 | 2021-12-01 | Marion | Indiana | 18097 | 144825 | 2314 |
1966856 | 1966856 | 2021-11-30 | Marion | Indiana | 18097 | 144385 | 2311 |
1963604 | 1963604 | 2021-11-29 | Marion | Indiana | 18097 | 144010 | 2302 |
1960353 | 1960353 | 2021-11-28 | Marion | Indiana | 18097 | 142778 | 2297 |
1957102 | 1957102 | 2021-11-27 | Marion | Indiana | 18097 | 142778 | 2297 |
1953851 | 1953851 | 2021-11-26 | Marion | Indiana | 18097 | 142778 | 2297 |
1950600 | 1950600 | 2021-11-25 | Marion | Indiana | 18097 | 142778 | 2297 |
1947349 | 1947349 | 2021-11-24 | Marion | Indiana | 18097 | 142778 | 2297 |
1944098 | 1944098 | 2021-11-23 | Marion | Indiana | 18097 | 142467 | 2294 |
1940848 | 1940848 | 2021-11-22 | Marion | Indiana | 18097 | 142158 | 2288 |
1937598 | 1937598 | 2021-11-21 | Marion | Indiana | 18097 | 141410 | 2283 |
1934348 | 1934348 | 2021-11-20 | Marion | Indiana | 18097 | 141410 | 2283 |
1931097 | 1931097 | 2021-11-19 | Marion | Indiana | 18097 | 141410 | 2283 |
1927846 | 1927846 | 2021-11-18 | Marion | Indiana | 18097 | 141078 | 2280 |
1924596 | 1924596 | 2021-11-17 | Marion | Indiana | 18097 | 140716 | 2277 |
1921347 | 1921347 | 2021-11-16 | Marion | Indiana | 18097 | 140429 | 2276 |
1918097 | 1918097 | 2021-11-15 | Marion | Indiana | 18097 | 140115 | 2272 |
1914847 | 1914847 | 2021-11-14 | Marion | Indiana | 18097 | 139593 | 2271 |
1911597 | 1911597 | 2021-11-13 | Marion | Indiana | 18097 | 139593 | 2271 |
1908348 | 1908348 | 2021-11-12 | Marion | Indiana | 18097 | 139593 | 2271 |
1905099 | 1905099 | 2021-11-11 | Marion | Indiana | 18097 | 139380 | 2262 |
1901849 | 1901849 | 2021-11-10 | Marion | Indiana | 18097 | 138797 | 2260 |
1898599 | 1898599 | 2021-11-09 | Marion | Indiana | 18097 | 138549 | 2258 |
1895349 | 1895349 | 2021-11-08 | Marion | Indiana | 18097 | 138342 | 2255 |
1892099 | 1892099 | 2021-11-07 | Marion | Indiana | 18097 | 137887 | 2252 |
1888849 | 1888849 | 2021-11-06 | Marion | Indiana | 18097 | 137887 | 2252 |
1885599 | 1885599 | 2021-11-05 | Marion | Indiana | 18097 | 137887 | 2252 |
1882350 | 1882350 | 2021-11-04 | Marion | Indiana | 18097 | 137699 | 2247 |
1879101 | 1879101 | 2021-11-03 | Marion | Indiana | 18097 | 137498 | 2241 |
1875852 | 1875852 | 2021-11-02 | Marion | Indiana | 18097 | 137358 | 2234 |
1872603 | 1872603 | 2021-11-01 | Marion | Indiana | 18097 | 137189 | 2231 |
1869354 | 1869354 | 2021-10-31 | Marion | Indiana | 18097 | 136798 | 2227 |
1866105 | 1866105 | 2021-10-30 | Marion | Indiana | 18097 | 136798 | 2227 |
1862856 | 1862856 | 2021-10-29 | Marion | Indiana | 18097 | 136798 | 2227 |
1859607 | 1859607 | 2021-10-28 | Marion | Indiana | 18097 | 136658 | 2227 |
1856358 | 1856358 | 2021-10-27 | Marion | Indiana | 18097 | 136438 | 2222 |
1853109 | 1853109 | 2021-10-26 | Marion | Indiana | 18097 | 136286 | 2213 |
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);