FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Short_Form_Last_Name = "Simpson"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 16
- Ogilvy Public Relations Worldwide 2
- British Information Services 1
- New Zealand Central Reservations Office 1
- German Federal Railroad 1
- Squire Patton Boggs, LLP 1
- Hogan Lovells US LLP 1
- Korea Trade Center, Los Angeles 1
- Daniel J. Edelman, Inc. 1
- Welsh Development Agency 1
- YHDA International 1
- McKinney & McDowell Associates 1
- Morgan Meguire, LLC 1
- Mercury Public Affairs, LLC 1
- MMGY Global, LLC 1
- Myriad International Marketing, LLC 1
- Ogilvy Group LLC 1
Registrant_Name 16
- Ogilvy Public Relations Worldwide 2
- British Information Services 1
- Daniel J. Edelman, Inc. 1
- German Federal Railroad 1
- Hogan Lovells US LLP 1
- Korea Trade Center, Los Angeles 1
- MMGY Global, LLC 1
- McKinney & McDowell Associates 1
- Mercury Public Affairs, LLC 1
- Morgan Meguire, LLC 1
- Myriad International Marketing, LLC 1
- New Zealand Central Reservations Office 1
- Ogilvy Group LLC 1
- Squire Patton Boggs, LLP 1
- Welsh Development Agency 1
- YHDA International 1
City 6
- Washington 7
- New York 4
- Los Angeles 2
- Overland Park 2
- Chicago 1
- Concord 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3285 | 3285 | 1995-01-06 | 1993-06-21 | Simpson | Karlene | McKinney & McDowell Associates 4516 | 1991-05-28 | McKinney & McDowell Associates | 1730 Rhode Island Avenue, N.W. | Suite 717 | Washington | DC | 20036 |
3703 | 3703 | 1983-01-14 | 1979-03-05 | Simpson | Roger | New Zealand Central Reservations Office 672 | 1951-04-23 | New Zealand Central Reservations Office | 6033 West Century Boulevard | Suite 1270 | Los Angeles | CA | 90045 |
4329 | 4329 | 2015-01-23 | 2014-12-17 | Simpson | Charles Kyle | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8888 | 8888 | 2013-03-01 | 2012-06-29 | Simpson | Lauren | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
10354 | 10354 | 1954-03-20 | 1954-02-05 | Simpson | Frank E. W. | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
12131 | 12131 | 2013-03-31 | 2012-06-29 | Simpson | Kendra | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12976 | 12976 | 2021-04-08 | 2021-03-10 | Simpson | Sarah | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
14774 | 14774 | 1998-04-30 | 1998-06-08 | Simpson | Deirdre | YHDA International 4421 | 1990-10-12 | YHDA International | 28 Junction Square | Concord | MA | 01742 | |
15460 | 15460 | 2002-05-01 | 1991-02-22 | Simpson | Teri L. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
16487 | 16487 | 2019-05-15 | 2018-06-29 | Simpson | Crystalyn | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
16489 | 16489 | 2019-05-15 | 2018-12-18 | Simpson | Crystalyn | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
19688 | 19688 | 2000-06-16 | 1992-01-31 | Simpson | Robert Ivor | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
25025 | 25025 | 2003-07-31 | 2003-05-15 | Simpson | C. Kyle | Morgan Meguire, LLC 5560 | 2003-05-15 | Morgan Meguire, LLC | 1225 I Street, N.W. | Suite 300 | Washington | DC | 20005 |
36208 | 36208 | 1982-11-22 | 1980-04-09 | Simpson | Cindy | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
37136 | 37136 | 2019-11-30 | 2018-08-16 | Simpson | Al | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
38651 | 38651 | 2000-12-18 | 1995-05-12 | Simpson | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
40409 | 40409 | 1987-12-31 | 1986-06-13 | Simpson | Teresa J. | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
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]) );