FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "Washington" and "Short_Form_Termination_Date" is on date 1981-12-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40183 | 40183 | 1981-12-31 | 1978-05-04 | Lowenstein | Robert | Newman & Holtzinger, P.C. 2895 | 1978-05-04 | Newman & Holtzinger, P.C. | 1615 L Street, N.W. | Suite 1000 | Washington | DC | 20036 |
40184 | 40184 | 1981-12-31 | 1981-05-08 | Kaplan | Julius | Kaplan, Russin & Vecchi 3238 | 1981-05-08 | Kaplan, Russin & Vecchi | 1218 - 16th Street, N.W. | Washington | DC | 20036 | |
40186 | 40186 | 1981-12-31 | 1969-05-14 | Whalen | John F. | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
40191 | 40191 | 1981-12-31 | 1981-08-07 | Graham | Thomas R. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
40197 | 40197 | 1981-12-31 | 1980-09-30 | Devine | James T. | Lipsen, Charles B. 3152 | 1980-09-30 | Lipsen, Charles B. | 1826 Calvert Street, N.W. | Washington | DC | 20009 | |
40198 | 40198 | 1981-12-31 | 1980-09-30 | Leonard | Jerris | Lipsen, Charles B. 3152 | 1980-09-30 | Lipsen, Charles B. | 1826 Calvert Street, N.W. | Washington | DC | 20009 | |
40200 | 40200 | 1981-12-31 | 1979-10-04 | Mock | William B.T. , Jr. | Metzger, Shadyac & Schwarz 2861 | 1978-01-25 | Metzger, Shadyac & Schwarz | 1275 K Street, N.W. | 10th Floor | Washington | DC | 20005 |
40201 | 40201 | 1981-12-31 | 1977-10-13 | Mickaelian | Fred , Jr. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
40204 | 40204 | 1981-12-31 | 1979-10-22 | Adams | Cary M. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
40206 | 40206 | 1981-12-31 | 1976-11-16 | Wise | Edmund N. | Dutton & Dutton, P.C. 2591 | 1975-06-12 | Dutton & Dutton, P.C. | 5017 Tilden Street, N.W. | Washington | DC | 20016 |
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]) );