ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 295 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 4
- Twin Falls 21
- Canyon 5
- Kootenai 2
- Ada 1
state 1
- Idaho · 29 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496916 | 2496916 | 2022-05-12 | Twin Falls | Idaho | 16083 | 24115 | 295 |
2493658 | 2493658 | 2022-05-11 | Twin Falls | Idaho | 16083 | 24115 | 295 |
2490400 | 2490400 | 2022-05-10 | Twin Falls | Idaho | 16083 | 24107 | 295 |
2487143 | 2487143 | 2022-05-09 | Twin Falls | Idaho | 16083 | 24107 | 295 |
2483885 | 2483885 | 2022-05-08 | Twin Falls | Idaho | 16083 | 24091 | 295 |
2480627 | 2480627 | 2022-05-07 | Twin Falls | Idaho | 16083 | 24091 | 295 |
2477369 | 2477369 | 2022-05-06 | Twin Falls | Idaho | 16083 | 24091 | 295 |
2474111 | 2474111 | 2022-05-05 | Twin Falls | Idaho | 16083 | 24080 | 295 |
2470854 | 2470854 | 2022-05-04 | Twin Falls | Idaho | 16083 | 24080 | 295 |
2467598 | 2467598 | 2022-05-03 | Twin Falls | Idaho | 16083 | 24060 | 295 |
2464343 | 2464343 | 2022-05-02 | Twin Falls | Idaho | 16083 | 24060 | 295 |
2461087 | 2461087 | 2022-05-01 | Twin Falls | Idaho | 16083 | 24056 | 295 |
2457831 | 2457831 | 2022-04-30 | Twin Falls | Idaho | 16083 | 24056 | 295 |
2454575 | 2454575 | 2022-04-29 | Twin Falls | Idaho | 16083 | 24056 | 295 |
2451319 | 2451319 | 2022-04-28 | Twin Falls | Idaho | 16083 | 24051 | 295 |
2448063 | 2448063 | 2022-04-27 | Twin Falls | Idaho | 16083 | 24051 | 295 |
2444807 | 2444807 | 2022-04-26 | Twin Falls | Idaho | 16083 | 24047 | 295 |
2441551 | 2441551 | 2022-04-25 | Twin Falls | Idaho | 16083 | 24047 | 295 |
2438295 | 2438295 | 2022-04-24 | Twin Falls | Idaho | 16083 | 24041 | 295 |
2435039 | 2435039 | 2022-04-23 | Twin Falls | Idaho | 16083 | 24041 | 295 |
2431783 | 2431783 | 2022-04-22 | Twin Falls | Idaho | 16083 | 24041 | 295 |
1732723 | 1732723 | 2021-09-19 | Kootenai | Idaho | 16055 | 24421 | 295 |
1729473 | 1729473 | 2021-09-18 | Kootenai | Idaho | 16055 | 24420 | 295 |
1307331 | 1307331 | 2021-05-11 | Canyon | Idaho | 16027 | 26730 | 295 |
1291099 | 1291099 | 2021-05-06 | Canyon | Idaho | 16027 | 26625 | 295 |
1287853 | 1287853 | 2021-05-05 | Canyon | Idaho | 16027 | 26592 | 295 |
1284607 | 1284607 | 2021-05-04 | Canyon | Idaho | 16027 | 26548 | 295 |
1281360 | 1281360 | 2021-05-03 | Canyon | Idaho | 16027 | 26509 | 295 |
830125 | 830125 | 2020-12-15 | Ada | Idaho | 16001 | 32190 | 295 |
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);