home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

416 rows where State = "MO"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number 17

  • Fleishman-Hillard, Inc. 191
  • Fleishman-Hillard, Inc. 118
  • Gardner Advertising Company, Inc. 41
  • VML, Inc. 18
  • Ashcroft Law Firm, LLC 12
  • Armstrong, Teasdale, Kramer & Vaughan 7
  • Wood, Randell K. 6
  • Thompson & Mitchell 5
  • Oliver A. Dulle Jr. & Company 3
  • Avatar Enterprises, Inc. 3
  • Baron Public Affairs, LLC 3
  • Kit Bond Strategies, LLP 3
  • Boasberg Valentine-Radford, Inc. 2
  • Transcontinental Financial & Trading Corporation 1
  • Oliver A. Dulle, Jr. & Company, Inc. 1
  • Bryan Cave LLP 1
  • Oliver A. Dulle Jr. & Company, Inc. 1

Registrant_Name 16

  • Fleishman-Hillard, Inc. 309
  • Gardner Advertising Company, Inc. 41
  • VML, Inc. 18
  • Ashcroft Law Firm, LLC 12
  • Armstrong, Teasdale, Kramer & Vaughan 7
  • Wood, Randell K. 6
  • Thompson & Mitchell 5
  • Avatar Enterprises, Inc. 3
  • Baron Public Affairs, LLC 3
  • Kit Bond Strategies, LLP 3
  • Oliver A. Dulle Jr. & Company 3
  • Boasberg Valentine-Radford, Inc. 2
  • Bryan Cave LLP 1
  • Oliver A. Dulle Jr. & Company, Inc. 1
  • Oliver A. Dulle, Jr. & Company, Inc. 1
  • Transcontinental Financial & Trading Corporation 1

City 4

  • St. Louis 375
  • Kansas City 32
  • Springfield 6
  • Clayton 3

State 1

  • MO · 416 ✖
Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
237 237   2022-01-31 Johnson Byron E Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
239 239   2022-01-31 Pierce Margaret Hannaway Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
240 240   2022-01-31 Williams Timothy Robert Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
260 260   2011-02-04 Overstreet Larry L. Oliver A. Dulle Jr. & Company 5246 1998-03-01 Oliver A. Dulle Jr. & Company 7711 Bonhomme Avenue Suite 310 Clayton MO 63105
1173 1173   2017-06-09 Ashcroft John D. Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1174 1174   2017-06-09 Ayres David T. Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1175 1175   2017-06-09 Day Lori Sharpe Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1176 1176   2017-06-09 Peele Christopher L. Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1177 1177   2017-06-09 Reyes Luis Alejandro Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1178 1178   2017-06-09 Sullivan Michael J. Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1324 1324   2020-07-10 Brennan Nathan Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1629 1629   2021-09-10 Rand Amy Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1630 1630   2021-09-10 Schmidt Michael T Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1739 1739   2019-10-02 West Kimberly Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
1785 1785   2020-10-13 Sadlier Lizanne Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2026 2026   2019-11-13 Bennett Barry Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
2330 2330   2007-12-26 Dulle Oliver A. Oliver A. Dulle Jr. & Company 5246 1998-03-01 Oliver A. Dulle Jr. & Company 7711 Bonhomme Avenue Suite 310 Clayton MO 63105
2417 2417 1969-01-01 1960-08-12 Claggett Charles Evans Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
2870 2870 2018-01-01 2017-09-19 Leong Lonna Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2975 2975 1973-01-03 1960-08-12 Pellegrino Thomas John Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3191 3191 1999-01-07 1992-03-05 Campbell W. Douglas Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3330 3330 2020-01-09 2017-06-09 Reilly Michelle T. Ashcroft Law Firm, LLC 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2710 Kansas City MO 64105
3531 3531 2000-01-14 1999-03-05 Harrower David A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3573 3573 1972-01-15 1968-10-11 Lucci Giuseppe Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
3721 3721 1998-01-16 1986-02-05 Sullivan Richard J. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3722 3722 1998-01-16 1992-03-05 Anderson William K. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3724 3724 1998-01-16 1988-09-01 Epstein Jerry A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3725 3725 1998-01-16 1989-09-05 Van Meter Jan R. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3726 3726 1998-01-16 1993-09-07 Modzelewski Jack (John F.) Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3780 3780 1989-01-17 1988-03-03 de Leon Richard Rueda Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3806 3806 2017-01-17 2009-03-16 Cutin Dario O. Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
3918 3918 1998-01-19 1995-09-06 Gonzalez Luis A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4301 4301 1995-01-25 1990-05-14 Morrison Jean Anne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4642 4642 2004-01-30 2002-03-28 Collender Stanley E. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4738 4738 1972-01-31 1968-10-11 Digby Noel Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
4827 4827 1988-01-31 1986-09-05 White Rene L. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4968 4968 1996-01-31 1993-10-20 Bingol Selim Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4978 4978 1997-01-31 1994-03-04 Sharples Susan Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4998 4998 1998-01-31 1994-09-08 Tuncata Arzu F. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
5235 5235 2010-01-31 2007-07-27 Fears Gary Avatar Enterprises, Inc. 5821 2007-07-27 Avatar Enterprises, Inc. 10349 Watson Road Suite 100 St. Louis MO 63127
5486 5486 1973-02-01 1972-11-13 Filice Michael Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6372 6372 2009-02-10 2007-04-16 Edwards Samantha A. Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6658 6658 1963-02-15 1962-09-07 Eastright Robert Earl Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6677 6677 1973-02-15 1971-03-29 Vecchio Pasquale G. Del Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6679 6679 1973-02-15 1966-12-08 Sabatino Daniel Casper Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
6754 6754 2018-02-15 2017-06-08 Hancock Katy Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6985 6985 2000-02-18 1996-09-04 Jennings Malin Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7065 7065 1998-02-20 1986-02-20 Pearlman Vicki E. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7552 7552 1998-02-27 1988-01-19 Sonnenfeldt Marjorie Hecht Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7563 7563 2009-02-27 2007-04-16 Viorst Marla Rigel Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7771 7771 1995-02-28 1993-03-05 Sommerfield Frank E. , Jr. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8086 8086 2018-02-28 2017-05-16 Moroney Michael Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8103 8103 2018-02-28 2017-11-04 Perrien Ainsley Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8565 8565 2000-03-01 1998-03-01 Hennessey Timothy J. Oliver A. Dulle Jr. & Company 5246 1998-03-01 Oliver A. Dulle Jr. & Company 7711 Bonhomme Avenue Suite 310 Clayton MO 63105
8629 8629 2010-03-01 2009-10-29 Dulle Jr. Oliver A. Oliver A. Dulle Jr. & Company, Inc. 5959 2009-10-29 Oliver A. Dulle Jr. & Company, Inc. 8000 Maryland Avenue Suite 1320 St. Louis MO 63105
8720 8720 2018-03-02 2017-09-19 Mok Martina Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8857 8857 1994-03-04 1992-03-05 Clarkson Pamela A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8858 8858 1994-03-04 1993-03-05 Tucker Brett Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8859 8859 1994-03-04 1992-03-18 Ampolsk Alan G. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8869 8869 2017-03-04 2013-06-14 Yang Jennifer Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
8901 8901 1993-03-05 1991-03-07 Levy Jill Anne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8903 8903 1993-03-05 1989-09-05 Bloch Jayne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8904 8904 1993-03-05 1989-09-05 McCabe Ian Richard Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8905 8905 1993-03-05 1989-09-05 Smith Alan Wayne Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8906 8906 1993-03-05 1989-09-05 Turner Caren Zeldie Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8907 8907 1993-03-05 1991-09-05 de Tejada Marivi Lerdo Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8908 8908 1993-03-05 1988-10-12 Christy Valerie E. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8963 8963 1992-03-06 1991-03-07 Hamblin Koleen Carole Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8968 8968 1995-03-06 1991-03-07 Hancock Mary Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8971 8971 1995-03-06 1990-05-18 Solymossy Diana Sun Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9141 9141 1997-03-07 1993-09-07 Carpenter Cynthia L. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9304 9304 2021-03-10 2021-03-10 Schmidt Michael T Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9439 9439 1998-03-12 1990-12-10 Woods Andrew A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9515 9515 1973-03-14 1963-03-05 Brugnatelli Bruno Ercole Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9516 9516 1973-03-14 1963-03-05 Buffington Louis Dell , III Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9517 9517 1973-03-14 1961-03-08 Pierce Alvin Frederick Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9518 9518 1973-03-14 1962-03-09 Cornwell William Earl Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9519 9519 1973-03-14 1962-03-09 Ewell Charles Lee Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9520 9520 1973-03-14 1962-03-09 Rice Francis Xavier Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9523 9523 1973-03-14 1965-11-05 Davidson John M. Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9524 9524 1973-03-14 1968-11-25 Dalton Peter J. Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102
9547 9547 2001-03-14 2000-03-10 Martin Kim S. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9550 9550 2003-03-14 2003-03-07 Franco Nathalia Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9564 9564 2018-03-14 2018-03-14 Adolph Michael Charles Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9565 9565 2018-03-14 2018-03-14 Choi Michelle Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9566 9566 2018-03-14 2018-03-14 Demashkieh Diala Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9567 9567 2018-03-14 2018-03-14 Flaster Samuel Grant Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9568 9568 2018-03-14 2018-03-14 Francomano Sarah Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9569 9569 2018-03-14 2018-03-14 Isaf John K. Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9570 9570 2018-03-14 2018-03-15 Hollyer Luke Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9571 9571 2018-03-14 2018-03-15 Prior Melanie Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9572 9572 2018-03-14 2018-03-15 Thom Amy Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9693 9693 2010-03-15 2009-03-16 Licha Rissig Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9721 9721 2021-03-15 2021-01-21 Rand Amy Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9771 9771 2000-03-16 1989-09-05 Colon William A. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9869 9869 2000-03-17 1997-09-04 Doble Michael F. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9870 9870 2000-03-17 1999-09-07 Klein Mara S. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9964 9964 1998-03-18 1993-09-07 Beightol Michael H. Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10230 10230 2002-03-22 2000-09-01 Blomquist Eric Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10433 10433 1969-03-25 1960-08-12 Humphrey Champ C. Gardner Advertising Company, Inc. 1385 1960-08-12 Gardner Advertising Company, Inc. 10 Broadway   St. Louis MO 63102

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_Date] TEXT,
   [Registrant_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 304.381ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history