ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 18091 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174944 | 2174944 | 2022-02-02 | LaPorte | Indiana | 18091 | 24719 | 331 |
2171691 | 2171691 | 2022-02-01 | LaPorte | Indiana | 18091 | 24666 | 329 |
2168438 | 2168438 | 2022-01-31 | LaPorte | Indiana | 18091 | 24600 | 324 |
2165183 | 2165183 | 2022-01-30 | LaPorte | Indiana | 18091 | 24415 | 324 |
2161928 | 2161928 | 2022-01-29 | LaPorte | Indiana | 18091 | 24415 | 324 |
2158673 | 2158673 | 2022-01-28 | LaPorte | Indiana | 18091 | 24415 | 324 |
2155419 | 2155419 | 2022-01-27 | LaPorte | Indiana | 18091 | 24208 | 323 |
2152166 | 2152166 | 2022-01-26 | LaPorte | Indiana | 18091 | 24061 | 322 |
2148914 | 2148914 | 2022-01-25 | LaPorte | Indiana | 18091 | 24026 | 318 |
2145662 | 2145662 | 2022-01-24 | LaPorte | Indiana | 18091 | 23934 | 317 |
2142407 | 2142407 | 2022-01-23 | LaPorte | Indiana | 18091 | 23613 | 317 |
2139152 | 2139152 | 2022-01-22 | LaPorte | Indiana | 18091 | 23613 | 317 |
2135896 | 2135896 | 2022-01-21 | LaPorte | Indiana | 18091 | 23613 | 317 |
2132644 | 2132644 | 2022-01-20 | LaPorte | Indiana | 18091 | 23443 | 313 |
2129391 | 2129391 | 2022-01-19 | LaPorte | Indiana | 18091 | 23282 | 311 |
2126137 | 2126137 | 2022-01-18 | LaPorte | Indiana | 18091 | 23092 | 311 |
2122885 | 2122885 | 2022-01-17 | LaPorte | Indiana | 18091 | 22907 | 311 |
2119633 | 2119633 | 2022-01-16 | LaPorte | Indiana | 18091 | 22371 | 310 |
2116381 | 2116381 | 2022-01-15 | LaPorte | Indiana | 18091 | 22371 | 310 |
2113130 | 2113130 | 2022-01-14 | LaPorte | Indiana | 18091 | 22371 | 310 |
2109878 | 2109878 | 2022-01-13 | LaPorte | Indiana | 18091 | 22210 | 306 |
2106627 | 2106627 | 2022-01-12 | LaPorte | Indiana | 18091 | 21987 | 305 |
2103376 | 2103376 | 2022-01-11 | LaPorte | Indiana | 18091 | 21818 | 305 |
2100125 | 2100125 | 2022-01-10 | LaPorte | Indiana | 18091 | 21680 | 304 |
2096874 | 2096874 | 2022-01-09 | LaPorte | Indiana | 18091 | 21042 | 300 |
2093622 | 2093622 | 2022-01-08 | LaPorte | Indiana | 18091 | 21042 | 300 |
2090370 | 2090370 | 2022-01-07 | LaPorte | Indiana | 18091 | 21042 | 300 |
2087119 | 2087119 | 2022-01-06 | LaPorte | Indiana | 18091 | 20771 | 297 |
2083867 | 2083867 | 2022-01-05 | LaPorte | Indiana | 18091 | 20505 | 293 |
2080615 | 2080615 | 2022-01-04 | LaPorte | Indiana | 18091 | 20323 | 291 |
2077363 | 2077363 | 2022-01-03 | LaPorte | Indiana | 18091 | 19995 | 287 |
2074112 | 2074112 | 2022-01-02 | LaPorte | Indiana | 18091 | 19369 | 286 |
2070861 | 2070861 | 2022-01-01 | LaPorte | Indiana | 18091 | 19369 | 286 |
2067610 | 2067610 | 2021-12-31 | LaPorte | Indiana | 18091 | 19369 | 286 |
2064359 | 2064359 | 2021-12-30 | LaPorte | Indiana | 18091 | 19369 | 286 |
2061109 | 2061109 | 2021-12-29 | LaPorte | Indiana | 18091 | 19180 | 285 |
2057860 | 2057860 | 2021-12-28 | LaPorte | Indiana | 18091 | 19033 | 285 |
2054611 | 2054611 | 2021-12-27 | LaPorte | Indiana | 18091 | 18953 | 284 |
2051361 | 2051361 | 2021-12-26 | LaPorte | Indiana | 18091 | 18579 | 284 |
2048111 | 2048111 | 2021-12-25 | LaPorte | Indiana | 18091 | 18579 | 284 |
2044861 | 2044861 | 2021-12-24 | LaPorte | Indiana | 18091 | 18579 | 284 |
2041612 | 2041612 | 2021-12-23 | LaPorte | Indiana | 18091 | 18579 | 284 |
2038362 | 2038362 | 2021-12-22 | LaPorte | Indiana | 18091 | 18579 | 284 |
2035112 | 2035112 | 2021-12-21 | LaPorte | Indiana | 18091 | 18522 | 284 |
2031862 | 2031862 | 2021-12-20 | LaPorte | Indiana | 18091 | 18453 | 283 |
2028611 | 2028611 | 2021-12-19 | LaPorte | Indiana | 18091 | 18256 | 281 |
2025360 | 2025360 | 2021-12-18 | LaPorte | Indiana | 18091 | 18256 | 281 |
2022109 | 2022109 | 2021-12-17 | LaPorte | Indiana | 18091 | 18256 | 281 |
2018858 | 2018858 | 2021-12-16 | LaPorte | Indiana | 18091 | 18192 | 281 |
2015608 | 2015608 | 2021-12-15 | LaPorte | Indiana | 18091 | 18132 | 280 |
2012357 | 2012357 | 2021-12-14 | LaPorte | Indiana | 18091 | 18073 | 279 |
2009106 | 2009106 | 2021-12-13 | LaPorte | Indiana | 18091 | 17990 | 275 |
2005855 | 2005855 | 2021-12-12 | LaPorte | Indiana | 18091 | 17782 | 274 |
2002604 | 2002604 | 2021-12-11 | LaPorte | Indiana | 18091 | 17782 | 274 |
1999354 | 1999354 | 2021-12-10 | LaPorte | Indiana | 18091 | 17782 | 274 |
1996103 | 1996103 | 2021-12-09 | LaPorte | Indiana | 18091 | 17663 | 272 |
1992852 | 1992852 | 2021-12-08 | LaPorte | Indiana | 18091 | 17577 | 270 |
1989601 | 1989601 | 2021-12-07 | LaPorte | Indiana | 18091 | 17499 | 270 |
1986351 | 1986351 | 2021-12-06 | LaPorte | Indiana | 18091 | 17418 | 265 |
1983101 | 1983101 | 2021-12-05 | LaPorte | Indiana | 18091 | 17205 | 265 |
1979851 | 1979851 | 2021-12-04 | LaPorte | Indiana | 18091 | 17205 | 265 |
1976601 | 1976601 | 2021-12-03 | LaPorte | Indiana | 18091 | 17205 | 265 |
1973352 | 1973352 | 2021-12-02 | LaPorte | Indiana | 18091 | 17128 | 265 |
1970102 | 1970102 | 2021-12-01 | LaPorte | Indiana | 18091 | 17032 | 265 |
1966852 | 1966852 | 2021-11-30 | LaPorte | Indiana | 18091 | 16937 | 265 |
1963600 | 1963600 | 2021-11-29 | LaPorte | Indiana | 18091 | 16870 | 264 |
1960349 | 1960349 | 2021-11-28 | LaPorte | Indiana | 18091 | 16651 | 264 |
1957098 | 1957098 | 2021-11-27 | LaPorte | Indiana | 18091 | 16651 | 264 |
1953847 | 1953847 | 2021-11-26 | LaPorte | Indiana | 18091 | 16651 | 264 |
1950596 | 1950596 | 2021-11-25 | LaPorte | Indiana | 18091 | 16651 | 264 |
1947345 | 1947345 | 2021-11-24 | LaPorte | Indiana | 18091 | 16651 | 264 |
1944094 | 1944094 | 2021-11-23 | LaPorte | Indiana | 18091 | 16585 | 264 |
1940844 | 1940844 | 2021-11-22 | LaPorte | Indiana | 18091 | 16532 | 264 |
1937594 | 1937594 | 2021-11-21 | LaPorte | Indiana | 18091 | 16402 | 264 |
1934344 | 1934344 | 2021-11-20 | LaPorte | Indiana | 18091 | 16402 | 264 |
1931093 | 1931093 | 2021-11-19 | LaPorte | Indiana | 18091 | 16402 | 264 |
1927842 | 1927842 | 2021-11-18 | LaPorte | Indiana | 18091 | 16326 | 263 |
1924592 | 1924592 | 2021-11-17 | LaPorte | Indiana | 18091 | 16257 | 263 |
1921343 | 1921343 | 2021-11-16 | LaPorte | Indiana | 18091 | 16197 | 261 |
1918093 | 1918093 | 2021-11-15 | LaPorte | Indiana | 18091 | 16149 | 260 |
1914843 | 1914843 | 2021-11-14 | LaPorte | Indiana | 18091 | 16018 | 260 |
1911593 | 1911593 | 2021-11-13 | LaPorte | Indiana | 18091 | 16018 | 260 |
1908344 | 1908344 | 2021-11-12 | LaPorte | Indiana | 18091 | 16018 | 260 |
1905095 | 1905095 | 2021-11-11 | LaPorte | Indiana | 18091 | 15958 | 257 |
1901845 | 1901845 | 2021-11-10 | LaPorte | Indiana | 18091 | 15820 | 256 |
1898595 | 1898595 | 2021-11-09 | LaPorte | Indiana | 18091 | 15778 | 256 |
1895345 | 1895345 | 2021-11-08 | LaPorte | Indiana | 18091 | 15743 | 256 |
1892095 | 1892095 | 2021-11-07 | LaPorte | Indiana | 18091 | 15631 | 256 |
1888845 | 1888845 | 2021-11-06 | LaPorte | Indiana | 18091 | 15631 | 256 |
1885595 | 1885595 | 2021-11-05 | LaPorte | Indiana | 18091 | 15631 | 256 |
1882346 | 1882346 | 2021-11-04 | LaPorte | Indiana | 18091 | 15576 | 256 |
1879097 | 1879097 | 2021-11-03 | LaPorte | Indiana | 18091 | 15536 | 256 |
1875848 | 1875848 | 2021-11-02 | LaPorte | Indiana | 18091 | 15499 | 256 |
1872599 | 1872599 | 2021-11-01 | LaPorte | Indiana | 18091 | 15465 | 256 |
1869350 | 1869350 | 2021-10-31 | LaPorte | Indiana | 18091 | 15374 | 255 |
1866101 | 1866101 | 2021-10-30 | LaPorte | Indiana | 18091 | 15374 | 255 |
1862852 | 1862852 | 2021-10-29 | LaPorte | Indiana | 18091 | 15374 | 255 |
1859603 | 1859603 | 2021-10-28 | LaPorte | Indiana | 18091 | 15327 | 255 |
1856354 | 1856354 | 2021-10-27 | LaPorte | Indiana | 18091 | 15291 | 255 |
1853105 | 1853105 | 2021-10-26 | LaPorte | Indiana | 18091 | 15261 | 255 |
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);