FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_Last_Name = "Reilly"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 12
Registrant_Name 12
City 7
- Washington 6
- New York 4
- Chicago 2
- Bannockburn 1
- Baton Rouge 1
- Kansas City 1
- Silver Spring 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3506 | 3506 | 2020-01-09 | 2017-06-09 | Reilly | Michelle T. | Ashcroft Law Firm, LLC 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2710 | Kansas City | MO | 64105 |
3707 | 3707 | 1994-01-14 | 1992-04-07 | Reilly | Joan | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
4637 | 4637 | 1995-01-27 | 1994-07-05 | Reilly | John C. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
7862 | 7862 | 1970-02-28 | 1964-02-10 | Reilly | Madeleine Halpin | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9025 | 9025 | 1989-03-03 | 1986-05-28 | Reilly | James V. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
13700 | 13700 | 1995-04-18 | 1990-04-13 | Reilly | Terry | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
21316 | 21316 | 1998-06-30 | 1993-12-14 | Reilly | John R. | Baker & McKenzie 4591 | 1991-11-12 | Baker & McKenzie | 815 Connecticut Avenue, N.W. | Suite 900 | Washington | DC | 20006 |
23865 | 23865 | 1992-07-23 | 1991-01-03 | Reilly | John C. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
24355 | 24355 | 1980-07-29 | 1979-04-02 | Reilly | John R. | DGA International, Inc. 2621 | 1975-10-28 | DGA International, Inc. | 1110 Bonifant Street | Silver Spring | MD | 20910 | |
25547 | 25547 | 1987-08-01 | 1986-08-13 | Reilly | John R. | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | 1400 L Street, N.W. | Washington | DC | 20005-3502 | |
25712 | 25712 | 2015-08-01 | 2011-07-22 | Reilly | Michael A. | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25814 | 25814 | 2008-08-02 | 2007-01-25 | Reilly | Kathleen | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
28613 | 28613 | 2015-08-31 | 2014-08-18 | Reilly | Patricia A. | AUX Initiatives, LLC 6238 | 2014-08-04 | AUX Initiatives, LLC | 6298 Seven Oaks Avenue | Baton Rouge | LA | 70806 | |
28732 | 28732 | 1955-09-01 | 1955-03-18 | Reilly | Arthur | John Moynahan & Associates 879 | 1955-03-18 | John Moynahan & Associates | 380 Madison Avenue | New York | NY | ||
29683 | 29683 | 1993-09-13 | 1989-03-10 | Reilly | John R. | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | 1400 L Street, N.W. | Washington | DC | 20005-3502 | |
35029 | 35029 | 2014-11-01 | 2014-02-05 | Reilly | Patricia | Potomac Square Group 6096 | 2012-03-27 | Potomac Square Group | 660 Pennsylvania Ave., SE | Suite 303 | Washington | DC | 20003 |
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]) );