FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where "Short_Form_Termination_Date" is on date 2019-04-30
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Date (date)
Registration_Number 14
- Daniel J. Edelman, Inc. 16
- QORVIS LLC 3
- Fleishman-Hillard, Inc. 3
- Picard Kentz & Rowe, LLP 3
- Project Associates UK Ltd 3
- OPC Strategies LLC 3
- Mercury Public Affairs, LLC 2
- Bavarian U.S. Offices for Economic Development, LLC 1
- Taiwan Democratic Progressive Party Mission in the U.S. 1
- MWW Group, LLC 1
- Quinn & Co. of NY LTD. 1
- MMGY Global, LLC 1
- Dentons Canada LLP 1
- Envoy Strategy Group LLC 1
Registrant_Name 14
- Daniel J. Edelman, Inc. 16
- Fleishman-Hillard, Inc. 3
- OPC Strategies LLC 3
- Picard Kentz & Rowe, LLP 3
- Project Associates UK Ltd 3
- QORVIS LLC 3
- Mercury Public Affairs, LLC 2
- Bavarian U.S. Offices for Economic Development, LLC 1
- Dentons Canada LLP 1
- Envoy Strategy Group LLC 1
- MMGY Global, LLC 1
- MWW Group, LLC 1
- Quinn & Co. of NY LTD. 1
- Taiwan Democratic Progressive Party Mission in the U.S. 1
City 8
- Chicago 16
- Washington 11
- London 3
- Silver Spring 3
- St. Louis 3
- New York 2
- East Rutherford 1
- Overland Park 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15141 | 15141 | 2019-04-30 | 2019-01-31 | Dhanaphatana | Sarah Kelly | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15142 | 15142 | 2019-04-30 | 2019-01-31 | Sklad | Amanda | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15143 | 15143 | 2019-04-30 | 2018-02-05 | Chen | Michael Win-How | Taiwan Democratic Progressive Party Mission in the U.S. 6187 | 2013-09-06 | Taiwan Democratic Progressive Party Mission in the U.S. | 1455 Pennsylvania Avenue NW #439 | Washington | DC | 20004 | |
15144 | 15144 | 2019-04-30 | 2019-02-15 | Morland | Danielle | Project Associates UK Ltd 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | ||
15145 | 15145 | 2019-04-30 | 2019-02-15 | Wild | Suzy | Project Associates UK Ltd 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | ||
15146 | 15146 | 2019-04-30 | 2017-03-01 | Eckert | Kristin | Bavarian U.S. Offices for Economic Development, LLC 6015 | 2011-01-07 | Bavarian U.S. Offices for Economic Development, LLC | 80 Pine Street | 24th Floor | New York | NY | 10005 |
15147 | 15147 | 2019-04-30 | 2018-03-07 | Doer | Gary | Dentons Canada LLP 6532 | 2018-03-07 | Dentons Canada LLP | 1900 K Street, NW | Washington | DC | 20006 | |
15148 | 15148 | 2019-04-30 | 2022-03-17 | Towriss | John | Envoy Strategy Group LLC 6663 | 2019-04-15 | Envoy Strategy Group LLC | 1701 Pennsylvania Avenue, NW | Suite 200 | Washington | DC | 20006 |
15149 | 15149 | 2019-04-30 | 2019-04-09 | Shepherd | Margaret | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15150 | 15150 | 2019-04-30 | 2019-04-18 | Nelson | Anna | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15151 | 15151 | 2019-04-30 | 2019-04-18 | Salloum | Amy | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15152 | 15152 | 2019-04-30 | 2019-04-23 | Pressler | Sarah | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15153 | 15153 | 2019-04-30 | 2018-04-27 | Walton | Laura | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15154 | 15154 | 2019-04-30 | 2018-04-27 | Workman | Daniel | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15155 | 15155 | 2019-04-30 | 2019-04-30 | Guzman | Martha Veronica | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
15156 | 15156 | 2019-04-30 | 2019-04-30 | List | Sarah | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
15157 | 15157 | 2019-04-30 | 2019-04-30 | Lopez | Ilse | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
15158 | 15158 | 2019-04-30 | 2019-05-07 | Bradley | Braden Todd | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15159 | 15159 | 2019-04-30 | 2019-05-14 | Mitra | Sujata | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15160 | 15160 | 2019-04-30 | 2019-05-14 | Williams | Lynnette Johnson | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15161 | 15161 | 2019-04-30 | 2018-05-17 | Howard | Greg | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | 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 | |
15163 | 15163 | 2019-04-30 | 2009-05-28 | Picard | B. Donovan | Picard Kentz & Rowe, LLP 5939 | 2009-05-28 | Picard Kentz & Rowe, LLP | 1750 K Street, NW | Washington | DC | 20006 | |
15164 | 15164 | 2019-04-30 | 2009-05-28 | Rowe | Edward | Picard Kentz & Rowe, LLP 5939 | 2009-05-28 | Picard Kentz & Rowe, LLP | 1750 K Street, NW | Washington | DC | 20006 | |
15165 | 15165 | 2019-04-30 | 2019-06-11 | Fuehrmeyer | Matthew | OPC Strategies LLC 6601 | 2018-10-16 | OPC Strategies LLC | 8701 Georgia Ave | Suite 605 | Silver Spring | MD | 20910 |
15166 | 15166 | 2019-04-30 | 2013-06-14 | Lyall | Alexander | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15167 | 15167 | 2019-04-30 | 2018-07-03 | Chabria | Jai | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
15168 | 15168 | 2019-04-30 | 2019-08-01 | Sheffield III | Ralph Harrison | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15169 | 15169 | 2019-04-30 | 2019-08-01 | Warpinski | Joseph | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15170 | 15170 | 2019-04-30 | 2018-08-29 | Zuniga | Diane | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15171 | 15171 | 2019-04-30 | 2017-09-26 | Rose | Sheila | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15172 | 15172 | 2019-04-30 | 2017-10-06 | Loeffen-Gallagher | Ryan | Project Associates UK Ltd 6472 | 2017-10-06 | Project Associates UK Ltd | 30 Haymarket | St James's | London | ||
15173 | 15173 | 2019-04-30 | 2017-10-11 | Akahoshi | Teri | Quinn & Co. of NY LTD. 6433 | 2017-05-24 | Quinn & Co. of NY LTD. | 48 W 38th Street, 12th Floor | New York | NY | 10018 | |
15174 | 15174 | 2019-04-30 | 2018-10-16 | Summers | Jon | OPC Strategies LLC 6601 | 2018-10-16 | OPC Strategies LLC | 8701 Georgia Ave | Suite 605 | Silver Spring | MD | 20910 |
15175 | 15175 | 2019-04-30 | 2018-10-18 | Rake | Launce | OPC Strategies LLC 6601 | 2018-10-16 | OPC Strategies LLC | 8701 Georgia Ave | Suite 605 | Silver Spring | MD | 20910 |
15176 | 15176 | 2019-04-30 | 2018-11-15 | Cloud | Bridget | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15177 | 15177 | 2019-04-30 | 2018-11-15 | Niadna | Kimberly Marie | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
15178 | 15178 | 2019-04-30 | 2013-11-20 | Rockenbach | Denise M. | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15179 | 15179 | 2019-04-30 | 2017-11-27 | Cohen | Stephen | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
15180 | 15180 | 2019-04-30 | 2017-12-15 | Satler | Erika | MWW Group, LLC 6381 | 2016-09-30 | MWW Group, LLC | One Meadowlands Plaza | East Rutherford | NJ | 07073 |
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]) );