ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-07-10 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
318714 | 318714 | 2020-07-10 | Autauga | Alabama | 1001 | 670 | 15 |
318715 | 318715 | 2020-07-10 | Baldwin | Alabama | 1003 | 1187 | 12 |
318716 | 318716 | 2020-07-10 | Barbour | Alabama | 1005 | 381 | 2 |
318717 | 318717 | 2020-07-10 | Bibb | Alabama | 1007 | 218 | 1 |
318718 | 318718 | 2020-07-10 | Blount | Alabama | 1009 | 292 | 1 |
318719 | 318719 | 2020-07-10 | Bullock | Alabama | 1011 | 381 | 11 |
318720 | 318720 | 2020-07-10 | Butler | Alabama | 1013 | 648 | 29 |
318721 | 318721 | 2020-07-10 | Calhoun | Alabama | 1015 | 465 | 5 |
318722 | 318722 | 2020-07-10 | Chambers | Alabama | 1017 | 679 | 27 |
318723 | 318723 | 2020-07-10 | Cherokee | Alabama | 1019 | 118 | 7 |
318724 | 318724 | 2020-07-10 | Chilton | Alabama | 1021 | 303 | 3 |
318725 | 318725 | 2020-07-10 | Choctaw | Alabama | 1023 | 210 | 12 |
318726 | 318726 | 2020-07-10 | Clarke | Alabama | 1025 | 304 | 6 |
318727 | 318727 | 2020-07-10 | Clay | Alabama | 1027 | 82 | 2 |
318728 | 318728 | 2020-07-10 | Cleburne | Alabama | 1029 | 42 | 1 |
318729 | 318729 | 2020-07-10 | Coffee | Alabama | 1031 | 421 | 4 |
318730 | 318730 | 2020-07-10 | Colbert | Alabama | 1033 | 491 | 6 |
318731 | 318731 | 2020-07-10 | Conecuh | Alabama | 1035 | 229 | 8 |
318732 | 318732 | 2020-07-10 | Coosa | Alabama | 1037 | 63 | 1 |
318733 | 318733 | 2020-07-10 | Covington | Alabama | 1039 | 421 | 13 |
318734 | 318734 | 2020-07-10 | Crenshaw | Alabama | 1041 | 130 | 3 |
318735 | 318735 | 2020-07-10 | Cullman | Alabama | 1043 | 564 | 6 |
318736 | 318736 | 2020-07-10 | Dale | Alabama | 1045 | 375 | 1 |
318737 | 318737 | 2020-07-10 | Dallas | Alabama | 1047 | 990 | 9 |
318738 | 318738 | 2020-07-10 | DeKalb | Alabama | 1049 | 874 | 7 |
318739 | 318739 | 2020-07-10 | Elmore | Alabama | 1051 | 1025 | 21 |
318740 | 318740 | 2020-07-10 | Escambia | Alabama | 1053 | 468 | 8 |
318741 | 318741 | 2020-07-10 | Etowah | Alabama | 1055 | 931 | 14 |
318742 | 318742 | 2020-07-10 | Fayette | Alabama | 1057 | 84 | 1 |
318743 | 318743 | 2020-07-10 | Franklin | Alabama | 1059 | 933 | 16 |
318744 | 318744 | 2020-07-10 | Geneva | Alabama | 1061 | 95 | 0 |
318745 | 318745 | 2020-07-10 | Greene | Alabama | 1063 | 192 | 9 |
318746 | 318746 | 2020-07-10 | Hale | Alabama | 1065 | 348 | 23 |
318747 | 318747 | 2020-07-10 | Henry | Alabama | 1067 | 147 | 4 |
318748 | 318748 | 2020-07-10 | Houston | Alabama | 1069 | 576 | 8 |
318749 | 318749 | 2020-07-10 | Jackson | Alabama | 1071 | 406 | 3 |
318750 | 318750 | 2020-07-10 | Jefferson | Alabama | 1073 | 6283 | 169 |
318751 | 318751 | 2020-07-10 | Lamar | Alabama | 1075 | 88 | 1 |
318752 | 318752 | 2020-07-10 | Lauderdale | Alabama | 1077 | 558 | 6 |
318753 | 318753 | 2020-07-10 | Lawrence | Alabama | 1079 | 124 | 0 |
318754 | 318754 | 2020-07-10 | Lee | Alabama | 1081 | 1571 | 38 |
318755 | 318755 | 2020-07-10 | Limestone | Alabama | 1083 | 602 | 4 |
318756 | 318756 | 2020-07-10 | Lowndes | Alabama | 1085 | 484 | 24 |
318757 | 318757 | 2020-07-10 | Macon | Alabama | 1087 | 218 | 9 |
318758 | 318758 | 2020-07-10 | Madison | Alabama | 1089 | 2012 | 10 |
318759 | 318759 | 2020-07-10 | Marengo | Alabama | 1091 | 344 | 11 |
318760 | 318760 | 2020-07-10 | Marion | Alabama | 1093 | 271 | 14 |
318761 | 318761 | 2020-07-10 | Marshall | Alabama | 1095 | 1918 | 11 |
318762 | 318762 | 2020-07-10 | Mobile | Alabama | 1097 | 4649 | 142 |
318763 | 318763 | 2020-07-10 | Monroe | Alabama | 1099 | 257 | 4 |
318764 | 318764 | 2020-07-10 | Montgomery | Alabama | 1101 | 4445 | 113 |
318765 | 318765 | 2020-07-10 | Morgan | Alabama | 1103 | 1255 | 5 |
318766 | 318766 | 2020-07-10 | Perry | Alabama | 1105 | 224 | 2 |
318767 | 318767 | 2020-07-10 | Pickens | Alabama | 1107 | 265 | 6 |
318768 | 318768 | 2020-07-10 | Pike | Alabama | 1109 | 473 | 5 |
318769 | 318769 | 2020-07-10 | Randolph | Alabama | 1111 | 250 | 9 |
318770 | 318770 | 2020-07-10 | Russell | Alabama | 1113 | 672 | 0 |
318771 | 318771 | 2020-07-10 | Shelby | Alabama | 1117 | 1587 | 24 |
318772 | 318772 | 2020-07-10 | St. Clair | Alabama | 1115 | 499 | 2 |
318773 | 318773 | 2020-07-10 | Sumter | Alabama | 1119 | 288 | 13 |
318774 | 318774 | 2020-07-10 | Talladega | Alabama | 1121 | 379 | 8 |
318775 | 318775 | 2020-07-10 | Tallapoosa | Alabama | 1123 | 634 | 70 |
318776 | 318776 | 2020-07-10 | Tuscaloosa | Alabama | 1125 | 2608 | 54 |
318777 | 318777 | 2020-07-10 | Walker | Alabama | 1127 | 1070 | 31 |
318778 | 318778 | 2020-07-10 | Washington | Alabama | 1129 | 139 | 7 |
318779 | 318779 | 2020-07-10 | Wilcox | Alabama | 1131 | 302 | 8 |
318780 | 318780 | 2020-07-10 | Winston | Alabama | 1133 | 296 | 5 |
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);