ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1097 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1079518 | 1079518 | 2021-03-02 | Mobile | Alabama | 1097 | 36184 | 735 |
1076273 | 1076273 | 2021-03-01 | Mobile | Alabama | 1097 | 36139 | 727 |
1073027 | 1073027 | 2021-02-28 | Mobile | Alabama | 1097 | 36108 | 725 |
1069781 | 1069781 | 2021-02-27 | Mobile | Alabama | 1097 | 36044 | 725 |
1066536 | 1066536 | 2021-02-26 | Mobile | Alabama | 1097 | 35937 | 724 |
1063291 | 1063291 | 2021-02-25 | Mobile | Alabama | 1097 | 35894 | 721 |
1060046 | 1060046 | 2021-02-24 | Mobile | Alabama | 1097 | 35810 | 721 |
1056800 | 1056800 | 2021-02-23 | Mobile | Alabama | 1097 | 35725 | 716 |
1053554 | 1053554 | 2021-02-22 | Mobile | Alabama | 1097 | 35378 | 707 |
1050307 | 1050307 | 2021-02-21 | Mobile | Alabama | 1097 | 35345 | 707 |
1047060 | 1047060 | 2021-02-20 | Mobile | Alabama | 1097 | 35289 | 705 |
1043815 | 1043815 | 2021-02-19 | Mobile | Alabama | 1097 | 35230 | 703 |
1040570 | 1040570 | 2021-02-18 | Mobile | Alabama | 1097 | 35182 | 697 |
1037325 | 1037325 | 2021-02-17 | Mobile | Alabama | 1097 | 35054 | 688 |
1034080 | 1034080 | 2021-02-16 | Mobile | Alabama | 1097 | 35003 | 686 |
1030834 | 1030834 | 2021-02-15 | Mobile | Alabama | 1097 | 34951 | 684 |
1027587 | 1027587 | 2021-02-14 | Mobile | Alabama | 1097 | 34840 | 682 |
1024342 | 1024342 | 2021-02-13 | Mobile | Alabama | 1097 | 34762 | 682 |
1021097 | 1021097 | 2021-02-12 | Mobile | Alabama | 1097 | 34645 | 671 |
1017852 | 1017852 | 2021-02-11 | Mobile | Alabama | 1097 | 34555 | 667 |
1014607 | 1014607 | 2021-02-10 | Mobile | Alabama | 1097 | 34431 | 661 |
1011362 | 1011362 | 2021-02-09 | Mobile | Alabama | 1097 | 34329 | 658 |
1008116 | 1008116 | 2021-02-08 | Mobile | Alabama | 1097 | 34219 | 654 |
1004870 | 1004870 | 2021-02-07 | Mobile | Alabama | 1097 | 34090 | 647 |
1001624 | 1001624 | 2021-02-06 | Mobile | Alabama | 1097 | 33996 | 645 |
998378 | 998378 | 2021-02-05 | Mobile | Alabama | 1097 | 33796 | 639 |
995132 | 995132 | 2021-02-04 | Mobile | Alabama | 1097 | 33718 | 636 |
991886 | 991886 | 2021-02-03 | Mobile | Alabama | 1097 | 33449 | 630 |
988640 | 988640 | 2021-02-02 | Mobile | Alabama | 1097 | 33311 | 627 |
985393 | 985393 | 2021-02-01 | Mobile | Alabama | 1097 | 33159 | 611 |
982146 | 982146 | 2021-01-31 | Mobile | Alabama | 1097 | 33060 | 611 |
978900 | 978900 | 2021-01-30 | Mobile | Alabama | 1097 | 32747 | 608 |
975655 | 975655 | 2021-01-29 | Mobile | Alabama | 1097 | 32747 | 608 |
972410 | 972410 | 2021-01-28 | Mobile | Alabama | 1097 | 32552 | 605 |
969165 | 969165 | 2021-01-27 | Mobile | Alabama | 1097 | 32260 | 595 |
965921 | 965921 | 2021-01-26 | Mobile | Alabama | 1097 | 32138 | 590 |
962676 | 962676 | 2021-01-25 | Mobile | Alabama | 1097 | 31746 | 574 |
959431 | 959431 | 2021-01-24 | Mobile | Alabama | 1097 | 31620 | 572 |
956185 | 956185 | 2021-01-23 | Mobile | Alabama | 1097 | 31435 | 569 |
952940 | 952940 | 2021-01-22 | Mobile | Alabama | 1097 | 31211 | 565 |
949695 | 949695 | 2021-01-21 | Mobile | Alabama | 1097 | 30967 | 562 |
946449 | 946449 | 2021-01-20 | Mobile | Alabama | 1097 | 30794 | 557 |
943202 | 943202 | 2021-01-19 | Mobile | Alabama | 1097 | 30551 | 554 |
939957 | 939957 | 2021-01-18 | Mobile | Alabama | 1097 | 30381 | 549 |
936712 | 936712 | 2021-01-17 | Mobile | Alabama | 1097 | 30225 | 548 |
933467 | 933467 | 2021-01-16 | Mobile | Alabama | 1097 | 30058 | 548 |
930222 | 930222 | 2021-01-15 | Mobile | Alabama | 1097 | 29768 | 542 |
926977 | 926977 | 2021-01-14 | Mobile | Alabama | 1097 | 29590 | 538 |
923731 | 923731 | 2021-01-13 | Mobile | Alabama | 1097 | 29334 | 536 |
920486 | 920486 | 2021-01-12 | Mobile | Alabama | 1097 | 29011 | 532 |
917241 | 917241 | 2021-01-11 | Mobile | Alabama | 1097 | 28793 | 527 |
913996 | 913996 | 2021-01-10 | Mobile | Alabama | 1097 | 28584 | 523 |
910751 | 910751 | 2021-01-09 | Mobile | Alabama | 1097 | 28266 | 523 |
907506 | 907506 | 2021-01-08 | Mobile | Alabama | 1097 | 28034 | 521 |
904260 | 904260 | 2021-01-07 | Mobile | Alabama | 1097 | 27708 | 518 |
901015 | 901015 | 2021-01-06 | Mobile | Alabama | 1097 | 27343 | 513 |
897770 | 897770 | 2021-01-05 | Mobile | Alabama | 1097 | 27099 | 511 |
894524 | 894524 | 2021-01-04 | Mobile | Alabama | 1097 | 26854 | 510 |
891278 | 891278 | 2021-01-03 | Mobile | Alabama | 1097 | 26677 | 508 |
888031 | 888031 | 2021-01-02 | Mobile | Alabama | 1097 | 26431 | 508 |
884786 | 884786 | 2021-01-01 | Mobile | Alabama | 1097 | 26151 | 508 |
881541 | 881541 | 2020-12-31 | Mobile | Alabama | 1097 | 25858 | 506 |
878296 | 878296 | 2020-12-30 | Mobile | Alabama | 1097 | 25635 | 494 |
875051 | 875051 | 2020-12-29 | Mobile | Alabama | 1097 | 25353 | 491 |
871806 | 871806 | 2020-12-28 | Mobile | Alabama | 1097 | 25171 | 489 |
868561 | 868561 | 2020-12-27 | Mobile | Alabama | 1097 | 24933 | 487 |
865316 | 865316 | 2020-12-26 | Mobile | Alabama | 1097 | 24668 | 487 |
862071 | 862071 | 2020-12-25 | Mobile | Alabama | 1097 | 24578 | 482 |
858826 | 858826 | 2020-12-24 | Mobile | Alabama | 1097 | 24325 | 481 |
855581 | 855581 | 2020-12-23 | Mobile | Alabama | 1097 | 24002 | 468 |
852336 | 852336 | 2020-12-22 | Mobile | Alabama | 1097 | 23754 | 439 |
849091 | 849091 | 2020-12-21 | Mobile | Alabama | 1097 | 23627 | 415 |
845846 | 845846 | 2020-12-20 | Mobile | Alabama | 1097 | 23463 | 415 |
842600 | 842600 | 2020-12-19 | Mobile | Alabama | 1097 | 23224 | 415 |
839355 | 839355 | 2020-12-18 | Mobile | Alabama | 1097 | 23078 | 392 |
836110 | 836110 | 2020-12-17 | Mobile | Alabama | 1097 | 22829 | 392 |
832864 | 832864 | 2020-12-16 | Mobile | Alabama | 1097 | 22651 | 390 |
829617 | 829617 | 2020-12-15 | Mobile | Alabama | 1097 | 22488 | 389 |
826371 | 826371 | 2020-12-14 | Mobile | Alabama | 1097 | 22294 | 389 |
823124 | 823124 | 2020-12-13 | Mobile | Alabama | 1097 | 22169 | 389 |
819878 | 819878 | 2020-12-12 | Mobile | Alabama | 1097 | 22034 | 389 |
816632 | 816632 | 2020-12-11 | Mobile | Alabama | 1097 | 21937 | 387 |
813386 | 813386 | 2020-12-10 | Mobile | Alabama | 1097 | 21704 | 386 |
810142 | 810142 | 2020-12-09 | Mobile | Alabama | 1097 | 21480 | 384 |
806897 | 806897 | 2020-12-08 | Mobile | Alabama | 1097 | 21257 | 383 |
803652 | 803652 | 2020-12-07 | Mobile | Alabama | 1097 | 21166 | 380 |
800407 | 800407 | 2020-12-06 | Mobile | Alabama | 1097 | 20869 | 379 |
797162 | 797162 | 2020-12-05 | Mobile | Alabama | 1097 | 20764 | 377 |
793917 | 793917 | 2020-12-04 | Mobile | Alabama | 1097 | 20626 | 372 |
790672 | 790672 | 2020-12-03 | Mobile | Alabama | 1097 | 20452 | 370 |
787427 | 787427 | 2020-12-02 | Mobile | Alabama | 1097 | 20299 | 366 |
784183 | 784183 | 2020-12-01 | Mobile | Alabama | 1097 | 20103 | 365 |
780938 | 780938 | 2020-11-30 | Mobile | Alabama | 1097 | 19951 | 362 |
777692 | 777692 | 2020-11-29 | Mobile | Alabama | 1097 | 19904 | 362 |
774447 | 774447 | 2020-11-28 | Mobile | Alabama | 1097 | 19859 | 361 |
771202 | 771202 | 2020-11-27 | Mobile | Alabama | 1097 | 19687 | 361 |
767956 | 767956 | 2020-11-26 | Mobile | Alabama | 1097 | 19651 | 361 |
764711 | 764711 | 2020-11-25 | Mobile | Alabama | 1097 | 19562 | 361 |
761466 | 761466 | 2020-11-24 | Mobile | Alabama | 1097 | 19446 | 360 |
758221 | 758221 | 2020-11-23 | Mobile | Alabama | 1097 | 19306 | 358 |
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);