FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Last_Name = "Ramsey"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 13
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Mexican Tourism Board 1
- JETRO, San Francisco 1
- Burson-Marsteller 1
- Daniel J. Edelman, Inc. 1
- Fleishman-Hillard, Inc. 1
- Fenton Communications, Inc. 1
- Steptoe & Johnson, L.L.P. 1
- Washington & Christian 1
- International Technology and Trade Associates, Inc. (ITTA) 1
- QORVIS LLC 1
- DCI Group AZ, LLC 1
Registrant_Name 13
- Burson-Marsteller 1
- DCI Group AZ, LLC 1
- Daniel J. Edelman, Inc. 1
- Fenton Communications, Inc. 1
- Fleishman-Hillard, Inc. 1
- International Technology and Trade Associates, Inc. (ITTA) 1
- JETRO, San Francisco 1
- Mexican Tourism Board 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- QORVIS LLC 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Steptoe & Johnson, L.L.P. 1
- Washington & Christian 1
City 5
- Washington 8
- New York 2
- Chicago 1
- San Francisco 1
- St. Louis 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1044 | 1044 | 2023-05-17 | Ramsey | Kevin | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 | |
2057 | 2057 | 2020-10-29 | Ramsey | Edward | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
3234 | 3234 | 1990-01-05 | 1987-05-08 | Ramsey | Stephen D. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
4390 | 4390 | 1988-01-25 | 1986-07-14 | Ramsey | Patricia | Fenton Communications, Inc. 3857 | 1986-07-14 | Fenton Communications, Inc. | 1606 - 20th Street, N.W. | Washington | DC | 20009 | |
5186 | 5186 | 1998-01-31 | 1995-01-10 | Ramsey | Henry , Jr. | Washington & Christian 4569 | 1991-09-20 | Washington & Christian | 1155 15th Street, N.W. | Suite 1004 | Washington | DC | 20005 |
7193 | 7193 | 1959-02-18 | 1951-04-04 | Ramsey | Hobart Cole | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
19089 | 19089 | 1964-06-09 | 1964-06-09 | Ramsey | Betty Jo | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
19456 | 19456 | 2010-06-14 | 2010-05-21 | Ramsey | Joseph | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
23722 | 23722 | 1988-07-21 | 1988-07-06 | Ramsey | Thomas J. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
25701 | 25701 | 2015-08-01 | 2012-06-06 | Ramsey | Jane Stuart | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
26032 | 26032 | 2004-08-05 | 1992-09-04 | Ramsey | Shawn S. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
33477 | 33477 | 1987-10-23 | 1987-02-09 | Ramsey | Cathy Anne | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
41240 | 41240 | 2001-12-31 | 2001-09-10 | Ramsey | Douglas F. | International Technology and Trade Associates, Inc. (ITTA) 5458 | 2001-09-10 | International Technology and Trade Associates, Inc. (ITTA) | 1330 Connecticut Avenue, N.W. | Suite 210 | Washington | DC | 20036-1704 |
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]) );