FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Short_Form_Last_Name = "Nielsen"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
601 | 601 | 2009-03-19 | Nielsen | Anna | VisitDenmark 634 | 1950-07-25 | VisitDenmark | 655 Third Avenue | 18th Floor, Suite 2010 | New York | NY | 10017 | |
9340 | 9340 | 1960-03-07 | 1959-04-16 | Nielsen | Alice L. | University Travel Company 1218 | 1959-04-16 | University Travel Company | 18 Brattle Street | Cambridge | MA | ||
13127 | 13127 | 1946-04-11 | 1945-04-11 | Nielsen | Tage | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
18603 | 18603 | 2021-06-01 | 2017-05-09 | Nielsen | Mike | CGCN Group 6396 | 2016-11-30 | CGCN Group | 1307 New York Avenue, NW | 6th Floor | Washington | DC | 20005 |
20731 | 20731 | 1963-06-30 | 1961-01-23 | Nielsen | Bent Winter | Scandinavian Railways 736 | 1952-07-23 | Scandinavian Railways | 630 Fifth Avenue | Room 901 | New York | NY | 10020 |
24502 | 24502 | 1991-07-30 | 1991-03-13 | Nielsen | Hollie | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 |
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]) );