ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
391 rows where deaths = 39 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Whitley 62
- Fulton 33
- Knox 30
- Brown 18
- Greene 18
- Scott 16
- Sullivan 14
- Carroll 12
- St. Joseph 11
- Owen 10
- Boone 8
- Fountain 8
- Newton 8
- Vermillion 8
- Clinton 7
- Dearborn 7
- Franklin 7
- Hancock 7
- Parke 7
- Porter 7
- Ripley 6
- Crawford 5
- Daviess 5
- Jackson 5
- Morgan 5
- Monroe 4
- Washington 4
- Blackford 3
- Floyd 3
- Lawrence 3
- …
state 1
- Indiana · 391 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2376557 | 2376557 | 2022-04-05 | Crawford | Indiana | 18025 | 2546 | 39 |
2373305 | 2373305 | 2022-04-04 | Crawford | Indiana | 18025 | 2546 | 39 |
2370052 | 2370052 | 2022-04-03 | Crawford | Indiana | 18025 | 2546 | 39 |
2366799 | 2366799 | 2022-04-02 | Crawford | Indiana | 18025 | 2546 | 39 |
2363546 | 2363546 | 2022-04-01 | Crawford | Indiana | 18025 | 2546 | 39 |
2142432 | 2142432 | 2022-01-23 | Rush | Indiana | 18139 | 4260 | 39 |
2139177 | 2139177 | 2022-01-22 | Rush | Indiana | 18139 | 4260 | 39 |
2135921 | 2135921 | 2022-01-21 | Rush | Indiana | 18139 | 4260 | 39 |
2106643 | 2106643 | 2022-01-12 | Parke | Indiana | 18121 | 2921 | 39 |
2103392 | 2103392 | 2022-01-11 | Parke | Indiana | 18121 | 2897 | 39 |
2100141 | 2100141 | 2022-01-10 | Parke | Indiana | 18121 | 2881 | 39 |
2096890 | 2096890 | 2022-01-09 | Parke | Indiana | 18121 | 2833 | 39 |
2093638 | 2093638 | 2022-01-08 | Parke | Indiana | 18121 | 2833 | 39 |
2090386 | 2090386 | 2022-01-07 | Parke | Indiana | 18121 | 2833 | 39 |
2087135 | 2087135 | 2022-01-06 | Parke | Indiana | 18121 | 2810 | 39 |
1914806 | 1914806 | 2021-11-14 | Carroll | Indiana | 18015 | 2765 | 39 |
1911556 | 1911556 | 2021-11-13 | Carroll | Indiana | 18015 | 2765 | 39 |
1908307 | 1908307 | 2021-11-12 | Carroll | Indiana | 18015 | 2765 | 39 |
1905058 | 1905058 | 2021-11-11 | Carroll | Indiana | 18015 | 2759 | 39 |
1901808 | 1901808 | 2021-11-10 | Carroll | Indiana | 18015 | 2737 | 39 |
1898558 | 1898558 | 2021-11-09 | Carroll | Indiana | 18015 | 2724 | 39 |
1895308 | 1895308 | 2021-11-08 | Carroll | Indiana | 18015 | 2712 | 39 |
1892058 | 1892058 | 2021-11-07 | Carroll | Indiana | 18015 | 2695 | 39 |
1888808 | 1888808 | 2021-11-06 | Carroll | Indiana | 18015 | 2695 | 39 |
1885558 | 1885558 | 2021-11-05 | Carroll | Indiana | 18015 | 2695 | 39 |
1882309 | 1882309 | 2021-11-04 | Carroll | Indiana | 18015 | 2686 | 39 |
1879060 | 1879060 | 2021-11-03 | Carroll | Indiana | 18015 | 2677 | 39 |
1810826 | 1810826 | 2021-10-13 | Blackford | Indiana | 18009 | 1866 | 39 |
1807577 | 1807577 | 2021-10-12 | Blackford | Indiana | 18009 | 1862 | 39 |
1804326 | 1804326 | 2021-10-11 | Blackford | Indiana | 18009 | 1859 | 39 |
1791399 | 1791399 | 2021-10-07 | Spencer | Indiana | 18147 | 3322 | 39 |
1758858 | 1758858 | 2021-09-27 | Franklin | Indiana | 18047 | 2466 | 39 |
1755610 | 1755610 | 2021-09-26 | Franklin | Indiana | 18047 | 2445 | 39 |
1752362 | 1752362 | 2021-09-25 | Franklin | Indiana | 18047 | 2445 | 39 |
1749113 | 1749113 | 2021-09-24 | Franklin | Indiana | 18047 | 2445 | 39 |
1745863 | 1745863 | 2021-09-23 | Franklin | Indiana | 18047 | 2423 | 39 |
1745902 | 1745902 | 2021-09-23 | Pike | Indiana | 18125 | 2095 | 39 |
1742614 | 1742614 | 2021-09-22 | Franklin | Indiana | 18047 | 2411 | 39 |
1742653 | 1742653 | 2021-09-22 | Pike | Indiana | 18125 | 2076 | 39 |
1739365 | 1739365 | 2021-09-21 | Franklin | Indiana | 18047 | 2388 | 39 |
1739404 | 1739404 | 2021-09-21 | Pike | Indiana | 18125 | 2056 | 39 |
1619236 | 1619236 | 2021-08-15 | Washington | Indiana | 18175 | 2653 | 39 |
1615988 | 1615988 | 2021-08-14 | Washington | Indiana | 18175 | 2653 | 39 |
1612739 | 1612739 | 2021-08-13 | Washington | Indiana | 18175 | 2653 | 39 |
1609491 | 1609491 | 2021-08-12 | Washington | Indiana | 18175 | 2639 | 39 |
1602961 | 1602961 | 2021-08-10 | Newton | Indiana | 18111 | 1254 | 39 |
1599712 | 1599712 | 2021-08-09 | Newton | Indiana | 18111 | 1253 | 39 |
1596464 | 1596464 | 2021-08-08 | Newton | Indiana | 18111 | 1249 | 39 |
1593215 | 1593215 | 2021-08-07 | Newton | Indiana | 18111 | 1249 | 39 |
1589966 | 1589966 | 2021-08-06 | Newton | Indiana | 18111 | 1249 | 39 |
1586717 | 1586717 | 2021-08-05 | Newton | Indiana | 18111 | 1247 | 39 |
1583467 | 1583467 | 2021-08-04 | Newton | Indiana | 18111 | 1245 | 39 |
1580217 | 1580217 | 2021-08-03 | Newton | Indiana | 18111 | 1243 | 39 |
1495794 | 1495794 | 2021-07-08 | Perry | Indiana | 18123 | 1883 | 39 |
1340023 | 1340023 | 2021-05-21 | Whitley | Indiana | 18183 | 4005 | 39 |
1336776 | 1336776 | 2021-05-20 | Whitley | Indiana | 18183 | 4002 | 39 |
1333529 | 1333529 | 2021-05-19 | Whitley | Indiana | 18183 | 3994 | 39 |
1330282 | 1330282 | 2021-05-18 | Whitley | Indiana | 18183 | 3989 | 39 |
1327035 | 1327035 | 2021-05-17 | Whitley | Indiana | 18183 | 3987 | 39 |
1323789 | 1323789 | 2021-05-16 | Whitley | Indiana | 18183 | 3979 | 39 |
1320543 | 1320543 | 2021-05-15 | Whitley | Indiana | 18183 | 3975 | 39 |
1317296 | 1317296 | 2021-05-14 | Whitley | Indiana | 18183 | 3974 | 39 |
1314049 | 1314049 | 2021-05-13 | Whitley | Indiana | 18183 | 3971 | 39 |
1310802 | 1310802 | 2021-05-12 | Whitley | Indiana | 18183 | 3967 | 39 |
1307556 | 1307556 | 2021-05-11 | Whitley | Indiana | 18183 | 3961 | 39 |
1304310 | 1304310 | 2021-05-10 | Whitley | Indiana | 18183 | 3959 | 39 |
1301063 | 1301063 | 2021-05-09 | Whitley | Indiana | 18183 | 3956 | 39 |
1297816 | 1297816 | 2021-05-08 | Whitley | Indiana | 18183 | 3952 | 39 |
1294570 | 1294570 | 2021-05-07 | Whitley | Indiana | 18183 | 3947 | 39 |
1291324 | 1291324 | 2021-05-06 | Whitley | Indiana | 18183 | 3944 | 39 |
1288078 | 1288078 | 2021-05-05 | Whitley | Indiana | 18183 | 3937 | 39 |
1284832 | 1284832 | 2021-05-04 | Whitley | Indiana | 18183 | 3927 | 39 |
1281585 | 1281585 | 2021-05-03 | Whitley | Indiana | 18183 | 3922 | 39 |
1278338 | 1278338 | 2021-05-02 | Whitley | Indiana | 18183 | 3922 | 39 |
1275091 | 1275091 | 2021-05-01 | Whitley | Indiana | 18183 | 3902 | 39 |
1271844 | 1271844 | 2021-04-30 | Whitley | Indiana | 18183 | 3899 | 39 |
1268597 | 1268597 | 2021-04-29 | Whitley | Indiana | 18183 | 3895 | 39 |
1265350 | 1265350 | 2021-04-28 | Whitley | Indiana | 18183 | 3878 | 39 |
1262103 | 1262103 | 2021-04-27 | Whitley | Indiana | 18183 | 3874 | 39 |
1258856 | 1258856 | 2021-04-26 | Whitley | Indiana | 18183 | 3869 | 39 |
1255609 | 1255609 | 2021-04-25 | Whitley | Indiana | 18183 | 3860 | 39 |
1252362 | 1252362 | 2021-04-24 | Whitley | Indiana | 18183 | 3855 | 39 |
1249115 | 1249115 | 2021-04-23 | Whitley | Indiana | 18183 | 3843 | 39 |
1245868 | 1245868 | 2021-04-22 | Whitley | Indiana | 18183 | 3832 | 39 |
1242621 | 1242621 | 2021-04-21 | Whitley | Indiana | 18183 | 3822 | 39 |
1239374 | 1239374 | 2021-04-20 | Whitley | Indiana | 18183 | 3814 | 39 |
1236060 | 1236060 | 2021-04-19 | Fulton | Indiana | 18049 | 1921 | 39 |
1236127 | 1236127 | 2021-04-19 | Whitley | Indiana | 18183 | 3802 | 39 |
1232813 | 1232813 | 2021-04-18 | Fulton | Indiana | 18049 | 1918 | 39 |
1232880 | 1232880 | 2021-04-18 | Whitley | Indiana | 18183 | 3796 | 39 |
1229564 | 1229564 | 2021-04-17 | Fulton | Indiana | 18049 | 1915 | 39 |
1229631 | 1229631 | 2021-04-17 | Whitley | Indiana | 18183 | 3779 | 39 |
1226316 | 1226316 | 2021-04-16 | Fulton | Indiana | 18049 | 1910 | 39 |
1226383 | 1226383 | 2021-04-16 | Whitley | Indiana | 18183 | 3763 | 39 |
1223069 | 1223069 | 2021-04-15 | Fulton | Indiana | 18049 | 1909 | 39 |
1223136 | 1223136 | 2021-04-15 | Whitley | Indiana | 18183 | 3755 | 39 |
1219821 | 1219821 | 2021-04-14 | Fulton | Indiana | 18049 | 1905 | 39 |
1219888 | 1219888 | 2021-04-14 | Whitley | Indiana | 18183 | 3749 | 39 |
1216573 | 1216573 | 2021-04-13 | Fulton | Indiana | 18049 | 1901 | 39 |
1216640 | 1216640 | 2021-04-13 | Whitley | Indiana | 18183 | 3739 | 39 |
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);