fara

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

Tables

FARA_All_ForeignPrincipals

Foreign_Principal_Termination_Date, Foreign_Principal, Foreign_Principal_Registration_Date, Country/Location_Represented, Registration_Number, Registrant_Date, Registrant_Name, Address_1, Address_2, City, State, Zip

16,838 rows

FARA_All_RegistrantDocs

Date_Stamped, Registrant_Name, Registration_Number, Document_Type, Short_Form_Name, Foreign_Principal_Name, Foreign_Principal_Country, URL

132,967 rows

FARA_All_Registrants

Registration_Number, Registration_Date, Termination_Date, Name, Business_Name, Address_1, Address_2, City, State, Zip

6,666 rows

FARA_All_ShortForms

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

42,149 rows

... and 20 hidden tables