About this Dataset

Commissioned NYS Notaries Public

This data contains active Commissioned Notaries Public from New York State Department of State (DOS). Each line will be either an individual or business licensee which holds business address and license number information. If the license type is an individual, the business name that the individual works for will be listed.
Organization: State of New York
Last updated: 2023-07-14T07:47:47.106916
Tags: commission, notary

Tables

Table 1

@usgov.state_of_new_york_commissioned_nys_notaries_public.table_1

10.08 MB
255,312 rows
13 columns

CREATE TABLE table_1 (
  "commission_holder_name" VARCHAR,
  "commission_number_uid" VARCHAR  -- Commission Number (UID),
  "business_name_if_available" VARCHAR  -- Business Name (if Available),
  "business_address_1_if_available" VARCHAR  -- Business Address 1 (if Available),
  "business_address_2_if_available" VARCHAR  -- Business Address 2 (if Available),
  "n__business_city_if_available" VARCHAR  -- Business City (if Available),
  "business_state_if_available" VARCHAR  -- Business State (if Available),
  "business_zip_if_available" VARCHAR  -- Business Zip (if Available),
  "commissioned_county" VARCHAR,
  "commission_type_traditional_or_electronic" VARCHAR  -- Commission Type (Traditional Or Electronic),
  "term_issue_date" TIMESTAMP,
  "term_expiration_date" TIMESTAMP,
  "georeference" VARCHAR
);