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

29 rows where City = "Los Angeles" and Registration_Number = 672

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name

State 1

Registration_Number 1

  • New Zealand Central Reservations Office · 29 ✖

City 1

  • Los Angeles · 29 ✖
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
2526 2526 1964-01-01 1961-03-02 Scott Wilson New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3616 3616 1983-01-12 1979-03-05 Hunt Leonard Godfrey New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3703 3703 1983-01-14 1979-03-05 Simpson Roger New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3940 3940 1960-01-17 1951-04-23 Firth Roberts Mathew New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
7325 7325 1973-02-21 1968-11-19 Yates Joseph Bernard New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
7695 7695 1976-02-26 1972-08-09 Storry John Bradford Russell New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
10660 10660 1975-03-24 1975-03-24 Heppleston James William New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
11030 11030 1971-03-29 1970-08-20 Andrew Kevin Wayne New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
14163 14163 1956-04-27 1952-02-07 Feslier Arthur Gerard New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
16398 16398 1987-05-15 1984-01-23 Meilink John Charles New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
16866 16866 1972-05-22 1967-08-16 Davey John Daysh New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
17075 17075 1973-05-25 1970-08-20 Robinson Thomas Garth New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
20702 20702 1960-06-30 1954-05-10 Hamilton Ian Alan New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
21175 21175 1992-06-30 1987-10-15 McKinlay Dennis Gordon New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
22058 22058 1965-07-01 1963-04-18 Wilson Warwick Bruce New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
29520 29520 1981-09-10 1978-06-13 Pierce Denis New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
33048 33048 1967-10-17 1967-08-16 Bollard Richard Dakin New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
34176 34176 1974-10-31 1971-02-19 Boggs Ilma Merle New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
35464 35464 1960-11-09 1956-09-10 Stone James Reginald New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
37600 37600 1977-12-02 1974-01-30 Kerr Frank Edward New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
37652 37652 1957-12-03 1956-09-10 Smith Irene Margaret New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
37956 37956 1983-12-09 1980-01-25 Damiano Michael John New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
38499 38499 1983-12-16 1981-08-03 Smith Patricia Lynn New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
39873 39873 1969-12-31 1960-08-10 Gouffe Noel Frederick Francis New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
39875 39875 1969-12-31 1967-08-16 McAnnalley Colin Arkle New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
40452 40452 1988-12-31 1984-01-23 Murray Sean Alistair New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
40507 40507 1988-12-31 1983-07-07 Tippen Jefferie James New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
40518 40518 1988-12-31 1973-08-08 Manning Langley Frederick New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
40520 40520 1988-12-31 1970-08-20 Race Brian Peter New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045

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