ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 188 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2200973 | 2200973 | 2022-02-10 | Marshall | Indiana | 18099 | 12190 | 188 |
2197719 | 2197719 | 2022-02-09 | Marshall | Indiana | 18099 | 12148 | 188 |
2194465 | 2194465 | 2022-02-08 | Marshall | Indiana | 18099 | 12148 | 188 |
2191211 | 2191211 | 2022-02-07 | Marshall | Indiana | 18099 | 12126 | 188 |
1986353 | 1986353 | 2021-12-06 | Lawrence | Indiana | 18093 | 8137 | 188 |
1983103 | 1983103 | 2021-12-05 | Lawrence | Indiana | 18093 | 8060 | 188 |
1979853 | 1979853 | 2021-12-04 | Lawrence | Indiana | 18093 | 8060 | 188 |
1976603 | 1976603 | 2021-12-03 | Lawrence | Indiana | 18093 | 8060 | 188 |
1973354 | 1973354 | 2021-12-02 | Lawrence | Indiana | 18093 | 8021 | 188 |
1940829 | 1940829 | 2021-11-22 | Hancock | Indiana | 18059 | 12588 | 188 |
1937579 | 1937579 | 2021-11-21 | Hancock | Indiana | 18059 | 12455 | 188 |
1934329 | 1934329 | 2021-11-20 | Hancock | Indiana | 18059 | 12455 | 188 |
1931078 | 1931078 | 2021-11-19 | Hancock | Indiana | 18059 | 12455 | 188 |
1927827 | 1927827 | 2021-11-18 | Hancock | Indiana | 18059 | 12396 | 188 |
1924577 | 1924577 | 2021-11-17 | Hancock | Indiana | 18059 | 12370 | 188 |
1895303 | 1895303 | 2021-11-08 | Bartholomew | Indiana | 18005 | 11996 | 188 |
1892053 | 1892053 | 2021-11-07 | Bartholomew | Indiana | 18005 | 11932 | 188 |
1888803 | 1888803 | 2021-11-06 | Bartholomew | Indiana | 18005 | 11932 | 188 |
1885553 | 1885553 | 2021-11-05 | Bartholomew | Indiana | 18005 | 11932 | 188 |
1882304 | 1882304 | 2021-11-04 | Bartholomew | Indiana | 18005 | 11905 | 188 |
1879055 | 1879055 | 2021-11-03 | Bartholomew | Indiana | 18005 | 11881 | 188 |
1875806 | 1875806 | 2021-11-02 | Bartholomew | Indiana | 18005 | 11865 | 188 |
1859613 | 1859613 | 2021-10-28 | Morgan | Indiana | 18109 | 9554 | 188 |
1801159 | 1801159 | 2021-10-10 | Warrick | Indiana | 18173 | 11066 | 188 |
1797910 | 1797910 | 2021-10-09 | Warrick | Indiana | 18173 | 11066 | 188 |
1794661 | 1794661 | 2021-10-08 | Warrick | Indiana | 18173 | 11066 | 188 |
1791413 | 1791413 | 2021-10-07 | Warrick | Indiana | 18173 | 11042 | 188 |
1667923 | 1667923 | 2021-08-30 | Monroe | Indiana | 18105 | 13554 | 188 |
1606176 | 1606176 | 2021-08-11 | Floyd | Indiana | 18043 | 8384 | 188 |
1602927 | 1602927 | 2021-08-10 | Floyd | Indiana | 18043 | 8336 | 188 |
1599678 | 1599678 | 2021-08-09 | Floyd | Indiana | 18043 | 8308 | 188 |
1596430 | 1596430 | 2021-08-08 | Floyd | Indiana | 18043 | 8225 | 188 |
1593181 | 1593181 | 2021-08-07 | Floyd | Indiana | 18043 | 8225 | 188 |
1589932 | 1589932 | 2021-08-06 | Floyd | Indiana | 18043 | 8225 | 188 |
1586683 | 1586683 | 2021-08-05 | Floyd | Indiana | 18043 | 8194 | 188 |
1586688 | 1586688 | 2021-08-05 | Grant | Indiana | 18053 | 7908 | 188 |
1583433 | 1583433 | 2021-08-04 | Floyd | Indiana | 18043 | 8171 | 188 |
1583438 | 1583438 | 2021-08-04 | Grant | Indiana | 18053 | 7888 | 188 |
1580183 | 1580183 | 2021-08-03 | Floyd | Indiana | 18043 | 8138 | 188 |
1580188 | 1580188 | 2021-08-03 | Grant | Indiana | 18053 | 7868 | 188 |
1576934 | 1576934 | 2021-08-02 | Floyd | Indiana | 18043 | 8118 | 188 |
1576939 | 1576939 | 2021-08-02 | Grant | Indiana | 18053 | 7841 | 188 |
1573686 | 1573686 | 2021-08-01 | Floyd | Indiana | 18043 | 8082 | 188 |
1573691 | 1573691 | 2021-08-01 | Grant | Indiana | 18053 | 7808 | 188 |
1570438 | 1570438 | 2021-07-31 | Floyd | Indiana | 18043 | 8082 | 188 |
1570443 | 1570443 | 2021-07-31 | Grant | Indiana | 18053 | 7808 | 188 |
1567190 | 1567190 | 2021-07-30 | Floyd | Indiana | 18043 | 8082 | 188 |
1567195 | 1567195 | 2021-07-30 | Grant | Indiana | 18053 | 7808 | 188 |
1563947 | 1563947 | 2021-07-29 | Grant | Indiana | 18053 | 7798 | 188 |
1560699 | 1560699 | 2021-07-28 | Grant | Indiana | 18053 | 7790 | 188 |
1557452 | 1557452 | 2021-07-27 | Grant | Indiana | 18053 | 7779 | 188 |
1554205 | 1554205 | 2021-07-26 | Grant | Indiana | 18053 | 7762 | 188 |
1550958 | 1550958 | 2021-07-25 | Grant | Indiana | 18053 | 7750 | 188 |
1547711 | 1547711 | 2021-07-24 | Grant | Indiana | 18053 | 7750 | 188 |
1544464 | 1544464 | 2021-07-23 | Grant | Indiana | 18053 | 7750 | 188 |
1541216 | 1541216 | 2021-07-22 | Grant | Indiana | 18053 | 7743 | 188 |
1537969 | 1537969 | 2021-07-21 | Grant | Indiana | 18053 | 7741 | 188 |
1534721 | 1534721 | 2021-07-20 | Grant | Indiana | 18053 | 7737 | 188 |
1531474 | 1531474 | 2021-07-19 | Grant | Indiana | 18053 | 7732 | 188 |
1528227 | 1528227 | 2021-07-18 | Grant | Indiana | 18053 | 7727 | 188 |
1524980 | 1524980 | 2021-07-17 | Grant | Indiana | 18053 | 7727 | 188 |
1521732 | 1521732 | 2021-07-16 | Grant | Indiana | 18053 | 7727 | 188 |
1518484 | 1518484 | 2021-07-15 | Grant | Indiana | 18053 | 7724 | 188 |
1515237 | 1515237 | 2021-07-14 | Grant | Indiana | 18053 | 7719 | 188 |
1206822 | 1206822 | 2021-04-10 | Delaware | Indiana | 18035 | 10255 | 188 |
1203574 | 1203574 | 2021-04-09 | Delaware | Indiana | 18035 | 10234 | 188 |
1200326 | 1200326 | 2021-04-08 | Delaware | Indiana | 18035 | 10218 | 188 |
1197077 | 1197077 | 2021-04-07 | Delaware | Indiana | 18035 | 10199 | 188 |
1193829 | 1193829 | 2021-04-06 | Delaware | Indiana | 18035 | 10191 | 188 |
1190579 | 1190579 | 2021-04-05 | Delaware | Indiana | 18035 | 10188 | 188 |
1187332 | 1187332 | 2021-04-04 | Delaware | Indiana | 18035 | 10178 | 188 |
1184085 | 1184085 | 2021-04-03 | Delaware | Indiana | 18035 | 10170 | 188 |
1180838 | 1180838 | 2021-04-02 | Delaware | Indiana | 18035 | 10165 | 188 |
1177591 | 1177591 | 2021-04-01 | Delaware | Indiana | 18035 | 10152 | 188 |
1174344 | 1174344 | 2021-03-31 | Delaware | Indiana | 18035 | 10126 | 188 |
1171097 | 1171097 | 2021-03-30 | Delaware | Indiana | 18035 | 10119 | 188 |
1167849 | 1167849 | 2021-03-29 | Delaware | Indiana | 18035 | 10110 | 188 |
1164601 | 1164601 | 2021-03-28 | Delaware | Indiana | 18035 | 10103 | 188 |
1161353 | 1161353 | 2021-03-27 | Delaware | Indiana | 18035 | 10095 | 188 |
1158105 | 1158105 | 2021-03-26 | Delaware | Indiana | 18035 | 10081 | 188 |
1154858 | 1154858 | 2021-03-25 | Delaware | Indiana | 18035 | 10070 | 188 |
1151611 | 1151611 | 2021-03-24 | Delaware | Indiana | 18035 | 10055 | 188 |
1148364 | 1148364 | 2021-03-23 | Delaware | Indiana | 18035 | 10051 | 188 |
1145117 | 1145117 | 2021-03-22 | Delaware | Indiana | 18035 | 10044 | 188 |
1141870 | 1141870 | 2021-03-21 | Delaware | Indiana | 18035 | 10035 | 188 |
1138624 | 1138624 | 2021-03-20 | Delaware | Indiana | 18035 | 10031 | 188 |
1135378 | 1135378 | 2021-03-19 | Delaware | Indiana | 18035 | 10023 | 188 |
1070445 | 1070445 | 2021-02-27 | Clark | Indiana | 18019 | 11949 | 188 |
1067200 | 1067200 | 2021-02-26 | Clark | Indiana | 18019 | 11934 | 188 |
1034823 | 1034823 | 2021-02-16 | Wayne | Indiana | 18177 | 6934 | 188 |
1018585 | 1018585 | 2021-02-11 | Tippecanoe | Indiana | 18157 | 19227 | 188 |
976372 | 976372 | 2021-01-29 | Porter | Indiana | 18127 | 15142 | 188 |
810826 | 810826 | 2020-12-09 | Hendricks | Indiana | 18063 | 8292 | 188 |
797855 | 797855 | 2020-12-05 | Johnson | Indiana | 18081 | 8176 | 188 |
489843 | 489843 | 2020-09-01 | Allen | Indiana | 18003 | 5035 | 188 |
486610 | 486610 | 2020-08-31 | Allen | Indiana | 18003 | 5005 | 188 |
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);