FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where "Short_Form_Termination_Date" is on date 2020-07-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 13
- Pivot Integrated Communications, a division of BCW LLC 9
- QORVIS LLC 8
- Stone Strategic Solutions SRL 2
- Daniel J. Edelman, Inc. 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Fratelli Group 1
- Myriad International Marketing, LLC 1
- NRW.INVEST (NORTH AMERICA) LLC 1
- Beacon Policy Advisors LLC 1
- Terakeet LLC 1
- Global Management Association, Corp 1
- Kivvit, LLC 1
- McClellan Group 1
Registrant_Name 13
- Pivot Integrated Communications, a division of BCW LLC 9
- QORVIS LLC 8
- Stone Strategic Solutions SRL 2
- Beacon Policy Advisors LLC 1
- Daniel J. Edelman, Inc. 1
- Fratelli Group 1
- Global Management Association, Corp 1
- Kivvit, LLC 1
- McClellan Group 1
- Myriad International Marketing, LLC 1
- NRW.INVEST (NORTH AMERICA) LLC 1
- Pillsbury Winthrop Shaw Pittman, LLP 1
- Terakeet LLC 1
City 8
- Washington 11
- New York 9
- Chicago 3
- Bucharest 2
- Overland Park 1
- Pearl City 1
- San Francisco 1
- Syracuse 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25368 | 25368 | 2020-07-31 | 2020-01-16 | Comins | Marshall | Stone Strategic Solutions SRL 6783 | 2020-01-16 | Stone Strategic Solutions SRL | 19-21 Sos. Bucuresti-Ploiesti, Baneasa Business Park | 6th Floor Sec. 1 | Bucharest | ||
25369 | 25369 | 2020-07-31 | 2020-01-16 | Stone | Alan Blaine | Stone Strategic Solutions SRL 6783 | 2020-01-16 | Stone Strategic Solutions SRL | 19-21 Sos. Bucuresti-Ploiesti, Baneasa Business Park | 6th Floor Sec. 1 | Bucharest | ||
25370 | 25370 | 2020-07-31 | 2019-02-23 | Jean | Joseph D. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 |
25371 | 25371 | 2020-07-31 | 2019-03-14 | Rubin | Ginta Rose | NRW.INVEST (NORTH AMERICA) LLC 6645 | 2019-03-13 | NRW.INVEST (NORTH AMERICA) LLC | 150 North Michigan Avenue | Suite 2940 | Chicago | IL | 60601 |
25372 | 25372 | 2020-07-31 | 2020-03-18 | Minuskin | Eric | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25373 | 25373 | 2020-07-31 | 2020-03-18 | Silvers | Sharron | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25374 | 25374 | 2020-07-31 | 2020-04-08 | Bader | Nabil Ahmad | Global Management Association, Corp 6812 | 2020-04-08 | Global Management Association, Corp | 1300 I Street, NW | Suite 400 E | Washington | DC | 20005 |
25375 | 25375 | 2020-07-31 | 2019-04-09 | Pierson | Rachel | Beacon Policy Advisors LLC 6658 | 2019-04-09 | Beacon Policy Advisors LLC | 1701 Pennsylvania Avenue, NW | Suite 200 | Washington | DC | 20006 |
25376 | 25376 | 2020-07-31 | 2019-04-30 | Dain | Rebekah | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25377 | 25377 | 2020-07-31 | 2019-04-30 | Perez | David | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25378 | 25378 | 2020-07-31 | 2019-04-30 | Shapiro | Josh | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25379 | 25379 | 2020-07-31 | 2019-04-30 | Tanaka Pacheco | Gerardo Seiji | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25380 | 25380 | 2020-07-31 | 2019-04-30 | Thomas | Carlos | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25381 | 25381 | 2020-07-31 | 2019-04-30 | Warschawski | Jonathan | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25382 | 25382 | 2020-07-31 | 2020-04-30 | Kissel | Paris | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25383 | 25383 | 2020-07-31 | 2020-05-15 | Davmer | Ariella | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25384 | 25384 | 2020-07-31 | 2019-05-22 | Hernandez | Jonathan | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 |
25385 | 25385 | 2020-07-31 | 2020-07-31 | DeAngelis | Bryan | Kivvit, LLC 6839 | 2020-07-30 | Kivvit, LLC | 222 W. Merchandise Mart Plaza | Suite 2400 | Chicago | IL | 60654 |
25386 | 25386 | 2020-07-31 | 2017-09-08 | Bray | John | Fratelli Group 5867 | 2008-06-03 | Fratelli Group | 1300 Connecticut Avenue, NW | Suite 950 | Washington | DC | 20036 |
25387 | 25387 | 2020-07-31 | 2019-09-11 | Almeleh | Shira Eloise | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25388 | 25388 | 2020-07-31 | 2019-10-03 | Goodman | Adam | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25389 | 25389 | 2020-07-31 | 2019-10-03 | Hendl | Jonathan | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25390 | 25390 | 2020-07-31 | 2019-10-03 | Marino | Gabrielle | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25391 | 25391 | 2020-07-31 | 2020-10-29 | Grafe | Alexandra | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | |
25392 | 25392 | 2020-07-31 | 2019-11-06 | Culbertson | Matthew | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25393 | 25393 | 2020-07-31 | 2019-11-06 | Mastrojohn | Dean | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25394 | 25394 | 2020-07-31 | 2016-11-14 | Trumbull | Mackenzie C. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
25395 | 25395 | 2020-07-31 | 2019-11-27 | Delgado | Kelly | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25396 | 25396 | 2020-07-31 | 2020-12-16 | McClellan | William Henry K. | McClellan Group 6900 | 2020-12-16 | McClellan Group | 2319 Ahamoa Street | Pearl City | HI | 96782 |
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]) );