FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

30 rows where Registration_Number = 948

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Tanaka, Michele N. · 30 ✖

Registrant_Name 1

City 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
3127 3127 1986-01-03 1981-06-05 Schwartz Robert Steven Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
4089 4089 1979-01-19 1975-11-07 Jung Frances L. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
4270 4270 1988-01-22 1986-09-08 Sackett Karen L. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
6174 6174 1992-02-05 1986-04-23 Lynn Mary Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
6816 6816 1992-02-14 1989-08-09 Mugavero Thomas C. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
10204 10204 1983-03-18 1977-11-18 Caine Wesley K. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
12677 12677 1978-04-03 1974-05-22 Triplett William C. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
13206 13206 1974-04-12 1973-06-22 Hertzberg Michael A. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
15818 15818 1992-05-06 1987-09-15 Hatfield Kathleen Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22768 22768 1993-07-08 1988-02-12 Kenkel John J. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22770 22770 1993-07-08 1990-04-10 Tanaka H. William Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22771 22771 1993-07-08 1984-05-16 Tanaka Michele N. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22772 22772 1993-07-08 1988-07-25 Brown Michael J. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22773 22773 1993-07-08 1981-08-05 Middleton B. Jenkins Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22774 22774 1993-07-08 1991-09-18 Hembrey Douglas C. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22775 22775 1993-07-08 1990-09-20 Cody Ann E. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22776 22776 1993-07-08 1976-11-16 O'Leary Patrick F. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
22777 22777 1993-07-08 1979-11-23 Davenport James C. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
24450 24450 1966-07-30 1957-06-14 Sheble Walter Franklin Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
24753 24753 1987-07-31 1986-04-23 O'Mara Patrick J. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
26164 26164 1987-08-07 1981-07-31 Preiss Jeremy O. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
26262 26262 1986-08-08 1981-06-05 Russell Robert Marvin Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
26268 26268 1991-08-08 1989-05-22 Yanagihara Margaret Midori Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
27198 27198 1986-08-22 1986-04-23 Seevers James P. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
27698 27698 1980-08-29 1978-11-06 Stillman Betsy Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
31785 31785 1961-10-01 1961-06-02 Walders Lawrence Richard Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
35994 35994 1992-11-17 1987-05-29 Graig Ian C. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
37874 37874 1990-12-07 1987-05-29 Mattice Alice Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
38109 38109 1981-12-11 1979-11-23 Schwandt Craig Allen Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005
40402 40402 1987-12-31 1976-05-05 Ritger Donald L.E. Tanaka, Michele N. 948 1956-04-24 Tanaka, Michele N. 655 - 15th Street, N.W. Suite 800 Washington DC 20005

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])
);