bills

Data license: 비공개

23,379 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, bill_type, region, org, committee, result, propose_date (date), result_date (date), collected_at (date)

Next page

CREATE TABLE bills (
    id             INTEGER PRIMARY KEY AUTOINCREMENT,
    source         TEXT NOT NULL,
    source_id      TEXT,
    bill_type      TEXT,                     -- 'local_bill'|'national_bill'|'pre_announcement'
    bill_no        TEXT,
    bill_name      TEXT NOT NULL,
    region         TEXT,
    org            TEXT,
    proposer       TEXT,
    propose_date   TEXT,
    committee      TEXT,
    result         TEXT,                     -- 처리 결과
    result_date    TEXT,
    -- 입법예고 전용
    deadline_date  TEXT,                     -- 의견 제출 마감일
    opinion_email  TEXT,                     -- 의견 제출 이메일
    opinion_tel    TEXT,                     -- 의견 제출 전화
    -- 공통
    content_summary TEXT,
    detail_url     TEXT,
    extra          TEXT,                     -- JSON
    collect_method TEXT DEFAULT 'api',
    collected_at   TEXT NOT NULL,
    UNIQUE(source, source_id)
);