FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where Short_Form_Last_Name = "Lopez"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 21
- Junta de Cultura Espanola 2
- Mexican Tourism Board 2
- Media Planning International Corporation 2
- Mexican Government Railway System 1
- Instituto Argentino de Promocion del Intercambio 1
- Club Patriotico 26 de Julio de Miami 1
- Nicaraguan Liberation Movement of July 23rd 1
- Movimiento 26 de Julio (26th of July Movement) 1
- Partido Reformista Social Cristiano 1
- National Development Institute of Nicaragua 1
- Spanish National Tourist Office, Puerto Rico 1
- Aruba Tourism Authority 1
- Federal Reformist Party 1
- Daniel J. Edelman, Inc. 1
- Daniel J. Edelman, Inc. 1
- Collier Shannon Scott, PLLC 1
- Morrison & Foerster 1
- Moya, Villanueva & Associates 1
- QORVIS LLC 1
- Zeno Group, Inc. 1
- Ogilvy Group LLC 1
Registrant_Name 20
- Daniel J. Edelman, Inc. 2
- Junta de Cultura Espanola 2
- Media Planning International Corporation 2
- Mexican Tourism Board 2
- Aruba Tourism Authority 1
- Club Patriotico 26 de Julio de Miami 1
- Collier Shannon Scott, PLLC 1
- Federal Reformist Party 1
- Instituto Argentino de Promocion del Intercambio 1
- Mexican Government Railway System 1
- Morrison & Foerster 1
- Movimiento 26 de Julio (26th of July Movement) 1
- Moya, Villanueva & Associates 1
- National Development Institute of Nicaragua 1
- Nicaraguan Liberation Movement of July 23rd 1
- Ogilvy Group LLC 1
- Partido Reformista Social Cristiano 1
- QORVIS LLC 1
- Spanish National Tourist Office, Puerto Rico 1
- Zeno Group, Inc. 1
City 10
- New York 11
- Washington 3
- Chicago 2
- Tampa 2
- Evanston 1
- Manhattan 1
- Miami 1
- San Juan 1
- Secaucus 1
- Universal City 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
653 | 653 | 2022-03-25 | Lopez | Jissette | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
2519 | 2519 | 1959-01-01 | 1958-06-23 | Lopez | Marco Antonio Ojeda y | Club Patriotico 26 de Julio de Miami 998 | 1957-02-06 | Club Patriotico 26 de Julio de Miami | 3527 Northwest 2nd Street | Miami | FL | ||
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 |
10098 | 10098 | 1960-03-17 | 1960-03-17 | Lopez | Raull Meza | Nicaraguan Liberation Movement of July 23rd 1341 | 1960-03-17 | Nicaraguan Liberation Movement of July 23rd | 1422 Elmwood Street | Evanston | IL | ||
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 |
14819 | 14819 | 2000-04-30 | 1999-01-19 | Lopez | Istvan | Aruba Tourism Authority 2987 | 1978-12-29 | Aruba Tourism Authority | 400 Plaza Drive | Suite 101 | Secaucus | NJ | 07094 |
15157 | 15157 | 2019-04-30 | 2019-04-30 | Lopez | Ilse | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
20246 | 20246 | 1999-06-25 | 1998-07-06 | Lopez | Daniel | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3050 K Street N.W. | Suite 400 | Washington | DC | 20007-5108 |
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 |
23473 | 23473 | 1961-07-18 | 1962-03-07 | Lopez | Bienvenido Efrain | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
28170 | 28170 | 1990-08-31 | 1989-08-23 | Lopez | Edward | Morrison & Foerster 4282 | 1989-08-23 | Morrison & Foerster | 2000 Pennsylvania Avenue, N.W. | Suite 5500 | Washington | DC | 20006 |
29088 | 29088 | 1968-09-03 | 1944-07-31 | Lopez | Jose | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | Post Office Box 5037 | Tampa | FL | 33605 | |
29089 | 29089 | 1968-09-03 | 1944-07-31 | Lopez | Ramon Rodriguez | Junta de Cultura Espanola 273 | 1944-07-31 | Junta de Cultura Espanola | Post Office Box 5037 | Tampa | FL | 33605 | |
33708 | 33708 | 1994-10-27 | 1992-03-03 | Lopez | Deborah | Moya, Villanueva & Associates 4629 | 1992-03-03 | Moya, Villanueva & Associates | 10 Universal City Plaza | Suite 2600 | Universal City | CA | 91608-1084 |
35013 | 35013 | 2011-11-01 | 2010-07-20 | Lopez | Jennifer | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
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 |
37675 | 37675 | 1981-12-03 | 1972-06-05 | Lopez | Roman Arango | Spanish National Tourist Office, Puerto Rico 2344 | 1972-06-05 | Spanish National Tourist Office, Puerto Rico | 367 Fortaleza Street | San Juan | PR | 00902 | |
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 | |
38855 | 38855 | 2022-12-20 | 2021-08-05 | Lopez | Natalia | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
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]) );