FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
86 rows where City = "New York", "Registration_Date" is on date 2020-03-04 and Registration_Number = 6797
This data as json, CSV (advanced)
State 1
- NY 86
Registration_Number 1
- Ogilvy Group LLC · 86 ✖
Registrant_Name 1
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
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]) );