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 = "Joyce"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5826 | 5826 | 2005-02-01 | 1999-02-08 | Joyce | Jonathan Robert | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
17610 | 17610 | 1970-05-31 | 1969-06-25 | Joyce | William R. , Jr. | Casey, Lane & Mittendorf 1553 | 1962-07-02 | Casey, Lane & Mittendorf | 26 Broadway | New York | NY | 10004 | |
24946 | 24946 | 1999-07-31 | 1996-08-05 | Joyce | William A. | Beef + Lamb New Zealand, Ltd. 2526 | 1974-07-08 | Beef + Lamb New Zealand, Ltd. | 6841 Elm Street | #7401 | McLean | VA | 22106 |
26424 | 26424 | 1964-08-11 | 1961-01-27 | Joyce | Robert Nelson | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | 17 Eagle Rock Road | Mill Valley | CA | 94941 | |
29062 | 29062 | 2005-09-02 | 1983-10-07 | Joyce | David E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35867 | 35867 | 1991-11-15 | 1990-09-19 | Joyce | Thomas B. | Price Waterhouse 4413 | 1990-09-19 | Price Waterhouse | Washington Nat'l. Tax Services | 1801 K Street, N.W. | Washington | DC | 20006 |
35969 | 35969 | 1967-11-17 | 1962-05-16 | Joyce | Gerard F. | Kramer, Marx, Greenlee & Backus 1293 | 1959-11-09 | Kramer, Marx, Greenlee & Backus | 29 Broadway | New York | NY | 10006 | |
36441 | 36441 | 1984-11-26 | 1984-03-29 | Joyce | Rosemary | Taylor & Hammond, Ltd. 2977 | 1978-11-09 | Taylor & Hammond, Ltd. | 39 East 51st Street | New York | NY | 10022 | |
39649 | 39649 | 1958-12-31 | 1958-01-07 | Joyce | William R. , Jr. | LeBoeuf, Lamb & Leiby 1100 | 1958-01-07 | LeBoeuf, Lamb & Leiby | 15 Broad Street | New York | NY | ||
39888 | 39888 | 1970-12-31 | 1969-10-29 | Joyce | Thomas Richard , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
40245 | 40245 | 1983-12-31 | 1982-01-29 | Joyce | Eileen | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 |
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]) );