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

15 rows where Registration_Number = 7070

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date)

State 1

  • DC 15

Registration_Number 1

  • Ballard Partners · 15 ✖

Registrant_Name 1

  • Ballard Partners 15

City 1

  • Washington 15
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
111 111   2022-01-13 O'Hanlon John Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
112 112   2022-01-13 Ballard Brian Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
114 114   2022-01-13 Diaz Jose Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
270 270   2022-01-31 Lukis Sylvester Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
595 595   2022-03-18 Bryza Matthew James Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
596 596   2022-03-18 Goodman Michael Adam Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
600 600   2022-03-18 Thompson Tola Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
791 791   2023-04-14 Eagle Dane Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
792 792   2023-04-14 Frances Coppola Courtney Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
793 793   2023-04-14 Lukis Adrian Anthony Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
854 854   2023-04-21 Klopp Stephen Richard Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
1146 1146   2023-05-29 McFaul Daniel Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
1366 1366   2023-07-06 Miller Jefferson Bingham Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
32297 32297 2022-10-04 2022-01-13 Sayfie Justin Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
32300 32300 2022-10-04 2022-12-12 Sayfie Justin Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S 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 699.955ms · 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