hospital_data
Data source: Big Local News · About: big-local-datasette
7 rows where csatitle = "Atlanta--Athens-Clarke County--Sandy Springs, GA" and "filed_date" is on date 2019-11-22
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, hospital_ownership, emergency_services, cbsacode, centraloutlyingcounty, coronary_beds, oth_spec_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2134 | 2134 | PIEDMONT ATHENS REGIONAL MEDICAL CENTER | 1199 PRINCE AVENUE | ATHENS | GA | 30606 | CLARKE | (706) 475-7000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.9623770 | -83.3977330 | 0 | 59 | 13 | 13059 | 12020 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Clarke County | https://data.medicare.gov/resource/xubh-q36u/row-599w-riw6~r6rq | 110074 | 659937 | 2019-11-22 | 2019-06-30 | 301 | 24 | 12 | 20 | 357 | 357 | ||||||||||
3462 | 3462 | PIEDMONT FAYETTE HOSPITAL | 1255 HIGHWAY 54 WEST | FAYETTEVILLE | GA | 30214 | FAYETTE | (770) 719-7000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.4505930 | -84.5105260 | 0 | 113 | 13 | 13113 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Fayette County | https://data.medicare.gov/resource/xubh-q36u/row-gfr6_jzg4.vm89 | 110215 | 659234 | 2019-11-22 | 2019-06-30 | 204 | 66 | 20 | 290 | 290 | |||||||||||
4461 | 4461 | MORGAN MEDICAL CENTER | 1740 LIONS CLUB ROAD | MADISON | GA | 30650 | MORGAN | (706) 342-1667 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 33.5675450 | -83.4720040 | 0 | 211 | 13 | 13211 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Outlying | Morgan County | https://data.medicare.gov/resource/xubh-q36u/row-55f2~6g7b_y7ku | 111304 | 659236 | 2019-11-22 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
4479 | 4479 | PIEDMONT NEWTON HOSPITAL | 5126 HOSPITAL DRIVE NE | COVINGTON | GA | 30014 | NEWTON | (770) 786-7053 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.6026730 | -83.8480820 | 0 | 217 | 13 | 13217 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Newton County | https://data.medicare.gov/resource/xubh-q36u/row-esav.9mwz.esp9 | 110018 | 659488 | 2019-11-22 | 2019-06-30 | 78 | 10 | 6 | 94 | 94 | |||||||||||
4494 | 4494 | PIEDMONT MOUNTAINSIDE HOSPITAL INC | 1266 HIGHWAY 515 SOUTH | JASPER | GA | 30143 | PICKENS | (706) 301-5269 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 34.4474660 | -84.4465610 | 0 | 227 | 13 | 13227 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Outlying | Pickens County | https://data.medicare.gov/resource/xubh-q36u/row-3378.2eh9-tse8 | 110225 | 659235 | 2019-11-22 | 2019-06-30 | 46 | 6 | 52 | 52 | ||||||||||||
4518 | 4518 | PIEDMONT ROCKDALE HOSPITAL | 1412 MILSTEAD AVENUE, NE | CONYERS | GA | 30012 | ROCKDALE | (770) 918-3000 | Acute Care Hospitals | Proprietary | FALSE | 33.6822390 | -84.0019410 | 0 | 247 | 13 | 13247 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Rockdale County | https://data.medicare.gov/resource/xubh-q36u/row-x66k.dxnr.f5df | 110091 | 659231 | 2019-11-22 | 2019-06-30 | 105 | 16 | 141 | 141 | ||||||||||||
4555 | 4555 | PIEDMONT WALTON HOSPITAL, INC | 2151 W SPRING STREET | MONROE | GA | 30655 | WALTON | (770) 267-8461 | Acute Care Hospitals | Proprietary | TRUE | 33.7986350 | -83.7463160 | 0 | 297 | 13 | 13297 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Walton County | https://data.medicare.gov/resource/xubh-q36u/row-ncms_jxz6_rqcg | 110046 | 659772 | 2019-11-22 | 2019-06-30 | 69 | 7 | 76 | 76 |
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 );