About this Dataset

Vehicle, Snowmobile, And Boat Registrations

This dataset contains the file of vehicle, snowmobile and boat registrations in NYS. Registrations expired more than 2 years are excluded. Records that have a scofflaw, revocation and/or suspension are included with indicators specifying those kinds of records.
Organization: State of New York
Last updated: 2020-11-12T04:00:36.172999
Tags: boat, dmv, registration, snowmobile, sticker, trailer, vehicle

Tables

Table 1

@usgov.state_of_new_york_vehicle_snowmobile_and_boat_registrations.table_1

214 MB
12,369,732 rows
20 columns

CREATE TABLE table_1 (
  "record_type" VARCHAR,
  "vin" VARCHAR,
  "registration_class" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "county" VARCHAR,
  "model_year" DOUBLE,
  "make" VARCHAR,
  "body_type" VARCHAR,
  "fuel_type" VARCHAR,
  "unladen_weight" DOUBLE,
  "maximum_gross_weight" DOUBLE,
  "passengers" DOUBLE,
  "reg_valid_date" TIMESTAMP,
  "reg_expiration_date" TIMESTAMP,
  "color" VARCHAR,
  "scofflaw_indicator" VARCHAR,
  "suspension_indicator" VARCHAR,
  "revocation_indicator" VARCHAR
);