Public data surface

Inspect the evidence. Query the model.

Purpose-built endpoints support normal product tasks. A separate SQL projection supports analysis. It contains public fields only.

Base URL · https://amnog.shoulde.rs

Task APIs

Stable product read models

GET /api/gba/cases

Search validated G-BA case workspaces.

q, status, series, page

GET /api/gba/cases/{id}

Read one case with its assessments, hearings, decisions, documents, and sources.

G-BA case ID

GET /api/gba/decisions

List typed G-BA actions and source-cited synopses.

q, action

GET /api/gba/decisions/{id}

Read one decision with claim evidence, targets, and official documents.

G-BA decision ID

GET /api/gba/meetings

List meeting, recording, and agenda coverage without merging these objects.

year

GET /api/gba/search

Search page-level passages in official G-BA documents.

q, limit

GET /api/graph/entities

Browse the public cross-channel graph.

q, type, module, year, status, page

GET /api/graph/entities/{id}

Read one public entity with relations and provenance.

URL-encoded graph ID

GET /api/assessments

Search the connected IQWiG assessment corpus.

search, area, ausmaß, year, type, page

GET /api/query

Run one read-only SQL query against the sanitized public projection.

sql, limit (maximum 500)

GET /api/schema

Read the exact schema of the sanitized public projection.

none

SQL examples

Query across channels

Send one SELECT or non-recursive WITH statement to /api/query?sql=.

Cases and their decisions

SELECT c.procedure_number, c.medicine_label, d.gba_decision_id,
       d.action_type, d.decision_date
FROM cases c
JOIN case_decisions cd ON cd.procedure_node_id = c.node_id
JOIN decisions d ON d.node_id = cd.decision_node_id
ORDER BY d.decision_date DESC

Cited claims for decision 4689

SELECT c.claim_index, c.claim_text, e.supporting_text,
       json_extract(e.locator_json, '$.page') AS page
FROM summaries s
JOIN summary_claims c ON c.summary_id = s.id
JOIN summary_claim_evidence e
  ON e.summary_id = c.summary_id AND e.claim_index = c.claim_index
WHERE s.node_id = 'gba:decision:4689'
  AND s.summary_type = 'deterministic'

Meeting agenda coverage

SELECT substr(m.meeting_date, 1, 4) AS year,
       a.parse_state, COUNT(*) AS meetings
FROM meetings m
LEFT JOIN meeting_agendas a ON a.meeting_node_id = m.node_id
GROUP BY year, a.parse_state
ORDER BY year DESC, a.parse_state

IQWiG oncology assessments

SELECT id, drug_inn, indication, publication_date
FROM assessments
WHERE therapeutic_area = 'Onkologie'
ORDER BY publication_date DESC
LIMIT 20