ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where deaths = 57 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500176 | 2500176 | 2022-05-13 | Washington | Idaho | 16087 | 2394 | 57 |
2496918 | 2496918 | 2022-05-12 | Washington | Idaho | 16087 | 2393 | 57 |
2493660 | 2493660 | 2022-05-11 | Washington | Idaho | 16087 | 2393 | 57 |
2490402 | 2490402 | 2022-05-10 | Washington | Idaho | 16087 | 2392 | 57 |
2487145 | 2487145 | 2022-05-09 | Washington | Idaho | 16087 | 2392 | 57 |
2483887 | 2483887 | 2022-05-08 | Washington | Idaho | 16087 | 2392 | 57 |
2480629 | 2480629 | 2022-05-07 | Washington | Idaho | 16087 | 2392 | 57 |
2477371 | 2477371 | 2022-05-06 | Washington | Idaho | 16087 | 2392 | 57 |
2474113 | 2474113 | 2022-05-05 | Washington | Idaho | 16087 | 2392 | 57 |
2470856 | 2470856 | 2022-05-04 | Washington | Idaho | 16087 | 2392 | 57 |
2467600 | 2467600 | 2022-05-03 | Washington | Idaho | 16087 | 2391 | 57 |
2464345 | 2464345 | 2022-05-02 | Washington | Idaho | 16087 | 2391 | 57 |
2461089 | 2461089 | 2022-05-01 | Washington | Idaho | 16087 | 2390 | 57 |
2457833 | 2457833 | 2022-04-30 | Washington | Idaho | 16087 | 2390 | 57 |
2454577 | 2454577 | 2022-04-29 | Washington | Idaho | 16087 | 2390 | 57 |
2451321 | 2451321 | 2022-04-28 | Washington | Idaho | 16087 | 2388 | 57 |
2448065 | 2448065 | 2022-04-27 | Washington | Idaho | 16087 | 2388 | 57 |
2444809 | 2444809 | 2022-04-26 | Washington | Idaho | 16087 | 2388 | 57 |
2441553 | 2441553 | 2022-04-25 | Washington | Idaho | 16087 | 2388 | 57 |
2438297 | 2438297 | 2022-04-24 | Washington | Idaho | 16087 | 2388 | 57 |
2435041 | 2435041 | 2022-04-23 | Washington | Idaho | 16087 | 2388 | 57 |
2431785 | 2431785 | 2022-04-22 | Washington | Idaho | 16087 | 2388 | 57 |
2428529 | 2428529 | 2022-04-21 | Washington | Idaho | 16087 | 2388 | 57 |
2425273 | 2425273 | 2022-04-20 | Washington | Idaho | 16087 | 2388 | 57 |
2422017 | 2422017 | 2022-04-19 | Washington | Idaho | 16087 | 2386 | 57 |
2418761 | 2418761 | 2022-04-18 | Washington | Idaho | 16087 | 2386 | 57 |
2415505 | 2415505 | 2022-04-17 | Washington | Idaho | 16087 | 2386 | 57 |
2412249 | 2412249 | 2022-04-16 | Washington | Idaho | 16087 | 2386 | 57 |
2408993 | 2408993 | 2022-04-15 | Washington | Idaho | 16087 | 2386 | 57 |
2405737 | 2405737 | 2022-04-14 | Washington | Idaho | 16087 | 2386 | 57 |
2402482 | 2402482 | 2022-04-13 | Washington | Idaho | 16087 | 2386 | 57 |
2399227 | 2399227 | 2022-04-12 | Washington | Idaho | 16087 | 2386 | 57 |
2395972 | 2395972 | 2022-04-11 | Washington | Idaho | 16087 | 2386 | 57 |
2392716 | 2392716 | 2022-04-10 | Washington | Idaho | 16087 | 2386 | 57 |
2389460 | 2389460 | 2022-04-09 | Washington | Idaho | 16087 | 2386 | 57 |
2386205 | 2386205 | 2022-04-08 | Washington | Idaho | 16087 | 2386 | 57 |
2382950 | 2382950 | 2022-04-07 | Washington | Idaho | 16087 | 2387 | 57 |
2379695 | 2379695 | 2022-04-06 | Washington | Idaho | 16087 | 2379 | 57 |
2376441 | 2376441 | 2022-04-05 | Washington | Idaho | 16087 | 2368 | 57 |
2373189 | 2373189 | 2022-04-04 | Washington | Idaho | 16087 | 2368 | 57 |
2369936 | 2369936 | 2022-04-03 | Washington | Idaho | 16087 | 2368 | 57 |
2366683 | 2366683 | 2022-04-02 | Washington | Idaho | 16087 | 2368 | 57 |
2363430 | 2363430 | 2022-04-01 | Washington | Idaho | 16087 | 2368 | 57 |
2360176 | 2360176 | 2022-03-31 | Washington | Idaho | 16087 | 2368 | 57 |
2356922 | 2356922 | 2022-03-30 | Washington | Idaho | 16087 | 2368 | 57 |
2353669 | 2353669 | 2022-03-29 | Washington | Idaho | 16087 | 2368 | 57 |
2350417 | 2350417 | 2022-03-28 | Washington | Idaho | 16087 | 2368 | 57 |
2347164 | 2347164 | 2022-03-27 | Washington | Idaho | 16087 | 2368 | 57 |
2343911 | 2343911 | 2022-03-26 | Washington | Idaho | 16087 | 2368 | 57 |
2340658 | 2340658 | 2022-03-25 | Washington | Idaho | 16087 | 2368 | 57 |
2337405 | 2337405 | 2022-03-24 | Washington | Idaho | 16087 | 2368 | 57 |
2334151 | 2334151 | 2022-03-23 | Washington | Idaho | 16087 | 2368 | 57 |
2330897 | 2330897 | 2022-03-22 | Washington | Idaho | 16087 | 2367 | 57 |
2291833 | 2291833 | 2022-03-10 | Boundary | Idaho | 16021 | 2038 | 57 |
2288581 | 2288581 | 2022-03-09 | Boundary | Idaho | 16021 | 2034 | 57 |
2285330 | 2285330 | 2022-03-08 | Boundary | Idaho | 16021 | 2024 | 57 |
2282078 | 2282078 | 2022-03-07 | Boundary | Idaho | 16021 | 2021 | 57 |
2278825 | 2278825 | 2022-03-06 | Boundary | Idaho | 16021 | 2019 | 57 |
2275572 | 2275572 | 2022-03-05 | Boundary | Idaho | 16021 | 2019 | 57 |
2272319 | 2272319 | 2022-03-04 | Boundary | Idaho | 16021 | 2019 | 57 |
2269067 | 2269067 | 2022-03-03 | Boundary | Idaho | 16021 | 2024 | 57 |
2265814 | 2265814 | 2022-03-02 | Boundary | Idaho | 16021 | 2022 | 57 |
2265847 | 2265847 | 2022-03-02 | Washington | Idaho | 16087 | 2345 | 57 |
2262563 | 2262563 | 2022-03-01 | Boundary | Idaho | 16021 | 2017 | 57 |
2259312 | 2259312 | 2022-02-28 | Boundary | Idaho | 16021 | 2016 | 57 |
2256061 | 2256061 | 2022-02-27 | Boundary | Idaho | 16021 | 2013 | 57 |
2252810 | 2252810 | 2022-02-26 | Boundary | Idaho | 16021 | 2013 | 57 |
2249559 | 2249559 | 2022-02-25 | Boundary | Idaho | 16021 | 2013 | 57 |
2246308 | 2246308 | 2022-02-24 | Boundary | Idaho | 16021 | 2012 | 57 |
2239829 | 2239829 | 2022-02-22 | Minidoka | Idaho | 16067 | 3787 | 57 |
2194294 | 2194294 | 2022-02-08 | Jefferson | Idaho | 16051 | 5851 | 57 |
2191040 | 2191040 | 2022-02-07 | Jefferson | Idaho | 16051 | 5843 | 57 |
2187787 | 2187787 | 2022-02-06 | Jefferson | Idaho | 16051 | 5832 | 57 |
2184534 | 2184534 | 2022-02-05 | Jefferson | Idaho | 16051 | 5832 | 57 |
2181282 | 2181282 | 2022-02-04 | Jefferson | Idaho | 16051 | 5825 | 57 |
2178031 | 2178031 | 2022-02-03 | Jefferson | Idaho | 16051 | 5816 | 57 |
2171519 | 2171519 | 2022-02-01 | Elmore | Idaho | 16039 | 5336 | 57 |
2168266 | 2168266 | 2022-01-31 | Elmore | Idaho | 16039 | 5288 | 57 |
2165011 | 2165011 | 2022-01-30 | Elmore | Idaho | 16039 | 5233 | 57 |
2161756 | 2161756 | 2022-01-29 | Elmore | Idaho | 16039 | 5233 | 57 |
2158500 | 2158500 | 2022-01-28 | Elmore | Idaho | 16039 | 5173 | 57 |
2155247 | 2155247 | 2022-01-27 | Elmore | Idaho | 16039 | 5173 | 57 |
2151994 | 2151994 | 2022-01-26 | Elmore | Idaho | 16039 | 5131 | 57 |
2148742 | 2148742 | 2022-01-25 | Elmore | Idaho | 16039 | 5057 | 57 |
2086954 | 2086954 | 2022-01-06 | Jerome | Idaho | 16053 | 4542 | 57 |
2083702 | 2083702 | 2022-01-05 | Jerome | Idaho | 16053 | 4521 | 57 |
2080450 | 2080450 | 2022-01-04 | Jerome | Idaho | 16053 | 4505 | 57 |
2077198 | 2077198 | 2022-01-03 | Jerome | Idaho | 16053 | 4501 | 57 |
2073947 | 2073947 | 2022-01-02 | Jerome | Idaho | 16053 | 4494 | 57 |
2070696 | 2070696 | 2022-01-01 | Jerome | Idaho | 16053 | 4494 | 57 |
2067445 | 2067445 | 2021-12-31 | Jerome | Idaho | 16053 | 4494 | 57 |
2064194 | 2064194 | 2021-12-30 | Jerome | Idaho | 16053 | 4494 | 57 |
2060944 | 2060944 | 2021-12-29 | Jerome | Idaho | 16053 | 4486 | 57 |
2057695 | 2057695 | 2021-12-28 | Jerome | Idaho | 16053 | 4475 | 57 |
1849687 | 1849687 | 2021-10-25 | Gem | Idaho | 16045 | 2762 | 57 |
1830205 | 1830205 | 2021-10-19 | Payette | Idaho | 16075 | 3927 | 57 |
1826956 | 1826956 | 2021-10-18 | Payette | Idaho | 16075 | 3903 | 57 |
1823707 | 1823707 | 2021-10-17 | Payette | Idaho | 16075 | 3886 | 57 |
1823709 | 1823709 | 2021-10-17 | Shoshone | Idaho | 16079 | 1859 | 57 |
1820458 | 1820458 | 2021-10-16 | Payette | Idaho | 16075 | 3865 | 57 |
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);