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-09 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315541 | 315541 | 2020-07-09 | Autauga | Alabama | 1001 | 661 | 14 |
315542 | 315542 | 2020-07-09 | Baldwin | Alabama | 1003 | 1131 | 11 |
315543 | 315543 | 2020-07-09 | Barbour | Alabama | 1005 | 371 | 2 |
315544 | 315544 | 2020-07-09 | Bibb | Alabama | 1007 | 211 | 1 |
315545 | 315545 | 2020-07-09 | Blount | Alabama | 1009 | 282 | 1 |
315546 | 315546 | 2020-07-09 | Bullock | Alabama | 1011 | 375 | 11 |
315547 | 315547 | 2020-07-09 | Butler | Alabama | 1013 | 646 | 28 |
315548 | 315548 | 2020-07-09 | Calhoun | Alabama | 1015 | 445 | 5 |
315549 | 315549 | 2020-07-09 | Chambers | Alabama | 1017 | 672 | 27 |
315550 | 315550 | 2020-07-09 | Cherokee | Alabama | 1019 | 115 | 7 |
315551 | 315551 | 2020-07-09 | Chilton | Alabama | 1021 | 295 | 3 |
315552 | 315552 | 2020-07-09 | Choctaw | Alabama | 1023 | 203 | 12 |
315553 | 315553 | 2020-07-09 | Clarke | Alabama | 1025 | 295 | 6 |
315554 | 315554 | 2020-07-09 | Clay | Alabama | 1027 | 74 | 2 |
315555 | 315555 | 2020-07-09 | Cleburne | Alabama | 1029 | 41 | 1 |
315556 | 315556 | 2020-07-09 | Coffee | Alabama | 1031 | 412 | 4 |
315557 | 315557 | 2020-07-09 | Colbert | Alabama | 1033 | 474 | 6 |
315558 | 315558 | 2020-07-09 | Conecuh | Alabama | 1035 | 229 | 7 |
315559 | 315559 | 2020-07-09 | Coosa | Alabama | 1037 | 62 | 1 |
315560 | 315560 | 2020-07-09 | Covington | Alabama | 1039 | 412 | 12 |
315561 | 315561 | 2020-07-09 | Crenshaw | Alabama | 1041 | 131 | 3 |
315562 | 315562 | 2020-07-09 | Cullman | Alabama | 1043 | 549 | 5 |
315563 | 315563 | 2020-07-09 | Dale | Alabama | 1045 | 365 | 1 |
315564 | 315564 | 2020-07-09 | Dallas | Alabama | 1047 | 971 | 9 |
315565 | 315565 | 2020-07-09 | DeKalb | Alabama | 1049 | 851 | 6 |
315566 | 315566 | 2020-07-09 | Elmore | Alabama | 1051 | 1005 | 19 |
315567 | 315567 | 2020-07-09 | Escambia | Alabama | 1053 | 452 | 8 |
315568 | 315568 | 2020-07-09 | Etowah | Alabama | 1055 | 894 | 14 |
315569 | 315569 | 2020-07-09 | Fayette | Alabama | 1057 | 81 | 1 |
315570 | 315570 | 2020-07-09 | Franklin | Alabama | 1059 | 927 | 16 |
315571 | 315571 | 2020-07-09 | Geneva | Alabama | 1061 | 92 | 0 |
315572 | 315572 | 2020-07-09 | Greene | Alabama | 1063 | 192 | 8 |
315573 | 315573 | 2020-07-09 | Hale | Alabama | 1065 | 342 | 22 |
315574 | 315574 | 2020-07-09 | Henry | Alabama | 1067 | 144 | 4 |
315575 | 315575 | 2020-07-09 | Houston | Alabama | 1069 | 567 | 8 |
315576 | 315576 | 2020-07-09 | Jackson | Alabama | 1071 | 378 | 3 |
315577 | 315577 | 2020-07-09 | Jefferson | Alabama | 1073 | 6092 | 164 |
315578 | 315578 | 2020-07-09 | Lamar | Alabama | 1075 | 82 | 1 |
315579 | 315579 | 2020-07-09 | Lauderdale | Alabama | 1077 | 540 | 6 |
315580 | 315580 | 2020-07-09 | Lawrence | Alabama | 1079 | 120 | 0 |
315581 | 315581 | 2020-07-09 | Lee | Alabama | 1081 | 1527 | 38 |
315582 | 315582 | 2020-07-09 | Limestone | Alabama | 1083 | 579 | 1 |
315583 | 315583 | 2020-07-09 | Lowndes | Alabama | 1085 | 484 | 24 |
315584 | 315584 | 2020-07-09 | Macon | Alabama | 1087 | 212 | 9 |
315585 | 315585 | 2020-07-09 | Madison | Alabama | 1089 | 1934 | 9 |
315586 | 315586 | 2020-07-09 | Marengo | Alabama | 1091 | 332 | 11 |
315587 | 315587 | 2020-07-09 | Marion | Alabama | 1093 | 249 | 14 |
315588 | 315588 | 2020-07-09 | Marshall | Alabama | 1095 | 1879 | 11 |
315589 | 315589 | 2020-07-09 | Mobile | Alabama | 1097 | 4442 | 141 |
315590 | 315590 | 2020-07-09 | Monroe | Alabama | 1099 | 251 | 3 |
315591 | 315591 | 2020-07-09 | Montgomery | Alabama | 1101 | 4386 | 111 |
315592 | 315592 | 2020-07-09 | Morgan | Alabama | 1103 | 1234 | 5 |
315593 | 315593 | 2020-07-09 | Perry | Alabama | 1105 | 209 | 1 |
315594 | 315594 | 2020-07-09 | Pickens | Alabama | 1107 | 258 | 6 |
315595 | 315595 | 2020-07-09 | Pike | Alabama | 1109 | 465 | 5 |
315596 | 315596 | 2020-07-09 | Randolph | Alabama | 1111 | 246 | 9 |
315597 | 315597 | 2020-07-09 | Russell | Alabama | 1113 | 664 | 0 |
315598 | 315598 | 2020-07-09 | Shelby | Alabama | 1117 | 1535 | 24 |
315599 | 315599 | 2020-07-09 | St. Clair | Alabama | 1115 | 481 | 2 |
315600 | 315600 | 2020-07-09 | Sumter | Alabama | 1119 | 286 | 12 |
315601 | 315601 | 2020-07-09 | Talladega | Alabama | 1121 | 361 | 8 |
315602 | 315602 | 2020-07-09 | Tallapoosa | Alabama | 1123 | 625 | 70 |
315603 | 315603 | 2020-07-09 | Tuscaloosa | Alabama | 1125 | 2566 | 50 |
315604 | 315604 | 2020-07-09 | Walker | Alabama | 1127 | 1066 | 27 |
315605 | 315605 | 2020-07-09 | Washington | Alabama | 1129 | 130 | 7 |
315606 | 315606 | 2020-07-09 | Wilcox | Alabama | 1131 | 299 | 8 |
315607 | 315607 | 2020-07-09 | Winston | Alabama | 1133 | 293 | 3 |
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);