ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 199 ✖
- 0 61
- 278 24
- 392 21
- 96 18
- 279 18
- 443 18
- 380 16
- 291 15
- 274 14
- 388 14
- 438 14
- 277 13
- 286 13
- 80 11
- 1 10
- 6 9
- 70 9
- 280 9
- 77 8
- 92 8
- 113 8
- 275 8
- 300 8
- 370 8
- 2 7
- 67 7
- 93 7
- 111 7
- 174 7
- 281 7
- 282 7
- 288 7
- 386 7
- 91 6
- 95 6
- 138 6
- 269 6
- 285 6
- 298 6
- 446 6
- 8 5
- 88 5
- 133 5
- 170 5
- 268 5
- 294 5
- 375 5
- 377 5
- 379 5
- 399 5
- 401 5
- 413 5
- 426 5
- 24 4
- 51 4
- 69 4
- 112 4
- 238 4
- 240 4
- 302 4
- 356 4
- 371 4
- 376 4
- 410 4
- 419 4
- 429 4
- 3 3
- 13 3
- 58 3
- 66 3
- 68 3
- 83 3
- 84 3
- 89 3
- 131 3
- 177 3
- 183 3
- 209 3
- 255 3
- 259 3
- 260 3
- 276 3
- 312 3
- 330 3
- 341 3
- 366 3
- 387 3
- 395 3
- 433 3
- 436 3
- 12 2
- 23 2
- 25 2
- 31 2
- 32 2
- 56 2
- 75 2
- 76 2
- 132 2
- 185 2
- 194 2
- 197 2
- 206 2
- 239 2
- 251 2
- 264 2
- 283 2
- 296 2
- 336 2
- 369 2
- 390 2
- 391 2
- 398 2
- 424 2
- 428 2
- 440 2
- 445 2
- 447 2
- 5 1
- 10 1
- 15 1
- 17 1
- 27 1
- 35 1
- 37 1
- 43 1
- 49 1
- 54 1
- 55 1
- 62 1
- 63 1
- 64 1
- 71 1
- 73 1
- 78 1
- 79 1
- 85 1
- 87 1
- 90 1
- 99 1
- 108 1
- 116 1
- 123 1
- 125 1
- 130 1
- 136 1
- 137 1
- 139 1
- 176 1
- 184 1
- 201 1
- 202 1
- 210 1
- 227 1
- 234 1
- 235 1
- 236 1
- 249 1
- 258 1
- 266 1
- 267 1
- 270 1
- 272 1
- 287 1
- 289 1
- 303 1
- 304 1
- 306 1
- 320 1
- 323 1
- 328 1
- 329 1
- 338 1
- 340 1
- 342 1
- 343 1
- 347 1
- 350 1
- 361 1
- 363 1
- 364 1
- 368 1
- 372 1
- 378 1
- 383 1
- 397 1
- 400 1
- 403 1
- 405 1
- 406 1
- 408 1
- 411 1
- 412 1
- 415 1
- 422 1
- 432 1
- 437 1
- 442 1
- 444 1
state 1
- Alabama 786
fips 1
- 1127 · 786 ✖
county 1
- Walker 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499638 | 2499638 | 2022-05-13 | Walker | Alabama | 1127 | 18767 | 447 |
2496380 | 2496380 | 2022-05-12 | Walker | Alabama | 1127 | 18763 | 447 |
2493122 | 2493122 | 2022-05-11 | Walker | Alabama | 1127 | 18758 | 446 |
2489864 | 2489864 | 2022-05-10 | Walker | Alabama | 1127 | 18751 | 446 |
2486607 | 2486607 | 2022-05-09 | Walker | Alabama | 1127 | 18749 | 446 |
2483349 | 2483349 | 2022-05-08 | Walker | Alabama | 1127 | 18748 | 446 |
2480091 | 2480091 | 2022-05-07 | Walker | Alabama | 1127 | 18748 | 446 |
2476833 | 2476833 | 2022-05-06 | Walker | Alabama | 1127 | 18748 | 446 |
2473575 | 2473575 | 2022-05-05 | Walker | Alabama | 1127 | 18745 | 445 |
2470318 | 2470318 | 2022-05-04 | Walker | Alabama | 1127 | 18743 | 445 |
2467062 | 2467062 | 2022-05-03 | Walker | Alabama | 1127 | 18741 | 444 |
2463807 | 2463807 | 2022-05-02 | Walker | Alabama | 1127 | 18737 | 443 |
2460551 | 2460551 | 2022-05-01 | Walker | Alabama | 1127 | 18736 | 443 |
2457295 | 2457295 | 2022-04-30 | Walker | Alabama | 1127 | 18736 | 443 |
2454039 | 2454039 | 2022-04-29 | Walker | Alabama | 1127 | 18736 | 443 |
2450783 | 2450783 | 2022-04-28 | Walker | Alabama | 1127 | 18734 | 443 |
2447527 | 2447527 | 2022-04-27 | Walker | Alabama | 1127 | 18733 | 443 |
2444271 | 2444271 | 2022-04-26 | Walker | Alabama | 1127 | 18732 | 443 |
2441015 | 2441015 | 2022-04-25 | Walker | Alabama | 1127 | 18732 | 443 |
2437759 | 2437759 | 2022-04-24 | Walker | Alabama | 1127 | 18729 | 443 |
2434503 | 2434503 | 2022-04-23 | Walker | Alabama | 1127 | 18729 | 443 |
2431247 | 2431247 | 2022-04-22 | Walker | Alabama | 1127 | 18729 | 443 |
2427991 | 2427991 | 2022-04-21 | Walker | Alabama | 1127 | 18727 | 443 |
2424735 | 2424735 | 2022-04-20 | Walker | Alabama | 1127 | 18727 | 443 |
2421479 | 2421479 | 2022-04-19 | Walker | Alabama | 1127 | 18726 | 443 |
2418223 | 2418223 | 2022-04-18 | Walker | Alabama | 1127 | 18658 | 443 |
2414967 | 2414967 | 2022-04-17 | Walker | Alabama | 1127 | 18658 | 443 |
2411711 | 2411711 | 2022-04-16 | Walker | Alabama | 1127 | 18658 | 443 |
2408455 | 2408455 | 2022-04-15 | Walker | Alabama | 1127 | 18658 | 443 |
2405199 | 2405199 | 2022-04-14 | Walker | Alabama | 1127 | 18657 | 442 |
2401944 | 2401944 | 2022-04-13 | Walker | Alabama | 1127 | 18656 | 440 |
2398689 | 2398689 | 2022-04-12 | Walker | Alabama | 1127 | 18656 | 440 |
2395434 | 2395434 | 2022-04-11 | Walker | Alabama | 1127 | 18654 | 438 |
2392178 | 2392178 | 2022-04-10 | Walker | Alabama | 1127 | 18652 | 438 |
2388922 | 2388922 | 2022-04-09 | Walker | Alabama | 1127 | 18652 | 438 |
2385667 | 2385667 | 2022-04-08 | Walker | Alabama | 1127 | 18652 | 438 |
2382412 | 2382412 | 2022-04-07 | Walker | Alabama | 1127 | 18652 | 438 |
2379157 | 2379157 | 2022-04-06 | Walker | Alabama | 1127 | 18635 | 438 |
2375903 | 2375903 | 2022-04-05 | Walker | Alabama | 1127 | 18633 | 438 |
2372651 | 2372651 | 2022-04-04 | Walker | Alabama | 1127 | 18621 | 438 |
2369398 | 2369398 | 2022-04-03 | Walker | Alabama | 1127 | 18598 | 438 |
2366145 | 2366145 | 2022-04-02 | Walker | Alabama | 1127 | 18598 | 438 |
2362892 | 2362892 | 2022-04-01 | Walker | Alabama | 1127 | 18598 | 438 |
2359638 | 2359638 | 2022-03-31 | Walker | Alabama | 1127 | 18592 | 438 |
2356384 | 2356384 | 2022-03-30 | Walker | Alabama | 1127 | 18572 | 438 |
2353131 | 2353131 | 2022-03-29 | Walker | Alabama | 1127 | 18564 | 438 |
2349879 | 2349879 | 2022-03-28 | Walker | Alabama | 1127 | 18538 | 437 |
2346626 | 2346626 | 2022-03-27 | Walker | Alabama | 1127 | 18536 | 436 |
2343373 | 2343373 | 2022-03-26 | Walker | Alabama | 1127 | 18536 | 436 |
2340120 | 2340120 | 2022-03-25 | Walker | Alabama | 1127 | 18536 | 436 |
2336867 | 2336867 | 2022-03-24 | Walker | Alabama | 1127 | 18533 | 433 |
2333613 | 2333613 | 2022-03-23 | Walker | Alabama | 1127 | 18532 | 433 |
2330359 | 2330359 | 2022-03-22 | Walker | Alabama | 1127 | 18531 | 433 |
2327107 | 2327107 | 2022-03-21 | Walker | Alabama | 1127 | 18529 | 432 |
2323854 | 2323854 | 2022-03-20 | Walker | Alabama | 1127 | 18525 | 429 |
2320600 | 2320600 | 2022-03-19 | Walker | Alabama | 1127 | 18525 | 429 |
2317346 | 2317346 | 2022-03-18 | Walker | Alabama | 1127 | 18525 | 429 |
2314093 | 2314093 | 2022-03-17 | Walker | Alabama | 1127 | 18524 | 429 |
2310840 | 2310840 | 2022-03-16 | Walker | Alabama | 1127 | 18521 | 428 |
2307587 | 2307587 | 2022-03-15 | Walker | Alabama | 1127 | 18521 | 428 |
2304336 | 2304336 | 2022-03-14 | Walker | Alabama | 1127 | 18519 | 426 |
2301084 | 2301084 | 2022-03-13 | Walker | Alabama | 1127 | 18515 | 426 |
2297832 | 2297832 | 2022-03-12 | Walker | Alabama | 1127 | 18515 | 426 |
2294580 | 2294580 | 2022-03-11 | Walker | Alabama | 1127 | 18515 | 426 |
2291328 | 2291328 | 2022-03-10 | Walker | Alabama | 1127 | 18514 | 426 |
2288076 | 2288076 | 2022-03-09 | Walker | Alabama | 1127 | 18508 | 424 |
2284824 | 2284824 | 2022-03-08 | Walker | Alabama | 1127 | 18507 | 424 |
2281572 | 2281572 | 2022-03-07 | Walker | Alabama | 1127 | 18506 | 422 |
2278319 | 2278319 | 2022-03-06 | Walker | Alabama | 1127 | 18484 | 419 |
2275066 | 2275066 | 2022-03-05 | Walker | Alabama | 1127 | 18484 | 419 |
2271813 | 2271813 | 2022-03-04 | Walker | Alabama | 1127 | 18484 | 419 |
2268561 | 2268561 | 2022-03-03 | Walker | Alabama | 1127 | 18480 | 419 |
2265308 | 2265308 | 2022-03-02 | Walker | Alabama | 1127 | 18471 | 415 |
2262058 | 2262058 | 2022-03-01 | Walker | Alabama | 1127 | 18469 | 413 |
2258807 | 2258807 | 2022-02-28 | Walker | Alabama | 1127 | 18457 | 413 |
2255556 | 2255556 | 2022-02-27 | Walker | Alabama | 1127 | 18454 | 413 |
2252305 | 2252305 | 2022-02-26 | Walker | Alabama | 1127 | 18448 | 413 |
2249054 | 2249054 | 2022-02-25 | Walker | Alabama | 1127 | 18434 | 413 |
2245803 | 2245803 | 2022-02-24 | Walker | Alabama | 1127 | 18420 | 412 |
2242552 | 2242552 | 2022-02-23 | Walker | Alabama | 1127 | 18407 | 411 |
2239301 | 2239301 | 2022-02-22 | Walker | Alabama | 1127 | 18395 | 410 |
2236050 | 2236050 | 2022-02-21 | Walker | Alabama | 1127 | 18374 | 410 |
2232799 | 2232799 | 2022-02-20 | Walker | Alabama | 1127 | 18365 | 410 |
2229548 | 2229548 | 2022-02-19 | Walker | Alabama | 1127 | 18361 | 410 |
2226297 | 2226297 | 2022-02-18 | Walker | Alabama | 1127 | 18347 | 408 |
2223046 | 2223046 | 2022-02-17 | Walker | Alabama | 1127 | 18321 | 406 |
2219795 | 2219795 | 2022-02-16 | Walker | Alabama | 1127 | 18292 | 405 |
2216545 | 2216545 | 2022-02-15 | Walker | Alabama | 1127 | 18255 | 403 |
2213294 | 2213294 | 2022-02-14 | Walker | Alabama | 1127 | 18202 | 401 |
2210041 | 2210041 | 2022-02-13 | Walker | Alabama | 1127 | 18182 | 401 |
2206788 | 2206788 | 2022-02-12 | Walker | Alabama | 1127 | 18135 | 401 |
2203535 | 2203535 | 2022-02-11 | Walker | Alabama | 1127 | 18101 | 401 |
2200281 | 2200281 | 2022-02-10 | Walker | Alabama | 1127 | 18064 | 401 |
2197027 | 2197027 | 2022-02-09 | Walker | Alabama | 1127 | 18014 | 400 |
2193772 | 2193772 | 2022-02-08 | Walker | Alabama | 1127 | 17974 | 399 |
2190519 | 2190519 | 2022-02-07 | Walker | Alabama | 1127 | 17865 | 399 |
2187266 | 2187266 | 2022-02-06 | Walker | Alabama | 1127 | 17819 | 399 |
2184013 | 2184013 | 2022-02-05 | Walker | Alabama | 1127 | 17819 | 399 |
2180761 | 2180761 | 2022-02-04 | Walker | Alabama | 1127 | 17800 | 399 |
2177510 | 2177510 | 2022-02-03 | Walker | Alabama | 1127 | 17677 | 398 |
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);