About this Dataset

CFS Export File 2012-2022

This is the CFS export file. It describes geographic movements of all exported commodities and includes breakdowns by mode, NAICS, commodity, shipping distance, shipment weight. It includes estimates for tonnage, value, average mile per shipment (Geomiler estimate (2012 and 2017) or GCD (2022))
Organization: Department of Transportation
Last updated: 2025-07-11T14:22:53.929893
Tags: cfs, freight, statistics

Tables

Table 1

@usgov.dot_gov_cfs_export_file_2012_2022.table_1

242.58 kB
11,192 rows
33 columns

CREATE TABLE table_1 (
  "geotype" BIGINT,
  "st" BIGINT,
  "geo_id" VARCHAR,
  "geo_ttl" VARCHAR,
  "geo_id_f" VARCHAR,
  "naics" VARCHAR,
  "naics_ttl" VARCHAR,
  "naics_f" VARCHAR,
  "comm" BIGINT,
  "comm_ttl" VARCHAR,
  "xmode" DOUBLE,
  "xmode_ttl" VARCHAR,
  "dmode" BIGINT,
  "dmode_ttl" VARCHAR,
  "xdestgeo" BIGINT,
  "xdestgeo_ttl" VARCHAR,
  "year" BIGINT,
  "ton" BIGINT,
  "ton_f" VARCHAR,
  "ton_s" DOUBLE,
  "ton_s_f" VARCHAR,
  "tonpchg" DOUBLE,
  "tonpchg_f" VARCHAR,
  "tonpchg_s" DOUBLE,
  "tonpchg_s_f" VARCHAR,
  "val" BIGINT,
  "val_f" VARCHAR,
  "val_s" DOUBLE,
  "val_s_f" VARCHAR,
  "valpchg" DOUBLE,
  "valpchg_f" VARCHAR,
  "valpchg_s" DOUBLE,
  "valpchg_s_f" VARCHAR
);