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

13 rows where Registration_Number = 2378

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Grenada Board of Tourism · 13 ✖

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
6666 6666 1991-02-12 1984-01-27 Evans Margaret B. Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
7882 7882 1977-02-28 1974-11-14 Protain Sandra Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
9932 9932 1979-03-15 1975-07-30 Redhead Francis M. Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
11535 11535 1984-03-31 1981-12-17 Sylvester-Henry Jocelyn Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
13392 13392 1981-04-15 1981-12-17 Davidson Bernice W. Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
15636 15636 1994-05-03 1991-06-18 Ogilvie Linda Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
28081 28081 1985-08-31 1984-01-27 Hood Dave D. Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
30031 30031 2000-09-18 1999-07-27 Bullen Gail Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
32898 32898 1990-10-15 1990-08-02 Greaves Dunbar J. Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
33186 33186 1973-10-19 1972-09-10 Gibbs Jenny Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
34950 34950 1993-11-01 1992-04-24 Mathlin Shireene Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
36776 36776 1994-11-30 1991-06-18 Smith Eunice Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017
40244 40244 1982-12-31 1981-12-17 Francis Nordica Grenada Board of Tourism 2378 1972-09-10 Grenada Board of Tourism 317 Madison Avenue Suite 1522 New York NY 10017

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