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

236.89 KB
11192 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
);