---
name: inform-risk-index-ingestion
description: "How to get EU JRC INFORM Risk Index data into a pandas DataFrame and Parquet: access, the request, the format, limits, quirks and terms."
---

# Load INFORM country risk trends into pandas and Parquet

Source entry: https://signal-lab-jet.vercel.app/datasets/inform-risk-index
Provider: https://drmkc.jrc.ec.europa.eu/inform-index/INFORM-Risk/Results-and-data
Checked against the provider's documentation: 2026-11-01

## Access
- No account or key. The country-trends endpoint returns JSON.
- The results page also links direct XLSX files for the current, mid-year and trend releases.

## Request
```bash
curl 'https://drmkc.jrc.ec.europa.eu/inform-index/api/informapi/countries/trends?workflowid=0'
```

## Format
JSON array of country-indicator-year scores with ISO3, indicator ID and full name, year, score, workflow ID, methodology ID, hierarchy level and step number.

## Load into pandas and Parquet
Needs Python 3 with requests, pandas and pyarrow.
```python
"""INFORM country risk trends -> pandas -> Parquet. No key."""
import requests
import pandas as pd

URL = "https://drmkc.jrc.ec.europa.eu/inform-index/api/informapi/countries/trends"
r = requests.get(URL, params={"workflowid": 0}, timeout=120)
r.raise_for_status()
df = pd.DataFrame(r.json())
df.to_parquet("inform_risk_trends.parquet", index=False)
print(len(df), "scores", df["Iso3"].nunique(), "ISO3 codes",
      int(df["GNAYear"].min()), "to", int(df["GNAYear"].max()),
      df["IndicatorId"].nunique(), "indicators")
```
Run by us on 2026-11-01 (python 3.13.5 | pandas 3.1.0 | pyarrow 26.0.0 | requests 2.34.2). Result: 7640 scores 191 ISO3 codes 2016 to 2025 4 indicators

## Limits
- Rate limit: Not stated.
- The checked JSON response contained 7,640 rows and was about 1.7 MB.
- The results page listed a 2.4 MB 2026 workbook and an 18.8 MB 2017-2026 trend workbook.

## Quirks
- The trends endpoint's latest returned score year was 2025 even though the download page offered 2026 workbooks.
- Treat GNAYear as the score edition year and preserve WorkflowId and MethodologyId for reproducibility.
- CountryName was empty in the checked response; join Iso3 to a separate country reference when labels are required.

## Terms and attribution
- EU-owned website content is CC BY 4.0 unless an individual notice states otherwise.
- Give appropriate credit, indicate changes and clear any additional rights in third-party material.
- Terms page: https://commission.europa.eu/legal-notice_en

## Sources
- https://drmkc.jrc.ec.europa.eu/inform-index/INFORM-Risk/Results-and-data: "The overall INFORM risk index identifies countries at risk from humanitarian crises and disasters that could overwhelm national response capacity."
- https://drmkc.jrc.ec.europa.eu/inform-index/INFORM-Risk/Results-and-data: "INFORM Trend 2017 - 2026"
- https://drmkc.jrc.ec.europa.eu/inform-index/INFORM-Risk/Methodology: "The model of INFORM Risk can be split into different levels to provide a quick overview of the issues in need of targeted actions:"
- https://commission.europa.eu/legal-notice_en: "This means that reuse is allowed, provided appropriate credit is given and changes are indicated."

## Help improve this skill
Missing a source, or see something to improve? Call the MCP tool suggest_source or feedback (or POST /api/suggest or /api/feedback). Reviewed ideas: https://signal-lab-jet.vercel.app/agent-suggestions

Information for educational purposes only. Free tiers, limits and licenses belong to the providers and may change; check the provider's own terms before using the data.