FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where State = "LA" and Zip = ""
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Termination_Date, Name, Address_2, Registration_Date (date), Termination_Date (date)
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
171 | 1943-01-06 | 1943-01-06 | Longin-Spindler, Emanuel Mary Paul | 2318 Broadway | New Orleans | LA | |||
504 | 1947-11-28 | 1948-04-06 | Urruela, Rafael J. | Hotel Roosevelt | New Orleans | LA | |||
907 | 1955-09-01 | 1957-03-01 | Scott Wilson & Associates | St. Charles Hotel | Suite 338 | New Orleans | LA | ||
1147 | 1958-04-11 | 1963-04-01 | Schaumburger, Max Maas | Whitney Building | Suite 621 | New Orleans | LA | ||
1152 | 1958-06-23 | 1958-11-30 | Scott Wilson & Associates | St. Charles Hotel | Suite 338 | New Orleans | LA | ||
1167 | 1958-09-04 | 1959-03-04 | Smithhart, Clyde Geral | 405-6 Pioneer Building | Lake Charles | LA | |||
1376 | 1960-07-14 | 1960-08-16 | Cabrera, Henry | C/O W.R. Zanes of LA, Inc. | 442 Canal Street | New Orleans | LA | ||
1377 | 1960-07-14 | 1960-08-16 | Comite de Ayuda Pro Liberacion de Nicaragua | Post Office Box 2432 | New Orleans | LA | |||
1504 | 1961-12-29 | 1962-06-30 | Ronny Caire Advertising Agency, Inc. | 704 Cigali Building | New Orleans | LA |
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]) );