FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where City = "Washington" and "Short_Form_Termination_Date" is on date 2018-12-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 14
- Bluetext, LLC 3
- Korea Economic Institute 2
- QORVIS LLC 2
- Silversmith Law Offices PLLC 2
- Office of Tibet 1
- Arnold & Porter Kaye Scholer LLP 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Representative of German Industry and Trade 1
- Orion Strategies LLC 1
- CDN International, Inc. 1
- Portland PR Inc. 1
- Cornerstone Government Affairs 1
- Potomac Square Group 1
- APCO Worldwide LLC 1
Registrant_Name 14
- Bluetext, LLC 3
- Korea Economic Institute 2
- QORVIS LLC 2
- Silversmith Law Offices PLLC 2
- APCO Worldwide LLC 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Arnold & Porter Kaye Scholer LLP 1
- CDN International, Inc. 1
- Cornerstone Government Affairs 1
- Office of Tibet 1
- Orion Strategies LLC 1
- Portland PR Inc. 1
- Potomac Square Group 1
- Representative of German Industry and Trade 1
State 1
- DC 19
City 1
- Washington · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42177 | 42177 | 2018-12-31 | 2017-01-20 | Murray | Mark | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 |
42178 | 42178 | 2018-12-31 | 1982-01-28 | Schneider | Lawrence A. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
42179 | 42179 | 2018-12-31 | 2019-01-28 | Petersen | Thor | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
42181 | 42181 | 2018-12-31 | 1993-03-09 | Park | Yoon S. | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
42183 | 42183 | 2018-12-31 | 2009-04-09 | Scheunemann | Randy | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 6331 Western Avenue, NW | Washington | DC | 20015 | |
42184 | 42184 | 2018-12-31 | 2018-04-19 | Curtis | David | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 805 15th St NW | Floor 3 | Washington | DC | 20005 |
42185 | 42185 | 2018-12-31 | 2018-04-25 | Celotta | Sam | Bluetext, LLC 6546 | 2018-04-25 | Bluetext, LLC | 2121 Wisconsin Avenue, NW | Suite 320 | Washington | DC | 20007 |
42186 | 42186 | 2018-12-31 | 2018-04-25 | Goldberg | Don | Bluetext, LLC 6546 | 2018-04-25 | Bluetext, LLC | 2121 Wisconsin Avenue, NW | Suite 320 | Washington | DC | 20007 |
42189 | 42189 | 2018-12-31 | 2016-04-29 | Akhonbay | Nedda | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
42190 | 42190 | 2018-12-31 | 2016-05-17 | Hyun | Oh-Seok | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
42192 | 42192 | 2018-12-31 | 2010-06-28 | Rego | Alexandre Pinheiro | CDN International, Inc. 5992 | 2010-06-28 | CDN International, Inc. | 1717 K Street, NW | Suite 900 | Washington | DC | 20006 |
42193 | 42193 | 2018-12-31 | 2018-07-18 | Cooper | Christopher | Potomac Square Group 6576 | 2018-07-18 | Potomac Square Group | 1509 16th Street, NW | Suite 407 | Washington | DC | 20036 |
42195 | 42195 | 2018-12-31 | 2018-08-22 | Goldman | Kevin | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
42196 | 42196 | 2018-12-31 | 2018-08-30 | Baire | Adiam | Representative of German Industry and Trade 4274 | 1989-07-21 | Representative of German Industry and Trade | 1130 Connecticut Avenue, NW | Suite 1200 | Washington | DC | 20036 |
42198 | 42198 | 2018-12-31 | 2018-10-01 | Noel | Matthew R | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
42199 | 42199 | 2018-12-31 | 2018-10-02 | Cristi | Amanda | Bluetext, LLC 6546 | 2018-04-25 | Bluetext, LLC | 2121 Wisconsin Avenue, NW | Suite 320 | Washington | DC | 20007 |
42200 | 42200 | 2018-12-31 | 2018-10-10 | Palkyi | Tenzin | Office of Tibet 1699 | 1964-03-14 | Office of Tibet | 1228 17th Street, NW | Washington | DC | 20036 | |
42201 | 42201 | 2018-12-31 | 2018-10-11 | Jolly | Stuart | Silversmith Law Offices PLLC 6597 | 2018-10-03 | Silversmith Law Offices PLLC | 1730 Rhode Island Avenue NW, #1005 | Washington | DC | 20036 | |
42202 | 42202 | 2018-12-31 | 2018-10-11 | Silversmith | Gary | Silversmith Law Offices PLLC 6597 | 2018-10-03 | Silversmith Law Offices PLLC | 1730 Rhode Island Avenue NW, #1005 | 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]) );