FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Short_Form_Last_Name = "Robertson"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 16
- Hill and Knowlton Strategies, LLC 3
- British Information Services 2
- Squire Patton Boggs, LLP 2
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Netherlands Information Service, Michigan 1
- Dancer Fitzgerald Sample, Inc. 1
- Aaron D. Cushman & Associates, Inc. 1
- White & Case, LLP 1
- Foster Garvey PC 1
- Pagonis & Donnelly Group, Inc. 1
- Gold & Liebengood, Inc. 1
- Robertson Group, Inc. 1
- Merritt Group, Ltd. 1
- Janus-Merritt Strategies, LLC 1
- MWW Group 1
- Williams Mullen Strategies, Inc. 1
Registrant_Name 16
- Hill and Knowlton Strategies, LLC 3
- British Information Services 2
- Squire Patton Boggs, LLP 2
- Aaron D. Cushman & Associates, Inc. 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Dancer Fitzgerald Sample, Inc. 1
- Foster Garvey PC 1
- Gold & Liebengood, Inc. 1
- Janus-Merritt Strategies, LLC 1
- MWW Group 1
- Merritt Group, Ltd. 1
- Netherlands Information Service, Michigan 1
- Pagonis & Donnelly Group, Inc. 1
- Robertson Group, Inc. 1
- White & Case, LLP 1
- Williams Mullen Strategies, Inc. 1
City 8
- Washington 10
- New York 4
- Chicago 1
- East Rutherford 1
- Holland 1
- Reston 1
- Richmond 1
- Seattle 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2830 | 2830 | 2004-01-01 | 1982-09-27 | Robertson | Bruce A. | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 1111 Third Avenue | Suite 3000 | Seattle | WA | 98101 |
6474 | 6474 | 1994-02-09 | 1989-04-05 | Robertson | William B. | Pagonis & Donnelly Group, Inc. 3692 | 1985-06-20 | Pagonis & Donnelly Group, Inc. | 1620 I Street, N.W. | Suite 202 | Washington | DC | 20006 |
7122 | 7122 | 1996-02-16 | 1991-01-10 | Robertson | Mark John | Gold & Liebengood, Inc. 3700 | 1985-07-09 | Gold & Liebengood, Inc. | 1455 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20004 |
8492 | 8492 | 2000-02-29 | 1999-08-31 | Robertson | Mark J. | Janus-Merritt Strategies, LLC 5326 | 1999-08-31 | Janus-Merritt Strategies, LLC | 1133 21st Street, N.W. | Suite 700 | Washington | DC | 20036 |
8748 | 8748 | 1983-03-01 | 1982-07-21 | Robertson | John S. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11442 | 11442 | 1974-03-31 | 1971-12-31 | Robertson | Katrijn A. | Netherlands Information Service, Michigan 2049 | 1967-09-13 | Netherlands Information Service, Michigan | City Hall | Holland | MI | 49423 | |
12905 | 12905 | 1997-04-07 | 1995-12-26 | Robertson | Kylie A. | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | 35 East Wacker Drive | Suite 850 | Chicago | IL | 60601 |
17038 | 17038 | 1994-05-24 | 1993-07-08 | Robertson | Peter D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
19186 | 19186 | 1994-06-10 | 1991-09-10 | Robertson | Mark | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
19350 | 19350 | 1995-06-13 | 1994-12-09 | Robertson | William B. | Robertson Group, Inc. 4954 | 1994-09-29 | Robertson Group, Inc. | 12009 Trotter Lane | Reston | VA | 22091 | |
21642 | 21642 | 2009-06-30 | 2005-07-21 | Robertson | Mark John | Williams Mullen Strategies, Inc. 5698 | 2005-07-21 | Williams Mullen Strategies, Inc. | Two James Center, 1021 East Cary Street | P.O. Box 1320 | Richmond | VA | 23218 |
23297 | 23297 | 2003-07-15 | 2003-06-03 | Robertson | Grant | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
23372 | 23372 | 1991-07-16 | 1990-07-17 | Robertson | Peter D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
28342 | 28342 | 1999-08-31 | 1999-04-22 | Robertson | Mark J. | Merritt Group, Ltd. 5270 | 1998-08-17 | Merritt Group, Ltd. | 1133 21st Street, N.W. | Suite 700 | Washington | DC | 20036 |
30889 | 30889 | 1969-09-30 | 1954-09-17 | Robertson | Alexander (Alec) Ernest | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
34513 | 34513 | 2004-10-31 | 2001-07-20 | Robertson | Michelle Beilsmith | MWW Group 5448 | 2001-07-20 | MWW Group | One Meadowlands Plaza | East Rutherford | NJ | 07073 | |
35320 | 35320 | 1972-11-06 | 1969-02-10 | Robertson | C.L. | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
35690 | 35690 | 1973-11-13 | 1953-04-29 | Robertson | William Ganson | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
37325 | 37325 | 1978-12-01 | 1974-10-09 | Robertson | Sandra | Dancer Fitzgerald Sample, Inc. 2539 | 1974-10-09 | Dancer Fitzgerald Sample, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
40484 | 40484 | 1988-12-31 | 1984-05-01 | Robertson | Mark | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );