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

155 rows where Registration_Number = 508

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

  • 508 · 155 ✖

City

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
2458 2458 1965-01-01 1951-05-10 Kiernan Thomas J. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
3885 3885 1951-01-19 1948-01-19 Mercer Samuel David 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
3887 3887 1954-01-19 1953-05-14 Taft Charles Phelps 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
4394 4394 1961-01-27 1948-01-19 Ball George Wildman 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
4420 4420 1993-01-27 1990-08-13 Plog Henry J. , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
5398 5398 1968-02-01 1953-04-23 Sharon John Hurford 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
5399 5399 1968-02-01 1953-04-27 Jackson Edward Perkins , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
5400 5400 1968-02-01 1953-04-29 Harmon Dudley 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
5744 5744 1964-02-03 1964-02-03 Pohle Klaus 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
6183 6183 1960-02-10 1960-02-10 Cone Sidney M. , III 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
6824 6824 1971-02-18 1971-03-11 Stock Richard H. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
6932 6932 1955-02-21 1954-01-21 Clarke Ann Thatcher 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
6933 6933 1956-02-21 1952-02-20 Yarnolinsky Adam 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
7440 7440 1967-02-28 1964-08-06 Ehrlich Robert Sali 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
8151 8151 1960-03-01 1952-09-19 Sheriff Leonard S. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
9273 9273 1986-03-14 1981-12-29 Polebaum Elliot E. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
9706 9706 1964-03-19 1964-03-19 Hudson Manley O. , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
10064 10064 1955-03-24 1955-03-24 Martin Julian R. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
10065 10065 1955-03-24 1955-03-24 Sharon William Francis 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
10066 10066 1955-03-24 1955-03-24 Wilkins Herbert Putnam 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
10067 10067 1955-03-24 1953-04-27 Cutter Richard Ammi 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
10068 10068 1955-03-24 1953-04-27 Rham Casimir , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
11742 11742 1976-04-01 1975-03-10 Zamora Stephen T. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
11768 11768 1984-04-01 1982-04-26 Mahaffie Charles D. , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
11810 11810 1991-04-01 1990-08-13 Newburg Andre W.G. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
12573 12573 1967-04-14 1965-11-08 Barnett Stephen Roger 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
12735 12735 2000-04-15 1990-09-19 Robinson Steven N. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
12824 12824 1986-04-16 1984-01-16 Menke John A. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
12923 12923 1955-04-18 1955-04-18 Frawley Mark W. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
16422 16422 1983-05-30 1982-03-08 Klein Christopher M. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
16431 16431 1988-05-30 1987-01-12 Gorin William F. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
16566 16566 1961-05-31 1951-05-08 Stinson George 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
18338 18338 1955-06-15 1955-06-15 Overton George W. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
18339 18339 1955-06-15 1955-06-20 Staub Ernest F. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
18340 18340 1955-06-15 1955-07-07 James Thomas W. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
18856 18856 1984-06-22 1979-01-31 Hall William N. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
18859 18859 1984-06-22 1982-11-16 Wiegard Michael A. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19047 19047 1982-06-25 1982-02-25 Stiles Ned B. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19048 19048 1982-06-25 1978-11-06 McGurn William B. , III 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19563 19563 1964-06-30 1964-03-24 Steefel Ernest C. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19572 19572 1965-06-30 1963-02-01 Sayad William Yohannan , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19584 19584 1965-06-30 1964-08-06 Chambers David Laurance , III 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19591 19591 1966-06-30 1965-03-19 Patrick Robert John , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19599 19599 1966-06-30 1965-08-02 Johnson Robert Knowles 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19600 19600 1966-06-30 1964-08-06 Pugh Richard Crawford 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19605 19605 1966-06-30 1962-12-14 Homet Roland Stevens , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
19884 19884 1986-06-30 1985-11-05 Paine Peter S. , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20144 20144 1999-06-30 1996-03-21 Griffin Kevin A. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20147 20147 1999-06-30 1991-04-04 Anzaldua-Montoya Ricardo A. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20148 20148 1999-06-30 1991-04-04 Benedict Scott N. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20149 20149 1999-06-30 1991-04-04 Murphy John C. , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20161 20161 1999-06-30 1996-11-12 Marquardt Paul D. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20164 20164 1999-06-30 1981-12-29 Silver Daniel B. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
20992 20992 1997-07-01 1971-03-11 Kliever Douglas E. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21189 21189 1968-07-03 1967-02-02 Chittum Roger Dean 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21191 21191 1968-07-03 1964-03-19 Chapman Dudley Harry 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21192 21192 1968-07-03 1965-03-19 Ciriello Nicholas Gregory 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21197 21197 1968-07-03 1963-08-01 Ebb Lawrence Forrest 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21198 21198 1968-07-03 1964-08-06 Carroll Joe Speed 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21199 21199 1968-07-03 1964-08-06 Dinces Stephen L. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21200 21200 1968-07-03 1962-08-08 Duncan Robert Michael 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21201 21201 1968-07-03 1963-10-04 Beveridge Albert Jeremiah , III 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21272 21272 1968-07-05 1964-08-06 Green Sedwick William 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21273 21273 1968-07-05 1964-08-06 Hagoort Thomas H. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21504 21504 1968-07-09 1955-04-11 Kerr Edmund H. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21506 21506 1968-07-09 1951-05-08 Lipson Leon Samuel 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21511 21511 1968-07-09 1958-08-15 Kaczmarek Jan Michal Zdzibor 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21512 21512 1968-07-09 1952-08-19 Lamberton James Wilson 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21559 21559 1968-07-10 1960-07-26 Mallory John Kenneth , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21560 21560 1968-07-10 1964-08-06 Manning Elliott 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21563 21563 1968-07-10 1950-11-09 Morgan Erwin Joseph 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21611 21611 1968-07-11 1965-02-02 Newburg Andre W.G. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21613 21613 1968-07-11 1962-08-08 Morgan Donald Lee 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21736 21736 1994-07-13 1990-08-13 Moniz J. Webb 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21839 21839 1968-07-15 1967-02-02 Stokes John Myers 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21840 21840 1968-07-15 1952-03-11 Tondel Lyman M. , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21841 21841 1968-07-15 1965-03-19 Rubin Robert Edward 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21842 21842 1968-07-15 1965-03-19 Stiles Ned Berry 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21843 21843 1968-07-15 1965-03-19 Trencher Carol Linda Wolf 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21845 21845 1968-07-15 1955-03-24 Stoops Dale Ira 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21846 21846 1968-07-15 1955-04-22 Rothchild Walter S. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21852 21852 1968-07-15 1954-09-28 Tennyson Leonard Berhard 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21855 21855 1968-07-15 1965-11-02 Shchuchinski Luis 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21856 21856 1968-07-15 1965-11-08 Turnage Fred Douglas 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21992 21992 1968-07-16 1962-01-31 Wales Robert W. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21993 21993 1968-07-16 1967-02-02 Vansant John Matthew , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21995 21995 1968-07-16 1961-02-21 Winston Morton M. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21997 21997 1968-07-16 1965-03-19 Wiese James Douglas 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21998 21998 1968-07-16 1965-03-19 Zimmer Robert Charles 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
21999 21999 1968-07-16 1951-05-08 Ward John F. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
22002 22002 1968-07-16 1965-11-02 Zabel William D. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
23043 23043 1962-07-30 1958-08-15 Sharon John Hurford 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
23211 23211 1956-07-31 1951-05-08 Shea John Joseph Brendan 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
23212 23212 1956-07-31 1955-05-18 Zingman Edgar Alan 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
24286 24286 1965-08-02 1965-08-02 Cohen George Meyers 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
24287 24287 1965-08-02 1965-08-02 Minikes Jon Charles 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
24288 24288 1965-08-02 1965-08-02 Tessler Allan Roger 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
24295 24295 1982-08-02 1978-11-17 Gardner Paul , Jr. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
24470 24470 1957-08-05 1955-04-11 Haner Jack A. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
24471 24471 1957-08-05 1955-04-18 Hamburg Morton I. 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801

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 · Query took 359.144ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history