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

14 rows where Registration_Number = 5579

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 14

Registration_Number 1

  • Weber Shandwick, Inc. · 14 ✖

Registrant_Name 1

  • Weber Shandwick, Inc. 14

City 1

  • Washington 14
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
5336 5336 2005-01-31 2003-10-10 Barrett Laurence Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
5369 5369 2006-01-31 2004-12-09 Delahunt Kara Mai Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
11942 11942 2004-03-31 2003-10-10 Keeter Brian C. Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
14958 14958 2007-04-30 2006-08-31 Adelsberger Bernard Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
18682 18682 2008-06-02 2006-09-28 Britton Robin Elizabeth Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
27528 27528 2005-08-27 2004-12-09 Perrotto Trent Joseph Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
29358 29358 2007-09-07 2003-10-10 Gest Kathryn W. Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
30628 30628 2007-09-27 2004-12-09 Harrison Gail L. Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
34570 34570 2008-10-31 2004-03-22 Tate Sheila Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
34575 34575 2008-10-31 2003-10-10 Meszaros James A. Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
34576 34576 2008-10-31 2003-10-10 Powell Joseph L. Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
34578 34578 2008-10-31 2006-10-13 Levin Seth David Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
38420 38420 2006-12-15 2006-08-01 Thompson Amy Lynn Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th Street, N.W. Suite 800 Washington DC 20005
41376 41376 2004-12-31 2004-12-09 Glassner Lauren Weber Shandwick, Inc. 5579 2003-10-02 Weber Shandwick, Inc. 700 13th 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])
);
Powered by Datasette · Queries took 439.919ms · 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