What you can ask
- “What does Colombia ANH have for the area or asset I'm working on?”
- “Pull the most recent Colombia ANH records and put them in a table.”
- “What does Colombia ANH cover, and how fresh is the data?”
About this source
Colombian oil & gas open data published by ANH (Agencia Nacional de Hidrocarburos) via datos.gov.co Socrata SODA. First Socrata connector in PatchOps. Datasets (live-probed 2026-05-07): - Crude oil production (51,924 monthly rows) ⭐ field/operator/department/contract + Point geometry - Gas production (69,074 monthly rows) ⭐ same shape, gas in KPC - Active contracts (275) ⭐ operator/cuenca/estado/etapa - Production tests (723, 2025-2026) initial + extended well tests - Field royalty liquidations (203,572) USD price, COP regalías per field-month upstream quirks: SoQL filters case-sensitive (CASANARE not casanare). Numbers stored as text with mixed US (11,955.00) and EU (63,13) formats. Year column on royalties is "a_o" (mangled "año").
Connector ID colombia
Provenance
Freshness & coverage
› Methods (6)
Technical detail for developers: parameters, pagination, units, and freshness per method.
searchOilProduction
readCrude oil production (51,924 rows). Filter by departamento, operadora, campo, contrato, year, month.
EntitiesproductionFilters exact, any case (Casanare = CASANARE). produccion_bls parsed from text.
searchGasProduction
readGas production in KPC (69,074 rows). Same filter shape as oil; geolocalizacion Point.
Entitiesproductionupstream uses nombremes (no underscore); handler normalizes.
searchContracts
readActive hydrocarbon contracts (275). Filter by operator, basin, status, etapa, surface.
EntitiesleaseFilters ignore case: status "En ejecución" matches both upstream casings.
searchProductionTests
readInitial / extended well production tests (723 rows). Only 2025-2026 populated.
Entitiesproduction, completiontipoPrueba: Iniciales|Extensas. estado: Activo|Inactivo|Abandonado|Cerrado.
searchFieldRoyalties
readField-level royalty liquidations (203,572 rows). USD price + COP regalías per month.
Entitiesproduction, ownership, fieldYear column is `a_o` upstream. Numbers in EU comma-decimal — handler parses.
getServiceInfo
readDataset row counts as of lastVerified, enum values, publisher info, and §0 probe notes.
Entitiesmetadata
