create_hospital.sql

/* @create_hospital.sql */

/* Data about Spanish hospitals (2015) */

/* Tabla hospital */
CREATE TABLE IF NOT EXISTS hospital (idHosp INTEGER PRIMARY KEY,
    nombre CHAR(50),
    direccion CHAR(50),
    provincia CHAR(50),
    tfno CHAR(9),
    email CHAR(100),
    titularidad BOOLEAN); /* 0 = Non Public & 1 = Public */

INSERT INTO hospital VALUES(10035, "RED DE SALUD MENTAL DE ARABA (HOSPITAL PSIQUIÁTRICO DE ÁLAVA)", "Álava, 43", "ÁLAVA", 945006555, "secretariagerencia.sma@osakidetza.net", 1);
INSERT INTO hospital VALUES(10040, "HOSPITAL SAN JOSÉ", "Beato Tomás de Zumarraga, 10", "ÁLAVA", 945140900, "diazdecorcueram@vithas.es", 0);
INSERT INTO hospital VALUES(10053, "HOSPITAL QUIRÓN VITORIA", "Esperanza, 3", "ÁLAVA", 945252500, "info.cle@usphospitales.com", 0);
INSERT INTO hospital VALUES(10066, "HOSPITAL DE CUIDADOS SAN ONOFRE, S.L. (HOSPITAL DE CUIDADOS SAN ONOFRE)", "Salvatierrabide, 9", "ÁLAVA", 945142100, "info@hospitalsanonofre.com", 0);
INSERT INTO hospital VALUES(10088, "HOSPITAL DE LEZA", "Ctra. Vitoria - Logroño, km. 59", "ÁLAVA", 945006900, "hospital.leza@osakidetza.net", 1);
INSERT INTO hospital VALUES(10090, "HOSPITAL UNIVERSITARIO DE ARABA (SEDE TXAGORRITXU Y SEDE SANTIAGO)", "José Atxotegui, s/n", "ÁLAVA", 945007000, "", 1);
INSERT INTO hospital VALUES(20019, "COMPLEJO HOSPITALARIO UNIVERSITARIO DE ALBACETE", "Hermanos Falcó, 37", "ALBACETE", 967597100, "", 1);
INSERT INTO hospital VALUES(20030, "HOSPITAL GENERAL UNIVERSITARIO DE ALBACETE", "Hermanos Falcó, 37", "ALBACETE", 967597100, "", 1);
INSERT INTO hospital VALUES(20061, "CLÍNICA SANTA CRISTINA ALBACETE", "Pérez Galdós, 7", "ALBACETE", 967223300, "", 0);
INSERT INTO hospital VALUES(20096, "HOSPITAL DE HELLÍN", "Juan Ramón Jiménez, 40", "ALBACETE", 967309500, "", 1);
INSERT INTO hospital VALUES(20100, "IDCSALUD HOSPITAL ALBACETE", "Plaza del Madroño, 11", "ALBACETE", 967247100, "albacete@idcsalud.es", 0);
INSERT INTO hospital VALUES(20117, "HOSPITAL NUESTRA SEÑORA DEL PERPETUO SOCORRO", "Seminario, 4", "ALBACETE", 967597799, "", 1);
INSERT INTO hospital VALUES(20136, "HOSPITAL GENERAL DE ALMANSA", "Avda. Adolfo Suárez, s/n", "ALBACETE", 967339526, "", 1);
INSERT INTO hospital VALUES(20147, "HOSPITAL GENERAL DE VILLAROBLEDO", "Avenida Miguel de Cervantes C/V a Ctra. El Provencio, Km. 0,3", "ALBACETE", 967133000, "", 1);
INSERT INTO hospital VALUES(20158, "CENTRO DE ATENCIÓN A LA SALUD MENTAL 'LA MILAGROSA'", "Travesía de la Igualdad, s/n", "ALBACETE", 967192350, "", 1);
INSERT INTO hospital VALUES(30015, "HOSPITAL GENERAL UNIVERSITARIO DE ALICANTE", "Av. Pintor Baeza, 12", "ALICANTE", 965933000, "", 1);
INSERT INTO hospital VALUES(30036, "CLINICA VISTAHERMOSA, S.A.", "Av. de Denia, 103", "ALICANTE", 965264200, "admon.vistahermosa@asisa.es", 0);
INSERT INTO hospital VALUES(30041, "HOSPITAL PERPETUO SOCORRO, S.A.", "Pza. Doctor Gómez Ulla, 15", "ALICANTE", 965201100, "perpetuosocorro@vithas.es", 0);
INSERT INTO hospital VALUES(30067, "HOSPITAL VIRGEN DE LOS LIRIOS", "Polígono Caramanchel, s/n", "ALICANTE", 965537400, "aracil_car@gva.es", 1);
INSERT INTO hospital VALUES(30089, "SANATORIO SAN JORGE", "Oliver, 55", "ALICANTE", 965330400, "administracion@sanatoriosanjorge.com", 0);
INSERT INTO hospital VALUES(30092, "HOSPITAL CLÍNICA BENIDORM", "Av. Alfonso Puchades, 8", "ALICANTE", 965853850, "hospital@clinicabenidorm.com", 0);
INSERT INTO hospital VALUES(30128, "POLICLÍNICO SAN CARLOS, S.L.", "Les Madrigueres sud A-14", "ALICANTE", 902300124, "central.sancarlos@policlinico-sancarlos.es", 0);
INSERT INTO hospital VALUES(30152, "HOSPITAL GENERAL UNIVERSITARIO DE ELCHE", "Camí de L´Amàssera, 11", "ALICANTE", 966616900, "", 1);
INSERT INTO hospital VALUES(30165, "HOSPITAL GENERAL UNIVERSITARIO DE ELDA-VIRGEN DE LA SALUD", "Ctra. Elda a Sax, s/n", "ALICANTE", 966989000, "", 1);
INSERT INTO hospital VALUES(30187, "HOSPITAL  SANT VICENT DEL RASPEIG", "Lillo Juan, 137", "ALICANTE", 965907700, "hospitalsanvicente@gva.es", 1);
INSERT INTO hospital VALUES(30190, "SANATORIO SAN FRANCISCO DE BORJA 'FONTILLES'", "Ctra. Orba-Vall de Laguart, km. 4 (Fontilles)", "ALICANTE", 965583350, "fontilles@fontilles.org", 0);
INSERT INTO hospital VALUES(30204, "HOSPITAL DE LA MARINA BAIXA DE LA VILA JOIOSA", "Av. Alcalde en Jaume Botella Mayor, 7", "ALICANTE", 966859800, "marques_jua@gva.es", 1);
INSERT INTO hospital VALUES(30211, "HOSPITAL VEGA BAJA DE ORIHUELA", "Ctra. Orihuela-Almoradi, s/n", "ALICANTE", 965877500, "", 1);
INSERT INTO hospital VALUES(30226, "HOSPITAL INTERNACIONAL MEDIMAR S.A.", "Av. de Denia, 78", "ALICANTE", 965162200, "egonzalez@hospitalmedimar.com", 0);
INSERT INTO hospital VALUES(30232, "HOSPITAL PSIQUIÁTRICO PENITENCIARIO", "Polígono Pla de la Vallonga, s/n", "ALICANTE", 965102222, "director.alicantep@dgip.mir.es", 1);
INSERT INTO hospital VALUES(30250, "HOSPITAL UNIVERSITARIO SAN JUAN DE ALICANTE", "Ctra. Alicante-Valencia s/n", "ALICANTE", 965169400, "fernandez_asu@gva.es", 1);
INSERT INTO hospital VALUES(30298, "USP HOSPITAL SAN JAIME", "Partida de la Loma, s/n", "ALICANTE", 966921313, "antonio.domenech@quiron.es", 0);
INSERT INTO hospital VALUES(30317, "CLÍNICA CAZORLA", "Hogar Provincial, 12", "ALICANTE", 965160774, "info@clinicacazorla.com", 0);
INSERT INTO hospital VALUES(30328, "HOSPITAL IMED LEVANTE", "Dr. Ramón y Cajal, 7", "ALICANTE", 966878787, "ffiestras@imedhospitales.com", 0);
INSERT INTO hospital VALUES(30339, "HOSPITAL DE TORREVIEJA (*)", "Ctra. Torrevieja a San Miguel de Salinas Cv 95 Partida La Ceñuela", "ALICANTE", 965721200, "javelasco@torrevieja-salud.com", 1);
INSERT INTO hospital VALUES(30340, "HOSPITAL DE DENIA (*)", "Pda. Beniadlá, s/n", "ALICANTE", 966429000, "", 1);
INSERT INTO hospital VALUES(30351, "HOSPITAL LA PEDRERA", "Ptda. Plana d'Est, 4", "ALICANTE", 965579700, "", 1);
INSERT INTO hospital VALUES(30362, "CENTRO DE REHABILITACIÓN NEUROLÓGICA CASAVERDE", "Ponent, 15", "ALICANTE", 965950711, "direccion.muchamiel@grupocasaverde.com", 0);
INSERT INTO hospital VALUES(30373, "HOSPITAL UNIVERSITARIO VINALOPO (*)", "Tonico Sansano Mora, 14", "ALICANTE", 966679800, "narques@vinaloposalud.com", 1);
INSERT INTO hospital VALUES(30384, "HOSPITAL PRIVADO IMED ELCHE", "Max Planck, s/n", "ALICANTE", 966915151, "ffiestras@imedhospitales.com", 0);
INSERT INTO hospital VALUES(40010, "HOSPITAL TORRECÁRDENAS", "Paraje de Torrecárdenas, s/n", "ALMERÍA", 950016114, "", 0);
INSERT INTO hospital VALUES(40031, "HOSPITAL CRUZ ROJA DE ALMERÍA", "Ctra. de Ronda, km. 196", "ALMERÍA", 950017400, "", 0);
INSERT INTO hospital VALUES(40046, "HOSPITAL PROVINCIAL", "Pza. de San Luis, s/n", "ALMERÍA", 950017601, "", 0);
INSERT INTO hospital VALUES(40059, "SANATORIO VIRGEN DEL MAR", "Ctra. del Mamí, km. 1", "ALMERÍA", 950210100, "virgendelmar@vithas.es", 0);
INSERT INTO hospital VALUES(40084, "HOSPITAL COMARCAL LA INMACULADA", "Av. Dra. Ana Parra, s/n", "ALMERÍA", 950029176, "h.inmaculada.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(40097, "COMPLEJO HOSPITALARIO DE ESPECIALIDADES TORRECÁRDENAS", "Paraje de Torrecárdenas, s/n", "ALMERÍA", 950016114, "", 0);
INSERT INTO hospital VALUES(40101, "CLÍNICA MEDITERRÁNEO", "Nueva Musa, s/n", "ALMERÍA", 950621063, "jarojas@asisa.es", 0);
INSERT INTO hospital VALUES(40118, "COMPLEJO HOSPITALARIO DE PONIENTE (*)", "Crta. de Almerimar, s/n", "ALMERÍA", 950022568, "sugerencias@ephpo.es", 0);
INSERT INTO hospital VALUES(40127, "HOSPITAL DE ALTA RESOLUCION EL TOYO", "Camino de La Botica s/n. Retamar", "ALMERÍA", 950158015, "sugerencias@ephpo.es", 1);
INSERT INTO hospital VALUES(50013, "HOSPITAL NUESTRA SEÑORA DE SONSOLES", "Av. Juan Carlos I, s/n", "ÁVILA", 920358000, "gerente.hnss@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(50034, "HOSPITAL PROVINCIAL DE ÁVILA", "Jesús del Gran Poder, 42", "ÁVILA", 920357200, "gerente.hnss@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(50049, "CLÍNICA SANTA TERESA", "Av.Santa Cruz de Tenerife, 11", "ÁVILA", 920252525, "direccion@clinicasantateresa.es", 0);
INSERT INTO hospital VALUES(50061, "COMPLEJO ASISTENCIAL DE AVILA", "Avda. Juan Carlos I, s/n", "ÁVILA", 920358000, "gerente.hnss@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(60016, "COMPLEJO H. UNIVERSITARIO DE BADAJOZ*", "Av. de Elvas, s/n", "BADAJOZ", 924218100, "admision.hifc@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(60021, "HOSPITAL INFANTA CRISTINA", "Av. de Elvas, s/n", "BADAJOZ", 924218100, "admision.hifc@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(60037, "HOSPITAL MATERNO INFANTIL", "La Violeta, 1", "BADAJOZ", 924215000, "", 1);
INSERT INTO hospital VALUES(60080, "HOSPITAL 'FUNDACIÓN SAN JUAN DE DIOS DE EXTREMADURA'", "Paseo de la Piedad, 5", "BADAJOZ", 924670017, "marian.torrado@sjd.es", 0);
INSERT INTO hospital VALUES(60093, "HOSPITAL DON BENITO-VILLANUEVA DE LA SERENA", "Ctra. Don Benito-Villanueva de la Serena, km. 3", "BADAJOZ", 924386800, "silvia.sanchezv@gobex.es", 1);
INSERT INTO hospital VALUES(60114, "HOSPITAL GENERAL DE LLERENA", "Avda. Dr. Fleming, s/n", "BADAJOZ", 924877000, "dirmedllerena.hllz@ses.juntaex.es", 1);
INSERT INTO hospital VALUES(60129, "HOSPITAL DE MÉRIDA", "Polígono Nueva Ciudad, s/n", "BADAJOZ", 924381002, "julian.garciam@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(60135, "CENTRO SOCIOSANITARIO DE MÉRIDA (*)", "Ctra. Valverde-Mérida, km. 2", "BADAJOZ", 924388081, "csanitario.merida@gobex.es", 0);
INSERT INTO hospital VALUES(60140, "HOSPITAL SANTA JUSTA", "Concepción, 24", "BADAJOZ", 924840746, "", 0);
INSERT INTO hospital VALUES(60172, "IDCSALUD CLIDEBA", "Eladio Salinero de los Santos, 6", "BADAJOZ", 924229050, "clideba@idcsalud.es", 0);
INSERT INTO hospital VALUES(60188, "ZAFRA SALUD", "Ctra. de los Sántos, s/n", "BADAJOZ", 924552755, "", 0);
INSERT INTO hospital VALUES(60208, "HOSPITAL DE ZAFRA", "Antigua Crtra. Nacional 432", "BADAJOZ", 924029200, "francisco.martinez@ses.gobex.es", 1);
INSERT INTO hospital VALUES(60219, "COMPLEJO HOSPITALARIO LLERENA-ZAFRA", "Avda. Dr. Fleming, s/n", "BADAJOZ", 924877000, "francisco.martinez@ses.gobex.es", 1);
INSERT INTO hospital VALUES(60220, "HOSPITAL PERPETUO SOCORRO", "Av. Damián Téllez Lafuente s/n", "BADAJOZ", 924215000, "", 1);
INSERT INTO hospital VALUES(60231, "HOSPITAL SIBERIA-SERENA", "Crtra Talarrubias-Agudo Km2", "BADAJOZ", 924648100, "felix.miranda@ses.gobex.es", 1);
INSERT INTO hospital VALUES(60242, "HOSPITAL TIERRA DE BARROS", "Crta. Nal 630, km 654,300", "BADAJOZ", 924699200, "", 1);
INSERT INTO hospital VALUES(60253, "COMPLEJO H. DON BENITO-VVA DE LA SERENA", "Avda. Alonso Martín, 8", "BADAJOZ", 924382800, "gerente.donbenito@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(60264, "COMPLEJO HOSPITALARIO DEL ÁREA DE SALUD DE MÉRIDA", "Polígono Nueva Ciudad, s/n", "BADAJOZ", 924381000, "julian.garciam@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(60275, "CENTRO DE REHABILITACIÓN NEUROLÓGICO DE EXTREMADURA", "Avda. Adolfo Suárez González, 56", "BADAJOZ", 924380330, "direccion.merida@grupocasaverde.com", 0);
INSERT INTO hospital VALUES(60286, "CLINICA EXTREMEÑA DE SALUD", "Federico Mayor Zaragoza s/n", "BADAJOZ", 924211818, "", 0);
INSERT INTO hospital VALUES(70048, "HOSPITAL GENERAL DE MALLORCA", "Pza del Hospital, 3", "ILLES BALEARS", 971212400, "arecober@gesma.caib.es", 1);
INSERT INTO hospital VALUES(70051, "HOSPITAL PSIQUIÀTRIC", "Camí de Jesús, 40", "ILLES BALEARS", 971212400, "arecober@gesma.caib.es", 1);
INSERT INTO hospital VALUES(70064, "CLÍNICA MUTUA BALEAR", "Obispo Campins, 4", "ILLES BALEARS", 971213400, "mutuabalear@mutuabalear.es", 0);
INSERT INTO hospital VALUES(70070, "HOSPITAL DE LA CRUZ ROJA ESPAÑOLA", "Pons y Gallarza, 90", "ILLES BALEARS", 971751445, "", 0);
INSERT INTO hospital VALUES(70086, "HOSPITAL SANT JOAN DE DEU", "Sant Joan de Déu, 7", "ILLES BALEARS", 971265854, "hsjdpalma@ohsjd.es", 0);
INSERT INTO hospital VALUES(70099, "SANITARIA BALEAR, SA. (CLINICA ROTGER)", "Santiago Russiñol, 9", "ILLES BALEARS", 971448500, "info@clinicarotger.es", 0);
INSERT INTO hospital VALUES(70110, "CLINICA JUANEDA", "Company, 30", "ILLES BALEARS", 971221257, "info@clinicajuaneda.es", 0);
INSERT INTO hospital VALUES(70131, "POLICLINICA MIRAMAR (AMEBA S.A.)", "Camino de La Vileta, 30", "ILLES BALEARS", 971767000, "amas@policlinicamiramar.com", 0);
INSERT INTO hospital VALUES(70162, "HOSPITAL JOAN MARCH", "Ctra. de Bunyola, km. 12", "ILLES BALEARS", 971212400, "erecober@gesma.caib.es", 1);
INSERT INTO hospital VALUES(70184, "HOSPITAL CAN MISSES", "Corona, s/n", "ILLES BALEARS", 971397000, "", 1);
INSERT INTO hospital VALUES(70197, "HOSPITAL RESIDENCIA ASISTIDA CAS SERRES", "Cosme Vidal Llaser, 27. Barrio Cas Serres", "ILLES BALEARS", 971392960, "mjmari@conselldelvissa.es", 1);
INSERT INTO hospital VALUES(70201, "POLICLÍNICA NUESTRA SEÑORA DEL ROSARIO, S.A.", "Vía Romana, s/n", "ILLES BALEARS", 971301916, "grupopoliclinica@grupopoliclinica.com", 0);
INSERT INTO hospital VALUES(70244, "CLINICA SALUS MENORCA S.L", "Canonge Moll, s/n", "ILLES BALEARS", 971480505, "info@juanedamenorca.es", 0);
INSERT INTO hospital VALUES(70260, "HOSPITAL GENERAL DE MURO", "Veler, 1. Playa de Muro", "ILLES BALEARS", 971891900, "contabilidad@hgm.es", 0);
INSERT INTO hospital VALUES(70295, "POLICLÍNICA VIRGEN DE GRACIA", "Av. Vives LLull, 6", "ILLES BALEARS", 971351115, "administracion@juanedamenorca.es", 0);
INSERT INTO hospital VALUES(70309, "HOSPITAL MANACOR (*)", "Crta. Manacor-Alcudia, s/n", "ILLES BALEARS", 971847000, "gerencia@hmanacor.org", 1);
INSERT INTO hospital VALUES(70333, "HOSPITAL SON LLATZER (*)", "Ctra. Manacor, Km.4", "ILLES BALEARS", 871202000, "", 1);
INSERT INTO hospital VALUES(70344, "HOSPITAL QUIRÓN PALMAPLANAS", "Camí dels Reis, 308", "ILLES BALEARS", 971918000, "info.pln@palmaplanas.com", 0);
INSERT INTO hospital VALUES(70366, "HOSPITAL DE FORMENTERA", "Venda des Brolls, s/n", "ILLES BALEARS", 971321212, "ygomez@asef.es", 1);
INSERT INTO hospital VALUES(70377, "FUNDACION HOSPITAL COMARCAL D'INCA (*)", "Crtra Vella de Llubi, s/n", "ILLES BALEARS", 971888514, "", 1);
INSERT INTO hospital VALUES(70388, "HOSPITAL MATEU ORFILA", "Ronda Malbúger, 1", "ILLES BALEARS", 971487000, "gerencia@hgmo.es", 1);
INSERT INTO hospital VALUES(70399, "HOSPITAL UNIVERSITARI SON ESPASES", "Carretera Valdemossa, 79", "ILLES BALEARS", 871205000, "", 1);
INSERT INTO hospital VALUES(70412, "HOSPITAL DE LLEVANT", "Escamarlá, 6  (Porto Cristo)", "ILLES BALEARS", 971822400, "msoteras@hllevant.com", 0);
INSERT INTO hospital VALUES(70423, "HOSPITAL CLINIC BALEAR", "Paseo  Arbreda  s/n", "ILLES BALEARS", 971443030, "", 0);
INSERT INTO hospital VALUES(80044, "HOSPITAL CLÍNIC I PROVINCIAL DE BARCELONA, SEU SABINO DE ARANA", "Sabino Arana, 1", "BARCELONA", 932275600, "asalgot@medicina.ub.es", 1);
INSERT INTO hospital VALUES(80057, "HOSPITAL DEL MAR", "Passeig Marítim de la Barceloneta, 25", "BARCELONA", 932483000, "jvarela@imas.imim.es", 1);
INSERT INTO hospital VALUES(80060, "HOSPITAL DE L´ESPERANÇA", "Sant Josep de la Muntanya  12", "BARCELONA", 933674100, "jvalera@imas.imim.es", 1);
INSERT INTO hospital VALUES(80109, "HOSPITAL CLÍNIC I PROVINCIAL DE BARCELONA", "Villarroel, 170", "BARCELONA", 932275400, "asalgot@medicina.ub.es", 1);
INSERT INTO hospital VALUES(80116, "HOSPITAL FREMAP BARCELONA", "Madrazo, 8", "BARCELONA", 934169100, "admision_barcelona@fremap.es", 0);
INSERT INTO hospital VALUES(80137, "CENTRE DE PREVENCIÓ I REHABILITACIÓ ASEPEYO", "Av. Alcalde Barnils, 54-60", "BARCELONA", 935653900, "asepeyo@asepeyo.es", 0);
INSERT INTO hospital VALUES(80142, "CLÍNICA MC COPÈRNIC", "Copèrnic, 58", "BARCELONA", 934141992, "info@mc-mutual.com", 0);
INSERT INTO hospital VALUES(80155, "CLÍNICA MC Londres", "Cr. Londres, 28-38", "BARCELONA", 934577200, "info@mc-mutual.com", 0);
INSERT INTO hospital VALUES(80168, "CLÍNICA SUMA BCN (SAN HONORAT)", "Av. Tibidabo, 20", "BARCELONA", 932127000, "", 0);
INSERT INTO hospital VALUES(80174, "HOSPITAL DOS DE MAIG", "Dos de Maig, 301", "BARCELONA", 935072700, "gerencia.bcn@consorcicreuroja.es", 1);
INSERT INTO hospital VALUES(80180, "CLÍNICA DEL PILAR", "Balmes, 271", "BARCELONA", 932360500, "info@clinicadelpilar.org", 0);
INSERT INTO hospital VALUES(80214, "HOSPITAL SANT RAFAEL", "Passeig Vall D'Hebron, 107", "BARCELONA", 932112508, "hsrafael@comb.es", 0);
INSERT INTO hospital VALUES(80229, "CLÍNICA NOSTRA SENYORA DEL REMEI", "Escorial, 148", "BARCELONA", 932850010, "clinica.remedio@irsjg.org", 0);
INSERT INTO hospital VALUES(80235, "CLÍNICA SAGRADA FAMILIA", "Torras I Pujalt, 1", "BARCELONA", 932122300, "info@clinicasagradafamilia.com", 0);
INSERT INTO hospital VALUES(80253, "HOSPITAL MARE DE DÉU DE LA MERCÈ", "Passeig Universal, 34", "BARCELONA", 934275250, "administracion@hhscjmerced.com", 0);
INSERT INTO hospital VALUES(80266, "CLÍNICA SOLARIUM", "Ticià, 21", "BARCELONA", 934172007, "", 0);
INSERT INTO hospital VALUES(80291, "HOSPITAL DE LA SANTA CREU I SANT PAU", "Sant Antoni Maria Claret, 167", "BARCELONA", 935537160, "", 0);
INSERT INTO hospital VALUES(80312, "NOU HOSPITAL EVANGÈLIC", "Camèlies, 15", "BARCELONA", 932859955, "heablanco@hospitalevangelic.com", 0);
INSERT INTO hospital VALUES(80327, "HOSPITAL DE NENS DE BARCELONA", "Consell de Cent, 437", "BARCELONA", 932310512, "", 0);
INSERT INTO hospital VALUES(80333, "INSTITUT GUTTMANN", "Cami Can Ruti, s/n", "BARCELONA", 934977700, "gerencia@guttmann.com", 0);
INSERT INTO hospital VALUES(80348, "FUNDACIÓ PUIGVERT-IUNA", "Cartagena, 340", "BARCELONA", 934169700, "dirgeneral@fundacio-puigvert.es", 0);
INSERT INTO hospital VALUES(80351, "CENTRE SOCIOSANITARI PALAU", "Sant Antoni M. Claret, 135", "BARCELONA", 934501819, "secretaria@csspalau.com", 0);
INSERT INTO hospital VALUES(80364, "CAPIO HOSPITAL UNIVERSITARI SAGRAT COR", "Viladomat, 288", "BARCELONA", 933221111, "gerencia@hscor.com", 0);
INSERT INTO hospital VALUES(80370, "CLÍNICA CORACHAN, S.A.", "Buïgas, 19", "BARCELONA", 932545800, "", 0);
INSERT INTO hospital VALUES(80386, "CLÍNICA TRES TORRES", "Doctor Roux, 76", "BARCELONA", 932041300, "info@clinicatrestorres.com", 0);
INSERT INTO hospital VALUES(80399, "HOSPITAL QUIRÓN", "Pç. Alfons Comín 7-8", "BARCELONA", 932850000, "direccion.cqb@quiron.es", 0);
INSERT INTO hospital VALUES(80403, "CENTRE MÈDIC DELFOS, S.A.", "Av. Vallcarca, 151", "BARCELONA", 932545000, "comunicació@delfos.cat", 0);
INSERT INTO hospital VALUES(80410, "CENTRE MÈDIC SANT JORDI DE SANT ANDREU, S.A.", "Pç. Estació, 12", "BARCELONA", 933451604, "clinicasantjordi@csantjordi.com", 0);
INSERT INTO hospital VALUES(80431, "HOSPITAL PLATÓ", "Plató, 21", "BARCELONA", 933069900, "hospital@hospitalplato.com", 0);
INSERT INTO hospital VALUES(80446, "HOSPITAL  UNIVERSITARI QUIRÓN DEXEUS", "Sabino de Arana, 5-19", "BARCELONA", 932274747, "informacion@idexeus.es", 0);
INSERT INTO hospital VALUES(80478, "CENTRO MEDICO TEKNON", "Vilana, 12", "BARCELONA", 932906200, "info@teknon.es", 0);
INSERT INTO hospital VALUES(80484, "HOSPITAL DE BARCELONA", "Av. Diagonal, 656", "BARCELONA", 932542400, "", 0);
INSERT INTO hospital VALUES(80497, "POLICLÍNICA BARCELONA", "Guillem Tell, 4", "BARCELONA", 934161616, "", 0);
INSERT INTO hospital VALUES(80538, "CENTRE D'OFTALMOLOGIA BARRAQUER", "Muntaner, 314", "BARCELONA", 932095311, "info@barraquer.com", 0);
INSERT INTO hospital VALUES(80543, "FUNDACIÓ SOCIOSANITÀRIA DE BARCELONA", "Av. Gran Via, 203", "BARCELONA", 934170400, "direccio@fssbcn.org", 0);
INSERT INTO hospital VALUES(80556, "SERVEIS CLÍNICS, S.A.", "García Mariño, 4", "BARCELONA", 934174602, "administracion@serviciosclinicos.com", 0);
INSERT INTO hospital VALUES(80575, "CLÍNICA COROLEU", "Coroleu, 50", "BARCELONA", 931165500, "coroleu@clinicacoroleu.org", 0);
INSERT INTO hospital VALUES(80581, "CLÍNICA BARCELONETA", "Pescadors, 88", "BARCELONA", 932214700, "msanchez@blauclinic.cat", 0);
INSERT INTO hospital VALUES(80641, "CLÍNICA PLANAS", "Pere II de Montcada, 16", "BARCELONA", 932032812, "doctor@clinica-planas.com", 0);
INSERT INTO hospital VALUES(80667, "HOSPITAL UNIVERSITARI GERMANS TRIAS I PUJOL DE BADALONA", "Ct. Canyet, s/n", "BARCELONA", 934651200, "gerencia.germanstrias@gencat.net", 1);
INSERT INTO hospital VALUES(80673, "HOSPITAL MUNICIPAL DE BADALONA", "Via Augusta, 9", "BARCELONA", 934648300, "", 0);
INSERT INTO hospital VALUES(80689, "CENTRE SOCIOSANITARI EL CARME", "Cami Sant Jeroni de la Murtra, 60", "BARCELONA", 935074710, "", 0);
INSERT INTO hospital VALUES(80692, "HOSPITAL COMARCAL DE SANT BERNABÉ", "Crtra de Ribes, s/n", "BARCELONA", 938243400, "hsb@hsb.es", 0);
INSERT INTO hospital VALUES(80706, "HOSPITAL COMARCAL SANT JAUME DE CALELLA", "Sant Jaume, 209-217", "BARCELONA", 937690201, "", 1);
INSERT INTO hospital VALUES(80713, "HOSPITAL DE SANT JOAN DE DÉU", "Passeig Sant Joan de Déu, 2", "BARCELONA", 932804000, "mcastillo@hsjdbcn.org", 0);
INSERT INTO hospital VALUES(80728, "CLÍNICA NOSTRA SENYORA DE GUADALUPE", "Francesc Moragas, 2", "BARCELONA", 934702970, "", 0);
INSERT INTO hospital VALUES(80734, "HOSPITAL GENERAL DE GRANOLLERS", "Cr. Francesc Ribas, s/n", "BARCELONA", 938425000, "dgeneral@fhgranollers.com", 0);
INSERT INTO hospital VALUES(80752, "HOSPITAL UNIVERSITARI DE BELLVITGE", "Feixa Llarga, s/n", "BARCELONA", 933357011, "ger@csub.scs.es", 1);
INSERT INTO hospital VALUES(80771, "HOSPITAL GENERAL DE L´HOSPITALET", "Av. Josep Molins, 29", "BARCELONA", 934407500, "josep.casademont@chcr.scs.es", 1);
INSERT INTO hospital VALUES(80787, "FUNDACIÓ SANITÀRIA SANT JOSEP", "Carme Verdaguer, 56", "BARCELONA", 938032650, "info@fssj.es", 0);
INSERT INTO hospital VALUES(80826, "HOSPITAL DE SANT JAUME", "Crtra D'OLot, 7", "BARCELONA", 938506565, "gerencia@hospitalmanlleu.com", 1);
INSERT INTO hospital VALUES(80832, "CLÍNICA SANT JOSEP", "Caputxins, 16", "BARCELONA", 938744050, "clinicasantjosep@althaia.cat/cimetir@a", 0);
INSERT INTO hospital VALUES(80850, "CENTRE HOSPITALARI", "Av. Bases de Manresa, 6-8", "BARCELONA", 938732550, "chucm@chucm.org", 0);
INSERT INTO hospital VALUES(80863, "HOSPITAL DE SANT JOAN DE DÉU", "Dr. Joan Soler, 1-3", "BARCELONA", 938732550, "hosp.g.man@hgm.scs.es", 0);
INSERT INTO hospital VALUES(80879, "HOSPITAL DE SANT ANDREU", "Remei de Dalt, 3", "BARCELONA", 938743312, "", 0);
INSERT INTO hospital VALUES(80885, "GERMANES HOSPITALÀRIES. HOSPITAL SAGRAT COR", "Av. Comte de Llobregat, 117", "BARCELONA", 937752200, "scormart@comb.es", 0);
INSERT INTO hospital VALUES(80898, "FUNDACIÓ HOSPITAL SANT JOAN DE DÉU", "Av. Mancomunitats Comarcals, 1", "BARCELONA", 937742020, "gerencia@hmartorell.es", 0);
INSERT INTO hospital VALUES(80930, "CENTRE MÈDIC MOLINS, SL", "Passeig del Terraplè, 97", "BARCELONA", 936680004, "", 0);
INSERT INTO hospital VALUES(80945, "HOSPITAL DE MOLLET", "RD Pinetons, 6-8", "BARCELONA", 935760300, "hmolldir@ctv.es", 0);
INSERT INTO hospital VALUES(80958, "HOSPITAL DE SABADELL", "Parc Taulí, s/n", "BARCELONA", 937231010, "direcciógeneral@cspt.es", 1);
INSERT INTO hospital VALUES(80977, "BENITO MENNI,COMPLEX ASSISTENCIAL EN SALUT MENTAL", "Dr. Antoni Pujadas, 38", "BARCELONA", 936402400, "hospital@hsc-bmennibcn.org", 0);
INSERT INTO hospital VALUES(80983, "PARC SANITARI SANT JOAN DE DÉU - RECINTE SANT BOI", "Dr. Antoni Pujadas, 42", "BARCELONA", 936406350, "", 0);
INSERT INTO hospital VALUES(80996, "PARC SANITARI SANT JOAN DE DÉU - HOSPITAL GENERAL", "CM Vell de la Colònia, 25", "BARCELONA", 936615208, "hsantboi@hsantboi.es", 0);
INSERT INTO hospital VALUES(81000, "HOSPITAL DE SANT CELONI", "Av. de L' Hospital, 19", "BARCELONA", 938670617, "secretaria@hsceloni.es", 0);
INSERT INTO hospital VALUES(81017, "HOSPITAL GENERAL DE CATALUNYA", "Pedro i Pons, 1", "BARCELONA", 935656000, "hgc@hgc.es", 0);
INSERT INTO hospital VALUES(81022, "CASAL DE CURACIÓ", "María Vidal, 19", "BARCELONA", 937590241, "curacio@suport.org", 0);
INSERT INTO hospital VALUES(81038, "HOSPITAL RESIDÈNCIA SANT CAMIL - CONSORCI SANITARI DEL GARRAF", "Ronda Sant Camil, s/n", "BARCELONA", 938960025, "santcamil@hrsantcamil.es", 1);
INSERT INTO hospital VALUES(81056, "CENTRES ASSISTENCIALS DR. EMILI MIRA I LÓPEZ (RECINTE TORRIBERA)", "Av. Prat de la Riba, 171", "BARCELONA", 934628926, "g.torribera@diba.es", 1);
INSERT INTO hospital VALUES(81069, "FUNDACIÓ HOSPITAL DE L'ESPERIT SANT", "Av. Mossèn Josep Pons i Robadà, S/N", "BARCELONA", 933869648, "mesteva@hes.scs.es/ hesperitsant@hes.sc", 0);
INSERT INTO hospital VALUES(81075, "HOSPITAL DE TERRASSA", "Ct. Torrebonica, s/n", "BARCELONA", 937310007, "csdt@csdt.es", 1);
INSERT INTO hospital VALUES(81081, "HOSPITAL DE SANT LLÀTZER", "Pl. Dr Robert , 1", "BARCELONA", 937837111, "", 1);
INSERT INTO hospital VALUES(81094, "HOSPITAL UNIVERSITARI MÚTUA DE TERRASSA", "PL. Doctor Robert, 5", "BARCELONA", 937365050, "gerencimutua@mutuaterrassa.es", 0);
INSERT INTO hospital VALUES(81108, "HOSPITAL GENERAL DE VIC", "Francesc Pla 'El Vigata', 1", "BARCELONA", 938891111, "gerencia@hgv.es", 1);
INSERT INTO hospital VALUES(81115, "CLÍNICA SANT JOSEP", "Sant Segimon, 3", "BARCELONA", 938861700, "", 0);
INSERT INTO hospital VALUES(81120, "HOSPITAL DE LA SANTA CREU", "Rambla Hospital, 52", "BARCELONA", 938833300, "sjuridica@chv.cat", 0);
INSERT INTO hospital VALUES(81136, "CLÍNICA DE VIC", "Ronda Francesc Camprodon, 4", "BARCELONA", 938816500, "clinivic@mundivia.es", 1);
INSERT INTO hospital VALUES(81141, "HOSPITAL DE VILADECANS", "Av Gavà, 38", "BARCELONA", 936590111, "gerencia@hv.scs.es", 1);
INSERT INTO hospital VALUES(81189, "HOSPITAL SANT ANTONI ABAT - CONSORCI SANITARI DEL GARRAF", "Sant Josep, 21", "BARCELONA", 938931616, "fhcaa@retemail.es", 1);
INSERT INTO hospital VALUES(81192, "CENTRE SOCIOSANITARI CAN TORRAS", "Ct. El Masnou a Alella, 1", "BARCELONA", 935551994, "", 0);
INSERT INTO hospital VALUES(81213, "CENTRE GERIÀTRIC DEL MARESME", "Lepant, 13-21", "BARCELONA", 937965003, "", 0);
INSERT INTO hospital VALUES(81228, "PRYTANIS SANT BOI CENTRE SOCIOSANITARI", "Josep Torras i Bages, 55", "BARCELONA", 936300931, "prytanis@prytanisresidencial.es", 0);
INSERT INTO hospital VALUES(81234, "CENTRE SOCIOSANITARI VERGE DEL PUIG", "Campins, 37", "BARCELONA", 938673995, "residencia@hsceloni.cat", 0);
INSERT INTO hospital VALUES(81287, "RESIDÈNCIA L'ESTADA", "Cami de la masía, s/n", "BARCELONA", 937926612, "estada@lestada.com", 0);
INSERT INTO hospital VALUES(81304, "RESIDÈNCIA PUIG-REIG", "Llobregat, 75", "BARCELONA", 938380045, "cassbenefica2@logiccontrol.es", 0);
INSERT INTO hospital VALUES(81311, "RESIDÈNCIA SANTA SUSANNA", "Font i Boet, 16", "BARCELONA", 938654994, "", 0);
INSERT INTO hospital VALUES(81326, "HOSPITAL DE MATARÓ", "Ct. Cirera, s/n", "BARCELONA", 937417700, "administrador@csm.scs.es", 1);
INSERT INTO hospital VALUES(81347, "HOSPITAL UNIVERSITARI VALL D'HEBRON", "Ps Vall d'Hebron, 119-129", "BARCELONA", 934894524, "", 1);
INSERT INTO hospital VALUES(81350, "CENTRE POLIVALENT CAN FOSC", "Ct. de Llerona, s/n", "BARCELONA", 938432786, "", 0);
INSERT INTO hospital VALUES(81379, "HOSPITAL SOCIOSANITARI MUTUAM GÜELL", "Mare de Déu de la Salut, 49", "BARCELONA", 932133400, "mutuam@mutuam.com", 0);
INSERT INTO hospital VALUES(81385, "INSTITUT FREEDMAN", "Bartolomé Bermejo, 21", "BARCELONA", 934739101, "freedman@sociosanitaria.net", 0);
INSERT INTO hospital VALUES(81402, "MÚTUA DE GRANOLLERS, MÚTUA DE PREVISIÓ SOCIAL A PRIMA FIXA", "Pl. Pau Casals, s/n", "BARCELONA", 938708099, "", 0);
INSERT INTO hospital VALUES(81430, "HOSPITAL COMARCAL DE L'ALT PENEDÈS", "Espirall, s/n", "BARCELONA", 938180440, "xvillanova@csap.scs.es", 1);
INSERT INTO hospital VALUES(81458, "ÀPTIMA CENTRE CLÍNIC - MÚTUA DE TERRASSA", "Pl. Doctor Robert, 5", "BARCELONA", 937365072, "cmarin@mutuaterrassa.cat", 0);
INSERT INTO hospital VALUES(81461, "INSTITUT CATALÀ D'ONCOLOGIA L'HOSPITALET (ICO)", "Avda. Gran Via, 203", "BARCELONA", 933357011, "cserra@ico.scs.es", 1);
INSERT INTO hospital VALUES(81483, "SAR MONT MARTÍ", "Ct. Casserres (Abans Po. La Sala s/n), 1", "BARCELONA", 938290138, "", 0);
INSERT INTO hospital VALUES(81496, "REGINA SAR", "Mare de Déu del Coll, 22", "BARCELONA", 932848635, "", 0);
INSERT INTO hospital VALUES(81509, "U. HOSPITALÀRIA PENITENCIÀRIA D'HOMES", "Entença, 155", "BARCELONA", 934108796, "", 1);
INSERT INTO hospital VALUES(81537, "CENTRE VALLPARADÍS", "Sant Antoni, 52", "BARCELONA", 937365030, "", 0);
INSERT INTO hospital VALUES(81568, "ITA MARESME", "Cr.  Baró de Viver, 58", "BARCELONA", 937530062, "itacat@itacat.com", 0);
INSERT INTO hospital VALUES(81574, "CLÍNICA LLÚRIA", "Passatge Mercader, 14", "BARCELONA", 934882142, "clinicalluria@cpbssm.org", 0);
INSERT INTO hospital VALUES(81580, "ANTIC HOSPITAL DE SANT JAUME I SANTA MAGDALENA", "Hospital, 29-31", "BARCELONA", 937582800, "gerencia@csdm.es", 1);
INSERT INTO hospital VALUES(81593, "PARC SANITARI SANT JOAN DE DÉU - NUMÀNCIA", "Numancia, 7-13", "BARCELONA", 933249600, "upps@pssjd.org", 0);
INSERT INTO hospital VALUES(81605, "PRYTANIS HOSPITALET CENTRE SOCIOSANITARI", "Aprestadora, 43-45", "BARCELONA", 932988090, "", 0);
INSERT INTO hospital VALUES(81616, "COMUNITAT TERAPÈUTICA ARENYS DE MUNT", "Barri Orient 'CAN ZARIQUIEY'", 26"", "BARCELONA", 937938006, "ctam@ctm-salutmental.com", 0);
INSERT INTO hospital VALUES(81649, "HOSPITAL SOCIOSANITARI PERE VIRGILI", "Av.  Vallcarca, 169-205", "BARCELONA", 932594000, "pvirgili@perevirgili.catsalut.net", 1);
INSERT INTO hospital VALUES(81661, "BENITO MENNI COMPLEX ASSISTENCIAL EN SALUT MENTAL", "Cr. Francesc Ribas, s/n", "BARCELONA", 938425035, "hospital@hospitalbenitomenni.org", 0);
INSERT INTO hospital VALUES(81672, "HOSPITAL SANITAS CIMA", "Passeig Manuel Girona, 33", "BARCELONA", 935522700, "info@cimaclinic.com", 0);
INSERT INTO hospital VALUES(81683, "PARC SANITARI SANT JOAN DE DÉU - BRIANS 1", "Ct. de Capellades a Martorell, 23", "BARCELONA", 937758000, "joodircperi.dj@gencat.cat", 0);
INSERT INTO hospital VALUES(81694, "INSTITUT CATALÀ D'ONCOLOGIA BADALONA (ICO)", "Ct. Canyet, s/n", "BARCELONA", 934651200, "", 1);
INSERT INTO hospital VALUES(81706, "CENTRE COLLSEROLA MUTUAL", "Passeig Vall d'Hebron, 157", "BARCELONA", 933613900, "mutuam@mutuam.com", 0);
INSERT INTO hospital VALUES(81717, "CENTRE SOCIOSANITARI SARQUAVITAE SANT JORDI", "Ct Sant Joan Despí, 60", "BARCELONA", 934752690, "direccion.santjordi@sarquavitae.es", 0);
INSERT INTO hospital VALUES(81728, "HOSPITAL GENERAL PENITENCIARI", "Ct TORREBONICA, s/n", "BARCELONA", 937317861, "suhp@cst.cat", 1);
INSERT INTO hospital VALUES(81739, "CENTRE SOCIOSANITARI DE L'HOSPITALET - CONSORCI SANITARI INTEGRAL", "Avda. Josep Molins, 41", "BARCELONA", 934407500, "", 1);
INSERT INTO hospital VALUES(81740, "SAR LA SALUT JOSEP SERVAT", "Antequera, 8-18", "BARCELONA", 932857512, "info@sarquavitae.es", 0);
INSERT INTO hospital VALUES(81751, "CLÍNICA CREU BLANCA", "PS. Reina Elisenda de Montcada, 17", "BARCELONA", 932522522, "", 0);
INSERT INTO hospital VALUES(81762, "CLÍNICA SECRETARI COLOMA", "Secretari Coloma, 95", "BARCELONA", 934170400, "hestiagracia@hestiagracia.org", 0);
INSERT INTO hospital VALUES(81784, "CENTRE SOCIOSANITARI D'ESPLUGUES", "Via Augusta, 66-70", "BARCELONA", 936406350, "", 0);
INSERT INTO hospital VALUES(81795, "CENTRE SOCIOSANITARI RICARD FORTUNY", "Av.  Garraf, 3", "BARCELONA", 938172357, "", 1);
INSERT INTO hospital VALUES(81818, "CENTRE RESIDENCIAL MUTUAM DIAGONAL", "Llacuna , 120-122", "BARCELONA", 933209630, "", 0);
INSERT INTO hospital VALUES(81829, "CENTRE FÒRUM", "Llull, 410", "BARCELONA", 932483000, "", 1);
INSERT INTO hospital VALUES(81830, "CENTRE SOCIOSANITARI BLAUCLÍNIC DOLORS ALEU", "Marquès de Santa Anna, 9", "BARCELONA", 934343216, "msanchez@blauclinic.cat", 0);
INSERT INTO hospital VALUES(81841, "UNITAT TERAPÈUTICA CENTRE EDUCATIU ELS TIL-LERS", "Mossos d'esquadra, 3", "BARCELONA", 935705289, "", 0);
INSERT INTO hospital VALUES(81874, "CLÍNICA GALATEA", "Palafolls 15-19", "BARCELONA", 932057267, "info@clinica-galatea.com", 0);
INSERT INTO hospital VALUES(81885, "HOSPITAL D'IGUALADA", "Avda. Catalunya, 1", "BARCELONA", 938075500, "", 1);
INSERT INTO hospital VALUES(81896, "CENTRE SOCIAL I SANITARI FREDERICA MONTSENY", "Eslida, 6-8", "BARCELONA", 936473525, "mgrifol@chc.cat", 0);
INSERT INTO hospital VALUES(81919, "SERVEIS SANITARIS CENTRE PENITENCIARI BRIANS-2", "Crtra Martorell a Capellades, 23", "BARCELONA", 936935000, "justicia@gencat.net", 1);
INSERT INTO hospital VALUES(81920, "CENTRE INTEGRAL DE SERVEIS EN SALUT MENTAL COMUNITÀRIA", "Verntallat, 11-19", "BARCELONA", 932184908, "cis@arapdis.org", 0);
INSERT INTO hospital VALUES(81931, "CENTRE SOCIOSANITARI SANT JORDI DE LA VALL D'HEBRON", "Ps. Vall d'Hebrón 135-141", "BARCELONA", 934280000, "direccio.sj@chc.es", 0);
INSERT INTO hospital VALUES(81942, "LEPANT RESIDENCIAL QGG, SL", "Lepant, 401-403", "BARCELONA", 934507438, "andresmanero@hotmail.com", 0);
INSERT INTO hospital VALUES(81953, "MAPFRE QUAVITAE BARCELONA", "Sant Antoni Maria Claret, 200", "BARCELONA", 934579400, "recepcion.claret@sarquavitae.es", 0);
INSERT INTO hospital VALUES(81964, "UNITAT POLIVALENT SALUT MENTAL BARCELONA-NORD", "Av. Jordà, 8", "BARCELONA", 934275250, "", 0);
INSERT INTO hospital VALUES(81997, "CQM CLÍNIC MARESME, SL", "Lepant, 13-21", "BARCELONA", 937556219, "ucma@cqmaresme.net", 0);
INSERT INTO hospital VALUES(82001, "SERVEIS SANITARIS CENTRE PENITENCIARI JOVES DE BARCELONA", "Ct. de Masnou a Granollers, 13-42", "BARCELONA", 932140100, "mpujolr@gencat.cat", 1);
INSERT INTO hospital VALUES(82012, "CLÍNICA DEL VALLÈS", "Ps. Rubió i Ors, 25-27", "BARCELONA", 937283100, "rmunoz@cliniquesdecatalunya.com", 0);
INSERT INTO hospital VALUES(82023, "CENTRE GERONTOLÒGIC AMMA SANT CUGAT", "Victor Hugo, 10", "BARCELONA", 935836100, "direccion@santcugat.amma.es", 0);
INSERT INTO hospital VALUES(82034, "SERVEIS SANITARIS. CENTRE PENITENCIARI LLEDONERS", "Ct. de Manresa a Solsona. Camí de les Torres, C-55", "BARCELONA", 932140100, "", 1);
INSERT INTO hospital VALUES(82045, "CENTRE STAUROS", "Pl. Karl Marx, 1", "BARCELONA", 931171074, "stauros@centrestauros.org", 0);
INSERT INTO hospital VALUES(82066, "HOSPITAL DE SANT JOAN DESPÍ MOISÈS BROGGI", "Av. Jacint Verdaguer, 90", "BARCELONA", 935531200, "", 1);
INSERT INTO hospital VALUES(82099, "AMMA HORTA", "Av. Can Marcet, 11", "BARCELONA", 934280092, "recepcion@horta.amma.es", 0);
INSERT INTO hospital VALUES(82100, "CENTRE BLAUCLÍNIC SANT JOSEP ORIOL", "Rd. Guinardó, 48-50", "BARCELONA", 932214700, "msanchez@blauclinic.cat", 0);
INSERT INTO hospital VALUES(82112, "UNITAT POLIVALENT BENITO MENNI EN SALUT MENTAL DE L'HOSPITALET-EL PRAT DE LLOBREGAT", "Sant Rafael, 11", "BARCELONA", 936402400, "", 0);
INSERT INTO hospital VALUES(82134, "ITA MARESME", "Cavallers, 37", "BARCELONA", 933621258, "snavarro@itacat.com", 0);
INSERT INTO hospital VALUES(82145, "CENTRE SOCIOSANITARI DEL CENTRE INTEGRAL DE SALUT COTXERES", "Av Borbó, 18-30", "BARCELONA", 932438991, "jserrat@consorci.org", 0);
INSERT INTO hospital VALUES(82156, "CLÍNICA SANT ANTONI", "Sant Eloi, 6-8", "BARCELONA", 932974010, "provfig@ediho.es", 0);
INSERT INTO hospital VALUES(82167, "CLÍNICA  DIAGONAL", "Sant Mateu, 24-26", "BARCELONA", 932053213, "clinica@fiatc.es", 0);
INSERT INTO hospital VALUES(82178, "HOSPITAL SOCIOSANITARI DE MOLLET", "Sant Llorenç, 39-4", "BARCELONA", 935760300, "direcciogeneral@hospitalmollet.cat", 0);
INSERT INTO hospital VALUES(82189, "CENTRE SOCIOSANITARI ISABEL ROIG", "Fernando Pessoa, 47-51", "BARCELONA", 931780667, "cssisabelroig@blauclinic.cat", 0);
INSERT INTO hospital VALUES(82190, "IM CLÍNIC", "Victor Hugo, 24", "BARCELONA", 902401540, "imclinic@imclinic.com", 0);
INSERT INTO hospital VALUES(90026, "HOSPITAL FUENTE BERMEJA", "Francisco Salinas, s/n", "BURGOS", 947256236, "gerente.hgyg@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(90047, "HOSPITAL RECOLETAS DE BURGOS", "Cruz Roja, s/n", "BURGOS", 947244055, "admision.hrb@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(90050, "HOSPITAL SAN JUAN DE DIOS DE BURGOS", "Pº de la Isla, 3", "BURGOS", 947257730, "hsanjuandb@hsjd.es", 0);
INSERT INTO hospital VALUES(90079, "HOSPITAL SANTOS REYES", "Av. Ruperta Baraya, 6", "BURGOS", 947522000, "gerente.hsry@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(90085, "HOSPITAL RESIDENCIA ASISTIDA DE LA LUZ", "Duratón, 2", "BURGOS", 947500150, "gerencia@hralaluz.es", 0);
INSERT INTO hospital VALUES(90098, "HOSPITAL SANTIAGO APÓSTOL", "Ctra. de Orón, s/n", "BURGOS", 947349000, "gerente.hsap@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(90133, "COMPLEJO ASISTENCIAL UNIVERSITARIO DE BURGOS", "Av. Islas Baleares, 3", "BURGOS", 947281800, "gerente.hgyg@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(90155, "HOSPITAL UNIVERSITARIO DE BURGOS", "Islas Baleares, 3", "BURGOS", 947281800, "gerente.hgyg@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(100015, "HOSPITAL SAN PEDRO DE ALCANTARA", "Av. Pablo Naranjo, s/n", "CÁCERES", 927256200, "", 1);
INSERT INTO hospital VALUES(100020, "HOSPITAL PROVINCIAL NUESTRA SEÑORA DE LA MONTAÑA", "Av. de España, s/n", "CÁCERES", 927256800, "", 1);
INSERT INTO hospital VALUES(100041, "HOSPITAL CIUDAD DE CORIA", "Cervantes, 75", "CÁCERES", 927149200, "", 1);
INSERT INTO hospital VALUES(100054, "HOSPITAL CAMPO ARAÑUELO", "Tomás Yuste Mirón, s/n", "CÁCERES", 927548900, "jorge.farfan@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(100067, "HOSPITAL VIRGEN DEL PUERTO", "Paraje Valcorchero, s/n", "CÁCERES", 927428300, "gerent.hvpt@ses.juntaextremadura.net", 1);
INSERT INTO hospital VALUES(100073, "HOSPITAL SOCIOSANITARIO DE PLASENCIA (*)", "Ctra. de Cáceres, s/n", "CÁCERES", 927428800, "", 0);
INSERT INTO hospital VALUES(100089, "COMPLEJO HOSPITALARIO DE CÁCERES", "Av.Pablo Naranjo, s/n", "CÁCERES", 927256200, "", 1);
INSERT INTO hospital VALUES(100092, "CLÍNICA VIRGEN DE GUADALUPE", "Av. de la Universidad, 5", "CÁCERES", 927181360, "federico.delgado@idcsalud.es", 0);
INSERT INTO hospital VALUES(100106, "CLÍNICA SOQUIMEX", "AVDA. LA SALLE, 22", "CÁCERES", 927418484, "soquimex@soquimex.com", 0);
INSERT INTO hospital VALUES(100113, "CLÍNICA SAN FRANCISCO", "Ronda de San Francisco, 1", "CÁCERES", 927012200, "clinica@cqcsanfrancisco.es", 0);
INSERT INTO hospital VALUES(110012, "HOSPITAL  PUERTA DEL MAR", "Av. Ana de Viya, 21", "CÁDIZ", 956002040, "gerencia.hpm.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(110048, "CLÍNICA NUESTRA SEÑORA DE LA SALUD", "Feduchy, 8-14", "CÁDIZ", 956225301, "administracion@clinicalasalud.es", 0);
INSERT INTO hospital VALUES(110051, "HOSPITAL SAN RAFAEL", "Diego Arias, 2", "CÁDIZ", 956017267, "cadiz.secretaria@jmpascual.com", 0);
INSERT INTO hospital VALUES(110086, "COMPLEJO HOSPITALARIO PUNTA DE EUROPA", "Ctra. de Getares, s/n", "CÁDIZ", 956025000, "franciscoj.martos.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(110103, "CLINICA  LOS ÁLAMOS", "Av. de Tamarix, 4", "CÁDIZ", 956182244, "rrhh@clinicalosalamos.com", 0);
INSERT INTO hospital VALUES(110110, "HOSPITAL DE ESPECIALIDADES DE JEREZ DE LA FRONTERA", "Ronda de Circunvalacion, s/n", "CÁDIZ", 956032075, "", 0);
INSERT INTO hospital VALUES(110125, "HOSPITAL JUAN GRANDE", "Glorieta Félix Rodriguez de la Fuente, s/n", "CÁDIZ", 956357300, "jerez@sjd.es", 0);
INSERT INTO hospital VALUES(110146, "HOSPITAL DE LA LÍNEA DE LA CONCEPCIÓN", "Av. Menéndez y Pelayo, 103", "CÁDIZ", 956026500, "franciscoj.martos.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(110162, "HOSPITAL GENERAL SANTA MARÍA DEL PUERTO", "Valdés, s/n", "CÁDIZ", 956017000, "stamaria.secretaria@jmpascual.com", 0);
INSERT INTO hospital VALUES(110184, "HOSPITAL  DE ESPECIALIDADES DE PUERTO REAL", "Ctra. Nacional IV, km. 665", "CÁDIZ", 956005147, "", 0);
INSERT INTO hospital VALUES(110218, "HOSPITAL VIRGEN DE LAS MONTAÑAS", "Av. Ambulatorio s/n", "CÁDIZ", 956041000, "", 0);
INSERT INTO hospital VALUES(110223, "HOSPITAL VIRGEN DEL CAMINO", "Crtra Sanlúcar-Chipiona, s/n", "CÁDIZ", 956048068, "sanlucar.secretaria@jmpascual.com", 0);
INSERT INTO hospital VALUES(110239, "CLÍNICA JEREZ", "Av. Puerta del Sur, s/n", "CÁDIZ", 956357100, "rrhhcj@asisa.es", 0);
INSERT INTO hospital VALUES(110248, "CENTRO MÉDICO CHICLANA", "Ayala, 2", "CÁDIZ", 956533333, "gerencia@hospitalcmc.es", 0);
INSERT INTO hospital VALUES(110259, "AREA DE GESTION SANITARIA CAMPO DE GIBRALTAR", "Crtra de Getares, s/n", "CÁDIZ", 956025000, "", 0);
INSERT INTO hospital VALUES(110260, "CLINICA NOVO SANCTI PETRI", "Urb. Novo Sancti Petri, s/n", "CÁDIZ", 956495000, "gerente@clinicanovo.es", 0);
INSERT INTO hospital VALUES(110271, "INSTITUTO SERMAN", "Pº de la Rosaleda, 40", "CÁDIZ", 956301211, "jefeadministracion@xlinicaserman.com", 0);
INSERT INTO hospital VALUES(110282, "HOSPITAL QUIRÓN CAMPO DE GIBRALTAR", "Parque Empresarial “Las Marismas de Palmones”, Edificio ARTTYSUR", "CÁDIZ", 956798301, "", 0);
INSERT INTO hospital VALUES(120017, "HOSPITAL GENERAL UNIVERSITARIO DE CASTELLÓN", "Av. Benicasim, s/n", "CASTELLÓN", 964726500, "", 1);
INSERT INTO hospital VALUES(120038, "HOSPITAL LA MAGDALENA", "Cuadra Collet, 32. Partida Bovalar", "CASTELLÓN", 964356800, "monferrer_mar@gva.es", 1);
INSERT INTO hospital VALUES(120043, "CONSORCIO HOSPITALARIO PROVINCIAL DE CASTELLÓN", "Av. Doctor Clara, 19", "CASTELLÓN", 964359700, "arce_raf@gva.es", 1);
INSERT INTO hospital VALUES(120115, "HOSPITAL COMARCAL DE VINAROS", "Av. Gil de Atrocillo, s/n", "CASTELLÓN", 964477000, "", 1);
INSERT INTO hospital VALUES(120136, "HOSPITAL UNIVERSITARIO DE LA PLANA", "Crtra de Vila-Real a Borriana, km. 0,5", "CASTELLÓN", 964357600, "", 1);
INSERT INTO hospital VALUES(120148, "INSTITUTO DE TRAUMATOLOGÍA DE UNION DE MUTUAS", "Av. Lidon 69 (y Juan de Herrera 27)", "CASTELLÓN", 964231212, "amarti@uniondemutuas.es", 0);
INSERT INTO hospital VALUES(120159, "HOSPITAL REY DON JAIME", "Sta María Rosa Molas, 25", "CASTELLÓN", 964726000, "reydjaime@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(130034, "SERVICIOS SANITARIOS Y ASISTENCIALES", "Ronda del Carmen, s/n", "CIUDAD REAL", 926231276, "psiquiatria@dipucr.es", 1);
INSERT INTO hospital VALUES(130049, "IDC SALUD HOSPITAL CIUDAD REAL", "Alisos, 19", "CIUDAD REAL", 926255008, "ciudad.real@idcsalud.es", 0);
INSERT INTO hospital VALUES(130052, "HOSPITAL GENERAL LA MANCHA CENTRO", "Avenida de la Constitución, 3", "CIUDAD REAL", 926580500, "gerencia.manchacentro@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(130065, "HOSPITAL VIRGEN DE ALTAGRACIA", "Avda. D. Emiliano García Roldán, 2", "CIUDAD REAL", 926646000, "mlgomezg@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(130071, "HOSPITAL SANTA BÁRBARA", "C/ Malagón, s/n", "CIUDAD REAL", 926421100, "buzong@sescam.org", 1);
INSERT INTO hospital VALUES(130087, "HOSPITAL GUTIÉRREZ ORTEGA", "Avda. Estudiantes, s/n", "CIUDAD REAL", 926320200, "", 1);
INSERT INTO hospital VALUES(130127, "HOSPITAL GENERAL DE CIUDAD REAL", "Obispo Rafael Torija, s/n", "CIUDAD REAL", 926278000, "emperez@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(130128, "HOSPITAL GENERAL DE TOMELLOSO", "Vereda de Socuéllamos, s/n", "CIUDAD REAL", 926525800, "magnoliar@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(140023, "COMPLEJO HOSPITALARIO REGIONAL REINA SOFÍA", "Av. Menéndez Pidal, s/n", "CÓRDOBA", 957010380, "gerencia.hrs.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(140039, "HOSPITAL LOS MORALES", "Ctra. de Los Morales, s/n", "CÓRDOBA", 957012042, "", 0);
INSERT INTO hospital VALUES(140044, "HOSPITAL REINA SOFÍA", "Av. Menéndez Pidal, s/n", "CÓRDOBA", 957010380, "", 0);
INSERT INTO hospital VALUES(140060, "HOSPITAL PROVINCIAL", "Av. Menéndez Pidal, s/n", "CÓRDOBA", 957011604, "", 0);
INSERT INTO hospital VALUES(140076, "HOSPITAL DE LA CRUZ ROJA DE CÓRDOBA", "Pº de la Victoria, s/n", "CÓRDOBA", 957420666, "", 0);
INSERT INTO hospital VALUES(140082, "HOSPITAL SAN JUAN DE DIOS DE CÓRDOBA", "Av. del Brillante, 106", "CÓRDOBA", 957274600, "cordoba.hospital@sjd.es", 0);
INSERT INTO hospital VALUES(140116, "HOSPITAL COMARCAL INFANTA MARGARITA", "Av. de Góngora, s/n", "CÓRDOBA", 957021300, "", 0);
INSERT INTO hospital VALUES(140121, "HOSPITAL COMARCAL  VALLE DE LOS PEDROCHES", "C/ Juan del Rey Calero, s/n", "CÓRDOBA", 957026306, "", 0);
INSERT INTO hospital VALUES(140142, "HOSPITAL MATERNO INFANTIL", "Av. Menendez Pidal, s/n", "CÓRDOBA", 957010345, "", 0);
INSERT INTO hospital VALUES(140195, "HOSPITAL DE MONTILLA", "Crtra. Montoro-Puente Genil, Km 65,350", "CÓRDOBA", 957022600, "", 0);
INSERT INTO hospital VALUES(140207, "HOSPITAL LA ARRUZAFA-INSTITUTO DE OFTALMOLOGÍA", "Av. de la Arruzafa, 9", "CÓRDOBA", 957767610, "rab@hospitalarruzafa.com", 0);
INSERT INTO hospital VALUES(140218, "HOSPITAL DE ALTA RESOLUCION DE PUENTE GENIL", "Burgos, s/n", "CÓRDOBA", 957615000, "", 0);
INSERT INTO hospital VALUES(140229, "HOSPITAL DE ALTA RESOLUCIÓN VALLE DEL GUADIATO", "Paraje Cerro del Camello, s/n", "CÓRDOBA", 957579100, "", 0);
INSERT INTO hospital VALUES(150011, "COMPLEXO HOSPITALARIO UNIVERSITARIO A CORUÑA", "Jubias de Arriba, 84", "A CORUÑA", 981178000, "", 1);
INSERT INTO hospital VALUES(150026, "HOSPITAL UNIVERSITARIO A CORUÑA", "Jubias de Arriba, 84", "A CORUÑA", 981178000, "", 1);
INSERT INTO hospital VALUES(150032, "HOSPITAL MATERNO INFANTIL TERESA HERRERA", "Jubias de Arriba, s/n", "A CORUÑA", 981178000, "", 1);
INSERT INTO hospital VALUES(150047, "HOSPITAL MARÍTIMO DE OZA", "Jubias de Arriba, 1", "A CORUÑA", 981178000, "", 1);
INSERT INTO hospital VALUES(150050, "CENTRO ONCOLÓXICO DE GALICIA", "Doctor Camilo Veiras, 1", "A CORUÑA", 981287499, "direccion@cog.es", 0);
INSERT INTO hospital VALUES(150063, "HOSPITAL QUIRÓN  A CORUÑA", "Londres, 2", "A CORUÑA", 981219800, "", 0);
INSERT INTO hospital VALUES(150079, "HOSPITAL SAN RAFAEL", "Jubias de Arriba, 82", "A CORUÑA", 981179000, "ade@imqsanrafael.com", 0);
INSERT INTO hospital VALUES(150085, "HOSPITAL MODELO (*)", "Virrey Ossorio, 30", "A CORUÑA", 981147300, "hospitalmodelo@hospitalmodelo.com", 0);
INSERT INTO hospital VALUES(150102, "MATERNIDAD BELEN (*)", "Teniente Coronel Teijeiro, 3", "A CORUÑA", 981251600, "hospitalmodelo@hospitalmodelo.com", 0);
INSERT INTO hospital VALUES(150124, "HOSPITAL ABENTE Y LAGO", "General Sir John Moore, 6", "A CORUÑA", 981178000, "", 1);
INSERT INTO hospital VALUES(150130, "COMPLEXO HOSPITALARIO UNIVERSITARIO ARQUITECTO MARCIDE-PROFESOR NOVOA SANTOS DE FERROL", "Av.  Residencia, s/n", "A CORUÑA", 981334000, "", 1);
INSERT INTO hospital VALUES(150145, "HOSPITAL ARQUITECTO MARCIDE", "Av.  Residencia, s/n", "A CORUÑA", 981334000, "", 1);
INSERT INTO hospital VALUES(150177, "HOSPITAL GENERAL JUAN CARDONA", "Pardo Bazán, s/n", "A CORUÑA", 981312500, "gerencia@hjcardona.org", 0);
INSERT INTO hospital VALUES(150183, "HOSPITAL NAVAL", "Pega (A) s/n", "A CORUÑA", 981339759, "", 1);
INSERT INTO hospital VALUES(150200, "COMPLEXO HOSPITALARIO UNIVERSITARIO DE SANTIAGO", "Choupana (Da), s/n", "A CORUÑA", 981950000, "secretaria.xer.chus@sergas.es", 1);
INSERT INTO hospital VALUES(150217, "HOSPITAL CLÍNICO UNIVERSITARIO", "Choupana (Da), s/n", "A CORUÑA", 981950000, "secretaria.xer.chus@sergas.es", 1);
INSERT INTO hospital VALUES(150222, "HOSPITAL PROFESOR GIL CASARES", "Choupana (Da), s/n", "A CORUÑA", 981950000, "secretaria.xer.chus@sergas.es", 1);
INSERT INTO hospital VALUES(150238, "HOSPITAL MÉDICO-CIRÚRXICO DE CONXO", "Ramon Baltar, s/n", "A CORUÑA", 981951500, "secretaria.xer.chus@sergas.es", 1);
INSERT INTO hospital VALUES(150243, "HOSPITAL PSIQUIÁTRICO DE CONXO", "Pza Martín Herrera, 2", "A CORUÑA", 981951900, "secretaria.xer.chus@sergas.es", 1);
INSERT INTO hospital VALUES(150256, "HOSPITAL NUESTRA SEÑORA DE LA ESPERANZA", "Burgas (Das), 2", "A CORUÑA", 981552200, "info@nslaesperanza.es", 0);
INSERT INTO hospital VALUES(150269, "HOSPITAL POLICLÍNICO LA ROSALEDA", "Santiago León de Caracas, 1", "A CORUÑA", 981551200, "rosaleda@jet.es", 0);
INSERT INTO hospital VALUES(150308, "SANATORIO LA ROBLEDA", "Santiso, s/n", "A CORUÑA", 981585811, "administracion@sanatoriolarobleda.com", 0);
INSERT INTO hospital VALUES(150336, "HOSPITAL DA BARBANZA", "Salmón, s/n", "A CORUÑA", 981835985, "xerencia.bbz@sergas.es", 1);
INSERT INTO hospital VALUES(150341, "HOSPITAL VIRXE DA XUNQUEIRA", "Alcalde Pepe Sánchez, 7", "A CORUÑA", 981706010, "", 1);
INSERT INTO hospital VALUES(160014, "HOSPITAL VIRGEN DE LA LUZ", "Hermandad Donantes de Sangre, 1", "CUENCA", 969179900, "pguardial@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(160053, "HOSPITAL RECOLETAS CUENCA S.L.U.", "Avda. San Julián, 1", "CUENCA", 969240559, "olga.barrios.aj@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(170010, "HOSPITAL UNIVERSITARI DE GIRONA DR. JOSEP TRUETA", "Av. França, s/n", "GIRONA", 972940200, "gerencia@htrueta.scs.es", 1);
INSERT INTO hospital VALUES(170031, "CLÍNICA BOFILL", "Ronda Sant Antoni Maria Claret , 20", "GIRONA", 972204350, "", 0);
INSERT INTO hospital VALUES(170059, "CLÍNICA GIRONA", "Joan Maragall, 26", "GIRONA", 972204500, "cespigol@arrakis.es", 0);
INSERT INTO hospital VALUES(170062, "CLÍNICA QUIRÚRGICA ONYAR", "Heroïnes de Santa Bárbara, 6", "GIRONA", 972204900, "xbusquets@giroclinic.com", 0);
INSERT INTO hospital VALUES(170097, "CLÍNICA SALUS INFIRMORUM", "Passeig Mossèn Lluís Constans, 130", "GIRONA", 972570208, "si.direc@teleline.es", 0);
INSERT INTO hospital VALUES(170101, "HOSPITAL DE SANT JAUME", "Jaume Arcelos, 1", "GIRONA", 972331550, "", 1);
INSERT INTO hospital VALUES(170118, "HOSPITAL DE CAMPDEVÀNOL", "Carretera de Gombren, 20", "GIRONA", 972730028, "gerencia@hoscamp.com", 0);
INSERT INTO hospital VALUES(170123, "HOSPITAL DE FIGUERES", "Ronda Rector Arolas, s/n", "GIRONA", 972501400, "direccio@hospfig.es", 0);
INSERT INTO hospital VALUES(170139, "CLÍNICA SANTA CREU", "Pere III, 41", "GIRONA", 972503650, "", 0);
INSERT INTO hospital VALUES(170160, "HOSPITAL SOCIOSANITARI DE LLORET DE MAR", "Vall de Venecia, 59", "GIRONA", 972364736, "salut@salutms.org", 1);
INSERT INTO hospital VALUES(170176, "HOSPITAL D'OLOT I COMARCAL DE LA GARROTXA", "Av Països Catalans, 86", "GIRONA", 972261800, "direccio@hospiolot.com", 0);
INSERT INTO hospital VALUES(170195, "HOSPITAL DE PALAMÓS", "Hospital, 36", "GIRONA", 972600160, "direccio@hosppal.es", 0);
INSERT INTO hospital VALUES(170209, "HOSPITAL DE PUIGCERDÀ", "Plaza Santa María, 1", "GIRONA", 972880150, "hp.gerencia@mx3.redestb.es", 0);
INSERT INTO hospital VALUES(170216, "HOSPITAL PSIQUIÀTRIC", "Doctor Castany, s/n", "GIRONA", 972182512, "atenciousuari@ias.scs.es", 1);
INSERT INTO hospital VALUES(170221, "RESIDÈNCIA DE GENT GRAN PUIG D'EN ROCA", "Antoni Vares i Martinell, 37", "GIRONA", 972209250, "", 1);
INSERT INTO hospital VALUES(170237, "HOSPITAL COMARCAL DE BLANES", "Crtra Accés Cala de Sant Frances, 5", "GIRONA", 972353264, "csselva@conecta.es", 1);
INSERT INTO hospital VALUES(170242, "RESIDÈNCIA GERIÀTRICA MARIA GAY", "Portal Nou, 12", "GIRONA", 972205045, "info.mgay@irsjg.org", 0);
INSERT INTO hospital VALUES(170255, "HOSPITAL SOCIOSANITARI MUTUAM GIRONA", "Avda. de França, 64", "GIRONA", 972171819, "mutuam@mutuam.com", 0);
INSERT INTO hospital VALUES(170277, "CENTRE SOCIOSANITARI DE PUIGCERDÀ", "Camino Antic de LLívia, s/n", "GIRONA", 972880150, "jcatala@hospitalpuigcerda.com", 0);
INSERT INTO hospital VALUES(170288, "CENTRE SOCIOSANITARI BERNAT JAUME", "Ronda Rector Arolas, s/n", "GIRONA", 972501400, "hospital@hospitaldefigueres.com", 0);
INSERT INTO hospital VALUES(170299, "INSTITUT CATALÀ D'ONCOLOGIA GIRONA (ICO)", "Avda França, s/n", "GIRONA", 972940200, "", 1);
INSERT INTO hospital VALUES(170301, "HOSPITAL SANTA CATERINA", "Avda. Doctor Castany (P. H. Martí i Julià), s/n", "GIRONA", 972182600, "gerencia@ias.scs.es", 1);
INSERT INTO hospital VALUES(170312, "CENTRE PALAMÓS GENT GRAN", "Provença, 36", "GIRONA", 972600160, "", 0);
INSERT INTO hospital VALUES(170323, "CENTRE SOCIOSANITARI PARC HOSPITALARI MARTÍ I JULIÀ", "Dr. Castany, s/n", "GIRONA", 972182512, "atenciousuari@ias.scs.es", 1);
INSERT INTO hospital VALUES(170334, "HOSPITAL DE CERDANYA / HÒPITAL DE CERDAGNE", "Camino Antic d’Ur, 31.", "GIRONA", 972114090, "dir@hcerdanya.eu", 1);
INSERT INTO hospital VALUES(180016, "HOSPITAL UNIVERSITARIO VIRGEN DE LAS NIEVES", "Av. de las Fuerzas Armadas, 2", "GRANADA", 958020000, "", 0);
INSERT INTO hospital VALUES(180021, "HOSPITAL SAN CECILIO", "Av. del Doctor Oloriz, 16", "GRANADA", 958023000, "husc.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(180037, "COMUNIDAD TERAPÉUTICA ÁREA NORTE", "Av. de Andalucia, 116", "GRANADA", 958021301, "", 0);
INSERT INTO hospital VALUES(180042, "HOSPITAL SAN JUAN DE DIOS", "San Juan de Dios, 15", "GRANADA", 958022339, "", 0);
INSERT INTO hospital VALUES(180055, "HOSPITAL SAN RAFAEL", "San Juan de Dios, 19-23", "GRANADA", 958275700, "sanrafael@granada1.sjd.es", 0);
INSERT INTO hospital VALUES(180068, "SANATORIO NUESTRA SEÑORA DE LA SALUD", "Ntra. Sra. de la Salud, s/n", "GRANADA", 958001450, "lasalud@lasalud.nehos.com", 0);
INSERT INTO hospital VALUES(180074, "CLÍNICA INMACULADA CONCEPCIÓN", "Dr Alejandro Otero, 8", "GRANADA", 958187700, "admon@clinicainmaculada.com", 0);
INSERT INTO hospital VALUES(180093, "HOSPITAL COMARCAL DE BAZA", "Ctra. de Murcia, Km. 1,6", "GRANADA", 958031303, "josea.reche.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(180107, "HOSPITAL COMARCAL SANTA ANA DE MOTRIL", "Av. Enrique Martín Cuevas, s/n", "GRANADA", 958038200, "francisco.perez.saez.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(180114, "COMPLEJO HOSPITALARIO REGIONAL VIRGEN DE LAS NIEVES", "Av. Fuerzas Armadas, 2", "GRANADA", 958020000, "jluis.martinez.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(180122, "HOSPITAL DE ALTA RESOLUCION DE GUADIX", "Mariana Pineda, s/n", "GRANADA", 958699153, "sugerencias@ephpo.es", 0);
INSERT INTO hospital VALUES(180133, "HOSPITAL DE ALTA RESOLUCIÓN DE LOJA", "Avda. Tierno Galván, s/n", "GRANADA", 958338100, "", 1);
INSERT INTO hospital VALUES(190019, "HOSPITAL UNIVERSITARIO DE GUADALAJARA", "Donantes de Sangre, s/n", "GUADALAJARA", 949209200, "hospital.guadalajara@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(190030, "CLÍNICA LA ANTIGUA", "Constitución, 18", "GUADALAJARA", 949223600, "info@clinicalaantigua.es", 0);
INSERT INTO hospital VALUES(190045, "CLÍNICA SANZ VÁZQUEZ", "Paseo Doctor Fernández Iparraguirre, 6", "GUADALAJARA", 949227200, "clinicasanzvazquez@gmail.com", 0);
INSERT INTO hospital VALUES(190061, "U.R.R. DE ENFERMOS PSÍQUICOS ALCOHETE", "Carretera de Guadalajara a Cuenca, km. 8.200", "GUADALAJARA", 949291136, "jmyague@jccm.es", 1);
INSERT INTO hospital VALUES(190077, "INSTITUTO DE ENFERMEDADES NEUROLÓGICAS DE CASTILLA-LA MANCHA", "Paseo de la Estación, 2", "GUADALAJARA", 949211500, "correo.ien@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(200049, "MUTUALIA-CLINICA PAKEA", "Pº de Arriola, 26", "GUIPÚZCOA", 943212600, "clinicapakea@mutualia.es", 0);
INSERT INTO hospital VALUES(200071, "HOSPITAL RICARDO BERMINGHAM (FUNDACIÓN MATIA)", "Camino de los Pinos, 35", "GUIPÚZCOA", 943317100, "vugarte@matiaf.net", 0);
INSERT INTO hospital VALUES(200104, "POLICLÍNICA GUIPUZKOA, S.A.", "Parque  Miramón, 174", "GUIPÚZCOA", 943002800, "dirmed@policlinicagipuzkoa.com", 0);
INSERT INTO hospital VALUES(200111, "CENTRO SANITARIO VIRGEN DEL PILAR", "Pº de Zarategui, 10", "GUIPÚZCOA", 943327020, "csvp@csvp.com", 0);
INSERT INTO hospital VALUES(200126, "HOSPITAL QUIRÓN DONOSTIA", "Alkolea, 7", "GUIPÚZCOA", 943437100, "direccion.ss@quiron.es", 0);
INSERT INTO hospital VALUES(200132, "FUNDACIÓN ONCOLOGIKOA FUNDATZIOA", "Pº. Dr. Begiristain, 121", "GUIPÚZCOA", 943328000, "", 0);
INSERT INTO hospital VALUES(200163, "ORGANIZACIÓN SANITARIA INTEGRADA BIDASOA (OSI BIDASOA)", "Finca Zubieta. Bº. Mendelu, s/n", "GUIPÚZCOA", 943007702, "osintegradabidasoa@osakidetza.net", 1);
INSERT INTO hospital VALUES(200185, "ORGANIZACIÓN SANITARIA INTEGRADA ALTO DEBA", "Avda. Navarra, 16", "GUIPÚZCOA", 943035300, "direccion.haltodeba@osakidetza.net", 1);
INSERT INTO hospital VALUES(200198, "HOSPITAL AITA MENNI", "Barrio Gesalibar, 15", "GUIPÚZCOA", 943794411, "gerencia@aita-menni.org", 0);
INSERT INTO hospital VALUES(200202, "HOSPITAL PSIQUIÁTRICO SAN JUAN DE DIOS", "Barrio Gesalibar, 14", "GUIPÚZCOA", 943793900, "mondragon.hospital@hsjd.es", 0);
INSERT INTO hospital VALUES(200219, "CLINICA SANTA MARÍA DE LA ASUNCION, (INVIZA, S.A.)", "Ctra. Izaskun, 9", "GUIPÚZCOA", 943697000, "info@clinicadelaasuncion.com", 0);
INSERT INTO hospital VALUES(200230, "SANATORIO DE USURBIL, S.L.", "Barrio San Esteban, 48", "GUIPÚZCOA", 943361124, "aolano@sanatoriodeusurbil.com", 0);
INSERT INTO hospital VALUES(200245, "HOSPITAL DE ZUMARRAGA", "Barrio Argixao, s/n", "GUIPÚZCOA", 943035000, "secretaria.direccionzumarraga@osakidetza.net", 1);
INSERT INTO hospital VALUES(200258, "HOSPITAL DE MENDARO", "Bº. Mendarozabal, s/n", "GUIPÚZCOA", 943032800, "EDUARDO.GONZALEZLOMBIDE@OSAKIDETZA.NET", 1);
INSERT INTO hospital VALUES(200261, "HOSPITAL UNIVERSITARIO DONOSTIA-DONOSTIA UNIBERTSITATE OSPITALEA", "Pº Dr. Beguiristain, 109", "GUIPÚZCOA", 943007060, "HDO.GERENTZIA@osakidetza.net", 1);
INSERT INTO hospital VALUES(200271, "HOSPITAL SAN JUAN DE DIOS DONOSTIA", "Camino de San Juan de Dios, 12", "GUIPÚZCOA", 943460033, "ss.hospital@hsjd.es", 0);
INSERT INTO hospital VALUES(210025, "HOSPITAL COMARCAL INFANTA ELENA", "Autovía Sevilla-Huelva, s/n", "HUELVA", 959015132, "direccion.hie.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(210031, "HOSPITAL VÁZQUEZ DÍAZ", "Ctra. de Sevilla-Huelva, s/n", "HUELVA", 959014603, "", 0);
INSERT INTO hospital VALUES(210059, "HOSPITAL BLANCA PALOMA", "Avda. Diego Morón, 3", "HUELVA", 959012100, "huelva.secretaria@jmpascual.com", 0);
INSERT INTO hospital VALUES(210084, "CLÍNICA LOS NARANJOS", "Pº de los Naranjos, 1", "HUELVA", 959243900, "admon.naranjoscitra@asisa.es", 0);
INSERT INTO hospital VALUES(210097, "HOSPITAL COMARCAL DE RIOTINTO", "La Esquila, 5", "HUELVA", 959025295, "secdireccion.dsa.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(210101, "COMPLEJO HOSPITALARIO DE ESPECIALIDADES JUAN RAMÓN JIMENEZ", "Ronda Norte, s/n", "HUELVA", 959016000, "", 0);
INSERT INTO hospital VALUES(210123, "HOSPITAL GENERAL JUAN RAMÓN JIMENEZ", "Ronda Norte, s/n", "HUELVA", 959016000, "", 0);
INSERT INTO hospital VALUES(210137, "HOSPITAL COSTA DE LA LUZ", "Punta Umbría, s/n", "HUELVA", 959242100, "", 0);
INSERT INTO hospital VALUES(220015, "HOSPITAL GENERAL SAN JORGE", "Av. Martínez de Velasco, 36", "HUESCA", 974247000, "gmontero@salud.aragon.es", 1);
INSERT INTO hospital VALUES(220020, "CENTRO DE REHAB. PSICOSOCIAL SANTO CRISTO DE LOS MILAGROS", "Ctra. de Arguis, km. 2,5", "HUESCA", 974220772, "", 1);
INSERT INTO hospital VALUES(220036, "HOSPITAL SAGRADO CORAZÓN DE JESÚS", "Lucas Mallada, 22", "HUESCA", 974292000, "hscjhuesca@salud.aragon.es", 1);
INSERT INTO hospital VALUES(220041, "CLÍNICA SANTIAGO", "Sariñena, 12", "HUESCA", 974220600, "bnasarre@viamedsantiago.com", 0);
INSERT INTO hospital VALUES(220054, "HOSPITAL DE BARBASTRO", "Ctra. Nacional 240, s/n", "HUESCA", 974249000, "", 1);
INSERT INTO hospital VALUES(220089, "HOSPITAL DE ALTA RESOLUCIÓN DEL PIRINEO(*)", "Calzada de Rapitán, s/n", "HUESCA", 974355331, "mlmeavilla@salud.aragon.es", 1);
INSERT INTO hospital VALUES(220105, "CENTRO SANITARIO DE ALTA RESOLUCIÓN BAJO CINCA-BAIX CINCA(*)", "Hermana Andresa, 2", "HUESCA", 974474545, "administracionbajocinca.casar@aragon.es", 1);
INSERT INTO hospital VALUES(230011, "HOSPITAL UNIVERSITARIO MÉDICO- QUIRÚRGICO", "Av. del Ejército Español, 10", "JAÉN", 953008000, "", 0);
INSERT INTO hospital VALUES(230026, "HOSPITAL  UNIVERSITARIO DOCTOR SAGÁZ", "Ctra. del Neveral, s/n", "JAÉN", 953008001, "", 0);
INSERT INTO hospital VALUES(230047, "HOSPITAL UNIVERSITARIO NEUROTRAUMATOLÓGICO", "Ctra. Bailén-Motril, s/n", "JAÉN", 953008000, "", 0);
INSERT INTO hospital VALUES(230063, "CLÍNICA CRISTO REY", "Paseo de la Estación, 40", "JAÉN", 953250440, "", 0);
INSERT INTO hospital VALUES(230079, "HOSPITAL COMARCAL SAN AGUSTÍN", "Av. de San Cristobal, s/n", "JAÉN", 953024200, "", 0);
INSERT INTO hospital VALUES(230098, "HOSPITAL COMARCAL  SAN JUAN DE LA CRUZ", "Ctra. de Linares, km. 1", "JAÉN", 953028200, "", 0);
INSERT INTO hospital VALUES(230119, "COMPLEJO HOSPITALARIO  DE JAÉN", "Av. del Ejército Español, 10", "JAÉN", 953008010, "", 0);
INSERT INTO hospital VALUES(230145, "HOSPITAL ALTO GUADALQUIVIR (*)", "Av. Blas Infante, s/n", "JAÉN", 953021575, "gerencia@ephag.es", 0);
INSERT INTO hospital VALUES(230151, "HOSPITAL UNIVERSITARIO MATERNO-INFANTIL", "Avda. del Ejercito Español, 10", "JAÉN", 953008000, "", 0);
INSERT INTO hospital VALUES(230162, "HOSPITAL DE ALTA RESOLUCION SIERRA DE SEGURA", "Crtra Puente de Génave-La Puerta de Segura Km 0,300", "JAÉN", 953499012, "gerencia@ephag.es", 0);
INSERT INTO hospital VALUES(230173, "HOSPITAL DE ALTA RESOLUCION DE ALCAUDETE", "Camino Viejo de la Fuensanta, 2", "JAÉN", 953368211, "gerencia@ephag.es", 0);
INSERT INTO hospital VALUES(230184, "HOSPITAL DE ALTA RESOLUCIÓN DE ALCALÁ LA REAL", "Avda. Iberoamérica, s/n", "JAÉN", 953599008, "gerencia@ephag.es", 1);
INSERT INTO hospital VALUES(240016, "HOSPITAL DE LEÓN", "Altos de Nava, s/n", "LEÓN", 987237400, "gerente.hleo@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(240021, "HOSPITAL MONTE SAN ISIDRO", "Ctra. de Asturias, s/n", "LEÓN", 987227250, "gerente.hleo@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(240055, "OBRA HOSPITALARIA NUESTRA SEÑORA DE REGLA", "Cardenal Landázuri, 2", "LEÓN", 987236900, "gerencia@hos-regla.org", 0);
INSERT INTO hospital VALUES(240074, "CLÍNICA SAN FRANCISCO", "Marqueses de San Isidro, 11", "LEÓN", 987202111, "sazibaje@clinicasanfrancisco.es", 0);
INSERT INTO hospital VALUES(240093, "HOSPITAL SANTA ISABEL", "Av. de Madrid, 118", "LEÓN", 987203000, "gerente.hleo@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(240135, "HOSPITAL EL BIERZO", "Médicos sin Fronteras, 7", "LEÓN", 987455200, "gerente.hbrz@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(240140, "HOSPITAL DE LA REINA", "Hospital, 26-28", "LEÓN", 987409109, "felixrapun@hospital-reina.com", 0);
INSERT INTO hospital VALUES(240188, "HOSPITAL SAN JUAN DE DIOS", "Av. San Ignacio de Loyola, 73", "LEÓN", 987232500, "leon.hospital@hsjd.es", 0);
INSERT INTO hospital VALUES(240191, "COMPLEJO ASISTENCIAL UNIVERSITARIO DE LEÓN", "Altos de la Nava s/n", "LEÓN", 987237400, "gerente.hleo@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(240205, "CLÍNICA ALTOLLANO", "La Fuentina, s/n. LLanos de Nava. Navatejera", "LEÓN", 987286000, "info@altollano.org", 0);
INSERT INTO hospital VALUES(240212, "CLÍNICA PONFERRADA", "Av. de Galicia, 1", "LEÓN", 987423732, "info@clinicaponferrada.com", 0);
INSERT INTO hospital VALUES(240220, "HOSPITAL VALLE DE LACIANA", "Av. de Asturias, s/n", "LEÓN", 987481057, "afrances@araliaservicios.es", 1);
INSERT INTO hospital VALUES(250019, "HOSPITAL UNIVERSITARI ARNAU DE VILANOVA DE LLEIDA", "Avda. Alcalde Rovira Roure, 80", "LLEIDA", 973248100, "arnau@arnau.scs.es", 1);
INSERT INTO hospital VALUES(250024, "HOSPITAL SANTA MARIA", "Avda Alcalde Rovira Roure, 44", "LLEIDA", 973727222, "gerencia@gss.scs.es", 1);
INSERT INTO hospital VALUES(250045, "HOSPITAL MONTSERRAT", "Bisbe Torres, 13", "LLEIDA", 973266300, "", 0);
INSERT INTO hospital VALUES(250058, "CLÍNICA NOSTRA SENYORA DEL PERPETU SOCORS", "Bisbe Messeguer, 3", "LLEIDA", 973266100, "ipaules@asisa.es", 0);
INSERT INTO hospital VALUES(250061, "CLÍNICA TERRES DE PONENT", "Avda. Enric Prat de la Riba, 79-81", "LLEIDA", 973232943, "gerencia@clinicalleida.com", 0);
INSERT INTO hospital VALUES(250077, "CLÍNICA PSIQUIÀTRICA BELLAVISTA", "Rovira Roure, 116", "LLEIDA", 973231698, "", 0);
INSERT INTO hospital VALUES(250117, "FUNDACIÓ SANT HOSPITAL", "Passeig Joan Brudieu, 8", "LLEIDA", 973350050, "gerencia@hospseu.es", 0);
INSERT INTO hospital VALUES(250138, "CENTRE SANITARI DEL SOLSONÈS, FPC", "Plaza Antoni Guitart, 1", "LLEIDA", 973481172, "info@cssolsones.com", 1);
INSERT INTO hospital VALUES(250143, "HOSPITAL COMARCAL DEL PALLARS", "Pau Casals, 5", "LLEIDA", 973652255, "hcp@hospitalpallars.com", 1);
INSERT INTO hospital VALUES(250156, "ESPITAU VAL D'ARAN", "Espitau, 8", "LLEIDA", 973640004, "", 0);
INSERT INTO hospital VALUES(250169, "HOSPITAL JAUME D'URGELL", "Gregori Gallego, s/n", "LLEIDA", 973450304, "hospitaljaumeurgell@jaumeurgell.org", 0);
INSERT INTO hospital VALUES(250175, "RESIDÈNCIA TERRAFERMA", "Partida del Graó, s/n", "LLEIDA", 973737455, "", 0);
INSERT INTO hospital VALUES(250181, "CASTELL D'OLIANA RESIDENCIAL,S.L.", "Carretera de Lleida a Puigcerdà km.89", "LLEIDA", 973463030, "", 0);
INSERT INTO hospital VALUES(250209, "HOSPITAL JAUME NADAL MEROLES", "Acadèmia, 41", "LLEIDA", 973289333, "", 0);
INSERT INTO hospital VALUES(250210, "CENTRE ASSISTENCIAL SANT JOAN DE DÉU", "Carretera N- 240, 111", "LLEIDA", 973740010, "mvalencia@pssjd.org", 0);
INSERT INTO hospital VALUES(260012, "COMPLEJO HOSPITAL SAN PEDRO*", "Piqueras 98", "LA RIOJA", 941298000, "", 1);
INSERT INTO hospital VALUES(260027, "HOSPITAL SAN PEDRO", "Ctra. de Piqueras, 98", "LA RIOJA", 941298000, "", 1);
INSERT INTO hospital VALUES(260048, "HOSPITAL GENERAL DE LA RIOJA", "Av. de Viana, s/n", "LA RIOJA", 941298000, "", 1);
INSERT INTO hospital VALUES(260051, "POLICLÍNICO RIOJANO NUESTRA SEÑORA DE VALVANERA, S.A.", "Calle Ramón y Cajal s/n", "LA RIOJA", 941211900, "losmanzanos@viamedlosmanzanos.com", 0);
INSERT INTO hospital VALUES(260099, "FUNDACIÓN HOSPITAL CALAHORRA (*)", "Ctra. Logroño, s/n", "LA RIOJA", 941151000, "calahorra.fhc@riojasalud.es", 1);
INSERT INTO hospital VALUES(260109, "CLÍNICA LOS MANZANOS", "Hermanos Maristas s/n", "LA RIOJA", 941499490, "losmanzanos@viamedlosmanzanos.com", 0);
INSERT INTO hospital VALUES(260110, "CENTRO ASISTENCIAL ALBELDA DE IREGUA", "Crta. Soria Km. 8", "LA RIOJA", 941279220, "", 1);
INSERT INTO hospital VALUES(260121, "CENTRO SOCIOSANITARIO DE CONVALENCENCIA LOS JAZMINES", "Severo Ochoa, 5", "LA RIOJA", 941303650, "", 0);
INSERT INTO hospital VALUES(260132, "CENTRO  SOCIOSANITARIO  DE CONVALECENCIA NUESTRA SEÑORA VIRGEN DEL CARMEN", "Santiago Ramón y Cajal S/n", "LA RIOJA", 941010000, "losmanzanos@viamedlosmanzanos.com", 0);
INSERT INTO hospital VALUES(270018, "COMPLEXO HOSPITALARIO UNIVERSITARIO XERAL-CALDE DE LUGO", "Ulises Romero, 1", "LUGO", 982296000, "Jesus.Conde.Freire@sergas.es", 1);
INSERT INTO hospital VALUES(270039, "HOSPITAL DE CALDE", "Calde, s/n", "LUGO", 982296000, "Jesus.Conde.Freire@sergas.es", 1);
INSERT INTO hospital VALUES(270057, "POLICLÍNICO LUCENSE", "Dr. Iglesias Otero, s/n", "LUGO", 982222854, "polusa@ctv.es", 0);
INSERT INTO hospital VALUES(270076, "SANATORIO NOSA SEÑORA DOS OLLOS GRANDES", "Montevideo, 23", "LUGO", 982284040, "administracion@nsog.es", 0);
INSERT INTO hospital VALUES(270095, "HOSPITAL DA COSTA", "Médico  Vior, s/n", "LUGO", 982589901, "", 1);
INSERT INTO hospital VALUES(270109, "HOSPITAL COMARCAL DE MONFORTE", "Corredoira, s/n", "LUGO", 982417900, "Hospital.Monforte.Gerencia@sergas.es", 1);
INSERT INTO hospital VALUES(270122, "HOSPITAL UNIVERSITARIO LUCUS AUGUSTI", "Ulises Romero, 1", "LUGO", 982296000, "Jesus.Conde.Freire@sergas.es", 1);
INSERT INTO hospital VALUES(280014, "HOSPITAL UNIVERSITARIO LA PAZ", "Pº de la Castellana, 261", "MADRID", 917277000, "gencia.hulp@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280029, "HOSPITAL RAMÓN Y CAJAL", "Ctra. de Colmenar Viejo, km. 9,1", "MADRID", 913368000, "", 1);
INSERT INTO hospital VALUES(280035, "HOSPITAL UNIVERSITARIO 12 DE OCTUBRE", "Av. de Córdoba, s/n", "MADRID", 913908000, "gerent.hdoc@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280072, "HOSPITAL CLÍNICO SAN CARLOS", "Prof. Martín Lagos, s/n", "MADRID", 913303000, "", 1);
INSERT INTO hospital VALUES(280091, "HOSPITAL VIRGEN DE LA TORRE", "Puerto Lumbreras, 5", "MADRID", 911918883, "gerent.hvtr@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280112, "HOSPITAL UNIVERSITARIO SANTA CRISTINA", "Maestro Vives, 2", "MADRID", 915574300, "gencia.hscr@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280127, "HOSPITAL UNIVERSITARIO DE LA PRINCESA", "Diego de León, 62", "MADRID", 915202200, "gencia.hlpr@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280133, "HOSPITAL INFANTIL UNIVERSITARIO NIÑO JESUS", "Av. Menéndez Pelayo, 65", "MADRID", 915035900, "gerent.hnjs@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280148, "HOSPITAL CENTRAL DE LA CRUZ ROJA SAN JOSÉ Y SANTA ADELA", "Av. de la Reina Victoria, 22-26", "MADRID", 914538300, "gerent.hccruzr@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280164, "HOSPITAL CARLOS III", "Sinesio Delgado, 8-10", "MADRID", 917277000, "gencia.hulp@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280210, "HOSPITAL CANTOBLANCO", "Ctra. de Colmenar Viejo, km. 14,5", "MADRID", 917277000, "gencia.hulp@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280225, "COMPLEJO HOSPITALARIO GREGORIO MARAÑÓN", "Dr Esquerdo, 46", "MADRID", 915868000, "gerencia.hgugm@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280231, "INSTITUTO OFTÁLMICO DE MADRID", "General Arrando, 17", "MADRID", 915867300, "", 1);
INSERT INTO hospital VALUES(280246, "HOSPITAL GENERAL UNIVERSITARIO GREGORIO MARAÑÓN", "Dr Esquerdo, 46", "MADRID", 915868000, "", 1);
INSERT INTO hospital VALUES(280259, "INSTITUTO PROVINCIAL DE REHABILITACIÓN", "Francisco Silvela, 40", "MADRID", 915868967, "", 1);
INSERT INTO hospital VALUES(280262, "HOSPITAL DR. R. LAFORA", "Ctra. de Colmenar Viejo, km. 13,8", "MADRID", 915867500, "gerent.hlafora@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280323, "SANATORIO NUESTRA SEÑORA DEL ROSARIO", "Príncipe de Vergara, 53", "MADRID", 914359100, "h.rosario@hospitalrosario.com", 0);
INSERT INTO hospital VALUES(280339, "HOSPITAL SAN RAFAEL", "Serrano, 199", "MADRID", 915649943, "sanrafael.secretaria@hsjd.es", 0);
INSERT INTO hospital VALUES(280344, "HOSPITAL DE LA V.O.T. DE SAN FRANCISCO DE ASÍS", "San Bernabé, 13", "MADRID", 913657600, "administrador@hospitalvot.es", 0);
INSERT INTO hospital VALUES(280357, "HOSPITAL QUIRÓN SAN JOSÉ", "Cartagena, 111", "MADRID", 902024747, "info.sanjose@quiron.es", 0);
INSERT INTO hospital VALUES(280360, "HOSPITAL BEATA MARÍA ANA. HH. HOSPITALARIAS SGDO. C. DE JESÚS", "Dr Esquerdo, 83", "MADRID", 914097423, "jmsanabria@hospitalariasmadrid.org", 0);
INSERT INTO hospital VALUES(280376, "CLÍNICA SANTA ELENA", "La Granja, 8", "MADRID", 914539400, "informacion@clinica-santa-elena.org", 0);
INSERT INTO hospital VALUES(280382, "HOSPITAL SAN FRANCISCO DE ASÍS", "Joaquín Costa, 28", "MADRID", 915617100, "jmanuel.lopez@ssfda.com", 0);
INSERT INTO hospital VALUES(280395, "CLINICA SAN MIGUEL", "Arturo Soria, 204", "MADRID", 914135011, "amartin@hospitalariasmadrid.org", 0);
INSERT INTO hospital VALUES(280409, "CLÍNICA NUESTRA SRA. DE LA PAZ", "López de Hoyos, 259", "MADRID", 914156000, "Madrid@sjd.es", 0);
INSERT INTO hospital VALUES(280416, "FUNDACIÓN INSTITUTO SAN JOSÉ", "C\ Pinar de San José, 98", "MADRID", 915080140, "fisj@ohsjd.es", 0);
INSERT INTO hospital VALUES(280421, "HOSPITAL UNIVERSITARIO FUNDACIÓN JIMÉNEZ DÍAZ", "Av. de los Reyes Católicos, 2", "MADRID", 915504800, "fjd@fjd.es", 0);
INSERT INTO hospital VALUES(280442, "HOSPITAL VIRGEN DEL MAR", "Calle Honduras, 14", "MADRID", 913539500, "jmestevezh@sanitas.es", 0);
INSERT INTO hospital VALUES(280455, "CLÍNICA SEAR, S.A.", "Ctra. de Colmenar Viejo, km. 16", "MADRID", 917340500, "sear@clinicasear.com", 0);
INSERT INTO hospital VALUES(280468, "HOSPITAL QUIRON SAN CAMILO", "Juan Bravo, 39", "MADRID", 902112121, "sca.info@usphospitales.com", 0);
INSERT INTO hospital VALUES(280474, "HOSPITAL NUESTRA SEÑORA DE AMERICA", "Arturo Soria, 103", "MADRID", 902500112, "comunicacion@vithas.es", 0);
INSERT INTO hospital VALUES(280528, "HOSPITAL VIRGEN DE LA PALOMA, S.A.", "Loma, 1", "MADRID", 915348207, "facturacion@hospitalvpaloma.com", 0);
INSERT INTO hospital VALUES(280534, "CLÍNICA LA LUZ, S.L.", "General Rodrigo, 8", "MADRID", 914530200, "secretaria@clinicalaluz.es", 0);
INSERT INTO hospital VALUES(280549, "FUENSANTA S.L. (CLÍNICA FUENSANTA)", "Arturo Soria, 17", "MADRID", 914100200, "clinicafuensanta@grupofuensanta.com", 0);
INSERT INTO hospital VALUES(280552, "CLÍNICA RUBER, S.A.", "Juan Bravo, 49", "MADRID", 914026100, "direccion@ruber.es", 0);
INSERT INTO hospital VALUES(280565, "HOSPITAL RUBER INTERNACIONAL", "La Masó, 38", "MADRID", 913875000, "ruber@ruberinternacional.es", 0);
INSERT INTO hospital VALUES(280587, "CLÍNICA LA MILAGROSA", "Modesto Lafuente, 14", "MADRID", 914472100, "lamilagrosa@lamilagrosa.com", 0);
INSERT INTO hospital VALUES(280604, "HOSPITAL DE LA ZARZUELA", "Pléyades, 25 (Aravaca)", "MADRID", 915858000, "ampolanco@sanitas.es", 0);
INSERT INTO hospital VALUES(280626, "CLÍNICA MATERNIDAD NUESTRA SEÑORA DE BELÉN", "José Silva, 7", "MADRID", 917444100, "pmonteliu@hmhospitales.com", 0);
INSERT INTO hospital VALUES(280647, "SANATORIO NEUROPSIQUIÁTRICO DOCTOR LEÓN", "Pza Mariano de Cavia, 3", "MADRID", 914332948, "sanatoriodrleon@telefonica.net", 0);
INSERT INTO hospital VALUES(280650, "INSTITUTO DE INVESTIGACIONES NEUROPSIQUIÁTRICAS DR. LÓPEZ IBOR", "Doctor Juan José Lopez Ibor, 2", "MADRID", 913162740, "info@lopezibor.com", 0);
INSERT INTO hospital VALUES(280679, "SANATORIO ESQUERDO, S.A.", "Av. de los Poblados, 70", "MADRID", 917061100, "info@sanatorioesquerdo.com", 0);
INSERT INTO hospital VALUES(280724, "HOSPITAL CENTRAL DE LA DEFENSA GOMEZ ULLA", "Glorieta del Ejército, s/n", "MADRID", 914222000, "", 1);
INSERT INTO hospital VALUES(280745, "HOSPITAL UNIVERSITARIO PRÍNCIPE DE ASTURIAS", "Ctra. Alcalá-Meco, s/n", "MADRID", 918878100, "gerent.hupa@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280761, "HOSPITAL DE LA FUENFRÍA", "Ctra. de Las Dehesas, s/n", "MADRID", 918520300, "gencia.hlff@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280777, "HH. HH. SGDO. C. DE JESÚS. COMPLEJO ASISTENCIAL BENITO MENNI", "Jardines, 1", "MADRID", 918930150, "jrodriguez@hospitalariasmadrid.org", 0);
INSERT INTO hospital VALUES(280783, "CENTRO SAN JUAN DE DIOS", "Av. de San Juan de Dios, 1", "MADRID", 918930001, "elvira.conde@sjd.es", 0);
INSERT INTO hospital VALUES(280796, "HOSPITAL MONOGRÁFICO ASEPEYO DE TRAUMAT. CIRUGÍA Y REHABILITACIÓN", "Joaquín de Cárdenas, 2", "MADRID", 916735011, "IGARCIAGISMERA@ASEPEYO.ES", 0);
INSERT INTO hospital VALUES(280800, "HOSPITAL GUADARRAMA", "Paseo del Molino del Rey, 2", "MADRID", 918562000, "gerencia.hgua@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280838, "HOSPITAL UNIVERSITARIO SEVERO OCHOA", "Av. de Orellana, s/n", "MADRID", 914818000, "gencia.hsvo@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280843, "INSTITUTO PSIQUIÁTRICO SERVICIOS DE SALUD MENTAL JOSÉ GERMAIN", "La Luna, 1", "MADRID", 915866767, "gerencia.ipjg@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280856, "FREMAP HOSPITAL Y CENTRO DE REHABILITACIÓN DE MAJADAHONDA", "Ctra. de Pozuelo, 61", "MADRID", 916265642, "braulio_garrido@fremap.es", 0);
INSERT INTO hospital VALUES(280894, "HOSPITAL UNIVERSITARIO DE MÓSTOLES", "Río Júcar, s/n", "MADRID", 916648600, "gerent.hmtl@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280920, "HOSPITAL EL ESCORIAL", "Ctra. Guadarrama-S. Lorenzo de El Escorial, km. 6,2", "MADRID", 918973000, "hospitalelescorial.h@salud.madrid.org", 1);
INSERT INTO hospital VALUES(280936, "HOSPITAL VIRGEN DE LA POVEDA", "Ctra. del Hospital, s/n km. 5", "MADRID", 918608000, "hvirgen.poveda@madrid.org", 1);
INSERT INTO hospital VALUES(280954, "HOSPITAL DE MADRID", "Pza Conde del Valle de Suchill, 16", "MADRID", 914476600, "msanchezgalindo@hmhopsitales.com", 0);
INSERT INTO hospital VALUES(280989, "HOSPITAL UNIVERSITARIO DE GETAFE", "Crtra de Toledo, km. 12,5", "MADRID", 916839360, "gencia.hugf@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281034, "CLÍNICA ISADORA", "Pirineos, 7", "MADRID", 913111000, "clinica-isadora@clinica-isadora.es", 0);
INSERT INTO hospital VALUES(281049, "HOSPITAL MONCLOA", "Av. Valladolid, 83", "MADRID", 915957292, "direccion@hospitalmoncloa.es", 0);
INSERT INTO hospital VALUES(281071, "HOSPITAL UNIVERSITARIO FUNDACIÓN ALCORCÓN (*)", "Budapest, 1", "MADRID", 916219400, "direcciongerencia@fhalcorcon.es", 1);
INSERT INTO hospital VALUES(281087, "CLINICA CEMTRO", "Av. Ventisquero de la Condesa, 42", "MADRID", 917355757, "administracion@clinicacemtro.com", 0);
INSERT INTO hospital VALUES(281090, "HM HOSPITAL UNIVERSITARIO DE MONTEPRÍNCIPE", "Av. Montepríncipe, 25", "MADRID", 917089900, "secretariadirmed@hospitaldemadrid.com", 0);
INSERT INTO hospital VALUES(281113, "CENTRO ONCOLÓGICO MD ANDERSON INTERNATIONAL ESPAÑA", "Gómez Hemans. 2-4", "MADRID", 917878600, "admision.plataforma902@mdanderson.es", 0);
INSERT INTO hospital VALUES(281124, "HOSPITAL SUR", "Estambul, 30", "MADRID", 916496600, "hospitalsur@idcsalud.es", 0);
INSERT INTO hospital VALUES(281146, "HOSPITAL UNIVERSITARIO DE FUENLABRADA (*)", "Camino del Molino, 2", "MADRID", 916006000, "gerencia.hflr@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281157, "HOSPITAL UNIVERSITARIO HM TORRELODONES", "Av. Castillo Olivares s/n", "MADRID", 912675000, "mvillarino@hmhospitales.com", 0);
INSERT INTO hospital VALUES(281168, "COMPLEJO UNIVERSITARIO LA PAZ", "Pº de la Castellana, 261", "MADRID", 917277000, "gencia.hulp@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281179, "HOSPITAL LA MORALEJA", "Av. Francisco Pi y Margall, 81", "MADRID", 917679100, "bruiz@sanitas.es", 0);
INSERT INTO hospital VALUES(281180, "HOSPITAL LOS MADROÑOS", "Crtra. M-501 Km 17,900 (Vía de Servicio)", "MADRID", 918163526, "beatriz.alejo@lmh.es", 0);
INSERT INTO hospital VALUES(281203, "HOSPITAL QUIRÓN MADRID", "Diego de Velazquez, 1", "MADRID", 902151016, "direccion.mad@quiron.es", 0);
INSERT INTO hospital VALUES(281214, "HOSPITAL CENTRO DE CUIDADOS LAGUNA", "Concejal Francisco José Jiménez Martín, 128", "MADRID", 915099137, "direccion@lagunacuida.org", 0);
INSERT INTO hospital VALUES(281225, "HOSPITAL UNIVERSITARIO MADRID SANCHINARRO*", "Oña, 10", "MADRID", 917567800, "rlaguna@hmhospitales.com", 0);
INSERT INTO hospital VALUES(281236, "HOSPITAL INFANTA ELENA (*)", "Av. Reyes Católicos, 21", "MADRID", 918948540, "sonia.gonzalez@capiosanidad.es", 1);
INSERT INTO hospital VALUES(281247, "HOSPITAL PARDO DE ARAVACA", "La Salle, 12", "MADRID", 915129000, "aravaca@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(281258, "HOSPITAL UNIVERSITARIO INFANTA SOFÍA (*)", "Paseo de Europa, 34", "MADRID", 911914000, "gerencia.hnor@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281269, "HOSPITAL UNIVERSITARIO DEL HENARES (*)", "Av. Marie Curie, s/n", "MADRID", 911912000, "gerencia.hhen@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281270, "HOSPITAL UNIVERSITARIO INFANTA LEONOR (*)", "Gran Vía del Este, 80", "MADRID", 911918000, "gerencia.hvll@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281281, "HOSPITAL UNIVERSITARIO DEL SURESTE (*)", "Ronda del Sur, 10", "MADRID", 918394454, "gerencia.hses@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281292, "HOSPITAL UNIVESITARIO DEL TAJO (*)", "Avda. Amazonas Central, s/n", "MADRID", 918014101, "gerencia.htaj@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281304, "HOSPITAL UNIVERSITARIO INFANTA CRISTINA (*)", "Av. 9 de Junio, 2", "MADRID", 911913500, "gerencia.hsur@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281315, "HOSPITAL UNIVERSITARIO PUERTA DE HIERRO MAJADAHONDA", "Joaquín Rodrígo, 2", "MADRID", 911916000, "gerent.hpth@salud.madrid.org", 1);
INSERT INTO hospital VALUES(281326, "CASTA GUADARRAMA", "Carretera Nacional VI, Km. 50,300", "MADRID", 918548328, "direccionguadarrama@castasalud.com", 0);
INSERT INTO hospital VALUES(281337, "HOSPITAL DE TORREJON", "Mateo Inurria, s/n", "MADRID", 916262518, "gerencia@torrejonsalud.com", 1);
INSERT INTO hospital VALUES(281348, "HOSPITAL REY JUAN CARLOS (*)", "Gladiolo s/n", "MADRID", 914816225, "", 1);
INSERT INTO hospital VALUES(281359, "HOSPITAL GENERAL DE VILLALBA", "Ctra. M-608. Km 41", "MADRID", 910908102, "", 1);
INSERT INTO hospital VALUES(281360, "HM UNIVERSITARIO PUERTA DEL SUR", "Avenida de Carlos V, 70", "MADRID", 912673100, "", 0);
INSERT INTO hospital VALUES(290017, "HOSPITAL GENERAL", "Av. Carlos Haya, s/n", "MALAGA", 951030100, "", 0);
INSERT INTO hospital VALUES(290022, "HOSPITAL VIRGEN DE LA VICTORIA", "Colonia de Sta. Ines, s/n", "MALAGA", 951032000, "", 0);
INSERT INTO hospital VALUES(290038, "HOSPITAL CIVIL", "Av. Doctor Galvez Ginachero, s/n", "MALAGA", 951030300, "", 0);
INSERT INTO hospital VALUES(290043, "HOSPITAL CIUDAD JARDÍN", "Av. Jorge Silvela, 8-10", "MALAGA", 951030400, "", 0);
INSERT INTO hospital VALUES(290069, "CENTRO ASISTENCIAL SAN JUAN DE DIOS", "Ctra. Casabermeja, 126", "MALAGA", 952250550, "centro11@malaga1.betica.sanjuandedios-oh", 0);
INSERT INTO hospital VALUES(290075, "CENTRO ASISTENCIAL HNAS. HOSP. DEL SAGRADO CORAZÓN DE JESÚS", "San Juan Bosco, 41", "MALAGA", 952256150", 0);2administracion@hscmadrid.org", 0);
INSERT INTO hospital VALUES(290081, "CLINICA PARQUE SAN ANTONIO", "Av. Pintor Joaquín Sorolla, 2", "MALAGA", 952211050, "jmtamara@parquesanantonio.nehos.com", 0);
INSERT INTO hospital VALUES(290094, "CLINICA EL ÁNGEL", "Corregidor Nicolás Isidro, 16", "MALAGA", 952045000, "admon.elangel@asisa.es", 0);
INSERT INTO hospital VALUES(290108, "SANATORIO DOCTOR GALVEZ", "San Agustín, 1", "MALAGA", 952224295, "", 0);
INSERT INTO hospital VALUES(290115, "CLÍNICA DE LA ENCARNACIÓN", "Fernández de Alarcón, 2", "MALAGA", 952287766, "info@clinicadelaencarnacion.com", 0);
INSERT INTO hospital VALUES(290136, "HOSPITAL PSIQUIÁTRICO SAN FRANCISCO DE ASÍS", "Av. Hernán Nuñez de Toledo, 5", "MALAGA", 952201464, "hospital@hospitalsanfrancisco.com", 0);
INSERT INTO hospital VALUES(290141, "CLÍNICA NUESTRA SRA. DEL PILAR", "Pº de Sancha, 15-17", "MALAGA", 952217606, "clinicadelpilar@clinicadelpilar.com", 0);
INSERT INTO hospital VALUES(290154, "HOSPITAL COMARCAL DE ANTEQUERA", "Av. del Poeta Muñoz Rojas, s/n", "MALAGA", 951061008, "informacion2.han.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(290173, "HOSPITAL QUIRÓN DE MARBELLA (ANTIGUO USP HOSPITAL DE MARBELLA)", "Av. Severo Ochoa, 22", "MALAGA", 952774200, "", 0);
INSERT INTO hospital VALUES(290192, "HOSPITAL COMARCAL DE LA SERRANÍA", "Ctra. El Burgo, Km.1", "MALAGA", 951065076, "direccion.hsr.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(290206, "HOSPITAL  COMARCAL DE LA AXARQUÍA", "Urb. El Tomillar, s/n", "MALAGA", 951067010, "", 0);
INSERT INTO hospital VALUES(290213, "HOSPITAL DE TORREMOLINOS", "Sanatorio, 5", "MALAGA", 951033735, "", 0);
INSERT INTO hospital VALUES(290228, "CLÍNICA SANTA ELENA", "Urbanización Los Alamos, s/n", "MALAGA", 952386266, "seara@csantaelena.com", 0);
INSERT INTO hospital VALUES(290234, "COMPLEJO HOSPITALARIO REGIONAL DE MÁLAGA", "Av. Carlos Haya, s/n", "MALAGA", 951030100, "", 0);
INSERT INTO hospital VALUES(290252, "COMPLEJO HOSPITALARIO DE ESPECIALIDADES VIRGEN DE LA VICTORIA", "Campus Universitario Teatinos, s/n", "MALAGA", 951032000, "", 0);
INSERT INTO hospital VALUES(290265, "HOSPITAL MATERNO INFANTIL", "Arroyo de los Angeles, s/n", "MALAGA", 951030200, "", 0);
INSERT INTO hospital VALUES(290287, "COMPLEJO HOSPITAL COSTA DEL SOL (*)", "Autovía A-7, km. 187", "MALAGA", 952828250, "", 0);
INSERT INTO hospital VALUES(290290, "HOSPITAL  F.A.C. DOCTOR PASCUAL", "Amargura, 31", "MALAGA", 951019100, "hospitaldrpascual@jmpascual.com", 0);
INSERT INTO hospital VALUES(290348, "CLÍNICA EL SERANIL", "Crtra. de Almería Km 261", "MALAGA", 952513267, "clinica@seranil.com", 0);
INSERT INTO hospital VALUES(290359, "CLÍNICA MARBELLA HIGH CARE", "Urb. Las Mimosas. Casa Santa Isabel, s/n (Nueva Andalucía)", "MALAGA", 952908628, "bdc@marbellahighcare.com", 0);
INSERT INTO hospital VALUES(290360, "HOSPITAL HUMANLINE BANUS (antiguo ROYAL MARBELLA HOSPITAL)", "C. Nacional 340, KM. 176, Puerto Banús", "MALAGA", 951055950, "infobanus@humanline.es", 0);
INSERT INTO hospital VALUES(290371, "CLINICA RINCON BEJAR", "Av. de la Torre, 24", "MALAGA", 902300107, "josequesada@clinicasrincon.com", 0);
INSERT INTO hospital VALUES(290382, "HOSPITEN ESTEPONA", "Crtra. Nacional 340, Km 162. Partido de Velerin", "MALAGA", 952760600, "estepona@hospiten.com", 0);
INSERT INTO hospital VALUES(290393, "CENTRO DE CUIDADOS PALIATIVOS", "Av. del Cosmos, s/n (Arroyo de la Miel-Benalmádena Costa)", "MALAGA", 952564910, "", 0);
INSERT INTO hospital VALUES(290405, "XANIT HOSPITAL INTERNACIONAL", "Avda. de los Argonautas, s/n (Arroyo de la Miel-Benalmádena Costa)", "MALAGA", 952443119, "xanit@xanit.net", 0);
INSERT INTO hospital VALUES(290416, "COMUNIDAD TERAPEUTICA SAN ANTONIO", "Extremadura, 8", "MALAGA", 952201464, "", 0);
INSERT INTO hospital VALUES(290427, "HOSPITAL DE ALTA RESOLUCIÓN DE BENALMÁDENA", "Avda. Arroyo Hondo, s/n", "MALAGA", 951976000, "", 0);
INSERT INTO hospital VALUES(290438, "POLICLÍNICA LITORAL", "Mendoza, s/n", "MALAGA", 952350401, "mcperez@intradi.com", 0);
INSERT INTO hospital VALUES(290449, "HOSPITAL QUIRON", "Av Imperio Argentina 1", "MALAGA", 952176016, "direccion.mlg@quiron.es", 0);
INSERT INTO hospital VALUES(290450, "CLÍNICA PREMIUM INTERNACIONAL", "Avda. Andalucía, 4", "MALAGA", 659051380, "direccionadministrativa@clinicapremium.com", 0);
INSERT INTO hospital VALUES(290461, "CENTRO CLÍNICO OCHOA", "Avda. Severo Ochoa, s/n, Edificio Mayoral", "MALAGA", 952861400, "clinicaochoa@clinicaochoa.com", 0);
INSERT INTO hospital VALUES(300011, "HOSPITAL CLÍNICO UNIVERSITARIO VIRGEN DE LA ARRIXACA", "Ctra. Madrid-Cartagena, s/n. (El Palmar)", "MURCIA", 968369500, "mariai.santos@carm.es", 1);
INSERT INTO hospital VALUES(300026, "HOSPITAL GENERAL UNIVERSITARIO REINA SOFIA", "Av. Intendente Jorge Palacios, 1", "MURCIA", 968359000, "", 1);
INSERT INTO hospital VALUES(300032, "HOSPITAL PSIQUIÁTRICO ROMAN ALBERCA", "Lorca, 58  (El Palmar)", "MURCIA", 968365800, "", 1);
INSERT INTO hospital VALUES(300050, "HOSPITAL QUIRÓN MURCIA", "Miguel Hernández, 12", "MURCIA", 968365000, "admision.hsc@quiron.es", 0);
INSERT INTO hospital VALUES(300063, "CLÍNICA NUESTRA SEÑORA DE BELÉN", "Almirante Gravina, 2", "MURCIA", 968233500, "contacto@hospitallavega.es", 0);
INSERT INTO hospital VALUES(300079, "HOSPITAL LA VEGA", "Román Alberca, s/n", "MURCIA", 968278100, "contacto@hospitallavega.es", 0);
INSERT INTO hospital VALUES(300085, "HOSPITAL MESA DEL CASTILLO", "Ronda Sur, 20", "MURCIA", 968246116, "hmdc@mesadelcastillo.com", 0);
INSERT INTO hospital VALUES(300098, "SANATORIO DOCTOR MUÑOZ S.L.", "Ctra. Cartagena, 59", "MURCIA", 968885550, "javier.munoz@clinicamunoz.com", 0);
INSERT INTO hospital VALUES(300119, "CLÍNICA MÉDICO-QUIRÚRGICA SAN JOSÉ, S.A.", "Maestra Lola Meseguer, s/n", "MURCIA", 968800600, "sanjose@viamedsanjose.com", 0);
INSERT INTO hospital VALUES(300124, "HOSPITAL COMARCAL DEL NOROESTE", "Av. Miguel Espinosa, 1", "MURCIA", 968709100, "rita.pla@carm.es", 1);
INSERT INTO hospital VALUES(300130, "CLÍNICA DOCTOR BERNAL S.L.", "Dr. Robles, s/n", "MURCIA", 968705541, "info@hospitalbernal.com", 0);
INSERT INTO hospital VALUES(300145, "HOSPITAL GENERAL UNIVERSITARIO SANTA MARÍA DEL ROSELL", "Pº Alfonso XIII, 61", "MURCIA", 968504800, "", 1);
INSERT INTO hospital VALUES(300161, "HOSPITAL DE LA CARIDAD - LOS PINOS", "Camino Barrio Peral s/n (Los Barreros)", "MURCIA", 968510300, "lgimenez@roldan1693.es", 0);
INSERT INTO hospital VALUES(300177, "HOSPITAL NUESTRA SEÑORA DEL PERPETUO SOCORRO", "Sebastián Feringan, 12", "MURCIA", 968510500, "hospital@perpetuosocorro.es", 0);
INSERT INTO hospital VALUES(300196, "FUNDACION HOSPITAL REAL PIEDAD", "Pza del Mesoncico, 3 y Mayor, 22", "MURCIA", 968741156, "fundacionrealpiedad@hrpiedad.es", 0);
INSERT INTO hospital VALUES(300217, "HOSPITAL VIRGEN DEL ALCAZAR", "Alameda de los Tristes, s/n", "MURCIA", 968468600, "cmva@virgendelalcazar.com", 0);
INSERT INTO hospital VALUES(300222, "HOSPITAL GENERAL UNIVERSITARIO LOS ARCOS DEL MAR MENOR", "Paraje Torre Octavio, S/N. (Pozo Aledo)", "MURCIA", 968565000, "", 1);
INSERT INTO hospital VALUES(300243, "HOSPITAL VIRGEN DEL CASTILLO", "Av. de la Feria, s/n", "MURCIA", 968719800, "", 1);
INSERT INTO hospital VALUES(300256, "HOSPITAL RAFAEL MÉNDEZ", "Ctra. Nacional 340, km. 589", "MURCIA", 968445500, "", 1);
INSERT INTO hospital VALUES(300269, "HOSPITAL GENERAL UNIVERSITARIO J.M. MORALES MESEGUER", "Av. Marqués de los Vélez, s/n", "MURCIA", 968244200, "mpilar.fernandez2@carm.es", 1);
INSERT INTO hospital VALUES(300275, "HOSPITAL IBERMUTUAMUR-PATOLOGÍA LABORAL", "Antonio Rocamora, 4. Edificio Ibermutuamur (Espinardo)", "MURCIA", 968394000, "", 0);
INSERT INTO hospital VALUES(300281, "HOSPITAL DE LA VEGA LORENZO GUIRAO", "Ctra. de Abarán, s/n", "MURCIA", 968775550, "carlosa.arenas@carm.es", 1);
INSERT INTO hospital VALUES(300294, "HOSPITAL DE MOLINA", "Asociación, s/n", "MURCIA", 968644030, "hmolina@hospitaldemolina.com", 0);
INSERT INTO hospital VALUES(300317, "CLINICA SAN FELIPE DEL MEDITERRÁNEO", "Finca el Mayayo, 16 (El Palmar)", "MURCIA", 968889096, "jcarrilero77@hotmail.com", 0);
INSERT INTO hospital VALUES(300339, "RESIDENCIA VILLADEMAR", "Av Concejal Mariano Henarejos, 13", "MURCIA", 968187346, "info@villademar.com", 0);
INSERT INTO hospital VALUES(300340, "RESIDENCIA LOS ALMENDROS", "Paraje Los Pinos, s/n (Perín)", "MURCIA", 968168716, "info@residencialosalmendros.com", 0);
INSERT INTO hospital VALUES(300351, "COMPLEJO HOSPITALARIO UNIVERSITARIO DE CARTAGENA", "Pº Alfonso XIII, 61", "MURCIA", 968504800, "", 1);
INSERT INTO hospital VALUES(300362, "HOSPITAL GENERAL UNIVERSITARIO SANTA LUCIA", "Mezquita, s/n. Paraje Los Arcos. Barrio de Santa Lucía", "MURCIA", 968128600, "", 1);
INSERT INTO hospital VALUES(300373, "HOSPITAL PERPETUO SOCORRO ALAMEDA", "Alameda de San Anton nº 6", "MURCIA", 968115055, "", 0);
INSERT INTO hospital VALUES(310039, "CENTRO SAN FRANCISCO JAVIER", "Av. Villava, 53", "NAVARRA", 848422730, "rehabilitacion.psicogeriatrico@cfnavarra.es", 1);
INSERT INTO hospital VALUES(310044, "HOSPITAL SAN JUAN DE DIOS", "Beloso Alto, 3", "NAVARRA", 948231800, "hsjdpamplona@ohsjd.es", 0);
INSERT INTO hospital VALUES(310057, "CLÍNICA PSIQUIÁTRICA PADRE MENNI", "Joaquín Beúnza, 45", "NAVARRA", 948140611, "", 0);
INSERT INTO hospital VALUES(310060, "CLINICA UNIVERSIDAD DE NAVARRA", "Av. Pio XII, 36", "NAVARRA", 948255400, "www.cun.es", 0);
INSERT INTO hospital VALUES(310076, "CLÍNICA ARCANGEL SAN MIGUEL", "Beloso Alto, 32", "NAVARRA", 948296000, "", 0);
INSERT INTO hospital VALUES(310095, "CLÍNICA SAN FERMIN, S.A.", "Av. de Galicia, 2-A", "NAVARRA", 948235850, "clinica@clinicasanfermin.com", 0);
INSERT INTO hospital VALUES(310109, "CENTRO HOSPITALARIO BENITO MENNI", "Mendinueta, s/n. (Elizondo)", "NAVARRA", 948452162, "", 0);
INSERT INTO hospital VALUES(310121, "HOSPITAL GARCÍA ORCOYEN", "Santa Soria, 22", "NAVARRA", 848435000, "", 1);
INSERT INTO hospital VALUES(310137, "HOSPITAL REINA SOFÍA", "Ctra. Tudela-Tarazona, km. 4", "NAVARRA", 848434000, "hrst@cfnavarra.es", 1);
INSERT INTO hospital VALUES(310142, "CLÍNICA PSICOGERIÁTRICA JOSEFINA ARREGUI", "Erburua s/n", "NAVARRA", 948563850, "administracion@josefinaarregui.com", 0);
INSERT INTO hospital VALUES(310150, "COMPLEJO HOSPITALARIO DE NAVARRA", "Irunlarrea, 3", "NAVARRA", 848422100, "", 1);
INSERT INTO hospital VALUES(320013, "COMPLEXO HOSPITALARIO UNIVERSITARIO DE OURENSE", "Ramón Puga, 52", "OURENSE", 988385500, "Xerencia.chou@sergas.es", 1);
INSERT INTO hospital VALUES(320028, "HOSPITAL NOSA SEÑORA DO CRISTAL", "Ramón Puga, 52", "OURENSE", 988385500, "Xerencia.chou@sergas.es", 1);
INSERT INTO hospital VALUES(320034, "HOSPITAL SANTO CRISTO DE PIÑOR", "Estrada de Piñor, s/n", "OURENSE", 988385500, "Xerencia-chou@sergas.es", 1);
INSERT INTO hospital VALUES(320052, "HOSPITAL SANTA MARÍA NAI", "Ramón Puga, 52", "OURENSE", 988385500, "", 1);
INSERT INTO hospital VALUES(320087, "CENTRO MÉDICO EL CARMEN", "Av. de la Habana, 50", "OURENSE", 988223400, "info@centromedicoelcarmen.es", 0);
INSERT INTO hospital VALUES(320126, "HOSPITAL COMARCAL DE VALDEORRAS", "Av. Conde de Fenosa, 50", "OURENSE", 988339000, "luis.sanchez.garcia@sergas.es", 1);
INSERT INTO hospital VALUES(320150, "HOSPITAL DE VERÍN", "Estrada de Laza, s/n", "OURENSE", 988413636, "", 1);
INSERT INTO hospital VALUES(320163, "CLÍNICA SANTA TERESA", "Sáenz Díez, 11", "OURENSE", 988371710, "correo@cosaga.com", 0);
INSERT INTO hospital VALUES(330024, "INSTITUTO NACIONAL DE SILICOSIS", "Dr. Bellmut, s/n.", "ASTURIAS", 985108000, "", 1);
INSERT INTO hospital VALUES(330030, "HOSPITAL GENERAL DE ASTURIAS", "Julián Clavería, s/n.", "ASTURIAS", 985108000, "gerent@hcas.sespa.es", 1);
INSERT INTO hospital VALUES(330045, "HOSPITAL MONTE NARANCO", "Avda. Dres. Fernández-Vega, 107", "ASTURIAS", 985106900, "gerencia.hmn@sespa.princast.es", 1);
INSERT INTO hospital VALUES(330061, "CENTRO MÉDICO DE ASTURIAS", "Avda. Richard Grandío s/n", "ASTURIAS", 985250300, "cma@las.es", 0);
INSERT INTO hospital VALUES(330077, "CLÍNICA ASTURIAS", "Naranjo de Bulnes, 4 y 6", "ASTURIAS", 985286000, "info@clinica.asturias.com", 0);
INSERT INTO hospital VALUES(330096, "CLÍNICA SAN RAFAEL", "La Estrecha 33 ( La Corredoria)", "ASTURIAS", 985282526, "admin@sanrafael.es", 0);
INSERT INTO hospital VALUES(330100, "HOSPITAL SAN AGUSTÍN", "Camino de Heros, 6", "ASTURIAS", 985123000, "gerencia.gae3@sespa.es", 1);
INSERT INTO hospital VALUES(330117, "FUNDACIÓN HOSPITAL DE AVILÉS", "Cabruñana, 19", "ASTURIAS", 985525744, "gestion@fhaviles.org", 0);
INSERT INTO hospital VALUES(330138, "HOSPITAL CARMEN Y SEVERO OCHOA", "Sienra, 11", "ASTURIAS", 985812346, "gerencia.area2@sespa.es", 1);
INSERT INTO hospital VALUES(330143, "HOSPITAL COMARCAL DE JARRIO", "Jarrio", "ASTURIAS", 985639300, "gerencia.gae1@sespa.princast.es", 1);
INSERT INTO hospital VALUES(330156, "HOSPITAL DE CABUEÑES", "Los Prados, 395", "ASTURIAS", 985185000, "", 1);
INSERT INTO hospital VALUES(330169, "HOSPITAL DE LA CRUZ ROJA", "Uría, 37", "ASTURIAS", 985195000, "correo@hospitalcrgijon.com", 0);
INSERT INTO hospital VALUES(330175, "SANATORIO NUESTRA SEÑORA DE COVADONGA", "General Suárez Valdés, 40", "ASTURIAS", 985365122, "gerente@sanatoriocovadonga.com", 0);
INSERT INTO hospital VALUES(330194, "FUNDACIÓN HOSPITAL DE JOVE", "Av. Eduardo Castro, s/n", "ASTURIAS", 985320308, "direcciondegestion@hospitaldejove.com", 0);
INSERT INTO hospital VALUES(330208, "HOSPITAL BEGOÑA DE GIJÓN, S.L.", "Pablo Iglesias, 92", "ASTURIAS", 985367711, "gerencia@hospitalbegona.com", 0);
INSERT INTO hospital VALUES(330241, "HOSPITAL VALLE DEL NALÓN", "Polígono de Riaño", "ASTURIAS", 985652000, "gerente.gae8@sespa.princast.es", 1);
INSERT INTO hospital VALUES(330254, "FUNDACION SANATORIO ADARO", "Jove y Canella, 1", "ASTURIAS", 985692051, "gerencia@sanatorioadaro.com", 0);
INSERT INTO hospital VALUES(330267, "HOSPITAL V. ALVAREZ BUYLLA", "Santullano", "ASTURIAS", 985458500, "maria.rozas@sespa.princast.es", 1);
INSERT INTO hospital VALUES(330292, "HOSPITAL UNIVERSITARIO CENTRAL DE ASTURIAS", "Avda. Roma, S/N  La Corredoria", "ASTURIAS", 985108000, "gerencia.area4@sespa.es", 1);
INSERT INTO hospital VALUES(330306, "HOSPITAL DEL ORIENTE DE ASTURIAS FRANCISCO GRANDE COVIÁN", "La Castañera, s/n", "ASTURIAS", 985840032, "gerencia.gae6@sespa.princast.es", 1);
INSERT INTO hospital VALUES(330313, "ASISTENCIA MÉDICA OCCIDENTAL S.L.-. HOSPITAL DE LUARCA", "Villar s/n- LUARCA", "ASTURIAS", 985470707, "amosl@grupomelca.com", 0);
INSERT INTO hospital VALUES(330321, "INSTITUTO SALUD MENTAL PÉREZ-ESPINOSA ORIA, S.L.", "LG Santa Rosa, nº 6", "ASTURIAS", 985771677, "contacto@clinicaperez-espinosayoria.com", 0);
INSERT INTO hospital VALUES(340014, "HOSPITAL RIO CARRIÓN", "Av. Donantes de Sangre, s/n", "PALENCIA", 979167000, "gerente.hrcr@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(340029, "HOSPITAL SAN TELMO", "Av. San Telmo, s/n", "PALENCIA", 979167000, "gerente.hrcr@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(340035, "HOSPITAL PSIQUIATRICO SAN LUIS", "Ctra. de Burgos, s/n", "PALENCIA", 979165324, "ch@sanluis.org", 0);
INSERT INTO hospital VALUES(340040, "UNIDAD DE REHABILITACIÓN PSIQUIÁTRICA CENTRO ASISTENCIAL SAN JUAN DE DIOS", "Ps. Padre Faustino Calvo, s/n", "PALENCIA", 979742300, "palencia.hospital@hsjd.es", 0);
INSERT INTO hospital VALUES(340053, "HOSPITAL RECOLETAS DE PALENCIA", "Av. Simón Nieto, 31-34", "PALENCIA", 979747700, "admision.hrp@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(340063, "COMPLEJO ASISTENCIAL DE PALENCIA", "Av. Donantes de Sangre, s/n", "PALENCIA", 979167000, "gerente.hrcr@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(350043, "HOSPITAL UNIVERSITARIO MATERNO-INFANTIL DE CANARIAS", "Av. Marítima del Sur, s/n", "LAS PALMAS", 928444400, "gerenchuimi.scs@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350056, "HOSPITAL UNIVERSITARIO INSULAR DE GRAN CANARIA", "Av Marítima del Sur, s/n", "LAS PALMAS", 928444000, "gerenciachmi@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350069, "UNIDADES CLÍNICAS Y DE REHABILITACIÓN (UCYR)", "Real del Castillo, 152", "LAS PALMAS", 928303834, "hospitaldrnegrin@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350081, "SANATORIO DERMATOLÓGICO REGIONAL", "Hoya del Parrado, 2 (Tafira Alta)", "LAS PALMAS", 928350354, "jmiguelhs@instituto-as.es", 1);
INSERT INTO hospital VALUES(350115, "FUNDACIÓN BENÉFICA CANARIA CASA ASILO SAN JOSÉ", "Padre Cueto, 26", "LAS PALMAS", 928263708, "clinicasanjose_lascanteras@hotmail.com  -  administracion@asilosanjose.e.telefonica,net", 0);
INSERT INTO hospital VALUES(350120, "VITHAS HOSPITAL SANTA CATALINA", "León y Castillo, 292", "LAS PALMAS", 928297151, "buzonhscainfo@vithas.es", 0);
INSERT INTO hospital VALUES(350154, "HOSPITAL POLICLÍNICO LA PALOMA, S.A.", "Maestro Valle, 20", "LAS PALMAS", 928234466, "fernandojimenezdelcampo@hospitallapaloma.com", 0);
INSERT INTO hospital VALUES(350167, "INSTITUTO POLICLÍNICO CAJAL, S.L.", "Senador Castillo Olivares, 15", "LAS PALMAS", 928369166, "info@clinicacajal.es", 0);
INSERT INTO hospital VALUES(350173, "HOSPITAL SAN ROQUE LAS PALMAS DE GRAN CANARIA", "Dolores de la Rocha, 5", "LAS PALMAS", 928012630, "callcenter@clinicasanroque.com", 0);
INSERT INTO hospital VALUES(350192, "CLÍNICA BANDAMA", "La Tornera, 16 (Tafira Alta)", "LAS PALMAS", 928350050, "bandama@clinicabandama.com", 0);
INSERT INTO hospital VALUES(350206, "CLÍNICA NUESTRA SEÑORA DEL PERPETUO SOCORRO", "León y Castillo, 407", "LAS PALMAS", 928499900, "jpetit@hospitalperpetuosocorro.es", 0);
INSERT INTO hospital VALUES(350228, "HOSPITAL DOCTOR JOSÉ MOLINA OROSA", "Ctra. Arrecife-Tinajo, km. 1,3", "LAS PALMAS", 928595103, "ftolrod@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350249, "HOSPITAL INSULAR DE LANZAROTE", "Juan de Quesada, s/n", "LAS PALMAS", 928810000, "domingodeguzman@cabildodelanzarote.com", 1);
INSERT INTO hospital VALUES(350252, "HOSPITAL GENERAL DE FUERTEVENTURA", "Ctra. Aeropuerto, km. 1", "LAS PALMAS", 928862000, "gerenciafue.scs@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350265, "QUINTA MÉDICA DE REPOSO, S.A.", "Palma Romero, 7", "LAS PALMAS", 928640050, "admision@quintamedica.com", 0);
INSERT INTO hospital VALUES(350271, "HOSPITAL DE SAN ROQUE GUÍA", "Cuesta de Caraballo, 1", "LAS PALMAS", 928882000, "hospitaldrnegrin@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350287, "RESIDENCIA MÉDICA ASISTIDA NUESTRA SEÑORA DEL MAR S.L.", "Mister Blisse, s/n  Urb. La Estrella", "LAS PALMAS", 928707555, "admision@residenciamedicaasistida.com", 0);
INSERT INTO hospital VALUES(350290, "COMPLEJO HOSPITALARIO UNIVERSITARIO INSULAR-MATERNO INFANTIL", "Av. Maritima del Sur, s/n", "LAS PALMAS", 928444000, "gerenchuimi.scs@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350304, "HOSPITAL CLINICA ROCA (ROCA GESTION HOSPITALARIA)", "Buganvilla, 1 (San Agustín)", "LAS PALMAS", 928769004, "info@clinicaroca.com", 0);
INSERT INTO hospital VALUES(350311, "HOSPITAL UNIVERSITARIO  DE GRAN CANARIA DR. NEGRIN", "Barranco de la Ballena, s/n", "LAS PALMAS", 928450001, "hospitaldrnegrin@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350326, "HOSPITEN LANZAROTE (CLÍNICAS DEL SUR S.L.U.)", "Lomo Gordo, s/n", "LAS PALMAS", 928596100, "lanzarote@hospiten.com", 0);
INSERT INTO hospital VALUES(350332, "COMPLEJO HOSPITALARIO UNIVERSITARIO DE GRAN CANARIA DR. NEGRÍN", "Barranco de la Ballena s/n", "LAS PALMAS", 928450001, "hospitaldrnegrin@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(350367, "HOSPITAL SAN ROQUE MASPALOMAS", "Mar de Siberia, 1", "LAS PALMAS", 928063600, "callcenter@clinicasanroque.com", 0);
INSERT INTO hospital VALUES(350378, "ROCA GESTION HOSPITALARIA, S.L.", "Avda. Tomas Roca Bosch, s/n", "LAS PALMAS", 928769004, "info@clinicaroca.com", 0);
INSERT INTO hospital VALUES(350389, "CLÍNICA PARQUE FUERTEVENTURA  (*)", "León y Castillo, esq. Secundino Alonso, s/n", "LAS PALMAS", 928851500, "", 0);
INSERT INTO hospital VALUES(360010, "HOSPITAL MONTECELO", "Mourente", "PONTEVEDRA", 986800000, "", 1);
INSERT INTO hospital VALUES(360025, "HOSPITAL  PROVINCIAL DE PONTEVEDRA", "Doctor Loureiro Crespo, 2", "PONTEVEDRA", 986800000, "", 1);
INSERT INTO hospital VALUES(360031, "HESTIA SANTA MARÍA", "Av. Santa María, 9", "PONTEVEDRA", 986856562, "santamaria@sociosanitaria.net", 0);
INSERT INTO hospital VALUES(360059, "HOSPITAL MIGUEL DOMÍNGUEZ", "Fray Juan de Navarrete, 9", "PONTEVEDRA", 986856800, "iria.rodriguez@grupohmd.com", 0);
INSERT INTO hospital VALUES(360097, "HOSPITAL PSIQ. PROVINCIAL REBULLON", "Puxeiros, s/n", "PONTEVEDRA", 986487517, "", 1);
INSERT INTO hospital VALUES(360101, "CLÍNICA MÉDICA LA MERCED", "Andurique, 11", "PONTEVEDRA", 986856800, "iria.rodriguez@grupohmd.com", 0);
INSERT INTO hospital VALUES(360118, "HOSPITAL DO MEIXOEIRO", "Meixoeiro, s/n", "PONTEVEDRA", 986811111, "", 1);
INSERT INTO hospital VALUES(360139, "HOSPITAL XERAL DE VIGO", "Pizarro, 22", "PONTEVEDRA", 986816000, "", 1);
INSERT INTO hospital VALUES(360144, "POLICLÍNICO CIES", "Av. de Madrid, 15", "PONTEVEDRA", 986816035, "", 1);
INSERT INTO hospital VALUES(360157, "HOSPITAL NICOLAS PEÑA", "Av. Camelias, 109", "PONTEVEDRA", 986219115, "", 1);
INSERT INTO hospital VALUES(360160, "FREMAP, HOSPITAL DE VIGO", "Feliciano Rolán, 12", "PONTEVEDRA", 986413033, "fjose_fernandez_rivera@fremap.es", 0);
INSERT INTO hospital VALUES(360182, "HOSPITAL POVISA", "Salamanca, 5", "PONTEVEDRA", 986413144, "povisa@povisa.es", 0);
INSERT INTO hospital VALUES(360195, "EL CASTRO, HOSPITAL DEL PERPETUO SOCORRO", "Manuel Olivie, 11", "PONTEVEDRA", 986411466, "administracion@elcastrovigo.com", 0);
INSERT INTO hospital VALUES(360209, "VITHAS HOSPITAL  NOSA SEÑORA DE FATIMA", "Via Norte, 48", "PONTEVEDRA", 986821100, "millarab@hospitalfatima.nehos.com", 0);
INSERT INTO hospital VALUES(360216, "SANATORIO CONCHEIRO", "Av. de Madrid, 4", "PONTEVEDRA", 986413244, "documentacion@sanatorioconcheiro.com", 0);
INSERT INTO hospital VALUES(360255, "CENTRO MÉDICO PINTADO", "Vía Hispanidad, 40", "PONTEVEDRA", 986413300, "juanpintado@infonegocio.com", 0);
INSERT INTO hospital VALUES(360268, "SANATORIO PSIQUIÁTRICO SAN JOSE", "Tomás Alonso, 89", "PONTEVEDRA", 986235606, "psqsanjose@telefonica.net", 0);
INSERT INTO hospital VALUES(360274, "CLINICA RESIDENCIA EL PINAR", "Ctra. Vella de Madrid, 120.- Meixoeiro", "PONTEVEDRA", 986266400, "clinica@celpinar.com", 0);
INSERT INTO hospital VALUES(360340, "COMPLEXO HOSPITALARIO UNIVERSITARIO DE PONTEVEDRA", "Mourente", "PONTEVEDRA", 986800000, "", 1);
INSERT INTO hospital VALUES(360353, "HOSPITAL  DO SALNÉS", "Hospital do Salnes, 30", "PONTEVEDRA", 986568000, "hospital.salnes@sergas.es", 1);
INSERT INTO hospital VALUES(360368, "COMPLEXO HOSPITALARIO UNIVERSITARIO DE VIGO", "Pizarro, 22", "PONTEVEDRA", 986816000, "", 1);
INSERT INTO hospital VALUES(370016, "COMPLEJO ASISTENCIAL UNIVERSITARIO DE SALAMANCA", "Pº de San Vicente, 58-182", "SALAMANCA", 923291100, "gerencia.husa@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(370037, "HOSPITAL UNIVERSITARIO DE SALAMANCA", "Pº de San Vicente, 58-182", "SALAMANCA", 923291100, "gerencia.husa@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(370055, "HOSPITAL GENERAL DE LA SANTISIMA TRINIDAD", "Pº de Carmelitas, 74-94", "SALAMANCA", 923269300, "mbenavente@fhgst.es", 0);
INSERT INTO hospital VALUES(370068, "HOSPITAL VIRGEN DEL CASTAÑAR", "Trva Santa Ana, 4", "SALAMANCA", 923402371, "gerencia.husa@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(370074, "HOSPITAL LOS MONTALVOS", "Carretera Ciudad Rodrigo, s/n", "SALAMANCA", 923330163, "gerencia.husa@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(380012, "COMPLEJO HOSPITALARIO UNIVERSITARIO NTRA. SRA. DE CANDELARIA", "Ctra. del Rosario, 145", "SANTA CRUZ DE TENERIFE", 922602000, "mcueser@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380027, "HOSPITAL UNIVERSITARIO NUESTRA SEÑORA DE CANDELARIA", "Ctra. del Rosario, 145", "SANTA CRUZ DE TENERIFE", 922602000, "mcueser@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380033, "HOSPITAL DE OFRA", "La Cuesta, s/n", "SANTA CRUZ DE TENERIFE", 922602000, "mcueser@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380048, "UNIDADES DE  HOSPITALIZACIÓN DE  SUBAGUDOS Y REHABILITACIÓN DE  SALUD MENTAL", "Domingo José Manrique, 2", "SANTA CRUZ DE TENERIFE", 922678000, "", 1);
INSERT INTO hospital VALUES(380051, "HOSPITAL FEBLES CAMPOS", "Domingo José Manrique, 2", "SANTA CRUZ DE TENERIFE", 922843300, "eafonso@iass.es", 1);
INSERT INTO hospital VALUES(380064, "CLÍNICA SAN JUAN DE DIOS", "Ctra. General  Norte, 53", "SANTA CRUZ DE TENERIFE", 922645511, "juan.Deleon@sjd.es", 0);
INSERT INTO hospital VALUES(380086, "HOSPITAL QUIRÓN TENERIFE", "Poeta Rodríguez Herrera, 1", "SANTA CRUZ DE TENERIFE", 922280700, "info.tenerife@quiron.es", 0);
INSERT INTO hospital VALUES(380099, "VITHAS HOSPITAL SANTA CRUZ", "Enrique Wolfson, 8", "SANTA CRUZ DE TENERIFE", 922534733, "RojasE@vithas.es", 0);
INSERT INTO hospital VALUES(380103, "CLÍNICA PARQUE, S.A.", "Méndez Núñez, 40", "SANTA CRUZ DE TENERIFE", 922274400, "contabilidad@parquehospitales.es", 0);
INSERT INTO hospital VALUES(380146, "HOSPITEN SUR", "Siete Islas, 8 (Playa de las Américas)", "SANTA CRUZ DE TENERIFE", 922750022, "clisur@hospiten.es", 0);
INSERT INTO hospital VALUES(380178, "HOSPITAL UNIVERSITARIO DE CANARIAS (H.U.C)", "Ofra, s/n", "SANTA CRUZ DE TENERIFE", 922678061, "dirgerhuc.scs@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380197, "HOSPITAL DE LA SANTÍSIMA TRINIDAD", "Camino Las Gaviotas nº 22. Barrio del Buen Paso", "SANTA CRUZ DE TENERIFE", 922321633, "eafonso@iass.es", 1);
INSERT INTO hospital VALUES(380201, "CLÍNICA VIDA", "Magnolias, 2 (Urbanización San Miguel)", "SANTA CRUZ DE TENERIFE", 922330550, "clinicasvida@clinicasvida.es", 0);
INSERT INTO hospital VALUES(380223, "HOSPITAL BELLEVUE", "Alemania, 4 (Urb. San Fernándo)", "SANTA CRUZ DE TENERIFE", 922368822, "bellevue@hospiten.com", 0);
INSERT INTO hospital VALUES(380244, "HOSPITAL NUESTRA SEÑORA DE GUADALUPE", "El Langrero, s/n", "SANTA CRUZ DE TENERIFE", 922140219, "mherarm@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380260, "HOSPITAL NUESTRA SEÑORA DE LOS DOLORES", "San Vicente de Paúl, 1", "SANTA CRUZ DE TENERIFE", 922423204, "jose.regidor@cablapalma.es", 1);
INSERT INTO hospital VALUES(380276, "HOSPITAL INSULAR NTRA. SRA. DE LOS REYES", "Los Barriales, 1", "SANTA CRUZ DE TENERIFE", 922553500, "mherdora@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380282, "HOSPITAL QUIRÓN COSTA ADEJE", "Urbanización San Eugenio", "SANTA CRUZ DE TENERIFE", 922752626, "admision.adj@quiron.es", 0);
INSERT INTO hospital VALUES(380295, "HOSPITAL RAMBLA S.L.", "Rambla General Franco, 115", "SANTA CRUZ DE TENERIFE", 922291600, "alicia.fernaud@hospiten.com", 0);
INSERT INTO hospital VALUES(380309, "CLÍNICA VINTERSOL (HUMLEGARDEN S.L.)", "Nórdica, 1", "SANTA CRUZ DE TENERIFE", 922777900, "pablo.gonzalez@vintersol.com", 0);
INSERT INTO hospital VALUES(380316, "HOSPITAL GENERAL DE LA PALMA", "Carretera La Cumbre, 28. Buenavista de Arriba", "SANTA CRUZ DE TENERIFE", 922185000, "mcasmarl@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(380326, "COMPLEJO HOSPITALARIO UNIVERSITARIO DE CANARIAS", "Ofra, s/n", "SANTA CRUZ DE TENERIFE", 922678061, "dirgerhuc.scs@gobiernodecanarias.org", 1);
INSERT INTO hospital VALUES(390015, "HOSPITAL UNIVERSITARIO MARQUÉS DE VALDECILLA", "Av. de Valdecilla, s/n", "CANTABRIA", 942202520, "", 1);
INSERT INTO hospital VALUES(390041, "HOSPITAL RAMÓN NEGRETE", "Av. del Faro-Pintor Eduardo Sanz nº 19", "CANTABRIA", 942204100, "t.usle@mutuamontanesa.es", 0);
INSERT INTO hospital VALUES(390054, "HOSPITAL SANTA CLOTILDE", "Av. General Dávila, 35", "CANTABRIA", 942217711, "hsclotilde.gerencia@hsjd.es", 0);
INSERT INTO hospital VALUES(390067, "CENTRO HOSPITALARIO PADRE MENNI", "Av. de Cantabria, 52", "CANTABRIA", 942390060, "gerencia@mennisant.com", 0);
INSERT INTO hospital VALUES(390134, "HOSPITAL COMARCAL DE LAREDO", "Av. de los Derechos Humanos, s/n", "CANTABRIA", 942638500, "gerent.galrd@scsalud.es", 1);
INSERT INTO hospital VALUES(390149, "HOSPITAL SIERRALLANA (*)", "Bº. de Ganzo, s/n", "CANTABRIA", 942847400, "", 1);
INSERT INTO hospital VALUES(390152, "CLÍNICA MOMPÍA, S.A.U.", "Av. de los Condes, s/n.", "CANTABRIA", 942584100, "", 0);
INSERT INTO hospital VALUES(400019, "COMPLEJO ASISTENCIAL DE SEGOVIA", "Miguel Servet, s/n", "SEGOVIA", 921419100, "gerente.hgse@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(400030, "HOSPITAL GENERAL DE SEGOVIA", "Miguel Servet, s/n", "SEGOVIA", 921419100, "gerente.hgse@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(400045, "HOSPITAL RECOLETAS SEGOVIA NTRA. SRA. DE LA MISERICORDIA", "Dr. Velasco, 21", "SEGOVIA", 921460112, "ignacio.lopez.hrsg@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(400058, "UNIDAD DE REHABILITACIÓN PSIQUIÁTRICA NTRA. SRA. DE LA FUENCISLA", "Ctra. de la Granja, km. 7", "SEGOVIA", 921421800, "rsantos@dipsegovia.es", 1);
INSERT INTO hospital VALUES(410016, "HOSPITAL VIRGEN DEL ROCÍO", "Av. Manuel Siurot, s/n", "SEVILLA", 955012000, "huvr@hvr.sas.junta-andalucia.es", 0);
INSERT INTO hospital VALUES(410021, "HOSPITAL NUESTRA SEÑORA DE VALME", "Ctra. Cádiz-Bellavista, km. 548,9", "SEVILLA", 955015000, "hospitalvalme.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(410042, "HOSPITAL VIRGEN MACARENA", "Av. Doctor Fedriani, 3", "SEVILLA", 955008000, "ahvm@hvm.sas.junta-andalucia.es", 0);
INSERT INTO hospital VALUES(410055, "HOSPITAL SAN LÁZARO", "Av. Doctor Fedriani, 56", "SEVILLA", 955017800, "", 0);
INSERT INTO hospital VALUES(410074, "HOSPITAL VICTORIA EUGENIA DE LA CRUZ ROJA ESPAÑOLA", "Av. Cruz Roja, 1", "SEVILLA", 954351400, "direccion@hospitalveugenia.com", 0);
INSERT INTO hospital VALUES(410080, "HOSPITAL SAN JUAN DE DIOS DE SEVILLA", "Av. Eduardo Dato, 42", "SEVILLA", 954933870, "sevilla2@sjd.es", 0);
INSERT INTO hospital VALUES(410093, "HOSPITAL DUQUES DEL INFANTADO", "Sor Gregoria de Santa Teresa, s/n", "SEVILLA", 955016300, "", 0);
INSERT INTO hospital VALUES(410107, "CLÍNICA SANTA ISABEL", "Luis Montoto, 100", "SEVILLA", 954919000, "", 0);
INSERT INTO hospital VALUES(410114, "CLÍNICA QUIRÓN SAGRADO CORAZÓN", "Rafael Salgado, 3", "SEVILLA", 954937676, "", 0);
INSERT INTO hospital VALUES(410129, "HOSPITAL FÁTIMA", "Glorieta de México, 1", "SEVILLA", 954613300, "info@hospitalfatima.es", 0);
INSERT INTO hospital VALUES(410135, "HOSPITAL INFANTA LUISA", "San Jacinto, 87", "SEVILLA", 954330100, "obdulio@infantaluisa.com", 0);
INSERT INTO hospital VALUES(410191, "CLÍNICA NUESTRA SEÑORA DE ARANZAZU", "Jesús del Gran Poder, 29", "SEVILLA", 954382110, "direccion@clinicaaranzazu.com", 0);
INSERT INTO hospital VALUES(410212, "RESIDENCIA DE SALUD MENTAL NUESTRA SEÑORA DEL CARMEN", "Av. Rio Pudio, s/n", "SEVILLA", 955723391, "rescudero@trajanoxxv.com", 0);
INSERT INTO hospital VALUES(410227, "HOSPITAL DE EL TOMILLAR", "Ctra. Alcalá -Dos Hermanas, km. 6", "SEVILLA", 955016000, "hospitalvalme.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(410233, "HOSPITAL SAN AGUSTIN - O.R.L.", "Prolongación Doctor Fleming, sector 13, s/n", "SEVILLA", 955050570, "josemanuel@hsanagustin.com", 0);
INSERT INTO hospital VALUES(410248, "HOSPITAL DE ALTA RESOLUCION MORÓN DE LA FRONTERA", "Pza de San Francisco, s/n", "SEVILLA", 954851008, "", 0);
INSERT INTO hospital VALUES(410251, "HOSPITAL COMARCAL DE LA MERCED", "Av. de la Constitución, 2", "SEVILLA", 955077200, "dgerencia.aso.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(410286, "COMPLEJO HOSPITALARIO REGIONAL VIRGEN DEL ROCÍO", "Av. Manuel Siurot, s/n", "SEVILLA", 955013466, "", 0);
INSERT INTO hospital VALUES(410299, "COMPLEJO HOSPITALARIO REGIONAL VIRGEN MACARENA", "Av. Doctor Fedriani, 3", "SEVILLA", 955008000, "secretariadireccionger.hvm.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(410303, "COMPLEJO HOSPITALARIO DE ESPECIALIDADES VIRGEN DE VALME", "Avda. de Bellavista, s/n", "SEVILLA", 955015160, "hospitalvalme.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(410310, "HOSPITAL DE ALTA RESOLUCIÓN DE ÉCIJA", "Sor Cándida Sáiz Alonso, 1", "SEVILLA", 955074500, "", 0);
INSERT INTO hospital VALUES(410325, "HOSPITAL CLÍNICA FREMAP PREVENCIÓN Y REHABILITACIÓN", "Av. de Jerez, s/n", "SEVILLA", 954249102, "", 0);
INSERT INTO hospital VALUES(410346, "HOSPITAL PSIQUIÁTRICO PENITENCIARIO", "Crta. Torreblanca-Mairena, km. 3,5", "SEVILLA", 955616666, "director.sevillaps@dgip.mir.es", 1);
INSERT INTO hospital VALUES(410353, "HOSPITAL SAN JUAN DE DIOS DE EL ALJARAFE", "Avda. San Juan de Dios, s/n", "SEVILLA", 955050550, "", 0);
INSERT INTO hospital VALUES(410375, "HOSPITAL NISA SEVILLA-ALJARAFE", "Avda. Placido Fernandez Viagas, s/n", "SEVILLA", 954464000, "sevillaaljarafe@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(410386, "HOSPITAL ALTA RESOLUCION DE UTRERA", "Brigadas Internacionales, s/n", "SEVILLA", 955839097, "secretaria.chare.utrera.sspa@juntadeandalucia.es", 0);
INSERT INTO hospital VALUES(410397, "HOSPITAL DE ALTA RESOLUCIÓN SIERRA NORTE", "Dr. Larrauri, s/n", "SEVILLA", 955889037, "", 0);
INSERT INTO hospital VALUES(410409, "HOSPITAL SANTA ÁNGELA DE LA CRUZ", "Avda. de Jerez, 59", "SEVILLA", 954032000, "gpc@viamedsantaangeladelacruz.com", 0);
INSERT INTO hospital VALUES(420011, "HOSPITAL SANTA BÁRBARA", "Pº Santa Bárbara, s/n", "SORIA", 975234300, "gerente.hsor@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(420026, "HOSPITAL VIRGEN DEL MIRÓN", "Ctra. de Logroño, 8", "SORIA", 975220850, "gerente.hsor@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(420040, "COMPLEJO ASISTENCIAL DE SORIA", "Pº. Sta. Barbara, s/n", "SORIA", 975234300, "gerente.hsor@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(430017, "HOSPITAL UNIVERSITARI JOAN XXIII DE TARRAGONA", "Doctor Mallafré Guasch, 4", "TARRAGONA", 977295800, "rramon@hjxxiii.scs.es / hospital@hj23.es", 1);
INSERT INTO hospital VALUES(430022, "HOSPITAL SOCIOSANITARI FRANCOLÍ", "Doctor Mallafre Guasch, s/n", "TARRAGONA", 977232714, "", 1);
INSERT INTO hospital VALUES(430043, "HOSPITAL DE SANT PAU I SANTA TECLA", "Rambla Vella, 14", "TARRAGONA", 977259900, "gloria@sv.ftecla.es", 0);
INSERT INTO hospital VALUES(430056, "HOSPITAL VIAMED  MONEGAL", "Lopez Pelaez, 15", "TARRAGONA", 977225012, "", 0);
INSERT INTO hospital VALUES(430069, "CLÍNICA ACTIVA MÚTUA 2008", "Pin i Soler, 12", "TARRAGONA", 977217900, "", 0);
INSERT INTO hospital VALUES(430081, "HOSPITAL COMARCAL MÓRA D'EBRE", "Benet Messeguer, s/n", "TARRAGONA", 977401863, "dtorras@grupsgs.com", 0);
INSERT INTO hospital VALUES(430094, "HOSPITAL UNIVERSITARI DE SANT JOAN DE REUS", "Av. Dr. Josep Laporte,  2", "TARRAGONA", 977310300, "abrunet@grupsgs.com", 1);
INSERT INTO hospital VALUES(430108, "CENTRE MQ REUS", "Antoni Gaudí, 26", "TARRAGONA", 977010800, "dadm.cmqr@grupsgs.com", 0);
INSERT INTO hospital VALUES(430115, "VILLABLANCA SERVEIS ASSISTENCIALS, SA", "Partida Bellisens, s/n", "TARRAGONA", 977390011, "", 0);
INSERT INTO hospital VALUES(430120, "INSTITUT PERE MATA, S.A.", "Carretera de L'Institut Pere Mata, s/n", "TARRAGONA", 977338565, "ipm@peremata.com", 0);
INSERT INTO hospital VALUES(430167, "HOSPITAL DE TORTOSA VERGE DE LA CINTA", "Esplanetes, 44", "TARRAGONA", 977519100, "htvc@tinet.fut.es", 1);
INSERT INTO hospital VALUES(430173, "HOSPITAL DE LA SANTA CREU", "Ps.  Mossèn Valls Bartomeu, 1", "TARRAGONA", 977500533, "lopd@grupsagessa.cat", 1);
INSERT INTO hospital VALUES(430189, "CLÍNICA TERRES DE L'EBRE", "Plaça Joaquim Bau, 6-8", "TARRAGONA", 977588200, "carsa@clinicatortosa.com", 0);
INSERT INTO hospital VALUES(430213, "POLICLÍNICA COMARCAL DEL VENDRELL", "Av Santa Oliva, 1-13", "TARRAGONA", 977660140, "elvendrell@policlinicacomarcal.com", 0);
INSERT INTO hospital VALUES(430228, "PIUS HOSPITAL DE VALLS", "Plaça Sant Francesc, s/n", "TARRAGONA", 977613000, "mclofent@piushospital.org", 0);
INSERT INTO hospital VALUES(430234, "RESIDÈNCIA ALT CAMP", "Camí del Bosc, s/n", "TARRAGONA", 977600292, "residenciaaltcamp@piushospital.cat", 0);
INSERT INTO hospital VALUES(430249, "CENTRE SOCIOSANITARI CIUTAT DE REUS", "Camí de Tarragona, 10", "TARRAGONA", 977300021, "info@stsgrup.org", 0);
INSERT INTO hospital VALUES(430252, "HOSPITAL COMARCAL D'AMPOSTA", "Jacint Verdaguer, 11", "TARRAGONA", 977700050, "", 1);
INSERT INTO hospital VALUES(430265, "CENTRE SOCIOSANITARI LLEVANT", "Joan Fuster Ortells, s/n", "TARRAGONA", 977239412, "jmadsera@sv.ftecla.es", 0);
INSERT INTO hospital VALUES(430276, "RESIDÈNCIA VILA-SECA", "Requet de Fèlix, 35", "TARRAGONA", 977395825, "mutuam@mutuam.com", 0);
INSERT INTO hospital VALUES(430287, "UNITAT POLIVALENT EN SALUT MENTAL D'AMPOSTA", "Amèrica, 15", "TARRAGONA", 977338565, "fpmte@peremata.com", 0);
INSERT INTO hospital VALUES(430298, "HOSPITAL DEL VENDRELL", "Carretera N-340, 1193", "TARRAGONA", 977257900, "", 0);
INSERT INTO hospital VALUES(430300, "CENTRE SOCIOSANITARI I RESIDÈNCIA ASSISTIDA SALOU", "Av. Pau Casals, 3", "TARRAGONA", 977774705, "salouassistencial@stsgrup.org", 0);
INSERT INTO hospital VALUES(430322, "RESIDÈNCIA SANTA TECLA PONENT", "Menorca, 26", "TARRAGONA", 977540678, "megarcia@xarxatecla.cat", 0);
INSERT INTO hospital VALUES(440012, "HOSPITAL OBISPO POLANCO DE TERUEL", "Av. Ruiz Jarabo, s/n", "TERUEL", 978654000, "buzgen.holp@salud.aragon.es", 1);
INSERT INTO hospital VALUES(440027, "HOSPITAL SAN JOSÉ", "Av. Zaragoza, 16", "TERUEL", 978654070, "rgomezn@salud.aragon.es", 1);
INSERT INTO hospital VALUES(440033, "CENTRO DE REHABILITACION PSICOSOCIAL SAN JUAN DE DIOS", "Av. de Zaragoza, 10", "TERUEL", 978654040, "hpsiquiteruel@aragon.es", 1);
INSERT INTO hospital VALUES(440048, "HOSPITAL DE ALCAÑIZ", "Dr. Repollés, 2", "TERUEL", 978830100, "pbono@salud.aragon.es", 1);
INSERT INTO hospital VALUES(450015, "HOSPITAL VIRGEN DE LA SALUD", "Avda. de Barber, 30", "TOLEDO", 925269200, "", 1);
INSERT INTO hospital VALUES(450020, "HOSPITAL GERIÁTRICO VIRGEN DEL VALLE", "Ctra. de Cobisa, s/n", "TOLEDO", 925269300, "", 1);
INSERT INTO hospital VALUES(450036, "HOSPITAL NACIONAL DE PARAPLÉJICOS", "Finca La Peraleda, s/n", "TOLEDO", 925247700, "gerencia.hnp@sescam.jccm.es", 1);
INSERT INTO hospital VALUES(450041, "HOSPITAL PROVINCIAL NUESTRA SEÑORA DE LA MISERICORDIA", "Subida de San Servando, s/n", "TOLEDO", 925259350, "", 1);
INSERT INTO hospital VALUES(450067, "HOSPITAL GENERAL NUESTRA SEÑORA DEL PRADO", "Ctra. de Madrid, km. 114", "TOLEDO", 925803600, "informacion@hospital-prado.org", 1);
INSERT INTO hospital VALUES(450089, "CLÍNICA MARAZUELA, S.A.", "Avenida de Extremadura, 5", "TOLEDO", 925815281, "clinica@clinicamarazuela.com", 0);
INSERT INTO hospital VALUES(450092, "COMPLEJO HOSPITALARIO DE TOLEDO (*)", "Avda. de Barber, 30", "TOLEDO", 925269200, "", 1);
INSERT INTO hospital VALUES(450113, "HOSPITAL LABORAL SOLIMAT, MUTUA DE A.T. Y E.P. DE LA SS Nº 72", "San Pedro el Verde, 35", "TOLEDO", 925215267, "jlopez@solimat.com", 0);
INSERT INTO hospital VALUES(450122, "IDCSALUD HOSPITAL TRES CULTURAS", "Urbanización Tres Culturas, s/n", "TOLEDO", 925266100, "informacion.tresculturas@idcsalud.es", 0);
INSERT INTO hospital VALUES(450133, "CENTRO DE TRAT. DE DROGODEP. 'EL ALBA'", "Ctra. La Puebla de Montalbán, Km. 4", "TOLEDO", 925216254, "", 1);
INSERT INTO hospital VALUES(460018, "HOSPITAL UNIVERSITARI I POLITÈCNIC LA FE", "Bulevar Sur, s/n", "VALENCIA", 961244000, "puig_isa@gva.es", 1);
INSERT INTO hospital VALUES(460023, "HOSPITAL UNIVERSITARIO DOCTOR PESET", "Av. Gaspar Aguilar, 90", "VALENCIA", 961622300, "", 1);
INSERT INTO hospital VALUES(460039, "HOSPITAL ARNAU DE VILANOVA", "San Clemente, 12", "VALENCIA", 961976000, "dvav@gva.es", 1);
INSERT INTO hospital VALUES(460044, "HOSPITAL CLÍNICO UNIVERSITARIO DE VALENCIA", "Av. Blasco Ibáñez, 17", "VALENCIA", 961973500, "dirgerencia_hcv@gva.es", 1);
INSERT INTO hospital VALUES(460057, "HOSPITAL LA MALVA-ROSA", "Isabel de Villena, 2", "VALENCIA", 961925400, "mora_eri@gva.es", 1);
INSERT INTO hospital VALUES(460060, "HOSPITAL GENERAL UNIVERSITARIO DE VALENCIA", "Av. Tres Cruces, 2", "VALENCIA", 963131800, "gerencia_d9_hgv@gva.es", 1);
INSERT INTO hospital VALUES(460082, "HOSPITAL CASA DE LA SALUD", "Dr. Manuel Candela, 41", "VALENCIA", 963897700, "casadesalud@casadesalud.es", 0);
INSERT INTO hospital VALUES(460095, "HOSPITAL NISA VALENCIA AL MAR", "Río Tajo, 1", "VALENCIA", 963352500, "mar@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(460109, "FUNDACIÓN INSTITUTO VALENCIANO DE ONCOLOGÍA", "Profesor Beltrán Báguena, 11,8 y 19", "VALENCIA", 961114099, "aperales@fivo.org", 0);
INSERT INTO hospital VALUES(460116, "CLINICA VIRGEN DEL CONSUELO", "Callosa de Ensarria, 12", "VALENCIA", 963177800, "cvconsuelo@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(460137, "CLÍNICA QUIRÓN DE VALENCIA", "Av. Blasco Ibáñez, 14", "VALENCIA", 963690600, "", 0);
INSERT INTO hospital VALUES(460168, "HOSPITAL PSIQUIÁTRICO PROVINCIAL", "Ctra. Valencia-Torres Torres, km. 9", "VALENCIA", 961699000, "isabel.flores@dival.es", 1);
INSERT INTO hospital VALUES(460180, "CASA DE REPOSO SAN ONOFRE S.L.", "Pujada de l'Ermita, 31", "VALENCIA", 963638036, "info@clinicasanonofre.com", 0);
INSERT INTO hospital VALUES(460207, "HOSPITAL FRANCESC DE BORJA DE GANDIA", "Pº Germania, 71", "VALENCIA", 962959200, "", 1);
INSERT INTO hospital VALUES(460229, "HOSPITAL LLUIS ALCANYÍS DE XATIVA", "Ctra. Xàtiva-Silla, km. 2", "VALENCIA", 962289500, "hla_udca@gva.es", 1);
INSERT INTO hospital VALUES(460235, "HOSPITAL GENERAL DE ONTINYENT", "Av. Francisco Cerda, 3", "VALENCIA", 962989300, "hla_udca@gva.es", 1);
INSERT INTO hospital VALUES(460240, "HOSPITAL INTERMUTUAL DE LEVANTE", "Autovía Valencia-Ademuz, km. 11,7", "VALENCIA", 961350250, "direccionmedica@hilevante.com", 0);
INSERT INTO hospital VALUES(460266, "HOSPITAL DE SAGUNTO", "Av. Ramón y Cajal, s/n", "VALENCIA", 962339300, "dpsagunto_gerencia@gva.es", 1);
INSERT INTO hospital VALUES(460272, "HOSPITAL DOCTOR MOLINER", "Porta Coeli, s/n", "VALENCIA", 961687900, "perez_framar@gva.es", 1);
INSERT INTO hospital VALUES(460288, "HOSPITAL GENERAL DE REQUENA", "Paraje Casablanca s/n", "VALENCIA", 962339180, "martinez_dol@gva.es", 1);
INSERT INTO hospital VALUES(460291, "HOSPITAL 9 DE OCTUBRE", "Av. Valle de la Ballestera, 59", "VALENCIA", 963179100", 9octubre@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(460327, "CENTRO MÉDICO GANDÍA", "Daimuz, 26", "VALENCIA", 962874740, "jrivera@centro-medico.com", 0);
INSERT INTO hospital VALUES(460333, "HOSPITAL NISA AGUAS VIVAS", "Urbanización Aguas Vivas, s/n", "VALENCIA", 962588800, "jginemez@hospitales.nisa.es", 0);
INSERT INTO hospital VALUES(460348, "CLÍNICA FONTANA", "Alicante, 31", "VALENCIA", 963410600, "fontana@clinicafontana.es", 0);
INSERT INTO hospital VALUES(460351, "HOSPITAL UNIVERSITARIO DE LA RIBERA (*)", "Crtra Corbera, Km. 1", "VALENCIA", 962458100, "", 1);
INSERT INTO hospital VALUES(460369, "HOSPITAL PARE JOFRÉ", "San Llátzer s/n", "VALENCIA", 961223900, "peset_raf@gva.es", 1);
INSERT INTO hospital VALUES(460370, "HOSPITAL DE MANISES (*)", "Avda. Generalitat Valenciana, 50", "VALENCIA", 961845000, "crodigo@hospitalmanises.es", 1);
INSERT INTO hospital VALUES(460381, "HOSPITAL DE CRÓNICOS DE MISLATA. ANTIGUO H. MILITAR DE VALENCIA (*)", "Dolores Ibarruri,1", "VALENCIA", 963874692, "rfranco@hospitalmanises.es", 1);
INSERT INTO hospital VALUES(470014, "HOSPITAL UNIVERSITARIO RIO HORTEGA", "Dulzaina, 2", "VALLADOLID", 983420400, "gerente.hurh@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(470029, "HOSPITAL CLINICO UNIVERSITARIO DE VALLADOLID", "Av. Ramón y Cajal, 3", "VALLADOLID", 983420000, "gerente.hcuv@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(470053, "SANATORIO SAGRADO CORAZÓN", "Fidel Recio, 1", "VALLADOLID", 983299000, "santsgc@planalfa.es", 0);
INSERT INTO hospital VALUES(470072, "CENTRO HOSPITALARIO BENITO MENNI", "Pº Juan Carlos I, 10", "VALLADOLID", 983272600, "chbm@menni.com", 0);
INSERT INTO hospital VALUES(470091, "HOSPITAL MEDINA DEL CAMPO", "Calle de Peñaranda,  24", "VALLADOLID", 983838000, "gerente.hmdc@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(470105, "HOSPITAL DE VALLADOLID FELIPE II", "Felipe II, 9", "VALLADOLID", 983358000, "nuria.mediavilla.hcg@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(470113, "HOSPITAL CAMPO GRANDE", "Plaza de Colón, s/n", "VALLADOLID", 983135555, "nuria.mediavilla.hcg@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(480010, "HOSPITAL SANTA MARINA", "Ctra. Santa Marina, 41", "VIZCAYA", 944006900, "hsm@osakidetza.net", 1);
INSERT INTO hospital VALUES(480025, "HOSPITAL INTERMUTUAL DE EUSKADI", "Fontecha y Salazar, 6", "VIZCAYA", 944132380, "", 0);
INSERT INTO hospital VALUES(480031, "CLÍNICA ERCILLA MUTUALIA", "Ercilla, 10", "VIZCAYA", 944252500, "Marijuan@mutualia.es", 0);
INSERT INTO hospital VALUES(480046, "HOSPITAL CRUZ ROJA DE BILBAO", "Alameda de Urquijo, 65", "VIZCAYA", 944434792, "i.idigoras@hospitalcruzroja.biz", 0);
INSERT INTO hospital VALUES(480059, "SANATORIO BILBAÍNO", "Gordoniz, 18", "VIZCAYA", 944430150, "sanatoriobilbaino@siervasdejesus.com", 0);
INSERT INTO hospital VALUES(480078, "HOSPITAL DE BASURTO", "Av. Montevideo, 18", "VIZCAYA", 944006000, "", 1);
INSERT INTO hospital VALUES(480097, "IMQ CLÍNICA VIRGEN BLANCA", "Maestro Mendiri, 2", "VIZCAYA", 944127011, "direccion@clinica.imq.com", 0);
INSERT INTO hospital VALUES(480123, "CLÍNICA GUIMON S.A.", "Manuel Allende, 24", "VIZCAYA", 944215200, "contabilidad@clinicaguimon.net", 0);
INSERT INTO hospital VALUES(480160, "CLÍNICA INDAUTXU", "Gordoniz, 9", "VIZCAYA", 944445012, "clinicaindautxu@clinicaindautxu.com", 0);
INSERT INTO hospital VALUES(480176, "HOSPITAL UNIVERSITARIO DE CRUCES", "Pza de Cruces, 12", "VIZCAYA", 946006000, "gerencia.cruces@osakidetza.net/control.gestion.cruces@osakidetza.net", 1);
INSERT INTO hospital VALUES(480182, "HOSPITAL SAN ELOY", "Av. Antonio Miranda, 5", "VIZCAYA", 944006700, "G31265.DireccionSanEloy@osakidetza.net", 1);
INSERT INTO hospital VALUES(480195, "RED DE SALUD MENTAL DE BIZKAIA (HOSPITAL DE BERMEO)", "Tompoi Bidea, s/n", "VIZCAYA", 946029000, "MARIAISABEL.AQUESOLOUGALDE@osakidetza.net", 1);
INSERT INTO hospital VALUES(480209, "HOSPITAL GALDAKAO-USANSOLO", "Barrio Labeaga, s/n", "VIZCAYA", 944007000, "hospital.galdakao-usansolo@osakidetza.net", 1);
INSERT INTO hospital VALUES(480216, "HOSPITAL GORLIZ", "Urezarantza Ibiltokia, 1", "VIZCAYA", 944006600, "merche.lecumberriayarza@osakidetza.net", 1);
INSERT INTO hospital VALUES(480237, "SANATORIO NEUROPSIQUIÁTRICO SAN IGNACIO DE LOYOLA", "Peruri, 4", "VIZCAYA", 944606822, "sanatorioloyola@euskaltel.net", 0);
INSERT INTO hospital VALUES(480255, "HOSPITAL SAN JUAN DE DIOS", "Av. Cristobal Murrieta, 70", "VIZCAYA", 944939900, "santurce.secretaria@hsjd.es", 0);
INSERT INTO hospital VALUES(480268, "RED DE SALUD MENTAL DE BIZKAIA (HOSPITAL DE ZALDIBAR)", "Av. de Bilbao, s/n", "VIZCAYA", 946032800, "MARIAISABEL.AQUESOLUAGALDE@osakidetza.net", 1);
INSERT INTO hospital VALUES(480274, "RED DE SALUD MENTAL DE BIZKAIA (HOSPITAL DE ZAMUDIO)", "Arteaga Auzoa, 45", "VIZCAYA", 944006500, "MARIAISABEL.AQUESOLOUGALDE@osakidetza.net", 1);
INSERT INTO hospital VALUES(480293, "AVANCES MÉDICOS S.A", "Av.  Murrieta, 70", "VIZCAYA", 902407071, "koldogu@avancesmedicos.es", 0);
INSERT INTO hospital VALUES(480305, "HOSPITAL QUIRON BIZKAIA", "Carretera Leioa-Unbe, 33 bis", "VIZCAYA", 902445595, "direccion.bil@quiron.es", 0);
INSERT INTO hospital VALUES(480316, "CLÍNICA IMQ  ZORROTZAURRE", "Ballets Olaeta, 4", "VIZCAYA", 944755000, "", 0);
INSERT INTO hospital VALUES(490013, "HOSPITAL VIRGEN DE LA CONCHA", "Av. Requejo, 35", "ZAMORA", 980548200, "gerente.hvcn@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(490028, "HOSPITAL  PROVINCIAL DE ZAMORA", "Hernán Cortés, 40", "ZAMORA", 980520200, "gerente.hvcn@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(490065, "HOSPITAL DE BENAVENTE", "Luisa Mozo, 6", "ZAMORA", 980631900, "gerente.hvcn@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(490070, "COMPLEJO ASISTENCIAL  DE ZAMORA", "Avda. Requejo, 35", "ZAMORA", 980548200, "gerente.hvcn@saludcastillayleon.es", 1);
INSERT INTO hospital VALUES(490081, "HOSPITAL RECOLETAS DE ZAMORA", "Pinar, 7", "ZAMORA", 980545300, "carlos.beneitez.hrza@gruporecoletas.com", 0);
INSERT INTO hospital VALUES(500016, "HOSPITAL CLÍNICO UNIVERSITARIO LOZANO BLESA", "San Juan Bosco, 15", "ZARAGOZA", 976765700, "", 1);
INSERT INTO hospital VALUES(500021, "HOSPITAL UNIVERSITARIO MIGUEL SERVET", "Pº de Isabel La Católica, 1-3", "ZARAGOZA", 976765500, "sector2@salud.aragon.es", 1);
INSERT INTO hospital VALUES(500055, "HOSPITAL ROYO VILLANOVA", "Av. San Gregorio, 30", "ZARAGOZA", 976466910, "", 1);
INSERT INTO hospital VALUES(500068, "CENTRO DE REHABILITACION PSICOSOCIAL NUESTRA SEÑORA DEL PILAR", "Duquesa de Villahermosa, 66-68", "ZARAGOZA", 976331500, "", 1);
INSERT INTO hospital VALUES(500074, "HOSPITAL  NUESTRA SEÑORA DE GRACIA", "Ramón y Cajal, 60", "ZARAGOZA", 976440022, "jmmanrique@salud.aragon.es", 1);
INSERT INTO hospital VALUES(500080, "HOSPITAL MAZ", "Av. de la Academia General Militar, 74", "ZARAGOZA", 976748000, "maz@maz.es", 0);
INSERT INTO hospital VALUES(500093, "CLÍNICA MÉDICO QUIRÚRGICA MONTPELIER S.A.", "Vía Hispanidad, 37", "ZARAGOZA", 976765400, "secretaria.montpellier@clinicamontpellier.es", 0);
INSERT INTO hospital VALUES(500107, "CENTRO NEUROPSIQUIÁTRICO NUESTRA SEÑORA DEL CARMEN", "Camino del Abejar, nº 100 (Garrapinillos)", "ZARAGOZA", 976770635, "gerencia@neuronscarmen.org", 0);
INSERT INTO hospital VALUES(500114, "HOSPITAL SAN JUAN DE DIOS", "Pº de Colón, 14", "ZARAGOZA", 976271660, "hsjdzaragoza@ohsjd.es", 0);
INSERT INTO hospital VALUES(500129, "CLÍNICA QUIRÓN ZARAGOZA S.A.", "Pº Mariano Renovales, s/n", "ZARAGOZA", 976720000, "", 0);
INSERT INTO hospital VALUES(500135, "CLÍNICA NUESTRA SEÑORA DEL PILAR", "Pº de Ruiseñores, 20", "ZARAGOZA", 976275700, "gerencia@clinicansdelpilar.com", 0);
INSERT INTO hospital VALUES(500140, "HOSPITAL GENERAL DE LA DEFENSA DE ZARAGOZA", "Vía Ibérica, 1-15", "ZARAGOZA", 976305000, "", 1);
INSERT INTO hospital VALUES(500153, "HOSPITAL ERNEST LLUCH MARTIN", "Ctra. de Sagunto-Burgos, km. 254", "ZARAGOZA", 976880964, "", 1);
INSERT INTO hospital VALUES(500172, "CENTRO ASISTENCIAL PSIQUIÁTRICO DE SÁDABA", "Ctra. de Sos, s/n", "ZARAGOZA", 976675479, "", 0);
INSERT INTO hospital VALUES(500188, "UNIDAD REHABILITADORA DE MEDIA ESTANCIA PROFESOR REY ARDID", "Camino Viejo de Alfocea,10 Juslibol", "ZARAGOZA", 976731000, "rjuslibol@reyardid.org", 1);
INSERT INTO hospital VALUES(500195, "PROYECTO DE REHAB. INTEGRAL DE LA SALUD MENTAL EN ARAGÓN, S.A.", "Torre del cerezo, nº 17 Bº. de San Juan de Mozarrifar", "ZARAGOZA", 976151152, "administracion@prismasa.org", 0);
INSERT INTO hospital VALUES(500200, "CENTRO SANITARIO DE ALTA RESOLUCIÓN CINCO VILLAS (*)", "Antonio Machado, s/n", "ZARAGOZA", 976677978, "", 1);
INSERT INTO hospital VALUES(500218, "CLÍNICA MONTECANAL, SL", "C/ Franz Shubert, 2", "ZARAGOZA", 876241818, "admi@viamedmontecanal.com", 0);
INSERT INTO hospital VALUES(510039, "HOSPITAL UNIVERSITARIO DE CEUTA", "Loma Colmenar, s/n", "CEUTA", 856907000, "", 1);
INSERT INTO hospital VALUES(520018, "HOSPITAL COMARCAL", "Ctra. Remonta, 2", "MELILLA", 952698001, "inform@hcml.insalud.es", 1);