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, atom, 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
2400 2400 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
3818 3818 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
3820 3820 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
4324 4324 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
4350 4350 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
5310 5310 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
5311 5311 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
5312 5312 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
5656 5656 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
6088 6088 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
6724 6724 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
6828 6828 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
6829 6829 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
7331 7331 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
8025 8025 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
9142 9142 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
9575 9575 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
9930 9930 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
9931 9931 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
9932 9932 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
9933 9933 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
9934 9934 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
11585 11585 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
11611 11611 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
11653 11653 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
12410 12410 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
12571 12571 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
12659 12659 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
12758 12758 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
16192 16192 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
16201 16201 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
16335 16335 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
18093 18093 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
18094 18094 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
18095 18095 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
18610 18610 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
18613 18613 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
18801 18801 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
18802 18802 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
19316 19316 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
19325 19325 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
19337 19337 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
19344 19344 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
19352 19352 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
19353 19353 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
19358 19358 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
19637 19637 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
19897 19897 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
19900 19900 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
19901 19901 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
19902 19902 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
19914 19914 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
19917 19917 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
20725 20725 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
20920 20920 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
20922 20922 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
20923 20923 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
20928 20928 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
20929 20929 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
20930 20930 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
20931 20931 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
20932 20932 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
21002 21002 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
21003 21003 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
21233 21233 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
21235 21235 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
21240 21240 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
21241 21241 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
21288 21288 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
21289 21289 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
21292 21292 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
21340 21340 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
21342 21342 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
21464 21464 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
21567 21567 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
21568 21568 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
21569 21569 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
21570 21570 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
21571 21571 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
21573 21573 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
21574 21574 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
21580 21580 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
21583 21583 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
21584 21584 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
21720 21720 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
21721 21721 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
21723 21723 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
21725 21725 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
21726 21726 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
21727 21727 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
21730 21730 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
22767 22767 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
22934 22934 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
22935 22935 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
23998 23998 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
23999 23999 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
24000 24000 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
24007 24007 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
24180 24180 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
24181 24181 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 316.661ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history