FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_First_Name = "Patrick B."
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 7
Registrant_Name 7
City 5
- Alexandria 2
- Washington 2
- Montreal 1
- New York 1
- Wichita 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8497 | 8497 | 2000-02-29 | 1999-10-29 | Fazzone | Patrick B. | Lipstein, Jaffe & Lawson, L.L.P. 5337 | 1999-10-15 | Lipstein, Jaffe & Lawson, L.L.P. | 1225 Eye Street, N.W. | Suite 700 | Washington | DC | 20005 |
14723 | 14723 | 1997-04-30 | 1997-04-16 | Brady | Patrick B. | Davis, Manafort & Freedman 5173 | 1997-04-16 | Davis, Manafort & Freedman | 211 North Union Street | Suite 250 | Alexandria | VA | 22314 |
19441 | 19441 | 1996-06-14 | 1996-06-05 | Brady | Patrick B. | DMS, Inc. 5077 | 1995-11-16 | DMS, Inc. | 201 North Union Street | Suite 360 | Alexandria | VA | 22314 |
21940 | 21940 | 2019-06-30 | 2013-12-20 | Hughes | Patrick B. | Adams Jones Law Firm, P.A. 6202 | 2013-12-20 | Adams Jones Law Firm, P.A. | 1635 N. Waterfront Parkway | Wichita | KS | 67206 | |
26711 | 26711 | 1984-08-15 | 1982-01-29 | Muldowney | Patrick B. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
32397 | 32397 | 1968-10-07 | 1966-08-08 | Segrave | Patrick B. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
32474 | 32474 | 2014-10-08 | 2013-12-11 | Hughes | Patrick B. | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | c/o Tragen Resources & Logistics | 740 Notre Dame Ouest, Suite 1250 | Montreal |
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]) );