FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where City = "Boston" and Zip = "" sorted by Registration_Date
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37852 | 37852 | 1946-12-07 | 1943-06-23 | Shaheen | George | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | 216 Harrison Avenue | Boston | MA | ||
37853 | 37853 | 1946-12-07 | 1943-07-05 | Abourjaily | Michel | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | 216 Harrison Avenue | Boston | MA | ||
37854 | 37854 | 1946-12-07 | 1946-08-08 | Tuweiny | Ghassan (Ghassane Tueni) | Syrian National Party in the U.S. 32 | 1942-07-24 | Syrian National Party in the U.S. | 216 Harrison Avenue | Boston | MA | ||
7267 | 7267 | 1943-02-20 | 1943-03-20 | Ghiloni | Alfred R. | Ghiloni, Alfred R. 113 | 1942-08-20 | Ghiloni, Alfred R. | 7 Park Square | Boston | MA | ||
7268 | 7268 | 1943-02-20 | 1943-11-13 | Cowie | Kay | Ghiloni, Alfred R. 112 | 1942-08-20 | Ghiloni, Alfred R. | 7 Park Square | Boston | MA | ||
3464 | 3464 | 1949-01-09 | 1948-01-09 | Felton | George Eugene | Mysore Company 507 | 1948-01-09 | Mysore Company | 75 Federal Street | Boston | MA | ||
3465 | 3465 | 1949-01-09 | 1948-01-09 | Magel | Theodore Tellmann | Mysore Company 507 | 1948-01-09 | Mysore Company | 75 Federal Street | Boston | MA | ||
3466 | 3466 | 1949-01-09 | 1948-01-09 | Webb | Elizabeth | Mysore Company 507 | 1948-01-09 | Mysore Company | 75 Federal Street | Boston | MA | ||
10108 | 10108 | 1960-03-17 | 1959-11-02 | Comito | Vincenzo | National Travel Company, Inc. 1271 | 1959-09-17 | National Travel Company, Inc. | 90 State Street | Boston | MA | ||
10109 | 10109 | 1960-03-17 | 1959-11-02 | Iacuzio | Nicola Ciriaco | National Travel Company, Inc. 1271 | 1959-09-17 | National Travel Company, Inc. | 90 State Street | Boston | MA | ||
10110 | 10110 | 1960-03-17 | 1959-11-02 | Olivito | John S. | National Travel Company, Inc. 1271 | 1959-09-17 | National Travel Company, Inc. | 90 State Street | Boston | MA | ||
10111 | 10111 | 1960-03-17 | 1959-11-02 | Pedrelli | Bruno | National Travel Company, Inc. 1271 | 1959-09-17 | National Travel Company, Inc. | 90 State Street | Boston | MA | ||
10112 | 10112 | 1960-03-17 | 1959-11-02 | Peirano | James John | National Travel Company, Inc. 1271 | 1959-09-17 | National Travel Company, Inc. | 90 State Street | Boston | MA | ||
10113 | 10113 | 1960-03-17 | 1959-11-02 | de Rensis | Pardo | National Travel Company, Inc. 1271 | 1959-09-17 | National Travel Company, Inc. | 90 State Street | Boston | MA | ||
19085 | 19085 | 1960-06-09 | 1960-03-29 | Barkin | Alan Solomon | Bernstone, Lawrence Jesse 1347 | 1960-03-29 | Bernstone, Lawrence Jesse | 11 Beacon Street | Boston | MA | ||
19086 | 19086 | 1960-06-09 | 1960-03-29 | Swartz | Herbert Stanley | Bernstone, Lawrence Jesse 1347 | 1960-03-29 | Bernstone, Lawrence Jesse | 11 Beacon Street | Boston | MA | ||
14439 | 14439 | 1964-04-30 | 1963-01-04 | Cardozo | Antonio Jesus | Portuguese-American Committee on Foreign Affairs 1588 | 1963-01-04 | Portuguese-American Committee on Foreign Affairs | 20 Pemberton Square | Suite 909 | Boston | MA | |
14443 | 14443 | 1964-04-30 | 1963-04-01 | Camacho | Martin Thomas | Portuguese-American Committee on Foreign Affairs 1588 | 1963-01-04 | Portuguese-American Committee on Foreign Affairs | 20 Pemberton Square | Suite 909 | Boston | MA |
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]) );