FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Short_Form_Last_Name = "Long"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 16
- Australian Information Service 2
- Doremus & Company 1
- Chinese Information Service 1
- Spanish National Tourist Office, New York 1
- Government of Ontario, Canada 1
- Rollinson, Long & Stein 1
- Cayman Islands Department of Tourism 1
- Malaysia Tourism Promotion Board 1
- Oestreicher, Michael R. 1
- Jones Day 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Goodman Group, Ltd. 1
- Law Firm of Latham & Watkins, a Partnership 1
- Greenberg Traurig, LLP 1
- McGuireWoods Consulting, LLC 1
- Terakeet LLC 1
Registrant_Name 16
- Australian Information Service 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Cayman Islands Department of Tourism 1
- Chinese Information Service 1
- Doremus & Company 1
- Goodman Group, Ltd. 1
- Government of Ontario, Canada 1
- Greenberg Traurig, LLP 1
- Jones Day 1
- Law Firm of Latham & Watkins, a Partnership 1
- Malaysia Tourism Promotion Board 1
- McGuireWoods Consulting, LLC 1
- Oestreicher, Michael R. 1
- Rollinson, Long & Stein 1
- Spanish National Tourist Office, New York 1
- Terakeet LLC 1
City 7
- New York 7
- Washington 5
- Boston 1
- Cincinnati 1
- Los Angeles 1
- Richmond 1
- Syracuse 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3279 | 3279 | 1992-01-06 | 1990-05-11 | Long | Walter G. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
3624 | 3624 | 1992-01-12 | 1991-04-25 | Long | Alan | Goodman Group, Ltd. 4505 | 1991-04-25 | Goodman Group, Ltd. | 303 Congress Street | Boston | MA | 02210 | |
4786 | 4786 | 1964-01-30 | 1961-10-06 | Long | Frank | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
5133 | 5133 | 1994-01-31 | 1993-09-17 | Long | William | Law Firm of Latham & Watkins, a Partnership 4849 | 1993-09-17 | Law Firm of Latham & Watkins, a Partnership | 1001 Pennsylvania Avenue, N.W. | 13th Floor | Washington | DC | 20004-2505 |
5714 | 5714 | 1979-02-01 | 1973-03-13 | Long | Frank H. | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
9634 | 9634 | 1993-03-11 | 1987-07-22 | Long | C. Thomas | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
14052 | 14052 | 2000-04-24 | 1999-01-19 | Long | Kristin | Oestreicher, Michael R. 3426 | 1982-12-08 | Oestreicher, Michael R. | 312 Walnut Street | Suite 1400 | Cincinnati | OH | 45202 |
18605 | 18605 | 2021-06-01 | 2020-10-29 | Long | Kylie | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | |
21089 | 21089 | 1988-06-30 | 1988-04-11 | Long | Janis C. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21596 | 21596 | 2007-06-30 | 2002-09-19 | Long | Abd. Talib HJ. | Malaysia Tourism Promotion Board 2510 | 1974-04-17 | Malaysia Tourism Promotion Board | 818 West Seventh Street | Suite 970 | Los Angeles | CA | 90017-3432 |
23287 | 23287 | 2000-07-15 | 1998-11-12 | Long | Lynda | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
25820 | 25820 | 2017-08-02 | 2015-10-13 | Long | Killoran | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | 2101 L Street, NW | Suite 1000 | Washington | DC | 20037 |
34144 | 34144 | 1962-10-31 | 1958-09-30 | Long | Hwa Shu | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
35980 | 35980 | 1972-11-17 | 1972-02-15 | Long | Ralph B. | Rollinson, Long & Stein 2315 | 1972-02-15 | Rollinson, Long & Stein | 1019 - 19th Street, N.W. | Washington | DC | 20036 | |
37932 | 37932 | 1948-12-09 | 1948-09-14 | Long | Georgia B. | Spanish National Tourist Office, New York 538 | 1948-09-14 | Spanish National Tourist Office, New York | 665 Fifth Avenue | New York | NY | 10022 | |
38195 | 38195 | 1944-12-13 | 1943-05-11 | Long | William H. , Jr. | Doremus & Company 134 | 1942-10-05 | Doremus & Company | 120 Broadway | New York | NY | ||
42011 | 42011 | 2015-12-31 | 2015-11-24 | Long | Andrew | McGuireWoods Consulting, LLC 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 800 East Canal Street | Richmond | VA | 23219 |
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]) );