FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where "Short_Form_Termination_Date" is on date 2007-01-01
This data as json, CSV (advanced)
Registration_Number 12
Registrant_Name 12
City 6
- Washington 13
- New York 3
- Reston 2
- Arlington 1
- Los Angeles 1
- North Barrington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2841 | 2841 | 2007-01-01 | 1997-03-04 | Gardner | Barbara K. | Leventhal, Senter & Lerman, PLLC 5161 | 1997-03-04 | Leventhal, Senter & Lerman, PLLC | 2000 K Street, N.W. | Suite 600 | Washington | DC | 20006-1809 |
2842 | 2842 | 2007-01-01 | 2004-03-12 | Leonard | Robert J. | Clark Consulting 5611 | 2004-03-12 | Clark Consulting | 102 South Wynstone Park Drive | North Barrington | IL | 60010 | |
2843 | 2843 | 2007-01-01 | 2001-03-23 | Egelston | Phillip | International Registries, Inc. 4533 | 1991-07-01 | International Registries, Inc. | 11495 Commerce Park Drive | Reston | VA | 20191-1506 | |
2844 | 2844 | 2007-01-01 | 2003-05-05 | Blacklin | Scott | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
2845 | 2845 | 2007-01-01 | 2003-07-01 | Barber, III | Robert J. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2846 | 2846 | 2007-01-01 | 1979-07-16 | Lipton | Charles | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
2847 | 2847 | 2007-01-01 | 1962-08-09 | Ruder | William | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
2848 | 2848 | 2007-01-01 | 2005-08-15 | Kohler | Nancy L. | Richard L. Collins & Company, Inc. 5537 | 2003-01-22 | Richard L. Collins & Company, Inc. | 2111 Wilson Boulevard | Suite 700 | Arlington | VA | 22201 |
2849 | 2849 | 2007-01-01 | 1985-09-13 | Tompkins | Joseph B. , Jr. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
2850 | 2850 | 2007-01-01 | 2006-09-19 | Davenport | Rory | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2851 | 2851 | 2007-01-01 | 2001-10-03 | Plankl | Kurt B. | International Registries, Inc. 4533 | 1991-07-01 | International Registries, Inc. | 11495 Commerce Park Drive | Reston | VA | 20191-1506 | |
2852 | 2852 | 2007-01-01 | 2006-10-10 | Medina | Carla | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | 1850 M Street, NW | Suite 900 | Washington | DC | 20036 |
2853 | 2853 | 2007-01-01 | 2006-10-20 | Nelson | Reid | Capitol Links LLC 5761 | 2006-06-27 | Capitol Links LLC | 1300 Pennsylvania Avenue, NW | Suite 700 | Washington | DC | 20004 |
2854 | 2854 | 2007-01-01 | 2001-10-23 | McCabe | Ian | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
2855 | 2855 | 2007-01-01 | 2003-10-30 | Masters | Rich | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2856 | 2856 | 2007-01-01 | 2006-10-31 | Begala | Chris | Capitol Links LLC 5761 | 2006-06-27 | Capitol Links LLC | 1300 Pennsylvania Avenue, NW | Suite 700 | Washington | DC | 20004 |
2857 | 2857 | 2007-01-01 | 2005-11-01 | Goldberg | Donald F. | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2858 | 2858 | 2007-01-01 | 2006-12-08 | Milmoe | Peter | Sitrick and Company, Inc. 5777 | 2006-11-20 | Sitrick and Company, Inc. | 1840 Century Park East | Suite 800 | Los Angeles | CA | 90067-2109 |
2859 | 2859 | 2007-01-01 | 2006-12-19 | Martin | Charles | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2860 | 2860 | 2007-01-01 | 2006-12-19 | Michael | Kathleen Connors | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
2861 | 2861 | 2007-01-01 | 1966-12-30 | Warshaw | Saul Leon | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 |
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]) );