FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

28 rows where State = "OR"

View and edit SQL

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
4662 1958-01-31 1956-07-30 Bloch Ivan 965 965 1956-07-30 Ivan Bloch & Associates 661 Park Building 729 Southwest Alder Street Portland OR  
4663 1958-01-31 1956-07-30 Bloch Ivan 966 966 1956-07-30 North Pacific Consultants 611 Park Building 220 Southwest Alder Street Portland OR  
4664 1958-01-31 1956-07-30 Moment Samuel 965 965 1956-07-30 Ivan Bloch & Associates 661 Park Building 729 Southwest Alder Street Portland OR  
5052 2003-01-31 2001-04-02 Stevenson Carmen M. 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5056 2003-01-31 2001-05-23 Ciresi Charles 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5060 2003-01-31 2000-07-07 Flanagan Kimberly 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5061 2003-01-31 2000-07-07 Holtzman Linda 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5062 2003-01-31 2000-07-07 Lane Wendy 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5063 2003-01-31 2000-07-07 Paterson Amy 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5064 2003-01-31 2000-07-07 Stammer Heather 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5065 2003-01-31 2000-07-07 Waselik Sarah 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
6011 1985-02-07 1973-04-06 Bloch Henry J. 2454 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
6012 1985-02-07 1973-04-06 Feibelmann Alice 2454 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
6013 1985-02-07 1973-04-06 Morris Dorothy L. 2454 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
6107 1994-02-08 1993-08-12 Goldschmidt Neil 4847 4847 1993-08-12 Neil Goldschmidt, Inc. 222 Southwest Columbia Suite 1850 Portland OR 97201
7078 1993-02-23 1993-01-19 Achterman Gail L. 4644 4644 1992-04-08 Neil Goldschmidt, Inc. 222 Southwest Columbia Suite 1850 Portland OR 97201-6618
7079 1993-02-23 1992-04-08 Goldschmidt Neil 4644 4644 1992-04-08 Neil Goldschmidt, Inc. 222 Southwest Columbia Suite 1850 Portland OR 97201-6618
11051 1991-03-31 1989-03-28 Beall James A. 4230 4230 1989-03-28 Ball, Janik & Novack 101 Southwest Main Street Suite 1100 Portland OR 97204
11054 1991-03-31 1989-06-16 Cram M. Victoria 4230 4230 1989-03-28 Ball, Janik & Novack 101 Southwest Main Street Suite 1100 Portland OR 97204
12080 1994-04-05 1988-06-17 Atiyeh Victor 4125 4125 1988-04-22 Victor Atiyeh & Company 519 Southwest Park Suite 208 Portland OR 97205
23852 2015-07-31 2015-03-23 Reiten Richard 6283 6283 2015-03-19 Quinn Thomas Public Affairs, LLC 5 Centerpointe Drive Suite 570 Lake Oswego OR 97035
29873 2015-09-30 2015-03-23 Badger Douglas Quinn 6283 6283 2015-03-19 Quinn Thomas Public Affairs, LLC 5 Centerpointe Drive Suite 570 Lake Oswego OR 97035
31784 2000-10-25 2000-07-07 Lundy Alison 5377 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
34936 2007-11-30 2006-02-01 Montgomery Joel R. 5721 5721 2005-11-21 Sunshine Uzbekistan USA, NFP 14525 SW Millikan Way #34692   Beaverton OR 97005-2343
34947 2007-11-30 2005-11-21 Canepa Thomas V. 5721 5721 2005-11-21 Sunshine Uzbekistan USA, NFP 14525 SW Millikan Way #34692   Beaverton OR 97005-2343
34948 2007-11-30 2005-12-01 Umarov Arslanbek 5721 5721 2005-11-21 Sunshine Uzbekistan USA, NFP 14525 SW Millikan Way #34692   Beaverton OR 97005-2343
34949 2007-11-30 2005-12-01 Umarov Gulam 5721 5721 2005-11-21 Sunshine Uzbekistan USA, NFP 14525 SW Millikan Way #34692   Beaverton OR 97005-2343
36684 2016-12-20 2011-06-01 Lubanovici Mircea 5999 5999 2009-09-14 Lubanovici, Mircea 7715 S.E. Powell Boulevard   Portland OR 97206-2348

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY(Registration_Number) REFERENCES FARA_All_Registrants(Registration_Number)
);
Powered by Datasette · Query took 390.949ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history