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 |
---|---|---|---|---|---|---|---|
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 |
725752 | 725752 | 2020-11-13 | Jefferson | Alabama | 1073 | 27264 | 454 |
722509 | 722509 | 2020-11-12 | Jefferson | Alabama | 1073 | 26813 | 454 |
719266 | 719266 | 2020-11-11 | Jefferson | Alabama | 1073 | 26514 | 442 |
716023 | 716023 | 2020-11-10 | Jefferson | Alabama | 1073 | 26232 | 409 |
712779 | 712779 | 2020-11-09 | Jefferson | Alabama | 1073 | 26003 | 403 |
709535 | 709535 | 2020-11-08 | Jefferson | Alabama | 1073 | 25827 | 403 |
706291 | 706291 | 2020-11-07 | Jefferson | Alabama | 1073 | 25627 | 403 |
703048 | 703048 | 2020-11-06 | Jefferson | Alabama | 1073 | 25370 | 391 |
699805 | 699805 | 2020-11-05 | Jefferson | Alabama | 1073 | 25159 | 391 |
696561 | 696561 | 2020-11-04 | Jefferson | Alabama | 1073 | 24973 | 390 |
693319 | 693319 | 2020-11-03 | Jefferson | Alabama | 1073 | 24754 | 388 |
690076 | 690076 | 2020-11-02 | Jefferson | Alabama | 1073 | 24597 | 388 |
686831 | 686831 | 2020-11-01 | Jefferson | Alabama | 1073 | 24472 | 388 |
683587 | 683587 | 2020-10-31 | Jefferson | Alabama | 1073 | 24285 | 384 |
680344 | 680344 | 2020-10-30 | Jefferson | Alabama | 1073 | 24088 | 384 |
677101 | 677101 | 2020-10-29 | Jefferson | Alabama | 1073 | 23940 | 385 |
673858 | 673858 | 2020-10-28 | Jefferson | Alabama | 1073 | 23769 | 383 |
670616 | 670616 | 2020-10-27 | Jefferson | Alabama | 1073 | 23573 | 377 |
667373 | 667373 | 2020-10-26 | Jefferson | Alabama | 1073 | 23443 | 377 |
664128 | 664128 | 2020-10-25 | Jefferson | Alabama | 1073 | 23292 | 377 |
660884 | 660884 | 2020-10-24 | Jefferson | Alabama | 1073 | 23129 | 377 |
657640 | 657640 | 2020-10-23 | Jefferson | Alabama | 1073 | 22988 | 375 |
654395 | 654395 | 2020-10-22 | Jefferson | Alabama | 1073 | 22861 | 374 |
651150 | 651150 | 2020-10-21 | Jefferson | Alabama | 1073 | 22720 | 374 |
647906 | 647906 | 2020-10-20 | Jefferson | Alabama | 1073 | 22563 | 372 |
644661 | 644661 | 2020-10-19 | Jefferson | Alabama | 1073 | 22400 | 372 |
641413 | 641413 | 2020-10-18 | Jefferson | Alabama | 1073 | 22300 | 372 |
638166 | 638166 | 2020-10-17 | Jefferson | Alabama | 1073 | 22194 | 372 |
634921 | 634921 | 2020-10-16 | Jefferson | Alabama | 1073 | 22030 | 371 |
631676 | 631676 | 2020-10-15 | Jefferson | Alabama | 1073 | 21897 | 364 |
628432 | 628432 | 2020-10-14 | Jefferson | Alabama | 1073 | 21746 | 362 |
625189 | 625189 | 2020-10-13 | Jefferson | Alabama | 1073 | 21652 | 362 |
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);