P04.001- Muestra toda la información de AREA.
id | tipo | color | orientacion |
---|---|---|---|
0 | Psiquiatría | Blanco | Noreste |
1 | Maternidad | Rojo | Sur |
2 | Oncología | Verde | Este |
3 | Laboratorio | Azul | Noroeste |
4 | Quirófano | Amarillo | Norte |
5 | Urgencias | Naranja | Oeste |
6 | Traumatología | Gris | Sureste |
7 | Farmacia | Magenta | Suroeste |
8 filas (de 8) seleccionadas
P04.002- Muestra toda la información de HABITACION.
id | dimension | ocupado | idArea |
---|---|---|---|
1 | 15 | 1 | 0 |
1 | 15 | 0 | 1 |
1 | (null) | 0 | 2 |
1 | 14 | 0 | 4 |
1 | 14 | 0 | 5 |
1 | 14 | 0 | 6 |
2 | 15 | 0 | 0 |
2 | (null) | 0 | 1 |
2 | 15 | 0 | 2 |
2 | 14 | 0 | 4 |
2 | 15 | 0 | 5 |
2 | 16 | 0 | 6 |
3 | 15 | 1 | 0 |
3 | 15 | 0 | 1 |
3 | 16 | 1 | 2 |
3 | 15 | 0 | 4 |
3 | 16 | 0 | 5 |
3 | 15 | 0 | 6 |
4 | 15 | 0 | 0 |
4 | 14 | 0 | 1 |
4 | 14 | 0 | 2 |
4 | 15 | 0 | 4 |
4 | 16 | 0 | 5 |
4 | 16 | 0 | 6 |
5 | 16 | 0 | 0 |
5 | 15 | 0 | 1 |
5 | 15 | 0 | 2 |
5 | 14 | 0 | 4 |
5 | 14 | 0 | 5 |
5 | (null) | 0 | 6 |
6 | 14 | 0 | 0 |
6 | 16 | 0 | 1 |
6 | 15 | 0 | 2 |
6 | 15 | 0 | 4 |
6 | 15 | 0 | 5 |
6 | 15 | 0 | 6 |
7 | 15 | 0 | 0 |
7 | 15 | 0 | 1 |
7 | 15 | 0 | 2 |
7 | 16 | 0 | 4 |
7 | 16 | 0 | 5 |
7 | 15 | 0 | 6 |
8 | 16 | 0 | 0 |
8 | 15 | 0 | 1 |
8 | 15 | 0 | 2 |
8 | 16 | 0 | 4 |
8 | 15 | 0 | 5 |
8 | 16 | 0 | 6 |
9 | 15 | 0 | 0 |
9 | 14 | 0 | 1 |
9 | 14 | 0 | 2 |
9 | 14 | 0 | 4 |
9 | 15 | 0 | 5 |
9 | 15 | 0 | 6 |
10 | 14 | 0 | 0 |
10 | (null) | 0 | 1 |
10 | 15 | 0 | 2 |
10 | 15 | 0 | 4 |
10 | 14 | 0 | 5 |
10 | 15 | 0 | 6 |
11 | 16 | 0 | 0 |
11 | 14 | 0 | 1 |
11 | 15 | 0 | 2 |
11 | 15 | 0 | 4 |
11 | 15 | 0 | 5 |
11 | (null) | 0 | 6 |
12 | 15 | 0 | 0 |
12 | (null) | 0 | 1 |
12 | 14 | 0 | 2 |
12 | 16 | 1 | 4 |
12 | 16 | 0 | 5 |
12 | 16 | 0 | 6 |
13 | (null) | 0 | 0 |
13 | 15 | 0 | 1 |
13 | 16 | 0 | 2 |
13 | 16 | 0 | 4 |
13 | 16 | 0 | 5 |
13 | 15 | 0 | 6 |
14 | 15 | 0 | 0 |
14 | 15 | 0 | 1 |
14 | 15 | 0 | 2 |
14 | 14 | 0 | 4 |
14 | 15 | 0 | 5 |
14 | 16 | 0 | 6 |
15 | 16 | 0 | 0 |
15 | 15 | 0 | 1 |
15 | 15 | 0 | 2 |
15 | (null) | 0 | 4 |
15 | 14 | 0 | 5 |
15 | 16 | 0 | 6 |
16 | 16 | 0 | 0 |
16 | 15 | 0 | 1 |
16 | 15 | 0 | 2 |
16 | 15 | 0 | 4 |
16 | 15 | 0 | 5 |
16 | 15 | 0 | 6 |
17 | 16 | 0 | 0 |
17 | 16 | 0 | 1 |
17 | 15 | 0 | 2 |
17 | 15 | 0 | 4 |
100 filas (de 600) seleccionadas
P04.003- Prueba la siguiente orden: select * from habitacion h, area a ¿Tienen algún sentido los resultados? ¿Cuántas filas han salido?
id | dimension | ocupado | idArea | id | tipo | color | orientacion |
---|---|---|---|---|---|---|---|
1 | 15 | 1 | 0 | 0 | Psiquiatría | Blanco | Noreste |
1 | 15 | 1 | 0 | 1 | Maternidad | Rojo | Sur |
1 | 15 | 1 | 0 | 2 | Oncología | Verde | Este |
1 | 15 | 1 | 0 | 3 | Laboratorio | Azul | Noroeste |
1 | 15 | 1 | 0 | 4 | Quirófano | Amarillo | Norte |
1 | 15 | 1 | 0 | 5 | Urgencias | Naranja | Oeste |
1 | 15 | 1 | 0 | 6 | Traumatología | Gris | Sureste |
1 | 15 | 1 | 0 | 7 | Farmacia | Magenta | Suroeste |
1 | 15 | 0 | 1 | 0 | Psiquiatría | Blanco | Noreste |
1 | 15 | 0 | 1 | 1 | Maternidad | Rojo | Sur |
1 | 15 | 0 | 1 | 2 | Oncología | Verde | Este |
1 | 15 | 0 | 1 | 3 | Laboratorio | Azul | Noroeste |
1 | 15 | 0 | 1 | 4 | Quirófano | Amarillo | Norte |
1 | 15 | 0 | 1 | 5 | Urgencias | Naranja | Oeste |
1 | 15 | 0 | 1 | 6 | Traumatología | Gris | Sureste |
1 | 15 | 0 | 1 | 7 | Farmacia | Magenta | Suroeste |
1 | (null) | 0 | 2 | 0 | Psiquiatría | Blanco | Noreste |
1 | (null) | 0 | 2 | 1 | Maternidad | Rojo | Sur |
1 | (null) | 0 | 2 | 2 | Oncología | Verde | Este |
1 | (null) | 0 | 2 | 3 | Laboratorio | Azul | Noroeste |
1 | (null) | 0 | 2 | 4 | Quirófano | Amarillo | Norte |
1 | (null) | 0 | 2 | 5 | Urgencias | Naranja | Oeste |
1 | (null) | 0 | 2 | 6 | Traumatología | Gris | Sureste |
1 | (null) | 0 | 2 | 7 | Farmacia | Magenta | Suroeste |
1 | 14 | 0 | 4 | 0 | Psiquiatría | Blanco | Noreste |
1 | 14 | 0 | 4 | 1 | Maternidad | Rojo | Sur |
1 | 14 | 0 | 4 | 2 | Oncología | Verde | Este |
1 | 14 | 0 | 4 | 3 | Laboratorio | Azul | Noroeste |
1 | 14 | 0 | 4 | 4 | Quirófano | Amarillo | Norte |
1 | 14 | 0 | 4 | 5 | Urgencias | Naranja | Oeste |
1 | 14 | 0 | 4 | 6 | Traumatología | Gris | Sureste |
1 | 14 | 0 | 4 | 7 | Farmacia | Magenta | Suroeste |
1 | 14 | 0 | 5 | 0 | Psiquiatría | Blanco | Noreste |
1 | 14 | 0 | 5 | 1 | Maternidad | Rojo | Sur |
1 | 14 | 0 | 5 | 2 | Oncología | Verde | Este |
1 | 14 | 0 | 5 | 3 | Laboratorio | Azul | Noroeste |
1 | 14 | 0 | 5 | 4 | Quirófano | Amarillo | Norte |
1 | 14 | 0 | 5 | 5 | Urgencias | Naranja | Oeste |
1 | 14 | 0 | 5 | 6 | Traumatología | Gris | Sureste |
1 | 14 | 0 | 5 | 7 | Farmacia | Magenta | Suroeste |
1 | 14 | 0 | 6 | 0 | Psiquiatría | Blanco | Noreste |
1 | 14 | 0 | 6 | 1 | Maternidad | Rojo | Sur |
1 | 14 | 0 | 6 | 2 | Oncología | Verde | Este |
1 | 14 | 0 | 6 | 3 | Laboratorio | Azul | Noroeste |
1 | 14 | 0 | 6 | 4 | Quirófano | Amarillo | Norte |
1 | 14 | 0 | 6 | 5 | Urgencias | Naranja | Oeste |
1 | 14 | 0 | 6 | 6 | Traumatología | Gris | Sureste |
1 | 14 | 0 | 6 | 7 | Farmacia | Magenta | Suroeste |
2 | 15 | 0 | 0 | 0 | Psiquiatría | Blanco | Noreste |
2 | 15 | 0 | 0 | 1 | Maternidad | Rojo | Sur |
2 | 15 | 0 | 0 | 2 | Oncología | Verde | Este |
2 | 15 | 0 | 0 | 3 | Laboratorio | Azul | Noroeste |
2 | 15 | 0 | 0 | 4 | Quirófano | Amarillo | Norte |
2 | 15 | 0 | 0 | 5 | Urgencias | Naranja | Oeste |
2 | 15 | 0 | 0 | 6 | Traumatología | Gris | Sureste |
2 | 15 | 0 | 0 | 7 | Farmacia | Magenta | Suroeste |
2 | (null) | 0 | 1 | 0 | Psiquiatría | Blanco | Noreste |
2 | (null) | 0 | 1 | 1 | Maternidad | Rojo | Sur |
2 | (null) | 0 | 1 | 2 | Oncología | Verde | Este |
2 | (null) | 0 | 1 | 3 | Laboratorio | Azul | Noroeste |
2 | (null) | 0 | 1 | 4 | Quirófano | Amarillo | Norte |
2 | (null) | 0 | 1 | 5 | Urgencias | Naranja | Oeste |
2 | (null) | 0 | 1 | 6 | Traumatología | Gris | Sureste |
2 | (null) | 0 | 1 | 7 | Farmacia | Magenta | Suroeste |
2 | 15 | 0 | 2 | 0 | Psiquiatría | Blanco | Noreste |
2 | 15 | 0 | 2 | 1 | Maternidad | Rojo | Sur |
2 | 15 | 0 | 2 | 2 | Oncología | Verde | Este |
2 | 15 | 0 | 2 | 3 | Laboratorio | Azul | Noroeste |
2 | 15 | 0 | 2 | 4 | Quirófano | Amarillo | Norte |
2 | 15 | 0 | 2 | 5 | Urgencias | Naranja | Oeste |
2 | 15 | 0 | 2 | 6 | Traumatología | Gris | Sureste |
2 | 15 | 0 | 2 | 7 | Farmacia | Magenta | Suroeste |
2 | 14 | 0 | 4 | 0 | Psiquiatría | Blanco | Noreste |
2 | 14 | 0 | 4 | 1 | Maternidad | Rojo | Sur |
2 | 14 | 0 | 4 | 2 | Oncología | Verde | Este |
2 | 14 | 0 | 4 | 3 | Laboratorio | Azul | Noroeste |
2 | 14 | 0 | 4 | 4 | Quirófano | Amarillo | Norte |
2 | 14 | 0 | 4 | 5 | Urgencias | Naranja | Oeste |
2 | 14 | 0 | 4 | 6 | Traumatología | Gris | Sureste |
2 | 14 | 0 | 4 | 7 | Farmacia | Magenta | Suroeste |
2 | 15 | 0 | 5 | 0 | Psiquiatría | Blanco | Noreste |
2 | 15 | 0 | 5 | 1 | Maternidad | Rojo | Sur |
2 | 15 | 0 | 5 | 2 | Oncología | Verde | Este |
2 | 15 | 0 | 5 | 3 | Laboratorio | Azul | Noroeste |
2 | 15 | 0 | 5 | 4 | Quirófano | Amarillo | Norte |
2 | 15 | 0 | 5 | 5 | Urgencias | Naranja | Oeste |
2 | 15 | 0 | 5 | 6 | Traumatología | Gris | Sureste |
2 | 15 | 0 | 5 | 7 | Farmacia | Magenta | Suroeste |
2 | 16 | 0 | 6 | 0 | Psiquiatría | Blanco | Noreste |
2 | 16 | 0 | 6 | 1 | Maternidad | Rojo | Sur |
2 | 16 | 0 | 6 | 2 | Oncología | Verde | Este |
2 | 16 | 0 | 6 | 3 | Laboratorio | Azul | Noroeste |
2 | 16 | 0 | 6 | 4 | Quirófano | Amarillo | Norte |
2 | 16 | 0 | 6 | 5 | Urgencias | Naranja | Oeste |
2 | 16 | 0 | 6 | 6 | Traumatología | Gris | Sureste |
2 | 16 | 0 | 6 | 7 | Farmacia | Magenta | Suroeste |
3 | 15 | 1 | 0 | 0 | Psiquiatría | Blanco | Noreste |
3 | 15 | 1 | 0 | 1 | Maternidad | Rojo | Sur |
3 | 15 | 1 | 0 | 2 | Oncología | Verde | Este |
3 | 15 | 1 | 0 | 3 | Laboratorio | Azul | Noroeste |
100 filas (de 4800) seleccionadas
P04.004- Muestra toda la información de área e id y dimensión de las habitaciones que pertenecen a cada una de las anteriores, ordenado por identificador de área y número de habitación.
id | tipo | color | orientacion | habitacion | dimension |
---|---|---|---|---|---|
0 | Psiquiatría | Blanco | Noreste | 1 | 15 |
0 | Psiquiatría | Blanco | Noreste | 2 | 15 |
0 | Psiquiatría | Blanco | Noreste | 3 | 15 |
0 | Psiquiatría | Blanco | Noreste | 4 | 15 |
0 | Psiquiatría | Blanco | Noreste | 5 | 16 |
0 | Psiquiatría | Blanco | Noreste | 6 | 14 |
0 | Psiquiatría | Blanco | Noreste | 7 | 15 |
0 | Psiquiatría | Blanco | Noreste | 8 | 16 |
0 | Psiquiatría | Blanco | Noreste | 9 | 15 |
0 | Psiquiatría | Blanco | Noreste | 10 | 14 |
0 | Psiquiatría | Blanco | Noreste | 11 | 16 |
0 | Psiquiatría | Blanco | Noreste | 12 | 15 |
0 | Psiquiatría | Blanco | Noreste | 13 | (null) |
0 | Psiquiatría | Blanco | Noreste | 14 | 15 |
0 | Psiquiatría | Blanco | Noreste | 15 | 16 |
0 | Psiquiatría | Blanco | Noreste | 16 | 16 |
0 | Psiquiatría | Blanco | Noreste | 17 | 16 |
0 | Psiquiatría | Blanco | Noreste | 18 | 15 |
0 | Psiquiatría | Blanco | Noreste | 19 | 15 |
0 | Psiquiatría | Blanco | Noreste | 20 | 14 |
0 | Psiquiatría | Blanco | Noreste | 21 | 15 |
0 | Psiquiatría | Blanco | Noreste | 22 | 15 |
0 | Psiquiatría | Blanco | Noreste | 23 | 15 |
0 | Psiquiatría | Blanco | Noreste | 24 | 15 |
0 | Psiquiatría | Blanco | Noreste | 25 | 14 |
0 | Psiquiatría | Blanco | Noreste | 26 | 15 |
0 | Psiquiatría | Blanco | Noreste | 27 | 15 |
0 | Psiquiatría | Blanco | Noreste | 28 | 15 |
0 | Psiquiatría | Blanco | Noreste | 29 | 14 |
0 | Psiquiatría | Blanco | Noreste | 30 | 15 |
0 | Psiquiatría | Blanco | Noreste | 31 | 15 |
0 | Psiquiatría | Blanco | Noreste | 32 | 15 |
0 | Psiquiatría | Blanco | Noreste | 33 | 15 |
0 | Psiquiatría | Blanco | Noreste | 34 | (null) |
0 | Psiquiatría | Blanco | Noreste | 35 | 15 |
0 | Psiquiatría | Blanco | Noreste | 36 | 16 |
0 | Psiquiatría | Blanco | Noreste | 37 | 15 |
0 | Psiquiatría | Blanco | Noreste | 38 | 15 |
0 | Psiquiatría | Blanco | Noreste | 39 | 16 |
0 | Psiquiatría | Blanco | Noreste | 40 | 15 |
0 | Psiquiatría | Blanco | Noreste | 41 | 14 |
0 | Psiquiatría | Blanco | Noreste | 42 | 16 |
0 | Psiquiatría | Blanco | Noreste | 43 | 15 |
0 | Psiquiatría | Blanco | Noreste | 44 | 16 |
0 | Psiquiatría | Blanco | Noreste | 45 | 16 |
0 | Psiquiatría | Blanco | Noreste | 46 | 16 |
0 | Psiquiatría | Blanco | Noreste | 47 | 14 |
0 | Psiquiatría | Blanco | Noreste | 48 | 15 |
0 | Psiquiatría | Blanco | Noreste | 49 | 14 |
0 | Psiquiatría | Blanco | Noreste | 50 | 14 |
0 | Psiquiatría | Blanco | Noreste | 51 | 14 |
0 | Psiquiatría | Blanco | Noreste | 52 | 15 |
0 | Psiquiatría | Blanco | Noreste | 53 | 16 |
0 | Psiquiatría | Blanco | Noreste | 54 | 15 |
0 | Psiquiatría | Blanco | Noreste | 55 | 15 |
0 | Psiquiatría | Blanco | Noreste | 56 | 15 |
0 | Psiquiatría | Blanco | Noreste | 57 | 15 |
0 | Psiquiatría | Blanco | Noreste | 58 | 15 |
0 | Psiquiatría | Blanco | Noreste | 59 | 15 |
0 | Psiquiatría | Blanco | Noreste | 60 | 15 |
0 | Psiquiatría | Blanco | Noreste | 61 | 15 |
0 | Psiquiatría | Blanco | Noreste | 62 | 15 |
0 | Psiquiatría | Blanco | Noreste | 63 | 14 |
0 | Psiquiatría | Blanco | Noreste | 64 | (null) |
0 | Psiquiatría | Blanco | Noreste | 65 | 15 |
0 | Psiquiatría | Blanco | Noreste | 66 | 15 |
0 | Psiquiatría | Blanco | Noreste | 67 | 15 |
0 | Psiquiatría | Blanco | Noreste | 68 | 15 |
0 | Psiquiatría | Blanco | Noreste | 69 | 15 |
0 | Psiquiatría | Blanco | Noreste | 70 | 15 |
0 | Psiquiatría | Blanco | Noreste | 71 | 15 |
0 | Psiquiatría | Blanco | Noreste | 72 | 16 |
0 | Psiquiatría | Blanco | Noreste | 73 | 14 |
0 | Psiquiatría | Blanco | Noreste | 74 | 15 |
0 | Psiquiatría | Blanco | Noreste | 75 | 15 |
0 | Psiquiatría | Blanco | Noreste | 76 | 15 |
0 | Psiquiatría | Blanco | Noreste | 77 | 15 |
0 | Psiquiatría | Blanco | Noreste | 78 | 16 |
0 | Psiquiatría | Blanco | Noreste | 79 | 14 |
0 | Psiquiatría | Blanco | Noreste | 80 | 16 |
0 | Psiquiatría | Blanco | Noreste | 81 | 15 |
0 | Psiquiatría | Blanco | Noreste | 82 | 15 |
0 | Psiquiatría | Blanco | Noreste | 83 | 15 |
0 | Psiquiatría | Blanco | Noreste | 84 | 15 |
0 | Psiquiatría | Blanco | Noreste | 85 | 16 |
0 | Psiquiatría | Blanco | Noreste | 86 | (null) |
0 | Psiquiatría | Blanco | Noreste | 87 | 14 |
0 | Psiquiatría | Blanco | Noreste | 88 | 15 |
0 | Psiquiatría | Blanco | Noreste | 89 | 16 |
0 | Psiquiatría | Blanco | Noreste | 90 | 15 |
0 | Psiquiatría | Blanco | Noreste | 91 | (null) |
0 | Psiquiatría | Blanco | Noreste | 92 | 15 |
0 | Psiquiatría | Blanco | Noreste | 93 | 16 |
0 | Psiquiatría | Blanco | Noreste | 94 | 16 |
0 | Psiquiatría | Blanco | Noreste | 95 | 16 |
0 | Psiquiatría | Blanco | Noreste | 96 | 16 |
0 | Psiquiatría | Blanco | Noreste | 97 | (null) |
0 | Psiquiatría | Blanco | Noreste | 98 | 14 |
0 | Psiquiatría | Blanco | Noreste | 99 | 14 |
0 | Psiquiatría | Blanco | Noreste | 100 | 16 |
100 filas (de 600) seleccionadas
P04.005- Muestra toda la información de las habitaciones del área 5, ordenado por identificador de área y número de habitación.
id | dimension | ocupado | idArea |
---|---|---|---|
1 | 14 | 0 | 5 |
2 | 15 | 0 | 5 |
3 | 16 | 0 | 5 |
4 | 16 | 0 | 5 |
5 | 14 | 0 | 5 |
6 | 15 | 0 | 5 |
7 | 16 | 0 | 5 |
8 | 15 | 0 | 5 |
9 | 15 | 0 | 5 |
10 | 14 | 0 | 5 |
11 | 15 | 0 | 5 |
12 | 16 | 0 | 5 |
13 | 16 | 0 | 5 |
14 | 15 | 0 | 5 |
15 | 14 | 0 | 5 |
16 | 15 | 0 | 5 |
17 | 15 | 0 | 5 |
18 | (null) | 0 | 5 |
19 | 14 | 0 | 5 |
20 | 15 | 0 | 5 |
21 | 15 | 0 | 5 |
22 | 15 | 0 | 5 |
23 | (null) | 0 | 5 |
24 | 14 | 0 | 5 |
25 | 16 | 0 | 5 |
26 | 14 | 0 | 5 |
27 | 16 | 0 | 5 |
28 | 16 | 0 | 5 |
29 | 15 | 0 | 5 |
30 | 14 | 0 | 5 |
31 | 15 | 0 | 5 |
32 | 15 | 0 | 5 |
33 | (null) | 0 | 5 |
34 | 16 | 0 | 5 |
35 | 15 | 0 | 5 |
36 | 15 | 0 | 5 |
37 | 14 | 0 | 5 |
38 | 14 | 0 | 5 |
39 | 15 | 0 | 5 |
40 | 16 | 0 | 5 |
41 | 15 | 0 | 5 |
42 | 16 | 0 | 5 |
43 | 15 | 0 | 5 |
44 | 14 | 0 | 5 |
45 | 15 | 0 | 5 |
46 | 15 | 0 | 5 |
47 | 16 | 0 | 5 |
48 | 15 | 0 | 5 |
49 | 14 | 0 | 5 |
50 | 15 | 0 | 5 |
51 | 16 | 0 | 5 |
52 | 15 | 0 | 5 |
53 | 15 | 0 | 5 |
54 | 16 | 0 | 5 |
55 | 16 | 0 | 5 |
56 | 16 | 0 | 5 |
57 | 16 | 0 | 5 |
58 | 16 | 0 | 5 |
59 | 15 | 0 | 5 |
60 | 15 | 0 | 5 |
61 | 14 | 0 | 5 |
62 | 14 | 0 | 5 |
63 | 16 | 0 | 5 |
64 | 15 | 0 | 5 |
65 | 15 | 0 | 5 |
66 | 15 | 0 | 5 |
67 | 15 | 0 | 5 |
68 | 15 | 0 | 5 |
69 | 15 | 0 | 5 |
70 | (null) | 0 | 5 |
71 | 14 | 0 | 5 |
72 | 15 | 0 | 5 |
73 | 16 | 0 | 5 |
74 | 16 | 0 | 5 |
75 | 15 | 0 | 5 |
76 | 15 | 0 | 5 |
77 | 15 | 0 | 5 |
78 | 16 | 0 | 5 |
79 | 15 | 0 | 5 |
80 | 15 | 0 | 5 |
81 | 14 | 0 | 5 |
82 | 14 | 0 | 5 |
83 | 15 | 0 | 5 |
84 | 16 | 0 | 5 |
85 | 16 | 0 | 5 |
86 | 15 | 0 | 5 |
87 | 15 | 0 | 5 |
88 | 15 | 0 | 5 |
89 | 16 | 0 | 5 |
90 | 15 | 0 | 5 |
91 | 14 | 0 | 5 |
92 | 15 | 0 | 5 |
93 | 14 | 0 | 5 |
94 | 15 | 0 | 5 |
95 | 15 | 0 | 5 |
96 | 15 | 0 | 5 |
97 | 14 | 0 | 5 |
98 | 15 | 0 | 5 |
99 | 15 | 0 | 5 |
100 | (null) | 0 | 5 |
100 filas (de 100) seleccionadas
P04.006- Muestra toda la información de las habitaciones del área de "traumatología", ordenado por número de habitación.
id | dimension | ocupado | idArea |
---|---|---|---|
1 | 14 | 0 | 6 |
2 | 16 | 0 | 6 |
3 | 15 | 0 | 6 |
4 | 16 | 0 | 6 |
5 | (null) | 0 | 6 |
6 | 15 | 0 | 6 |
7 | 15 | 0 | 6 |
8 | 16 | 0 | 6 |
9 | 15 | 0 | 6 |
10 | 15 | 0 | 6 |
11 | (null) | 0 | 6 |
12 | 16 | 0 | 6 |
13 | 15 | 0 | 6 |
14 | 16 | 0 | 6 |
15 | 16 | 0 | 6 |
16 | 15 | 0 | 6 |
17 | 16 | 0 | 6 |
18 | 15 | 0 | 6 |
19 | (null) | 0 | 6 |
20 | 14 | 1 | 6 |
21 | 14 | 0 | 6 |
22 | 15 | 0 | 6 |
23 | 14 | 0 | 6 |
24 | 15 | 0 | 6 |
25 | 15 | 0 | 6 |
26 | 14 | 0 | 6 |
27 | 15 | 0 | 6 |
28 | (null) | 0 | 6 |
29 | 16 | 0 | 6 |
30 | 15 | 0 | 6 |
31 | 14 | 0 | 6 |
32 | 15 | 0 | 6 |
33 | 15 | 0 | 6 |
34 | 16 | 0 | 6 |
35 | 15 | 0 | 6 |
36 | 15 | 0 | 6 |
37 | 15 | 0 | 6 |
38 | 15 | 0 | 6 |
39 | 16 | 0 | 6 |
40 | 14 | 0 | 6 |
41 | (null) | 0 | 6 |
42 | 15 | 0 | 6 |
43 | 14 | 0 | 6 |
44 | 14 | 0 | 6 |
45 | 15 | 0 | 6 |
46 | 15 | 0 | 6 |
47 | 14 | 0 | 6 |
48 | 15 | 0 | 6 |
49 | 14 | 0 | 6 |
50 | 15 | 0 | 6 |
51 | 15 | 0 | 6 |
52 | 16 | 0 | 6 |
53 | 16 | 0 | 6 |
54 | 16 | 0 | 6 |
55 | 16 | 0 | 6 |
56 | 15 | 0 | 6 |
57 | 15 | 0 | 6 |
58 | 16 | 0 | 6 |
59 | 14 | 0 | 6 |
60 | 15 | 0 | 6 |
61 | 16 | 0 | 6 |
62 | 15 | 0 | 6 |
63 | 15 | 0 | 6 |
64 | 15 | 0 | 6 |
65 | 15 | 0 | 6 |
66 | 15 | 0 | 6 |
67 | 15 | 0 | 6 |
68 | 16 | 0 | 6 |
69 | 14 | 0 | 6 |
70 | 15 | 0 | 6 |
71 | 15 | 0 | 6 |
72 | 14 | 0 | 6 |
73 | 15 | 0 | 6 |
74 | (null) | 0 | 6 |
75 | 16 | 0 | 6 |
76 | (null) | 0 | 6 |
77 | 15 | 0 | 6 |
78 | 15 | 0 | 6 |
79 | 14 | 0 | 6 |
80 | 16 | 0 | 6 |
81 | 15 | 0 | 6 |
82 | 14 | 0 | 6 |
83 | 14 | 0 | 6 |
84 | 16 | 0 | 6 |
85 | 14 | 0 | 6 |
86 | 16 | 0 | 6 |
87 | 15 | 0 | 6 |
88 | 15 | 0 | 6 |
89 | 16 | 0 | 6 |
90 | 14 | 0 | 6 |
91 | 14 | 0 | 6 |
92 | 15 | 0 | 6 |
93 | 15 | 0 | 6 |
94 | 15 | 0 | 6 |
95 | 16 | 0 | 6 |
96 | 14 | 0 | 6 |
97 | 15 | 0 | 6 |
98 | 16 | 0 | 6 |
99 | 16 | 0 | 6 |
100 | 14 | 0 | 6 |
100 filas (de 100) seleccionadas
P04.007- Muestra el número de colegiado, apellidos, nombre, dirección y ciudad de los trabajadores de la provincia de Alicante que son médicos, ordenado por ciudad y apellidos.
colegiado | apellidos | nombre | direccion | ciudad |
---|---|---|---|---|
347526498 | FERNANDEZ GARCIA | DIEGO | GOTETA, LA 90 | Alacant/Alicante |
187770287 | FERNANDEZ GARCIA | MIGUEL | DOCTOR GIMENEZ DIAZ 6 | Alacant/Alicante |
974479934 | FERNANDEZ LOPEZ | CRISTINA | ARIES 45 | Alacant/Alicante |
330376507 | FERNANDEZ LOPEZ | ANDREA | VICENTE BONASTRE 87 | Alacant/Alicante |
864072850 | FERNANDEZ MARTINEZ | JORGE | MUSICO AGUSTIN BERTOMEU 10 | Alacant/Alicante |
985550808 | GARCIA FERNANDEZ | CARLOS | PARDO GIMENO 87 | Alacant/Alicante |
643754981 | GARCIA GARCIA | CRISTINA | MAESTRO CABALLERO (Impares del 31 al final) (Pa | Alacant/Alicante |
854799473 | GARCIA GARCIA | SARA | TOPACIO 52 | Alacant/Alicante |
650750677 | GARCIA GONZALEZ | LAURA | VICTOR DE LA SERNA 118 | Alacant/Alicante |
458428870 | GARCIA LOPEZ | ALBA | PRESBITERO GISBERT 102 | Alacant/Alicante |
206443884 | GARCIA LOPEZ | MARINA | AGUAS DE SAX 15 | Alacant/Alicante |
394502395 | GARCIA LOPEZ | ADRIAN | JAIME MARIA BUCH 91 | Alacant/Alicante |
247593713 | GARCIA PEREZ | JORGE | JOSE LOPEZ AGUDO 32 | Alacant/Alicante |
626476402 | GARCIA PEREZ | IVAN | PLATOS 80 | Alacant/Alicante |
570791488 | GONZALEZ FERNANDEZ | CRISTINA | SAN EMILIO 24 | Alacant/Alicante |
297146925 | GONZALEZ GONZALEZ | ANTONIO | JULIO ANTONIO 45 | Alacant/Alicante |
735949716 | GONZALEZ LOPEZ | ANTONIO | VIRGEN DEL PUIG 106 | Alacant/Alicante |
308709810 | GONZALEZ MARTINEZ | CRISTINA | MUSICO TORRES CLIMENT 89 | Alacant/Alicante |
677198881 | GONZALEZ PEREZ | ANDREA | PASCUAL DE LA MATA 15 | Alacant/Alicante |
836518140 | GONZALEZ RODRIGUEZ | ADRIAN | PADRE ESPLA 15 | Alacant/Alicante |
560793157 | GONZALEZ RODRIGUEZ | ALBA | OCHO 22 | Alacant/Alicante |
736193481 | GONZALEZ RODRIGUEZ | SERGIO | REDES 51 | Alacant/Alicante |
184091067 | GONZALEZ SANCHEZ | ADRIAN | FAMORCA 15 | Alacant/Alicante |
890187817 | LOPEZ FERNANDEZ | MIGUEL | SAN JUAN DE LA CRUZ,Pasaje 39 | Alacant/Alicante |
739791584 | LOPEZ GARCIA | ANDREA | SAN AGATANGELO 18 | Alacant/Alicante |
640080309 | LOPEZ GARCIA | ADRIAN | CATEDRATICO JAUME MAS I PORCEL 109 | Alacant/Alicante |
181909936 | LOPEZ LOPEZ | RAUL | PAGEL 112 | Alacant/Alicante |
896576438 | LOPEZ MARTINEZ | CLAUDIA | MIGUEL CREVEA 92 | Alacant/Alicante |
524389017 | LOPEZ MARTINEZ | ALEJANDRO | EINSTEIN 51 | Alacant/Alicante |
595546469 | LOPEZ MARTINEZ | ALBA | JUAN ALEMANY LIMIÑANA 80 | Alacant/Alicante |
362155170 | LOPEZ MARTINEZ | RAUL | AUSO Y MONZO 45 | Alacant/Alicante |
754938493 | LOPEZ PEREZ | PABLO | PRIMITIVO PEREZ 12 | Alacant/Alicante |
334122262 | LOPEZ PEREZ | RAUL | DIPUTADO JUAN A. RODRIGUEZ MARIN 90 | Alacant/Alicante |
281729181 | LOPEZ RODRIGUEZ | SERGIO | ONDARA 15 | Alacant/Alicante |
333574972 | MARTINEZ FERNANDEZ | ANTONIO | PERIODISTA RODOLFO SALAZAR,Avenida (Impares del 1 | Alacant/Alicante |
541945660 | MARTINEZ FERNANDEZ | CARLOS | CONSERVA, LA,Callejon 35 | Alacant/Alicante |
963620875 | MARTINEZ FERNANDEZ | RAUL | ALCALDE LORENZO CARBONELL (Pares del 2 al final) | Alacant/Alicante |
625235463 | MARTINEZ GARCIA | MARIO | SICILIA 105 | Alacant/Alicante |
579476094 | MARTINEZ GONZALEZ | CARLOS | TORERO JOSE MARIA MANZANARES 13 | Alacant/Alicante |
403739660 | MARTINEZ GONZALEZ | ANTONIO | PASEITO RAMIRO,Plaza 37 | Alacant/Alicante |
882918997 | MARTINEZ MARTINEZ | DAVID | DOCTOR GASCUÑANA HERNANDO,Plaza 16 | Alacant/Alicante |
197727380 | MARTINEZ MARTINEZ | ADRIAN | FOGUERER JOSE ANGEL GUIRAO 79 | Alacant/Alicante |
698795903 | MARTINEZ PEREZ | CARLOS | FRANCO, DEL (POL. DE LAS ATALAYAS) 97 | Alacant/Alicante |
944587781 | MARTINEZ RODRIGUEZ | ADRIAN | CAMPOAMOR,Paseo 15 | Alacant/Alicante |
124333933 | MARTINEZ RODRIGUEZ | DAVID | ANTONIO DE TRUEBA 28 | Alacant/Alicante |
559375400 | MARTINEZ RODRIGUEZ | DAVID | MOSEN FENOLLAR 44 | Alacant/Alicante |
712190148 | MARTINEZ RODRIGUEZ | ELENA | DAGNIOL 68 | Alacant/Alicante |
381885135 | MARTINEZ SANCHEZ | DIEGO | JACINTO BENAVENTE 46 | Alacant/Alicante |
614928783 | MARTINEZ SANCHEZ | MARIO | SAUCE 42 | Alacant/Alicante |
802130340 | MARTINEZ SANCHEZ | MARINA | ROMULO 71 | Alacant/Alicante |
485526094 | PEREZ FERNANDEZ | DAVID | CLAUSTRO,Plaza 91 | Alacant/Alicante |
933560487 | PEREZ FERNANDEZ | MARIO | CATEDRATICO FERRE VIDIELLA 57 | Alacant/Alicante |
100664498 | PEREZ GARCIA | CLAUDIA | NIAGARA 67 | Alacant/Alicante |
201529507 | PEREZ GARCIA | JORGE | GRECO, EL 8 | Alacant/Alicante |
771265929 | PEREZ GARCIA | JAVIER | PINTOR VARELA 82 | Alacant/Alicante |
990694733 | PEREZ GARCIA | ANTONIO | OVIEDO,Avenida 5 | Alacant/Alicante |
319011133 | PEREZ GONZALEZ | JORGE | PELAYO 7 | Alacant/Alicante |
126316702 | PEREZ GONZALEZ | SARA | NUÑEZ DE BALBOA 84 | Alacant/Alicante |
335799383 | PEREZ LOPEZ | CARLOS | HERMANOS MACHADO 5 | Alacant/Alicante |
782849844 | PEREZ LOPEZ | NEREA | RAFAEL TEROL 69 | Alacant/Alicante |
598003246 | PEREZ PEREZ | JORGE | OSCAR ESPLA,Avenida (Impares del 11 al final) 59 | Alacant/Alicante |
189610677 | PEREZ PEREZ | MARTA | ALFONSO GUIXOT 12 | Alacant/Alicante |
297471657 | PEREZ PEREZ | ALEJANDRO | JILGUERO 14 | Alacant/Alicante |
597876641 | PEREZ RODRIGUEZ | IVAN | ANSALDO,Avenida 19 | Alacant/Alicante |
109296556 | PEREZ RODRIGUEZ | ALBA | ARTILLEROS 58 | Alacant/Alicante |
409396466 | RODRIGUEZ FERNANDEZ | MARIO | ROQUE CHAVAS 84 | Alacant/Alicante |
965848190 | RODRIGUEZ GARCIA | ELENA | ALFAZ DEL PI 100 | Alacant/Alicante |
162752861 | RODRIGUEZ MARTINEZ | ALVARO | MAESTRO BARBIERI 2 | Alacant/Alicante |
177434790 | RODRIGUEZ MARTINEZ | MANUEL | MILLENA 92 | Alacant/Alicante |
783594499 | RODRIGUEZ SANCHEZ | SERGIO | ALTEA 77 | Alacant/Alicante |
621225687 | RODRIGUEZ SANCHEZ | ALEJANDRO | LAFORA 62 | Alacant/Alicante |
351939151 | SANCHEZ FERNANDEZ | JAVIER | JUANA FRANCES, DE 102 | Alacant/Alicante |
326793703 | SANCHEZ FERNANDEZ | PAULA | SEÑORITA DE TREVELES 96 | Alacant/Alicante |
932505404 | SANCHEZ GARCIA | ANA | BALMES 61 | Alacant/Alicante |
244890489 | SANCHEZ GONZALEZ | SARA | SALADAR, DEL,Carretera 17 | Alacant/Alicante |
970942180 | SANCHEZ LOPEZ | CARLOS | ENRIQUETA ELIZAICIN 100 | Alacant/Alicante |
999004293 | SANCHEZ LOPEZ | MARINA | CATEDRATICO LEVERONI 30 | Alacant/Alicante |
369965227 | SANCHEZ PEREZ | PABLO | SANTANDER,Avenida 117 | Alacant/Alicante |
186556871 | SANCHEZ RODRIGUEZ | ALBA | LIMONES 99 | Alacant/Alicante |
680264714 | SANCHEZ SANCHEZ | RAUL | DOCTOR SANTA OLALLA 96 | Alacant/Alicante |
886716664 | SANCHEZ SANCHEZ | JAVIER | CORINDON 4 | Alacant/Alicante |
100816868 | FERNANDEZ LOPEZ | DIEGO | FONT DOLCA 9 | Alcoi/Alcoy |
340356147 | FERNANDEZ SANCHEZ | ANDREA | JUAN GIL ALBERT 17 | Alcoi/Alcoy |
937368276 | GARCIA GARCIA | ALVARO | SANG, LA 96 | Alcoi/Alcoy |
787356870 | GONZALEZ LOPEZ | MARTA | DINS, DE 19 | Alcoi/Alcoy |
547201058 | LOPEZ FERNANDEZ | ANTONIO | BISBE ORBERA 84 | Alcoi/Alcoy |
574602724 | LOPEZ GARCIA | ANTONIO | SANT BLAI 56 | Alcoi/Alcoy |
692026452 | LOPEZ GONZALEZ | MARIO | MOSSEN ARNAUDA 70 | Alcoi/Alcoy |
148074362 | LOPEZ GONZALEZ | MARIA | REALETS 104 | Alcoi/Alcoy |
675642697 | LOPEZ PEREZ | ANDREA | CARME, DEL 27 | Alcoi/Alcoy |
933108112 | LOPEZ RODRIGUEZ | ANDREA | MOSSEN CIRILO TORMO 112 | Alcoi/Alcoy |
504532323 | LOPEZ RODRIGUEZ | CLAUDIA | MERITA,Passatge 47 | Alcoi/Alcoy |
337067689 | PEREZ FERNANDEZ | LUCIA | COLON 38 | Alcoi/Alcoy |
365017533 | PEREZ GARCIA | DAVID | MONTDUBER 94 | Alcoi/Alcoy |
924685080 | RODRIGUEZ GARCIA | MARIA | CASETA MASCARELLES 32 | Alcoi/Alcoy |
924121149 | RODRIGUEZ GONZALEZ | CRISTINA | FONTANELLA 34 | Alcoi/Alcoy |
343570306 | RODRIGUEZ SANCHEZ | SERGIO | VERGE DEL PILAR 41 | Alcoi/Alcoy |
756724297 | SANCHEZ MARTINEZ | MIGUEL | FILA ASTURIANOS,Carrer 35 | Alcoi/Alcoy |
000000001 | Gomez Rico | Juan | Mayor, 12, Bloque 4 | Alicante |
593465179 | FERNANDEZ FERNANDEZ | MARIO | FLORES, LAS,Urbanizacion (Impares del 1 al final) | Benidorm |
100 filas (de 166) seleccionadas
P04.008- Muestra el id y tipo de especialidad, número de colegiado, apellidos, nombre, dirección y ciudad de los médicos de la provincia de Alicante, ordenado por tipo de especialidad y apellidos.
id | tipo | colegiado | apellidos | nombre | direccion | ciudad |
---|---|---|---|---|---|---|
3 | Cirujano | 317890272 | FERNANDEZ RODRIGUEZ | MARIO | LLIRIET DE TOUS,Partida 119 | Benidorm |
3 | Cirujano | 458428870 | GARCIA LOPEZ | ALBA | PRESBITERO GISBERT 102 | Alacant/Alicante |
3 | Cirujano | 308709810 | GONZALEZ MARTINEZ | CRISTINA | MUSICO TORRES CLIMENT 89 | Alacant/Alicante |
3 | Cirujano | 560793157 | GONZALEZ RODRIGUEZ | ALBA | OCHO 22 | Alacant/Alicante |
3 | Cirujano | 249970242 | GONZALEZ SANCHEZ | ALBA | DIEGO DE CARDENAS 99 | Elx/Elche |
3 | Cirujano | 692026452 | LOPEZ GONZALEZ | MARIO | MOSSEN ARNAUDA 70 | Alcoi/Alcoy |
3 | Cirujano | 625235463 | MARTINEZ GARCIA | MARIO | SICILIA 105 | Alacant/Alicante |
3 | Cirujano | 712190148 | MARTINEZ RODRIGUEZ | ELENA | DAGNIOL 68 | Alacant/Alicante |
3 | Cirujano | 201529507 | PEREZ GARCIA | JORGE | GRECO, EL 8 | Alacant/Alicante |
3 | Cirujano | 259490363 | PEREZ MARTINEZ | JAVIER | FERROCARRIL,Avenida 38 | Elx/Elche |
3 | Cirujano | 153175673 | PEREZ PEREZ | NEREA | CANARIO 17 | Benidorm |
3 | Cirujano | 965848190 | RODRIGUEZ GARCIA | ELENA | ALFAZ DEL PI 100 | Alacant/Alicante |
3 | Cirujano | 162752861 | RODRIGUEZ MARTINEZ | ALVARO | MAESTRO BARBIERI 2 | Alacant/Alicante |
3 | Cirujano | 621225687 | RODRIGUEZ SANCHEZ | ALEJANDRO | LAFORA 62 | Alacant/Alicante |
3 | Cirujano | 326793703 | SANCHEZ FERNANDEZ | PAULA | SEÑORITA DE TREVELES 96 | Alacant/Alicante |
3 | Cirujano | 401758388 | SANCHEZ FERNANDEZ | SARA | MAREDEDEU DEL ROSARI 93 | Elx/Elche |
3 | Cirujano | 981137599 | SANCHEZ GONZALEZ | NEREA | FRANCISCO ALEMAN PEREZ 40 | Elx/Elche |
3 | Cirujano | 429636295 | SANCHEZ LOPEZ | MANUEL | ANTONIO MOYA ALBALADEJO 14 | Elx/Elche |
3 | Cirujano | 186556871 | SANCHEZ RODRIGUEZ | ALBA | LIMONES 99 | Alacant/Alicante |
6 | Farmaceutico | 593230766 | FERNANDEZ GARCIA | SARA | JOVENTUT, DE LA,Passeig 96 | Elx/Elche |
6 | Farmaceutico | 539008927 | FERNANDEZ RODRIGUEZ | ADRIAN | SAN MIGUEL,Travesia 81 | Benidorm |
6 | Farmaceutico | 643754981 | GARCIA GARCIA | CRISTINA | MAESTRO CABALLERO (Impares del 31 al final) (Pa | Alacant/Alicante |
6 | Farmaceutico | 152496629 | GARCIA LOPEZ | CRISTINA | SAN JERONIMO 48 | Benidorm |
6 | Farmaceutico | 206443884 | GARCIA LOPEZ | MARINA | AGUAS DE SAX 15 | Alacant/Alicante |
6 | Farmaceutico | 394502395 | GARCIA LOPEZ | ADRIAN | JAIME MARIA BUCH 91 | Alacant/Alicante |
6 | Farmaceutico | 612960332 | GARCIA PEREZ | MANUEL | BEATA M. SUFRAGIO ORTS BALDO,Carrer 116 | Benidorm |
6 | Farmaceutico | 802750397 | LOPEZ FERNANDEZ | JORGE | JOSE PERAL 60 | Elx/Elche |
6 | Farmaceutico | 890187817 | LOPEZ FERNANDEZ | MIGUEL | SAN JUAN DE LA CRUZ,Pasaje 39 | Alacant/Alicante |
6 | Farmaceutico | 640080309 | LOPEZ GARCIA | ADRIAN | CATEDRATICO JAUME MAS I PORCEL 109 | Alacant/Alicante |
6 | Farmaceutico | 139029537 | LOPEZ GONZALEZ | LUCIA | OLEGARIO DOMARCO SELLER 74 | Elx/Elche |
6 | Farmaceutico | 754938493 | LOPEZ PEREZ | PABLO | PRIMITIVO PEREZ 12 | Alacant/Alicante |
6 | Farmaceutico | 933108112 | LOPEZ RODRIGUEZ | ANDREA | MOSSEN CIRILO TORMO 112 | Alcoi/Alcoy |
6 | Farmaceutico | 140019549 | LOPEZ SANCHEZ | ALVARO | ESPI 64 | Elx/Elche |
6 | Farmaceutico | 944587781 | MARTINEZ RODRIGUEZ | ADRIAN | CAMPOAMOR,Paseo 15 | Alacant/Alicante |
6 | Farmaceutico | 614928783 | MARTINEZ SANCHEZ | MARIO | SAUCE 42 | Alacant/Alicante |
6 | Farmaceutico | 267940085 | PEREZ FERNANDEZ | MANUEL | BLAS ORTS SANCHEZ 70 | Elx/Elche |
6 | Farmaceutico | 771265929 | PEREZ GARCIA | JAVIER | PINTOR VARELA 82 | Alacant/Alicante |
6 | Farmaceutico | 100664498 | PEREZ GARCIA | CLAUDIA | NIAGARA 67 | Alacant/Alicante |
6 | Farmaceutico | 752832115 | PEREZ RODRIGUEZ | ANDREA | ANTONIO GARCIA CAMPOS 104 | Elx/Elche |
6 | Farmaceutico | 712753842 | RODRIGUEZ LOPEZ | LUCIA | CALLOSA D'ENSARRIA 53 | Benidorm |
6 | Farmaceutico | 224916652 | RODRIGUEZ MARTINEZ | ANA | MONTEVIDEO 44 | Benidorm |
6 | Farmaceutico | 496159077 | SANCHEZ FERNANDEZ | LAURA | FERRANDEZ, DE,Camino 53 | Elx/Elche |
6 | Farmaceutico | 756724297 | SANCHEZ MARTINEZ | MIGUEL | FILA ASTURIANOS,Carrer 35 | Alcoi/Alcoy |
6 | Farmaceutico | 369965227 | SANCHEZ PEREZ | PABLO | SANTANDER,Avenida 117 | Alacant/Alicante |
5 | Laboratorio | 593465179 | FERNANDEZ FERNANDEZ | MARIO | FLORES, LAS,Urbanizacion (Impares del 1 al final) | Benidorm |
5 | Laboratorio | 330376507 | FERNANDEZ LOPEZ | ANDREA | VICENTE BONASTRE 87 | Alacant/Alicante |
5 | Laboratorio | 542859471 | FERNANDEZ MARTINEZ | DANIEL | PALANGRE 81 | Benidorm |
5 | Laboratorio | 198322172 | FERNANDEZ PEREZ | ADRIAN | PALMA, LA 49 | Elx/Elche |
5 | Laboratorio | 854799473 | GARCIA GARCIA | SARA | TOPACIO 52 | Alacant/Alicante |
5 | Laboratorio | 570791488 | GONZALEZ FERNANDEZ | CRISTINA | SAN EMILIO 24 | Alacant/Alicante |
5 | Laboratorio | 199987111 | GONZALEZ PEREZ | SARA | HERMANOS LOPEZ SANTOS 87 | Elx/Elche |
5 | Laboratorio | 524389017 | LOPEZ MARTINEZ | ALEJANDRO | EINSTEIN 51 | Alacant/Alicante |
5 | Laboratorio | 334122262 | LOPEZ PEREZ | RAUL | DIPUTADO JUAN A. RODRIGUEZ MARIN 90 | Alacant/Alicante |
5 | Laboratorio | 641842643 | MARTINEZ GONZALEZ | SARA | GENT DE L'ARCADA 97 | Elx/Elche |
5 | Laboratorio | 882918997 | MARTINEZ MARTINEZ | DAVID | DOCTOR GASCUÑANA HERNANDO,Plaza 16 | Alacant/Alicante |
5 | Laboratorio | 704443637 | MARTINEZ RODRIGUEZ | CARLOS | SAN JUAN BAUTISTA 6 | Benidorm |
5 | Laboratorio | 559375400 | MARTINEZ RODRIGUEZ | DAVID | MOSEN FENOLLAR 44 | Alacant/Alicante |
5 | Laboratorio | 337067689 | PEREZ FERNANDEZ | LUCIA | COLON 38 | Alcoi/Alcoy |
5 | Laboratorio | 319011133 | PEREZ GONZALEZ | JORGE | PELAYO 7 | Alacant/Alicante |
5 | Laboratorio | 576759100 | PEREZ MARTINEZ | SERGIO | FRANCISCO VICENTE RODRIGUEZ 92 | Elx/Elche |
5 | Laboratorio | 297471657 | PEREZ PEREZ | ALEJANDRO | JILGUERO 14 | Alacant/Alicante |
5 | Laboratorio | 339230598 | RODRIGUEZ RODRIGUEZ | PABLO | LLIRIET D'EN MIG,Partida 60 | Benidorm |
5 | Laboratorio | 173295200 | SANCHEZ FERNANDEZ | ADRIAN | ABADIA 75 | Elx/Elche |
5 | Laboratorio | 999004293 | SANCHEZ LOPEZ | MARINA | CATEDRATICO LEVERONI 30 | Alacant/Alicante |
5 | Laboratorio | 691093012 | SANCHEZ PEREZ | MARTA | LLOMA, LA,Urbanizacion 31 | Benidorm |
5 | Laboratorio | 931647555 | SANCHEZ RODRIGUEZ | JAVIER | EUCALIPTUS 103 | Elx/Elche |
5 | Laboratorio | 279481791 | SANCHEZ RODRIGUEZ | ADRIAN | MUSICO PEPICO VAELLO 78 | Elx/Elche |
4 | Matrona | 132625152 | FERNANDEZ PEREZ | ANTONIO | CREVILLENTE,Plaza (Impares del 5 al final) (Pares | Elx/Elche |
4 | Matrona | 340356147 | FERNANDEZ SANCHEZ | ANDREA | JUAN GIL ALBERT 17 | Alcoi/Alcoy |
4 | Matrona | 985550808 | GARCIA FERNANDEZ | CARLOS | PARDO GIMENO 87 | Alacant/Alicante |
4 | Matrona | 787356870 | GONZALEZ LOPEZ | MARTA | DINS, DE 19 | Alcoi/Alcoy |
4 | Matrona | 735949716 | GONZALEZ LOPEZ | ANTONIO | VIRGEN DEL PUIG 106 | Alacant/Alicante |
4 | Matrona | 675642697 | LOPEZ PEREZ | ANDREA | CARME, DEL 27 | Alcoi/Alcoy |
4 | Matrona | 281729181 | LOPEZ RODRIGUEZ | SERGIO | ONDARA 15 | Alacant/Alicante |
4 | Matrona | 403739660 | MARTINEZ GONZALEZ | ANTONIO | PASEITO RAMIRO,Plaza 37 | Alacant/Alicante |
4 | Matrona | 197727380 | MARTINEZ MARTINEZ | ADRIAN | FOGUERER JOSE ANGEL GUIRAO 79 | Alacant/Alicante |
4 | Matrona | 802130340 | MARTINEZ SANCHEZ | MARINA | ROMULO 71 | Alacant/Alicante |
4 | Matrona | 381885135 | MARTINEZ SANCHEZ | DIEGO | JACINTO BENAVENTE 46 | Alacant/Alicante |
4 | Matrona | 933560487 | PEREZ FERNANDEZ | MARIO | CATEDRATICO FERRE VIDIELLA 57 | Alacant/Alicante |
4 | Matrona | 436654463 | RODRIGUEZ FERNANDEZ | ANA | GIRASOLES, LOS 48 | Benidorm |
4 | Matrona | 157494515 | RODRIGUEZ GARCIA | PABLO | BULGARIA 65 | Benidorm |
4 | Matrona | 301378669 | SANCHEZ FERNANDEZ | LUCIA | DOCTOR SAPENA (Impares del 71 al final) (Pares | Elx/Elche |
4 | Matrona | 181086011 | SANCHEZ GONZALEZ | NEREA | MARINA, DE LA,Carretera 17 | Elx/Elche |
4 | Matrona | 970942180 | SANCHEZ LOPEZ | CARLOS | ENRIQUETA ELIZAICIN 100 | Alacant/Alicante |
4 | Matrona | 886716664 | SANCHEZ SANCHEZ | JAVIER | CORINDON 4 | Alacant/Alicante |
4 | Matrona | 660206358 | SANCHEZ SANCHEZ | LAURA | CALA, DE LA 109 | Benidorm |
4 | Matrona | 680264714 | SANCHEZ SANCHEZ | RAUL | DOCTOR SANTA OLALLA 96 | Alacant/Alicante |
2 | Oncologo | 187770287 | FERNANDEZ GARCIA | MIGUEL | DOCTOR GIMENEZ DIAZ 6 | Alacant/Alicante |
2 | Oncologo | 937368276 | GARCIA GARCIA | ALVARO | SANG, LA 96 | Alcoi/Alcoy |
2 | Oncologo | 677198881 | GONZALEZ PEREZ | ANDREA | PASCUAL DE LA MATA 15 | Alacant/Alicante |
2 | Oncologo | 736193481 | GONZALEZ RODRIGUEZ | SERGIO | REDES 51 | Alacant/Alicante |
2 | Oncologo | 362155170 | LOPEZ MARTINEZ | RAUL | AUSO Y MONZO 45 | Alacant/Alicante |
2 | Oncologo | 579476094 | MARTINEZ GONZALEZ | CARLOS | TORERO JOSE MARIA MANZANARES 13 | Alacant/Alicante |
2 | Oncologo | 953730361 | MARTINEZ PEREZ | SARA | ANTONIO GOMIS VICENTE 60 | Elx/Elche |
2 | Oncologo | 990694733 | PEREZ GARCIA | ANTONIO | OVIEDO,Avenida 5 | Alacant/Alicante |
2 | Oncologo | 189610677 | PEREZ PEREZ | MARTA | ALFONSO GUIXOT 12 | Alacant/Alicante |
2 | Oncologo | 262412385 | PEREZ RODRIGUEZ | LUCIA | GRECIA 100 | Benidorm |
2 | Oncologo | 109296556 | PEREZ RODRIGUEZ | ALBA | ARTILLEROS 58 | Alacant/Alicante |
2 | Oncologo | 177434790 | RODRIGUEZ MARTINEZ | MANUEL | MILLENA 92 | Alacant/Alicante |
2 | Oncologo | 351939151 | SANCHEZ FERNANDEZ | JAVIER | JUANA FRANCES, DE 102 | Alacant/Alicante |
100 filas (de 166) seleccionadas
P04.009- Toda la información de los diagnósticos y de los historiales a los que pertenecen.
id | grupo_sanguineo | observaciones | vacunas | alergias | idH | idL | descripcion |
---|---|---|---|---|---|---|---|
361174 | A+ | ENFERMO DE CORAZON | HEPATITIS B | PLATA | 361174 | 1 | Neumotorax |
361174 | A+ | ENFERMO DE CORAZON | HEPATITIS B | PLATA | 361174 | 2 | Eritremia crónica |
361174 | A+ | ENFERMO DE CORAZON | HEPATITIS B | PLATA | 361174 | 3 | Neumotorax |
361174 | A+ | ENFERMO DE CORAZON | HEPATITIS B | PLATA | 361174 | 4 | Neumonia bilateral |
411812 | B+ | DIABETES | SIN VACUNA | ALERGIA NO DETECTADA | 411812 | 1 | Dermatitis facticia |
419273 | AB | ENFERMO DE CORAZON | VARICELA | SULFAMIDAS | 419273 | 1 | Herpes zóster |
479406 | A+ | ARRITMIA | RABIA | ALERGIA NO DETECTADA | 479406 | 1 | Herpes zóster |
479406 | A+ | ARRITMIA | RABIA | ALERGIA NO DETECTADA | 479406 | 2 | Condromalacia, hombro derecho |
509223 | AB | ENFERMO DE CORAZON | RABIA | PLATA | 509223 | 1 | Osteoporosis |
641270 | A- | CANCER | HEPATITIS A | SULFAMIDAS | 641270 | 1 | Rotura de quiste sinovial |
641270 | A- | CANCER | HEPATITIS A | SULFAMIDAS | 641270 | 2 | Lupus eritematoso sistémico |
680328 | B- | HIPERTENSION | SIN VACUNA | PLATA | 680328 | 1 | Artrosis primaria, hombro izquierdo |
680328 | B- | HIPERTENSION | SIN VACUNA | PLATA | 680328 | 2 | Esguince pie derecho |
718153 | AB | ARRITMIA | HEPATITIS A | SULFAMIDAS | 718153 | 1 | Eritremia crónica |
14 filas (de 14) seleccionadas
P04.010- Toda la información de los diagnósticos, fecha, y número de colegiado del médico que firma ese diagnóstico.
idH | idL | descripcion | fecha | idMedico |
---|---|---|---|---|
361174 | 1 | Neumotorax | 2014-05-11 | 100012029 |
361174 | 2 | Eritremia crónica | 2014-05-11 | 000000004 |
361174 | 3 | Neumotorax | 2014-05-11 | 000000004 |
361174 | 4 | Neumonia bilateral | 2020-10-02 | 100012029 |
411812 | 1 | Dermatitis facticia | 2014-05-14 | 000000001 |
419273 | 1 | Herpes zóster | 2014-05-11 | 000000004 |
479406 | 1 | Herpes zóster | 2014-05-15 | 000000001 |
479406 | 2 | Condromalacia, hombro derecho | 2014-05-15 | 000000001 |
509223 | 1 | Osteoporosis | 2014-05-11 | 101650695 |
641270 | 1 | Rotura de quiste sinovial | 2014-05-18 | 000000001 |
641270 | 2 | Lupus eritematoso sistémico | 2014-05-18 | 000000001 |
680328 | 1 | Artrosis primaria, hombro izquierdo | 2014-05-14 | 000000001 |
680328 | 2 | Esguince pie derecho | 2014-05-14 | 000000001 |
718153 | 1 | Eritremia crónica | 2014-05-13 | 000000004 |
14 filas (de 14) seleccionadas
P04.011- Toda la información de los diagnósticos, fecha, y número de colegiado, apellidos y nombre del médico que firma ese diagnóstico.
idH | idL | descripcion | fecha | idMedico | apellidos | nombre |
---|---|---|---|---|---|---|
361174 | 1 | Neumotorax | 2014-05-11 | 100012029 | PEREZ SANCHEZ | ADRIAN |
361174 | 2 | Eritremia crónica | 2014-05-11 | 000000004 | Martinez Avila | Nora |
361174 | 3 | Neumotorax | 2014-05-11 | 000000004 | Martinez Avila | Nora |
361174 | 4 | Neumonia bilateral | 2020-10-02 | 100012029 | PEREZ SANCHEZ | ADRIAN |
411812 | 1 | Dermatitis facticia | 2014-05-14 | 000000001 | Gomez Rico | Juan |
419273 | 1 | Herpes zóster | 2014-05-11 | 000000004 | Martinez Avila | Nora |
479406 | 1 | Herpes zóster | 2014-05-15 | 000000001 | Gomez Rico | Juan |
479406 | 2 | Condromalacia, hombro derecho | 2014-05-15 | 000000001 | Gomez Rico | Juan |
509223 | 1 | Osteoporosis | 2014-05-11 | 101650695 | RODRIGUEZ RODRIGUEZ | ANA |
641270 | 1 | Rotura de quiste sinovial | 2014-05-18 | 000000001 | Gomez Rico | Juan |
641270 | 2 | Lupus eritematoso sistémico | 2014-05-18 | 000000001 | Gomez Rico | Juan |
680328 | 1 | Artrosis primaria, hombro izquierdo | 2014-05-14 | 000000001 | Gomez Rico | Juan |
680328 | 2 | Esguince pie derecho | 2014-05-14 | 000000001 | Gomez Rico | Juan |
718153 | 1 | Eritremia crónica | 2014-05-13 | 000000004 | Martinez Avila | Nora |
14 filas (de 14) seleccionadas
P04.012- Toda la información de los diagnósticos, fecha, y número de colegiado, apellidos y nombre del médico que firma ese diagnóstico, y SIP, apellidos y nombre del paciente.
idH | idL | descripcion | fecha | idMedico | apellidos | nombre | sip paciente | apellidos | nombre |
---|---|---|---|---|---|---|---|---|---|
361174 | 1 | Neumotorax | 2014-05-11 | 100012029 | PEREZ SANCHEZ | ADRIAN | 5655779 | RUIZ RAMIREZ | NURIA |
361174 | 2 | Eritremia crónica | 2014-05-11 | 000000004 | Martinez Avila | Nora | 5655779 | RUIZ RAMIREZ | NURIA |
361174 | 3 | Neumotorax | 2014-05-11 | 000000004 | Martinez Avila | Nora | 5655779 | RUIZ RAMIREZ | NURIA |
361174 | 4 | Neumonia bilateral | 2020-10-02 | 100012029 | PEREZ SANCHEZ | ADRIAN | 5655779 | RUIZ RAMIREZ | NURIA |
411812 | 1 | Dermatitis facticia | 2014-05-14 | 000000001 | Gomez Rico | Juan | 9999996 | DIAZ LOPEZ | LAURA |
419273 | 1 | Herpes zóster | 2014-05-11 | 000000004 | Martinez Avila | Nora | 1001827 | DIAZ MARTINEZ | NURIA |
479406 | 1 | Herpes zóster | 2014-05-15 | 000000001 | Gomez Rico | Juan | 1035835 | RUIZ JIMENEZ | CARLOS |
479406 | 2 | Condromalacia, hombro derecho | 2014-05-15 | 000000001 | Gomez Rico | Juan | 1035835 | RUIZ JIMENEZ | CARLOS |
509223 | 1 | Osteoporosis | 2014-05-11 | 101650695 | RODRIGUEZ RODRIGUEZ | ANA | 1234043 | RUIZ JIMENEZ | CARLOS |
641270 | 1 | Rotura de quiste sinovial | 2014-05-18 | 000000001 | Gomez Rico | Juan | 1000007 | SANCHEZ MARTINEZ | CLAUDIA |
641270 | 2 | Lupus eritematoso sistémico | 2014-05-18 | 000000001 | Gomez Rico | Juan | 1000007 | SANCHEZ MARTINEZ | CLAUDIA |
680328 | 1 | Artrosis primaria, hombro izquierdo | 2014-05-14 | 000000001 | Gomez Rico | Juan | 1076874 | LOPEZ GARCIA | LAURA |
680328 | 2 | Esguince pie derecho | 2014-05-14 | 000000001 | Gomez Rico | Juan | 1076874 | LOPEZ GARCIA | LAURA |
718153 | 1 | Eritremia crónica | 2014-05-13 | 000000004 | Martinez Avila | Nora | 1000035 | RODRIGUEZ RODRIGUEZ | MARIA |
14 filas (de 14) seleccionadas
P04.013- SIP, apellidos y nombre de paciente, y medicación prescrita en cualquier tratamiento que haya tenido.
sip | apellidos | nombre | medicacion |
---|---|---|---|
5655779 | RUIZ RAMIREZ | NURIA | vendarle la mano |
1076874 | LOPEZ GARCIA | LAURA | atorvastatina 40mg |
1000035 | RODRIGUEZ RODRIGUEZ | MARIA | atorvastatina 20mg |
3 filas (de 3) seleccionadas
P04.014- SIP, apellidos y nombre de paciente, fecha y medicación prescrita en cualquier tratamiento que haya tenido.
sip | apellidos | nombre | medicacion | fecha |
---|---|---|---|---|
5655779 | RUIZ RAMIREZ | NURIA | vendarle la mano | 2014-05-11 |
1076874 | LOPEZ GARCIA | LAURA | atorvastatina 40mg | 2024-10-11 |
1000035 | RODRIGUEZ RODRIGUEZ | MARIA | atorvastatina 20mg | 2024-10-11 |
3 filas (de 3) seleccionadas
P04.015- Número de colegiado,nif,apellidos y nombre de los trabajadores de la ciudad de Benidorm.
colegiado | nif | apellidos | nombre |
---|---|---|---|
142491310 | 52158913V | SANZ CALVO | RUBEN |
143233502 | 69230351K | RODRIGUEZ FERNANDEZ | MIGUEL |
152496629 | 66989208V | GARCIA LOPEZ | CRISTINA |
153175673 | 10398988F | PEREZ PEREZ | NEREA |
153900646 | 52785126K | HIDALGO ROMAN | JORDI |
157494515 | 24151350D | RODRIGUEZ GARCIA | PABLO |
174357378 | 74092160F | VAZQUEZ DIAZ | JOEL |
189198737 | 44995399G | SANZ ORTIZ | ALEX |
195314361 | 57449749M | BLANCO SUAREZ | RAFAEL |
196351646 | 36386473B | DELGADO RUIZ | SERGI |
211673044 | 28722534N | CASTRO RUBIO | MARIA JOSE |
224916652 | 93934252V | RODRIGUEZ MARTINEZ | ANA |
226699597 | 31376074P | SANTIAGO MARQUEZ | ANDREA |
228375795 | 45653101E | LOPEZ DIEZ | LUIS MIGUEL |
230106801 | 84932912U | PEREZ GARCIA | LAURA |
249957149 | 62183460L | MARIN MOLINA | CELIA |
251471514 | 46738171M | VAZQUEZ SANCHEZ | MARINA |
251486333 | 40618139D | DIAZ MARQUEZ | JOEL |
256535991 | 14332263Y | SUAREZ BLANCO | JORGE |
261188521 | 51429060W | SANTIAGO CARRASCO | ERIK |
262412385 | 40523083I | PEREZ RODRIGUEZ | LUCIA |
277593740 | 43821720H | ROMERO RUBIO | JORGE |
281304312 | 88637955T | CALVO FERNANDEZ | SEBASTIAN |
282829566 | 80564633L | LEON PEREZ | PAULA |
284420561 | 40607128I | VAZQUEZ GIL | ALEJANDRA |
289865769 | 13275831U | CORTES MEDINA | JUAN FRANCISCO |
292358252 | 26985673J | MARIN CARRASCO | JUAN FRANCISCO |
315542103 | 72537656I | MOLINA GOMEZ | ALBERTO |
317890272 | 43497416P | FERNANDEZ RODRIGUEZ | MARIO |
321597215 | 84711909H | JIMENEZ VEGA | SUSANA |
339230598 | 32819421E | RODRIGUEZ RODRIGUEZ | PABLO |
393062785 | 74360330L | SUAREZ BLANCO | FRANCISCO JAVIER |
393960434 | 32341314E | FERNANDEZ FERNANDEZ | JORGE |
397298547 | 44108898D | CRESPO PRIETO | FRANCISCO JAVIER |
401487862 | 84072888U | IGLESIAS CASTILLO | ANA BELEN |
427191935 | 56302430E | MOYA PRIETO | SARA |
428089040 | 14571087I | GONZALEZ SANCHEZ | SERGIO |
436654463 | 87894510E | RODRIGUEZ FERNANDEZ | ANA |
449689932 | 65329725H | GUTIERREZ ORTIZ | VALERIA |
458297114 | 29792878G | SANTANA MARTIN | DIEGO |
463074472 | 65978776B | NUÑEZ MOYA | PAU |
465595517 | 76846195V | VAZQUEZ SUAREZ | ROCIO |
476882398 | 82379861M | GARCIA PEREZ | MARINA |
479892369 | 61968503W | BENITEZ DURAN | JOSE CARLOS |
488637974 | 26029992H | MUÑOZ GOMEZ | MATEO |
517946941 | 90216388A | GIL SANZ | LORENA |
525853527 | 93227775X | SOLER MUÑOZ | MARIA DEL MAR |
530721450 | 76877305P | RAMIREZ DELGADO | NEREA |
539008927 | 59929432L | FERNANDEZ RODRIGUEZ | ADRIAN |
542859471 | 88298770M | FERNANDEZ MARTINEZ | DANIEL |
558926508 | 23449103T | MOLINA DELGADO | LAURA |
561597610 | 93278282O | ROMAN CASTRO | MARKEL |
593465179 | 17731459T | FERNANDEZ FERNANDEZ | MARIO |
612321516 | 15465233F | CANO MENDEZ | KEVIN |
612960332 | 77294518X | GARCIA PEREZ | MANUEL |
626608499 | 58549039A | PARRA AGUILAR | JUAN CARLOS |
641296109 | 27612710U | GARCIA MARTINEZ | JAVIER |
657814129 | 32052654T | JIMENEZ SANCHEZ | IRENE |
660206358 | 88280446F | SANCHEZ SANCHEZ | LAURA |
671048150 | 73685901B | RUIZ TORRES | MARKEL |
675216965 | 18936000S | SERRANO GALLEGO | YERAY |
675511506 | 66155273V | MUÑOZ DIAZ | VERONICA |
680580898 | 12741408X | HERNANDEZ GOMEZ | NOA |
691093012 | 54919601A | SANCHEZ PEREZ | MARTA |
693206330 | 84129572L | NUÑEZ HERNANDEZ | MARC |
704443637 | 79244688D | MARTINEZ RODRIGUEZ | CARLOS |
712753842 | 88907464E | RODRIGUEZ LOPEZ | LUCIA |
715644906 | 29742142Y | NUÑEZ GOMEZ | VICTOR |
736251417 | 67569343Y | RUBIO RAMOS | SANDRA |
739815778 | 95598059P | SANCHEZ GIL | BEATRIZ |
745359549 | 47289142C | FERNANDEZ RODRIGUEZ | SERGIO |
748827365 | 62195610D | ROMERO CALVO | MARIONA |
751476100 | 87881443W | BLANCO ALVAREZ | ANGEL |
753431539 | 60990290N | SANTANA MEDINA | RUTH |
755633171 | 54014441G | GONZALEZ GONZALEZ | DIEGO |
798900636 | 21739274C | LORENZO HERRERO | PABLO |
801537693 | 78922529G | PEREZ CASTRO | LUCIA |
806150249 | 86111966K | MARTINEZ RAMIREZ | JOEL |
820182020 | 16995826S | SANCHEZ FERNANDEZ | PABLO |
825912285 | 86117957O | SANZ VAZQUEZ | ARNAU |
846061325 | 81786549K | MARTINEZ PEREZ | ANDREA |
848828464 | 57315790L | DIAZ RUBIO | JULIA |
880590042 | 88543790G | PEREZ FERNANDEZ | SERGIO |
941088537 | 80091864T | BRAVO GIMENEZ | CARLES |
941887273 | 13753413N | FERNANDEZ VAZQUEZ | ANA |
943036928 | 88915424O | MUÑOZ RUIZ | RODRIGO |
955299356 | 23139992K | DIAZ RUIZ | SARA |
970230947 | 58086563U | BLANCO VAZQUEZ | PEDRO |
971865175 | 98883929Z | HERRERA ALVAREZ | SANDRA |
972579291 | 47818186S | FERNANDEZ FERNANDEZ | JAVIER |
984332472 | 28096321Q | PEREZ GARCIA | JAVIER |
990566872 | 68304778I | GIMENEZ SUAREZ | JUAN MANUEL |
92 filas (de 92) seleccionadas
P04.016- Número de colegiado,nif,apellidos y nombre de los trabajadores de la ciudad de Benidorm, e identificador del turno que tengan asignado.
colegiado | nif | apellidos | nombre | idturno |
---|---|---|---|---|
142491310 | 52158913V | SANZ CALVO | RUBEN | 3 |
143233502 | 69230351K | RODRIGUEZ FERNANDEZ | MIGUEL | 3 |
152496629 | 66989208V | GARCIA LOPEZ | CRISTINA | 5 |
153175673 | 10398988F | PEREZ PEREZ | NEREA | 1 |
153900646 | 52785126K | HIDALGO ROMAN | JORDI | 1 |
157494515 | 24151350D | RODRIGUEZ GARCIA | PABLO | 3 |
174357378 | 74092160F | VAZQUEZ DIAZ | JOEL | 1 |
189198737 | 44995399G | SANZ ORTIZ | ALEX | 7 |
195314361 | 57449749M | BLANCO SUAREZ | RAFAEL | 1 |
196351646 | 36386473B | DELGADO RUIZ | SERGI | 8 |
211673044 | 28722534N | CASTRO RUBIO | MARIA JOSE | 9 |
224916652 | 93934252V | RODRIGUEZ MARTINEZ | ANA | 1 |
226699597 | 31376074P | SANTIAGO MARQUEZ | ANDREA | 8 |
228375795 | 45653101E | LOPEZ DIEZ | LUIS MIGUEL | 4 |
249957149 | 62183460L | MARIN MOLINA | CELIA | 9 |
251471514 | 46738171M | VAZQUEZ SANCHEZ | MARINA | 8 |
251486333 | 40618139D | DIAZ MARQUEZ | JOEL | 9 |
256535991 | 14332263Y | SUAREZ BLANCO | JORGE | 2 |
261188521 | 51429060W | SANTIAGO CARRASCO | ERIK | 8 |
262412385 | 40523083I | PEREZ RODRIGUEZ | LUCIA | 8 |
277593740 | 43821720H | ROMERO RUBIO | JORGE | 4 |
281304312 | 88637955T | CALVO FERNANDEZ | SEBASTIAN | 1 |
282829566 | 80564633L | LEON PEREZ | PAULA | 6 |
284420561 | 40607128I | VAZQUEZ GIL | ALEJANDRA | 6 |
289865769 | 13275831U | CORTES MEDINA | JUAN FRANCISCO | 8 |
292358252 | 26985673J | MARIN CARRASCO | JUAN FRANCISCO | 8 |
315542103 | 72537656I | MOLINA GOMEZ | ALBERTO | 5 |
317890272 | 43497416P | FERNANDEZ RODRIGUEZ | MARIO | 1 |
321597215 | 84711909H | JIMENEZ VEGA | SUSANA | 2 |
339230598 | 32819421E | RODRIGUEZ RODRIGUEZ | PABLO | 7 |
393062785 | 74360330L | SUAREZ BLANCO | FRANCISCO JAVIER | 3 |
393960434 | 32341314E | FERNANDEZ FERNANDEZ | JORGE | 8 |
397298547 | 44108898D | CRESPO PRIETO | FRANCISCO JAVIER | 5 |
401487862 | 84072888U | IGLESIAS CASTILLO | ANA BELEN | 3 |
427191935 | 56302430E | MOYA PRIETO | SARA | 5 |
436654463 | 87894510E | RODRIGUEZ FERNANDEZ | ANA | 4 |
449689932 | 65329725H | GUTIERREZ ORTIZ | VALERIA | 5 |
458297114 | 29792878G | SANTANA MARTIN | DIEGO | 8 |
463074472 | 65978776B | NUÑEZ MOYA | PAU | 2 |
465595517 | 76846195V | VAZQUEZ SUAREZ | ROCIO | 5 |
476882398 | 82379861M | GARCIA PEREZ | MARINA | 7 |
479892369 | 61968503W | BENITEZ DURAN | JOSE CARLOS | 8 |
488637974 | 26029992H | MUÑOZ GOMEZ | MATEO | 6 |
517946941 | 90216388A | GIL SANZ | LORENA | 4 |
525853527 | 93227775X | SOLER MUÑOZ | MARIA DEL MAR | 9 |
530721450 | 76877305P | RAMIREZ DELGADO | NEREA | 5 |
539008927 | 59929432L | FERNANDEZ RODRIGUEZ | ADRIAN | 6 |
542859471 | 88298770M | FERNANDEZ MARTINEZ | DANIEL | 1 |
558926508 | 23449103T | MOLINA DELGADO | LAURA | 2 |
561597610 | 93278282O | ROMAN CASTRO | MARKEL | 5 |
593465179 | 17731459T | FERNANDEZ FERNANDEZ | MARIO | 9 |
612321516 | 15465233F | CANO MENDEZ | KEVIN | 6 |
612960332 | 77294518X | GARCIA PEREZ | MANUEL | 9 |
626608499 | 58549039A | PARRA AGUILAR | JUAN CARLOS | 2 |
641296109 | 27612710U | GARCIA MARTINEZ | JAVIER | 8 |
657814129 | 32052654T | JIMENEZ SANCHEZ | IRENE | 3 |
660206358 | 88280446F | SANCHEZ SANCHEZ | LAURA | 8 |
671048150 | 73685901B | RUIZ TORRES | MARKEL | 9 |
675216965 | 18936000S | SERRANO GALLEGO | YERAY | 5 |
675511506 | 66155273V | MUÑOZ DIAZ | VERONICA | 8 |
680580898 | 12741408X | HERNANDEZ GOMEZ | NOA | 2 |
691093012 | 54919601A | SANCHEZ PEREZ | MARTA | 5 |
693206330 | 84129572L | NUÑEZ HERNANDEZ | MARC | 8 |
704443637 | 79244688D | MARTINEZ RODRIGUEZ | CARLOS | 2 |
712753842 | 88907464E | RODRIGUEZ LOPEZ | LUCIA | 1 |
715644906 | 29742142Y | NUÑEZ GOMEZ | VICTOR | 1 |
736251417 | 67569343Y | RUBIO RAMOS | SANDRA | 3 |
739815778 | 95598059P | SANCHEZ GIL | BEATRIZ | 9 |
745359549 | 47289142C | FERNANDEZ RODRIGUEZ | SERGIO | 1 |
748827365 | 62195610D | ROMERO CALVO | MARIONA | 1 |
751476100 | 87881443W | BLANCO ALVAREZ | ANGEL | 2 |
753431539 | 60990290N | SANTANA MEDINA | RUTH | 4 |
755633171 | 54014441G | GONZALEZ GONZALEZ | DIEGO | 4 |
798900636 | 21739274C | LORENZO HERRERO | PABLO | 8 |
801537693 | 78922529G | PEREZ CASTRO | LUCIA | 6 |
806150249 | 86111966K | MARTINEZ RAMIREZ | JOEL | 8 |
820182020 | 16995826S | SANCHEZ FERNANDEZ | PABLO | 7 |
825912285 | 86117957O | SANZ VAZQUEZ | ARNAU | 6 |
846061325 | 81786549K | MARTINEZ PEREZ | ANDREA | 9 |
848828464 | 57315790L | DIAZ RUBIO | JULIA | 9 |
880590042 | 88543790G | PEREZ FERNANDEZ | SERGIO | 6 |
941088537 | 80091864T | BRAVO GIMENEZ | CARLES | 1 |
941887273 | 13753413N | FERNANDEZ VAZQUEZ | ANA | 3 |
943036928 | 88915424O | MUÑOZ RUIZ | RODRIGO | 6 |
955299356 | 23139992K | DIAZ RUIZ | SARA | 8 |
970230947 | 58086563U | BLANCO VAZQUEZ | PEDRO | 3 |
971865175 | 98883929Z | HERRERA ALVAREZ | SANDRA | 9 |
972579291 | 47818186S | FERNANDEZ FERNANDEZ | JAVIER | 9 |
984332472 | 28096321Q | PEREZ GARCIA | JAVIER | 7 |
990566872 | 68304778I | GIMENEZ SUAREZ | JUAN MANUEL | 5 |
90 filas (de 90) seleccionadas
P04.017- Número de colegiado,nif,apellidos y nombre de los trabajadores de la ciudad de Benidorm, e identificador y tipo del turno que tengan asignado.
colegiado | nif | apellidos | nombre | idturno | tipo |
---|---|---|---|---|---|
142491310 | 52158913V | SANZ CALVO | RUBEN | 3 | Noche |
143233502 | 69230351K | RODRIGUEZ FERNANDEZ | MIGUEL | 3 | Noche |
152496629 | 66989208V | GARCIA LOPEZ | CRISTINA | 5 | Tarde |
153175673 | 10398988F | PEREZ PEREZ | NEREA | 1 | Mañana |
153900646 | 52785126K | HIDALGO ROMAN | JORDI | 1 | Mañana |
157494515 | 24151350D | RODRIGUEZ GARCIA | PABLO | 3 | Noche |
174357378 | 74092160F | VAZQUEZ DIAZ | JOEL | 1 | Mañana |
189198737 | 44995399G | SANZ ORTIZ | ALEX | 7 | Mañana |
195314361 | 57449749M | BLANCO SUAREZ | RAFAEL | 1 | Mañana |
196351646 | 36386473B | DELGADO RUIZ | SERGI | 8 | Tarde |
211673044 | 28722534N | CASTRO RUBIO | MARIA JOSE | 9 | Noche |
224916652 | 93934252V | RODRIGUEZ MARTINEZ | ANA | 1 | Mañana |
226699597 | 31376074P | SANTIAGO MARQUEZ | ANDREA | 8 | Tarde |
228375795 | 45653101E | LOPEZ DIEZ | LUIS MIGUEL | 4 | Mañana |
249957149 | 62183460L | MARIN MOLINA | CELIA | 9 | Noche |
251471514 | 46738171M | VAZQUEZ SANCHEZ | MARINA | 8 | Tarde |
251486333 | 40618139D | DIAZ MARQUEZ | JOEL | 9 | Noche |
256535991 | 14332263Y | SUAREZ BLANCO | JORGE | 2 | Tarde |
261188521 | 51429060W | SANTIAGO CARRASCO | ERIK | 8 | Tarde |
262412385 | 40523083I | PEREZ RODRIGUEZ | LUCIA | 8 | Tarde |
277593740 | 43821720H | ROMERO RUBIO | JORGE | 4 | Mañana |
281304312 | 88637955T | CALVO FERNANDEZ | SEBASTIAN | 1 | Mañana |
282829566 | 80564633L | LEON PEREZ | PAULA | 6 | Noche |
284420561 | 40607128I | VAZQUEZ GIL | ALEJANDRA | 6 | Noche |
289865769 | 13275831U | CORTES MEDINA | JUAN FRANCISCO | 8 | Tarde |
292358252 | 26985673J | MARIN CARRASCO | JUAN FRANCISCO | 8 | Tarde |
315542103 | 72537656I | MOLINA GOMEZ | ALBERTO | 5 | Tarde |
317890272 | 43497416P | FERNANDEZ RODRIGUEZ | MARIO | 1 | Mañana |
321597215 | 84711909H | JIMENEZ VEGA | SUSANA | 2 | Tarde |
339230598 | 32819421E | RODRIGUEZ RODRIGUEZ | PABLO | 7 | Mañana |
393062785 | 74360330L | SUAREZ BLANCO | FRANCISCO JAVIER | 3 | Noche |
393960434 | 32341314E | FERNANDEZ FERNANDEZ | JORGE | 8 | Tarde |
397298547 | 44108898D | CRESPO PRIETO | FRANCISCO JAVIER | 5 | Tarde |
401487862 | 84072888U | IGLESIAS CASTILLO | ANA BELEN | 3 | Noche |
427191935 | 56302430E | MOYA PRIETO | SARA | 5 | Tarde |
436654463 | 87894510E | RODRIGUEZ FERNANDEZ | ANA | 4 | Mañana |
449689932 | 65329725H | GUTIERREZ ORTIZ | VALERIA | 5 | Tarde |
458297114 | 29792878G | SANTANA MARTIN | DIEGO | 8 | Tarde |
463074472 | 65978776B | NUÑEZ MOYA | PAU | 2 | Tarde |
465595517 | 76846195V | VAZQUEZ SUAREZ | ROCIO | 5 | Tarde |
476882398 | 82379861M | GARCIA PEREZ | MARINA | 7 | Mañana |
479892369 | 61968503W | BENITEZ DURAN | JOSE CARLOS | 8 | Tarde |
488637974 | 26029992H | MUÑOZ GOMEZ | MATEO | 6 | Noche |
517946941 | 90216388A | GIL SANZ | LORENA | 4 | Mañana |
525853527 | 93227775X | SOLER MUÑOZ | MARIA DEL MAR | 9 | Noche |
530721450 | 76877305P | RAMIREZ DELGADO | NEREA | 5 | Tarde |
539008927 | 59929432L | FERNANDEZ RODRIGUEZ | ADRIAN | 6 | Noche |
542859471 | 88298770M | FERNANDEZ MARTINEZ | DANIEL | 1 | Mañana |
558926508 | 23449103T | MOLINA DELGADO | LAURA | 2 | Tarde |
561597610 | 93278282O | ROMAN CASTRO | MARKEL | 5 | Tarde |
593465179 | 17731459T | FERNANDEZ FERNANDEZ | MARIO | 9 | Noche |
612321516 | 15465233F | CANO MENDEZ | KEVIN | 6 | Noche |
612960332 | 77294518X | GARCIA PEREZ | MANUEL | 9 | Noche |
626608499 | 58549039A | PARRA AGUILAR | JUAN CARLOS | 2 | Tarde |
641296109 | 27612710U | GARCIA MARTINEZ | JAVIER | 8 | Tarde |
657814129 | 32052654T | JIMENEZ SANCHEZ | IRENE | 3 | Noche |
660206358 | 88280446F | SANCHEZ SANCHEZ | LAURA | 8 | Tarde |
671048150 | 73685901B | RUIZ TORRES | MARKEL | 9 | Noche |
675216965 | 18936000S | SERRANO GALLEGO | YERAY | 5 | Tarde |
675511506 | 66155273V | MUÑOZ DIAZ | VERONICA | 8 | Tarde |
680580898 | 12741408X | HERNANDEZ GOMEZ | NOA | 2 | Tarde |
691093012 | 54919601A | SANCHEZ PEREZ | MARTA | 5 | Tarde |
693206330 | 84129572L | NUÑEZ HERNANDEZ | MARC | 8 | Tarde |
704443637 | 79244688D | MARTINEZ RODRIGUEZ | CARLOS | 2 | Tarde |
712753842 | 88907464E | RODRIGUEZ LOPEZ | LUCIA | 1 | Mañana |
715644906 | 29742142Y | NUÑEZ GOMEZ | VICTOR | 1 | Mañana |
736251417 | 67569343Y | RUBIO RAMOS | SANDRA | 3 | Noche |
739815778 | 95598059P | SANCHEZ GIL | BEATRIZ | 9 | Noche |
745359549 | 47289142C | FERNANDEZ RODRIGUEZ | SERGIO | 1 | Mañana |
748827365 | 62195610D | ROMERO CALVO | MARIONA | 1 | Mañana |
751476100 | 87881443W | BLANCO ALVAREZ | ANGEL | 2 | Tarde |
753431539 | 60990290N | SANTANA MEDINA | RUTH | 4 | Mañana |
755633171 | 54014441G | GONZALEZ GONZALEZ | DIEGO | 4 | Mañana |
798900636 | 21739274C | LORENZO HERRERO | PABLO | 8 | Tarde |
801537693 | 78922529G | PEREZ CASTRO | LUCIA | 6 | Noche |
806150249 | 86111966K | MARTINEZ RAMIREZ | JOEL | 8 | Tarde |
820182020 | 16995826S | SANCHEZ FERNANDEZ | PABLO | 7 | Mañana |
825912285 | 86117957O | SANZ VAZQUEZ | ARNAU | 6 | Noche |
846061325 | 81786549K | MARTINEZ PEREZ | ANDREA | 9 | Noche |
848828464 | 57315790L | DIAZ RUBIO | JULIA | 9 | Noche |
880590042 | 88543790G | PEREZ FERNANDEZ | SERGIO | 6 | Noche |
941088537 | 80091864T | BRAVO GIMENEZ | CARLES | 1 | Mañana |
941887273 | 13753413N | FERNANDEZ VAZQUEZ | ANA | 3 | Noche |
943036928 | 88915424O | MUÑOZ RUIZ | RODRIGO | 6 | Noche |
955299356 | 23139992K | DIAZ RUIZ | SARA | 8 | Tarde |
970230947 | 58086563U | BLANCO VAZQUEZ | PEDRO | 3 | Noche |
971865175 | 98883929Z | HERRERA ALVAREZ | SANDRA | 9 | Noche |
972579291 | 47818186S | FERNANDEZ FERNANDEZ | JAVIER | 9 | Noche |
984332472 | 28096321Q | PEREZ GARCIA | JAVIER | 7 | Mañana |
990566872 | 68304778I | GIMENEZ SUAREZ | JUAN MANUEL | 5 | Tarde |
90 filas (de 90) seleccionadas
P04.018- Número de colegiado,nif,apellidos y nombre de los enfermeros de la ciudad de Benidorm, e identificador y tipo del turno que tengan asignado.
colegiado | nif | apellidos | nombre | idturno | tipo |
---|---|---|---|---|---|
142491310 | 52158913V | SANZ CALVO | RUBEN | 3 | Noche |
153900646 | 52785126K | HIDALGO ROMAN | JORDI | 1 | Mañana |
174357378 | 74092160F | VAZQUEZ DIAZ | JOEL | 1 | Mañana |
189198737 | 44995399G | SANZ ORTIZ | ALEX | 7 | Mañana |
196351646 | 36386473B | DELGADO RUIZ | SERGI | 8 | Tarde |
211673044 | 28722534N | CASTRO RUBIO | MARIA JOSE | 9 | Noche |
226699597 | 31376074P | SANTIAGO MARQUEZ | ANDREA | 8 | Tarde |
228375795 | 45653101E | LOPEZ DIEZ | LUIS MIGUEL | 4 | Mañana |
249957149 | 62183460L | MARIN MOLINA | CELIA | 9 | Noche |
251471514 | 46738171M | VAZQUEZ SANCHEZ | MARINA | 8 | Tarde |
251486333 | 40618139D | DIAZ MARQUEZ | JOEL | 9 | Noche |
256535991 | 14332263Y | SUAREZ BLANCO | JORGE | 2 | Tarde |
261188521 | 51429060W | SANTIAGO CARRASCO | ERIK | 8 | Tarde |
277593740 | 43821720H | ROMERO RUBIO | JORGE | 4 | Mañana |
281304312 | 88637955T | CALVO FERNANDEZ | SEBASTIAN | 1 | Mañana |
282829566 | 80564633L | LEON PEREZ | PAULA | 6 | Noche |
284420561 | 40607128I | VAZQUEZ GIL | ALEJANDRA | 6 | Noche |
289865769 | 13275831U | CORTES MEDINA | JUAN FRANCISCO | 8 | Tarde |
292358252 | 26985673J | MARIN CARRASCO | JUAN FRANCISCO | 8 | Tarde |
315542103 | 72537656I | MOLINA GOMEZ | ALBERTO | 5 | Tarde |
321597215 | 84711909H | JIMENEZ VEGA | SUSANA | 2 | Tarde |
393062785 | 74360330L | SUAREZ BLANCO | FRANCISCO JAVIER | 3 | Noche |
397298547 | 44108898D | CRESPO PRIETO | FRANCISCO JAVIER | 5 | Tarde |
401487862 | 84072888U | IGLESIAS CASTILLO | ANA BELEN | 3 | Noche |
427191935 | 56302430E | MOYA PRIETO | SARA | 5 | Tarde |
449689932 | 65329725H | GUTIERREZ ORTIZ | VALERIA | 5 | Tarde |
458297114 | 29792878G | SANTANA MARTIN | DIEGO | 8 | Tarde |
463074472 | 65978776B | NUÑEZ MOYA | PAU | 2 | Tarde |
465595517 | 76846195V | VAZQUEZ SUAREZ | ROCIO | 5 | Tarde |
479892369 | 61968503W | BENITEZ DURAN | JOSE CARLOS | 8 | Tarde |
488637974 | 26029992H | MUÑOZ GOMEZ | MATEO | 6 | Noche |
517946941 | 90216388A | GIL SANZ | LORENA | 4 | Mañana |
525853527 | 93227775X | SOLER MUÑOZ | MARIA DEL MAR | 9 | Noche |
530721450 | 76877305P | RAMIREZ DELGADO | NEREA | 5 | Tarde |
558926508 | 23449103T | MOLINA DELGADO | LAURA | 2 | Tarde |
561597610 | 93278282O | ROMAN CASTRO | MARKEL | 5 | Tarde |
612321516 | 15465233F | CANO MENDEZ | KEVIN | 6 | Noche |
626608499 | 58549039A | PARRA AGUILAR | JUAN CARLOS | 2 | Tarde |
671048150 | 73685901B | RUIZ TORRES | MARKEL | 9 | Noche |
675216965 | 18936000S | SERRANO GALLEGO | YERAY | 5 | Tarde |
675511506 | 66155273V | MUÑOZ DIAZ | VERONICA | 8 | Tarde |
680580898 | 12741408X | HERNANDEZ GOMEZ | NOA | 2 | Tarde |
693206330 | 84129572L | NUÑEZ HERNANDEZ | MARC | 8 | Tarde |
715644906 | 29742142Y | NUÑEZ GOMEZ | VICTOR | 1 | Mañana |
736251417 | 67569343Y | RUBIO RAMOS | SANDRA | 3 | Noche |
739815778 | 95598059P | SANCHEZ GIL | BEATRIZ | 9 | Noche |
748827365 | 62195610D | ROMERO CALVO | MARIONA | 1 | Mañana |
751476100 | 87881443W | BLANCO ALVAREZ | ANGEL | 2 | Tarde |
753431539 | 60990290N | SANTANA MEDINA | RUTH | 4 | Mañana |
798900636 | 21739274C | LORENZO HERRERO | PABLO | 8 | Tarde |
801537693 | 78922529G | PEREZ CASTRO | LUCIA | 6 | Noche |
806150249 | 86111966K | MARTINEZ RAMIREZ | JOEL | 8 | Tarde |
825912285 | 86117957O | SANZ VAZQUEZ | ARNAU | 6 | Noche |
848828464 | 57315790L | DIAZ RUBIO | JULIA | 9 | Noche |
941088537 | 80091864T | BRAVO GIMENEZ | CARLES | 1 | Mañana |
941887273 | 13753413N | FERNANDEZ VAZQUEZ | ANA | 3 | Noche |
943036928 | 88915424O | MUÑOZ RUIZ | RODRIGO | 6 | Noche |
955299356 | 23139992K | DIAZ RUIZ | SARA | 8 | Tarde |
970230947 | 58086563U | BLANCO VAZQUEZ | PEDRO | 3 | Noche |
971865175 | 98883929Z | HERRERA ALVAREZ | SANDRA | 9 | Noche |
990566872 | 68304778I | GIMENEZ SUAREZ | JUAN MANUEL | 5 | Tarde |
61 filas (de 61) seleccionadas