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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ countyFIPS County Name State stateFIPS date cases deaths
101 101 4001 Apache County AZ 4 1/22/20 0 0
102 102 4003 Cochise County AZ 4 1/22/20 0 0
103 103 4005 Coconino County AZ 4 1/22/20 0 0
104 104 4007 Gila County AZ 4 1/22/20 0 0
105 105 4009 Graham County AZ 4 1/22/20 0 0
106 106 4011 Greenlee County AZ 4 1/22/20 0 0
107 107 4012 La Paz County AZ 4 1/22/20 0 0
108 108 4013 Maricopa County AZ 4 1/22/20 0 0
109 109 4015 Mohave County AZ 4 1/22/20 0 0
110 110 4017 Navajo County AZ 4 1/22/20 0 0
111 111 4019 Pima County AZ 4 1/22/20 0 0
112 112 4021 Pinal County AZ 4 1/22/20 0 0
113 113 4023 Santa Cruz County AZ 4 1/22/20 0 0
114 114 4025 Yavapai County AZ 4 1/22/20 0 0
115 115 4027 Yuma County AZ 4 1/22/20 0 0
116 116 0 Statewide Unallocated AR 5 1/22/20 0 0
117 117 5001 Arkansas County AR 5 1/22/20 0 0
118 118 5003 Ashley County AR 5 1/22/20 0 0
119 119 5005 Baxter County AR 5 1/22/20 0 0
120 120 5007 Benton County AR 5 1/22/20 0 0
121 121 5009 Boone County AR 5 1/22/20 0 0
122 122 5011 Bradley County AR 5 1/22/20 0 0
123 123 5013 Calhoun County AR 5 1/22/20 0 0
124 124 5015 Carroll County AR 5 1/22/20 0 0
125 125 5017 Chicot County AR 5 1/22/20 0 0
126 126 5019 Clark County AR 5 1/22/20 0 0
127 127 5021 Clay County AR 5 1/22/20 0 0
128 128 5023 Cleburne County AR 5 1/22/20 0 0
129 129 5025 Cleveland County AR 5 1/22/20 0 0
130 130 5027 Columbia County AR 5 1/22/20 0 0
131 131 5029 Conway County AR 5 1/22/20 0 0
132 132 5031 Craighead County AR 5 1/22/20 0 0
133 133 5033 Crawford County AR 5 1/22/20 0 0
134 134 5035 Crittenden County AR 5 1/22/20 0 0
135 135 5037 Cross County AR 5 1/22/20 0 0
136 136 5039 Dallas County AR 5 1/22/20 0 0
137 137 5041 Desha County AR 5 1/22/20 0 0
138 138 5043 Drew County AR 5 1/22/20 0 0
139 139 5045 Faulkner County AR 5 1/22/20 0 0
140 140 5047 Franklin County AR 5 1/22/20 0 0
141 141 5049 Fulton County AR 5 1/22/20 0 0
142 142 5051 Garland County AR 5 1/22/20 0 0
143 143 5053 Grant County AR 5 1/22/20 0 0
144 144 5055 Greene County AR 5 1/22/20 0 0
145 145 5057 Hempstead County AR 5 1/22/20 0 0
146 146 5059 Hot Spring County AR 5 1/22/20 0 0
147 147 5061 Howard County AR 5 1/22/20 0 0
148 148 5063 Independence County AR 5 1/22/20 0 0
149 149 5065 Izard County AR 5 1/22/20 0 0
150 150 5067 Jackson County AR 5 1/22/20 0 0
151 151 5069 Jefferson County AR 5 1/22/20 0 0
152 152 5071 Johnson County AR 5 1/22/20 0 0
153 153 5073 Lafayette County AR 5 1/22/20 0 0
154 154 5075 Lawrence County AR 5 1/22/20 0 0
155 155 5077 Lee County AR 5 1/22/20 0 0
156 156 5079 Lincoln County AR 5 1/22/20 0 0
157 157 5081 Little River County AR 5 1/22/20 0 0
158 158 5083 Logan County AR 5 1/22/20 0 0
159 159 5085 Lonoke County AR 5 1/22/20 0 0
160 160 5087 Madison County AR 5 1/22/20 0 0
161 161 5089 Marion County AR 5 1/22/20 0 0
162 162 5091 Miller County AR 5 1/22/20 0 0
163 163 5093 Mississippi County AR 5 1/22/20 0 0
164 164 5095 Monroe County AR 5 1/22/20 0 0
165 165 5097 Montgomery County AR 5 1/22/20 0 0
166 166 5099 Nevada County AR 5 1/22/20 0 0
167 167 5101 Newton County AR 5 1/22/20 0 0
168 168 5103 Ouachita County AR 5 1/22/20 0 0
169 169 5105 Perry County AR 5 1/22/20 0 0
170 170 5107 Phillips County AR 5 1/22/20 0 0
171 171 5109 Pike County AR 5 1/22/20 0 0
172 172 5111 Poinsett County AR 5 1/22/20 0 0
173 173 5113 Polk County AR 5 1/22/20 0 0
174 174 5115 Pope County AR 5 1/22/20 0 0
175 175 5117 Prairie County AR 5 1/22/20 0 0
176 176 5119 Pulaski County AR 5 1/22/20 0 0
177 177 5121 Randolph County AR 5 1/22/20 0 0
178 178 5123 St. Francis County AR 5 1/22/20 0 0
179 179 5125 Saline County AR 5 1/22/20 0 0
180 180 5127 Scott County AR 5 1/22/20 0 0
181 181 5129 Searcy County AR 5 1/22/20 0 0
182 182 5131 Sebastian County AR 5 1/22/20 0 0
183 183 5133 Sevier County AR 5 1/22/20 0 0
184 184 5135 Sharp County AR 5 1/22/20 0 0
185 185 5137 Stone County AR 5 1/22/20 0 0
186 186 5139 Union County AR 5 1/22/20 0 0
187 187 5141 Van Buren County AR 5 1/22/20 0 0
188 188 5143 Washington County AR 5 1/22/20 0 0
189 189 5145 White County AR 5 1/22/20 0 0
190 190 5147 Woodruff County AR 5 1/22/20 0 0
191 191 5149 Yell County AR 5 1/22/20 0 0
192 192 0 Statewide Unallocated CA 6 1/22/20 0 0
193 193 6000 Grand Princess Cruise Ship CA 6 1/22/20 0 0
194 194 6001 Alameda County CA 6 1/22/20 0 0
195 195 6003 Alpine County CA 6 1/22/20 0 0
196 196 6005 Amador County CA 6 1/22/20 0 0
197 197 6007 Butte County CA 6 1/22/20 0 0
198 198 6009 Calaveras County CA 6 1/22/20 0 0
199 199 6011 Colusa County CA 6 1/22/20 0 0
200 200 6013 Contra Costa County CA 6 1/22/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
);