home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

31 rows where City = "Portland"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 11

  • Lane Marketing Communications 9
  • Kemp Goldberg Partners, LLC 5
  • Marketing International, Ltd. 4
  • Austrian National Tourist Office for the Pacific Northwest 3
  • Ivan Bloch & Associates 2
  • Ball, Janik & Novack 2
  • Neil Goldschmidt, Inc. 2
  • North Pacific Consultants 1
  • Victor Atiyeh & Company 1
  • Neil Goldschmidt, Inc. 1
  • Lubanovici, Mircea 1

Registrant_Name 10

  • Lane Marketing Communications 9
  • Kemp Goldberg Partners, LLC 5
  • Marketing International, Ltd. 4
  • Austrian National Tourist Office for the Pacific Northwest 3
  • Neil Goldschmidt, Inc. 3
  • Ball, Janik & Novack 2
  • Ivan Bloch & Associates 2
  • Lubanovici, Mircea 1
  • North Pacific Consultants 1
  • Victor Atiyeh & Company 1

State 2

  • OR 22
  • ME 9

City 1

  • Portland · 31 ✖
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
4885 4885 1958-01-31 1956-07-30 Bloch Ivan Ivan Bloch & Associates 965 1956-07-30 Ivan Bloch & Associates 661 Park Building 729 Southwest Alder Street Portland OR  
4886 4886 1958-01-31 1956-07-30 Bloch Ivan North Pacific Consultants 966 1956-07-30 North Pacific Consultants 611 Park Building 220 Southwest Alder Street Portland OR  
4887 4887 1958-01-31 1956-07-30 Moment Samuel Ivan Bloch & Associates 965 1956-07-30 Ivan Bloch & Associates 661 Park Building 729 Southwest Alder Street Portland OR  
5275 5275 2003-01-31 2001-04-02 Stevenson Carmen M. Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5279 5279 2003-01-31 2001-05-23 Ciresi Charles Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5283 5283 2003-01-31 2000-07-07 Flanagan Kimberly Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5284 5284 2003-01-31 2000-07-07 Holtzman Linda Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5285 5285 2003-01-31 2000-07-07 Lane Wendy Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5286 5286 2003-01-31 2000-07-07 Paterson Amy Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5287 5287 2003-01-31 2000-07-07 Stammer Heather Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
5288 5288 2003-01-31 2000-07-07 Waselik Sarah Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
6312 6312 1985-02-07 1973-04-06 Bloch Henry J. Austrian National Tourist Office for the Pacific Northwest 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
6313 6313 1985-02-07 1973-04-06 Feibelmann Alice Austrian National Tourist Office for the Pacific Northwest 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
6314 6314 1985-02-07 1973-04-06 Morris Dorothy L. Austrian National Tourist Office for the Pacific Northwest 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
6414 6414 1994-02-08 1993-08-12 Goldschmidt Neil Neil Goldschmidt, Inc. 4847 1993-08-12 Neil Goldschmidt, Inc. 222 Southwest Columbia Suite 1850 Portland OR 97201
7466 7466 1993-02-23 1993-01-19 Achterman Gail L. Neil Goldschmidt, Inc. 4644 1992-04-08 Neil Goldschmidt, Inc. 222 Southwest Columbia Suite 1850 Portland OR 97201-6618
7467 7467 1993-02-23 1992-04-08 Goldschmidt Neil Neil Goldschmidt, Inc. 4644 1992-04-08 Neil Goldschmidt, Inc. 222 Southwest Columbia Suite 1850 Portland OR 97201-6618
11639 11639 1991-03-31 1989-03-28 Beall James A. Ball, Janik & Novack 4230 1989-03-28 Ball, Janik & Novack 101 Southwest Main Street Suite 1100 Portland OR 97204
11642 11642 1991-03-31 1989-06-16 Cram M. Victoria Ball, Janik & Novack 4230 1989-03-28 Ball, Janik & Novack 101 Southwest Main Street Suite 1100 Portland OR 97204
12788 12788 1994-04-05 1988-06-17 Atiyeh Victor Victor Atiyeh & Company 4125 1988-04-22 Victor Atiyeh & Company 519 Southwest Park Suite 208 Portland OR 97205
12821 12821 1979-04-06 1979-04-09 Martin Mary V. Marketing International, Ltd. 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
29207 29207 1979-09-05 1974-09-05 Andersen Torben K. Marketing International, Ltd. 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
30388 30388 2014-09-24 2014-09-24 Fibich Don Kemp Goldberg Partners, LLC 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
30389 30389 2014-09-24 2014-09-24 LaVallee Derek Kemp Goldberg Partners, LLC 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
30390 30390 2014-09-24 2014-09-24 Philbrook Christopher Kemp Goldberg Partners, LLC 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
30391 30391 2014-09-24 2014-09-24 Sommer Leah Kemp Goldberg Partners, LLC 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
30392 30392 2014-09-24 2014-09-24 Ventura Dan Kemp Goldberg Partners, LLC 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
32842 32842 1978-10-15 1974-09-05 Miller Isabell Marketing International, Ltd. 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
32843 32843 1978-10-15 1971-10-18 Breitenberg Lynn Marketing International, Ltd. 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
33641 33641 2000-10-25 2000-07-07 Lundy Alison Lane Marketing Communications 5377 2000-07-07 Lane Marketing Communications 905 S.W. 16th Avenue   Portland OR 97205
38850 38850 2016-12-20 2011-06-01 Lubanovici Mircea Lubanovici, Mircea 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 · Queries took 320.15ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows