FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_First_Name = "William S."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Culbertson, Pendleton & Pendleton 1
- Development & Resources Corporation 1
- Pendleton & McLaughlin 1
- Squire Patton Boggs, LLP 1
- Hogan Lovells US LLP 1
- Doremus & Company 1
- Keating Group, Inc. 1
- White & Case, LLP 1
- Doyle, Graf & Mabley, Inc. 1
- King & Spalding 1
- Strategic Policy, Inc. 1
- Public Strategies, Inc. 1
Registrant_Name 12
- Culbertson, Pendleton & Pendleton 1
- Development & Resources Corporation 1
- Doremus & Company 1
- Doyle, Graf & Mabley, Inc. 1
- Hogan Lovells US LLP 1
- Keating Group, Inc. 1
- King & Spalding 1
- Pendleton & McLaughlin 1
- Public Strategies, Inc. 1
- Squire Patton Boggs, LLP 1
- Strategic Policy, Inc. 1
- White & Case, LLP 1
City 4
- New York 5
- Washington 5
- Atlanta 1
- Austin 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5230 | 5230 | 2001-01-31 | 1996-03-04 | Mashek | William S. | Public Strategies, Inc. 4928 | 1994-07-15 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 900 | Austin | TX | 78701 |
7165 | 7165 | 1984-02-17 | 1973-11-23 | Wallace | William S. | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | 331 Madison Avenue | 8th Floor | New York | NY | 10017 |
7542 | 7542 | 1995-02-24 | 1990-04-09 | Haft | William S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8152 | 8152 | 2002-02-28 | 2001-05-09 | Haft | William S. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
17141 | 17141 | 1987-05-26 | 1986-04-10 | McKee | William S. | King & Spalding 3812 | 1986-04-10 | King & Spalding | 1500 Trust Company | Atlanta | GA | 30303 | |
19274 | 19274 | 1970-06-12 | 1969-03-20 | Donovan | William S. | Development & Resources Corporation 969 | 1956-08-02 | Development & Resources Corporation | 44 Wall Street | New York | NY | ||
19866 | 19866 | 1992-06-19 | 1992-04-06 | Barker | William S. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
23066 | 23066 | 1997-07-13 | 1989-01-13 | Merkin | William S. | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 |
25461 | 25461 | 1966-08-01 | 1964-05-28 | Culbertson | William S. | Pendleton & McLaughlin 1743 | 1964-05-28 | Pendleton & McLaughlin | 700 Brawner Building | 888 - 17th Street, N.W. | Washington | DC | 20006 |
26341 | 26341 | 1962-08-10 | 1950-08-10 | Culbertson | William S. | Culbertson, Pendleton & Pendleton 637 | 1950-08-10 | Culbertson, Pendleton & Pendleton | 1025 Connecticut Avenue, N.W. | Washington | DC | ||
33057 | 33057 | 1980-10-17 | 1978-10-31 | Wells | William S. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
35862 | 35862 | 1989-11-15 | 1985-08-09 | Doyle | William S. | Doyle, Graf & Mabley, Inc. 3719 | 1985-08-09 | Doyle, Graf & Mabley, Inc. | 115 East 67th Street | New York | NY | 10021 |
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]) );