FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Short_Form_Date = "2007-09-27"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8550 | 8550 | 2008-02-29 | 2007-09-27 | Berard | Nicole | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8551 | 8551 | 2008-02-29 | 2007-09-27 | Frazier | Liz | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8552 | 8552 | 2008-02-29 | 2007-09-27 | Madden | Christian | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8553 | 8553 | 2008-02-29 | 2007-09-27 | Mangus | Catherine E. | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8554 | 8554 | 2008-02-29 | 2007-09-27 | Mellgren | Erik | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8555 | 8555 | 2008-02-29 | 2007-09-27 | Merke | Tonya | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8556 | 8556 | 2008-02-29 | 2007-09-27 | Puls | Colleen | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8557 | 8557 | 2008-02-29 | 2007-09-27 | Russell | Adam | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8558 | 8558 | 2008-02-29 | 2007-09-27 | Sumner | Sarah | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 | |
8873 | 8873 | 2009-03-01 | 2007-09-27 | Livingston | Robert L. | PLM Group, LLC 5825 | 2007-08-20 | PLM Group, LLC | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
8874 | 8874 | 2009-03-01 | 2007-09-27 | Podesta | Anthony T. | PLM Group, LLC 5825 | 2007-08-20 | PLM Group, LLC | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
18010 | 18010 | 2006-05-31 | 2007-09-27 | Columbus | R. Timothy | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18011 | 18011 | 2006-05-31 | 2007-09-27 | Cunningham | Richard O. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18012 | 18012 | 2006-05-31 | 2007-09-27 | Fremlin | Grace Parke | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18013 | 18013 | 2006-05-31 | 2007-09-27 | Kantor | Douglas S. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18014 | 18014 | 2006-05-31 | 2007-09-27 | Maloney | Robert | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
33087 | 33087 | 2007-10-17 | 2007-09-27 | Desmond | Katherin | Mullen 5512 | 2002-08-01 | Mullen | 36 Essex Street | Wenham | MA | 01984 |
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]) );