FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_First_Name = "Kent"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 9
Registrant_Name 8
City 5
- Washington 6
- Austin 2
- Chicago 2
- New York 1
- Silver Spring 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1758 | 1758 | 2019-09-10 | Yalowitz | Kent | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | ||
1946 | 1946 | 2022-10-12 | Swig | Kent | Visit Mexico USA, LLC 7184 | 2022-10-12 | Visit Mexico USA, LLC | 444 Madison Avenue | Suite 300 | New York | NY | 10022 | |
4568 | 4568 | 1993-01-26 | 1992-08-25 | Killelea | Kent | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
6763 | 6763 | 2023-02-13 | 2020-05-28 | Bressie | Kent | HWG LLP 6831 | 2020-05-28 | HWG LLP | 1919 M Street, NW | Suite 800 | Washington | DC | 20036 |
15709 | 15709 | 1995-05-04 | 1986-05-19 | Montavon | Kent | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
18541 | 18541 | 2010-06-01 | 2009-08-14 | Jarrell | Kent | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
18575 | 18575 | 2016-06-01 | 2015-10-08 | Caperton | Kent | Ben Barnes Group 6322 | 2015-10-08 | Ben Barnes Group | 1003 Rio Grande | Austin | TX | 78701 | |
19322 | 19322 | 2015-06-12 | 2014-12-03 | Caperton | Kent | Ben Barnes Group 6264 | 2014-12-03 | Ben Barnes Group | 1003 Rio Grande | Austin | TX | 78701 | |
22404 | 22404 | 2022-07-01 | 2020-07-30 | Holland | Kent | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
35015 | 35015 | 2011-11-01 | 2010-08-31 | Caperton | Kent | Sharp & Barnes, LLP 6000 | 2010-08-31 | Sharp & Barnes, LLP | 1215 19th Street, NW | Washington | DC | 20036-2401 | |
42012 | 42012 | 2015-12-31 | 1990-12-12 | Yalowitz | Kent | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
42375 | 42375 | 2021-12-31 | 2022-01-31 | Hlolland | Kent | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
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]) );