home / civic

Menu
  • Log in

law_appendix

Data license: 비공개

1 row where law_master_id = 68

✎ 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
6328 68 68 0001 00 서식 [별지 제1호서식]공용차량 자동차보험 자기부담금 지원 신청서 http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=161660173&flNm=%5B%EB%B3%84%EC%A7%80+%EC%A0%9C1%ED%98%B8%EC%84%9C%EC%8B%9D%5D%EA%B3%B5%EC%9A%A9%EC%B0%A8%EB%9F%89+%EC%9E%90%EB%8F%99%EC%B0%A8%EB%B3%B4%ED%97%98+%EC%9E%90%EA%B8%B0%EB%B6%80%EB%8B%B4%EA%B8%88+%EC%A7%80%EC%9B%90+%EC%8B%A0%EC%B2%AD%EC%84%9C   {"별표제목": "[별지 제1호서식]공용차량 자동차보험 자기부담금 지원 신청서", "별표첨부파일구분": "hwpx", "별표첨부파일명": "http://www.law.go.kr/flDownload.do?gubun=ELIS&flSeq=161660173&flNm=%5B%EB%B3%84%EC%A7%80+%EC%A0%9C1%ED%98%B8%EC%84%9C%EC%8B%9D%5D%EA%B3%B5%EC%9A%A9%EC%B0%A8%EB%9F%89+%EC%9E%90%EB%8F%99%EC%B0%A8%EB%B3%B4%ED%97%98+%EC%9E%90%EA%B8%B0%EB%B6%80%EB%8B%B4%EA%B8%88+%EC%A7%80%EC%9B%90+%EC%8B%A0%EC%B2%AD%EC%84%9C", "별표번호": "0001", "별표키": "21539831", "별표내용": "", "별표구분": "서식", "별표가지번호": "00"} 2026-06-27 00:54:53

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.795ms · Data license: 비공개