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

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • New South Wales Government Office · 29 ✖

Registrant_Name 1

City 1

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
3521 3521 1985-01-10 1980-03-11 Shurtleff Robert Bruce New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
4935 4935 1972-01-31 1967-07-20 Rule Frank Edwin New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
7581 7581 1974-02-25 1974-02-05 Jones Brian Jeffrey New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
7844 7844 1967-02-28 1959-10-30 Denning Arthur New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
9218 9218 1974-03-06 1974-02-05 Terry Christopher Stephen New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
12817 12817 1965-04-06 1962-04-09 Rees Esmond John New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
12986 12986 1982-04-09 1980-03-11 Hanks Bruce Owen New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
13380 13380 1974-04-15 1974-02-25 Harding Peter Graham New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
17665 17665 1982-05-31 1979-02-14 Black James Wilfred New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
18972 18972 1980-06-06 1975-05-09 Muir James Fulton New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
19952 19952 1968-06-21 1967-01-18 Jones Brian Dudley Jeffrey New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
20209 20209 1961-06-25 1961-05-26 Flood William Swift New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
23954 23954 1978-07-24 1975-05-09 Parsons William Joseph New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
25460 25460 1966-08-01 1962-04-09 Martin Phillip James New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
27297 27297 1962-08-24 1959-10-30 Larcombe Richard Boston New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
29978 29978 1966-09-17 1962-10-19 Giles Leslie Morton New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
30111 30111 1966-09-20 1964-08-06 Dodds Raymond Stewart New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
32404 32404 1981-10-07 1979-02-06 Froud Alan John New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
33598 33598 1979-10-25 1978-11-28 McKie Richard Storey New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
35791 35791 1968-11-15 1959-10-30 Whitecross Roy Hamilton New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
36365 36365 1983-11-25 1981-07-29 Williams David Kenneth New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
36464 36464 1963-11-27 1961-05-26 Gibson John Douglas New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
37249 37249 1962-12-01 1960-11-07 Reed Dennis Lindsay New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
38267 38267 1962-12-14 1959-10-30 Walker William John New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
38918 38918 1962-12-22 1961-10-12 Savage John New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
40549 40549 1989-12-31 1980-03-11 Van Helden Hendrik G. New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
40574 40574 1989-12-31 1988-06-20 Hamwey Michael C. New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
40577 40577 1989-12-31 1980-07-04 Day Gary Spears New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
40587 40587 1989-12-31 1972-09-19 Dyer David L. New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 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])
);