DuckDB 1.1.3 · 2026-10-21 17:04:10


## -- 00. Cobertura de num_ofertas, oferta_min/max, ofertas_anormales y PBL. unified_20261018, adjudicaciones no 

| Count |
|---|
| 3224151 |

_0.9 s_

## 1. Por fuente (todas las fuentes con algún num_ofertas): % de lotes con cada dato

| source | lotes | pct_n | pct_min | pct_max | pct_min_y_max | pct_anormales | pct_pbl |
|---|---|---|---|---|---|---|---|
| PLACSP | 1644754 | 100 | 38.1 | 37.9 | 37.7 | 8.7 | 81 |
| CATALUNYA_PSCP | 556621 | 78.4 | 0 | 0 | 0 | 0 | 89.4 |
| TED | 347748 | 90.7 | 0 | 0 | 0 | 0 | 73.3 |
| EUSKADI | 60183 | 0.1 | 0 | 0 | 0 | 0 | 77 |
| VALENCIA | 48376 | 100 | 0 | 0 | 0 | 0 | 98.9 |
| MADRID_CAM | 41961 | 99.8 | 0 | 0 | 0 | 0 | 59.6 |
| MADRID_AYTO | 36581 | 24.1 | 0 | 0 | 0 | 0 | 94.7 |
| ARAGON | 26337 | 41.2 | 0 | 0 | 0 | 0 | 90.8 |
| CASTILLA_LEON | 23798 | 34.5 | 0 | 0 | 0 | 0 | 95.2 |
| EXTREMADURA | 9615 | 9.5 | 0 | 0 | 0 | 0 | 98.9 |

_0.0 s_

## 2. PLACSP por año

| anio | lotes | pct_n | pct_min | pct_max | pct_min_y_max | pct_anormales | pct_anormales_si | pct_pbl | n3_minmax |
|---|---|---|---|---|---|---|---|---|---|
| 2018 | 124772 | 100 | 16.5 | 16.1 | 15.9 | 5.6 | 7 | 71.6 | 8821 |
| 2019 | 168632 | 100 | 31.1 | 30.9 | 30.6 | 7.3 | 8.8 | 78.4 | 18774 |
| 2020 | 171244 | 100 | 31.8 | 31.4 | 31.2 | 7.3 | 9.7 | 80.1 | 18254 |
| 2021 | 203304 | 100 | 38.2 | 38 | 37.9 | 8.5 | 9.5 | 80.9 | 29144 |
| 2022 | 222027 | 100 | 41.6 | 41.4 | 41.3 | 9.2 | 7.1 | 82.2 | 31516 |
| 2023 | 234325 | 100 | 41.8 | 41.6 | 41.5 | 8.7 | 6.7 | 83.3 | 32662 |
| 2024 | 251381 | 100 | 44.2 | 44 | 43.9 | 9.5 | 5.7 | 82.9 | 38787 |
| 2025 | 269069 | 100 | 44.7 | 44.5 | 44.4 | 10.7 | 4.4 | 82.8 | 41043 |

_0.0 s_

## 3. PLACSP por clase de procedimiento (2018-2025)

| clase | lotes | pct_n | pct_min_y_max | pct_anormales | pct_pbl | n3_minmax |
|---|---|---|---|---|---|---|
| abierto | 707021 | 100 | 37.7 | 12.4 | 70.2 | 96038 |
| abierto_simplificado | 433638 | 100 | 55.2 | 9.4 | 93 | 98930 |
| basado | 235104 | 100 | 28.7 | 3.6 | 87.4 | 20105 |
| nsp | 134411 | 100 | 27.1 | 2.9 | 87.6 | 1505 |
| otro | 87467 | 99.9 | 5.2 | 0.3 | 82 | 1115 |
| emergencia | 28313 | 100 | 7.5 | 2.8 | 90.4 | 529 |
| negociado_publicidad | 10764 | 100 | 23.3 | 3.9 | 76.5 | 504 |
| restringido | 7909 | 100 | 21.4 | 4.6 | 46.9 | 271 |
| dialogo_innovacion | 122 | 100 | 9.8 | 0 | 47.5 | 4 |
| sin_procedimiento | 5 | 100 | 0 | 0 | 60 | 0 |

_0.0 s_

## 4. PLACSP por tipo de contrato (2018-2025)

| tipo_contrato | lotes | pct_n | pct_min_y_max | pct_anormales | pct_pbl | n3_minmax |
|---|---|---|---|---|---|---|
| Suministros | 681203 | 100 | 36 | 10.6 | 74.9 | 75003 |
| Servicios | 664095 | 100 | 36 | 7.8 | 84.7 | 79692 |
| Obras | 222385 | 100 | 47.6 | 5.7 | 90.4 | 58439 |
| Privado | 30462 | 100 | 41.1 | 7.7 | 89.5 | 1782 |
| Patrimonial | 23103 | 100 | 43.8 | 11.1 | 74.7 | 2417 |
| Concesion_servicios | 10935 | 100 | 42.2 | 6.2 | 57.5 | 702 |
| Administrativo_especial | 8726 | 100 | 34 | 9.3 | 58.4 | 875 |
| Otro | 1926 | 100 | 2 | 0.4 | 46.3 | 12 |
| Gestion_servicios_publicos | 1632 | 100 | 12.2 | 1.5 | 63.5 | 61 |
| Concesion_obras | 287 | 100 | 26.8 | 3.5 | 85 | 18 |

_0.0 s_

## 5. PLACSP año × tipo (obras, servicios, suministros): lotes con >= 3 ofertas y min y max > 0

| anio | obras | servicios | suministros | pct_de_los_3mas |
|---|---|---|---|---|
| 2018 | 3127 | 3087 | 2411 | 13.7 |
| 2019 | 5744 | 7207 | 5304 | 22.6 |
| 2020 | 4867 | 7254 | 5776 | 23.2 |
| 2021 | 8052 | 11604 | 8690 | 30.1 |
| 2022 | 8875 | 11905 | 9796 | 33.8 |
| 2023 | 8277 | 11260 | 12295 | 37 |
| 2024 | 8893 | 13165 | 15605 | 37.8 |
| 2025 | 10604 | 14210 | 15126 | 38 |

_0.1 s_

## 6. Coherencia (PLACSP, min y max > 0): min <= max, min <= adj <= max (tolerancia 0,5 %), min <= PBL, max <= PBL

| lotes | pct_min_le_max | pct_min_adj_max | pct_adj_igual_min | pct_adj_igual_min_x121 | pct_adj_sobre_max | pct_adj_bajo_min | pct_min_le_pbl | pct_max_le_pbl | pct_min_sobre_pbl_x121 | pct_min_igual_max |
|---|---|---|---|---|---|---|---|---|---|---|
| 516070 | 100 | 88.58 | 71.02 | 0.29 | 3.57 | 7.84 | 93.15 | 89.54 | 1.26 | 42.71 |

_0.0 s_

## 7. Coherencia por tipo (O/S/S frente al resto), con >= 3 ofertas

| oss | lotes | pct_min_le_max | pct_min_adj_max | pct_min_le_pbl | pct_min_en_pbl_01 | pct_min_igual_max | rango_p50 | rango_p90 | rango_p99 |
|---|---|---|---|---|---|---|---|---|---|
| True | 213134 | 100 | 87.69 | 96.48 | 3.2 | 7.53 | 0.2117 | 1.025 | 2445 |
| False | 5867 | 100 | 92.39 | 47 | 8.84 | 9.07 | 0.4519 | 3.801 | 2379 |

_0.0 s_

## 8. Desiertos con min/max (PLACSP) y num_ofertas < 3 con min y max distintos (rareza)

| n1_min_distinto_max | n2 | sin_n_con_min | min_o_max_no_positivo |
|---|---|---|---|
| 1111 | 258975 | 19 | 105981 |

_0.0 s_

## 9. imp_lic_reparto en PLACSP con >= 3 ofertas y min/max (de dónde sale el PBL del lote)

| rep | n | con_pbl |
|---|---|---|
| expediente_sin_reparto | 136384 | 127123 |
| por_lote | 82617 | 81027 |

_0.0 s_