home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

12 rows where Registrant_Name = "Irish Northern Aid Committee"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 12

Registration_Number 1

  • Irish Northern Aid Committee 12

Registrant_Name 1

  • Irish Northern Aid Committee · 12 ✖

City 1

  • New York 12
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
2695 2695 1990-01-01 1973-07-02 Connolly John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
2696 2696 1990-01-01 1973-07-02 Guerin Patrick Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
2697 2697 1990-01-01 1973-07-24 Byrnes Peter Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
2700 2700 1990-01-01 1985-10-03 Kelly James Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
3788 3788 1987-01-15 1985-06-12 McElhone John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
10789 10789 1979-03-26 1971-04-12 Higgins Matthew Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
15332 15332 1974-05-01 1971-04-06 McGowan John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
18445 18445 1981-06-01 1971-04-06 McCarthy John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
27491 27491 1996-08-26 1992-01-30 McCann Robert Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
27492 27492 1996-08-26 1985-06-12 Murphy Alexander Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
31035 31035 1989-09-30 1971-04-06 Flannery Michael Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
40258 40258 1983-12-31 1976-06-25 McCusker Brendan Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154

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])
);
Powered by Datasette · Queries took 362.767ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows