FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Short_Form_Last_Name = "Pearson"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 14
- South African Tourism 2
- VisitBritain 1
- Quebec Government Office 1
- Clinton, Moats, Anderson & Fleck, Attorneys at Law 1
- Clinton, Fleck, Glein & Brown 1
- LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1
- Pearson Sandor Associates 1
- Scottish Enterprise 1
- AbramsonEhrlichManes, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Pearson & Pipkin, Inc. 1
- GCI Group, Inc. 1
- Spectrum Group Members, LLC 1
- Pearson & Associates 1
Registrant_Name 14
- South African Tourism 2
- AbramsonEhrlichManes, Inc. 1
- Clinton, Fleck, Glein & Brown 1
- Clinton, Moats, Anderson & Fleck, Attorneys at Law 1
- GCI Group, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- LeBoeuf, Lamb, Greene & MacRae, L.L.P. 1
- Pearson & Associates 1
- Pearson & Pipkin, Inc. 1
- Pearson Sandor Associates 1
- Quebec Government Office 1
- Scottish Enterprise 1
- Spectrum Group Members, LLC 1
- VisitBritain 1
City 6
- New York 5
- Washington 5
- Seattle 2
- Alexandria 1
- Cambridge 1
- Coral Gables 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4593 | 4593 | 2018-01-26 | 2013-10-09 | Pearson | Meredith | VisitBritain 579 | 1949-07-07 | VisitBritain | 885 Second Avenue | 28th Floor | New York | NY | 10017 |
4696 | 4696 | 1991-01-28 | 1989-06-01 | Pearson | Toni | AbramsonEhrlichManes, Inc. 3103 | 1980-04-30 | AbramsonEhrlichManes, Inc. | 1275 K Street, N.W. | Suite 300 | Washington | DC | 20005 |
13335 | 13335 | 2006-04-14 | 2004-10-14 | Pearson | Lance | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
15339 | 15339 | 1978-05-01 | 1978-02-23 | Pearson | Russell R. | Clinton, Fleck, Glein & Brown 2865 | 1978-02-23 | Clinton, Fleck, Glein & Brown | 2112 Third Avenue | Suite 500 | Seattle | WA | 98121 |
15745 | 15745 | 1982-05-05 | 1978-07-03 | Pearson | David | Pearson Sandor Associates 2924 | 1978-07-03 | Pearson Sandor Associates | 1450 Madruga Avenue | Suite 405 | Coral Gables | FL | 33146 |
20324 | 20324 | 2008-06-26 | 2007-03-08 | Pearson | Zakee A. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21649 | 21649 | 2009-06-30 | 2008-12-01 | Pearson | William R. | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 11 Canal Center Plaza | Suite 103 | Alexandria | VA | 22314 |
26974 | 26974 | 2000-08-18 | 1998-11-30 | Pearson | Catherine | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
27589 | 27589 | 1991-08-28 | 1985-08-29 | Pearson | Ronald W. | Pearson & Pipkin, Inc. 3727 | 1985-08-29 | Pearson & Pipkin, Inc. | 422 - 1st Street, S.E. | Suite 208 | Washington | DC | 20003 |
29095 | 29095 | 1971-09-03 | 1956-07-30 | Pearson | Oscar Edward | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
31308 | 31308 | 2003-09-30 | 2003-02-25 | Pearson | Robert | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
37666 | 37666 | 1971-12-03 | 1971-12-03 | Pearson | Russell R. | Clinton, Moats, Anderson & Fleck, Attorneys at Law 2292 | 1971-12-03 | Clinton, Moats, Anderson & Fleck, Attorneys at Law | 500 Third & Lenora Building | Seattle | WA | 98121 | |
38447 | 38447 | 2015-12-15 | 2012-08-30 | Pearson | Rachel | Pearson & Associates 6129 | 2012-08-30 | Pearson & Associates | 1111 19th Street, NW | Suite 1100 | Washington | DC | 20036 |
39896 | 39896 | 1971-12-31 | 1971-05-26 | Pearson | Oscar E. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40653 | 40653 | 1990-12-31 | 1983-12-06 | Pearson | James B. | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | 1875 Connecticut Avenue, N.W. | Suite 1200 | Washington | DC | 20009-5728 |
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]) );