Know your data sources.

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").

Federal spending transparency — every prime award since FY2008 (Treasury/OMB). No auth. - searchAwards ⭐ filter recipient, NAICS, agency, place - getAwardById ⭐ full record by generated_internal_id - searchByRecipient ⭐ recipient-name fuzzy wrapper - searchByNaics ⭐ NAICS (oil-svcs 21 / 2111 / 213111) - searchByAgency by toptier_code (089 DOE, 097 DoD) - getRecipientById profile (-C/-P/-R suffix) - autocompleteRecipient fuzzy name -> hits - getServiceInfo taxonomy + agencies + NAICS upstream quirk: award_type_codes MUST be a single group per call (mixed groups → 422). Pass awardTypeGroup (contracts | idvs | grants | loans | direct_payments | other_financial_assistance); handler rejects mixed groups. upstream quirk: limit caps at 100; page 1-indexed; time_period floor 2007-10-01.