埼玉県、救命救急科の病院・クリニック一覧
18件の病院が見つかりました。(1~10件を表示)
埼玉医科大学総合医療センター
〒350-8550 埼玉県川越市鴨田辻道町1981
- 病院の診療科目
- 血管外、精(メンタルクリニック)、画像診断・核医学、放腫瘍、リウマチ・膠原病内、肝胆膵外・小外、乳腺・内泌外、形外・美外
| 経営体 | 学校法人 |
|---|---|
| 開設 | 1985/03/01 |
| 病床数 | 991床 |
18件の病院が見つかりました。(1~10件を表示)
SELECT `id`,`name` FROM `line_master` WHERE `flag`='1'AND`delete_flag`='0' ORDER BY `display_num` ASC MySQL server has gone awaySELECT `id`,`name`,`line_id` FROM `station_master` WHERE `flag`='1'AND`delete_flag`='0' ORDER BY `station_sort` DESC MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='3720100006' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='3720300002' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1120800022' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1110900001' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1121200003' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1120100013' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1122200005' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1124200004' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1121900002' MySQL server has gone awaySELECT `item_id`,`item_type` FROM `facility_item_relation` WHERE `facility_id`='1123700005' MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='11'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='11'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='37'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='11'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT * FROM `city_master` WHERE `pref_id`='37'AND`flag`='1'AND`delete_flag`='0' MySQL server has gone awaySELECT `id`,`type`,`value` FROM `facility_item_master` WHERE `flag`='1'AND`search_flag`='1'AND`delete_flag`='0' ORDER BY `display_num` DESC MySQL server has gone away
18件の病院が見つかりました。(1~10件を表示)
〒350-8550 埼玉県川越市鴨田辻道町1981
| 経営体 | 学校法人 |
|---|---|
| 開設 | 1985/03/01 |
| 病床数 | 991床 |
18件の病院が見つかりました。(1~10件を表示)