home / civic

Menu
  • Log in

law_appendix

Data license: 비공개

1 row where law_master_id = 29

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: collected_at (date)

id ▼ law_master_id appendix_no appendix_branch_no appendix_type appendix_title attachment_name appendix_text extra collected_at
54 29 29 0001 00 서식 [별지 제1호서식] 이동약자를 위한 경사로 설치 신청서(동의서) http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=161390877&flNm=%5B%EB%B3%84%EC%A7%80+%EC%A0%9C1%ED%98%B8%EC%84%9C%EC%8B%9D%5D+%EC%9D%B4%EB%8F%99%EC%95%BD%EC%9E%90%EB%A5%BC+%EC%9C%84%ED%95%9C+%EA%B2%BD%EC%82%AC%EB%A1%9C+%EC%84%A4%EC%B9%98+%EC%8B%A0%EC%B2%AD%EC%84%9C%28%EB%8F%99%EC%9D%98%EC%84%9C%29   {"별표제목": "[별지 제1호서식] 이동약자를 위한 경사로 설치 신청서(동의서)", "별표첨부파일구분": "hwp", "별표첨부파일명": "http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=161390877&flNm=%5B%EB%B3%84%EC%A7%80+%EC%A0%9C1%ED%98%B8%EC%84%9C%EC%8B%9D%5D+%EC%9D%B4%EB%8F%99%EC%95%BD%EC%9E%90%EB%A5%BC+%EC%9C%84%ED%95%9C+%EA%B2%BD%EC%82%AC%EB%A1%9C+%EC%84%A4%EC%B9%98+%EC%8B%A0%EC%B2%AD%EC%84%9C%28%EB%8F%99%EC%9D%98%EC%84%9C%29", "별표번호": "0001", "별표키": "21498991", "별표내용": "", "별표구분": "서식", "별표가지번호": "00"} 2026-06-25 01:49:00

Advanced export

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

CSV options:

CREATE TABLE law_appendix (
    id                  INTEGER PRIMARY KEY AUTOINCREMENT,
    law_master_id       INTEGER NOT NULL REFERENCES law_master(id) ON DELETE CASCADE,
    appendix_no         TEXT,
    appendix_branch_no  TEXT,
    appendix_type       TEXT,
    appendix_title      TEXT,
    attachment_name     TEXT,
    appendix_text       TEXT,
    extra               TEXT,
    collected_at        TEXT NOT NULL,
    UNIQUE(law_master_id, appendix_no, appendix_branch_no, appendix_title)
);
CREATE INDEX idx_law_appendix_master
    ON law_appendix(law_master_id);
Powered by Datasette · Queries took 7.962ms · Data license: 비공개