product_id
stringStable Rohlik URL numeric identifier, not a GTIN.
20,091 distinct values, no chart
- Valid
- 20,091 · 100%
- Missing
- 0 · 0%
- Distinct
- 20,091 · 100% of valid
192 MB across 2 parts, newest sealed 22 November 2026 at 07:28 UTC. The first build wrote 2 parts and 20,091 rows.
Stable Rohlik URL numeric identifier, not a GTIN.
20,091 distinct values, no chart
Original target product heading.
19,804 distinct values, no chart
Controlled ingredient identity, cut and form; unknown preserves original title. Does not replace original commercial name.
19,427 distinct values, no chart
Clef controlled product identity; uncertain classifications stay unknown.
food, beverage, non_food or unknown; unknown rows require review.
Explicit meat cut classification, else unknown/not_applicable.
Physical form classification.
Preparation state classification; missing facts are unknown.
Storage state classification from title only.
Lowest confidence among identity and food scope decisions; model probability, not calibrated accuracy.
All raw Clef decisions/probabilities for audit.
20,005 distinct values, no chart
Model actually served by platform.
Controlled ingredient vocabulary version.
Unknown or low-confidence labels remain flagged for review.
Target heading-adjacent quantity text; extraction is conservative and may be missing.
Target product description section from Popis to nutrition/ingredients/footer boundary; layout-sensitive extraction.
19,761 distinct values, no chart
Target ingredients section when recognized; missing means unknown.
16,581 distinct values, no chart
Original allergen and traces section when recognized; absence is never inferred.
Original nutrition section including original basis/units; not normalized numeric facts.
9,047 distinct values, no chart
Original full captured page including unrelated recommendations, retained for extraction audit only.
20,091 distinct values, no chart
Exact captured Rohlik URL.
20,091 distinct values, no chart
UTC acquisition timestamp.
per hour
UTC acquisition date.
per hour
Hash of title used in classifier request.
19,804 distinct values, no chart
Standardized identity and original title for retrieval; excludes recommendations.
19,819 distinct values, no chart
Observed primary product image URL; gallery first image with og:image fallback.
20,091 distinct values, no chart
JSON array of observed product gallery URLs in page order; primary metadata fallback when gallery is absent. Null if no image is observed. More than 20 gallery images refuses verification rather than silently truncating.
20,091 distinct values, no chart
Ordered inferred recipe ingredient candidates; original ingredient/measure, constraints and evidence retained. No quantity conversion, serving normalization, availability or allergy guarantee.
348 distinct values, no chart
Distinct acquired recipes having an ingredient candidate for this product.
Recipe ingredient positions having this product as a candidate; many products may match a position.
Observed recipe/ingredient counts; does not attest acquisition completeness. Includes, classified positions, uncertain positions and matched/unmatched counts; repeated consistently for audit.
1 distinct value, no chart
1 only when every observed nonempty recipe ingredient position has exactly one pinned classifier answer and product classifier models match the same pin.
1 only when all indexed Toprecepty URLs yielded ingredient rows, provider semantic IDs are numeric, every decoded occurrence position(page_ordinal) is positive and unique, and identical classifier inputs have one nonconflicting actual answer. Actual publisher DOM order and every occurrence are preserved; run receipt still governs acquisition completeness.
Unmodified main-product price amount extracted with a product-scoped DOM selector; absent publisher values remain null.
1,476 distinct values, no chart
Unmodified main-product price currency extracted with a product-scoped DOM selector; absent publisher values remain null.
1 distinct value, no chart
Unmodified main-product price display extracted with a product-scoped DOM selector; absent publisher values remain null.
3,062 distinct values, no chart
Unmodified main-product brand extracted with a product-scoped DOM selector; absent publisher values remain null.
3,253 distinct values, no chart
Unmodified main-product pack extracted with a product-scoped DOM selector; absent publisher values remain null.
980 distinct values, no chart
Unmodified main-product unit price extracted with a product-scoped DOM selector; absent publisher values remain null.
8,476 distinct values, no chart
Unmodified main-product social proof extracted with a product-scoped DOM selector; absent publisher values remain null.
17,711 distinct values, no chart
Unmodified main-product category path extracted with a product-scoped DOM selector; absent publisher values remain null.
1,849 distinct values, no chart
Unmodified main-product country of origin extracted with a product-scoped DOM selector; absent publisher values remain null.
263 distinct values, no chart
Unmodified main-product description extracted with a product-scoped DOM selector; absent publisher values remain null.
19,712 distinct values, no chart
Unmodified main-product shelf life average extracted with a product-scoped DOM selector; absent publisher values remain null.
318 distinct values, no chart
Unmodified main-product shelf life minimal extracted with a product-scoped DOM selector; absent publisher values remain null.
52 distinct values, no chart
Unmodified main-product nutrition extracted with a product-scoped DOM selector; absent publisher values remain null.
9,052 distinct values, no chart
Unmodified main-product nutrition basis extracted with a product-scoped DOM selector; absent publisher values remain null.
5 distinct values, no chart
Unmodified main-product ingredients allergens extracted with a product-scoped DOM selector; absent publisher values remain null.
16,646 distinct values, no chart
Main-product posted price in price_currency at fetched_at. Publisher delivery-area context remains in page_text when present.
Publisher currency code accompanying price_amount.
Main-product publisher brand label.
Publisher country-of-origin text; multiple countries remain text.
Publisher nutrition energy kj per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher calorie amount and kCal unit as displayed, per product_nutrition_basis_raw; no inferred unit or conversion.
875 distinct values, no chart
Publisher nutrition fat g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher nutrition saturated fat g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher nutrition carbohydrate g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher nutrition sugars g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher nutrition protein g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher nutrition salt g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
Publisher nutrition fibre g per the explicitly retained product_nutrition_basis_raw; unparseable or inequality values remain null and raw text is preserved.
One only when at least one main-product price was captured and every displayed main-product price has parsed amount and currency metadata.
1 distinct value, no chart
For non-food products: cleaning, cosmetics, pet, baby, household or other; not_applicable for food/beverage; unknown when Clef confidence < 0.85. From title, Rohlik category path and description.
yes/no only when title, category or description explicitly states it (Clef, confidence >= 0.85); otherwise unknown. Not inferred from general food knowledge.
yes/no only when explicitly stated (Clef, confidence >= 0.85); otherwise unknown.
yes/no only when explicitly stated (bez lepku / bezlepkove; Clef, confidence >= 0.85); otherwise unknown.
yes/no only when explicitly stated (bez laktozy; Clef, confidence >= 0.85); otherwise unknown.
yes/no only when BIO/organic is explicitly stated (Clef, confidence >= 0.85); otherwise unknown.
food_or_beverage, non_food or unknown (food_scope confidence < 0.85).
Publisher 'Alergeny' subsection text verbatim; null when the page has none. Absence is never inferred.
EU-14 allergen keys the publisher lists as contained (before 'Může obsahovat'); null when no allergen subsection.
265 distinct values, no chart
EU-14 allergen keys the publisher lists as possible traces ('Může obsahovat stopy'); null when no allergen subsection.
448 distinct values, no chart
Total pack size normalized to g or ml (multipacks multiplied); null for piece counts and other units.
g or ml for pack_size_amount; null when not normalizable.
price_amount divided by pack size, per kg or per litre (see price_per_unit_basis); null when pack size not normalizable.
CZK/kg or CZK/l for price_per_kg_or_l.
Profile of the served version, all rows, computed 22 Nov 2026, 07:40 UTC
| Warning | Freshness | Latest event 17 d before this version |
|---|---|---|
| Passed | Gaps | No empty days |
| Passed | Anomalies | No spikes or dips |
| Passed | Unique keys | Every product_id is unique |
| Passed | Change since last profile | No change, 20,091 rows |