FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and Short_Form_First_Name = "Brian"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
458 | 458 | 2021-02-26 | Conroy | Brian | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
12776 | 12776 | 1984-04-05 | 1979-04-02 | Garvan | Brian | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
12913 | 12913 | 2012-04-07 | 2010-08-03 | Wagner | Brian | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 |
13308 | 13308 | 1980-04-14 | 1977-03-24 | O'Neill | Brian | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
13586 | 13586 | 2004-04-16 | 2003-02-25 | Bertsch | Brian | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
14292 | 14292 | 2010-04-28 | 2010-04-19 | Glynn | Brian | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
15525 | 15525 | 2018-05-01 | 2016-08-10 | Goldberg | Brian | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
23939 | 23939 | 2003-07-23 | 2003-08-08 | Grabowski | Brian | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
25521 | 25521 | 1982-08-01 | 1982-06-07 | Hanley | Brian | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
25587 | 25587 | 1990-08-01 | 1977-09-19 | Stack | Brian | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
28320 | 28320 | 1997-08-31 | 1991-09-19 | Greer | Brian | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
31457 | 31457 | 2009-09-30 | 2009-05-07 | McNeill | Brian | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
32695 | 32695 | 1994-10-12 | 1992-05-21 | Renaud | Brian | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
36282 | 36282 | 2020-11-23 | 2020-06-22 | Laird | Brian | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
41130 | 41130 | 1999-12-31 | 1999-03-26 | O'Dwyer | Brian | O'Dwyer, Brian 5308 | 1999-03-26 | O'Dwyer, Brian | 52 Duane Street | New York | NY | 10007 |
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]) );