FARA_All_Registrants

List of all registrant data (active and terminated)

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

14 rows where City = "San Juan"

View and edit SQL

Suggested facets: Name, Business_Name, Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

City

  • San Juan · 14
Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
662 1951-03-05 1961-09-05 Dominican Revolutionary Party, Puerto Rico   1458 Feria Street   San Juan    
914 1955-09-26 1955-09-26 Confederacion General de Trabajadores de P. Rico-Autentica   Calle San Antonio 620 Barrio Obrero, Santurce San Juan    
1124 1958-03-19 1958-03-19 De Carreras, Josefa Moreno   Pub. Recreation & Parks Admin. Commonwealth of Puerto Rico San Juan    
1143 1958-05-23 1958-05-23 Delgado Linares, Nicolas   Casa Baldrich 354 San Francisco Street San Juan    
1367 1960-06-06 1962-12-06 Netherlands West Indies Tourist Commission   Post Office Box 3072   San Juan    
1439 1961-04-24 1961-04-24 Roques Martinez, Jose Ricardo   Box 2014   San Juan    
1557 1962-07-05 1962-07-05 Matos Gonzalez, Celeste Antonia   Collins 618 Summit Hills, Puerto Nuevo San Juan    
1572 1963-01-21 1963-09-27 Roca Jr., Gaspar   First Federal Savings Building P.O. Box 4011, Stop 23 San Juan    
1730 1964-05-13 1966-11-29 Nachman & Feldstein   Ballester Building 104 Paseo Covadonga, 3rd Floor San Juan    
1733 1964-05-15 1964-09-09 Ponsa Feliu, Francisco   401 Plaza Building Box 3992 San Juan    
1929 1965-09-28 1966-12-12 Partido Revolucionario Dominicano, Puerto Rico   6 Borda Building Reparto Acacia Monterrey, P.V. San Juan    
2246 1971-03-08 1978-09-08 Partido Revolucionario Dominicano, Puerto Rico   361 Aponte Street   San Juan    
2344 1972-06-05 1981-12-03 Spanish National Tourist Office, Puerto Rico Oficina Nacional Espanola de Turismo 367 Fortaleza Street   San Juan PR 00902
2967 1978-10-24 1982-11-24 Partido de la Liberacion Dominicana, San Juan   Lippitt 405 (altes) Villa Palmeras San Juan    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);
Powered by Datasette · Query took 36.226ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history