FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where City = "Santurce" sorted by Registration_Number descending
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Registration_Date (date)
Termination_Date (date) 6 ✖
- 1946-03-06 1
- 1946-07-02 1
- 1961-02-01 1
- 1961-06-28 1
- 1963-06-17 1
- 1990-01-30 1
Address_1 6
City 1
- Santurce · 6 ✖
Registration_Number ▲ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
3664 | 1985-03-27 | 1990-01-30 | Partido de la Liberacion Dominicana, Santurce | Lippit 405 Altos | Santurce | PR | 00915 | ||
1893 | 1965-05-14 | 1963-06-17 | Publicidad Antillas, Inc. | 1556 Ponce de Leon Avenue | Santurce | ||||
1461 | 1961-06-28 | 1961-06-28 | Mainardi Reyna, Jose Virgilio | Santurce Station | Post Office Box 10135 | Santurce | |||
1424 | 1961-02-01 | 1961-02-01 | De Cuello, Luz Carolina Mainardi | Ponce de Leon Avenue 1259 | Santurce | ||||
286 | 1945-01-02 | 1946-07-02 | Comite Central de la Union Patriotica Dominicana | 9th Street & Magnolia Avenue | Suite 53 | Santurce | |||
279 | 1944-09-11 | 1946-03-06 | Dominican Revolutionary Party/Sect. of San Juan, Puerto Rico | 21 De Diego Avenue | Santurce |
Advanced export
JSON shape: default, array, newline-delimited, object
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]) );