ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where deaths = 144 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314760 | 2314760 | 2022-03-17 | Gibson | Indiana | 18051 | 11620 | 144 |
2311507 | 2311507 | 2022-03-16 | Gibson | Indiana | 18051 | 11618 | 144 |
2308296 | 2308296 | 2022-03-15 | Randolph | Indiana | 18135 | 5931 | 144 |
2305045 | 2305045 | 2022-03-14 | Randolph | Indiana | 18135 | 5931 | 144 |
2301793 | 2301793 | 2022-03-13 | Randolph | Indiana | 18135 | 5921 | 144 |
2298541 | 2298541 | 2022-03-12 | Randolph | Indiana | 18135 | 5921 | 144 |
2295289 | 2295289 | 2022-03-11 | Randolph | Indiana | 18135 | 5921 | 144 |
2285483 | 2285483 | 2022-03-08 | Decatur | Indiana | 18031 | 7048 | 144 |
2285503 | 2285503 | 2022-03-08 | Jasper | Indiana | 18073 | 8976 | 144 |
2282251 | 2282251 | 2022-03-07 | Jasper | Indiana | 18073 | 8974 | 144 |
2278998 | 2278998 | 2022-03-06 | Jasper | Indiana | 18073 | 8969 | 144 |
2275745 | 2275745 | 2022-03-05 | Jasper | Indiana | 18073 | 8969 | 144 |
2272492 | 2272492 | 2022-03-04 | Jasper | Indiana | 18073 | 8969 | 144 |
2269240 | 2269240 | 2022-03-03 | Jasper | Indiana | 18073 | 8967 | 144 |
2265971 | 2265971 | 2022-03-02 | Fayette | Indiana | 18041 | 6845 | 144 |
2262720 | 2262720 | 2022-03-01 | Fayette | Indiana | 18041 | 6842 | 144 |
2259469 | 2259469 | 2022-02-28 | Fayette | Indiana | 18041 | 6842 | 144 |
2256218 | 2256218 | 2022-02-27 | Fayette | Indiana | 18041 | 6831 | 144 |
2252967 | 2252967 | 2022-02-26 | Fayette | Indiana | 18041 | 6831 | 144 |
2249716 | 2249716 | 2022-02-25 | Fayette | Indiana | 18041 | 6831 | 144 |
2246465 | 2246465 | 2022-02-24 | Fayette | Indiana | 18041 | 6829 | 144 |
2243214 | 2243214 | 2022-02-23 | Fayette | Indiana | 18041 | 6825 | 144 |
2223701 | 2223701 | 2022-02-17 | Daviess | Indiana | 18027 | 7408 | 144 |
2220450 | 2220450 | 2022-02-16 | Daviess | Indiana | 18027 | 7399 | 144 |
2217199 | 2217199 | 2022-02-15 | Daviess | Indiana | 18027 | 7395 | 144 |
2197684 | 2197684 | 2022-02-09 | DeKalb | Indiana | 18033 | 11155 | 144 |
2194430 | 2194430 | 2022-02-08 | DeKalb | Indiana | 18033 | 11155 | 144 |
2191246 | 2191246 | 2022-02-07 | Wabash | Indiana | 18169 | 8483 | 144 |
2187993 | 2187993 | 2022-02-06 | Wabash | Indiana | 18169 | 8448 | 144 |
2184740 | 2184740 | 2022-02-05 | Wabash | Indiana | 18169 | 8448 | 144 |
2181488 | 2181488 | 2022-02-04 | Wabash | Indiana | 18169 | 8448 | 144 |
2178237 | 2178237 | 2022-02-03 | Wabash | Indiana | 18169 | 8423 | 144 |
2174984 | 2174984 | 2022-02-02 | Wabash | Indiana | 18169 | 8396 | 144 |
2171698 | 2171698 | 2022-02-01 | Miami | Indiana | 18103 | 8889 | 144 |
2168445 | 2168445 | 2022-01-31 | Miami | Indiana | 18103 | 8860 | 144 |
2165190 | 2165190 | 2022-01-30 | Miami | Indiana | 18103 | 8741 | 144 |
2161935 | 2161935 | 2022-01-29 | Miami | Indiana | 18103 | 8741 | 144 |
2158680 | 2158680 | 2022-01-28 | Miami | Indiana | 18103 | 8741 | 144 |
2148904 | 2148904 | 2022-01-25 | Huntington | Indiana | 18069 | 10612 | 144 |
2145652 | 2145652 | 2022-01-24 | Huntington | Indiana | 18069 | 10530 | 144 |
2142397 | 2142397 | 2022-01-23 | Huntington | Indiana | 18069 | 10284 | 144 |
2139142 | 2139142 | 2022-01-22 | Huntington | Indiana | 18069 | 10284 | 144 |
2135886 | 2135886 | 2022-01-21 | Huntington | Indiana | 18069 | 10284 | 144 |
2129352 | 2129352 | 2022-01-19 | Boone | Indiana | 18011 | 13411 | 144 |
2129403 | 2129403 | 2022-01-19 | Noble | Indiana | 18113 | 11661 | 144 |
2126098 | 2126098 | 2022-01-18 | Boone | Indiana | 18011 | 13291 | 144 |
2126149 | 2126149 | 2022-01-18 | Noble | Indiana | 18113 | 11514 | 144 |
2122846 | 2122846 | 2022-01-17 | Boone | Indiana | 18011 | 13195 | 144 |
2122897 | 2122897 | 2022-01-17 | Noble | Indiana | 18113 | 11426 | 144 |
2119594 | 2119594 | 2022-01-16 | Boone | Indiana | 18011 | 12885 | 144 |
2119645 | 2119645 | 2022-01-16 | Noble | Indiana | 18113 | 11156 | 144 |
2116342 | 2116342 | 2022-01-15 | Boone | Indiana | 18011 | 12885 | 144 |
2116393 | 2116393 | 2022-01-15 | Noble | Indiana | 18113 | 11156 | 144 |
2113091 | 2113091 | 2022-01-14 | Boone | Indiana | 18011 | 12885 | 144 |
2113142 | 2113142 | 2022-01-14 | Noble | Indiana | 18113 | 11156 | 144 |
2109839 | 2109839 | 2022-01-13 | Boone | Indiana | 18011 | 12761 | 144 |
2005829 | 2005829 | 2021-12-12 | Dubois | Indiana | 18037 | 8993 | 144 |
2002578 | 2002578 | 2021-12-11 | Dubois | Indiana | 18037 | 8993 | 144 |
1999328 | 1999328 | 2021-12-10 | Dubois | Indiana | 18037 | 8993 | 144 |
1901850 | 1901850 | 2021-11-10 | Marshall | Indiana | 18099 | 8353 | 144 |
1898600 | 1898600 | 2021-11-09 | Marshall | Indiana | 18099 | 8318 | 144 |
1895350 | 1895350 | 2021-11-08 | Marshall | Indiana | 18099 | 8298 | 144 |
1892100 | 1892100 | 2021-11-07 | Marshall | Indiana | 18099 | 8246 | 144 |
1888850 | 1888850 | 2021-11-06 | Marshall | Indiana | 18099 | 8246 | 144 |
1885600 | 1885600 | 2021-11-05 | Marshall | Indiana | 18099 | 8246 | 144 |
1768613 | 1768613 | 2021-09-30 | Henry | Indiana | 18065 | 7849 | 144 |
1762125 | 1762125 | 2021-09-28 | Kosciusko | Indiana | 18085 | 11592 | 144 |
1693908 | 1693908 | 2021-09-07 | Lawrence | Indiana | 18093 | 6527 | 144 |
1323752 | 1323752 | 2021-05-16 | Morgan | Indiana | 18109 | 6623 | 144 |
1320506 | 1320506 | 2021-05-15 | Morgan | Indiana | 18109 | 6620 | 144 |
1317259 | 1317259 | 2021-05-14 | Morgan | Indiana | 18109 | 6613 | 144 |
1314012 | 1314012 | 2021-05-13 | Morgan | Indiana | 18109 | 6610 | 144 |
1310765 | 1310765 | 2021-05-12 | Morgan | Indiana | 18109 | 6599 | 144 |
1307519 | 1307519 | 2021-05-11 | Morgan | Indiana | 18109 | 6593 | 144 |
1304273 | 1304273 | 2021-05-10 | Morgan | Indiana | 18109 | 6586 | 144 |
1301026 | 1301026 | 2021-05-09 | Morgan | Indiana | 18109 | 6580 | 144 |
1297754 | 1297754 | 2021-05-08 | Hancock | Indiana | 18059 | 8284 | 144 |
1297779 | 1297779 | 2021-05-08 | Morgan | Indiana | 18109 | 6574 | 144 |
1294508 | 1294508 | 2021-05-07 | Hancock | Indiana | 18059 | 8275 | 144 |
1294533 | 1294533 | 2021-05-07 | Morgan | Indiana | 18109 | 6572 | 144 |
1291262 | 1291262 | 2021-05-06 | Hancock | Indiana | 18059 | 8263 | 144 |
1291287 | 1291287 | 2021-05-06 | Morgan | Indiana | 18109 | 6564 | 144 |
1288016 | 1288016 | 2021-05-05 | Hancock | Indiana | 18059 | 8250 | 144 |
1288041 | 1288041 | 2021-05-05 | Morgan | Indiana | 18109 | 6560 | 144 |
1284795 | 1284795 | 2021-05-04 | Morgan | Indiana | 18109 | 6546 | 144 |
1281548 | 1281548 | 2021-05-03 | Morgan | Indiana | 18109 | 6540 | 144 |
1278301 | 1278301 | 2021-05-02 | Morgan | Indiana | 18109 | 6537 | 144 |
1275054 | 1275054 | 2021-05-01 | Morgan | Indiana | 18109 | 6531 | 144 |
1271807 | 1271807 | 2021-04-30 | Morgan | Indiana | 18109 | 6522 | 144 |
1268560 | 1268560 | 2021-04-29 | Morgan | Indiana | 18109 | 6503 | 144 |
1265313 | 1265313 | 2021-04-28 | Morgan | Indiana | 18109 | 6493 | 144 |
1262066 | 1262066 | 2021-04-27 | Morgan | Indiana | 18109 | 6485 | 144 |
1258819 | 1258819 | 2021-04-26 | Morgan | Indiana | 18109 | 6479 | 144 |
1255572 | 1255572 | 2021-04-25 | Morgan | Indiana | 18109 | 6475 | 144 |
1252325 | 1252325 | 2021-04-24 | Morgan | Indiana | 18109 | 6467 | 144 |
1038066 | 1038066 | 2021-02-17 | Warrick | Indiana | 18173 | 7312 | 144 |
1012019 | 1012019 | 2021-02-09 | Bartholomew | Indiana | 18005 | 7081 | 144 |
947112 | 947112 | 2021-01-20 | Clark | Indiana | 18019 | 10449 | 144 |
947136 | 947136 | 2021-01-20 | Howard | Indiana | 18067 | 8071 | 144 |
898468 | 898468 | 2021-01-05 | LaPorte | Indiana | 18091 | 7895 | 144 |
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);