FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
50 rows where Address_1 = "Guatemala City"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Date (date) 42 ✖
- 1946-12-06 3
- 1960-03-28 3
- 1969-10-09 2
- 1977-11-29 2
- 1991-04-22 2
- 1993-03-02 2
- 1953-05-21 1
- 1953-05-26 1
- 1955-01-21 1
- 1955-02-07 1
- 1955-03-23 1
- 1955-04-05 1
- 1955-08-12 1
- 1955-09-01 1
- 1955-11-30 1
- 1956-01-17 1
- 1956-04-11 1
- 1957-01-09 1
- 1957-03-26 1
- 1957-07-10 1
- 1957-12-05 1
- 1958-01-07 1
- 1958-04-11 1
- 1959-06-03 1
- 1960-02-04 1
- 1962-12-28 1
- 1968-07-01 1
- 1970-06-01 1
- 1972-01-14 1
- 1977-06-27 1
- 1979-11-05 1
- 1980-07-15 1
- 1980-12-02 1
- 1981-11-10 1
- 1984-05-09 1
- 1987-09-28 1
- 1989-01-25 1
- 1991-07-10 1
- 1991-07-12 1
- 1993-06-22 1
- 1994-09-23 1
- 1995-04-04 1
Registrant_Name 39
- Kaplan, Sheldon Z. 4
- Pan-American Coffee Bureau 3
- Foley Hoag, LLP 2
- Hannaford Company, Inc. 2
- McMahon, Henry Oliver Patrick 2
- Perez, H. Hugo 2
- Schuette, Keith E. 2
- Squire Patton Boggs, LLP 2
- Black Eagle Associates, Inc. 1
- Cameron, Bruce P. 1
- Central American Sugar Council 1
- Chapman, DiSalle & Friedman 1
- Cheesman, Frank Albert 1
- Clark, Robert Brewster 1
- Compton Advertising, Inc. 1
- Continental-Allied Company 1
- DC International, Inc. 1
- Dellale, Dina 1
- Dodd, Thomas J. 1
- Ed Graves & Associates 1
- George Peabody & Associates, Inc. 1
- Gleason Associates, Inc. 1
- Guatemala FUNDESA Working Group 1
- Haley, Kiss & Dowd, Inc. 1
- Hill and Knowlton Strategies, LLC 1
- John A. Clements Associates 1
- Keats, Allen & Keats 1
- Klein & Saks 1
- M. Silver Associates, Inc. 1
- MWW/Strategic Communications, Inc. 1
- McBryde, F. Webster 1
- McDermott, Will & Emery 1
- O'Neall, Charles F. 1
- R. Thompson & Company 1
- Ramirez-Eva, Arnoldo 1
- Reichler & Soble 1
- Schaumburger, Max Maas 1
- Scott Wilson & Associates 1
- Universal Research & Consultants, Inc. 1
Foreign_Principal 29
- Government of Guatemala 11
- Republic of Guatemala 7
- Asociacion de Azucareros de Guatemala 3
- Asociacion de Amigos del Pais 2
- CBI Sugar Group 2
- Supreme Court of Justice of the Republic of Guatemala 2
- Carlos Enrique Garcia 1
- Comite de Soporte al Comercio (COSOSCO) 1
- Continental Anti-Communist Congress 1
- FUNDESA (Fundacion para el Desarrollo de Guatemala) 1
- Federation of Central American Sugar Producers 1
- Fundacion Guatemalteca por la Libertad 1
- General Miguel Ydigoras Fuentes 1
- Government of Guatemala (President Carlos Castillo Armas & Ambassador Luis Cruis Salazar) 1
- Government of Guatemala, Central America 1
- Government of the Republic of Guatemala 1
- Government of the Republic of Guatemala Office of the Presidency 1
- Guatemala Tourism Institute (Instituto Guatemalteco de Turismo) 1
- Guatemala Tourist Commission 1
- Guatemala Tourist Institute 1
- Miguel Ydigoras Fuentes 1
- Ministerio de Hacienda y Credito Publico (Ministry of Finance & Public Credit) 1
- Ministry of Communications & Public Works - Government of Guatemala 1
- Office of the President of Guatemala 1
- Oficina Central del Cafe' 1
- Oficina Contralora de Cafe' (Formerly: Oficina Central del Cafe)" 1
- Presidency of the Republic of Guatemala 1
- President of Guatemala, H.E. Jorge Serrano Elias Director of Tourist Commission, Alfonso Reimers 1
- Procesadora de Carne, S.A. (PROCASA) 1
State 1
- - 50
Country/Location_Represented 1
- GUATEMALA 50
City 1
- - 50
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
957 | 957 | 1995-01-01 | Comite de Soporte al Comercio (COSOSCO) | 1993-06-22 | GUATEMALA | McDermott, Will & Emery 4818 | 1993-06-22 | McDermott, Will & Emery | Guatemala City | ||||
1156 | 1156 | 1980-01-08 | Guatemala Tourism Institute (Instituto Guatemalteco de Turismo) | 1973-01-26 | GUATEMALA | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | Guatemala City | ||||
1166 | 1166 | 1959-01-09 | Ministerio de Hacienda y Credito Publico (Ministry of Finance & Public Credit) | 1957-01-09 | GUATEMALA | O'Neall, Charles F. 993 | 1957-01-09 | O'Neall, Charles F. | Guatemala City | ||||
1341 | 1341 | 1996-01-15 | Government of Guatemala | 1995-04-21 | GUATEMALA | R. Thompson & Company 4950 | 1994-09-23 | R. Thompson & Company | Guatemala City | ||||
1379 | 1379 | 1956-01-17 | Republic of Guatemala | 1956-01-17 | GUATEMALA | Perez, H. Hugo 928 | 1956-01-17 | Perez, H. Hugo | Guatemala City | ||||
1429 | 1429 | 1982-01-20 | Asociacion de Azucareros de Guatemala | 1962-12-28 | GUATEMALA | Central American Sugar Council 1585 | 1962-12-28 | Central American Sugar Council | Guatemala City | ||||
1542 | 1542 | 1993-01-26 | Republic of Guatemala | 1991-07-12 | GUATEMALA | MWW/Strategic Communications, Inc. 4542 | 1991-07-12 | MWW/Strategic Communications, Inc. | Guatemala City | ||||
1856 | 1856 | 2006-01-31 | CBI Sugar Group | 1991-07-10 | GUATEMALA | Ed Graves & Associates 4541 | 1991-07-10 | Ed Graves & Associates | Guatemala City | ||||
2912 | 2912 | 1971-02-28 | Guatemala Tourist Institute | 1969-05-02 | GUATEMALA | Compton Advertising, Inc. 2095 | 1968-07-01 | Compton Advertising, Inc. | Guatemala City | ||||
4301 | 4301 | 1959-03-31 | Continental Anti-Communist Congress | 1958-09-05 | GUATEMALA | Universal Research & Consultants, Inc. 1013 | 1957-03-26 | Universal Research & Consultants, Inc. | Guatemala City | ||||
4312 | 4312 | 1963-03-31 | General Miguel Ydigoras Fuentes | 1958-04-11 | GUATEMALA | Schaumburger, Max Maas 1147 | 1958-04-11 | Schaumburger, Max Maas | Guatemala City | ||||
4314 | 4314 | 1963-03-31 | Miguel Ydigoras Fuentes | 1958-01-07 | GUATEMALA | McBryde, F. Webster 1101 | 1958-01-07 | McBryde, F. Webster | Guatemala City | ||||
4383 | 4383 | 1981-03-31 | Guatemala Tourist Commission | 1980-07-15 | GUATEMALA | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | Guatemala City | ||||
4830 | 4830 | 1955-04-01 | Government of Guatemala | 1955-02-07 | GUATEMALA | John A. Clements Associates 872 | 1955-02-07 | John A. Clements Associates | Guatemala City | ||||
6566 | 6566 | 1991-05-15 | CBI Sugar Group | 1990-08-16 | GUATEMALA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Guatemala City | ||||
6682 | 6682 | 1954-05-21 | Government of Guatemala | 1953-05-21 | GUATEMALA | Black Eagle Associates, Inc. 767 | 1953-05-21 | Black Eagle Associates, Inc. | Guatemala City | ||||
6852 | 6852 | 1961-05-26 | Oficina Central del Cafe' | 1946-12-06 | GUATEMALA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Guatemala City | ||||
6922 | 6922 | 1956-05-30 | Government of Guatemala, Central America | 1955-11-30 | GUATEMALA | Keats, Allen & Keats 921 | 1955-11-30 | Keats, Allen & Keats | Guatemala City | ||||
7049 | 7049 | 1978-05-31 | Government of Guatemala | 1977-06-27 | GUATEMALA | Kaplan, Sheldon Z. 2797 | 1977-06-27 | Kaplan, Sheldon Z. | Guatemala City | ||||
7603 | 7603 | 1958-06-05 | Republic of Guatemala | 1957-12-05 | GUATEMALA | McMahon, Henry Oliver Patrick 1092 | 1957-12-05 | McMahon, Henry Oliver Patrick | Guatemala City | ||||
7648 | 7648 | 1980-06-07 | Asociacion de Amigos del Pais | 1979-11-05 | GUATEMALA | Clark, Robert Brewster 3066 | 1979-11-05 | Clark, Robert Brewster | Guatemala City | ||||
7847 | 7847 | 1993-06-15 | Supreme Court of Justice of the Republic of Guatemala | 1992-03-10 | GUATEMALA | Reichler & Soble 3582 | 1984-05-09 | Reichler & Soble | Guatemala City | ||||
8332 | 8332 | 1980-06-30 | Fundacion Guatemalteca por la Libertad | 1980-10-23 | GUATEMALA | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | Guatemala City | ||||
8814 | 8814 | 1959-07-01 | Government of Guatemala | 1958-09-08 | GUATEMALA | Chapman, DiSalle & Friedman 867 | 1955-01-21 | Chapman, DiSalle & Friedman | Guatemala City | ||||
9059 | 9059 | 1967-07-07 | Asociacion de Azucareros de Guatemala | 1965-03-19 | GUATEMALA | Dellale, Dina 1326 | 1960-02-04 | Dellale, Dina | Guatemala City | ||||
9235 | 9235 | 1982-07-14 | Carlos Enrique Garcia | 1980-12-02 | GUATEMALA | Haley, Kiss & Dowd, Inc. 3176 | 1980-12-02 | Haley, Kiss & Dowd, Inc. | Guatemala City | ||||
9649 | 9649 | 1956-07-31 | Government of Guatemala (President Carlos Castillo Armas & Ambassador Luis Cruis Salazar) | 1955-08-12 | GUATEMALA | McMahon, Henry Oliver Patrick 905 | 1955-08-12 | McMahon, Henry Oliver Patrick | Guatemala City | ||||
10239 | 10239 | 1993-08-09 | Republic of Guatemala | 1991-02-12 | GUATEMALA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Guatemala City | ||||
10829 | 10829 | 1955-08-30 | Government of Guatemala | 1955-04-05 | GUATEMALA | Continental-Allied Company 885 | 1955-04-05 | Continental-Allied Company | Guatemala City | ||||
10905 | 10905 | 1981-08-31 | Asociacion de Amigos del Pais | 1980-11-09 | GUATEMALA | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | Guatemala City | ||||
11002 | 11002 | 1990-08-31 | Government of the Republic of Guatemala Office of the Presidency | 1989-01-25 | GUATEMALA | DC International, Inc. 4210 | 1989-01-25 | DC International, Inc. | Guatemala City | ||||
11317 | 11317 | 1955-09-02 | Government of Guatemala | 1955-03-23 | GUATEMALA | Cheesman, Frank Albert 880 | 1955-03-23 | Cheesman, Frank Albert | Guatemala City | ||||
11558 | 11558 | 1960-09-13 | Ministry of Communications & Public Works - Government of Guatemala | 1960-04-05 | GUATEMALA | Kaplan, Sheldon Z. 1344 | 1960-03-28 | Kaplan, Sheldon Z. | Guatemala City | ||||
11592 | 11592 | 1993-09-14 | Office of the President of Guatemala | 1992-04-02 | GUATEMALA | Schuette, Keith E. 4503 | 1991-04-22 | Schuette, Keith E. | Guatemala City | ||||
12033 | 12033 | 1991-09-30 | President of Guatemala, H.E. Jorge Serrano Elias Director of Tourist Commission, Alfonso Reimers | 1991-04-22 | GUATEMALA | Schuette, Keith E. 4503 | 1991-04-22 | Schuette, Keith E. | Guatemala City | ||||
12149 | 12149 | 2003-09-30 | Republic of Guatemala | 2000-02-09 | GUATEMALA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Guatemala City | ||||
12306 | 12306 | 1962-10-01 | Government of Guatemala | 1960-10-10 | GUATEMALA | Kaplan, Sheldon Z. 1344 | 1960-03-28 | Kaplan, Sheldon Z. | Guatemala City | ||||
13342 | 13342 | 1995-10-31 | FUNDESA (Fundacion para el Desarrollo de Guatemala) | 1995-04-04 | GUATEMALA | Guatemala FUNDESA Working Group 5007 | 1995-04-04 | Guatemala FUNDESA Working Group | Guatemala City | ||||
13524 | 13524 | 1955-11-01 | Government of the Republic of Guatemala | 1956-03-21 | GUATEMALA | George Peabody & Associates, Inc. 768 | 1953-05-26 | George Peabody & Associates, Inc. | Guatemala City | ||||
13724 | 13724 | 1958-11-05 | Republic of Guatemala | 1957-07-10 | GUATEMALA | Dodd, Thomas J. 1050 | 1957-07-10 | Dodd, Thomas J. | Guatemala City | ||||
14178 | 14178 | 1956-11-23 | Republic of Guatemala | 1956-04-11 | GUATEMALA | Perez, H. Hugo 943 | 1956-04-11 | Perez, H. Hugo | Guatemala City | ||||
15325 | 15325 | 1994-12-22 | Supreme Court of Justice of the Republic of Guatemala | 1993-03-03 | GUATEMALA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Guatemala City | ||||
15559 | 15559 | 1956-12-31 | Government of Guatemala | 1955-09-01 | GUATEMALA | Scott Wilson & Associates 907 | 1955-09-01 | Scott Wilson & Associates | Guatemala City | ||||
15598 | 15598 | 1960-12-31 | Government of Guatemala | 1959-06-03 | GUATEMALA | Klein & Saks 1234 | 1959-06-03 | Klein & Saks | Guatemala City | ||||
15636 | 15636 | 1965-12-31 | Asociacion de Azucareros de Guatemala | 1960-04-05 | GUATEMALA | Kaplan, Sheldon Z. 1344 | 1960-03-28 | Kaplan, Sheldon Z. | Guatemala City | ||||
15729 | 15729 | 1974-12-31 | Federation of Central American Sugar Producers | 1970-06-01 | GUATEMALA | Ramirez-Eva, Arnoldo 2197 | 1970-06-01 | Ramirez-Eva, Arnoldo | Guatemala City | ||||
15764 | 15764 | 1976-12-31 | Government of Guatemala | 1965-08-16 | GUATEMALA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Guatemala City | ||||
15780 | 15780 | 1976-12-31 | Oficina Contralora de Cafe' (Formerly: Oficina Central del Cafe)" | 1960-11-25 | GUATEMALA | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Guatemala City | ||||
15882 | 15882 | 1982-12-31 | Procesadora de Carne, S.A. (PROCASA) | 1980-08-12 | GUATEMALA | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Guatemala City | ||||
16173 | 16173 | 1990-12-31 | Presidency of the Republic of Guatemala | 1987-09-28 | GUATEMALA | Cameron, Bruce P. 4043 | 1987-09-28 | Cameron, Bruce P. | Guatemala City |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );