FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "Rice"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date)
Registration_Number 9
Registrant_Name 9
City 6
- Washington 5
- Chicago 2
- Los Angeles 1
- Miami 1
- Pasadena 1
- St. Louis 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
936 | 936 | 2020-04-30 | Rice | Rebecca | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
1330 | 1330 | 2023-06-29 | Rice | Sydney | S-3 Group 6422 | 2017-04-26 | S-3 Group | 418 C Street, NE | Washington | DC | 20002 | ||
3317 | 3317 | 2023-01-06 | 2022-10-07 | Rice | Karen | Wagstaff Worldwide Public Relations, Inc. 7179 | 2022-10-07 | Wagstaff Worldwide Public Relations, Inc. | 5443 Fountain Avenue | Los Angeles | CA | 90029 | |
6980 | 6980 | 2012-02-15 | 2008-09-23 | Rice | Theresa J. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
9813 | 9813 | 1973-03-14 | 1962-03-09 | Rice | Francis Xavier | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
14381 | 14381 | 2011-04-29 | 2010-04-28 | Rice | Emily | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
21912 | 21912 | 2018-06-30 | 2017-10-05 | Rice | Theresa | Burson-Marsteller, LLC (Miami Office) 6223 | 2014-05-20 | Burson-Marsteller, LLC (Miami Office) | 601 Brickell Key Drive | Suite 900 | Miami | FL | 33131 |
24389 | 24389 | 2009-07-29 | 2008-08-07 | Rice | Andrew | Mark Saylor Company, LLC 5827 | 2007-09-07 | Mark Saylor Company, LLC | 931 East Walnut Street | Suite 203 | Pasadena | CA | 91106 |
25702 | 25702 | 2015-08-01 | 2012-06-06 | Rice | Rebecca | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28493 | 28493 | 2007-08-31 | 2004-03-01 | Rice | Theresa | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
34080 | 34080 | 1998-10-30 | 1997-02-13 | Rice | Julie R. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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]) );