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

17 rows where City = "St. Louis"

View and edit SQL

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

State

City

  • St. Louis · 17
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
976 1956-09-11 1957-09-11 Mercado, Juan   3700 Page Boulevard   St. Louis MO  
1220 1959-04-21 1959-04-21 Jones, Robert Nagel   1010 Arcade Building 812 Olive Street St. Louis MO  
1385 1960-08-12 1973-03-14 Gardner Advertising Company, Inc.   10 Broadway   St. Louis MO 63102
2179 1969-12-19 1971-10-26 Niven, Alexander C.   Warson Woods 1121 Timberlane St. Louis MO 63122
3156 1980-10-10 1986-08-22 Transcontinental Financial & Trading Corporation   4146 South Grand Boulevard   St. Louis MO 63118
3436 1983-01-11 1989-12-19 Thompson & Mitchell   1 Mercantile Center Suite 3400 St. Louis MO 63101
3461 1983-04-20 1984-11-20 Armstrong, Teasdale, Kramer & Vaughan   611 Olive Street Suite 1900 St. Louis MO 63101
3774 1986-02-05 2004-08-05 Fleishman-Hillard, Inc.   200 North Broadway   St. Louis MO 63102-2796
4739 1992-12-17 2006-07-31 Oliver A. Dulle, Jr. & Company, Inc.   8000 Maryland Avenue Suite 1320 St. Louis MO 63105
5429 2001-05-09 2002-11-30 Bryan Cave LLP   One Metropolitan Square 211 North Broadway, Suite 3600 St. Louis MO 63102
5801 2007-04-16   Fleishman-Hillard, Inc.   200 North Broadway   St. Louis MO 63102
5821 2007-07-27 2010-01-31 Avatar Enterprises, Inc.   10349 Watson Road Suite 100 St. Louis MO 63127
5891 2008-11-18 2009-05-31 Everson, David E.   Stinson Morrison Hecker, LLP 7700 Forsyth Boulevard Suite 1100 St. Louis MO 63105
5959 2009-10-29 2010-03-01 Oliver A. Dulle Jr. & Company, Inc.   8000 Maryland Avenue Suite 1320 St. Louis MO 63105
6418 2017-04-16 2017-07-31 Baron Public Affairs, LLC   7777 Bonhomme Avenue Suite 1800 St. Louis MO 63105
6438 2017-06-09   Ashcroft Law Firm, LLC   1100 Main Street Suite 2700 St. Louis MO 64105
6486 2017-11-09 2018-11-30 Kit Bond Strategies, LLP   7733 Forsyth Boulevard Suite 2200 St. Louis MO 63105

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 46.819ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history