P05.001- Número de colegiado, apellidos, nombre y teléfono de los trabajadores de las ciudades "Simpson","Burgos" u "Ourense"
| colegiado | apellidos | nombre | telefono |
|---|---|---|---|
| 100092145 | ORTIZ CANO | SILVIA | 673768107 |
| 103805022 | PEREZ HERNANDEZ | AINHOA | 690980478 |
| 105685049 | LOPEZ MARTINEZ | ALBA | 669526151 |
| 107250057 | PEREZ GARCIA | ADRIAN | 673654478 |
| 113587728 | GONZALEZ MARTINEZ | NEREA | 677867107 |
| 114410185 | GALLEGO PEREZ | BORJA | 615656814 |
| 116508908 | SANCHEZ GARCIA | AARON | 653822788 |
| 124536942 | SANCHEZ JIMENEZ | SANDRA | 601745372 |
| 129841724 | TORRES ALVAREZ | SARA | 663501244 |
| 136550922 | FERNANDEZ FERNANDEZ | DAVID | 693093469 |
| 148722726 | GIL MOLINA | EVA MARIA | 679756130 |
| 157231659 | SANCHEZ PEREZ | DAVID | 671179285 |
| 171170425 | MOYA LOPEZ | ANNA | 602172509 |
| 175010439 | ROMERO GARCIA | AARON | 633206402 |
| 180313988 | ALVAREZ JIMENEZ | SONIA | 676070064 |
| 183769289 | ALVAREZ DIAZ | LAURA | 606484160 |
| 185678705 | RUIZ LOPEZ | HUGO | 621404057 |
| 190022289 | FERNANDEZ SANCHEZ | DAVID | 644363521 |
| 201518366 | RAMOS DIAZ | NAIARA | 613245654 |
| 206312127 | LOPEZ GARCIA | IGNACIO | 666923262 |
| 212759735 | ESTEBAN LOZANO | MATEO | 651798627 |
| 217390131 | RODRIGUEZ GONZALEZ | DANIEL | 657551910 |
| 219346176 | VARGAS SOTO | MIGUEL | 615452724 |
| 228857239 | MORA REYES | OIER | 662056422 |
| 241669872 | NAVARRO JIMENEZ | ALEJANDRA | 645088600 |
| 245776501 | PEÑA DELGADO | ALICIA | 602578840 |
| 247891195 | RODRIGUEZ SANCHEZ | CARLA | 660900108 |
| 251007572 | SANCHEZ DOMINGUEZ | PAULA | 649053671 |
| 251454464 | ROJAS FLORES | JUAN CARLOS | 621825233 |
| 251707519 | MARTIN DIAZ | RODRIGO | 685129781 |
| 254108940 | HIDALGO MENDEZ | EDUARDO | 698929409 |
| 258632479 | VARGAS SANTANA | YOLANDA | 655401060 |
| 268678331 | TORRES LOPEZ | RUBEN | 609007645 |
| 271007600 | REYES VARGAS | EVA MARIA | 619167184 |
| 274204291 | RODRIGUEZ GARCIA | ALICIA | 630998747 |
| 277483521 | GONZALEZ VAZQUEZ | DANIELA | 660567600 |
| 283137177 | CRESPO SANTOS | MARIA JOSE | 674029712 |
| 297911617 | CARRASCO MARTIN | CLARA | 650699510 |
| 299717384 | DIAZ DOMINGUEZ | LIDIA | 678457838 |
| 313493499 | GIL RUIZ | ALBA | 674793227 |
| 330489483 | GOMEZ GONZALEZ | IKER | 694500474 |
| 333702042 | MONTERO GUERRERO | INES | 643972964 |
| 343262685 | JIMENEZ GOMEZ | PABLO | 697174829 |
| 344560105 | MUÑOZ MARTINEZ | EDUARDO | 662658732 |
| 345614549 | CRUZ LORENZO | VANESSA | 687211888 |
| 345754282 | VAZQUEZ ALONSO | SOFIA | 611974685 |
| 361362261 | GONZALEZ SANCHEZ | ANDREA | 664604126 |
| 365141686 | DURAN MORENO | SANDRA | 676329399 |
| 366207685 | GARCIA GARCIA | ALBA | 604282087 |
| 370580440 | MEDINA CORTES | IRATI | 642388980 |
| 379156917 | GIL MARTINEZ | RUBEN | 687122728 |
| 381139543 | JIMENEZ ALVAREZ | RUBEN | 647478817 |
| 382172268 | SANCHEZ LOPEZ | DAVID | 604686068 |
| 382468599 | GONZALEZ MARTINEZ | SERGIO | 647880098 |
| 383415289 | FERNANDEZ NAVARRO | ROCIO | 645087474 |
| 383694423 | MARTINEZ GARCIA | DANIEL | 678716501 |
| 392892033 | SERRANO RAMIREZ | VIRGINIA | 667552196 |
| 395928571 | PEREZ ORTIZ | ALEJANDRA | 633825862 |
| 403528675 | SANCHEZ GUTIERREZ | SARA | 654983508 |
| 410135124 | RAMOS ROMERO | MARIO | 664558528 |
| 414055797 | HERNANDEZ SERRANO | NAIM | 691768720 |
| 421913651 | MENDEZ VICENTE | MARTINA | 658117758 |
| 437527250 | SANCHEZ ALONSO | ELENA | 660047581 |
| 454358258 | GARCIA SANCHEZ | ALVARO | 624385024 |
| 470224837 | MUÑOZ TORRES | MARTA | 690747599 |
| 473862388 | MENDEZ RUBIO | ELISA | 671429699 |
| 475175803 | NUÑEZ PASCUAL | AITOR | 643681965 |
| 477364539 | RODRIGUEZ FERNANDEZ | PAULA | 680714861 |
| 496265676 | MARTIN MUÑOZ | JOSE ANTONIO | 698460395 |
| 497223759 | SANCHEZ MARTINEZ | ADRIAN | 668194049 |
| 502432959 | VAZQUEZ NAVARRO | ANNA | 613861435 |
| 512329156 | GALLEGO GALLARDO | RUBEN | 607885918 |
| 519257614 | FERNANDEZ GONZALEZ | LUCIA | 686339147 |
| 530527167 | PEREZ RODRIGUEZ | LUCIA | 695404885 |
| 537923587 | CRUZ FERNANDEZ | JOSE ANGEL | 613715689 |
| 538156997 | SANCHEZ ROMERO | MIGUEL | 622568851 |
| 539402640 | HERNANDEZ DOMINGUEZ | NATALIA | 695941196 |
| 541112393 | SANCHEZ SANZ | FRANCISCO JAVIER | 689335923 |
| 548739108 | MUÑOZ DELGADO | ISAAC | 622461467 |
| 554573501 | ROMERO CABALLERO | VALERIA | 648989271 |
| 571211863 | GARCIA MARTINEZ | ANDREA | 653521398 |
| 571290866 | LOPEZ RODRIGUEZ | NATALIA | 680702045 |
| 579839850 | CABRERA ROMERO | SERGI | 641239041 |
| 581566554 | GARCIA MARTIN | ANGEL | 699016150 |
| 583044836 | PEREZ ALONSO | RAFAEL | 673390506 |
| 598128001 | ALVAREZ PEREZ | ELENA | 617366248 |
| 605747230 | HERNANDEZ ROMAN | VANESSA | 696110048 |
| 615729841 | GONZALEZ MARTINEZ | LUCIA | 674890272 |
| 616969411 | RODRIGUEZ DOMINGUEZ | NURIA | 652510491 |
| 626631561 | GOMEZ GUTIERREZ | ANGELA | 659168399 |
| 637684427 | VIDAL NIETO | LUIS MIGUEL | 654721207 |
| 647673398 | MARTINEZ MARTINEZ | PAULA | 694462589 |
| 647773586 | NAVARRO RUIZ | JOSE MANUEL | 647251323 |
| 654221869 | FERRER MORA | PATRICIA | 683704714 |
| 662445261 | JIMENEZ DIAZ | AINHOA | 698588491 |
| 668764471 | ROMERO GUTIERREZ | PEDRO | 635065230 |
| 681685795 | TORRES MORENO | EDUARDO | 673293962 |
| 690815950 | RODRIGUEZ ROMAN | HUGO | 699311241 |
| 707282499 | PARRA SANZ | GEMA | 637072538 |
| 707784664 | NAVARRO ROMERO | DIEGO | 679120800 |
100 filas (de 243) seleccionadas
P05.002- Número de colegiado, apellidos, nombre y teléfono de los trabajadores de las ciudades "Simpson","Burgos" u "Ourense" que son médicos.
| colegiado | apellidos | nombre | telefono |
|---|---|---|---|
| 105685049 | LOPEZ MARTINEZ | ALBA | 669526151 |
| 107250057 | PEREZ GARCIA | ADRIAN | 673654478 |
| 136550922 | FERNANDEZ FERNANDEZ | DAVID | 693093469 |
| 157231659 | SANCHEZ PEREZ | DAVID | 671179285 |
| 190022289 | FERNANDEZ SANCHEZ | DAVID | 644363521 |
| 217390131 | RODRIGUEZ GONZALEZ | DANIEL | 657551910 |
| 361362261 | GONZALEZ SANCHEZ | ANDREA | 664604126 |
| 366207685 | GARCIA GARCIA | ALBA | 604282087 |
| 382172268 | SANCHEZ LOPEZ | DAVID | 604686068 |
| 382468599 | GONZALEZ MARTINEZ | SERGIO | 647880098 |
| 383694423 | MARTINEZ GARCIA | DANIEL | 678716501 |
| 454358258 | GARCIA SANCHEZ | ALVARO | 624385024 |
| 477364539 | RODRIGUEZ FERNANDEZ | PAULA | 680714861 |
| 497223759 | SANCHEZ MARTINEZ | ADRIAN | 668194049 |
| 519257614 | FERNANDEZ GONZALEZ | LUCIA | 686339147 |
| 530527167 | PEREZ RODRIGUEZ | LUCIA | 695404885 |
| 571211863 | GARCIA MARTINEZ | ANDREA | 653521398 |
| 647673398 | MARTINEZ MARTINEZ | PAULA | 694462589 |
| 717551071 | FERNANDEZ RODRIGUEZ | LUCIA | 626001854 |
| 723174432 | SANCHEZ MARTINEZ | DAVID | 664212266 |
| 738401272 | SANCHEZ SANCHEZ | LAURA | 626684145 |
| 754972639 | LOPEZ LOPEZ | MARTA | 615828088 |
| 767806693 | GONZALEZ GONZALEZ | MARTA | 600006163 |
| 811624391 | LOPEZ LOPEZ | MARTA | 606521751 |
| 825094043 | LOPEZ MARTINEZ | MARTA | 607710921 |
| 832618897 | PEREZ FERNANDEZ | ALVARO | 641128912 |
| 849275399 | LOPEZ RODRIGUEZ | ALVARO | 618788037 |
| 860294890 | LOPEZ PEREZ | MARIA | 648255029 |
| 895461988 | GONZALEZ GONZALEZ | LUCIA | 654397970 |
| 930625095 | PEREZ MARTINEZ | ANDREA | 661326884 |
| 959211869 | PEREZ GONZALEZ | ADRIAN | 681686000 |
| 999498032 | GONZALEZ RODRIGUEZ | ANDREA | 660675743 |
| 100486812 | LOPEZ FERNANDEZ | JAIME | 610386743 |
| 111135999 | RUIZ JIMENEZ | JORGE | 618623252 |
| 143237785 | JIMENEZ JIMENEZ | NATALIA | 675181589 |
| 208951572 | MARTINEZ MORENO | SARA | 611025581 |
| 226401357 | MORENO GOMEZ | JORGE | 673013571 |
| 305805025 | RUIZ HERNANDEZ | MARCOS | 609296743 |
| 320737503 | MORENO DIAZ | LAURA | 658530687 |
| 332603258 | RODRIGUEZ FERNANDEZ | PATRICIA | 663049836 |
| 352807796 | GONZALEZ GONZALEZ | ALBA | 632405863 |
| 373437294 | DIAZ RODRIGUEZ | CRISTINA | 658440723 |
| 374246087 | SANCHEZ JIMENEZ | RAQUEL | 656388648 |
| 383812756 | LOPEZ MARTINEZ | PATRICIA | 676514759 |
| 400690204 | MARTIN GOMEZ | IRENE | 607154302 |
| 407019587 | HERNANDEZ MARTIN | SERGIO | 613781924 |
| 439317356 | PEREZ FERNANDEZ | PAULA | 663509685 |
| 441261384 | SANCHEZ JIMENEZ | MIGUEL | 669409896 |
| 448670555 | MORENO RUIZ | RUBEN | 685512001 |
| 451294364 | HERNANDEZ JIMENEZ | MARCOS | 641479036 |
| 488725113 | GARCIA LOPEZ | ELENA | 613388542 |
| 518118686 | MARTIN RUIZ | MARIO | 687644218 |
| 518618303 | MARTINEZ LOPEZ | PAULA | 632766287 |
| 530697871 | MARTIN MORENO | JAIME | 673755651 |
| 558435199 | DIAZ MORENO | CRISTINA | 620014643 |
| 572542614 | MORENO GARCIA | PABLO | 682410101 |
| 587633308 | MARTIN HERNANDEZ | ADRIAN | 661601093 |
| 600107736 | MORENO RODRIGUEZ | JORGE | 600895621 |
| 618504770 | GARCIA HERNANDEZ | OSCAR | 602587430 |
| 679096841 | JIMENEZ LOPEZ | ELENA | 633642505 |
| 778659158 | FERNANDEZ DIAZ | MARCOS | 691698625 |
| 779944996 | SANCHEZ SANCHEZ | AINHOA | 693838121 |
| 783628624 | PEREZ PEREZ | ANA | 634791543 |
| 860693896 | FERNANDEZ PEREZ | PABLO | 652149717 |
| 898372423 | PEREZ MORENO | RAQUEL | 680840721 |
| 925069761 | LOPEZ MARTINEZ | VICTOR | 602315806 |
| 936862762 | RODRIGUEZ DIAZ | ANA | 641886882 |
| 953094256 | PEREZ MARTIN | PABLO | 644303676 |
| 988785145 | JIMENEZ DIAZ | IRENE | 699245002 |
| 999974644 | PEREZ LOPEZ | ANGELA | 678584086 |
| 000000004 | Martinez Avila | Nora | 658412398 |
71 filas (de 71) seleccionadas
P05.003- Número de colegiado, apellidos, nombre y teléfono de los trabajadores de las ciudades "Simpson","Burgos" u "Ourense" que son médicos y no se llaman ni Nora, ni AINHOA ni ALBA.
| colegiado | apellidos | nombre | telefono |
|---|---|---|---|
| 107250057 | PEREZ GARCIA | ADRIAN | 673654478 |
| 136550922 | FERNANDEZ FERNANDEZ | DAVID | 693093469 |
| 157231659 | SANCHEZ PEREZ | DAVID | 671179285 |
| 190022289 | FERNANDEZ SANCHEZ | DAVID | 644363521 |
| 217390131 | RODRIGUEZ GONZALEZ | DANIEL | 657551910 |
| 361362261 | GONZALEZ SANCHEZ | ANDREA | 664604126 |
| 382172268 | SANCHEZ LOPEZ | DAVID | 604686068 |
| 382468599 | GONZALEZ MARTINEZ | SERGIO | 647880098 |
| 383694423 | MARTINEZ GARCIA | DANIEL | 678716501 |
| 454358258 | GARCIA SANCHEZ | ALVARO | 624385024 |
| 477364539 | RODRIGUEZ FERNANDEZ | PAULA | 680714861 |
| 497223759 | SANCHEZ MARTINEZ | ADRIAN | 668194049 |
| 519257614 | FERNANDEZ GONZALEZ | LUCIA | 686339147 |
| 530527167 | PEREZ RODRIGUEZ | LUCIA | 695404885 |
| 571211863 | GARCIA MARTINEZ | ANDREA | 653521398 |
| 647673398 | MARTINEZ MARTINEZ | PAULA | 694462589 |
| 717551071 | FERNANDEZ RODRIGUEZ | LUCIA | 626001854 |
| 723174432 | SANCHEZ MARTINEZ | DAVID | 664212266 |
| 738401272 | SANCHEZ SANCHEZ | LAURA | 626684145 |
| 754972639 | LOPEZ LOPEZ | MARTA | 615828088 |
| 767806693 | GONZALEZ GONZALEZ | MARTA | 600006163 |
| 811624391 | LOPEZ LOPEZ | MARTA | 606521751 |
| 825094043 | LOPEZ MARTINEZ | MARTA | 607710921 |
| 832618897 | PEREZ FERNANDEZ | ALVARO | 641128912 |
| 849275399 | LOPEZ RODRIGUEZ | ALVARO | 618788037 |
| 860294890 | LOPEZ PEREZ | MARIA | 648255029 |
| 895461988 | GONZALEZ GONZALEZ | LUCIA | 654397970 |
| 930625095 | PEREZ MARTINEZ | ANDREA | 661326884 |
| 959211869 | PEREZ GONZALEZ | ADRIAN | 681686000 |
| 999498032 | GONZALEZ RODRIGUEZ | ANDREA | 660675743 |
| 100486812 | LOPEZ FERNANDEZ | JAIME | 610386743 |
| 111135999 | RUIZ JIMENEZ | JORGE | 618623252 |
| 143237785 | JIMENEZ JIMENEZ | NATALIA | 675181589 |
| 208951572 | MARTINEZ MORENO | SARA | 611025581 |
| 226401357 | MORENO GOMEZ | JORGE | 673013571 |
| 305805025 | RUIZ HERNANDEZ | MARCOS | 609296743 |
| 320737503 | MORENO DIAZ | LAURA | 658530687 |
| 332603258 | RODRIGUEZ FERNANDEZ | PATRICIA | 663049836 |
| 373437294 | DIAZ RODRIGUEZ | CRISTINA | 658440723 |
| 374246087 | SANCHEZ JIMENEZ | RAQUEL | 656388648 |
| 383812756 | LOPEZ MARTINEZ | PATRICIA | 676514759 |
| 400690204 | MARTIN GOMEZ | IRENE | 607154302 |
| 407019587 | HERNANDEZ MARTIN | SERGIO | 613781924 |
| 439317356 | PEREZ FERNANDEZ | PAULA | 663509685 |
| 441261384 | SANCHEZ JIMENEZ | MIGUEL | 669409896 |
| 448670555 | MORENO RUIZ | RUBEN | 685512001 |
| 451294364 | HERNANDEZ JIMENEZ | MARCOS | 641479036 |
| 488725113 | GARCIA LOPEZ | ELENA | 613388542 |
| 518118686 | MARTIN RUIZ | MARIO | 687644218 |
| 518618303 | MARTINEZ LOPEZ | PAULA | 632766287 |
| 530697871 | MARTIN MORENO | JAIME | 673755651 |
| 558435199 | DIAZ MORENO | CRISTINA | 620014643 |
| 572542614 | MORENO GARCIA | PABLO | 682410101 |
| 587633308 | MARTIN HERNANDEZ | ADRIAN | 661601093 |
| 600107736 | MORENO RODRIGUEZ | JORGE | 600895621 |
| 618504770 | GARCIA HERNANDEZ | OSCAR | 602587430 |
| 679096841 | JIMENEZ LOPEZ | ELENA | 633642505 |
| 778659158 | FERNANDEZ DIAZ | MARCOS | 691698625 |
| 783628624 | PEREZ PEREZ | ANA | 634791543 |
| 860693896 | FERNANDEZ PEREZ | PABLO | 652149717 |
| 898372423 | PEREZ MORENO | RAQUEL | 680840721 |
| 925069761 | LOPEZ MARTINEZ | VICTOR | 602315806 |
| 936862762 | RODRIGUEZ DIAZ | ANA | 641886882 |
| 953094256 | PEREZ MARTIN | PABLO | 644303676 |
| 988785145 | JIMENEZ DIAZ | IRENE | 699245002 |
| 999974644 | PEREZ LOPEZ | ANGELA | 678584086 |
66 filas (de 66) seleccionadas
P05.004- Obtener en una única columna el nombre completo de los trabajadores, con el formato "APELLIDOS, NOMBRE", de aquellos que son de la ciudad de "Elx/Elche". Busca la función necesaria en el manual de MySQL. La columna ha de estar etiquetada como "NomCompleto".
| NomCompleto |
|---|
| SANTOS NUÑEZ, ESTHER |
| MARTINEZ SANCHEZ, DIEGO |
| ALVAREZ MARTINEZ, JOSE MARIA |
| ROJAS PARRA, UNAI |
| PRIETO SUAREZ, LUCIA |
| ORTIZ GUTIERREZ, ALEIX |
| SANCHEZ RODRIGUEZ, JUAN |
| ALONSO GIL, ENRIQUE |
| GARCIA GARCIA, ANDREA |
| FERNANDEZ PEREZ, ANTONIO |
| LOPEZ GONZALEZ, LUCIA |
| LOPEZ SANCHEZ, ALVARO |
| LOPEZ BLANCO, NATALIA |
| GONZALEZ HERNANDEZ, RODRIGO |
| GONZALEZ GARCIA, MARIA |
| ORTIZ GIL, NEREA |
| MARTIN MORALES, FRANCISCO JAVIER |
| NAVARRO PEREZ, DAVID |
| SANCHEZ FERNANDEZ, ADRIAN |
| DIAZ CABALLERO, ROGER |
| SANCHEZ GONZALEZ, NEREA |
| MARIN HERNANDEZ, CARMEN MARIA |
| MARTINEZ FERNANDEZ, CRISTINA |
| FERNANDEZ PEREZ, ADRIAN |
| GONZALEZ PEREZ, SARA |
| ALVAREZ NUÑEZ, JAVIER |
| HERNANDEZ VAZQUEZ, LARA |
| MARTINEZ GARCIA, ANA |
| SANCHEZ MORENO, ALBA |
| CASTRO DELGADO, VICTOR |
| PEREZ GARCIA, NEREA |
| GOMEZ RAMIREZ, ROCIO |
| GONZALEZ SANCHEZ, ALBA |
| PEREZ MARTINEZ, JAVIER |
| GARRIDO RAMOS, ISABEL MARIA |
| PEREZ FERNANDEZ, MANUEL |
| DIAZ PEREZ, PAU |
| SANCHEZ RODRIGUEZ, ADRIAN |
| SANCHEZ FERNANDEZ, LUCIA |
| GONZALEZ GONZALEZ, JULIA |
| RODRIGUEZ RODRIGUEZ, ADRIAN |
| SOLER SOTO, LUNA |
| MARTINEZ FERNANDEZ, ANTONIO |
| SUAREZ PEREZ, AARON |
| RUBIO JIMENEZ, ANGEL |
| PEREZ GUTIERREZ, CLARA |
| CABALLERO TORRES, JOSE |
| CORTES SERRANO, LORENA |
| PEREZ MORENO, ANDRES |
| SERRANO RUIZ, ISABEL |
| FERNANDEZ CANO, LOLA |
| SANCHEZ FERNANDEZ, SARA |
| SANCHEZ GIMENEZ, MARIA JOSE |
| SANCHEZ LOPEZ, CRISTINA |
| GIL TORRES, ANDREA |
| GALLEGO GARCIA, JULIAN |
| GIMENEZ ROJAS, GONZALO |
| PEREZ GONZALEZ, NEREA |
| SANCHEZ LOPEZ, MANUEL |
| CASTRO MUÑOZ, FERNANDO |
| MARIN PRIETO, VICTORIA |
| NUÑEZ ORTEGA, UNAI |
| DURAN CASTILLO, ESTHER |
| RAMOS LOPEZ, GERARD |
| RAMIREZ MORENO, PABLO |
| BRAVO ROMAN, INMACULADA |
| ROMAN SANZ, SOFIA |
| SANTANA VELASCO, NAIARA |
| SANCHEZ MARTINEZ, ADRIAN |
| MUÑOZ JIMENEZ, MARIA |
| VAZQUEZ VAZQUEZ, HECTOR |
| VAZQUEZ MORA, SERGI |
| SANCHEZ FERNANDEZ, LAURA |
| MORALES LOPEZ, ANNA |
| GUTIERREZ TORRES, MONICA |
| SANZ MORALES, FRANCISCO JAVIER |
| RODRIGUEZ FERNANDEZ, ANA |
| ALVAREZ ALVAREZ, JESUS |
| JIMENEZ MARIN, KEVIN |
| PEÑA MENDEZ, ANA |
| ARIAS FERNANDEZ, GEMMA |
| MORALES NAVARRO, MIREIA |
| DELGADO VAZQUEZ, ALBERTO |
| CASTRO NUÑEZ, ENEKO |
| SANCHEZ PEREZ, NEREA |
| MARTINEZ BLANCO, LUCAS |
| ROMERO NUÑEZ, BEATRIZ |
| DIAZ BLANCO, JESUS |
| LOPEZ LOPEZ, NEREA |
| GARRIDO CASTILLO, CLARA |
| PEREZ MARTINEZ, SERGIO |
| MOLINA RAMOS, AINHOA |
| MARIN MARTIN, ANGEL |
| FERNANDEZ GARCIA, SARA |
| MARTINEZ FERNANDEZ, CARLOS |
| ORTIZ LOPEZ, MARTA |
| VARGAS CRUZ, JOSE MIGUEL |
| ORTEGA MARTINEZ, ANGEL |
| MUÑOZ GUERRERO, OIER |
| MARTINEZ GONZALEZ, SARA |
100 filas (de 156) seleccionadas
P05.005- Mostrar apellidos, nombre y provincia de los médicos, y si la ciudad es Alicante, mostrarla como Alacant; las otras ciudades, tal y como estén en la BD.
| apellidos | nombre | if(ciudad='Alicante','Alacant',ciudad) |
|---|---|---|
| Gomez Rico | Juan | Alacant |
| Martinez Avila | Nora | Simpson |
| PEREZ SANCHEZ | ADRIAN | Barcelona |
| FERNANDEZ LOPEZ | MARTA | Barcelona |
| LOPEZ FERNANDEZ | JAIME | Ourense |
| LOPEZ LOPEZ | PABLO | Barcelona |
| FERNANDEZ GONZALEZ | ADRIAN | Santander |
| PEREZ GARCIA | CLAUDIA | Alacant/Alicante |
| FERNANDEZ LOPEZ | DIEGO | Alcoi/Alcoy |
| MARTINEZ GONZALEZ | DAVID | Córdoba |
| LOPEZ RODRIGUEZ | SILVIA | Madrid |
| FERNANDEZ MARTINEZ | MARINA | Zamora |
| GARCIA PEREZ | ALEJANDRO | Cáceres |
| RUIZ GOMEZ | NEREA | Málaga |
| LOPEZ SANCHEZ | DANIEL | Almería |
| RODRIGUEZ RODRIGUEZ | ANA | Mataró |
| LOPEZ SANCHEZ | ADRIAN | Segovia |
| GARCIA GARCIA | ALEJANDRO | Lleida |
| GONZALEZ GARCIA | LAURA | Santander |
| HERNANDEZ GOMEZ | ELENA | Salamanca |
| GONZALEZ GARCIA | ROCIO | Fuenlabrada |
| GOMEZ FERNANDEZ | JUAN | Valladolid |
| RODRIGUEZ PEREZ | MARIA | Tarragona |
| FERNANDEZ RODRIGUEZ | PABLO | Mataró |
| GONZALEZ GONZALEZ | DANIEL | Santiago de Compostela |
| GONZALEZ MARTINEZ | MIGUEL | Tarragona |
| SANCHEZ PEREZ | CLAUDIA | Ávila |
| FERNANDEZ RODRIGUEZ | DANIEL | Granada |
| RUIZ MUÑOZ | RAUL | Madrid |
| SANCHEZ SANCHEZ | ALBA | Barcelona |
| GONZALEZ PEREZ | JAVIER | Badajoz |
| MARTINEZ PEREZ | ADRIAN | Barcelona |
| HERNANDEZ DIAZ | ANGELA | Madrid |
| RODRIGUEZ LOPEZ | LUCIA | Cuenca |
| LOPEZ HERNANDEZ | JOSE | Madrid |
| GARCIA GARCIA | LUCIA | Lleida |
| RODRIGUEZ ALVAREZ | AINHOA | Madrid |
| GONZALEZ GONZALEZ | MANUEL | Segovia |
| FERNANDEZ RODRIGUEZ | LAURA | Sant Cugat del Vallés |
| GARCIA DIAZ | ALBA | Madrid |
| HERNANDEZ GARCIA | ANTONIO | Vigo |
| RODRIGUEZ FERNANDEZ | ALEJANDRO | Barcelona |
| LOPEZ SANCHEZ | ALBA | Córdoba |
| MARTINEZ SANCHEZ | ALVARO | Algeciras |
| LOPEZ MARTINEZ | ALBA | Burgos |
| LOPEZ SANCHEZ | ELENA | Sevilla |
| PEREZ SANCHEZ | CARLOS | Palma de Mallorca |
| GOMEZ GOMEZ | PAULA | Salamanca |
| PEREZ FERNANDEZ | ALVARO | Badajoz |
| LOPEZ DIAZ | ALBA | Palencia |
| PEREZ GARCIA | ADRIAN | Burgos |
| GONZALEZ RODRIGUEZ | DANIEL | Terrassa |
| SANCHEZ LOPEZ | IRENE | Sevilla |
| MARTINEZ RODRIGUEZ | ANDREA | Barcelona |
| GOMEZ MARTINEZ | VICTOR | Málaga |
| GONZALEZ LOPEZ | JORGE | Zaragoza |
| GARCIA GARCIA | LAURA | Granada |
| SANCHEZ GARCIA | NEREA | Gandía |
| GARCIA GARCIA | ADRIAN | Castelló de la Plana/Castellón de la Plana |
| PEREZ MARTIN | PAULA | Soria |
| SANCHEZ PEREZ | LAURA | Barcelona |
| GONZALEZ LOPEZ | ADRIAN | Jerez de la Frontera |
| LOPEZ GARCIA | MARIA | Granada |
| LOPEZ GONZALEZ | PAULA | Badajoz |
| RODRIGUEZ PEREZ | ALBA | Castelló de la Plana/Castellón de la Plana |
| PEREZ RODRIGUEZ | ALBA | Alacant/Alicante |
| FERNANDEZ RODRIGUEZ | ANDREA | Santander |
| GARCIA FERNANDEZ | MARIA | Jerez de la Frontera |
| MARTINEZ RUIZ | CRISTINA | Cartagena |
| RUIZ JIMENEZ | JORGE | Ourense |
| GOMEZ FERNANDEZ | IRENE | Sevilla |
| GARCIA SANCHEZ | DAVID | Granollers |
| GOMEZ MARTIN | DIEGO | Las Arenas |
| GOMEZ RODRIGUEZ | ALEJANDRO | Valladolid |
| LOPEZ GARCIA | LAURA | Granada |
| RODRIGUEZ GARCIA | ANDREA | Almería |
| MARTINEZ SANCHEZ | DIEGO | Elx/Elche |
| FERNANDEZ LOPEZ | IRENE | Valencia |
| SANCHEZ GARCIA | DAVID | Badajoz |
| RODRIGUEZ MARTINEZ | ALVARO | Mataró |
| LOPEZ LOPEZ | ADRIAN | Sant Cugat del Vallés |
| RODRIGUEZ GONZALEZ | MARTA | Barcelona |
| PEREZ JIMENEZ | ALVARO | Madrid |
| SANCHEZ GARCIA | ALVARO | Ciudad Real |
| GONZALEZ RODRIGUEZ | ADRIAN | Girona |
| RODRIGUEZ GONZALEZ | DANIEL | Castelló de la Plana/Castellón de la Plana |
| PEREZ LOPEZ | ANDREA | Santa Coloma de Gramanet |
| RUIZ GARCIA | JOSE | Alcorcón |
| LOPEZ LOPEZ | ADRIAN | Bilbao |
| RODRIGUEZ FERNANDEZ | JUAN | Málaga |
| FERNANDEZ RUIZ | CARLOS | Palmas de Gran Canaria,Las |
| GARCIA GARCIA | LUCIA | León |
| GONZALEZ MARTINEZ | PABLO | Badajoz |
| GARCIA GARCIA | LUCIA | León |
| GARCIA GARCIA | ALEJANDRO | Madrid |
| SANCHEZ RODRIGUEZ | JAVIER | Mataró |
| RODRIGUEZ PEREZ | CRISTINA | Gijón |
| PEREZ LOPEZ | JORGE | Sevilla |
| FERNANDEZ DIAZ | ALVARO | Palmas de Gran Canaria,Las |
| RODRIGUEZ GONZALEZ | SARA | Gandía |
100 filas (de 5004) seleccionadas
P05.006- Crear un código con las 3 primeras letras de los apellidos, las 3 primeras del nombre y los 3 últimos dígitos del teléfono de los médicos. La columna se etiquetará "código".
| código |
|---|
| GomJua076 |
| MarNor398 |
| PERADR846 |
| FERMAR015 |
| LOPJAI743 |
| LOPPAB818 |
| FERADR432 |
| PERCLA679 |
| FERDIE764 |
| MARDAV593 |
| LOPSIL204 |
| FERMAR435 |
| GARALE085 |
| RUINER446 |
| LOPDAN623 |
| RODANA719 |
| LOPADR986 |
| GARALE270 |
| GONLAU013 |
| HERELE005 |
| GONROC565 |
| GOMJUA570 |
| RODMAR797 |
| FERPAB574 |
| GONDAN360 |
| GONMIG162 |
| SANCLA811 |
| FERDAN016 |
| RUIRAU523 |
| SANALB595 |
| GONJAV375 |
| MARADR637 |
| HERANG320 |
| RODLUC314 |
| LOPJOS979 |
| GARLUC947 |
| RODAIN601 |
| GONMAN577 |
| FERLAU500 |
| GARALB965 |
| HERANT743 |
| RODALE218 |
| LOPALB031 |
| MARALV010 |
| LOPALB151 |
| LOPELE243 |
| PERCAR775 |
| GOMPAU472 |
| PERALV980 |
| LOPALB965 |
| PERADR478 |
| GONDAN327 |
| SANIRE870 |
| MARAND458 |
| GOMVIC548 |
| GONJOR660 |
| GARLAU281 |
| SANNER078 |
| GARADR043 |
| PERPAU526 |
| SANLAU004 |
| GONADR906 |
| LOPMAR154 |
| LOPPAU152 |
| RODALB285 |
| PERALB751 |
| FERAND186 |
| GARMAR101 |
| MARCRI889 |
| RUIJOR252 |
| GOMIRE385 |
| GARDAV585 |
| GOMDIE959 |
| GOMALE990 |
| LOPLAU536 |
| RODAND666 |
| MARDIE338 |
| FERIRE022 |
| SANDAV338 |
| RODALV371 |
| LOPADR740 |
| RODMAR154 |
| PERALV381 |
| SANALV586 |
| GONADR938 |
| RODDAN060 |
| PERAND770 |
| RUIJOS078 |
| LOPADR101 |
| RODJUA642 |
| FERCAR334 |
| GARLUC043 |
| GONPAB527 |
| GARLUC108 |
| GARALE411 |
| SANJAV364 |
| RODCRI865 |
| PERJOR074 |
| FERALV494 |
| RODSAR929 |
100 filas (de 5004) seleccionadas
P05.007- SIP y fecha de nacimiento de los pacientes, ordenado por fecha de nacimiento descendente.
| sip | fecha_nacimiento |
|---|---|
| 1790933 | 2014-05-01 |
| 1165936 | 2014-05-01 |
| 3954015 | 2014-04-30 |
| 1827919 | 2014-04-29 |
| 5222859 | 2014-04-28 |
| 5783678 | 2014-04-28 |
| 1548020 | 2014-04-27 |
| 3303632 | 2014-04-26 |
| 1694019 | 2014-04-25 |
| 1525153 | 2014-04-24 |
| 6209858 | 2014-04-24 |
| 8904255 | 2014-04-22 |
| 4600067 | 2014-04-22 |
| 5608429 | 2014-04-22 |
| 5158313 | 2014-04-18 |
| 5105371 | 2014-04-15 |
| 2518562 | 2014-04-15 |
| 1830029 | 2014-04-14 |
| 8986096 | 2014-04-11 |
| 9557525 | 2014-04-10 |
| 7884722 | 2014-04-07 |
| 4890746 | 2014-04-07 |
| 6523038 | 2014-04-06 |
| 5942406 | 2014-04-06 |
| 1355447 | 2014-04-05 |
| 5301969 | 2014-04-04 |
| 3415423 | 2014-04-04 |
| 9647583 | 2014-04-04 |
| 8937281 | 2014-04-04 |
| 4967947 | 2014-04-03 |
| 9711399 | 2014-04-03 |
| 9970131 | 2014-04-01 |
| 8242126 | 2014-03-31 |
| 9261497 | 2014-03-31 |
| 3573311 | 2014-03-30 |
| 1659713 | 2014-03-29 |
| 5530504 | 2014-03-27 |
| 9012305 | 2014-03-27 |
| 8440771 | 2014-03-26 |
| 2130591 | 2014-03-25 |
| 8497254 | 2014-03-25 |
| 7304980 | 2014-03-25 |
| 1236153 | 2014-03-23 |
| 2248257 | 2014-03-23 |
| 4897710 | 2014-03-23 |
| 6971939 | 2014-03-21 |
| 1438606 | 2014-03-21 |
| 2883634 | 2014-03-21 |
| 9948865 | 2014-03-20 |
| 5225461 | 2014-03-19 |
| 3448034 | 2014-03-18 |
| 6693967 | 2014-03-16 |
| 8027181 | 2014-03-16 |
| 6244798 | 2014-03-15 |
| 1153244 | 2014-03-14 |
| 9343622 | 2014-03-11 |
| 8326752 | 2014-03-11 |
| 6196820 | 2014-03-11 |
| 8668400 | 2014-03-10 |
| 2812224 | 2014-03-09 |
| 3960731 | 2014-03-08 |
| 6001858 | 2014-03-08 |
| 6202509 | 2014-03-07 |
| 9242692 | 2014-03-07 |
| 8003271 | 2014-03-04 |
| 7773142 | 2014-03-03 |
| 4969728 | 2014-03-03 |
| 5260056 | 2014-03-02 |
| 4137229 | 2014-03-02 |
| 7267069 | 2014-03-02 |
| 3445889 | 2014-03-01 |
| 5763405 | 2014-03-01 |
| 5531391 | 2014-03-01 |
| 4276358 | 2014-02-28 |
| 9814916 | 2014-02-27 |
| 6899733 | 2014-02-26 |
| 4662354 | 2014-02-26 |
| 6980240 | 2014-02-24 |
| 5445515 | 2014-02-23 |
| 6826928 | 2014-02-23 |
| 7837223 | 2014-02-22 |
| 1473151 | 2014-02-21 |
| 2584450 | 2014-02-20 |
| 6328764 | 2014-02-20 |
| 4334143 | 2014-02-19 |
| 9773746 | 2014-02-19 |
| 5731895 | 2014-02-19 |
| 9577756 | 2014-02-18 |
| 9273324 | 2014-02-18 |
| 3751370 | 2014-02-18 |
| 6260927 | 2014-02-17 |
| 9828394 | 2014-02-17 |
| 6391713 | 2014-02-16 |
| 6374461 | 2014-02-15 |
| 4039957 | 2014-02-13 |
| 9664763 | 2014-02-13 |
| 7578944 | 2014-02-13 |
| 2682988 | 2014-02-09 |
| 3501813 | 2014-02-08 |
| 5678361 | 2014-02-07 |
100 filas (de 20000) seleccionadas
P05.008- SIP y día del mes de la fecha de nacimiento de los pacientes, ordenado por fecha de nacimiento descendente.
| sip | día |
|---|---|
| 1790933 | 1 |
| 1165936 | 1 |
| 3954015 | 30 |
| 1827919 | 29 |
| 5222859 | 28 |
| 5783678 | 28 |
| 1548020 | 27 |
| 3303632 | 26 |
| 1694019 | 25 |
| 1525153 | 24 |
| 6209858 | 24 |
| 8904255 | 22 |
| 4600067 | 22 |
| 5608429 | 22 |
| 5158313 | 18 |
| 5105371 | 15 |
| 2518562 | 15 |
| 1830029 | 14 |
| 8986096 | 11 |
| 9557525 | 10 |
| 7884722 | 7 |
| 4890746 | 7 |
| 6523038 | 6 |
| 5942406 | 6 |
| 1355447 | 5 |
| 5301969 | 4 |
| 3415423 | 4 |
| 9647583 | 4 |
| 8937281 | 4 |
| 4967947 | 3 |
| 9711399 | 3 |
| 9970131 | 1 |
| 8242126 | 31 |
| 9261497 | 31 |
| 3573311 | 30 |
| 1659713 | 29 |
| 5530504 | 27 |
| 9012305 | 27 |
| 8440771 | 26 |
| 2130591 | 25 |
| 8497254 | 25 |
| 7304980 | 25 |
| 1236153 | 23 |
| 2248257 | 23 |
| 4897710 | 23 |
| 6971939 | 21 |
| 1438606 | 21 |
| 2883634 | 21 |
| 9948865 | 20 |
| 5225461 | 19 |
| 3448034 | 18 |
| 6693967 | 16 |
| 8027181 | 16 |
| 6244798 | 15 |
| 1153244 | 14 |
| 9343622 | 11 |
| 8326752 | 11 |
| 6196820 | 11 |
| 8668400 | 10 |
| 2812224 | 9 |
| 3960731 | 8 |
| 6001858 | 8 |
| 6202509 | 7 |
| 9242692 | 7 |
| 8003271 | 4 |
| 7773142 | 3 |
| 4969728 | 3 |
| 5260056 | 2 |
| 4137229 | 2 |
| 7267069 | 2 |
| 3445889 | 1 |
| 5763405 | 1 |
| 5531391 | 1 |
| 4276358 | 28 |
| 9814916 | 27 |
| 6899733 | 26 |
| 4662354 | 26 |
| 6980240 | 24 |
| 5445515 | 23 |
| 6826928 | 23 |
| 7837223 | 22 |
| 1473151 | 21 |
| 2584450 | 20 |
| 6328764 | 20 |
| 4334143 | 19 |
| 9773746 | 19 |
| 5731895 | 19 |
| 9577756 | 18 |
| 9273324 | 18 |
| 3751370 | 18 |
| 6260927 | 17 |
| 9828394 | 17 |
| 6391713 | 16 |
| 6374461 | 15 |
| 4039957 | 13 |
| 9664763 | 13 |
| 7578944 | 13 |
| 2682988 | 9 |
| 3501813 | 8 |
| 5678361 | 7 |
100 filas (de 20000) seleccionadas
P05.009- SIP, mes y día del mes de la fecha de nacimiento de los pacientes, ordenado por fecha de nacimiento descendente.
| sip | mes | día |
|---|---|---|
| 1790933 | 5 | 1 |
| 1165936 | 5 | 1 |
| 3954015 | 4 | 30 |
| 1827919 | 4 | 29 |
| 5222859 | 4 | 28 |
| 5783678 | 4 | 28 |
| 1548020 | 4 | 27 |
| 3303632 | 4 | 26 |
| 1694019 | 4 | 25 |
| 1525153 | 4 | 24 |
| 6209858 | 4 | 24 |
| 8904255 | 4 | 22 |
| 4600067 | 4 | 22 |
| 5608429 | 4 | 22 |
| 5158313 | 4 | 18 |
| 5105371 | 4 | 15 |
| 2518562 | 4 | 15 |
| 1830029 | 4 | 14 |
| 8986096 | 4 | 11 |
| 9557525 | 4 | 10 |
| 7884722 | 4 | 7 |
| 4890746 | 4 | 7 |
| 6523038 | 4 | 6 |
| 5942406 | 4 | 6 |
| 1355447 | 4 | 5 |
| 5301969 | 4 | 4 |
| 3415423 | 4 | 4 |
| 9647583 | 4 | 4 |
| 8937281 | 4 | 4 |
| 4967947 | 4 | 3 |
| 9711399 | 4 | 3 |
| 9970131 | 4 | 1 |
| 8242126 | 3 | 31 |
| 9261497 | 3 | 31 |
| 3573311 | 3 | 30 |
| 1659713 | 3 | 29 |
| 5530504 | 3 | 27 |
| 9012305 | 3 | 27 |
| 8440771 | 3 | 26 |
| 2130591 | 3 | 25 |
| 8497254 | 3 | 25 |
| 7304980 | 3 | 25 |
| 1236153 | 3 | 23 |
| 2248257 | 3 | 23 |
| 4897710 | 3 | 23 |
| 6971939 | 3 | 21 |
| 1438606 | 3 | 21 |
| 2883634 | 3 | 21 |
| 9948865 | 3 | 20 |
| 5225461 | 3 | 19 |
| 3448034 | 3 | 18 |
| 6693967 | 3 | 16 |
| 8027181 | 3 | 16 |
| 6244798 | 3 | 15 |
| 1153244 | 3 | 14 |
| 9343622 | 3 | 11 |
| 8326752 | 3 | 11 |
| 6196820 | 3 | 11 |
| 8668400 | 3 | 10 |
| 2812224 | 3 | 9 |
| 3960731 | 3 | 8 |
| 6001858 | 3 | 8 |
| 6202509 | 3 | 7 |
| 9242692 | 3 | 7 |
| 8003271 | 3 | 4 |
| 7773142 | 3 | 3 |
| 4969728 | 3 | 3 |
| 5260056 | 3 | 2 |
| 4137229 | 3 | 2 |
| 7267069 | 3 | 2 |
| 3445889 | 3 | 1 |
| 5763405 | 3 | 1 |
| 5531391 | 3 | 1 |
| 4276358 | 2 | 28 |
| 9814916 | 2 | 27 |
| 6899733 | 2 | 26 |
| 4662354 | 2 | 26 |
| 6980240 | 2 | 24 |
| 5445515 | 2 | 23 |
| 6826928 | 2 | 23 |
| 7837223 | 2 | 22 |
| 1473151 | 2 | 21 |
| 2584450 | 2 | 20 |
| 6328764 | 2 | 20 |
| 4334143 | 2 | 19 |
| 9773746 | 2 | 19 |
| 5731895 | 2 | 19 |
| 9577756 | 2 | 18 |
| 9273324 | 2 | 18 |
| 3751370 | 2 | 18 |
| 6260927 | 2 | 17 |
| 9828394 | 2 | 17 |
| 6391713 | 2 | 16 |
| 6374461 | 2 | 15 |
| 4039957 | 2 | 13 |
| 9664763 | 2 | 13 |
| 7578944 | 2 | 13 |
| 2682988 | 2 | 9 |
| 3501813 | 2 | 8 |
| 5678361 | 2 | 7 |
100 filas (de 20000) seleccionadas
P05.010- SIP, año, mes y día del mes de la fecha de nacimiento de los pacientes, ordenado por fecha de nacimiento descendente.
| sip | año | mes | día |
|---|---|---|---|
| 1790933 | 2014 | 5 | 1 |
| 1165936 | 2014 | 5 | 1 |
| 3954015 | 2014 | 4 | 30 |
| 1827919 | 2014 | 4 | 29 |
| 5222859 | 2014 | 4 | 28 |
| 5783678 | 2014 | 4 | 28 |
| 1548020 | 2014 | 4 | 27 |
| 3303632 | 2014 | 4 | 26 |
| 1694019 | 2014 | 4 | 25 |
| 1525153 | 2014 | 4 | 24 |
| 6209858 | 2014 | 4 | 24 |
| 8904255 | 2014 | 4 | 22 |
| 4600067 | 2014 | 4 | 22 |
| 5608429 | 2014 | 4 | 22 |
| 5158313 | 2014 | 4 | 18 |
| 5105371 | 2014 | 4 | 15 |
| 2518562 | 2014 | 4 | 15 |
| 1830029 | 2014 | 4 | 14 |
| 8986096 | 2014 | 4 | 11 |
| 9557525 | 2014 | 4 | 10 |
| 7884722 | 2014 | 4 | 7 |
| 4890746 | 2014 | 4 | 7 |
| 6523038 | 2014 | 4 | 6 |
| 5942406 | 2014 | 4 | 6 |
| 1355447 | 2014 | 4 | 5 |
| 5301969 | 2014 | 4 | 4 |
| 3415423 | 2014 | 4 | 4 |
| 9647583 | 2014 | 4 | 4 |
| 8937281 | 2014 | 4 | 4 |
| 4967947 | 2014 | 4 | 3 |
| 9711399 | 2014 | 4 | 3 |
| 9970131 | 2014 | 4 | 1 |
| 8242126 | 2014 | 3 | 31 |
| 9261497 | 2014 | 3 | 31 |
| 3573311 | 2014 | 3 | 30 |
| 1659713 | 2014 | 3 | 29 |
| 5530504 | 2014 | 3 | 27 |
| 9012305 | 2014 | 3 | 27 |
| 8440771 | 2014 | 3 | 26 |
| 2130591 | 2014 | 3 | 25 |
| 8497254 | 2014 | 3 | 25 |
| 7304980 | 2014 | 3 | 25 |
| 1236153 | 2014 | 3 | 23 |
| 2248257 | 2014 | 3 | 23 |
| 4897710 | 2014 | 3 | 23 |
| 6971939 | 2014 | 3 | 21 |
| 1438606 | 2014 | 3 | 21 |
| 2883634 | 2014 | 3 | 21 |
| 9948865 | 2014 | 3 | 20 |
| 5225461 | 2014 | 3 | 19 |
| 3448034 | 2014 | 3 | 18 |
| 6693967 | 2014 | 3 | 16 |
| 8027181 | 2014 | 3 | 16 |
| 6244798 | 2014 | 3 | 15 |
| 1153244 | 2014 | 3 | 14 |
| 9343622 | 2014 | 3 | 11 |
| 8326752 | 2014 | 3 | 11 |
| 6196820 | 2014 | 3 | 11 |
| 8668400 | 2014 | 3 | 10 |
| 2812224 | 2014 | 3 | 9 |
| 3960731 | 2014 | 3 | 8 |
| 6001858 | 2014 | 3 | 8 |
| 6202509 | 2014 | 3 | 7 |
| 9242692 | 2014 | 3 | 7 |
| 8003271 | 2014 | 3 | 4 |
| 7773142 | 2014 | 3 | 3 |
| 4969728 | 2014 | 3 | 3 |
| 5260056 | 2014 | 3 | 2 |
| 4137229 | 2014 | 3 | 2 |
| 7267069 | 2014 | 3 | 2 |
| 3445889 | 2014 | 3 | 1 |
| 5763405 | 2014 | 3 | 1 |
| 5531391 | 2014 | 3 | 1 |
| 4276358 | 2014 | 2 | 28 |
| 9814916 | 2014 | 2 | 27 |
| 6899733 | 2014 | 2 | 26 |
| 4662354 | 2014 | 2 | 26 |
| 6980240 | 2014 | 2 | 24 |
| 5445515 | 2014 | 2 | 23 |
| 6826928 | 2014 | 2 | 23 |
| 7837223 | 2014 | 2 | 22 |
| 1473151 | 2014 | 2 | 21 |
| 2584450 | 2014 | 2 | 20 |
| 6328764 | 2014 | 2 | 20 |
| 4334143 | 2014 | 2 | 19 |
| 9773746 | 2014 | 2 | 19 |
| 5731895 | 2014 | 2 | 19 |
| 9577756 | 2014 | 2 | 18 |
| 9273324 | 2014 | 2 | 18 |
| 3751370 | 2014 | 2 | 18 |
| 6260927 | 2014 | 2 | 17 |
| 9828394 | 2014 | 2 | 17 |
| 6391713 | 2014 | 2 | 16 |
| 6374461 | 2014 | 2 | 15 |
| 4039957 | 2014 | 2 | 13 |
| 9664763 | 2014 | 2 | 13 |
| 7578944 | 2014 | 2 | 13 |
| 2682988 | 2014 | 2 | 9 |
| 3501813 | 2014 | 2 | 8 |
| 5678361 | 2014 | 2 | 7 |
100 filas (de 20000) seleccionadas
P05.011- SIP y fecha de nacimiento de los pacientes que nacieron en 2013, ordenado por fecha de nacimiento descendente.
| sip | fecha_nacimiento |
|---|---|
| 8784310 | 2013-12-31 |
| 2341557 | 2013-12-30 |
| 9561811 | 2013-12-30 |
| 2495296 | 2013-12-30 |
| 9413254 | 2013-12-30 |
| 8599202 | 2013-12-28 |
| 5040193 | 2013-12-26 |
| 9909626 | 2013-12-25 |
| 2903376 | 2013-12-25 |
| 6703734 | 2013-12-23 |
| 4351282 | 2013-12-23 |
| 1427735 | 2013-12-23 |
| 9309201 | 2013-12-22 |
| 4727047 | 2013-12-21 |
| 7548902 | 2013-12-21 |
| 1846374 | 2013-12-18 |
| 3148482 | 2013-12-18 |
| 2411301 | 2013-12-18 |
| 7659721 | 2013-12-18 |
| 3744584 | 2013-12-16 |
| 3411160 | 2013-12-16 |
| 9058909 | 2013-12-14 |
| 7116299 | 2013-12-14 |
| 8336947 | 2013-12-14 |
| 2958891 | 2013-12-12 |
| 5023414 | 2013-12-11 |
| 3611971 | 2013-12-09 |
| 9161342 | 2013-12-09 |
| 4418986 | 2013-12-08 |
| 1955472 | 2013-12-02 |
| 3241590 | 2013-12-02 |
| 9829697 | 2013-12-02 |
| 8880380 | 2013-12-02 |
| 7556883 | 2013-12-01 |
| 5524347 | 2013-11-30 |
| 6285488 | 2013-11-28 |
| 6074145 | 2013-11-28 |
| 5876069 | 2013-11-26 |
| 4841839 | 2013-11-26 |
| 9842332 | 2013-11-25 |
| 1397026 | 2013-11-25 |
| 8685039 | 2013-11-25 |
| 2687227 | 2013-11-24 |
| 1381731 | 2013-11-23 |
| 6534283 | 2013-11-23 |
| 4560436 | 2013-11-22 |
| 6577799 | 2013-11-21 |
| 1715929 | 2013-11-20 |
| 7426097 | 2013-11-20 |
| 1188936 | 2013-11-19 |
| 2512938 | 2013-11-19 |
| 2831974 | 2013-11-17 |
| 5774574 | 2013-11-17 |
| 5134131 | 2013-11-16 |
| 7108606 | 2013-11-16 |
| 2029227 | 2013-11-15 |
| 7727985 | 2013-11-14 |
| 9432167 | 2013-11-13 |
| 2676279 | 2013-11-10 |
| 8365211 | 2013-11-10 |
| 9183215 | 2013-11-09 |
| 5915563 | 2013-11-08 |
| 9004988 | 2013-11-07 |
| 2639493 | 2013-11-06 |
| 5017267 | 2013-11-06 |
| 2785625 | 2013-11-05 |
| 5194094 | 2013-11-04 |
| 6217369 | 2013-11-04 |
| 5069012 | 2013-11-03 |
| 4252624 | 2013-11-02 |
| 2558509 | 2013-10-31 |
| 9073122 | 2013-10-27 |
| 4724905 | 2013-10-24 |
| 2613723 | 2013-10-22 |
| 9782904 | 2013-10-22 |
| 7275905 | 2013-10-20 |
| 2356856 | 2013-10-19 |
| 3057848 | 2013-10-19 |
| 5504058 | 2013-10-17 |
| 5735659 | 2013-10-15 |
| 4835594 | 2013-10-14 |
| 2410250 | 2013-10-14 |
| 9505759 | 2013-10-13 |
| 4445880 | 2013-10-13 |
| 3470217 | 2013-10-12 |
| 2533820 | 2013-10-12 |
| 2079502 | 2013-10-12 |
| 6252492 | 2013-10-11 |
| 9023891 | 2013-10-10 |
| 1297121 | 2013-10-08 |
| 8419860 | 2013-10-07 |
| 2443378 | 2013-10-07 |
| 4392089 | 2013-10-07 |
| 1829487 | 2013-10-06 |
| 1411381 | 2013-10-05 |
| 4300798 | 2013-10-05 |
| 8254123 | 2013-10-05 |
| 7076486 | 2013-10-04 |
| 9356845 | 2013-10-03 |
| 9061738 | 2013-10-02 |
100 filas (de 389) seleccionadas
P05.012- SIP y fecha de nacimiento, con formato "dd/mm/aaaa", de los pacientes que nacieron en 2013, ordenado por fecha de nacimiento descendente.
| sip | nacido |
|---|---|
| 8784310 | 31/12/2013 |
| 2341557 | 30/12/2013 |
| 9561811 | 30/12/2013 |
| 2495296 | 30/12/2013 |
| 9413254 | 30/12/2013 |
| 8599202 | 28/12/2013 |
| 5040193 | 26/12/2013 |
| 9909626 | 25/12/2013 |
| 2903376 | 25/12/2013 |
| 6703734 | 23/12/2013 |
| 4351282 | 23/12/2013 |
| 1427735 | 23/12/2013 |
| 9309201 | 22/12/2013 |
| 4727047 | 21/12/2013 |
| 7548902 | 21/12/2013 |
| 1846374 | 18/12/2013 |
| 3148482 | 18/12/2013 |
| 2411301 | 18/12/2013 |
| 7659721 | 18/12/2013 |
| 3744584 | 16/12/2013 |
| 3411160 | 16/12/2013 |
| 9058909 | 14/12/2013 |
| 7116299 | 14/12/2013 |
| 8336947 | 14/12/2013 |
| 2958891 | 12/12/2013 |
| 5023414 | 11/12/2013 |
| 3611971 | 09/12/2013 |
| 9161342 | 09/12/2013 |
| 4418986 | 08/12/2013 |
| 1955472 | 02/12/2013 |
| 3241590 | 02/12/2013 |
| 9829697 | 02/12/2013 |
| 8880380 | 02/12/2013 |
| 7556883 | 01/12/2013 |
| 5524347 | 30/11/2013 |
| 6285488 | 28/11/2013 |
| 6074145 | 28/11/2013 |
| 5876069 | 26/11/2013 |
| 4841839 | 26/11/2013 |
| 9842332 | 25/11/2013 |
| 1397026 | 25/11/2013 |
| 8685039 | 25/11/2013 |
| 2687227 | 24/11/2013 |
| 1381731 | 23/11/2013 |
| 6534283 | 23/11/2013 |
| 4560436 | 22/11/2013 |
| 6577799 | 21/11/2013 |
| 1715929 | 20/11/2013 |
| 7426097 | 20/11/2013 |
| 1188936 | 19/11/2013 |
| 2512938 | 19/11/2013 |
| 2831974 | 17/11/2013 |
| 5774574 | 17/11/2013 |
| 5134131 | 16/11/2013 |
| 7108606 | 16/11/2013 |
| 2029227 | 15/11/2013 |
| 7727985 | 14/11/2013 |
| 9432167 | 13/11/2013 |
| 2676279 | 10/11/2013 |
| 8365211 | 10/11/2013 |
| 9183215 | 09/11/2013 |
| 5915563 | 08/11/2013 |
| 9004988 | 07/11/2013 |
| 2639493 | 06/11/2013 |
| 5017267 | 06/11/2013 |
| 2785625 | 05/11/2013 |
| 5194094 | 04/11/2013 |
| 6217369 | 04/11/2013 |
| 5069012 | 03/11/2013 |
| 4252624 | 02/11/2013 |
| 2558509 | 31/10/2013 |
| 9073122 | 27/10/2013 |
| 4724905 | 24/10/2013 |
| 2613723 | 22/10/2013 |
| 9782904 | 22/10/2013 |
| 7275905 | 20/10/2013 |
| 2356856 | 19/10/2013 |
| 3057848 | 19/10/2013 |
| 5504058 | 17/10/2013 |
| 5735659 | 15/10/2013 |
| 4835594 | 14/10/2013 |
| 2410250 | 14/10/2013 |
| 9505759 | 13/10/2013 |
| 4445880 | 13/10/2013 |
| 3470217 | 12/10/2013 |
| 2533820 | 12/10/2013 |
| 2079502 | 12/10/2013 |
| 6252492 | 11/10/2013 |
| 9023891 | 10/10/2013 |
| 1297121 | 08/10/2013 |
| 8419860 | 07/10/2013 |
| 2443378 | 07/10/2013 |
| 4392089 | 07/10/2013 |
| 1829487 | 06/10/2013 |
| 1411381 | 05/10/2013 |
| 4300798 | 05/10/2013 |
| 8254123 | 05/10/2013 |
| 7076486 | 04/10/2013 |
| 9356845 | 03/10/2013 |
| 9061738 | 02/10/2013 |
100 filas (de 389) seleccionadas
P05.013- SIP y fecha de nacimiento, con formato "dd de mm de aaaa", de los pacientes que nacieron en 2013, ordenado por fecha de nacimiento descendente.
| sip | nacido |
|---|---|
| 8784310 | 31 de 12 de 2013 |
| 2341557 | 30 de 12 de 2013 |
| 9561811 | 30 de 12 de 2013 |
| 2495296 | 30 de 12 de 2013 |
| 9413254 | 30 de 12 de 2013 |
| 8599202 | 28 de 12 de 2013 |
| 5040193 | 26 de 12 de 2013 |
| 9909626 | 25 de 12 de 2013 |
| 2903376 | 25 de 12 de 2013 |
| 6703734 | 23 de 12 de 2013 |
| 4351282 | 23 de 12 de 2013 |
| 1427735 | 23 de 12 de 2013 |
| 9309201 | 22 de 12 de 2013 |
| 4727047 | 21 de 12 de 2013 |
| 7548902 | 21 de 12 de 2013 |
| 1846374 | 18 de 12 de 2013 |
| 3148482 | 18 de 12 de 2013 |
| 2411301 | 18 de 12 de 2013 |
| 7659721 | 18 de 12 de 2013 |
| 3744584 | 16 de 12 de 2013 |
| 3411160 | 16 de 12 de 2013 |
| 9058909 | 14 de 12 de 2013 |
| 7116299 | 14 de 12 de 2013 |
| 8336947 | 14 de 12 de 2013 |
| 2958891 | 12 de 12 de 2013 |
| 5023414 | 11 de 12 de 2013 |
| 3611971 | 09 de 12 de 2013 |
| 9161342 | 09 de 12 de 2013 |
| 4418986 | 08 de 12 de 2013 |
| 1955472 | 02 de 12 de 2013 |
| 3241590 | 02 de 12 de 2013 |
| 9829697 | 02 de 12 de 2013 |
| 8880380 | 02 de 12 de 2013 |
| 7556883 | 01 de 12 de 2013 |
| 5524347 | 30 de 11 de 2013 |
| 6285488 | 28 de 11 de 2013 |
| 6074145 | 28 de 11 de 2013 |
| 5876069 | 26 de 11 de 2013 |
| 4841839 | 26 de 11 de 2013 |
| 9842332 | 25 de 11 de 2013 |
| 1397026 | 25 de 11 de 2013 |
| 8685039 | 25 de 11 de 2013 |
| 2687227 | 24 de 11 de 2013 |
| 1381731 | 23 de 11 de 2013 |
| 6534283 | 23 de 11 de 2013 |
| 4560436 | 22 de 11 de 2013 |
| 6577799 | 21 de 11 de 2013 |
| 1715929 | 20 de 11 de 2013 |
| 7426097 | 20 de 11 de 2013 |
| 1188936 | 19 de 11 de 2013 |
| 2512938 | 19 de 11 de 2013 |
| 2831974 | 17 de 11 de 2013 |
| 5774574 | 17 de 11 de 2013 |
| 5134131 | 16 de 11 de 2013 |
| 7108606 | 16 de 11 de 2013 |
| 2029227 | 15 de 11 de 2013 |
| 7727985 | 14 de 11 de 2013 |
| 9432167 | 13 de 11 de 2013 |
| 2676279 | 10 de 11 de 2013 |
| 8365211 | 10 de 11 de 2013 |
| 9183215 | 09 de 11 de 2013 |
| 5915563 | 08 de 11 de 2013 |
| 9004988 | 07 de 11 de 2013 |
| 2639493 | 06 de 11 de 2013 |
| 5017267 | 06 de 11 de 2013 |
| 2785625 | 05 de 11 de 2013 |
| 5194094 | 04 de 11 de 2013 |
| 6217369 | 04 de 11 de 2013 |
| 5069012 | 03 de 11 de 2013 |
| 4252624 | 02 de 11 de 2013 |
| 2558509 | 31 de 10 de 2013 |
| 9073122 | 27 de 10 de 2013 |
| 4724905 | 24 de 10 de 2013 |
| 2613723 | 22 de 10 de 2013 |
| 9782904 | 22 de 10 de 2013 |
| 7275905 | 20 de 10 de 2013 |
| 2356856 | 19 de 10 de 2013 |
| 3057848 | 19 de 10 de 2013 |
| 5504058 | 17 de 10 de 2013 |
| 5735659 | 15 de 10 de 2013 |
| 4835594 | 14 de 10 de 2013 |
| 2410250 | 14 de 10 de 2013 |
| 9505759 | 13 de 10 de 2013 |
| 4445880 | 13 de 10 de 2013 |
| 3470217 | 12 de 10 de 2013 |
| 2533820 | 12 de 10 de 2013 |
| 2079502 | 12 de 10 de 2013 |
| 6252492 | 11 de 10 de 2013 |
| 9023891 | 10 de 10 de 2013 |
| 1297121 | 08 de 10 de 2013 |
| 8419860 | 07 de 10 de 2013 |
| 2443378 | 07 de 10 de 2013 |
| 4392089 | 07 de 10 de 2013 |
| 1829487 | 06 de 10 de 2013 |
| 1411381 | 05 de 10 de 2013 |
| 4300798 | 05 de 10 de 2013 |
| 8254123 | 05 de 10 de 2013 |
| 7076486 | 04 de 10 de 2013 |
| 9356845 | 03 de 10 de 2013 |
| 9061738 | 02 de 10 de 2013 |
100 filas (de 389) seleccionadas
P05.014- SIP y fecha de nacimiento, con formato "dd de mes de aaaa", con el mes como nombre (en inglés), de los pacientes que nacieron en 2013, ordenado por fecha de nacimiento descendente.
| sip | nacido |
|---|---|
| 8784310 | 31 de December de 2013 |
| 2341557 | 30 de December de 2013 |
| 9561811 | 30 de December de 2013 |
| 2495296 | 30 de December de 2013 |
| 9413254 | 30 de December de 2013 |
| 8599202 | 28 de December de 2013 |
| 5040193 | 26 de December de 2013 |
| 9909626 | 25 de December de 2013 |
| 2903376 | 25 de December de 2013 |
| 6703734 | 23 de December de 2013 |
| 4351282 | 23 de December de 2013 |
| 1427735 | 23 de December de 2013 |
| 9309201 | 22 de December de 2013 |
| 4727047 | 21 de December de 2013 |
| 7548902 | 21 de December de 2013 |
| 1846374 | 18 de December de 2013 |
| 3148482 | 18 de December de 2013 |
| 2411301 | 18 de December de 2013 |
| 7659721 | 18 de December de 2013 |
| 3744584 | 16 de December de 2013 |
| 3411160 | 16 de December de 2013 |
| 9058909 | 14 de December de 2013 |
| 7116299 | 14 de December de 2013 |
| 8336947 | 14 de December de 2013 |
| 2958891 | 12 de December de 2013 |
| 5023414 | 11 de December de 2013 |
| 3611971 | 09 de December de 2013 |
| 9161342 | 09 de December de 2013 |
| 4418986 | 08 de December de 2013 |
| 1955472 | 02 de December de 2013 |
| 3241590 | 02 de December de 2013 |
| 9829697 | 02 de December de 2013 |
| 8880380 | 02 de December de 2013 |
| 7556883 | 01 de December de 2013 |
| 5524347 | 30 de November de 2013 |
| 6285488 | 28 de November de 2013 |
| 6074145 | 28 de November de 2013 |
| 5876069 | 26 de November de 2013 |
| 4841839 | 26 de November de 2013 |
| 9842332 | 25 de November de 2013 |
| 1397026 | 25 de November de 2013 |
| 8685039 | 25 de November de 2013 |
| 2687227 | 24 de November de 2013 |
| 1381731 | 23 de November de 2013 |
| 6534283 | 23 de November de 2013 |
| 4560436 | 22 de November de 2013 |
| 6577799 | 21 de November de 2013 |
| 1715929 | 20 de November de 2013 |
| 7426097 | 20 de November de 2013 |
| 1188936 | 19 de November de 2013 |
| 2512938 | 19 de November de 2013 |
| 2831974 | 17 de November de 2013 |
| 5774574 | 17 de November de 2013 |
| 5134131 | 16 de November de 2013 |
| 7108606 | 16 de November de 2013 |
| 2029227 | 15 de November de 2013 |
| 7727985 | 14 de November de 2013 |
| 9432167 | 13 de November de 2013 |
| 2676279 | 10 de November de 2013 |
| 8365211 | 10 de November de 2013 |
| 9183215 | 09 de November de 2013 |
| 5915563 | 08 de November de 2013 |
| 9004988 | 07 de November de 2013 |
| 2639493 | 06 de November de 2013 |
| 5017267 | 06 de November de 2013 |
| 2785625 | 05 de November de 2013 |
| 5194094 | 04 de November de 2013 |
| 6217369 | 04 de November de 2013 |
| 5069012 | 03 de November de 2013 |
| 4252624 | 02 de November de 2013 |
| 2558509 | 31 de October de 2013 |
| 9073122 | 27 de October de 2013 |
| 4724905 | 24 de October de 2013 |
| 2613723 | 22 de October de 2013 |
| 9782904 | 22 de October de 2013 |
| 7275905 | 20 de October de 2013 |
| 2356856 | 19 de October de 2013 |
| 3057848 | 19 de October de 2013 |
| 5504058 | 17 de October de 2013 |
| 5735659 | 15 de October de 2013 |
| 4835594 | 14 de October de 2013 |
| 2410250 | 14 de October de 2013 |
| 9505759 | 13 de October de 2013 |
| 4445880 | 13 de October de 2013 |
| 3470217 | 12 de October de 2013 |
| 2533820 | 12 de October de 2013 |
| 2079502 | 12 de October de 2013 |
| 6252492 | 11 de October de 2013 |
| 9023891 | 10 de October de 2013 |
| 1297121 | 08 de October de 2013 |
| 8419860 | 07 de October de 2013 |
| 2443378 | 07 de October de 2013 |
| 4392089 | 07 de October de 2013 |
| 1829487 | 06 de October de 2013 |
| 1411381 | 05 de October de 2013 |
| 4300798 | 05 de October de 2013 |
| 8254123 | 05 de October de 2013 |
| 7076486 | 04 de October de 2013 |
| 9356845 | 03 de October de 2013 |
| 9061738 | 02 de October de 2013 |
100 filas (de 389) seleccionadas
P05.015- SIP, fecha de nacimiento y días que han pasado desde su nacimiento hasta el 1 de septiembre de 2016 de los pacientes que nacieron en 2013, ordenado por fecha de nacimiento descendente.
| sip | fecha_nacimiento | días |
|---|---|---|
| 8784310 | 2013-12-31 | 975 |
| 2341557 | 2013-12-30 | 976 |
| 9561811 | 2013-12-30 | 976 |
| 2495296 | 2013-12-30 | 976 |
| 9413254 | 2013-12-30 | 976 |
| 8599202 | 2013-12-28 | 978 |
| 5040193 | 2013-12-26 | 980 |
| 9909626 | 2013-12-25 | 981 |
| 2903376 | 2013-12-25 | 981 |
| 6703734 | 2013-12-23 | 983 |
| 4351282 | 2013-12-23 | 983 |
| 1427735 | 2013-12-23 | 983 |
| 9309201 | 2013-12-22 | 984 |
| 4727047 | 2013-12-21 | 985 |
| 7548902 | 2013-12-21 | 985 |
| 1846374 | 2013-12-18 | 988 |
| 3148482 | 2013-12-18 | 988 |
| 2411301 | 2013-12-18 | 988 |
| 7659721 | 2013-12-18 | 988 |
| 3744584 | 2013-12-16 | 990 |
| 3411160 | 2013-12-16 | 990 |
| 9058909 | 2013-12-14 | 992 |
| 7116299 | 2013-12-14 | 992 |
| 8336947 | 2013-12-14 | 992 |
| 2958891 | 2013-12-12 | 994 |
| 5023414 | 2013-12-11 | 995 |
| 3611971 | 2013-12-09 | 997 |
| 9161342 | 2013-12-09 | 997 |
| 4418986 | 2013-12-08 | 998 |
| 1955472 | 2013-12-02 | 1004 |
| 3241590 | 2013-12-02 | 1004 |
| 9829697 | 2013-12-02 | 1004 |
| 8880380 | 2013-12-02 | 1004 |
| 7556883 | 2013-12-01 | 1005 |
| 5524347 | 2013-11-30 | 1006 |
| 6285488 | 2013-11-28 | 1008 |
| 6074145 | 2013-11-28 | 1008 |
| 5876069 | 2013-11-26 | 1010 |
| 4841839 | 2013-11-26 | 1010 |
| 9842332 | 2013-11-25 | 1011 |
| 1397026 | 2013-11-25 | 1011 |
| 8685039 | 2013-11-25 | 1011 |
| 2687227 | 2013-11-24 | 1012 |
| 1381731 | 2013-11-23 | 1013 |
| 6534283 | 2013-11-23 | 1013 |
| 4560436 | 2013-11-22 | 1014 |
| 6577799 | 2013-11-21 | 1015 |
| 1715929 | 2013-11-20 | 1016 |
| 7426097 | 2013-11-20 | 1016 |
| 1188936 | 2013-11-19 | 1017 |
| 2512938 | 2013-11-19 | 1017 |
| 2831974 | 2013-11-17 | 1019 |
| 5774574 | 2013-11-17 | 1019 |
| 5134131 | 2013-11-16 | 1020 |
| 7108606 | 2013-11-16 | 1020 |
| 2029227 | 2013-11-15 | 1021 |
| 7727985 | 2013-11-14 | 1022 |
| 9432167 | 2013-11-13 | 1023 |
| 2676279 | 2013-11-10 | 1026 |
| 8365211 | 2013-11-10 | 1026 |
| 9183215 | 2013-11-09 | 1027 |
| 5915563 | 2013-11-08 | 1028 |
| 9004988 | 2013-11-07 | 1029 |
| 2639493 | 2013-11-06 | 1030 |
| 5017267 | 2013-11-06 | 1030 |
| 2785625 | 2013-11-05 | 1031 |
| 5194094 | 2013-11-04 | 1032 |
| 6217369 | 2013-11-04 | 1032 |
| 5069012 | 2013-11-03 | 1033 |
| 4252624 | 2013-11-02 | 1034 |
| 2558509 | 2013-10-31 | 1036 |
| 9073122 | 2013-10-27 | 1040 |
| 4724905 | 2013-10-24 | 1043 |
| 2613723 | 2013-10-22 | 1045 |
| 9782904 | 2013-10-22 | 1045 |
| 7275905 | 2013-10-20 | 1047 |
| 2356856 | 2013-10-19 | 1048 |
| 3057848 | 2013-10-19 | 1048 |
| 5504058 | 2013-10-17 | 1050 |
| 5735659 | 2013-10-15 | 1052 |
| 4835594 | 2013-10-14 | 1053 |
| 2410250 | 2013-10-14 | 1053 |
| 9505759 | 2013-10-13 | 1054 |
| 4445880 | 2013-10-13 | 1054 |
| 3470217 | 2013-10-12 | 1055 |
| 2533820 | 2013-10-12 | 1055 |
| 2079502 | 2013-10-12 | 1055 |
| 6252492 | 2013-10-11 | 1056 |
| 9023891 | 2013-10-10 | 1057 |
| 1297121 | 2013-10-08 | 1059 |
| 8419860 | 2013-10-07 | 1060 |
| 2443378 | 2013-10-07 | 1060 |
| 4392089 | 2013-10-07 | 1060 |
| 1829487 | 2013-10-06 | 1061 |
| 1411381 | 2013-10-05 | 1062 |
| 4300798 | 2013-10-05 | 1062 |
| 8254123 | 2013-10-05 | 1062 |
| 7076486 | 2013-10-04 | 1063 |
| 9356845 | 2013-10-03 | 1064 |
| 9061738 | 2013-10-02 | 1065 |
100 filas (de 389) seleccionadas
P05.016- SIP, fecha de nacimiento y días que han pasado desde su nacimiento hasta el 1 de septiembre de 2016 de los pacientes que nacieron en 2013, ordenado por esa cantidad de días descendente.
| sip | fecha_nacimiento | días |
|---|---|---|
| 3165524 | 2013-01-01 | 1339 |
| 5514822 | 2013-01-01 | 1339 |
| 1064238 | 2013-01-02 | 1338 |
| 3512507 | 2013-01-03 | 1337 |
| 4229145 | 2013-01-05 | 1335 |
| 3930261 | 2013-01-06 | 1334 |
| 3988221 | 2013-01-07 | 1333 |
| 4190238 | 2013-01-08 | 1332 |
| 7308642 | 2013-01-08 | 1332 |
| 3260670 | 2013-01-11 | 1329 |
| 9174690 | 2013-01-12 | 1328 |
| 9419468 | 2013-01-12 | 1328 |
| 8957298 | 2013-01-12 | 1328 |
| 8291807 | 2013-01-13 | 1327 |
| 1568876 | 2013-01-14 | 1326 |
| 2777637 | 2013-01-16 | 1324 |
| 4048099 | 2013-01-19 | 1321 |
| 8228724 | 2013-01-20 | 1320 |
| 9109100 | 2013-01-21 | 1319 |
| 6258018 | 2013-01-24 | 1316 |
| 7722925 | 2013-01-24 | 1316 |
| 9211882 | 2013-01-24 | 1316 |
| 9204314 | 2013-01-25 | 1315 |
| 7391898 | 2013-01-25 | 1315 |
| 9931601 | 2013-01-25 | 1315 |
| 8665684 | 2013-01-26 | 1314 |
| 8235541 | 2013-01-27 | 1313 |
| 8567158 | 2013-01-28 | 1312 |
| 1534684 | 2013-01-28 | 1312 |
| 8466939 | 2013-01-31 | 1309 |
| 1430134 | 2013-02-01 | 1308 |
| 9499686 | 2013-02-02 | 1307 |
| 1481082 | 2013-02-02 | 1307 |
| 4551480 | 2013-02-02 | 1307 |
| 6225566 | 2013-02-03 | 1306 |
| 9528528 | 2013-02-04 | 1305 |
| 5208869 | 2013-02-04 | 1305 |
| 5828666 | 2013-02-06 | 1303 |
| 2145037 | 2013-02-08 | 1301 |
| 2290822 | 2013-02-08 | 1301 |
| 3770130 | 2013-02-08 | 1301 |
| 2880941 | 2013-02-09 | 1300 |
| 2710674 | 2013-02-10 | 1299 |
| 3486665 | 2013-02-11 | 1298 |
| 5664904 | 2013-02-12 | 1297 |
| 6076997 | 2013-02-12 | 1297 |
| 9903118 | 2013-02-13 | 1296 |
| 5437798 | 2013-02-17 | 1292 |
| 6273081 | 2013-02-17 | 1292 |
| 6052163 | 2013-02-17 | 1292 |
| 4426270 | 2013-02-17 | 1292 |
| 6999099 | 2013-02-19 | 1290 |
| 7448497 | 2013-02-21 | 1288 |
| 3330657 | 2013-02-21 | 1288 |
| 1608567 | 2013-02-27 | 1282 |
| 6210252 | 2013-02-27 | 1282 |
| 6177686 | 2013-03-01 | 1280 |
| 7188959 | 2013-03-04 | 1277 |
| 7776316 | 2013-03-08 | 1273 |
| 4724535 | 2013-03-08 | 1273 |
| 6199514 | 2013-03-08 | 1273 |
| 7344456 | 2013-03-08 | 1273 |
| 8103950 | 2013-03-09 | 1272 |
| 6072249 | 2013-03-10 | 1271 |
| 8525916 | 2013-03-11 | 1270 |
| 8169202 | 2013-03-11 | 1270 |
| 9523481 | 2013-03-14 | 1267 |
| 8653646 | 2013-03-15 | 1266 |
| 6765055 | 2013-03-15 | 1266 |
| 1649809 | 2013-03-16 | 1265 |
| 4478477 | 2013-03-18 | 1263 |
| 1678347 | 2013-03-19 | 1262 |
| 7070571 | 2013-03-20 | 1261 |
| 2246459 | 2013-03-22 | 1259 |
| 4146778 | 2013-03-23 | 1258 |
| 3687799 | 2013-03-23 | 1258 |
| 1041415 | 2013-03-23 | 1258 |
| 8404601 | 2013-03-25 | 1256 |
| 4957663 | 2013-03-26 | 1255 |
| 5163628 | 2013-03-27 | 1254 |
| 4983829 | 2013-03-28 | 1253 |
| 5572544 | 2013-03-28 | 1253 |
| 6252285 | 2013-03-28 | 1253 |
| 9861663 | 2013-03-29 | 1252 |
| 9190801 | 2013-03-30 | 1251 |
| 4987364 | 2013-03-31 | 1250 |
| 8737246 | 2013-04-01 | 1249 |
| 9361552 | 2013-04-02 | 1248 |
| 1231498 | 2013-04-02 | 1248 |
| 3875310 | 2013-04-02 | 1248 |
| 9570846 | 2013-04-04 | 1246 |
| 3295167 | 2013-04-05 | 1245 |
| 5484687 | 2013-04-06 | 1244 |
| 2100584 | 2013-04-07 | 1243 |
| 8730607 | 2013-04-07 | 1243 |
| 6613544 | 2013-04-09 | 1241 |
| 2016529 | 2013-04-09 | 1241 |
| 1550674 | 2013-04-10 | 1240 |
| 5248507 | 2013-04-10 | 1240 |
| 6017832 | 2013-04-11 | 1239 |
100 filas (de 389) seleccionadas
P05.017- SIP y fecha de nacimiento de los pacientes cuando han pasado entre 900 y 1000 días desde esa fecha hasta el 1 de septiembre de 2016.
| sip | fecha_nacimiento |
|---|---|
| 1153244 | 2014-03-14 |
| 1427735 | 2013-12-23 |
| 1473151 | 2014-02-21 |
| 1846374 | 2013-12-18 |
| 2316465 | 2014-01-31 |
| 2341557 | 2013-12-30 |
| 2411301 | 2013-12-18 |
| 2495296 | 2013-12-30 |
| 2584450 | 2014-02-20 |
| 2620327 | 2014-01-29 |
| 2682988 | 2014-02-09 |
| 2806911 | 2014-01-14 |
| 2812224 | 2014-03-09 |
| 2862671 | 2014-01-13 |
| 2863870 | 2014-01-27 |
| 2903376 | 2013-12-25 |
| 2958891 | 2013-12-12 |
| 2983557 | 2014-01-08 |
| 2984250 | 2014-01-03 |
| 3051361 | 2014-01-05 |
| 3056609 | 2014-01-17 |
| 3148482 | 2013-12-18 |
| 3374582 | 2014-01-03 |
| 3411160 | 2013-12-16 |
| 3445889 | 2014-03-01 |
| 3501813 | 2014-02-08 |
| 3611971 | 2013-12-09 |
| 3744584 | 2013-12-16 |
| 3751370 | 2014-02-18 |
| 3960731 | 2014-03-08 |
| 3962776 | 2014-01-06 |
| 4039957 | 2014-02-13 |
| 4055815 | 2014-01-01 |
| 4137229 | 2014-03-02 |
| 4276358 | 2014-02-28 |
| 4324714 | 2014-01-31 |
| 4334143 | 2014-02-19 |
| 4351282 | 2013-12-23 |
| 4418986 | 2013-12-08 |
| 4451363 | 2014-01-29 |
| 4662354 | 2014-02-26 |
| 4727047 | 2013-12-21 |
| 4969728 | 2014-03-03 |
| 4994865 | 2014-02-03 |
| 5016410 | 2014-01-23 |
| 5023414 | 2013-12-11 |
| 5040193 | 2013-12-26 |
| 5162079 | 2014-01-19 |
| 5176557 | 2014-01-19 |
| 5260056 | 2014-03-02 |
| 5321079 | 2014-01-07 |
| 5445515 | 2014-02-23 |
| 5531391 | 2014-03-01 |
| 5678361 | 2014-02-07 |
| 5731895 | 2014-02-19 |
| 5763405 | 2014-03-01 |
| 6001858 | 2014-03-08 |
| 6196820 | 2014-03-11 |
| 6202509 | 2014-03-07 |
| 6244798 | 2014-03-15 |
| 6260927 | 2014-02-17 |
| 6328764 | 2014-02-20 |
| 6374461 | 2014-02-15 |
| 6391713 | 2014-02-16 |
| 6693967 | 2014-03-16 |
| 6703734 | 2013-12-23 |
| 6722453 | 2014-01-16 |
| 6826928 | 2014-02-23 |
| 6890086 | 2014-01-28 |
| 6899733 | 2014-02-26 |
| 6971695 | 2014-01-03 |
| 6980240 | 2014-02-24 |
| 7116299 | 2013-12-14 |
| 7267069 | 2014-03-02 |
| 7427838 | 2014-02-06 |
| 7446136 | 2014-01-10 |
| 7548902 | 2013-12-21 |
| 7578944 | 2014-02-13 |
| 7625071 | 2014-01-11 |
| 7643250 | 2014-01-25 |
| 7659721 | 2013-12-18 |
| 7681206 | 2014-01-29 |
| 7705769 | 2014-02-04 |
| 7773142 | 2014-03-03 |
| 7837223 | 2014-02-22 |
| 7877924 | 2014-01-05 |
| 8003271 | 2014-03-04 |
| 8027181 | 2014-03-16 |
| 8326752 | 2014-03-11 |
| 8336947 | 2013-12-14 |
| 8596661 | 2014-01-12 |
| 8599202 | 2013-12-28 |
| 8668400 | 2014-03-10 |
| 8784310 | 2013-12-31 |
| 8840639 | 2014-02-01 |
| 8881333 | 2014-01-25 |
| 9058909 | 2013-12-14 |
| 9161342 | 2013-12-09 |
| 9196842 | 2014-01-07 |
| 9242692 | 2014-03-07 |
100 filas (de 116) seleccionadas
P05.018- SIP y semana del año de la fecha de nacimiento de los pacientes cuando han pasado entre 900 y 1000 días desde esa fecha hasta el 1 de septiembre de 2016, ordenado por semana.
| sip | semana |
|---|---|
| 2984250 | 1 |
| 8784310 | 1 |
| 9561811 | 1 |
| 7877924 | 1 |
| 2495296 | 1 |
| 9413254 | 1 |
| 2341557 | 1 |
| 6971695 | 1 |
| 4055815 | 1 |
| 3051361 | 1 |
| 3374582 | 1 |
| 8596661 | 2 |
| 9413976 | 2 |
| 3962776 | 2 |
| 9196842 | 2 |
| 2983557 | 2 |
| 7625071 | 2 |
| 5321079 | 2 |
| 7446136 | 2 |
| 5162079 | 3 |
| 6722453 | 3 |
| 3056609 | 3 |
| 2862671 | 3 |
| 2806911 | 3 |
| 5176557 | 3 |
| 5016410 | 4 |
| 8881333 | 4 |
| 7643250 | 4 |
| 2620327 | 5 |
| 4451363 | 5 |
| 7681206 | 5 |
| 6890086 | 5 |
| 8840639 | 5 |
| 9276226 | 5 |
| 4324714 | 5 |
| 9652673 | 5 |
| 9681388 | 5 |
| 2316465 | 5 |
| 2863870 | 5 |
| 9871449 | 5 |
| 5678361 | 6 |
| 7427838 | 6 |
| 4994865 | 6 |
| 3501813 | 6 |
| 2682988 | 6 |
| 7705769 | 6 |
| 6391713 | 7 |
| 4039957 | 7 |
| 7578944 | 7 |
| 9664763 | 7 |
| 6374461 | 7 |
| 7837223 | 8 |
| 6328764 | 8 |
| 9577756 | 8 |
| 6260927 | 8 |
| 2584450 | 8 |
| 9773746 | 8 |
| 6826928 | 8 |
| 3751370 | 8 |
| 9828394 | 8 |
| 5731895 | 8 |
| 5445515 | 8 |
| 4334143 | 8 |
| 1473151 | 8 |
| 9273324 | 8 |
| 6899733 | 9 |
| 7267069 | 9 |
| 6980240 | 9 |
| 9814916 | 9 |
| 4276358 | 9 |
| 4137229 | 9 |
| 5531391 | 9 |
| 5763405 | 9 |
| 5260056 | 9 |
| 4662354 | 9 |
| 3445889 | 9 |
| 7773142 | 10 |
| 8003271 | 10 |
| 9242692 | 10 |
| 3960731 | 10 |
| 4969728 | 10 |
| 6202509 | 10 |
| 2812224 | 10 |
| 6001858 | 10 |
| 1153244 | 11 |
| 9343622 | 11 |
| 8027181 | 11 |
| 8668400 | 11 |
| 8326752 | 11 |
| 6196820 | 11 |
| 6244798 | 11 |
| 6693967 | 11 |
| 4418986 | 49 |
| 8336947 | 50 |
| 7116299 | 50 |
| 3611971 | 50 |
| 9161342 | 50 |
| 9058909 | 50 |
| 5023414 | 50 |
| 2958891 | 50 |
100 filas (de 116) seleccionadas
P05.019- SIP de los pacientes y nombre en español del día de la semana de su nacimiento, para los nacidos en marzo de 2014.
| sip | diasemana |
|---|---|
| 1153244 | Viernes |
| 1236153 | Domingo |
| 1438606 | Viernes |
| 1659713 | Sábado |
| 2130591 | Miércoles |
| 2248257 | Domingo |
| 2812224 | Domingo |
| 2883634 | Viernes |
| 3445889 | Sábado |
| 3448034 | Miércoles |
| 3573311 | Domingo |
| 3960731 | Sábado |
| 4137229 | Domingo |
| 4897710 | Domingo |
| 4969728 | Lunes |
| 5225461 | Miércoles |
| 5260056 | Domingo |
| 5530504 | Jueves |
| 5531391 | Sábado |
| 5763405 | Sábado |
| 6001858 | Sábado |
| 6196820 | Miércoles |
| 6202509 | Viernes |
| 6244798 | Sábado |
| 6693967 | Domingo |
| 6971939 | Viernes |
| 7267069 | Domingo |
| 7304980 | Miércoles |
| 7773142 | Lunes |
| 8003271 | Miércoles |
| 8027181 | Domingo |
| 8242126 | Lunes |
| 8326752 | Miércoles |
| 8440771 | Miércoles |
| 8497254 | Miércoles |
| 8668400 | Lunes |
| 9012305 | Jueves |
| 9242692 | Viernes |
| 9261497 | Lunes |
| 9343622 | Miércoles |
| 9948865 | Jueves |
41 filas (de 41) seleccionadas
P05.020- SIP, nombre, apellidos, día de nacimiento, mes de nacimiento y años que cumplen, los pacientes que celebran su cumpleaños este mes.
| nombre | apellidos | día | mes | años |
|---|---|---|---|---|
| NIL | LOPEZ GIL | 29 | October | 44 |
| CESAR | FERNANDEZ ROMERO | 23 | October | 24 |
| LUCAS | ARIAS PEREZ | 3 | October | 40 |
| ANA | PEREZ PEREZ | 10 | October | 28 |
| YASMINA | MARQUEZ MUNYOZ | 9 | October | 37 |
| IRIA | DELGADO SAEZ | 3 | October | 38 |
| IVAN | GOMEZ RODRIGUEZ | 23 | October | 33 |
| ALEJANDRO | MARTIN FERNANDEZ | 22 | October | 59 |
| JUAN CARLOS | CABRERA MENDEZ | 3 | October | 35 |
| JOSEP | RAMIREZ ALVAREZ | 14 | October | 41 |
| RAMON | HERRERO GONZALEZ | 5 | October | 46 |
| ANNA | GONZALEZ DELGADO | 11 | October | 32 |
| ISABEL | FERNANDEZ MORA | 9 | October | 40 |
| JOEL | MARTIN GOMEZ | 17 | October | 34 |
| DANIEL | RODRIGUEZ GONZALEZ | 30 | October | 53 |
| MERCEDES | RAMOS RAMIREZ | 2 | October | 34 |
| JOEL | CARRASCO BRAVO | 30 | October | 18 |
| VANESA | MONTERO CORTES | 14 | October | 57 |
| ALVARO | SANCHEZ FERNANDEZ | 23 | October | 19 |
| LUIS | FERNANDEZ GOMEZ | 10 | October | 44 |
| SERGI | CABRERA VAZQUEZ | 9 | October | 33 |
| YASMINA | CANO NUNYEZ | 2 | October | 22 |
| VIRGINIA | ORTEGA NAVARRO | 18 | October | 19 |
| IGNACIO | ROMERO ORTEGA | 18 | October | 55 |
| LUNA | SERRANO CABALLERO | 20 | October | 46 |
| ALBERT | CRESPO ROMAN | 26 | October | 44 |
| PILAR | MARTINEZ SUAREZ | 26 | October | 22 |
| NIL | CRUZ CRESPO | 23 | October | 29 |
| PAU | GONZALEZ VAZQUEZ | 13 | October | 44 |
| MARTIN | DOMINGUEZ MARIN | 27 | October | 23 |
| POL | ROMERO PASCUAL | 30 | October | 18 |
| PAU | HERNANDEZ SANTANA | 4 | October | 28 |
| VICENTE | RAMOS SANCHEZ | 3 | October | 16 |
| OSCAR | FERNANDEZ PEREZ | 22 | October | 15 |
| GONZALO | CASTRO DIAZ | 18 | October | 40 |
| JON | DOMINGUEZ SUAREZ | 22 | October | 21 |
| JUAN JOSE | MENDEZ MORENO | 22 | October | 54 |
| TERESA | MONTERO RAMOS | 4 | October | 58 |
| ALBERTO | PEREZ FERRER | 3 | October | 40 |
| NICOLAS | VEGA DOMINGUEZ | 24 | October | 50 |
| DAVID | MARTINEZ PEREZ | 22 | October | 33 |
| ANTONIO | GONZALEZ CABRERA | 9 | October | 18 |
| SERGIO | CABRERA SANTIAGO | 15 | October | 13 |
| GABRIEL | RAMOS MARTIN | 28 | October | 51 |
| HECTOR | RAMIREZ PARRA | 8 | October | 21 |
| IRATI | ROMAN BRAVO | 10 | October | 45 |
| ALEJANDRO | GARCIA GARCIA | 19 | October | 13 |
| ERIC | DOMINGUEZ DIAZ | 29 | October | 30 |
| PALOMA | ROMERO DIEZ | 13 | October | 21 |
| ADRIAN | VICENTE HIDALGO | 17 | October | 32 |
| DANIEL | HERNANDEZ MARTINEZ | 25 | October | 27 |
| ITZIAR | MOLINA MENDEZ | 29 | October | 31 |
| ALVARO | GONZALEZ SANCHEZ | 21 | October | 39 |
| JAVIER | GONZALEZ RODRIGUEZ | 8 | October | 37 |
| IVAN | CRUZ PEREZ | 8 | October | 12 |
| EMILIO | HERNANDEZ DELGADO | 12 | October | 29 |
| JOEL | VARGAS HERRERO | 28 | October | 48 |
| NURIA | CABALLERO ROJAS | 9 | October | 35 |
| ALBA | GOMEZ MARTINEZ | 2 | October | 54 |
| MARIA | GARCIA GARCIA | 12 | October | 47 |
| GUILLERMO | ALVAREZ SANCHEZ | 22 | October | 20 |
| ELSA | GONZALEZ MARIN | 7 | October | 21 |
| MARC | LOPEZ MARTINEZ | 4 | October | 60 |
| JOSE ANTONIO | MORENO NAVARRO | 11 | October | 49 |
| JUAN CARLOS | DELGADO GONZALEZ | 30 | October | 17 |
| ANA | GARCIA PEREZ | 14 | October | 45 |
| CELIA | SANZ SANZ | 6 | October | 20 |
| LARA | CRUZ DIEZ | 22 | October | 56 |
| AINHOA | MEDINA VEGA | 2 | October | 55 |
| KEVIN | ROMERO MOYA | 14 | October | 41 |
| ALEJANDRO | GOMEZ RODRIGUEZ | 27 | October | 51 |
| UNAI | ALVAREZ ALONSO | 1 | October | 34 |
| LAURA | GIMENEZ BENITEZ | 17 | October | 47 |
| DANIEL | GONZALEZ RODRIGUEZ | 2 | October | 32 |
| RAQUEL | PEREZ CORTES | 31 | October | 36 |
| JAIME | LEON DIAZ | 24 | October | 46 |
| ASIER | CAMPOS VICENTE | 26 | October | 45 |
| SALVADOR | MENDEZ RUBIO | 23 | October | 14 |
| ROSA | GUERRERO PASTOR | 11 | October | 28 |
| MIGUEL | SUAREZ GUTIERREZ | 5 | October | 60 |
| ANDER | SANTANA ALVAREZ | 21 | October | 39 |
| MARIA | GARCIA GARCIA | 13 | October | 22 |
| MARTI | MARTINEZ SANTANA | 5 | October | 12 |
| PABLO | FERNANDEZ FERNANDEZ | 21 | October | 49 |
| GERARD | CORTES SERRANO | 3 | October | 37 |
| VICENTE | ORTIZ HERRERO | 31 | October | 21 |
| ANDRES | RUIZ GONZALEZ | 18 | October | 40 |
| JON | GUERRERO CRUZ | 18 | October | 16 |
| LEYRE | CABALLERO ALONSO | 29 | October | 43 |
| MIGUEL | SERRANO PRIETO | 28 | October | 49 |
| ADRIA | VELASCO CRESPO | 19 | October | 29 |
| ANA | GOMEZ ALVAREZ | 20 | October | 26 |
| DANIEL | GONZALEZ FERNANDEZ | 10 | October | 50 |
| LAURA | REYES HERNANDEZ | 26 | October | 22 |
| DANIELA | SANTIAGO MORALES | 26 | October | 34 |
| SOFIA | CASTRO DOMINGUEZ | 27 | October | 33 |
| GABRIEL | JIMENEZ GUERRERO | 14 | October | 42 |
| ESTEFANIA | PASTOR LORENZO | 19 | October | 40 |
| MERCEDES | GARRIDO CABALLERO | 19 | October | 60 |
| INYIGO | ORTIZ PASTOR | 24 | October | 48 |
100 filas (de 1726) seleccionadas