FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Short_Form_Last_Name = "Scanlon"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 13
- Daniel J. Edelman, Inc. 2
- Enterprise Ireland 1
- Edelman International Corporation 1
- Daniel J. Edelman, Inc. 1
- Jones Day 1
- Daniel J. Edelman, Inc. 1
- Sawyer Miller Group 1
- Benchmarks, Inc. 1
- Abernathy/MacGregor Group, Inc. 1
- Al Paul Lefton Company, Inc. 1
- Icon Group 1
- Al Paul Lefton Company Inc. 1
- Fleishman-Hillard, Inc. 1
Registrant_Name 11
City 6
- New York 5
- Washington 4
- Philadelphia 2
- Bronxville 1
- Chicago 1
- St. Louis 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7981 | 7981 | 1991-02-28 | 1986-08-08 | Scanlon | John P. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
9592 | 9592 | 2023-03-10 | 2022-11-16 | Scanlon | Sean | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9633 | 9633 | 1993-03-11 | 1989-02-17 | Scanlon | Melissa T. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
19399 | 19399 | 1976-06-14 | 1975-12-16 | Scanlon | Michael B. | Daniel J. Edelman, Inc. 2640 | 1975-12-15 | Daniel J. Edelman, Inc. | 1730 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
21393 | 21393 | 2001-06-30 | 1994-05-06 | Scanlon | Raymond D. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
24884 | 24884 | 1996-07-31 | 1992-12-11 | Scanlon | John P. | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | 501 Madison Avenue | Suite 1300 | New York | NY | 10022 |
24901 | 24901 | 1998-07-31 | 1985-01-09 | Scanlon | John Patrick | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
24984 | 24984 | 2000-07-31 | 1996-11-12 | Scanlon | John P. | Icon Group 4926 | 1994-07-08 | Icon Group | 130 Pondfield Road | Suite 1 | Bronxville | NY | 10708 |
26497 | 26497 | 1987-08-12 | 1986-07-09 | Scanlon | Thomas J. | Benchmarks, Inc. 3852 | 1986-07-09 | Benchmarks, Inc. | 3248 Prospect Street, N.W. | Washington | DC | 20007 | |
28535 | 28535 | 2009-08-31 | 2007-04-09 | Scanlon | Jennifer | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
28551 | 28551 | 2010-08-31 | 2004-03-25 | Scanlon | Raymond D. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
29748 | 29748 | 1993-09-14 | 1991-06-11 | Scanlon | John | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
33496 | 33496 | 1992-10-23 | 1991-04-18 | Scanlon | John P. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
39331 | 39331 | 1982-12-30 | 1978-03-13 | Scanlon | Michael B. | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | 1730 Pennsylvania Avenue, N.W. | Room 460 | 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]) );