FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
58 rows where "Short_Form_Termination_Date" is on date 2014-07-31 sorted by Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_2
Registration_Number 8
Registrant_Name 8
City 5
- Chicago 43
- New York 5
- Washington 5
- Philadelphia 4
- San Francisco 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25221 | 25221 | 2014-07-31 | 2011-05-25 | Lee | Sung Hun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25251 | 25251 | 2014-07-31 | 2011-11-28 | Jeon | Sanghyun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25252 | 25252 | 2014-07-31 | 2011-11-28 | Kim | Ki Joon | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25253 | 25253 | 2014-07-31 | 2012-11-28 | Choi | Byunghun | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25231 | 25231 | 2014-07-31 | 2009-06-09 | Nguyen | Anh | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
25237 | 25237 | 2014-07-31 | 2011-06-29 | Ling | Yuan Chun | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
25200 | 25200 | 2014-07-31 | 2007-01-03 | Hawkins | Tamika | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25203 | 25203 | 2014-07-31 | 2012-02-07 | Jang | Mira | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25204 | 25204 | 2014-07-31 | 2012-02-07 | Kuntz | Jessica | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25205 | 25205 | 2014-07-31 | 2012-02-07 | Six | Robert J. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25206 | 25206 | 2014-07-31 | 2012-02-07 | Woo | Courtney | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25207 | 25207 | 2014-07-31 | 2012-03-09 | Choi | Michelle | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25208 | 25208 | 2014-07-31 | 2014-03-10 | O'Tierney | Brenna Clairr | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25209 | 25209 | 2014-07-31 | 2014-03-10 | Beebe | Christianna | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25210 | 25210 | 2014-07-31 | 2011-03-14 | Gibson | Mike | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25211 | 25211 | 2014-07-31 | 2011-03-14 | Lacey | Kathleen | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25212 | 25212 | 2014-07-31 | 2011-03-14 | Maya | Raquel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25213 | 25213 | 2014-07-31 | 2011-03-14 | Terrones-Dimant | Gaston | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25214 | 25214 | 2014-07-31 | 2013-03-15 | Hanczor | Kristin | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25215 | 25215 | 2014-07-31 | 2013-03-15 | Moran | Matthew | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25216 | 25216 | 2014-07-31 | 2011-03-30 | Forrest | Thomas | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25222 | 25222 | 2014-07-31 | 2012-06-06 | Alagno | Caryn McLeod | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25223 | 25223 | 2014-07-31 | 2012-06-06 | Dreyer | Kate | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25224 | 25224 | 2014-07-31 | 2012-06-06 | Emrich | Mitzi | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25225 | 25225 | 2014-07-31 | 2012-06-06 | Fritz | Lindsey | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25226 | 25226 | 2014-07-31 | 2012-06-06 | Golter | Elizabeth | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25227 | 25227 | 2014-07-31 | 2012-06-06 | Holwill | Claudia | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25228 | 25228 | 2014-07-31 | 2012-06-06 | Kinney | Maura | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25229 | 25229 | 2014-07-31 | 2012-06-06 | Snow | Meghan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25230 | 25230 | 2014-07-31 | 2012-06-06 | Suiters | Tyler | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25232 | 25232 | 2014-07-31 | 2012-06-11 | Naple | Michael Anthony | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25235 | 25235 | 2014-07-31 | 2010-06-25 | Aabram | Michael P. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25236 | 25236 | 2014-07-31 | 2010-06-25 | Flacks | Abigail | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25238 | 25238 | 2014-07-31 | 2011-07-22 | Lineberger | John | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25239 | 25239 | 2014-07-31 | 2011-07-22 | Lumet | Michele | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25240 | 25240 | 2014-07-31 | 2011-07-22 | Zivin | Aaron Sparky"" | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25241 | 25241 | 2014-07-31 | 2012-08-27 | Kerner | Sarah | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25242 | 25242 | 2014-07-31 | 2011-09-02 | Cassella | Kelly | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25243 | 25243 | 2014-07-31 | 2011-09-02 | Dean | Natalie | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25244 | 25244 | 2014-07-31 | 2011-09-02 | Hardesty | Cameron E. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25245 | 25245 | 2014-07-31 | 2011-09-02 | Raze | Mathieu | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25246 | 25246 | 2014-07-31 | 2011-09-02 | Wellman | Frederick Paul | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25247 | 25247 | 2014-07-31 | 2013-09-17 | Briceno | Erika Isabel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25248 | 25248 | 2014-07-31 | 2013-09-17 | Lau | Timothy C | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25249 | 25249 | 2014-07-31 | 2010-09-24 | Naim | Claudia | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25250 | 25250 | 2014-07-31 | 2000-11-21 | Domingo | Roquena R. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25254 | 25254 | 2014-07-31 | 2013-12-04 | Hara | Stacey Zolt | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25255 | 25255 | 2014-07-31 | 2013-12-04 | Verhey | Amy | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25256 | 25256 | 2014-07-31 | 2010-12-09 | Solomon | Angela | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25202 | 25202 | 2014-07-31 | 2014-01-30 | Aziz | A. Fadzli | Malaysian Palm Oil Council (f/k/a American Palm Oil Council) 4575 | 1991-10-04 | Malaysian Palm Oil Council (f/k/a American Palm Oil Council) | 1010 Wisconsin Avenue, NW | Suite 307 | Washington | DC | 20007 |
25201 | 25201 | 2014-07-31 | 2014-01-27 | Horwitz | Seth | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
25220 | 25220 | 2014-07-31 | 2011-05-24 | Orr | John H. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25233 | 25233 | 2014-07-31 | 2013-06-20 | Foster | Stephanie A. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25234 | 25234 | 2014-07-31 | 2013-06-20 | Talbot | James B. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25257 | 25257 | 2014-07-31 | 2013-12-12 | Waters | D. Bruce | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25217 | 25217 | 2014-07-31 | 2014-05-19 | Bagley | Steven | KGlobal 6219 | 2014-04-29 | KGlobal | 1919 M Street, NW | Suite 610 | Washington | DC | 20036 |
25218 | 25218 | 2014-07-31 | 2014-05-19 | DeCleene | Randy | KGlobal 6219 | 2014-04-29 | KGlobal | 1919 M Street, NW | Suite 610 | Washington | DC | 20036 |
25219 | 25219 | 2014-07-31 | 2014-05-19 | Dolan | Charles | KGlobal 6219 | 2014-04-29 | KGlobal | 1919 M Street, NW | Suite 610 | Washington | DC | 20036 |
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]) );