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 = "O'Connor"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 14
- Australian Information Service 1
- U.S. Office of the British Broadcasting Corporation 1
- Tourism Australia 1
- Ruder Finn, Inc. 1
- O'Connor, Green, Thomas & Walters 1
- Squire Patton Boggs, LLP 1
- O'Connor & Hannan 1
- O'Connor & Hannan, L.L.P. 1
- Hill and Knowlton Strategies, LLC 1
- Cassidy & Associates, Inc. 1
- McDermott Will & Emery, LLP 1
- Venn Strategies, LLC 1
- CGCN Group 1
- Sanitas International, Inc. 1
Registrant_Name 14
- Australian Information Service 1
- CGCN Group 1
- Cassidy & Associates, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- McDermott Will & Emery, LLP 1
- O'Connor & Hannan 1
- O'Connor & Hannan, L.L.P. 1
- O'Connor, Green, Thomas & Walters 1
- Ruder Finn, Inc. 1
- Sanitas International, Inc. 1
- Squire Patton Boggs, LLP 1
- Tourism Australia 1
- U.S. Office of the British Broadcasting Corporation 1
- Venn Strategies, LLC 1
City 3
- Washington 10
- New York 3
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7504 | 7504 | 1978-02-24 | 1968-09-17 | O'Connor | Jean | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10014 | 10014 | 2020-03-15 | 2019-11-22 | O'Connor | Reilly | Sanitas International, Inc. 6530 | 2018-03-07 | Sanitas International, Inc. | 1629 K Street, NW | Suite 300 | Washington | DC | 20006 |
14857 | 14857 | 2001-04-30 | 1978-10-25 | O'Connor | Patrick J. | O'Connor & Hannan, L.L.P. 2972 | 1978-10-25 | O'Connor & Hannan, L.L.P. | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006 |
18427 | 18427 | 1977-06-01 | 1976-05-10 | O'Connor | Patrick J. | O'Connor & Hannan 2691 | 1976-05-10 | O'Connor & Hannan | 1747 Pennsylvania Avenue, N.W. | Washington | NY | 20006 | |
19594 | 19594 | 2010-06-15 | 2010-04-29 | O'Connor | Eileen M. | McDermott Will & Emery, LLP 5986 | 2010-04-29 | McDermott Will & Emery, LLP | 600 13th Street, NW | Washington | DC | 20005 | |
23700 | 23700 | 1948-07-21 | 1946-12-31 | O'Connor | Arthur Henry | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
27798 | 27798 | 2003-08-30 | 2003-06-23 | O'Connor | Eileen M. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
32949 | 32949 | 2012-10-15 | 2012-08-03 | O'Connor | Christine | Venn Strategies, LLC 6110 | 2012-06-14 | Venn Strategies, LLC | 805 15th Street, NW | Suite 650 | Washington | DC | 20005 |
34171 | 34171 | 1970-10-31 | 1964-09-25 | O'Connor | David Francis | Tourism Australia 1032 | 1957-06-03 | Tourism Australia | 2029 Century Park East | Suite 3150 | Los Angeles | CA | 90067 |
36040 | 36040 | 1964-11-19 | 1964-05-19 | O'Connor | Patrick John | O'Connor, Green, Thomas & Walters 1738 | 1964-05-19 | O'Connor, Green, Thomas & Walters | 508 Federal Bar Building | 1815 H Street, N.W. | Washington | DC | |
37430 | 37430 | 1991-12-01 | 1990-09-21 | O'Connor | Steve | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
37538 | 37538 | 2018-12-01 | 2017-04-12 | O'Connor | Patrick Michael | CGCN Group 6396 | 2016-11-30 | CGCN Group | 1307 New York Avenue, NW | 6th Floor | Washington | DC | 20005 |
39391 | 39391 | 1988-12-30 | 1974-08-12 | O'Connor | James Joseph | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
41724 | 41724 | 2010-12-31 | 2007-10-04 | O'Connor | Christine A. | Cassidy & Associates, Inc. 5643 | 2004-09-10 | Cassidy & Associates, Inc. | 700 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
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]) );