About this Dataset

VIUS Public Use File Data

This is a recoded version of the 2021 VIUS Public Use file.

The Original is found at https://www2.census.gov/programs-surveys/vius/datasets/2021/ and should be used as the most up to date version. This version will be updated as need be and was extracted 2/2/2024.

The main difference between the files is that the data dictionary has been incorporated into the database to minimize cross-checking.
Organization: Department of Transportation
Last updated: 2024-02-06T16:31:15.893156
Tags: vius

Tables

Table 1

@usgov.dot_gov_vius_public_use_file_data.table_1

4.82 MB
67,952 rows
168 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "tabweight" DOUBLE,
  "regstate" VARCHAR,
  "acquireyear" VARCHAR,
  "acquisition" VARCHAR,
  "avgweight" VARCHAR,
  "brakes" VARCHAR,
  "btype" VARCHAR,
  "busrelated" VARCHAR,
  "cab" VARCHAR,
  "cabday" VARCHAR,
  "cabheight" VARCHAR,
  "ci_autoebrake" VARCHAR,
  "ci_autoesteer" VARCHAR,
  "ci_rautoebrake" VARCHAR,
  "cubicinchdisp" VARCHAR,
  "cw_blindspot" VARCHAR,
  "cw_fwdcoll" VARCHAR,
  "cw_lanedepart" VARCHAR,
  "cw_parkobst" VARCHAR,
  "cw_rcrosstraf" VARCHAR,
  "cylinders" VARCHAR,
  "dc_actdrivasst" VARCHAR,
  "dc_adapcruise" VARCHAR,
  "dc_laneasst" VARCHAR,
  "dc_platoon" VARCHAR,
  "dc_vtvcomm" VARCHAR,
  "deadheadpct" VARCHAR,
  "driveaxles" VARCHAR,
  "engrebuild" VARCHAR,
  "er_compown" VARCHAR,
  "er_cost" VARCHAR,
  "er_dealer" VARCHAR,
  "er_general" VARCHAR,
  "er_leasing" VARCHAR,
  "er_other" VARCHAR,
  "er_self" VARCHAR,
  "er_unkloc" VARCHAR,
  "fe_aerobump" VARCHAR,
  "fe_aerohood" VARCHAR,
  "fe_aeromirror" VARCHAR,
  "fe_autoengoff" VARCHAR,
  "fe_autotireinf" VARCHAR,
  "fe_fairings" VARCHAR,
  "fe_ftcover" VARCHAR,
  "fe_gapreducer" VARCHAR,
  "fe_hybdrivenp" VARCHAR,
  "fe_hybdrivepl" VARCHAR,
  "fe_idlereduce" VARCHAR,
  "fe_lrrtires" VARCHAR,
  "fe_nosecone" VARCHAR,
  "fe_sideskirt" VARCHAR,
  "ftype" VARCHAR,
  "fueltype" VARCHAR,
  "fuelwhere" VARCHAR,
  "gm_compown" VARCHAR,
  "gm_cost" VARCHAR,
  "gm_dealer" VARCHAR,
  "gm_general" VARCHAR,
  "gm_leasing" VARCHAR,
  "gm_other" VARCHAR,
  "gm_self" VARCHAR,
  "gvwr_class" VARCHAR,
  "hazcarry" VARCHAR,
  "hazpct" VARCHAR,
  "hbstate" VARCHAR,
  "hbtype" VARCHAR,
  "ju_canada" VARCHAR,
  "ju_homebase" VARCHAR,
  "ju_mexico" VARCHAR,
  "ju_otherst" VARCHAR,
  "kindofbus" VARCHAR,
  "le_height" VARCHAR,
  "le_weightbr" VARCHAR,
  "le_weighthi" VARCHAR,
  "leasechar" VARCHAR,
  "leaselength" VARCHAR,
  "leasestat" VARCHAR,
  "lf_below" VARCHAR,
  "lf_beyond" VARCHAR,
  "lf_forward" VARCHAR,
  "loadedpct" VARCHAR,
  "lp_financeonly" VARCHAR,
  "lp_fuelcont" VARCHAR,
  "lp_fullmaint" VARCHAR,
  "lp_licenseperm" VARCHAR,
  "lp_paytax" VARCHAR,
  "lp_recordkeep" VARCHAR,
  "ltruckloadpct" VARCHAR,
  "milesannl" BIGINT,
  "mileslife" VARCHAR,
  "modelyear" VARCHAR,
  "monthoperate" VARCHAR,
  "mpg" VARCHAR,
  "numbraking" VARCHAR,
  "numgears" VARCHAR,
  "numliftable" VARCHAR,
  "od_ahighbeam" VARCHAR,
  "od_backupcam" VARCHAR,
  "od_drivermon" VARCHAR
);