ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 223 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2243226 | 2243226 | 2022-02-23 | Henry | Indiana | 18065 | 12874 | 223 |
2239975 | 2239975 | 2022-02-22 | Henry | Indiana | 18065 | 12858 | 223 |
2233483 | 2233483 | 2022-02-20 | Kosciusko | Indiana | 18085 | 19603 | 223 |
2230232 | 2230232 | 2022-02-19 | Kosciusko | Indiana | 18085 | 19603 | 223 |
2226981 | 2226981 | 2022-02-18 | Kosciusko | Indiana | 18085 | 19603 | 223 |
2223730 | 2223730 | 2022-02-17 | Kosciusko | Indiana | 18085 | 19588 | 223 |
2220479 | 2220479 | 2022-02-16 | Kosciusko | Indiana | 18085 | 19572 | 223 |
2217228 | 2217228 | 2022-02-15 | Kosciusko | Indiana | 18085 | 19553 | 223 |
2213977 | 2213977 | 2022-02-14 | Kosciusko | Indiana | 18085 | 19536 | 223 |
2148956 | 2148956 | 2022-01-25 | Warrick | Indiana | 18173 | 18008 | 223 |
2145620 | 2145620 | 2022-01-24 | Bartholomew | Indiana | 18005 | 19007 | 223 |
2142365 | 2142365 | 2022-01-23 | Bartholomew | Indiana | 18005 | 18460 | 223 |
2139110 | 2139110 | 2022-01-22 | Bartholomew | Indiana | 18005 | 18460 | 223 |
2135854 | 2135854 | 2022-01-21 | Bartholomew | Indiana | 18005 | 18460 | 223 |
2132646 | 2132646 | 2022-01-20 | Lawrence | Indiana | 18093 | 10199 | 223 |
2129393 | 2129393 | 2022-01-19 | Lawrence | Indiana | 18093 | 10085 | 223 |
2126139 | 2126139 | 2022-01-18 | Lawrence | Indiana | 18093 | 9976 | 223 |
2119618 | 2119618 | 2022-01-16 | Hancock | Indiana | 18059 | 17688 | 223 |
2116366 | 2116366 | 2022-01-15 | Hancock | Indiana | 18059 | 17688 | 223 |
2113115 | 2113115 | 2022-01-14 | Hancock | Indiana | 18059 | 17688 | 223 |
2080625 | 2080625 | 2022-01-04 | Morgan | Indiana | 18109 | 11997 | 223 |
1992860 | 1992860 | 2021-12-08 | Monroe | Indiana | 18105 | 16894 | 223 |
1989609 | 1989609 | 2021-12-07 | Monroe | Indiana | 18105 | 16833 | 223 |
1986359 | 1986359 | 2021-12-06 | Monroe | Indiana | 18105 | 16798 | 223 |
1983109 | 1983109 | 2021-12-05 | Monroe | Indiana | 18105 | 16632 | 223 |
1979859 | 1979859 | 2021-12-04 | Monroe | Indiana | 18105 | 16632 | 223 |
1976609 | 1976609 | 2021-12-03 | Monroe | Indiana | 18105 | 16632 | 223 |
1973360 | 1973360 | 2021-12-02 | Monroe | Indiana | 18105 | 16560 | 223 |
1970110 | 1970110 | 2021-12-01 | Monroe | Indiana | 18105 | 16467 | 223 |
1853082 | 1853082 | 2021-10-26 | Floyd | Indiana | 18043 | 11161 | 223 |
1791353 | 1791353 | 2021-10-07 | Grant | Indiana | 18053 | 10019 | 223 |
1788104 | 1788104 | 2021-10-06 | Grant | Indiana | 18053 | 9989 | 223 |
1732931 | 1732931 | 2021-09-19 | Wayne | Indiana | 18177 | 10056 | 223 |
1729681 | 1729681 | 2021-09-18 | Wayne | Indiana | 18177 | 10056 | 223 |
1726431 | 1726431 | 2021-09-17 | Wayne | Indiana | 18177 | 10056 | 223 |
1700368 | 1700368 | 2021-09-09 | Clark | Indiana | 18019 | 16594 | 223 |
1463316 | 1463316 | 2021-06-28 | LaPorte | Indiana | 18091 | 12452 | 223 |
1460071 | 1460071 | 2021-06-27 | LaPorte | Indiana | 18091 | 12444 | 223 |
1456826 | 1456826 | 2021-06-26 | LaPorte | Indiana | 18091 | 12444 | 223 |
1453581 | 1453581 | 2021-06-25 | LaPorte | Indiana | 18091 | 12444 | 223 |
1450335 | 1450335 | 2021-06-24 | LaPorte | Indiana | 18091 | 12442 | 223 |
1447090 | 1447090 | 2021-06-23 | LaPorte | Indiana | 18091 | 12440 | 223 |
1443845 | 1443845 | 2021-06-22 | LaPorte | Indiana | 18091 | 12436 | 223 |
1440600 | 1440600 | 2021-06-21 | LaPorte | Indiana | 18091 | 12431 | 223 |
1437353 | 1437353 | 2021-06-20 | LaPorte | Indiana | 18091 | 12430 | 223 |
1434106 | 1434106 | 2021-06-19 | LaPorte | Indiana | 18091 | 12430 | 223 |
1430860 | 1430860 | 2021-06-18 | LaPorte | Indiana | 18091 | 12429 | 223 |
1427615 | 1427615 | 2021-06-17 | LaPorte | Indiana | 18091 | 12426 | 223 |
1424370 | 1424370 | 2021-06-16 | LaPorte | Indiana | 18091 | 12419 | 223 |
1421122 | 1421122 | 2021-06-15 | LaPorte | Indiana | 18091 | 12411 | 223 |
1417877 | 1417877 | 2021-06-14 | LaPorte | Indiana | 18091 | 12405 | 223 |
1414631 | 1414631 | 2021-06-13 | LaPorte | Indiana | 18091 | 12396 | 223 |
1411386 | 1411386 | 2021-06-12 | LaPorte | Indiana | 18091 | 12396 | 223 |
1330224 | 1330224 | 2021-05-18 | Howard | Indiana | 18067 | 10017 | 223 |
999116 | 999116 | 2021-02-05 | Vigo | Indiana | 18167 | 11167 | 223 |
921187 | 921187 | 2021-01-12 | Madison | Indiana | 18095 | 10196 | 223 |
827053 | 827053 | 2020-12-14 | Hamilton | Indiana | 18057 | 19278 | 223 |
823806 | 823806 | 2020-12-13 | Hamilton | Indiana | 18057 | 19048 | 223 |
629098 | 629098 | 2020-10-14 | Allen | Indiana | 18003 | 7354 | 223 |
625855 | 625855 | 2020-10-13 | Allen | Indiana | 18003 | 7274 | 223 |
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);