FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Webster"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
- U.S. Office of the British Broadcasting Corporation 2
- Jamaica Tourist Board, Florida 1
- Shaw, Pittman, Potts & Trowbridge 1
- Cole Corette & Abrutyn, P.C. 1
- Hill and Knowlton Strategies, LLC 1
- Promotional Concept Group, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Webster, Chamberlain & Bean 1
- Mercury Public Affairs, LLC 1
- Cornerstone Government Affairs 1
Registrant_Name 10
- U.S. Office of the British Broadcasting Corporation 2
- Cole Corette & Abrutyn, P.C. 1
- Cornerstone Government Affairs 1
- Hill and Knowlton Strategies, LLC 1
- Jamaica Tourist Board, Florida 1
- Mercury Public Affairs, LLC 1
- Promotional Concept Group, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Shaw, Pittman, Potts & Trowbridge 1
- Webster, Chamberlain & Bean 1
City 3
- Washington 6
- New York 4
- Miami 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1250 | 1250 | 2021-06-16 | Webster | Whitney | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 | |
1589 | 1589 | 2017-08-10 | Webster | Peter | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 | |
1710 | 1710 | 2021-08-31 | Webster | Sean-Pierre | Jamaica Tourist Board, Florida 2360 | 1972-07-26 | Jamaica Tourist Board, Florida | 5201 Blue Lagoon Drive | Suite 670 | Miami | FL | 33126 | |
4347 | 4347 | 1992-01-24 | 1989-08-16 | Webster | Alex | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
5068 | 5068 | 1991-01-31 | 1988-02-17 | Webster | Anne Emerson | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
8753 | 8753 | 1985-03-01 | 1982-02-22 | Webster | David | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
8756 | 8756 | 1985-03-01 | 1971-08-24 | Webster | David | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
17867 | 17867 | 1996-05-31 | 1995-05-15 | Webster | George D. | Webster, Chamberlain & Bean 5018 | 1995-05-15 | Webster, Chamberlain & Bean | 1747 Pennsylvania Avenue, N.W. | Suite 1000 | Washington | DC | 20006 |
27152 | 27152 | 1996-08-21 | 1990-10-23 | Webster | Aen Walker | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | 2300 N Street, N.W. | Washington | DC | 20037-1128 | |
29544 | 29544 | 2019-09-10 | 2019-07-02 | Webster | Morgan Ashley | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
34900 | 34900 | 1985-11-01 | 1983-05-03 | Webster | Ronald Dan | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | 805 - 15th Street, N.W, | Suite 900 | Washington | DC | 20005 |
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]) );