Skip to contents

Query city-level foreign trade data

Source: R/query_city.R
comex_query_city.Rd

Query the city endpoint of the ComexStat API. City-level data is more aggregated than general data, with fewer available details and metrics.

City information is based on the declarant of exports/imports, not the producer or buyer.

Usage

comex_query_city(
  flow = "export",
  start_period,
  end_period,
  details = NULL,
  filters = NULL,
  month_detail = TRUE,
  metric_fob = TRUE,
  metric_kg = TRUE,
  metric_statistic = FALSE,
  language = "en",
  verbose = TRUE
)

Arguments

flow

Trade flow: "export" or "import".

start_period

Start period in "YYYY-MM" format.

end_period

End period in "YYYY-MM" format.

details

Character vector of detail/grouping fields. Options:

Geographic: "country", "state", "city"

Products: "hs6" (or "sh6"), "hs4" (or "sh4"), "hs2" (or "sh2"), "section"

filters

Named list of filters. Example: list(city = "3550308", state = "26")

month_detail

Logical. If TRUE, break down by month. Default: FALSE.

metric_fob

Logical. Include FOB value (US$). Default: TRUE.

metric_kg

Logical. Include net weight (kg). Default: TRUE.

metric_statistic

Logical. Include statistical quantity. Default: FALSE.

language

Response language: "pt", "en", or "es". Default: "en".

verbose

Logical. Show progress messages. Default: TRUE.

Value

A data.frame (or tibble) with query results.

Details

City-level data differs from general data:

  • Full NCM is not available (use HS6/SH4/SH2)

  • Classifications like CGCE, SITC, and ISIC are not available

  • Only FOB, KG, and Statistical quantity metrics are available

  • Freight, Insurance, and CIF metrics are not available

Examples

if (FALSE) { # \dontrun{
# Exports from Pernambuco in 2023
comex_query_city(
  flow = "export",
  start_period = "2023-01",
  end_period = "2023-12",
  details = c("country", "state"),
  filters = list(state = 26)
)
} # }