FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Registration_Number = 536
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
32658 | 32658 | 1976-10-12 | 1967-05-17 | Malone | Joseph N. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
34194 | 34194 | 1977-10-31 | 1974-11-06 | Morrison | William Patrick | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
36628 | 36628 | 1973-11-30 | 1970-11-30 | Glynn | Alan George | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
38602 | 38602 | 1970-12-18 | 1967-05-17 | White | Sean J. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
38779 | 38779 | 1967-12-20 | 1967-03-16 | Sexton | Michael J. B. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
39538 | 39538 | 1955-12-31 | 1954-03-17 | Sheehy | Terence Joseph | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
39786 | 39786 | 1965-12-31 | 1964-05-11 | Clark | Gordon Bernard | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40347 | 40347 | 1986-12-31 | 1977-01-19 | McSullivan | Donal F. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
41269 | 41269 | 2002-12-31 | 1979-07-19 | Fullington | Marie Therese | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
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]) );