FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
286 rows where State = "KS"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32225 | 32225 | 2017-10-03 | 2017-11-27 | Herrera | Nathalie | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
32226 | 32226 | 2017-10-03 | 2017-11-27 | Tan | Rebecca | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
32342 | 32342 | 2018-10-05 | 2018-06-29 | Weishaar | Derrick | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
32713 | 32713 | 2018-10-12 | 2018-06-29 | Scarafile | Francesca | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
32757 | 32757 | 2017-10-13 | 2017-11-27 | Ho | Yalun | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
32758 | 32758 | 2022-10-13 | 2022-02-22 | Carder | Rachel | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
33734 | 33734 | 2017-10-27 | 2017-11-27 | Perez | David | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #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 |
35070 | 35070 | 2021-11-01 | 2019-06-26 | Kuhnert | Amber | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #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 |
35930 | 35930 | 2019-11-15 | 2018-06-29 | Contreras | Susana lakovliev | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #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 |
36184 | 36184 | 2018-11-21 | 2018-06-29 | Olson | Michael | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
36189 | 36189 | 2022-11-21 | 2022-09-14 | Schumann | Emily | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
37112 | 37112 | 2018-11-30 | 2018-06-29 | Hughes | Stephanie | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
37113 | 37113 | 2018-11-30 | 2018-06-29 | Koehly | Chelsea | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
38448 | 38448 | 2016-12-15 | 2017-11-27 | Grossman | Carolyn | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
40391 | 40391 | 1987-12-31 | 1985-02-06 | Morgan | Gary Russell | Morgan, Gary Russell 3648 | 1985-02-06 | Morgan, Gary Russell | 401 East Douglas | Suite 505 | Wichita | KS | 67202 |
42079 | 42079 | 2016-12-31 | 2017-11-27 | Chabot | Kelsey | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42206 | 42206 | 2018-12-31 | 2017-11-27 | Yang | Fu-Hua | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42227 | 42227 | 2019-12-31 | 2019-01-14 | Layland | Brandon | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42228 | 42228 | 2019-12-31 | 2019-01-14 | McAtee | Brett | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42265 | 42265 | 2019-12-31 | 2019-06-26 | Arnoldi | Aimee | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42266 | 42266 | 2019-12-31 | 2019-06-26 | Bryant | Amanda | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42267 | 42267 | 2019-12-31 | 2019-06-26 | Burge | Brooke | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42268 | 42268 | 2019-12-31 | 2019-06-26 | Gill | Carolyn | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42269 | 42269 | 2019-12-31 | 2019-06-26 | Oberzan | Kaylee | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42270 | 42270 | 2019-12-31 | 2018-06-29 | Harbaugh | Allison | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42271 | 42271 | 2019-12-31 | 2018-06-29 | Lenox | Kim | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42294 | 42294 | 2019-12-31 | 2017-11-27 | Colovin | Stewart | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42295 | 42295 | 2019-12-31 | 2017-11-27 | Reid | Clayton Patrick | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42296 | 42296 | 2019-12-31 | 2017-11-27 | Sanders | Brandon S. | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42299 | 42299 | 2020-12-31 | 2020-01-06 | Stine | Danielle | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42334 | 42334 | 2020-12-31 | 2020-07-22 | Baragary | Austin | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42335 | 42335 | 2020-12-31 | 2020-07-22 | Dye | Emily | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42361 | 42361 | 2020-12-31 | 2020-12-16 | Conder | Megan | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42362 | 42362 | 2020-12-31 | 2020-12-16 | Larsen | Jenna | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #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]) );