FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

15 rows where Address_1 = "1706 - 18th Street, N.W."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Termination_Date, Name, Zip, Registration_Date (date), Termination_Date (date)

State 1

City 1

Address_1 1

  • 1706 - 18th Street, N.W. · 15 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
597 1949-11-10 1991-05-15 Henley, Lillian   1706 - 18th Street, N.W.   Washington DC 20009
641 1950-09-20 1966-02-18 Kreisinger, Robert   1706 - 18th Street, N.W.   Washington DC 20009
973 1956-08-28 1980-03-03 Lerman, Louis   1706 - 18th Street, N.W.   Washington DC 20009
1022 1957-05-07 1966-02-18 Davidson, Martha Golden   1706 - 18th Street, N.W.   Washington DC  
1916 1965-08-17 1967-02-03 Lemma, Susan Weber   1706 - 18th Street, N.W.   Washington DC 20009
2050 1967-09-20 1967-09-20 Marr, Barbara Ann   1706 - 18th Street, N.W.   Washington DC  
2132 1969-05-01 1976-11-05 Felter, Marcia   1706 - 18th Street, N.W.   Washington DC  
2383 1972-10-04 1973-09-24 Silvin, Mary Jane   1706 - 18th Street, N.W.   Washington DC 20009
2475 1973-10-27 1974-05-01 O'Leary, Anne   1706 - 18th Street, N.W.   Washington DC  
2588 1975-06-09 1976-06-14 Berman, Karen   1706 - 18th Street, N.W.   Washington DC  
2697 1976-06-12 1976-12-02 Silvin, Mary Jane   1706 - 18th Street, N.W.   Washington DC 20009
2699 1976-06-18 1976-08-12 Boland, Kerby Ann   1706 - 18th Street, N.W.   Washington DC 20007
3125 1980-07-28 1981-03-05 Levine, Allen   1706 - 18th Street, N.W.   Washington DC 20009
3924 1987-01-07 1991-12-31 Styles, Deborah M.   1706 - 18th Street, N.W.   Washington DC 20009
4179 1988-09-23 1992-04-22 Hammack, Sarah N.   1706 - 18th Street, N.W.   Washington DC 20009

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);