us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows sorted by state
This data as json, copyable, CSV (advanced)
| Link | rowid | date | county | state ▼ | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 6099 | 6099 | 2020-03-21 | St. Clair | Alabama | 1115 | 1 | 0 |
| 6100 | 6100 | 2020-03-21 | Talladega | Alabama | 1121 | 1 | 0 |
| 6101 | 6101 | 2020-03-21 | Tuscaloosa | Alabama | 1125 | 6 | 0 |
| 6102 | 6102 | 2020-03-21 | Walker | Alabama | 1127 | 1 | 0 |
| 6103 | 6103 | 2020-03-21 | Washington | Alabama | 1129 | 1 | 0 |
| 7117 | 7117 | 2020-03-22 | Baldwin | Alabama | 1003 | 2 | 0 |
| 7118 | 7118 | 2020-03-22 | Calhoun | Alabama | 1015 | 1 | 0 |
| 7119 | 7119 | 2020-03-22 | Chambers | Alabama | 1017 | 2 | 0 |
| 7120 | 7120 | 2020-03-22 | Cullman | Alabama | 1043 | 2 | 0 |
| 7121 | 7121 | 2020-03-22 | Elmore | Alabama | 1051 | 6 | 0 |
| 7122 | 7122 | 2020-03-22 | Jackson | Alabama | 1071 | 1 | 0 |
| 7123 | 7123 | 2020-03-22 | Jefferson | Alabama | 1073 | 71 | 0 |
| 7124 | 7124 | 2020-03-22 | Lamar | Alabama | 1075 | 1 | 0 |
| 7125 | 7125 | 2020-03-22 | Lauderdale | Alabama | 1077 | 2 | 0 |
| 7126 | 7126 | 2020-03-22 | Lee | Alabama | 1081 | 16 | 0 |
| 7127 | 7127 | 2020-03-22 | Limestone | Alabama | 1083 | 1 | 0 |
| 7128 | 7128 | 2020-03-22 | Madison | Alabama | 1089 | 16 | 0 |
| 7129 | 7129 | 2020-03-22 | Marion | Alabama | 1093 | 1 | 0 |
| 7130 | 7130 | 2020-03-22 | Mobile | Alabama | 1097 | 2 | 0 |
| 7131 | 7131 | 2020-03-22 | Montgomery | Alabama | 1101 | 3 | 0 |
| 7132 | 7132 | 2020-03-22 | Shelby | Alabama | 1117 | 17 | 0 |
| 7133 | 7133 | 2020-03-22 | St. Clair | Alabama | 1115 | 3 | 0 |
| 7134 | 7134 | 2020-03-22 | Talladega | Alabama | 1121 | 1 | 0 |
| 7135 | 7135 | 2020-03-22 | Tuscaloosa | Alabama | 1125 | 7 | 0 |
| 7136 | 7136 | 2020-03-22 | Walker | Alabama | 1127 | 1 | 0 |
| 7137 | 7137 | 2020-03-22 | Washington | Alabama | 1129 | 1 | 0 |
| 8255 | 8255 | 2020-03-23 | Baldwin | Alabama | 1003 | 3 | 0 |
| 8256 | 8256 | 2020-03-23 | Calhoun | Alabama | 1015 | 2 | 0 |
| 8257 | 8257 | 2020-03-23 | Chambers | Alabama | 1017 | 2 | 0 |
| 8258 | 8258 | 2020-03-23 | Cullman | Alabama | 1043 | 2 | 0 |
| 8259 | 8259 | 2020-03-23 | Elmore | Alabama | 1051 | 6 | 0 |
| 8260 | 8260 | 2020-03-23 | Franklin | Alabama | 1059 | 1 | 0 |
| 8261 | 8261 | 2020-03-23 | Houston | Alabama | 1069 | 1 | 0 |
| 8262 | 8262 | 2020-03-23 | Jackson | Alabama | 1071 | 1 | 0 |
| 8263 | 8263 | 2020-03-23 | Jefferson | Alabama | 1073 | 86 | 0 |
| 8264 | 8264 | 2020-03-23 | Lamar | Alabama | 1075 | 1 | 0 |
| 8265 | 8265 | 2020-03-23 | Lauderdale | Alabama | 1077 | 3 | 0 |
| 8266 | 8266 | 2020-03-23 | Lee | Alabama | 1081 | 19 | 0 |
| 8267 | 8267 | 2020-03-23 | Limestone | Alabama | 1083 | 1 | 0 |
| 8268 | 8268 | 2020-03-23 | Madison | Alabama | 1089 | 21 | 0 |
| 8269 | 8269 | 2020-03-23 | Marion | Alabama | 1093 | 1 | 0 |
| 8270 | 8270 | 2020-03-23 | Mobile | Alabama | 1097 | 2 | 0 |
| 8271 | 8271 | 2020-03-23 | Montgomery | Alabama | 1101 | 4 | 0 |
| 8272 | 8272 | 2020-03-23 | Shelby | Alabama | 1117 | 22 | 0 |
| 8273 | 8273 | 2020-03-23 | St. Clair | Alabama | 1115 | 3 | 0 |
| 8274 | 8274 | 2020-03-23 | Talladega | Alabama | 1121 | 1 | 0 |
| 8275 | 8275 | 2020-03-23 | Tallapoosa | Alabama | 1123 | 1 | 0 |
| 8276 | 8276 | 2020-03-23 | Tuscaloosa | Alabama | 1125 | 9 | 0 |
| 8277 | 8277 | 2020-03-23 | Walker | Alabama | 1127 | 3 | 0 |
| 8278 | 8278 | 2020-03-23 | Washington | Alabama | 1129 | 1 | 0 |
| 9481 | 9481 | 2020-03-24 | Autauga | Alabama | 1001 | 1 | 0 |
| 9482 | 9482 | 2020-03-24 | Baldwin | Alabama | 1003 | 4 | 0 |
| 9483 | 9483 | 2020-03-24 | Calhoun | Alabama | 1015 | 2 | 0 |
| 9484 | 9484 | 2020-03-24 | Chambers | Alabama | 1017 | 5 | 0 |
| 9485 | 9485 | 2020-03-24 | Cullman | Alabama | 1043 | 3 | 0 |
| 9486 | 9486 | 2020-03-24 | Elmore | Alabama | 1051 | 8 | 0 |
| 9487 | 9487 | 2020-03-24 | Franklin | Alabama | 1059 | 1 | 0 |
| 9488 | 9488 | 2020-03-24 | Houston | Alabama | 1069 | 1 | 0 |
| 9489 | 9489 | 2020-03-24 | Jackson | Alabama | 1071 | 2 | 0 |
| 9490 | 9490 | 2020-03-24 | Jefferson | Alabama | 1073 | 91 | 0 |
| 9491 | 9491 | 2020-03-24 | Lamar | Alabama | 1075 | 1 | 0 |
| 9492 | 9492 | 2020-03-24 | Lauderdale | Alabama | 1077 | 3 | 0 |
| 9493 | 9493 | 2020-03-24 | Lee | Alabama | 1081 | 26 | 0 |
| 9494 | 9494 | 2020-03-24 | Limestone | Alabama | 1083 | 4 | 0 |
| 9495 | 9495 | 2020-03-24 | Madison | Alabama | 1089 | 21 | 0 |
| 9496 | 9496 | 2020-03-24 | Marion | Alabama | 1093 | 1 | 0 |
| 9497 | 9497 | 2020-03-24 | Mobile | Alabama | 1097 | 6 | 0 |
| 9498 | 9498 | 2020-03-24 | Montgomery | Alabama | 1101 | 9 | 0 |
| 9499 | 9499 | 2020-03-24 | Morgan | Alabama | 1103 | 2 | 0 |
| 9500 | 9500 | 2020-03-24 | Shelby | Alabama | 1117 | 27 | 0 |
| 9501 | 9501 | 2020-03-24 | St. Clair | Alabama | 1115 | 4 | 0 |
| 9502 | 9502 | 2020-03-24 | Talladega | Alabama | 1121 | 2 | 0 |
| 9503 | 9503 | 2020-03-24 | Tallapoosa | Alabama | 1123 | 2 | 0 |
| 9504 | 9504 | 2020-03-24 | Tuscaloosa | Alabama | 1125 | 10 | 0 |
| 9505 | 9505 | 2020-03-24 | Walker | Alabama | 1127 | 5 | 0 |
| 9506 | 9506 | 2020-03-24 | Washington | Alabama | 1129 | 1 | 0 |
| 10836 | 10836 | 2020-03-25 | Autauga | Alabama | 1001 | 4 | 0 |
| 10837 | 10837 | 2020-03-25 | Baldwin | Alabama | 1003 | 4 | 0 |
| 10838 | 10838 | 2020-03-25 | Blount | Alabama | 1009 | 1 | 0 |
| 10839 | 10839 | 2020-03-25 | Butler | Alabama | 1013 | 1 | 0 |
| 10840 | 10840 | 2020-03-25 | Calhoun | Alabama | 1015 | 2 | 0 |
| 10841 | 10841 | 2020-03-25 | Chambers | Alabama | 1017 | 10 | 0 |
| 10842 | 10842 | 2020-03-25 | Cherokee | Alabama | 1019 | 1 | 0 |
| 10843 | 10843 | 2020-03-25 | Chilton | Alabama | 1021 | 1 | 0 |
| 10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
| 10845 | 10845 | 2020-03-25 | Cleburne | Alabama | 1029 | 1 | 0 |
| 10846 | 10846 | 2020-03-25 | Colbert | Alabama | 1033 | 1 | 0 |
| 10847 | 10847 | 2020-03-25 | Cullman | Alabama | 1043 | 4 | 0 |
| 10848 | 10848 | 2020-03-25 | Dallas | Alabama | 1047 | 2 | 0 |
| 10849 | 10849 | 2020-03-25 | Elmore | Alabama | 1051 | 9 | 0 |
| 10850 | 10850 | 2020-03-25 | Etowah | Alabama | 1055 | 3 | 0 |
| 10851 | 10851 | 2020-03-25 | Franklin | Alabama | 1059 | 2 | 0 |
| 10852 | 10852 | 2020-03-25 | Houston | Alabama | 1069 | 2 | 0 |
| 10853 | 10853 | 2020-03-25 | Jackson | Alabama | 1071 | 2 | 1 |
| 10854 | 10854 | 2020-03-25 | Jefferson | Alabama | 1073 | 129 | 0 |
| 10855 | 10855 | 2020-03-25 | Lamar | Alabama | 1075 | 1 | 0 |
| 10856 | 10856 | 2020-03-25 | Lauderdale | Alabama | 1077 | 7 | 0 |
| 10857 | 10857 | 2020-03-25 | Lawrence | Alabama | 1079 | 1 | 0 |
| 10858 | 10858 | 2020-03-25 | Lee | Alabama | 1081 | 40 | 0 |
| 10859 | 10859 | 2020-03-25 | Limestone | Alabama | 1083 | 6 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );