ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
303 rows where deaths = 20 and state = "Idaho" 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 |
---|---|---|---|---|---|---|---|
2500171 | 2500171 | 2022-05-13 | Power | Idaho | 16077 | 1496 | 20 |
2496913 | 2496913 | 2022-05-12 | Power | Idaho | 16077 | 1495 | 20 |
2493655 | 2493655 | 2022-05-11 | Power | Idaho | 16077 | 1495 | 20 |
2490397 | 2490397 | 2022-05-10 | Power | Idaho | 16077 | 1495 | 20 |
2487140 | 2487140 | 2022-05-09 | Power | Idaho | 16077 | 1495 | 20 |
2483882 | 2483882 | 2022-05-08 | Power | Idaho | 16077 | 1495 | 20 |
2480624 | 2480624 | 2022-05-07 | Power | Idaho | 16077 | 1495 | 20 |
2477366 | 2477366 | 2022-05-06 | Power | Idaho | 16077 | 1495 | 20 |
2474108 | 2474108 | 2022-05-05 | Power | Idaho | 16077 | 1495 | 20 |
2470851 | 2470851 | 2022-05-04 | Power | Idaho | 16077 | 1495 | 20 |
2467595 | 2467595 | 2022-05-03 | Power | Idaho | 16077 | 1495 | 20 |
2464340 | 2464340 | 2022-05-02 | Power | Idaho | 16077 | 1495 | 20 |
2461084 | 2461084 | 2022-05-01 | Power | Idaho | 16077 | 1494 | 20 |
2457828 | 2457828 | 2022-04-30 | Power | Idaho | 16077 | 1494 | 20 |
2454572 | 2454572 | 2022-04-29 | Power | Idaho | 16077 | 1494 | 20 |
2451316 | 2451316 | 2022-04-28 | Power | Idaho | 16077 | 1494 | 20 |
2448060 | 2448060 | 2022-04-27 | Power | Idaho | 16077 | 1494 | 20 |
2444804 | 2444804 | 2022-04-26 | Power | Idaho | 16077 | 1493 | 20 |
2441548 | 2441548 | 2022-04-25 | Power | Idaho | 16077 | 1493 | 20 |
2438292 | 2438292 | 2022-04-24 | Power | Idaho | 16077 | 1493 | 20 |
2435036 | 2435036 | 2022-04-23 | Power | Idaho | 16077 | 1493 | 20 |
2431780 | 2431780 | 2022-04-22 | Power | Idaho | 16077 | 1493 | 20 |
2428524 | 2428524 | 2022-04-21 | Power | Idaho | 16077 | 1492 | 20 |
2425268 | 2425268 | 2022-04-20 | Power | Idaho | 16077 | 1492 | 20 |
2422012 | 2422012 | 2022-04-19 | Power | Idaho | 16077 | 1492 | 20 |
2418756 | 2418756 | 2022-04-18 | Power | Idaho | 16077 | 1492 | 20 |
2415500 | 2415500 | 2022-04-17 | Power | Idaho | 16077 | 1492 | 20 |
2412244 | 2412244 | 2022-04-16 | Power | Idaho | 16077 | 1492 | 20 |
2408988 | 2408988 | 2022-04-15 | Power | Idaho | 16077 | 1492 | 20 |
2405732 | 2405732 | 2022-04-14 | Power | Idaho | 16077 | 1492 | 20 |
2402477 | 2402477 | 2022-04-13 | Power | Idaho | 16077 | 1492 | 20 |
2399222 | 2399222 | 2022-04-12 | Power | Idaho | 16077 | 1492 | 20 |
2395967 | 2395967 | 2022-04-11 | Power | Idaho | 16077 | 1490 | 20 |
2392711 | 2392711 | 2022-04-10 | Power | Idaho | 16077 | 1490 | 20 |
2389455 | 2389455 | 2022-04-09 | Power | Idaho | 16077 | 1490 | 20 |
2386200 | 2386200 | 2022-04-08 | Power | Idaho | 16077 | 1490 | 20 |
2382945 | 2382945 | 2022-04-07 | Power | Idaho | 16077 | 1490 | 20 |
2379690 | 2379690 | 2022-04-06 | Power | Idaho | 16077 | 1490 | 20 |
2376436 | 2376436 | 2022-04-05 | Power | Idaho | 16077 | 1490 | 20 |
2373184 | 2373184 | 2022-04-04 | Power | Idaho | 16077 | 1490 | 20 |
2369931 | 2369931 | 2022-04-03 | Power | Idaho | 16077 | 1490 | 20 |
2366678 | 2366678 | 2022-04-02 | Power | Idaho | 16077 | 1490 | 20 |
2363425 | 2363425 | 2022-04-01 | Power | Idaho | 16077 | 1490 | 20 |
2360171 | 2360171 | 2022-03-31 | Power | Idaho | 16077 | 1490 | 20 |
2356917 | 2356917 | 2022-03-30 | Power | Idaho | 16077 | 1489 | 20 |
2353664 | 2353664 | 2022-03-29 | Power | Idaho | 16077 | 1489 | 20 |
2350412 | 2350412 | 2022-03-28 | Power | Idaho | 16077 | 1489 | 20 |
2347159 | 2347159 | 2022-03-27 | Power | Idaho | 16077 | 1488 | 20 |
2343906 | 2343906 | 2022-03-26 | Power | Idaho | 16077 | 1488 | 20 |
2340653 | 2340653 | 2022-03-25 | Power | Idaho | 16077 | 1488 | 20 |
2337400 | 2337400 | 2022-03-24 | Power | Idaho | 16077 | 1488 | 20 |
2334146 | 2334146 | 2022-03-23 | Power | Idaho | 16077 | 1488 | 20 |
2330892 | 2330892 | 2022-03-22 | Power | Idaho | 16077 | 1488 | 20 |
2327640 | 2327640 | 2022-03-21 | Power | Idaho | 16077 | 1488 | 20 |
2324387 | 2324387 | 2022-03-20 | Power | Idaho | 16077 | 1488 | 20 |
2321133 | 2321133 | 2022-03-19 | Power | Idaho | 16077 | 1488 | 20 |
2317879 | 2317879 | 2022-03-18 | Power | Idaho | 16077 | 1488 | 20 |
2314626 | 2314626 | 2022-03-17 | Power | Idaho | 16077 | 1488 | 20 |
2311373 | 2311373 | 2022-03-16 | Power | Idaho | 16077 | 1488 | 20 |
2308120 | 2308120 | 2022-03-15 | Power | Idaho | 16077 | 1488 | 20 |
2304869 | 2304869 | 2022-03-14 | Power | Idaho | 16077 | 1488 | 20 |
2301617 | 2301617 | 2022-03-13 | Power | Idaho | 16077 | 1488 | 20 |
2298365 | 2298365 | 2022-03-12 | Power | Idaho | 16077 | 1488 | 20 |
2295113 | 2295113 | 2022-03-11 | Power | Idaho | 16077 | 1488 | 20 |
2291861 | 2291861 | 2022-03-10 | Power | Idaho | 16077 | 1487 | 20 |
2288609 | 2288609 | 2022-03-09 | Power | Idaho | 16077 | 1487 | 20 |
2285358 | 2285358 | 2022-03-08 | Power | Idaho | 16077 | 1487 | 20 |
2282106 | 2282106 | 2022-03-07 | Power | Idaho | 16077 | 1487 | 20 |
2278853 | 2278853 | 2022-03-06 | Power | Idaho | 16077 | 1486 | 20 |
2275600 | 2275600 | 2022-03-05 | Power | Idaho | 16077 | 1486 | 20 |
2272347 | 2272347 | 2022-03-04 | Power | Idaho | 16077 | 1486 | 20 |
2269095 | 2269095 | 2022-03-03 | Power | Idaho | 16077 | 1486 | 20 |
2265842 | 2265842 | 2022-03-02 | Power | Idaho | 16077 | 1486 | 20 |
2262591 | 2262591 | 2022-03-01 | Power | Idaho | 16077 | 1485 | 20 |
2259340 | 2259340 | 2022-02-28 | Power | Idaho | 16077 | 1479 | 20 |
2256089 | 2256089 | 2022-02-27 | Power | Idaho | 16077 | 1480 | 20 |
2252838 | 2252838 | 2022-02-26 | Power | Idaho | 16077 | 1480 | 20 |
2249587 | 2249587 | 2022-02-25 | Power | Idaho | 16077 | 1480 | 20 |
2246336 | 2246336 | 2022-02-24 | Power | Idaho | 16077 | 1481 | 20 |
2243085 | 2243085 | 2022-02-23 | Power | Idaho | 16077 | 1477 | 20 |
2239834 | 2239834 | 2022-02-22 | Power | Idaho | 16077 | 1475 | 20 |
2236583 | 2236583 | 2022-02-21 | Power | Idaho | 16077 | 1474 | 20 |
2233332 | 2233332 | 2022-02-20 | Power | Idaho | 16077 | 1474 | 20 |
2230081 | 2230081 | 2022-02-19 | Power | Idaho | 16077 | 1474 | 20 |
2226830 | 2226830 | 2022-02-18 | Power | Idaho | 16077 | 1474 | 20 |
2132474 | 2132474 | 2022-01-20 | Fremont | Idaho | 16043 | 1968 | 20 |
2129221 | 2129221 | 2022-01-19 | Fremont | Idaho | 16043 | 1936 | 20 |
2125967 | 2125967 | 2022-01-18 | Fremont | Idaho | 16043 | 1912 | 20 |
2122715 | 2122715 | 2022-01-17 | Fremont | Idaho | 16043 | 1899 | 20 |
2119463 | 2119463 | 2022-01-16 | Fremont | Idaho | 16043 | 1899 | 20 |
2116211 | 2116211 | 2022-01-15 | Fremont | Idaho | 16043 | 1899 | 20 |
2112960 | 2112960 | 2022-01-14 | Fremont | Idaho | 16043 | 1894 | 20 |
2109708 | 2109708 | 2022-01-13 | Fremont | Idaho | 16043 | 1862 | 20 |
2106457 | 2106457 | 2022-01-12 | Fremont | Idaho | 16043 | 1851 | 20 |
2103206 | 2103206 | 2022-01-11 | Fremont | Idaho | 16043 | 1838 | 20 |
2099955 | 2099955 | 2022-01-10 | Fremont | Idaho | 16043 | 1821 | 20 |
2096704 | 2096704 | 2022-01-09 | Fremont | Idaho | 16043 | 1811 | 20 |
2093452 | 2093452 | 2022-01-08 | Fremont | Idaho | 16043 | 1811 | 20 |
2090200 | 2090200 | 2022-01-07 | Fremont | Idaho | 16043 | 1810 | 20 |
2086949 | 2086949 | 2022-01-06 | Fremont | Idaho | 16043 | 1801 | 20 |
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);