Skip to content

K-Dense-AI/scientific-agent-skills / skills/database-lookup

database-lookup

Verified

Queries documented public database APIs with explicit endpoints, filters, pagination, and provenance. Used when a scientific, regulatory, financial, or other database-backed fact must be retrieved reproducibly from a named source rather than inferred from general knowledge.

FileKindSize
SKILL.mdskill md26.9 KB
references/addgene.mdmarkdown1.7 KB
references/alphafold.mdmarkdown2.9 KB
references/alphavantage.mdmarkdown7.9 KB
references/bea.mdmarkdown14.3 KB
references/bindingdb.mdmarkdown2.9 KB
references/biogrid.mdmarkdown3.8 KB
references/bls.mdmarkdown9.1 KB
references/brenda.mdmarkdown2.9 KB
references/cbioportal.mdmarkdown7.4 KB
references/census.mdmarkdown9.0 KB
references/chebi.mdmarkdown3.5 KB
references/chembl.mdmarkdown2.7 KB
references/clinicaltrials.mdmarkdown3.4 KB
references/clinpgx.mdmarkdown1.5 KB
references/clinvar.mdmarkdown4.1 KB
references/cod.mdmarkdown3.0 KB
references/cosmic.mdmarkdown1.3 KB
references/dailymed.mdmarkdown1.8 KB
references/database_selection_guide.mdmarkdown10.0 KB
references/datacommons.mdmarkdown7.0 KB
references/dbsnp.mdmarkdown3.5 KB
references/disgenet.mdmarkdown1.4 KB
references/drugbank.mdmarkdown1.3 KB
references/ecb.mdmarkdown5.2 KB
references/emdb.mdmarkdown1.1 KB
references/ena.mdmarkdown9.9 KB
references/encode.mdmarkdown1.8 KB
references/ensembl.mdmarkdown14.0 KB
references/epa.mdmarkdown1.9 KB
references/eurostat.mdmarkdown7.3 KB
references/fda.mdmarkdown2.1 KB
references/federal-reserve.mdmarkdown6.7 KB
references/fred.mdmarkdown9.9 KB
references/gene-ontology.mdmarkdown4.4 KB
references/geo.mdmarkdown3.8 KB
references/gnomad.mdmarkdown3.5 KB
references/gtex.mdmarkdown4.1 KB
references/gwas-catalog.mdmarkdown1.6 KB
references/hca.mdmarkdown1.4 KB
references/hpo.mdmarkdown1.2 KB
references/human-protein-atlas.mdmarkdown1.2 KB
references/interpro.mdmarkdown3.4 KB
references/jaspar.mdmarkdown1.4 KB
references/kegg.mdmarkdown2.5 KB
references/lincs-l1000.mdmarkdown2.1 KB
references/materials-project.mdmarkdown4.8 KB
references/metabolomics-workbench.mdmarkdown3.8 KB
references/monarch.mdmarkdown1.5 KB
references/mousemine.mdmarkdown1.5 KB
references/myvariant.mdmarkdown1.3 KB
references/nasa-exoplanet-archive.mdmarkdown4.3 KB
references/nasa.mdmarkdown3.0 KB
references/ncbi-gene.mdmarkdown1.7 KB
references/ncbi-protein.mdmarkdown3.2 KB
references/ncbi-taxonomy.mdmarkdown3.7 KB
references/nist.mdmarkdown3.6 KB
references/noaa.mdmarkdown6.7 KB
references/omim.mdmarkdown3.4 KB
references/opentargets.mdmarkdown7.0 KB
references/openweathermap.mdmarkdown8.2 KB
references/pdb.mdmarkdown3.2 KB
references/pride.mdmarkdown1.4 KB
references/pubchem.mdmarkdown3.4 KB
references/quickgo.mdmarkdown1.5 KB
references/reactome.mdmarkdown2.9 KB
references/regulomedb.mdmarkdown2.0 KB
references/retrieval-contract.mdmarkdown7.2 KB
references/rummageo.mdmarkdown1.3 KB
references/sdss.mdmarkdown4.4 KB
references/sec-edgar.mdmarkdown8.3 KB
references/simbad.mdmarkdown12.3 KB
references/sra.mdmarkdown4.5 KB
references/string.mdmarkdown7.7 KB
references/tcga-gdc.mdmarkdown2.0 KB
references/treasury.mdmarkdown7.2 KB
references/ucsc-genome.mdmarkdown3.3 KB
references/uniprot.mdmarkdown7.1 KB
references/usgs.mdmarkdown9.9 KB
references/uspto.mdmarkdown4.6 KB
references/who.mdmarkdown8.7 KB
references/worldbank.mdmarkdown7.0 KB
references/zinc.mdmarkdown5.7 KB

references/eurostat.md

View on GitHub
# Eurostat API Reference

## Overview
Eurostat is the statistical office of the European Union, providing statistics on economy, population, trade, labor, environment, and more for EU/EEA member states and partner countries. The API follows the SDMX (Statistical Data and Metadata Exchange) standard.

## Base URL
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1
```

An older JSON-stat endpoint also exists:
```
https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0
```

## Authentication
**No API key required.** The API is fully open and free.

## Rate Limits
- No formal rate limits documented.
- Eurostat may throttle aggressive scraping. Keep automated requests to 1-2 per second.
- Large datasets may time out; use filters to reduce response size.

---

## Key Endpoints (SDMX 2.1 API)

### 1. Get Dataset (Observations)

```
GET /data/{datasetCode}/{filter}
```

| Parameter | Required | Description |
|-----------|----------|-------------|
| `datasetCode` | Yes | Eurostat dataset code (e.g., `nama_10_gdp`, `demo_pjan`) |
| `filter` | No | Dot-separated dimension filter. Use `+` for multiple values in a dimension, `.` to separate dimensions, empty segment for "all". |

**Query parameters:**
| Parameter | Required | Description |
|-----------|----------|-------------|
| `format` | No | `sdmx+json` (default), `sdmx+csv`, `sdmx+xml`, `TSV` |
| `startPeriod` | No | Start year/quarter/month: `2015`, `2020-Q1`, `2020-01` |
| `endPeriod` | No | End year/quarter/month |
| `detail` | No | `full` (default), `dataonly`, `serieskeysonly`, `nodata` |
| `lang` | No | `en` (default), `fr`, `de` |

**Example (GDP at market prices for Germany and France, annual, 2018-2023):**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/nama_10_gdp/A.CP_MEUR.B1GQ.DE+FR?startPeriod=2018&endPeriod=2023
```

**Example (total population by country, annual):**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/demo_pjan/A.NR.T.TOTAL.DE+FR+IT+ES?startPeriod=2015&endPeriod=2023
```

**Example (unemployment rate, seasonally adjusted, monthly):**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/une_rt_m/M.SA.TOTAL.PC_ACT.T.EA20?startPeriod=2023-01&endPeriod=2024-12
```

**Example (HICP inflation, all items, monthly):**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/prc_hicp_mmor/M.RCH_M.CP00.DE+FR+IT?startPeriod=2023-01&endPeriod=2024-06&format=JSON
```

### 2. Get Dataset as CSV

Append `?format=SDMX-CSV` to any data request for a flat CSV response that is easier to parse.

**Example:**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/nama_10_gdp/A.CP_MEUR.B1GQ.DE+FR?startPeriod=2018&endPeriod=2023&format=SDMX-CSV
```

### 3. Get Dataset Structure (Dimensions and Code Lists)

```
GET /datastructure/ESTAT/{datasetCode}
```

**Example:**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/datastructure/ESTAT/nama_10_gdp
```

Returns dimension names, positions, and code list references.

### 4. Get Code List (Dimension Values)

```
GET /codelist/ESTAT/{codelistId}
```

**Example:**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/codelist/ESTAT/GEO
```

### 5. Search/Browse Datasets (Dataflows)

```
GET /dataflow/ESTAT/all
```

Returns all available Eurostat datasets. Add `?detail=allstubs` for a lighter listing.

**Example:**
```
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/dataflow/ESTAT/all?detail=allstubs
```

---

## JSON-stat API (Simpler Alternative)

### Base URL
```
https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data
```

### Get Data
```
GET /data/{datasetCode}?{dimension_filters}
```

Dimensions are passed as query parameters using their dimension name.

**Example (GDP for DE and FR):**
```
https://ec.europa.eu/eurostat/api/dissemination/statistics/1.0/data/nama_10_gdp?geo=DE&geo=FR&unit=CP_MEUR&na_item=B1GQ&freq=A&time=2020&time=2021&time=2022&lang=en
```

**Response (JSON-stat format):**
```json
{
  "version": "2.0",
  "label": "GDP and main components (output, expenditure and income)",
  "id": ["freq", "unit", "na_item", "geo", "time"],
  "size": [1, 1, 1, 2, 3],
  "dimension": {
    "geo": {
      "label": "Geopolitical entity",
      "category": {
        "index": {"DE": 0, "FR": 1},
        "label": {"DE": "Germany", "FR": "France"}
      }
    },
    "time": {
      "label": "Time",
      "category": {
        "index": {"2020": 0, "2021": 1, "2022": 2}
      }
    }
  },
  "value": [3336010.0, 3601750.0, 3876810.0, 2310420.0, 2500870.0, 2639090.0],
  "status": {}
}
```

Values are in a flat array; use dimension sizes to reshape.

---

## Common Dataset Codes

| Code | Description |
|------|-------------|
| `nama_10_gdp` | GDP and main components |
| `nama_10_pc` | GDP per capita |
| `namq_10_gdp` | GDP quarterly |
| `demo_pjan` | Population on 1 January |
| `demo_gind` | Population change (births, deaths, migration) |
| `une_rt_m` | Unemployment rate (monthly) |
| `une_rt_a` | Unemployment rate (annual) |
| `lfsi_emp_a` | Employment rate (annual) |
| `prc_hicp_manr` | HICP inflation (annual rate of change, monthly) |
| `prc_hicp_mmor` | HICP inflation (monthly rate of change) |
| `ext_lt_maineu` | EU trade by partner (main partners) |
| `ext_st_27_2020sitc` | International trade by SITC |
| `bop_c6_q` | Balance of payments (quarterly) |
| `gov_10dd_edpt1` | Government deficit/surplus |
| `gov_10a_main` | Government revenue, expenditure and main aggregates |
| `sts_inpr_m` | Industrial production (monthly) |
| `tour_occ_nim` | Tourism (nights spent at accommodation) |
| `env_air_gge` | Greenhouse gas emissions |
| `tec00114` | GDP growth rate (percentage change) |
| `tec00118` | Government debt as % of GDP |

## Common Country Codes (ISO 2-letter, Eurostat uses uppercase)

`AT` Austria, `BE` Belgium, `BG` Bulgaria, `CY` Cyprus, `CZ` Czechia, `DE` Germany, `DK` Denmark, `EE` Estonia, `EL` Greece, `ES` Spain, `FI` Finland, `FR` France, `HR` Croatia, `HU` Hungary, `IE` Ireland, `IT` Italy, `LT` Lithuania, `LU` Luxembourg, `LV` Latvia, `MT` Malta, `NL` Netherlands, `PL` Poland, `PT` Portugal, `RO` Romania, `SE` Sweden, `SI` Slovenia, `SK` Slovakia

Aggregates: `EU27_2020` (EU-27), `EA20` (Euro area 20), `EA19` (Euro area 19), `EEA30_2007` (EEA)

**Note:** Greece uses `EL` (not `GR`) in Eurostat.

## Format and dimension handling

The SDMX 2.1 API defaults to SDMX-ML Generic XML. Supported `format` values
include `SDMX_2.1_STRUCTURED`, `SDMX-CSV`, `JSON` (JSON-stat), and `TSV`.
Do not parse `format=JSON` as a SDMX-JSON dataSets/structure envelope.
For JSON-stat, use `id`, `size`, and each dimension's category index to reshape
`value`; values may be an array or a sparse index-keyed object. Missing cells
are not zero. Preserve observation flags and dataset update time.

## Notes
- Dimension order in the filter path depends on the dataset structure. Always check `/datastructure/ESTAT/{code}` first.
- Use `+` to select multiple values in one dimension (e.g., `DE+FR+IT`).
- Leave a dimension segment empty (consecutive dots `..`) to select all values.
- CSV format (`?format=SDMX-CSV`) is recommended for easier parsing -- it returns flat rows with labeled columns.
- The JSON-stat API is simpler for quick queries but the SDMX API is more powerful and complete.
- Dataset codes can be found at https://ec.europa.eu/eurostat/databrowser/ by browsing themes.
- Large unrestricted queries may time out. Always filter by country and time period.
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall