{"topic_id":"EFSA_OpenFoodTox_3_sheet_inventory_completion","category":"efsa","context":"---\ntopic_id: EFSA_OpenFoodTox_3_sheet_inventory_completion\ncategory: efsa\ntitle: EFSA OpenFoodTox 3.0 — Complete 17-sheet inventory with Pet Food relevance classification\nlang: en\nsource: OpenFoodTox 3.0 (Zenodo 19388272), full sheet inventory\ndate_parsed: 2026-07-20\ntokens_estimated: 720\n---\n\nOpenFoodTox 3.0 ships as **17 worksheets** in one\nXLSX. Each sheet is a different entity bucket within\nthe EFSA knowledge graph. **Pet food relevance\nvaries** — for a project focused on pet food and feed\nadditives, certain sheets are gold mines while others\ncontain only pesticide-REACH compliance data.\n\nThis topic lists all 17 sheets with size, primary\ncontent, and pet food utility assessment.\n\n## Sheet inventory (17 sheets)\n\n| # | Sheet name | Rows | Pet food relevance | Status |\n|---|------------|-----:|--------------------|--------|\n| 1 | REF_SUB | 10189 | **High** — substance identity anchor | ✅ Sliced |\n| 2 | SUB | 7881 | **High** — substance entities | ✅ Sliced |\n| 3 | DOSSIER | 1722 | **High** — dossier-level records | ✅ Sliced |\n| 4 | DOSSIER_DOCS | 11614 | **High** — dossier→study links | ✅ Sliced |\n| 5 | FLEX_SUM.ToxRefValues | 8516 | **High** — toxicological reference values | ✅ Sliced (vitamin landscape) |\n| 6 | FLEX_REC | 4579 | **High** — substance composition | ✅ **Sliced** (vitamin compos breakdown) |\n| 7 | FLEX_SUM.Metabolites | 1374 | **High** — pet food mycotoxin metabolites | ✅ **Sliced** (T-2 / ZEN / Fumonisin) |\n| 8 | FLEX_SUM.ExpectedExposure | 2 | Low — too few records | — Skipped (sparse) |\n| 9 | END_STUDY_REC.AnimalHealth | 382 | **High** — **most direct pet/feed relevance** | ✅ **Sliced** (382 swinelhorse/livestock tox studies) |\n| 10 | END_STUDY_REC.PhysChemProps | 25148 | Low — REACH compliance (melting/partition) | — Skipped (pesticide physchem) |\n| 11 | END_STUDY_REC.HumanHealth | 38809 | **Excluded by project scope** | — Out of scope |\n| 12 | END_STUDY_REC.TerrestEcotox | 5451 | Low — pesticide birds/bees/arthropods | — Skipped (no pet) |\n| 13 | END_STUDY_REC.AquaticEcotox | 3498 | Low — fish/daphnia/algae (fish food indirect) | — Skipped |\n| 14 | END_STUDY_REC.EnvFateBehaviour | 931 | Low — pesticide biodegradation | — Skipped |\n| 15 | END_SUM | 23567 | Low — pesticide genotoxicity/carcinogenicity | — Skipped |\n| 16 | LEGAL | 8 | Low — 8 administrative entities | ✅ **Sliced** (lightweight administrative) |\n| 17 | LIT | 3186 | **High** — EFSA opinion bibliography | ✅ **Sliced** (FEEDAP/FAF/ANS/NDA focus panels) |\n\n## Coverage summary\n\n**9/17 sheets (53%)** are directly pet food relevant\nand have been sliced or deep-dived.\n\n**8/17 sheets (47%)** are excluded:\n\n- **1 explicitly out of scope**: HumanHealth (蔡之旅程\n  asked to exclude human-only data)\n- **7 pesticide/REACH compliance**: PhysChemProps,\n  TerrestEcotox, AquaticEcotox, EnvFateBehaviour, END_SUM,\n  ExpectedExposure, and the bulk of FLEX_REC coverage\n  pivoted away from pesticides to vitamin composition\n\n## Joined sheets working pair (verified)\n\n`REF_SUB.UUID → SUB.ReferenceSubstance.ReferenceSubstance`\n→ `SUB.UUID` → `DOSSIER_DOCS.UUID` → `DOSSIER` →\n`LIT / END_STUDY_REC / FLEX_SUM`\n\nThis 4-table join is the canonical OpenFoodTox\nsubstance-to-dossier traversal pattern validated\nacross Vitamin D anomaly correction, FLEX_REC vitamin\ncomposition, and FLEX_SUM.Metabolites mycotoxin\ninvestigations.\n\n## Topics produced (15 EFSA topics)\n\n| Topic | Slice | Pet food value |\n|-------|-------|----------------|\n| `EFSA_FEEDAP_pet_food_additives_dossiers` | Pet-food explicit dossier scan | Anchors the project |\n| `EFSA_OpenFoodTox_3_FEEDAP_chemistry_breakdown` | Substance dossiers by regulation | Maps the regulation landscape |\n| `EFSA_OpenFoodTox_3_dataset_overview` | XLSX macro inventory | First orientation |\n| `EFSA_OpenFoodTox_3_substance_to_dossier_mapping` | SUB → DOSSIER join mechanics | Technical reference |\n| `EFSA_OpenFoodTox_3_toxref_values_distribution` | ToxRefValues 8516 rows shape | Toxicological baseline |\n| `EFSA_OpenFoodTox_3_vitamins_overview` | 11 vitamins overview | The original Vitamin saga |\n| `EFSA_OpenFoodTox_3_vitamin_b3_dossiers` | Vitamin B3 deep dive | First vitamin-specific topic |\n| `EFSA_OpenFoodTox_3_vitamin_regulation_landscape` | All 11 vitamins regulation distribution | Regulatory overview |\n| `EFSA_OpenFoodTox_3_vitamin_d_anomaly` | Vitamin D \"0 dossier\" anomaly correction | **Important** — methodology discovery |\n| `EFSA_OpenFoodTox_3_animal_health_study_records` | AnimalHealth 382 | Note: broad overview (deprecated) |\n| `EFSA_OpenFoodTox_3_animal_health_tox_studies` | AnimalHealth detailed study records | Species / organ / duration deep dive |\n| `EFSA_OpenFoodTox_3_vitamin_composition_breakdown` | FLEX_REC 46 vitamin constituents | B1/B2/B5/B7 gaps + C/D/E/A forms |\n| `EFSA_OpenFoodTox_3_legal_entities` | LEGAL 8 entities | EFSA OpenFoodTox owns 7880 SUB (100%) |\n| `EFSA_OpenFoodTox_3_pet_food_mycotoxin_metabolites` | FLEX_SUM.Metabolites pet mycotoxins | ZEN/T-2/HT-2/Fumonisin masked forms |\n| `EFSA_OpenFoodTox_3_FEEFAP_NDA_panel_literature_index` | LIT 1141 panel records | Cross-validates Vitamin D anomaly |\n| `EFSA_OpenFoodTox_3_sheet_inventory_completion` (this) | Coverage summary | Project planning |\n\n## Pet food dimensions covered\n\n1. **Substances**: 7880 SUB (full)\n2. **Dossiers**: 1722 DOSSIER (full)\n3. **Tox reference values**: 8516 ToxRef (full)\n4. **Animal health toxicology studies**: 382 AnimalHealth (full)\n5. **Substance composition**: 4579 FLEX_REC (vitamin-focused)\n6. **Metabolite profiles**: 1374 (mycotoxin-focused)\n7. **EFSA opinions bibliography**: 1141/3185 (panel-focused)\n8. **Administrative metadata**: 8 LEGAL (full)\n9. **Regulatory landscapes**: Distribution by 1831/2003,\n   178/2002, 2015/2283, 524/1970, etc. (full)\n\n## What is NOT covered (explicit exclusions)\n\n- **Human toxicology** (38809 HumanHealth rows) —\n  out of scope per project mandate\n- **Pesticide REACH physics** (PhysChemProps 25148)\n- **Pesticide birds / bees / soil arthropods**\n  (TerrestEcotox 5451)\n- **Pesticide aquatic biology** (AquaticEcotox 3498)\n- **Pesticide environmental fate** (EnvFate 931)\n- **Pesticide genetic toxicity / carcinogenicity**\n  (END_SUM 23567)\n\n## Conclusion\n\n**OpenFoodTox 3.0 is the most comprehensive EFSA\nsubstance-dossier pipeline for pet food safety**, but\nroughly **half of the dataset (8/17 sheets) is pesticide-\ncentric** and irrelevant to companion animal nutrition\nresearch. The pet food value is concentrated in:\n\n- **Vitamin/Additive substance dossiers** (SUB + DOSSIER)\n- **AnimalHealth toxicology studies** (382 rows)\n- **Vit/Min additives compositional data** (FLEX_REC)\n- **Mycotoxin metabolite profiles** (FLEX_SUM.Metabolites)\n- **EFSA Panel opinions** (FEEDAP/FAF/ANS/NDA in LIT)\n\n**P1 priority expansion**: Once W14 verification work\nis comfortable with these 9 sliced sheets, the project\nmay extend into EU P3 (pet food specific EU regs) or\nW2-W3 EU 2025/639 + CFIA completion.\n\n## Source\n\n`toxicology/efsa/OFT3.0_export_repository.xlsx` 17\nworksheets inventoried. Sheet sizes from `openpyxl\nread_only` row counters; relevance classification by\ncontent category (regulatory panel / entity type /\npet mention keyword density). Cross-validated with\nrelated topics in this category.\n\nVerified 2026-07-20.","sources":[],"tokens_estimated":720,"generated_at":null,"tip":"Use /api/v1/topics to discover more topics. /api/v1/nutrient for precise single-point queries. /api/v1/cross_compare for 2-3 standard comparisons."}