FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where City = "Washington" and Short_Form_First_Name = "Ryan"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Zip, Registration_Date (date)
Registration_Number 12
- Hill and Knowlton Strategies, LLC 3
- DCI Group AZ, LLC 3
- Dow, Lohnes & Albertson, L.L.P. 1
- Crowell & Moring International, LLC 1
- Global Communicators/ Harff Communications, Inc. 1
- Policy Impact Communications, Inc. 1
- GAGE International, LLC 1
- DCI Group, LLC 1
- BCW LLC 1
- Rokk Solutions, LLC 1
- Navigators Global LLC 1
- Navigators Global LLC 1
Registrant_Name 11
- DCI Group AZ, LLC 3
- Hill and Knowlton Strategies, LLC 3
- Navigators Global LLC 2
- BCW LLC 1
- Crowell & Moring International, LLC 1
- DCI Group, LLC 1
- Dow, Lohnes & Albertson, L.L.P. 1
- GAGE International, LLC 1
- Global Communicators/ Harff Communications, Inc. 1
- Policy Impact Communications, Inc. 1
- Rokk Solutions, LLC 1
State 1
- DC 16
City 1
- Washington · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
914 | 914 | 2022-04-29 | Berger | Ryan | Navigators Global LLC 7112 | 2022-04-29 | Navigators Global LLC | 901 7th Street, NW | Suite 200 | Washington | DC | 20001 | |
1040 | 1040 | 2023-05-17 | Grillo | Ryan | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 | |
2125 | 2125 | 2017-11-09 | MacFarlane | Ryan | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 | |
2357 | 2357 | 2021-12-06 | Cassidy | Ryan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 | |
7549 | 7549 | 2006-02-24 | 2005-06-10 | Peal | Ryan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11911 | 11911 | 2003-03-31 | 2002-07-30 | Higgins | Ryan | Global Communicators/ Harff Communications, Inc. 5241 | 1998-03-05 | Global Communicators/ Harff Communications, Inc. | 1925 K Street, N.W. | Suite 450 | Washington | DC | 20006 |
14014 | 14014 | 2021-04-23 | 2020-02-12 | Grillo | Ryan | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 |
15484 | 15484 | 2012-05-01 | 2010-12-21 | Thomas | Ryan | GAGE International, LLC 6011 | 2010-12-21 | GAGE International, LLC | 122 C Street, NW | Suite 380 | Washington | DC | 20001 |
15668 | 15668 | 2014-05-03 | 2014-01-14 | Honick | Ryan | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18073 | 18073 | 2010-05-31 | 2009-05-28 | Morley | Ryan | Policy Impact Communications, Inc. 5936 | 2009-05-28 | Policy Impact Communications, Inc. | 1401 K Street, NW | Suite 600 | Washington | DC | 20005 |
23080 | 23080 | 2018-07-13 | 2017-11-28 | Connor | Ryan | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | Washington | DC | 20006 |
23572 | 23572 | 2019-07-18 | 2019-06-21 | Hughes | Ryan | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
28696 | 28696 | 2021-08-31 | 2021-02-13 | Berger | Ryan | Navigators Global LLC 6925 | 2021-02-13 | Navigators Global LLC | 901 7th Street, NW | Suite 200 | Washington | DC | 20001 |
31075 | 31075 | 1991-09-30 | 1985-09-09 | Conroy | Ryan | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | 1200 New Hampshire Avenue, N.W | Suite 800 | Washington | DC | 20036 |
31731 | 31731 | 2022-09-30 | 2021-08-30 | Grillo | Ryan | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 |
35028 | 35028 | 2013-11-01 | 2012-10-08 | Grillo | Ryan | DCI Group, LLC 6140 | 2012-10-05 | DCI Group, LLC | 1828 L Street, NW | Suite 400 | Washington | DC | 20036 |
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]) );