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 |
---|---|---|---|---|---|---|---|
1193157 | 1193157 | 2021-04-06 | Mobile | Alabama | 1097 | 37605 | 794 |
1189907 | 1189907 | 2021-04-05 | Mobile | Alabama | 1097 | 37593 | 793 |
1186660 | 1186660 | 2021-04-04 | Mobile | Alabama | 1097 | 37590 | 792 |
1183413 | 1183413 | 2021-04-03 | Mobile | Alabama | 1097 | 37574 | 792 |
1180166 | 1180166 | 2021-04-02 | Mobile | Alabama | 1097 | 37555 | 792 |
1176919 | 1176919 | 2021-04-01 | Mobile | Alabama | 1097 | 37515 | 792 |
1173672 | 1173672 | 2021-03-31 | Mobile | Alabama | 1097 | 37492 | 792 |
1170425 | 1170425 | 2021-03-30 | Mobile | Alabama | 1097 | 37473 | 791 |
1167177 | 1167177 | 2021-03-29 | Mobile | Alabama | 1097 | 37458 | 789 |
1163929 | 1163929 | 2021-03-28 | Mobile | Alabama | 1097 | 37449 | 789 |
1160681 | 1160681 | 2021-03-27 | Mobile | Alabama | 1097 | 37439 | 789 |
1157433 | 1157433 | 2021-03-26 | Mobile | Alabama | 1097 | 37420 | 786 |
1154186 | 1154186 | 2021-03-25 | Mobile | Alabama | 1097 | 37395 | 785 |
1150939 | 1150939 | 2021-03-24 | Mobile | Alabama | 1097 | 37363 | 785 |
1147692 | 1147692 | 2021-03-23 | Mobile | Alabama | 1097 | 37320 | 777 |
1144445 | 1144445 | 2021-03-22 | Mobile | Alabama | 1097 | 37312 | 775 |
1141198 | 1141198 | 2021-03-21 | Mobile | Alabama | 1097 | 37240 | 775 |
1137952 | 1137952 | 2021-03-20 | Mobile | Alabama | 1097 | 37182 | 775 |
1134706 | 1134706 | 2021-03-19 | Mobile | Alabama | 1097 | 37163 | 774 |
1131458 | 1131458 | 2021-03-18 | Mobile | Alabama | 1097 | 37106 | 769 |
1128211 | 1128211 | 2021-03-17 | Mobile | Alabama | 1097 | 37092 | 765 |
1124965 | 1124965 | 2021-03-16 | Mobile | Alabama | 1097 | 36979 | 762 |
1121719 | 1121719 | 2021-03-15 | Mobile | Alabama | 1097 | 36932 | 755 |
1118472 | 1118472 | 2021-03-14 | Mobile | Alabama | 1097 | 36717 | 753 |
1115225 | 1115225 | 2021-03-13 | Mobile | Alabama | 1097 | 36694 | 753 |
1111979 | 1111979 | 2021-03-12 | Mobile | Alabama | 1097 | 36629 | 752 |
1108733 | 1108733 | 2021-03-11 | Mobile | Alabama | 1097 | 36598 | 749 |
1105487 | 1105487 | 2021-03-10 | Mobile | Alabama | 1097 | 36525 | 746 |
1102241 | 1102241 | 2021-03-09 | Mobile | Alabama | 1097 | 36473 | 743 |
1098995 | 1098995 | 2021-03-08 | Mobile | Alabama | 1097 | 36436 | 741 |
1095747 | 1095747 | 2021-03-07 | Mobile | Alabama | 1097 | 36423 | 741 |
1092501 | 1092501 | 2021-03-06 | Mobile | Alabama | 1097 | 36396 | 741 |
1089255 | 1089255 | 2021-03-05 | Mobile | Alabama | 1097 | 36328 | 740 |
1086010 | 1086010 | 2021-03-04 | Mobile | Alabama | 1097 | 36294 | 737 |
1082764 | 1082764 | 2021-03-03 | Mobile | Alabama | 1097 | 36252 | 736 |
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 |
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);