FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "Herbert"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 10
- Krosney Productions, Ltd. 2
- French National Railroads, New York 1
- National Film Board of Canada 1
- U.S. Office of the British Broadcasting Corporation 1
- Bennett Associates, Inc. 1
- Doremus & Company 1
- Partido Democrata Popular 1
- Fund for the Democratic Movement for Change 1
- Deutsche Telekom, Inc. 1
- Herzfeld & Rubin, P.C. 1
Registrant_Name 10
- Krosney Productions, Ltd. 2
- Bennett Associates, Inc. 1
- Deutsche Telekom, Inc. 1
- Doremus & Company 1
- French National Railroads, New York 1
- Fund for the Democratic Movement for Change 1
- Herzfeld & Rubin, P.C. 1
- National Film Board of Canada 1
- Partido Democrata Popular 1
- U.S. Office of the British Broadcasting Corporation 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7364 | 7364 | 1974-02-22 | 1973-04-10 | Schaefer | Herbert | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
11484 | 11484 | 1979-03-31 | 1977-02-22 | Anderson | Herbert | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
12383 | 12383 | 1964-04-01 | 1963-06-24 | McDonough | Herbert | Bennett Associates, Inc. 1140 | 1958-05-08 | Bennett Associates, Inc. | 605 Third Avenue | New York | NY | 10016 | |
13210 | 13210 | 1978-04-12 | 1972-11-16 | Christophers | Herbert | Partido Democrata Popular 2390 | 1972-11-16 | Partido Democrata Popular | 202 East 117th Street | New York | NY | 10035 | |
13950 | 13950 | 1982-04-23 | 1976-07-12 | Summers | Herbert | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
16937 | 16937 | 1977-05-23 | 1977-05-02 | Friedman | Herbert | Fund for the Democratic Movement for Change 2775 | 1977-04-12 | Fund for the Democratic Movement for Change | C/O Daniel Doron | 58 West 68th Street | New York | NY | 10023 |
19948 | 19948 | 1946-06-21 | 1945-12-03 | LeJeune | Herbert | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | 10020 | |
21281 | 21281 | 1997-06-30 | 1990-10-09 | Wirz | Herbert | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
23348 | 23348 | 1971-07-16 | 1970-02-12 | Krosney | Herbert | Krosney Productions, Ltd. 2180 | 1970-01-16 | Krosney Productions, Ltd. | 50 East 42nd Street | Suite 407 | New York | NY | 10017 |
23349 | 23349 | 1971-07-16 | 1971-03-12 | Krosney | Herbert | Krosney Productions, Ltd. 2180 | 1970-01-16 | Krosney Productions, Ltd. | 50 East 42nd Street | Suite 407 | New York | NY | 10017 |
36852 | 36852 | 1997-11-30 | 1996-05-06 | Rubin | Herbert | Herzfeld & Rubin, P.C. 5112 | 1996-05-06 | Herzfeld & Rubin, P.C. | 40 Wall Street | New York | NY | 10005 |
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]) );