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

38 rows where Registration_Number = 6806

✖
✖

✎ 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

  • NY 38

Registration_Number 1

  • Terakeet LLC · 38 ✖

Registrant_Name 1

  • Terakeet LLC 38

City 1

  • Syracuse 38
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
533 533   2023-03-08 Janitz Emilee Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
599 599   2022-03-18 Scarpato Daniel Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
633 633   2020-03-24 Cummings MacLaren Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
634 634   2020-03-24 Danial Patrick Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
635 635   2020-03-24 Heintz Gabriela Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
636 636   2020-03-24 Reedy Shannon Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
637 637   2020-03-24 Schiefer Kenneth Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
945 945   2021-04-30 Snyder Justin Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
1396 1396   2023-07-12 Coloccia Megan E. Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
1399 1399   2023-07-12 Stayer Jesse Robert Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
1400 1400   2023-07-12 Wilson Kelly Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
1505 1505   2022-07-28 Compton Zoe Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
1507 1507   2022-07-28 Rogers Jason Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
1853 1853   2022-09-26 Rouse Shaun Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
2056 2056   2020-10-29 Pinkel William Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
5614 5614 2022-01-31 2021-10-29 Lettin Whitney Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
5617 5617 2023-01-31 2020-03-24 MacBlane Brianna Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
8926 8926 2021-03-01 2020-10-29 Hoff Caitlin Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
9289 9289 2023-03-06 2022-09-26 Riehle Alecia Jo Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
13345 13345 2022-04-14 2020-03-24 Kimball Antoinette Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
13774 13774 2022-04-19 2021-10-29 Elmer Hannah Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
13936 13936 2021-04-22 2020-03-24 Harrison Anneliese Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
15545 15545 2021-05-01 2020-10-29 Moroz Ihor Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
16632 16632 2021-05-17 2021-04-30 Day Ryan Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
17206 17206 2022-05-26 2021-10-29 Hicks Brandon Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
18252 18252 2022-05-31 2022-05-04 Leone Samantha Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
18259 18259 2022-05-31 2020-10-29 MacBlane Lauren Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
18605 18605 2021-06-01 2020-10-29 Long Kylie Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
18606 18606 2021-06-01 2020-10-29 Neeves Rachel Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
22014 22014 2022-06-30 2021-10-29 Condon Amanda Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
22803 22803 2022-07-08 2020-10-29 Rosati Emily Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
23327 23327 2022-07-15 2021-10-29 Lipsky Liam Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
25391 25391 2020-07-31 2020-10-29 Grafe Alexandra Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
29501 29501 2022-09-09 2022-06-29 Leonard Stanton Merideth Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
30105 30105 2022-09-19 2022-06-29 Day Ryan Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
31695 31695 2020-09-30 2020-03-24 Hurlburt Ryan Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
34775 34775 2022-10-31 2021-04-30 Manno Dominick Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202
37545 37545 2020-12-01 2020-03-24 Weyant Curtis Terakeet LLC 6806 2020-03-24 Terakeet LLC 333 West Washington Street, Suite 500   Syracuse NY 13202

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 727.79ms · 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