ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
466 rows where deaths = 7 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923739 | 923739 | 2021-01-13 | Russell | Alabama | 1113 | 3149 | 7 |
920494 | 920494 | 2021-01-12 | Russell | Alabama | 1113 | 3105 | 7 |
917249 | 917249 | 2021-01-11 | Russell | Alabama | 1113 | 3075 | 7 |
914004 | 914004 | 2021-01-10 | Russell | Alabama | 1113 | 3067 | 7 |
910759 | 910759 | 2021-01-09 | Russell | Alabama | 1113 | 3052 | 7 |
907476 | 907476 | 2021-01-08 | Coosa | Alabama | 1037 | 571 | 7 |
907514 | 907514 | 2021-01-08 | Russell | Alabama | 1113 | 3013 | 7 |
904230 | 904230 | 2021-01-07 | Coosa | Alabama | 1037 | 563 | 7 |
904268 | 904268 | 2021-01-07 | Russell | Alabama | 1113 | 2979 | 7 |
900985 | 900985 | 2021-01-06 | Coosa | Alabama | 1037 | 556 | 7 |
901023 | 901023 | 2021-01-06 | Russell | Alabama | 1113 | 2942 | 7 |
897740 | 897740 | 2021-01-05 | Coosa | Alabama | 1037 | 545 | 7 |
894494 | 894494 | 2021-01-04 | Coosa | Alabama | 1037 | 528 | 7 |
891248 | 891248 | 2021-01-03 | Coosa | Alabama | 1037 | 525 | 7 |
888001 | 888001 | 2021-01-02 | Coosa | Alabama | 1037 | 523 | 7 |
884756 | 884756 | 2021-01-01 | Coosa | Alabama | 1037 | 519 | 7 |
881511 | 881511 | 2020-12-31 | Coosa | Alabama | 1037 | 517 | 7 |
878266 | 878266 | 2020-12-30 | Coosa | Alabama | 1037 | 501 | 7 |
875021 | 875021 | 2020-12-29 | Coosa | Alabama | 1037 | 493 | 7 |
871776 | 871776 | 2020-12-28 | Coosa | Alabama | 1037 | 480 | 7 |
868531 | 868531 | 2020-12-27 | Coosa | Alabama | 1037 | 478 | 7 |
865286 | 865286 | 2020-12-26 | Coosa | Alabama | 1037 | 477 | 7 |
862041 | 862041 | 2020-12-25 | Coosa | Alabama | 1037 | 477 | 7 |
858796 | 858796 | 2020-12-24 | Coosa | Alabama | 1037 | 475 | 7 |
813371 | 813371 | 2020-12-10 | Henry | Alabama | 1067 | 956 | 7 |
810127 | 810127 | 2020-12-09 | Henry | Alabama | 1067 | 948 | 7 |
806882 | 806882 | 2020-12-08 | Henry | Alabama | 1067 | 937 | 7 |
806901 | 806901 | 2020-12-08 | Perry | Alabama | 1105 | 714 | 7 |
803637 | 803637 | 2020-12-07 | Henry | Alabama | 1067 | 928 | 7 |
803656 | 803656 | 2020-12-07 | Perry | Alabama | 1105 | 708 | 7 |
800392 | 800392 | 2020-12-06 | Henry | Alabama | 1067 | 925 | 7 |
800411 | 800411 | 2020-12-06 | Perry | Alabama | 1105 | 707 | 7 |
797147 | 797147 | 2020-12-05 | Henry | Alabama | 1067 | 921 | 7 |
797166 | 797166 | 2020-12-05 | Perry | Alabama | 1105 | 706 | 7 |
793902 | 793902 | 2020-12-04 | Henry | Alabama | 1067 | 909 | 7 |
793921 | 793921 | 2020-12-04 | Perry | Alabama | 1105 | 703 | 7 |
790676 | 790676 | 2020-12-03 | Perry | Alabama | 1105 | 698 | 7 |
787431 | 787431 | 2020-12-02 | Perry | Alabama | 1105 | 692 | 7 |
761455 | 761455 | 2020-11-24 | Lamar | Alabama | 1075 | 633 | 7 |
758210 | 758210 | 2020-11-23 | Lamar | Alabama | 1075 | 626 | 7 |
754963 | 754963 | 2020-11-22 | Lamar | Alabama | 1075 | 622 | 7 |
751717 | 751717 | 2020-11-21 | Lamar | Alabama | 1075 | 609 | 7 |
748471 | 748471 | 2020-11-20 | Lamar | Alabama | 1075 | 601 | 7 |
745225 | 745225 | 2020-11-19 | Lamar | Alabama | 1075 | 600 | 7 |
741978 | 741978 | 2020-11-18 | Lamar | Alabama | 1075 | 596 | 7 |
738731 | 738731 | 2020-11-17 | Lamar | Alabama | 1075 | 588 | 7 |
735487 | 735487 | 2020-11-16 | Lamar | Alabama | 1075 | 584 | 7 |
732241 | 732241 | 2020-11-15 | Lamar | Alabama | 1075 | 584 | 7 |
728996 | 728996 | 2020-11-14 | Lamar | Alabama | 1075 | 581 | 7 |
725753 | 725753 | 2020-11-13 | Lamar | Alabama | 1075 | 579 | 7 |
722510 | 722510 | 2020-11-12 | Lamar | Alabama | 1075 | 576 | 7 |
719267 | 719267 | 2020-11-11 | Lamar | Alabama | 1075 | 570 | 7 |
716024 | 716024 | 2020-11-10 | Lamar | Alabama | 1075 | 565 | 7 |
712780 | 712780 | 2020-11-09 | Lamar | Alabama | 1075 | 559 | 7 |
709536 | 709536 | 2020-11-08 | Lamar | Alabama | 1075 | 554 | 7 |
706292 | 706292 | 2020-11-07 | Lamar | Alabama | 1075 | 553 | 7 |
703049 | 703049 | 2020-11-06 | Lamar | Alabama | 1075 | 544 | 7 |
699806 | 699806 | 2020-11-05 | Lamar | Alabama | 1075 | 541 | 7 |
696562 | 696562 | 2020-11-04 | Lamar | Alabama | 1075 | 540 | 7 |
693313 | 693313 | 2020-11-03 | Geneva | Alabama | 1061 | 985 | 7 |
693320 | 693320 | 2020-11-03 | Lamar | Alabama | 1075 | 533 | 7 |
690070 | 690070 | 2020-11-02 | Geneva | Alabama | 1061 | 984 | 7 |
686825 | 686825 | 2020-11-01 | Geneva | Alabama | 1061 | 975 | 7 |
683581 | 683581 | 2020-10-31 | Geneva | Alabama | 1061 | 971 | 7 |
680338 | 680338 | 2020-10-30 | Geneva | Alabama | 1061 | 959 | 7 |
677095 | 677095 | 2020-10-29 | Geneva | Alabama | 1061 | 942 | 7 |
673852 | 673852 | 2020-10-28 | Geneva | Alabama | 1061 | 935 | 7 |
670610 | 670610 | 2020-10-27 | Geneva | Alabama | 1061 | 921 | 7 |
667367 | 667367 | 2020-10-26 | Geneva | Alabama | 1061 | 916 | 7 |
664122 | 664122 | 2020-10-25 | Geneva | Alabama | 1061 | 906 | 7 |
660878 | 660878 | 2020-10-24 | Geneva | Alabama | 1061 | 900 | 7 |
657634 | 657634 | 2020-10-23 | Geneva | Alabama | 1061 | 861 | 7 |
654389 | 654389 | 2020-10-22 | Geneva | Alabama | 1061 | 852 | 7 |
651128 | 651128 | 2020-10-21 | Cleburne | Alabama | 1029 | 532 | 7 |
651144 | 651144 | 2020-10-21 | Geneva | Alabama | 1061 | 844 | 7 |
647884 | 647884 | 2020-10-20 | Cleburne | Alabama | 1029 | 528 | 7 |
647900 | 647900 | 2020-10-20 | Geneva | Alabama | 1061 | 841 | 7 |
644639 | 644639 | 2020-10-19 | Cleburne | Alabama | 1029 | 524 | 7 |
644655 | 644655 | 2020-10-19 | Geneva | Alabama | 1061 | 833 | 7 |
641391 | 641391 | 2020-10-18 | Cleburne | Alabama | 1029 | 520 | 7 |
641407 | 641407 | 2020-10-18 | Geneva | Alabama | 1061 | 829 | 7 |
638144 | 638144 | 2020-10-17 | Cleburne | Alabama | 1029 | 515 | 7 |
638160 | 638160 | 2020-10-17 | Geneva | Alabama | 1061 | 823 | 7 |
634899 | 634899 | 2020-10-16 | Cleburne | Alabama | 1029 | 504 | 7 |
634915 | 634915 | 2020-10-16 | Geneva | Alabama | 1061 | 814 | 7 |
631670 | 631670 | 2020-10-15 | Geneva | Alabama | 1061 | 810 | 7 |
628411 | 628411 | 2020-10-14 | Coffee | Alabama | 1031 | 1568 | 7 |
628426 | 628426 | 2020-10-14 | Geneva | Alabama | 1061 | 806 | 7 |
612199 | 612199 | 2020-10-09 | Coffee | Alabama | 1031 | 1513 | 7 |
605701 | 605701 | 2020-10-07 | Barbour | Alabama | 1005 | 927 | 7 |
602459 | 602459 | 2020-10-06 | Barbour | Alabama | 1005 | 923 | 7 |
599216 | 599216 | 2020-10-05 | Barbour | Alabama | 1005 | 921 | 7 |
595973 | 595973 | 2020-10-04 | Barbour | Alabama | 1005 | 921 | 7 |
592731 | 592731 | 2020-10-03 | Barbour | Alabama | 1005 | 921 | 7 |
589491 | 589491 | 2020-10-02 | Barbour | Alabama | 1005 | 902 | 7 |
586250 | 586250 | 2020-10-01 | Barbour | Alabama | 1005 | 898 | 7 |
583010 | 583010 | 2020-09-30 | Barbour | Alabama | 1005 | 896 | 7 |
579771 | 579771 | 2020-09-29 | Barbour | Alabama | 1005 | 886 | 7 |
576530 | 576530 | 2020-09-28 | Barbour | Alabama | 1005 | 886 | 7 |
573286 | 573286 | 2020-09-27 | Barbour | Alabama | 1005 | 885 | 7 |
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);