home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

31 rows where Registration_Number = 996

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 31

Registration_Number 1

  • Communications Counselors, Inc. · 31 ✖

Registrant_Name 1

  • Communications Counselors, Inc. 31

City 1

  • New York 31
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
9887 9887 1959-03-15 1959-03-05 Smith Ralph W. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
11355 11355 1959-03-31 1957-12-24 Chase William Howard Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
17565 17565 1958-05-31 1958-03-28 Vandeburg Clyde M. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25908 25908 1959-08-04 1957-02-04 Benn Gale D. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25909 25909 1959-08-04 1957-02-04 Brecker Richard Lee Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25910 25910 1959-08-04 1957-02-04 Hefter Frank Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25911 25911 1959-08-04 1957-02-04 Patterson Buell Averell Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25912 25912 1959-08-04 1959-03-05 Berk Harry Augustus Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25913 25913 1959-08-04 1958-03-28 Berchtold William Edward Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25914 25914 1959-08-04 1958-03-28 Bray William H. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25915 25915 1959-08-04 1958-03-28 Gosselin Robert Thomas Astor Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25916 25916 1959-08-04 1958-03-28 Losee Thomas Penny Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25917 25917 1959-08-04 1958-03-28 MaCafee Donald Rosco Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25918 25918 1959-08-04 1958-03-28 Martin Wiss Murray Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25919 25919 1959-08-04 1958-03-28 Tomlinson Harry J. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25920 25920 1959-08-04 1958-09-15 Friend Charles Wood Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25921 25921 1959-08-04 1958-09-15 Hedge Frank Scott Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25922 25922 1959-08-04 1958-09-15 Owsley David Thomas Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25923 25923 1959-08-04 1957-10-18 Griswold Dixon B. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25924 25924 1959-08-04 1957-10-18 White Frank Kiggins Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25925 25925 1959-08-04 1957-11-18 Allen Frank A. , Jr. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25926 25926 1959-08-04 1957-11-18 Carruthers Ben Frederick Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25927 25927 1959-08-04 1957-11-18 Harper Marion , Jr. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25928 25928 1959-08-04 1957-11-18 Holme Benjamin F. , Jr. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25929 25929 1959-08-04 1957-11-18 Kollenborn Roy Craik Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25930 25930 1959-08-04 1957-11-18 Longyear Peter Rudston Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
25931 25931 1959-08-04 1957-11-18 Shattuck Margaret Ettinger Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
30812 30812 1958-09-30 1957-02-04 Baumer Edward Ferdinand Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
30813 30813 1958-09-30 1958-04-04 Mayer Edward Newton , Jr. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
30815 30815 1958-09-30 1957-10-18 Bennett Harry M. , Jr. Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  
38719 38719 1958-12-19 1957-02-04 Dudley Herman Andrew Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. 750 Third Avenue   New York NY  

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])
);
Powered by Datasette · Queries took 696.906ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows