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 = 6331

View and edit SQL

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

State

Registration_Number

  • 6331 · 27

Registrant_Name

City

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
272   2018-02-09 Crowley Daniel F.C. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1342   2020-07-19 Ettinger Stacy J. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1343   2020-07-19 Orenstein Jeffrey 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1344   2020-07-19 Purpuro Laurie 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1345   2020-07-19 Purpuro Laurine B. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1346   2020-07-19 Schooley Eli M. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1347   2020-07-19 Shik Won Tyler Hong 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1348   2020-07-19 Won Tyler Hong Shik 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
1432   2019-07-30 Peckinpaugh Tim 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
2928 2019-01-01 2018-02-16 Nelson Scott C. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
2935 2019-01-01 2018-05-22 Aliferis Scott 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
4166 2017-01-24 2017-01-24 Gordon Barton J. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12122 2019-04-05 2018-02-16 McHugh John 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12126 2019-04-05 2018-07-18 LeMay Anne R. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12547 2017-04-12 2017-01-23 Carnevale Amy 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12548 2017-04-12 2017-01-23 Conner Darrell 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12549 2017-04-12 2017-01-23 Fremlin Grace Parke 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12550 2017-04-12 2017-01-23 Kirk William A. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12551 2017-04-12 2017-01-23 LeMay Anne 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12552 2017-04-12 2017-01-23 McHugh John 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12553 2017-04-12 2017-01-23 Walsh James T. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12554 2017-04-12 2017-02-21 O'Neil Michael James 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12555 2017-04-12 2017-08-02 Peckinpaugh Tim 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12556 2017-04-12 2015-12-18 Greif Judson 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
18135 2019-06-10 2018-07-18 Chudzicki Pawel 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
20759 2018-06-30 2018-02-16 Carnevale Amy 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
21157 2019-07-01 2018-02-16 Heiman Bruce J. 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222

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 · Query took 366.004ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history