COVID-19 Reported Patient Impact and Hospital Capacity by Facility

This dataset provides facility-level data for hospital utilization overall, and for COVID patients, on a weekly basis (Friday to Thursday) since July 31. The data come directly from the U.S. Department of Health and Human Services. We have not reviewed the data for accuracy.

The data is released each Monday with data for the prior week. This data was updated Mar 21, 2022.

Numbers smaller than 4 have been replaced, by HHS, with the value -999999. See the data dictionary for more details.

The 'collection_week' date is the start of a seven day period including Friday and ending and including reports for the following Thursday

Data source: U.S. Department of Health & Human Services

This database can be queried directly using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here. Read more about datasette, the technology powering these interactive queries.

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidcbsacodemetrodivisioncodecsacodecbsatitlemetropolitanmicropolitanstatismetropolitandivisiontitlecsatitlecountycountyequivalentstatenamefipsstatecodefipscountycodecentraloutlyingcounty
103 25260   546 Hanford-Corcoran, CA Metropolitan Statistical Area   Visalia-Porterville-Hanford, CA Kings County California 6 31 Central
104 17340     Clearlake, CA Micropolitan Statistical Area     Lake County California 6 33 Central
105 45000     Susanville, CA Micropolitan Statistical Area     Lassen County California 6 35 Central
107 31460   260 Madera, CA Metropolitan Statistical Area   Fresno-Madera, CA Madera County California 6 39 Central
109 46380     Ukiah, CA Micropolitan Statistical Area     Mendocino County California 6 45 Central
110 32900   382 Merced, CA Metropolitan Statistical Area   Modesto-Merced, CA Merced County California 6 47 Central
111 41500     Salinas, CA Metropolitan Statistical Area     Monterey County California 6 53 Central
112 34900   488 Napa, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Napa County California 6 55 Central
113 46020   472 Truckee-Grass Valley, CA Micropolitan Statistical Area   Sacramento-Roseville, CA Nevada County California 6 57 Central
115 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Placer County California 6 61 Central
116 40140   348 Riverside-San Bernardino-Ontario, CA Metropolitan Statistical Area   Los Angeles-Long Beach, CA Riverside County California 6 65 Central
117 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Sacramento County California 6 67 Central
118 41940   488 San Jose-Sunnyvale-Santa Clara, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA San Benito County California 6 69 Outlying
119 40140   348 Riverside-San Bernardino-Ontario, CA Metropolitan Statistical Area   Los Angeles-Long Beach, CA San Bernardino County California 6 71 Central
120 41740     San Diego-Carlsbad, CA Metropolitan Statistical Area     San Diego County California 6 73 Central
122 44700   488 Stockton-Lodi, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA San Joaquin County California 6 77 Central
123 42020     San Luis Obispo-Paso Robles-Arroyo Grande, CA Metropolitan Statistical Area     San Luis Obispo County California 6 79 Central
125 42200     Santa Maria-Santa Barbara, CA Metropolitan Statistical Area     Santa Barbara County California 6 83 Central
126 41940   488 San Jose-Sunnyvale-Santa Clara, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Santa Clara County California 6 85 Central
127 42100   488 Santa Cruz-Watsonville, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Santa Cruz County California 6 87 Central
128 39820   454 Redding, CA Metropolitan Statistical Area   Redding-Red Bluff, CA Shasta County California 6 89 Central
129 46700   488 Vallejo-Fairfield, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Solano County California 6 95 Central
130 42220   488 Santa Rosa, CA Metropolitan Statistical Area   San Jose-San Francisco-Oakland, CA Sonoma County California 6 97 Central
131 33700   382 Modesto, CA Metropolitan Statistical Area   Modesto-Merced, CA Stanislaus County California 6 99 Central
132 49700   472 Yuba City, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Sutter County California 6 101 Central
133 39780   454 Red Bluff, CA Micropolitan Statistical Area   Redding-Red Bluff, CA Tehama County California 6 103 Central
134 47300   546 Visalia-Porterville, CA Metropolitan Statistical Area   Visalia-Porterville-Hanford, CA Tulare County California 6 107 Central
135 43760     Sonora, CA Micropolitan Statistical Area     Tuolumne County California 6 109 Central
136 37100   348 Oxnard-Thousand Oaks-Ventura, CA Metropolitan Statistical Area   Los Angeles-Long Beach, CA Ventura County California 6 111 Central
137 40900   472 Sacramento--Roseville--Arden-Arcade, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Yolo County California 6 113 Outlying
138 49700   472 Yuba City, CA Metropolitan Statistical Area   Sacramento-Roseville, CA Yuba County California 6 115 Central
139 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Adams County Colorado 8 1 Central
140 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Arapahoe County Colorado 8 5 Central
141 14500   216 Boulder, CO Metropolitan Statistical Area   Denver-Aurora, CO Boulder County Colorado 8 13 Central
142 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Broomfield County Colorado 8 14 Central
143 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Clear Creek County Colorado 8 19 Outlying
144 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Denver County Colorado 8 31 Central
145 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Douglas County Colorado 8 35 Central
146 20780   233 Edwards, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Eagle County Colorado 8 37 Central
147 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Elbert County Colorado 8 39 Outlying
148 17820     Colorado Springs, CO Metropolitan Statistical Area     El Paso County Colorado 8 41 Central
149 15860   444 Cañon City, CO Micropolitan Statistical Area   Pueblo-Cañon City, CO Fremont County Colorado 8 43 Central
150 24060   233 Glenwood Springs, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Garfield County Colorado 8 45 Central
151 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Gilpin County Colorado 8 47 Outlying
152 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Jefferson County Colorado 8 59 Central
153 20420     Durango, CO Micropolitan Statistical Area     La Plata County Colorado 8 67 Central
154 22660     Fort Collins, CO Metropolitan Statistical Area     Larimer County Colorado 8 69 Central
155 44540     Sterling, CO Micropolitan Statistical Area     Logan County Colorado 8 75 Central
156 24300     Grand Junction, CO Metropolitan Statistical Area     Mesa County Colorado 8 77 Central
157 18780   525 Craig, CO Micropolitan Statistical Area   Steamboat Springs-Craig, CO Moffat County Colorado 8 81 Central
158 33940     Montrose, CO Micropolitan Statistical Area     Montrose County Colorado 8 85 Central
159 22820     Fort Morgan, CO Micropolitan Statistical Area     Morgan County Colorado 8 87 Central
160 19740   216 Denver-Aurora-Lakewood, CO Metropolitan Statistical Area   Denver-Aurora, CO Park County Colorado 8 93 Outlying
161 24060   233 Glenwood Springs, CO Micropolitan Statistical Area   Edwards-Glenwood Springs, CO Pitkin County Colorado 8 97 Outlying
162 39380   444 Pueblo, CO Metropolitan Statistical Area   Pueblo-Cañon City, CO Pueblo County Colorado 8 101 Central
163 44460   525 Steamboat Springs, CO Micropolitan Statistical Area   Steamboat Springs-Craig, CO Routt County Colorado 8 107 Central
164 14720     Breckenridge, CO Micropolitan Statistical Area     Summit County Colorado 8 117 Central
165 17820     Colorado Springs, CO Metropolitan Statistical Area     Teller County Colorado 8 119 Outlying
166 24540   216 Greeley, CO Metropolitan Statistical Area   Denver-Aurora, CO Weld County Colorado 8 123 Central
167 14860   408 Bridgeport-Stamford-Norwalk, CT Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Fairfield County Connecticut 9 1 Central
168 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Hartford County Connecticut 9 3 Central
169 45860   408 Torrington, CT Micropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA Litchfield County Connecticut 9 5 Central
170 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Middlesex County Connecticut 9 7 Central
171 35300   408 New Haven-Milford, CT Metropolitan Statistical Area   New York-Newark, NY-NJ-CT-PA New Haven County Connecticut 9 9 Central
172 35980   278 Norwich-New London, CT Metropolitan Statistical Area   Hartford-West Hartford, CT New London County Connecticut 9 11 Central
173 25540   278 Hartford-West Hartford-East Hartford, CT Metropolitan Statistical Area   Hartford-West Hartford, CT Tolland County Connecticut 9 13 Central
174 49340   148 Worcester, MA-CT Metropolitan Statistical Area   Boston-Worcester-Providence, MA-RI-NH-CT Windham County Connecticut 9 15 Central
175 20100   428 Dover, DE Metropolitan Statistical Area   Philadelphia-Reading-Camden, PA-NJ-DE-MD Kent County Delaware 10 1 Central
177 41540     Salisbury, MD-DE Metropolitan Statistical Area     Sussex County Delaware 10 5 Central
179 23540   264 Gainesville, FL Metropolitan Statistical Area   Gainesville-Lake City, FL Alachua County Florida 12 1 Central
180 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Baker County Florida 12 3 Outlying
181 37460     Panama City, FL Metropolitan Statistical Area     Bay County Florida 12 5 Central
182 37340     Palm Bay-Melbourne-Titusville, FL Metropolitan Statistical Area     Brevard County Florida 12 9 Central
184 39460   412 Punta Gorda, FL Metropolitan Statistical Area   North Port-Sarasota, FL Charlotte County Florida 12 15 Central
185 26140     Homosassa Springs, FL Metropolitan Statistical Area     Citrus County Florida 12 17 Central
186 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Clay County Florida 12 19 Central
187 34940   162 Naples-Immokalee-Marco Island, FL Metropolitan Statistical Area   Cape Coral-Fort Myers-Naples, FL Collier County Florida 12 21 Central
188 29380   264 Lake City, FL Micropolitan Statistical Area   Gainesville-Lake City, FL Columbia County Florida 12 23 Central
189 11580   412 Arcadia, FL Micropolitan Statistical Area   North Port-Sarasota, FL DeSoto County Florida 12 27 Central
190 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Duval County Florida 12 31 Central
191 37860     Pensacola-Ferry Pass-Brent, FL Metropolitan Statistical Area     Escambia County Florida 12 33 Central
192 19660   422 Deltona-Daytona Beach-Ormond Beach, FL Metropolitan Statistical Area   Orlando-Deltona-Daytona Beach, FL Flagler County Florida 12 35 Central
193 45220   533 Tallahassee, FL Metropolitan Statistical Area   Tallahassee-Bainbridge, FL-GA Gadsden County Florida 12 39 Outlying
194 23540   264 Gainesville, FL Metropolitan Statistical Area   Gainesville-Lake City, FL Gilchrist County Florida 12 41 Outlying
195 37460     Panama City, FL Metropolitan Statistical Area     Gulf County Florida 12 45 Outlying
196 48100     Wauchula, FL Micropolitan Statistical Area     Hardee County Florida 12 49 Central
197 17500     Clewiston, FL Micropolitan Statistical Area     Hendry County Florida 12 51 Central
198 45300     Tampa-St. Petersburg-Clearwater, FL Metropolitan Statistical Area     Hernando County Florida 12 53 Outlying
199 42700     Sebring, FL Metropolitan Statistical Area     Highlands County Florida 12 55 Central
200 45300     Tampa-St. Petersburg-Clearwater, FL Metropolitan Statistical Area     Hillsborough County Florida 12 57 Central
201 42680   370 Sebastian-Vero Beach, FL Metropolitan Statistical Area   Miami-Fort Lauderdale-Port St. Lucie, FL Indian River County Florida 12 61 Central
202 45220   533 Tallahassee, FL Metropolitan Statistical Area   Tallahassee-Bainbridge, FL-GA Jefferson County Florida 12 65 Outlying
203 36740   422 Orlando-Kissimmee-Sanford, FL Metropolitan Statistical Area   Orlando-Deltona-Daytona Beach, FL Lake County Florida 12 69 Outlying
204 15980   162 Cape Coral-Fort Myers, FL Metropolitan Statistical Area   Cape Coral-Fort Myers-Naples, FL Lee County Florida 12 71 Central
205 45220   533 Tallahassee, FL Metropolitan Statistical Area   Tallahassee-Bainbridge, FL-GA Leon County Florida 12 73 Central
206 35840   412 North Port-Sarasota-Bradenton, FL Metropolitan Statistical Area   North Port-Sarasota, FL Manatee County Florida 12 81 Central
207 36100     Ocala, FL Metropolitan Statistical Area     Marion County Florida 12 83 Central
208 38940   370 Port St. Lucie, FL Metropolitan Statistical Area   Miami-Fort Lauderdale-Port St. Lucie, FL Martin County Florida 12 85 Central
210 28580     Key West, FL Micropolitan Statistical Area     Monroe County Florida 12 87 Central
211 27260   300 Jacksonville, FL Metropolitan Statistical Area   Jacksonville-St. Marys-Palatka, FL-GA Nassau County Florida 12 89 Outlying
212 18880     Crestview-Fort Walton Beach-Destin, FL Metropolitan Statistical Area     Okaloosa County Florida 12 91 Central
Powered by Datasette · Queries took 3.119ms · Data source: U.S. Department of Health & Human Services