FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
48 rows where "Short_Form_Termination_Date" is on date 2021-04-30
This data as json, CSV (advanced)
Registration_Number 13
- Fleishman-Hillard, Inc. 15
- CITGO Petroleum Corporation ("CPC") 7
- Ogilvy Group LLC 6
- GR Pro, LLC 5
- CITGO Holding, Inc. ("CITGOH") 3
- National Wildlife Federation 2
- VantageKnight LLC 2
- PDV Holding, Inc. ("PDVH") 2
- Willkie Farr & Gallagher LLP 2
- Avenue Strategies, LLC 1
- Freeman Mathis Decisions 1
- Ruder Finn, Inc. 1
- Liberty International Group 1
Registrant_Name 13
- Fleishman-Hillard, Inc. 15
- CITGO Petroleum Corporation ("CPC") 7
- Ogilvy Group LLC 6
- GR Pro, LLC 5
- CITGO Holding, Inc. ("CITGOH") 3
- National Wildlife Federation 2
- PDV Holding, Inc. ("PDVH") 2
- VantageKnight LLC 2
- Willkie Farr & Gallagher LLP 2
- Avenue Strategies, LLC 1
- Freeman Mathis Decisions 1
- Liberty International Group 1
- Ruder Finn, Inc. 1
City 9
- St. Louis 15
- Houston 9
- New York 9
- Oklahoma City 5
- Houston 3
- Reston 2
- San Juan 2
- Washington 2
- Atlanta 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15215 | 15215 | 2021-04-30 | 2021-01-28 | Balough | Rebecca | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
15216 | 15216 | 2021-04-30 | 2021-01-30 | Adolph | Michael Charles | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15217 | 15217 | 2021-04-30 | 2021-01-30 | Belding | Arman | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15218 | 15218 | 2021-04-30 | 2021-01-30 | Bernard | Mikael | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15219 | 15219 | 2021-04-30 | 2021-01-30 | Bueno | Alexander de la Torre | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15220 | 15220 | 2021-04-30 | 2021-01-30 | Franklin | James Nikolai | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15221 | 15221 | 2021-04-30 | 2021-01-30 | Graziano | Devon | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15222 | 15222 | 2021-04-30 | 2021-01-30 | Heibeck | Olivia | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15223 | 15223 | 2021-04-30 | 2021-01-30 | Sanchez | Nicole | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15224 | 15224 | 2021-04-30 | 2021-03-10 | Mulcahy | Sarah | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
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 | |
15231 | 15231 | 2021-04-30 | 2021-04-30 | Bennett | Barry | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 1627 I Street, NW | Suite 825 | Washington | DC | 20006 |
15232 | 15232 | 2021-04-30 | 2021-04-30 | Coleman IV | Thomas Gordon | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15233 | 15233 | 2021-04-30 | 2021-04-30 | DeMetri | Olga | VantageKnight LLC 6953 | 2021-04-30 | VantageKnight LLC | 705 Fernandez Juncos Avenue | San Juan | |||
15234 | 15234 | 2021-04-30 | 2021-04-30 | Elizondo Sr. | Larry Raymond | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15235 | 15235 | 2021-04-30 | 2021-04-30 | Esser II | Richard A. | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15236 | 15236 | 2021-04-30 | 2021-04-30 | Esser II | Richard A. | CITGO Holding, Inc. ("CITGOH") 6955 | 2021-04-30 | CITGO Holding, Inc. ("CITGOH") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15237 | 15237 | 2021-04-30 | 2021-04-30 | Gottlieb | Michael | Willkie Farr & Gallagher LLP 6957 | 2021-04-30 | Willkie Farr & Gallagher LLP | 787 Seventh Avenue | New York | NY | 10019 | |
15238 | 15238 | 2021-04-30 | 2021-04-30 | Jorda | Carlos E. | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15239 | 15239 | 2021-04-30 | 2021-04-30 | Lynch Jr. | John E. | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15240 | 15240 | 2021-04-30 | 2021-04-30 | Ortiz | Manuel Antonio | VantageKnight LLC 6953 | 2021-04-30 | VantageKnight LLC | 705 Fernandez Juncos Avenue | San Juan | |||
15241 | 15241 | 2021-04-30 | 2021-04-30 | Palacios | Luisa | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15242 | 15242 | 2021-04-30 | 2021-04-30 | Palacios | Luisa | CITGO Holding, Inc. ("CITGOH") 6955 | 2021-04-30 | CITGO Holding, Inc. ("CITGOH") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15243 | 15243 | 2021-04-30 | 2021-04-30 | Palacios | Luisa | PDV Holding, Inc. ("PDVH") 6956 | 2021-04-30 | PDV Holding, Inc. ("PDVH") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15244 | 15244 | 2021-04-30 | 2021-04-30 | Strickland | Rachel | Willkie Farr & Gallagher LLP 6957 | 2021-04-30 | Willkie Farr & Gallagher LLP | 787 Seventh Avenue | New York | NY | 10019 | |
15245 | 15245 | 2021-04-30 | 2021-04-30 | Vera | Fernando J. | CITGO Petroleum Corporation ("CPC") 6954 | 2021-04-30 | CITGO Petroleum Corporation ("CPC") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15246 | 15246 | 2021-04-30 | 2021-04-30 | Vera | Fernando J. | CITGO Holding, Inc. ("CITGOH") 6955 | 2021-04-30 | CITGO Holding, Inc. ("CITGOH") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15247 | 15247 | 2021-04-30 | 2021-04-30 | Vera | Fernando J. | PDV Holding, Inc. ("PDVH") 6956 | 2021-04-30 | PDV Holding, Inc. ("PDVH") | 1293 Eldridge Parkway | Houston | TX | 77077 | |
15248 | 15248 | 2021-04-30 | 2020-06-16 | Burns | David Nathaniel | National Wildlife Federation 6836 | 2020-06-16 | National Wildlife Federation | 11100 Wildlife Center Drive | Reston | VA | 20190 | |
15249 | 15249 | 2021-04-30 | 2020-06-16 | Walker | Nathalie Fleur | National Wildlife Federation 6836 | 2020-06-16 | National Wildlife Federation | 11100 Wildlife Center Drive | Reston | VA | 20190 | |
15250 | 15250 | 2021-04-30 | 2020-06-26 | Rahman | Kamilla | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15251 | 15251 | 2021-04-30 | 2020-06-26 | Teahan | Caitlin | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15252 | 15252 | 2021-04-30 | 2021-09-10 | Powers | Shelby L | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15253 | 15253 | 2021-04-30 | 2021-09-10 | Powers | Shelby Lynn | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15254 | 15254 | 2021-04-30 | 2019-10-08 | Chatlos | Shannon B. | GR Pro, LLC 6738 | 2019-10-08 | GR Pro, LLC | 316 N.W. 61st Street | Oklahoma City | OK | 73118 | |
15255 | 15255 | 2021-04-30 | 2019-10-08 | Heitman | Mary L. | GR Pro, LLC 6738 | 2019-10-08 | GR Pro, LLC | 316 N.W. 61st Street | Oklahoma City | OK | 73118 | |
15256 | 15256 | 2021-04-30 | 2019-10-08 | Richardson III | John W. | GR Pro, LLC 6738 | 2019-10-08 | GR Pro, LLC | 316 N.W. 61st Street | Oklahoma City | OK | 73118 | |
15257 | 15257 | 2021-04-30 | 2019-10-08 | Richardson | Jeri L. | GR Pro, LLC 6738 | 2019-10-08 | GR Pro, LLC | 316 N.W. 61st Street | Oklahoma City | OK | 73118 | |
15258 | 15258 | 2021-04-30 | 2019-10-08 | Robinson | Karma K. | GR Pro, LLC 6738 | 2019-10-08 | GR Pro, LLC | 316 N.W. 61st Street | Oklahoma City | OK | 73118 | |
15259 | 15259 | 2021-04-30 | 2020-10-09 | Girouard | Spencer | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15260 | 15260 | 2021-04-30 | 2020-10-13 | Evenson | Erin | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
15261 | 15261 | 2021-04-30 | 2018-10-15 | Satcher | Daraka | Freeman Mathis Decisions 6600 | 2018-10-15 | Freeman Mathis Decisions | 100 Galleria Parkway | Suite 1600 | Atlanta | GA | 30339 |
15262 | 15262 | 2021-04-30 | 2020-10-24 | Mack | Connie | Liberty International Group 6881 | 2020-10-24 | Liberty International Group | 1120 20th Street NW | Washington | DC | 20036 |
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]) );