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

17 rows where Registration_Number = 6549 and "Short_Form_Date" is on date 2018-04-30

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

State 1

Registration_Number 1

  • Myriad International Marketing, LLC · 17 ✖

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

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