Historical Municipality Directory

Custom SQL query

Queries

Tables

bez1848

histid, kt_id, id, long, short, type, admissionnumber, admissiontype, admissiondate, abolitionnumber, abolitiontype, abolitiondate, changedate

309 rows

bez1960

histid, kt_id, id, long, short, type, admissionnumber, admissiontype, admissiondate, abolitionnumber, abolitiontype, abolitiondate, changedate

309 rows

gde1848

histid, bez_histid, kt_code, id, long, short, type, status, admissionnumber, admissiontype, admissiondate, abolitionnumber, abolitiontype, abolitiondate, changedate

6,336 rows

gde1960

histid, bez_histid, kt_code, id, long, short, type, status, admissionnumber, admissiontype, admissiondate, abolitionnumber, abolitiontype, abolitiondate, changedate

5,868 rows

kt1848

id, code, label, changedate

26 rows

kt1960

id, code, label, changedate

26 rows