財務に関する事業概況報告書は、報告事業種別(路線バス、貸切バス、タクシー)、経営形態、資本金、発行済株式数、事業の名称、従業員数、営業収入、営業収益、営業費用、営業損益、営業外収益、営業外損益、特別損益、法人税、投資その他の資産等に関する情報を、ランク化及び偏差値により秘匿化したデータ化です。(1,036レコード)
元の資料: 一般旅客自動車運送事業 事業概況報告書(乗合・貸切・乗用)
G空間情報センターのデータセット links-ippanryokyaku-2025 の 04_ippanryokyakujidousya_jigyougaikyou.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.passenger_motor_carrier_overview ( year BIGINT, reportperiod_from VARCHAR, reportperiod_to VARCHAR, operatorinfo_operatorid BIGINT, reportedbusinesstype_taxi_or_for_hire BIGINT, reportedbusinesstype_charter BIGINT, reportedbusinesstype_scheduled BIGINT, address VARCHAR, address_geometry GEOMETRY, managementandcapital_businesstype VARCHAR, managementandcapital_capitalamount_rank VARCHAR, managementandcapital_issuedshares_rank VARCHAR, managedbusiness_1_businessname VARCHAR, managedbusiness_1_employees_rank VARCHAR, managedbusiness_1_revenueshare_rank VARCHAR, managedbusiness_2_businessname VARCHAR, managedbusiness_2_employees_rank VARCHAR, managedbusiness_2_revenueshare_rank VARCHAR, managedbusiness_3_businessname VARCHAR, managedbusiness_3_employees_rank VARCHAR, managedbusiness_3_revenueshare_rank VARCHAR, managedbusiness_4_businessname VARCHAR, managedbusiness_4_employees_rank VARCHAR, managedbusiness_4_revenueshare_rank VARCHAR, managedbusiness_5_businessname VARCHAR, managedbusiness_5_employees_rank VARCHAR, managedbusiness_5_revenueshare_rank VARCHAR, managedbusiness_6_businessname VARCHAR, managedbusiness_6_employees_rank VARCHAR, managedbusiness_6_revenueshare_rank VARCHAR, managedbusiness_7_businessname VARCHAR, managedbusiness_7_employees_rank VARCHAR, managedbusiness_7_revenueshare_rank VARCHAR, managedbusiness_8_businessname VARCHAR, managedbusiness_8_employees_rank VARCHAR, managedbusiness_8_revenueshare_rank VARCHAR, operatingrevenue_rank VARCHAR, operatingexpense_rank VARCHAR, operatingprofitorloss_rank VARCHAR, nonoperatingincome_rank VARCHAR, nonoperatingexpense_rank VARCHAR, ofwhich_financialexpense_rank VARCHAR, nonoperatingprofitorloss_rank VARCHAR, ordinaryprofitorloss_rank VARCHAR, extraordinarygainorloss_rank VARCHAR, profitbeforetax_rank VARCHAR, corporatetax_rank VARCHAR, corporatetaxadjustment_rank VARCHAR, netprofitorloss_rank VARCHAR, totalcurrentassets_rank VARCHAR, cashanddeposits_rank VARCHAR, uncollectedfare_rank VARCHAR, accountsreceivable_rank VARCHAR, totalfixedassets_rank VARCHAR, tangiblefixedassets_rank VARCHAR, ofwhich_constructioninprogress_rank VARCHAR, intangiblefixedassets_rank VARCHAR, investmentsandotherassets_rank VARCHAR, deferredassets_rank VARCHAR, totalassets_rank VARCHAR, totalcurrentliabilities_rank VARCHAR, fixedliabilities_rank VARCHAR, totalliabilities_rank VARCHAR, capitalstock_rank VARCHAR, totalshareholdersequity_rank VARCHAR, prefecture_code VARCHAR, source_sha256 VARCHAR );