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

98 rows where Country/Location_Represented = "BELGIUM" sorted by City

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

Registrant_Name >30

  • Belgo-American Development Corporation 18
  • Berry, Max N. 4
  • Daniels, Houlihan & Palmeter 4
  • European Community Information Service 3
  • Modern Education Services, Inc. 3
  • Cleary, Gottlieb, Steen & Hamilton, LLP 2
  • Development Counsellors International 2
  • Hill and Knowlton Strategies, LLC 2
  • Newman & Holtzinger, P.C. 2
  • Richard Weiner, Inc. 2
  • Ruder Finn, Inc. 2
  • Seyfarth, Shaw, Fairweather & Geraldson 2
  • Squire, Sanders & Dempsey, L.L.P. 2
  • APCO Worldwide LLC 1
  • Al Paul Lefton Company, Inc. 1
  • Arnold & Porter Kaye Scholer LLP 1
  • Arter & Hadden 1
  • Association Films, Inc. 1
  • Belgian Chamber of Commerce in the U.S., Inc. 1
  • Belgian Government Information Center 1
  • Belgian Industrial Information Service 1
  • Belgian National Tourist Office 1
  • Cohen & Aleshire, Inc. 1
  • Collier Shannon Scott, PLLC 1
  • Communications Counselors, Inc. 1
  • Cox, Oscar S. 1
  • Culbertson, William S. 1
  • Daniel J. Edelman, Inc. 1
  • De Give, Henry L. 1
  • Dewey, Ballantine, Bushby, Palmer & Wood 1
  • …

Foreign_Principal >30

  • Belgian National Tourist Office 4
  • Belgian Government 2
  • Belgian Tourist Office 2
  • Commission of the European Communities 2
  • EUROFER 2
  • Embassy of Belgium 2
  • European Atomic Energy Community (EURATOM) 2
  • The Centre for a European Future 2
  • Albrecht, Jan Phillipp 1
  • Association des Amidonneries de Cereals de L.U.E. 1
  • Association of Plastics Manufacturers of Europe 1
  • Association of the Chocolate, Biscuit & Confectionery Industry 1
  • Banque Belge pur l'Etranger, S.A. 1
  • Belgian Embassy 1
  • Belgian Endive Marketing Board 1
  • Belgian Government Information Center 1
  • Belgian Information Center 1
  • Belgian Information Service 1
  • Belgian Ministry of Agriculture, Economical Services 1
  • Belgian Nuclear Research Centre (C.E.N./S.C.K.) 1
  • Belgium Endive Marketing Board 1
  • Belgonucleaire, S.A. 1
  • Biscuit-and Confectionery Industries of the EEC (CAOBISCO) 1
  • Biscuit-and Confectionery Industries of the EEC (CAORISCO) 1
  • Boelwerf Shipyard 1
  • Cerestar 1
  • Cimenteries et Briqueteries Reunies, S.A. 1
  • Commission of the European Atomic Energy Community 1
  • Commission of the European Economic Community 1
  • Compagnie Martitime Belga 1
  • …

City 5

  • - 89
  • Brussels 6
  • Brussels 1
  • Brussels 1
  • Washington 1

State 4

  • - 85
  • NY 7
  • DC 5
  • CA 1

Country/Location_Represented 1

  • BELGIUM · 98 ✖
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
9 9   European People's Party 2019-01-28 BELGIUM Shepura, Nathan 6630 2019-01-28 Shepura, Nathan 10 Rue de Commerce Brussels 1000      
984 984 1999-01-01 Region of Brussels - Capital 1998-11-17 BELGIUM Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Brussels        
1981 1981 1972-02-01 European Atomic Energy Community (EURATOM) 1964-01-20 BELGIUM Edlow International Company 1683 1964-01-20 Edlow International Company Brussels        
2098 2098 1968-02-02 European Atomic Energy Commission 1959-11-10 BELGIUM Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP Brussels        
2099 2099 1968-02-02 European Economic Commission 1959-03-23 BELGIUM Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP Brussels        
2602 2602 1995-02-16 Techspace Aero, S.A. (Formerly: FN Moteurs, a Division of Fabrique Nationale Herstal, S.A.) 1982-03-15 BELGIUM Seyfarth, Shaw, Fairweather & Geraldson 3122 1980-07-18 Seyfarth, Shaw, Fairweather & Geraldson Herstal        
2617 2617 1987-02-17 Boelwerf Shipyard 1983-03-30 BELGIUM Program Planning Services, Inc. 3454 1983-03-30 Program Planning Services, Inc. Temse        
2854 2854 1965-02-26 Ministere des Affaires Etrangeres et du Commerce Exterieur 1960-06-13 BELGIUM Belgian Industrial Information Service 1370 1960-06-13 Belgian Industrial Information Service Bruxelles        
2879 2879 1981-02-27 Ets. Beherman Demoen, N.V./S.A., Engineering 1980-02-15 BELGIUM Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP Bornem        
2966 2966 1991-02-28 Commission of the European Communities 1990-06-08 BELGIUM Verstandig & Associates, Inc. 4383 1990-06-08 Verstandig & Associates, Inc. Brussels        
3028 3028 1999-02-28 Fabrique Nationale Herstal (formerly: Fabrique Nationale Nouvelle Herstal, S.A.) 1993-08-18 BELGIUM FN Manufacturing, Inc. 4864 1993-08-18 FN Manufacturing, Inc. Herstal        
3419 3419 1969-03-04 Compagnie des Metaux d'Overpelt-Lommel et de Corphalie 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3420 3420 1969-03-04 Compagnie du Congo Pour le Commerce et l'Industrie 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3421 3421 1969-03-04 Societe d'Entreprise et d'Investissements du Beceka (Sibeka) 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3422 3422 1969-03-04 Societe de Traction et d'Electricite 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3423 3423 1969-03-04 Cimenteries et Briqueteries Reunies, S.A. 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3424 3424 1969-03-04 Compagnie Martitime Belga 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3425 3425 1969-03-04 Compagnie du Katanga 1964-01-20 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3426 3426 1969-03-04 Forges, Fonderies & Usines de la Providence 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3427 3427 1969-03-04 La Brugeoise & Nivelles, S.A. 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3428 3428 1969-03-04 Papeteries de Belgique, S.A. 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3429 3429 1969-03-04 Poudreries Reunies de Belgique 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3430 3430 1969-03-04 SOPARCO 1961-12-18 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3431 3431 1969-03-04 Societe Carbochimique 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3432 3432 1969-03-04 Societe Generale Metallurgique de Hoboken 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3433 3433 1969-03-04 Societe Generale de Belgique, S.A. 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3434 3434 1969-03-04 Societe Generale des Minerals 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3435 3435 1969-03-04 Societe des Mines et Fonderies de Zinc de la Vieille-Montagne 1963-12-16 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3436 3436 1969-03-04 Union Miniere du Haut-Katanga 1964-07-17 BELGIUM Belgo-American Development Corporation 1501 1961-12-18 Belgo-American Development Corporation Brussels        
3487 3487 1997-03-06 European Electronic Component Manufacturers' Association 1992-05-27 BELGIUM Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC Bruxelles        
3673 3673 1993-03-12 Region of Wallonia 1987-11-17 BELGIUM J. Woodman Associates, Inc. 3590 1984-05-31 J. Woodman Associates, Inc.          
3935 3935 1994-03-21 Belgian Nuclear Research Centre (C.E.N./S.C.K.) 1993-01-13 BELGIUM Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge Boeretang        
4065 4065 1986-03-26 Union des Industries de la Communaute Europeenne 1977-03-02 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
4300 4300 1959-03-31 Belgian Government 1957-02-04 BELGIUM Communications Counselors, Inc. 996 1957-02-04 Communications Counselors, Inc. New York     NY  
4524 4524 1993-03-31 Belgonucleaire, S.A. 1980-07-14 BELGIUM Newman & Holtzinger, P.C. 2895 1978-05-04 Newman & Holtzinger, P.C. Brussels        
4530 4530 1993-03-31 Synatom, Societe Anonyme 1978-05-04 BELGIUM Newman & Holtzinger, P.C. 2895 1978-05-04 Newman & Holtzinger, P.C. Brussels        
5031 5031 1973-04-05 Official Belgian Tourist Bureau 1963-03-11 BELGIUM Picard Advertising, Inc. 1606 1963-03-11 Picard Advertising, Inc.          
5078 5078 1982-04-07 North Atlantic Treaty Organization (NATO) 1972-05-09 BELGIUM Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
5226 5226 1993-04-12 Conseil Europeen des Federations de L'Industrie Chimique 1987-10-07 BELGIUM O'Melveny & Myers 3346 1982-03-12 O'Melveny & Myers Brussels        
5358 5358 1996-04-17 Cerestar 1995-12-04 BELGIUM Tutwiler, M. Ann 5083 1995-12-04 Tutwiler, M. Ann Brussels        
5380 5380 1986-04-18 Joint Venture, S.A., Entreprises Jan de Nul & Dragomar, S.p.A. 1980-07-18 BELGIUM Seyfarth, Shaw, Fairweather & Geraldson 3122 1980-07-18 Seyfarth, Shaw, Fairweather & Geraldson Aalst        
5642 5642 1976-04-28 Banque Belge pur l'Etranger, S.A. 1973-03-14 BELGIUM Dewey, Ballantine, Bushby, Palmer & Wood 2412 1973-03-14 Dewey, Ballantine, Bushby, Palmer & Wood Brussels        
6338 6338 1993-05-05 Belgian Tourist Office 1992-06-02 BELGIUM Al Paul Lefton Company, Inc. 4678 1992-06-02 Al Paul Lefton Company, Inc. New York     NY  
6941 6941 1985-05-30 Traditional Belgian Brewers Market 1985-05-30 BELGIUM Public Relations Services, Inc. 3685 1985-05-30 Public Relations Services, Inc.          
7183 7183 2001-05-31 Association des Amidonneries de Cereals de L.U.E. 1998-03-25 BELGIUM O'Mara, Charles J. 5181 1997-05-30 O'Mara, Charles J. BRUSSELS        
7364 7364 1977-06-01 Confederation of Europeenne de L'Industrie de la Chaussure (European Confederation of the Footwear Industry) 1976-05-11 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
7514 7514 1960-06-03 European Travel Commission Commissionariat General au Tourisme Care Centrale, Rue de l'Imperatrice 1959-12-03 BELGIUM Cohen & Aleshire, Inc. 1302 1959-12-03 Cohen & Aleshire, Inc. Brussels        
7529 7529 1971-06-03 Government of the Kingdom of Belgium 1968-01-10 BELGIUM Squire, Sanders & Dempsey, L.L.P. 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Brussels        
7537 7537 1986-06-03 Association of Plastics Manufacturers of Europe 1984-10-30 BELGIUM Hochschewender, Karl A. 3625 1984-10-30 Hochschewender, Karl A. Brussels        
7696 7696 1969-06-09 Kingdom of Belgium, Ministry for Foreign Trade (Ministere du Commerce Exterieur) 1954-07-06 BELGIUM Belgian Chamber of Commerce in the U.S., Inc. 835 1954-07-06 Belgian Chamber of Commerce in the U.S., Inc. Brussels        
7839 7839 1993-06-15 European Roundtable of Industrialists 1992-04-28 BELGIUM Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Brussels        
8062 8062 1987-06-24 Belgian Endive Marketing Board 1986-06-24 BELGIUM Kassinger, Theodore W. 3846 1986-06-24 Kassinger, Theodore W.       NY  
8227 8227 1957-06-30 Belgian Government Information Center 1950-09-25 BELGIUM Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
8280 8280 1970-06-30 Belgian Information Service 1967-09-19 BELGIUM Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
8285 8285 1972-06-30 Belgian Ministry of Agriculture, Economical Services 1967-05-16 BELGIUM Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
8477 8477 1991-06-30 DAF 1990-06-29 BELGIUM Hand, Arendall, Bedsole, Greaves & Johnson 4396 1990-06-29 Hand, Arendall, Bedsole, Greaves & Johnson Brussels        
8515 8515 1994-06-30 Belgian Tourist Office 1993-08-30 BELGIUM West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
8860 8860 1984-07-01 Rene Piot 1983-09-21 BELGIUM Richard Weiner, Inc. 3302 1981-11-13 Richard Weiner, Inc.          
9556 9556 1952-07-28 Government of Belgium 1948-08-23 BELGIUM Cox, Oscar S. 341 1946-01-28 Cox, Oscar S. Washington     DC  
9829 9829 2000-07-31 Flanders' Foreign Investment Office 1998-10-26 BELGIUM Oliver A. Dulle, Jr. & Company, Inc. 4739 1992-12-17 Oliver A. Dulle, Jr. & Company, Inc. Brussels        
10841 10841 1985-08-30 Gicom Puba 1985-08-06 BELGIUM Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Antwerpen        
11041 11041 1996-08-31 Fabrique Nationale Nouvelle Herstal, S.A. 1994-02-28 BELGIUM Marvin Leath Associates 4895 1994-02-28 Marvin Leath Associates Herstal        
11045 11045 1997-08-31 Flanders' Foreign Investment Office, Government of Flanders 1997-12-24 BELGIUM Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Brussels        
11462 11462 1977-09-09 Syndicat d'Etude de l'Industrie Atomique 1969-11-10 BELGIUM LeBoeuf, Lamb, Leiby & MacRae 2169 1969-11-10 LeBoeuf, Lamb, Leiby & MacRae          
11679 11679 1959-09-17 Kingdom of Belgium 1951-12-26 BELGIUM De Give, Henry L. 700 1951-12-26 De Give, Henry L. Brussels        
11714 11714 1989-09-19 Delegation of the Commission of the European Communities 1989-05-30 BELGIUM Berry, Max N. 2216 1970-10-30 Berry, Max N. Washington     DC  
12055 12055 1994-09-30 EUROFER 1994-08-02 BELGIUM Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Bruxelles        
13040 13040 1967-10-26 European Atomic Energy Community (EURATOM) 1959-06-26 BELGIUM Julius Klein Public Relations 975 1956-09-07 Julius Klein Public Relations Brussels        
13087 13087 1947-10-28 Belgian Embassy 1947-01-10 BELGIUM Culbertson, William S. 421 1947-01-10 Culbertson, William S. Washington     DC  
13940 13940 1986-11-14 Association of the Chocolate, Biscuit & Confectionery Industry 1980-06-03 BELGIUM Berry, Max N. 2216 1970-10-30 Berry, Max N.          
13941 13941 1986-11-14 Biscuit-and Confectionery Industries of the EEC (CAOBISCO) 1985-11-20 BELGIUM Berry, Max N. 2216 1970-10-30 Berry, Max N. Brussels, Belgium        
13942 13942 1986-11-14 Biscuit-and Confectionery Industries of the EEC (CAORISCO) 1985-11-20 BELGIUM Berry, Max N. 2216 1970-10-30 Berry, Max N.          
14242 14242 1969-11-25 Belgian Government 1946-12-02 BELGIUM Belgian Government Information Center 405 1946-12-02 Belgian Government Information Center Brussels        
14367 14367 1985-11-30 Sugar and Alcohol Institute (IAA) 1985-05-29 BELGIUM Arter & Hadden 3686 1985-06-03 Arter & Hadden          
14641 14641 1973-12-01 ORGALIME (Organisme de Liaison des Industries Metalliques Europennes) 1973-09-10 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
14757 14757 1997-12-02 Embassy of Belgium 1952-12-05 BELGIUM Squire, Sanders & Dempsey, L.L.P. 746 1952-12-02 Squire, Sanders & Dempsey, L.L.P. Washington     DC  
14814 14814 1972-12-05 Commission of the European Atomic Energy Community 1958-10-08 BELGIUM European Community Information Service 933 1956-03-12 European Community Information Service Brussels        
14815 14815 1972-12-05 Commission of the European Communities 1967-09-28 BELGIUM European Community Information Service 933 1956-03-12 European Community Information Service Brussels        
14816 14816 1972-12-05 Commission of the European Economic Community 1960-07-25 BELGIUM European Community Information Service 933 1956-03-12 European Community Information Service Brussels        
15003 15003 1950-12-11 Belgian Information Center 1942-07-08 BELGIUM Gotham Advertising Company 17 1942-07-08 Gotham Advertising Company          
15073 15073 1993-12-13 European Community (Gerrit Jeelof and Gianfranco Figini) 1991-11-08 BELGIUM European-American Chamber of Commerce in Washington, DC, Inc 4599 1991-11-08 European-American Chamber of Commerce in Washington, DC, Inc Brussels        
15118 15118 1950-12-15 Consul General of Belgium (Francis G. Lockem) 1950-11-01 BELGIUM Latta & Company 647 1950-11-01 Latta & Company San Francisco     CA  
15294 15294 1984-12-21 Belgium Endive Marketing Board 1981-11-13 BELGIUM Richard Weiner, Inc. 3302 1981-11-13 Richard Weiner, Inc.          
15682 15682 1971-12-31 ORGALIME (Organisme de Liaison des Industries Metalliques Europeennes) 1971-10-08 BELGIUM Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Brussels        
15817 15817 1979-12-31 Belgian National Tourist Office 1974-02-23 BELGIUM Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. Brussels        
15830 15830 1980-12-31 Belgian National Tourist Office 1979-03-26 BELGIUM Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
16098 16098 1989-12-31 Belgian National Tourist Office 1980-12-19 BELGIUM Jordan, McGrath, Case & Taylor, Inc. 3182 1980-12-19 Jordan, McGrath, Case & Taylor, Inc. New York     NY  
16313 16313 1995-12-31 EUROFER 1991-01-30 BELGIUM International Advisory Services Group, Ltd. 4267 1989-06-23 International Advisory Services Group, Ltd. Brussels        
16533 16533 2003-12-31 Flanders Foreign Investment Office 2000-05-09 BELGIUM Development Counsellors International 4777 1993-03-12 Development Counsellors International G. Vander Lindenstaat 9 3000 Leuven        
251 251   Flanders Tourism Board 2007-11-15 BELGIUM Tourist Office for Flanders, Belgium - New York Office 5840 2007-11-15 Tourist Office for Flanders, Belgium - New York Office Grasmarkt 61, B-1000   Brussels    
685 685   The Centre for a European Future 2023-03-20 BELGIUM Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Rue des POISSONNIERS 13   Brussels    
769 769   visit.brussels 2022-05-09 BELGIUM Development Counsellors International 4777 1993-03-12 Development Counsellors International Rue Royale 2-4 Koningsstraat   Brussels    
6594 6594 2022-05-15 DIGITALEUROPE 2022-04-25 BELGIUM Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Rue de la Science, 14 B-1040 Brussels    
7901 7901 2011-06-17 Albrecht, Jan Phillipp 2010-11-12 BELGIUM Ngo, Melissa 6006 2010-11-12 Ngo, Melissa ASP 08 H 246 Rue Wiertz 60 Brussels    
16775 16775 2016-12-31 Belgian National Tourist Office 1948-06-17 BELGIUM Belgian National Tourist Office 529 1948-06-17 Belgian National Tourist Office Grasmark 30   Brussels    
684 684   The Centre for a European Future 2023-03-07 BELGIUM APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC Rue des Poissonniers 13   Brussels    
544 544   Open Dialogue Foundation 2023-03-20 BELGIUM Open Dialogue Foundation, Inc. 7246 2023-03-20 Open Dialogue Foundation, Inc. Rond-point Schuman 6/5   Brussels    
9368 9368 2014-07-19 Embassy of Belgium 2014-07-19 BELGIUM IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 3330 Garfield Street, NW   Washington DC 20008

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 331.256ms · 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