Know your data sources.

US imports & exports time series — Census Foreign Trade (no auth). 8 endpoints (hs / porths / statehs / naics × imports / exports). searchExports / searchImports filter HS or NAICS + country + month. searchTradeByPort and searchTradeByState slice by US port / state. getTradeBalance fetches both directions in parallel. getCountryCodes is a built-in CTY_CODE↔ISO map (top 30 partners + USMCA/OECD/NATO/APEC). lookupHsCode is a chapter index (27 fuels, 28/29/39 chem, 72/73 steel, 84/85 machinery, 26 ores). upstream quirk: exports use ALL_VAL_MO + E_COMMODITY; imports use GEN_VAL_MO + I_COMMODITY — search dispatches on direction. upstream quirk: country codes are Census Schedule C/D — NOT ISO. Mexico=2010, Canada=1220, China=5700. Optional CENSUS_API_KEY raises the 500/day per-IP cap.

Geological Survey of Queensland — ~190k datasets: well completion reports (16k+), well proposals, hydraulic-fracturing reports, petroleum production/reserves reports, boreholes, seismic, geochemistry, magnetic/radiometric/gravity grids. No-auth CKAN 3. METHODS: packageSearch, packageShow, resourceShow, searchPetroleumReports, searchBoreholes, listOrganizations, listGroups, getServiceInfo RULES: 1. Vocab values are full URIs (linked.data.gov.au/def/...); fq accepts `:*petroleum` shorthand. 2. Single org (GSQ), single group (geoscience). 3. Pagination caps at 1000 rows; use `start`. 4. `type`: report | borehole | map-collection | geochemistry | seismic | magnetic | radiometric | electromagnetic | gravity | dataset | gravity-gradiometry | spectral | magnetotelluric | electrical.

Queensland Open Data Portal — 188k+ QLD government datasets. Strong O&G: petroleum/gas production stats, CSG/condensate/crude/LPG/natural-gas reserves, tenure, environment. CKAN 3 with search, package/resource metadata, and datastore queries incl. SELECT-only SQL. Platform JWT embedded for higher rate limits. METHODS: packageSearch, packageShow, resourceShow, datastoreSearch, datastoreSearchSql, listOrganizations, listGroups, getServiceInfo RULES: 1. `datastore_active: true` ≠ parsed rows; XLSX often empty — fall back to download URL. 2. Pagination caps at 1000 rows; use `start` / `offset`. 3. datastoreSearchSql rejects non-SELECT.