FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Swanson"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
446 | 446 | 2009-02-24 | Swanson | Stacy A. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | ||
6893 | 6893 | 1961-02-15 | 1959-06-15 | Swanson | Sandra Charlotte | Kangles, Constantine N. 1237 | 1959-06-15 | Kangles, Constantine N. | 100 North La Salle Street | Chicago | IL | ||
9530 | 9530 | 2005-03-09 | 2003-05-01 | Swanson | Melissa Anne | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
18303 | 18303 | 1948-06-01 | 1947-12-01 | Swanson | Hans Adolph | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
20430 | 20430 | 1991-06-28 | 1968-01-09 | Swanson | Edwin Leroy | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
27615 | 27615 | 2015-08-28 | 2015-06-05 | Swanson | Kevin Christopher Orth | DUTKO WORLDWIDE, LLC DBA GRAYLING 6270 | 2015-01-15 | DUTKO WORLDWIDE, LLC DBA GRAYLING | 100 M Street, SE | Suite 500 | Washington | DC | 20003 |
32513 | 32513 | 1992-10-09 | 1980-03-28 | Swanson | David W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );