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

151 rows where Registrant_Name = "Cassidy & Associates, Inc." and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 5

  • Cassidy & Associates, Inc. 110
  • Cassidy & Associates, Inc. 32
  • Cassidy & Associates, Inc. 5
  • Cassidy & Associates, Inc. 3
  • Cassidy & Associates, Inc. 1

State 1

  • DC · 151 ✖

Registrant_Name 1

  • Cassidy & Associates, Inc. · 151 ✖

City 1

  • Washington 151
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
3492 3492 1997-01-09 1994-09-29 Macari Robert A. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
5234 5234 2001-01-31 1994-06-03 Tate Dan C. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
8469 8469 1996-02-29 1994-09-07 Minjack Gregory Anson Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
8803 8803 1996-03-01 1995-02-02 Bentson Kristina Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
9573 9573 1995-03-10 1994-06-16 Herring Laura Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
10765 10765 2007-03-25 2004-09-10 Hochstein Amos Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
10987 10987 2008-03-28 2007-10-25 Quinn Jack Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
12023 12023 2007-03-31 2004-10-21 Rinaldo Diane Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
13239 13239 1994-04-12 1995-12-07 Wade Susan R. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
13711 13711 2007-04-18 2007-04-30 Hale Russell D. Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
13720 13720 2018-04-18 2017-01-28 Anderson Kai Cassidy & Associates, Inc. 6272 2015-01-16 Cassidy & Associates, Inc. 733 Tenth Street, NW Suite 400 Washington DC 20001
13721 13721 2018-04-18 2017-01-28 Paul Terry Cassidy & Associates, Inc. 6272 2015-01-16 Cassidy & Associates, Inc. 733 Tenth Street, NW Suite 400 Washington DC 20001
13722 13722 2018-04-18 2017-01-28 Thomasson Russell Cassidy & Associates, Inc. 6272 2015-01-16 Cassidy & Associates, Inc. 733 Tenth Street, NW Suite 400 Washington DC 20001
13723 13723 2018-04-18 2017-08-30 Barba Jesse Cassidy & Associates, Inc. 6272 2015-01-16 Cassidy & Associates, Inc. 733 Tenth Street, NW Suite 400 Washington DC 20001
15451 15451 1996-05-01 1994-12-28 Dickson Timothy E. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
17376 17376 2015-05-29 2015-01-16 Clack Mark C. Cassidy & Associates, Inc. 6272 2015-01-16 Cassidy & Associates, Inc. 733 Tenth Street, NW Suite 400 Washington DC 20001
17480 17480 1996-05-30 1995-12-28 Ifshin David M. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
17507 17507 2008-05-30 2007-10-25 Gill Gregory M. Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
17760 17760 1992-05-31 1989-05-25 Godfrey Carl F. , Jr. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
17761 17761 1992-05-31 1989-05-25 Versage Vincent M. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
17856 17856 1996-05-31 1996-02-08 Beach Dawn Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
17873 17873 1996-05-31 1994-09-07 Smith Patricia M. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
17957 17957 2002-05-31 1992-02-04 Sutton Barbara Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
21197 21197 1994-06-30 1992-02-04 De Grandchamp Diane Carol Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
21241 21241 1996-06-30 1996-02-08 Hazelrigg Margaret J. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
21250 21250 1996-06-30 1994-09-07 Sturgill Kerry Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22227 22227 1993-07-01 1991-04-30 Bobbitt Douglass E. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22228 22228 1993-07-01 1991-04-30 Lion Victoria Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22229 22229 1993-07-01 1991-04-30 Perry Priscilla Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22230 22230 1993-07-01 1989-05-25 Fabiani James P. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22231 22231 1993-07-01 1992-06-03 Mason Arthur Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22232 22232 1993-07-01 1992-06-03 McGarity Neal Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22234 22234 1993-07-01 1991-08-09 Dawson Robert K. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22235 22235 1993-07-01 1991-08-09 Godfrey Carl Franklin , Jr. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22236 22236 1993-07-01 1991-08-09 McNamara Daniel Justin Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22237 22237 1993-07-01 1991-09-11 Coyle James R. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22238 22238 1993-07-01 1991-09-11 Grossman Tammy R. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22239 22239 1993-07-01 1991-09-11 Kevin Yuan-Zhi Zhang Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22284 22284 2000-07-01 1996-03-01 Rowan James P. , Sr. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22285 22285 2000-07-01 1999-03-02 Ford, Jr. Carl W. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
22288 22288 2000-07-01 1994-07-19 Warburg Gerald Felix Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
24878 24878 1996-07-31 1994-06-23 Scheer Julian Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
24949 24949 1999-07-31 1994-12-28 Tom Maeley L. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
25161 25161 2009-07-31 2007-10-04 Raphel Robin Lynn Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
26560 26560 2001-08-13 1993-12-20 Bobbitt Douglas E. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
27438 27438 2006-08-25 2005-04-08 Kolton Chad M. Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
27714 27714 2006-08-29 2004-10-21 Steel Aimee N. Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
28289 28289 1996-08-31 1994-07-07 Ayres Larry F. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
28292 28292 1996-08-31 1994-09-29 Cowan Mark Douglas Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
29442 29442 1995-09-08 1994-07-07 Wood Kennan R. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
29881 29881 1997-09-15 1993-11-18 Cowan Glenn Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
31557 31557 2014-09-30 2014-04-15 Clack Mark Cassidy & Associates, Inc. 6214 2014-04-15 Cassidy & Associates, Inc. 733 10th Street, NW Suite 400 Washington DC 20001
32521 32521 1995-10-09 1993-08-02 Kelly Francis J. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
32522 32522 2002-10-09 2001-06-29 Whitaker Stephen B. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
32526 32526 2009-10-09 2009-07-24 Amirhooshmand Ali Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
32742 32742 1995-10-13 1994-09-07 Newton Charlotte Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
33497 33497 1992-10-23 1991-04-30 Warburg Gerald Felix Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
33713 33713 1994-10-27 1992-06-03 Thibaut Elizabeth Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
35449 35449 2007-11-08 2007-10-04 Britton Robin Elizabeth Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
35450 35450 2007-11-08 2007-10-04 Meszaros James A. Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
35451 35451 2007-11-08 2007-10-04 Opinsky Howard S. Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
35452 35452 2007-11-08 2007-10-25 Burdick Amanda Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
35453 35453 2007-11-08 2007-10-25 Hanna Moira Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
35454 35454 2007-11-08 2007-10-25 Morgan Lance Ian Cassidy & Associates, Inc. 5643 2004-09-10 Cassidy & Associates, Inc. 700 13th Street, N.W. Suite 400 Washington DC 20005
35881 35881 1996-11-15 1996-03-18 Raines Elvoy Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36787 36787 1995-11-30 1994-07-07 Godfrey Carl Franklin Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36792 36792 1995-11-30 1994-09-21 Bernard Lynda Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36793 36793 1995-11-30 1994-09-21 Ng Bik Fung Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36794 36794 1995-11-30 1994-09-29 Dawson Robert K. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36799 36799 1996-11-30 1995-01-05 Armenian Zanku Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36800 36800 1996-11-30 1995-01-19 Smith Philip A. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36801 36801 1996-11-30 1996-02-08 Cramer Jerome Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36802 36802 1996-11-30 1996-02-08 Gross Meghan E. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36803 36803 1996-11-30 1996-02-08 Tarbell Carey Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36804 36804 1996-11-30 1996-02-08 Udowitz Robert Howard Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36806 36806 1996-11-30 1994-03-01 Mirijanian Peter G. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36807 36807 1996-11-30 1995-03-03 Madigan Peter Thomas Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36808 36808 1996-11-30 1993-03-15 Schwartz Haidee L. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36809 36809 1996-11-30 1996-03-20 Posner Steven C. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36810 36810 1996-11-30 1996-03-26 Miller Andrew Clark Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36811 36811 1996-11-30 1992-03-31 Mahoney Margaret Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36812 36812 1996-11-30 1996-04-15 Gallagher James P. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36815 36815 1996-11-30 1996-05-31 Gillcash Robert S. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36816 36816 1996-11-30 1992-06-03 Johnson Jerry Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36817 36817 1996-11-30 1993-06-16 Powell Joseph L. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36818 36818 1996-11-30 1994-06-16 Howell Annie Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36819 36819 1996-11-30 1994-06-16 Jensen Paul H. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36820 36820 1996-11-30 1994-06-16 King John W. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36821 36821 1996-11-30 1996-06-18 Burns James A. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36822 36822 1996-11-30 1993-08-06 Gilroy Brent Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36823 36823 1996-11-30 1991-08-09 Gelb Michael Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36824 36824 1996-11-30 1991-08-09 Leibach Dale Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36826 36826 1996-11-30 1996-08-16 Berland Noah D. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36827 36827 1996-11-30 1996-08-16 Jenkins Lee D. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36828 36828 1996-11-30 1994-09-07 Hartz Michelle Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36829 36829 1996-11-30 1994-09-07 Ray Jerry M. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36830 36830 1996-11-30 1994-10-04 Kerekes Steve Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36831 36831 1996-11-30 1992-10-16 Tate Sheila Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36834 36834 1996-11-30 1995-11-02 Casey Daniel L. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005
36835 36835 1996-11-30 1995-11-02 Maloni Jason W. Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. 700 - 13th Street, N.W. Suite 400 Washington DC 20005

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