FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Registrant_Name = "Ginsburg, Feldman & Bress", "Short_Form_Termination_Date" is on date 1970-03-16 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- DC · 12 ✖
Registration_Number 1
Registrant_Name 1
- Ginsburg, Feldman & Bress · 12 ✖
City 1
- Washington 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10032 | 10032 | 1970-03-16 | 1952-04-16 | Leventhal | Harold | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10033 | 10033 | 1970-03-16 | 1966-04-20 | Friedman | Alvin | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10034 | 10034 | 1970-03-16 | 1967-04-20 | Zentay | John H. | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10035 | 10035 | 1970-03-16 | 1961-04-21 | Bebchick | Leonard Norman | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10036 | 10036 | 1970-03-16 | 1964-05-19 | Abrams | George Saul | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10037 | 10037 | 1970-03-16 | 1964-06-15 | Egert | Leonard G. | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10038 | 10038 | 1970-03-16 | 1964-06-23 | Myers | Kenneth Morton | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10039 | 10039 | 1970-03-16 | 1948-09-16 | Ginsburg | David | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10040 | 10040 | 1970-03-16 | 1951-10-15 | Brown | Darwin Charles | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10041 | 10041 | 1970-03-16 | 1965-10-18 | Marks | Lee Robert | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10042 | 10042 | 1970-03-16 | 1967-10-18 | Samuel | Frank E. , Jr. | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC | ||
10043 | 10043 | 1970-03-16 | 1966-10-20 | Miser | Robert Newman | Ginsburg, Feldman & Bress 540 | 1948-09-16 | Ginsburg, Feldman & Bress | 914 Ring Building | Washington | DC |
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]) );