FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Short_Form_Date" is on date 2013-07-26
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16481 | 16481 | 2014-05-15 | 2013-07-26 | Kraushar | Elizabeth | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
22352 | 22352 | 2013-07-01 | 2013-07-26 | Wright | Shawn | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | Watergate Office Building | 600 New Hampshire Avenue, NW | Washington | DC | 20037 |
24336 | 24336 | 2017-07-28 | 2013-07-26 | Meszaros | James A. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
25415 | 25415 | 2022-07-31 | 2013-07-26 | Sukthavorn | Proud | Tourism Authority of Thailand, Los Angeles 2178 | 1969-12-19 | Tourism Authority of Thailand, Los Angeles | 611 North Larchmont Boulevard | 1st Floor | Los Angeles | CA | 90004 |
32284 | 32284 | 2014-10-04 | 2013-07-26 | Zabell | Melissa | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
35238 | 35238 | 2010-11-04 | 2013-07-26 | Payne | Sarah | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41944 | 41944 | 2014-12-31 | 2013-07-26 | Drucker | Cynthia R. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41945 | 41945 | 2014-12-31 | 2013-07-26 | Findlen | Sean T. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41946 | 41946 | 2014-12-31 | 2013-07-26 | Grasso | Jeanne M. | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | Watergate Office Building | 600 New Hampshire Avenue, NW | Washington | DC | 20037 |
41947 | 41947 | 2014-12-31 | 2013-07-26 | Isaf | John | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41948 | 41948 | 2014-12-31 | 2013-07-26 | McNerney | Griff | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41949 | 41949 | 2014-12-31 | 2013-07-26 | Peranich | Stephen | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | Watergate Office Building | 600 New Hampshire Avenue, NW | Washington | DC | 20037 |
41950 | 41950 | 2014-12-31 | 2013-07-26 | Pimentel | Paul | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41951 | 41951 | 2014-12-31 | 2013-07-26 | Price | Gregory Field | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41952 | 41952 | 2014-12-31 | 2013-07-26 | Rambo | Katherine | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41953 | 41953 | 2014-12-31 | 2013-07-26 | Reddin | Katy | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
41954 | 41954 | 2014-12-31 | 2013-07-26 | Waldron | Jon | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | Watergate Office Building | 600 New Hampshire Avenue, NW | Washington | DC | 20037 |
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]) );