FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where "Short_Form_Termination_Date" is on date 2010-08-31
This data as json, CSV (advanced)
Suggested facets: Address_2
Registration_Number 9
Registrant_Name 9
City 7
- Philadelphia 10
- Chicago 2
- New York 2
- Washington 2
- Columbia 1
- Little Rock 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28544 | 28544 | 2010-08-31 | 2009-01-31 | Ng | Chong-Keat | 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 |
28545 | 28545 | 2010-08-31 | 2009-02-04 | Martin | David | Cranford Johnson Robinson Woods, Inc. 5905 | 2009-02-04 | Cranford Johnson Robinson Woods, Inc. | 303 W. Capitol Center | Capitol Avenue | Little Rock | AR | 72201 |
28546 | 28546 | 2010-08-31 | 2010-02-18 | Henriksen | Andrea Storm | VisitDenmark 634 | 1950-07-25 | VisitDenmark | 655 Third Avenue | 18th Floor, Suite 2010 | New York | NY | 10017 |
28547 | 28547 | 2010-08-31 | 2004-03-25 | Brandsdorfer | Louis | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28548 | 28548 | 2010-08-31 | 2004-03-25 | Ditton | Jill | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28549 | 28549 | 2010-08-31 | 2004-03-25 | Lefton | Al Paul Jr., | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28550 | 28550 | 2010-08-31 | 2004-03-25 | Orr | John H. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28551 | 28551 | 2010-08-31 | 2004-03-25 | Scanlon | Raymond D. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28552 | 28552 | 2010-08-31 | 2004-03-25 | Sharkey | Darlene M. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28553 | 28553 | 2010-08-31 | 2004-03-25 | Waters | D. Bruce | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28554 | 28554 | 2010-08-31 | 2004-03-25 | Yarrow | Steven E. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28555 | 28555 | 2010-08-31 | 2009-04-10 | Wilkins | Robert Whitley | Nelson Mullins Riley & Scarborough, LLP 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 1320 Main Street | 17th Floor | Columbia | SC | 29201 |
28556 | 28556 | 2010-08-31 | 2008-05-06 | Foster | Stephanie | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28557 | 28557 | 2010-08-31 | 2009-05-07 | Talbot | James E. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28558 | 28558 | 2010-08-31 | 2009-06-09 | Lackey | Michiru | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
28559 | 28559 | 2010-08-31 | 2010-09-01 | Green | Tai | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28560 | 28560 | 2010-08-31 | 2010-09-01 | Gutman | Beata | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28561 | 28561 | 2010-08-31 | 2009-09-28 | Hamidi | Yasmin | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | 1010 Vermont Avenue, NW | Suite 1100 | Washington | DC | 20005 |
28562 | 28562 | 2010-08-31 | 2005-11-29 | Huenemann | Jon E. | Miller & Chevalier, Chartered 5365 | 2000-04-03 | Miller & Chevalier, Chartered | 655 Fifteenth Street, N.W. | Suite 900 - Metropolitan Square | Washington | DC | 20005-5701 |
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]) );