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 = "Weill"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Burson-Marsteller 2
- French Chamber of Commerce of the U.S., Inc. 1
- France Amerique Corporation 1
- Agence France-Presse (France-Presse News Agency) 1
- Ruder Finn, Inc. 1
- Marshall, Leon, Weill & Mahony 1
- Duncan, Weinberg, Palmer & Miller, P.C. 1
- Harshe-Rotman & Druck, Inc. 1
- Daniel J. Edelman, Inc. 1
- Weill & Paxton 1
- Geoffrey Weill Associates 1
- Geoffrey Weill 1
Registrant_Name 12
- Burson-Marsteller 2
- Agence France-Presse (France-Presse News Agency) 1
- Daniel J. Edelman, Inc. 1
- Duncan, Weinberg, Palmer & Miller, P.C. 1
- France Amerique Corporation 1
- French Chamber of Commerce of the U.S., Inc. 1
- Geoffrey Weill 1
- Geoffrey Weill Associates 1
- Harshe-Rotman & Druck, Inc. 1
- Marshall, Leon, Weill & Mahony 1
- Ruder Finn, Inc. 1
- Weill & Paxton 1
City 3
- New York 8
- Washington 4
- Jackson 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1860 | 1860 | 2022-09-27 | Weill | Geoffrey | Geoffrey Weill 7173 | 2022-09-27 | Geoffrey Weill | Geoffrey Weill Associates | 29 Broadway, Suite 2205 | New York | NY | 10006 | |
2610 | 2610 | 1982-01-01 | 1981-11-13 | Weill | Laura | Harshe-Rotman & Druck, Inc. 3292 | 1981-11-21 | Harshe-Rotman & Druck, Inc. | 300 East 44th Street | New York | NY | 10017 | |
15284 | 15284 | 1946-05-01 | 1943-10-25 | Weill | Pierre-Andre | France Amerique Corporation 218 | 1943-10-25 | France Amerique Corporation | 730 Fifth Avenue | New York | NY | ||
16969 | 16969 | 1997-05-23 | 1996-05-10 | Weill | Gus | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
22970 | 22970 | 1995-07-11 | 1991-04-18 | Weill | Gus | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
24050 | 24050 | 2016-07-25 | 2006-10-03 | Weill | Geoffrey | Geoffrey Weill Associates 5773 | 2006-10-03 | Geoffrey Weill Associates | 27 West 24th Street | Suite 305 | New York | NY | 10010 |
26684 | 26684 | 1977-08-15 | 1977-03-24 | Weill | Jay R. | Duncan, Weinberg, Palmer & Miller, P.C. 2763 | 1977-03-24 | Duncan, Weinberg, Palmer & Miller, P.C. | 1775 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
28061 | 28061 | 1983-08-31 | 1982-05-11 | Weill | Laura | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
30362 | 30362 | 1976-09-24 | 1975-05-16 | Weill | Harold | Marshall, Leon, Weill & Mahony 2584 | 1975-05-16 | Marshall, Leon, Weill & Mahony | 1825 K Street, N.W. | Suite 703 | Washington | DC | 20006 |
34437 | 34437 | 2000-10-31 | 1997-10-07 | Weill | Gus | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
39625 | 39625 | 1957-12-31 | 1945-09-24 | Weill | Anne L. | Agence France-Presse (France-Presse News Agency) 223 | 1943-12-02 | Agence France-Presse (France-Presse News Agency) | 50 Rockefeller Plaza | New York | NY | 10020 | |
39797 | 39797 | 1966-12-31 | 1953-02-16 | Weill | Michel David | French Chamber of Commerce of the U.S., Inc. 167 | 1943-01-01 | French Chamber of Commerce of the U.S., Inc. | 1350 Avenue of the Americas | New York | NY | 10019 | |
40698 | 40698 | 1991-12-31 | 1989-08-11 | Weill | Jeff | Weill & Paxton 4280 | 1989-08-11 | Weill & Paxton | 405 Tombigbee Street | Jackson | MS | 39201 |
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]) );