"""
blockchain_logic.py

Provides a simple educational blockchain-like data structure for traceability
of shrimp supply chains. This module includes:

- Block: lightweight block object
- Blockchain: chain manager that persists blocks to a sqlite DB
- Helper functions to query and traverse chains
- Sample lineages for P. vannamei (extended with 32 blocks), P. monodon, P. indicus
- Full KDEs and sequential Unique Blockchain / Secondary IDs.

Author: Generated for user (updated)
Date: 2025-10-22
"""

import hashlib
import json
import datetime
import os
import sqlite3
import logging
from collections import deque

logging.basicConfig(level=logging.INFO, format='%(levelname)s: %(message)s')

# SQLite resolves relative paths against the process's current working
# directory, not this file's directory. Under mod_wsgi the CWD is normally
# Apache's server root, not the project directory, which makes relative
# db_name values fail with "unable to open database file". Anchor them here
# so the DB location is independent of the process CWD.
BASE_DIR = os.path.dirname(os.path.abspath(__file__))

STAGES = [
    "Broodstock Facility","Hatchery-Nursery","Grow-out System","Harvesting",
    "Aggregation/Trading at Farm Gate","Transportation","Processing (direct from farms)",
    "Exporting","Marketing","Retailing","Shrimp on a plate","Production of feed & inputs",
    "Shrimp on a plate (Customer View)"
]

class Block:
    def __init__(self, index, timestamp, transactions, prev_hash, stage, data_id, nonce=0):
        self.index=index; self.timestamp=timestamp; self.transactions=transactions
        self.prev_hash=prev_hash; self.stage=stage; self.data_id=data_id; self.nonce=nonce
    def to_dict(self,include_hash=False):
        d={"index":self.index,"timestamp":self.timestamp.isoformat() if isinstance(self.timestamp,datetime.datetime) else self.timestamp,
           "transactions":self.transactions,"prev_hash":self.prev_hash,"nonce":self.nonce,"stage":self.stage,"data_id":self.data_id}
        if include_hash and hasattr(self,"hash"): d["hash"]=self.hash
        return d
    def compute_hash(self):
        return hashlib.sha256(json.dumps(self.to_dict(),sort_keys=True).encode()).hexdigest()

class Blockchain:
    def __init__(self,db_name,sample_lineage=None):
        self.db_name=db_name if os.path.isabs(db_name) else os.path.join(BASE_DIR,db_name)
        self.sample_lineage=sample_lineage
        self.chain=[]; self.load_chain(); self.create_genesis_block()
    def load_chain(self):
        self.chain=[]; conn=None
        try:
            conn=sqlite3.connect(self.db_name); c=conn.cursor()
            c.execute('''CREATE TABLE IF NOT EXISTS blocks(index_ INTEGER PRIMARY KEY,timestamp TEXT,transactions TEXT,prev_hash TEXT,nonce INTEGER,stage TEXT,data_id TEXT UNIQUE,hash TEXT)''')
            for r in c.execute('SELECT * FROM blocks ORDER BY index_ ASC').fetchall():
                i,t,tr,ph,n,st,di,_=r
                try: ts=datetime.datetime.fromisoformat(t)
                except: ts=t
                b=Block(i,ts,json.loads(tr),ph,st,di,n); self.chain.append(b)
        except Exception as e: logging.error(f"Load error {e}")
        finally:
            if conn: conn.close()
    def save_block(self,b):
        try:
            conn=sqlite3.connect(self.db_name); c=conn.cursor(); d=b.to_dict()
            c.execute('INSERT INTO blocks VALUES(?,?,?,?,?,?,?,?)',(b.index,d["timestamp"],json.dumps(d["transactions"]),b.prev_hash,b.nonce,b.stage,b.data_id,b.compute_hash())); conn.commit()
        except sqlite3.IntegrityError: logging.warning(f"Duplicate block {b.data_id}")
        except Exception as e: logging.error(f"Save error {e}")
        finally:
            conn.close()
    def create_genesis_block(self):
        if not self.chain:
            g=Block(0,datetime.datetime.now(),[{"sender":"System","recipient":"Genesis","amount":0,"data":{"ID":"GENESIS-BLOCK"}}],"0","Genesis","GENESIS-BLOCK")
            g.hash=g.compute_hash(); self.chain.append(g); self.save_block(g); self.add_sample_data()
        else: logging.info(f"Loaded {len(self.chain)} blocks")
    @property
    def last_block(self): return self.chain[-1]
    def add_block(self,b,p): b.hash=p; self.chain.append(b); self.save_block(b); return True
    def proof_of_work(self,b,diff='0000'):
        b.nonce=0; h=b.compute_hash()
        while not h.startswith(diff): b.nonce+=1; h=b.compute_hash()
        return h
    def mine(self,stage,data):
        did=data.get("ID") or data.get("Unique ID") or data.get("Unique ID ") or data.get("Batch No") or f"NO_ID_{datetime.datetime.now().isoformat()}"
        if any(x.data_id==did for x in self.chain): return None,did
        nb=Block(self.last_block.index+1,datetime.datetime.now(),[{"sender":"System","recipient":stage,"amount":1,"data":data}],self.last_block.compute_hash(),stage,did)
        pf=self.proof_of_work(nb); self.add_block(nb,pf); return nb.index,did
    def add_sample_data(self):
        if len(self.chain)==1 and self.sample_lineage:
            logging.info(f"Populating {self.db_name} with {len(self.sample_lineage)} stages")
            for d in self.sample_lineage:
                dd=dict(d); st=dd.pop("stage",None)
                try: self.mine(st,dd)
                except Exception as e: logging.error(f"Mine error {e}")
            logging.info(f"{self.db_name} now has {len(self.chain)} blocks")

def get_batch_id_from_block(b):
    try: return b.get("data_id") or b.get("transactions",[{}])[0].get("data",{}).get("ID")
    except: return None
def find_block_by_data_id(i,c):
    for b in c:
        if get_batch_id_from_block(b.to_dict())==i: return b.to_dict()
    return None
def get_product_lineage_trace(s,c):
    id_map={get_batch_id_from_block(b.to_dict()):b.to_dict() for b in c}
    blk=find_block_by_data_id(s,c)
    if not blk: return []
    res=[]; cid=s
    while cid and cid!='GENESIS-BLOCK':
        b=id_map.get(cid)
        if not b: break
        res.insert(0,b)
        try: cid=b["transactions"][0]["data"]["parent_batch_id"]
        except: break
    return res
def get_product_lineage_forward(s,c):
    pmap={}; imap={}
    for b in c:
        bd=b.to_dict(); bid=get_batch_id_from_block(bd); imap[bid]=bd
        try:
            pid=bd["transactions"][0]["data"]["parent_batch_id"]
            if pid: pmap.setdefault(pid,[]).append(bid)
        except: pass
    out=[]; q=[s]; v={s}
    while q:
        cid=q.pop(0); cb=imap.get(cid)
        if cb: out.append(cb)
        for ch in pmap.get(cid,[]):
            if ch not in v: v.add(ch); q.append(ch)
    return out


# ==================== EXTENDED P. VANNAMEI LINEAGE (32 BLOCKS) ====================
LINEAGE_P_VANNAMEI = [
  {
    "stage": "Broodstock Facility",
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "301123100001010125",
    "NFDP Reg No": "NFDP1001",
    "Facility Name": "M/s. Konabay",
    "Address": "Sunrise Capital, Inc. dba Kona Bay Marine\nResources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752 ",
    "Species": "P. vannamei",
    "Genetic selection": "SPF",
    "Date of receipt": "2025-04-15 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods": "130",
    "Size of broods (g)": "40",
    "Import": "Yes",
    "Survival rate (%)": "88.8",
    "Quarantine": "Yes",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Source": "Domesticated",
    "Feeding regime": "Standard",
    "SPF status": "Verified",
    "Unique Blockchain ID": "251021010128025504",
    "Unique Secondary ID": "251021010199984591"
  },
  {
    "stage": "Hatchery-Nursery",
    "Stakeholder/Custodian": "Hatchery/Nursery operator",
    "Unique ID": "AP5690961001010125",
    "parent_batch_id": "301123100001010125",
    "NFDP Reg No": "NFDP2001",
    "Broodstock supplier": "M/s. Konabay",
    "DoF approved": "Yes",
    "MPEDA enrolment": "MPEDA5001",
    "Species": "P. vannamei",
    "Life stage": "Broodstock",
    "Size of broods (g)": "40",
    "Quantity of broods (No.)": "130",
    "Import": "Yes",
    "Quarantine": "Yes",
    "Hatchery details": "M/s. Sree Vyjayanthee Hatcheries LLP.",
    "Address": "Batti somaiahpalem, Karedu, Ulavapadu Mandal, SPSR Nellore, Andhra Pradesh",
    "Location (GPS coordinates)": "15.150090, 80.060336",
    "CAA approval": "56-9(96)/2019",
    "Capacity (PLs No.)": "100000000",
    "Seed production details (PLs No.)": "100000000",
    "Date": "2025-01-20 00:00:00",
    "PL age (days)": "12",
    "Gender": "Mixed",
    "Genetic strain": "SPF",
    "Survival rate of nauplii and PLs (%)": "89.7 and 58",
    "Larval tank size (MT)": "1000",
    "Larval density (per L)": "100",
    "Use of probiotics": "Yes",
    "Use of antibiotics": "No",
    "Light logs": "Standard",
    "Aeration logs": "Standard",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity measures": "Yes",
    "Hatchery success rate (%)": "95",
    "Feed details": "Starter feed",
    "Inputs": "Bio-supplements",
    "Effluent treatment system (MT)": "140",
    "Certification": "ICAR-CIBA verified",
    "Water quality": "Temp 28°C, pH 7.8, DO 6 mg/L, Salinity 23 ppt",
    "Unique Blockchain ID": "251021010264928514",
    "Unique Secondary ID": "251021010245186359"
  },
  {
    "stage": "Grow-out System-1",
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-GROW-001",
    "NFDP Reg No": "NFDP3001",
    "Farm Name": "Greekay farm",
    "Address": "Pudiparthi village, Venkatachalam, SPSR Nellore, Andhra Pradesh - 524321",
    "Owner": "Mrs. Kanupuru Jayalakshmi, W/o. Mr. Kanupuru Sunil Kumar Reddy",
    "Location (GPS coordinates)": "14.225910, 80.001002",
    "CAA approval": "AP-II 2022(20690)",
    "Farm size (ha)": "0.72",
    "Water spread area (ha)": "0.43",
    "Type of culture system": "Traditional, Semi-intensive, Intensive, Super-Intensive",
    "Ponds (No.)": "2",
    "Species farmed": "P. vannamei",
    "PLs age (days)": "12",
    "Stocking density (per sq. mt.)": "40",
    "Date of stocking": "2025-02-01 00:00:00",
    "Feed": "Pellet feed",
    "Inputs": "Probiotics",
    "Water quality": "Temp 29°C, pH 7.5, DO 5.5 mg/L",
    "Culture duration (days)": "110",
    "Survival rate (%)": "92",
    "Certification": "ICAR-CIBA verified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "Unique Blockchain ID": "251022010300001001",
    "Unique Secondary ID": "251022010300002001"
  },
  {
    "stage": "Production of feed & inputs-1",
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "VAN1-FEED-001",
    "parent_batch_id": "VAN1-PROW-001",
    "NFDP Reg No": "NFDP4001",
    "Address": "Chennai",
    "Feed Name": "Larval, starter, grower",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Soy protein",
    "Nutritional profile": "Crude protein 36%; Fat 5%; Fibre 5%; Ash 15%; Moisture 11%",
    "FCR": "1.1 to 1.5",
    "Manufacture Date": "2025-01-30 00:00:00",
    "Expiry date": "2025-04-29 00:00:00",
    "Quantity of feed available (Tonnes)": "100",
    "Batch No": "B101",
    "Supplier": "AquaFeed Pvt Ltd",
    "Certification": "HACCP",
    "Unique Blockchain ID": "251022010300001002",
    "Unique Secondary ID": "251022010300002002"
   },
   {
    "stage": "Harvesting-1",
    "Stakeholder/Custodian": "Farmer/Farm owner/Aggregator",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-HARV-001",
    "Harvesting Date": "2025-05-21 00:00:00",
    "Method": "Drag net",
    "Duration (h)": "1",
    "Species": "P. vannamei",
    "Avg Body Weight (g)": "25.1",
    "Total production (Tonnes)": "4.1",
    "Partial harvesting": "No",
    "Iced used & quality": "Yes & good",
    "Unique Blockchain ID": "251022010300001003",
    "Unique Secondary ID": "251022010300002003"
  },
  {
    "stage": "Aggregation/Trading at Farm Gate-1",
    "Stakeholder/Custodian": "Aggregator/Trader",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-AGG-001",
    "Trade Date": "2025-05-21 00:00:00",
    "Aggregator": "Nellore Shrimp Traders",
    "Species": "P. vannamei",
    "Quantity (Tonnes)": "50",
    "Ice used & quality": "Yes & good",
    "Next custodian": "Cold Chain Ltd",
    "Grade wise quantity (Tonnes)": "A - 30; B - 20",
    "Unique Blockchain ID": "251022010300001004",
    "Unique Secondary ID": "251022010300002004"
  },
  {
    "stage": "Transportation-1",
    "Stakeholder/Custodian": "Cold chain operator",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-TRANS-001",
    "Transporter": "Cold Chain Ltd",
    "Contact": "9876543210",
    "Truck type": "Refrigerated Truck",
    "Transport license": "TRK123",
    "Vehicle ID": "VH001; VH002",
    "Vehicle sanitation log": "OK",
    "Vehicle capacity (Tonnes)": "20-30",
    "Weight transported (Tonnes)": "20; 30",
    "Name of the driver": "Mr. Kandasamy",
    "Contact detail": "8056006399",
    "Distance (km)": "50",
    "Duration (h)": "1",
    "Loading and unloading time (h)": "3",
    "GPS log": "14.468515, 80.039072",
    "Condition": "Iced",
    "Temperature at packing": "4°C",
    "Temperature data logger": "Yes",
    "Species": "P. vannamei",
    "Unique Blockchain ID": "251022010300001005",
    "Unique Secondary ID": "251022010300002005"
  },
  {
    "stage": "Marketing-1",
    "Stakeholder/Custodian": "Distributor/Wholesaler",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-MARK-001",
    "Name": "Nellore Fish Market",
    "Address": "Nellore",
    "GPS coordinate": "14.464770, 80.008052",
    "Contact": "9299808577",
    "Seller": "Mixed",
    "Temperature": "4°C",
    "Stall type": "Platform",
    "No. of stalls": "4",
    "Species": "P. vannamei",
    "Condition": "Iced",
    "Hygiene": "Yes",
    "Drainage facility": "Yes",
    "Waste disposal": "Yes",
    "Potable water facility": "Yes",
    "Ice plant (No. & capacity)": "2; 5 tonnes",
    "e-Commerce": "AquaMart",
    "Quantity sold (kg)": "100",
    "Buyer": "Retailers",
    "Expiry/use-by date": "2025-06-01 00:00:00",
    "Unique Blockchain ID": "251022010300001006",
    "Unique Secondary ID": "251022010300002006"
  },
  {
    "stage": "Processing (direct from farms)-1",
    "Stakeholder/Custodian": "Processor",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-PROC-001",
    "Processing Plant": "SeaFresh Ltd",
    "Address": "Chennai",
    "Approval No": "PL1234",
    "Capacity (Tonnes/day)": "2",
    "Processor credentials": "Certified",
    "Date and Time of receipt": "2025-05-22 10:00:00",
    "Species": "P. vannamei",
    "Product type": "IQF",
    "Temperature": "0-4°C",
    "Equipment": "Freezers",
    "Packaging": "Bulk",
    "Certification": "HACCP",
    "Water availability": "Yes",
    "Waste management": "Yes",
    "Unique Blockchain ID": "251022010300001007",
    "Unique Secondary ID": "251022010300002007"
  },
  {
    "stage": "Exporting-1",
    "Stakeholder/Custodian": "Exporter",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-EXP-001",
    "Exporter": "Oceanic Exports",
    "IEC Code": "IEC5001",
    "Export mode": "Sea",
    "Airline": "N/A",
    "Place of embarkation/disembarkation": "N/A",
    "Shipping liner name": "COSCO",
    "Country of loading and unloading": "India and China",
    "Date and time": "2025-05-30 06:00:00",
    "Transport duration (days)": "15",
    "Container size (Tonnes)": "25",
    "Temperature": "18°C",
    "Species": "P. vannamei",
    "Category": "Ready-to-cook",
    "ITC-HS Code": "30617",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, SHAPHARI, FSSAI, HACCP, CATCH IT, ASC, BAP, Global GAP, GAA, GDST, ICCAT, DS 2031, CoO, Non-radioactivity",
    "Unique Blockchain ID": "251022010300001008",
    "Unique Secondary ID": "251022010300002008"
  },
  {
    "stage": "Retailing-1",
    "Stakeholder/Custodian": "Retailer/E-commerce vendor",
    "Unique ID": "AP5690960101010125",
    "parent_batch_id": "VAN1-RET-001",
    "Retailer Name": "AquaRetail",
    "Address": "Chennai",
    "Contact": "9876501234",
    "Temperature": "4°C",
    "Product category": "Ready-to-cook",
    "e-Commerce": "AquaMart",
    "Quantity sold (kg)": "10",
    "Buyer": "Consumers",
    "Expiry date": "2025-06-01 00:00:00",
    "Unique Blockchain ID": "251022010300001009",
    "Unique Secondary ID": "251022010300002009"
  },
  {
    "stage": "Shrimp on a plate-1",
    "Stakeholder/Custodian": "Consumer",
    "Unique ID": "AP5690960101010189",
    "parent_batch_id": "VAN1-PLATE-001",
    "Freshess": "Fresh/spoiled",
    "Smell": "Fresh/fishy/ammonia",
    "Appearance": "Good/Poor",
    "Texture": "Leathery/Smooth",
    "Black spots": "Yes/No",
    "Shape and size" : "Intact & Uniform",
    "Weight": "Correct/Incorrect",
    "Unique Blockchain ID": "251022010300001010",
    "Unique Secondary ID": "251022010300002010"
  },
  {
    "stage": "Shrimp on a plate (Customer View)-1",
    "Stakeholder/Custodian": "Customer",
    "Unique ID": "AP5690860101010165",
    "parent_batch_id": "VAN1-Cus PLATE-001",
    "Customer Name": "",
    "Purchase Date": "",
    "Feedback Link": "",
    "Temperature at Delivery": "",
    "Unique Blockchain ID": "251022010300001011",
    "Unique Secondary ID": "251022010300002011"
  },
  {
    "stage": "Grow-out System-2",
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TN5690960101010178",
    "parent_batch_id": "VAN2-GROW-002",
    "NFDP Reg No": "NFDP100B",
    "Farm Name": "Nagore Aqua Farm",
    "Address": "Harbour Road, Nagore, Nagapattinam, Tamil Nadu - 611105",
    "Owner": "Mrs. Deepa Selvan",
    "Location (GPS coordinates)": "10.7732,79.8650",
    "CAA approval": "TN-FARM-2023-45",
    "Farm size (ha)": "0.65",
    "Water spread area (ha)": "0.40",
    "Type of culture system": "Traditional, Semi-intensive, Intensive, Super-Intensive",
    "Ponds (No.)": "2",
    "Species farmed": "P. vannamei",
    "PLs age (days)": "12",
    "Stocking density (per sq. mt.)": "38",
    "Date of stocking": "2025-02-12 00:00:00",
    "Feed": "Pellet feed",
    "Inputs": "Bio-supplements",
    "Water quality": "Temp 29°C, pH 7.6, DO 5.8 mg/L",
    "Culture duration (days)": "105",
    "Survival rate (%)": "90",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "Unique Blockchain ID": "251022010300002100",
    "Unique Secondary ID": "251022010300011100"
  },
  {
    "stage": "Production of feed & inputs-2",
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "TN5690960101010256",
    "parent_batch_id": "VAN2-PROW-002",
    "NFDP Reg No": "NFDP100B",
    "Address": "Harbour Road, Nagore, Nagapattinam, Tamil Nadu - 611105",
    "Feed Name": "Seaside Starter, Grower",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Soy protein, Vitamins",
    "Nutritional profile": "Crude protein 37%; Fat 6%; Fibre 4%; Ash 14%; Moisture 10%",
    "FCR" : "1.1 to 1.5",
    "Manufacture Date": "2025-02-15 00:00:00",
    "Expiry date": "2025-07-04 00:00:00",
    "Quantity of feed available (Tonnes)": "40",
    "Batch No": "SW202",
    "Supplier": "Seaside Feeds Pvt Ltd",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Unique Blockchain ID": "251022010300002101",
    "Unique Secondary ID": "251022010300011101"
  },
  {
    "stage": "Harvesting-2",
    "Stakeholder/Custodian": "Farmer/Farm owner/Aggregator",
    "Unique ID": "AP5690960101010151",
    "parent_batch_id": "VAN2-HARV-002",
    "Harvesting Date": "2025-06-10 00:00:00",
    "Method": "Seine net",
    "Duration (h)": "1.2",
    "Species": "P. vannamei",
    "Avg Body Weight (g)": "25.1",
    "Total production (Tonnes)": "3.9",
    "Partial harvesting": "No",
    "Iced used & quality": "Yes & good",
    "Unique Blockchain ID": "251022010300002102",
    "Unique Secondary ID": "251022010300011102"
  },
  {
    "stage": "Aggregation/Trading at Farm Gate-2",
    "Stakeholder/Custodian": "Aggregator/Trader",
    "Unique ID": "TN5690960101010789",
    "parent_batch_id": "VAN2-AGG-002",
    "Trade Date": "2025-06-10 00:00:00",
    "Aggregator": "Nagapattinam Market Aggregators",
    "Species": "P. vannamei",
    "Quantity (Tonnes)": "40",
    "Ice used & quality": "Yes & good",
    "Next custodian": "TN Cold Chain Ltd",
    "Grade wise quantity (Tonnes)": "A - 25; B - 15",
    "Unique Blockchain ID": "251022010300002103",
    "Unique Secondary ID": "251022010300011103"
  },
  {
    "stage": "Transportation-2",
    "Stakeholder/Custodian": "Transporter/Cold chain operator",
    "Unique ID": "AP5690960101018456",
    "parent_batch_id": "VAN2-TRANS-002",
    "Transporter": "East Coast Cold Trans",
    "Contact": "9876599999",
    "Truck type": "Refrigerated Truck",
    "Transport license": "TRK502",
    "Vehicle ID": "TNCT010; TNCT011",
    "Vehicle sanitation log": "OK",
    "Vehicle capacity (Tonnes)": "20-30",
    "Weight transported (Tonnes)": "20; 20",
    "Name of the driver": "Mr. S. Ravi",
    "Contact detail": "8056007788",
    "Diatance (km)": "45",
    "Duration (h)": "1.2",
    "Loading and unloading time (h)": "2.5",
    "GPS log": "10.7802,79.8501",
    "Condition": "Iced",
    "Temperature at packing": "3-4°C",
    "Temperature data logger": "Yes",
    "Species": "P. vannamei",
    "Unique Blockchain ID": "251022010300002104",
    "Unique Secondary ID": "251022010300011104"
  },
  {
    "stage": "Marketing-2",
    "Stakeholder/Custodian": "Distributor/Wholesaler",
    "Unique ID": "TN5690960107540189",
    "parent_batch_id": "VAN2-MARK-002",
    "Name": "Nagore Fish Market",
    "Address": "Harbour Road, Nagore, Nagapattinam, Tamil Nadu - 611105",
    "GPS coordinate": "10.7732,79.8650",
    "Contact": "9876599999",
    "Seller": "Mixed",
    "Temperature": "0-4°C",
    "Stall type": "Platform",
    "No. of stalls": "5",
    "Species": "P. vannamei",
    "Condition": "Iced",
    "Hygiene": "Yes",
    "Drainage facility": "Yes",
    "Waste disposal": "Yes",
    "Potable water facility": "Yes",
    "Ice plant (No. & capacity)": "1; 5 tonnes",
    "e-Commerce": "AquaMart",
    "Quantity sold (kg)": "12",
    "Buyer": "Consumers",
    "Expiry/use-by date": "2025-07-03 00:00:00",
    "Unique Blockchain ID": "251022010300002105",
    "Unique Secondary ID": "251022010300011105"
  },
  {
    "stage": "Processing (direct from farms)-2",
    "Stakeholder/Custodian": "Processor",
    "Unique ID": "TN5690960101042189",
    "parent_batch_id": "VAN2-PROC-002",
    "Processing Plant": "Coastal Processors Pvt Ltd",
    "Address": "Harbour Road, Nagore, Nagapattinam, Tamil Nadu - 611105",
    "Approval No": "PL-NPT-1002",
    "Capacity (Tonnes/day)": "3",
    "Processor credentials": "Certified",
    "Date and Time of receipt": "2025-10-06 10:00:00",
    "Species": "P. vannamei",
    "Product type": "IQF",
    "Temperature": "0-4°C",
    "Equipment": "Freezers",
    "Packaging": "Bulk",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Water availability": "Yes",
    "Waste management": "Yes",
    "Unique Blockchain ID": "251022010300002106",
    "Unique Secondary ID": "251022010300011106"
 },
 {
    "stage": "Exporting-2",
    "Stakeholder/Custodian": "Exporter",
    "Unique ID": "AP5690960845010189",
    "parent_batch_id": "VAN2-EXP-002",
    "Exporter": "BayLine Exports",
    "IEC Code": "IEC9002",
    "Export mode": "Sea",
    "Airline": "N/A",
    "Place of embarkation/disembarkation": "Navi Mumbai Port",
    "Shipping liner name": "MAERSK",
    "Country of loading and unloading": "India and Vietnam",
    "Date and time": "2025-06-12 06:00:00",
    "Transport duration (days)": "14",
    "Container size (Tonnes)": "22",
    "Temperature": "0-4°C",
    "Species": "P. vannamei",
    "Category": "Ready-to-cook",
    "ITC-HS Code": "30617",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Unique Blockchain ID": "251022010300002107",
    "Unique Secondary ID": "251022010300011107"
  },
  {
    "stage": "Retailing-2",
    "Stakeholder/Custodian": "Retailer/E-commerce vendor",
    "Unique ID": "TN5690960101018471",
    "parent_batch_id": "VAN2-RET-002",
    "Retailer Name": "OceanFresh Retail",
    "Address": "Harbour Road, Nagore, Nagapattinam, Tamil Nadu - 611105",
    "Contact": "9876599999",
    "Temperature": "0-4°C",
    "Product category": "Ready-to-cook",
    "e-Commerce": "AquaMart",
    "Quantity sold (kg)": "12",
    "Buyer": "Consumers",
    "Expiry date": "2025-07-04 00:00:00",
    "Unique Blockchain ID": "251022010300002108",
    "Unique Secondary ID": "251022010300011108"
  },
  {
    "stage": "Shrimp on a plate-2",
    "Stakeholder/Custodian": "Consumer",
    "Unique ID": "AP5690960106350189",
    "parent_batch_id": "VAN2-PLATE-002",
    "Freshess": "Fresh/spoiled",
    "Smell": "Fresh/fishy/ammonia",
    "Appearance": "Good/Poor",
    "Texture": "Leathery/Smooth",
    "Black spots": "Yes/No",
    "Shape and size" : "Intact & Uniform",
    "Weight": "Correct/Incorrect",
    "Unique Blockchain ID": "251022010300002109",
    "Unique Secondary ID": "251022010300011109"
  },
{
    "stage": "Shrimp on a plate (Customer View)-1",
    "Stakeholder/Custodian": "Customer",
    "Unique ID": "AP5690860101010165",
    "parent_batch_id": "VAN2-Cus PLATE-002",
    "Customer Name": "",
    "Purchase Date": "",
    "Feedback Link": "",
    "Temperature at Delivery": "",
    "Unique Blockchain ID": "251022010300001011",
    "Unique Secondary ID": "251022010300002011"
  },

  {
    "stage": "Grow-out System-3",
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "AP5690960101011478",
    "parent_batch_id": "VAN3-GROW-003",
    "NFDP Reg No": "NFDP100B",
    "Farm Name": "Poompuhar Aqua Farm",
    "Address": "Harbour Road, Poompuhar, Nagapattinam, Tamil Nadu - 611105",
    "Owner": "Mrs. Deepa Selvan",
    "Location (GPS coordinates)": "10.7732,79.8650",
    "CAA approval": "TN-FARM-2023-45",
    "Farm size (ha)": "0.65",
    "Water spread area (ha)": "0.40",
    "Type of culture system": "Traditional, Semi-intensive, Intensive, Super-Intensive",
    "Ponds (No.)": "2",
    "Species farmed": "P. vannamei",
    "PLs age (days)": "12",
    "Stocking density (per sq. mt.)": "38",
    "Date of stocking": "2025-02-12 00:00:00",
    "Feed": "Pellet feed",
    "Inputs": "Bio-supplements",
    "Water quality": "Temp 29°C, pH 7.6, DO 5.8 mg/L",
    "Culture duration (days)": "105",
    "Survival rate (%)": "90",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "Unique Blockchain ID": "251022010300002110",
    "Unique Secondary ID": "251022010300011110"
  },
  {
    "stage": "Production of feed & inputs-3",
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "TN5656460101010189",
    "parent_batch_id": "VAN3-PROW-003",
    "NFDP Reg No": "NFDP100B",
    "Address": "Harbour Road, Poompuhar, Nagapattinam, Tamil Nadu - 611105",
    "Feed Name": "Seaside Starter, Grower",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Soy protein, Vitamins",
    "Nutritional profile": "Crude protein 37%; Fat 6%; Fibre 4%; Ash 14%; Moisture 10%",
    "FCR": "1.1 to 1.5",
    "Manufacture Date": "2025-02-15 00:00:00",
    "Expiry date": "2025-07-04 00:00:00",
    "Quantity of feed available (Tonnes)": "40",
    "Batch No": "SW202",
    "Supplier": "Seaside Feeds Pvt Ltd",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Unique Blockchain ID": "251022010300002111",
    "Unique Secondary ID": "251022010300011111"
  },
  {
    "stage": "Harvesting-3",
    "Stakeholder/Custodian": "Farmer/Farm owner/Aggregator",
    "Unique ID": "AP5690960101564189",
    "parent_batch_id": "VAN3-HARV-003",
    "Harvesting Date": "2025-06-10 00:00:00",
    "Method": "Seine net",
    "Duration (h)": "1.2",
    "Species": "P. vannamei",
    "Avg Body Weight (g)": "25.1",
    "Total production (Tonnes)": "3.9",
    "Partial harvesting": "No",
    "Iced used & quality": "Yes & good",
    "Unique Blockchain ID": "251022010300002112",
    "Unique Secondary ID": "251022010300011112"
  },
  {
    "stage": "Aggregation/Trading at Farm Gate-3",
    "Stakeholder/Custodian": "Aggregator/Trader",
    "Unique ID": "AP5690960101010487",
    "parent_batch_id": "VAN3-AGG-003",
    "Trade Date": "2025-06-10 00:00:00",
    "Aggregator": "Nagapattinam Market Aggregators",
    "Species": "P. vannamei",
    "Quantity (Tonnes)": "40",
    "Ice used & quality": "Yes & good",
    "Next custodian": "TN Cold Chain Ltd",
    "Grade wise quantity (Tonnes)": "A - 25; B - 15",
    "Unique Blockchain ID": "251022010300002113",
    "Unique Secondary ID": "251022010300011113"
  },
  {
    "stage": "Transportation-3",
    "Stakeholder/Custodian": "Transporter/Cold chain operator",
    "Unique ID": "AP5690960101018412",
    "parent_batch_id": "VAN3-TRANS-003",
    "Transporter": "East Coast Cold Trans",
    "Contact": "9876599999",
    "Truck type": "Refrigerated Truck",
    "Transport license": "TRK502",
    "Vehicle ID": "TNCT010; TNCT011",
    "Vehicle sanitation log": "OK",
    "Vehicle capacity (Tonnes)": "20-30",
    "Weight transported (Tonnes)": "20; 20",
    "Name of the driver": "Mr. S. Ravi",
    "Contact detail": "8056007788",
    "Diatance (km)": "45",
    "Duration (h)": "1.2",
    "Loading and unloading time (h)": "2.5",
    "GPS log": "10.7802,79.8501",
    "Condition": "Iced",
    "Temperature at packing": "3-4°C",
    "Temperature data logger": "Yes",
    "Species": "P. vannamei",
    "Unique Blockchain ID": "251022010300002114",
    "Unique Secondary ID": "251022010300011114"
  },
  {
    "stage": "Marketing-3",
    "Stakeholder/Custodian": "Distributor/Wholesaler",
    "Unique ID": "TN7890960101010189",
    "parent_batch_id": "VAN3-MARK-003",
    "Name": "Nagore Fish Market",
    "Address": "Harbour Road, Poompuhar, Nagapattinam, Tamil Nadu - 611105",
    "GPS coordinate": "10.7732,79.8650",
    "Contact": "9876599999",
    "Seller": "Mixed",
    "Temperature": "0-4°C",
    "Stall type": "Platform",
    "No. of stalls": "5",
    "Species": "P. vannamei",
    "Condition": "Iced",
    "Hygiene": "Yes",
    "Drainage facility": "Yes",
    "Waste disposal": "Yes",
    "Potable water facility": "Yes",
    "Ice plant (No. & capacity)": "1; 5 tonnes",
    "e-Commerce": "AquaMart",
    "Quantity sold (kg)": "12",
    "Buyer": "Consumers",
    "Expiry/use-by date": "2025-07-03 00:00:00",
    "Unique Blockchain ID": "251022010300002115",
    "Unique Secondary ID": "251022010300011115"
  },
  {
    "stage": "Processing (direct from farms)-3",
    "Stakeholder/Custodian": "Processor",
    "Unique ID": "TN5690960101014889",
    "parent_batch_id": "VAN3-PROC-003",
    "Processing Plant": "Coastal Processors Pvt Ltd",
    "Address": "Harbour Road, Poompuhar, Nagapattinam, Tamil Nadu - 611105",
    "Approval No": "PL-NPT-1002",
    "Capacity (Tonnes/day)": "3",
    "Processor credentials": "Certified",
    "Date and Time of receipt": "2025-06-10 10:00:00",
    "Species": "P. vannamei",
    "Product type": "IQF",
    "Temperature": "0-4°C",
    "Equipment": "Freezers",
    "Packaging": "Bulk",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Water availability": "Yes",
    "Waste management": "Yes",
    "Unique Blockchain ID": "251022010300002116",
    "Unique Secondary ID": "251022010300011116"
  },
  {
    "stage": "Exporting-3",
    "Stakeholder/Custodian": "Exporter",
    "Unique ID": "AP5623960101010189",
    "parent_batch_id": "VAN3-EXP-003",
    "Exporter": "BayLine Exports",
    "IEC Code": "IEC9002",
    "Export mode": "Sea",
    "Airline": "N/A",
    "Place of embarkation/disembarkation": "Navi Mumbai Port",
    "Shipping liner name": "MAERSK",
    "Country of loading and unloading": "India and Vietnam",
    "Date and time": "2025-06-12 06:00:00",
    "Transport duration (days)": "14",
    "Container size (Tonnes)": "22",
    "Temperature": "0-4°C",
    "Species": "P. vannamei",
    "Category": "Ready-to-cook",
    "ITC-HS Code": "30617",
    "Certification": "ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP",
    "Unique Blockchain ID": "251022010300002117",
    "Unique Secondary ID": "251022010300011117"
  },
  {
    "stage": "Retailing-3",
    "Stakeholder/Custodian": "Retailer/E-commerce vendor",
    "Unique Blockchain ID": "251022010300002118",
    "Unique ID": "VAN3-RET-003",
    "parent_batch_id": "VAN3-EXP",
    "Retailer Name": "OceanFresh Retail",
    "Address": "Harbour Road, Poompuhar, Nagapattinam, Tamil Nadu - 611105",
    "Contact": "9876599999",
    "Temperature": "0-4°C",
    "Product category": "Ready-to-cook",
    "e-Commerce": "AquaMart",
    "Quantity sold (kg)": "12",
    "Buyer": "Consumers",
    "Expiry date": "2025-07-04 00:00:00",
    "Unique Blockchain ID": "251022010300002118",
    "Unique Secondary ID": "251022010300011118"
  },
  {
    "stage": "Shrimp on a plate-3",
    "Stakeholder/Custodian": "Consumer",
    "Unique ID": "AP5690960101010721",
    "parent_batch_id": "VAN3-PLATE-003",
    "Freshess": "Fresh/spoiled",
    "Smell": "Fresh/fishy/ammonia",
    "Appearance": "Good/Poor",
    "Texture": "Leathery/Smooth",
    "Black spots": "Yes/No",
    "Shape and size" : "Intact & Uniform",
    "Weight": "Correct/Incorrect",
    "Unique Blockchain ID": "251022010300002119",
    "Unique Secondary ID": "251022010300011119"
  },
{
    "stage": "Shrimp on a plate (Customer View)-1",
    "Stakeholder/Custodian": "Customer",
    "Unique ID": "AP5690860101010165",
    "parent_batch_id": "VAN3-Cus PLATE-003",
    "Customer Name": "",
    "Purchase Date": "",
    "Feedback Link": "",
    "Temperature at Delivery": "",
    "Unique Blockchain ID": "251022010300001011",
    "Unique Secondary ID": "251022010300002011"
  }

]

LINEAGE_P_MONODON = [
  {
    'stage': 'Broodstock Facility',
    'Stakeholder/Custodian': 'NBC/BMC/Brood Bank operator',
    'Unique ID': '301123200001010125',
    'NFDP Reg No': 'NFDP1002',
    'Facility Name': 'M/s CP SPF Foods Public Company Ltd.',
    'Address': 'Amphoe Laem Sing, Chanthaburi, Thailand',
    'Species': 'P. monodon',
    'Genetic selection': 'SPF',
    'Date of receipt': '2025-04-16 00:00:00',
    'DoF approved': 'Yes',
    'Quantity of broods': '380',
    'Size of broods (g)': '125',
    'Import': 'Yes',
    'Survival rate (%)': '88.7',
    'Quarantine': 'Yes',
    'Health certificate': 'WOAH listed diseases free',
    'Disease outbreak': 'None',
    'Disease mitigation protocol': 'Available',
    'Source': 'Domesticated',
    'Feeding regime': 'Standard',
    'SPF status': 'Verified',
    'Unique Blockchain ID': '251021020148959336',
    'Unique Secondary ID': '251021020183824383',
  },
  {
    'stage': 'Hatchery-Nursery',
    'Stakeholder/Custodian': 'Hatchery/Nursery operator',
    'Unique ID': 'TN5692382001010125',
    'NFDP Reg No': 'NFDP2002',
    'Broodstock supplier': 'M/s CP SPF Foods Public Company Ltd.',
    'DoF approved': 'Yes',
    'MPEDA enrolment': 'MPEDA5002',
    'Species': 'P. monodon',
    'Life stage': 'Broodstock',
    'Size of broods (g)': '125',
    'Quantity of broods (No.)': '380',
    'Import': 'Yes',
    'Quarantine': 'Yes',
    'Hatchery details': 'M/s. Vishal Aqua GLV Prawn',
    'Address': 'Bharathidasan street, Kanathur Reddikuppam, Thirupporur, Chengalpattu, Tamil Nadu',
    'Location (GPS coordinates)': '12.853136, 80.248843',
    'CAA approval': '56-9(238)/2024',
    'Capacity (PLs No.)': '2000000',
    'Seed production details (PLs No.)': '2000000',
    'Date': '2025-01-22 00:00:00',
    'PL age (days)': '20',
    'Gender': 'Mixed',
    'Genetic strain': 'SPF',
    'Survival rate of nauplii and PLs (%)': '89 and 45',
    'Larval tank size (MT)': '200',
    'Larval density (per L)': '100',
    'Use of probiotics': 'Yes',
    'Use of antibiotics': 'No',
    'Light logs': 'Standard',
    'Aeration logs': 'Standard',
    'Health certificate': 'WOAH listed diseases free',
    'Disease outbreak': 'None',
    'Disease mitigation protocol': 'Available',
    'Biosecurity measures': 'Yes',
    'Hatchery success rate (%)': '94',
    'Feed details': 'Starter feed',
    'Inputs': 'Bio-supplements',
    'Effluent treatment system (MT)': '28',
    'Certification': 'ICAR-CIBA verified',
    'Water quality': 'Temp 27.5°C, pH 7.7, DO 6 mg/L, Salinity 24 ppt',
    'Unique Blockchain ID': '251021020202900191',
    'Unique Secondary ID': '251021020238879790',
  },
  {
    'stage': 'Grow-out System-1',
    'Stakeholder/Custodian': 'Farmer/Farm owner',
    'Unique ID': 'TN5692382001010125',
    'NFDP Reg No': 'NFDP3002',
    'Farm Name': 'Selvaraj farm',
    'Address': 'Old No:4/268, New No:8/268, Veerankudikadu, South Poigainallur (PO), Nagapattinam, Tamil Nadu - 611111',
    'Owner': 'Selvaraj. K',
    'Location (GPS coordinates)': '10.703866, 79.826911',
    'CAA approval': 'TN-II 2022(2153)',
    'Farm size (ha)': '1.93',
    'Water spread area (ha)': '1.15',
    'Type of culture system': 'Traditional, Semi-intensive, Intensive, Super-Intensive',
    'Ponds (No.)': '4',
    'Species farmed': 'P. monodon',
    'PLs age': '20',
    'Stocking density': '10',
    'Date of stocking': '2025-02-03 00:00:00',
    'Feed': 'Pellet feed',
    'Inputs': 'Probiotics',
    'Water quality': 'Temp 29.5°C, pH 7.6, DO 5.8 mg/L',
    'Culture duration (days)': '125',
    'Survival rate (%)': '87',
    'Certification': 'ICAR-CIBA verified',
    'Disease outbreak': 'None',
    'Disease mitigation protocol': 'Available',
    'Biosecurity': 'Yes',
    'Unique Blockchain ID': '251021020370335984',
    'Unique Secondary ID': '251021020366811498',
  },
  {
    'stage': 'Production of feed & inputs-1',
    'Stakeholder/Custodian': 'Feed manufacturer/feed supplier/distributor',
    'Manufacturer Name': 'OceanFeed Ltd',
    'NFDP Reg No': 'NFDP4002',
    'Address': 'Kochi',
    'Feed Name': 'Larval, starter, grower',
    'Species targeted': 'P. monodon',
    'Ingredients': 'Fish meal, Soy protein',
    'Nutritional profile': 'Crude protein 35%; Fat 10%; Fibre 5%; Ash 15%; Moisture 11%',
    'FCR': '1.1 to 1.5',
    'Manufacture Date': '2025-02-05 00:00:00',
    'Expiry': '2025-05-04 00:00:00',
    'Quantity of feed available (Tonnes)': '50',
    'Batch No': 'B102',
    'Supplier': 'MarineBrood',
    'Certification': 'ISO, GMP, HACCP',
    'Unique ID': '251021020453033150',
    'Unique Blockchain ID': '251021020440332255',
    'Unique Secondary ID': '251021020484133556',
  },
  {
    'stage': 'Harvesting-1',
    'Stakeholder/Custodian': 'Farmer/Farm owner/Aggregator',
    'Unique ID': 'TN5692380101010125',
    'Harvesting Date': '2025-06-05 00:00:00',
    'Method': 'Drag net',
    'Duration (h)': '4',
    'Species': 'P. monodon',
    'Avg Body Weight (g)': '30',
    'Total production (Tonnes)': '3',
    'Partial harvesting': 'No',
    'Iced used & quality': 'Yes & good',
    'Unique Blockchain ID': '251021020586623019',
    'Unique Secondary ID': '251021020502497964',
  },
  {
    'stage': 'Aggregation/Trading at Farm Gate-1',
    'Stakeholder/Custodian': 'Aggregator/Trader',
    'Trade Date': '2025-06-06 00:00:00',
    'Aggregator': 'Chennai Shrimp Traders',
    'Species': 'P. monodon',
    'Quantity (Tonnes)': '24',
    'Ice used & quality': 'Yes & good',
    'Next custodian': 'Fresh Transport Pvt Ltd',
    'Grade wise quantity (Tonnes)': 'A - 20; B - 4',
    'Unique ID': 'TN5692380101010125',
    'Unique Blockchain ID': '251021020649541092',
    'Unique Secondary ID': '251021020695817214',
  },
  {
    'stage': 'Transportation-1',
    'Stakeholder/Custodian': 'Transporter/Cold chain operator',
    'Unique ID': 'TN5692380101010125',
    'Transporter': 'Fresh Transport Pvt Ltd',
    'Contact': '9444117051',
    'Type': 'Refrigerated Truck',
    'License': 'TRK124',
    'Vehicle ID': 'VH003',
    'Vehicle sanitation log': 'OK',
    'Vehicle capacity (Tonnes)': '20-30',
    'Weight transported (Tonnes)': '20; 30',
    'Name of the driver': 'Mr. Kandasamy',
    'Contact detail': '8056006399',
    'Diatance (km)': '325',
    'Duration (h)': '6',
    'Loading and unloading time (h)': '3',
    'GPS log': '12.9716, 80.2337',
    'Condition': 'Iced',
    'Temperature at packing': '4°C',
    'Temperature data logger': 'Yes',
    'Species': 'P. monodon',
    'Unique Blockchain ID': '251021020738606447',
    'Unique Secondary ID': '251021020799837186',
  },
  {
    'stage': 'Marketing-1',
    'Stakeholder/Custodian': 'Distributor/Wholesaler',
    'Unique ID': 'TN5692380101010125',
    'Name': 'Pattinapakkam Fish Market',
    'Address': 'Chennai',
    'GPS coordinate': '13.030356, 80.279230',
    'Contact': '9003142798',
    'Seller': 'Mixed',
    'Temperature': '4°C',
    'Stall type': 'Platform',
    'No. of stalls': '10',
    'Species': 'P. monodon',
    'Condition': 'Iced',
    'Hygiene': 'Yes',
    'Drainage facility': 'Yes',
    'Waste disposal': 'Yes',
    'Potable water facility': 'Yes',
    'Ice plant (No. & capacity)': '2; 10 tonnes',
    'e-Commerce': 'AquaMart',
    'Quantity sold (kg)': '50',
    'Buyer': 'Retailers',
    'Expiry/use-by date': '2025-06-20 00:00:00',
    'Unique Blockchain ID': '251021020882849624',
    'Unique Secondary ID': '251021020838877904',
  },
  {
    'stage': 'Processing (direct from farms)-1',
    'Stakeholder/Custodian': 'Processor',
    'Unique ID': 'TN5692380101010125',
    'Processing Plant': 'Oceanic Processors',
    'Address': 'Kochi',
    'Approval No': 'PL1235',
    'Capacity (Tonnes/day)': '2',
    'Processor credentials': 'Certified',
    'Date and Time of receipt': '2025-06-10 10:00:00',
    'Species': 'P. monodon',
    'Product type': 'IQF',
    'Temperature': '0-4°C',
    'Equipment': 'Freezers',
    'Packaging': 'Bulk',
    'Certification': 'HACCP',
    'Water availability': 'Yes',
    'Waste management': 'Yes',
    'Unique Blockchain ID': '251021020951193064',
    'Unique Secondary ID': '251021020968428447',
  },
  {
    'stage': 'Exporting-1',
    'Stakeholder/Custodian': 'Exporter',
    'Unique ID': 'TN5692380101010125',
    'Exporter': 'Global Shrimp Traders',
    'IEC Code': 'IEC5002',
    'Export mode': 'Sea',
    'Airline': '',
    'Place of embarkation/disembarkation': '',
    'Shipping liner name': 'COSCO',
    'Country of loading and unloading': 'India and China',
    'Date and time': '2025-05-30 06:00:00',
    'Transport duration (days)': '15',
    'Container size (Tonnes)': '25',
    'Temperature': '-18°C',
    'Species': 'P. monodon',
    'Category': 'Ready-to-cook',
    'ITC-HS Code': '30617',
    'Certification': 'ICAR-CIBA, EIC, Phytosanitary, BIS, SHAPHARI, FSSAI, HACCP, CATCH IT, ASC, BAP, Global GAP, GAA, GDST, ICCAT, DS 2031, CoO, Non-radioactivity',
    'Unique Blockchain ID': '251021021011479375',
    'Unique Secondary ID': '251021021063138583',
  },
  {
    'stage': 'Retailing-1',
    'Stakeholder/Custodian': 'Retailer/E-commerce vendor',
    'Unique ID': 'TN5692380101010125',
    'Retailer Name': 'BlueRetail',
    'Address': 'Kochi',
    'Contact': '9876523450',
    'Temperature': '4°C',
    'Product category': 'Ready-to-cook',
    'e-Commerce': 'SeaMart',
    'Quantity sold (kg)': '15',
    'Buyer': 'Consumers',
    'Expiry date': '2025-07-05 00:00:00',
    'Unique Blockchain ID': '251021021141838943',
    'Unique Secondary ID': '251021021121329566',
  },
  {
    'stage': 'Shrimp on a plate-1',
    'Stakeholder/Custodian': 'Consumer',
    "Freshess": "Fresh/spoiled",
    "Smell": "Fresh/fishy/ammonia",
    "Appearance": "Good/Poor",
    "Texture": "Leathery/Smooth",
    "Black spots": "Yes/No",
    "Shape and size" : "Intact & Uniform",
    "Weight": "Correct/Incorrect",

    'Unique ID': '251021021270024594',
    'Unique Blockchain ID': '251021021238105860',
    'Unique Secondary ID': '251021021280253139',
  },
  {
    'stage': 'Shrimp on a plate (Customer View)-1',
    'Stakeholder/Custodian': 'Customer',
    'Customer Name': '',
    'Purchase Date': '',
    'Feedback Link': '',
    'Temperature at Delivery': '',
    'Unique ID': '251021021351147728',
    'Unique Blockchain ID': '251021021348555183',
    'Unique Secondary ID': '251021021308086841',
  },
  {
    'stage': 'Grow-out System-2',
    'Stakeholder/Custodian': 'Farmer/Farm owner',
    'Unique ID': 'AP2301020101012025',
    'NFDP Reg No': 'NFDP7001',
    'Farm Name': 'GreenHarvest Aqua Farm',
    'Address': 'Thotapalli Village, Nellore, Andhra Pradesh',
    'Owner': 'K. Ramesh',
    'Location (GPS coordinates)': '14.4031, 79.9914',
    'CAA approval': 'AP-III/2025(1572)',
    'Farm size (ha)': '2.8',
    'Water spread area (ha)': '2.1',
    'Type of culture system': 'Traditional, Semi-intensive, Intensive, Super-Intensive',
    'Ponds (No.)': '5',
    'Species farmed': 'P. monodon',
    'PLs age': '18',
    'Stocking density': '80',
    'Date of stocking': '2025-03-10 00:00:00',
    'Feed': 'Commercial pellet feed',
    'Inputs': 'Probiotics, molasses',
    'Water quality': 'Temp 30°C, pH 7.6, DO 5.9 mg/L',
    'Culture duration (days)': '120',
    'Survival rate (%)': '86',
    'Certification': 'ICAR-CIBA verified',
    'Disease outbreak': 'None',
    'Disease mitigation protocol': 'Available',
    'Biosecurity': 'Yes',
    'Unique Blockchain ID': '251021020370335970',
    'Unique Secondary ID': '251021020366811471',
  },
  {
    'stage': 'Production of feed & inputs-2',
    'Stakeholder/Custodian': 'Feed manufacturer/feed supplier/distributor',
    'Manufacturer Name': 'AquaNutra Feed Mills',
    'NFDP Reg No': 'NFDP8001',
    'Address': 'Gudur, Nellore District',
    'Feed Name': 'Vannamei grower feed',
    'Species targeted': 'P. monodon',
    'Ingredients': 'Fish meal, soya protein, wheat flour',
    'Nutritional profile': 'Crude Protein 38%; Fat 7%; Fibre 5%; Moisture 10%',
    'FCR': '1.1 to 1.5',
    'Manufacture Date': '2025-03-05 00:00:00',
    'Expiry': '2025-06-05 00:00:00',
    'Quantity of feed available (Tonnes)': '70',
    'Batch No': 'BW3025',
    'Supplier': 'AquaSupply Pvt. Ltd.',
    'Certification': 'ISO, GMP, HACCP',
    'Unique ID': 'AP2301020101012025',
    'Unique Blockchain ID': '251021020440332273',
    'Unique Secondary ID': '251021020484133574',
  },
  {
    'stage': 'Harvesting-2',
    'Stakeholder/Custodian': 'Farmer/Farm owner/Aggregator',
    'Unique ID': 'AP2301020101012025',
    'Harvesting Date': '2025-07-10 00:00:00',
    'Method': 'Cast net',
    'Duration (h)': '5',
    'Species': 'P. monodon',
    'Avg Body Weight (g)': '25',
    'Total production (Tonnes)': '3.5',
    'Partial harvesting': 'No',
    'Iced used & quality': 'Yes & good',
    'Unique Blockchain ID': '251021020586623075',
    'Unique Secondary ID': '251021020502497976',
  },
  {
    'stage': 'Aggregation/Trading at Farm Gate-2',
    'Stakeholder/Custodian': 'Aggregator/Trader',
    'Trade Date': '2025-07-10 00:00:00',
    'Aggregator': 'Coastal Aqua Traders',
    'Species': 'P. monodon',
    'Quantity (Tonnes)': '3.5',
    'Ice used & quality': 'Yes & good',
    'Next custodian': 'BlueOcean Logistics',
    'Grade wise quantity (Tonnes)': 'A-2.5; B-1',
    'Unique ID': 'AP2301020101012025',
    'Unique Blockchain ID': '251021020649541077',
    'Unique Secondary ID': '251021020695817278',
  },
  {
    'stage': 'Transportation-2',
    'Stakeholder/Custodian': 'Transporter/Cold chain operator',
    'Unique ID': 'AP2301020101012025',
    'Transporter': 'BlueOcean Logistics',
    'Contact': '9445899632',
    'Type': 'Refrigerated Truck',
    'License': 'TRK240',
    'Vehicle ID': 'VH008',
    'Vehicle sanitation log': 'OK',
    'Vehicle capacity (Tonnes)': '10-20',
    'Weight transported (Tonnes)': '10; 20',
    'Name of the driver': 'Narasimulu',
    'Contact detail': '8056116399',
    'Diatance (km)': '300',
    'Duration (h)': '7',
    'Loading and unloading time (h)': '4',
    'GPS log': '13.0827, 80.2707',
    'Condition': 'Iced',
    'Temperature at packing': '4°C',
    'Temperature data logger': 'Yes',
    'Species': 'P. monodon',
    'Unique Blockchain ID': '251021020738606479',
    'Unique Secondary ID': '251021020799837180',
  },
  {
    'stage': 'Marketing-2',
    'Stakeholder/Custodian': 'Distributor/Wholesaler',
    'Unique ID': 'AP2301020101012025',
    'Name': 'Nellore Coastal Fish Market',
    'Address': 'Nellore, Andhra Pradesh',
    'GPS coordinate': '14.4286, 80.1025',
    'Contact': '9445899632',
    'Seller': 'Mixed',
    'Temperature': '4°C',
    'Stall type': 'Platform',
    'No. of stalls': '8',
    'Species': 'P. monodon',
    'Condition': 'Iced',
    'Hygiene': 'Yes',
    'Drainage facility': 'Yes',
    'Waste disposal': 'Yes',
    'Potable water facility': 'Yes',
    'Ice plant (No. & capacity)': '2; 8 tonnes',
    'e-Commerce': 'AquaFreshMart',
    'Quantity sold (kg)': '50',
    'Buyer': 'Retailers',
    'Expiry/use-by date': '2025-07-26 00:00:00',
    'Unique Blockchain ID': '251021020882849681',
    'Unique Secondary ID': '251021020838877982',
  },
  {
    'stage': 'Processing (direct from farms)-2',
    'Stakeholder/Custodian': 'Processor',
    'Unique ID': 'AP7894560202020256',
    'Processing Plant': 'Coastal Aqua Exports',
    'Address': 'Nellore, Andhra Pradesh',
    'Approval No': 'NL4589',
    'Capacity (Tonnes/day)': '2',
    'Processor credentials': 'Certified',
    'Date and Time of receipt': '2025-06-15 11:30:00',
    'Species': 'P. monodon',
    'Product type': 'IQF (Individually Quick Frozen)',
    'Temperature': '0-4°C',
    'Equipment': 'Freezers',
    'Packaging': 'Bulk',
    'Certification': 'HACCP',
    'Water availability': 'Yes',
    'Waste management': 'Yes',
    'Unique Blockchain ID': '251021020951193083',
    'Unique Secondary ID': '251021020968428484',
  },
  {
    'stage': 'Exporting-2',
    'Stakeholder/Custodian': 'Exporter',
    'Unique ID': 'AP7894560202020256',
    'Exporter': 'Nellore Aqua Exports',
    'IEC Code': 'IEC6025',
    'Export mode': 'Sea',
    'Airline': '',
    'Place of embarkation/disembarkation': '',
    'Shipping liner name': 'Maersk Line',
    'Country of loading and unloading': 'India and Japan',
    'Date and time': '2025-06-05 07:30:00',
    'Transport duration (days)': '18',
    'Container size (Tonnes)': '28',
    'Temperature': '-18°C',
    'Species': 'P. monodon',
    'Category': 'Ready-to-cook',
    'ITC-HS Code': '50982',
    'Certification': 'ICAR-CIBA, EIC, Phytosanitary, BIS, SHAPHARI, FSSAI, HACCP, CATCH IT, ASC, BAP, Global GAP, GAA, GDST, ICCAT, DS 2031, CoO, Non-radioactivity',
    'Unique Blockchain ID': '251021021011479385',
    'Unique Secondary ID': '251021021063138586',
  },
  {
    'stage': 'Retailing-2',
    'Stakeholder/Custodian': 'Retailer/E-commerce vendor',
    'Unique ID': 'AP230102010202025',
    'Retailer Name': 'Coastal Fresh Mart',
    'Address': 'Nellore',
    'Contact': '9012345678',
    'Temperature': '5°C',
    'Product category': 'Ready-to-cook',
    'e-Commerce': 'AquaDelight',
    'Quantity sold (kg)': '20',
    'Buyer': 'Consumers',
    'Expiry date': '2025-07-15 00:00:00',
    'Unique Blockchain ID': '251021021141838987',
    'Unique Secondary ID': '251021021121329588',
  },
  {
    'stage': 'Shrimp on a plate-2',
    'Stakeholder/Custodian': 'Consumer',
    "Freshess": "Fresh/spoiled",
    "Smell": "Fresh/fishy/ammonia",
    "Appearance": "Good/Poor",
    "Texture": "Leathery/Smooth",
    "Black spots": "Yes/No",
    "Shape and size" : "Intact & Uniform",
    "Weight": "Correct/Incorrect",

    'Unique ID': '251021021270024593',
    'Unique Blockchain ID': '251021021238105889',
    'Unique Secondary ID': '251021021280253190',
  },
  {
    'stage': 'Shrimp on a plate (Customer View)-2',
    'Stakeholder/Custodian': 'Customer',
    'Customer Name': '',
    'Purchase Date': '',
    'Feedback Link': '',
    'Temperature at Delivery': '',
    'Unique ID': '251021021351147794',
    'Unique Blockchain ID': '251021021348555191',
    'Unique Secondary ID': '251021021308086892',
  },
  {
    'stage': 'Grow-out System-3',
    'Stakeholder/Custodian': 'Farmer/Farm owner',
    'Unique ID': 'TN5692382001010456',
    'NFDP Reg No': 'NFDP3002',
    'Farm Name': 'M/s BlueWave Aqua Hatchery',
    'Address': 'No. 12, Kattukuppam Road, Chidambaram, Cuddalore District, Tamil Nadu – 608001',
    'Owner': 'Ramesh K',
    'Location (GPS coordinates)': '11.420123, 79.695432',
    'CAA approval': 'TN-II 2023(1245)',
    'Farm size (ha)': '2.1',
    'Water spread area (ha)': '2',
    'Type of culture system': 'Traditional, Semi-intensive, Intensive, Super-Intensive',
    'Ponds (No.)': '5',
    'Species farmed': 'P. monodon',
    'PLs age': '25',
    'Stocking density': '12',
    'Date of stocking': '2025-03-12 00:00:00',
    'Feed': 'Pellet feed',
    'Inputs': 'Probiotics, Bio-supplements',
    'Water quality': 'Temp 28°C, pH 7.8, DO 6.2 mg/L, Salinity 23 ppt',
    'Culture duration (days)': '120',
    'Survival rate (%)': '95',
    'Certification': 'ICAR-CIBA verified',
    'Disease outbreak': 'WOAH listed diseases free',
    'Disease mitigation protocol': 'Available',
    'Biosecurity': 'Yes',
    'Unique Blockchain ID': '251021020370335955',
    'Unique Secondary ID': '251021020366811456',
  },
  {
    'stage': 'Production of feed & inputs-3',
    'Stakeholder/Custodian': 'Feed manufacturer/feed supplier/distributor',
    'Manufacturer Name': 'AquaNutri Pvt. Ltd.',
    'NFDP Reg No': 'NFDP4005',
    'Address': 'Chennai, Tamil Nadu',
    'Feed Name': 'Larval, starter',
    'Species targeted': 'P. monodon',
    'Ingredients': 'Fish meal, Wheat flour, Soy protein',
    'Nutritional profile': 'Crude Protein: 38%, Fat: 9%, Fibre: 4%, Ash: 12%,',
    'FCR': '1.1 to 1.5',
    'Manufacture Date': '2025-10-03 00:00:00',
    'Expiry': '05-05-2025 00:00:00',
    'Quantity of feed available (Tonnes)': '12',
    'Batch No': 'LN101',
    'Supplier': 'CoastalBrood',
    'Certification': 'ISO, HACCP',
    'Unique ID': 'TN5692382001010456',
    'Unique Blockchain ID': '251021020440332292',
    'Unique Secondary ID': '251021020484133593',
  },
  {
    'stage': 'Harvesting-3',
    'Stakeholder/Custodian': 'Farmer/Farm owner/Aggregator',
    'Unique ID': 'TN5692380101010125',
    'Harvesting Date': '2025-05-06 00:00:00',
    'Method': 'Drag net',
    'Duration (h)': '4',
    'Species': 'P. monodon',
    'Avg Body Weight (g)': '30',
    'Total production (Tonnes)': '3',
    'Partial harvesting': 'No',
    'Iced used & quality': 'Yes & good',
    'Unique Blockchain ID': '251021020586623025',
    'Unique Secondary ID': '251021020502497926',
  },
  {
    'stage': 'Aggregation/Trading at Farm Gate-3',
    'Stakeholder/Custodian': 'Aggregator/Trader',
    'Trade Date': '2025-06-08 00:00:00',
    'Aggregator': 'Cooum Shrimp Traders',
    'Species': 'P. monodon',
    'Quantity (Tonnes)': '35',
    'Ice used & quality': 'Yes & good',
    'Next custodian': 'Southern Marine Transport Pvt Ltd',
    'Grade wise quantity (Tonnes)': 'A - 20; B - 15',
    'Unique ID': 'TN5692380101010131',
    'Unique Blockchain ID': '251021020649541035',
    'Unique Secondary ID': '251021020695817236',
  },
  {
    'stage': 'Transportation-3',
    'Stakeholder/Custodian': 'Transporter/Cold chain operator',
    'Unique ID': 'TN5692380101010134',
    'Transporter': 'Bayline Transport Pvt Ltd',
    'Contact': '9444223344',
    'Type': 'Refrigerated Van',
    'License': 'TRK256',
    'Vehicle ID': 'VH007',
    'Vehicle sanitation log': 'OK',
    'Vehicle capacity (Tonnes)': '25-35',
    'Weight transported (Tonnes)': '25; 35',
    'Name of the driver': 'Mr. Ramesh',
    'Contact detail': '8056123456',
    'Diatance (km)': '350',
    'Duration (h)': '7',
    'Loading and unloading time (h)': '4',
    'GPS log': '12.9876, 80.2456',
    'Condition': 'Iced',
    'Temperature at packing': '4°C',
    'Temperature data logger': 'Yes',
    'Species': 'P. monodon',
    'Unique Blockchain ID': '251021020738606489',
    'Unique Secondary ID': '251021020799837190',
  },
  {
    'stage': 'Marketing-3',
    'Stakeholder/Custodian': 'Distributor/Wholesaler',
    'Unique ID': 'TN5692380101010137',
    'Name': 'Marina Fish Market',
    'Address': 'Chennai',
    'GPS coordinate': '13.045678, 80.285432',
    'Contact': '9003123456',
    'Seller': 'Mixed',
    'Temperature': '4°C',
    'Stall type': 'Platform',
    'No. of stalls': '12',
    'Species': 'P. monodon',
    'Condition': 'Iced',
    'Hygiene': 'Yes',
    'Drainage facility': 'Yes',
    'Waste disposal': 'Yes',
    'Potable water facility': 'Yes',
    'Ice plant (No. & capacity)': '3; 12 tonnes',
    'e-Commerce': 'SeaFresh',
    'Quantity sold (kg)': '55',
    'Buyer': 'Retailers & Wholesalers',
    'Expiry/use-by date': '2025-06-21 00:00:00',
    'Unique Blockchain ID': '251021020882849623',
    'Unique Secondary ID': '251021020838877903',
  },
  {
    'stage': 'Processing (direct from farms)-3',
    'Stakeholder/Custodian': 'Processor',
    'Unique ID': 'TN5692380101010142',
    'Processing Plant': 'Coastal Shrimp Processors',
    'Address': 'Chennai, Tamil Nadu',
    'Approval No': 'PL1265',
    'Capacity (Tonnes/day)': '4',
    'Processor credentials': 'Certified, HACCP',
    'Date and Time of receipt': '2025-06-13 08:45:00',
    'Species': 'P. monodon',
    'Product type': 'IQF',
    'Temperature': '0-4°C',
    'Equipment': 'Freezers',
    'Packaging': 'Bulk',
    'Certification': 'HACCP',
    'Water availability': 'Yes',
    'Waste management': 'Yes',
    'Unique Blockchain ID': '251021020951193072',
    'Unique Secondary ID': '251021020968428473',
  },
  {
    'stage': 'Exporting-3',
    'Stakeholder/Custodian': 'Exporter',
    'Unique ID': 'TN5692380101010143',
    'Exporter': 'Coastal Aqua Traders',
    'IEC Code': 'IEC5005',
    'Export mode': 'Sea',
    'Airline': '',
    'Place of embarkation/disembarkation': '',
    'Shipping liner name': 'MAERSK',
    'Country of loading and unloading': 'India, Singapore',
    'Date and time': '2025-05-31 07:00:00',
    'Transport duration (days)': '12',
    'Container size (Tonnes)': '20',
    'Temperature': '-18°C',
    'Species': 'P. monodon',
    'Category': 'Ready-to-cook',
    'ITC-HS Code': '30625',
    'Certification': 'ICAR-CIBA, EIC, Phytosanitary, BIS, FSSAI, HACCP, ASC, BAP, Global GAP',
    'Unique Blockchain ID': '251021021011479329',
    'Unique Secondary ID': '251021021063138530',
  },
  {
    'stage': 'Retailing-3',
    'Stakeholder/Custodian': 'Retailer/E-commerce vendor',
    'Unique ID': 'TN5692380101010146',
    'Retailer Name': 'Marina Shrimp Retail',
    'Address': 'Chennai, Tamil Nadu',
    'Contact': '9876523450',
    'Temperature': '4°C',
    'Product category': 'Ready-to-cook',
    'e-Commerce': 'AquaMart',
    'Quantity sold (kg)': '20',
    'Buyer': 'Consumers',
    'Expiry date': '2025-05-08 00:00:00',
    'Unique Blockchain ID': '251021021141838945',
    'Unique Secondary ID': '251021021121329546',
  },
  {
    'stage': 'Shrimp on a plate-3',
    'Stakeholder/Custodian': 'Consumer',
    "Freshess": "Fresh/spoiled",
    "Smell": "Fresh/fishy/ammonia",
    "Appearance": "Good/Poor",
    "Texture": "Leathery/Smooth",
    "Black spots": "Yes/No",
    "Shape and size" : "Intact & Uniform",
    "Weight": "Correct/Incorrect",

    'Unique ID': '251021021270024573',
    'Unique Blockchain ID': '251021021238105878',
    'Unique Secondary ID': '251021021280253179',
  },
  {
    'stage': 'Shrimp on a plate (Customer View)-3',
    'Stakeholder/Custodian': 'Customer',
    'Customer Name': '',
    'Purchase Date': '',
    'Feedback Link': '',
    'Temperature at Delivery': '',
    'Unique ID': '251021021351147763',
    'Unique Blockchain ID': '251021021348555183',
    'Unique Secondary ID': '251021021308086841',
  }
]

# ------------------ P. indicus Sample Lineage (Nellore Project) ------------------
# ------------------ P. indicus Sample Lineage (Nellore Project) ------------------
LINEAGE_P_INDICUS = [
  {
    "stage": "Broodstock Facility",
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "301125300001010125",
    "NFDP Reg No": "NFDP4001",
    "Facility Name": "OceanGene Broodstock Center",
    "Address": "Survey No. 47/2, Krishnapatnam, SPSR Nellore, A.P.",
    "Species": "Penaeus indicus",
    "Genetic selection": "Third generation SPF line",
    "Date of receipt": "2025-01-10 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods": "180",
    "Size of broods (g)": "45",   
    "Import": "Kuwait Broodstock Pvt. Ltd.",
    "Survival rate (%)": "93",
    "Quarantine": "10 days, freshwater treatment",
    "Health certificate": "MPEDA/HC/IND/2025/014",
    "Disease outbreak": "None observed",
    "Disease mitigation protocol": "Regular PCR screening",
    "Source": "SPF Institute, Kuwait",
    "Feeding regime": "Polychaete + formulated feed",
    "SPF status": "Verified SPF line",
    "Unique Blockchain ID": "251021030100101001",
    "Unique Secondary ID": "251021030200202001"
  },
  {
    "stage": "Hatchery/Nursery",
    "Stakeholder/Custodian": "Hatchery/Nursery operator",
    "Unique ID": "AP5693054001010125",
    "parent_batch_id": "INDI1-HAT-001",
    "NFDP Reg No": "NFDP4002",
    "Broodstock supplier": "OceanGene Broodstock Center",
    "DoF approved": "Yes",
    "MPEDA enrolment": "MPEDA-HAT-AP-209",
    "Species": "P. indicus",
    "Life stage": "PL12",
    "Size of broods (g)": "0.05",
    "Quantity of broods (No.)": "180000",
    "Import": "Local from Nellore",
    "Quarantine": "48 hrs pre-stocking",
    "Hatchery details": "10 tanks of 10 MT each",
    "Address": "Muthukur, Nellore",
    "Location (GPS coordinates)": "14.410300N,80.124500E",
    "CAA approval": "HATCH-AP-3021",
    "Capacity (PLs No.)": "2000000",
    "Seed production details (PLs No.)": "Batch IND-HAT-25",
    "Date": "2025-02-02 00:00:00",
    "PL age (days)": "12",
    "Gender": "Mixed",
    "Genetic strain": "SPF 3rd generation",
    "Survival rate of nauplii and PLs (%)": "87",
    "Larval tank size (MT)": "10",
    "Larval density (per L)": "90",
    "Use of probiotics": "Yes",
    "Use of antibiotics": "No",
    "Light logs": "16/8 photoperiod",
    "Aeration logs": "Continuous blower",
    "Health certificate": "MPEDA/HC/IND/2025/021",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Chlorination + UV sterilization",
    "Biosecurity measures": "Footbath + net disinfection",
    "Hatchery success rate (%)": "88",
    "Feed details": "Artemia + commercial micro diet",
    "Inputs": "Seawater filtered + ozone",
    "Effluent treatment system (MT)": "5",
    "Certification": "MPEDA certified",
    "Water quality": "29°C,28 ppt salinity",
    "Unique Blockchain ID": "251021030100101002",
    "Unique Secondary ID": "251021030200202002"
  },
  {
    "stage": "Grow-out System-1",
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TN5693054002010125",
    "parent_batch_id": "INDI1-GROW-001",
    "NFDP Reg No": "NFDP4003",
    "Farm Name": "AquaCare Grow-out Farm",
    "Address": "Venkatachalam, Nellore",
    "Owner": "K. Suresh",
    "Location (GPS coordinates)": "14.417500N,80.034200E",
    "CAA approval": "FARM-AP-3012",
    "Farm size (ha)": "1.2",
    "Water spread area (ha)": "1.0",
    "Type of culture system": "Traditional, Semi-intensive, Intensive, Super-Intensive",
    "Ponds (No.)": "3",
    "Species farmed": "P. indicus",
    "PLs age (days)": "12",
    "Stocking density (per sq. mt.)": "120",
    "Date of stocking": "2025-02-15 00:00:00",
    "Feed": "Avanti Feeds CP 38%",
    "Inputs": "Lime, probiotics, molasses",
    "Water quality": "28-30°C,25 ppt",
    "Culture duration (days)": "100",
    "Survival rate (%)": "85",
    "Certification": "CAA Certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Biofloc & EM application",
    "Biosecurity": "Perimeter fencing, bird nets",
    "Unique Blockchain ID": "251021030100101003",
    "Unique Secondary ID": "251021030200202003"
  },
  {
    "stage": "Production of feed & inputs-1",
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "TN5693054112010125",
    "parent_batch_id": "INDI1-PROW-001",
    "NFDP Reg No": "NFDP4004",
    "Address": "APIIC Industrial Park, Nellore",
    "Feed Name": "Avanti Marine Gold 38%",
    "Species targeted": "P. indicus,P. monodon",
    "Ingredients": "Fishmeal,soybean,wheat,binder",
    "FCR": "1.1 to 1.5",
    "Manufacture Date": "2025-02-12 00:00:00",
    "Expiry date": "2026-02-12 00:00:00",
    "Quantity of feed available (Tonnes)": "0.5",
    "Nutritional profile": "CP 38%, Fat 7%, Fiber 4%",
    "Batch No": "FEED_IND_NL25",
    "Supplier": "Coastal Aqua Distributors",
    "Certification": "MPEDA Feed Certified",
    "Unique Blockchain ID": "251021030100101004",
    "Unique Secondary ID": "251021030200202004"
  },
  {
    "stage": "Harvesting-1",
    "Stakeholder/Custodian": "Farmer/Farm owner/Aggregator",
    "Unique ID": "TN5693054004010125",
    "parent_batch_id": "INDI1-HARV-001",
    "Harvesting Date": "2025-05-25 00:00:00",
    "Method": "Cast net & drain harvesting",
    "Duration (h)": "6",
    "Species": "P. indicus",
    "Avg Body Weight (g)": "26",
    "Total production (Tonnes)": "1.42",
    "Partial harvesting": "No",
    "Iced used & quality": "250 kg flake ice, potable water",
    "Unique Blockchain ID": "251021030100101005",
    "Unique Secondary ID": "251021030200202005"
  },
  {
    "stage": "Aggregation/Trading at Farm Gate-1",
    "Stakeholder/Custodian": "Aggregator/Trader",
    "Unique ID": "TN5693054005010125",
    "parent_batch_id": "INDI1-AGG-001",
    "Trade Date": "2025-05-26 00:00:00",
    "Aggregator": "Sri Aqua Traders",
    "Species": "P. indicus",
    "Quantity (Tonnes)": "1.38",
    "Ice used & quality": "Yes & good",
    "Next custodian": "SeaHarvest Processing Unit",
    "Grade wise quantity (Tonnes)": "60-70 count:0.9,71-90 count:0.48",
    "Unique Blockchain ID": "251021030100101006",
    "Unique Secondary ID": "251021030200202006"
  },
  {
    "stage": "Transportation-1",
    "Stakeholder/Custodian": "Transporter/Cold chain operator",
    "Unique ID": "TN5693054006010125",
    "parent_batch_id": "INDI1-TRANS-001",
    "Transporter": "AquaTrans Logistics",
    "Contact": "9876543210",
    "Truck type": "Refrigerated (3T)",
    "Transport license": "AP-TL-2209",
    "Vehicle ID": "AP27 AQ 4502",
    "Vehicle sanitation log": "OK",
    "Vehicle capacity (Tonnes)": "3",
    "Weight transported (Tonnes)": "1.38",
    "Name of the driver": "R. Venkatesh",
    "Contact detail": "9998855544",
    "Distance (km)": "45",
    "Duration (h)": "1.5",
    "Loading and unloading time (h)": "0.5",
    "GPS log": "Enabled",
    "Condition": "Excellent",
    "Temperature at packing": "-2°C",
    "Temperature data logger": "Yes",
    "Species": "P. indicus",
    "Unique Blockchain ID": "251021030100101007",
    "Unique Secondary ID": "251021030200202007"
  },
  {
    "stage": "Marketing-1",
    "Stakeholder/Custodian": "Distributor/Wholesaler",
    "Unique ID": "TN5693054007010125",
    "parent_batch_id": "INDI1-MARK-001",
    "Name": "Coastal Marketing Agency",
    "Address": "Kavali, Nellore",
    "GPS coordinate": "14.9112N,79.9941E",
    "Contact": "9003114455",
    "Seller": "SeaHarvest Processing Unit",
    "Temperature": "-18°C",
    "Stall type": "Enclosed cold room",
    "No. of stalls": "4",
    "Species": "P. indicus",
    "Condition": "Frozen",
    "Hygiene": "Yes",
    "Drainage facility": "Yes",
    "Waste disposal": "Yes",
    "Potable water facility": "Yes",
    "Ice plant (No. & capacity)": "1 unit,3T/day",
    "e-Commerce": "Linked to FreshWave portal",
    "Quantity sold (kg)": "1240",
    "Buyer": "BlueOcean Exports Pvt. Ltd.",
    "Expiry/use-by date": "2026-05-25 00:00:00",
    "Unique Blockchain ID": "251021030100101008",
    "Unique Secondary ID": "251021030200202008"
  },
  {
    "stage": "Processing (direct from farms)-1",
    "Stakeholder/Custodian": "Processor",
    "Unique ID": "TN5693054008010125",
    "parent_batch_id": "INDI1-PROC-001",
    "Processing Plant": "SeaHarvest Processing Unit",
    "Address": "SPSR Nellore Industrial Zone",
    "Approval No": "MPEDA-AP-122",
    "Capacity (Tonnes/day)": "5",
    "Processor credentials": "HACCP,BRC certified",
    "Date and Time of receipt": "2025-06-03 10:00:00",
    "Species": "P. indicus",
    "Product type": "IQF P&D tail-on",
    "Temperature": "-20°C",
    "Equipment": "IQF Tunnel",
    "Packaging": "Vacuum sealed",
    "Certification": "MPEDA certified",
    "Water availability": "Yes",
    "Waste management": "Yes",
    "Unique Blockchain ID": "251021030100101009",
    "Unique Secondary ID": "251021030200202009"
  },
  {
    "stage": "Exporting-1",
    "Stakeholder/Custodian": "Exporter",
    "Unique ID": "TN5693054009010125",
    "parent_batch_id": "INDI1-EXP-001",
    "Exporter": "BlueOcean Exports Pvt. Ltd.",
    "IEC Code": "1002093388",
    "Export mode": "Sea",
    "Airline": "",
    "Place of embarkation/disembarkation": "Krishnapatnam / Tokyo",
    "Shipping liner name": "Evergreen Marine",
    "Country of loading and unloading": "India / Japan",
    "Date and time": "2025-06-12 19:00:00",
    "Transport duration (days)": "11",
    "Container size (Tonnes)": "20",
    "Temperature": "-18°C",
    "Species": "P. indicus",
    "Category": "Frozen seafood",
    "ITC-HS Code": "03061710",
    "Certification": "EIC, MPEDA export certified",
    "Unique Blockchain ID": "251021030100101010",
    "Unique Secondary ID": "251021030200202010"
  },
  { 
    "stage": "Retailing-1",
    "Stakeholder/Custodian": "Retailer/E-commerce vendor",
    "Unique ID": "TN5693054010010125",
    "parent_batch_id": "INDI1-RET-001",
    "Retailer Name": "FreshWave Seafoods",
    "Address": "Venkatagiri,Nellore",
    "Contact": "9944112233",
    "Temperature": "-18°C",
    "Product category": "Ready-to-cook frozen shrimp",
    "e-Commerce": "Available on FreshWave App",
    "Quantity sold (kg)": "800",
    "Buyer": "BayView Seafood Grill",
    "Expiry date": "2026-06-12 00:00:00",
    "Unique Blockchain ID": "251021030100101011",
    "Unique Secondary ID": "251021030200202011"
  },
  {
    "stage": "Shrimp on a plate-1",
    "Stakeholder/Custodian": "Consumer / Restaurant",
    "Unique ID": "TN5693054011010125",
    "parent_batch_id": "INDI1-PLATE-001",
    "Feedback": "Excellent taste and texture, clearly marked as Nellore origin.",
    "Unique Blockchain ID": "251021030100101012",
    "Unique Secondary ID": "251021030200202012"
  },
  {
    "stage": "Shrimp on a plate (Customer View)-1",
    "Stakeholder/Custodian": "End Customer",
    "Unique ID": "AP5643054012010125",
    "Customer Name": "A. Pradeep",
    "Purchase Date": "2025-07-05 00:00:00",
    "Feedback Link": "https://freshwave.example/feedback/IND001",
    "Temperature at Delivery": "",
    "Unique Blockchain ID": "251021030100101013",
    "Unique Secondary ID": "251021030200202013"
  },
  {
    "stage": "Grow-out System-2",
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "AP5697054002010125",
    "parent_batch_id": "INDI2-GROW-002",
    "NFDP Reg No": "NFDP4403",
    "Farm Name": "Nellore Grow-out Farm",
    "Address": "Naidupeta,Nellore",
    "Owner": "S. Ramesh",
    "Location (GPS coordinates)": "10.760000N,79.850000E",
    "CAA approval": "FARM-TN-4002",
    "Farm size (ha)": "1.5",
    "Water spread area (ha)": "1.2",
    "Type of culture system": "Traditional, Semi-intensive, Intensive, Super-Intensive",
    "Ponds (No.)": "4",
    "Species farmed": "P. indicus",
    "PLs age (days)": "12",
    "Stocking density (per sq. mt.)": "120",
    "Date of stocking": "2025-05-22 00:00:00",
    "Feed": "Avanti Feeds CP 38%",
    "Inputs": "Lime, probiotics, molasses",
    "Water quality": "28-30°C, 28 ppt",
    "Culture duration (days)": "100",
    "Survival rate (%)": "85",
    "Certification": "CAA Certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Biofloc & EM application",
    "Biosecurity": "Perimeter fencing, bird nets",
    "Unique Blockchain ID": "251021070100101003",
    "Unique Secondary ID": "251021070200202003"
  },
  {
    "stage": "Production of feed & inputs-2",
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "AP5690960251010256",
    "parent_batch_id": "INDI2-PROW-002",
    "NFDP Reg No": "NFDP4404",
    "Address": "Podili,Nellore",
    "Feed Name": "Avanti Marine Premium 40%",
    "Species targeted": "P. indicus,P. monodon",
    "Ingredients": "Fishmeal, soybean, wheat, binder",
    "Nutritional profile": "CP 40%, Fat 7%, Fiber 3%",
    "FCR": "1.1 to 1.5",
    "Manufacture Date": "2025-05-25 00:00:00",
    "Expiry date": "2026-06-12 00:00:00",
    "Quantity of feed available (Tonnes)": "1",
    "Batch No": "FEED_TN_NP25",
    "Supplier": "Coastal Aqua Distributors",
    "Certification": "MPEDA Feed Certified",
    "Unique Blockchain ID": "251021070100101004",
    "Unique Secondary ID": "251021070200202004"
  },
  {
    "stage": "Harvesting-2",
    "Stakeholder/Custodian": "Farmer/Farm owner/Aggregator",
    "Unique ID": "TN5697054004010125",
    "parent_batch_id": "INDI2-HARV-002",
    "Harvesting Date": "2025-06-28 00:00:00",
    "Method": "Cast net & drain harvesting",
    "Duration (h)": "6",
    "Species": "P. indicus",
    "Avg Body Weight (g)": "30",
    "Total production (Tonnes)": "1.5",
    "Partial harvesting": "No",
    "Iced used & quality": "280 kg flake ice, potable water",
    "Unique Blockchain ID": "251021070100101005",
    "Unique Secondary ID": "251021070200202005"
  },
  {
    "stage": "Aggregation/Trading at Farm Gate-2",
    "Stakeholder/Custodian": "Aggregator/Trader",
    "Unique ID": "TN5697054005010125",
    "parent_batch_id": "INDI2-AGG-002",
    "Trade Date": "2025-06-29 00:00:00",
    "Aggregator": "Tamil Aqua Traders",
    "Species": "P. indicus",
    "Quantity (Tonnes)": "1.35",
    "Ice used & quality": "220 kg flake ice",
    "Next custodian": "SeaHarvest Processing Unit",
    "Grade wise quantity (Tonnes)": "60-70 count:0.8,71-90 count:0.5",
    "Unique Blockchain ID": "251021070100101006",
    "Unique Secondary ID": "251021070200202006"
  },
  {
    "stage": "Transportation-2",
    "Stakeholder/Custodian": "Transporter/Cold chain operator",
    "Unique ID": "TN5697054006010125",
    "parent_batch_id": "INDI2-TRANS-002",
    "Transporter": "AquaTrans Logistics",
    "Contact": "9876543322",
    "Truck type": "Refrigerated (3T)",
    "Transport license": "TN-TL-3301",
    "Vehicle ID": "TN27 AQ 4601",
    "Vehicle sanitation log": "Updated before loading",
    "Vehicle capacity (Tonnes)": "3",
    "Weight transported (Tonnes)": "1.35",
    "Name of the driver": "R. Vignesh",
    "Contact detail": "9998877442",
    "Distance (km)": "60",
    "Duration (h)": "2.5",
    "Loading and unloading time (h)": "0.5",
    "GPS log": "Enabled",
    "Condition": "Excellent",
    "Temperature at packing": "-2°C",
    "Temperature data logger": "Yes",
    "Species": "P. indicus",
    "Unique Blockchain ID": "251021070100101007",
    "Unique Secondary ID": "251021070200202007"
  },
  {
    "stage": "Marketing-2",
    "Stakeholder/Custodian": "Distributor/Wholesaler",
    "Unique ID": "AP5697054007010125",
    "parent_batch_id": "INDI2-MARK-002",
    "Name": "Coastal Marketing Agency",
    "Address": "Kondapuram,Nellore",
    "GPS coordinate": "8.7650N,78.1340E",
    "Contact": "9003114499",
    "Seller": "SeaHarvest Processing Unit",
    "Temperature": "-18°C",
    "Stall type": "Enclosed cold room",
    "No. of stalls": "3",
    "Species": "P. indicus",
    "Condition": "Frozen",
    "Hygiene": "9/10",
    "Drainage facility": "Available",
    "Waste disposal": "MPEDA-approved",
    "Potable water facility": "Available",
    "Ice plant (No. & capacity)": "1 unit,3T/day",
    "e-Commerce": "Linked to FreshWave portal",
    "Quantity sold (kg)": "1300",
    "Buyer": "BlueOcean Exports Pvt. Ltd.",
    "Expiry/use-by date": "2026-06-28 00:00:00",
    "Unique Blockchain ID": "251021070100101008",
    "Unique Secondary ID": "251021070200202008"
  },
  {
   "stage": "Processing (direct from farms)-2",
    "Stakeholder/Custodian": "Processor",
    "Unique ID": "AP5697054008010125",
    "parent_batch_id": "INDI2-PROC-002",
    "Processing Plant": "SeaHarvest Processing Unit",
    "Address": "Tekkali,Nellore",
    "Approval No": "MPEDA-TN-142",
    "Capacity (Tonnes/day)": "6",
    "Processor credentials": "HACCP,BRC certified",
    "Date and Time of receipt": "2025-07-05 10:00:00",
    "Species": "P. indicus",
    "Product type": "IQF P&D tail-on",
    "Temperature": "-20°C",
    "Equipment": "IQF Tunnel",
    "Packaging": "Vacuum sealed",
    "Certification": "MPEDA certified",
    "Water availability": "Bore + RO treated",
    "Waste management": "Effluent treatment 6 KL/day",
    "Unique Blockchain ID": "251021070100101009",
    "Unique Secondary ID": "251021070200202009"
  },
  {
    "stage": "Exporting-2",
    "Stakeholder/Custodian": "Exporter",
    "Unique ID": "TN5697054009010125",
    "parent_batch_id": "INDI2-EXP-002",
    "Exporter": "BlueOcean Exports Pvt. Ltd.",
    "IEC Code": "1002093400",
    "Export mode": "Sea",
    "Airline": "N/A",
    "Place of embarkation/disembarkation": "Thoothukudi / Singapore",
    "Shipping liner name": "Evergreen Marine",
    "Country of loading and unloading": "India / Singapore",
    "Date and time": "2025-07-12 19:00:00",
    "Transport duration (days)": "7",
    "Container size (Tonnes)": "20",
    "Temperature": "-18°C",
    "Species": "P. indicus",
    "Category": "Frozen seafood",
    "ITC-HS Code": "03061710",
    "Certification": "EIC, MPEDA export certified",
    "Unique Blockchain ID": "251021070100101010",
    "Unique Secondary ID": "251021070200202010"
  },
  {
    "stage": "Retailing-2",
    "Stakeholder/Custodian": "Retailer/E-commerce vendor",
    "Unique ID": "AP5697054010010125",
    "parent_batch_id": "INDI2-RET-002",
    "Retailer Name": "FreshWave Seafoods",
    "Address": "Venkatapalam, Nellore",
    "Contact": "9944112266",
    "Temperature": "-18°C",
    "Product category": "Ready-to-cook frozen shrimp",
    "e-Commerce": "Available on FreshWave App",
    "Quantity sold (kg)": "850",
    "Buyer": "BayView Seafood Grill",
    "Expiry date": "2026-07-10 00:00:00",
    "Unique Blockchain ID": "251021070100101011",
    "Unique Secondary ID": "251021070200202011"
  },
  {
    "stage": "Shrimp on a plate-2",
    "Stakeholder/Custodian": "Consumer / Restaurant",
    "Unique ID": "AP5697054011010125",
    "parent_batch_id": "INDI2-PLATE-002",
    "Feedback": "Satisfactory",
    "Unique Blockchain ID": "251021070100101012",
    "Unique Secondary ID": "251021070200202012"
  },
  {
    "stage": "Shrimp on a plate (Customer View)-2",
    "Stakeholder/Custodian": "End Customer",
    "Unique ID": "AP5697054012010125",
    "parent_batch_id": "INDI2-Cus PLATE-002",
    "Customer Name": "K. Aravind",
    "Purchase Date": "2025-07-18 00:00:00",
    "Feedback Link": "https://freshwave.example/feedback/TN001",
    "Temperature at Delivery": "",
    "Unique Blockchain ID": "251021070100101013",
    "Unique Secondary ID": "251021070200202013"
  },
  {
    "stage": "Grow-out System-3",
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "AP5698054002010125",
    "parent_batch_id": "INDI3-GROW-003",
    "NFDP Reg No": "NFDP4203",
    "Farm Name": "Vidavalur Grow-out Farm",
    "Address": "Vidavalur, Nellore",
    "Owner": "S. Murugan Reddy",
    "Location (GPS coordinates)": "9.380000N, 78.800000E",
    "CAA approval": "FARM-TN-5002",
    "Farm size (ha)": "1.8",
    "Water spread area (ha)": "1.5",
    "Type of culture system": "Traditional, Semi-intensive, Intensive, Super-Intensive",
    "Ponds (No.)": "5",
    "Species farmed": "P. indicus",
    "PLs age (days)": "12",
    "Stocking density (per sq. mt.)": "115",
    "Date of stocking": "2025-04-20 00:00:00",
    "Feed": "Avanti Feeds CP 40%",
    "Inputs": "Lime, probiotics, molasses",
    "Water quality": "28-31°C, 27 ppt",
    "Culture duration (days)": "110",
    "Survival rate (%)": "87",
    "Certification": "CAA Certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Biofloc & EM application",
    "Biosecurity": "Perimeter fencing, bird nets, net covers",
    "Unique Blockchain ID": "251021050100101003",
    "Unique Secondary ID": "251021050200202003"
  },
  {
    "stage": "Production of feed & inputs-3",
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "AP5698054003010125",
    "parent_batch_id": "INDI3-PROW-003",
    "NFDP Reg No": "NFDP4204",
    "Address": "Atmakur, Nellore",
    "Feed Name": "Avanti Marine Supreme 42%",
    "Species targeted": "P. indicus",
    "Ingredients": "Fishmeal, soybean, wheat, binder",
    "Nutritional profile": "CP 42%, Fat 8%, Fiber 3%",
    "FCR": "1.1 to 1.5",
    "Manufacture Date": "2025-04-25 00:00:00",
    "Expiry date": "2026-07-12 00:00:00",
    "Quantity of feed available(Tonnes)": "1.2",
    "Batch No": "FEED_TN_NP30",
    "Supplier": "Coastal Aqua Distributors",
    "Manufacturer Name": "Avanti Feeds Pvt. Ltd.",
    "Certification": "MPEDA Feed Certified",
    "Unique Blockchain ID": "251021050100101004",
    "Unique Secondary ID": "251021050200202004"
  },
  {
    "stage": "Harvesting-3",
    "Stakeholder/Custodian": "Farmer/Farm owner/Aggregator",
    "Unique ID": "AP5698054004010125",
    "parent_batch_id": "INDI3-HARV-003",
    "Harvesting Date": "2025-05-30 00:00:00",
    "Method": "Cast net & drain harvesting",
    "Duration (h)": "6",
    "Species": "P. indicus",
    "Avg Body Weight (g)": "32",
    "Total production (Tonnes)": "1.6",
    "Partial harvesting": "No",
    "Iced used & quality": "300 kg flake ice, potable water",
    "Unique Blockchain ID": "251021050100101005",
    "Unique Secondary ID": "251021050200202005"
  },
  {
    "stage": "Aggregation/Trading at Farm Gate-3",
    "Stakeholder/Custodian": "Aggregator/Trader",
    "Unique ID": "AP5698054005010125",
    "parent_batch_id": "INDI3-AGG-003",
    "Trade Date": "2025-05-31 00:00:00",
    "Aggregator": "Aqua Exports",
    "Species": "P. indicus",
    "Quantity (Tonnes)": "1.4",
    "Ice used & quality": "250 kg flake ice",
    "Next custodian": "SeaHarvest Processing Unit",
    "Grade wise quantity (Tonnes)": "60-70 count:0.85,71-90 count:0.55",
    "Unique Blockchain ID": "251021050100101006",
    "Unique Secondary ID": "251021050200202006"
  },
  {
    "stage": "Transportation-3",
    "Stakeholder/Custodian": "Transporter/Cold chain operator",
    "Unique ID": "AP5698054006010125",
    "parent_batch_id": "INDI3-TRANS-003",
    "Transporter": "AquaTrans Logistics",
    "Contact": "9876544455",
    "Truck type": "Refrigerated (3T)",
    "Transport license": "AP-TL-3401",
    "Vehicle ID": "AP28 AQ 4702",
    "Vehicle sanitation log": "Updated before loading",
    "Vehicle capacity (Tonnes)": "3",
    "Weight transported (Tonnes)": "1.4",
    "Name of the driver": "R. Senju Sai Praveen",
    "Contact detail": "9998877555",
    "Distance (km)": "70",
    "Duration (h)": "3",
    "Loading and unloading time (h)": "0.5",
    "GPS log": "Enabled",
    "Condition": "Excellent",
    "Temperature at packing": "-2°C",
    "Temperature data logger": "Yes",
    "Species": "P. indicus",
    "Unique Blockchain ID": "251021050100101007",
    "Unique Secondary ID": "251021050200202007"
  },
  {
    "stage": "Marketing-3",
    "Stakeholder/Custodian": "Distributor/Wholesaler",
    "Unique ID": "AP5698054007010125",
    "parent_batch_id": "INDI3-MARK-003",
    "Name": "Coastal Marketing Agency",
    "Address": "Alluru, Nellore",
    "GPS coordinate": "8.764200,78.134500",
    "Contact": "9003114455",
    "Seller": "SeaHarvest Processing Unit",
    "Temperature": "-18°C",
    "Stall type": "Enclosed cold room",
    "No. of stalls": "4",
    "Species": "P. indicus",
    "Condition": "Frozen",
    "Hygiene": "9/10",
    "Drainage facility": "Available",
    "Waste disposal": "MPEDA-approved",
    "Potable water facility": "Available",
    "Ice plant (No. & capacity)": "1 unit, 3T/day",
    "e-Commerce": "Linked to FreshWave portal",
    "Quantity sold (kg)": "1240",
    "Buyer": "BlueOcean Exports Pvt. Ltd.",
    "Expiry/use-by date": "2026-05-25 00:00:00",
    "Unique Blockchain ID": "251021050100101008",
    "Unique Secondary ID": "251021050200202008"
  },
  {
    "stage": "Processing (direct from farms)-3",
    "Stakeholder/Custodian": "Processor",
    "Unique ID": "AP5698054008010125",
    "parent_batch_id": "INDI3-PROC-003",
    "Processing Plant": "SeaHarvest Processing Unit",
    "Address": "SPSR Nellore Industrial Zone",
    "Approval No": "MPEDA-AP-122-AP",
    "Capacity (Tonnes/day)": "5",
    "Processor credentials": "HACCP, BRC certified",
    "Date and Time of receipt": "2025-06-03 10:00:00",
    "Species": "P. indicus",
    "Product type": "IQF P&D tail-on",
    "Temperature": "-20°C",
    "Equipment": "IQF Tunnel",
    "Packaging": "Vacuum sealed",
    "Certification": "MPEDA certified",
    "Water availability": "Bore + RO treated",
    "Waste management": "Effluent treatment 5 KL/day",
    "Unique Blockchain ID": "251021050100101009",
    "Unique Secondary ID": "251021050200202009"
  },
  {
    "stage": "Exporting-3",
    "Stakeholder/Custodian": "Exporter",
    "Unique ID": "AP5698054009010125",
    "parent_batch_id": "INDI3-EXP-003",
    "Exporter": "BlueOcean Exports Pvt. Ltd.",
    "IEC Code": "1002093388",
    "Export mode": "Sea",
    "Airline": "N/A",
    "Place of embarkation/disembarkation": "Krishnapatnam / Tokyo",
    "Shipping liner name": "Evergreen Marine",
    "Country of loading and unloading": "India / Japan",
    "Date and time": "2025-06-12 19:00:00",
    "Transport duration (days)": "11",
    "Container size (Tonnes)": "20",
    "Temperature": "-18°C",
    "Species": "P. indicus",
    "Category": "Frozen seafood",
    "ITC-HS Code": "03061710",
    "Certification": "EIC, MPEDA export certified",
    "Unique Blockchain ID": "251021050100101010",
    "Unique Secondary ID": "251021050200202010"
  },
  {
    "stage": "Retailing-3",
    "Stakeholder/Custodian": "Retailer/E-commerce vendor",
    "Unique Blockchain ID": "251021050100101011",
    "Unique ID": "AP5698054010010125",
    "parent_batch_id": "INDI3-EXP",
    "Retailer Name": "FreshWave Seafoods",
    "Address": "Muthukur, Nellore",
    "Contact": "9944112233",
    "Temperature": "-18°C",
    "Product category": "Ready-to-cook frozen shrimp",
    "e-Commerce": "Available on FreshWave App",
    "Quantity sold (kg)": "800",
    "Buyer": "BayView Seafood Grill",
    "Expiry date": "2026-06-12 00:00:00",
    "Unique Blockchain ID": "251021050100101011",
    "Unique Secondary ID": "251021050200202011"
  },
  {
    "stage": "Shrimp on a plate-3",
    "Stakeholder/Custodian": "Consumer / Restaurant",
    "Unique ID": "AP5698054011010125",
    "parent_batch_id": "INDI3-PLATE-003",
    "Feedback": "Excellent taste and texture, clearly marked as Tamil Nadu origin.",
    "Unique Blockchain ID": "251021050100101012",
    "Unique Secondary ID": "251021050200202012"
  },
  {
    "stage": "Shrimp on a plate (Customer View)-3",
    "Stakeholder/Custodian": "End Customer",
    "Unique ID": "AP5698054012010125",
    "parent_batch_id": "INDI3-Cus PLATE-003",
    "Customer Name": "K. Arjun Narasimha Reddy",
    "Purchase Date": "2025-07-05 00:00:00",
    "Feedback Link": "https://freshwave.example/feedback/AP001",
    "Temperature at Delivery": "",
    "Unique Blockchain ID": "251021050100101013",
    "Unique Secondary ID": "251022010311002011"
  }
]




# ==================== XLSX TRACEABILITY PARAMETERS (2025) ====================
LINEAGE_XLSX_2025 = [
  {
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "3011231150A7010125",
    "NFDP Reg No": "NFDP1001-XX",
    "Facility Name": "M/s. Konabay",
    "Address": "Sunrise Capital, Inc. dba Kona Bay Marine\nResources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752, USA",
    "Species": "P. vannamei",
    "Genetic selection": "SPF",
    "Date of receipt": "2025-12-25 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods (in pairs)": "150",
    "Size of broods (Male & female in g)": "35 & 40",
    "Import": "Yes",
    "Survival rate (%)": "100",
    "Quarantine": "Yes",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Source": "Domesticated",
    "Feeding regime": "Standard (Imported SPF polychaete, squid, krill, artemia biomass)",
    "SPF status": "Verified",
    "stage": "Broodstock Facility",
  },
  {
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "3011231015A2010125",
    "NFDP Reg No": "NFDP1001-XX",
    "Facility Name": "M/s. Konabay",
    "Address": "Sunrise Capital, Inc. dba Kona Bay Marine\nResources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752, USA",
    "Species": "P. vannamei",
    "Genetic selection": "SPF",
    "Date of receipt": "2025-11-28 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods (in pairs)": "15",
    "Size of broods (Male & female in g)": "35 & 40",
    "Import": "Yes",
    "Survival rate (%)": "80",
    "Quarantine": "Yes",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Source": "Domesticated",
    "Feeding regime": "Standard (Imported SPF polychaete, squid, krill, artemia biomass)",
    "SPF status": "Verified",
    "stage": "Broodstock Facility",
  },
  {
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "3011231150A5010125",
    "NFDP Reg No": "NFDP1001-XX",
    "Facility Name": "M/s. Konabay",
    "Address": "Sunrise Capital, Inc. dba Kona Bay Marine\nResources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752, USA",
    "Species": "P. vannamei",
    "Genetic selection": "SPF",
    "Date of receipt": "2025-12-25 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods (in pairs)": "150",
    "Size of broods (Male & female in g)": "35 & 40",
    "Import": "Yes",
    "Survival rate (%)": "100",
    "Quarantine": "Yes",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Source": "Domesticated",
    "Feeding regime": "Standard (Imported SPF polychaete, squid, krill, artemia biomass)",
    "SPF status": "Verified",
    "stage": "Broodstock Facility",
  },
  {
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "3011231150A4010125",
    "NFDP Reg No": "NFDP1001-XX",
    "Facility Name": "M/s. Konabay",
    "Address": "Sunrise Capital, Inc. dba Kona Bay Marine\nResources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752, USA",
    "Species": "P. vannamei",
    "Genetic selection": "SPF",
    "Date of receipt": "2025-12-25 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods (in pairs)": "150",
    "Size of broods (Male & female in g)": "35 & 40",
    "Import": "Yes",
    "Survival rate (%)": "100",
    "Quarantine": "Yes",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Source": "Domesticated",
    "Feeding regime": "Standard (Imported SPF polychaete, squid, krill, artemia biomass)",
    "SPF status": "Verified",
    "stage": "Broodstock Facility",
  },
  {
    "Stakeholder/Custodian": "NBC/BMC/Brood Bank operator",
    "Unique ID": "301123100720010225",
    "NFDP Reg No": "NFDP1001-XX",
    "Facility Name": "M/s. Konabay",
    "Address": "Sunrise Capital, Inc. dba Kona Bay Marine\nResources, P.O. Box No.1282, Kekaha,Kauai, Hi 96752, USA",
    "Species": "P. vannamei",
    "Genetic selection": "SPF",
    "Date of receipt": "2025-12-03 00:00:00",
    "DoF approved": "Yes",
    "Quantity of broods (in pairs)": "720",
    "Size of broods (Male & female in g)": "41 & 43",
    "Import": "Yes",
    "Survival rate (%)": "98.9",
    "Quarantine": "Yes",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Source": "Domesticated",
    "Feeding regime": "Standard (Imported SPF polychaete, squid, krill, artemia biomass)",
    "SPF status": "Verified",
    "stage": "Broodstock Facility",
  },
  {
    "Stakeholder/Custodian": "Hatchery/Nursery operator",
    "Unique ID": "TNII15981720010127",
    "NFDP Reg No": "NFDP2026-XX",
    "Broodstock/PL supplier": "M/s. Vaisakhi Biomarine Pvt. Ltd., Marakkanam, Tamil Nadu",
    "DoF approval": "Yes",
    "MPEDA enrolment": "MPEDA2026-XX",
    "Species": "P. vannamei",
    "Life stage": "Post larvae (PLs)",
    "Size of broods/PLs (g)": "0.015",
    "Quantity of broods/PLs (No.)": "300000",
    "Import": "No",
    "Quarantine": "No",
    "Hatchery/Nursery details": "RGCA",
    "Address": "Rajiv Gandhi Centre for Aquaculture (RGCA),\u00a0Moozhiyar\u00a0road, Thoduvai, Thirumullaivasal Sirkali Taluk,, Thirumullaivasal, Tamil Nadu 609113",
    "Location (GPS coordinates)": "11.265341, 79.840522",
    "CAA approval": "TNII/2012/1598",
    "Capacity (PLs No.)": "300000",
    "Seed production details (PLs No.)": "NA",
    "Date of stocking": "2026-02-02 00:00:00",
    "Gender": "Mixed",
    "Genetic strain": "SPF",
    "Survival rate of nauplii in hatchery (%)": "85",
    "Survival rate of PLs in hatchery (%)": "60",
    "Larval/Nursery tank size (MT)": "100",
    "Larval density (per L)": "3",
    "Use of probiotics": "No",
    "Use of antibiotics": "No",
    "Light logs": "Natural",
    "Aeration logs": "As per smart panel (ICAR-CIBA technology)",
    "Health certificate": "WOAH listed diseases free",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity measures": "Yes",
    "Hatchery/Nursery success rate (%)": "100",
    "Feed details": "CIBA Vannamei plus (CP-38%)",
    "Other inputs": "No supplements",
    "Discharged water treatment system (MT)": "Discharged water treatment plant available",
    "Certification": "ICAR-CIBA certified",
    "Water quality": "Temp 28-31 oC",
    "pH": "7.2 - 8.1",
    "DO (mg/L)": "4 - 7",
    "Salinity (ppt)": "15 - 19",
    "stage": "Hatchery-Nursery",
  },
  {
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TNII1598115001A726",
    "NFDP Reg No": "NFDP2026-XX",
    "Farm Name": "Super Intensive Precision Natural Shrimp Farming (SIPNSF)",
    "Address": "Muttukadu Experimental Station (MES), Muttukadu, Kovalam Post, ECR, Chennai, Tamil Nadu 603112",
    "Owner": "MES of ICAR-CIBA",
    "Location (GPS coordinates)": "12.805964, 80.247878",
    "CAA approval": "TNII/2012/1598",
    "Farm size (ha)": "0.4",
    "Water spread area (ha)": "0.05",
    "Ponds (No.)": "1",
    "Species farmed": "P. vannamei",
    "PLs/Juvenile age (days)": "28",
    "Stocking density (per cubic. mt.)": "250",
    "Date of stocking": "2026-02-01 00:00:00",
    "Feed": "CIBA Vannamei plus (CP-34%)",
    "Other inputs": "No",
    "Water quality": "Temp 28-31 oC",
    "Culture duration (days)": "110",
    "Survival rate (%)": "92",
    "Certification": "ICAR-CIBA certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "stage": "Grow-out System",
  },
  {
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TNII1598101501A226",
    "NFDP Reg No": "NFDP2026-XX",
    "Farm Name": "Super Intensive Precision Natural Shrimp Farming (SIPNSF)",
    "Address": "Muttukadu Experimental Station (MES), Muttukadu, Kovalam Post, ECR, Chennai, Tamil Nadu 603112",
    "Owner": "MES of ICAR-CIBA",
    "Location (GPS coordinates)": "12.805964, 80.247878",
    "CAA approval": "TNII/2012/1598",
    "Farm size (ha)": "0.4",
    "Water spread area (ha)": "0.05",
    "Ponds (No.)": "1",
    "Species farmed": "P. vannamei",
    "PLs/Juvenile age (days)": "28",
    "Stocking density (per cubic. mt.)": "250",
    "Date of stocking": "2026-02-01 00:00:00",
    "Feed": "CIBA Vannamei plus (CP-34%)",
    "Other inputs": "No",
    "Water quality": "Temp 28-31 oC",
    "Culture duration (days)": "110",
    "Survival rate (%)": "92",
    "Certification": "ICAR-CIBA certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "stage": "Grow-out System",
  },
  {
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TNII1598115001A526",
    "NFDP Reg No": "NFDP2026-XX",
    "Farm Name": "Super Intensive Precision Natural Shrimp Farming (SIPNSF)",
    "Address": "Muttukadu Experimental Station (MES), Muttukadu, Kovalam Post, ECR, Chennai, Tamil Nadu 603112",
    "Owner": "MES of ICAR-CIBA",
    "Location (GPS coordinates)": "12.805964, 80.247878",
    "CAA approval": "TNII/2012/1598",
    "Farm size (ha)": "0.4",
    "Water spread area (ha)": "0.05",
    "Ponds (No.)": "1",
    "Species farmed": "P. vannamei",
    "PLs/Juvenile age (days)": "28",
    "Stocking density (per cubic. mt.)": "250",
    "Date of stocking": "2026-02-01 00:00:00",
    "Feed": "CIBA Vannamei plus (CP-34%)",
    "Other inputs": "No",
    "Water quality": "Temp 28-31 oC",
    "Culture duration (days)": "110",
    "Survival rate (%)": "92",
    "Certification": "ICAR-CIBA certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "stage": "Grow-out System",
  },
  {
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TNII1598115001A426",
    "NFDP Reg No": "NFDP2026-XX",
    "Farm Name": "Super Intensive Precision Natural Shrimp Farming (SIPNSF)",
    "Address": "Muttukadu Experimental Station (MES), Muttukadu, Kovalam Post, ECR, Chennai, Tamil Nadu 603112",
    "Owner": "MES of ICAR-CIBA",
    "Location (GPS coordinates)": "12.805964, 80.247878",
    "CAA approval": "TNII/2012/1598",
    "Farm size (ha)": "0.4",
    "Water spread area (ha)": "0.05",
    "Ponds (No.)": "1",
    "Species farmed": "P. vannamei",
    "PLs/Juvenile age (days)": "28",
    "Stocking density (per cubic. mt.)": "250",
    "Date of stocking": "2026-02-01 00:00:00",
    "Feed": "CIBA Vannamei plus (CP-34%)",
    "Other inputs": "No",
    "Water quality": "Temp 28-31 oC",
    "Culture duration (days)": "110",
    "Survival rate (%)": "92",
    "Certification": "ICAR-CIBA certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "stage": "Grow-out System",
  },
  {
    "Stakeholder/Custodian": "Farmer/Farm owner",
    "Unique ID": "TNII15981720010126",
    "NFDP Reg No": "NFDP2026-XX",
    "Farm Name": "Super Intensive Precision Natural Shrimp Farming (SIPNSF)",
    "Address": "Rajiv Gandhi Centre for Aquaculture (RGCA),\u00a0Moozhiyar\u00a0road, Thoduvai, Thirumullaivasal Sirkali Taluk,, Thirumullaivasal, Tamil Nadu 609113",
    "Owner": "RGCA",
    "Location (GPS coordinates)": "11.265341, 79.840522",
    "CAA approval": "TNII/2012/1598",
    "Farm size (ha)": "0.2",
    "Water spread area (ha)": "0.1",
    "Ponds (No.)": "2",
    "Species farmed": "P. vannamei",
    "PLs/Juvenile age (days)": "28",
    "Stocking density (per cubic. mt.)": "250",
    "Date of stocking": "2026-03-02 00:00:00",
    "Feed": "CIBA Vannamei plus (CP-34%)",
    "Inputs": "No",
    "Water quality": "Temp 28-31 oC",
    "Culture duration (days)": "105",
    "Survival rate (%)": "92",
    "Certification": "ICAR-CIBA certified",
    "Disease outbreak": "None",
    "Disease mitigation protocol": "Available",
    "Biosecurity": "Yes",
    "stage": "Grow-out System",
  },
  {
    # Block 4a — Feed Batch B101, Sub-entry 1 (for SIPNSF Pond 1 / TNII1598115001A726)
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "B101-4a",
    "Manufacturer Name": "ICAR-CIBA",
    "NFDP Reg No": "NFDP4001-XX",
    "Address": "Chennai",
    "Feed Name": "CIBA Vannamei plus",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Fish oil, Soy lecithin, Soy protein, Wheat, Rice, Vitamins and Minerals",
    "Nutritional profile": "Crude protein 34-36%; Fat 6%; Fibre 5%; Ash 15%; Moisture 10%",
    "Manufacture Date": "03-01-2026 & 31-01-2026",
    "Expiry date": "03-04-2026 & 31-04-2026",
    "Quantity (Tonnes)": "2.5",
    "Batch No": "B101",
    "Supplied to Farm": "TNII1598115001A726 (SIPNSF MES Pond 1)",
    "Supplier": "ICAR-CIBA",
    "Certification": "ICAR-CIBA certified",
    "stage": "Production of feed & inputs",
  },
  {
    # Block 4b — Feed Batch B101, Sub-entry 2 (for SIPNSF Pond 2 / TNII1598101501A226)
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "B101-4b",
    "Manufacturer Name": "ICAR-CIBA",
    "NFDP Reg No": "NFDP4001-XX",
    "Address": "Chennai",
    "Feed Name": "CIBA Vannamei plus",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Fish oil, Soy lecithin, Soy protein, Wheat, Rice, Vitamins and Minerals",
    "Nutritional profile": "Crude protein 34-36%; Fat 6%; Fibre 5%; Ash 15%; Moisture 10%",
    "Manufacture Date": "03-01-2026 & 31-01-2026",
    "Expiry date": "03-04-2026 & 31-04-2026",
    "Quantity (Tonnes)": "2.5",
    "Batch No": "B101",
    "Supplied to Farm": "TNII1598101501A226 (SIPNSF MES Pond 2)",
    "Supplier": "ICAR-CIBA",
    "Certification": "ICAR-CIBA certified",
    "stage": "Production of feed & inputs",
  },
  {
    # Block 4c — Feed Batch B101, Sub-entry 3 (for SIPNSF Pond 3 / TNII1598115001A526)
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "B101-4c",
    "Manufacturer Name": "ICAR-CIBA",
    "NFDP Reg No": "NFDP4001-XX",
    "Address": "Chennai",
    "Feed Name": "CIBA Vannamei plus",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Fish oil, Soy lecithin, Soy protein, Wheat, Rice, Vitamins and Minerals",
    "Nutritional profile": "Crude protein 34-36%; Fat 6%; Fibre 5%; Ash 15%; Moisture 10%",
    "Manufacture Date": "03-01-2026 & 31-01-2026",
    "Expiry date": "03-04-2026 & 31-04-2026",
    "Quantity (Tonnes)": "2.5",
    "Batch No": "B101",
    "Supplied to Farm": "TNII1598115001A526 (SIPNSF MES Pond 3)",
    "Supplier": "ICAR-CIBA",
    "Certification": "ICAR-CIBA certified",
    "stage": "Production of feed & inputs",
  },
  {
    # Block 4d — Feed Batch B101, Sub-entry 4 (for SIPNSF Pond 4 / TNII1598115001A426)
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "B101-4d",
    "Manufacturer Name": "ICAR-CIBA",
    "NFDP Reg No": "NFDP4001-XX",
    "Address": "Chennai",
    "Feed Name": "CIBA Vannamei plus",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Fish oil, Soy lecithin, Soy protein, Wheat, Rice, Vitamins and Minerals",
    "Nutritional profile": "Crude protein 34-36%; Fat 6%; Fibre 5%; Ash 15%; Moisture 10%",
    "Manufacture Date": "03-01-2026 & 31-01-2026",
    "Expiry date": "03-04-2026 & 31-04-2026",
    "Quantity (Tonnes)": "2.5",
    "Batch No": "B101",
    "Supplied to Farm": "TNII1598115001A426 (SIPNSF MES Pond 4)",
    "Supplier": "ICAR-CIBA",
    "Certification": "ICAR-CIBA certified",
    "stage": "Production of feed & inputs",
  },
  {
    # Block 4e — Feed Batch B102 (for RGCA Farm / TNII15981720010126)
    "Stakeholder/Custodian": "Feed manufacturer/feed supplier/distributor",
    "Unique ID": "B102-4e",
    "Manufacturer Name": "ICAR-CIBA",
    "NFDP Reg No": "NFDP4001-XX",
    "Address": "Chennai",
    "Feed Name": "CIBA Vannamei plus",
    "Species targeted": "P. vannamei",
    "Ingredients": "Fish meal, Fish oil, Soy lecithin, Soy protein, Wheat, Rice, Vitamins and Minerals",
    "Nutritional profile": "Crude protein 34-36%; Fat 6%; Fibre 5%; Ash 15%; Moisture 10%",
    "Manufacture Date": "01-02-2026 & 01-03-2026",
    "Expiry date": "01-05-2026 & 01-06-2026",
    "Quantity (Tonnes)": "5",
    "Batch No": "B102",
    "Supplied to Farm": "TNII15981720010126 (SIPNSF RGCA Farm)",
    "Supplier": "ICAR-CIBA",
    "Certification": "ICAR-CIBA certified",
    "stage": "Production of feed & inputs",
  },
]
