home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

54 rows where State = "IA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 6

  • Larson Shannahan Slifka Group, LLC 33
  • IPSCO Tubulars, Inc. 15
  • Greater Iowa Trading Corporation 3
  • Belin, Harris, Helmick, Lamson, McCormick, P.C. 1
  • Reichert, E. Karl 1
  • Larson Shannahan Slifka Group, LLC 1

Registrant_Name 5

  • Larson Shannahan Slifka Group, LLC 34
  • IPSCO Tubulars, Inc. 15
  • Greater Iowa Trading Corporation 3
  • Belin, Harris, Helmick, Lamson, McCormick, P.C. 1
  • Reichert, E. Karl 1

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
274 274   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
289 289   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
301 301   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
304 304   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
326 326   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
334 334   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
1824 1824   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
1910 1910   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
2139 2139   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
2141 2141   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
2142 2142   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
2143 2143   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
2192 2192   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
2320 2320   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
4654 4654 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
4655 4655 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
6084 6084 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
6884 6884 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  
6885 6885 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  
6886 6886 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  
7396 7396 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
10145 10145 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
10146 10146 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
11602 11602 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
11624 11624 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
12596 12596 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
14147 14147 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
14379 14379 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
14601 14601 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
14602 14602 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
14607 14607 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
14608 14608 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
15054 15054 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
15690 15690 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
16701 16701 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
17710 17710 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
18224 18224 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
18225 18225 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
18762 18762 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
19067 19067 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
19110 19110 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
19174 19174 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
22538 22538 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
23307 23307 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
23308 23308 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
24317 24317 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
36387 36387 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
36730 36730 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
37174 37174 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
38921 38921 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
38922 38922 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
38923 38923 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
38929 38929 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
42334 42334 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])
);
Powered by Datasette · Queries took 498.681ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history