시민감시 통합 DB
Data license: 비공개
Tables
announcements
id, source, source_id, announce_type, region, org, title, announce_date, deadline_date, content_summary, detail_url, extra, collect_method, collected_at
19,362 rows
attachments
id, ref_table, ref_id, file_name, file_path, file_type, original_url, file_size_kb, note, collected_at
0 rows
bills
id, source, source_id, bill_type, bill_no, bill_name, region, org, proposer, propose_date, committee, result, result_date, deadline_date, opinion_email, opinion_tel, content_summary, detail_url, extra, collect_method, collected_at
23,379 rows
budgets
id, source, source_id, budget_type, fiscal_year, region, org, department, budget_level, project_code, parent_project_code, project_name, budget_amount, execution_amount, content_summary, extra, collect_method, collected_at
0 rows
collect_log
id, table_name, source, period, region, org, status, row_count, error_msg, collected_at
2,457 rows
contracts
id, source, source_id, contract_type, region, org, vendor, contract_name, contract_amount, contract_date, contract_period, purpose, person_name, bid_method, bid_participants, evaluators, extra, collect_method, collected_at, vendor_biz_no
97,281 rows
foia_documents
id, source, source_id, region, org, doc_type, request_date, receive_date, title, file_path, content_summary, fiscal_year, extra, collect_method, collected_at
0 rows
law_appendix
id, law_master_id, appendix_no, appendix_branch_no, appendix_type, appendix_title, attachment_name, appendix_text, extra, collected_at
40,158 rows
law_article
id, law_master_id, article_key, article_no, is_article, article_title, article_text, sort_order, extra, collected_at
674,384 rows
law_finance_link
id, local_gov_code, fiscal_year, law_master_id, article_id, finance_tag, target_type, target_id, link_type, evidence_text, match_method, confidence, review_status, collected_at
0 rows
law_finance_tag
id, law_master_id, article_id, finance_tag, keyword, evidence_text, confidence, collected_at
0 rows
law_master
id, source, source_id, law_api_id, mst, law_name, law_type, region, org, promulgation_no, promulgation_date, effective_date, proposal_type, department_name, phone, revision_status, detail_url, content_summary, extra, collect_method, collected_at
51,873 rows
law_project_link
id, law_master_id, article_id, project_id, link_type, confidence, collected_at
0 rows
law_revision_history
id, law_master_id, revision_date, revision_type, revision_reason, major_changes, extra, collected_at
50,899 rows
local_announcements
id, source, gosi_type, source_id, title, department, announced_at, detail_url, attachment_path, content_md, extra, collected_at, region, org, collect_method
622 rows
lofin365_raw
id, hub_code, hub_name, hub_category, fyr, laf_cd, laf_hg_nm, row_no, row_data, collected_at
Many rows
meetings
id, source, source_id, meeting_type, region, org, meeting_date, meeting_no, term, agenda, speaker, district, content, detail_url, extra, collect_method, collected_at
18,336 rows
orgs
id, org_code, org_name, org_type, parent_org, region, homepage_url, council_url, api_inst_nm, is_active, note, created_at
0 rows
overseas_trips
id, source, source_id, region, org, trip_year, departure_date, return_date, nights, destination, purpose, total_amount, participant_count, report_filed, report_date, extra, collect_method, collected_at
0 rows
people
id, source, source_id, person_type, name, name_hanja, name_eng, region, org, party, district, position, term, committee, gender, birth_date, contact_tel, contact_email, homepage, photo_url, extra, collect_method, collected_at
925 rows
vehicle_logs
id, source, source_id, region, org, vehicle_no, vehicle_type, purpose_type, log_date, departure, destination, distance_km, driver, purpose, passenger, fuel_amount, fiscal_year, foia_doc_id, extra, collected_at
0 rows