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

27 rows where Registration_Number = 6826

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • NY 27

Registration_Number 1

  • Brunswick Group LLC · 27 ✖

Registrant_Name 1

  • Brunswick Group LLC 27

City 1

  • New York 27
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
101 101   2021-01-12 Belz Anne Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
173 173   2023-01-23 Caraway Chanel Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
174 174   2023-01-23 Cockfield Jr. Errol Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
175 175   2023-01-23 Ghiheen Julia Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
176 176   2023-01-23 Safler Noam Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1064 1064   2020-05-20 Eliano Liza Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1065 1065   2020-05-20 Sleiman Dana Ghaleb Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1666 1666   2022-08-26 Burnett Alex Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1667 1667   2022-08-26 Drew Phil Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1668 1668   2022-08-26 Hurst Giacomo Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1669 1669   2022-08-26 Knight Robin Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
1713 1713   2022-09-01 McGivan Tom Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
4294 4294 2019-01-22 2020-05-20 Guesdon Fanny Genevieve Solange Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
7358 7358 2023-02-21 2021-12-28 Deliss Saskia Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
11313 11313 2023-03-30 2021-01-12 van der Meijden Annabel Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
16792 16792 2020-05-20 2020-05-20 Carter Alice Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
16793 16793 2020-05-20 2020-05-20 Diviney John Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
16794 16794 2020-05-20 2020-05-20 Mead Amanda Liann Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
16795 16795 2020-05-20 2020-05-20 Mitchell Kim Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
16796 16796 2020-05-20 2020-05-20 Ray Agnish Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
18612 18612 2022-06-01 2021-01-12 Borkhoche Angela Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
18615 18615 2022-06-01 2020-05-20 Nasser Roya Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
18617 18617 2023-06-01 2020-05-20 Hills-Bos Tristan Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
37559 37559 2021-12-01 2021-01-12 Campbell Katherine Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
37560 37560 2021-12-01 2021-01-12 Yamlikha Sana Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
37565 37565 2021-12-01 2020-05-20 Kanne Nicole Alexandra Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
37651 37651 2022-12-02 2021-12-28 Amanatidis Pavlos Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167

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 1179.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