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 = "Glass"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
- Clark, Clifford M. 1
- George Peabody & Associates, Inc. 1
- Gotham-Vladimir Advertising, Inc. 1
- Rogers & Cowan, Inc. 1
- Burson-Marsteller 1
- Clifford & Warnke 1
- Cayman Islands News Bureau 1
- Hill and Knowlton Strategies, LLC 1
- Holland & Knight 1
- Miner, Fraser & Gabriel Public Affairs, Inc. 1
- Daniel J. Edelman, Inc. - San Francisco 1
Registrant_Name 11
- Burson-Marsteller 1
- Cayman Islands News Bureau 1
- Clark, Clifford M. 1
- Clifford & Warnke 1
- Daniel J. Edelman, Inc. - San Francisco 1
- George Peabody & Associates, Inc. 1
- Gotham-Vladimir Advertising, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Holland & Knight 1
- Miner, Fraser & Gabriel Public Affairs, Inc. 1
- Rogers & Cowan, Inc. 1
City 5
- Washington 6
- New York 2
- Beverly Hills 1
- Miami 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2582 | 2582 | 1979-01-01 | 1975-06-30 | Glass | Carson M. | Clifford & Warnke 2564 | 1975-03-26 | Clifford & Warnke | 815 Connecticut Avenue, N.W. | Washington | DC | 20006 | |
3607 | 3607 | 1953-01-12 | 1951-01-12 | Glass | Carson M. | Clark, Clifford M. 655 | 1951-01-12 | Clark, Clifford M. | 1523 L Street, N.W. | Washington | DC | ||
5935 | 5935 | 1967-02-02 | 1964-08-11 | Glass | James Lowell | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
9232 | 9232 | 1992-03-06 | 1985-08-07 | Glass | W. Reeder | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
22456 | 22456 | 1996-07-02 | 1990-01-22 | Glass | Sally | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
27202 | 27202 | 1988-08-22 | 1988-02-17 | Glass | Sally | Miner, Fraser & Gabriel Public Affairs, Inc. 4022 | 1987-08-11 | Miner, Fraser & Gabriel Public Affairs, Inc. | 1025 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 |
33739 | 33739 | 1965-10-28 | 1965-10-27 | Glass | George | Rogers & Cowan, Inc. 1933 | 1965-10-27 | Rogers & Cowan, Inc. | 250 North Canon Drive | Beverly Hills | CA | ||
37389 | 37389 | 1986-12-01 | 1984-12-19 | Glass | Holly | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
38286 | 38286 | 1984-12-14 | 1984-09-17 | Glass | Joel A. | Cayman Islands News Bureau 2823 | 1977-08-12 | Cayman Islands News Bureau | Post Office Box 330106 | Miami | FL | 33133 | |
39735 | 39735 | 1962-12-31 | 1953-05-26 | Glass | William Burton | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | 501 Madison Avenue | New York | NY | 10022 | |
41461 | 41461 | 2005-12-31 | 2005-10-19 | Glass | Eric Mathew | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
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]) );