FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Short_Form_Last_Name = "Stern"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 20
- Teddy Kollek for Mayor 2
- Teddy Kollek for Mayor 2
- Squire, Sanders & Dempsey, L.L.P. 1
- Ruder Finn, Inc. 1
- Fred Rosen Associates, Inc. 1
- Artley, Inc. 1
- Dickstein Shapiro, LLP 1
- Hill and Knowlton Strategies, LLC 1
- Korea Economic Institute 1
- Wilmer, Cutler & Pickering 1
- DLA Piper US LLP 1
- R. Duffy Wall & Associates, Inc. 1
- Sawyer Miller Group 1
- Winthrop, Stimson, Putnam & Roberts, Washington Office 1
- McKenna & Cuneo 1
- Hughes, Hubbard & Reed 1
- Washington Media Group, Inc. 1
- Burson-Marsteller, LLC (Miami Office) 1
- New Partners Consulting, Inc. 1
- NP Consulting Inc. 1
Registrant_Name 19
- Teddy Kollek for Mayor 4
- Artley, Inc. 1
- Burson-Marsteller, LLC (Miami Office) 1
- DLA Piper US LLP 1
- Dickstein Shapiro, LLP 1
- Fred Rosen Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Hughes, Hubbard & Reed 1
- Korea Economic Institute 1
- McKenna & Cuneo 1
- NP Consulting Inc. 1
- New Partners Consulting, Inc. 1
- R. Duffy Wall & Associates, Inc. 1
- Ruder Finn, Inc. 1
- Sawyer Miller Group 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Washington Media Group, Inc. 1
- Wilmer, Cutler & Pickering 1
- Winthrop, Stimson, Putnam & Roberts, Washington Office 1
City 4
- Washington 12
- New York 8
- Washington 1
- Miami 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
47 | 47 | Stern | Cara Morris | NP Consulting Inc. 7301 | 2023-08-01 | NP Consulting Inc. | 1100 G Street, NW | Suite 750 | Washington | DC | 20005 | ||
4763 | 4763 | 1993-01-29 | 1991-06-20 | Stern | Carole | McKenna & Cuneo 4530 | 1991-06-20 | McKenna & Cuneo | 1575 I Street, N.W. | Washington | DC | 20005 | |
5512 | 5512 | 2016-01-31 | 2015-12-17 | Stern | Cara Morris | New Partners Consulting, Inc. 6330 | 2015-12-17 | New Partners Consulting, Inc. | 1250 I Street, NW | Suite 200 | Washington | DC | 20005 |
7339 | 7339 | 1991-02-21 | 1989-02-07 | Stern | Paula | Winthrop, Stimson, Putnam & Roberts, Washington Office 3873 | 1986-08-21 | Winthrop, Stimson, Putnam & Roberts, Washington Office | 1133 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
7376 | 7376 | 1990-02-22 | 1982-02-01 | Stern | Thomas | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
7974 | 7974 | 1991-02-28 | 1990-04-27 | Stern | Ava | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
8766 | 8766 | 1988-03-01 | 1986-03-07 | Stern | Samuel A. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
10460 | 10460 | 1994-03-21 | 1993-08-12 | Stern | Isaac | Teddy Kollek for Mayor 4828 | 1993-07-09 | Teddy Kollek for Mayor | 635 Madison Avenue | New York | NY | 10022 | |
10461 | 10461 | 1994-03-21 | 1993-08-12 | Stern | Vera | Teddy Kollek for Mayor 4828 | 1993-07-09 | Teddy Kollek for Mayor | 635 Madison Avenue | New York | NY | 10022 | |
11148 | 11148 | 1990-03-30 | 1988-08-02 | Stern | Isaac | Teddy Kollek for Mayor 4164 | 1988-08-02 | Teddy Kollek for Mayor | 635 Madison Avenue | New York | NY | 10022 | |
11149 | 11149 | 1990-03-30 | 1988-08-02 | Stern | Vera | Teddy Kollek for Mayor 4164 | 1988-08-02 | Teddy Kollek for Mayor | 635 Madison Avenue | New York | NY | 10022 | |
12686 | 12686 | 1992-04-03 | 1988-05-03 | Stern | Samuel A. | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
14344 | 14344 | 1993-04-29 | 1986-04-01 | Stern | J. Michael | R. Duffy Wall & Associates, Inc. 3737 | 1985-09-25 | R. Duffy Wall & Associates, Inc. | 601 - 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
14430 | 14430 | 1962-04-30 | 1956-10-03 | Stern | Samuel A. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
17719 | 17719 | 1989-05-31 | 1989-03-13 | Stern | Rachael | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
19671 | 19671 | 1994-06-16 | 1993-05-19 | Stern | Margaret L. | Hughes, Hubbard & Reed 4804 | 1993-05-19 | Hughes, Hubbard & Reed | 1300 I Street, N.W. | Suite 900 West | Washington | DC | 20005 |
21909 | 21909 | 2018-06-30 | 2019-09-06 | Stern | Jonathan M. | Burson-Marsteller, LLC (Miami Office) 6223 | 2014-05-20 | Burson-Marsteller, LLC (Miami Office) | 601 Brickell Key Drive | Suite 900 | Miami | FL | 33131 |
22063 | 22063 | 1967-07-01 | 1964-01-17 | Stern | Fred | Artley, Inc. 1681 | 1964-01-17 | Artley, Inc. | C/O Eugene J. Cohen | 405 East 56th Street | New York | NY | 10022 |
29664 | 29664 | 1968-09-13 | 1968-05-16 | Stern | Margaret L. | Fred Rosen Associates, Inc. 1488 | 1961-10-16 | Fred Rosen Associates, Inc. | 110 East 59th Street | New York | NY | 10022 | |
29742 | 29742 | 1993-09-14 | 1992-03-03 | Stern | Lenny | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
29998 | 29998 | 2010-09-17 | 2010-05-13 | Stern | Christopher | Washington Media Group, Inc. 5988 | 2010-05-13 | Washington Media Group, Inc. | 525 9th Street, NW | Suite 800 | Washington | DC | 20004 |
33037 | 33037 | 2020-10-16 | 2015-03-12 | Stern | Rochelle Eva | 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]) );