行政事業レビューのレビューシートの基本情報です。1 行が 1 事業年度の 1 予算事業で、全府省庁の事業を収録します。
CREATE TABLE review.projects ( review_year INTEGER, project_id VARCHAR, project_name VARCHAR, sheet_url VARCHAR, policy_ministry VARCHAR, ministry VARCHAR, bureau VARCHAR, department VARCHAR, division VARCHAR, office VARCHAR, purpose VARCHAR, issues VARCHAR, overview VARCHAR, overview_url VARCHAR, project_category VARCHAR, start_year INTEGER, start_year_unknown BOOLEAN, end_year INTEGER, no_end_year BOOLEAN, major_expense_items LIST, method_direct BOOLEAN, method_subsidy BOOLEAN, method_burden BOOLEAN, method_grant BOOLEAN, method_contribution BOOLEAN, method_other BOOLEAN, former_project_number VARCHAR, notes VARCHAR, source_sha256 VARCHAR );