Agri-food trade competitiveness indicators (FAOSTAT, yearly)

No commercial useFreshLicense: CC-BY-4.0

Downloads are disabled for this dataset: its license prohibits commercial use. The documentation, schema and sample rows stay available here.

Agri-food trade competitiveness indicators from FAO's FAOSTAT Trade domain (TCLI): one row per (area, commodity, year), 2010 onward, ~185 areas x 23 items — six of FAO's eight published trade indicators (Balassa revealed comparative advantage, import dependency ratio, self-sufficiency ratio, terms of trade, trade openness, share of agri exports in GDP; the two World-only market-concentration indices are excluded by design), with an RCA>1 comparative-advantage flag and the within-(commodity, year) RCA rank. Keyless official bulk download. Who joins this: trade economists read rca_index/rca_advantage as the workhorse competitiveness signal; procurement teams use import_dependency_ratio and self_sufficiency_ratio as supply-risk features; macro models track terms_of_trade_pct and agri_exports_gdp_share_pct. Pairs with the FAOSTAT production (QCL) and food-security panels.

Source: FAOSTAT Agri-Food Trade Competitiveness Indicators (yearly, keyless)
Rows: 38,272
Columns: 17
Source cadence: Yearly
Last refreshed: Oct 10, 2026
Theme: economy

Column	Type	Description
area_code	string	FAOSTAT numeric area code (countries and territories; 5000 = World, kept by design because FAO publishes the market-concentration indices only globally). (unit: string)
area_code_m49	string	UN M49 code for the area, as published by FAOSTAT. (unit: string)
area	string	FAOSTAT area name. (unit: string)
item_code	string	FAOSTAT item code of the commodity (1882 = the 'Crops and livestock products' headline aggregate, kept by design). (unit: string)
item	string	FAOSTAT commodity name. (unit: string)
item_cpc	string	Central Product Classification code of the commodity, as published by FAOSTAT. (unit: string)
year	integer	Observation year (the panel join key together with area_code and item_code). (unit: year)
import_dependency_ratio	float	FAO indicator 501: import dependency ratio (imports relative to domestic supply). Negative values are genuine upstream (net exporters beyond domestic supply) and kept verbatim. (unit: ratio)
self_sufficiency_ratio	float	FAO indicator 502: self-sufficiency ratio (domestic production relative to supply). (unit: ratio)
agri_exports_gdp_share_pct	float	FAO indicator 503: share of agricultural exports in GDP, percent (published only for the headline aggregate item). (unit: percent)
trade_openness_index	float	FAO indicator 505: agricultural trade openness index (published only for the headline aggregate item). (unit: index)
terms_of_trade_pct	float	FAO indicator 506: terms of trade, percent (export vs import unit values). Explodes upstream for tiny trade legs — kept verbatim, never winsorized. (unit: percent)
rca_index	float	FAO indicator 509.02: revealed comparative advantage index (Balassa RCA) — the workhorse trade-competitiveness signal. (unit: index)
rca_advantage	integer	1 when rca_index > 1 (the definitional Balassa comparative-advantage threshold); null where RCA is null. (unit: flag)
rca_rank	integer	Dense rank of rca_index within the (commodity, year), 1 = strongest revealed comparative advantage that year (null where RCA is null). (unit: rank)
fao_flag	string	FAO observation flag (E = Estimated value; every upstream cell in this domain is E). (unit: string)
row_hash	string	Deterministic 16-hex sha256 of area_code + item_code + year + the six indicator columns (idempotency key). (unit: string)

First 10 sample rows — a preview, not the complete dataset.

area_code	area_code_m49	area	item_code	item	item_cpc	year	import_dependency_ratio	self_sufficiency_ratio	agri_exports_gdp_share_pct	trade_openness_index	terms_of_trade_pct	rca_index	rca_advantage	rca_rank	fao_flag	row_hash
1	051	Armenia	116	Potatoes	01510	2,010	0	1	—	—	—	0.97	0	31	E	b76247c93a909da0
1	051	Armenia	116	Potatoes	01510	2,011	0.02	0.98	—	—	—	0.35	0	48	E	7959eddcf94515a3
1	051	Armenia	116	Potatoes	01510	2,012	0.01	0.99	—	—	—	0	0	70	E	397aa512d424ee1a
1	051	Armenia	116	Potatoes	01510	2,013	-0.01	1.01	—	—	—	3.52	1	11	E	027ac171e9731dd1
1	051	Armenia	116	Potatoes	01510	2,014	0.01	0.99	—	—	—	1.67	1	21	E	0c569ae86f8949a1
1	051	Armenia	116	Potatoes	01510	2,015	0	1	—	—	—	0.74	0	29	E	eaae3cb67852e779
1	051	Armenia	116	Potatoes	01510	2,017	0	1	—	—	—	0.02	0	68	E	165aebd71812ac45
1	051	Armenia	116	Potatoes	01510	2,018	0	1	—	—	—	0.01	0	68	E	937c5630be980a7e
1	051	Armenia	116	Potatoes	01510	2,020	0.01	0.99	—	—	—	0.01	0	63	E	58ef12fccf42a848
1	051	Armenia	116	Potatoes	01510	2,021	0.01	0.99	—	—	—	0.17	0	54	E	c2a001257cb5e065

Profiled Oct 11, 2026 from snapshot 20261010T203032Z-5eb829d55f71

Measured

Completeness: 81.8%
Rows: 38,272
Columns: 17
Columns with gaps: 8

Rows per yearyear · 2010–2024 · 15 years

20102024

Column	Missing	Distinct	Range	Distribution
area_codevarchar	0%	182	—	106345 150345 203345
area_code_m49varchar	0%	176	—	250345 300345 380345
areavarchar	0%	178	—	France345 Greece345 Italy345
item_codevarchar	0%	23	—	18822,301 1161,935 561,905
itemvarchar	0%	25	—	Crops and livestock products2,301 Potatoes1,935 Maize (corn)1,905
item_cpcvarchar	0%	20	—	F18822,301 015101,935 01121,905
yearbigint	0%	17	2,010 → 2,024median 2,016
import_dependency_ratiodouble	35.2%	760	-867.87 → 1,449median 0.03	438 outside 1st–99th percentile
self_sufficiency_ratiodouble	35.2%	893	-1,448 → 868.87median 0.97	438 outside 1st–99th percentile
agri_exports_gdp_share_pctdouble	94%	825	0 → 54.65median 2.68	39 outside 1st–99th percentile
trade_openness_indexdouble	94%	32	0.01 → 1.07median 0.08	20 outside 1st–99th percentile
terms_of_trade_pctdouble	33.5%	12,187	0 → 3,934,069median 98.97	255 outside 1st–99th percentile
rca_indexdouble	6%	1,999	0 → 603.11median 0.04	360 outside 1st–99th percentile
rca_advantagebigint	6%	2	0 → 1median 0
rca_rankbigint	6%	73	1 → 75median 41	619 outside 1st–99th percentile
fao_flagvarchar	0%	1	—	E38,272
row_hashvarchar	0%	40,180	—	0002b25b075da90d1 0003289da0edb2e71 000384e441b1f9cc1

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/faostat_trade_indicators_intel/agri_trade_indicators_annual" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/faostat_trade_indicators_intel/agri_trade_indicators_annual").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/faostat_trade_indicators_intel/agri_trade_indicators_annual

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20261010T203032Z-5eb829d55f71 and its content hash, so readers get exactly the data you used.

APA

FAOSTAT Agri-Food Trade Competitiveness Indicators (yearly, keyless). (2026). Agri-food trade competitiveness indicators (FAOSTAT, yearly) [Data set, snapshot 20261010T203032Z-5eb829d55f71, sha256 5eb829d55f71]. Datazimuts. Retrieved 2026-10-11, from https://datazimuts.com/en/datasets/faostat_trade_indicators_intel/agri_trade_indicators_annual?snapshot=20261010T203032Z-5eb829d55f71

BibTeX

@misc{dz_faostat_trade_indicators_intel_agri_trad_5eb829d5,
  title        = {{Agri-food trade competitiveness indicators (FAOSTAT, yearly)}},
  author       = {{FAOSTAT Agri-Food Trade Competitiveness Indicators (yearly, keyless)}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/faostat_trade_indicators_intel/agri_trade_indicators_annual?snapshot=20261010T203032Z-5eb829d55f71}},
  note         = {Snapshot 20261010T203032Z-5eb829d55f71, sha256 5eb829d55f711ae1aecf92f8d0b59ffad976d5fec38b5a70ee58c8352755f16f; accessed 2026-10-11}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=faostat_trade_indicators_intel%2Fagri_trade_indicators_annual&lang=en&theme=auto&snapshot=20261010T203032Z-5eb829d55f71&x=year&y=year&agg=avg" title="Agri-food trade competitiveness indicators (FAOSTAT, yearly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>