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,939 rows
FARA_All_RegistrantDocs
Date_Stamped, Registrant_Name, Registration_Number, Document_Type, Short_Form_Name, Foreign_Principal_Name, Foreign_Principal_Country, URL
135,872 rows
FARA_All_Registrants
Registration_Number, Registration_Date, Termination_Date, Name, Business_Name, Address_1, Address_2, City, State, Zip
6,717 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,460 rows
FARA_All_ForeignPrincipals_fts (hidden)
Foreign_Principal, Registrant_Name, FARA_All_ForeignPrincipals_fts, rank
16,939 rows
FARA_All_RegistrantDocs_fts (hidden)
Registrant_Name, Short_Form_Name, Foreign_Principal_Name, FARA_All_RegistrantDocs_fts, rank
135,872 rows
FARA_All_Registrants_fts (hidden)
Name, Address_1, Address_2, FARA_All_Registrants_fts, rank
6,717 rows
FARA_All_ShortForms_fts (hidden)
Short_Form_Last_Name, Short_Form_First_Name, Registrant_Name, FARA_All_ShortForms_fts, rank
42,460 rows
Download SQLite DB: fara.db 36.3 MB