ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Elmore" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 179 ✖
- 0 35
- 347 24
- 47 21
- 214 19
- 294 18
- 205 16
- 296 13
- 1 12
- 61 12
- 44 11
- 50 11
- 217 11
- 297 11
- 301 11
- 7 10
- 59 10
- 200 10
- 295 10
- 302 10
- 343 10
- 9 9
- 201 9
- 208 9
- 288 9
- 10 8
- 14 8
- 52 8
- 206 8
- 41 7
- 64 7
- 215 7
- 220 7
- 234 7
- 284 7
- 4 6
- 6 6
- 70 6
- 80 6
- 83 6
- 101 6
- 202 6
- 216 6
- 236 6
- 286 6
- 324 6
- 340 6
- 342 6
- 2 5
- 27 5
- 34 5
- 37 5
- 39 5
- 48 5
- 53 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
- 11 4
- 178 4
- 203 4
- 204 4
- 219 4
- 308 4
- 327 4
- 330 4
- 337 4
- 3 3
- 8 3
- 12 3
- 13 3
- 35 3
- 42 3
- 46 3
- 58 3
- 60 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
- 19 2
- 21 2
- 33 2
- 49 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
- 5 1
- 15 1
- 20 1
- 22 1
- 24 1
- 25 1
- 26 1
- 45 1
- 51 1
- 62 1
- 67 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
state 1
- Alabama · 792 ✖
fips 1
- 1051 792
county 1
- Elmore · 792 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499600 | 2499600 | 2022-05-13 | Elmore | Alabama | 1051 | 23420 | 347 |
2496342 | 2496342 | 2022-05-12 | Elmore | Alabama | 1051 | 23419 | 347 |
2493084 | 2493084 | 2022-05-11 | Elmore | Alabama | 1051 | 23410 | 347 |
2489826 | 2489826 | 2022-05-10 | Elmore | Alabama | 1051 | 23408 | 347 |
2486569 | 2486569 | 2022-05-09 | Elmore | Alabama | 1051 | 23403 | 347 |
2483311 | 2483311 | 2022-05-08 | Elmore | Alabama | 1051 | 23392 | 347 |
2480053 | 2480053 | 2022-05-07 | Elmore | Alabama | 1051 | 23392 | 347 |
2476795 | 2476795 | 2022-05-06 | Elmore | Alabama | 1051 | 23392 | 347 |
2473537 | 2473537 | 2022-05-05 | Elmore | Alabama | 1051 | 23389 | 347 |
2470280 | 2470280 | 2022-05-04 | Elmore | Alabama | 1051 | 23386 | 347 |
2467024 | 2467024 | 2022-05-03 | Elmore | Alabama | 1051 | 23381 | 347 |
2463769 | 2463769 | 2022-05-02 | Elmore | Alabama | 1051 | 23376 | 347 |
2460513 | 2460513 | 2022-05-01 | Elmore | Alabama | 1051 | 23366 | 347 |
2457257 | 2457257 | 2022-04-30 | Elmore | Alabama | 1051 | 23366 | 347 |
2454001 | 2454001 | 2022-04-29 | Elmore | Alabama | 1051 | 23366 | 347 |
2450745 | 2450745 | 2022-04-28 | Elmore | Alabama | 1051 | 23363 | 347 |
2447489 | 2447489 | 2022-04-27 | Elmore | Alabama | 1051 | 23360 | 347 |
2444233 | 2444233 | 2022-04-26 | Elmore | Alabama | 1051 | 23356 | 347 |
2440977 | 2440977 | 2022-04-25 | Elmore | Alabama | 1051 | 23352 | 347 |
2437721 | 2437721 | 2022-04-24 | Elmore | Alabama | 1051 | 23297 | 347 |
2434465 | 2434465 | 2022-04-23 | Elmore | Alabama | 1051 | 23297 | 347 |
2431209 | 2431209 | 2022-04-22 | Elmore | Alabama | 1051 | 23297 | 347 |
2427953 | 2427953 | 2022-04-21 | Elmore | Alabama | 1051 | 23293 | 347 |
2424697 | 2424697 | 2022-04-20 | Elmore | Alabama | 1051 | 23289 | 347 |
2421441 | 2421441 | 2022-04-19 | Elmore | Alabama | 1051 | 23289 | 346 |
2418185 | 2418185 | 2022-04-18 | Elmore | Alabama | 1051 | 23283 | 346 |
2414929 | 2414929 | 2022-04-17 | Elmore | Alabama | 1051 | 23283 | 346 |
2411673 | 2411673 | 2022-04-16 | Elmore | Alabama | 1051 | 23283 | 346 |
2408417 | 2408417 | 2022-04-15 | Elmore | Alabama | 1051 | 23283 | 346 |
2405161 | 2405161 | 2022-04-14 | Elmore | Alabama | 1051 | 23279 | 344 |
2401906 | 2401906 | 2022-04-13 | Elmore | Alabama | 1051 | 23275 | 343 |
2398651 | 2398651 | 2022-04-12 | Elmore | Alabama | 1051 | 23263 | 343 |
2395396 | 2395396 | 2022-04-11 | Elmore | Alabama | 1051 | 23240 | 343 |
2392140 | 2392140 | 2022-04-10 | Elmore | Alabama | 1051 | 23220 | 343 |
2388884 | 2388884 | 2022-04-09 | Elmore | Alabama | 1051 | 23220 | 343 |
2385629 | 2385629 | 2022-04-08 | Elmore | Alabama | 1051 | 23220 | 343 |
2382374 | 2382374 | 2022-04-07 | Elmore | Alabama | 1051 | 23217 | 343 |
2379119 | 2379119 | 2022-04-06 | Elmore | Alabama | 1051 | 23194 | 343 |
2375865 | 2375865 | 2022-04-05 | Elmore | Alabama | 1051 | 23164 | 343 |
2372613 | 2372613 | 2022-04-04 | Elmore | Alabama | 1051 | 23151 | 343 |
2369360 | 2369360 | 2022-04-03 | Elmore | Alabama | 1051 | 23066 | 342 |
2366107 | 2366107 | 2022-04-02 | Elmore | Alabama | 1051 | 23066 | 342 |
2362854 | 2362854 | 2022-04-01 | Elmore | Alabama | 1051 | 23066 | 342 |
2359600 | 2359600 | 2022-03-31 | Elmore | Alabama | 1051 | 23039 | 342 |
2356346 | 2356346 | 2022-03-30 | Elmore | Alabama | 1051 | 22975 | 342 |
2353093 | 2353093 | 2022-03-29 | Elmore | Alabama | 1051 | 22974 | 342 |
2349841 | 2349841 | 2022-03-28 | Elmore | Alabama | 1051 | 22971 | 341 |
2346588 | 2346588 | 2022-03-27 | Elmore | Alabama | 1051 | 22968 | 340 |
2343335 | 2343335 | 2022-03-26 | Elmore | Alabama | 1051 | 22968 | 340 |
2340082 | 2340082 | 2022-03-25 | Elmore | Alabama | 1051 | 22968 | 340 |
2336829 | 2336829 | 2022-03-24 | Elmore | Alabama | 1051 | 22963 | 340 |
2333575 | 2333575 | 2022-03-23 | Elmore | Alabama | 1051 | 22953 | 340 |
2330321 | 2330321 | 2022-03-22 | Elmore | Alabama | 1051 | 22951 | 340 |
2327069 | 2327069 | 2022-03-21 | Elmore | Alabama | 1051 | 22947 | 339 |
2323816 | 2323816 | 2022-03-20 | Elmore | Alabama | 1051 | 22939 | 337 |
2320562 | 2320562 | 2022-03-19 | Elmore | Alabama | 1051 | 22939 | 337 |
2317308 | 2317308 | 2022-03-18 | Elmore | Alabama | 1051 | 22939 | 337 |
2314055 | 2314055 | 2022-03-17 | Elmore | Alabama | 1051 | 22936 | 337 |
2310802 | 2310802 | 2022-03-16 | Elmore | Alabama | 1051 | 22934 | 335 |
2307549 | 2307549 | 2022-03-15 | Elmore | Alabama | 1051 | 22931 | 335 |
2304298 | 2304298 | 2022-03-14 | Elmore | Alabama | 1051 | 22930 | 335 |
2301046 | 2301046 | 2022-03-13 | Elmore | Alabama | 1051 | 22929 | 336 |
2297794 | 2297794 | 2022-03-12 | Elmore | Alabama | 1051 | 22929 | 336 |
2294542 | 2294542 | 2022-03-11 | Elmore | Alabama | 1051 | 22929 | 336 |
2291290 | 2291290 | 2022-03-10 | Elmore | Alabama | 1051 | 22926 | 335 |
2288038 | 2288038 | 2022-03-09 | Elmore | Alabama | 1051 | 22920 | 335 |
2284786 | 2284786 | 2022-03-08 | Elmore | Alabama | 1051 | 22912 | 334 |
2281534 | 2281534 | 2022-03-07 | Elmore | Alabama | 1051 | 22907 | 332 |
2278281 | 2278281 | 2022-03-06 | Elmore | Alabama | 1051 | 22898 | 330 |
2275028 | 2275028 | 2022-03-05 | Elmore | Alabama | 1051 | 22898 | 330 |
2271775 | 2271775 | 2022-03-04 | Elmore | Alabama | 1051 | 22898 | 330 |
2268523 | 2268523 | 2022-03-03 | Elmore | Alabama | 1051 | 22889 | 330 |
2265270 | 2265270 | 2022-03-02 | Elmore | Alabama | 1051 | 22881 | 329 |
2262020 | 2262020 | 2022-03-01 | Elmore | Alabama | 1051 | 22872 | 327 |
2258769 | 2258769 | 2022-02-28 | Elmore | Alabama | 1051 | 22862 | 327 |
2255518 | 2255518 | 2022-02-27 | Elmore | Alabama | 1051 | 22855 | 327 |
2252267 | 2252267 | 2022-02-26 | Elmore | Alabama | 1051 | 22848 | 327 |
2249016 | 2249016 | 2022-02-25 | Elmore | Alabama | 1051 | 22834 | 325 |
2245765 | 2245765 | 2022-02-24 | Elmore | Alabama | 1051 | 22824 | 325 |
2242514 | 2242514 | 2022-02-23 | Elmore | Alabama | 1051 | 22819 | 324 |
2239263 | 2239263 | 2022-02-22 | Elmore | Alabama | 1051 | 22804 | 324 |
2236012 | 2236012 | 2022-02-21 | Elmore | Alabama | 1051 | 22785 | 324 |
2232761 | 2232761 | 2022-02-20 | Elmore | Alabama | 1051 | 22777 | 324 |
2229510 | 2229510 | 2022-02-19 | Elmore | Alabama | 1051 | 22777 | 324 |
2226259 | 2226259 | 2022-02-18 | Elmore | Alabama | 1051 | 22760 | 324 |
2223008 | 2223008 | 2022-02-17 | Elmore | Alabama | 1051 | 22754 | 320 |
2219757 | 2219757 | 2022-02-16 | Elmore | Alabama | 1051 | 22736 | 320 |
2216507 | 2216507 | 2022-02-15 | Elmore | Alabama | 1051 | 22732 | 319 |
2213256 | 2213256 | 2022-02-14 | Elmore | Alabama | 1051 | 22713 | 317 |
2210003 | 2210003 | 2022-02-13 | Elmore | Alabama | 1051 | 22693 | 317 |
2206750 | 2206750 | 2022-02-12 | Elmore | Alabama | 1051 | 22688 | 317 |
2203497 | 2203497 | 2022-02-11 | Elmore | Alabama | 1051 | 22646 | 315 |
2200243 | 2200243 | 2022-02-10 | Elmore | Alabama | 1051 | 22625 | 315 |
2196989 | 2196989 | 2022-02-09 | Elmore | Alabama | 1051 | 22591 | 315 |
2193734 | 2193734 | 2022-02-08 | Elmore | Alabama | 1051 | 22547 | 314 |
2190481 | 2190481 | 2022-02-07 | Elmore | Alabama | 1051 | 22491 | 314 |
2187228 | 2187228 | 2022-02-06 | Elmore | Alabama | 1051 | 22450 | 314 |
2183975 | 2183975 | 2022-02-05 | Elmore | Alabama | 1051 | 22450 | 314 |
2180723 | 2180723 | 2022-02-04 | Elmore | Alabama | 1051 | 22428 | 314 |
2177472 | 2177472 | 2022-02-03 | Elmore | Alabama | 1051 | 22220 | 311 |
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);