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-12-15 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
829569 | 829569 | 2020-12-15 | Autauga | Alabama | 1001 | 3426 | 43 |
829570 | 829570 | 2020-12-15 | Baldwin | Alabama | 1003 | 11061 | 141 |
829571 | 829571 | 2020-12-15 | Barbour | Alabama | 1005 | 1292 | 30 |
829572 | 829572 | 2020-12-15 | Bibb | Alabama | 1007 | 1504 | 39 |
829573 | 829573 | 2020-12-15 | Blount | Alabama | 1009 | 3881 | 49 |
829574 | 829574 | 2020-12-15 | Bullock | Alabama | 1011 | 733 | 20 |
829575 | 829575 | 2020-12-15 | Butler | Alabama | 1013 | 1332 | 44 |
829576 | 829576 | 2020-12-15 | Calhoun | Alabama | 1015 | 7966 | 130 |
829577 | 829577 | 2020-12-15 | Chambers | Alabama | 1017 | 2040 | 57 |
829578 | 829578 | 2020-12-15 | Cherokee | Alabama | 1019 | 1213 | 24 |
829579 | 829579 | 2020-12-15 | Chilton | Alabama | 1021 | 2585 | 46 |
829580 | 829580 | 2020-12-15 | Choctaw | Alabama | 1023 | 455 | 20 |
829581 | 829581 | 2020-12-15 | Clarke | Alabama | 1025 | 2101 | 24 |
829582 | 829582 | 2020-12-15 | Clay | Alabama | 1027 | 1014 | 28 |
829583 | 829583 | 2020-12-15 | Cleburne | Alabama | 1029 | 892 | 15 |
829584 | 829584 | 2020-12-15 | Coffee | Alabama | 1031 | 2971 | 25 |
829585 | 829585 | 2020-12-15 | Colbert | Alabama | 1033 | 3915 | 53 |
829586 | 829586 | 2020-12-15 | Conecuh | Alabama | 1035 | 784 | 15 |
829587 | 829587 | 2020-12-15 | Coosa | Alabama | 1037 | 438 | 4 |
829588 | 829588 | 2020-12-15 | Covington | Alabama | 1039 | 2563 | 38 |
829589 | 829589 | 2020-12-15 | Crenshaw | Alabama | 1041 | 793 | 32 |
829590 | 829590 | 2020-12-15 | Cullman | Alabama | 1043 | 5831 | 61 |
829591 | 829591 | 2020-12-15 | Dale | Alabama | 1045 | 2809 | 59 |
829592 | 829592 | 2020-12-15 | Dallas | Alabama | 1047 | 2517 | 34 |
829593 | 829593 | 2020-12-15 | DeKalb | Alabama | 1049 | 5933 | 49 |
829594 | 829594 | 2020-12-15 | Elmore | Alabama | 1051 | 5076 | 74 |
829595 | 829595 | 2020-12-15 | Escambia | Alabama | 1053 | 2291 | 32 |
829596 | 829596 | 2020-12-15 | Etowah | Alabama | 1055 | 8156 | 80 |
829597 | 829597 | 2020-12-15 | Fayette | Alabama | 1057 | 1199 | 16 |
829598 | 829598 | 2020-12-15 | Franklin | Alabama | 1059 | 2896 | 34 |
829599 | 829599 | 2020-12-15 | Geneva | Alabama | 1061 | 1427 | 16 |
829600 | 829600 | 2020-12-15 | Greene | Alabama | 1063 | 552 | 20 |
829601 | 829601 | 2020-12-15 | Hale | Alabama | 1065 | 1159 | 33 |
829602 | 829602 | 2020-12-15 | Henry | Alabama | 1067 | 1006 | 8 |
829603 | 829603 | 2020-12-15 | Houston | Alabama | 1069 | 6155 | 51 |
829604 | 829604 | 2020-12-15 | Jackson | Alabama | 1071 | 4433 | 27 |
829605 | 829605 | 2020-12-15 | Jefferson | Alabama | 1073 | 41718 | 565 |
829606 | 829606 | 2020-12-15 | Lamar | Alabama | 1075 | 870 | 9 |
829607 | 829607 | 2020-12-15 | Lauderdale | Alabama | 1077 | 5200 | 61 |
829608 | 829608 | 2020-12-15 | Lawrence | Alabama | 1079 | 1617 | 37 |
829609 | 829609 | 2020-12-15 | Lee | Alabama | 1081 | 8857 | 73 |
829610 | 829610 | 2020-12-15 | Limestone | Alabama | 1083 | 5457 | 49 |
829611 | 829611 | 2020-12-15 | Lowndes | Alabama | 1085 | 870 | 30 |
829612 | 829612 | 2020-12-15 | Macon | Alabama | 1087 | 855 | 24 |
829613 | 829613 | 2020-12-15 | Madison | Alabama | 1089 | 17454 | 163 |
829614 | 829614 | 2020-12-15 | Marengo | Alabama | 1091 | 1523 | 25 |
829615 | 829615 | 2020-12-15 | Marion | Alabama | 1093 | 1716 | 41 |
829616 | 829616 | 2020-12-15 | Marshall | Alabama | 1095 | 7890 | 64 |
829617 | 829617 | 2020-12-15 | Mobile | Alabama | 1097 | 22488 | 389 |
829618 | 829618 | 2020-12-15 | Monroe | Alabama | 1099 | 939 | 10 |
829619 | 829619 | 2020-12-15 | Montgomery | Alabama | 1101 | 14070 | 262 |
829620 | 829620 | 2020-12-15 | Morgan | Alabama | 1103 | 8662 | 64 |
829621 | 829621 | 2020-12-15 | Perry | Alabama | 1105 | 749 | 9 |
829622 | 829622 | 2020-12-15 | Pickens | Alabama | 1107 | 1441 | 24 |
829623 | 829623 | 2020-12-15 | Pike | Alabama | 1109 | 1754 | 16 |
829624 | 829624 | 2020-12-15 | Randolph | Alabama | 1111 | 1133 | 28 |
829625 | 829625 | 2020-12-15 | Russell | Alabama | 1113 | 2494 | 6 |
829626 | 829626 | 2020-12-15 | Shelby | Alabama | 1117 | 12983 | 87 |
829627 | 829627 | 2020-12-15 | St. Clair | Alabama | 1115 | 5391 | 62 |
829628 | 829628 | 2020-12-15 | Sumter | Alabama | 1119 | 686 | 22 |
829629 | 829629 | 2020-12-15 | Talladega | Alabama | 1121 | 4448 | 64 |
829630 | 829630 | 2020-12-15 | Tallapoosa | Alabama | 1123 | 2085 | 93 |
829631 | 829631 | 2020-12-15 | Tuscaloosa | Alabama | 1125 | 15811 | 193 |
829632 | 829632 | 2020-12-15 | Walker | Alabama | 1127 | 4479 | 116 |
829633 | 829633 | 2020-12-15 | Washington | Alabama | 1129 | 1037 | 23 |
829634 | 829634 | 2020-12-15 | Wilcox | Alabama | 1131 | 790 | 19 |
829635 | 829635 | 2020-12-15 | Winston | Alabama | 1133 | 1667 | 25 |
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);