FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Termination_Date = "2015-02-28"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 8
Registrant_Name 8
City 5
- Washington 6
- New York 3
- Bannockburn 1
- Los Angeles 1
- Philadelphia 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8284 | 8284 | 2015-02-28 | 2015-02-09 | Feldman | Dennis | Ceisler Media & Issue Advocacy, LLC 6266 | 2014-12-19 | Ceisler Media & Issue Advocacy, LLC | 1525 Locust Street, 6th Floor | Philadelphia | PA | 19102 | |
8285 | 8285 | 2015-02-28 | 2011-03-30 | Smith | Brian | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
8286 | 8286 | 2015-02-28 | 2014-05-08 | Hertling | Richard | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
8287 | 8287 | 2015-02-28 | 2011-05-25 | Lee | Sung Gi | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
8288 | 8288 | 2015-02-28 | 2014-06-02 | Berman | Howard | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
8289 | 8289 | 2015-02-28 | 2015-06-05 | Fitzgerald | MaryClare | DUTKO WORLDWIDE, LLC DBA GRAYLING 6270 | 2015-01-15 | DUTKO WORLDWIDE, LLC DBA GRAYLING | 100 M Street, SE | Suite 500 | Washington | DC | 20003 |
8290 | 8290 | 2015-02-28 | 2013-06-10 | Lai | Erica | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
8291 | 8291 | 2015-02-28 | 2013-06-24 | Wichterman | William | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
8292 | 8292 | 2015-02-28 | 2013-06-25 | Choi | Sung Won | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 625 South Kingsley Drive | 4th Floor | Los Angeles | CA | 90005 |
8293 | 8293 | 2015-02-28 | 2010-07-13 | Hughes | Sarah-Anne | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
8294 | 8294 | 2015-02-28 | 2013-10-23 | Lim | Wey-Len | 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 |
8295 | 8295 | 2015-02-28 | 2010-11-17 | Winterstrid | Maria | VisitSweden 4885 | 1994-01-26 | VisitSweden | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
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]) );