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,476 rows where City = "Chicago"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number >30

  • Daniel J. Edelman, Inc. 571
  • JETRO, Chicago 196
  • 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
  • Julius Klein Public Relations 17
  • North of England 17
  • Golin/Harris Communications, Inc. 17
  • Mexican Chamber of Commerce, Inc., Chicago 16
  • Jasculca/Terman & Associates, Inc. 12
  • NRW.INVEST (NORTH AMERICA) LLC 10
  • Grant Advertising, Inc. 8
  • Mexico Tourism Board 8
  • Nineveh Plain Defense Fund 8
  • Beveridge, Kraus, Robbins & Manning, Inc. 7
  • Government of India Tourist Office, Chicago 6
  • Romanian Foreign Trade Promotion Office, Chicago 6
  • Austrian National Tourist Office, Midwest Office 6
  • …

Registrant_Name >30

  • Daniel J. Edelman, Inc. 571
  • JETRO, Chicago 196
  • 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
  • Golin/Harris Communications, Inc. 17
  • Julius Klein Public Relations 17
  • North of England 17
  • Mexican Chamber of Commerce, Inc., Chicago 16
  • Jasculca/Terman & Associates, Inc. 12
  • NRW.INVEST (NORTH AMERICA) LLC 10
  • Grant Advertising, Inc. 8
  • Mexico Tourism Board 8
  • Nineveh Plain Defense Fund 8
  • Beveridge, Kraus, Robbins & Manning, Inc. 7
  • Austrian National Tourist Office, Midwest Office 6
  • Government of India Tourist Office, Chicago 6
  • Romanian Foreign Trade Promotion Office, Chicago 6
  • …

State 1

  • IL 1,476

City 1

  • Chicago · 1,476 ✖
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
131 131   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
132 132   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
133 133   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
134 134   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
135 135   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
136 136   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
137 137   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
188 188   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
189 189   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
265 265   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
266 266   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
268 268   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
269 269   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
270 270   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
271 271   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
272 272   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
273 273   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
325 325   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
327 327   2023-02-07 Petraglia Gina Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
345 345   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
346 346   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
347 347   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
453 453   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
472 472   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
473 473   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
476 476   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
477 477   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
478 478   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
479 479   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
524 524   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
526 526   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
527 527   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
541 541   2022-03-10 Garcia Emily Anne Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
552 552   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
566 566   2022-03-15 Maruschak Gina Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
573 573   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
643 643   2022-03-25 Barrett Scott Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
646 646   2013-03-26 Stevenson Naoko JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
653 653   2018-03-27 Hashimoto Tsubasa JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
689 689   2020-03-30 Nishizawa Tomofumi JETRO, Chicago 1850 1965-02-02 JETRO, Chicago 1 East Wacker Drive Suite 3350 Chicago IL 60601
753 753   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
755 755   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
756 756   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
757 757   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
758 758   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
759 759   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
764 764   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
765 765   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
845 845   2022-04-21 Haddad Paisley Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
853 853   2019-04-22 Rie Katherine Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
854 854   2019-04-22 Thiele Tracey Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
872 872   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
911 911   2020-04-29 Corlies Charissa Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
978 978   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
984 984   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
985 985   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
1025 1025   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
1035 1035   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
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
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
1368 1368   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
1370 1370   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
1438 1438   2023-07-19 Defrancesco Thomas Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1447 1447   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
1448 1448   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
1451 1451   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
1452 1452   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
1454 1454   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
1484 1484   2023-07-25 Samsudin Muhammad Haikal Malaysian Industrial Development Authority 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1810 Chicago IL 60611
1524 1524   2020-07-29 Gustafson Christopher Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1538 1538   2020-07-30 Scherrman Molly Kivvit, LLC 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1555 1555   2021-08-05 Phillips Lauren Delaney Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1617 1617   2021-08-17 O'Shea Jack Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1651 1651   2022-08-23 Blumenschein Bryer Zeno Group, Inc. 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
1724 1724   2022-09-06 Meara Thomas Kivvit, LLC 6839 2020-07-30 Kivvit, LLC 222 W. Merchandise Mart Plaza Suite 2400 Chicago IL 60654
1769 1769   2022-09-14 Davidson-Musser Stella Bijou Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1770 1770   2022-09-14 Edelman Richard Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1773 1773   2022-09-14 Harris Lauren Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606

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