Skip to content

Colombian public procurement, four questions deep

SECOP II publishes every public contract in Colombia. This is a read-only view over a daily ELT pipeline that lands it in BigQuery, models it with dbt, and serves four questions through a FastAPI service on Cloud Run.

One thing to carry into every page: these figures describe what entities reported, not what they did. A missing value is a missing report, and it is not a zero. Wherever a number was not reported this site draws it as a hatched gap rather than filling it in — because a confident zero is a wrong answer where no answer exists.

Live figures are unavailable

The API is reporting itself as degraded, so the row counts and national context below are missing. The pipeline description is still accurate.

The pipeline

Every stage runs daily, orchestrated by Airflow. Nothing on this site is precomputed at build time.

  1. 01

    Socrata API

    SECOP II, daily extract

  2. 02

    GCS

    raw landing

  3. 03

    BigQuery

    secop_raw

  4. 04

    dbt

    staging → marts

  5. 05

    FastAPI

    Cloud Run

  6. 06

    Next.js

    this site

Rows loaded by the API

The API did not answer

How to read a gap

The most important convention on this site.

A hatched block means not reported. It never means zero, and it never means low. It appears for every null value, every contract that recorded no value, the unknown supplier, and every entity with no median.

Solid blue is a reported figure. The texture, not the colour, is what distinguishes the two — so it survives greyscale, printing, and colour vision deficiency.

Amounts are Colombian pesos, compacted on the long scale: M is a million and B is a billón, 10¹². Entity, sector and modality names are Spanish because the source data is.

The four questions

Q1 · direct contracting

How much is awarded without competition?

The share of an entity's contracting awarded directly rather than competitively, by count and by value.

The catch: direct contracting is 78 % of all Colombian contracts, so a high rate is normal. The signal is deviation from peers. Both rates are published because they diverge — 90 % of contracts and 1 % of the money is a different story from the reverse.

Q2 · supplier concentration

Who did the money actually go to?

For one entity in one year: its largest suppliers, and how concentrated its spending was.

The catch: concentration without size is meaningless — 100 % across one supplier and two contracts is noise. This is also the only page that queries the fact table live, at about 163 MiB per entity, so the list you pick from is served from memory instead.

Q3 · year-end rush

How much is signed in the last two months?

The share of an entity's yearly contracting signed in November and December, against the national figure for the same year.

The catch: an entity's figure means nothing without the national one beside it, and the count share and the value share answer different questions.

Q4 · coverage and execution

Do finished contracts record what was paid?

Of an entity's finished contracts, the share recording any payment — and among those, the median paid-to-contracted ratio.

The catch: ranking by the median alone measures reporting discipline, not execution. An entity that never reports looks identical to one that never executed.