FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where "Registrant_Date" is on date 1970-10-30 and State = ""
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date)
Foreign_Principal 24
- AVEBE America, Inc. 1
- Asociacion Nacional de Manufactureros del Cuero 1
- Association of the Chocolate, Biscuit & Confectionery Industry 1
- Austrian Hard Cheese Association 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
- 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
- Evian, S.A. 1
- Federation du Commerce d'Exportation des Vins et Spiritueux 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
Address_1 15 ✖
- - 10
- 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
- Princeton 1
- Rainham 1
- San Salvador 1
- Zoetermeer 1
Country/Location_Represented 11
- DENMARK 5
- AUSTRIA 4
- FRANCE 4
- BELGIUM 3
- NETHERLANDS 2
- COLOMBIA 1
- EL SALVADOR 1
- FINLAND 1
- GREAT BRITAIN 1
- INTERNATIONAL 1
- MEXICO 1
State 1
- - · 24 ✖
Registrant_Name 1
City 1
- - 24
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. | |||||
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 | ||||
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 | ||||
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 | ||||
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]) );