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

26 rows where State = "MO"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
183 1943-03-31 1943-03-31 Gastreich, Hermann   1400 Walnut Street   Kansas City MO  
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
3162 1980-11-04 1982-04-28 Koerner, Paul K.   Post Office Box 16041   Clayton MO 63105
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
4143 1988-05-18 1993-07-08 Wood, Randell K.   1736 East Sunshine Suite 517 Springfield MO 65804
4492 1991-04-01 1991-10-31 Boasberg Valentine-Radford, Inc.   4600 Madison Avenue   Kansas City MO 64112
4739 1992-12-17 2006-07-31 Oliver A. Dulle, Jr. & Company, Inc.   8000 Maryland Avenue Suite 1320 St. Louis MO 63105
5246 1998-03-01   Oliver A. Dulle Jr. & Company   7751 Carondelet Avenue Suite 805 Clayton MO 63105
5366 2000-04-12 2000-07-10 Quiko, Eduard   1899 Point Royale Drive   Branson MO 65618
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
6400 2016-12-23   VML, Inc.   250 Richards Road   Kansas City MO 64116
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
6492 2017-11-27   MMGY Global, LLC   4601 Madison Avenue   Kansas City MO 64112
6549 2018-04-30   Myriad International Marketing, LLC   4601 Madison Avenue   Kansas City MO 64112

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