ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where county = "Shoshone" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500172 | 2500172 | 2022-05-13 | Shoshone | Idaho | 16079 | 2746 | 76 |
2496914 | 2496914 | 2022-05-12 | Shoshone | Idaho | 16079 | 2745 | 76 |
2493656 | 2493656 | 2022-05-11 | Shoshone | Idaho | 16079 | 2745 | 76 |
2490398 | 2490398 | 2022-05-10 | Shoshone | Idaho | 16079 | 2739 | 76 |
2487141 | 2487141 | 2022-05-09 | Shoshone | Idaho | 16079 | 2739 | 76 |
2483883 | 2483883 | 2022-05-08 | Shoshone | Idaho | 16079 | 2739 | 76 |
2480625 | 2480625 | 2022-05-07 | Shoshone | Idaho | 16079 | 2739 | 76 |
2477367 | 2477367 | 2022-05-06 | Shoshone | Idaho | 16079 | 2739 | 76 |
2474109 | 2474109 | 2022-05-05 | Shoshone | Idaho | 16079 | 2739 | 76 |
2470852 | 2470852 | 2022-05-04 | Shoshone | Idaho | 16079 | 2739 | 76 |
2467596 | 2467596 | 2022-05-03 | Shoshone | Idaho | 16079 | 2737 | 76 |
2464341 | 2464341 | 2022-05-02 | Shoshone | Idaho | 16079 | 2737 | 76 |
2461085 | 2461085 | 2022-05-01 | Shoshone | Idaho | 16079 | 2737 | 76 |
2457829 | 2457829 | 2022-04-30 | Shoshone | Idaho | 16079 | 2737 | 76 |
2454573 | 2454573 | 2022-04-29 | Shoshone | Idaho | 16079 | 2737 | 76 |
2451317 | 2451317 | 2022-04-28 | Shoshone | Idaho | 16079 | 2736 | 76 |
2448061 | 2448061 | 2022-04-27 | Shoshone | Idaho | 16079 | 2736 | 76 |
2444805 | 2444805 | 2022-04-26 | Shoshone | Idaho | 16079 | 2736 | 76 |
2441549 | 2441549 | 2022-04-25 | Shoshone | Idaho | 16079 | 2736 | 76 |
2438293 | 2438293 | 2022-04-24 | Shoshone | Idaho | 16079 | 2735 | 76 |
2435037 | 2435037 | 2022-04-23 | Shoshone | Idaho | 16079 | 2735 | 76 |
2431781 | 2431781 | 2022-04-22 | Shoshone | Idaho | 16079 | 2735 | 76 |
2428525 | 2428525 | 2022-04-21 | Shoshone | Idaho | 16079 | 2734 | 76 |
2425269 | 2425269 | 2022-04-20 | Shoshone | Idaho | 16079 | 2734 | 76 |
2422013 | 2422013 | 2022-04-19 | Shoshone | Idaho | 16079 | 2734 | 76 |
2418757 | 2418757 | 2022-04-18 | Shoshone | Idaho | 16079 | 2734 | 76 |
2415501 | 2415501 | 2022-04-17 | Shoshone | Idaho | 16079 | 2734 | 76 |
2412245 | 2412245 | 2022-04-16 | Shoshone | Idaho | 16079 | 2734 | 76 |
2408989 | 2408989 | 2022-04-15 | Shoshone | Idaho | 16079 | 2734 | 76 |
2405733 | 2405733 | 2022-04-14 | Shoshone | Idaho | 16079 | 2734 | 76 |
2402478 | 2402478 | 2022-04-13 | Shoshone | Idaho | 16079 | 2734 | 76 |
2399223 | 2399223 | 2022-04-12 | Shoshone | Idaho | 16079 | 2733 | 76 |
2395968 | 2395968 | 2022-04-11 | Shoshone | Idaho | 16079 | 2732 | 76 |
2392712 | 2392712 | 2022-04-10 | Shoshone | Idaho | 16079 | 2732 | 76 |
2389456 | 2389456 | 2022-04-09 | Shoshone | Idaho | 16079 | 2732 | 76 |
2386201 | 2386201 | 2022-04-08 | Shoshone | Idaho | 16079 | 2732 | 76 |
2382946 | 2382946 | 2022-04-07 | Shoshone | Idaho | 16079 | 2732 | 76 |
2379691 | 2379691 | 2022-04-06 | Shoshone | Idaho | 16079 | 2732 | 76 |
2376437 | 2376437 | 2022-04-05 | Shoshone | Idaho | 16079 | 2731 | 76 |
2373185 | 2373185 | 2022-04-04 | Shoshone | Idaho | 16079 | 2731 | 76 |
2369932 | 2369932 | 2022-04-03 | Shoshone | Idaho | 16079 | 2730 | 76 |
2366679 | 2366679 | 2022-04-02 | Shoshone | Idaho | 16079 | 2730 | 76 |
2363426 | 2363426 | 2022-04-01 | Shoshone | Idaho | 16079 | 2730 | 76 |
2360172 | 2360172 | 2022-03-31 | Shoshone | Idaho | 16079 | 2730 | 76 |
2356918 | 2356918 | 2022-03-30 | Shoshone | Idaho | 16079 | 2730 | 76 |
2353665 | 2353665 | 2022-03-29 | Shoshone | Idaho | 16079 | 2730 | 75 |
2350413 | 2350413 | 2022-03-28 | Shoshone | Idaho | 16079 | 2730 | 75 |
2347160 | 2347160 | 2022-03-27 | Shoshone | Idaho | 16079 | 2729 | 75 |
2343907 | 2343907 | 2022-03-26 | Shoshone | Idaho | 16079 | 2729 | 75 |
2340654 | 2340654 | 2022-03-25 | Shoshone | Idaho | 16079 | 2729 | 75 |
2337401 | 2337401 | 2022-03-24 | Shoshone | Idaho | 16079 | 2729 | 75 |
2334147 | 2334147 | 2022-03-23 | Shoshone | Idaho | 16079 | 2727 | 75 |
2330893 | 2330893 | 2022-03-22 | Shoshone | Idaho | 16079 | 2726 | 75 |
2327641 | 2327641 | 2022-03-21 | Shoshone | Idaho | 16079 | 2720 | 75 |
2324388 | 2324388 | 2022-03-20 | Shoshone | Idaho | 16079 | 2712 | 75 |
2321134 | 2321134 | 2022-03-19 | Shoshone | Idaho | 16079 | 2712 | 75 |
2317880 | 2317880 | 2022-03-18 | Shoshone | Idaho | 16079 | 2712 | 75 |
2314627 | 2314627 | 2022-03-17 | Shoshone | Idaho | 16079 | 2698 | 75 |
2311374 | 2311374 | 2022-03-16 | Shoshone | Idaho | 16079 | 2689 | 75 |
2308121 | 2308121 | 2022-03-15 | Shoshone | Idaho | 16079 | 2676 | 75 |
2304870 | 2304870 | 2022-03-14 | Shoshone | Idaho | 16079 | 2665 | 75 |
2301618 | 2301618 | 2022-03-13 | Shoshone | Idaho | 16079 | 2647 | 75 |
2298366 | 2298366 | 2022-03-12 | Shoshone | Idaho | 16079 | 2647 | 75 |
2295114 | 2295114 | 2022-03-11 | Shoshone | Idaho | 16079 | 2647 | 75 |
2291862 | 2291862 | 2022-03-10 | Shoshone | Idaho | 16079 | 2637 | 75 |
2288610 | 2288610 | 2022-03-09 | Shoshone | Idaho | 16079 | 2623 | 75 |
2285359 | 2285359 | 2022-03-08 | Shoshone | Idaho | 16079 | 2606 | 75 |
2282107 | 2282107 | 2022-03-07 | Shoshone | Idaho | 16079 | 2603 | 75 |
2278854 | 2278854 | 2022-03-06 | Shoshone | Idaho | 16079 | 2599 | 75 |
2275601 | 2275601 | 2022-03-05 | Shoshone | Idaho | 16079 | 2599 | 75 |
2272348 | 2272348 | 2022-03-04 | Shoshone | Idaho | 16079 | 2599 | 75 |
2269096 | 2269096 | 2022-03-03 | Shoshone | Idaho | 16079 | 2590 | 75 |
2265843 | 2265843 | 2022-03-02 | Shoshone | Idaho | 16079 | 2587 | 75 |
2262592 | 2262592 | 2022-03-01 | Shoshone | Idaho | 16079 | 2580 | 74 |
2259341 | 2259341 | 2022-02-28 | Shoshone | Idaho | 16079 | 2578 | 74 |
2256090 | 2256090 | 2022-02-27 | Shoshone | Idaho | 16079 | 2575 | 74 |
2252839 | 2252839 | 2022-02-26 | Shoshone | Idaho | 16079 | 2575 | 74 |
2249588 | 2249588 | 2022-02-25 | Shoshone | Idaho | 16079 | 2575 | 74 |
2246337 | 2246337 | 2022-02-24 | Shoshone | Idaho | 16079 | 2574 | 74 |
2243086 | 2243086 | 2022-02-23 | Shoshone | Idaho | 16079 | 2570 | 74 |
2239835 | 2239835 | 2022-02-22 | Shoshone | Idaho | 16079 | 2569 | 74 |
2236584 | 2236584 | 2022-02-21 | Shoshone | Idaho | 16079 | 2563 | 74 |
2233333 | 2233333 | 2022-02-20 | Shoshone | Idaho | 16079 | 2563 | 74 |
2230082 | 2230082 | 2022-02-19 | Shoshone | Idaho | 16079 | 2563 | 74 |
2226831 | 2226831 | 2022-02-18 | Shoshone | Idaho | 16079 | 2560 | 74 |
2223580 | 2223580 | 2022-02-17 | Shoshone | Idaho | 16079 | 2556 | 74 |
2220329 | 2220329 | 2022-02-16 | Shoshone | Idaho | 16079 | 2548 | 74 |
2217078 | 2217078 | 2022-02-15 | Shoshone | Idaho | 16079 | 2543 | 73 |
2213827 | 2213827 | 2022-02-14 | Shoshone | Idaho | 16079 | 2529 | 71 |
2210575 | 2210575 | 2022-02-13 | Shoshone | Idaho | 16079 | 2524 | 71 |
2207322 | 2207322 | 2022-02-12 | Shoshone | Idaho | 16079 | 2524 | 71 |
2204069 | 2204069 | 2022-02-11 | Shoshone | Idaho | 16079 | 2515 | 71 |
2200816 | 2200816 | 2022-02-10 | Shoshone | Idaho | 16079 | 2513 | 71 |
2197562 | 2197562 | 2022-02-09 | Shoshone | Idaho | 16079 | 2487 | 71 |
2194308 | 2194308 | 2022-02-08 | Shoshone | Idaho | 16079 | 2479 | 71 |
2191054 | 2191054 | 2022-02-07 | Shoshone | Idaho | 16079 | 2473 | 71 |
2187801 | 2187801 | 2022-02-06 | Shoshone | Idaho | 16079 | 2462 | 71 |
2184548 | 2184548 | 2022-02-05 | Shoshone | Idaho | 16079 | 2462 | 71 |
2181296 | 2181296 | 2022-02-04 | Shoshone | Idaho | 16079 | 2458 | 71 |
2178045 | 2178045 | 2022-02-03 | Shoshone | Idaho | 16079 | 2446 | 71 |
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);