local_announcements

Data license: 비공개

622 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: announced_at (date), collected_at (date)

Next page

CREATE TABLE local_announcements (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    source          TEXT NOT NULL,
    gosi_type       TEXT NOT NULL,
    source_id       TEXT NOT NULL,
    title           TEXT,
    department      TEXT,
    announced_at    TEXT,
    detail_url      TEXT,
    attachment_path TEXT,
    content_md      TEXT,
    extra           TEXT,
    collected_at    TEXT NOT NULL, region TEXT, org TEXT, collect_method TEXT DEFAULT 'crawl',
    UNIQUE(source, source_id)
);