home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

32 rows where Registration_Number = 2548

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 32

Registration_Number 1

  • Edelman International Corporation · 32 ✖

Registrant_Name 1

  • Edelman International Corporation 32

City 1

  • Washington 32
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
12428 12428 1980-04-01 1976-03-09 Banks David O. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
22121 22121 1978-07-01 1978-05-11 Peabody Robert Lee Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
25503 25503 1978-08-01 1978-05-11 Lanier R. Josh Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
25504 25504 1978-08-01 1978-05-11 Reckley Gladys Genevieve Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
25506 25506 1978-08-01 1978-08-02 Reynolds William A. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
36145 36145 1975-11-21 1974-11-29 Stiner James E. , Jr. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39326 39326 1982-12-30 1978-02-09 Yacker Jeffrey B. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39327 39327 1982-12-30 1978-02-17 Aurelio Richard Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39328 39328 1982-12-30 1978-02-17 Barrett Paulette Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39329 39329 1982-12-30 1975-02-28 Sheehan Shaun M. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39331 39331 1982-12-30 1978-03-13 Scanlon Michael B. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39332 39332 1982-12-30 1978-03-14 Tanber George Joseph Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39333 39333 1982-12-30 1980-04-01 Hunt William Hodges Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39334 39334 1982-12-30 1976-04-05 Kranz Sally Green Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39337 39337 1982-12-30 1979-05-26 Guerrero Judy Levy Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39338 39338 1982-12-30 1978-06-27 Harrison Wendell Nicholas Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39339 39339 1982-12-30 1977-07-05 Buckhalt Ronald B. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39340 39340 1982-12-30 1982-07-09 Utley Lisa Ann Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39341 39341 1982-12-30 1977-07-13 Heine Kristine E. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39342 39342 1982-12-30 1978-07-17 Hartman Robert S. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39343 39343 1982-12-30 1976-07-30 Kaufman Judith M. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39344 39344 1982-12-30 1976-07-30 Pellerin Patrick L. , Jr. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39345 39345 1982-12-30 1976-08-03 Muhlberg Peeter Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39346 39346 1982-12-30 1976-08-03 Wilkerson Jerry C. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39348 39348 1982-12-30 1981-10-13 Sullivan Richard J. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39349 39349 1982-12-30 1979-11-06 Newman Judith A. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39350 39350 1982-12-30 1977-11-15 Dietsch John Joseph Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39351 39351 1982-12-30 1975-11-25 Ball Nancy L. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39352 39352 1982-12-30 1974-11-29 Meek John Martin Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39353 39353 1982-12-30 1974-11-29 Rosenker Mark V. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39354 39354 1982-12-30 1975-12-09 Jones Neal R. Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006
39355 39355 1982-12-30 1975-12-10 Yarmuth John Edelman International Corporation 2548 1974-11-29 Edelman International Corporation 1730 Pennsylvania Avenue, N.W. Room 460 Washington DC 20006

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 · Queries took 671.163ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows