FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Termination_Date = "2009-10-31"
This data as json, CSV (advanced)
Suggested facets: Address_2, Registration_Date (date)
Registration_Number 8
Registrant_Name 8
City 5
- Washington 3
- New York 2
- Falls Church 1
- Halifax 1
- St. Louis 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34581 | 34581 | 2009-10-31 | 2009-04-06 | Coulanges | Ashley | Moffett Group, LLC 5802 | 2007-04-17 | Moffett Group, LLC | 1801 18th Street, NW | Suite 9 | Washington | DC | 20009 |
34582 | 34582 | 2009-10-31 | 2007-04-16 | Church | Cynthia Renee | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
34583 | 34583 | 2009-10-31 | 2008-05-06 | Nunneley | Devon | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
34584 | 34584 | 2009-10-31 | 2008-05-30 | Conconi | Charles N. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
34585 | 34585 | 2009-10-31 | 2007-06-01 | Dowdall | Emmanuel | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
34586 | 34586 | 2009-10-31 | 2002-07-18 | Boyd | Robert W,. | Nova Scotia Information Centre 3078 | 1979-12-18 | Nova Scotia Information Centre | 1800 Argyle Street Suite 603 | Box 456 | Halifax | ||
34587 | 34587 | 2009-10-31 | 2009-09-30 | Smith | Gordon | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 850 Tenth Street, NW | Washington | DC | 20001 | |
34588 | 34588 | 2009-10-31 | 2008-10-09 | Footlik | Jay | Footlik, Jay 5886 | 2008-10-09 | Footlik, Jay | 3035 Meeting Street | Falls Church | VA | 22044 |
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]) );