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 Registration_Number = 672

View and edit SQL

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

State

Registration_Number

  • 672 · 29

City

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
2296 1964-01-01 1961-03-02 Scott Wilson 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3333 1983-01-12 1979-03-05 Hunt Leonard Godfrey 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3419 1983-01-14 1979-03-05 Simpson Roger 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3641 1960-01-17 1951-04-23 Firth Roberts Mathew 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
6944 1973-02-21 1968-11-19 Yates Joseph Bernard 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
7301 1976-02-26 1972-08-09 Storry John Bradford Russell 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
10172 1975-03-24 1975-03-24 Heppleston James William 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
10537 1971-03-29 1970-08-20 Andrew Kevin Wayne 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
13557 1956-04-27 1952-02-07 Feslier Arthur Gerard 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
15683 1987-05-15 1984-01-23 Meilink John Charles 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
16139 1972-05-22 1967-08-16 Davey John Daysh 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
16348 1973-05-25 1970-08-20 Robinson Thomas Garth 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
19847 1960-06-30 1954-05-10 Hamilton Ian Alan 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
20320 1992-06-30 1987-10-15 McKinlay Dennis Gordon 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
21145 1965-07-01 1963-04-18 Wilson Warwick Bruce 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
28370 1981-09-10 1978-06-13 Pierce Denis 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
31770 1967-10-17 1967-08-16 Bollard Richard Dakin 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
32877 1974-10-31 1971-02-19 Boggs Ilma Merle 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
34113 1960-11-09 1956-09-10 Stone James Reginald 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
36150 1977-12-02 1974-01-30 Kerr Frank Edward 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
36200 1957-12-03 1956-09-10 Smith Irene Margaret 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
36496 1983-12-09 1980-01-25 Damiano Michael John 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
37020 1983-12-16 1981-08-03 Smith Patricia Lynn 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
38383 1969-12-31 1960-08-10 Gouffe Noel Frederick Francis 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
38385 1969-12-31 1967-08-16 McAnnalley Colin Arkle 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
38962 1988-12-31 1984-01-23 Murray Sean Alistair 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
39017 1988-12-31 1983-07-07 Tippen Jefferie James 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
39028 1988-12-31 1973-08-08 Manning Langley Frederick 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
39030 1988-12-31 1970-08-20 Race Brian Peter 672 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])
);