home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

92 rows where State = "FL" sorted by Country/Location_Represented

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)

Registrant_Name >30

  • Junta de Liberacion Cubana 7
  • Fernandez, Carlos B. 6
  • International Council of Cruise Lines 6
  • Alcalde & Fay 3
  • Hill and Knowlton Strategies, LLC 3
  • Holland & Knight 3
  • Hogan, Donald W. 2
  • Robinsons, Inc. 2
  • Tew Cardenas, LLP 2
  • Akin, Gump, Strauss, Hauer & Feld, LLP 1
  • Asencio, Armando J. 1
  • Associates Detectives, Inc. 1
  • BGR Government Affairs, LLC 1
  • Bergner Bockorny, Inc. 1
  • Betancourt, Ernesto F. 1
  • Brock Group 1
  • Bryan Cave Leighton Paisner LLP 1
  • Burgum & Grimm, Ltd. 1
  • Capital Services of Washington, Inc. 1
  • Carmen Group, Inc. 1
  • Carmen, Carmen & Hugel, Inc. 1
  • Club 26 de Julio de Miami 1
  • Corcoran, Howard F. 1
  • DLA Piper US LLP 1
  • Dow, Thomas Michael 1
  • Downey McGrath Group, Inc. 1
  • Fiallo, Rene 1
  • Foley & Lardner 1
  • Fraser Associates, Inc. 1
  • Freed, Owen S. 1
  • …

Foreign_Principal >30

  • Government of Haiti 4
  • Committee for Free Elections & Democracy in Nicaragua 2
  • Dr. Carlos Prio Socarras 2
  • Embraer Aircraft Corporation 2
  • His Thai Majesty's Consulate 2
  • Norwegian Caribbean Lines 2
  • Republic of Haiti 2
  • 26 de Julio Committee in Exile 1
  • 26 de Julio, Country in Exile 1
  • ADO-Civilista of Panama 1
  • Aeromexico 1
  • Air Jamaica Limited 1
  • Antonov Aircraft Corporation 1
  • Arcaya and Associates 1
  • Avianca, Inc. 1
  • Bacardi Imports of Miami 1
  • Bahamas Tourist Office 1
  • Banque Paribas 1
  • Berna Products Corporation 1
  • Burger King Corporation (a Subsidiary of Pillsbury Company) 1
  • Carlos Prio Socarras 1
  • Carnival Corporation 1
  • Carnival Corporation & plc 1
  • Carnival Cruise Lines 1
  • Central American Lawyers' Group 1
  • Claudio Motta 1
  • Club 26 de Julio de Miami 1
  • Colombia Flower Council 1
  • Commodore Cruise Lines 1
  • Consulate of Brasil 1
  • …

Country/Location_Represented 30

  • CUBA 22
  • HAITI 10
  • INTERNATIONAL 8
  • BAHAMAS 5
  • BRAZIL 5
  • COLOMBIA 5
  • MEXICO 4
  • VENEZUELA 3
  • EL SALVADOR 2
  • GREAT BRITAIN 2
  • HONDURAS 2
  • JAMAICA 2
  • NICARAGUA 2
  • NORWAY 2
  • PANAMA 2
  • THAILAND 2
  • ANGOLA 1
  • BERMUDA 1
  • CAYMAN ISLANDS 1
  • CHINA 1
  • COSTA RICA 1
  • DOMINICAN REPUBLIC 1
  • FRANCE 1
  • GUATEMALA 1
  • ISRAEL 1
  • PERU 1
  • RUSSIA 1
  • ST. MARTIN 1
  • SWITZERLAND 1
  • UKRAINE 1

City 5

  • - 83
  • Miami 6
  • Coral Gables 1
  • Doral 1
  • Plantation 1

State 1

  • FL · 92 ✖
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
2979 2979 1992-02-28 Claudio Motta 1991-09-06 ANGOLA Samuels International Associates, Inc. 4563 1991-09-06 Samuels International Associates, Inc. Key Biscayne     FL  
1191 1191 1991-01-10 Royal Caribbean Cruise Line 1985-09-26 BAHAMAS Alcalde & Fay 3571 1984-03-14 Alcalde & Fay Miami     FL  
1734 1734 1989-01-31 Nassau & Paradise Island Promotion Board 1983-01-28 BAHAMAS Needham & Grohmann, Inc. 3451 1983-01-28 Needham & Grohmann, Inc. Miami     FL  
7472 7472 2021-06-01 Nassau Paradise Island Promotion Board 2017-11-27 BAHAMAS MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 1200 S. Pine Island Road, Suite 700   Plantation FL 33324
8503 8503 1992-06-30 Nassau/Cable Beach/Paradise Island Promotion Board 1991-09-05 BAHAMAS M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. Coral Cables     FL  
14785 14785 1982-12-04 Bahamas Tourist Office 1980-07-08 BAHAMAS Robinsons, Inc. 3110 1980-06-03 Robinsons, Inc. Coral Gables     FL  
13353 13353 1996-10-31 Bacardi Imports of Miami 1993-11-24 BERMUDA Brock Group 4310 1989-10-23 Brock Group Miami     FL  
2785 2785 1996-02-25 Embraer Aircraft Corporation 1995-05-24 BRAZIL Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Fort Lauderdale     FL  
3084 3084 2007-02-28 Varig Brazilian Airlines 1989-09-07 BRAZIL Holland & Knight 3718 1985-08-07 Holland & Knight Miami     FL  
6669 6669 1988-05-20 Transbrasil Airlines, Inc. 1987-02-20 BRAZIL L.A. Motley & Company 3723 1985-08-15 L.A. Motley & Company Miami     FL  
12843 12843 1962-10-19 Consulate of Brasil 1962-10-19 BRAZIL Freed, Owen S. 1575 1962-10-19 Freed, Owen S. Miami     FL  
13245 13245 1987-10-31 Embraer Aircraft Corporation 1987-05-22 BRAZIL Hannaford Company, Inc. 2850 1977-11-29 Hannaford Company, Inc. Fort Lauderdale     FL  
7840 7840 1993-06-15 Laboratorios BioPur, S.A. 1990-04-27 CAYMAN ISLANDS Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Miami     FL  
7730 7730 1992-06-10 U.S. Agri-Chemicals, Inc. (SINOCHEM) 1991-05-30 CHINA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Ft. Meade     FL  
5478 5478 1994-04-22 Avianca, Inc. 1988-03-10 COLOMBIA Bergner Bockorny, Inc. 3801 1986-03-20 Bergner Bockorny, Inc. Miami     FL  
8074 8074 1996-06-24 Colombia Flower Council 1994-05-26 COLOMBIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Miami     FL  
12431 12431 2022-10-01 ProColombia 2022-03-15 COLOMBIA Ketchum, Inc. 7096 2022-03-15 Ketchum, Inc. 601 Brickell Key Drive   Miami FL 33131
14146 14146 1963-11-22 Consulate of Columbia 1961-03-30 COLOMBIA Fernandez, Carlos B. 1409 1960-11-22 Fernandez, Carlos B. Miami     FL  
16770 16770 2015-12-31 Procolombia 2014-03-11 COLOMBIA Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 601 Brickell Key Drive   Miami FL 33131
14789 14789 1982-12-04 Costa Rican Tourist Board 1980-07-08 COSTA RICA Robinsons, Inc. 3110 1980-06-03 Robinsons, Inc. Miami     FL  
1664 1664 1958-01-31 Directorio Obrero Revolucionario 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1665 1665 1958-01-31 Directorio Revolucionario 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1666 1666 1958-01-31 Federacion Estudiantil Universitaria 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1669 1669 1958-01-31 Movimiento 26 de Julio 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1670 1670 1958-01-31 Organizacion Autentica 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1671 1671 1958-01-31 Partido Revolucionario Cubano (Autentico) 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1672 1672 1958-01-31 Partido del Pueblo Cubano (Ortodoxos) 1957-11-27 CUBA Junta de Liberacion Cubana 1086 1957-11-27 Junta de Liberacion Cubana Miami     FL  
1962 1962 1961-02-01 Club 26 de Julio de Miami 1961-02-01 CUBA Club 26 de Julio de Miami 1423 1961-02-01 Club 26 de Julio de Miami Miami     FL  
2534 2534 1954-02-15 Carlos Prio Socarras 1954-02-15 CUBA Griffin, John David 815 1954-02-15 Griffin, John David Miami     FL  
5451 5451 1962-04-21 Republic of Cuba 1960-10-21 CUBA Patton & Kanner 1403 1960-10-21 Patton & Kanner Miami     FL  
6355 6355 1964-05-06 Ejercito Libertador de Cuba (Libertad y Soberarania) 1962-11-06 CUBA Friends of Cuba In Exile 1579 1962-11-06 Friends of Cuba In Exile Miami     FL  
7029 7029 1964-05-31 No foreign principal listed 1963-08-22 CUBA Movimiento Revolucionario 30 de Noviembre, Frank Pais 1654 1963-08-22 Movimiento Revolucionario 30 de Noviembre, Frank Pais Miami     FL  
7933 7933 1959-06-19 26 de Julio Committee in Exile 1959-06-19 CUBA Hogan, Donald W. 1238 1959-06-19 Hogan, Donald W. Miami     FL  
8233 8233 1959-06-30 26 de Julio, Country in Exile 1959-06-19 CUBA Hogan, Donald W. 1238 1959-06-19 Hogan, Donald W. Miami     FL  
10289 10289 1963-08-12 Ejercito Libertador de Cuba 1963-07-08 CUBA Betancourt, Ernesto F. 1644 1963-07-08 Betancourt, Ernesto F. Miami     FL  
10754 10754 1956-08-26 Dr. Carlos Prio Socarras 1954-02-26 CUBA Fiallo, Rene 818 1954-02-26 Fiallo, Rene Miami     FL  
10878 10878 1963-08-31 Consulate of Cuba 1961-03-30 CUBA Fernandez, Carlos B. 1409 1960-11-22 Fernandez, Carlos B. Miami     FL  
11825 11825 1960-09-26 Hector Garcia Soto 1960-09-26 CUBA Asencio, Armando J. 1395 1960-09-26 Asencio, Armando J. Miami     FL  
13913 13913 1958-11-13 Junta de Liberacion 1957-11-13 CUBA Prio Socarras, Carlos 1082 1957-11-13 Prio Socarras, Carlos Miami     FL  
14145 14145 1963-11-22 Cuban Air Force, Attache' (Captain Randolfo Cossio) 1961-03-30 CUBA Fernandez, Carlos B. 1409 1960-11-22 Fernandez, Carlos B. Miami     FL  
14149 14149 1963-11-22 Frente Revolucionario Democratico 1960-11-22 CUBA Fernandez, Carlos B. 1409 1960-11-22 Fernandez, Carlos B. Miami     FL  
15401 15401 1963-12-27 Movimiento Democrata Cristiano (Christian Democrat Movement) (Underground) 1961-12-07 CUBA Movimiento Democrata Cristiano de Cuba (MDC) 1498 1961-12-07 Movimiento Democrata Cristiano de Cuba (MDC) Miami     FL  
5522 5522 2006-04-24 Embassy of the Dominican Republic 2004-03-29 DOMINICAN REPUBLIC Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP Consulate of the Dominican Republic 1038 Brickell Avenue Miami FL 33131
1539 1539 1993-01-26 Central American Lawyers' Group 1991-10-08 EL SALVADOR Sciaroni, Bretton G. 4574 1991-10-08 Sciaroni, Bretton G. Miami     FL  
13556 13556 1982-11-01 Salvadorean Coalition for Freedom & Independence, Inc. 1982-10-14 EL SALVADOR Fraser Associates, Inc. 2844 1977-11-08 Fraser Associates, Inc. Coral Gables     FL  
14362 14362 1984-11-30 Banque Paribas 1984-05-31 FRANCE Hank Meyer Associates, Inc. 1161 1958-08-11 Hank Meyer Associates, Inc. Miami     FL  
3486 3486 1995-03-06 NEI Syncrolift, Inc., Wholly-Owned Subsidiary of Rolls-Royce, PLC, of England - London, England 1991-03-14 GREAT BRITAIN Hyman Fine & Associates, Ltd. 3273 1981-09-02 Hyman Fine & Associates, Ltd. Miami     FL  
14872 14872 1992-12-07 Burger King Corporation (a Subsidiary of Pillsbury Company) 1990-11-30 GREAT BRITAIN McGrann Shea Franzen Carnival Straughn & Lamb, Chartered 4357 1990-04-02 McGrann Shea Franzen Carnival Straughn & Lamb, Chartered Miami     FL  
2929 2929 1982-02-28 Domingo Moreira 1982-02-26 GUATEMALA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Miami     FL  
3332 3332 2004-03-01 Government of Haiti 2003-05-07 HAITI DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP Plaza 2650, 2nd Floor 2650 S.W. 27th Avenue Miami 33133     FL  
3571 3571 1959-03-10 Haiti 1958-09-10 HAITI Associates Detectives, Inc. 1168 1958-09-10 Associates Detectives, Inc. Miami Springs     FL  
3575 3575 1983-03-10 Consulate of Republic of Haiti 1982-09-14 HAITI Paul, Landy, Beiley, Harper & Metsch, P.A. 3413 1982-09-14 Paul, Landy, Beiley, Harper & Metsch, P.A. Miami     FL  
3585 3585 2004-03-10 Government of Haiti 2003-07-24 HAITI Global Market Solutions, Inc. 5568 2003-07-24 Global Market Solutions, Inc.       FL  
6991 6991 2003-05-30 Government of Haiti 2003-03-21 HAITI Foley & Lardner 5546 2003-03-21 Foley & Lardner c/o Ira Kurzban, Esq. 2650 S.W. 27th Avenue, 2nd Floor, Miami 33133     FL  
12066 12066 1995-09-30 Gregory Mevs 1992-05-07 HAITI Williams & Connolly 4225 1989-03-14 Williams & Connolly Miami     FL  
12614 12614 1983-10-12 Republic of Haiti 1982-03-05 HAITI Walters, Costanzo, Miller & Russell 3343 1982-03-05 Walters, Costanzo, Miller & Russell       FL  
16497 16497 2001-12-31 Government of Haiti 2001-06-04 HAITI Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Kurzban Kurzban Weinger & Tetzeli Plaza 2650, Second Floor 2650 S.W. 27th Avenue Miami 33133     FL  
16508 16508 2001-12-31 Republic of Haiti 2003-06-04 HAITI QORVIS LLC 5483 2002-03-06 QORVIS LLC Kurzban, Kurzban, Weinger & Tetzeli Plaza 2650, Second Floor 2650 S.W. 27th Avenue Miami 33133     FL  
16517 16517 2002-12-31 Government of Haiti 2002-01-18 HAITI Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. Kurzban, Kurzban, Weinger & Tetzeli Plaza 2650, Second Floor 2650 SW 27th Avenue Miami 33133     FL  
1731 1731 1988-01-31 Oswaldo Ramos-Soto (Through Friends of Democracy, Inc.) 1988-01-25 HONDURAS Seyedin, Hamid Reza 4081 1988-01-25 Seyedin, Hamid Reza Miami     FL  
9587 9587 1988-07-29 Friends of Oswaldo Ramos-Soto - Friends of Democracy, Inc. 1987-11-23 HONDURAS Carmen, Carmen & Hugel, Inc. 4066 1987-11-23 Carmen, Carmen & Hugel, Inc. Miami     FL  
1012 1012 2011-01-01 Carnival Corporation & plc 2011-01-28 INTERNATIONAL Dow, Thomas Michael 6021 2011-01-28 Dow, Thomas Michael 3655 NW 87th Avenue   Miami FL 33178
1518 1518 1996-01-25 Carnival Cruise Lines 1979-05-14 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
1520 1520 1996-01-25 Commodore Cruise Lines 1992-09-10 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Coral Gables     FL  
2491 2491 1994-02-14 Dolphin Cruise Lines 1992-09-10 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
6780 6780 1994-05-24 Fantasy Cruises 1993-08-23 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
10217 10217 1998-08-08 Florida International Bankers Association 1991-12-19 INTERNATIONAL Holland & Knight 3718 1985-08-07 Holland & Knight Miami     FL  
14119 14119 1990-11-21 Gotaas Larsen, Inc. (Eastern Steamship Lines) 1978-03-09 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
14122 14122 1990-11-21 Scandinavian World Cruises 1982-03-04 INTERNATIONAL International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines Miami     FL  
360 360   Israel Ministry of Foreign Affairs 2019-01-09 ISRAEL Holland & Knight 3718 1985-08-07 Holland & Knight Consulate General of Israel 100 Biscayne Blvd. Miami FL 33132
1843 1843 2003-01-31 Air Jamaica Limited 2002-05-10 JAMAICA Jensen/Boga Inc. 5495 2002-05-10 Jensen/Boga Inc. 9200 South Dadeland Boulevard Miami 33156     FL  
15496 15496 1992-12-30 Jamaica Vacations, Ltd. 1990-05-31 JAMAICA Peter Martin Associates, Inc. 4236 1989-04-05 Peter Martin Associates, Inc. Coral Gables     FL  
1622 1622 1952-01-30 Pedro Martinez 1947-01-31 MEXICO Junta de Cultura Espanola 273 1944-07-31 Junta de Cultura Espanola Tampa     FL  
14147 14147 1963-11-22 Consulate of Mexico 1961-03-30 MEXICO Fernandez, Carlos B. 1409 1960-11-22 Fernandez, Carlos B. Miami     FL  
14321 14321 1955-11-30 Dr. Carlos Prio Socarras 1955-05-31 MEXICO Ortega Sierra, Luis 892 1955-05-31 Ortega Sierra, Luis Miami     FL  
15130 15130 1984-12-15 Aeromexico 1984-05-25 MEXICO Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. Miami     FL  
4043 4043 1990-03-25 Committee for Free Elections & Democracy in Nicaragua 1989-10-04 NICARAGUA Carmen Group, Inc. 4233 1989-03-20 Carmen Group, Inc. Miami     FL  
5852 5852 1990-04-30 Committee for Free Elections & Democracy in Nicaragua 1989-10-04 NICARAGUA Burgum & Grimm, Ltd. 4301 1989-10-04 Burgum & Grimm, Ltd. Miami     FL  
1190 1190 1991-01-10 Norwegian Caribbean Lines 1985-09-26 NORWAY Alcalde & Fay 3571 1984-03-14 Alcalde & Fay Miami     FL  
1705 1705 1981-01-31 Norwegian Caribbean Lines 1980-04-24 NORWAY T.J. Ross & Associates, Inc. 3102 1980-04-24 T.J. Ross & Associates, Inc. Miami     FL  
2421 2421 1996-02-12 Carnival Corporation 1995-04-14 PANAMA Alcalde & Fay 3571 1984-03-14 Alcalde & Fay Miami     FL  
12455 12455 1990-10-03 ADO-Civilista of Panama 1990-02-27 PANAMA Capital Services of Washington, Inc. 4175 1988-09-13 Capital Services of Washington, Inc. Miami     FL  
13315 13315 1991-10-31 Peru Tourist Office, Inc. (FOPTUR) 1991-07-24 PERU Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Miami     FL  
12146 12146 2003-09-30 ITERA International Energy Corporation 2002-09-16 RUSSIA Solutions North America Incorporated 5517 2002-09-16 Solutions North America Incorporated 10151 Deerwood Park Boulevard Building 100, Suite 410 Jacksonville 32256     FL  
9369 9369 2018-07-19 Tromp, Emsley 2018-04-24 ST. MARTIN Livingston Group, LLC 6344 2016-03-25 Livingston Group, LLC 808 Brickell Key Drive #606   Miami FL 33131
962 962 1996-01-01 Berna Products Corporation 1993-02-16 SWITZERLAND MWW/Strategic Communications, Inc. 4542 1991-07-12 MWW/Strategic Communications, Inc. Coral Gables     FL  
6255 6255 1956-05-02 His Thai Majesty's Consulate 1955-05-02 THAILAND Lockett, Edward B. 888 1955-05-02 Lockett, Edward B. Miami     FL  
12502 12502 1956-10-06 His Thai Majesty's Consulate 1956-04-06 THAILAND Corcoran, Howard F. 940 1956-04-06 Corcoran, Howard F. Miami     FL  
1849 1849 2004-01-31 Antonov Aircraft Corporation 2003-11-24 UKRAINE BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 1100 Lee Wagener Boulevard #208 FLL International Airport Ft. Lauderdale 33315     FL  
720 720   Tribunal Supremo de Justicia de la Republica Bolivariana de Venezuela (TSJ) in exile 2022-08-12 VENEZUELA Bryan Cave Leighton Paisner LLP 7157 2022-08-12 Bryan Cave Leighton Paisner LLP 8300 NW 53rd Street, Suite 350   Doral FL 33166
1875 1875 2009-01-31 Arcaya and Associates 2008-02-11 VENEZUELA Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP 2600 Douglas Road Suite 904 Coral Gables FL 33132
14148 14148 1963-11-22 Consulate of Venezuela 1961-03-30 VENEZUELA Fernandez, Carlos B. 1409 1960-11-22 Fernandez, Carlos B. Miami     FL  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 349.269ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows