hospital_data
Data source: Big Local News · About: big-local-datasette
12 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Physician"
This data as json, copyable, CSV (advanced)
Suggested facets: state, county_name, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, acute_beds, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, all_beds, filed_date (date), fy_end_date (date)
Link | rowid ▼ | hospital_name | address | city | state | zip_code | county_name | phone_number | hospital_type | hospital_ownership | emergency_services | lat | lng | geocode_flag | geocode_accuracy | countyfips | statefips | statecountyfips | cbsacode | csatitle | centraloutlyingcounty | countyequivalent | hosp_lookup_url | PRVDR_NUM | RPT_REC_NUM | filed_date | fy_end_date | acute_beds | icu_beds | coronary_beds | burn_beds | surg_icu_beds | oth_spec_beds | subtotal_acute_beds | subprovider_ipf_beds | subprovider_irf_beds | subprovider_oth_beds | skilled_nursing_beds | nursing_fac_beds | oth_longterm_beds | hospice_beds | all_beds |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
576 | 576 | CORE INSTITUTE SPECIALTY HOSPITAL, THE | 6501 NORTH 19TH AVENUE | PHOENIX | AZ | 85015 | MARICOPA | (602) 795-6020 | Acute Care Hospitals | Physician | FALSE | 33.5318370 | -112.0996140 | 0 | 13 | 4 | 4013 | 38060 | Central | Maricopa County | https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j | 30108 | 659179 | 2019-06-03 | 2018-12-31 | 32 | 32 | 32 | ||||||||||||||
740 | 740 | SPECIALISTS HOSPITAL SHREVEPORT | 1500 LINE AVENUE | SHREVEPORT | LA | 71101 | CADDO | (318) 213-3800 | Acute Care Hospitals | Physician | FALSE | 32.4969260 | -93.7460460 | 0 | 17 | 22 | 22017 | 43340 | Central | Caddo Parish | https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi | 190278 | 649901 | 2019-06-03 | 2018-12-31 | 15 | 15 | 15 | ||||||||||||||
1305 | 1305 | UNITY MEDICAL CENTER | 481 INTERSTATE DRIVE | MANCHESTER | TN | 37355 | COFFEE | (931) 728-6354 | Acute Care Hospitals | Physician | TRUE | 35.4979320 | -86.0781410 | 0 | 31 | 47 | 47031 | 46100 | Central | Coffee County | https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik | 440007 | 651231 | 2019-06-03 | 2018-12-31 | 49 | 49 | 49 | ||||||||||||||
2282 | 2282 | MENIFEE GLOBAL MEDICAL CENTER | 28400 MCCALL B0ULEVARD | SUN CITY | CA | 92585 | RIVERSIDE | (951) 679-8888 | Acute Care Hospitals | Physician | FALSE | 33.7189772 | -117.1681518 | 1 | ROOFTOP | 65 | 6 | 6065 | 40140 | Los Angeles-Long Beach, CA | Central | Riverside County | https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv | 50684 | 651179 | 2019-06-03 | 2018-12-31 | 74 | 10 | 84 | 84 | |||||||||||
2285 | 2285 | HEMET VALLEY MEDICAL CENTER | 1117 EAST DEVONSHIRE | HEMET | CA | 92543 | RIVERSIDE | (951) 652-2811 | Acute Care Hospitals | Physician | TRUE | 33.7512200 | -116.9598590 | 0 | 65 | 6 | 6065 | 40140 | Los Angeles-Long Beach, CA | Central | Riverside County | https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi | 50390 | 650949 | 2019-06-03 | 2018-12-31 | 286 | 18 | 304 | 113 | 417 | |||||||||||
2532 | 2532 | MONROE SURGICAL HOSPITAL | 2408 BROADMOOR BLVD | MONROE | LA | 71201 | OUACHITA | (318) 410-0002 | Acute Care Hospitals | Physician | FALSE | 32.5367710 | -92.1022040 | 0 | 73 | 22 | 22073 | 33740 | Monroe-Ruston-Bastrop, LA | Central | Ouachita Parish | https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk | 190245 | 650140 | 2019-06-03 | 2018-12-31 | 10 | 10 | 10 | |||||||||||||
2624 | 2624 | SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH | 1503 CEDAR CREST BOULEVARD | ALLENTOWN | PA | 18104 | LEHIGH | (610) 871-9110 | Acute Care Hospitals | Physician | FALSE | 40.6121900 | -75.5327500 | 0 | 77 | 42 | 42077 | 10900 | New York-Newark, NY-NJ-CT-PA | Central | Lehigh County | https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 | 390321 | 650522 | 2019-06-03 | 2018-12-31 | 20 | 20 | 12 | 32 | ||||||||||||
3066 | 3066 | COORDINATED HEALTH ORTHOPEDIC HOSPITAL | 2310 HIGHLAND AVENUE | BETHLEHEM | PA | 18017 | NORTHAMPTON | (610) 691-4300 | Acute Care Hospitals | Physician | FALSE | 40.6737620 | -75.3654010 | 0 | 95 | 42 | 42095 | 10900 | New York-Newark, NY-NJ-CT-PA | Central | Northampton County | https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt | 390314 | 651057 | 2019-06-03 | 2018-12-31 | 20 | 20 | 20 | |||||||||||||
3191 | 3191 | SUTTER SURGICAL HOSPITAL - NORTH VALLEY | 455 PLUMAS BLVD | YUBA CITY | CA | 95991 | SUTTER | (530) 749-5700 | Acute Care Hospitals | Physician | FALSE | 39.1321670 | -121.6136030 | 0 | 101 | 6 | 6101 | 49700 | Sacramento-Roseville, CA | Central | Sutter County | https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 | 50766 | 651185 | 2019-06-03 | 2018-12-31 | 14 | 14 | 14 | |||||||||||||
3401 | 3401 | OKLAHOMA SPINE HOSPITAL | 14101 PARKWAY COMMONS DRIVE | OKLAHOMA CITY | OK | 73134 | OKLAHOMA | (405) 749-2700 | Acute Care Hospitals | Physician | TRUE | 35.6141370 | -97.5821240 | 0 | 109 | 40 | 40109 | 36420 | Oklahoma City-Shawnee, OK | Central | Oklahoma County | https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk | 370206 | 648756 | 2019-06-03 | 2018-12-31 | 23 | 23 | 23 | |||||||||||||
4475 | 4475 | DOCTORS HOSPITAL AT RENAISSANCE | 5501 SOUTH MCCOLL | EDINBURG | TX | 78539 | HIDALGO | (956) 362-8677 | Acute Care Hospitals | Physician | TRUE | 26.2524240 | -98.2041090 | 0 | 215 | 48 | 48215 | 32580 | McAllen-Edinburg, TX | Central | Hidalgo County | https://data.medicare.gov/resource/xubh-q36u/row-ie54-gr3x-shm2 | 450869 | 649837 | 2019-06-03 | 2018-12-31 | 287 | 58 | 394 | 87 | 38 | 519 | ||||||||||
4625 | 4625 | BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL | 1814 ROSELAND BOULEVARD | TYLER | TX | 75701 | SMITH | (903) 525-3300 | Acute Care Hospitals | Physician | TRUE | 32.3292480 | -95.2994670 | 0 | 423 | 48 | 48423 | 46340 | Tyler-Jacksonville, TX | Central | Smith County | https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 | 450864 | 649358 | 2019-06-03 | 2018-12-31 | 20 | 20 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [hospital_data] ( [hospital_name] TEXT, [address] TEXT, [city] TEXT, [state] TEXT, [zip_code] INTEGER, [county_name] TEXT, [phone_number] TEXT, [hospital_type] TEXT, [hospital_ownership] TEXT, [emergency_services] TEXT, [lat] TEXT, [lng] TEXT, [geocode_flag] INTEGER, [geocode_accuracy] TEXT, [countyfips] INTEGER, [statefips] INTEGER, [statecountyfips] INTEGER, [cbsacode] TEXT, [csatitle] TEXT, [centraloutlyingcounty] TEXT, [countyequivalent] TEXT, [hosp_lookup_url] TEXT, [PRVDR_NUM] INTEGER, [RPT_REC_NUM] INTEGER, [filed_date] TEXT, [fy_end_date] TEXT, [acute_beds] INTEGER, [icu_beds] TEXT, [coronary_beds] TEXT, [burn_beds] TEXT, [surg_icu_beds] TEXT, [oth_spec_beds] TEXT, [subtotal_acute_beds] INTEGER, [subprovider_ipf_beds] TEXT, [subprovider_irf_beds] TEXT, [subprovider_oth_beds] TEXT, [skilled_nursing_beds] TEXT, [nursing_fac_beds] TEXT, [oth_longterm_beds] TEXT, [hospice_beds] TEXT, [all_beds] INTEGER );