ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 195 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399380 | 2399380 | 2022-04-12 | Marshall | Indiana | 18099 | 12319 | 195 |
2396125 | 2396125 | 2022-04-11 | Marshall | Indiana | 18099 | 12319 | 195 |
2392869 | 2392869 | 2022-04-10 | Marshall | Indiana | 18099 | 12319 | 195 |
2389613 | 2389613 | 2022-04-09 | Marshall | Indiana | 18099 | 12319 | 195 |
2386358 | 2386358 | 2022-04-08 | Marshall | Indiana | 18099 | 12319 | 195 |
2383103 | 2383103 | 2022-04-07 | Marshall | Indiana | 18099 | 12319 | 195 |
2379848 | 2379848 | 2022-04-06 | Marshall | Indiana | 18099 | 12319 | 195 |
2376594 | 2376594 | 2022-04-05 | Marshall | Indiana | 18099 | 12317 | 195 |
2373342 | 2373342 | 2022-04-04 | Marshall | Indiana | 18099 | 12317 | 195 |
2370089 | 2370089 | 2022-04-03 | Marshall | Indiana | 18099 | 12316 | 195 |
2366836 | 2366836 | 2022-04-02 | Marshall | Indiana | 18099 | 12316 | 195 |
2363583 | 2363583 | 2022-04-01 | Marshall | Indiana | 18099 | 12316 | 195 |
2360329 | 2360329 | 2022-03-31 | Marshall | Indiana | 18099 | 12315 | 195 |
2357075 | 2357075 | 2022-03-30 | Marshall | Indiana | 18099 | 12315 | 195 |
2353822 | 2353822 | 2022-03-29 | Marshall | Indiana | 18099 | 12328 | 195 |
2350570 | 2350570 | 2022-03-28 | Marshall | Indiana | 18099 | 12327 | 195 |
2347317 | 2347317 | 2022-03-27 | Marshall | Indiana | 18099 | 12325 | 195 |
2344064 | 2344064 | 2022-03-26 | Marshall | Indiana | 18099 | 12325 | 195 |
2340811 | 2340811 | 2022-03-25 | Marshall | Indiana | 18099 | 12325 | 195 |
2337558 | 2337558 | 2022-03-24 | Marshall | Indiana | 18099 | 12322 | 195 |
2334304 | 2334304 | 2022-03-23 | Marshall | Indiana | 18099 | 12317 | 195 |
2331050 | 2331050 | 2022-03-22 | Marshall | Indiana | 18099 | 12317 | 195 |
2327798 | 2327798 | 2022-03-21 | Marshall | Indiana | 18099 | 12316 | 195 |
2324545 | 2324545 | 2022-03-20 | Marshall | Indiana | 18099 | 12315 | 195 |
2321291 | 2321291 | 2022-03-19 | Marshall | Indiana | 18099 | 12315 | 195 |
2318037 | 2318037 | 2022-03-18 | Marshall | Indiana | 18099 | 12315 | 195 |
2100113 | 2100113 | 2022-01-10 | Henry | Indiana | 18065 | 10702 | 195 |
2012359 | 2012359 | 2021-12-14 | Lawrence | Indiana | 18093 | 8391 | 195 |
1989643 | 1989643 | 2021-12-07 | Warrick | Indiana | 18173 | 12373 | 195 |
1966810 | 1966810 | 2021-11-30 | Bartholomew | Indiana | 18005 | 12753 | 195 |
1921353 | 1921353 | 2021-11-16 | Morgan | Indiana | 18109 | 9895 | 195 |
1918103 | 1918103 | 2021-11-15 | Morgan | Indiana | 18109 | 9870 | 195 |
1914853 | 1914853 | 2021-11-14 | Morgan | Indiana | 18109 | 9825 | 195 |
1911603 | 1911603 | 2021-11-13 | Morgan | Indiana | 18109 | 9825 | 195 |
1908354 | 1908354 | 2021-11-12 | Morgan | Indiana | 18109 | 9825 | 195 |
1905105 | 1905105 | 2021-11-11 | Morgan | Indiana | 18109 | 9797 | 195 |
1901855 | 1901855 | 2021-11-10 | Morgan | Indiana | 18109 | 9736 | 195 |
1898605 | 1898605 | 2021-11-09 | Morgan | Indiana | 18109 | 9716 | 195 |
1674393 | 1674393 | 2021-09-01 | Grant | Indiana | 18053 | 8661 | 195 |
1671144 | 1671144 | 2021-08-31 | Grant | Indiana | 18053 | 8624 | 195 |
1333455 | 1333455 | 2021-05-19 | Delaware | Indiana | 18035 | 10791 | 195 |
1330208 | 1330208 | 2021-05-18 | Delaware | Indiana | 18035 | 10780 | 195 |
1177583 | 1177583 | 2021-04-01 | Clark | Indiana | 18019 | 12460 | 195 |
1174336 | 1174336 | 2021-03-31 | Clark | Indiana | 18019 | 12442 | 195 |
1171089 | 1171089 | 2021-03-30 | Clark | Indiana | 18019 | 12430 | 195 |
1167841 | 1167841 | 2021-03-29 | Clark | Indiana | 18019 | 12427 | 195 |
1112722 | 1112722 | 2021-03-12 | Wayne | Indiana | 18177 | 7075 | 195 |
1109476 | 1109476 | 2021-03-11 | Wayne | Indiana | 18177 | 7070 | 195 |
1106230 | 1106230 | 2021-03-10 | Wayne | Indiana | 18177 | 7061 | 195 |
1102984 | 1102984 | 2021-03-09 | Wayne | Indiana | 18177 | 7055 | 195 |
1099738 | 1099738 | 2021-03-08 | Wayne | Indiana | 18177 | 7052 | 195 |
1096490 | 1096490 | 2021-03-07 | Wayne | Indiana | 18177 | 7047 | 195 |
1093244 | 1093244 | 2021-03-06 | Wayne | Indiana | 18177 | 7047 | 195 |
1089998 | 1089998 | 2021-03-05 | Wayne | Indiana | 18177 | 7040 | 195 |
1086753 | 1086753 | 2021-03-04 | Wayne | Indiana | 18177 | 7038 | 195 |
1083507 | 1083507 | 2021-03-03 | Wayne | Indiana | 18177 | 7035 | 195 |
1080261 | 1080261 | 2021-03-02 | Wayne | Indiana | 18177 | 7030 | 195 |
1050995 | 1050995 | 2021-02-21 | Howard | Indiana | 18067 | 9014 | 195 |
1047748 | 1047748 | 2021-02-20 | Howard | Indiana | 18067 | 9010 | 195 |
1038058 | 1038058 | 2021-02-17 | Tippecanoe | Indiana | 18157 | 19489 | 195 |
1021796 | 1021796 | 2021-02-12 | LaPorte | Indiana | 18091 | 9573 | 195 |
885487 | 885487 | 2021-01-01 | Madison | Indiana | 18095 | 9097 | 195 |
817317 | 817317 | 2020-12-11 | Hendricks | Indiana | 18063 | 8675 | 195 |
794598 | 794598 | 2020-12-04 | Hamilton | Indiana | 18057 | 15931 | 195 |
707029 | 707029 | 2020-11-07 | St. Joseph | Indiana | 18141 | 11818 | 195 |
512476 | 512476 | 2020-09-08 | Allen | Indiana | 18003 | 5400 | 195 |
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);