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

60 rows where Registration_Number = 5500

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date (date)

State 1

  • NY 60

Registration_Number 1

  • Arnold Worldwide/NY · 60 ✖

Registrant_Name 1

  • Arnold Worldwide/NY 60

City 1

  • New York 60
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
4584 4584 2004-01-26 2002-06-05 Ziv Suzanne Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
5280 5280 2003-01-31 2002-06-05 Regidor Cynthia Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
5281 5281 2003-01-31 2002-06-05 Serrano Amy Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
5303 5303 2004-01-31 2003-03-18 Fana Xenia Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
6254 6254 2004-02-06 2002-06-05 Klein Rochelle Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
6869 6869 2003-02-14 2002-06-05 Sustana Nick Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
9064 9064 2005-03-03 2004-03-25 Hinds Zeudi Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
9844 9844 2003-03-14 2002-06-05 Ferman Pamela Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
9845 9845 2003-03-14 2002-06-05 Fernandez Frank Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
11924 11924 2004-03-31 2002-06-05 Moorman Robert Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
14008 14008 2004-04-23 2003-03-18 Kendrick Sharon Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
15825 15825 2005-05-06 2002-06-05 Zuna Michael Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
20454 20454 2002-06-28 2002-06-05 Zinmaw Sandi Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
22482 22482 2005-07-02 2005-02-01 Jankowski Benjamin S. Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
22974 22974 2003-07-11 2002-06-05 Pomroy Cindy Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
25005 25005 2002-07-31 2002-06-05 Badenhop Stephen Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
25641 25641 2003-08-01 2003-08-06 Leisman Jenny Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
27079 27079 2004-08-20 2003-03-18 West Niels Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
28407 28407 2002-08-31 2002-06-05 Broad David Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
28933 28933 2004-09-01 2002-06-05 Kupfer Jean Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
29487 29487 2005-09-09 2002-06-05 Stewart Anne Marie Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
31959 31959 2002-10-01 2002-06-05 Ryan Kathryn Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
31969 31969 2003-10-01 2002-06-05 Finneran Thomas Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
31972 31972 2004-10-01 2003-08-06 Baglivo Mary Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
32931 32931 2004-10-15 2003-03-18 Dunlap Deborah Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
36566 36566 2004-11-29 2003-03-18 Murphy Jaime Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
38571 38571 2004-12-17 2003-08-06 Song David Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41264 41264 2002-12-31 2002-06-05 McGrath Patrick Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41312 41312 2003-12-31 2002-06-05 Quero Nicole Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41382 41382 2005-12-31 2006-01-30 Johnson Vaughnda Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41388 41388 2005-12-31 2005-02-01 Cohen Adam Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41389 41389 2005-12-31 2005-02-01 Kelly Francis J. III Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41390 41390 2005-12-31 2005-02-01 Smith Dara Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41395 41395 2005-12-31 2003-03-18 Elia Maria Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41396 41396 2005-12-31 2003-03-18 Marquez Susana Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41397 41397 2005-12-31 2003-03-18 Sands Danielle Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41400 41400 2005-12-31 2004-03-25 Fernandez Francisco Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41401 41401 2005-12-31 2004-03-25 Kapplow Nancy Casey Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41402 41402 2005-12-31 2004-03-25 Quinones Wencis Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41403 41403 2005-12-31 2004-03-25 Staffen John Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41404 41404 2005-12-31 2004-03-25 Talley Jamie Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41405 41405 2005-12-31 2004-03-25 Thomas Susan Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41412 41412 2005-12-31 2002-06-05 Byers Jeanne Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41413 41413 2005-12-31 2002-06-05 Cahill Andrew Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41414 41414 2005-12-31 2002-06-05 Conery Kevin Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41415 41415 2005-12-31 2002-06-05 Fischetti John Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41416 41416 2005-12-31 2002-06-05 Frazier Patricia Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41417 41417 2005-12-31 2002-06-05 Johnson Catherine Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41418 41418 2005-12-31 2002-06-05 Policano John Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41419 41419 2005-12-31 2002-06-05 Volk Kristin Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41440 41440 2005-12-31 2005-08-01 O'Hare Tim Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41441 41441 2005-12-31 2005-08-01 Albano Lisa Ann Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41442 41442 2005-12-31 2005-08-01 Irwin Maria Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41443 41443 2005-12-31 2005-08-01 Krongold Jaclyn Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41444 41444 2005-12-31 2005-08-01 Migliaccio Anthony Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41445 41445 2005-12-31 2005-08-01 Williams Meghan Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41446 41446 2005-12-31 2005-08-01 Williamson Natasha Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41447 41447 2005-12-31 2003-08-06 Gussman Michele Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41448 41448 2005-12-31 2003-08-06 Woodman Nathan Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41459 41459 2005-12-31 2005-10-07 Goger Jillian Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011

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