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

21 rows where Registration_Number = 479

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date)

State 1

  • NY 21

Registration_Number 1

  • French Broadcasting System · 21 ✖

Registrant_Name 1

  • French Broadcasting System 21

City 1

  • New York 21
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
4193 4193 1950-01-21 1949-02-23 Devau Jean R. French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
4507 4507 1948-01-26 1947-07-21 Steinberg Bertha French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
9803 9803 1965-03-14 1962-08-24 Sese Robert Daniel Paul French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
12352 12352 1949-04-01 1948-08-18 Gruskin Edward Irving French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
13360 13360 1963-04-15 1951-04-09 Weltman Suzanne French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
15732 15732 1950-05-05 1948-04-23 Duhart Michel French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
30785 30785 1947-09-30 1947-07-21 Milo Henry Louis French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
31760 31760 1949-10-01 1948-08-18 Whiteside Marie Pertschuk French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
32560 32560 1966-10-10 1962-12-03 Allain Yves French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
36597 36597 1964-11-30 1962-07-27 Texier Michel Jules French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37818 37818 1967-12-06 1965-02-02 Anfrol Michel Katchoura French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37819 37819 1967-12-06 1949-02-23 Sauvage Leo French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37820 37820 1967-12-06 1967-05-11 Tournier Denis French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37821 37821 1967-12-06 1964-06-19 Benaich Guy French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37822 37822 1967-12-06 1964-06-19 Daval Julien Antoine French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37823 37823 1967-12-06 1964-06-19 Powers Robert Weatherly French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37824 37824 1967-12-06 1947-07-21 Hooley John Anthony Paul French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
37825 37825 1967-12-06 1964-09-14 Berard-Pedrazzo Philippe French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
38919 38919 1966-12-22 1964-06-19 Crassat Guy French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
39714 39714 1961-12-31 1948-08-18 Crenesse Pierre French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison Avenue   New York NY  
39790 39790 1965-12-31 1948-08-18 Lewitin Alice Mizner French Broadcasting System 479 1947-07-21 French Broadcasting System 501 Madison 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 673.723ms · 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