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

45 rows where State = "IA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number

State

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     Ciabatti Michael J 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
17 17     Phipps Ashley 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
1193 1193   2020-07-03 Brown Michael 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
1713 1713   2020-09-23 Bir Emily 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
1714 1714   2020-09-23 Keen Jerry 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2039 2039   2019-11-12 Gaul Olivia 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2041 2041   2019-11-12 Larson Jr. Charles W. 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2042 2042   2019-11-12 Midkiff Charles K. 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2043 2043   2019-11-12 Slifka Karen 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2044 2044   2019-11-12 Tobin James D. 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2209 2209   2019-12-02 Donaghu Demaree 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2210 2210   2019-12-02 Lederman Dan 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2212 2212   2019-12-02 Ryan Courtney 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
2307 2307   2019-12-20 Slaven Quinn 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
6628 6628 1966-02-15 1965-01-11 Fitch Lucius W. 1840 1840 1965-01-11 Greater Iowa Trading Corporation 906 - 9th Street   Boone IA  
6629 6629 1966-02-15 1965-01-11 Hart Walter T. 1840 1840 1965-01-11 Greater Iowa Trading Corporation 906 - 9th Street   Boone IA  
6630 6630 1966-02-15 1965-01-11 Heline John Peter 1840 1840 1965-01-11 Greater Iowa Trading Corporation 906 - 9th Street   Boone IA  
7132 7132 2021-02-22 2020-06-16 Canney Crystal 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
9788 9788 1996-03-17 1987-03-17 Comrie John 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
9789 9789 1996-03-17 1992-09-16 Davis James D. 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
11235 11235 1989-03-31 1988-12-06 Stuart Bruce J. 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
11257 11257 1991-03-31 1991-02-28 Helmick Robert H. 4478 4478 1991-02-28 Belin, Harris, Helmick, Lamson, McCormick, P.C. 2000 Financial Center   Des Moines IA 50309
12177 12177 2021-04-01 2020-12-07 Moyer Kyle 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
14123 14123 1991-04-30 1987-03-17 Phillips Roger 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
14124 14124 1991-04-30 1987-03-17 Tulloch John 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
14129 14129 1991-04-30 1988-12-06 McKee Bruce 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
14130 14130 1991-04-30 1988-12-06 Rzonca Robert 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
14576 14576 2015-04-30 2015-03-19 Larson Jr. Charles W. 6282 6282 2015-03-19 Larson Shannahan Slifka Group, LLC 510 East Locust Street Suite 200 Des Moines IA 50309
15148 15148 1993-05-04 1992-10-23 Reichert E. Karl 4727 4727 1992-10-23 Reichert, E. Karl 3402 Tipton Road   Muscatine IA 52761
16125 16125 2021-05-19 2019-12-02 Luong Amy De Linh 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
17116 17116 1989-05-31 1988-12-06 Acquaviva Richard A. 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
17625 17625 2021-05-31 2019-12-02 Boeyink Nickalaus J. 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
17626 17626 2021-05-31 2019-12-02 Miller Brooke Mackenzie 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
18109 18109 2020-06-03 2019-12-02 Day Kyle B. 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
18452 18452 2020-06-09 2020-01-07 Stenseth Joel Tyler 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
18514 18514 1994-06-10 1988-12-06 Stefaniuk Robert M. 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
21755 21755 1988-07-04 1987-03-17 Vinzant S. Benton 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
23483 23483 2020-07-28 2019-11-12 Benjamin Kendall T. 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
35216 35216 2020-11-25 2019-11-12 Wood Mary 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
35541 35541 1992-11-30 1987-03-17 Kosanovich Milan 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
37643 37643 1994-12-22 1987-03-17 Backman G. Charles 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
37644 37644 1994-12-22 1987-03-17 Dalla-Vicenza Mario 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
37645 37645 1994-12-22 1990-05-01 Rougas Dean 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
37651 37651 1994-12-22 1988-12-06 Sutherland David 3948 3948 1987-03-17 IPSCO Tubulars, Inc. 2011 - 7th Avenue Post Office Box 180 Camanche IA 52730-0180
41042 41042 2020-12-31 2019-12-02 Summers-Grice Kathleen 6749 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])
);