FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

16 rows where Registrant_Name = "Quinn & Co. of NY LTD.", Registration_Number = 6433 and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Quinn & Co. of NY LTD. · 16 ✖

Registrant_Name 1

  • Quinn & Co. of NY LTD. · 16 ✖

City 1

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
2433 2433   2017-12-19 Morin Vanessa Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
2445 2445   2017-12-21 Szeto Stefanie Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
2995 2995 2018-01-01 2017-05-24 Deptula Kristie Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
2996 2996 2018-01-01 2017-05-24 Weeden Elizabeth Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
4069 4069 2018-01-18 2017-05-24 Galasso Casey Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
8362 8362 2019-02-28 2017-10-11 Chiou Ivy Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
12243 12243 2019-03-31 2017-05-24 Frazier John Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
12599 12599 2020-04-01 2019-05-31 Atienza Flerine Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
12607 12607 2020-04-01 2018-12-12 Malave Kaymi Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
13819 13819 2020-04-20 2019-05-31 Lisi Kaitlyn Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
15173 15173 2019-04-30 2017-10-11 Akahoshi Teri Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
17538 17538 2020-05-30 2017-10-11 Zeppieri Angelina Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
21913 21913 2018-06-30 2017-10-11 Maggio Christopher Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
22367 22367 2018-07-01 2017-05-24 Painvin Morgan E. Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
22377 22377 2020-07-01 2019-05-31 Marin Alexandra Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
37096 37096 2017-11-30 2017-10-11 Hurtado Sandra Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018

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])
);