covid_casesdeaths_reshaped_bln

Table actions
Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details

Data source: Big Local News · About: big-local-datasette

1,191,735 rows sorted by stateFIPS

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name State stateFIPS ▼ date cases deaths
1 1 0 Statewide Unallocated AL 1 1/22/20 0 0
2 2 1001 Autauga County AL 1 1/22/20 0 0
3 3 1003 Baldwin County AL 1 1/22/20 0 0
4 4 1005 Barbour County AL 1 1/22/20 0 0
5 5 1007 Bibb County AL 1 1/22/20 0 0
6 6 1009 Blount County AL 1 1/22/20 0 0
7 7 1011 Bullock County AL 1 1/22/20 0 0
8 8 1013 Butler County AL 1 1/22/20 0 0
9 9 1015 Calhoun County AL 1 1/22/20 0 0
10 10 1017 Chambers County AL 1 1/22/20 0 0
11 11 1019 Cherokee County AL 1 1/22/20 0 0
12 12 1021 Chilton County AL 1 1/22/20 0 0
13 13 1023 Choctaw County AL 1 1/22/20 0 0
14 14 1025 Clarke County AL 1 1/22/20 0 0
15 15 1027 Clay County AL 1 1/22/20 0 0
16 16 1029 Cleburne County AL 1 1/22/20 0 0
17 17 1031 Coffee County AL 1 1/22/20 0 0
18 18 1033 Colbert County AL 1 1/22/20 0 0
19 19 1035 Conecuh County AL 1 1/22/20 0 0
20 20 1037 Coosa County AL 1 1/22/20 0 0
21 21 1039 Covington County AL 1 1/22/20 0 0
22 22 1041 Crenshaw County AL 1 1/22/20 0 0
23 23 1043 Cullman County AL 1 1/22/20 0 0
24 24 1045 Dale County AL 1 1/22/20 0 0
25 25 1047 Dallas County AL 1 1/22/20 0 0
26 26 1049 DeKalb County AL 1 1/22/20 0 0
27 27 1051 Elmore County AL 1 1/22/20 0 0
28 28 1053 Escambia County AL 1 1/22/20 0 0
29 29 1055 Etowah County AL 1 1/22/20 0 0
30 30 1057 Fayette County AL 1 1/22/20 0 0
31 31 1059 Franklin County AL 1 1/22/20 0 0
32 32 1061 Geneva County AL 1 1/22/20 0 0
33 33 1063 Greene County AL 1 1/22/20 0 0
34 34 1065 Hale County AL 1 1/22/20 0 0
35 35 1067 Henry County AL 1 1/22/20 0 0
36 36 1069 Houston County AL 1 1/22/20 0 0
37 37 1071 Jackson County AL 1 1/22/20 0 0
38 38 1073 Jefferson County AL 1 1/22/20 0 0
39 39 1075 Lamar County AL 1 1/22/20 0 0
40 40 1077 Lauderdale County AL 1 1/22/20 0 0
41 41 1079 Lawrence County AL 1 1/22/20 0 0
42 42 1081 Lee County AL 1 1/22/20 0 0
43 43 1083 Limestone County AL 1 1/22/20 0 0
44 44 1085 Lowndes County AL 1 1/22/20 0 0
45 45 1087 Macon County AL 1 1/22/20 0 0
46 46 1089 Madison County AL 1 1/22/20 0 0
47 47 1091 Marengo County AL 1 1/22/20 0 0
48 48 1093 Marion County AL 1 1/22/20 0 0
49 49 1095 Marshall County AL 1 1/22/20 0 0
50 50 1097 Mobile County AL 1 1/22/20 0 0
51 51 1099 Monroe County AL 1 1/22/20 0 0
52 52 1101 Montgomery County AL 1 1/22/20 0 0
53 53 1103 Morgan County AL 1 1/22/20 0 0
54 54 1105 Perry County AL 1 1/22/20 0 0
55 55 1107 Pickens County AL 1 1/22/20 0 0
56 56 1109 Pike County AL 1 1/22/20 0 0
57 57 1111 Randolph County AL 1 1/22/20 0 0
58 58 1113 Russell County AL 1 1/22/20 0 0
59 59 1115 St. Clair County AL 1 1/22/20 0 0
60 60 1117 Shelby County AL 1 1/22/20 0 0
61 61 1119 Sumter County AL 1 1/22/20 0 0
62 62 1121 Talladega County AL 1 1/22/20 0 0
63 63 1123 Tallapoosa County AL 1 1/22/20 0 0
64 64 1125 Tuscaloosa County AL 1 1/22/20 0 0
65 65 1127 Walker County AL 1 1/22/20 0 0
66 66 1129 Washington County AL 1 1/22/20 0 0
67 67 1131 Wilcox County AL 1 1/22/20 0 0
68 68 1133 Winston County AL 1 1/22/20 0 0
3196 3196 0 Statewide Unallocated AL 1 1/23/20 0 0
3197 3197 1001 Autauga County AL 1 1/23/20 0 0
3198 3198 1003 Baldwin County AL 1 1/23/20 0 0
3199 3199 1005 Barbour County AL 1 1/23/20 0 0
3200 3200 1007 Bibb County AL 1 1/23/20 0 0
3201 3201 1009 Blount County AL 1 1/23/20 0 0
3202 3202 1011 Bullock County AL 1 1/23/20 0 0
3203 3203 1013 Butler County AL 1 1/23/20 0 0
3204 3204 1015 Calhoun County AL 1 1/23/20 0 0
3205 3205 1017 Chambers County AL 1 1/23/20 0 0
3206 3206 1019 Cherokee County AL 1 1/23/20 0 0
3207 3207 1021 Chilton County AL 1 1/23/20 0 0
3208 3208 1023 Choctaw County AL 1 1/23/20 0 0
3209 3209 1025 Clarke County AL 1 1/23/20 0 0
3210 3210 1027 Clay County AL 1 1/23/20 0 0
3211 3211 1029 Cleburne County AL 1 1/23/20 0 0
3212 3212 1031 Coffee County AL 1 1/23/20 0 0
3213 3213 1033 Colbert County AL 1 1/23/20 0 0
3214 3214 1035 Conecuh County AL 1 1/23/20 0 0
3215 3215 1037 Coosa County AL 1 1/23/20 0 0
3216 3216 1039 Covington County AL 1 1/23/20 0 0
3217 3217 1041 Crenshaw County AL 1 1/23/20 0 0
3218 3218 1043 Cullman County AL 1 1/23/20 0 0
3219 3219 1045 Dale County AL 1 1/23/20 0 0
3220 3220 1047 Dallas County AL 1 1/23/20 0 0
3221 3221 1049 DeKalb County AL 1 1/23/20 0 0
3222 3222 1051 Elmore County AL 1 1/23/20 0 0
3223 3223 1053 Escambia County AL 1 1/23/20 0 0
3224 3224 1055 Etowah County AL 1 1/23/20 0 0
3225 3225 1057 Fayette County AL 1 1/23/20 0 0
3226 3226 1059 Franklin County AL 1 1/23/20 0 0
3227 3227 1061 Geneva County AL 1 1/23/20 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [covid_casesdeaths_reshaped_bln] (
   [countyFIPS] INTEGER,
   [County Name] TEXT,
   [State] TEXT,
   [stateFIPS] INTEGER,
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);