FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Short_Form_Last_Name = "Andrews"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 18
- Squire, Sanders & Dempsey, L.L.P. 3
- Squire Patton Boggs, LLP 2
- Hill and Knowlton Strategies, LLC 2
- Wood, Randell K. 2
- Galland, Kharasch, Calkins & Short, P.C. 1
- China Books & Periodicals, Inc. 1
- Artley, Inc. 1
- Alpine Tourist Office 1
- Doub & Muntzing, Charterd 1
- Fergo Graff, Inc. 1
- Bozell & Jacobs Public Relations, Inc. 1
- Bishop, Cook, Purcell & Reynolds 1
- APCO Associates 1
- Andrews Associates, Inc. 1
- Walter E. Fauntroy & Associates, Inc. (WEFA) 1
- Smith, Dawson & Andrews, Inc. 1
- King & Spalding, LLP 1
- Witt Global Partners, LLC 1
Registrant_Name 18
- Squire, Sanders & Dempsey, L.L.P. 3
- Hill and Knowlton Strategies, LLC 2
- Squire Patton Boggs, LLP 2
- Wood, Randell K. 2
- APCO Associates 1
- Alpine Tourist Office 1
- Andrews Associates, Inc. 1
- Artley, Inc. 1
- Bishop, Cook, Purcell & Reynolds 1
- Bozell & Jacobs Public Relations, Inc. 1
- China Books & Periodicals, Inc. 1
- Doub & Muntzing, Charterd 1
- Fergo Graff, Inc. 1
- Galland, Kharasch, Calkins & Short, P.C. 1
- King & Spalding, LLP 1
- Smith, Dawson & Andrews, Inc. 1
- Walter E. Fauntroy & Associates, Inc. (WEFA) 1
- Witt Global Partners, LLC 1
City 4
- Washington 16
- New York 4
- Springfield 2
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1104 | 1104 | 2021-05-25 | Andrews | Thomas S | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | ||
6367 | 6367 | 1979-02-08 | 1974-04-19 | Andrews | John Paul | Fergo Graff, Inc. 2511 | 1974-04-19 | Fergo Graff, Inc. | 110 East 59th Street | New York | NY | 10022 | |
6394 | 6394 | 1983-02-08 | 1977-09-09 | Andrews | Dale Carter | Galland, Kharasch, Calkins & Short, P.C. 1051 | 1957-07-09 | Galland, Kharasch, Calkins & Short, P.C. | 1054 - 31st Street, N.W. | Washington | DC | 20007 | |
10231 | 10231 | 1988-03-18 | 1986-04-17 | Andrews | Todd G. | APCO Associates 3597 | 1984-06-20 | APCO Associates | Three Lafayette Centre | 1155 - 21st Street, N.W. #1000 | Washington | DC | 20036 |
12496 | 12496 | 1992-04-01 | 1991-07-05 | Andrews | Frank | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18902 | 18902 | 1981-06-05 | 1980-04-23 | Andrews | Michael P. | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | 1400 L Street, N.W. | Washington | DC | 20005-3502 | |
21369 | 21369 | 2000-06-30 | 1995-12-12 | Andrews | Gregory B. | Smith, Dawson & Andrews, Inc. 5085 | 1995-12-12 | Smith, Dawson & Andrews, Inc. | 1000 Connecticut Avenue, N.W. | Suite 302 | Washington | DC | 20036 |
21985 | 21985 | 2021-06-30 | 2021-06-21 | Andrews | Thomas S | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
22061 | 22061 | 1967-07-01 | 1964-01-17 | Andrews | John Paul | Artley, Inc. 1681 | 1964-01-17 | Artley, Inc. | C/O Eugene J. Cohen | 405 East 56th Street | New York | NY | 10022 |
22769 | 22769 | 1993-07-08 | 1991-02-12 | Andrews | Tom | Wood, Randell K. 4143 | 1988-05-18 | Wood, Randell K. | 1736 East Sunshine | Suite 517 | Springfield | MO | 65804 |
23860 | 23860 | 1992-07-23 | 1991-01-03 | Andrews | Rawle | 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 |
25303 | 25303 | 2017-07-31 | 2016-09-26 | Andrews | Michael A. | King & Spalding, LLP 6307 | 2015-07-24 | King & Spalding, LLP | 1700 Pennsylvania Avenue, NW | Suite 200 | Washington | DC | 20006 |
27200 | 27200 | 1986-08-22 | 1986-07-11 | Andrews | Patricia E. | 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 |
27345 | 27345 | 1992-08-24 | 1991-11-05 | Andrews | Wright H. | Walter E. Fauntroy & Associates, Inc. (WEFA) 4587 | 1991-11-05 | Walter E. Fauntroy & Associates, Inc. (WEFA) | 1025 Connecticut Avenue, N.W. | Suite 610 | Washington | DC | 20036 |
27588 | 27588 | 1991-08-28 | 1988-08-10 | Andrews | Thomas B. | Wood, Randell K. 4143 | 1988-05-18 | Wood, Randell K. | 1736 East Sunshine | Suite 517 | Springfield | MO | 65804 |
28473 | 28473 | 2006-08-31 | 2006-08-02 | Andrews | Mary Catherine | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
30940 | 30940 | 1980-09-30 | 1979-12-05 | Andrews | Alice C. | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
31595 | 31595 | 2016-09-30 | 2016-05-11 | Andrews | Mary Catherine | Witt Global Partners, LLC 6348 | 2016-04-02 | Witt Global Partners, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
37400 | 37400 | 1988-12-01 | 1987-11-25 | Andrews | Mark | Andrews Associates, Inc. 4062 | 1987-11-25 | Andrews Associates, Inc. | 2550 M Street, N.W. | Suite 450 | Washington | DC | 20037 |
37607 | 37607 | 1980-12-02 | 1975-10-14 | Andrews | Michael P. | Doub & Muntzing, Charterd 2458 | 1973-09-10 | Doub & Muntzing, Charterd | 1875 I Street, N.W. | Suite 775 | Washington | DC | 20006 |
37621 | 37621 | 1997-12-02 | 1995-01-27 | Andrews | Rawle , Jr. | 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 |
39963 | 39963 | 1974-12-31 | 1974-06-24 | Andrews | John Paul | Bozell & Jacobs Public Relations, Inc. 2522 | 1974-06-24 | Bozell & Jacobs Public Relations, Inc. | 1 Dag Hammarskjold Plaza | New York | NY | 10017 | |
40503 | 40503 | 1988-12-31 | 1974-06-26 | Andrews | John Paul | Alpine Tourist Office 2052 | 1967-09-27 | Alpine Tourist Office | C/O Austrian Tourist Office, Inc. | 608 Fifth Avenue | New York | NY | 10020 |
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]) );