Dataset: New Business List - March

About this Dataset

New Business List - March

Businesses registered with the Secretary of State Corporation Division during the month of March.
Organization: State of Oregon
Last updated: 2020-11-10T17:22:39.559053
Tags: business-name, registration

Tables

Table 1

@usgov.state_of_oregon_new_business_list_march.table_1

858.21 KB
36838 rows
17 columns


CREATE TABLE table_1 (
  "registry_number" BIGINT,
  "business_name" VARCHAR,
  "entity_type" VARCHAR,
  "registry_date" TIMESTAMP,
  "associated_name_type" VARCHAR,
  "first_name" VARCHAR,
  "middle_name" VARCHAR,
  "last_name" VARCHAR,
  "suffix" VARCHAR,
  "not_of_record_entity" VARCHAR,
  "entity_of_record_reg_number" DOUBLE,
  "entity_of_record_name" VARCHAR,
  "address" VARCHAR,
  "address_continued" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR
);