home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

103 rows where Registration_Number = 523

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date), Registration_Date (date)

State 1

  • DC 103

Registration_Number 1

  • Covington & Burling · 103 ✖

Registrant_Name 1

  • Covington & Burling 103

City 1

  • Washington 103
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
2504 2504 1955-01-01 1950-02-20 Parker William Merrick Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
4015 4015 1963-01-18 1952-11-21 Douglas John Woolman Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
7579 7579 1966-02-25 1965-01-21 Custer Benjamin Scott , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
7831 7831 1959-02-28 1950-08-17 Peter Humphrey Marshall Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
8448 8448 1964-02-29 1964-05-14 Johnson Nicholas Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
9876 9876 1951-03-15 1948-11-16 Leigh Edward Monroe Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
9895 9895 1960-03-15 1948-12-10 McElwain Edwin Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
10772 10772 1965-03-26 1964-05-14 Murphy John G. , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
11115 11115 1973-03-30 1969-05-16 Hamilton James Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13065 13065 1973-04-10 1948-04-16 O'Brian John Lord Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13501 13501 1952-04-16 1951-05-15 Silvers Herbert Ralston Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13505 13505 1954-04-16 1952-05-14 Grant James Pineo Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13506 13506 1954-04-16 1951-11-16 Ruttenberg Charles Byron Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13507 13507 1956-04-16 1948-04-16 Howard Edward Garfield Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13509 13509 1957-04-16 1954-11-15 Slowinski Walter Aloysius Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13514 13514 1961-04-16 1960-11-16 Clubb Bruce Edwin Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13515 13515 1964-04-16 1955-03-31 Claudy Donald Edwin Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13516 13516 1964-04-16 1961-05-16 Craig William Laurence Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13517 13517 1964-04-16 1963-11-15 Gershanov Fred F. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13518 13518 1964-04-16 1962-11-16 Sharlot Maurice Michael Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13519 13519 1964-04-16 1961-12-11 Robinson Thomas Earl Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13532 13532 1973-04-16 1959-01-20 Clagett Brice McAdoo Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13533 13533 1973-04-16 1965-01-21 Isbell David Bradford Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13534 13534 1973-04-16 1949-01-25 Hiss Donald Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13535 13535 1973-04-16 1954-02-11 Barlow Homer Joel McKown Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13536 13536 1973-04-16 1948-04-16 Laylin John Gallup Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13537 13537 1973-04-16 1965-05-14 Applebaum Harvey Milton Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13538 13538 1973-04-16 1951-05-15 Roper Willet Crosby , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13539 13539 1973-04-16 1959-05-15 Stanley William , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13540 13540 1973-04-16 1950-05-16 Gribbon Daniel McNamara Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13541 13541 1973-04-16 1960-05-16 Bradley Fontaine Cosby Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13542 13542 1973-04-16 1961-05-16 Schafer John Henry , III Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13543 13543 1973-04-16 1967-05-16 Brown David Nelson Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13544 13544 1973-04-16 1961-06-12 Sapienza John Thomas Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13545 13545 1973-04-16 1959-08-28 Westwood Howard Carter Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13546 13546 1973-04-16 1959-09-02 Allen William Hayes Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13547 13547 1973-04-16 1959-10-20 Temko Stanley Leonard Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13548 13548 1973-04-16 1950-11-15 McKay James Creighton Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13549 13549 1973-04-16 1963-11-15 O'Malley Robert E. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13550 13550 1973-04-16 1963-11-15 Nickles Peter John , II Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13551 13551 1973-04-16 1960-11-16 Carothers Hamilton Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13552 13552 1973-04-16 1965-11-16 Horne Michael Stewart Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13553 13553 1973-04-16 1965-11-16 Norton Gerald Patrick Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13554 13554 1973-04-16 1966-11-16 Jones John Barclay , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13555 13555 1973-04-16 1967-11-16 Leverich Bingham B. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13556 13556 1973-04-16 1964-11-17 Brady Richard A. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13557 13557 1973-04-16 1964-11-17 Dym Herbert Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13558 13558 1973-04-16 1964-11-17 Sailer Henry Powers Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13559 13559 1973-04-16 1952-11-21 Ackerman Jerome Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13560 13560 1973-04-16 1960-12-07 Ellison Newell Windom Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
13895 13895 1966-04-22 1964-04-10 Cogen Edward S. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
14020 14020 1961-04-24 1957-05-13 Acheson David Campion Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
14021 14021 1965-04-24 1962-05-15 Simpich Frederick Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
14471 14471 1969-04-30 1968-11-15 Wright Thomas H. , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
16173 16173 1955-05-13 1949-05-16 Dempsey Wallace Guy Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
17605 17605 1969-05-31 1968-05-15 Vining G. Joseph Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
19216 19216 1952-06-11 1948-04-16 Aiken William Mathew Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
22823 22823 1968-07-09 1967-05-16 Kirgis Frederic L. , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
23183 23183 1968-07-15 1964-05-14 Siena James V. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
23192 23192 1968-07-15 1967-11-16 Schramm Earl M. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
23195 23195 1969-07-15 1965-05-14 Zinn Matthew J. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
23196 23196 1969-07-15 1965-06-14 Oppenheimer Jerry L. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
24656 24656 1968-07-31 1959-10-06 Dobrovir William Aaron Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
27877 27877 1970-08-31 1962-11-16 Allen George Venable , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
28759 28759 1962-09-01 1955-06-28 Horsky Charles Antone Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
29506 29506 1965-09-10 1959-01-20 Holt Thaddeus Goode , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
30013 30013 1964-09-18 1964-04-29 Levenberg Gerry Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
30870 30870 1967-09-30 1948-07-22 Claytor William Graham , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32193 32193 1966-10-03 1952-11-21 Burling Edward , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32195 32195 1970-10-03 1961-11-13 McArdle Paul Francis Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32655 32655 1971-10-12 1960-03-31 Acheson Dean Gooderham Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32810 32810 1964-10-15 1960-05-16 Ewing Ky Pepper , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32965 32965 1950-10-16 1949-05-16 Marchant Anne Nelson Y. Armond Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32968 32968 1953-10-16 1950-11-15 Heires John Hopkins Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32969 32969 1954-10-16 1948-12-21 Barber Charles Finch Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32970 32970 1956-10-16 1950-05-16 Fisher Roger Dummer Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32971 32971 1956-10-16 1955-11-09 Willcox Alanson Work Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32972 32972 1958-10-16 1953-09-30 Rublee George , II Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32974 32974 1959-10-16 1957-11-15 Bianchi Rinaldo Lorenzo Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32975 32975 1959-10-16 1957-11-15 Graglia Florence Carolyn Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32976 32976 1960-10-16 1959-10-06 Wallace Lawrence Gerald Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32977 32977 1961-10-16 1961-01-25 Feeney Floyd Fulton Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32978 32978 1961-10-16 1960-02-09 McIntire Richard Lee Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32979 32979 1961-10-16 1960-03-01 Case Estella May Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32980 32980 1961-10-16 1959-08-28 Doolittle Jesse William , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32981 32981 1961-10-16 1959-10-20 Herzstein Priscilla Holmes Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32982 32982 1961-10-16 1958-11-12 McGiffert David Eliot Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32985 32985 1962-10-16 1955-11-09 Patton James Richard , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32986 32986 1962-10-16 1961-11-13 Purcell John Roper Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
32987 32987 1963-10-16 1962-07-18 Clinard David Marion Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
33587 33587 1963-10-25 1955-05-16 Blow George Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
34149 34149 1964-10-31 1961-11-13 Prather Alfred Val Jean Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
34169 34169 1969-10-31 1964-11-17 Brashares William Charles Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
35201 35201 1966-11-04 1965-11-16 Weiss Mark Anschel Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
35353 35353 1964-11-07 1962-11-16 Peasback David Raymond Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
35799 35799 1972-11-15 1968-11-15 Rossotti Barbara M. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
35935 35935 1977-11-16 1954-02-11 Sapienza John Thomas Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
35938 35938 1977-11-16 1959-08-28 Stansbury Phil Roger Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
35939 35939 1977-11-16 1969-11-14 Carpenter Russell H. , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006
36052 36052 1969-11-19 1965-05-14 Rothwell Thomas A. , Jr. Covington & Burling 523 1948-04-16 Covington & Burling 888 - 16th Street, N.W.   Washington DC 20006

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 1539.372ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows