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

48 rows where Registration_Number = 364

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Registration_Date (date)

State 1

  • NY 48

Registration_Number 1

  • French Government Tourist Office · 48 ✖

Registrant_Name 1

  • French Government Tourist Office 48

City 1

  • New York 48
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
3476 3476 1964-01-09 1948-02-11 Tremel Georges Leon Auguste French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
3478 3478 1964-01-09 1959-10-28 Petrocik Joseph French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
3726 3726 1957-01-15 1953-07-17 de Koenigswarter Jules French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4257 4257 1985-01-22 1971-01-31 Dameuve Genevieve French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4258 4258 1985-01-22 1971-02-26 Abrioux Carol French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4259 4259 1985-01-22 1971-02-26 Hern George L. , Jr. French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4260 4260 1985-01-22 1961-03-06 Delobel Jacques Mary Albert Fernand French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4261 4261 1985-01-22 1976-04-05 Baudry Marie France French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4262 4262 1985-01-22 1973-06-12 Graffin Cecile French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4263 4263 1985-01-22 1973-06-12 Rothstein Liliane Waksberg French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4264 4264 1985-01-22 1971-08-03 Hess Barbara French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4265 4265 1985-01-22 1970-08-06 Moraillon Andre French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4266 4266 1985-01-22 1973-08-08 Couturier Michel French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4267 4267 1985-01-22 1946-10-17 Levesque Angele French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4299 4299 1961-01-23 1959-09-28 Vernhet Francoise French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4510 4510 1960-01-26 1947-04-11 Levin Martha Anne Levit French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4729 4729 1953-01-29 1947-04-11 Boutin Michel A. H. D. French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
4920 4920 1967-01-31 1964-12-07 Mackay Margaret Anne French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
5680 5680 1971-02-01 1955-02-18 Clement Myron David French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
11395 11395 1965-03-31 1957-06-05 Salles Simone B. A. French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
12397 12397 1969-04-01 1967-05-04 Lambert Philippe French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
14410 14410 1950-04-30 1946-07-25 de Croisset Philippe Wiener French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
14411 14411 1952-04-30 1950-04-06 Bosson Jean Michel French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
14477 14477 1970-04-30 1964-12-07 Duprat Charles French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
15733 15733 1973-05-05 1972-08-03 Baulmeige Yvan French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
16726 16726 1953-05-20 1950-09-05 Montheard Rene French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
17607 17607 1970-05-31 1959-02-10 Barget Jacqueline French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
18317 18317 1956-06-01 1956-04-11 Porson Sean Claude Gaston A. French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
19135 19135 1970-06-10 1967-05-04 Sauvayre Gorges French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
20648 20648 1955-06-30 1954-08-30 Wallace William Sheldon French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
23989 23989 1953-07-25 1953-03-23 Anderia Georges Jori French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
23992 23992 1958-07-25 1946-10-17 Reader Norman Quentin French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
24132 24132 1953-07-27 1950-09-05 de Manziarly Alexandre French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
24133 24133 1955-07-27 1946-10-17 Powell William Baker French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
24618 24618 1952-07-31 1947-04-11 Kenney Madlyn Bolton French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
26572 26572 1957-08-14 1953-10-15 Bouillier Jeannine Francoise French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
26573 26573 1959-08-14 1957-06-05 Stuart Martin Bennette French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
27869 27869 1968-08-31 1967-11-07 de Kerprigent Gildas Riou French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
29605 29605 1969-09-12 1959-02-10 Bardy Rene French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
30843 30843 1963-09-30 1957-06-05 Alphand Andre' French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
30885 30885 1968-09-30 1967-11-07 Baretz Harley S. French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
30905 30905 1972-09-30 1970-06-10 Ditrie Jacques French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
36601 36601 1966-11-30 1957-06-05 Kobtzeff Igor French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
36618 36618 1971-11-30 1970-06-10 Biggio Adela French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
39514 39514 1950-12-31 1946-07-25 Gaido Yvonne Antoinette French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
39553 39553 1956-12-31 1956-03-07 Bowen Robert Watson French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
39668 39668 1959-12-31 1959-02-10 Hyde Charlotte French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020
39866 39866 1969-12-31 1967-05-04 Berne Maurice French Government Tourist Office 364 1946-07-25 French Government Tourist Office 610 Fifth Avenue   New York NY 10020

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 702.34ms · 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