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

29 rows where City = "Washington" and Registration_Number = 3597

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • APCO Associates · 29 ✖

Registrant_Name 1

City 1

  • Washington · 29 ✖
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
3573 3573 1991-01-11 1986-01-06 Barbour Nancy R. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
4750 4750 1988-01-29 1987-03-02 Fulton Pattison APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
10231 10231 1988-03-18 1986-04-17 Andrews Todd G. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
11607 11607 1989-03-31 1985-08-30 Epstein Anita APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
11608 11608 1989-03-31 1985-09-01 Parkhurst David Shelton APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
16654 16654 1990-05-18 1985-05-28 White Jocelyn APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
17345 17345 1987-05-29 1986-03-05 Wiggins Dena E. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
17721 17721 1989-05-31 1986-04-24 Donahue Mary (Marla) M. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
21072 21072 1987-06-30 1986-03-25 Huggins Susan M. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
22524 22524 1986-07-03 1985-10-21 Grub Diana Lynn APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
24182 24182 1990-07-27 1988-10-05 Navarrete Andres Luis APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
27422 27422 1988-08-25 1985-06-06 Olson Kimberly Sue APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28182 28182 1991-08-31 1987-02-10 Nealer Kevin Glenn APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28185 28185 1991-08-31 1987-02-18 Samors Robert John APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28190 28190 1991-08-31 1991-03-26 Eisner Steven B. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28192 28192 1991-08-31 1987-04-07 Schumacher Barry J. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28193 28193 1991-08-31 1986-04-24 Cohen Neal M. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28195 28195 1991-08-31 1989-06-06 Sliz Deborah R. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28196 28196 1991-08-31 1984-06-20 Kraus Margery APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28197 28197 1991-08-31 1991-07-03 Bronk Robin L. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28198 28198 1991-08-31 1991-07-03 Humpstone Jane Hamilton APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28201 28201 1991-08-31 1987-07-29 Farr Stephen N. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28205 28205 1991-08-31 1985-08-30 Judd Terry Walter APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
28209 28209 1991-08-31 1990-11-15 Bushnell David J. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
31013 31013 1988-09-30 1988-01-27 Alverson Cappie Lou APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
31020 31020 1988-09-30 1987-07-01 Goldsmith Marta Vivian APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
31916 31916 1991-10-01 1990-02-16 Bonker Don L. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
31924 31924 1991-10-01 1990-12-19 Jenkins Kempton B. APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036
40624 40624 1990-12-31 1989-06-06 Grunberg Carole Ann APCO Associates 3597 1984-06-20 APCO Associates Three Lafayette Centre 1155 - 21st Street, N.W. #1000 Washington DC 20036

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