ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1075 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917230 | 917230 | 2021-01-11 | Lamar | Alabama | 1075 | 1146 | 16 |
913985 | 913985 | 2021-01-10 | Lamar | Alabama | 1075 | 1137 | 16 |
910740 | 910740 | 2021-01-09 | Lamar | Alabama | 1075 | 1132 | 16 |
907495 | 907495 | 2021-01-08 | Lamar | Alabama | 1075 | 1124 | 16 |
904249 | 904249 | 2021-01-07 | Lamar | Alabama | 1075 | 1114 | 16 |
901004 | 901004 | 2021-01-06 | Lamar | Alabama | 1075 | 1098 | 16 |
897759 | 897759 | 2021-01-05 | Lamar | Alabama | 1075 | 1083 | 15 |
894513 | 894513 | 2021-01-04 | Lamar | Alabama | 1075 | 1077 | 15 |
891267 | 891267 | 2021-01-03 | Lamar | Alabama | 1075 | 1074 | 15 |
888020 | 888020 | 2021-01-02 | Lamar | Alabama | 1075 | 1069 | 15 |
884775 | 884775 | 2021-01-01 | Lamar | Alabama | 1075 | 1065 | 15 |
881530 | 881530 | 2020-12-31 | Lamar | Alabama | 1075 | 1056 | 15 |
878285 | 878285 | 2020-12-30 | Lamar | Alabama | 1075 | 1037 | 15 |
875040 | 875040 | 2020-12-29 | Lamar | Alabama | 1075 | 1025 | 15 |
871795 | 871795 | 2020-12-28 | Lamar | Alabama | 1075 | 1017 | 15 |
868550 | 868550 | 2020-12-27 | Lamar | Alabama | 1075 | 1012 | 15 |
865305 | 865305 | 2020-12-26 | Lamar | Alabama | 1075 | 1009 | 15 |
862060 | 862060 | 2020-12-25 | Lamar | Alabama | 1075 | 1007 | 15 |
858815 | 858815 | 2020-12-24 | Lamar | Alabama | 1075 | 997 | 15 |
855570 | 855570 | 2020-12-23 | Lamar | Alabama | 1075 | 986 | 15 |
852325 | 852325 | 2020-12-22 | Lamar | Alabama | 1075 | 979 | 12 |
849080 | 849080 | 2020-12-21 | Lamar | Alabama | 1075 | 966 | 12 |
845835 | 845835 | 2020-12-20 | Lamar | Alabama | 1075 | 946 | 12 |
842589 | 842589 | 2020-12-19 | Lamar | Alabama | 1075 | 941 | 12 |
839344 | 839344 | 2020-12-18 | Lamar | Alabama | 1075 | 925 | 12 |
836099 | 836099 | 2020-12-17 | Lamar | Alabama | 1075 | 912 | 11 |
832853 | 832853 | 2020-12-16 | Lamar | Alabama | 1075 | 889 | 10 |
829606 | 829606 | 2020-12-15 | Lamar | Alabama | 1075 | 870 | 9 |
826360 | 826360 | 2020-12-14 | Lamar | Alabama | 1075 | 858 | 9 |
823113 | 823113 | 2020-12-13 | Lamar | Alabama | 1075 | 855 | 9 |
819867 | 819867 | 2020-12-12 | Lamar | Alabama | 1075 | 841 | 9 |
816621 | 816621 | 2020-12-11 | Lamar | Alabama | 1075 | 830 | 9 |
813375 | 813375 | 2020-12-10 | Lamar | Alabama | 1075 | 806 | 8 |
810131 | 810131 | 2020-12-09 | Lamar | Alabama | 1075 | 786 | 8 |
806886 | 806886 | 2020-12-08 | Lamar | Alabama | 1075 | 769 | 8 |
803641 | 803641 | 2020-12-07 | Lamar | Alabama | 1075 | 759 | 8 |
800396 | 800396 | 2020-12-06 | Lamar | Alabama | 1075 | 755 | 8 |
797151 | 797151 | 2020-12-05 | Lamar | Alabama | 1075 | 744 | 8 |
793906 | 793906 | 2020-12-04 | Lamar | Alabama | 1075 | 734 | 8 |
790661 | 790661 | 2020-12-03 | Lamar | Alabama | 1075 | 725 | 8 |
787416 | 787416 | 2020-12-02 | Lamar | Alabama | 1075 | 713 | 8 |
784172 | 784172 | 2020-12-01 | Lamar | Alabama | 1075 | 701 | 8 |
780927 | 780927 | 2020-11-30 | Lamar | Alabama | 1075 | 689 | 8 |
777681 | 777681 | 2020-11-29 | Lamar | Alabama | 1075 | 683 | 8 |
774436 | 774436 | 2020-11-28 | Lamar | Alabama | 1075 | 679 | 8 |
771191 | 771191 | 2020-11-27 | Lamar | Alabama | 1075 | 671 | 8 |
767945 | 767945 | 2020-11-26 | Lamar | Alabama | 1075 | 667 | 8 |
764700 | 764700 | 2020-11-25 | Lamar | Alabama | 1075 | 650 | 8 |
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 |
693320 | 693320 | 2020-11-03 | Lamar | Alabama | 1075 | 533 | 7 |
690077 | 690077 | 2020-11-02 | Lamar | Alabama | 1075 | 535 | 6 |
686832 | 686832 | 2020-11-01 | Lamar | Alabama | 1075 | 534 | 6 |
683588 | 683588 | 2020-10-31 | Lamar | Alabama | 1075 | 530 | 6 |
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 |
631677 | 631677 | 2020-10-15 | Lamar | Alabama | 1075 | 429 | 3 |
628433 | 628433 | 2020-10-14 | Lamar | Alabama | 1075 | 426 | 3 |
625190 | 625190 | 2020-10-13 | Lamar | Alabama | 1075 | 424 | 3 |
621947 | 621947 | 2020-10-12 | Lamar | Alabama | 1075 | 423 | 3 |
618704 | 618704 | 2020-10-11 | Lamar | Alabama | 1075 | 420 | 3 |
615462 | 615462 | 2020-10-10 | Lamar | Alabama | 1075 | 413 | 3 |
612221 | 612221 | 2020-10-09 | Lamar | Alabama | 1075 | 407 | 3 |
608979 | 608979 | 2020-10-08 | Lamar | Alabama | 1075 | 404 | 3 |
605736 | 605736 | 2020-10-07 | Lamar | Alabama | 1075 | 402 | 2 |
602494 | 602494 | 2020-10-06 | Lamar | Alabama | 1075 | 403 | 2 |
599251 | 599251 | 2020-10-05 | Lamar | Alabama | 1075 | 402 | 2 |
596008 | 596008 | 2020-10-04 | Lamar | Alabama | 1075 | 400 | 2 |
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);