FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where Short_Form_First_Name = "Sean"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 23
- IDA Ireland 2
- Friends of Fine Gael, Inc. 2
- JETRO, New York 1
- JETRO, San Francisco 1
- Young & Rubicam, L.P. 1
- Friends of Fianna Fail, Inc. 1
- Daniel J. Edelman, Inc. 1
- North of England 1
- Lloyd's of London Market Representatives 1
- Fleishman-Hillard, Inc. 1
- Park Strategies, LLC 1
- Brownstein Hyatt Farber Schreck, LLP 1
- Park Strategies, LLC 1
- Lou Hammond & Associates, Inc. 1
- CRAFT I Media Digital 1
- R&R Partners, Inc. 1
- Park Strategies, LLC 1
- Rogich Communications Group 1
- VML, Inc. 1
- MMGY Global, LLC 1
- Ogilvy Group, LLC 1
- Larson Shannahan Slifka Group, LLC 1
- Ogilvy Group LLC 1
Registrant_Name 21
- Park Strategies, LLC 3
- Friends of Fine Gael, Inc. 2
- IDA Ireland 2
- Brownstein Hyatt Farber Schreck, LLP 1
- CRAFT I Media Digital 1
- Daniel J. Edelman, Inc. 1
- Fleishman-Hillard, Inc. 1
- Friends of Fianna Fail, Inc. 1
- JETRO, New York 1
- JETRO, San Francisco 1
- Larson Shannahan Slifka Group, LLC 1
- Lloyd's of London Market Representatives 1
- Lou Hammond & Associates, Inc. 1
- MMGY Global, LLC 1
- North of England 1
- Ogilvy Group LLC 1
- Ogilvy Group, LLC 1
- R&R Partners, Inc. 1
- Rogich Communications Group 1
- VML, Inc. 1
- Young & Rubicam, L.P. 1
City 12
- New York 11
- Boston 2
- Chicago 2
- Las Vegas 2
- Denver 1
- Des Moines 1
- Kansas City 1
- London 1
- Overland Park 1
- San Francisco 1
- St. Louis 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80 | 80 | 2022-01-07 | Simon | Sean | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
466 | 466 | 2020-02-28 | McWilliams | Sean | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 | |
1426 | 1426 | 2021-07-19 | Bryan | Sean | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 | |
1977 | 1977 | 2019-10-17 | Neary | Sean | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 | |
2201 | 2201 | 2021-11-19 | Moscynski | Sean | Larson Shannahan Slifka Group, LLC 6749 | 2019-11-12 | Larson Shannahan Slifka Group, LLC | 510 E. Locust Street | Suite 200 | Des Moines | IA | 50309 | |
2799 | 2799 | 2001-01-01 | 1986-09-09 | Fleming | Sean | Friends of Fianna Fail, Inc. 3596 | 1984-06-08 | Friends of Fianna Fail, Inc. | C/O Richardson Mahon Casey & Rooney, LLP | 1270 Avenue of the Americas #2911 | New York | NY | 10020 |
3307 | 3307 | 2017-01-06 | 2015-01-19 | Fellows | Sean | Rogich Communications Group 6274 | 2015-01-19 | Rogich Communications Group | 11920 Southern Highlands Parkway | Suite 301 | Las Vegas | NV | 89141 |
6096 | 6096 | 2022-02-03 | 2021-03-10 | Callahan | Sean | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
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 | |
14012 | 14012 | 2015-04-23 | 2014-06-23 | Tonner | Sean | R&R Partners, Inc. 6229 | 2014-06-23 | R&R Partners, Inc. | 900 South Pavilion Center Drive | Las Vegas | NV | 89144 | |
15035 | 15035 | 2011-04-30 | 2004-08-02 | Croson | Sean | North of England 3844 | 1986-06-16 | North of England | 444 N. Michigan Avenue | Suite 411 | Chicago | IL | 60611 |
18125 | 18125 | 2014-05-31 | 2013-06-19 | Layton | Sean | Lou Hammond & Associates, Inc. 5935 | 2009-05-15 | Lou Hammond & Associates, Inc. | 900 Third Avenue, Suite 401 | New York | NY | 10022 | |
22990 | 22990 | 2014-07-11 | 2014-07-07 | King | Sean | Park Strategies, LLC 6232 | 2014-07-07 | Park Strategies, LLC | 101 Park Avenue | Suite 2506 | New York | NY | 10178 |
23390 | 23390 | 2010-07-16 | 2008-02-06 | Lyngaas | Sean | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
27165 | 27165 | 2019-08-21 | 2019-03-20 | Simon | Sean | Ogilvy Group, LLC 6585 | 2018-08-30 | Ogilvy Group, LLC | 636 11th Avenue | New York | NY | 10036 | |
31590 | 31590 | 2016-09-30 | 2008-02-25 | McGovern | Sean | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
32046 | 32046 | 2011-10-01 | 2011-09-14 | Hackbarth | Sean | CRAFT I Media Digital 6061 | 2011-09-14 | CRAFT I Media Digital | 706 7th Street, SE | Washington | DC | 20003 | |
33151 | 33151 | 2007-10-18 | 2007-09-20 | King | Sean | Park Strategies, LLC 5830 | 2007-09-20 | Park Strategies, LLC | 101 Park Avenue | Suite 2506 | New York | NY | 10178 |
33732 | 33732 | 2017-10-27 | 2019-04-15 | Burns | Sean | VML, Inc. 6400 | 2016-12-23 | VML, Inc. | 250 Richards Road | Kansas City | MO | 64116 | |
35508 | 35508 | 1990-11-09 | 1985-05-24 | Skilling | Sean | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
36847 | 36847 | 1997-11-30 | 1996-04-25 | Barrett | Sean | Friends of Fine Gael, Inc. 5068 | 1995-11-08 | Friends of Fine Gael, Inc. | 55 Union Street | Suite 200 | Boston | MA | 02108-2400 |
36850 | 36850 | 1997-11-30 | 1996-04-25 | Murray | Sean | Friends of Fine Gael, Inc. 5068 | 1995-11-08 | Friends of Fine Gael, Inc. | 55 Union Street | Suite 200 | Boston | MA | 02108-2400 |
40068 | 40068 | 1978-12-31 | 1973-04-05 | Ward | Sean | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
41800 | 41800 | 2012-12-31 | 2009-01-09 | King | Sean | Park Strategies, LLC 5908 | 2009-01-09 | Park Strategies, LLC | 101 Park Avenue | Suite 2506 | New York | NY | 10178 |
41863 | 41863 | 2013-12-31 | 2010-05-06 | Lampe | Sean | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
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]) );