官公需情報ポータルサイトに載った入札公告です。1 行が 1 公告で、公告日の順に並びます。
CREATE TABLE tender.notices ( notice_key VARCHAR, project_name VARCHAR, organization_name VARCHAR, prefecture_code VARCHAR, prefecture_name VARCHAR, lg_code VARCHAR, city_code VARCHAR, city_name VARCHAR, category VARCHAR, procedure_type VARCHAR, certifications LIST, location VARCHAR, item_code VARCHAR, cft_issue_date DATE, tender_submission_date DATE, opening_tenders_date DATE, period_end_date DATE, description VARCHAR, document_url VARCHAR, file_type VARCHAR, file_size BIGINT, attachments LIST, crawled_at TIMESTAMP WITH TIME ZONE, fetched_at TIMESTAMP WITH TIME ZONE );