FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where City = "New York" and Short_Form_First_Name = "Patricia"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 19
- Needham, Harper & Steers Advertising, Inc. 3
- Young & Rubicam, L.P. 3
- Quebec Government Office 2
- Saatchi & Saatchi North America, Inc. 2
- GCI Group, Inc. 2
- Bermuda Tourism Authority 1
- Geyer & Oswald, Inc. 1
- Mexican Tourism Board 1
- Government of Ontario, Canada 1
- Doremus & Company 1
- Patricia Ryan Public Relations, Inc. 1
- August Group, Inc. 1
- Richard Weiner, Inc. 1
- St. Vincent, Richard L. 1
- Arnold Worldwide/NY 1
- Supporters of Fine Gael, Inc. 1
- Doremus & Company 1
- Media Planning International Corporation 1
- Havas Media Group USA LLC 1
Registrant_Name 18
- Needham, Harper & Steers Advertising, Inc. 3
- Young & Rubicam, L.P. 3
- Doremus & Company 2
- GCI Group, Inc. 2
- Quebec Government Office 2
- Saatchi & Saatchi North America, Inc. 2
- Arnold Worldwide/NY 1
- August Group, Inc. 1
- Bermuda Tourism Authority 1
- Geyer & Oswald, Inc. 1
- Government of Ontario, Canada 1
- Havas Media Group USA LLC 1
- Media Planning International Corporation 1
- Mexican Tourism Board 1
- Patricia Ryan Public Relations, Inc. 1
- Richard Weiner, Inc. 1
- St. Vincent, Richard L. 1
- Supporters of Fine Gael, Inc. 1
State 1
- NY 26
City 1
- New York · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1540 | 1540 | 2018-07-30 | Gruver | Patricia | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 | |
3517 | 3517 | 1976-01-10 | 1973-10-09 | Ryan | Patricia | Patricia Ryan Public Relations, Inc. 2465 | 1973-10-09 | Patricia Ryan Public Relations, Inc. | 412 East 55th Street | New York | NY | 10022 | |
5793 | 5793 | 1995-02-01 | 1990-01-29 | Cerisola | Patricia | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
6610 | 6610 | 1980-02-11 | 1976-08-11 | Wagner | Patricia | August Group, Inc. 2620 | 1975-10-21 | August Group, Inc. | 295 Madison Avenue | New York | NY | 10017 | |
12044 | 12044 | 2009-03-31 | 2008-07-10 | O'Dwyer | Patricia | Supporters of Fine Gael, Inc. 5798 | 2007-03-08 | Supporters of Fine Gael, Inc. | 52 Duane Street | 5th Floor | New York | NY | 10007 |
12454 | 12454 | 1985-04-01 | 1983-12-06 | Dillon | Patricia | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
14139 | 14139 | 1990-04-26 | 1986-07-21 | Schettino | Patricia | St. Vincent, Richard L. 3928 | 1986-07-21 | St. Vincent, Richard L. | 1156 Avenue of the Americas | New York | NY | 10036 | |
14412 | 14412 | 1954-04-30 | 1952-02-08 | Farrelly | Patricia | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
16111 | 16111 | 1989-05-12 | 1982-04-30 | Smith | Patricia | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
17831 | 17831 | 1995-05-31 | 1994-08-19 | Dougherty | Patricia | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
20967 | 20967 | 1980-06-30 | 1969-10-17 | O'Hare | Patricia | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
22223 | 22223 | 1992-07-01 | 1990-08-17 | Lyons | Patricia | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
25642 | 25642 | 2003-08-01 | 2003-08-08 | Mensah | Patricia | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
25738 | 25738 | 2016-08-01 | 2016-08-01 | Nacer | Patricia | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
25944 | 25944 | 1980-08-04 | 1978-04-25 | Nowlin | Patricia | Richard Weiner, Inc. 2892 | 1978-04-25 | Richard Weiner, Inc. | 888 Seventh Avenue | New York | NY | 10019 | |
28651 | 28651 | 2018-08-31 | 2017-09-14 | Rakos | Patricia | Doremus & Company 6387 | 2016-10-28 | Doremus & Company | 437 Madison Avenue | 5th Floor | New York | NY | 10022 |
30504 | 30504 | 1985-09-26 | 1977-03-24 | Allen | Patricia | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
32403 | 32403 | 1980-10-07 | 1975-08-11 | Kaufman | Patricia | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
32414 | 32414 | 1988-10-07 | 1988-10-04 | Kenney | Patricia | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
33235 | 33235 | 1974-10-20 | 1968-08-20 | O'Hare | Patricia | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
35480 | 35480 | 1990-11-09 | 1987-01-12 | Widyn | Patricia | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
35493 | 35493 | 1990-11-09 | 1987-05-13 | Roback | Patricia | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
37299 | 37299 | 1972-12-01 | 1971-09-20 | O'Hare | Patricia | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
38458 | 38458 | 2020-12-15 | 2020-01-30 | Pagliery | Patricia | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
39243 | 39243 | 1970-12-28 | 1966-08-25 | Schettino | Patricia | Geyer & Oswald, Inc. 1468 | 1961-08-01 | Geyer & Oswald, Inc. | 555 Madison Avenue | New York | NY | 10022 | |
41416 | 41416 | 2005-12-31 | 2002-06-05 | Frazier | Patricia | 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]) );