FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1,327 rows where City = "Chicago"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number
Registrant_Name
- Daniel J. Edelman, Inc. 459
- JETRO, Chicago 192
- Zeno Group, Inc. 55
- Korea National Tourism Organization, Chicago 35
- Welsh Development Agency 31
- Aaron D. Cushman & Associates, Inc. 30
- Far East Trade Service, Inc., Chicago 27
- Malaysian Industrial Development Authority 27
- Korea Trade Center, Chicago 25
- Kivvit, LLC 24
- 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
- Grant Advertising, Inc. 8
- Mexico Tourism Board 8
- NRW.INVEST (NORTH AMERICA) LLC 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
- IL 1,327
City
- Chicago · 1,327 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15 | 15 | Reiss | Kokja Alexander | 6645 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 | ||
110 | 110 | 2017-01-17 | Jalaludin | Faizal | 2331 2331 | 1972-04-17 | Malaysian Industrial Development Authority | 875 North Michigan Avenue | Suite 1515 | Chicago | IL | 60611 | |
172 | 172 | 2020-01-27 | Carbonara | Kristina | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
174 | 174 | 2020-01-27 | Love | Michael | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
175 | 175 | 2020-01-27 | Singh | Nirmala | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
177 | 177 | 2020-01-27 | Yohannan | Calvin | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
181 | 181 | 2020-01-28 | Garry | Katie | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
200 | 200 | 2020-01-29 | Kahn | Evan | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
333 | 333 | 2020-02-14 | Lamb | Megan Josephine | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
365 | 365 | 2020-02-20 | Streit | Matthew Alan | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
366 | 366 | 2020-02-20 | Thompson | Jeremy Solomon | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
406 | 406 | 2020-02-26 | Mansfield | Adalie Joy | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
412 | 412 | 2016-02-28 | David | Alex | 6339 6339 | 2016-02-28 | Nineveh Plain Defense Fund | 6241 N. Talman Avenue | Chicago | IL | 60659 | ||
413 | 413 | 2016-02-28 | Patto | Susan | 6339 6339 | 2016-02-28 | Nineveh Plain Defense Fund | 6241 N. Talman Avenue | Chicago | IL | 60659 | ||
414 | 414 | 2016-02-28 | Yaco | Yacob G. | 6339 6339 | 2016-02-28 | Nineveh Plain Defense Fund | 6241 N. Talman Avenue | Chicago | IL | 60659 | ||
415 | 415 | 2016-02-28 | Youash | Michael | 6339 6339 | 2016-02-28 | Nineveh Plain Defense Fund | 6241 N. Talman Avenue | Chicago | IL | 60659 | ||
470 | 470 | 2020-03-11 | Coughlan | William R. | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
471 | 471 | 2020-03-11 | De Jesus | Jessica Joy Sayson | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
474 | 474 | 2020-03-11 | McBrayer | Kaitlyn Jane | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
476 | 476 | 2020-03-11 | Ryan | Conor Patrick | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
477 | 477 | 2020-03-11 | Sullivan Jr | Jere Jerome | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
478 | 478 | 2020-03-11 | Zenatti | Ana Paula De Assis | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
479 | 479 | 2020-03-11 | de Vlaming | Lauren | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
512 | 512 | 2019-03-18 | Blocksom | Shara Lindsey | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
514 | 514 | 2019-03-18 | Murray | Maureen | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
530 | 530 | 2020-03-20 | Pervazova | Iana Andrianova | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
532 | 532 | 2020-03-20 | Stokes | Benjamin Noel | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
539 | 539 | 2020-03-23 | Faunce | Alexis Falon | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
556 | 556 | 2013-03-26 | Stevenson | Naoko | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
565 | 565 | 2018-03-27 | Hashimoto | Tsubasa | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
589 | 589 | 2020-03-30 | Conci | Maria Del Pilar | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
590 | 590 | 2020-03-30 | Nishizawa | Tomofumi | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
602 | 602 | 2020-04-02 | Edelman | Amanda | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
612 | 612 | 2000-04-05 | Inforzato | Ralph | 1850 1850 | 1965-02-02 | JETRO, Chicago | 1 East Wacker Drive | Suite 3350 | Chicago | IL | 60601 | |
664 | 664 | 2020-04-16 | Naik | Ojas | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
683 | 683 | 2019-04-22 | Insinga | Mary | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
684 | 684 | 2019-04-22 | Rie | Katherine | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
685 | 685 | 2019-04-22 | Thiele | Tracey | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
686 | 686 | 2019-04-22 | Tovar | Jesus Salvador | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
736 | 736 | 2020-04-29 | Corlies | Charissa | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
891 | 891 | 2019-05-28 | Cook | Meghan | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
893 | 893 | 2019-05-28 | Manzo | John | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
894 | 894 | 2019-05-28 | Morley | Jason | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
895 | 895 | 2019-05-28 | Nook | Emma | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
917 | 917 | 2019-05-29 | McKinney | Christopher | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
918 | 918 | 2019-05-29 | Patza | Ellesyn | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
941 | 941 | 2019-05-31 | Caffrey | Samantha | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
964 | 964 | 2015-06-08 | Sedlmayer | Peter D. | 6193 6193 | 2013-11-04 | Austrian Trade Commission, Chicago | 500 N. Michigan Avenue | Suite 1950 | Chicago | IL | 60611 | |
977 | 977 | 2020-06-09 | Vakili | Aryan Zandieh | 6645 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 | |
987 | 987 | 2019-06-11 | Camp | Lucas | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
989 | 989 | 2019-06-11 | Gordon | Claire | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
991 | 991 | 2019-06-11 | Manzoor | Mustafa | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
994 | 994 | 2019-06-11 | Wang | Danruo | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
997 | 997 | 2019-06-12 | Condon | Katie | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
1033 | 1033 | 2020-06-23 | Restieri | Jenna | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
1226 | 1226 | 2020-07-29 | Gustafson | Christopher | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
1239 | 1239 | 2020-07-30 | Busch | Patricia | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1240 | 1240 | 2020-07-30 | Chacon | Kelly Penton | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1241 | 1241 | 2020-07-30 | Farrell | Maura | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1242 | 1242 | 2020-07-30 | Frerichs | Colleen | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1243 | 1243 | 2020-07-30 | Hainline | Ian Adrian | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1244 | 1244 | 2020-07-30 | Holland | Kent | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1245 | 1245 | 2020-07-30 | Kisling | Alexander | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1246 | 1246 | 2020-07-30 | Klingeberger | Anne | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1247 | 1247 | 2020-07-30 | Lydgate | Annie | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1248 | 1248 | 2020-07-30 | Meara | Tom | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1249 | 1249 | 2020-07-30 | Paguaga | Fernanda | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1250 | 1250 | 2020-07-30 | Reese | Joel | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1251 | 1251 | 2020-07-30 | Roseneck | Rachel | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1252 | 1252 | 2020-07-30 | Scherrman | Molly | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1253 | 1253 | 2020-07-30 | Schmaler | Tracy | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1254 | 1254 | 2020-07-30 | Sedler | Eric | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1255 | 1255 | 2020-07-30 | Shutler | Mackenzie | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1256 | 1256 | 2020-07-30 | Terenzio | Rosemarie | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1257 | 1257 | 2020-07-30 | Turco | Catherine | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1262 | 1262 | 2020-07-31 | DeAngelis | Bryan | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1282 | 1282 | 2020-08-06 | Johnston | Michael | 6839 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 | |
1316 | 1316 | 2017-08-13 | Siddiqui | Adnan M. | 6454 6454 | 2017-08-13 | MQM International, Inc. (Muttahida Quami Movement) | 433 W Harrison Street | Box #6720 | Chicago | IL | 60699 | |
1344 | 1344 | 2020-08-19 | Cazalet | Eloise Margaret Rose | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1345 | 1345 | 2020-08-19 | Dingwell | Makena | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1350 | 1350 | 2020-08-20 | Riffat | Mustafa | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1355 | 1355 | 2020-08-21 | Roesler | Carolina Leighton | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1356 | 1356 | 2020-08-21 | Tendler | Chad | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1380 | 1380 | 2019-08-26 | Ontiveros-Oberg | Adam | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1381 | 1381 | 2019-08-26 | Salerno | Laura | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
1382 | 1382 | 2020-08-26 | Garvey | Alex | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1383 | 1383 | 2020-08-26 | Hedley | Devon Thomas | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1384 | 1384 | 2020-08-26 | Reid | Ross John | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1391 | 1391 | 2020-08-27 | Iorio | Bennett | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1392 | 1392 | 2020-08-27 | Lock | Benjamin | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1397 | 1397 | 2020-08-28 | Mughal | Hannah | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1458 | 1458 | 2019-09-10 | Ortiz | Mileska | 6652 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | ||
1468 | 1468 | 2017-09-12 | Jamali | Wakel A | 6454 6454 | 2017-08-13 | MQM International, Inc. (Muttahida Quami Movement) | 433 W Harrison Street | Box #6720 | Chicago | IL | 60699 | |
1480 | 1480 | 2020-09-14 | Abi Saleh | Doreen Antoine | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1481 | 1481 | 2020-09-14 | De Pauw | Kenneth Jean Jules | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1482 | 1482 | 2020-09-14 | Hand | Seth Michael | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1483 | 1483 | 2020-09-14 | Melissa | Leung On Ki | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1485 | 1485 | 2020-09-14 | Qirem | Omar | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1491 | 1491 | 2020-09-16 | Simmons | Alex | 3634 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 200 East Randolph Drive | Suite 900 | Chicago | IL | 60601 | |
1528 | 1528 | 2019-09-23 | Buehler | Kai | 6645 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 |
Advanced export
JSON shape: default, array, newline-delimited
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) );