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

422 rows where State = "MO"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 18

  • Fleishman-Hillard, Inc. 191
  • Fleishman-Hillard, Inc. 120
  • 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
  • Bryan Cave Leighton Paisner LLP 4
  • 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 17

  • Fleishman-Hillard, Inc. 311
  • 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
  • Bryan Cave Leighton Paisner LLP 4
  • 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 381
  • Kansas City 32
  • Springfield 6
  • Clayton 3

State 1

  • MO · 422 ✖
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
269 269   2022-01-31 Johnson Byron E Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
271 271   2022-01-31 Pierce Margaret Hannaway Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
272 272   2022-01-31 Williams Timothy Robert Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
300 300   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
1277 1277   2022-06-22 Boyd Stephanie Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1606 1606   2022-08-12 Carnahan Russ Bryan Cave Leighton Paisner LLP 7157 2022-08-12 Bryan Cave Leighton Paisner LLP 211 North Broadway Suite 3600 St. Louis MO 63102
1607 1607   2022-08-12 Martinez-Fraga Pedro Bryan Cave Leighton Paisner LLP 7157 2022-08-12 Bryan Cave Leighton Paisner LLP 211 North Broadway Suite 3600 St. Louis MO 63102
1608 1608   2022-08-12 Reetz C. Ryan Bryan Cave Leighton Paisner LLP 7157 2022-08-12 Bryan Cave Leighton Paisner LLP 211 North Broadway Suite 3600 St. Louis MO 63102
1609 1609   2022-08-12 Russell David Bryan Cave Leighton Paisner LLP 7157 2022-08-12 Bryan Cave Leighton Paisner LLP 211 North Broadway Suite 3600 St. Louis MO 63102
1759 1759   2021-09-10 Dillman Jessica Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1760 1760   2021-09-10 Hart Colin M Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1761 1761   2021-09-10 Jada Amanda Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1762 1762   2021-09-10 Rand Amy Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1763 1763   2021-09-10 Schmidt Michael T Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1950 1950   2020-10-13 Sadlier Lizanne Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2459 2459   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
2547 2547 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
3000 3000 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
3117 3117 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
3368 3368 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
3506 3506 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
3709 3709 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
3752 3752 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
3902 3902 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
3903 3903 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
3905 3905 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
3906 3906 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
3907 3907 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
3962 3962 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
3988 3988 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
4102 4102 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
4490 4490 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
4840 4840 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
4936 4936 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
5025 5025 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
5166 5166 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
5176 5176 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
5196 5196 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
5433 5433 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
5694 5694 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
6594 6594 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
6894 6894 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
6913 6913 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
6915 6915 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
6990 6990 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
7222 7222 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
7304 7304 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
7797 7797 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
7808 7808 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
8016 8016 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
8330 8330 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
8347 8347 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
8820 8820 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
8884 8884 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
8986 8986 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
9124 9124 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
9125 9125 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
9126 9126 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
9136 9136 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
9169 9169 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
9171 9171 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
9172 9172 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
9173 9173 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
9174 9174 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
9175 9175 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
9176 9176 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
9231 9231 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
9236 9236 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
9239 9239 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
9410 9410 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
9589 9589 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
9592 9592 2023-03-10 2022-11-16 Scanlon Sean Fleishman-Hillard, Inc. 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
9732 9732 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
9808 9808 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
9809 9809 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
9810 9810 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
9811 9811 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
9812 9812 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
9813 9813 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
9816 9816 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
9817 9817 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
9840 9840 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
9843 9843 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
9857 9857 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
9858 9858 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
9859 9859 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
9860 9860 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
9861 9861 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
9862 9862 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
9863 9863 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
9864 9864 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
9865 9865 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
9988 9988 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
10016 10016 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
10069 10069 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
10167 10167 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
10168 10168 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
10263 10263 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
10529 10529 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
10735 10735 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 394.802ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows