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

86 rows where City = "New York" and Registrant_Name = "Ogilvy Group LLC"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Date (date), Registration_Date (date)

State 1

  • NY 86

Registration_Number 1

  • Ogilvy Group LLC 86

Registrant_Name 1

  • Ogilvy Group LLC · 86 ✖

City 1

  • New York · 86 ✖
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
37 37     Prendergast Olivia Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
70 70   2022-01-06 Ling Margaret R Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
76 76   2022-01-07 Castro Erika Urgiles Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
77 77   2022-01-07 Ramano Chrikstine Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
78 78   2022-01-07 Romero Andrea Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
79 79   2022-01-07 Rose Michaelann Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
80 80   2022-01-07 Simon Sean Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
81 81   2022-01-07 Smith Melissa Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
82 82   2022-01-07 Tay Lilyan Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
83 83   2022-01-07 Zumwalt Denee Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
90 90   2022-01-10 Applegate Alyssa Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
91 91   2022-01-10 Daniel Hannah Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
92 92   2022-01-10 Fabinao Jillian Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
93 93   2022-01-10 Mullins Tara Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
94 94   2022-01-10 Ortiz Cathy Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
95 95   2022-01-10 Risi Jennifer Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
183 183   2022-01-24 Crawford Camilyn Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
185 185   2022-01-24 Hanna Edmund Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
433 433   2021-02-21 Calveiro Lisette Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
496 496   2020-03-04 Baumann Terri Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
497 497   2020-03-04 Dickson Madeline Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
498 498   2020-03-04 Mackenzie Kimberly Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
499 499   2020-03-04 Merritt Matthew Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
500 500   2020-03-04 Pope Kristie Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
501 501   2020-03-04 Redmond Hillary Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
502 502   2020-03-04 Vardaro Valerie Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
545 545   2021-03-10 Maranzani Martha Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
546 546   2021-03-10 Reiss Christina Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
582 582   2021-03-16 Kaiser Michael Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
583 583   2021-03-16 Williams Ansley Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
639 639   2022-03-24 Atta Kobby Amoako Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
640 640   2022-03-24 Chiu Leslie Tan Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
641 641   2022-03-24 Fishel Gayle Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
642 642   2022-03-24 Jimenez Camilo Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
643 643   2022-03-24 Pettersson Leah Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
644 644   2022-03-24 Romano Christine Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
645 645   2022-03-24 Sass Rebecca Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
646 646   2022-03-24 Sotelo Barbara Tamra Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
652 652   2022-03-25 Kretzschmar Natalie Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
653 653   2022-03-25 Lopez Jissette Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
812 812   2021-04-16 McGarry Kelly Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
814 814   2021-04-16 Ting Laura Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1066 1066   2022-05-20 Boesen Madelyn Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1067 1067   2022-05-20 Sequeira Siddhanth Iyer Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1085 1085   2022-05-23 Gross Dyneisha Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1233 1233   2022-06-14 Hilton Katherine Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1235 1235   2022-06-14 Schubert Sherri Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1590 1590   2021-08-10 Cardenas Carol Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1591 1591   2021-08-10 Smith Cara Meadows Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
1670 1670   2022-08-26 Sholley George Burrill Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2028 2028   2022-10-25 Ndjib Jacqueline Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2029 2029   2022-10-25 Shafer Isabelle Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2030 2030   2022-10-25 Smith Arianne Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2031 2031   2022-10-25 Szymanski Susan Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2091 2091   2020-11-02 Aaron Michael Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2096 2096   2020-11-02 Irons Todd Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2098 2098   2020-11-02 Kress Jason Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2100 2100   2020-11-02 Weiss Sophia Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2130 2130   2020-11-10 Caggiano Rachel Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2138 2138   2020-11-11 Dwyer Elizabeth Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2139 2139   2020-11-11 High Emily Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
2179 2179   2022-11-17 Urbach Brooke Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
3720 3720 2022-01-14 2020-03-04 Harrison Melissa Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
9671 9671 2022-03-11 2021-04-16 Ngo Angie Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
12611 12611 2022-04-01 2022-01-07 Treganowan Kathleen Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
12707 12707 2021-04-03 2020-03-04 Fairchild Elizabeth Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
12976 12976 2021-04-08 2021-03-10 Simpson Sarah Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
12977 12977 2021-04-08 2020-11-02 Fliflet Katherine Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
13886 13886 2021-04-21 2021-03-16 Smith Ashley Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
15225 15225 2021-04-30 2021-03-16 Thomas Jasmine Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
15226 15226 2021-04-30 2021-04-16 Castillo Cassandra Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
15227 15227 2021-04-30 2021-04-16 Hardy Laura Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
15228 15228 2021-04-30 2021-04-16 Parada Valencia Monica A. Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
15229 15229 2021-04-30 2021-04-16 Price Jessica Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
15230 15230 2021-04-30 2021-04-16 Wang Andrea Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
16347 16347 2021-05-14 2021-04-16 Ardis Joseph Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
21974 21974 2021-06-30 2021-03-10 Shamin Anastacia Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
21978 21978 2021-06-30 2021-04-26 Au Shannon Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
21979 21979 2021-06-30 2021-04-26 Collins Laurie Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
21980 21980 2021-06-30 2021-04-26 Sauter Danielle B Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
23752 23752 2021-07-21 2021-03-10 Ginde Uma Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
26468 26468 2022-08-11 2022-01-10 Bohinc Elizabeth Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
28705 28705 2021-08-31 2021-08-10 Suzuki Nanaka Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
29970 29970 2021-09-16 2021-04-16 Hanley Katelyn Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
29971 29971 2021-09-16 2021-04-16 Kim Hannah Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
30288 30288 2022-09-22 2022-03-24 McGarry Jacquelyn Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036

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