ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Elmore" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 196 ✖
- 2 95
- 3 73
- 19 72
- 70 70
- 0 56
- 4 52
- 10 37
- 14 36
- 9 30
- 12 29
- 47 29
- 52 27
- 347 24
- 7 23
- 13 19
- 214 19
- 6 18
- 50 18
- 294 18
- 1 17
- 44 17
- 54 17
- 11 16
- 15 16
- 17 16
- 205 16
- 58 15
- 61 15
- 20 14
- 51 13
- 296 13
- 53 11
- 217 11
- 297 11
- 301 11
- 59 10
- 64 10
- 200 10
- 295 10
- 302 10
- 343 10
- 23 9
- 27 9
- 37 9
- 42 9
- 48 9
- 201 9
- 208 9
- 288 9
- 57 8
- 206 8
- 8 7
- 38 7
- 39 7
- 41 7
- 43 7
- 63 7
- 69 7
- 215 7
- 220 7
- 234 7
- 284 7
- 18 6
- 24 6
- 31 6
- 34 6
- 80 6
- 83 6
- 101 6
- 202 6
- 216 6
- 236 6
- 286 6
- 324 6
- 340 6
- 342 6
- 46 5
- 49 5
- 55 5
- 72 5
- 81 5
- 85 5
- 168 5
- 185 5
- 190 5
- 198 5
- 210 5
- 212 5
- 231 5
- 239 5
- 277 5
- 314 5
- 335 5
- 346 5
- 16 4
- 178 4
- 203 4
- 204 4
- 219 4
- 308 4
- 327 4
- 330 4
- 337 4
- 5 3
- 26 3
- 35 3
- 60 3
- 67 3
- 104 3
- 110 3
- 134 3
- 152 3
- 196 3
- 199 3
- 207 3
- 245 3
- 264 3
- 273 3
- 275 3
- 289 3
- 315 3
- 317 3
- 336 3
- 21 2
- 22 2
- 33 2
- 45 2
- 62 2
- 78 2
- 91 2
- 132 2
- 179 2
- 191 2
- 197 2
- 211 2
- 213 2
- 222 2
- 225 2
- 226 2
- 228 2
- 265 2
- 290 2
- 291 2
- 298 2
- 299 2
- 311 2
- 320 2
- 325 2
- 25 1
- 28 1
- 29 1
- 30 1
- 65 1
- 66 1
- 74 1
- 76 1
- 82 1
- 86 1
- 112 1
- 123 1
- 131 1
- 143 1
- 149 1
- 151 1
- 155 1
- 162 1
- 165 1
- 170 1
- 171 1
- 182 1
- 183 1
- 192 1
- 194 1
- 209 1
- 229 1
- 230 1
- 233 1
- 235 1
- 238 1
- 240 1
- 241 1
- 254 1
- 256 1
- 259 1
- 260 1
- 268 1
- 272 1
- 279 1
- 283 1
- 319 1
- 329 1
- 332 1
- 334 1
- 339 1
- 341 1
- 344 1
county 1
- Elmore · 1,567 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499600 | 2499600 | 2022-05-13 | Elmore | Alabama | 1051 | 23420 | 347 |
2500152 | 2500152 | 2022-05-13 | Elmore | Idaho | 16039 | 7264 | 70 |
2496342 | 2496342 | 2022-05-12 | Elmore | Alabama | 1051 | 23419 | 347 |
2496894 | 2496894 | 2022-05-12 | Elmore | Idaho | 16039 | 7257 | 70 |
2493084 | 2493084 | 2022-05-11 | Elmore | Alabama | 1051 | 23410 | 347 |
2493636 | 2493636 | 2022-05-11 | Elmore | Idaho | 16039 | 7257 | 70 |
2489826 | 2489826 | 2022-05-10 | Elmore | Alabama | 1051 | 23408 | 347 |
2490378 | 2490378 | 2022-05-10 | Elmore | Idaho | 16039 | 7252 | 70 |
2486569 | 2486569 | 2022-05-09 | Elmore | Alabama | 1051 | 23403 | 347 |
2487121 | 2487121 | 2022-05-09 | Elmore | Idaho | 16039 | 7252 | 70 |
2483311 | 2483311 | 2022-05-08 | Elmore | Alabama | 1051 | 23392 | 347 |
2483863 | 2483863 | 2022-05-08 | Elmore | Idaho | 16039 | 7247 | 70 |
2480053 | 2480053 | 2022-05-07 | Elmore | Alabama | 1051 | 23392 | 347 |
2480605 | 2480605 | 2022-05-07 | Elmore | Idaho | 16039 | 7247 | 70 |
2476795 | 2476795 | 2022-05-06 | Elmore | Alabama | 1051 | 23392 | 347 |
2477347 | 2477347 | 2022-05-06 | Elmore | Idaho | 16039 | 7247 | 70 |
2473537 | 2473537 | 2022-05-05 | Elmore | Alabama | 1051 | 23389 | 347 |
2474089 | 2474089 | 2022-05-05 | Elmore | Idaho | 16039 | 7232 | 70 |
2470280 | 2470280 | 2022-05-04 | Elmore | Alabama | 1051 | 23386 | 347 |
2470832 | 2470832 | 2022-05-04 | Elmore | Idaho | 16039 | 7232 | 70 |
2467024 | 2467024 | 2022-05-03 | Elmore | Alabama | 1051 | 23381 | 347 |
2467576 | 2467576 | 2022-05-03 | Elmore | Idaho | 16039 | 7225 | 70 |
2463769 | 2463769 | 2022-05-02 | Elmore | Alabama | 1051 | 23376 | 347 |
2464321 | 2464321 | 2022-05-02 | Elmore | Idaho | 16039 | 7225 | 70 |
2460513 | 2460513 | 2022-05-01 | Elmore | Alabama | 1051 | 23366 | 347 |
2461065 | 2461065 | 2022-05-01 | Elmore | Idaho | 16039 | 7220 | 70 |
2457257 | 2457257 | 2022-04-30 | Elmore | Alabama | 1051 | 23366 | 347 |
2457809 | 2457809 | 2022-04-30 | Elmore | Idaho | 16039 | 7220 | 70 |
2454001 | 2454001 | 2022-04-29 | Elmore | Alabama | 1051 | 23366 | 347 |
2454553 | 2454553 | 2022-04-29 | Elmore | Idaho | 16039 | 7220 | 70 |
2450745 | 2450745 | 2022-04-28 | Elmore | Alabama | 1051 | 23363 | 347 |
2451297 | 2451297 | 2022-04-28 | Elmore | Idaho | 16039 | 7215 | 70 |
2447489 | 2447489 | 2022-04-27 | Elmore | Alabama | 1051 | 23360 | 347 |
2448041 | 2448041 | 2022-04-27 | Elmore | Idaho | 16039 | 7215 | 70 |
2444233 | 2444233 | 2022-04-26 | Elmore | Alabama | 1051 | 23356 | 347 |
2444785 | 2444785 | 2022-04-26 | Elmore | Idaho | 16039 | 7211 | 70 |
2440977 | 2440977 | 2022-04-25 | Elmore | Alabama | 1051 | 23352 | 347 |
2441529 | 2441529 | 2022-04-25 | Elmore | Idaho | 16039 | 7211 | 70 |
2437721 | 2437721 | 2022-04-24 | Elmore | Alabama | 1051 | 23297 | 347 |
2438273 | 2438273 | 2022-04-24 | Elmore | Idaho | 16039 | 7211 | 70 |
2434465 | 2434465 | 2022-04-23 | Elmore | Alabama | 1051 | 23297 | 347 |
2435017 | 2435017 | 2022-04-23 | Elmore | Idaho | 16039 | 7211 | 70 |
2431209 | 2431209 | 2022-04-22 | Elmore | Alabama | 1051 | 23297 | 347 |
2431761 | 2431761 | 2022-04-22 | Elmore | Idaho | 16039 | 7211 | 70 |
2427953 | 2427953 | 2022-04-21 | Elmore | Alabama | 1051 | 23293 | 347 |
2428505 | 2428505 | 2022-04-21 | Elmore | Idaho | 16039 | 7206 | 70 |
2424697 | 2424697 | 2022-04-20 | Elmore | Alabama | 1051 | 23289 | 347 |
2425249 | 2425249 | 2022-04-20 | Elmore | Idaho | 16039 | 7206 | 70 |
2421441 | 2421441 | 2022-04-19 | Elmore | Alabama | 1051 | 23289 | 346 |
2421993 | 2421993 | 2022-04-19 | Elmore | Idaho | 16039 | 7204 | 70 |
2418185 | 2418185 | 2022-04-18 | Elmore | Alabama | 1051 | 23283 | 346 |
2418737 | 2418737 | 2022-04-18 | Elmore | Idaho | 16039 | 7204 | 70 |
2414929 | 2414929 | 2022-04-17 | Elmore | Alabama | 1051 | 23283 | 346 |
2415481 | 2415481 | 2022-04-17 | Elmore | Idaho | 16039 | 7198 | 70 |
2411673 | 2411673 | 2022-04-16 | Elmore | Alabama | 1051 | 23283 | 346 |
2412225 | 2412225 | 2022-04-16 | Elmore | Idaho | 16039 | 7198 | 70 |
2408417 | 2408417 | 2022-04-15 | Elmore | Alabama | 1051 | 23283 | 346 |
2408969 | 2408969 | 2022-04-15 | Elmore | Idaho | 16039 | 7198 | 70 |
2405161 | 2405161 | 2022-04-14 | Elmore | Alabama | 1051 | 23279 | 344 |
2405713 | 2405713 | 2022-04-14 | Elmore | Idaho | 16039 | 7198 | 70 |
2401906 | 2401906 | 2022-04-13 | Elmore | Alabama | 1051 | 23275 | 343 |
2402458 | 2402458 | 2022-04-13 | Elmore | Idaho | 16039 | 7194 | 70 |
2398651 | 2398651 | 2022-04-12 | Elmore | Alabama | 1051 | 23263 | 343 |
2399203 | 2399203 | 2022-04-12 | Elmore | Idaho | 16039 | 7193 | 70 |
2395396 | 2395396 | 2022-04-11 | Elmore | Alabama | 1051 | 23240 | 343 |
2395948 | 2395948 | 2022-04-11 | Elmore | Idaho | 16039 | 7191 | 70 |
2392140 | 2392140 | 2022-04-10 | Elmore | Alabama | 1051 | 23220 | 343 |
2392692 | 2392692 | 2022-04-10 | Elmore | Idaho | 16039 | 7189 | 70 |
2388884 | 2388884 | 2022-04-09 | Elmore | Alabama | 1051 | 23220 | 343 |
2389436 | 2389436 | 2022-04-09 | Elmore | Idaho | 16039 | 7189 | 70 |
2385629 | 2385629 | 2022-04-08 | Elmore | Alabama | 1051 | 23220 | 343 |
2386181 | 2386181 | 2022-04-08 | Elmore | Idaho | 16039 | 7189 | 70 |
2382374 | 2382374 | 2022-04-07 | Elmore | Alabama | 1051 | 23217 | 343 |
2382926 | 2382926 | 2022-04-07 | Elmore | Idaho | 16039 | 7187 | 70 |
2379119 | 2379119 | 2022-04-06 | Elmore | Alabama | 1051 | 23194 | 343 |
2379671 | 2379671 | 2022-04-06 | Elmore | Idaho | 16039 | 7187 | 70 |
2375865 | 2375865 | 2022-04-05 | Elmore | Alabama | 1051 | 23164 | 343 |
2376417 | 2376417 | 2022-04-05 | Elmore | Idaho | 16039 | 7187 | 70 |
2372613 | 2372613 | 2022-04-04 | Elmore | Alabama | 1051 | 23151 | 343 |
2373165 | 2373165 | 2022-04-04 | Elmore | Idaho | 16039 | 7185 | 70 |
2369360 | 2369360 | 2022-04-03 | Elmore | Alabama | 1051 | 23066 | 342 |
2369912 | 2369912 | 2022-04-03 | Elmore | Idaho | 16039 | 7184 | 70 |
2366107 | 2366107 | 2022-04-02 | Elmore | Alabama | 1051 | 23066 | 342 |
2366659 | 2366659 | 2022-04-02 | Elmore | Idaho | 16039 | 7184 | 70 |
2362854 | 2362854 | 2022-04-01 | Elmore | Alabama | 1051 | 23066 | 342 |
2363406 | 2363406 | 2022-04-01 | Elmore | Idaho | 16039 | 7184 | 70 |
2359600 | 2359600 | 2022-03-31 | Elmore | Alabama | 1051 | 23039 | 342 |
2360152 | 2360152 | 2022-03-31 | Elmore | Idaho | 16039 | 7182 | 70 |
2356346 | 2356346 | 2022-03-30 | Elmore | Alabama | 1051 | 22975 | 342 |
2356898 | 2356898 | 2022-03-30 | Elmore | Idaho | 16039 | 7180 | 70 |
2353093 | 2353093 | 2022-03-29 | Elmore | Alabama | 1051 | 22974 | 342 |
2353645 | 2353645 | 2022-03-29 | Elmore | Idaho | 16039 | 7178 | 70 |
2349841 | 2349841 | 2022-03-28 | Elmore | Alabama | 1051 | 22971 | 341 |
2350393 | 2350393 | 2022-03-28 | Elmore | Idaho | 16039 | 7173 | 70 |
2346588 | 2346588 | 2022-03-27 | Elmore | Alabama | 1051 | 22968 | 340 |
2347140 | 2347140 | 2022-03-27 | Elmore | Idaho | 16039 | 7172 | 70 |
2343335 | 2343335 | 2022-03-26 | Elmore | Alabama | 1051 | 22968 | 340 |
2343887 | 2343887 | 2022-03-26 | Elmore | Idaho | 16039 | 7172 | 70 |
2340082 | 2340082 | 2022-03-25 | Elmore | Alabama | 1051 | 22968 | 340 |
2340634 | 2340634 | 2022-03-25 | Elmore | Idaho | 16039 | 7172 | 70 |
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);