ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
322 rows where deaths = 13 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Washington 42
- Conecuh 27
- Winston 25
- Randolph 23
- Cherokee 20
- Clay 14
- Etowah 14
- Sumter 13
- Chilton 12
- Choctaw 11
- Fayette 10
- Macon 8
- Autauga 7
- Bibb 6
- Blount 6
- Marion 6
- Pike 6
- Colbert 5
- Dallas 5
- Escambia 5
- Pickens 5
- Shelby 5
- Calhoun 4
- Covington 4
- Butler 3
- Elmore 3
- Greene 3
- Marengo 3
- Marshall 3
- Talladega 3
- …
state 1
- Alabama · 322 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923701 | 923701 | 2021-01-13 | Coosa | Alabama | 1037 | 594 | 13 |
920471 | 920471 | 2021-01-12 | Henry | Alabama | 1067 | 1458 | 13 |
780901 | 780901 | 2020-11-30 | Choctaw | Alabama | 1023 | 427 | 13 |
777655 | 777655 | 2020-11-29 | Choctaw | Alabama | 1023 | 426 | 13 |
774410 | 774410 | 2020-11-28 | Choctaw | Alabama | 1023 | 422 | 13 |
771165 | 771165 | 2020-11-27 | Choctaw | Alabama | 1023 | 421 | 13 |
767919 | 767919 | 2020-11-26 | Choctaw | Alabama | 1023 | 421 | 13 |
764674 | 764674 | 2020-11-25 | Choctaw | Alabama | 1023 | 419 | 13 |
761429 | 761429 | 2020-11-24 | Choctaw | Alabama | 1023 | 418 | 13 |
758184 | 758184 | 2020-11-23 | Choctaw | Alabama | 1023 | 417 | 13 |
754937 | 754937 | 2020-11-22 | Choctaw | Alabama | 1023 | 417 | 13 |
751691 | 751691 | 2020-11-21 | Choctaw | Alabama | 1023 | 416 | 13 |
748445 | 748445 | 2020-11-20 | Choctaw | Alabama | 1023 | 413 | 13 |
735463 | 735463 | 2020-11-16 | Clay | Alabama | 1027 | 850 | 13 |
732217 | 732217 | 2020-11-15 | Clay | Alabama | 1027 | 850 | 13 |
728972 | 728972 | 2020-11-14 | Clay | Alabama | 1027 | 845 | 13 |
725729 | 725729 | 2020-11-13 | Clay | Alabama | 1027 | 833 | 13 |
722486 | 722486 | 2020-11-12 | Clay | Alabama | 1027 | 825 | 13 |
719243 | 719243 | 2020-11-11 | Clay | Alabama | 1027 | 826 | 13 |
716000 | 716000 | 2020-11-10 | Clay | Alabama | 1027 | 819 | 13 |
716004 | 716004 | 2020-11-10 | Conecuh | Alabama | 1035 | 616 | 13 |
712756 | 712756 | 2020-11-09 | Clay | Alabama | 1027 | 817 | 13 |
712760 | 712760 | 2020-11-09 | Conecuh | Alabama | 1035 | 607 | 13 |
709512 | 709512 | 2020-11-08 | Clay | Alabama | 1027 | 816 | 13 |
709516 | 709516 | 2020-11-08 | Conecuh | Alabama | 1035 | 605 | 13 |
706268 | 706268 | 2020-11-07 | Clay | Alabama | 1027 | 812 | 13 |
706272 | 706272 | 2020-11-07 | Conecuh | Alabama | 1035 | 604 | 13 |
703025 | 703025 | 2020-11-06 | Clay | Alabama | 1027 | 806 | 13 |
703029 | 703029 | 2020-11-06 | Conecuh | Alabama | 1035 | 596 | 13 |
703078 | 703078 | 2020-11-06 | Winston | Alabama | 1133 | 1019 | 13 |
699782 | 699782 | 2020-11-05 | Clay | Alabama | 1027 | 799 | 13 |
699786 | 699786 | 2020-11-05 | Conecuh | Alabama | 1035 | 592 | 13 |
699835 | 699835 | 2020-11-05 | Winston | Alabama | 1133 | 1010 | 13 |
696538 | 696538 | 2020-11-04 | Clay | Alabama | 1027 | 793 | 13 |
696542 | 696542 | 2020-11-04 | Conecuh | Alabama | 1035 | 588 | 13 |
696591 | 696591 | 2020-11-04 | Winston | Alabama | 1133 | 1002 | 13 |
693296 | 693296 | 2020-11-03 | Clay | Alabama | 1027 | 785 | 13 |
693300 | 693300 | 2020-11-03 | Conecuh | Alabama | 1035 | 584 | 13 |
693349 | 693349 | 2020-11-03 | Winston | Alabama | 1133 | 988 | 13 |
690057 | 690057 | 2020-11-02 | Conecuh | Alabama | 1035 | 578 | 13 |
690106 | 690106 | 2020-11-02 | Winston | Alabama | 1133 | 985 | 13 |
686812 | 686812 | 2020-11-01 | Conecuh | Alabama | 1035 | 577 | 13 |
686861 | 686861 | 2020-11-01 | Winston | Alabama | 1133 | 981 | 13 |
683568 | 683568 | 2020-10-31 | Conecuh | Alabama | 1035 | 577 | 13 |
683617 | 683617 | 2020-10-31 | Winston | Alabama | 1133 | 964 | 13 |
680325 | 680325 | 2020-10-30 | Conecuh | Alabama | 1035 | 573 | 13 |
680336 | 680336 | 2020-10-30 | Fayette | Alabama | 1057 | 604 | 13 |
680374 | 680374 | 2020-10-30 | Winston | Alabama | 1133 | 953 | 13 |
677082 | 677082 | 2020-10-29 | Conecuh | Alabama | 1035 | 572 | 13 |
677093 | 677093 | 2020-10-29 | Fayette | Alabama | 1057 | 599 | 13 |
677131 | 677131 | 2020-10-29 | Winston | Alabama | 1133 | 947 | 13 |
673839 | 673839 | 2020-10-28 | Conecuh | Alabama | 1035 | 565 | 13 |
673850 | 673850 | 2020-10-28 | Fayette | Alabama | 1057 | 594 | 13 |
673888 | 673888 | 2020-10-28 | Winston | Alabama | 1133 | 943 | 13 |
670597 | 670597 | 2020-10-27 | Conecuh | Alabama | 1035 | 565 | 13 |
670608 | 670608 | 2020-10-27 | Fayette | Alabama | 1057 | 589 | 13 |
670646 | 670646 | 2020-10-27 | Winston | Alabama | 1133 | 940 | 13 |
667354 | 667354 | 2020-10-26 | Conecuh | Alabama | 1035 | 561 | 13 |
667365 | 667365 | 2020-10-26 | Fayette | Alabama | 1057 | 584 | 13 |
667391 | 667391 | 2020-10-26 | Pike | Alabama | 1109 | 1344 | 13 |
667403 | 667403 | 2020-10-26 | Winston | Alabama | 1133 | 937 | 13 |
664109 | 664109 | 2020-10-25 | Conecuh | Alabama | 1035 | 561 | 13 |
664120 | 664120 | 2020-10-25 | Fayette | Alabama | 1057 | 577 | 13 |
664146 | 664146 | 2020-10-25 | Pike | Alabama | 1109 | 1341 | 13 |
664158 | 664158 | 2020-10-25 | Winston | Alabama | 1133 | 929 | 13 |
660865 | 660865 | 2020-10-24 | Conecuh | Alabama | 1035 | 561 | 13 |
660876 | 660876 | 2020-10-24 | Fayette | Alabama | 1057 | 574 | 13 |
660902 | 660902 | 2020-10-24 | Pike | Alabama | 1109 | 1335 | 13 |
660914 | 660914 | 2020-10-24 | Winston | Alabama | 1133 | 922 | 13 |
657621 | 657621 | 2020-10-23 | Conecuh | Alabama | 1035 | 560 | 13 |
657632 | 657632 | 2020-10-23 | Fayette | Alabama | 1057 | 569 | 13 |
657658 | 657658 | 2020-10-23 | Pike | Alabama | 1109 | 1327 | 13 |
657670 | 657670 | 2020-10-23 | Winston | Alabama | 1133 | 919 | 13 |
654376 | 654376 | 2020-10-22 | Conecuh | Alabama | 1035 | 557 | 13 |
654387 | 654387 | 2020-10-22 | Fayette | Alabama | 1057 | 561 | 13 |
654413 | 654413 | 2020-10-22 | Pike | Alabama | 1109 | 1323 | 13 |
654425 | 654425 | 2020-10-22 | Winston | Alabama | 1133 | 913 | 13 |
651131 | 651131 | 2020-10-21 | Conecuh | Alabama | 1035 | 556 | 13 |
651142 | 651142 | 2020-10-21 | Fayette | Alabama | 1057 | 557 | 13 |
651168 | 651168 | 2020-10-21 | Pike | Alabama | 1109 | 1313 | 13 |
651180 | 651180 | 2020-10-21 | Winston | Alabama | 1133 | 906 | 13 |
647887 | 647887 | 2020-10-20 | Conecuh | Alabama | 1035 | 557 | 13 |
647936 | 647936 | 2020-10-20 | Winston | Alabama | 1133 | 904 | 13 |
644628 | 644628 | 2020-10-19 | Bibb | Alabama | 1007 | 789 | 13 |
644642 | 644642 | 2020-10-19 | Conecuh | Alabama | 1035 | 554 | 13 |
644691 | 644691 | 2020-10-19 | Winston | Alabama | 1133 | 899 | 13 |
641380 | 641380 | 2020-10-18 | Bibb | Alabama | 1007 | 785 | 13 |
641394 | 641394 | 2020-10-18 | Conecuh | Alabama | 1035 | 554 | 13 |
641443 | 641443 | 2020-10-18 | Winston | Alabama | 1133 | 886 | 13 |
638133 | 638133 | 2020-10-17 | Bibb | Alabama | 1007 | 775 | 13 |
638147 | 638147 | 2020-10-17 | Conecuh | Alabama | 1035 | 554 | 13 |
638196 | 638196 | 2020-10-17 | Winston | Alabama | 1133 | 882 | 13 |
634888 | 634888 | 2020-10-16 | Bibb | Alabama | 1007 | 771 | 13 |
634902 | 634902 | 2020-10-16 | Conecuh | Alabama | 1035 | 550 | 13 |
634951 | 634951 | 2020-10-16 | Winston | Alabama | 1133 | 870 | 13 |
631643 | 631643 | 2020-10-15 | Bibb | Alabama | 1007 | 761 | 13 |
631657 | 631657 | 2020-10-15 | Conecuh | Alabama | 1035 | 550 | 13 |
631675 | 631675 | 2020-10-15 | Jackson | Alabama | 1071 | 1901 | 13 |
631706 | 631706 | 2020-10-15 | Winston | Alabama | 1133 | 865 | 13 |
628399 | 628399 | 2020-10-14 | Bibb | Alabama | 1007 | 744 | 13 |
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);