About this Dataset

CFS Hazmat File 2012-2022

This is the CFS area file. It describes geographic movements of hazardous 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-11T07:58:16.108091
Tags: cfs, freight, statistics

Tables

Table 1

@usgov.dot_gov_cfs_hazmat_file_2012_2022.table_1

538.7 kB
40,443 rows
64 columns

CREATE TABLE table_1 (
  "geotype" BIGINT,
  "st" BIGINT,
  "geo_id" VARCHAR,
  "geo_ttl" VARCHAR,
  "geo_id_f" VARCHAR,
  "ddestgeo" VARCHAR,
  "ddestgeo_ttl" VARCHAR,
  "naics" VARCHAR,
  "naics_ttl" VARCHAR,
  "naics_f" VARCHAR,
  "comm" BIGINT,
  "comm_ttl" VARCHAR,
  "unna" BIGINT,
  "unna_ttl" VARCHAR,
  "hazclass" BIGINT,
  "hazclass_ttl" VARCHAR,
  "dmode" BIGINT,
  "dmode_ttl" VARCHAR,
  "hazstat" BIGINT,
  "hazstat_ttl" VARCHAR,
  "instat" BIGINT,
  "instat_ttl" VARCHAR,
  "haztih" BIGINT,
  "haztih_ttl" VARCHAR,
  "hazpkg" BIGINT,
  "hazpkg_ttl" VARCHAR,
  "xdestgeo" BIGINT,
  "xdestgeo_ttl" VARCHAR,
  "tempctrl" BIGINT,
  "tempctrl_ttl" VARCHAR,
  "year" BIGINT,
  "avgmile" DOUBLE,
  "avgmile_f" VARCHAR,
  "avgmile_s" DOUBLE,
  "avgmile_s_f" VARCHAR,
  "avgmilepchg" DOUBLE,
  "avgmilepchg_f" VARCHAR,
  "avgmilepchg_s" DOUBLE,
  "avgmilepchg_s_f" VARCHAR,
  "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,
  "dmode_f" VARCHAR,
  "avgmilegcd" DOUBLE,
  "avgmilegcd_f" VARCHAR,
  "avgmilegcd_s" DOUBLE,
  "avgmilegcd_s_f" VARCHAR,
  "avgmilepchggcd" DOUBLE,
  "avgmilepchggcd_f" VARCHAR,
  "avgmilepchggcd_s" DOUBLE,
  "avgmilepchggcd_s_f" VARCHAR
);