FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Short_Form_First_Name = "Louis"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 24
- American Section of the Jewish Agency for Israel 2
- Quebec Government Office 2
- Hong Kong Trade Development Council, Inc. 2
- Dominican Chamber of Commerce of the U.S., Inc. 1
- Quebec Government House 1
- Israel Government Tourist Office 1
- Fischer Brothers Travel Bureau, Inc. 1
- Berlanti Overseas Corporation 1
- Bacskai, Bela Harsany 1
- Arnold & Porter Kaye Scholer LLP 1
- Groban & Rava 1
- Columbus Lighthouse Committee of America 1
- World Zionist Organization - American Section, Inc. 1
- Supuran, Victor 1
- Alenia of U.S.A., Inc. 1
- Dow, Lohnes & Albertson, L.L.P. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Snyder, Ball, Kriser & Associates, Inc. 1
- Al Paul Lefton Company, Inc. 1
- McMillan Group, L.L.C. 1
- Al Paul Lefton Company Inc. 1
- Squire Sanders Public Advocacy, LLC 1
- AB&C Philadelphia, LLC 1
- Mercury Public Affairs, LLC 1
Registrant_Name 24
- American Section of the Jewish Agency for Israel 2
- Hong Kong Trade Development Council, Inc. 2
- Quebec Government Office 2
- AB&C Philadelphia, LLC 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Al Paul Lefton Company Inc. 1
- Al Paul Lefton Company, Inc. 1
- Alenia of U.S.A., Inc. 1
- Arnold & Porter Kaye Scholer LLP 1
- Bacskai, Bela Harsany 1
- Berlanti Overseas Corporation 1
- Columbus Lighthouse Committee of America 1
- Dominican Chamber of Commerce of the U.S., Inc. 1
- Dow, Lohnes & Albertson, L.L.P. 1
- Fischer Brothers Travel Bureau, Inc. 1
- Groban & Rava 1
- Israel Government Tourist Office 1
- McMillan Group, L.L.C. 1
- Mercury Public Affairs, LLC 1
- Quebec Government House 1
- Snyder, Ball, Kriser & Associates, Inc. 1
- Squire Sanders Public Advocacy, LLC 1
- Supuran, Victor 1
- World Zionist Organization - American Section, Inc. 1
City 9
- New York 11
- Washington 7
- Philadelphia 3
- Alexandria 1
- Harrison 1
- Irvington 1
- Phoenixville 1
- Trenton 1
- Warwick 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2137 | 2137 | 2020-11-11 | Agnello | Louis | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | ||
2654 | 2654 | 1987-01-01 | 1975-09-04 | Revesz | Louis | Supuran, Victor 2451 | 1973-08-20 | Supuran, Victor | 1103 Genesee Street | Trenton | NJ | 08610 | |
4161 | 4161 | 1987-01-20 | 1985-04-11 | Bograd | Louis | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
6282 | 6282 | 1970-02-07 | 1969-10-21 | Ciaramello | Louis | Columbus Lighthouse Committee of America 2163 | 1969-09-24 | Columbus Lighthouse Committee of America | 766 West Shore Road | Post Office Box 486 | Warwick | RI | 02889 |
7356 | 7356 | 2020-02-21 | 2017-08-01 | Hamann | Louis | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
8633 | 8633 | 1960-03-01 | 1958-08-20 | Fischer | Louis | Fischer Brothers Travel Bureau, Inc. 1163 | 1958-08-20 | Fischer Brothers Travel Bureau, Inc. | 749 Springfield Avenue | Irvington | NJ | ||
9924 | 9924 | 1976-03-15 | 1971-12-06 | Galei-Eger | Louis | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
12767 | 12767 | 1966-04-05 | 1964-08-17 | Sachs | Louis | Groban & Rava 1772 | 1964-07-21 | Groban & Rava | 400 Madison Avenue | New York | NY | 10017 | |
16841 | 16841 | 2014-05-21 | 2013-12-12 | Brandsdorfer | Louis | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
16861 | 16861 | 1969-05-22 | 1961-08-11 | Mikofalvy | Louis | Bacskai, Bela Harsany 1471 | 1961-08-11 | Bacskai, Bela Harsany | Post Office Box 304 | Phoenixville | PA | ||
21090 | 21090 | 1988-06-30 | 1983-04-12 | Bernstein | Louis | World Zionist Organization - American Section, Inc. 2278 | 1971-09-21 | World Zionist Organization - American Section, Inc. | 633 Third Avenue | 21st Floor | New York | NY | 10017 |
21252 | 21252 | 1996-06-30 | 1995-10-18 | Duclos | Louis | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21384 | 21384 | 2001-06-30 | 1994-05-06 | Brandsdorfer | Louis | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
22169 | 22169 | 1986-07-01 | 1985-05-03 | Kriser | Louis | Alenia of U.S.A., Inc. 3399 | 1982-08-11 | Alenia of U.S.A., Inc. | 1101 - 15th Street, N.W. | Suite 610 | Washington | DC | 20005 |
23153 | 23153 | 1961-07-15 | 1960-09-22 | Berlanti | Louis | Berlanti Overseas Corporation 1380 | 1960-07-19 | Berlanti Overseas Corporation | 15 Oakland Avenue | Harrison | NY | ||
27710 | 27710 | 1995-08-29 | 1988-07-12 | Ho | Louis | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
27855 | 27855 | 1964-08-31 | 1963-04-11 | Pare | Louis | Quebec Government House 440 | 1947-02-20 | Quebec Government House | 17 West 50th Street | New York | NY | 10020 | |
28547 | 28547 | 2010-08-31 | 2004-03-25 | Brandsdorfer | Louis | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28954 | 28954 | 2008-09-01 | 2007-02-08 | Stokes | Louis | Squire Sanders Public Advocacy, LLC 5791 | 2007-02-05 | Squire Sanders Public Advocacy, LLC | 1201 Pennsylvania Avenue, NW | Suite 500 | Washington | DC | 20004-2401 |
29982 | 29982 | 1987-09-17 | 1987-07-23 | Dejoie | Louis | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | 1200 New Hampshire Avenue, N.W | Suite 800 | Washington | DC | 20036 |
33855 | 33855 | 1971-10-29 | 1954-02-09 | Segal | Louis | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | 515 Park Avenue | New York | NY | 10022 | |
35054 | 35054 | 2021-11-01 | 2020-01-24 | Rynsard | Louis | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35666 | 35666 | 1993-11-12 | 1985-03-08 | Kriser | Louis | Snyder, Ball, Kriser & Associates, Inc. 3655 | 1985-03-08 | Snyder, Ball, Kriser & Associates, Inc. | 499 South Capitol Street, S.W. | Suite 520 | Washington | DC | 20003 |
37208 | 37208 | 1946-12-01 | 1943-09-14 | Lipsky | Louis | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | 515 Park Avenue | New York | NY | 10022 | |
38075 | 38075 | 1953-12-11 | 1943-06-11 | Naetzker | Louis | Dominican Chamber of Commerce of the U.S., Inc. 197 | 1943-06-11 | Dominican Chamber of Commerce of the U.S., Inc. | 1270 Avenue of the Americas | New York | NY | ||
40122 | 40122 | 1980-12-31 | 1973-02-22 | Epstein | Louis | Hong Kong Trade Development Council, Inc. 2181 | 1970-01-19 | Hong Kong Trade Development Council, Inc. | 219 East 46th Street | New York | NY | 10017 | |
40873 | 40873 | 1995-12-31 | 1995-06-23 | Lehrman | Louis | McMillan Group, L.L.C. 5028 | 1995-06-23 | McMillan Group, L.L.C. | 11 Canal Center Plaza | Suite 210 | Alexandria | VA | 22314 |
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]) );