FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where "Registrant_Date" is on date 1970-10-30
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 28
- AVEBE America, Inc. 1
- Asociacion Nacional de Manufactureros del Cuero 1
- Association of the Chocolate, Biscuit & Confectionery Industry 1
- Austrian Hard Cheese Association 1
- Austrian Trade Delegate in the U.S. 1
- Biscuit-and Confectionery Industries of the EEC (CAOBISCO) 1
- Biscuit-and Confectionery Industries of the EEC (CAORISCO) 1
- Centraal Bureau van de Tuinbouwveilingen of the Netherlands 1
- Centre National Interprofessional d'Economie Laitiere 1
- Chocolate, Biscuit & Confectionery Industries of the European Community (CAOBISCO) 1
- Comite Economique Agricole Regional Fruits et Legumes de Bretagne 1
- Committee to Assure the Availability of Casein (CAAC) 1
- Constructora Nacional de Carros de Ferrocarril, S.A. 1
- Danish Biscuit Alliance (Kelsen The International Bakery A/S, Ripensa A/S, Intergoods Bakery Ltd. A/S Queens Biscuits A/S 1
- Danish Cake & Biscuit Alliance 1
- Danish Fancy Food Group, A.S. 1
- Danish Meat Association (DMA) 1
- Danish Meat Canners Export Association 1
- Delegation of the Commission of the European Communities 1
- Evian, S.A. 1
- Federation du Commerce d'Exportation des Vins et Spiritueux 1
- Government of Canada 1
- Government of El Salvador 1
- OEHEG 1
- OEHEG-Austrian Hard Cheese Association - OEMOLK-Austrian Soft Cheese Assocation 1
- Oemolk 1
- Tilda Rice 1
- Valio Finnish Co-operative Dairies Association 1
Foreign_Principal_Termination_Date 21 ✖
- 1986-11-14 3
- 1993-06-02 3
- 1977-12-31 2
- 1982-05-17 2
- 1987-01-30 2
- 1974-08-22 1
- 1978-08-24 1
- 1979-03-31 1
- 1979-06-15 1
- 1982-01-01 1
- 1989-09-19 1
- 1990-12-18 1
- 1991-05-01 1
- 1992-11-30 1
- 1993-11-24 1
- 1994-06-07 1
- 1997-01-31 1
- 1998-04-29 1
- 2003-06-01 1
- 2007-04-30 1
- 2010-12-31 1
Address_1 18 ✖
- - 10
- Washington 2
- 3213 O Street, N.W. 20007 1
- Bogota 1
- Bredgade 27, Postboks 125 1
- Brussels 1
- Brussels, Belgium 1
- Bruxelles 1
- Copenhagen Z 1
- Elsinore 1
- Evian 1
- Innsbruck 1
- Morlaix 1
- New York 1
- Princeton 1
- Rainham 1
- San Salvador 1
- Zoetermeer 1
Country/Location_Represented 12
- AUSTRIA 5
- DENMARK 5
- BELGIUM 4
- FRANCE 4
- INTERNATIONAL 2
- NETHERLANDS 2
- CANADA 1
- COLOMBIA 1
- EL SALVADOR 1
- FINLAND 1
- GREAT BRITAIN 1
- MEXICO 1
Registrant_Name 1
City 1
- - 28
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
844 | 844 | 1982-01-01 | Constructora Nacional de Carros de Ferrocarril, S.A. | 1978-08-29 | MEXICO | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
1635 | 1635 | 1987-01-30 | Austrian Hard Cheese Association | 1980-06-03 | AUSTRIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
1638 | 1638 | 1987-01-30 | OEHEG-Austrian Hard Cheese Association - OEMOLK-Austrian Soft Cheese Assocation | 1979-07-24 | AUSTRIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Innsbruck | ||||
1810 | 1810 | 1997-01-31 | Tilda Rice | 1995-11-27 | GREAT BRITAIN | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Rainham | ||||
4370 | 4370 | 1979-03-31 | Danish Fancy Food Group, A.S. | 1978-09-12 | DENMARK | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
5760 | 5760 | 1998-04-29 | Danish Biscuit Alliance (Kelsen The International Bakery A/S, Ripensa A/S, Intergoods Bakery Ltd. A/S Queens Biscuits A/S | 1998-03-10 | DENMARK | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Bredgade 27, Postboks 125 | ||||
6032 | 6032 | 2007-04-30 | Centre National Interprofessional d'Economie Laitiere | 1980-06-03 | FRANCE | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
6209 | 6209 | 1991-05-01 | Government of Canada | 1989-12-04 | CANADA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Washington | DC | |||
6625 | 6625 | 1982-05-17 | Danish Cake & Biscuit Alliance | 1977-12-01 | DENMARK | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Elsinore | ||||
6626 | 6626 | 1982-05-17 | Danish Meat Canners Export Association | 1982-07-14 | DENMARK | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Copenhagen Z | ||||
7437 | 7437 | 2003-06-01 | Committee to Assure the Availability of Casein (CAAC) | 2001-08-16 | INTERNATIONAL | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | 3213 O Street, N.W. 20007 | DC | |||
7492 | 7492 | 1993-06-02 | Centraal Bureau van de Tuinbouwveilingen of the Netherlands | 1992-07-09 | NETHERLANDS | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Zoetermeer | ||||
7493 | 7493 | 1993-06-02 | Chocolate, Biscuit & Confectionery Industries of the European Community (CAOBISCO) | 1992-07-09 | INTERNATIONAL | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Brussels | ||||
7500 | 7500 | 1993-06-02 | Valio Finnish Co-operative Dairies Association | 1980-06-03 | FINLAND | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
7653 | 7653 | 1994-06-07 | Federation du Commerce d'Exportation des Vins et Spiritueux | 1985-06-07 | FRANCE | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
7818 | 7818 | 1979-06-15 | Government of El Salvador | 1979-03-15 | EL SALVADOR | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | San Salvador | ||||
10657 | 10657 | 1974-08-22 | Austrian Trade Delegate in the U.S. | 1970-10-30 | AUSTRIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | New York | NY | |||
10705 | 10705 | 1978-08-24 | Asociacion Nacional de Manufactureros del Cuero | 1977-12-01 | COLOMBIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Bogota | ||||
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 | |||
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. | |||||
14219 | 14219 | 1993-11-24 | Comite Economique Agricole Regional Fruits et Legumes de Bretagne | 1988-12-06 | FRANCE | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Morlaix | ||||
14435 | 14435 | 1992-11-30 | Evian, S.A. | 1988-12-06 | FRANCE | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Evian | ||||
15210 | 15210 | 1990-12-18 | AVEBE America, Inc. | 1990-12-06 | NETHERLANDS | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Princeton | ||||
15792 | 15792 | 1977-12-31 | OEHEG | 1974-01-09 | AUSTRIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
15793 | 15793 | 1977-12-31 | Oemolk | 1974-03-07 | AUSTRIA | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | |||||
16677 | 16677 | 2010-12-31 | Danish Meat Association (DMA) | 1997-05-28 | DENMARK | Berry, Max N. 2216 | 1970-10-30 | Berry, Max N. | Bruxelles |
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]) );