FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

35 rows where State = "WA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Zip, Registration_Date (date), Termination_Date (date)

State 1

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
99 1942-08-17 1943-02-17 Ryan, Askren & Mathewson   545 Henry Building   Seattle WA  
200 1943-07-03 1943-09-11 Redfield, Roy A.   919 Paulsen Building   Spokane WA 00000
2084 1968-03-27 1997-09-27 British Columbia Government   720 Olive Way Suite 1020 Seattle WA 98101
2292 1971-12-03 1971-12-03 Clinton, Moats, Anderson & Fleck, Attorneys at Law   500 Third & Lenora Building   Seattle WA 98121
2302 1972-01-05 1978-10-24 Sales Northwest of Australia   Post Office Box 871   Bellevue WA 98009
2438 1973-07-02   Kobe Trade Information Office   1001 Fourth Avenue Suite 4310 Seattle WA 98154
2495 1974-02-19 1984-11-06 Korea Trade Center, Seattle   Bank of California Center Suite 1245 Seattle WA 98164
2603 1975-09-02 1992-07-01 Ehrig & Associates, Inc.   Post Office Box 9940   Seattle WA 98109
2865 1978-02-23 1978-12-14 Clinton, Fleck, Glein & Brown   2112 Third Avenue Suite 500 Seattle WA 98121
2867 1978-03-14 2016-03-31 Hastings, Jay Donald   1676 Parkview Drive N.E.   Bainbridge Island WA 98110-2349
3047 1979-08-09   Foster Garvey PC   1111 Third Avenue Suite 3000 Seattle WA 98101
3210 1981-03-03 1981-09-15 Sharp, Hartwig & Vladimir   2819 Elliott Avenue   Seattle WA 98121
3258 1981-07-13 1983-08-25 Preston, Thorgrimson, Ellis & Holman   2000 IBM Building   Seattle WA 98101
3380 1982-06-16 1993-06-30 Tourism British Columbia   720 Olive Way Suite 930 Seattle WA 98101
3407 1982-09-07 1988-09-30 Mundt, MacGregor, Happel, Falconer, Zulauf & Hall   4200 First Interstate Center   Seattle WA 98104
3474 1983-05-24 1992-11-24 Bogle & Gates   Two Union Square 601 Union Street Seattle WA 98101-2346
3567 1984-03-22 1997-04-22 Preston, Gates & Ellis, L.L.P.   5000 Columbia Center 701 Fifth Avenue Seattle WA 98104-7078
3992 1987-06-15 2000-03-31 Bernhagen & Associates   10233 - 26th Avenue, S.W.   Seattle WA 98146
4186 1988-11-01 1988-11-01 Francis & Nichols, Inc., P.S.   1600 Seattle Tower 1218 Third Avenue Seattle WA 98101
4469 1991-01-14 1992-03-06 Hansen, Donald K.   Island Village 321 High School Rd., Suite 301 Bainbridge Island WA 98110
4594 1991-11-14 1998-11-25 Rockey Company, Inc.   2121 Fifth Avenue   Seattle WA 98121
4597 1991-11-26 1993-12-17 British Columbia Trade Center   720 Olive Way Suite 930 Seattle WA 98101
4852 1993-09-28 1995-03-31 Redman, Eric   Heller Ehrman White McAuliffe 701 Fifth Avenue, Suite 6100 Seattle WA 98104-7098
5023 1995-06-08 1995-06-08 Tiongson, Noel Viri   12506 Northeast 28th Street   Bellevue WA 98005
5243 1998-03-17 1999-09-30 Cominco American Incorporated   15918 East Euclid Avenue   Spokane WA 99216-1815
5653 2004-10-26 2007-10-31 Mohamed, Koshin A.   1215 Central Avenue South Suite 215 Kent WA 98032-7437
6195 2013-11-18   Korea SMEs and Startups Agency USA Office   1730 Minor Avenue 10th Floor - Suite 1050 Seattle WA 98101
6304 2015-07-09 2015-09-30 Northwest Communications Inc.   610 Market Street #201   Kirkland WA 98033
6575 2018-07-23 2019-01-24 Pamoja USA, LLC   1670 S Roberto Maestas Festival St Unit 312   Seattle WA 98144
6655 2019-04-03 2022-04-30 PacRim Bridges, LLC   7028 Dahlberg Road   Ferndale WA 98248
6670 2019-04-26 2019-06-30 JPW Communications   706 East Plateau Road   Spokane WA 99203
6712 2019-08-29 2020-07-17 Harris Bricken Sliwoski LLP   600 Stewart Street Suite 1200 Seattle WA 98101
6867 2020-09-10 2020-09-10 Khomutov, Andrey Vladimirovich   1225 E. Sunset Drive Suite 145 PMB1044 Bellingham WA 98226
7080 2022-02-16 2023-02-28 Morris, Luis A.   Bank of America Plaza - 800 5th Ave. SW STE. #101-260 Seattle WA 98104
7166 2022-09-09   Davis Wright Tremaine LLP   920 Fifth Ave, Suite 3300   Seattle WA 98104

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);