List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

205 rows where City = "Kansas City"

View and edit SQL

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

Registration_Number

State

City

  • Kansas City · 205
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
5     Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
13     Oceguera Fernanda Melgoza 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
19     Whitley Alexis 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
46   2020-01-06 Blake Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
47   2020-01-06 Carpenter Brendan 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
50   2020-01-06 Ostrove Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
51   2020-01-06 Riley David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
52   2020-01-06 Stine Danielle 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
53   2020-01-06 Wahrman Alyssa 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
54   2020-01-06 Worley Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
91   2019-01-14 Cano Ines 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
93   2019-01-14 Gaggioni Andrea 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
95   2019-01-14 Guest Thalia 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
96   2019-01-14 Luckey Chris 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
97   2019-01-14 Martinez Natalia Perez 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
98   2019-01-14 McAtee Brett 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
99   2019-01-14 Van Patten Amy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
100   2019-01-14 Whitley Alexis 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
101   2019-01-14 Woolery Andrew 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
735   2018-04-30 Achacoso Chris 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
736   2018-04-30 Chan Carman 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
737   2018-04-30 Goger Jennifer 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
738   2018-04-30 Luo Yvonne 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
739   2018-04-30 Matar Laura 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
741   2018-04-30 Merschen Al 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
742   2018-04-30 Nase Stephen 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
743   2018-04-30 Petrides Daniela 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
744   2018-04-30 Pfeiffer Heike 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
745   2018-04-30 Sabir Samina 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
746   2018-04-30 Troy Shannon 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
852   2019-05-22 Carvajal Tricia 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
854   2019-05-22 De La Riva Sarah 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
855   2019-05-22 Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
856   2019-05-22 Jones Stephanie 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
857   2019-05-22 LaBriola Allyson 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
858   2019-05-22 Leon Christopher 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
859   2019-05-22 Ostrove Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1014   2020-06-18 Riley David 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1015   2020-06-18 Sharp Dustin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1016   2020-06-18 Taylor Victoria 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1044   2019-06-26 Billings Brandon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1045   2019-06-26 Duhr Harrison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1046   2019-06-26 Fymbo David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1047   2019-06-26 Hanover Kurt 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1048   2019-06-26 Kuhnert Amber 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1049   2019-06-26 Miller Erica 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1050   2019-06-26 Orr Jean 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1051   2019-06-26 Palmer Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1052   2019-06-26 Pope Lauren 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1053   2019-06-26 Sharp Dustin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1054   2019-06-26 Williams Eliza 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1055   2019-06-26 Yantis Tara 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1056   2019-06-26 Zaidi Roya 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1070   2018-06-29 Anderson Brent 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1071   2018-06-29 Arnoldi Sarah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1072   2018-06-29 Freeman Julie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1073   2018-06-29 Gomez Catalina 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1074   2018-06-29 Guerrero Daniel 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1075   2018-06-29 Harbaugh Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1076   2018-06-29 Lenox Kim 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1077   2018-06-29 Matar Laura 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1078   2018-06-29 Oceguera Fernanda Melgoza 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1079   2018-06-29 Steinke William 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1179   2020-07-22 Averay Cuesta Juie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1180   2020-07-22 Baragary Austin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1181   2020-07-22 Dye Emily 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1182   2020-07-22 Ivey-Walker Glennah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1183   2020-07-22 Kaufman Lauren 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1184   2020-07-22 Klein Noah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1185   2020-07-22 Munsch Landon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1186   2020-07-22 Stelmach Rachel 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1187   2020-07-22 Walker Caitlin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1956   2019-11-26 Click Collin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1959   2019-11-26 Felipe Jessica 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1963   2019-11-26 Luckey Chris 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1964   2019-11-26 McCarthy Taryn 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1965   2019-11-26 Oceguera Fernanda Melgoza 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1967   2017-11-27 Attebury Whitney 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1968   2017-11-27 Colovin Stewart 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1969   2017-11-27 Dunn Richard 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1970   2017-11-27 Hill Leanne 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1971   2017-11-27 Schultz Jessica 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1972   2017-11-27 Vaught Christy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1973   2017-11-27 Yang Fu-Hua 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1974   2017-11-27 Yesawich Peter C. 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2130   2020-12-16 Conder Megan 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2131   2020-12-16 Crosser Emalee 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2132   2020-12-16 Gripe Mackenzie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2133   2020-12-16 Henry Brynne 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2134   2020-12-16 Larsen Jenna 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2135   2020-12-16 Layland Brandon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
2144   2018-12-18 Belcher Carolin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2145   2018-12-18 Contreras Susana Iakovliev 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2146   2018-12-18 DeMirci Walter 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2147   2018-12-18 Garcia-Maynard Ashley 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2148   2018-12-18 Koehly Chelsea 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2149   2018-12-18 Luca Friederike 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2150   2018-12-18 Lusher Jaime 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2151   2018-12-18 Michaud Stephanie 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2152   2018-12-18 Segre-Lawrence Elizabeth 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112

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)
);