FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Short_Form_First_Name = "Joel"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, Registration_Date (date)
Registration_Number 23
- Akin, Gump, Strauss, Hauer & Feld, LLP 4
- FGS Global (US) LLC (FKA FGH Holdings LLC) 3
- National Film Board of Canada 1
- Committee for the Free Republic of South Moluccas, Inc. 1
- Doremus & Company 1
- Ketchum Communications Holdings, Inc. 1
- Dickstein Shapiro, LLP 1
- Wald, Harkrader & Ross 1
- Hill and Knowlton Strategies, LLC 1
- Bogle & Gates 1
- Saatchi & Saatchi North America, Inc. 1
- Holland & Knight 1
- Sawyer Miller Group 1
- Pace Advertising 1
- Wexler & Walker Public Policy Associates 1
- Harbour Group, LLC 1
- Fenton Communications 1
- Park Strategies, LLC 1
- Crescent Consultants, LLC 1
- Shulman, Rogers, Gandal, Pordy & Ecker, P.A. 1
- Washington Strategy Group 1
- Park Strategies, LLC 1
- Kivvit, LLC 1
Registrant_Name 22
- Akin, Gump, Strauss, Hauer & Feld, LLP 4
- FGS Global (US) LLC (FKA FGH Holdings LLC) 3
- Park Strategies, LLC 2
- Bogle & Gates 1
- Committee for the Free Republic of South Moluccas, Inc. 1
- Crescent Consultants, LLC 1
- Dickstein Shapiro, LLP 1
- Doremus & Company 1
- Fenton Communications 1
- Harbour Group, LLC 1
- Hill and Knowlton Strategies, LLC 1
- Holland & Knight 1
- Ketchum Communications Holdings, Inc. 1
- Kivvit, LLC 1
- National Film Board of Canada 1
- Pace Advertising 1
- Saatchi & Saatchi North America, Inc. 1
- Sawyer Miller Group 1
- Shulman, Rogers, Gandal, Pordy & Ecker, P.A. 1
- Wald, Harkrader & Ross 1
- Washington Strategy Group 1
- Wexler & Walker Public Policy Associates 1
City 7
- Washington 15
- New York 8
- Chevy Chase 1
- Chicago 1
- Pittsburgh 1
- Potomac 1
- Seattle 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2694 | 2694 | 1990-01-01 | 1989-05-24 | Davidow | Joel | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
5291 | 5291 | 2003-01-31 | 1998-07-15 | Malina | Joel | Wexler & Walker Public Policy Associates 5265 | 1998-07-15 | Wexler & Walker Public Policy Associates | 1317 F Street, N.W. | Suite 600 | Washington | DC | 20004 |
6979 | 6979 | 2010-02-15 | 2010-05-06 | Frushone | Joel | Crescent Consultants, LLC 5944 | 2009-06-17 | Crescent Consultants, LLC | 4414 29th Street, NW | Washington | DC | 20008 | |
7538 | 7538 | 1994-02-24 | 1992-09-01 | Levinson | Joel | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
8350 | 8350 | 2018-02-28 | 2017-11-09 | Giambra | Joel | Park Strategies, LLC 6488 | 2017-11-09 | Park Strategies, LLC | 101 Park Avenue | Suite 2506 | New York | NY | 10178 |
9047 | 9047 | 1994-03-03 | 1991-05-03 | Cantos | Joel | Pace Advertising 4508 | 1991-05-03 | Pace Advertising | 485 Fifth Avenue | New York | NY | 10017 | |
12306 | 12306 | 2022-03-31 | 2022-02-07 | Johnson | Joel | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
14388 | 14388 | 2020-04-29 | 2016-08-04 | Rubin | Joel | Washington Strategy Group 6365 | 2016-08-04 | Washington Strategy Group | 4401 Walsh Street | Chevy Chase | MD | 20815 | |
15004 | 15004 | 2009-04-30 | 2007-06-07 | Finkelstein | Joel | Fenton Communications 5803 | 2007-04-30 | Fenton Communications | 1000 Vermont Avenue, N.W. | Suite 200 | Washington | DC | 20005 |
16717 | 16717 | 2017-05-19 | 2007-11-16 | Johnson | Joel | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
20128 | 20128 | 1970-06-24 | 1964-01-20 | Samuels | Joel | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
21068 | 21068 | 1987-06-30 | 1986-02-12 | McCleary | Joel | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
22405 | 22405 | 2022-07-01 | 2020-07-30 | Reese | Joel | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
25019 | 25019 | 2003-07-31 | 2003-03-18 | Malina | Joel | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
25106 | 25106 | 2007-07-31 | 2005-07-01 | Jankowsky | Joel | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
29284 | 29284 | 2007-09-06 | 2005-01-31 | Johnson | Joel | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
30516 | 30516 | 1985-09-26 | 1981-04-29 | Pomerantz | Joel | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30554 | 30554 | 2014-09-26 | 2010-03-29 | Roberson | Joel | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
31588 | 31588 | 2015-09-30 | 2013-11-06 | Schwartz | Joel | Shulman, Rogers, Gandal, Pordy & Ecker, P.A. 5976 | 2010-03-03 | Shulman, Rogers, Gandal, Pordy & Ecker, P.A. | 12505 Park Potomac Avenue | Sixth Floor | Potomac | MD | 20854-6803 |
33016 | 33016 | 1985-10-16 | 1984-12-20 | Winnik | Joel | Wald, Harkrader & Ross 3241 | 1981-05-10 | Wald, Harkrader & Ross | 1300 - 19th Street, N.W. | Washington | DC | 20036 | |
34940 | 34940 | 1991-11-01 | 1983-06-24 | Jankowsky | Joel | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
37294 | 37294 | 1972-12-01 | 1971-02-26 | Leihitu | Joel | Committee for the Free Republic of South Moluccas, Inc. 2172 | 1969-11-24 | Committee for the Free Republic of South Moluccas, Inc. | St. Mark Building | 115 East 9th Street #5L | New York | NY | 10003 |
37352 | 37352 | 1982-12-01 | 1974-01-21 | Weber | Joel | Ketchum Communications Holdings, Inc. 2386 | 1972-10-17 | Ketchum Communications Holdings, Inc. | 4 Gateway Center | Pittsburgh | PA | 15222 | |
39079 | 39079 | 1997-12-24 | 1992-04-30 | Jankowsky | Joel | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
40508 | 40508 | 1988-12-31 | 1985-07-12 | Pritchard | Joel | Bogle & Gates 3474 | 1983-05-24 | Bogle & Gates | Two Union Square | 601 Union Street | Seattle | WA | 98101-2346 |
41372 | 41372 | 2004-12-31 | 2002-10-30 | Johnson | Joel | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41821 | 41821 | 2012-12-31 | 2009-05-18 | Giambra | Joel | Park Strategies, LLC 5908 | 2009-01-09 | Park Strategies, LLC | 101 Park Avenue | Suite 2506 | New York | NY | 10178 |
42276 | 42276 | 2019-12-31 | 2008-07-30 | Jankowsky | Joel | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 |
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]) );