ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
537 rows where deaths = 5 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Fayette 31
- DeKalb 30
- Houston 25
- Colbert 24
- Clay 23
- Coffee 23
- Henry 23
- Calhoun 21
- Cleburne 21
- Pike 19
- Greene 18
- Perry 18
- Lawrence 17
- Talladega 16
- Lamar 15
- Washington 14
- Barbour 12
- Jackson 11
- Morgan 11
- Blount 10
- Madison 10
- Marion 10
- Shelby 10
- Autauga 9
- Clarke 9
- Monroe 8
- Cherokee 7
- Macon 7
- Montgomery 7
- Wilcox 7
- …
state 1
- Alabama · 537 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
836080 | 836080 | 2020-12-17 | Coosa | Alabama | 1037 | 445 | 5 |
806905 | 806905 | 2020-12-08 | Russell | Alabama | 1113 | 2383 | 5 |
680345 | 680345 | 2020-10-30 | Lamar | Alabama | 1075 | 525 | 5 |
677102 | 677102 | 2020-10-29 | Lamar | Alabama | 1075 | 523 | 5 |
673859 | 673859 | 2020-10-28 | Lamar | Alabama | 1075 | 516 | 5 |
670617 | 670617 | 2020-10-27 | Lamar | Alabama | 1075 | 508 | 5 |
667374 | 667374 | 2020-10-26 | Lamar | Alabama | 1075 | 506 | 5 |
664129 | 664129 | 2020-10-25 | Lamar | Alabama | 1075 | 496 | 5 |
660885 | 660885 | 2020-10-24 | Lamar | Alabama | 1075 | 490 | 5 |
657641 | 657641 | 2020-10-23 | Lamar | Alabama | 1075 | 474 | 5 |
654396 | 654396 | 2020-10-22 | Lamar | Alabama | 1075 | 466 | 5 |
651151 | 651151 | 2020-10-21 | Lamar | Alabama | 1075 | 459 | 5 |
647907 | 647907 | 2020-10-20 | Lamar | Alabama | 1075 | 456 | 5 |
644662 | 644662 | 2020-10-19 | Lamar | Alabama | 1075 | 457 | 5 |
641414 | 641414 | 2020-10-18 | Lamar | Alabama | 1075 | 455 | 5 |
638167 | 638167 | 2020-10-17 | Lamar | Alabama | 1075 | 446 | 5 |
634922 | 634922 | 2020-10-16 | Lamar | Alabama | 1075 | 441 | 5 |
628429 | 628429 | 2020-10-14 | Henry | Alabama | 1067 | 611 | 5 |
625186 | 625186 | 2020-10-13 | Henry | Alabama | 1067 | 605 | 5 |
621943 | 621943 | 2020-10-12 | Henry | Alabama | 1067 | 602 | 5 |
618700 | 618700 | 2020-10-11 | Henry | Alabama | 1067 | 597 | 5 |
615458 | 615458 | 2020-10-10 | Henry | Alabama | 1067 | 593 | 5 |
612217 | 612217 | 2020-10-09 | Henry | Alabama | 1067 | 589 | 5 |
608975 | 608975 | 2020-10-08 | Henry | Alabama | 1067 | 579 | 5 |
605714 | 605714 | 2020-10-07 | Coffee | Alabama | 1031 | 1486 | 5 |
605732 | 605732 | 2020-10-07 | Henry | Alabama | 1067 | 574 | 5 |
602472 | 602472 | 2020-10-06 | Coffee | Alabama | 1031 | 1482 | 5 |
602490 | 602490 | 2020-10-06 | Henry | Alabama | 1067 | 570 | 5 |
599229 | 599229 | 2020-10-05 | Coffee | Alabama | 1031 | 1472 | 5 |
599247 | 599247 | 2020-10-05 | Henry | Alabama | 1067 | 570 | 5 |
595986 | 595986 | 2020-10-04 | Coffee | Alabama | 1031 | 1462 | 5 |
596004 | 596004 | 2020-10-04 | Henry | Alabama | 1067 | 566 | 5 |
592744 | 592744 | 2020-10-03 | Coffee | Alabama | 1031 | 1452 | 5 |
592762 | 592762 | 2020-10-03 | Henry | Alabama | 1067 | 557 | 5 |
589503 | 589503 | 2020-10-02 | Cleburne | Alabama | 1029 | 420 | 5 |
589504 | 589504 | 2020-10-02 | Coffee | Alabama | 1031 | 1404 | 5 |
589522 | 589522 | 2020-10-02 | Henry | Alabama | 1067 | 523 | 5 |
586262 | 586262 | 2020-10-01 | Cleburne | Alabama | 1029 | 414 | 5 |
586263 | 586263 | 2020-10-01 | Coffee | Alabama | 1031 | 1394 | 5 |
586281 | 586281 | 2020-10-01 | Henry | Alabama | 1067 | 518 | 5 |
583022 | 583022 | 2020-09-30 | Cleburne | Alabama | 1029 | 408 | 5 |
583038 | 583038 | 2020-09-30 | Geneva | Alabama | 1061 | 650 | 5 |
583041 | 583041 | 2020-09-30 | Henry | Alabama | 1067 | 514 | 5 |
579783 | 579783 | 2020-09-29 | Cleburne | Alabama | 1029 | 394 | 5 |
579802 | 579802 | 2020-09-29 | Henry | Alabama | 1067 | 510 | 5 |
576542 | 576542 | 2020-09-28 | Cleburne | Alabama | 1029 | 389 | 5 |
576561 | 576561 | 2020-09-28 | Henry | Alabama | 1067 | 508 | 5 |
573298 | 573298 | 2020-09-27 | Cleburne | Alabama | 1029 | 382 | 5 |
573317 | 573317 | 2020-09-27 | Henry | Alabama | 1067 | 507 | 5 |
570056 | 570056 | 2020-09-26 | Cleburne | Alabama | 1029 | 380 | 5 |
570075 | 570075 | 2020-09-26 | Henry | Alabama | 1067 | 505 | 5 |
566834 | 566834 | 2020-09-25 | Henry | Alabama | 1067 | 493 | 5 |
563590 | 563590 | 2020-09-24 | Geneva | Alabama | 1061 | 599 | 5 |
563593 | 563593 | 2020-09-24 | Henry | Alabama | 1067 | 486 | 5 |
560354 | 560354 | 2020-09-23 | Henry | Alabama | 1067 | 483 | 5 |
557118 | 557118 | 2020-09-22 | Henry | Alabama | 1067 | 480 | 5 |
531241 | 531241 | 2020-09-14 | Perry | Alabama | 1105 | 538 | 5 |
528004 | 528004 | 2020-09-13 | Perry | Alabama | 1105 | 536 | 5 |
524768 | 524768 | 2020-09-12 | Perry | Alabama | 1105 | 534 | 5 |
521494 | 521494 | 2020-09-11 | Cleburne | Alabama | 1029 | 271 | 5 |
521532 | 521532 | 2020-09-11 | Perry | Alabama | 1105 | 531 | 5 |
518257 | 518257 | 2020-09-10 | Cleburne | Alabama | 1029 | 259 | 5 |
518295 | 518295 | 2020-09-10 | Perry | Alabama | 1105 | 530 | 5 |
515022 | 515022 | 2020-09-09 | Cleburne | Alabama | 1029 | 255 | 5 |
515060 | 515060 | 2020-09-09 | Perry | Alabama | 1105 | 528 | 5 |
511789 | 511789 | 2020-09-08 | Cleburne | Alabama | 1029 | 250 | 5 |
511814 | 511814 | 2020-09-08 | Lawrence | Alabama | 1079 | 524 | 5 |
511827 | 511827 | 2020-09-08 | Perry | Alabama | 1105 | 527 | 5 |
508556 | 508556 | 2020-09-07 | Cleburne | Alabama | 1029 | 250 | 5 |
508581 | 508581 | 2020-09-07 | Lawrence | Alabama | 1079 | 523 | 5 |
508594 | 508594 | 2020-09-07 | Perry | Alabama | 1105 | 527 | 5 |
505324 | 505324 | 2020-09-06 | Cleburne | Alabama | 1029 | 244 | 5 |
505349 | 505349 | 2020-09-06 | Lawrence | Alabama | 1079 | 520 | 5 |
505362 | 505362 | 2020-09-06 | Perry | Alabama | 1105 | 527 | 5 |
502090 | 502090 | 2020-09-05 | Cleburne | Alabama | 1029 | 242 | 5 |
502115 | 502115 | 2020-09-05 | Lawrence | Alabama | 1079 | 518 | 5 |
502128 | 502128 | 2020-09-05 | Perry | Alabama | 1105 | 524 | 5 |
498856 | 498856 | 2020-09-04 | Cleburne | Alabama | 1029 | 238 | 5 |
498881 | 498881 | 2020-09-04 | Lawrence | Alabama | 1079 | 505 | 5 |
498894 | 498894 | 2020-09-04 | Perry | Alabama | 1105 | 523 | 5 |
495623 | 495623 | 2020-09-03 | Cleburne | Alabama | 1029 | 230 | 5 |
495648 | 495648 | 2020-09-03 | Lawrence | Alabama | 1079 | 503 | 5 |
495661 | 495661 | 2020-09-03 | Perry | Alabama | 1105 | 523 | 5 |
492389 | 492389 | 2020-09-02 | Cleburne | Alabama | 1029 | 213 | 5 |
492414 | 492414 | 2020-09-02 | Lawrence | Alabama | 1079 | 483 | 5 |
492427 | 492427 | 2020-09-02 | Perry | Alabama | 1105 | 521 | 5 |
489156 | 489156 | 2020-09-01 | Cleburne | Alabama | 1029 | 211 | 5 |
489181 | 489181 | 2020-09-01 | Lawrence | Alabama | 1079 | 480 | 5 |
489194 | 489194 | 2020-09-01 | Perry | Alabama | 1105 | 519 | 5 |
485923 | 485923 | 2020-08-31 | Cleburne | Alabama | 1029 | 206 | 5 |
485948 | 485948 | 2020-08-31 | Lawrence | Alabama | 1079 | 476 | 5 |
485961 | 485961 | 2020-08-31 | Perry | Alabama | 1105 | 517 | 5 |
482688 | 482688 | 2020-08-30 | Cleburne | Alabama | 1029 | 204 | 5 |
482713 | 482713 | 2020-08-30 | Lawrence | Alabama | 1079 | 472 | 5 |
482726 | 482726 | 2020-08-30 | Perry | Alabama | 1105 | 516 | 5 |
479454 | 479454 | 2020-08-29 | Cleburne | Alabama | 1029 | 204 | 5 |
479479 | 479479 | 2020-08-29 | Lawrence | Alabama | 1079 | 455 | 5 |
479492 | 479492 | 2020-08-29 | Perry | Alabama | 1105 | 516 | 5 |
476246 | 476246 | 2020-08-28 | Lawrence | Alabama | 1079 | 448 | 5 |
476259 | 476259 | 2020-08-28 | Perry | Alabama | 1105 | 517 | 5 |
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);