FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York", Short_Form_Last_Name = "Lopez" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 9
- Mexican Tourism Board 2
- Media Planning International Corporation 2
- Mexican Government Railway System 1
- Instituto Argentino de Promocion del Intercambio 1
- Partido Reformista Social Cristiano 1
- National Development Institute of Nicaragua 1
- Federal Reformist Party 1
- Daniel J. Edelman, Inc. 1
- Ogilvy Group LLC 1
Registrant_Name 9
- Media Planning International Corporation 2
- Mexican Tourism Board 2
- Daniel J. Edelman, Inc. 1
- Federal Reformist Party 1
- Instituto Argentino de Promocion del Intercambio 1
- Mexican Government Railway System 1
- National Development Institute of Nicaragua 1
- Ogilvy Group LLC 1
- Partido Reformista Social Cristiano 1
State 1
- NY · 11 ✖
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
653 | 653 | 2022-03-25 | Lopez | Jissette | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
3203 | 3203 | 2008-01-04 | 2008-10-31 | Lopez | Jennifer | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
4143 | 4143 | 1953-01-20 | 1947-09-23 | Lopez | Blanca Maria | Instituto Argentino de Promocion del Intercambio 489 | 1947-09-23 | Instituto Argentino de Promocion del Intercambio | 45 Rockefeller Plaza | Room 557 | New York | NY | |
6192 | 6192 | 2002-02-05 | 1976-10-28 | Lopez | Amable | Partido Reformista Social Cristiano 1687 | 1964-02-05 | Partido Reformista Social Cristiano | 3736 10th Avenue | Suite 9A | New York | NY | 10034 |
11054 | 11054 | 1994-03-29 | 1987-02-20 | Lopez | Francisco J. Gurria | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
22007 | 22007 | 2022-06-30 | 2021-07-09 | Lopez | Victor | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
35945 | 35945 | 1988-11-16 | 1983-04-11 | Lopez | Manuel | Federal Reformist Party 3465 | 1983-04-11 | Federal Reformist Party | 3750 Broadway | Apartment 6 | New York | NY | 10032 |
38459 | 38459 | 2020-12-15 | 2019-03-08 | Lopez | Andrea | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
38778 | 38778 | 1966-12-20 | 1965-12-20 | Lopez | Jaime | National Development Institute of Nicaragua 1947 | 1965-12-20 | National Development Institute of Nicaragua | 270 Park Avenue | New York | NY | 10017 | |
39360 | 39360 | 1983-12-30 | 1946-12-17 | Lopez | Jose M. | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
41391 | 41391 | 2005-12-31 | 1991-02-08 | Lopez | Maria Isabel | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
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]) );