Name: DMV Office Locations, Hours And Messages
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DMV Office Locations, Hours And Messages

Hours, locations, contact info and messages regarding public, NYS DMV offices for which a notation is being displayed at DMV.NY.GOV.
Organization: State of New York
Last updated: 2022-09-08T21:08:08.652540
Tags: dmv, dmv-hours, dmv-office, dmv-office-message, dmv-office-service, holidays

Tables

Table 1

@usgov.state_of_new_york_dmv_office_locations_hours_and_messages.table_1

57.74 KB
144 rows
47 columns


CREATE TABLE table_1 (
  "office_name" VARCHAR,
  "office_type" VARCHAR,
  "street_address" VARCHAR,
  "street_address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "county" VARCHAR,
  "monday_opening_hours" VARCHAR,
  "monday_closing_hours" VARCHAR,
  "tuesday_opening_hours" VARCHAR,
  "tuesday_closing_hours" VARCHAR,
  "wednesday_opening_hours" VARCHAR,
  "wednesday_closing_hours" VARCHAR,
  "thursday_opening_hours" VARCHAR,
  "thursday_closing_hours" VARCHAR,
  "friday_opening_hours" VARCHAR,
  "friday_closing_hours" VARCHAR,
  "saturday_opening_hours" VARCHAR,
  "saturday_closing_hours" VARCHAR,
  "sunday_opening_hours" VARCHAR,
  "sunday_closing_hours" VARCHAR,
  "monday_opening_hours_summer" VARCHAR,
  "monday_closing_hours_summer" VARCHAR,
  "tuesday_opening_hours_summer" VARCHAR,
  "tuesday_closing_hours_summer" VARCHAR,
  "wednesday_opening_hours_summer" VARCHAR,
  "wednesday_closing_hours_summer" VARCHAR,
  "thursday_opening_hours_summer" VARCHAR,
  "thursday_closing_hours_summer" VARCHAR,
  "friday_opening_hours_summer" VARCHAR,
  "friday_closing_hours_summer" VARCHAR,
  "saturday_opening_hours_summer" VARCHAR,
  "saturday_closing_hours_summer" VARCHAR,
  "sunday_opening_hours_summer" VARCHAR,
  "sunday_closing_hours_summer" VARCHAR,
  "office_holiday" VARCHAR,
  "office_holiday_date" TIMESTAMP,
  "hours_message" VARCHAR,
  "directions" VARCHAR,
  "message_begin_date" TIMESTAMP,
  "message_end_date" TIMESTAMP,
  "message" VARCHAR,
  "office_web_link" VARCHAR,
  "hours_begin_date_summer" TIMESTAMP,
  "hours_end_date_summer" TIMESTAMP,
  "georeference" VARCHAR
);