FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
54 rows where State = "IA"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Short_Form_Termination_Date (date)
Short_Form_Date 25 ✖
- 2019-12-02 8
- 1987-03-17 7
- 2019-11-12 7
- 1988-12-06 6
- 1965-01-11 3
- 2020-09-23 2
- 2021-06-14 2
- 2022-02-04 2
- 1990-05-01 1
- 1991-02-28 1
- 1992-09-16 1
- 1992-10-23 1
- 2015-03-19 1
- 2019-12-20 1
- 2020-01-07 1
- 2020-06-16 1
- 2020-07-03 1
- 2020-12-07 1
- 2021-11-19 1
- 2022-01-06 1
- 2022-02-09 1
- 2022-10-07 1
- 2023-01-31 1
- 2023-02-03 1
- 2023-02-07 1
Registration_Number 6
Registration_Date (date) 6 ✖
- 2019-11-12 33
- 1987-03-17 15
- 1965-01-11 3
- 1991-02-28 1
- 1992-10-23 1
- 2015-03-19 1
Registrant_Name 5
City 4
- Des Moines 35
- Camanche 15
- Boone 3
- Muscatine 1
State 1
- IA · 54 ✖
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 |
6897 | 6897 | 1966-02-15 | 1965-01-11 | Fitch | Lucius W. | Greater Iowa Trading Corporation 1840 | 1965-01-11 | Greater Iowa Trading Corporation | 906 - 9th Street | Boone | IA | ||
6898 | 6898 | 1966-02-15 | 1965-01-11 | Hart | Walter T. | Greater Iowa Trading Corporation 1840 | 1965-01-11 | Greater Iowa Trading Corporation | 906 - 9th Street | Boone | IA | ||
6899 | 6899 | 1966-02-15 | 1965-01-11 | Heline | John Peter | Greater Iowa Trading Corporation 1840 | 1965-01-11 | Greater Iowa Trading Corporation | 906 - 9th Street | Boone | IA | ||
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 |
10158 | 10158 | 1996-03-17 | 1987-03-17 | Comrie | John | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
10159 | 10159 | 1996-03-17 | 1992-09-16 | Davis | James D. | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
11615 | 11615 | 1989-03-31 | 1988-12-06 | Stuart | Bruce J. | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
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 |
14616 | 14616 | 1991-04-30 | 1987-03-17 | Phillips | Roger | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
14617 | 14617 | 1991-04-30 | 1987-03-17 | Tulloch | John | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
14622 | 14622 | 1991-04-30 | 1988-12-06 | McKee | Bruce | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
14623 | 14623 | 1991-04-30 | 1988-12-06 | Rzonca | Robert | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
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 |
15706 | 15706 | 1993-05-04 | 1992-10-23 | Reichert | E. Karl | Reichert, E. Karl 4727 | 1992-10-23 | Reichert, E. Karl | 3402 Tipton Road | Muscatine | IA | 52761 | |
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 |
17727 | 17727 | 1989-05-31 | 1988-12-06 | Acquaviva | Richard A. | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
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 |
19191 | 19191 | 1994-06-10 | 1988-12-06 | Stefaniuk | Robert M. | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
22559 | 22559 | 1988-07-04 | 1987-03-17 | Vinzant | S. Benton | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
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 |
36752 | 36752 | 1992-11-30 | 1987-03-17 | Kosanovich | Milan | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
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 |
38943 | 38943 | 1994-12-22 | 1987-03-17 | Backman | G. Charles | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
38944 | 38944 | 1994-12-22 | 1987-03-17 | Dalla-Vicenza | Mario | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
38945 | 38945 | 1994-12-22 | 1990-05-01 | Rougas | Dean | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
38951 | 38951 | 1994-12-22 | 1988-12-06 | Sutherland | David | IPSCO Tubulars, Inc. 3948 | 1987-03-17 | IPSCO Tubulars, Inc. | 2011 - 7th Avenue | Post Office Box 180 | Camanche | IA | 52730-0180 |
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
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]) );