CoronavirusHospitalCapacity_metros

Table actions

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

24 rows where Geography_Type = "No clean match"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: State, Hospitals

Geography_Type ✖

  • No clean match · 24 ✖
Link rowid ▼ State Geography_Type Metro Hospitals Total Beds Estimated available beds (36% of total) Population_allages Infected_allages Severe_allages Critical_allages PatientsPerBed_allages PatientsPerAvailableBed_allages Population_60plus 60plus_PercentOfTotalPopulation Infected_60plus Severe_60plus Critical_60plus PatientsPerBed_60plus PatientsPerAvailableBed_60plus
425 425 Illinois No clean match Chicago-Naperville-Evanston, Illinois 68 19,170   No clean match                        
426 426 Illinois No clean match Elgin, Illinois 7 1,065   No clean match                        
427 427 Illinois No clean match Lake County-Kenosha County, Illinois 5 844   No clean match                        
428 428 Indiana No clean match Gary, Indiana 14 2,965   No clean match                        
429 429 Maryland No clean match Frederick-Gaithersburg-Rockville, Maryland 8 1,905   No clean match                        
430 430 Maryland No clean match Wilmington, Maryland 1 109   No clean match                        
431 431 Massachusetts No clean match Boston, Massachusetts 26 6,569   No clean match                        
432 432 Massachusetts No clean match Cambridge-Newton-Framingham, Massachusetts 19 3,934   No clean match                        
433 433 Missouri No clean match St Joseph, Missouri 1 352   No clean match                        
434 434 New Hampshire No clean match Rockingham County-Strafford County, New Hampshire 6 719   No clean match                        
435 435 New Jersey No clean match Camden, New Jersey 12 3,278   No clean match                        
436 436 New Jersey No clean match New Brunswick-Lakewood, New Jersey 21 5,086   No clean match                        
437 437 New Jersey No clean match New York-Jersey City-White Plains, New Jersey 15 4,793   No clean match                        
438 438 New Jersey No clean match Newark, New Jersey 18 5,200   No clean match                        
439 439 New Jersey No clean match Wilmington, New Jersey 2 222   No clean match                        
440 440 New York No clean match Nassau County-Suffolk County, New York 20 7,497   No clean match                        
441 441 New York No clean match New York-Jersey City-White Plains, New York 55 24,992   No clean match                        
442 442 Tennessee No clean match Chattanooga Clarksville, Tennessee 5 1921   No clean match                        
443 443 Texas No clean match Dallas-Plano-Irving, Texas 80 10,748   No clean match                        
444 444 Texas No clean match Fort Worth-Arlington-Grapevine, Texas 40 5,595   No clean match                        
445 445 Washington No clean match Olympia-Tumwater, Washington 2 401   No clean match                        
446 446 Washington No clean match Seattle-Bellevue-Kent, Washington 22 5,239   No clean match                        
447 447 Washington No clean match Tacoma-Lakewood, Washington 6 1,463   No clean match                        
448 448 Wisconsin No clean match Lake County-Kenosha County, Wisconsin 2 273   No clean match                        

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [CoronavirusHospitalCapacity_metros] (
   [State] TEXT,
   [Geography_Type] TEXT,
   [Metro] TEXT,
   [Hospitals] INTEGER,
   [Total Beds] TEXT,
   [Estimated available beds (36% of total)] INTEGER,
   [Population_allages] TEXT,
   [Infected_allages] TEXT,
   [Severe_allages] TEXT,
   [Critical_allages] TEXT,
   [PatientsPerBed_allages] TEXT,
   [PatientsPerAvailableBed_allages] TEXT,
   [Population_60plus] TEXT,
   [60plus_PercentOfTotalPopulation] TEXT,
   [Infected_60plus] TEXT,
   [Severe_60plus] TEXT,
   [Critical_60plus] TEXT,
   [PatientsPerBed_60plus] TEXT,
   [PatientsPerAvailableBed_60plus] TEXT
);