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-23 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
855533 | 855533 | 2020-12-23 | Autauga | Alabama | 1001 | 3889 | 46 |
855534 | 855534 | 2020-12-23 | Baldwin | Alabama | 1003 | 12321 | 151 |
855535 | 855535 | 2020-12-23 | Barbour | Alabama | 1005 | 1383 | 32 |
855536 | 855536 | 2020-12-23 | Bibb | Alabama | 1007 | 1683 | 42 |
855537 | 855537 | 2020-12-23 | Blount | Alabama | 1009 | 4367 | 57 |
855538 | 855538 | 2020-12-23 | Bullock | Alabama | 1011 | 765 | 20 |
855539 | 855539 | 2020-12-23 | Butler | Alabama | 1013 | 1423 | 45 |
855540 | 855540 | 2020-12-23 | Calhoun | Alabama | 1015 | 8968 | 145 |
855541 | 855541 | 2020-12-23 | Chambers | Alabama | 1017 | 2176 | 61 |
855542 | 855542 | 2020-12-23 | Cherokee | Alabama | 1019 | 1329 | 23 |
855543 | 855543 | 2020-12-23 | Chilton | Alabama | 1021 | 2773 | 51 |
855544 | 855544 | 2020-12-23 | Choctaw | Alabama | 1023 | 483 | 22 |
855545 | 855545 | 2020-12-23 | Clarke | Alabama | 1025 | 2225 | 25 |
855546 | 855546 | 2020-12-23 | Clay | Alabama | 1027 | 1083 | 34 |
855547 | 855547 | 2020-12-23 | Cleburne | Alabama | 1029 | 977 | 16 |
855548 | 855548 | 2020-12-23 | Coffee | Alabama | 1031 | 3312 | 36 |
855549 | 855549 | 2020-12-23 | Colbert | Alabama | 1033 | 4280 | 58 |
855550 | 855550 | 2020-12-23 | Conecuh | Alabama | 1035 | 817 | 16 |
855551 | 855551 | 2020-12-23 | Coosa | Alabama | 1037 | 472 | 6 |
855552 | 855552 | 2020-12-23 | Covington | Alabama | 1039 | 2778 | 38 |
855553 | 855553 | 2020-12-23 | Crenshaw | Alabama | 1041 | 878 | 36 |
855554 | 855554 | 2020-12-23 | Cullman | Alabama | 1043 | 6591 | 70 |
855555 | 855555 | 2020-12-23 | Dale | Alabama | 1045 | 3108 | 61 |
855556 | 855556 | 2020-12-23 | Dallas | Alabama | 1047 | 2649 | 38 |
855557 | 855557 | 2020-12-23 | DeKalb | Alabama | 1049 | 6609 | 55 |
855558 | 855558 | 2020-12-23 | Elmore | Alabama | 1051 | 5773 | 80 |
855559 | 855559 | 2020-12-23 | Escambia | Alabama | 1053 | 2488 | 34 |
855560 | 855560 | 2020-12-23 | Etowah | Alabama | 1055 | 9355 | 91 |
855561 | 855561 | 2020-12-23 | Fayette | Alabama | 1057 | 1333 | 19 |
855562 | 855562 | 2020-12-23 | Franklin | Alabama | 1059 | 3083 | 36 |
855563 | 855563 | 2020-12-23 | Geneva | Alabama | 1061 | 1544 | 18 |
855564 | 855564 | 2020-12-23 | Greene | Alabama | 1063 | 604 | 20 |
855565 | 855565 | 2020-12-23 | Hale | Alabama | 1065 | 1328 | 33 |
855566 | 855566 | 2020-12-23 | Henry | Alabama | 1067 | 1130 | 8 |
855567 | 855567 | 2020-12-23 | Houston | Alabama | 1069 | 6734 | 57 |
855568 | 855568 | 2020-12-23 | Jackson | Alabama | 1071 | 4787 | 34 |
855569 | 855569 | 2020-12-23 | Jefferson | Alabama | 1073 | 47754 | 630 |
855570 | 855570 | 2020-12-23 | Lamar | Alabama | 1075 | 986 | 15 |
855571 | 855571 | 2020-12-23 | Lauderdale | Alabama | 1077 | 5859 | 68 |
855572 | 855572 | 2020-12-23 | Lawrence | Alabama | 1079 | 1859 | 41 |
855573 | 855573 | 2020-12-23 | Lee | Alabama | 1081 | 9609 | 74 |
855574 | 855574 | 2020-12-23 | Limestone | Alabama | 1083 | 6268 | 54 |
855575 | 855575 | 2020-12-23 | Lowndes | Alabama | 1085 | 910 | 32 |
855576 | 855576 | 2020-12-23 | Macon | Alabama | 1087 | 937 | 29 |
855577 | 855577 | 2020-12-23 | Madison | Alabama | 1089 | 20254 | 178 |
855578 | 855578 | 2020-12-23 | Marengo | Alabama | 1091 | 1685 | 26 |
855579 | 855579 | 2020-12-23 | Marion | Alabama | 1093 | 1933 | 43 |
855580 | 855580 | 2020-12-23 | Marshall | Alabama | 1095 | 8653 | 80 |
855581 | 855581 | 2020-12-23 | Mobile | Alabama | 1097 | 24002 | 468 |
855582 | 855582 | 2020-12-23 | Monroe | Alabama | 1099 | 1086 | 11 |
855583 | 855583 | 2020-12-23 | Montgomery | Alabama | 1101 | 15145 | 270 |
855584 | 855584 | 2020-12-23 | Morgan | Alabama | 1103 | 9817 | 83 |
855585 | 855585 | 2020-12-23 | Perry | Alabama | 1105 | 808 | 9 |
855586 | 855586 | 2020-12-23 | Pickens | Alabama | 1107 | 1614 | 26 |
855587 | 855587 | 2020-12-23 | Pike | Alabama | 1109 | 1864 | 23 |
855588 | 855588 | 2020-12-23 | Randolph | Alabama | 1111 | 1196 | 30 |
855589 | 855589 | 2020-12-23 | Russell | Alabama | 1113 | 2629 | 6 |
855590 | 855590 | 2020-12-23 | Shelby | Alabama | 1117 | 14407 | 101 |
855591 | 855591 | 2020-12-23 | St. Clair | Alabama | 1115 | 6015 | 69 |
855592 | 855592 | 2020-12-23 | Sumter | Alabama | 1119 | 798 | 24 |
855593 | 855593 | 2020-12-23 | Talladega | Alabama | 1121 | 4818 | 72 |
855594 | 855594 | 2020-12-23 | Tallapoosa | Alabama | 1123 | 2231 | 97 |
855595 | 855595 | 2020-12-23 | Tuscaloosa | Alabama | 1125 | 17279 | 212 |
855596 | 855596 | 2020-12-23 | Walker | Alabama | 1127 | 4882 | 132 |
855597 | 855597 | 2020-12-23 | Washington | Alabama | 1129 | 1125 | 24 |
855598 | 855598 | 2020-12-23 | Wilcox | Alabama | 1131 | 832 | 19 |
855599 | 855599 | 2020-12-23 | Winston | Alabama | 1133 | 1816 | 27 |
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);