FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
36 rows where Address_2 = "Suite 2200"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 5
Registrant_Name 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3585 | 3585 | 2012-01-11 | 2010-03-12 | Sato | Miyuki | City of Osaka, Chicago Office 5979 | 2010-03-12 | City of Osaka, Chicago Office | 200 E. Randolph Street | Suite 2200 | Chicago | IL | 60601 |
3817 | 3817 | 2003-01-15 | 1997-11-24 | Yamashita | Hiroko | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
3819 | 3819 | 2004-01-15 | 2000-06-07 | Noguchi | Mayumi | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
7942 | 7942 | 1989-02-28 | 1981-06-04 | Fontaine | Michee | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
10792 | 10792 | 1982-03-26 | 1981-12-01 | Kober | Barbara | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
13877 | 13877 | 2000-04-21 | 1999-08-03 | Nakamura | Takako | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
13951 | 13951 | 1982-04-23 | 1981-10-05 | Brinkley | Lorrell | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
15616 | 15616 | 1982-05-03 | 1981-10-15 | Goodman | Cynthia | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
15860 | 15860 | 2010-05-07 | 2010-03-12 | Toriyama | Takayuki | City of Osaka, Chicago Office 5979 | 2010-03-12 | City of Osaka, Chicago Office | 200 E. Randolph Street | Suite 2200 | Chicago | IL | 60601 |
19151 | 19151 | 1982-06-10 | 1981-06-04 | Haber | George Elliott | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
22151 | 22151 | 1983-07-01 | 1981-11-12 | Saxton | Brian Edward | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
22260 | 22260 | 1997-07-01 | 1991-05-20 | Young | Yasuko M. | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
22521 | 22521 | 1981-07-03 | 1981-07-23 | Howell | Nancy Rae | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
23956 | 23956 | 1981-07-24 | 1981-06-04 | Cunningham | Melvin George | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
23957 | 23957 | 1981-07-24 | 1981-06-04 | Roberts | Jennifer M. | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
29519 | 29519 | 1981-09-10 | 1981-06-04 | Nyren | Edward A. | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
30366 | 30366 | 1981-09-24 | 1981-09-18 | Kimball | Merit Clark | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
33080 | 33080 | 2007-10-17 | 2007-07-02 | Black | Judy A. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33081 | 33081 | 2007-10-17 | 2007-07-02 | Brownstein | Norman | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33082 | 33082 | 2007-10-17 | 2007-07-02 | Cohen | David P. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33083 | 33083 | 2007-10-17 | 2007-07-02 | Dahl | Alexander R. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33084 | 33084 | 2007-10-17 | 2007-07-02 | Flood | James G. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33085 | 33085 | 2007-10-17 | 2007-07-02 | Levy | Michael B. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33086 | 33086 | 2007-10-17 | 2007-07-02 | Mottur | Alfred E. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
35366 | 35366 | 1989-11-07 | 1982-04-12 | Cromwell | James H. | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
35367 | 35367 | 1989-11-07 | 1982-05-09 | Shackelford | Edward A. | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
35368 | 35368 | 1989-11-07 | 1980-06-27 | Sabo | Anne F. | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
35369 | 35369 | 1989-11-07 | 1989-11-07 | Serrano | Juan J. | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
36244 | 36244 | 1981-11-23 | 1981-10-29 | Elliott | George A. , III | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
36926 | 36926 | 2004-11-30 | 1999-08-03 | Hutcheson | Kuniko | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
37029 | 37029 | 2012-11-30 | 2010-03-12 | Rokumoto | Akari | City of Osaka, Chicago Office 5979 | 2010-03-12 | City of Osaka, Chicago Office | 200 E. Randolph Street | Suite 2200 | Chicago | IL | 60601 |
37030 | 37030 | 2012-11-30 | 2010-03-12 | Sako | Satoko | City of Osaka, Chicago Office 5979 | 2010-03-12 | City of Osaka, Chicago Office | 200 E. Randolph Street | Suite 2200 | Chicago | IL | 60601 |
37117 | 37117 | 2018-11-30 | 2017-11-09 | Bond | Christopher S. | Kit Bond Strategies, LLP 6486 | 2017-11-09 | Kit Bond Strategies, LLP | 7733 Forsyth Boulevard | Suite 2200 | St. Louis | MO | 63105 |
37119 | 37119 | 2018-11-30 | 2017-11-09 | Hulshof | Kenny C. | Kit Bond Strategies, LLP 6486 | 2017-11-09 | Kit Bond Strategies, LLP | 7733 Forsyth Boulevard | Suite 2200 | St. Louis | MO | 63105 |
37120 | 37120 | 2018-11-30 | 2017-11-09 | Marchio | Shana | Kit Bond Strategies, LLP 6486 | 2017-11-09 | Kit Bond Strategies, LLP | 7733 Forsyth Boulevard | Suite 2200 | St. Louis | MO | 63105 |
41114 | 41114 | 1998-12-31 | 1997-11-24 | Imada | Chikako | Business Network Corporation 4513 | 1991-05-20 | Business Network Corporation | 245 Peachtree Center Avenue | Suite 2200 | Atlanta | GA | 30303 |
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]) );