계약·결산 정리본

계약 85,892건 / 결산 158,759건 / 보조금 16,634건

Data license: 비공개

Custom SQL query

Tables

budget

budget_id, gov_code, dept_norm, fiscal_year, project_name, budget_amount, source_table, source_id

0 rows

contract

contract_id, source_id, gov_code, dept_original, dept_norm, dept_category, fiscal_year, contract_date, contract_name, category, category_detail, method, is_negotiated, vendor, vendor_bizno, amount, source_table, source_file

Many rows

dept

dept_id, gov_code, dept_original, dept_norm, dept_category, contract_cnt

270 rows

gov

gov_code, gov_name, org_type, parent_code

8 rows

legislation

leg_id, gov_code, title, title_norm, leg_type, status, propose_date, result_date, source_table, source_id, source_file

0 rows

link

link_id, leg_id, contract_id, settlement_id, score, score_keyword, score_dept, score_year, score_amount, match_keywords, human_verified

1,643 rows

settlement

settlement_id, gov_code, fiscal_year, category_code, category_name, amount, source_table, hub_code

158,759 rows

sqlite_sequence

name, seq

5 rows

subsidy

subsidy_id, gov_code, fiscal_year, category_code, category_name, amount, source_table, hub_code

16,634 rows

Views