FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

586 rows where State = "MO"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number

State

  • MO · 586 ✖
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 5     Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
13 13     Oceguera Fernanda Melgoza 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
19 19     Whitley Alexis 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
46 46   2020-01-06 Blake Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
47 47   2020-01-06 Carpenter Brendan 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
50 50   2020-01-06 Ostrove Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
51 51   2020-01-06 Riley David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
52 52   2020-01-06 Stine Danielle 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
53 53   2020-01-06 Wahrman Alyssa 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
54 54   2020-01-06 Worley Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
91 91   2019-01-14 Cano Ines 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
93 93   2019-01-14 Gaggioni Andrea 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
95 95   2019-01-14 Guest Thalia 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
96 96   2019-01-14 Luckey Chris 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
97 97   2019-01-14 Martinez Natalia Perez 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
98 98   2019-01-14 McAtee Brett 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
99 99   2019-01-14 Van Patten Amy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
100 100   2019-01-14 Whitley Alexis 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
101 101   2019-01-14 Woolery Andrew 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
130 130   2021-01-21 Rand Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
216 216   2021-01-30 Adolph Michael Charles 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
217 217   2021-01-30 Belding Arman 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
218 218   2021-01-30 Bernard Mikael 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
219 219   2021-01-30 Bueno Alexander de la Torre 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
220 220   2021-01-30 Franklin James Nikolai 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
221 221   2021-01-30 Graziano Devon 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
222 222   2021-01-30 Heibeck Olivia 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
225 225   2021-01-30 Sanchez Nicole 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
272 272   2011-02-04 Overstreet Larry L. 5246 5246 1998-03-01 Oliver A. Dulle Jr. & Company 7751 Carondelet Avenue Suite 805 Clayton MO 63105
739 739   2018-04-30 Achacoso Chris 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
740 740   2018-04-30 Chan Carman 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
741 741   2018-04-30 Goger Jennifer 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
742 742   2018-04-30 Luo Yvonne 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
743 743   2018-04-30 Matar Laura 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
745 745   2018-04-30 Merschen Al 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
746 746   2018-04-30 Nase Stephen 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
747 747   2018-04-30 Petrides Daniela 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
748 748   2018-04-30 Pfeiffer Heike 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
749 749   2018-04-30 Sabir Samina 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
750 750   2018-04-30 Troy Shannon 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
856 856   2019-05-22 Carvajal Tricia 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
858 858   2019-05-22 De La Riva Sarah 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
859 859   2019-05-22 Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
860 860   2019-05-22 Jones Stephanie 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
861 861   2019-05-22 LaBriola Allyson 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
862 862   2019-05-22 Leon Christopher 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
863 863   2019-05-22 Ostrove Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
966 966   2017-06-09 Ashcroft John D. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
967 967   2017-06-09 Ayres David T. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
968 968   2017-06-09 Day Lori Sharpe 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
969 969   2017-06-09 Peele Christopher L. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
970 970   2017-06-09 Reyes Luis Alejandro 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
971 971   2017-06-09 Sullivan Michael J. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1018 1018   2020-06-18 Riley David 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1019 1019   2020-06-18 Sharp Dustin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1020 1020   2020-06-18 Taylor Victoria 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1048 1048   2019-06-26 Billings Brandon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1049 1049   2019-06-26 Duhr Harrison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1050 1050   2019-06-26 Fymbo David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1051 1051   2019-06-26 Hanover Kurt 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1052 1052   2019-06-26 Kuhnert Amber 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1053 1053   2019-06-26 Miller Erica 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1054 1054   2019-06-26 Orr Jean 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1055 1055   2019-06-26 Palmer Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1056 1056   2019-06-26 Pope Lauren 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1057 1057   2019-06-26 Sharp Dustin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1058 1058   2019-06-26 Williams Eliza 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1059 1059   2019-06-26 Yantis Tara 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1060 1060   2019-06-26 Zaidi Roya 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1062 1062   2020-06-26 Rahman Kamilla 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1063 1063   2020-06-26 Shaw Steven 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1064 1064   2020-06-26 Teahan Caitlin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1074 1074   2018-06-29 Anderson Brent 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1075 1075   2018-06-29 Arnoldi Sarah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1076 1076   2018-06-29 Freeman Julie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1077 1077   2018-06-29 Gomez Catalina 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1078 1078   2018-06-29 Guerrero Daniel 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1079 1079   2018-06-29 Harbaugh Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1080 1080   2018-06-29 Lenox Kim 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1081 1081   2018-06-29 Matar Laura 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1082 1082   2018-06-29 Oceguera Fernanda Melgoza 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1083 1083   2018-06-29 Steinke William 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1140 1140   2020-07-10 Brennan Nathan 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1183 1183   2020-07-22 Averay Cuesta Juie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1184 1184   2020-07-22 Baragary Austin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1185 1185   2020-07-22 Dye Emily 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1186 1186   2020-07-22 Ivey-Walker Glennah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1187 1187   2020-07-22 Kaufman Lauren 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1188 1188   2020-07-22 Klein Noah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1189 1189   2020-07-22 Munsch Landon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1190 1190   2020-07-22 Stelmach Rachel 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1191 1191   2020-07-22 Walker Caitlin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1596 1596   2019-10-02 West Kimberly 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1648 1648   2020-10-09 Girouard Spencer 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1649 1649   2020-10-09 Tchoukaleff Tayler 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1650 1650   2020-10-09 Tchoukaleff Tayler 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1651 1651   2020-10-09 Zagora Anthony 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1660 1660   2020-10-12 Witt Bailey 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1665 1665   2020-10-13 Evenson Erin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1671 1671   2020-10-13 Sadlier Lizanne 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102

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