Dataset: New Business List - January

About this Dataset

New Business List - January

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

Tables

Table 1

@usgov.state_of_oregon_new_business_list_january.table_1

886.88 KB
38749 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
);