ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
353 rows where deaths = 14 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Bullock 44
- Pike 38
- Cleburne 23
- Conecuh 23
- Cherokee 20
- Limestone 18
- Houston 17
- Pickens 15
- Clarke 13
- Marion 10
- Greene 9
- Elmore 8
- Etowah 8
- Talladega 8
- Bibb 7
- Randolph 7
- Macon 6
- Washington 6
- Blount 5
- Coffee 5
- Franklin 5
- Lowndes 5
- Marengo 5
- DeKalb 4
- Jackson 4
- Fayette 3
- Hale 3
- Jefferson 3
- Sumter 3
- Winston 3
- …
state 1
- Alabama · 353 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930192 | 930192 | 2021-01-15 | Coosa | Alabama | 1037 | 604 | 14 |
926947 | 926947 | 2021-01-14 | Coosa | Alabama | 1037 | 598 | 14 |
816598 | 816598 | 2020-12-11 | Cleburne | Alabama | 1029 | 870 | 14 |
813352 | 813352 | 2020-12-10 | Cleburne | Alabama | 1029 | 858 | 14 |
810108 | 810108 | 2020-12-09 | Cleburne | Alabama | 1029 | 844 | 14 |
806863 | 806863 | 2020-12-08 | Cleburne | Alabama | 1029 | 837 | 14 |
803618 | 803618 | 2020-12-07 | Cleburne | Alabama | 1029 | 826 | 14 |
800373 | 800373 | 2020-12-06 | Cleburne | Alabama | 1029 | 821 | 14 |
797128 | 797128 | 2020-12-05 | Cleburne | Alabama | 1029 | 819 | 14 |
793883 | 793883 | 2020-12-04 | Cleburne | Alabama | 1029 | 809 | 14 |
790638 | 790638 | 2020-12-03 | Cleburne | Alabama | 1029 | 807 | 14 |
790641 | 790641 | 2020-12-03 | Conecuh | Alabama | 1035 | 729 | 14 |
790678 | 790678 | 2020-12-03 | Pike | Alabama | 1109 | 1638 | 14 |
787393 | 787393 | 2020-12-02 | Cleburne | Alabama | 1029 | 799 | 14 |
787396 | 787396 | 2020-12-02 | Conecuh | Alabama | 1035 | 724 | 14 |
787433 | 787433 | 2020-12-02 | Pike | Alabama | 1109 | 1622 | 14 |
784146 | 784146 | 2020-12-01 | Choctaw | Alabama | 1023 | 431 | 14 |
784149 | 784149 | 2020-12-01 | Cleburne | Alabama | 1029 | 788 | 14 |
784152 | 784152 | 2020-12-01 | Conecuh | Alabama | 1035 | 700 | 14 |
784189 | 784189 | 2020-12-01 | Pike | Alabama | 1109 | 1615 | 14 |
780904 | 780904 | 2020-11-30 | Cleburne | Alabama | 1029 | 778 | 14 |
780907 | 780907 | 2020-11-30 | Conecuh | Alabama | 1035 | 688 | 14 |
780944 | 780944 | 2020-11-30 | Pike | Alabama | 1109 | 1599 | 14 |
777658 | 777658 | 2020-11-29 | Cleburne | Alabama | 1029 | 774 | 14 |
777661 | 777661 | 2020-11-29 | Conecuh | Alabama | 1035 | 685 | 14 |
777698 | 777698 | 2020-11-29 | Pike | Alabama | 1109 | 1592 | 14 |
774413 | 774413 | 2020-11-28 | Cleburne | Alabama | 1029 | 772 | 14 |
774416 | 774416 | 2020-11-28 | Conecuh | Alabama | 1035 | 684 | 14 |
774453 | 774453 | 2020-11-28 | Pike | Alabama | 1109 | 1586 | 14 |
771168 | 771168 | 2020-11-27 | Cleburne | Alabama | 1029 | 771 | 14 |
771171 | 771171 | 2020-11-27 | Conecuh | Alabama | 1035 | 684 | 14 |
771208 | 771208 | 2020-11-27 | Pike | Alabama | 1109 | 1583 | 14 |
767922 | 767922 | 2020-11-26 | Cleburne | Alabama | 1029 | 769 | 14 |
767925 | 767925 | 2020-11-26 | Conecuh | Alabama | 1035 | 683 | 14 |
767962 | 767962 | 2020-11-26 | Pike | Alabama | 1109 | 1581 | 14 |
764677 | 764677 | 2020-11-25 | Cleburne | Alabama | 1029 | 757 | 14 |
764680 | 764680 | 2020-11-25 | Conecuh | Alabama | 1035 | 683 | 14 |
764717 | 764717 | 2020-11-25 | Pike | Alabama | 1109 | 1575 | 14 |
761432 | 761432 | 2020-11-24 | Cleburne | Alabama | 1029 | 756 | 14 |
761435 | 761435 | 2020-11-24 | Conecuh | Alabama | 1035 | 682 | 14 |
761472 | 761472 | 2020-11-24 | Pike | Alabama | 1109 | 1560 | 14 |
758187 | 758187 | 2020-11-23 | Cleburne | Alabama | 1029 | 744 | 14 |
758190 | 758190 | 2020-11-23 | Conecuh | Alabama | 1035 | 668 | 14 |
758227 | 758227 | 2020-11-23 | Pike | Alabama | 1109 | 1555 | 14 |
754940 | 754940 | 2020-11-22 | Cleburne | Alabama | 1029 | 742 | 14 |
754943 | 754943 | 2020-11-22 | Conecuh | Alabama | 1035 | 668 | 14 |
754980 | 754980 | 2020-11-22 | Pike | Alabama | 1109 | 1547 | 14 |
751694 | 751694 | 2020-11-21 | Cleburne | Alabama | 1029 | 740 | 14 |
751697 | 751697 | 2020-11-21 | Conecuh | Alabama | 1035 | 668 | 14 |
751734 | 751734 | 2020-11-21 | Pike | Alabama | 1109 | 1531 | 14 |
748448 | 748448 | 2020-11-20 | Cleburne | Alabama | 1029 | 705 | 14 |
748451 | 748451 | 2020-11-20 | Conecuh | Alabama | 1035 | 667 | 14 |
748488 | 748488 | 2020-11-20 | Pike | Alabama | 1109 | 1529 | 14 |
745202 | 745202 | 2020-11-19 | Cleburne | Alabama | 1029 | 696 | 14 |
745205 | 745205 | 2020-11-19 | Conecuh | Alabama | 1035 | 666 | 14 |
745242 | 745242 | 2020-11-19 | Pike | Alabama | 1109 | 1520 | 14 |
741956 | 741956 | 2020-11-18 | Coffee | Alabama | 1031 | 2223 | 14 |
741958 | 741958 | 2020-11-18 | Conecuh | Alabama | 1035 | 655 | 14 |
741995 | 741995 | 2020-11-18 | Pike | Alabama | 1109 | 1515 | 14 |
738709 | 738709 | 2020-11-17 | Coffee | Alabama | 1031 | 2195 | 14 |
738711 | 738711 | 2020-11-17 | Conecuh | Alabama | 1035 | 647 | 14 |
738748 | 738748 | 2020-11-17 | Pike | Alabama | 1109 | 1511 | 14 |
735465 | 735465 | 2020-11-16 | Coffee | Alabama | 1031 | 2180 | 14 |
735467 | 735467 | 2020-11-16 | Conecuh | Alabama | 1035 | 647 | 14 |
735504 | 735504 | 2020-11-16 | Pike | Alabama | 1109 | 1502 | 14 |
732219 | 732219 | 2020-11-15 | Coffee | Alabama | 1031 | 2170 | 14 |
732221 | 732221 | 2020-11-15 | Conecuh | Alabama | 1035 | 645 | 14 |
732258 | 732258 | 2020-11-15 | Pike | Alabama | 1109 | 1494 | 14 |
728974 | 728974 | 2020-11-14 | Coffee | Alabama | 1031 | 2155 | 14 |
728976 | 728976 | 2020-11-14 | Conecuh | Alabama | 1035 | 639 | 14 |
729013 | 729013 | 2020-11-14 | Pike | Alabama | 1109 | 1492 | 14 |
725733 | 725733 | 2020-11-13 | Conecuh | Alabama | 1035 | 637 | 14 |
725770 | 725770 | 2020-11-13 | Pike | Alabama | 1109 | 1482 | 14 |
722490 | 722490 | 2020-11-12 | Conecuh | Alabama | 1035 | 627 | 14 |
722527 | 722527 | 2020-11-12 | Pike | Alabama | 1109 | 1461 | 14 |
719247 | 719247 | 2020-11-11 | Conecuh | Alabama | 1035 | 624 | 14 |
719284 | 719284 | 2020-11-11 | Pike | Alabama | 1109 | 1452 | 14 |
716041 | 716041 | 2020-11-10 | Pike | Alabama | 1109 | 1437 | 14 |
712797 | 712797 | 2020-11-09 | Pike | Alabama | 1109 | 1431 | 14 |
712809 | 712809 | 2020-11-09 | Winston | Alabama | 1133 | 1043 | 14 |
709553 | 709553 | 2020-11-08 | Pike | Alabama | 1109 | 1429 | 14 |
709565 | 709565 | 2020-11-08 | Winston | Alabama | 1133 | 1039 | 14 |
706309 | 706309 | 2020-11-07 | Pike | Alabama | 1109 | 1425 | 14 |
706321 | 706321 | 2020-11-07 | Winston | Alabama | 1133 | 1026 | 14 |
703066 | 703066 | 2020-11-06 | Pike | Alabama | 1109 | 1419 | 14 |
699823 | 699823 | 2020-11-05 | Pike | Alabama | 1109 | 1410 | 14 |
696579 | 696579 | 2020-11-04 | Pike | Alabama | 1109 | 1406 | 14 |
693337 | 693337 | 2020-11-03 | Pike | Alabama | 1109 | 1399 | 14 |
690068 | 690068 | 2020-11-02 | Fayette | Alabama | 1057 | 610 | 14 |
690094 | 690094 | 2020-11-02 | Pike | Alabama | 1109 | 1393 | 14 |
686823 | 686823 | 2020-11-01 | Fayette | Alabama | 1057 | 608 | 14 |
686849 | 686849 | 2020-11-01 | Pike | Alabama | 1109 | 1385 | 14 |
683579 | 683579 | 2020-10-31 | Fayette | Alabama | 1057 | 608 | 14 |
683605 | 683605 | 2020-10-31 | Pike | Alabama | 1109 | 1379 | 14 |
680362 | 680362 | 2020-10-30 | Pike | Alabama | 1109 | 1370 | 14 |
677074 | 677074 | 2020-10-29 | Cherokee | Alabama | 1019 | 764 | 14 |
677119 | 677119 | 2020-10-29 | Pike | Alabama | 1109 | 1364 | 14 |
673831 | 673831 | 2020-10-28 | Cherokee | Alabama | 1019 | 761 | 14 |
673876 | 673876 | 2020-10-28 | Pike | Alabama | 1109 | 1355 | 14 |
670589 | 670589 | 2020-10-27 | Cherokee | Alabama | 1019 | 756 | 14 |
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);