FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where Address_2 = "Suite 2250" and Registration_Number = 1276
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date (date)
State 1
- CA 29
Registration_Number 1
- New South Wales Government Office · 29 ✖
Registrant_Name 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]) );