ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
129 rows where deaths = 154 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500293 | 2500293 | 2022-05-13 | Daviess | Indiana | 18027 | 7496 | 154 |
2497035 | 2497035 | 2022-05-12 | Daviess | Indiana | 18027 | 7493 | 154 |
2493777 | 2493777 | 2022-05-11 | Daviess | Indiana | 18027 | 7493 | 154 |
2490519 | 2490519 | 2022-05-10 | Daviess | Indiana | 18027 | 7495 | 154 |
2487262 | 2487262 | 2022-05-09 | Daviess | Indiana | 18027 | 7495 | 154 |
2484004 | 2484004 | 2022-05-08 | Daviess | Indiana | 18027 | 7489 | 154 |
2480746 | 2480746 | 2022-05-07 | Daviess | Indiana | 18027 | 7489 | 154 |
2477488 | 2477488 | 2022-05-06 | Daviess | Indiana | 18027 | 7489 | 154 |
2474230 | 2474230 | 2022-05-05 | Daviess | Indiana | 18027 | 7489 | 154 |
2470973 | 2470973 | 2022-05-04 | Daviess | Indiana | 18027 | 7489 | 154 |
2467717 | 2467717 | 2022-05-03 | Daviess | Indiana | 18027 | 7484 | 154 |
2464462 | 2464462 | 2022-05-02 | Daviess | Indiana | 18027 | 7484 | 154 |
2461206 | 2461206 | 2022-05-01 | Daviess | Indiana | 18027 | 7482 | 154 |
2457950 | 2457950 | 2022-04-30 | Daviess | Indiana | 18027 | 7482 | 154 |
2454694 | 2454694 | 2022-04-29 | Daviess | Indiana | 18027 | 7482 | 154 |
2451438 | 2451438 | 2022-04-28 | Daviess | Indiana | 18027 | 7480 | 154 |
2448182 | 2448182 | 2022-04-27 | Daviess | Indiana | 18027 | 7480 | 154 |
2360318 | 2360318 | 2022-03-31 | Jefferson | Indiana | 18077 | 9337 | 154 |
2360364 | 2360364 | 2022-03-31 | Wabash | Indiana | 18169 | 8713 | 154 |
2357064 | 2357064 | 2022-03-30 | Jefferson | Indiana | 18077 | 9337 | 154 |
2357110 | 2357110 | 2022-03-30 | Wabash | Indiana | 18169 | 8713 | 154 |
2353811 | 2353811 | 2022-03-29 | Jefferson | Indiana | 18077 | 9349 | 154 |
2353857 | 2353857 | 2022-03-29 | Wabash | Indiana | 18169 | 8718 | 154 |
2350559 | 2350559 | 2022-03-28 | Jefferson | Indiana | 18077 | 9350 | 154 |
2350605 | 2350605 | 2022-03-28 | Wabash | Indiana | 18169 | 8717 | 154 |
2347306 | 2347306 | 2022-03-27 | Jefferson | Indiana | 18077 | 9349 | 154 |
2347352 | 2347352 | 2022-03-27 | Wabash | Indiana | 18169 | 8714 | 154 |
2344053 | 2344053 | 2022-03-26 | Jefferson | Indiana | 18077 | 9349 | 154 |
2344099 | 2344099 | 2022-03-26 | Wabash | Indiana | 18169 | 8714 | 154 |
2340800 | 2340800 | 2022-03-25 | Jefferson | Indiana | 18077 | 9349 | 154 |
2340846 | 2340846 | 2022-03-25 | Wabash | Indiana | 18169 | 8714 | 154 |
2337547 | 2337547 | 2022-03-24 | Jefferson | Indiana | 18077 | 9349 | 154 |
2337593 | 2337593 | 2022-03-24 | Wabash | Indiana | 18169 | 8714 | 154 |
2334293 | 2334293 | 2022-03-23 | Jefferson | Indiana | 18077 | 9348 | 154 |
2334339 | 2334339 | 2022-03-23 | Wabash | Indiana | 18169 | 8714 | 154 |
2331039 | 2331039 | 2022-03-22 | Jefferson | Indiana | 18077 | 9347 | 154 |
2331085 | 2331085 | 2022-03-22 | Wabash | Indiana | 18169 | 8714 | 154 |
2327787 | 2327787 | 2022-03-21 | Jefferson | Indiana | 18077 | 9347 | 154 |
2327833 | 2327833 | 2022-03-21 | Wabash | Indiana | 18169 | 8713 | 154 |
2324534 | 2324534 | 2022-03-20 | Jefferson | Indiana | 18077 | 9345 | 154 |
2324580 | 2324580 | 2022-03-20 | Wabash | Indiana | 18169 | 8711 | 154 |
2321280 | 2321280 | 2022-03-19 | Jefferson | Indiana | 18077 | 9345 | 154 |
2321326 | 2321326 | 2022-03-19 | Wabash | Indiana | 18169 | 8711 | 154 |
2318026 | 2318026 | 2022-03-18 | Jefferson | Indiana | 18077 | 9345 | 154 |
2318072 | 2318072 | 2022-03-18 | Wabash | Indiana | 18169 | 8711 | 154 |
2314773 | 2314773 | 2022-03-17 | Jefferson | Indiana | 18077 | 9345 | 154 |
2311520 | 2311520 | 2022-03-16 | Jefferson | Indiana | 18077 | 9344 | 154 |
2308267 | 2308267 | 2022-03-15 | Jefferson | Indiana | 18077 | 9343 | 154 |
2305016 | 2305016 | 2022-03-14 | Jefferson | Indiana | 18077 | 9342 | 154 |
2246496 | 2246496 | 2022-02-24 | Miami | Indiana | 18103 | 9204 | 154 |
2246501 | 2246501 | 2022-02-24 | Noble | Indiana | 18113 | 13012 | 154 |
2243250 | 2243250 | 2022-02-23 | Noble | Indiana | 18113 | 13007 | 154 |
2239999 | 2239999 | 2022-02-22 | Noble | Indiana | 18113 | 12998 | 154 |
2200932 | 2200932 | 2022-02-10 | Cass | Indiana | 18017 | 11303 | 154 |
2197678 | 2197678 | 2022-02-09 | Cass | Indiana | 18017 | 11226 | 154 |
2197723 | 2197723 | 2022-02-09 | Montgomery | Indiana | 18107 | 10365 | 154 |
2194424 | 2194424 | 2022-02-08 | Cass | Indiana | 18017 | 11226 | 154 |
2194469 | 2194469 | 2022-02-08 | Montgomery | Indiana | 18107 | 10365 | 154 |
2191170 | 2191170 | 2022-02-07 | Cass | Indiana | 18017 | 11212 | 154 |
2191215 | 2191215 | 2022-02-07 | Montgomery | Indiana | 18107 | 10347 | 154 |
2187917 | 2187917 | 2022-02-06 | Cass | Indiana | 18017 | 11199 | 154 |
2184664 | 2184664 | 2022-02-05 | Cass | Indiana | 18017 | 11199 | 154 |
2181412 | 2181412 | 2022-02-04 | Cass | Indiana | 18017 | 11199 | 154 |
2178161 | 2178161 | 2022-02-03 | Cass | Indiana | 18017 | 11175 | 154 |
2174908 | 2174908 | 2022-02-02 | Cass | Indiana | 18017 | 11093 | 154 |
2171652 | 2171652 | 2022-02-01 | Boone | Indiana | 18011 | 14513 | 154 |
2168399 | 2168399 | 2022-01-31 | Boone | Indiana | 18011 | 14459 | 154 |
2165144 | 2165144 | 2022-01-30 | Boone | Indiana | 18011 | 14309 | 154 |
2161889 | 2161889 | 2022-01-29 | Boone | Indiana | 18011 | 14309 | 154 |
2158634 | 2158634 | 2022-01-28 | Boone | Indiana | 18011 | 14309 | 154 |
2155380 | 2155380 | 2022-01-27 | Boone | Indiana | 18011 | 14141 | 154 |
2145636 | 2145636 | 2022-01-24 | Dubois | Indiana | 18037 | 11699 | 154 |
2142381 | 2142381 | 2022-01-23 | Dubois | Indiana | 18037 | 11421 | 154 |
2139126 | 2139126 | 2022-01-22 | Dubois | Indiana | 18037 | 11421 | 154 |
2135870 | 2135870 | 2022-01-21 | Dubois | Indiana | 18037 | 11421 | 154 |
2132618 | 2132618 | 2022-01-20 | Dubois | Indiana | 18037 | 11260 | 154 |
2129365 | 2129365 | 2022-01-19 | Dubois | Indiana | 18037 | 11126 | 154 |
2126111 | 2126111 | 2022-01-18 | Dubois | Indiana | 18037 | 10957 | 154 |
2122859 | 2122859 | 2022-01-17 | Dubois | Indiana | 18037 | 10785 | 154 |
1996108 | 1996108 | 2021-12-09 | Marshall | Indiana | 18099 | 9415 | 154 |
1992857 | 1992857 | 2021-12-08 | Marshall | Indiana | 18099 | 9365 | 154 |
1989606 | 1989606 | 2021-12-07 | Marshall | Indiana | 18099 | 9331 | 154 |
1986356 | 1986356 | 2021-12-06 | Marshall | Indiana | 18099 | 9304 | 154 |
1983106 | 1983106 | 2021-12-05 | Marshall | Indiana | 18099 | 9161 | 154 |
1979856 | 1979856 | 2021-12-04 | Marshall | Indiana | 18099 | 9161 | 154 |
1976606 | 1976606 | 2021-12-03 | Marshall | Indiana | 18099 | 9161 | 154 |
1875846 | 1875846 | 2021-11-02 | Kosciusko | Indiana | 18085 | 12657 | 154 |
1872597 | 1872597 | 2021-11-01 | Kosciusko | Indiana | 18085 | 12636 | 154 |
1869348 | 1869348 | 2021-10-31 | Kosciusko | Indiana | 18085 | 12586 | 154 |
1866099 | 1866099 | 2021-10-30 | Kosciusko | Indiana | 18085 | 12586 | 154 |
1862850 | 1862850 | 2021-10-29 | Kosciusko | Indiana | 18085 | 12586 | 154 |
1859601 | 1859601 | 2021-10-28 | Kosciusko | Indiana | 18085 | 12536 | 154 |
1856352 | 1856352 | 2021-10-27 | Kosciusko | Indiana | 18085 | 12499 | 154 |
1853103 | 1853103 | 2021-10-26 | Kosciusko | Indiana | 18085 | 12453 | 154 |
1849854 | 1849854 | 2021-10-25 | Kosciusko | Indiana | 18085 | 12430 | 154 |
1814103 | 1814103 | 2021-10-14 | Henry | Indiana | 18065 | 8116 | 154 |
1648438 | 1648438 | 2021-08-24 | Morgan | Indiana | 18109 | 7606 | 154 |
1645190 | 1645190 | 2021-08-23 | Morgan | Indiana | 18109 | 7565 | 154 |
1641941 | 1641941 | 2021-08-22 | Morgan | Indiana | 18109 | 7444 | 154 |
1638691 | 1638691 | 2021-08-21 | Morgan | Indiana | 18109 | 7444 | 154 |
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);