ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 16005 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 153 ✖
- 0 69
- 1 56
- 110 52
- 247 50
- 2 37
- 4 25
- 217 15
- 106 14
- 98 12
- 8 9
- 97 9
- 113 9
- 96 8
- 123 8
- 230 8
- 14 7
- 99 7
- 108 7
- 125 7
- 196 7
- 235 7
- 239 7
- 242 7
- 5 6
- 17 6
- 92 6
- 114 6
- 115 6
- 207 6
- 213 6
- 216 6
- 244 6
- 10 5
- 28 5
- 29 5
- 51 5
- 93 5
- 95 5
- 101 5
- 107 5
- 109 5
- 122 5
- 138 5
- 148 5
- 168 5
- 201 5
- 210 5
- 222 5
- 238 5
- 69 4
- 78 4
- 84 4
- 105 4
- 112 4
- 116 4
- 131 4
- 158 4
- 192 4
- 203 4
- 9 3
- 22 3
- 37 3
- 56 3
- 81 3
- 83 3
- 86 3
- 87 3
- 104 3
- 118 3
- 127 3
- 128 3
- 132 3
- 171 3
- 185 3
- 188 3
- 190 3
- 205 3
- 229 3
- 231 3
- 3 2
- 6 2
- 11 2
- 19 2
- 20 2
- 25 2
- 44 2
- 45 2
- 57 2
- 62 2
- 63 2
- 65 2
- 66 2
- 70 2
- 79 2
- 90 2
- 91 2
- 100 2
- 102 2
- 103 2
- 133 2
- 144 2
- 174 2
- 180 2
- 194 2
- 195 2
- 208 2
- 224 2
- 228 2
- 241 2
- 245 2
- 13 1
- 15 1
- 27 1
- 32 1
- 33 1
- 34 1
- 35 1
- 40 1
- 41 1
- 42 1
- 46 1
- 48 1
- 53 1
- 54 1
- 60 1
- 68 1
- 75 1
- 76 1
- 80 1
- 85 1
- 120 1
- 121 1
- 134 1
- 145 1
- 155 1
- 157 1
- 165 1
- 166 1
- 167 1
- 175 1
- 178 1
- 189 1
- 200 1
- 206 1
- 209 1
- 214 1
- 218 1
- 220 1
- 221 1
- 223 1
- 233 1
- 237 1
- 246 1
state 1
- Idaho · 781 ✖
fips 1
- 16005 · 781 ✖
county 1
- Bannock 781
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500135 | 2500135 | 2022-05-13 | Bannock | Idaho | 16005 | 20914 | 247 |
2496877 | 2496877 | 2022-05-12 | Bannock | Idaho | 16005 | 20906 | 247 |
2493619 | 2493619 | 2022-05-11 | Bannock | Idaho | 16005 | 20906 | 247 |
2490361 | 2490361 | 2022-05-10 | Bannock | Idaho | 16005 | 20893 | 247 |
2487104 | 2487104 | 2022-05-09 | Bannock | Idaho | 16005 | 20893 | 247 |
2483846 | 2483846 | 2022-05-08 | Bannock | Idaho | 16005 | 20886 | 247 |
2480588 | 2480588 | 2022-05-07 | Bannock | Idaho | 16005 | 20886 | 247 |
2477330 | 2477330 | 2022-05-06 | Bannock | Idaho | 16005 | 20886 | 247 |
2474072 | 2474072 | 2022-05-05 | Bannock | Idaho | 16005 | 20873 | 247 |
2470815 | 2470815 | 2022-05-04 | Bannock | Idaho | 16005 | 20873 | 247 |
2467559 | 2467559 | 2022-05-03 | Bannock | Idaho | 16005 | 20860 | 247 |
2464304 | 2464304 | 2022-05-02 | Bannock | Idaho | 16005 | 20860 | 247 |
2461048 | 2461048 | 2022-05-01 | Bannock | Idaho | 16005 | 20852 | 247 |
2457792 | 2457792 | 2022-04-30 | Bannock | Idaho | 16005 | 20852 | 247 |
2454536 | 2454536 | 2022-04-29 | Bannock | Idaho | 16005 | 20852 | 247 |
2451280 | 2451280 | 2022-04-28 | Bannock | Idaho | 16005 | 20840 | 247 |
2448024 | 2448024 | 2022-04-27 | Bannock | Idaho | 16005 | 20840 | 247 |
2444768 | 2444768 | 2022-04-26 | Bannock | Idaho | 16005 | 20835 | 247 |
2441512 | 2441512 | 2022-04-25 | Bannock | Idaho | 16005 | 20835 | 247 |
2438256 | 2438256 | 2022-04-24 | Bannock | Idaho | 16005 | 20830 | 247 |
2435000 | 2435000 | 2022-04-23 | Bannock | Idaho | 16005 | 20830 | 247 |
2431744 | 2431744 | 2022-04-22 | Bannock | Idaho | 16005 | 20830 | 247 |
2428488 | 2428488 | 2022-04-21 | Bannock | Idaho | 16005 | 20813 | 247 |
2425232 | 2425232 | 2022-04-20 | Bannock | Idaho | 16005 | 20813 | 247 |
2421976 | 2421976 | 2022-04-19 | Bannock | Idaho | 16005 | 20807 | 247 |
2418720 | 2418720 | 2022-04-18 | Bannock | Idaho | 16005 | 20807 | 247 |
2415464 | 2415464 | 2022-04-17 | Bannock | Idaho | 16005 | 20802 | 247 |
2412208 | 2412208 | 2022-04-16 | Bannock | Idaho | 16005 | 20802 | 247 |
2408952 | 2408952 | 2022-04-15 | Bannock | Idaho | 16005 | 20802 | 247 |
2405696 | 2405696 | 2022-04-14 | Bannock | Idaho | 16005 | 20803 | 247 |
2402441 | 2402441 | 2022-04-13 | Bannock | Idaho | 16005 | 20794 | 247 |
2399186 | 2399186 | 2022-04-12 | Bannock | Idaho | 16005 | 20793 | 247 |
2395931 | 2395931 | 2022-04-11 | Bannock | Idaho | 16005 | 20776 | 247 |
2392675 | 2392675 | 2022-04-10 | Bannock | Idaho | 16005 | 20776 | 247 |
2389419 | 2389419 | 2022-04-09 | Bannock | Idaho | 16005 | 20776 | 247 |
2386164 | 2386164 | 2022-04-08 | Bannock | Idaho | 16005 | 20776 | 247 |
2382909 | 2382909 | 2022-04-07 | Bannock | Idaho | 16005 | 20774 | 247 |
2379654 | 2379654 | 2022-04-06 | Bannock | Idaho | 16005 | 20773 | 247 |
2376400 | 2376400 | 2022-04-05 | Bannock | Idaho | 16005 | 20780 | 247 |
2373148 | 2373148 | 2022-04-04 | Bannock | Idaho | 16005 | 20781 | 247 |
2369895 | 2369895 | 2022-04-03 | Bannock | Idaho | 16005 | 20779 | 247 |
2366642 | 2366642 | 2022-04-02 | Bannock | Idaho | 16005 | 20779 | 247 |
2363389 | 2363389 | 2022-04-01 | Bannock | Idaho | 16005 | 20779 | 247 |
2360135 | 2360135 | 2022-03-31 | Bannock | Idaho | 16005 | 20779 | 247 |
2356881 | 2356881 | 2022-03-30 | Bannock | Idaho | 16005 | 20780 | 247 |
2353628 | 2353628 | 2022-03-29 | Bannock | Idaho | 16005 | 20779 | 247 |
2350376 | 2350376 | 2022-03-28 | Bannock | Idaho | 16005 | 20778 | 247 |
2347123 | 2347123 | 2022-03-27 | Bannock | Idaho | 16005 | 20774 | 247 |
2343870 | 2343870 | 2022-03-26 | Bannock | Idaho | 16005 | 20774 | 247 |
2340617 | 2340617 | 2022-03-25 | Bannock | Idaho | 16005 | 20774 | 247 |
2337364 | 2337364 | 2022-03-24 | Bannock | Idaho | 16005 | 20774 | 246 |
2334110 | 2334110 | 2022-03-23 | Bannock | Idaho | 16005 | 20772 | 245 |
2330856 | 2330856 | 2022-03-22 | Bannock | Idaho | 16005 | 20771 | 245 |
2327604 | 2327604 | 2022-03-21 | Bannock | Idaho | 16005 | 20770 | 244 |
2324351 | 2324351 | 2022-03-20 | Bannock | Idaho | 16005 | 20767 | 244 |
2321097 | 2321097 | 2022-03-19 | Bannock | Idaho | 16005 | 20767 | 244 |
2317843 | 2317843 | 2022-03-18 | Bannock | Idaho | 16005 | 20767 | 244 |
2314590 | 2314590 | 2022-03-17 | Bannock | Idaho | 16005 | 20766 | 244 |
2311337 | 2311337 | 2022-03-16 | Bannock | Idaho | 16005 | 20763 | 244 |
2308084 | 2308084 | 2022-03-15 | Bannock | Idaho | 16005 | 20758 | 242 |
2304833 | 2304833 | 2022-03-14 | Bannock | Idaho | 16005 | 20758 | 242 |
2301581 | 2301581 | 2022-03-13 | Bannock | Idaho | 16005 | 20750 | 242 |
2298329 | 2298329 | 2022-03-12 | Bannock | Idaho | 16005 | 20750 | 242 |
2295077 | 2295077 | 2022-03-11 | Bannock | Idaho | 16005 | 20750 | 242 |
2291825 | 2291825 | 2022-03-10 | Bannock | Idaho | 16005 | 20746 | 242 |
2288573 | 2288573 | 2022-03-09 | Bannock | Idaho | 16005 | 20743 | 242 |
2285322 | 2285322 | 2022-03-08 | Bannock | Idaho | 16005 | 20729 | 241 |
2282070 | 2282070 | 2022-03-07 | Bannock | Idaho | 16005 | 20721 | 241 |
2278817 | 2278817 | 2022-03-06 | Bannock | Idaho | 16005 | 20710 | 239 |
2275564 | 2275564 | 2022-03-05 | Bannock | Idaho | 16005 | 20710 | 239 |
2272311 | 2272311 | 2022-03-04 | Bannock | Idaho | 16005 | 20710 | 239 |
2269059 | 2269059 | 2022-03-03 | Bannock | Idaho | 16005 | 20704 | 239 |
2265806 | 2265806 | 2022-03-02 | Bannock | Idaho | 16005 | 20691 | 239 |
2262555 | 2262555 | 2022-03-01 | Bannock | Idaho | 16005 | 20682 | 239 |
2259304 | 2259304 | 2022-02-28 | Bannock | Idaho | 16005 | 20660 | 239 |
2256053 | 2256053 | 2022-02-27 | Bannock | Idaho | 16005 | 20639 | 238 |
2252802 | 2252802 | 2022-02-26 | Bannock | Idaho | 16005 | 20639 | 238 |
2249551 | 2249551 | 2022-02-25 | Bannock | Idaho | 16005 | 20639 | 238 |
2246300 | 2246300 | 2022-02-24 | Bannock | Idaho | 16005 | 20609 | 238 |
2243049 | 2243049 | 2022-02-23 | Bannock | Idaho | 16005 | 20586 | 238 |
2239798 | 2239798 | 2022-02-22 | Bannock | Idaho | 16005 | 20566 | 237 |
2236547 | 2236547 | 2022-02-21 | Bannock | Idaho | 16005 | 20515 | 235 |
2233296 | 2233296 | 2022-02-20 | Bannock | Idaho | 16005 | 20515 | 235 |
2230045 | 2230045 | 2022-02-19 | Bannock | Idaho | 16005 | 20515 | 235 |
2226794 | 2226794 | 2022-02-18 | Bannock | Idaho | 16005 | 20515 | 235 |
2223543 | 2223543 | 2022-02-17 | Bannock | Idaho | 16005 | 20500 | 235 |
2220292 | 2220292 | 2022-02-16 | Bannock | Idaho | 16005 | 20475 | 235 |
2217041 | 2217041 | 2022-02-15 | Bannock | Idaho | 16005 | 20459 | 235 |
2213790 | 2213790 | 2022-02-14 | Bannock | Idaho | 16005 | 20423 | 233 |
2210538 | 2210538 | 2022-02-13 | Bannock | Idaho | 16005 | 20355 | 231 |
2207285 | 2207285 | 2022-02-12 | Bannock | Idaho | 16005 | 20355 | 231 |
2204032 | 2204032 | 2022-02-11 | Bannock | Idaho | 16005 | 20350 | 231 |
2200779 | 2200779 | 2022-02-10 | Bannock | Idaho | 16005 | 20237 | 230 |
2197525 | 2197525 | 2022-02-09 | Bannock | Idaho | 16005 | 20182 | 230 |
2194271 | 2194271 | 2022-02-08 | Bannock | Idaho | 16005 | 20107 | 230 |
2191017 | 2191017 | 2022-02-07 | Bannock | Idaho | 16005 | 20009 | 230 |
2187764 | 2187764 | 2022-02-06 | Bannock | Idaho | 16005 | 19875 | 230 |
2184511 | 2184511 | 2022-02-05 | Bannock | Idaho | 16005 | 19875 | 230 |
2181259 | 2181259 | 2022-02-04 | Bannock | Idaho | 16005 | 19870 | 230 |
2178008 | 2178008 | 2022-02-03 | Bannock | Idaho | 16005 | 19730 | 230 |
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);