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

40 rows where Registrant_Name = "Australian Information Service"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

State 1

  • NY 40

Registration_Number 1

  • Australian Information Service 40

Registrant_Name 1

  • Australian Information Service · 40 ✖

City 1

  • New York 40
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
4192 4192 1949-01-21 1946-12-31 Clarke Alexander Lloyd Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
4197 4197 1970-01-21 1964-08-20 Hamilton Ian Charles Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
4240 4240 1951-01-22 1947-07-24 Briears John Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
4728 4728 1948-01-29 1946-12-31 Morison Peter Edward Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
4786 4786 1964-01-30 1961-10-06 Long Frank Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
5714 5714 1979-02-01 1973-03-13 Long Frank H. Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
5715 5715 1979-02-01 1977-04-04 Corless Yvonne Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
5721 5721 1979-02-01 1972-11-06 Henry James Malcolm Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
6042 6042 1973-02-03 1961-10-06 Malone John Michael Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
6137 6137 1952-02-05 1949-08-18 Mulgrue George Edward Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
6138 6138 1952-02-05 1950-09-05 O'Brien Patricia Marie Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
6272 6272 1958-02-07 1952-09-05 Slocombe Cecil Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
6273 6273 1958-02-07 1955-09-10 Herrick George Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
6882 6882 1949-02-15 1946-12-31 Houston Kathleen Rogers Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
7276 7276 1956-02-20 1955-08-05 Brown Stephen Stevenson Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
9802 9802 1951-03-14 1949-08-18 Bonney Edmund Garnet Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
11475 11475 1977-03-31 1961-10-06 Slocombe Cecil Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
18884 18884 1964-06-05 1960-02-25 Pratt Melbourne Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
21113 21113 1989-06-30 1957-02-13 Buckley Noel Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23086 23086 1947-07-14 1946-12-31 Brodie Diana Margaret Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23087 23087 1947-07-14 1946-12-31 Grossman Phoebe Aneza Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23088 23088 1947-07-14 1946-12-31 Marciante John J. Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23089 23089 1947-07-14 1946-12-31 Skolski Beryl Marie Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23696 23696 1948-07-21 1947-02-12 McArthur-Berry Doreen Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23697 23697 1948-07-21 1947-07-24 Hewitt Edwin John Hedley Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23698 23698 1948-07-21 1947-07-24 McEntee Catherine Helen Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23699 23699 1948-07-21 1947-07-24 McKenna Dorothy Margaret Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
23700 23700 1948-07-21 1946-12-31 O'Connor Arthur Henry Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
24131 24131 1949-07-27 1947-07-24 Stelling Marjorie Edith Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
24625 24625 1961-07-31 1958-04-10 Hungerford Thomas Arthur Guy Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
25968 25968 1955-08-05 1952-03-14 Arthur James Hartney Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
25969 25969 1955-08-05 1951-08-21 Younger Ronald Michel Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
27098 27098 1970-08-21 1947-07-24 MacDonald Jean Clara Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
27099 27099 1970-08-21 1947-07-24 Pozzesi Phyllis Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
27100 27100 1970-08-21 1946-12-31 Foley Lilian Mary Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
27101 27101 1970-08-21 1946-12-31 Slingland Margaret Patricia Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
27453 27453 1947-08-26 1946-12-31 Casey Gavin Stodart Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
29073 29073 1952-09-03 1952-09-05 Henderson Barbara June Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
29504 29504 1956-09-10 1955-08-05 Hefter Frank Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
35131 35131 1947-11-03 1946-12-31 Blunk Frank Mario Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020

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