FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington", Registration_Number = 759 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Registration_Date (date)
State 1
- DC · 13 ✖
Registration_Number 1
- France Actuelle · 13 ✖
Registrant_Name 1
City 1
- Washington · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10783 | 10783 | 1974-03-26 | 1953-03-02 | de Tchihatchef | Margaretha Johanna | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
10784 | 10784 | 1974-03-26 | 1967-09-13 | Ponsart | Gaston | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
11335 | 11335 | 1954-03-31 | 1954-03-04 | Veber | Monique Denyse O'Connor | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
12623 | 12623 | 1974-04-02 | 1954-08-02 | Raushenbush | Josephine Joan | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
14413 | 14413 | 1954-04-30 | 1953-07-10 | Korns | William Alexander | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
14414 | 14414 | 1954-04-30 | 1953-08-13 | Stein | Julian Samuel , Jr. | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
19480 | 19480 | 1954-06-15 | 1953-03-02 | Kuhn | Mary Coggeshall | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
24619 | 24619 | 1953-07-31 | 1953-03-02 | Bolles | Edmund Blair | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
29551 | 29551 | 1953-09-11 | 1954-03-04 | Grigaut | Hubert Lucien | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
29930 | 29930 | 1955-09-16 | 1954-11-23 | Winne | Sandra Annette | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
35783 | 35783 | 1954-11-15 | 1954-09-28 | Chapin | Mary Granger | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
36284 | 36284 | 1955-11-24 | 1954-07-23 | Sharon | John Hurford | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
39532 | 39532 | 1954-12-31 | 1954-09-28 | Tennyson | Leonard B. | France Actuelle 759 | 1953-03-02 | France Actuelle | 918 - 16th Street, N.W. | Room 401 | Washington | DC | 20006 |
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]) );