FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
43 rows where State = "IA"
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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1009 | 1009 | 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 | |
1104 | 1104 | 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 | |
1499 | 1499 | 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 | |
1500 | 1500 | 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 | |
1839 | 1839 | 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 | |
1841 | 1841 | 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 | |
1842 | 1842 | 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 | |
1843 | 1843 | 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 | |
1844 | 1844 | 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 | |
2021 | 2021 | 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 | |
2023 | 2023 | 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 | |
2024 | 2024 | 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 | |
2025 | 2025 | 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 | |
2027 | 2027 | 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 | |
2028 | 2028 | 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 | |
2058 | 2058 | 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 | |
2144 | 2144 | 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 | |
6438 | 6438 | 1966-02-15 | 1965-01-11 | Fitch | Lucius W. | 1840 1840 | 1965-01-11 | Greater Iowa Trading Corporation | 906 - 9th Street | Boone | IA | ||
6439 | 6439 | 1966-02-15 | 1965-01-11 | Hart | Walter T. | 1840 1840 | 1965-01-11 | Greater Iowa Trading Corporation | 906 - 9th Street | Boone | IA | ||
6440 | 6440 | 1966-02-15 | 1965-01-11 | Heline | John Peter | 1840 1840 | 1965-01-11 | Greater Iowa Trading Corporation | 906 - 9th Street | Boone | IA | ||
9550 | 9550 | 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 |
9551 | 9551 | 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 |
10990 | 10990 | 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 |
11012 | 11012 | 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 | |
13817 | 13817 | 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 |
13818 | 13818 | 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 |
13823 | 13823 | 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 |
13824 | 13824 | 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 |
14270 | 14270 | 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 |
14805 | 14805 | 1993-05-04 | 1992-10-23 | Reichert | E. Karl | 4727 4727 | 1992-10-23 | Reichert, E. Karl | 3402 Tipton Road | Muscatine | IA | 52761 | |
16756 | 16756 | 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 |
17727 | 17727 | 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 |
18067 | 18067 | 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 |
18130 | 18130 | 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 |
21342 | 21342 | 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 |
23063 | 23063 | 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 |
34747 | 34747 | 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 |
35072 | 35072 | 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 |
37168 | 37168 | 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 |
37169 | 37169 | 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 |
37170 | 37170 | 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 |
37176 | 37176 | 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 |
40504 | 40504 | 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
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) );