home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_Registrants

Table actions
  • GraphQL API for 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

25 rows where State = "MO"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Address_1 23

  • 200 North Broadway 2
  • 8000 Maryland Avenue 2
  • 1 Mercantile Center 1
  • 10 Broadway 1
  • 1010 Arcade Building 1
  • 10349 Watson Road 1
  • 1100 Main Street 1
  • 1400 Walnut Street 1
  • 1736 East Sunshine 1
  • 1899 Point Royale Drive 1
  • 211 North Broadway 1
  • 250 Richards Road 1
  • 3700 Page Boulevard 1
  • 4146 South Grand Boulevard 1
  • 4600 Madison Avenue 1
  • 611 Olive Street 1
  • 7711 Bonhomme Avenue 1
  • 7733 Forsyth Boulevard 1
  • 7777 Bonhomme Avenue 1
  • One Metropolitan Square 1
  • Post Office Box 16041 1
  • Stinson Morrison Hecker, LLP 1
  • Warson Woods 1

City 5

  • St. Louis 17
  • Kansas City 4
  • Clayton 2
  • Branson 1
  • Springfield 1

State 1

  • MO · 25 ✖
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   7711 Bonhomme Avenue Suite 310 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 2018-10-31 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 2710 Kansas City MO 64105
6486 2017-11-09 2018-11-30 Kit Bond Strategies, LLP   7733 Forsyth Boulevard Suite 2200 St. Louis MO 63105
7157 2022-08-12   Bryan Cave Leighton Paisner LLP   211 North Broadway Suite 3600 St. Louis MO 63102

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