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

64 rows where Registrant_Name = "Tourism Australia" and State = "CA"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • CA · 64 ✖

Registration_Number 1

  • Tourism Australia 64

Registrant_Name 1

  • Tourism Australia · 64 ✖

City 1

  • Los Angeles 64
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
2166 2166   1994-11-14 Monfrini Robert W. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2809 2809 2002-01-01 1988-07-26 Gray Lyndel Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
3388 3388 1973-01-08 1958-02-04 Flynn Patricia Mary Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
4991 4991 1984-01-31 1982-02-05 Wenn Paul Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
6171 6171 1986-02-05 1982-07-30 Browne Helene Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
6645 6645 1971-02-12 1970-07-23 McIvor Dormerick Adrian Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
9620 9620 1974-03-11 1962-03-12 Holmes John William Thomas Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
13742 13742 1982-04-19 1982-02-05 Tisdell Gemma Mary Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
15302 15302 1960-05-01 1958-06-03 Cummings David W. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
18738 18738 1964-06-03 1961-07-17 Brisacher Robert Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
18740 18740 1966-06-03 1965-02-11 Quartermain Arthur Alan Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
20774 20774 1966-06-30 1966-03-28 Arthur Harvey James Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
20775 20775 1966-06-30 1966-03-28 Clark Ian Melville Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
20998 20998 1983-06-30 1982-02-05 Shelton George Howard Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21057 21057 1986-06-30 1985-06-04 Begni Vera Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21378 21378 2001-06-30 1986-02-03 Fisher Luke Andrew Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21379 21379 2001-06-30 1992-02-18 Hancock Carole Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21380 21380 2001-06-30 1992-02-18 Mahoney Stephen Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21381 21381 2001-06-30 1991-03-28 White Susan Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21409 21409 2001-06-30 1988-07-26 Beere Richard Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21410 21410 2001-06-30 1988-07-26 King John Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21412 21412 2001-06-30 1990-08-07 Bowman David Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
21413 21413 2001-06-30 1990-08-07 Wren Greg Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
23845 23845 1982-07-23 1977-01-25 Wood Robert M. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
26082 26082 1977-08-06 1974-10-18 Bowman Steve Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
26939 26939 1990-08-18 1988-07-26 Squire Glenn Paul Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
27097 27097 1970-08-21 1970-07-23 Shackleton Gregory John Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
27909 27909 1973-08-31 1963-11-04 Mercer Harry Eric Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
28809 28809 1980-09-01 1980-04-04 McDonell Neil Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
28810 28810 1980-09-01 1980-04-04 Wenn Paul Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
29454 29454 1959-09-09 1957-06-03 Constable John Thomas Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
29668 29668 1985-09-13 1983-01-31 Corbett Kenneth Lee Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
29979 29979 1976-09-17 1974-01-30 Dodd Clifford Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
30425 30425 1981-09-25 1980-11-04 Millett-Brandon Gwenneth Claire Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
30949 30949 1981-09-30 1980-11-04 Dunstan Kimberly Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
32350 32350 1972-10-06 1970-07-23 Pittendrigh Andrew James Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
33957 33957 1981-10-29 1980-04-04 Storey Wayne Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
34171 34171 1970-10-31 1964-09-25 O'Connor David Francis Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
36643 36643 1981-11-30 1981-08-03 Hall Wendy A. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
37655 37655 1964-12-03 1962-08-03 Beresford Donald Charles la Poer Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
37717 37717 1968-12-04 1963-04-15 Walker William John Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
38374 38374 1979-12-15 1978-01-19 Kennedy Ian L. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
38782 38782 1972-12-20 1969-05-21 Richardson John I. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
38783 38783 1972-12-20 1969-07-17 Kennedy Ian L. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
39046 39046 1964-12-24 1960-02-19 Piesse Richard David Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
39868 39868 1969-12-31 1968-05-28 Bier Charles A. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
39869 39869 1969-12-31 1968-05-28 Ryan Patricia Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
39870 39870 1969-12-31 1968-05-28 Steinberg Jack Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
39883 39883 1970-12-31 1962-03-12 Younger Ronald M. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
39924 39924 1972-12-31 1965-08-19 Thomas Lowell , Jr. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40242 40242 1982-12-31 1980-11-04 Walker William J. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40332 40332 1985-12-31 1984-08-16 Edwards Helen Kaye Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40372 40372 1986-12-31 1984-08-16 Rooney Alison Ruth Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40389 40389 1987-12-31 1986-02-03 Bostock William D. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40390 40390 1987-12-31 1986-02-03 Bull Jeanette Rosemary Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40417 40417 1987-12-31 1982-07-30 Price Jennifer Evans Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40418 40418 1987-12-31 1983-08-01 Drew Alan John Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40422 40422 1987-12-31 1984-08-16 Baker Thomas William Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40423 40423 1987-12-31 1984-08-16 Benjamin Bernadette E. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40424 40424 1987-12-31 1984-08-16 Clark Colin John Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40425 40425 1987-12-31 1984-08-16 Hudson Daryl Stephen Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40430 40430 1987-12-31 1985-09-03 Arnold Kevin John Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40431 40431 1987-12-31 1985-09-03 Weeks Adrian Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
40432 40432 1987-12-31 1985-09-03 Zawadzki Roman Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067

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