FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

114 rows where Registration_Number = 1770

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • IDA Ireland · 114 ✖

Registrant_Name 1

City 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
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
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
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
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
5003 5003 1985-01-31 1977-11-28 O'Sullivan David IDA Ireland 1770 1964-07-10 IDA 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
5742 5742 1985-02-01 1981-02-11 Turpin Frank IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
5796 5796 1995-02-01 1985-07-17 Kavanagh Ken 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
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
7925 7925 1985-02-28 1979-11-15 Mullally Michael IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
7934 7934 1987-02-28 1979-12-12 Collins Declan IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
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
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
11155 11155 1990-03-30 1983-11-18 Fahey Desmond IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
12450 12450 1984-04-01 1979-12-21 O'Sullivan Eoin 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
13037 13037 1993-04-09 1988-05-03 Corish Philip IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
13038 13038 1993-04-09 1988-05-03 Lenehan Richard IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
13041 13041 1993-04-09 1984-11-06 Jones Thomas A. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
13042 13042 1993-04-09 1983-12-08 Kehoe Gerard IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
16823 16823 1988-05-21 1983-12-02 Barry Denis Dominic 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
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
21039 21039 1985-06-30 1982-05-12 Fine William M. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
21067 21067 1986-06-30 1977-11-28 Gargan Anthony P. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
21073 21073 1987-06-30 1982-05-21 Tuohy Dermot M. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
21094 21094 1988-06-30 1982-05-05 Halpin Brendan IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
21095 21095 1988-06-30 1985-06-26 Lyons John IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
21110 21110 1988-06-30 1982-12-22 Ahern Peter Philip IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
22254 22254 1996-07-01 1985-06-26 Gallagher Patrick IDA Ireland 1770 1964-07-10 IDA 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
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
23011 23011 1991-07-12 1985-08-01 Bolton John Michael 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
23426 23426 1985-07-17 1981-05-11 McNaughton Paul IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
24741 24741 1985-07-31 1974-05-22 Kelly Edward J. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
24778 24778 1989-07-31 1985-07-19 O'Brien Maurice IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
25413 25413 2022-07-31 2007-06-01 Hayes Paraic IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
26445 26445 1989-08-11 1979-02-26 Curran Denis IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
26517 26517 2020-08-12 2019-08-30 Skeffington Rebecca IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
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
26922 26922 1987-08-18 1983-12-19 Williams Jane M. IDA Ireland 1770 1964-07-10 IDA 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
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
28145 28145 1990-08-31 1983-01-04 Ryan Nicholas IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
28163 28163 1990-08-31 1988-08-15 Daly Patrick J. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
28913 28913 1996-09-01 1978-10-16 Byrne Peter D. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
28963 28963 2009-09-01 2007-10-15 McEvoy Thomas P. IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
28994 28994 2021-09-01 2018-08-30 Mitchell Emma IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
29453 29453 2018-09-08 2019-02-27 Hanley Siobhan IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
31480 31480 2009-09-30 2007-10-15 Nugent John 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
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
34585 34585 2009-10-31 2007-06-01 Dowdall Emmanuel IDA Ireland 1770 1964-07-10 IDA 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
35103 35103 1987-11-02 1982-12-22 Warren John Gerard 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
36548 36548 1991-11-29 1985-11-01 O'Brien John IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
36992 36992 2008-11-30 2007-10-15 Thurston Katherine M. IDA Ireland 1770 1964-07-10 IDA 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
38702 38702 2018-12-18 2019-02-27 Gaule Patrick IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);