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

175 rows where Registrant_Name = "Ketchum Inc. NY"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

State 1

  • NY 77

Registration_Number 1

  • Ketchum Inc. NY 77

Registrant_Name 1

  • Ketchum Inc. NY · 77 ✖

City 1

  • New York 77
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
16712 16712 2014-05-19 2013-07-18 Sheehan Rory Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
16838 16838 2009-05-21 2008-08-21 Lanham Kipp Bailey Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
17248 17248 2011-05-27 2011-04-15 Lieberman Anne W. Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18086 18086 2011-05-31 2011-02-18 Kim Eric Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18087 18087 2011-05-31 2011-02-18 Wiltz Marie Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18158 18158 2016-05-31 2016-02-08 Mann Nicole Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18167 18167 2016-05-31 2015-08-31 Brandon Emily Keiko Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18168 18168 2016-05-31 2015-08-31 Germaine Mary Elizabeth Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18169 18169 2016-05-31 2015-08-31 Schoeneman Kayanna Panagi Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18170 18170 2016-05-31 2015-08-31 Stoltz Elizabeth Anne Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18173 18173 2016-05-31 2015-12-08 D'Amico Kathleen Cavanaugh Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
18174 18174 2016-05-31 2015-12-08 Levinson Lauren Kerry Glassner Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
19028 19028 2013-06-07 2012-05-24 Verderosa Annie Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
19989 19989 2013-06-21 2011-08-31 Liberman Shanna Michelle Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
22547 22547 2013-07-03 2010-12-23 Kosygina Julia Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
23027 23027 2013-07-12 2008-12-30 Panagi KayAnn N. Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
23971 23971 2008-07-24 2007-02-22 Saunders Tonya Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
27229 27229 2008-08-22 2008-08-22 Edwards Melissa M. Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
27285 27285 2013-08-23 2008-12-30 DeLorme Thomas Paul Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
29066 29066 2008-09-02 2008-08-28 Pozner Jennifer Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
29595 29595 2013-09-11 2011-04-15 Blair Alexander Philip Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
30286 30286 2018-09-22 2008-09-22 Spencer Kathryn Diane Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
31579 31579 2015-09-30 2015-08-31 Jeavons Kathleen Stone Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
32220 32220 2008-10-03 2007-02-06 Mitrovich Marissa Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
32221 32221 2008-10-03 2007-02-06 Molinari Susan Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
32946 32946 2010-10-15 2010-09-14 Scheider Jeffrey Paul Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
35311 35311 2010-11-05 2008-08-22 Wilson Thomas Ian Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
35627 35627 2008-11-11 2007-02-06 Bonilla Carlos Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
36327 36327 2010-11-24 2010-09-24 Jenkins Jack Nelson Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
37497 37497 2010-12-01 2010-08-18 Yaross Wendy Ann Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
37803 37803 2008-12-05 2007-02-06 Patrone III Eugene F. Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41603 41603 2008-12-31 2007-02-06 Farmer Kimberley Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41604 41604 2008-12-31 2007-02-06 Noone James Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41605 41605 2008-12-31 2007-02-06 West Fowler Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41625 41625 2008-12-31 2007-06-05 O'Hanlon John Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41626 41626 2008-12-31 2007-06-05 Boyd Moses Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41906 41906 2014-12-31 2011-02-03 Kandel Marissa Cherson Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41908 41908 2014-12-31 2012-02-06 Strauss Daniel Alter Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41909 41909 2014-12-31 2014-02-24 Kontesi Amalia Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41917 41917 2014-12-31 2013-03-18 D'Amico Kathleen Cavanaugh Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41920 41920 2014-12-31 2014-04-01 Saharko Juliet Christina Johnson Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41921 41921 2014-12-31 2011-04-15 Drechsler Marc Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41925 41925 2014-12-31 2013-04-22 Thornton Ryan Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41926 41926 2014-12-31 2009-05-07 Ruggieri Kerry Elizabeth Slatkoff Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41927 41927 2014-12-31 2009-05-07 Wool Ann Margaret Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41928 41928 2014-12-31 2014-05-07 Amorosi Alexandra Scott Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41929 41929 2014-12-31 2006-05-09 Colpitts Jennifer O'Dell Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41930 41930 2014-12-31 2006-05-09 Flaherty Robert Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41931 41931 2014-12-31 2006-05-09 Gelfond Noam Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41932 41932 2014-12-31 2006-05-09 Kotcher Raymond Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41933 41933 2014-12-31 2012-05-10 Brady Lauren Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41934 41934 2014-12-31 2010-05-24 Shkiler Alla Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41935 41935 2014-12-31 2010-05-28 Gellman Marvin G. Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41936 41936 2014-12-31 2006-05-30 Rockland David Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41937 41937 2014-12-31 2010-06-02 Allan David A.R. Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41938 41938 2014-12-31 2010-06-02 Goldstein Carole Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41939 41939 2014-12-31 2012-06-08 Knox Lauren Peterson Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41960 41960 2014-12-31 2010-08-18 Watier Katherine Ann Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41962 41962 2014-12-31 2008-08-21 Jeavons Kathleen Stone Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41963 41963 2014-12-31 2008-08-21 Levinson Lauren Kerry Glassner Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41964 41964 2014-12-31 2008-08-22 Cohen Paul Douglas Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41968 41968 2014-12-31 2008-09-22 Lamb Erika Soto Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41970 41970 2014-12-31 2014-09-22 Adams Danielle Jenee' Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41971 41971 2014-12-31 2014-09-22 Newman Alyssa Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41973 41973 2014-12-31 2010-09-24 Cole Edward Lawrimore Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41974 41974 2014-12-31 2010-09-24 Weinheimer Timothy Mark Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41975 41975 2014-12-31 2008-09-25 Miglionico-Phipps Kerri Ann Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41981 41981 2014-12-31 2013-10-23 Delaney William Michael Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41982 41982 2014-12-31 2013-10-23 Donnelly James Joseph Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41985 41985 2014-12-31 2013-11-06 Hamilton Christopher Young Patrick Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41986 41986 2014-12-31 2013-11-06 McBride Shawn Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41987 41987 2014-12-31 2013-11-06 Ritenour Miles Patrick Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41988 41988 2014-12-31 2010-11-17 Chambers Marie Moe Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41989 41989 2014-12-31 2012-12-14 Conrad Robert Keenan Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41991 41991 2014-12-31 2011-12-28 O'Gorman Catherine Mary Anne Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41992 41992 2014-12-31 2008-12-30 Buraker Kenneth Matthew Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
42155 42155 2017-12-31 2016-08-10 Kelly-Durham AnLi Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019

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