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-09-07 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
508542 | 508542 | 2020-09-07 | Autauga | Alabama | 1001 | 1504 | 24 |
508543 | 508543 | 2020-09-07 | Baldwin | Alabama | 1003 | 4730 | 46 |
508544 | 508544 | 2020-09-07 | Barbour | Alabama | 1005 | 778 | 7 |
508545 | 508545 | 2020-09-07 | Bibb | Alabama | 1007 | 583 | 9 |
508546 | 508546 | 2020-09-07 | Blount | Alabama | 1009 | 1384 | 12 |
508547 | 508547 | 2020-09-07 | Bullock | Alabama | 1011 | 568 | 14 |
508548 | 508548 | 2020-09-07 | Butler | Alabama | 1013 | 892 | 38 |
508549 | 508549 | 2020-09-07 | Calhoun | Alabama | 1015 | 2877 | 39 |
508550 | 508550 | 2020-09-07 | Chambers | Alabama | 1017 | 1063 | 41 |
508551 | 508551 | 2020-09-07 | Cherokee | Alabama | 1019 | 452 | 12 |
508552 | 508552 | 2020-09-07 | Chilton | Alabama | 1021 | 1300 | 16 |
508553 | 508553 | 2020-09-07 | Choctaw | Alabama | 1023 | 335 | 12 |
508554 | 508554 | 2020-09-07 | Clarke | Alabama | 1025 | 1023 | 14 |
508555 | 508555 | 2020-09-07 | Clay | Alabama | 1027 | 425 | 6 |
508556 | 508556 | 2020-09-07 | Cleburne | Alabama | 1029 | 250 | 5 |
508557 | 508557 | 2020-09-07 | Coffee | Alabama | 1031 | 1145 | 7 |
508558 | 508558 | 2020-09-07 | Colbert | Alabama | 1033 | 1513 | 22 |
508559 | 508559 | 2020-09-07 | Conecuh | Alabama | 1035 | 499 | 11 |
508560 | 508560 | 2020-09-07 | Coosa | Alabama | 1037 | 142 | 3 |
508561 | 508561 | 2020-09-07 | Covington | Alabama | 1039 | 1187 | 27 |
508562 | 508562 | 2020-09-07 | Crenshaw | Alabama | 1041 | 483 | 32 |
508563 | 508563 | 2020-09-07 | Cullman | Alabama | 1043 | 1716 | 17 |
508564 | 508564 | 2020-09-07 | Dale | Alabama | 1045 | 1164 | 42 |
508565 | 508565 | 2020-09-07 | Dallas | Alabama | 1047 | 1676 | 26 |
508566 | 508566 | 2020-09-07 | DeKalb | Alabama | 1049 | 2227 | 18 |
508567 | 508567 | 2020-09-07 | Elmore | Alabama | 1051 | 2331 | 47 |
508568 | 508568 | 2020-09-07 | Escambia | Alabama | 1053 | 1471 | 22 |
508569 | 508569 | 2020-09-07 | Etowah | Alabama | 1055 | 3076 | 43 |
508570 | 508570 | 2020-09-07 | Fayette | Alabama | 1057 | 350 | 6 |
508571 | 508571 | 2020-09-07 | Franklin | Alabama | 1059 | 1628 | 27 |
508572 | 508572 | 2020-09-07 | Geneva | Alabama | 1061 | 472 | 4 |
508573 | 508573 | 2020-09-07 | Greene | Alabama | 1063 | 292 | 15 |
508574 | 508574 | 2020-09-07 | Hale | Alabama | 1065 | 576 | 28 |
508575 | 508575 | 2020-09-07 | Henry | Alabama | 1067 | 409 | 4 |
508576 | 508576 | 2020-09-07 | Houston | Alabama | 1069 | 2273 | 20 |
508577 | 508577 | 2020-09-07 | Jackson | Alabama | 1071 | 1375 | 9 |
508578 | 508578 | 2020-09-07 | Jefferson | Alabama | 1073 | 17389 | 312 |
508579 | 508579 | 2020-09-07 | Lamar | Alabama | 1075 | 303 | 2 |
508580 | 508580 | 2020-09-07 | Lauderdale | Alabama | 1077 | 1511 | 26 |
508581 | 508581 | 2020-09-07 | Lawrence | Alabama | 1079 | 523 | 5 |
508582 | 508582 | 2020-09-07 | Lee | Alabama | 1081 | 5146 | 58 |
508583 | 508583 | 2020-09-07 | Limestone | Alabama | 1083 | 1762 | 19 |
508584 | 508584 | 2020-09-07 | Lowndes | Alabama | 1085 | 630 | 27 |
508585 | 508585 | 2020-09-07 | Macon | Alabama | 1087 | 456 | 19 |
508586 | 508586 | 2020-09-07 | Madison | Alabama | 1089 | 6867 | 64 |
508587 | 508587 | 2020-09-07 | Marengo | Alabama | 1091 | 668 | 19 |
508588 | 508588 | 2020-09-07 | Marion | Alabama | 1093 | 842 | 28 |
508589 | 508589 | 2020-09-07 | Marshall | Alabama | 1095 | 3673 | 42 |
508590 | 508590 | 2020-09-07 | Mobile | Alabama | 1097 | 12576 | 271 |
508591 | 508591 | 2020-09-07 | Monroe | Alabama | 1099 | 553 | 7 |
508592 | 508592 | 2020-09-07 | Montgomery | Alabama | 1101 | 8236 | 166 |
508593 | 508593 | 2020-09-07 | Morgan | Alabama | 1103 | 3002 | 24 |
508594 | 508594 | 2020-09-07 | Perry | Alabama | 1105 | 527 | 5 |
508595 | 508595 | 2020-09-07 | Pickens | Alabama | 1107 | 579 | 12 |
508596 | 508596 | 2020-09-07 | Pike | Alabama | 1109 | 1049 | 9 |
508597 | 508597 | 2020-09-07 | Randolph | Alabama | 1111 | 545 | 12 |
508598 | 508598 | 2020-09-07 | Russell | Alabama | 1113 | 1663 | 2 |
508599 | 508599 | 2020-09-07 | Shelby | Alabama | 1117 | 4949 | 48 |
508600 | 508600 | 2020-09-07 | St. Clair | Alabama | 1115 | 1981 | 32 |
508601 | 508601 | 2020-09-07 | Sumter | Alabama | 1119 | 411 | 19 |
508602 | 508602 | 2020-09-07 | Talladega | Alabama | 1121 | 1857 | 24 |
508603 | 508603 | 2020-09-07 | Tallapoosa | Alabama | 1123 | 1088 | 83 |
508604 | 508604 | 2020-09-07 | Tuscaloosa | Alabama | 1125 | 6285 | 104 |
508605 | 508605 | 2020-09-07 | Walker | Alabama | 1127 | 2061 | 77 |
508606 | 508606 | 2020-09-07 | Washington | Alabama | 1129 | 528 | 13 |
508607 | 508607 | 2020-09-07 | Wilcox | Alabama | 1131 | 520 | 11 |
508608 | 508608 | 2020-09-07 | Winston | Alabama | 1133 | 624 | 11 |
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);