ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 1003 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917194 | 917194 | 2021-01-11 | Baldwin | Alabama | 1003 | 15417 | 173 |
913949 | 913949 | 2021-01-10 | Baldwin | Alabama | 1003 | 15327 | 173 |
910704 | 910704 | 2021-01-09 | Baldwin | Alabama | 1003 | 15202 | 173 |
907459 | 907459 | 2021-01-08 | Baldwin | Alabama | 1003 | 15052 | 171 |
904213 | 904213 | 2021-01-07 | Baldwin | Alabama | 1003 | 14845 | 171 |
900968 | 900968 | 2021-01-06 | Baldwin | Alabama | 1003 | 14656 | 171 |
897723 | 897723 | 2021-01-05 | Baldwin | Alabama | 1003 | 14440 | 169 |
894477 | 894477 | 2021-01-04 | Baldwin | Alabama | 1003 | 14187 | 169 |
891231 | 891231 | 2021-01-03 | Baldwin | Alabama | 1003 | 14064 | 169 |
887984 | 887984 | 2021-01-02 | Baldwin | Alabama | 1003 | 13955 | 169 |
884739 | 884739 | 2021-01-01 | Baldwin | Alabama | 1003 | 13823 | 169 |
881494 | 881494 | 2020-12-31 | Baldwin | Alabama | 1003 | 13601 | 161 |
878249 | 878249 | 2020-12-30 | Baldwin | Alabama | 1003 | 13392 | 160 |
875004 | 875004 | 2020-12-29 | Baldwin | Alabama | 1003 | 13172 | 156 |
871759 | 871759 | 2020-12-28 | Baldwin | Alabama | 1003 | 12962 | 152 |
868514 | 868514 | 2020-12-27 | Baldwin | Alabama | 1003 | 12825 | 152 |
865269 | 865269 | 2020-12-26 | Baldwin | Alabama | 1003 | 12708 | 151 |
862024 | 862024 | 2020-12-25 | Baldwin | Alabama | 1003 | 12666 | 151 |
858779 | 858779 | 2020-12-24 | Baldwin | Alabama | 1003 | 12521 | 151 |
855534 | 855534 | 2020-12-23 | Baldwin | Alabama | 1003 | 12321 | 151 |
852289 | 852289 | 2020-12-22 | Baldwin | Alabama | 1003 | 12155 | 149 |
849044 | 849044 | 2020-12-21 | Baldwin | Alabama | 1003 | 11952 | 147 |
845799 | 845799 | 2020-12-20 | Baldwin | Alabama | 1003 | 11827 | 147 |
842553 | 842553 | 2020-12-19 | Baldwin | Alabama | 1003 | 11722 | 147 |
839308 | 839308 | 2020-12-18 | Baldwin | Alabama | 1003 | 11556 | 146 |
836063 | 836063 | 2020-12-17 | Baldwin | Alabama | 1003 | 11364 | 145 |
832817 | 832817 | 2020-12-16 | Baldwin | Alabama | 1003 | 11212 | 145 |
829570 | 829570 | 2020-12-15 | Baldwin | Alabama | 1003 | 11061 | 141 |
826324 | 826324 | 2020-12-14 | Baldwin | Alabama | 1003 | 10898 | 141 |
823077 | 823077 | 2020-12-13 | Baldwin | Alabama | 1003 | 10806 | 141 |
819831 | 819831 | 2020-12-12 | Baldwin | Alabama | 1003 | 10665 | 141 |
816585 | 816585 | 2020-12-11 | Baldwin | Alabama | 1003 | 10489 | 141 |
813339 | 813339 | 2020-12-10 | Baldwin | Alabama | 1003 | 10288 | 141 |
810095 | 810095 | 2020-12-09 | Baldwin | Alabama | 1003 | 10087 | 141 |
806850 | 806850 | 2020-12-08 | Baldwin | Alabama | 1003 | 9974 | 141 |
803605 | 803605 | 2020-12-07 | Baldwin | Alabama | 1003 | 9821 | 138 |
800360 | 800360 | 2020-12-06 | Baldwin | Alabama | 1003 | 9728 | 138 |
797115 | 797115 | 2020-12-05 | Baldwin | Alabama | 1003 | 9626 | 138 |
793870 | 793870 | 2020-12-04 | Baldwin | Alabama | 1003 | 9501 | 138 |
790625 | 790625 | 2020-12-03 | Baldwin | Alabama | 1003 | 9341 | 137 |
787380 | 787380 | 2020-12-02 | Baldwin | Alabama | 1003 | 9163 | 137 |
784136 | 784136 | 2020-12-01 | Baldwin | Alabama | 1003 | 9051 | 137 |
780891 | 780891 | 2020-11-30 | Baldwin | Alabama | 1003 | 8890 | 98 |
777645 | 777645 | 2020-11-29 | Baldwin | Alabama | 1003 | 8820 | 98 |
774400 | 774400 | 2020-11-28 | Baldwin | Alabama | 1003 | 8733 | 98 |
771155 | 771155 | 2020-11-27 | Baldwin | Alabama | 1003 | 8603 | 98 |
767909 | 767909 | 2020-11-26 | Baldwin | Alabama | 1003 | 8576 | 98 |
764664 | 764664 | 2020-11-25 | Baldwin | Alabama | 1003 | 8473 | 98 |
761419 | 761419 | 2020-11-24 | Baldwin | Alabama | 1003 | 8376 | 84 |
758174 | 758174 | 2020-11-23 | Baldwin | Alabama | 1003 | 8269 | 84 |
754927 | 754927 | 2020-11-22 | Baldwin | Alabama | 1003 | 8199 | 84 |
751681 | 751681 | 2020-11-21 | Baldwin | Alabama | 1003 | 8131 | 84 |
748435 | 748435 | 2020-11-20 | Baldwin | Alabama | 1003 | 8038 | 84 |
745189 | 745189 | 2020-11-19 | Baldwin | Alabama | 1003 | 7933 | 84 |
741942 | 741942 | 2020-11-18 | Baldwin | Alabama | 1003 | 7849 | 84 |
738695 | 738695 | 2020-11-17 | Baldwin | Alabama | 1003 | 7772 | 84 |
735451 | 735451 | 2020-11-16 | Baldwin | Alabama | 1003 | 7696 | 84 |
732205 | 732205 | 2020-11-15 | Baldwin | Alabama | 1003 | 7646 | 84 |
728960 | 728960 | 2020-11-14 | Baldwin | Alabama | 1003 | 7596 | 84 |
725717 | 725717 | 2020-11-13 | Baldwin | Alabama | 1003 | 7523 | 84 |
722474 | 722474 | 2020-11-12 | Baldwin | Alabama | 1003 | 7454 | 84 |
719231 | 719231 | 2020-11-11 | Baldwin | Alabama | 1003 | 7409 | 84 |
715988 | 715988 | 2020-11-10 | Baldwin | Alabama | 1003 | 7348 | 84 |
712744 | 712744 | 2020-11-09 | Baldwin | Alabama | 1003 | 7263 | 83 |
709500 | 709500 | 2020-11-08 | Baldwin | Alabama | 1003 | 7226 | 83 |
706256 | 706256 | 2020-11-07 | Baldwin | Alabama | 1003 | 7188 | 83 |
703013 | 703013 | 2020-11-06 | Baldwin | Alabama | 1003 | 7134 | 83 |
699770 | 699770 | 2020-11-05 | Baldwin | Alabama | 1003 | 7097 | 77 |
696526 | 696526 | 2020-11-04 | Baldwin | Alabama | 1003 | 7061 | 77 |
693284 | 693284 | 2020-11-03 | Baldwin | Alabama | 1003 | 6995 | 74 |
690041 | 690041 | 2020-11-02 | Baldwin | Alabama | 1003 | 6985 | 71 |
686796 | 686796 | 2020-11-01 | Baldwin | Alabama | 1003 | 6966 | 71 |
683552 | 683552 | 2020-10-31 | Baldwin | Alabama | 1003 | 6940 | 71 |
680309 | 680309 | 2020-10-30 | Baldwin | Alabama | 1003 | 6888 | 71 |
677066 | 677066 | 2020-10-29 | Baldwin | Alabama | 1003 | 6768 | 69 |
673823 | 673823 | 2020-10-28 | Baldwin | Alabama | 1003 | 6743 | 69 |
670581 | 670581 | 2020-10-27 | Baldwin | Alabama | 1003 | 6712 | 69 |
667338 | 667338 | 2020-10-26 | Baldwin | Alabama | 1003 | 6694 | 69 |
664093 | 664093 | 2020-10-25 | Baldwin | Alabama | 1003 | 6658 | 69 |
660849 | 660849 | 2020-10-24 | Baldwin | Alabama | 1003 | 6637 | 69 |
657605 | 657605 | 2020-10-23 | Baldwin | Alabama | 1003 | 6615 | 69 |
654360 | 654360 | 2020-10-22 | Baldwin | Alabama | 1003 | 6475 | 69 |
651115 | 651115 | 2020-10-21 | Baldwin | Alabama | 1003 | 6443 | 69 |
647871 | 647871 | 2020-10-20 | Baldwin | Alabama | 1003 | 6405 | 69 |
644626 | 644626 | 2020-10-19 | Baldwin | Alabama | 1003 | 6375 | 67 |
641378 | 641378 | 2020-10-18 | Baldwin | Alabama | 1003 | 6369 | 67 |
638131 | 638131 | 2020-10-17 | Baldwin | Alabama | 1003 | 6350 | 67 |
634886 | 634886 | 2020-10-16 | Baldwin | Alabama | 1003 | 6333 | 67 |
631641 | 631641 | 2020-10-15 | Baldwin | Alabama | 1003 | 6285 | 66 |
628397 | 628397 | 2020-10-14 | Baldwin | Alabama | 1003 | 6270 | 66 |
625154 | 625154 | 2020-10-13 | Baldwin | Alabama | 1003 | 6248 | 65 |
621911 | 621911 | 2020-10-12 | Baldwin | Alabama | 1003 | 6220 | 65 |
618668 | 618668 | 2020-10-11 | Baldwin | Alabama | 1003 | 6203 | 65 |
615426 | 615426 | 2020-10-10 | Baldwin | Alabama | 1003 | 6190 | 65 |
612185 | 612185 | 2020-10-09 | Baldwin | Alabama | 1003 | 6172 | 64 |
608943 | 608943 | 2020-10-08 | Baldwin | Alabama | 1003 | 6141 | 64 |
605700 | 605700 | 2020-10-07 | Baldwin | Alabama | 1003 | 6134 | 56 |
602458 | 602458 | 2020-10-06 | Baldwin | Alabama | 1003 | 6116 | 55 |
599215 | 599215 | 2020-10-05 | Baldwin | Alabama | 1003 | 6085 | 53 |
595972 | 595972 | 2020-10-04 | Baldwin | Alabama | 1003 | 6073 | 53 |
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);