FARA_All_Registrants

List of all registrant data (active and terminated)

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

22 rows where City = "Seattle"

View and edit SQL

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

State

City

  • Seattle · 22
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  
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
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
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
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
6195 2013-11-18   Korea SMEs and Startups Agency USA Office   1730 Minor Avenue 10th Floor - Suite 1050 Seattle WA 98101
6575 2018-07-23 2019-01-24 Pamoja USA, LLC   1670 S Roberto Maestas Festival St Unit 312   Seattle WA 98144
6712 2019-08-29   Harris Bricken McVay Sliwoski, LLP   600 Stewart Street Suite 1200 Seattle WA 98101

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)
);
Powered by Datasette · Query took 43.069ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history