FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Registrant_Name = "Mullen", Registration_Number = 5512, Short_Form_Date = "2007-09-27" and State = "MA"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date)
State 1
- MA · 10 ✖
Registration_Number 1
- Mullen · 10 ✖
Registrant_Name 1
- Mullen · 10 ✖
City 1
- Wenham 10
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 | |
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]) );