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

561 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 · 561 ✖
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
37 37   2020-01-06 Blake Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
38 38   2020-01-06 Carpenter Brendan 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
42 42   2020-01-06 Ostrove Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
43 43   2020-01-06 Riley David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
44 44   2020-01-06 Stine Danielle 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
45 45   2020-01-06 Wahrman Alyssa 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
46 46   2020-01-06 Worley Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
73 73   2019-01-14 Cano Ines 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
75 75   2019-01-14 Gaggioni Andrea 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
76 76   2019-01-14 Guest Thalia 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
77 77   2019-01-14 Luckey Chris 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
78 78   2019-01-14 Martinez Natalia Perez 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
79 79   2019-01-14 McAtee Brett 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
80 80   2019-01-14 Van Patten Amy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
81 81   2019-01-14 Whitley Alexis 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
82 82   2019-01-14 Woolery Andrew 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
227 227   2011-02-04 Overstreet Larry L. 5246 5246 1998-03-01 Oliver A. Dulle Jr. & Company 7751 Carondelet Avenue Suite 805 Clayton MO 63105
526 526   2020-03-26 Bashir Mr. Junaid M 6807 6807 2020-03-26 PTI USA 403 C Mid Trail Ct.   Baldwin MO 63011
574 574   2020-03-30 Netto Joseph 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
576 576   2020-03-30 Schmidt Michael Thomas 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
577 577   2020-03-30 Shull Anna Marie 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
578 578   2020-03-30 Streich William Joseph Brendan 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
784 784   2018-04-30 Achacoso Chris 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
785 785   2018-04-30 Averay-Cuesta Julie 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
786 786   2018-04-30 Chan Carman 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
787 787   2018-04-30 Goger Jennifer 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
788 788   2018-04-30 Guerrero Daniel 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
789 789   2018-04-30 Luo Yvonne 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
790 790   2018-04-30 Matar Laura 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
792 792   2018-04-30 Merschen Al 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
793 793   2018-04-30 Nase Stephen 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
794 794   2018-04-30 Petrides Daniela 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
795 795   2018-04-30 Pfeiffer Heike 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
797 797   2018-04-30 Sabir Samina 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
798 798   2018-04-30 Troy Shannon 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
799 799   2018-04-30 Yang Erin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
951 951   2019-05-22 Carvajal Tricia 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
953 953   2019-05-22 De La Riva Sarah 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
954 954   2019-05-22 Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
955 955   2019-05-22 Hernandez Jonathan 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
956 956   2019-05-22 Jones Stephanie 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
957 957   2019-05-22 LaBriola Allyson 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
958 958   2019-05-22 Leon Christopher 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
960 960   2019-05-22 Ostrove Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
961 961   2019-05-22 Vaught Christy 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1100 1100   2017-06-09 Ashcroft John D. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1101 1101   2017-06-09 Ayres David T. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1102 1102   2017-06-09 Day Lori Sharpe 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1103 1103   2017-06-09 Peele Christopher L. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1104 1104   2017-06-09 Reyes Luis Alejandro 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1105 1105   2017-06-09 Sullivan Michael J. 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1143 1143   2013-06-14 Lyall Alexander 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1163 1163   2020-06-18 Bryant Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1164 1164   2020-06-18 Mullaney Erin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1165 1165   2020-06-18 Riley David 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1166 1166   2020-06-18 Sharp Dustin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1167 1167   2020-06-18 Taylor Victoria 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
1204 1204   2019-06-26 Billings Brandon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1205 1205   2019-06-26 Duhr Harrison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1206 1206   2019-06-26 Fymbo David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1207 1207   2019-06-26 Hanover Kurt 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1209 1209   2019-06-26 Kuhnert Amber 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1210 1210   2019-06-26 Miller Erica 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1211 1211   2019-06-26 Orr Jean 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1212 1212   2019-06-26 Palmer Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1213 1213   2019-06-26 Pope Lauren 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1214 1214   2019-06-26 Sharp Dustin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1215 1215   2019-06-26 Williams Eliza 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1216 1216   2019-06-26 Yantis Tara 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1217 1217   2019-06-26 Zaidi Roya 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1219 1219   2020-06-26 Rahman Kamilla 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1220 1220   2020-06-26 Shaw Steven 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1221 1221   2020-06-26 Teahan Caitlin 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1232 1232   2018-06-29 Anderson Brent 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1233 1233   2018-06-29 Arnoldi Sarah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1234 1234   2018-06-29 Freeman Julie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1235 1235   2018-06-29 Gomez Catalina 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1236 1236   2018-06-29 Guerrero Daniel 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1237 1237   2018-06-29 Harbaugh Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1238 1238   2018-06-29 Lenox Kim 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1239 1239   2018-06-29 Matar Laura 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1240 1240   2018-06-29 Oceguera Fernanda Melgoza 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1241 1241   2018-06-29 Steinke William 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1314 1314   2020-07-10 Brennan Nathan 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
1375 1375   2020-07-22 Averay Cuesta Juie 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1376 1376   2020-07-22 Baragary Austin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1377 1377   2020-07-22 Dye Emily 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1378 1378   2020-07-22 Ivey-Walker Glennah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1379 1379   2020-07-22 Kaufman Lauren 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1380 1380   2020-07-22 Klein Noah 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1381 1381   2020-07-22 Munsch Landon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1382 1382   2020-07-22 Stelmach Rachel 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1383 1383   2020-07-22 Walker Caitlin 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
1774 1774   2017-09-26 Rose Sheila 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
1828 1828   2019-10-02 West Kimberly 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
2077 2077   2019-11-13 Bennett Barry 6438 6438 2017-06-09 Ashcroft Law Firm, LLC 1100 Main Street Suite 2700 St. Louis MO 64105
2125 2125   2013-11-20 Rockenbach Denise M. 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
2158 2158   2019-11-26 Click Collin 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2161 2161   2019-11-26 Felipe Jessica 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
2162 2162   2019-11-26 Fox Dylan 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)
);
Powered by Datasette · Query took 340.485ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history