decisions

187,593 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: decision_date (date), fetched_at (date), Liste_Neuheiten (date)

Next page

CREATE TABLE decisions (json_url TEXT, reference TEXT PRIMARY KEY, decision_date TEXT, html_url TEXT, fetched_at TEXT, checksum TEXT, bger_url TEXT, type TEXT, Liste_Neuheiten TEXT, Sachgebiet TEXT, Themen TEXT, local_json_path TEXT, erledigung TEXT, Sprache TEXT, AnzahlRichter INTEGER, BGE_PublikationVorgesehen INTEGER DEFAULT 0);
CREATE INDEX idx_json_url ON decisions(json_url);
CREATE INDEX idx_reference ON decisions (reference);