FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
92 rows where Registration_Number = 6549 and State = "KS"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- KS · 92 ✖
Registration_Number 1
- Myriad International Marketing, LLC · 92 ✖
Registrant_Name 1
City 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 4 | Amores | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 5 | 5 | Amores | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 7 | 7 | Chiang | Yu-Jung | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 15 | 15 | Hanover | Kurt | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 16 | 16 | Hanover | Kurt | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 18 | 18 | Jones | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 19 | 19 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 20 | 20 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 21 | 21 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 22 | 22 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 23 | 23 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 24 | 24 | Kao | Yu Wen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 29 | 29 | McAtee | Brett | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 30 | 30 | McAtee | Brett | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 35 | 35 | Newton | Sienna | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 36 | 36 | Newton | Sienna | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 38 | 38 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 39 | 39 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 40 | 40 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 41 | 41 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 42 | 42 | Quinlan | Brandy Galvin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 45 | 45 | Sewton | Sienna | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 50 | 50 | Vega | Rebecca | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | ||
| 920 | 920 | 2018-04-30 | Chan | Carman | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 921 | 921 | 2018-04-30 | Goger | Jennifer | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 922 | 922 | 2018-04-30 | Luo | Yvonne | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 923 | 923 | 2018-04-30 | Matar | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 925 | 925 | 2018-04-30 | Merschen | Al | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 926 | 926 | 2018-04-30 | Nase | Stephen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 927 | 927 | 2018-04-30 | Petrides | Daniela | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 928 | 928 | 2018-04-30 | Pfeiffer | Heike | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 929 | 929 | 2018-04-30 | Sabir | Samina | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 930 | 930 | 2018-04-30 | Troy | Shannon | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1073 | 1073 | 2019-05-22 | Carvajal | Tricia | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1075 | 1075 | 2019-05-22 | Hefflinger | Amanda | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1076 | 1076 | 2019-05-22 | Jones | Stephanie | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1077 | 1077 | 2019-05-22 | LaBriola | Allyson | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1078 | 1078 | 2019-05-22 | Leon | Christopher | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1079 | 1079 | 2019-05-22 | Ostrove | Amanda | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1132 | 1132 | 2021-05-28 | Cuesta | Julie Averay- | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1255 | 1255 | 2020-06-18 | Riley | David | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 1256 | 1256 | 2020-06-18 | Sharp | Dustin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2228 | 2228 | 2019-11-26 | Click | Collin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2230 | 2230 | 2019-11-26 | Felipe | Jessica | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2233 | 2233 | 2019-11-26 | Luckey | Chris | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2234 | 2234 | 2019-11-26 | McCarthy | Taryn | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2235 | 2235 | 2019-11-26 | Oceguera | Fernanda Melgoza | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2268 | 2268 | 2021-11-29 | Albert | Jamie | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2274 | 2274 | 2021-11-29 | Lapke | Joise | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2276 | 2276 | 2021-11-29 | Melgoza | Fernanda | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2397 | 2397 | 2022-12-13 | Stefanak | Amanda Hefflinger | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2423 | 2423 | 2018-12-18 | Belcher | Carolin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2424 | 2424 | 2018-12-18 | Contreras | Susana Iakovliev | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2425 | 2425 | 2018-12-18 | DeMirci | Walter | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2426 | 2426 | 2018-12-18 | Garcia-Maynard | Ashley | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2427 | 2427 | 2018-12-18 | Koehly | Chelsea | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2428 | 2428 | 2018-12-18 | Luca | Friederike | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2429 | 2429 | 2018-12-18 | Michaud | Stephanie | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2430 | 2430 | 2018-12-18 | Segre-Lawrence | Elizabeth | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2431 | 2431 | 2018-12-18 | Steinke | William | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2432 | 2432 | 2018-12-18 | Whitley | Alexis | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2469 | 2469 | 2022-12-28 | Evans | Elizabeth | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2470 | 2470 | 2022-12-28 | Lemmons | Dawson Tate | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2471 | 2471 | 2022-12-28 | Nketiah | Cherise | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2472 | 2472 | 2022-12-28 | Putman | Helen | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2473 | 2473 | 2022-12-28 | Stark | Kaylin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2474 | 2474 | 2022-12-28 | Telischi | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 2475 | 2475 | 2022-12-28 | Warnecke | John Robert | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
| 8918 | 8918 | 2019-03-01 | 2018-12-18 | Hamilton | Mycah | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 13261 | 13261 | 2019-04-12 | 2019-05-22 | Dukoff | Gilian | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 14159 | 14159 | 2019-04-26 | 2018-12-18 | Dixon | Lucy | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 16489 | 16489 | 2019-05-15 | 2018-12-18 | Simpson | Crystalyn | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 16532 | 16532 | 2019-05-16 | 2018-12-18 | Gunn | Lauren | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 17385 | 17385 | 2020-05-29 | 2018-04-30 | Averay-Cuesta | Julie | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 17386 | 17386 | 2020-05-29 | 2018-04-30 | Guerrero | Daniel | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 17387 | 17387 | 2020-05-29 | 2018-04-30 | Yang | Erin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 17388 | 17388 | 2020-05-29 | 2019-05-22 | Vaught | Christy | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 17390 | 17390 | 2020-05-29 | 2020-06-18 | Mullaney | Erin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 17393 | 17393 | 2020-05-29 | 2019-11-26 | Fox | Dylan | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 19831 | 19831 | 2019-06-18 | 2018-04-30 | Morrow | Stephanie | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 20489 | 20489 | 2019-06-28 | 2018-04-30 | Rivera | Maria | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 20490 | 20490 | 2022-06-28 | 2018-12-18 | Lusher | Jaime | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 21981 | 21981 | 2021-06-30 | 2018-04-30 | Achacoso | Chris | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 22933 | 22933 | 2020-07-10 | 2018-12-18 | Harbaugh | Allison | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 24607 | 24607 | 2020-07-30 | 2020-06-18 | Bryant | Amanda | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 25384 | 25384 | 2020-07-31 | 2019-05-22 | Hernandez | Jonathan | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 27242 | 27242 | 2019-08-22 | 2018-12-18 | Cyrille | Laura | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 30171 | 30171 | 2022-09-20 | 2021-05-28 | De La Riva | Sarah | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 31668 | 31668 | 2019-09-30 | 2018-04-30 | Diaz | Eva | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 34778 | 34778 | 2022-10-31 | 2021-11-29 | Yang | Erin | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 35637 | 35637 | 2020-11-11 | 2019-05-22 | De La Riva | Sarah | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
| 36037 | 36037 | 2020-11-18 | 2020-06-18 | Taylor | Victoria | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
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]) );