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

26 rows where Registration_Number = 933

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 26

Registration_Number 1

  • European Community Information Service · 26 ✖

Registrant_Name 1

  • European Community Information Service 26

City 1

  • Washington 26
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
8649 8649 1965-03-01 1962-08-13 Van Dyk Frederick Theodore European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
10026 10026 1962-03-16 1958-10-01 Young Howard Winthrop European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
10733 10733 1966-03-25 1964-10-29 Mart Marcel Emile European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
12401 12401 1970-04-01 1968-03-25 Silj Alessandro European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
22589 22589 1968-07-05 1966-09-30 Froschmaier Franz European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
23194 23194 1969-07-15 1964-04-03 Dauman Alma Reid European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
24465 24465 1971-07-30 1967-07-18 Bayer Jonathan L. European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
27391 27391 1958-08-25 1958-02-25 Rittersporn Bernard Andrew , Jr. European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
33046 33046 1963-10-17 1963-10-17 Lewis John Fulton European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
34148 34148 1964-10-31 1956-03-12 Tennyson Leonard Bernhard European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
36352 36352 1966-11-25 1965-03-25 Freidberg Stephen Platt European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37769 37769 1972-12-05 1956-03-12 Lipson Leon Samuel European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37770 37770 1972-12-05 1971-04-19 Lynch Kathleen A. European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37771 37771 1972-12-05 1971-04-19 Tennyson Leonard Bernhard European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37772 37772 1972-12-05 1967-04-28 Hirst Stephen European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37773 37773 1972-12-05 1963-07-15 Krucoff Ella Lublin European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37774 37774 1972-12-05 1966-08-03 Lynch Kathleen Ann European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37775 37775 1972-12-05 1970-09-23 Vanhaeverbeke Guy European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37776 37776 1972-12-05 1971-10-08 Flattau Edward European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37777 37777 1972-12-05 1972-10-10 Howe Russell Warren European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37778 37778 1972-12-05 1972-10-10 Locke Mary Elizabeth European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37779 37779 1972-12-05 1972-10-10 Nicklin Walter Shirley , III European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
37780 37780 1972-12-05 1973-10-12 Trott Sarah Hays European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
38105 38105 1965-12-11 1964-10-29 Speranza Gianfranco European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
38859 38859 1973-12-21 1966-11-15 Ciarnelli Franco a. European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037
39781 39781 1964-12-31 1963-10-08 Weil Gordon Lee European Community Information Service 933 1956-03-12 European Community Information Service 2100 M Street, N.W. Suite 707 Washington DC 20037

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 1554.018ms · 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