Index | Column Heading | Required | Unique | Type | Value Constraints | Title/Description |
---|---|---|---|---|---|---|
1 |
code
|
Yes | No | String |
Pattern: |
Barcode |
2 |
producter_product_id
|
Yes | No | String |
Pattern: |
|
3 |
producer_version_id
|
Yes | No | String |
|
|
4 |
lang
|
Yes | No | String |
Main language in which the product is described |
|
5 |
countries
|
Yes | No | String |
Pattern: |
Countries where the product is sold The countries where the product is sold, in the language corresponding to the "lang" field |
6 |
product_name_de
|
Yes | No | String |
Pattern: |
German name of the product German name of the product, given by the vendor |
7 |
product_name_fr
|
Yes | No | String |
Pattern: |
French name of the product French name of the product, given by the vendor |
8 |
generic_name_de
|
Yes | No | String |
Pattern: |
Generic german name of the product Usual german name of the product |
9 |
generic_name_fr
|
Yes | No | String |
Pattern: |
Generic french name of the product Usual french name of the product |
10 |
brands
|
Yes | No | String |
Pattern: |
Brands of the product Brands of the product |
11 |
quantity
|
Yes | No | String |
Pattern: |
Quantity of the product Quantity of the product; number of pieces, weight |
12 |
net_weight
|
Yes | No | String |
Pattern: |
Net weight Net weight, in grammes |
13 |
drained_weight
|
Yes | No | String |
Pattern: |
Drained weight Drained weight, in grammes |
14 |
volume
|
Yes | No | String |
Pattern: |
Volume Volume |
15 |
categories
|
Yes | No | String |
Pattern: |
Categories Categories |
16 |
ingredients_text_de
|
Yes | No | String |
Pattern: |
ingredients_text_de ingredients_text_de |
17 |
ingredients_text_fr
|
Yes | No | String |
Pattern: |
ingredients_text_fr ingredients_text_fr |
18 |
allergens
|
Yes | No | String |
Pattern: |
Allergens Allergens |
19 |
traces
|
Yes | No | String |
Pattern: |
Traces Traces |
20 |
labels
|
Yes | No | String |
Pattern: |
Labels Labels |
21 |
packaging
|
Yes | No | String |
Pattern: |
Packaging Packaging |
22 |
origins
|
Yes | No | String |
Pattern: |
Origins Origins |
23 |
origin
|
Yes | No | String |
Pattern: |
Origin Origin |
24 |
producer
|
Yes | No | String |
Pattern: |
Producer Producer |
25 |
manufacturing_places
|
Yes | No | String |
Pattern: |
Manufacturing places Manufacturing places |
26 |
emb_codes
|
Yes | No | String |
Pattern: |
emb_codes emb_codes |
27 |
stores
|
Yes | No | String |
Pattern: |
Stores Store |
28 |
other_information
|
Yes | No | String |
Pattern: |
Other information Other information |
29 |
conservation_conditions
|
Yes | No | String |
Pattern: |
conservation_conditions conservation_conditions |
30 |
recycling_instructions_to_recycle
|
Yes | No | String |
Pattern: |
recycling_instructions_to_recycle recycling_instructions_to_recycle |
31 |
recycling_instructions_to_discard
|
Yes | No | String |
Pattern: |
recycling_instructions_to_discard recycling_instructions_to_discard |
32 |
recipe_idea
|
Yes | No | String |
Pattern: |
recipe_idea recipe_idea |
33 |
customer_service
|
Yes | No | String |
Pattern: |
customer_service customer_service |
34 |
preparation
|
Yes | No | String |
Pattern: |
preparation preparation |
35 |
warning
|
Yes | No | String |
Pattern: |
warning warning |
36 |
link
|
Yes | No | String |
Pattern: |
link link |
37 |
nutriscore
|
Yes | No | String |
Pattern: |
nutriscore nutriscore |
38 |
serving_size
|
Yes | No | String |
Pattern: |
serving_size serving_size |
39 |
energy_100g
|
Yes | No | String |
Pattern: |
energy_100g energy_100g |
40 |
fat_100g
|
Yes | No | String |
Pattern: |
fat_100g fat_100g |
41 |
saturated-fat_100g
|
Yes | No | String |
Pattern: |
saturated-fat_100g saturated-fat_100g |
42 |
carbohydrates_100g
|
Yes | No | String |
Pattern: |
carbohydrates_100g carbohydrates_100g |
43 |
sugars_100g
|
Yes | No | String |
Pattern: |
sugars_100g sugars_100g |
44 |
proteins_100g
|
Yes | No | String |
Pattern: |
proteins_100g proteins_100g |
45 |
salt_100g
|
Yes | No | String |
Pattern: |
salt_100g salt_100g |
46 |
fiber_100g
|
Yes | No | String |
Pattern: |
fiber_100g fiber_100g |
47 |
fruits-vegetables-nuts_100g
|
Yes | No | String |
Pattern: |
fruits-vegetables-nuts_100g fruits-vegetables-nuts_100g |
48 |
fruits-vegetables-nuts-dried_100g
|
Yes | No | String |
Pattern: |
fruits-vegetables-nuts-dried_100g fruits-vegetables-nuts-dried_100g |
49 |
energy-from-fat_100g
|
Yes | No | String |
Pattern: |
energy-from-fat_100g energy-from-fat_100g |
50 |
butyric-acid_100g
|
Yes | No | String |
Pattern: |
butyric-acid_100g butyric-acid_100g |
51 |
caproic-acid_100g
|
Yes | No | String |
Pattern: |
caproic-acid_100g caproic-acid_100g |
52 |
caprylic-acid_100g
|
Yes | No | String |
Pattern: |
caprylic-acid_100g caprylic-acid_100g |
53 |
capric-acid_100g
|
Yes | No | String |
Pattern: |
capric-acid_100g capric-acid_100g |
54 |
lauric-acid_100g
|
Yes | No | String |
Pattern: |
lauric-acid_100g lauric-acid_100g |
55 |
myristic-acid_100g
|
Yes | No | String |
Pattern: |
myristic-acid_100g myristic-acid_100g |
56 |
palmitic-acid_100g
|
Yes | No | String |
Pattern: |
palmitic-acid_100g palmitic-acid_100g |
57 |
stearic-acid_100g
|
Yes | No | String |
Pattern: |
stearic-acid_100g stearic-acid_100g |
58 |
arachidic-acid_100g
|
Yes | No | String |
Pattern: |
arachidic-acid_100g arachidic-acid_100g |
59 |
behenic-acid_100g
|
Yes | No | String |
Pattern: |
behenic-acid_100g behenic-acid_100g |
60 |
lignoceric-acid_100g
|
Yes | No | String |
Pattern: |
lignoceric-acid_100g lignoceric-acid_100g |
61 |
cerotic-acid_100g
|
Yes | No | String |
Pattern: |
cerotic-acid_100g cerotic-acid_100g |
62 |
montanic-acid_100g
|
Yes | No | String |
Pattern: |
montanic-acid_100g montanic-acid_100g |
63 |
melissic-acid_100g
|
Yes | No | String |
Pattern: |
melissic-acid_100g melissic-acid_100g |
64 |
monounsaturated-fat_100g
|
Yes | No | String |
Pattern: |
monounsaturated-fat_100g monounsaturated-fat_100g |
65 |
polyunsaturated-fat_100g
|
Yes | No | String |
Pattern: |
polyunsaturated-fat_100g polyunsaturated-fat_100g |
66 |
omega-3-fat_100g
|
Yes | No | String |
Pattern: |
omega-3-fat_100g omega-3-fat_100g |
67 |
alpha-linolenic-acid_100g
|
Yes | No | String |
Pattern: |
alpha-linolenic-acid_100g alpha-linolenic-acid_100g |
68 |
eicosapentaenoic-acid_100g
|
Yes | No | String |
Pattern: |
eicosapentaenoic-acid_100g eicosapentaenoic-acid_100g |
69 |
docosahexaenoic-acid_100g
|
Yes | No | String |
Pattern: |
docosahexaenoic-acid_100g docosahexaenoic-acid_100g |
70 |
omega-6-fat_100g
|
Yes | No | String |
Pattern: |
omega-6-fat_100g omega-6-fat_100g |
71 |
linoleic-acid_100g
|
Yes | No | String |
Pattern: |
linoleic-acid_100g linoleic-acid_100g |
72 |
arachidonic-acid_100g
|
Yes | No | String |
Pattern: |
arachidonic-acid_100g arachidonic-acid_100g |
73 |
gamma-linolenic-acid_100g
|
Yes | No | String |
Pattern: |
gamma-linolenic-acid_100g gamma-linolenic-acid_100g |
74 |
dihomo-gamma-linolenic-acid_100g
|
Yes | No | String |
Pattern: |
dihomo-gamma-linolenic-acid_100g dihomo-gamma-linolenic-acid_100g |
75 |
omega-9-fat_100g
|
Yes | No | String |
Pattern: |
omega-9-fat_100g omega-9-fat_100g |
76 |
oleic-acid_100g
|
Yes | No | String |
Pattern: |
oleic-acid_100g oleic-acid_100g |
77 |
elaidic-acid_100g
|
Yes | No | String |
Pattern: |
elaidic-acid_100g elaidic-acid_100g |
78 |
gondoic-acid_100g
|
Yes | No | String |
Pattern: |
gondoic-acid_100g gondoic-acid_100g |
79 |
mead-acid_100g
|
Yes | No | String |
Pattern: |
mead-acid_100g mead-acid_100g |
80 |
erucic-acid_100g
|
Yes | No | String |
Pattern: |
erucic-acid_100g erucic-acid_100g |
81 |
nervonic-acid_100g
|
Yes | No | String |
Pattern: |
nervonic-acid_100g nervonic-acid_100g |
82 |
trans-fat_100g
|
Yes | No | String |
Pattern: |
trans-fat_100g trans-fat_100g |
83 |
cholesterol_100g
|
Yes | No | String |
Pattern: |
cholesterol_100g cholesterol_100g |
84 |
sucrose_100g
|
Yes | No | String |
Pattern: |
sucrose_100g sucrose_100g |
85 |
glucose_100g
|
Yes | No | String |
Pattern: |
glucose_100g glucose_100g |
86 |
fructose_100g
|
Yes | No | String |
Pattern: |
fructose_100g fructose_100g |
87 |
lactose_100g
|
Yes | No | String |
Pattern: |
lactose_100g lactose_100g |
88 |
maltose_100g
|
Yes | No | String |
Pattern: |
maltose_100g maltose_100g |
89 |
maltodextrins_100g
|
Yes | No | String |
Pattern: |
maltodextrins_100g maltodextrins_100g |
90 |
starch_100g
|
Yes | No | String |
Pattern: |
starch_100g starch_100g |
91 |
polyols_100g
|
Yes | No | String |
Pattern: |
polyols_100g polyols_100g |
92 |
casein_100g
|
Yes | No | String |
Pattern: |
casein_100g casein_100g |
93 |
serum-proteins_100g
|
Yes | No | String |
Pattern: |
serum-proteins_100g serum-proteins_100g |
94 |
nucleotides_100g
|
Yes | No | String |
Pattern: |
nucleotides_100g nucleotides_100g |
95 |
sodium_100g
|
Yes | No | String |
Pattern: |
sodium_100g sodium_100g |
96 |
alcohol_100g
|
Yes | No | String |
Pattern: |
alcohol_100g alcohol_100g |
97 |
vitamin-a_100g
|
Yes | No | String |
Pattern: |
vitamin-a_100g vitamin-a_100g |
98 |
beta-carotene_100g
|
Yes | No | String |
Pattern: |
beta-carotene_100g beta-carotene_100g |
99 |
vitamin-d_100g
|
Yes | No | String |
Pattern: |
vitamin-d_100g vitamin-d_100g |
100 |
vitamin-e_100g
|
Yes | No | String |
Pattern: |
vitamin-e_100g vitamin-e_100g |
101 |
vitamin-k_100g
|
Yes | No | String |
Pattern: |
vitamin-k_100g vitamin-k_100g |
102 |
vitamin-c_100g
|
Yes | No | String |
Pattern: |
vitamin-c_100g vitamin-c_100g |
103 |
vitamin-b1_100g
|
Yes | No | String |
Pattern: |
vitamin-b1_100g vitamin-b1_100g |
104 |
vitamin-b2_100g
|
Yes | No | String |
Pattern: |
vitamin-b2_100g vitamin-b2_100g |
105 |
vitamin-pp_100g
|
Yes | No | String |
Pattern: |
vitamin-pp_100g vitamin-pp_100g |
106 |
vitamin-b6_100g
|
Yes | No | String |
Pattern: |
vitamin-b6_100g vitamin-b6_100g |
107 |
vitamin-b9_100g
|
Yes | No | String |
Pattern: |
vitamin-b9_100g vitamin-b9_100g |
108 |
folates_100g
|
Yes | No | String |
Pattern: |
folates_100g folates_100g |
109 |
vitamin-b12_100g
|
Yes | No | String |
Pattern: |
vitamin-b12_100g vitamin-b12_100g |
110 |
biotin_100g
|
Yes | No | String |
Pattern: |
biotin_100g biotin_100g |
111 |
pantothenic-acid_100g
|
Yes | No | String |
Pattern: |
pantothenic-acid_100g pantothenic-acid_100g |
112 |
silica_100g
|
Yes | No | String |
Pattern: |
silica_100g silica_100g |
113 |
bicarbonate_100g
|
Yes | No | String |
Pattern: |
bicarbonate_100g bicarbonate_100g |
114 |
potassium_100g
|
Yes | No | String |
Pattern: |
potassium_100g potassium_100g |
115 |
chloride_100g
|
Yes | No | String |
Pattern: |
chloride_100g chloride_100g |
116 |
calcium_100g
|
Yes | No | String |
Pattern: |
calcium_100g calcium_100g |
117 |
phosphorus_100g
|
Yes | No | String |
Pattern: |
phosphorus_100g phosphorus_100g |
118 |
iron_100g
|
Yes | No | String |
Pattern: |
iron_100g iron_100g |
119 |
magnesium_100g
|
Yes | No | String |
Pattern: |
magnesium_100g magnesium_100g |
120 |
zinc_100g
|
Yes | No | String |
Pattern: |
zinc_100g zinc_100g |
121 |
copper_100g
|
Yes | No | String |
Pattern: |
copper_100g copper_100g |
122 |
manganese_100g
|
Yes | No | String |
Pattern: |
manganese_100g manganese_100g |
123 |
fluoride_100g
|
Yes | No | String |
Pattern: |
fluoride_100g fluoride_100g |
124 |
selenium_100g
|
Yes | No | String |
Pattern: |
selenium_100g selenium_100g |
125 |
chromium_100g
|
Yes | No | String |
Pattern: |
chromium_100g chromium_100g |
126 |
molybdenum_100g
|
Yes | No | String |
Pattern: |
molybdenum_100g molybdenum_100g |
127 |
iodine_100g
|
Yes | No | String |
Pattern: |
iodine_100g iodine_100g |
128 |
caffeine_100g
|
Yes | No | String |
Pattern: |
caffeine_100g caffeine_100g |
129 |
taurine_100g
|
Yes | No | String |
Pattern: |
taurine_100g taurine_100g |
130 |
ph_100g
|
Yes | No | String |
Pattern: |
ph_100g ph_100g |
131 |
collagen-meat-protein-ratio_100g
|
Yes | No | String |
Pattern: |
collagen-meat-protein-ratio_100g collagen-meat-protein-ratio_100g |
132 |
cocoa_100g
|
Yes | No | String |
Pattern: |
cocoa_100g cocoa_100g |
133 |
chlorophyl_100g
|
Yes | No | String |
Pattern: |
chlorophyl_100g chlorophyl_100g |
134 |
carbon-footprint_100g
|
Yes | No | String |
Pattern: |
carbon-footprint_100g carbon-footprint_100g |
135 |
glycemic-index_100g
|
Yes | No | String |
Pattern: |
glycemic-index_100g glycemic-index_100g |
136 |
water-hardness_100g
|
Yes | No | String |
Pattern: |
water-hardness_100g water-hardness_100g |
137 |
choline_100g
|
Yes | No | String |
Pattern: |
choline_100g choline_100g |
138 |
phylloquinone_100g
|
Yes | No | String |
Pattern: |
phylloquinone_100g phylloquinone_100g |
139 |
beta-glucan_100g
|
Yes | No | String |
Pattern: |
beta-glucan_100g beta-glucan_100g |
140 |
inositol_100g
|
Yes | No | String |
Pattern: |
inositol_100g inositol_100g |
141 |
carnitine_100g
|
Yes | No | String |
Pattern: |
carnitine_100g carnitine_100g |