Oregon Active LLCs

A list of LLCs registered in Oregon.

@kaggle.aimzieslol_oregon_active_llcs

Table List

1 table(28.79 MB)

Active Businesses Llc

@kaggle.aimzieslol_oregon_active_llcs.active_businesses_llc

28.79 MB
949159 rows
18 columns

registry_number Registry Number	business_name Business Name	entity_type Entity Type	registry_date Registry Date	associated_name_type Associated Name Type	first_name First Name	middle_name Middle Name	last_name Last Name	suffix Suffix	not_of_record_entity Not Of Record Entity	entity_of_record_reg_number Entity Of Record Reg Number	entity_of_record_name Entity Of Record Name	address Address	address_continued Address Continued	city City	state State	zip Zip	business_details Business Details
49610686	LIFE WORKS OF CENTRAL OREGON, L.L.C.	DOMESTIC LIMITED LIABILITY COMPANY	Wed Jan 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	REGISTERED AGENT	nan	nan	nan	nan	nan	33241498	MILL VIEW PROFESSIONAL SERVICES, INC.	C/O PAUL J TAYLOR	591 SW MILL VIEW WAY	BEND	OR	97702	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49610686&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49595580	SEMINOLE ESTATES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Wed Jan 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MAILING ADDRESS	nan	nan	nan	nan	nan		nan	C/O LARRY MAR -MAR ASSOCIATES	16902 BOLSA CHICA RD STE 203	HUNTINGTON BEACH	CA	92649	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49595580&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49595580	SEMINOLE ESTATES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Wed Jan 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAGER	nan	nan	nan	nan	MAR & ASSOCIATES		nan	16902 BOLSA CHICA RD STE 203	nan	HUNTINGTON BEACH	CA	92649	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49595580&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49595580	SEMINOLE ESTATES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Wed Jan 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MEMBER	nan	nan	nan	nan	LARRY MAR SUCCESSOR TRUSTEE		nan	THE RAM TRUST DATED 1/27/84	16902 BOLSA CHICA RD STE 203	HUNTINGTON BEACH	CA	92649	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49595580&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49595580	SEMINOLE ESTATES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Wed Jan 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	PRINCIPAL PLACE OF BUSINESS	nan	nan	nan	nan	nan		nan	100 SW 195TH AVE	nan	BEAVERTON	OR	97006	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49595580&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49595580	SEMINOLE ESTATES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Wed Jan 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	REGISTERED AGENT	nan	nan	nan	nan	nan	46258083	NATIONAL REGISTERED AGENTS, INC.	780 COMMERCIAL ST SE STE 100	nan	SALEM	OR	97301	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49595580&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49639289	SANTIAM PROPERTIES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Thu Jan 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MAILING ADDRESS	nan	nan	nan	nan	nan		nan	PO BOX 186	nan	HERMISTON	OR	97838	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49639289&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49639289	SANTIAM PROPERTIES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Thu Jan 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MEMBER	DANIEL	E	BRAMMER	nan	nan		nan	PO BOX 1036	nan	STANFIELD	OR	97875	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49639289&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49639289	SANTIAM PROPERTIES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Thu Jan 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MEMBER	GLENNA	R	GRAMES	nan	nan		nan	PO BOX 181	nan	HERMISTON	OR	97838	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49639289&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA
49639289	SANTIAM PROPERTIES, LLC	DOMESTIC LIMITED LIABILITY COMPANY	Thu Jan 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	MEMBER	LAWRENCE	W	GRAMES	nan	nan		nan	PO BOX 181	nan	HERMISTON	OR	97838	http://egov.sos.state.or.us/br/pkg_web_name_srch_inq.do_name_srch?p_name=&p_regist_nbr=49639289&p_srch=PHASE1&p_print=FALSE&p_entity_status=ACTINA


CREATE TABLE active_businesses_llc (
  "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" VARCHAR,
  "business_details" VARCHAR
);