FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where Short_Form_First_Name = "Dan"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 25
- APCO Worldwide LLC 3
- Ruder Finn, Inc. 2
- Daniel J. Edelman, Inc. 2
- APCO Worldwide, Inc. 2
- Cannon Advertising Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Daniel J. Edelman, Inc. 1
- Crowell & Moring International, LLC 1
- Morrison & Foerster 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- BGR Government Affairs, LLC 1
- Arent Fox, PLLC 1
- Sterling International Consulting Corporation 1
- Alexander Strategy Group 1
- Ketchum Inc. NY 1
- Prism Public Affairs 1
- Mercury Public Affairs, LLC 1
- BCW LLC 1
- Kemp Goldberg Partners, LLC 1
- Ballard Partners 1
- FTI Consulting (SC), Inc. 1
- Lungren Lopina LLC 1
- Larson Shannahan Slifka Group, LLC 1
- Praia Consultants LLC 1
- Perceptual Advisors LLC 1
Registrant_Name 24
- APCO Worldwide LLC 3
- Daniel J. Edelman, Inc. 3
- APCO Worldwide, Inc. 2
- Ruder Finn, Inc. 2
- Alexander Strategy Group 1
- Arent Fox, PLLC 1
- BCW LLC 1
- BGR Government Affairs, LLC 1
- Ballard Partners 1
- Cannon Advertising Associates, Inc. 1
- Chlopak, Leonard, Schechter & Associates, Inc. 1
- Crowell & Moring International, LLC 1
- FTI Consulting (SC), Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Kemp Goldberg Partners, LLC 1
- Ketchum Inc. NY 1
- Larson Shannahan Slifka Group, LLC 1
- Lungren Lopina LLC 1
- Mercury Public Affairs, LLC 1
- Morrison & Foerster 1
- Perceptual Advisors LLC 1
- Praia Consultants LLC 1
- Prism Public Affairs 1
- Sterling International Consulting Corporation 1
City 8
- Washington 17
- New York 7
- Chicago 1
- Des Moines 1
- Lansing 1
- Miami 1
- Oak Hill 1
- Portland 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
887 | 887 | 2023-04-26 | Tarman | Dan | Perceptual Advisors LLC 7263 | 2023-04-26 | Perceptual Advisors LLC | 1000 Brickell Avenue | Suite 715 | Miami | FL | 33131 | |
1047 | 1047 | 2021-05-18 | Doherty | Dan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 | |
1513 | 1513 | 2023-07-28 | Scandling | Dan | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 | |
1630 | 1630 | 2020-08-18 | Shomon | Dan | Praia Consultants LLC 6857 | 2020-08-18 | Praia Consultants LLC | 4301 50th Street, NW | Suite 300 #2015 | Washington | DC | 20016 | |
2329 | 2329 | 2019-12-02 | Lederman | Dan | Larson Shannahan Slifka Group, LLC 6749 | 2019-11-12 | Larson Shannahan Slifka Group, LLC | 510 E. Locust Street | Suite 200 | Des Moines | IA | 50309 | |
5346 | 5346 | 2006-01-31 | 2005-03-18 | Gans | Dan | Alexander Strategy Group 5557 | 2003-04-23 | Alexander Strategy Group | 3000 K Street, N.W. | Suite 101 | Washington | DC | 20007 |
7031 | 7031 | 2020-02-15 | 2019-11-13 | Scandling | Dan | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
9262 | 9262 | 2019-03-06 | 2018-01-29 | Hindin | Dan | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
10816 | 10816 | 1997-03-26 | 1995-04-14 | Torrey | Dan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
13196 | 13196 | 2019-04-11 | 2018-05-04 | Wilson | Dan | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
13296 | 13296 | 2017-04-13 | 2017-04-05 | McFaul | Dan | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | 601 Thirteenth Street, NW | Suite 450 N | Washington | DC | 20005 |
15128 | 15128 | 2018-04-30 | 2017-07-28 | Scandling | Dan | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
15405 | 15405 | 1989-05-01 | 1963-07-19 | Balaban | Dan | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
15520 | 15520 | 2018-05-01 | 2017-07-24 | Kloeffler | Dan | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
17506 | 17506 | 2008-05-30 | 2008-01-29 | Casey | Dan | Prism Public Affairs 5841 | 2007-11-16 | Prism Public Affairs | 1399 New York Avenue, NW | Suite 550 | Washington | DC | 20005 |
18602 | 18602 | 2021-06-01 | 2019-04-17 | Murphy | Dan | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
22309 | 22309 | 2006-07-01 | 2001-07-16 | Geisler | Dan | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 |
23436 | 23436 | 2008-07-17 | 2008-10-06 | Schnwr | Dan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
26064 | 26064 | 2019-08-05 | 2019-01-14 | Lungren | Dan | Lungren Lopina LLC 6616 | 2019-01-14 | Lungren Lopina LLC | 3305 Bywater Ct. | Oak Hill | VA | 20171 | |
26669 | 26669 | 1968-08-15 | 1967-06-23 | Rosen | Dan | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
28175 | 28175 | 1990-08-31 | 1989-08-23 | Skrzynski | Dan | Morrison & Foerster 4282 | 1989-08-23 | Morrison & Foerster | 2000 Pennsylvania Avenue, N.W. | Suite 5500 | Washington | DC | 20006 |
28440 | 28440 | 2005-08-31 | 2004-03-10 | Renberg | Dan | Arent Fox, PLLC 5476 | 2002-02-21 | Arent Fox, PLLC | 1050 Connecticut Avenue, N.W. | Washington | DC | 20036-5339 | |
30222 | 30222 | 1994-09-21 | 1992-12-17 | D'Armond | Dan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
30392 | 30392 | 2014-09-24 | 2014-09-24 | Ventura | Dan | Kemp Goldberg Partners, LLC 6252 | 2014-09-24 | Kemp Goldberg Partners, LLC | 280 Fore Street | Suite 301 | Portland | ME | 04101 |
31465 | 31465 | 2009-09-30 | 2009-05-07 | Santow | Dan | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31851 | 31851 | 1978-10-01 | 1978-05-10 | Farnsworth | Dan | Cannon Advertising Associates, Inc. 1945 | 1965-12-14 | Cannon Advertising Associates, Inc. | 444 Madison Avenue | Suite 301 | New York | NY | 10022 |
32425 | 32425 | 2022-10-07 | 2022-09-16 | Scandling | Dan | APCO Worldwide LLC 6582 | 2018-08-22 | APCO Worldwide LLC | 1299 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20004 |
36907 | 36907 | 2002-11-30 | 2002-10-01 | Pero | Dan | Sterling International Consulting Corporation 5519 | 2002-10-01 | Sterling International Consulting Corporation | 118 West Ottawa Street | Lansing | MI | 48933 | |
41148 | 41148 | 1999-12-31 | 1997-07-09 | Leonard | Dan | Chlopak, Leonard, Schechter & Associates, Inc. 4953 | 1994-09-28 | Chlopak, Leonard, Schechter & Associates, Inc. | 1850 M Street, N.W. | Suite 550 | Washington | DC | 20036 |
42054 | 42054 | 2016-12-31 | 2016-07-29 | Scandling | Dan | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | 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]) );