FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
202 rows where Address_2 = "17th Floor" sorted by Short_Form_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 7
Registrant_Name 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130 | 130 | 2020-01-14 | Metz | Craig H. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
458 | 458 | 2021-02-26 | Conroy | Brian | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
459 | 459 | 2021-02-26 | Hayes | Michael Anthony | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
460 | 460 | 2021-02-26 | Loughlin | Gavin O. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
462 | 462 | 2019-02-27 | McCormack | Turlough | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
466 | 466 | 2020-02-28 | McWilliams | Sean | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
468 | 468 | 2023-02-28 | Roddy | Niamh | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
469 | 469 | 2023-02-28 | Rushe | Hilary | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
753 | 753 | 2009-04-10 | Cox | Christine M. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
754 | 754 | 2009-04-10 | Wilkins | David Horton | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
773 | 773 | 2022-04-13 | O'Flaherty | Catherina | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
774 | 774 | 2022-04-13 | O'Mahony | Tara | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
775 | 775 | 2022-04-13 | Curley | Paul | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
776 | 776 | 2022-04-13 | Leonard | Mark | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
778 | 778 | 2022-04-13 | Trautt | Enda | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
795 | 795 | 2022-04-15 | O'Brien | Damien | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
796 | 796 | 2022-04-15 | O'Brien | Mark | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
797 | 797 | 2022-04-15 | Allen | Gemma | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
798 | 798 | 2022-04-15 | Benson | Jessica Niamh | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
799 | 799 | 2022-04-15 | Carroll | Seamus | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
800 | 800 | 2022-04-15 | Cowley | Maeve Bernadette | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
801 | 801 | 2022-04-15 | Dempsey | Gary | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
802 | 802 | 2022-04-15 | Houlihan | Ivan Patrick | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
803 | 803 | 2022-04-15 | Jones | David | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
804 | 804 | 2022-04-15 | Loughran | Michelle | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
805 | 805 | 2022-04-15 | Lynch | Suzanne Helen | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
806 | 806 | 2022-04-15 | McGee | Patrick Joseph | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
807 | 807 | 2022-04-15 | Mooney | Doireann Eilish | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
808 | 808 | 2022-04-15 | Storan | Michael | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
809 | 809 | 2022-04-15 | Veale | James Paul | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
860 | 860 | 2015-04-23 | Klink | Ron | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
1072 | 1072 | 2017-05-22 | Meyers | Justin | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
1175 | 1175 | 2007-06-01 | Gaskin | David | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1176 | 1176 | 2007-06-01 | Shelly | Rachel | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1177 | 1177 | 2007-06-01 | Travers | Donal | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1649 | 1649 | 2014-08-21 | Cushing | Christopher T. | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 | |
1678 | 1678 | 2022-08-28 | Hearty | John | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1681 | 1681 | 2018-08-30 | Brody | David | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1682 | 1682 | 2018-08-30 | McEvoy | Mary | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1683 | 1683 | 2018-08-30 | Sheehy | Conor | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1685 | 1685 | 2019-08-30 | Healy | Karen | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1704 | 1704 | 2020-08-31 | Soye | Deborah | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1709 | 1709 | 2021-08-31 | Newton | Keith William | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1967 | 1967 | 2007-10-15 | Buckley | Mary | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
4194 | 4194 | 1955-01-21 | 1954-03-17 | Flynn | Winifred | 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 |
12391 | 12391 | 1967-04-01 | 1948-08-16 | Durnin | Kevin | 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 |
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 |
27871 | 27871 | 1969-08-31 | 1969-03-21 | Morrison | William Patrick | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
20816 | 20816 | 1970-06-30 | 1970-06-30 | Kelly | Anthony John | 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 |
5683 | 5683 | 1971-02-01 | 1969-06-27 | Cole | James Connolly | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
17615 | 17615 | 1971-05-31 | 1969-06-17 | Marsh | Louis Noel | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
19735 | 19735 | 1971-06-17 | 1954-03-17 | Gogarty | Henry A. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
34859 | 34859 | 1971-11-01 | 1971-11-17 | Brosnan | William | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
39911 | 39911 | 1972-12-31 | 1972-03-08 | O'Scollain | Seamus | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
10048 | 10048 | 1973-03-16 | 1965-05-13 | Hughes | Martin Thomas Alexander | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
10780 | 10780 | 1973-03-26 | 1948-08-16 | Baynes | Christina Ellen | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
19336 | 19336 | 1973-06-13 | 1970-07-20 | Cora | Fitzpatrick | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
27906 | 27906 | 1973-08-31 | 1971-02-17 | Burke-Kennedy | Desmond B. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
35266 | 35266 | 1973-11-05 | 1973-03-15 | Fleming | John Patrick | IDA Ireland 1770 | 1964-07-10 | IDA 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 |
37668 | 37668 | 1973-12-03 | 1973-09-24 | Kerr | Peter F. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
3153 | 3153 | 1974-01-04 | 1967-05-08 | Wold | Anne Rutledge | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
7872 | 7872 | 1974-02-28 | 1972-04-25 | Kenny | J. Frank | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
39977 | 39977 | 1975-12-31 | 1974-05-22 | McDermott | Robert J. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
14240 | 14240 | 1976-04-28 | 1967-03-16 | O'Brien | Pauline B. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
22833 | 22833 | 1976-07-09 | 1975-09-29 | Goodsir | Graeme C. | Australian Meat & Livestock Corporation 2611 | 1975-09-29 | Australian Meat & Livestock Corporation | 750 Lexington Avenue | 17th Floor | New York | NY | 10022 |
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 |
39994 | 39994 | 1976-12-31 | 1974-01-21 | Fitzgibbon | Mary S. | Shannon Free Airport Development Company, Ltd. 2467 | 1973-10-23 | Shannon Free Airport Development Company, Ltd. | 345 Park Avenue | 17th Floor | New York | NY | 10154-0037 |
40007 | 40007 | 1976-12-31 | 1973-04-05 | McCarthy | Richard | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40012 | 40012 | 1976-12-31 | 1971-08-16 | McElveen | Ivor | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
6112 | 6112 | 1977-02-04 | 1973-03-27 | Murphy | Michael Francis | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
6115 | 6115 | 1977-02-04 | 1976-08-04 | Muirhead | Denis B. | Australian Meat & Livestock Corporation 2611 | 1975-09-29 | Australian Meat & Livestock Corporation | 750 Lexington Avenue | 17th Floor | New York | NY | 10022 |
12425 | 12425 | 1977-04-01 | 1974-11-06 | Larkin | James | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
13383 | 13383 | 1977-04-15 | 1970-07-20 | Carberry | Sean P. | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
17631 | 17631 | 1977-05-31 | 1973-03-07 | Sullivan | Patrick J. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
17634 | 17634 | 1977-05-31 | 1974-05-22 | Finley | Grace J. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
27943 | 27943 | 1977-08-31 | 1973-03-27 | O'Donovan | David | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
27951 | 27951 | 1977-08-31 | 1976-05-03 | Roden | Brigid | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
34188 | 34188 | 1977-10-31 | 1976-03-22 | McDonald | Patrick Edward | IDA Ireland 1770 | 1964-07-10 | IDA 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 |
22897 | 22897 | 1978-07-10 | 1976-03-22 | Butler | Joseph Francis | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
22898 | 22898 | 1978-07-10 | 1973-04-05 | Lillis | Peter | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
22899 | 22899 | 1978-07-10 | 1975-06-12 | Lynn | Kenneth George | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40068 | 40068 | 1978-12-31 | 1973-04-05 | Ward | Sean | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
23035 | 23035 | 1979-07-13 | 1972-03-08 | Cashman | Seamus | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
34203 | 34203 | 1979-10-31 | 1975-03-10 | O'Rourke | Bernard C. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
8451 | 8451 | 1980-02-29 | 1976-02-12 | Hood | Ralph L. | Australian Meat & Livestock Corporation 2611 | 1975-09-29 | Australian Meat & Livestock Corporation | 750 Lexington Avenue | 17th Floor | New York | NY | 10022 |
11124 | 11124 | 1980-03-30 | 1973-03-27 | Walsh | Aidan M. St. P. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
25511 | 25511 | 1980-08-01 | 1956-07-16 | Walsh | Christopher Joseph | Tourism Ireland 536 | 1948-08-16 | Tourism Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40115 | 40115 | 1980-12-31 | 1974-01-21 | MacGowan | Noel | Shannon Free Airport Development Company, Ltd. 2467 | 1973-10-23 | Shannon Free Airport Development Company, Ltd. | 345 Park Avenue | 17th Floor | New York | NY | 10154-0037 |
26706 | 26706 | 1981-08-15 | 1976-03-22 | Keilthy | William J. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
4256 | 4256 | 1982-01-22 | 1978-10-05 | Wotton | John S.A. | Australian Meat & Livestock Corporation 2611 | 1975-09-29 | Australian Meat & Livestock Corporation | 750 Lexington Avenue | 17th Floor | New York | NY | 10022 |
40238 | 40238 | 1982-12-31 | 1979-10-12 | Chaby | Diane B. | Peter Rothholz Associates, Inc. 2830 | 1977-09-16 | Peter Rothholz Associates, Inc. | 355 Lexington Avenue | 17th Floor | New York | NY | 10017 |
10202 | 10202 | 1983-03-18 | 1978-04-18 | O'Duill | Olaf B. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
22902 | 22902 | 1983-07-10 | 1977-11-27 | Cronin | Paul B. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40246 | 40246 | 1983-12-31 | 1977-02-03 | Ussher | Bernard | IDA Ireland 1770 | 1964-07-10 | IDA 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]) );