FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Short_Form_First_Name = "Justin" and State = "DC"
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 17
- DCI Group AZ, LLC 3
- Gray Global Advisors, LLC 2
- Cornerstone Government Affairs 2
- Ballard Partners 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- DLA Piper US LLP 1
- DCI Group, L.L.C. 1
- Hunton & Williams, LLP 1
- Picard Kentz & Rowe, LLP 1
- Peck, Madigan, Jones & Stewart 1
- CRAFT I Media Digital 1
- DCI Group, LLC 1
- Peck, Madigan, Jones & Stewart, Inc. 1
- Alpaytac, Inc. 1
- Levick Strategic Communications, LP 1
- Ballard Partners 1
- Gray Global Advisors, LLC 1
Registrant_Name 15
- Ballard Partners 3
- DCI Group AZ, LLC 3
- Gray Global Advisors, LLC 3
- Cornerstone Government Affairs 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Alpaytac, Inc. 1
- CRAFT I Media Digital 1
- DCI Group, L.L.C. 1
- DCI Group, LLC 1
- DLA Piper US LLP 1
- Hunton & Williams, LLP 1
- Levick Strategic Communications, LP 1
- Peck, Madigan, Jones & Stewart 1
- Peck, Madigan, Jones & Stewart, Inc. 1
- Picard Kentz & Rowe, LLP 1
State 1
- DC · 22 ✖
City 1
- Washington 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
207 | 207 | 2021-01-27 | Gray | Justin | Gray Global Advisors, LLC 6892 | 2020-11-19 | Gray Global Advisors, LLC | 300 New Jersey Avenue, NW | Suite 900 | Washington | DC | 20001 | |
221 | 221 | 2020-01-29 | Jordan | Justin | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 | |
1052 | 1052 | 2023-05-18 | Peterson | Justin | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 | |
3816 | 3816 | 2003-01-15 | 2002-05-13 | Peterson | Justin | DCI Group, L.L.C. 5497 | 2002-05-13 | DCI Group, L.L.C. | Two Lafayette Square | 1133 21st Street, N.W., Suite M100 | Washington | DC | 20036 |
7403 | 7403 | 2013-02-22 | 2012-10-08 | Peterson | Justin | DCI Group, LLC 6140 | 2012-10-05 | DCI Group, LLC | 1828 L Street, NW | Suite 400 | Washington | DC | 20036 |
12341 | 12341 | 2023-03-31 | 2022-06-27 | Peterson | Justin | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 |
12575 | 12575 | 2016-04-01 | 2015-09-25 | Wilson | Justin | Levick Strategic Communications, LP 6228 | 2014-06-25 | Levick Strategic Communications, LP | 1900 M Street, NW | 4th Floor | Washington | DC | 20036 |
15162 | 15162 | 2019-04-30 | 2009-05-28 | Cawley | Justin | Picard Kentz & Rowe, LLP 5939 | 2009-05-28 | Picard Kentz & Rowe, LLP | 1750 K Street, NW | Washington | DC | 20006 | |
15828 | 15828 | 2006-05-06 | 2004-08-25 | Cawley | Justin | Hunton & Williams, LLP 5627 | 2004-06-15 | Hunton & Williams, LLP | 1900 K Street, N.W. | Suite 1200 | Washington | DC | 20006 |
18094 | 18094 | 2012-05-31 | 2008-05-21 | Gray | Justin | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 300 New Jersey Avenue, NW | Suite 900 | Washington | DC | 20001 |
18133 | 18133 | 2015-05-31 | 2015-04-08 | Wilson | Justin | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 888 16th Street, NW | Suite 800 | Washington | DC | 20006 |
18591 | 18591 | 2018-06-01 | 2017-10-17 | Sayfie | Justin | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | 601 Thirteenth Street, NW | Suite 450 N | Washington | DC | 20005 |
21924 | 21924 | 2019-06-30 | 2018-03-06 | Jordan | Justin | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 |
25885 | 25885 | 2004-08-03 | 2001-02-22 | Cawley | Justin | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32297 | 32297 | 2022-10-04 | 2022-01-13 | Sayfie | Justin | Ballard Partners 7070 | 2022-01-13 | Ballard Partners | 601 Thirteenth Street, NW | Suite 250 S | Washington | DC | 20005 |
32300 | 32300 | 2022-10-04 | 2022-12-12 | Sayfie | Justin | Ballard Partners 7070 | 2022-01-13 | Ballard Partners | 601 Thirteenth Street, NW | Suite 250 S | Washington | DC | 20005 |
34618 | 34618 | 2011-10-31 | 2011-04-22 | McCarthy | Justin | Peck, Madigan, Jones & Stewart 6036 | 2011-04-22 | Peck, Madigan, Jones & Stewart | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
34672 | 34672 | 2016-10-31 | 2013-06-10 | McCarthy | Justin | Peck, Madigan, Jones & Stewart, Inc. 6172 | 2013-06-10 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
34679 | 34679 | 2017-10-31 | 2014-02-26 | Gray | Justin | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 300 New Jersey Avenue, NW | Suite 900 | Washington | DC | 20001 |
41785 | 41785 | 2011-12-31 | 2011-09-14 | Germany | Justin | CRAFT I Media Digital 6061 | 2011-09-14 | CRAFT I Media Digital | 706 7th Street, SE | Washington | DC | 20003 | |
42313 | 42313 | 2020-12-31 | 2020-02-20 | Peterson | Justin | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | 2000 K Street NW | Suite 900 | Washington | DC | 20006 |
42317 | 42317 | 2020-12-31 | 2018-04-18 | McCarthy | Justin | 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]) );