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

35 rows where City = "Des Moines" and State = "IA"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

City 1

  • Des Moines · 35 ✖
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
282 282   2023-01-31 Torkelson Kyle Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
297 297   2023-02-03 Sands Jeffrey Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
309 309   2022-02-04 Abeln Mitchell B Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
312 312   2022-02-04 Gwinner James N Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
334 334   2023-02-07 Meyer Nicholas Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
342 342   2022-02-09 Gullickson Hans Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
1834 1834   2020-09-23 Bir Emily Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
1919 1919   2022-10-07 Stroller Christopher D Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2148 2148   2019-11-12 Gaul Olivia Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2150 2150   2019-11-12 Larson Jr. Charles W. Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2151 2151   2019-11-12 Slifka Karen Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2152 2152   2019-11-12 Tobin James D. Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2201 2201   2021-11-19 Moscynski Sean Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2329 2329   2019-12-02 Lederman Dan Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
4666 4666 2023-01-27 2021-06-14 Ciabatti Michael J Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
4667 4667 2023-01-27 2020-07-03 Brown Michael Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
6097 6097 2023-02-03 2022-01-06 Stover Sophia Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
7409 7409 2021-02-22 2020-06-16 Canney Crystal Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
11637 11637 1991-03-31 1991-02-28 Helmick Robert H. Belin, Harris, Helmick, Lamson, McCormick, P.C. 4478 1991-02-28 Belin, Harris, Helmick, Lamson, McCormick, P.C. 2000 Financial Center   Des Moines IA 50309
12610 12610 2021-04-01 2020-12-07 Moyer Kyle Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
14161 14161 2022-04-26 2019-12-20 Slaven Quinn Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
14394 14394 2022-04-29 2021-06-14 Phipps Ashley Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
15069 15069 2015-04-30 2015-03-19 Larson Jr. Charles W. Larson Shannahan Slifka Group, LLC 6282 2015-03-19 Larson Shannahan Slifka Group, LLC 510 East Locust Street Suite 200 Des Moines IA 50309
16718 16718 2021-05-19 2019-12-02 Luong Amy De Linh Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
18241 18241 2021-05-31 2019-12-02 Boeyink Nickalaus J. Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
18242 18242 2021-05-31 2019-12-02 Miller Brooke Mackenzie Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
18779 18779 2020-06-03 2019-12-02 Day Kyle B. Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
19084 19084 2023-06-08 2020-09-23 Keen Jerry Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
19127 19127 2020-06-09 2020-01-07 Stenseth Joel Tyler Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
23328 23328 2022-07-15 2019-12-02 Donaghu Demaree Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
23329 23329 2022-07-15 2019-12-02 Ryan Courtney Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
24339 24339 2020-07-28 2019-11-12 Benjamin Kendall T. Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
36409 36409 2020-11-25 2019-11-12 Wood Mary Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
37196 37196 2021-11-30 2019-11-12 Midkiff Charles K. Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
42356 42356 2020-12-31 2019-12-02 Summers-Grice Kathleen Larson Shannahan Slifka Group, LLC 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309

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