FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "New York" and Short_Form_First_Name = "Maria"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 12
- Daniel J. Edelman, Inc. 2
- Arnold Worldwide/NY 2
- Greek Government Office of Information 1
- Finnish Tourist Board, New York 1
- Package Express & Travel Agency, Inc. 1
- Fred Rosen Associates, Inc. 1
- Fred Rosen Associates, Inc. 1
- M. Silver Associates, Inc. 1
- Lou Hammond & Associates, Inc. 1
- VisitSweden 1
- Citigate, Inc. 1
- Media Planning International Corporation 1
Registrant_Name 11
- Arnold Worldwide/NY 2
- Daniel J. Edelman, Inc. 2
- Fred Rosen Associates, Inc. 2
- Citigate, Inc. 1
- Finnish Tourist Board, New York 1
- Greek Government Office of Information 1
- Lou Hammond & Associates, Inc. 1
- M. Silver Associates, Inc. 1
- Media Planning International Corporation 1
- Package Express & Travel Agency, Inc. 1
- VisitSweden 1
State 1
- NY 14
City 1
- New York · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4907 | 4907 | 1960-01-31 | 1959-02-27 | Wilhelm | Maria | Fred Rosen Associates, Inc. 1205 | 1959-02-27 | Fred Rosen Associates, Inc. | 65 East 55th Street | New York | NY | ||
5475 | 5475 | 2013-01-31 | 2011-09-15 | Castro | Maria | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 747 Third Avenue, 23rd Floor | New York | NY | 10017-2803 | |
8295 | 8295 | 2015-02-28 | 2010-11-17 | Winterstrid | Maria | VisitSweden 4885 | 1994-01-26 | VisitSweden | 655 Third Avenue | 18th Floor | New York | NY | 10017 |
12993 | 12993 | 1985-04-09 | 1971-04-19 | Noreika | Maria | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13527 | 13527 | 1971-04-16 | 1964-08-13 | Wilhelm | Maria | Fred Rosen Associates, Inc. 1488 | 1961-10-16 | Fred Rosen Associates, Inc. | 110 East 59th Street | New York | NY | 10022 | |
14938 | 14938 | 2006-04-30 | 2002-09-04 | Conte | Maria | Finnish Tourist Board, New York 573 | 1949-05-31 | Finnish Tourist Board, New York | 655 Third Avenue | Suite 1810 | New York | NY | 10017-5617 |
16095 | 16095 | 1986-05-12 | 1985-05-23 | Siff | Maria | Lou Hammond & Associates, Inc. 3682 | 1985-05-23 | Lou Hammond & Associates, Inc. | 39 East 51st Street | New York | NY | 10022-5901 | |
23322 | 23322 | 2020-07-15 | 2018-01-01 | Ruiz | Maria | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
31438 | 31438 | 2009-09-30 | 2009-03-19 | Schneider | Maria | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
36518 | 36518 | 2007-11-28 | 2008-04-22 | Schneider | Maria | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38639 | 38639 | 1995-12-18 | 1995-12-18 | Stokes | Maria | Citigate, Inc. 5089 | 1995-12-18 | Citigate, Inc. | 63 Wall Street | 34th Floor | New York | NY | 10005 |
39508 | 39508 | 1949-12-31 | 1947-12-10 | Moraitini | Maria | Greek Government Office of Information 449 | 1947-04-03 | Greek Government Office of Information | 30 Rockefeller Plaza | Rooms 1519 & 1817 | New York | NY | |
41395 | 41395 | 2005-12-31 | 2003-03-18 | Elia | Maria | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41442 | 41442 | 2005-12-31 | 2005-08-01 | Irwin | Maria | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 |
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]) );