home

Menu
  • Log in

시민감시 통합 DB

의원·의안·계약·재정·법령 통합 (2.9GB, 매일 자동 수집)

Data license: 비공개

Custom SQL query

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

cleaneye_raw

id, svc_code, svc_name, ac_year, ent_name, row_no, row_data, collected_at

33,107 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_department_link

id, law_master_id, dept_code, mapping_basis, confidence, collected_at

0 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_fund_link

id, law_master_id, article_id, fund_name, legal_basis, purpose, 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_exec_raw

id, laf_cd, sgg_nm, inq_yr, rn, code, row_data, collected_at

58,040 rows

lofin365_portal_raw

id, api_code, api_name, laf_cd, inq_yr, rn, row_data, collected_at

6 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

sqlite_sequence

name, seq

15 rows

trip_participants

id, trip_id, person_name, position, org, amount, extra, collected_at

0 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

Powered by Datasette · Queries took 49.363ms · Data license: 비공개