law_revision_history

Data license: 비공개

1 row where law_master_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: collected_at (date)

id ▼ law_master_id revision_date revision_type revision_reason major_changes extra collected_at
6601 40 40 20260410 전부개정     {"자치법규ID": "2149475", "자치법규명": "대전광역시 소방시설 및 피난ㆍ방화시설 등에 대한 위반행위 신고포상제 운영 조례", "자치법규일련번호": "2122133", "지자체기관명": "대전광역시", "시행일자": "20260901", "제개정정보": "전부개정", "자치법규종류": "C0001", "공포번호": "6628", "전화번호": "", "담당부서명": "", "자치법규발의종류": "", "공포일자": "20260410"} 2026-06-27 00:53:10

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE law_revision_history (
    id               INTEGER PRIMARY KEY AUTOINCREMENT,
    law_master_id    INTEGER NOT NULL REFERENCES law_master(id) ON DELETE CASCADE,
    revision_date    TEXT,
    revision_type    TEXT,
    revision_reason  TEXT,
    major_changes    TEXT,
    extra            TEXT,
    collected_at     TEXT NOT NULL,
    UNIQUE(law_master_id, revision_date, revision_type)
);