FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

14 rows where Registration_Number = 540

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date)

State 1

Registration_Number 1

  • Ginsburg, Feldman & Bress · 14 ✖

Registrant_Name 1

City 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
2553 2553 1970-01-01 1963-10-18 Hausman Robert M. Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress 914 Ring Building   Washington DC  
4331 4331 1951-01-24 1948-09-16 Leventhal Harold Ginsburg, Feldman & Bress 540 1948-09-16 Ginsburg, Feldman & Bress 914 Ring Building   Washington DC  
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

CSV options: 

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])
);