FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
47 rows where "Short_Form_Termination_Date" is on date 2018-12-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date)
Registration_Number 25
- Havas Media Group USA LLC 15
- Italian Government Tourist Board (ENIT), Los Angeles 3
- Bluetext, LLC 3
- Korea Economic Institute 2
- QORVIS LLC 2
- Mer Security and Communication Systems Ltd. 2
- Silversmith Law Offices PLLC 2
- South African Tourism 1
- Office of Tibet 1
- Arnold & Porter Kaye Scholer LLP 1
- Foster Garvey PC 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Daniel J. Edelman, Inc. 1
- Representative of German Industry and Trade 1
- Orion Strategies LLC 1
- Brownstein Hyatt Farber Schreck, LLP 1
- CDN International, Inc. 1
- Portland PR Inc. 1
- Camstoll Group, LLC 1
- Cornerstone Government Affairs 1
- Ashcroft Law Firm, LLC 1
- MMGY Global, LLC 1
- Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 1
- Potomac Square Group 1
- APCO Worldwide LLC 1
Registrant_Name 25
- Havas Media Group USA LLC 15
- Bluetext, LLC 3
- Italian Government Tourist Board (ENIT), Los Angeles 3
- Korea Economic Institute 2
- Mer Security and Communication Systems Ltd. 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
- Ashcroft Law Firm, LLC 1
- Brownstein Hyatt Farber Schreck, LLP 1
- CDN International, Inc. 1
- Camstoll Group, LLC 1
- Cornerstone Government Affairs 1
- Daniel J. Edelman, Inc. 1
- Foster Garvey PC 1
- Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 1
- MMGY Global, LLC 1
- Office of Tibet 1
- Orion Strategies LLC 1
- Portland PR Inc. 1
- Potomac Square Group 1
- Representative of German Industry and Trade 1
- South African Tourism 1
City 11
- Washington 19
- New York 16
- Los Angeles 3
- Holon 2
- Chicago 1
- Denver 1
- Kansas City 1
- Overland Park 1
- Santa Monica 1
- Seattle 1
- Tokyo 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
42180 | 42180 | 2018-12-31 | 2019-02-04 | Belcher | Amanda | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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 |
42182 | 42182 | 2018-12-31 | 2018-04-01 | Corallo | Mark | Ashcroft Law Firm, LLC 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2710 | Kansas City | MO | 64105 |
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 |
42187 | 42187 | 2018-12-31 | 2017-04-28 | Jalil | Adnan | Mer Security and Communication Systems Ltd. 6423 | 2017-04-28 | Mer Security and Communication Systems Ltd. | 5 Hatzoref Street | Holon | |||
42188 | 42188 | 2018-12-31 | 2017-04-28 | Laviv | Omer | Mer Security and Communication Systems Ltd. 6423 | 2017-04-28 | Mer Security and Communication Systems Ltd. | 5 Hatzoref Street | Holon | |||
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 |
42191 | 42191 | 2018-12-31 | 2009-05-19 | Dionisio | Virginia M. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
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 |
42194 | 42194 | 2018-12-31 | 2018-07-20 | Uozumi | Yasuhiro | Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 | 2018-07-20 | Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) | Keidanren Kaikan, 1-3-2 | Otemachi, Chiyoda-ku TOKYO | Tokyo | ||
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 |
42197 | 42197 | 2018-12-31 | 2018-09-28 | Feldman | Mark B. | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | 1111 Third Avenue | Suite 3000 | Seattle | WA | 98101 |
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 | |
42203 | 42203 | 2018-12-31 | 2017-10-17 | Boni | Emanuela | Italian Government Tourist Board (ENIT), Los Angeles 1884 | 1965-04-19 | Italian Government Tourist Board (ENIT), Los Angeles | 10850 Wilshire Boulevard | Suite 575 | Los Angeles | CA | 90024 |
42204 | 42204 | 2018-12-31 | 2017-10-17 | Lanzafame | Fabrizio | Italian Government Tourist Board (ENIT), Los Angeles 1884 | 1965-04-19 | Italian Government Tourist Board (ENIT), Los Angeles | 10850 Wilshire Boulevard | Suite 575 | Los Angeles | CA | 90024 |
42205 | 42205 | 2018-12-31 | 2017-10-17 | Moschini | Cinzia | Italian Government Tourist Board (ENIT), Los Angeles 1884 | 1965-04-19 | Italian Government Tourist Board (ENIT), Los Angeles | 10850 Wilshire Boulevard | Suite 575 | Los Angeles | CA | 90024 |
42206 | 42206 | 2018-12-31 | 2017-11-27 | Yang | Fu-Hua | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
42207 | 42207 | 2018-12-31 | 2017-11-29 | Dalal | Milan | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42208 | 42208 | 2018-12-31 | 2012-12-10 | Davis | Benjamin | Camstoll Group, LLC 6144 | 2012-12-10 | Camstoll Group, LLC | 1112 Montana Avenue | #904 | Santa Monica | CA | 90403 |
42209 | 42209 | 2018-12-31 | 2018-12-21 | Barest | Bonnie | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42210 | 42210 | 2018-12-31 | 2018-12-21 | Bernstein | Diana | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42211 | 42211 | 2018-12-31 | 2018-12-21 | Brown | Aaron N. | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42212 | 42212 | 2018-12-31 | 2018-12-21 | Crowell Eberle | Caroline | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42213 | 42213 | 2018-12-31 | 2018-12-21 | Fernando | Leo Franco | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42214 | 42214 | 2018-12-31 | 2018-12-21 | Isselbacher | Adam | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42215 | 42215 | 2018-12-31 | 2018-12-21 | Joseph Toussaint | Charmaine | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42216 | 42216 | 2018-12-31 | 2018-12-21 | Kanefsky | Jason | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42217 | 42217 | 2018-12-31 | 2018-12-21 | Leach | Russell | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42218 | 42218 | 2018-12-31 | 2018-12-21 | Miller Alper | Tricia | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42219 | 42219 | 2018-12-31 | 2018-12-21 | Panosian | Joseph | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42220 | 42220 | 2018-12-31 | 2018-12-21 | Shahid | Jennah | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42221 | 42221 | 2018-12-31 | 2018-12-21 | Sheffron | Paul | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42222 | 42222 | 2018-12-31 | 2018-12-21 | Stanley | Nichole | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42223 | 42223 | 2018-12-31 | 2018-12-21 | Swindell | Destinee | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 |
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]) );