FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Short_Form_First_Name = "Joseph R."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Date (date)
Registration_Number 13
- Columbus Lighthouse Committee of America 2
- DDB Worldwide Communications Group, Inc. 1
- Eastern News Distributors, Inc. 1
- Association Films, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Cayman Islands Department of Tourism 1
- Shaw, Pittman, Potts & Trowbridge 1
- Mayer, Brown & Platt 1
- Armstrong, Teasdale, Kramer & Vaughan 1
- DLA Piper US LLP 1
- Lord Group 1
- Public Strategies, Inc. 1
- Public Strategies, Inc. 1
Registrant_Name 12
- Columbus Lighthouse Committee of America 2
- Public Strategies, Inc. 2
- Armstrong, Teasdale, Kramer & Vaughan 1
- Association Films, Inc. 1
- Cayman Islands Department of Tourism 1
- DDB Worldwide Communications Group, Inc. 1
- DLA Piper US LLP 1
- Eastern News Distributors, Inc. 1
- Lord Group 1
- Mayer, Brown & Platt 1
- Milbank, Tweed, Hadley & McCloy 1
- Shaw, Pittman, Potts & Trowbridge 1
City 5
- New York 6
- Washington 3
- Austin 2
- Warwick 2
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5246 | 5246 | 2001-01-31 | 2000-08-22 | Dickie | Joseph R. | Public Strategies, Inc. 4928 | 1994-07-15 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 900 | Austin | TX | 78701 |
6544 | 6544 | 1992-02-10 | 1977-03-01 | Siphron | Joseph R. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
10076 | 10076 | 2002-03-16 | 1971-10-01 | Daly | Joseph R. | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
10465 | 10465 | 1994-03-21 | 1992-10-19 | Egan | Joseph R. | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | 2300 N Street, N.W. | Washington | DC | 20037-1128 | |
14197 | 14197 | 1993-04-27 | 1991-09-19 | Apablaza | Joseph R. | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
22760 | 22760 | 1985-07-08 | 1983-07-27 | Hall | Joseph R. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
23209 | 23209 | 1980-07-15 | 1973-07-10 | Pope | Joseph R. | Eastern News Distributors, Inc. 1796 | 1964-10-01 | Eastern News Distributors, Inc. | 111 Eighth Avenue | New York | NY | 10011 | |
24834 | 24834 | 1991-07-31 | 1989-09-18 | Goeke | Joseph R. | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | 2000 Pennsylvania Avenue, N.W. | Washington | DC | 20006-1882 | |
30044 | 30044 | 1977-09-19 | 1971-03-02 | Muratore | Joseph R. | Columbus Lighthouse Committee of America 2163 | 1969-09-24 | Columbus Lighthouse Committee of America | 766 West Shore Road | Post Office Box 486 | Warwick | RI | 02889 |
30054 | 30054 | 1977-09-19 | 1969-09-24 | Muratore | Joseph R. | Columbus Lighthouse Committee of America 2163 | 1969-09-24 | Columbus Lighthouse Committee of America | 766 West Shore Road | Post Office Box 486 | Warwick | RI | 02889 |
31285 | 31285 | 2002-09-30 | 2002-02-14 | Dickie | Joseph R. | Public Strategies, Inc. 5472 | 2002-02-14 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 900 | Austin | TX | 78701 |
34170 | 34170 | 1970-10-31 | 1968-05-07 | Liebich | Joseph R. | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
36110 | 36110 | 1984-11-20 | 1983-04-20 | Niemann | Joseph R. | Armstrong, Teasdale, Kramer & Vaughan 3461 | 1983-04-20 | Armstrong, Teasdale, Kramer & Vaughan | 611 Olive Street | Suite 1900 | St. Louis | MO | 63101 |
37392 | 37392 | 1987-12-01 | 1985-12-09 | Lowry | Joseph R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 |
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]) );