FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where City = "Washington", "Short_Form_Termination_Date" is on date 2004-12-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41345 | 41345 | 2004-12-31 | 1993-02-08 | Shapiro | Robert B. | Bernstein Law Firm, PLLC 4764 | 1993-02-08 | Bernstein Law Firm, PLLC | 5335 Wisconsin Avenue, NW | Suite 440 | Washington | DC | 20015 |
41346 | 41346 | 2004-12-31 | 1998-02-12 | Vertrees | James G. | O'Mara, Charles J. 5181 | 1997-05-30 | O'Mara, Charles J. | 3213 O Street, NW | Washington | DC | 20007 | |
41347 | 41347 | 2004-12-31 | 2003-02-28 | Ok | Justine | Korea Economic Institute 3327 | 1982-02-01 | Korea Economic Institute | 1800 K Street, NW | Suite 1010 | Washington | DC | 20006 |
41348 | 41348 | 2004-12-31 | 2005-02-28 | Acocella | Bart | DB Communications, LLC 5634 | 2004-07-22 | DB Communications, LLC | 1050 Thomas Jefferson Street, N.W. | Suite 300 | Washington | DC | 20007 |
41349 | 41349 | 2004-12-31 | 2002-03-04 | Collins | Christine | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41352 | 41352 | 2004-12-31 | 2003-04-23 | Darling | Brian | Alexander Strategy Group 5557 | 2003-04-23 | Alexander Strategy Group | 3000 K Street, N.W. | Suite 101 | Washington | DC | 20007 |
41353 | 41353 | 2004-12-31 | 2003-04-30 | Graefe | Erin | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41354 | 41354 | 2004-12-31 | 2004-05-06 | Haney | Mark | Sandler, Travis & Rosenberg, P.A. 5303 | 1998-12-07 | Sandler, Travis & Rosenberg, P.A. | 1300 Pennsylvania Avenue, N.W. | Suite 400 | Washington | DC | 20004-3002 |
41360 | 41360 | 2004-12-31 | 2001-06-28 | Peckham | Gardner G. | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41361 | 41361 | 2004-12-31 | 2003-07-03 | Hefti | Marlin L. | Van Scoyoc Associates, Inc. 5401 | 2000-12-14 | Van Scoyoc Associates, Inc. | 800 Maine Avenue, SW | Suite 800 | Washington | DC | 20024 |
41362 | 41362 | 2004-12-31 | 2004-07-22 | Baum | Daniel Jay | DB Communications, LLC 5634 | 2004-07-22 | DB Communications, LLC | 1050 Thomas Jefferson Street, N.W. | Suite 300 | Washington | DC | 20007 |
41363 | 41363 | 2004-12-31 | 2004-07-22 | Fredrick | Kelly | DB Communications, LLC 5634 | 2004-07-22 | DB Communications, LLC | 1050 Thomas Jefferson Street, N.W. | Suite 300 | Washington | DC | 20007 |
41364 | 41364 | 2004-12-31 | 2004-07-22 | Palmer | Douglas | DB Communications, LLC 5634 | 2004-07-22 | DB Communications, LLC | 1050 Thomas Jefferson Street, N.W. | Suite 300 | Washington | DC | 20007 |
41365 | 41365 | 2004-12-31 | 2004-07-22 | Spinck | Darren G. | DB Communications, LLC 5634 | 2004-07-22 | DB Communications, LLC | 1050 Thomas Jefferson Street, N.W. | Suite 300 | Washington | DC | 20007 |
41368 | 41368 | 2004-12-31 | 1996-08-15 | Jackson | Nancy Izzo | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | 1730 Rhode Island Avenue, NW | Suite 207 | Washington | DC | 20036 |
41371 | 41371 | 2004-12-31 | 2004-10-28 | Morgan | Kimberly James | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41372 | 41372 | 2004-12-31 | 2002-10-30 | Johnson | Joel | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41373 | 41373 | 2004-12-31 | 2003-10-30 | Tomljanovic | Marni L. | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
41375 | 41375 | 2004-12-31 | 2002-11-13 | Nussle | Karen | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41376 | 41376 | 2004-12-31 | 2004-12-09 | Glassner | Lauren | Weber Shandwick, Inc. 5579 | 2003-10-02 | Weber Shandwick, Inc. | 700 13th Street, N.W. | Suite 800 | Washington | DC | 20005 |
41378 | 41378 | 2004-12-31 | 2002-12-20 | O'Brien | Brett W. | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
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]) );