内航海運業の概況報告として、船舶の用途や船質、進水年、総トン数・載貨重量トン、長さ、馬力等の船舶スペックや航路の起終点、資本金や営業収益等に関する情報を有するもので、2023年度以前の船舶データ(2,710レコード)
元の資料: 内航海運業法登録申請書添付書類(5号様式)(使用船舶の明細)、内航海運業法登録申請書添付書類(6号様式)(内航貨物定期航路事業の明細)、内航海運業法事業概況(1号様式)(申請者の事業概要)、内航海運業事業概況報告書(2号様式)(内航海運業損益明細表)、内航海運業事業概況報告書(3号様式)(固定資産明細表)
G空間情報センターのデータセット links-naikoukaiungyou-2025 の 01_naikoukaiungyou_jigyougaikyouhoukoku.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.coastal_shipping_business_report ( ship_id BIGINT, usage VARCHAR, ship_material VARCHAR, gross_tonnage DOUBLE, deadweight_tonnage DOUBLE, length DOUBLE, horsepower BIGINT, ship_type_1 VARCHAR, ship_type_2 VARCHAR, ship_type_3 VARCHAR, launch_year_20 VARCHAR, business_management_id BIGINT, address VARCHAR, supervisory_transport_bureau VARCHAR, number_of_land_employees_rank VARCHAR, number_of_maritime_employees_rank VARCHAR, business_type VARCHAR, capital_amount_rank VARCHAR, change_in_capital_during_the_term_rank VARCHAR, operating_revenue_coastal_shipping_freight_contract_rank VARCHAR, operating_revenue_coastal_shipping_consignment_contract_rank VARCHAR, operating_revenue_ship_rental_rank VARCHAR, operating_revenue_operation_consignment_fee_rank VARCHAR, total_coastal_shipping_revenue_rank VARCHAR, other_maritime_business_income_rank VARCHAR, other_business_income_rank VARCHAR, total_operating_revenue_rank VARCHAR, operating_expenses_freight_costs_rank VARCHAR, operating_expenses_fuel_costs_rank VARCHAR, operating_expenses_port_costs_rank VARCHAR, operating_expenses_other_operation_costs_rank VARCHAR, operating_expenses_total_operation_costs_rank VARCHAR, operating_expenses_crew_costs_rank VARCHAR, operating_expenses_depreciation_rank VARCHAR, operating_expenses_other_ship_costs_rank VARCHAR, operating_expenses_total_ship_costs_rank VARCHAR, operating_expenses_charter_costs_rank VARCHAR, operating_expenses_operation_consignment_fee_rank VARCHAR, operating_expenses_other_shipping_costs_rank VARCHAR, operating_expenses_other_business_costs_rank VARCHAR, operating_expenses_general_administration_costs_rank VARCHAR, operating_expenses_total_rank VARCHAR, operating_profit_or_loss_rank VARCHAR, ordinary_profit_or_loss_rank VARCHAR, fixed_assets_rank VARCHAR, prefecture_code VARCHAR, source_sha256 VARCHAR );