FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Short_Form_Termination_Date" is on date 2005-05-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_2, Zip
Registration_Number 6
Registrant_Name 6
City 5
- New York 4
- Washington 4
- El Cerrito 2
- Minneapolis 2
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17979 | 17979 | 2005-05-31 | 2005-01-21 | Malec | Eric | Lumina Strategies 5624 | 2004-05-20 | Lumina Strategies | 3020 El Cerrito Plaza | Suite 113 | El Cerrito | CA | 94530 |
17980 | 17980 | 2005-05-31 | 2005-01-26 | Fazio | Victor H. | Clark & Weinstock 5617 | 2004-04-23 | Clark & Weinstock | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
17981 | 17981 | 2005-05-31 | 1999-03-08 | Shum | Lily | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
17982 | 17982 | 2005-05-31 | 1993-03-12 | Haberman | Nancy | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
17983 | 17983 | 2005-05-31 | 1993-03-12 | Rubenstein | Howard J. | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
17984 | 17984 | 2005-05-31 | 1993-03-12 | Rubenstein | Steven | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
17985 | 17985 | 2005-05-31 | 2005-04-22 | Morrison | Timothy J. | Clark & Weinstock 5617 | 2004-04-23 | Clark & Weinstock | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
17986 | 17986 | 2005-05-31 | 2004-04-23 | Glover Weiss | Juleanna R. | Clark & Weinstock 5617 | 2004-04-23 | Clark & Weinstock | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
17987 | 17987 | 2005-05-31 | 2004-05-20 | Shellenberger | Michael | Lumina Strategies 5624 | 2004-05-20 | Lumina Strategies | 3020 El Cerrito Plaza | Suite 113 | El Cerrito | CA | 94530 |
17988 | 17988 | 2005-05-31 | 2001-10-15 | Keaney | Thomas M. | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
17989 | 17989 | 2005-05-31 | 2004-11-04 | Ngang | Edith M. | Ambazonia Liberation Party (ALIP) 5655 | 2004-11-04 | Ambazonia Liberation Party (ALIP) | 18th North, 4th Street | Suite 704 | Minneapolis | MN | 55401 |
17990 | 17990 | 2005-05-31 | 2004-11-04 | Ngang | Edwin N. | Ambazonia Liberation Party (ALIP) 5655 | 2004-11-04 | Ambazonia Liberation Party (ALIP) | 18th North, 4th Street | Suite 704 | Minneapolis | MN | 55401 |
17991 | 17991 | 2005-05-31 | 2006-11-13 | Worlie | Paul | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
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]) );