FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

15 rows where State = "AZ"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Termination_Date, Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

State 1

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
281 1944-09-23 1948-03-23 Ong, Ying   1001 East Roosevelt Street   Phoenix AZ  
1570 1962-08-31 1962-08-31 Angelidis, John J.   3927 East Cheery Lynn Road   Phoenix AZ  
1870 1965-03-16 1985-10-22 Mexican Government Tourist Office, Tucson   5151 East Broadway Suite l535 Tucson AZ 85711
2201 1970-07-10 1985-12-31 Mexican Government Tourism Office, Phoenix   3443 North Central Avenue Suite 101 Phoenix AZ 85012
3388 1982-07-09 1983-02-04 Farnsworth, Albert M.   Post Office Box 306   Chandler AZ 85224
3683 1985-05-23 1987-02-09 Langgons, Jeanmarie   2550 East Beardsley Suite 41 Phoenix AZ 85024
3993 1987-06-15 1990-05-10 Immobiliaria Caribe Y. Pacifico, S.A. Samuel A. Joyner 1014 East Hampton Street   Tucson AZ 85719
3999 1987-06-29 1988-07-18 Eisenhower Group, Inc.   340 East Palm Lane Suite 110 Phoenix AZ 85004
4059 1987-11-16 1993-05-16 National Front for the Liberation of Angola   6420 West College Drive   Phoenix AZ 85033
5504 2002-06-18 2005-03-31 Policy Development Group, Inc.   3636 North Central Avenue Suite 590 Phoenix AZ 85012-1953
5759 2006-06-12 2006-12-31 Miko, Jason   215 E. Crooked Stick Drive   Oro Valley AZ 85737
5917 2009-03-09   Kuykendall, Gregory J., PC   531 South Convent Avenue   Tucson AZ 85701
5958 2009-10-05 2013-04-30 Discover the World Marketing   7020 E. Acoma Drive   Scottsdale AZ 85254
6893 2020-11-20 2021-02-26 Farhang & Medcoff, PLLC   4801 E. Broadway Boulevard #311 Tucson AZ 85711
6946 2021-04-09   Kyle Moyer & Company, LLC   10925 N 78th Street   Scottsdale AZ 85260

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);