DuckDB 1.1.3 · 2026-10-21 17:15:11


## -- 05. Implementación 1 (DuckDB SQL) de los screens de DEFINICIONES_PREVIAS.md §2 (sellado ee85d2f5…, 21-oct 1

| Count |
|---|
| 176743 |

_0.5 s_

## CREATE OR REPLACE TABLE s1 AS

| Count |
|---|
| 176743 |

_0.3 s_

## -- mediana de la baja por mercado × tramo, en PC, celdas con >= 10 bajas

| Count |
|---|
| 2858 |

_0.0 s_

## -- REP_IGUAL: licitaciones con >= 3 lotes adjudicados (b, O/S/S, 2018-2025), cuotas por ganador distinto

| Count |
|---|
| 54755 |

_0.2 s_

## -- ESTAB: órgano × CPV, Jaccard de ganadores entre t y t-1 (b, O/S/S, sin personas físicas, 2017-2025), >= 3 l

| Count |
|---|
| 50578 |

_0.2 s_

## -- UTE_RIVALES

| Count |
|---|
| 105 |

_0.1 s_

## CREATE OR REPLACE TABLE s2 AS

| Count |
|---|
| 176743 |

_0.6 s_

## -- percentiles orientados dentro del mercado (PC, mercados con >= 20 lotes); rango medio de empates

| Count |
|---|
| 176743 |

_1.1 s_

## CREATE OR REPLACE TABLE s4 AS

| Count |
|---|
| 176743 |

_0.4 s_

## -- percentil de S3 dentro del mercado (para D2: señalado si >= 0,80). S3 redondeado a 12 decimales antes de ra

| Count |
|---|
| 176743 |

_0.8 s_

## COPY (SELECT * EXCLUDE (o_rango, o_sep, o_baja, o_rep, o_est) FROM sc) TO '/c/interno/sc_impl1.parquet' (FORMA

| Count |
|---|
| 176743 |

_0.2 s_

## comprobaciones: filas, PC, mercados, nulos (sin etiqueta)

| p | pc | pc_merc20 | con_s3 | con_baja | con_rep | con_est | ute_riv_1 | con_pnc | pnc_1 | sin_disp | mercados |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 176743 | 164700 | 155908 | 155908 | 143926 | 36168 | 85682 | 88 | 169162 | 4897 | 11490 | 1129 |

_0.0 s_

## distribución de los screens en PC con mercado (sin etiqueta)

| s | q |
|---|---|
| rango | [0.055807240475686776, 0.23111992084156188, 1.0477956532328248] |
| sep | [0.00882432867245048, 0.1659783392088002, 0.667060835516929] |
| baja_cond | [-0.14269048406407428, -5.496480752045813e-07, 0.24247888446717916] |
| rep_igual | [0.4342961244559703, 0.6625520352437253, 0.9005507902301642] |
| estab | [0.0, 0.17162241476837145, 0.42046470480983883] |
| s3 | [0.14031281546968954, 0.5075609519299455, 0.8359616753663058] |

_0.0 s_

## percentiles en [0,1] y media 0,5 por mercado (control)

| min(p_rango) | max(p_rango) | avg(p_rango) | min(p_baja) | max(p_baja) | avg(p_baja) | avg(pct_s3) | frac80 |
|---|---|---|---|---|---|---|---|
| 0.0001292 | 0.9999 | 0.5 | 0.0001293 | 0.9999 | 0.5 | 0.5 | 0.2 |

_0.0 s_