people

Data license: 비공개

925 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, person_type, region, org, position, term, committee, gender, collected_at, birth_date (date), collected_at (date)

Next page

CREATE TABLE people (
    id             INTEGER PRIMARY KEY AUTOINCREMENT,
    source         TEXT NOT NULL,
    source_id      TEXT,
    person_type    TEXT,                     -- 'local_council'|'national_assembly'|'official'
    name           TEXT NOT NULL,
    name_hanja     TEXT,
    name_eng       TEXT,
    region         TEXT,
    org            TEXT,
    party          TEXT,
    district       TEXT,                     -- 선거구
    position       TEXT,                     -- 직책 (의원, 위원장 등)
    term           TEXT,                     -- 임기 ('제9대', '제22대' 등)
    committee      TEXT,                     -- 소속 위원회
    gender         TEXT,
    birth_date     TEXT,
    contact_tel    TEXT,
    contact_email  TEXT,
    homepage       TEXT,
    photo_url      TEXT,
    extra          TEXT,                     -- JSON
    collect_method TEXT DEFAULT 'api',
    collected_at   TEXT NOT NULL,
    UNIQUE(source, source_id)
);