FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where "Short_Form_Termination_Date" is on date 2005-12-31 and State = "DC"
This data as json, CSV (advanced)
Short_Form_Date (date) 22 ✖
- 2005-06-24 5
- 2004-12-22 4
- 2004-12-13 3
- 2003-07-28 2
- 1979-05-30 1
- 1999-02-19 1
- 1999-08-09 1
- 2001-07-16 1
- 2003-06-10 1
- 2003-06-16 1
- 2003-06-20 1
- 2004-03-09 1
- 2004-04-28 1
- 2004-08-09 1
- 2004-08-10 1
- 2004-08-25 1
- 2004-10-22 1
- 2005-01-05 1
- 2005-03-11 1
- 2005-06-15 1
- 2005-06-27 1
- 2006-12-01 1
Registration_Number 14
- Squire Patton Boggs, LLP 8
- Kemp Partners 5
- Kamber Group 4
- Valis Associates 3
- Sandler, Travis & Rosenberg, P.A. 2
- Brewster/Jory Associates, LLC 2
- Office of Tibet 1
- Arnold & Porter Kaye Scholer LLP 1
- Hill and Knowlton Strategies, LLC 1
- Foley Hoag, LLP 1
- Global Policy Group, Inc. 1
- QORVIS LLC 1
- Hunton & Williams, LLP 1
- Kirkpatrick & Lockhart Preston Gates Ellis LLP 1
Registrant_Name 14
- Squire Patton Boggs, LLP 8
- Kemp Partners 5
- Kamber Group 4
- Valis Associates 3
- Brewster/Jory Associates, LLC 2
- Sandler, Travis & Rosenberg, P.A. 2
- Arnold & Porter Kaye Scholer LLP 1
- Foley Hoag, LLP 1
- Global Policy Group, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- Hunton & Williams, LLP 1
- Kirkpatrick & Lockhart Preston Gates Ellis LLP 1
- Office of Tibet 1
- QORVIS LLC 1
State 1
- DC · 32 ✖
City 1
- Washington 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41380 | 41380 | 2005-12-31 | 2005-01-05 | Gaines | Sallie L. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41392 | 41392 | 2005-12-31 | 1999-02-19 | Gavin | Stephen Diaz | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41393 | 41393 | 2005-12-31 | 2004-03-09 | Slater | Rodney E. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41394 | 41394 | 2005-12-31 | 2005-03-11 | Johnson | Clete D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41406 | 41406 | 2005-12-31 | 2004-04-28 | Harker | Drew | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
41410 | 41410 | 2005-12-31 | 1979-05-30 | Dunn | David E. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41420 | 41420 | 2005-12-31 | 2003-06-10 | Castro | Maritza | 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 |
41421 | 41421 | 2005-12-31 | 2005-06-15 | Power | Michael G. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41422 | 41422 | 2005-12-31 | 2003-06-16 | Driver | Michael J. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41423 | 41423 | 2005-12-31 | 2003-06-20 | Hathaway | Charles Michael | 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 |
41426 | 41426 | 2005-12-31 | 2005-06-24 | Brooks | Leigh | Kemp Partners 5690 | 2005-06-24 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
41427 | 41427 | 2005-12-31 | 2005-06-24 | Kemp | Jack | Kemp Partners 5690 | 2005-06-24 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
41428 | 41428 | 2005-12-31 | 2005-06-24 | Kemp | James | Kemp Partners 5690 | 2005-06-24 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
41429 | 41429 | 2005-12-31 | 2005-06-24 | Okidi | Jongomoyi | Kemp Partners 5690 | 2005-06-24 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
41430 | 41430 | 2005-12-31 | 2005-06-24 | Taylor | James | Kemp Partners 5690 | 2005-06-24 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
41431 | 41431 | 2005-12-31 | 2005-06-27 | Christie | Ronald I. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41432 | 41432 | 2005-12-31 | 2001-07-16 | Rabgyal | Nawang | Office of Tibet 1699 | 1964-03-14 | Office of Tibet | 1228 17th Street, NW | Washington | DC | 20036 | |
41433 | 41433 | 2005-12-31 | 2003-07-28 | Kronmiller | Theodore G. | Brewster/Jory Associates, LLC 5569 | 2003-07-28 | Brewster/Jory Associates, LLC | 499 South Capitol Street, S.W. | Suite 608 | Washington | DC | 20003 |
41434 | 41434 | 2005-12-31 | 2003-07-28 | Sabathier | Robbie Koch | Brewster/Jory Associates, LLC 5569 | 2003-07-28 | Brewster/Jory Associates, LLC | 499 South Capitol Street, S.W. | Suite 608 | Washington | DC | 20003 |
41449 | 41449 | 2005-12-31 | 1999-08-09 | Passaic, Jr. | Joseph G. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41450 | 41450 | 2005-12-31 | 2004-08-09 | Wilson | Mary E. | Global Policy Group, Inc. 5290 | 1998-12-02 | Global Policy Group, Inc. | 1875 K Street, NW | 4th Floor | Washington | DC | 20006 |
41451 | 41451 | 2005-12-31 | 2004-08-10 | Hamann | Kathleen M. | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 1717 K Street, N.W. | Suite 1200 | Washington | DC | 20036 |
41452 | 41452 | 2005-12-31 | 2004-08-25 | Williamson | Jill M. | Hunton & Williams, LLP 5627 | 2004-06-15 | Hunton & Williams, LLP | 1900 K Street, N.W. | Suite 1200 | Washington | DC | 20006 |
41462 | 41462 | 2005-12-31 | 2004-10-22 | (Robitaille) Wissmann | Yvette T. | Kirkpatrick & Lockhart Preston Gates Ellis LLP 5652 | 2004-10-22 | Kirkpatrick & Lockhart Preston Gates Ellis LLP | 1601 K Street, NW | Washington | DC | 20006 | |
41464 | 41464 | 2005-12-31 | 2006-12-01 | Pierce Atwood Consulting | LLC | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
41465 | 41465 | 2005-12-31 | 2004-12-13 | Conti | Jennifer | Valis Associates 5660 | 2004-12-13 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
41466 | 41466 | 2005-12-31 | 2004-12-13 | Schulze | Richard T. | Valis Associates 5660 | 2004-12-13 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
41467 | 41467 | 2005-12-31 | 2004-12-13 | Valis | Wayne H. | Valis Associates 5660 | 2004-12-13 | Valis Associates | 1700 Pennsylvania Avenue, N.W. | Suite 950 | Washington | DC | 20006 |
41468 | 41468 | 2005-12-31 | 2004-12-22 | Erling | Christina M. | Kamber Group 5663 | 2004-12-22 | Kamber Group | 4527 29th Street, NW | Washington | DC | 20008 | |
41469 | 41469 | 2005-12-31 | 2004-12-22 | Huber | Lee | Kamber Group 5663 | 2004-12-22 | Kamber Group | 4527 29th Street, NW | Washington | DC | 20008 | |
41470 | 41470 | 2005-12-31 | 2004-12-22 | Kamber | Victor | Kamber Group 5663 | 2004-12-22 | Kamber Group | 4527 29th Street, NW | Washington | DC | 20008 | |
41471 | 41471 | 2005-12-31 | 2004-12-22 | McClure | Donovan V. | Kamber Group 5663 | 2004-12-22 | Kamber Group | 4527 29th Street, NW | Washington | DC | 20008 |
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]) );