ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Jefferson" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050295 | 1050295 | 2021-02-21 | Jefferson | Alabama | 1073 | 70177 | 1334 |
1047048 | 1047048 | 2021-02-20 | Jefferson | Alabama | 1073 | 70078 | 1334 |
1043803 | 1043803 | 2021-02-19 | Jefferson | Alabama | 1073 | 69995 | 1333 |
1040558 | 1040558 | 2021-02-18 | Jefferson | Alabama | 1073 | 69890 | 1319 |
1037313 | 1037313 | 2021-02-17 | Jefferson | Alabama | 1073 | 69808 | 1308 |
1034068 | 1034068 | 2021-02-16 | Jefferson | Alabama | 1073 | 69747 | 1308 |
1030822 | 1030822 | 2021-02-15 | Jefferson | Alabama | 1073 | 69599 | 1298 |
1027575 | 1027575 | 2021-02-14 | Jefferson | Alabama | 1073 | 69514 | 1298 |
1024330 | 1024330 | 2021-02-13 | Jefferson | Alabama | 1073 | 69364 | 1298 |
1021085 | 1021085 | 2021-02-12 | Jefferson | Alabama | 1073 | 69253 | 1278 |
1017840 | 1017840 | 2021-02-11 | Jefferson | Alabama | 1073 | 69117 | 1265 |
1014595 | 1014595 | 2021-02-10 | Jefferson | Alabama | 1073 | 68930 | 1245 |
1011350 | 1011350 | 2021-02-09 | Jefferson | Alabama | 1073 | 68747 | 1234 |
1008104 | 1008104 | 2021-02-08 | Jefferson | Alabama | 1073 | 68577 | 1236 |
1004858 | 1004858 | 2021-02-07 | Jefferson | Alabama | 1073 | 68456 | 1236 |
1001612 | 1001612 | 2021-02-06 | Jefferson | Alabama | 1073 | 68322 | 1236 |
998366 | 998366 | 2021-02-05 | Jefferson | Alabama | 1073 | 68090 | 1225 |
995120 | 995120 | 2021-02-04 | Jefferson | Alabama | 1073 | 67906 | 1210 |
991874 | 991874 | 2021-02-03 | Jefferson | Alabama | 1073 | 67639 | 1195 |
988628 | 988628 | 2021-02-02 | Jefferson | Alabama | 1073 | 67359 | 1164 |
985381 | 985381 | 2021-02-01 | Jefferson | Alabama | 1073 | 67010 | 1128 |
982134 | 982134 | 2021-01-31 | Jefferson | Alabama | 1073 | 66884 | 1128 |
978888 | 978888 | 2021-01-30 | Jefferson | Alabama | 1073 | 66323 | 1112 |
975643 | 975643 | 2021-01-29 | Jefferson | Alabama | 1073 | 66323 | 1112 |
972398 | 972398 | 2021-01-28 | Jefferson | Alabama | 1073 | 65992 | 1101 |
969153 | 969153 | 2021-01-27 | Jefferson | Alabama | 1073 | 65606 | 1094 |
965909 | 965909 | 2021-01-26 | Jefferson | Alabama | 1073 | 65189 | 1049 |
962664 | 962664 | 2021-01-25 | Jefferson | Alabama | 1073 | 64910 | 1007 |
959419 | 959419 | 2021-01-24 | Jefferson | Alabama | 1073 | 64681 | 1007 |
956173 | 956173 | 2021-01-23 | Jefferson | Alabama | 1073 | 64437 | 1007 |
952928 | 952928 | 2021-01-22 | Jefferson | Alabama | 1073 | 63969 | 994 |
949683 | 949683 | 2021-01-21 | Jefferson | Alabama | 1073 | 63523 | 957 |
946437 | 946437 | 2021-01-20 | Jefferson | Alabama | 1073 | 63040 | 956 |
943190 | 943190 | 2021-01-19 | Jefferson | Alabama | 1073 | 62752 | 920 |
939945 | 939945 | 2021-01-18 | Jefferson | Alabama | 1073 | 62258 | 921 |
936700 | 936700 | 2021-01-17 | Jefferson | Alabama | 1073 | 62039 | 921 |
933455 | 933455 | 2021-01-16 | Jefferson | Alabama | 1073 | 61755 | 921 |
930210 | 930210 | 2021-01-15 | Jefferson | Alabama | 1073 | 61313 | 888 |
926965 | 926965 | 2021-01-14 | Jefferson | Alabama | 1073 | 60842 | 887 |
923719 | 923719 | 2021-01-13 | Jefferson | Alabama | 1073 | 60269 | 872 |
920474 | 920474 | 2021-01-12 | Jefferson | Alabama | 1073 | 59867 | 842 |
917229 | 917229 | 2021-01-11 | Jefferson | Alabama | 1073 | 59248 | 784 |
913984 | 913984 | 2021-01-10 | Jefferson | Alabama | 1073 | 58896 | 784 |
910739 | 910739 | 2021-01-09 | Jefferson | Alabama | 1073 | 58394 | 784 |
907494 | 907494 | 2021-01-08 | Jefferson | Alabama | 1073 | 57609 | 776 |
904248 | 904248 | 2021-01-07 | Jefferson | Alabama | 1073 | 56823 | 748 |
901003 | 901003 | 2021-01-06 | Jefferson | Alabama | 1073 | 56031 | 738 |
897758 | 897758 | 2021-01-05 | Jefferson | Alabama | 1073 | 55344 | 725 |
894512 | 894512 | 2021-01-04 | Jefferson | Alabama | 1073 | 54349 | 722 |
891266 | 891266 | 2021-01-03 | Jefferson | Alabama | 1073 | 54012 | 719 |
888019 | 888019 | 2021-01-02 | Jefferson | Alabama | 1073 | 53621 | 719 |
884774 | 884774 | 2021-01-01 | Jefferson | Alabama | 1073 | 53058 | 719 |
881529 | 881529 | 2020-12-31 | Jefferson | Alabama | 1073 | 52339 | 697 |
878284 | 878284 | 2020-12-30 | Jefferson | Alabama | 1073 | 51676 | 694 |
875039 | 875039 | 2020-12-29 | Jefferson | Alabama | 1073 | 50686 | 689 |
871794 | 871794 | 2020-12-28 | Jefferson | Alabama | 1073 | 49981 | 675 |
868549 | 868549 | 2020-12-27 | Jefferson | Alabama | 1073 | 49645 | 658 |
865304 | 865304 | 2020-12-26 | Jefferson | Alabama | 1073 | 49278 | 658 |
862059 | 862059 | 2020-12-25 | Jefferson | Alabama | 1073 | 49125 | 658 |
858814 | 858814 | 2020-12-24 | Jefferson | Alabama | 1073 | 48517 | 658 |
855569 | 855569 | 2020-12-23 | Jefferson | Alabama | 1073 | 47754 | 630 |
852324 | 852324 | 2020-12-22 | Jefferson | Alabama | 1073 | 46794 | 616 |
849079 | 849079 | 2020-12-21 | Jefferson | Alabama | 1073 | 46004 | 607 |
845834 | 845834 | 2020-12-20 | Jefferson | Alabama | 1073 | 45527 | 607 |
842588 | 842588 | 2020-12-19 | Jefferson | Alabama | 1073 | 45092 | 607 |
839343 | 839343 | 2020-12-18 | Jefferson | Alabama | 1073 | 44274 | 586 |
836098 | 836098 | 2020-12-17 | Jefferson | Alabama | 1073 | 43318 | 571 |
832852 | 832852 | 2020-12-16 | Jefferson | Alabama | 1073 | 42489 | 570 |
829605 | 829605 | 2020-12-15 | Jefferson | Alabama | 1073 | 41718 | 565 |
826359 | 826359 | 2020-12-14 | Jefferson | Alabama | 1073 | 41150 | 558 |
823112 | 823112 | 2020-12-13 | Jefferson | Alabama | 1073 | 40709 | 558 |
819866 | 819866 | 2020-12-12 | Jefferson | Alabama | 1073 | 40232 | 558 |
816620 | 816620 | 2020-12-11 | Jefferson | Alabama | 1073 | 39541 | 559 |
813374 | 813374 | 2020-12-10 | Jefferson | Alabama | 1073 | 38794 | 548 |
810130 | 810130 | 2020-12-09 | Jefferson | Alabama | 1073 | 38031 | 533 |
806885 | 806885 | 2020-12-08 | Jefferson | Alabama | 1073 | 37488 | 529 |
803640 | 803640 | 2020-12-07 | Jefferson | Alabama | 1073 | 36872 | 520 |
800395 | 800395 | 2020-12-06 | Jefferson | Alabama | 1073 | 36475 | 520 |
797150 | 797150 | 2020-12-05 | Jefferson | Alabama | 1073 | 36002 | 519 |
793905 | 793905 | 2020-12-04 | Jefferson | Alabama | 1073 | 35310 | 515 |
790660 | 790660 | 2020-12-03 | Jefferson | Alabama | 1073 | 34716 | 513 |
787415 | 787415 | 2020-12-02 | Jefferson | Alabama | 1073 | 34214 | 511 |
784171 | 784171 | 2020-12-01 | Jefferson | Alabama | 1073 | 33526 | 501 |
780926 | 780926 | 2020-11-30 | Jefferson | Alabama | 1073 | 33064 | 500 |
777680 | 777680 | 2020-11-29 | Jefferson | Alabama | 1073 | 32718 | 500 |
774435 | 774435 | 2020-11-28 | Jefferson | Alabama | 1073 | 32314 | 500 |
771190 | 771190 | 2020-11-27 | Jefferson | Alabama | 1073 | 31944 | 500 |
767944 | 767944 | 2020-11-26 | Jefferson | Alabama | 1073 | 31809 | 500 |
764699 | 764699 | 2020-11-25 | Jefferson | Alabama | 1073 | 31391 | 491 |
761454 | 761454 | 2020-11-24 | Jefferson | Alabama | 1073 | 31043 | 491 |
758209 | 758209 | 2020-11-23 | Jefferson | Alabama | 1073 | 30620 | 491 |
754962 | 754962 | 2020-11-22 | Jefferson | Alabama | 1073 | 30318 | 491 |
751716 | 751716 | 2020-11-21 | Jefferson | Alabama | 1073 | 30027 | 491 |
748470 | 748470 | 2020-11-20 | Jefferson | Alabama | 1073 | 29626 | 491 |
745224 | 745224 | 2020-11-19 | Jefferson | Alabama | 1073 | 29186 | 490 |
741977 | 741977 | 2020-11-18 | Jefferson | Alabama | 1073 | 28781 | 481 |
738730 | 738730 | 2020-11-17 | Jefferson | Alabama | 1073 | 28420 | 476 |
735486 | 735486 | 2020-11-16 | Jefferson | Alabama | 1073 | 28140 | 461 |
732240 | 732240 | 2020-11-15 | Jefferson | Alabama | 1073 | 27884 | 461 |
728995 | 728995 | 2020-11-14 | Jefferson | Alabama | 1073 | 27579 | 461 |
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);