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

1,659 rows where State = "IL"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number >30

  • Daniel J. Edelman, Inc. 573
  • JETRO, Chicago 196
  • Invest Northern Ireland 95
  • Zeno Group, Inc. 74
  • Korea National Tourism Organization, Chicago 35
  • Welsh Development Agency 31
  • Aaron D. Cushman & Associates, Inc. 30
  • Kivvit, LLC 30
  • Malaysian Industrial Development Authority 28
  • Far East Trade Service, Inc., Chicago 27
  • Korea Trade Center, Chicago 25
  • Central Parcel Service, Inc. 23
  • Japan National Tourist Organization, Chicago 22
  • Collegial Society of Hungarian Veterans in the U.S.A. 21
  • Austrian Trade Commissioner in the U.S., Chicago 20
  • Jamaica Tourist Board, Chicago 20
  • Caples Company 19
  • Italian Government Travel Office, Chicago 19
  • Sorini, Samet & Associates, LLC 18
  • Julius Klein Public Relations 17
  • North of England 17
  • Golin/Harris Communications, Inc. 17
  • Mexican Chamber of Commerce, Inc., Chicago 16
  • One NorthEast 16
  • Polish National Tourist Office, New York 13
  • Jasculca/Terman & Associates, Inc. 12
  • NRW.INVEST (NORTH AMERICA) LLC 10
  • Grant Advertising, Inc. 8
  • Mexico Tourism Board 8
  • Nineveh Plain Defense Fund 8
  • …

Registrant_Name >30

  • Daniel J. Edelman, Inc. 573
  • JETRO, Chicago 196
  • Invest Northern Ireland 95
  • Zeno Group, Inc. 74
  • Korea National Tourism Organization, Chicago 35
  • Welsh Development Agency 31
  • Aaron D. Cushman & Associates, Inc. 30
  • Kivvit, LLC 30
  • Malaysian Industrial Development Authority 28
  • Far East Trade Service, Inc., Chicago 27
  • Korea Trade Center, Chicago 25
  • Central Parcel Service, Inc. 23
  • Japan National Tourist Organization, Chicago 22
  • Collegial Society of Hungarian Veterans in the U.S.A. 21
  • Austrian Trade Commissioner in the U.S., Chicago 20
  • Jamaica Tourist Board, Chicago 20
  • Caples Company 19
  • Italian Government Travel Office, Chicago 19
  • Sorini, Samet & Associates, LLC 18
  • Golin/Harris Communications, Inc. 17
  • Julius Klein Public Relations 17
  • North of England 17
  • Mexican Chamber of Commerce, Inc., Chicago 16
  • One NorthEast 16
  • Polish National Tourist Office, New York 13
  • Jasculca/Terman & Associates, Inc. 12
  • NRW.INVEST (NORTH AMERICA) LLC 10
  • Grant Advertising, Inc. 8
  • Mexico Tourism Board 8
  • Nineveh Plain Defense Fund 8
  • …

City 17

  • Chicago 1,478
  • Bannockburn 95
  • Hinsdale 18
  • Rolling Meadows 18
  • Chicago 13
  • North Barrington 6
  • Oak Lawn 6
  • Berwyn 5
  • Evanston 4
  • River Forest 4
  • DesPlaines 3
  • Glendale Heights 3
  • Chicago 2
  • Buffalo Grove 1
  • Lake Bluff 1
  • Northbrook 1
  • Waukegan 1

State 1

  • IL · 1,659 ✖
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
139 139   2023-01-17 Goldman Kevin Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
140 140   2023-01-17 London Joy Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
141 141   2023-01-17 Perlmutter Rachel Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
142 142   2023-01-17 Pittman Mary Gannon Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
143 143   2023-01-17 Prade Nasir Steven Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
144 144   2023-01-17 Ringler Todd D. Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
145 145   2023-01-17 Teitelman Sarah Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
196 196   2023-01-25 Chitwood Matthew McKenzie Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
197 197   2023-01-25 Garsko Summer Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
273 273   2023-01-31 O'Keefe Eleanor Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
274 274   2023-01-31 Albrow Sophie Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
276 276   2023-01-31 Cusack Patricia Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
277 277   2023-01-31 Garvey Alex Edward Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
278 278   2023-01-31 Jones Timothy Carlton Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
279 279   2023-01-31 Killick Charles Robinson Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
280 280   2023-01-31 Lock Benjamin Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
281 281   2023-01-31 Lowe Matthew Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
333 333   2022-02-07 Workman Daniel Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
335 335   2023-02-07 Petraglia Gina Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
353 353   2023-02-10 Awesu Awanat Toyin Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
354 354   2023-02-10 Streit Matthew Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
355 355   2023-02-10 Thompson Jeremy Solomon Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
461 461   2021-02-26 Millard Rachel Louise Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
480 480   2023-03-02 Cazalet Eloise Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
481 481   2023-03-02 Lehr Deborah Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
484 484   2023-03-02 Resnick-Ault Jessica Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
485 485   2023-03-02 Rowland Daniel Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
486 486   2023-03-02 Walters Lindsay E. Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
487 487   2023-03-02 Watts Joseph Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
532 532   2023-03-08 Ishaq Malalla Fairooz Noora Mohammed Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
534 534   2023-03-08 Petroccione Emily Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
535 535   2023-03-08 Roscoe Andrew Leslie Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
549 549   2022-03-10 Garcia Emily Anne Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
560 560   2020-03-11 Sullivan Jr. Jere J. Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
563 563   2015-03-12 Reid Mark Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
574 574   2022-03-15 Maruschak Gina Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
581 581   2021-03-16 Bledsoe Paul W. Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
651 651   2022-03-25 Barrett Scott Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
654 654   2013-03-26 Stevenson Naoko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
656 656   2018-03-26 Samet Andrew Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
661 661   2018-03-27 Hashimoto Tsubasa JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
694 694   2020-03-30 Nishizawa Tomofumi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
758 758   2023-04-10 Dunn Paul Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
760 760   2023-04-10 Ostrower Matthew Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
761 761   2023-04-10 Sabrina Lam Ka Wai Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
762 762   2023-04-10 Tailor Sophia Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
763 763   2023-04-10 Wei Ching Adrianna Lau Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
764 764   2023-04-10 Wong Yue Kei Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
769 769   2023-04-11 Si Ho Chan Simon Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
770 770   2023-04-12 Cheung Wing Sze Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
781 781   2006-04-14 Shuman Niahm Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
846 846   2008-04-21 Samet Andrew Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
848 848   2022-04-21 Haddad Paisley Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
856 856   2019-04-22 Rie Katherine Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
857 857   2019-04-22 Thiele Tracey Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
858 858   2021-04-22 Sorini Ronald Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
875 875   2023-04-25 Reid Zoe Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
891 891   2022-04-27 Amagai Mattie Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
912 912   2020-04-29 Corlies Charissa Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
979 979   2023-05-06 Palmer Jodie Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
985 985   2023-05-08 Mitchell John Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
986 986   2023-05-08 Morimoto Andrew Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1026 1026   2023-05-15 Rubel Steven Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1036 1036   2021-05-17 Antolini Rocco Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1068 1068   2023-05-20 Tyson Max Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1069 1069   2023-05-20 Vazquez Edgar Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1080 1080   2023-05-22 Johnson Tomos Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1081 1081   2023-05-22 Laws George Benjamin Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1095 1095   2023-05-24 DuToit Lili Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1096 1096   2023-05-24 Forrest Sophie Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1097 1097   2023-05-24 Gibbs Portia Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1098 1098   2023-05-24 Konowe Adam Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1114 1114   2023-05-26 Larese-Pollonin Sabrina Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1128 1128   2019-05-28 Morley Jason Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1144 1144   2019-05-29 Vando Francesca Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1155 1155   2023-05-30 Dempsey Rhett Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1156 1156   2023-05-30 Herron Rory Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1202 1202   2012-06-08 Costello Megan Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
1210 1210   2020-06-09 Vakili Aryan Zandieh NRW.INVEST (NORTH AMERICA) LLC 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
1213 1213   2022-06-09 Ames Joseph P. Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1214 1214   2022-06-09 Esguerra Lorenz Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1215 1215   2022-06-09 Moses Jarrod Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1216 1216   2022-06-09 Silverman Audra Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1218 1218   2023-06-09 Dingwell Makena Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1232 1232   2012-06-14 Conlon Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
1234 1234   2022-06-14 Marino Christopher Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1236 1236   2022-06-14 Vera Maria Pereyra Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1238 1238   2023-06-14 Steiger Nicole Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1242 1242   2022-06-15 Semaski Victoria Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1263 1263   2023-06-20 Murray Debora Comenalli Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1264 1264   2023-06-20 Oh Clare Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1283 1283   2020-06-23 Restieri Jenna Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1367 1367   2022-07-07 Hedquist Christopher Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1369 1369   2022-07-07 Nandigama Saveri Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1436 1436   2023-07-19 Defrancesco Thomas Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1445 1445   2023-07-20 Alvillar Raul Resolute Public Affairs  7297 2023-07-20 Resolute Public Affairs 27 N Wacker Drive, Box 403   Chicago IL 60606-2800
1446 1446   2023-07-20 Gleason Brendan Resolute Public Affairs  7297 2023-07-20 Resolute Public Affairs 27 N Wacker Drive, Box 403   Chicago IL 60606-2800
1449 1449   2023-07-20 Simon Neil Resolute Public Affairs  7297 2023-07-20 Resolute Public Affairs 27 N Wacker Drive, Box 403   Chicago IL 60606-2800
1450 1450   2023-07-20 Smolensky David Resolute Public Affairs  7297 2023-07-20 Resolute Public Affairs 27 N Wacker Drive, Box 403   Chicago IL 60606-2800
1452 1452   2023-07-20 Wilczewski Adam Resolute Public Affairs  7297 2023-07-20 Resolute Public Affairs 27 N Wacker Drive, Box 403   Chicago IL 60606-2800

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