FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
5 rows where Short_Form_First_Name = "Mark" and State = "MA"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7607 | 7607 | 1985-02-25 | 1982-09-13 | Saltzman | Mark | Newsome & Company, Inc. 3189 | 1981-01-09 | Newsome & Company, Inc. | 225 Franklin Street | Boston | MA | 02110 | |
9329 | 9329 | 1960-03-07 | 1959-04-16 | Kirsten | Mark | University Travel Company 1218 | 1959-04-16 | University Travel Company | 18 Brattle Street | Cambridge | MA | ||
16152 | 16152 | 2002-05-12 | 2000-01-27 | Hallan | Mark | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
28263 | 28263 | 1995-08-31 | 1992-04-20 | Hallan | Mark | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
36848 | 36848 | 1997-11-30 | 1996-04-25 | Fitzgerald | Mark | Friends of Fine Gael, Inc. 5068 | 1995-11-08 | Friends of Fine Gael, Inc. | 55 Union Street | Suite 200 | Boston | MA | 02108-2400 |
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]) );