hospital_data
Data source: Big Local News · About: big-local-datasette
14 rows where "filed_date" is on date 2019-10-28 and hospital_ownership = "Proprietary"
This data as json, copyable, CSV (advanced)
Suggested facets: city, state, zip_code, county_name, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
585 | 585 | SAN RAMON REGIONAL MEDICAL CENTER | 6001 NORRIS CANYON ROAD | SAN RAMON | CA | 94583 | CONTRA COSTA | (925) 275-9200 | Acute Care Hospitals | Proprietary | TRUE | 37.7759880 | -121.9592740 | 0 | 13 | 6 | 6013 | 41860 | San Jose-San Francisco-Oakland, CA | Outlying | Contra Costa County | https://data.medicare.gov/resource/xubh-q36u/row-mpyd~xeiu_s72k | 50689 | 655752 | 2019-10-28 | 2019-05-31 | 109 | 12 | 2 | 123 | 123 | |||||||||||
1453 | 1453 | LAKEWOOD REGIONAL MEDICAL CENTER | 3700 E SOUTH ST | LAKEWOOD | CA | 90712 | LOS ANGELES | (562) 602-6751 | Acute Care Hospitals | Proprietary | TRUE | 33.8602230 | -118.1487490 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-kkpc~5uz9~2td4 | 50581 | 655750 | 2019-10-28 | 2019-05-31 | 140 | 32 | 172 | 172 | ||||||||||||
1573 | 1573 | TRISTAR SOUTHERN HILLS MEDICAL CENTER | 391 WALLACE RD | NASHVILLE | TN | 37211 | DAVIDSON | (615) 781-4000 | Acute Care Hospitals | Proprietary | TRUE | 36.0778720 | -86.7238140 | 0 | 37 | 47 | 47037 | 34980 | Nashville-Davidson--Murfreesboro, TN | Central | Davidson County | https://data.medicare.gov/resource/xubh-q36u/row-hyay~dct4~yy74 | 440197 | 655473 | 2019-10-28 | 2019-05-31 | 83 | 20 | 103 | 16 | 119 | |||||||||||
2109 | 2109 | PLACENTIA LINDA HOSPITAL | 1301 N ROSE DRIVE | PLACENTIA | CA | 92870 | ORANGE | (714) 993-2000 | Acute Care Hospitals | Proprietary | TRUE | 33.8866120 | -117.8420960 | 0 | 59 | 6 | 6059 | 31080 | Los Angeles-Long Beach, CA | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-rjmd~3mmi-4rkc | 50589 | 656051 | 2019-10-28 | 2019-05-31 | 106 | 8 | 114 | 114 | ||||||||||||
2293 | 2293 | JOHN F KENNEDY MEMORIAL HOSPITAL | 47111 MONROE STREET | INDIO | CA | 92201 | RIVERSIDE | (760) 347-6191 | Acute Care Hospitals | Proprietary | TRUE | 33.7063590 | -116.2338810 | 0 | 65 | 6 | 6065 | 40140 | Los Angeles-Long Beach, CA | Central | Riverside County | https://data.medicare.gov/resource/xubh-q36u/row-5fp5.7ptj~7ga6 | 50534 | 655749 | 2019-10-28 | 2019-05-31 | 114 | 16 | 130 | 130 | ||||||||||||
2639 | 2639 | TWIN CITIES COMMUNITY HOSPITAL | 1100 LAS TABLAS RD | TEMPLETON | CA | 93465 | SAN LUIS OBISPO | (805) 434-3500 | Acute Care Hospitals | Proprietary | TRUE | 35.5543890 | -120.7201300 | 0 | 79 | 6 | 6079 | 42020 | Central | San Luis Obispo County | https://data.medicare.gov/resource/xubh-q36u/row-9pwz~hbhx_tz4b | 50633 | 655751 | 2019-10-28 | 2019-05-31 | 104 | 18 | 122 | 122 | |||||||||||||
2827 | 2827 | HIALEAH HOSPITAL | 651 E 25TH ST | HIALEAH | FL | 33013 | MIAMI-DADE | (305) 693-6100 | Acute Care Hospitals | Proprietary | TRUE | 25.8449310 | -80.2688810 | 0 | 86 | 12 | 12086 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Miami-Dade County | https://data.medicare.gov/resource/xubh-q36u/row-q4nv.dfh5_bbrg | 100053 | 655760 | 2019-10-28 | 2019-05-31 | 331 | 21 | 10 | 362 | 362 | |||||||||||
2836 | 2836 | NORTH SHORE MEDICAL CENTER | 1100 NW 95TH ST | MIAMI | FL | 33150 | MIAMI-DADE | (305) 835-6000 | Acute Care Hospitals | Proprietary | TRUE | 25.8616580 | -80.2146560 | 0 | 86 | 12 | 12086 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Miami-Dade County | https://data.medicare.gov/resource/xubh-q36u/row-9ga8_euvm.dbmz | 100029 | 655759 | 2019-10-28 | 2019-05-31 | 660 | 58 | 18 | 748 | 748 | |||||||||||
2977 | 2977 | PIEDMONT MEDICAL CENTER | 222 S HERLONG AVE | ROCK HILL | SC | 29730 | YORK | (803) 329-1234 | Acute Care Hospitals | Proprietary | TRUE | 34.9551980 | -81.0512500 | 0 | 91 | 45 | 45091 | 16740 | Charlotte-Concord, NC-SC | Outlying | York County | https://data.medicare.gov/resource/xubh-q36u/row-ut6b.7ida_ci73 | 420002 | 655837 | 2019-10-28 | 2019-05-31 | 244 | 24 | 268 | 20 | 288 | |||||||||||
3144 | 3144 | GOOD SAMARITAN MEDICAL CENTER | 1309 N FLAGLER DR | WEST PALM BEACH | FL | 33401 | PALM BEACH | (561) 655-5511 | Acute Care Hospitals | Proprietary | TRUE | 26.7250620 | -80.0499680 | 0 | 99 | 12 | 12099 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Palm Beach County | https://data.medicare.gov/resource/xubh-q36u/row-kt9e~dq2e-y9e2 | 100287 | 655762 | 2019-10-28 | 2019-05-31 | 304 | 22 | 7 | 333 | 333 | |||||||||||
3926 | 3926 | SIERRA MEDICAL CENTER | 1625 MEDICAL CENTER DR | EL PASO | TX | 79902 | EL PASO | (915) 747-4000 | Acute Care Hospitals | Proprietary | TRUE | 31.7786700 | -106.4796500 | 0 | 141 | 48 | 48141 | 21340 | El Paso-Las Cruces, TX-NM | Central | El Paso County | https://data.medicare.gov/resource/xubh-q36u/row-af3f.cjxd.pdpu | 450668 | 655844 | 2019-10-28 | 2019-05-31 | 196 | 23 | 7 | 1 | 234 | 24 | 258 | |||||||||
3929 | 3929 | THE HOSPITALS OF PROVIDENCE MEMORIAL CAMPUS | 2001 N OREGON ST | EL PASO | TX | 79902 | EL PASO | (915) 577-6011 | Acute Care Hospitals | Proprietary | TRUE | 31.7711610 | -106.4993450 | 0 | 141 | 48 | 48141 | 21340 | El Paso-Las Cruces, TX-NM | Central | El Paso County | https://data.medicare.gov/resource/xubh-q36u/row-mwx3.k55z_dt4b | 450002 | 655841 | 2019-10-28 | 2019-05-31 | 238 | 20 | 34 | 308 | 12 | 320 | ||||||||||
4105 | 4105 | ST FRANCIS HOSPITAL | 5959 PARK AVE | MEMPHIS | TN | 38119 | SHELBY | (901) 765-1000 | Acute Care Hospitals | Proprietary | TRUE | 35.0999010 | -89.8645160 | 0 | 157 | 47 | 47157 | 32820 | Memphis-Forrest City, TN-MS-AR | Central | Shelby County | https://data.medicare.gov/resource/xubh-q36u/row-i9be.s6u9_8ayy | 440183 | 655839 | 2019-10-28 | 2019-05-31 | 278 | 37 | 10 | 325 | 39 | 29 | 393 | |||||||||
4110 | 4110 | SAINT FRANCIS BARTLETT MEDICAL CENTER | 2986 KATE BOND RD | BARTLETT | TN | 38133 | SHELBY | (901) 820-7050 | Acute Care Hospitals | Proprietary | TRUE | 35.2070340 | -89.8023470 | 0 | 157 | 47 | 47157 | 32820 | Memphis-Forrest City, TN-MS-AR | Central | Shelby County | https://data.medicare.gov/resource/xubh-q36u/row-gj83-utqb_fg87 | 440228 | 655840 | 2019-10-28 | 2019-05-31 | 114 | 32 | 10 | 156 | 156 |
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 );