FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
80 rows where City = "San Francisco"
This data as json, CSV (advanced)
Address_1 28
- 3 Embarcadero Center 2
- 100 The Embarcadero 1
- 123 Hanover Street 1
- 130 Montgomery Street 1
- 180 Montgomery Street 1
- 2 Embarcadero Center 1
- 221 Main Street 1
- 235 Montgomery Street 1
- 300 Montgomery Street 1
- 332 Pine Street 1
- 350 Pacific Avenue 1
- 3825 Scott Street 1
- 4200 California Street 1
- 44 Montgomery 1
- 44 Montgomery Street 1
- 444 DeHaro Street 1
- 456 Montgomery Street 1
- 465 California Street 1
- 50 California Street 1
- 539 19th Avenue 1
- 582 Market Street 1
- 665 Third Street 1
- 680 Beach Street 1
- 874 North Point 1
- Alcoa Building 1
- Four Embarcadero Center 1
- One Market Street 1
- Three Embarcadero Center 1
State 1
- CA 29
City 1
- San Francisco · 29 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3249 | 1981-06-18 | 1984-09-20 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 | |
3252 | 1981-06-24 | 1986-07-18 | Ford & Vlahos | Alcoa Building | 1 Maritime Plaza, Suite 1313 | San Francisco | CA | 94111 | |
3254 | 1981-07-02 | 1983-02-23 | Ernest Beyl Public Relations, Inc. | 680 Beach Street | Suite 315 | San Francisco | CA | 94109 | |
3316 | 1981-12-17 | 1984-05-30 | Sullivan, Robert J. | 44 Montgomery | 5th Floor | San Francisco | CA | 94104 | |
3345 | 1982-03-12 | 1985-04-17 | Neptune Orient Lines, Ltd. | 300 Montgomery Street | Suite 540 | San Francisco | CA | 94104 | |
3377 | 1982-06-08 | 1989-12-31 | Russom & Leeper | 350 Pacific Avenue | San Francisco | CA | 94111 | ||
3421 | 1982-11-18 | 1997-05-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | ||
3463 | 1983-04-26 | 1988-12-30 | Ernest Beyl Public Relations, Inc. | 874 North Point | San Francisco | CA | 94109 | ||
4046 | 1987-09-29 | 1988-03-31 | Nossaman, Guthner, Knox & Elliott | 100 The Embarcadero | 3rd Floor | San Francisco | CA | 94105 | |
4057 | 1987-11-12 | 1994-12-24 | J.R. Bechtle & Company | 456 Montgomery Street | Suite 1010 | San Francisco | CA | 94104 | |
4173 | 1988-08-26 | 1999-03-30 | TransPacific Communications & Research Company | 582 Market Street | Suite 602 | San Francisco | CA | 94104 | |
4335 | 1990-01-25 | 1990-01-31 | Hi-Tech Public Relations, Inc. | 444 DeHaro Street | Suite 207 | San Francisco | CA | 94107 | |
4338 | 1990-02-01 | 1990-10-04 | Lillick & Charles | 2 Embarcadero Center | 26th Floor | San Francisco | CA | 94111 | |
4443 | 1990-12-03 | 1991-12-31 | Farella, Braun & Martel | 235 Montgomery Street | Suite 3000 | San Francisco | CA | 94104 | |
5026 | 1995-06-20 | 1995-12-31 | Sierra Club Legal Defense Fund, Inc. | 180 Montgomery Street | Suite 1400 | San Francisco | CA | 94104-4209 | |
5174 | 1997-04-21 | 2008-10-31 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 | |
5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | ||
5206 | 1997-09-04 | 1998-03-31 | PBN Company | 3 Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 | |
5218 | 1997-11-18 | 1998-05-31 | McCutchen, Doyle, Brown & Enersen, L.L.P. | 3 Embarcadero Center | San Francisco | CA | 94111-4067 | ||
5264 | 1998-07-12 | 1999-03-01 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 | |
5281 | 1998-10-26 | 1999-10-26 | Crane, Howard C. | 3825 Scott Street | Apartment 301 | San Francisco | CA | 94123 | |
5631 | 2004-07-12 | 2016-07-31 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 | |
5664 | 2004-12-28 | 2005-12-31 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 | |
5947 | 2009-07-31 | 2018-05-07 | Brunswick Group, LLC | One Market Street | 35th Floor | San Francisco | CA | 94105 | |
6091 | 2012-02-23 | Sprague, Esther Marie | 123 Hanover Street | San Francisco | CA | 94112 | |||
6133 | 2012-09-14 | 2012-12-31 | Grayling Connecting Point, LLC | 665 Third Street | San Francisco | CA | 94107 | ||
6674 | 2019-05-08 | 2019-06-01 | Hurd, James Daniel | 4200 California Street | #207 | San Francisco | CA | 94118 | |
6725 | 2019-09-20 | 2021-10-11 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 | |
6859 | 2020-08-26 | 2021-02-28 | Khan, Qamar Zaman | 539 19th Avenue | San Francisco | CA | 94121 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]) );