内航海運業の概況報告として、船舶の用途や船質、進水年、総トン数・載貨重量トン、長さ、馬力等の船舶スペックや航路の起終点、資本金や営業収益等に関する情報を有するデータ(2,274レコード)
元の資料: 内航海運業法登録申請書添付書類(5号様式)(使用船舶の明細)、内航海運業法登録申請書添付書類(6号様式)(内航貨物定期航路事業の明細)、内航海運業法事業概況(1号様式)(申請者の事業概要)、内航海運業事業概況報告書(2号様式)(内航海運業損益明細表)、内航海運業事業概況報告書(3号様式)(固定資産明細表)
G空間情報センターのデータセット links-naikoukaiungyou-2024 の 01_naikoukaiungyou_jigyougaikyouhoukoku.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.coastal_shipping_business_report_2024 ( ship_id VARCHAR, usage VARCHAR, ship_material VARCHAR, gross_tonnage BIGINT, deadweight_tonnage DOUBLE, length DOUBLE, horsepower BIGINT, ship_type_1 VARCHAR, ship_type_2 VARCHAR, ship_type_3 VARCHAR, launch_year_20 BIGINT, route_name BOOLEAN, route_starting_poin VARCHAR, route_end_point VARCHAR, business_management_id BIGINT, address VARCHAR, supervisory_transport_bureau VARCHAR, number_of_land_employees_rank BIGINT, number_of_land_employees_score DOUBLE, number_of_maritime_employees_rank BIGINT, number_of_maritime_employees_score DOUBLE, business_type VARCHAR, capital_amount_rank BIGINT, capital_amount_score DOUBLE, change_in_capital_during_the_term_rank BIGINT, change_in_capital_during_the_term_score BIGINT, number_of_maritime_employees_rank_1 BIGINT, number_of_maritime_employees_score_1 DOUBLE, number_of_land_employees_rank_1 BIGINT, number_of_land_employees_score_1 DOUBLE, operating_revenue_coastal_shipping_freight_contract_rank BIGINT, operating_revenue_coastal_shipping_freight_contract_score DOUBLE, operating_revenue_coastal_shipping_consignment_contract_rank BIGINT, operating_revenue_coastal_shipping_consignment_contract_score DOUBLE, operating_revenue_ship_rental_rank BIGINT, operating_revenue_ship_rental_score DOUBLE, operating_expenses_operation_consignment_fee_rank BIGINT, operating_expenses_operation_consignment_fee_score DOUBLE, operating_revenue_ship_management_income_rank BIGINT, operating_revenue_ship_management_income_score DOUBLE, total_coastal_shipping_revenue_rank BIGINT, total_coastal_shipping_revenue_score DOUBLE, other_maritime_business_income_rank BIGINT, other_maritime_business_income_score DOUBLE, other_business_income_rank BIGINT, other_business_income_score DOUBLE, total_operating_revenue_rank BIGINT, total_operating_revenue_score DOUBLE, operating_expenses_freight_costs_rank BIGINT, operating_expenses_freight_costs_score DOUBLE, operating_expenses_fuel_costs_rank BIGINT, operating_expenses_fuel_costs_score DOUBLE, operating_expenses_port_costs_rank BIGINT, operating_expenses_port_costs_score DOUBLE, operating_expenses_other_operation_costs_rank BIGINT, operating_expenses_other_operation_costs_score DOUBLE, operating_expenses_total_operation_costs_rank BIGINT, operating_expenses_total_operation_costs_score DOUBLE, operating_expenses_crew_costs_rank BIGINT, operating_expenses_crew_costs_score DOUBLE, operating_expenses_depreciation_rank BIGINT, operating_expenses_depreciation_score DOUBLE, operating_expenses_other_ship_costs_rank BIGINT, operating_expenses_other_ship_costs_score DOUBLE, operating_expenses_total_ship_costs_rank BIGINT, operating_expenses_total_ship_costs_score DOUBLE, operating_expenses_charter_costs_rank BIGINT, operating_expenses_charter_costs_score DOUBLE, operating_expenses_operation_consignment_fee_rank_1 BIGINT, operating_expenses_operation_consignment_fee_score_1 DOUBLE, operating_expenses_other_shipping_costs_rank BIGINT, operating_expenses_other_shipping_costs_score DOUBLE, operating_expenses_other_business_costs_rank BIGINT, operating_expenses_other_business_costs_score DOUBLE, operating_expenses_general_administration_costs_rank BIGINT, operating_expenses_general_administration_costs_score DOUBLE, operating_expenses_total_rank BIGINT, operating_expenses_total_score DOUBLE, operating_profit_or_loss_rank BIGINT, operating_profit_or_loss_score DOUBLE, ordinary_profit_or_loss_rank BIGINT, ordinary_profit_or_loss_score DOUBLE, fixed_assets_rank BIGINT, fixed_assets_score DOUBLE, labor_productivity_oerator DOUBLE, prefecture_code VARCHAR, source_sha256 VARCHAR );