FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
112 rows where City = "Silver Spring" sorted by Short_Form_First_Name
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28585 | 28585 | 2013-08-31 | 2013-03-14 | Shaw | Sun-wen | Fonte, Michael Joseph 5514 | 2002-08-08 | Fonte, Michael Joseph | 8 Belmont Court | Silver Spring | MD | 20910 | |
38837 | 38837 | 1995-12-20 | 1995-12-20 | Shoenberg | Susan S. | Shoenberg, Susan S. 5090 | 1995-12-20 | Shoenberg, Susan S. | 1808 Briggs Road | Silver Spring | MD | 20906 | |
9995 | 9995 | 2013-03-15 | 2009-03-27 | Tuko | Taha | Front for Independence of Oromia (FIO) 5888 | 2008-10-09 | Front for Independence of Oromia (FIO) | 1110 Chickasaw Dr. | Silver Spring | MD | 20903 | |
31857 | 31857 | 1979-10-01 | 1978-10-18 | Barron | Thea Rossi | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
37385 | 37385 | 1986-12-01 | 1976-04-22 | Floyd | Thomas H. , Jr. | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
34282 | 34282 | 1988-10-31 | 1988-05-04 | Mallonee | Thomas S. | Alan M. Porten & Associates, Inc. 4136 | 1988-05-04 | Alan M. Porten & Associates, Inc. | 8700 Georgia Avenue | Suite 300 | Silver Spring | MD | 20910 |
35741 | 35741 | 1978-11-14 | 1978-01-28 | Scambos | Thomas T. | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
20318 | 20318 | 2000-06-26 | 2000-04-28 | Patrick | Tiffany C. | Maseng Communications 4660 | 1992-05-05 | Maseng Communications | 11309 Baroque Road | Silver Spring | MD | 20901 | |
24136 | 24136 | 1959-07-27 | 1954-07-27 | Metcalfe | Violet | John C. Metcalfe & Associates, Inc. 838 | 1954-07-27 | John C. Metcalfe & Associates, Inc. | 9000 Colesville Road | Post Office Box 308 | Silver Spring | MD | |
4628 | 4628 | 1989-01-27 | 1983-08-02 | Lampley | Virginia A. | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
34885 | 34885 | 1982-11-01 | 1976-06-04 | Weitzen | William | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
15619 | 15619 | 1989-05-03 | 1977-01-31 | Reynolds | William A. | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 |
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]) );