All numbers on this dashboard derive from these tables. The ETL (etl/load.py) normalizes the AP State Excise xlsx exports, geocodes retailers, computes border distance, and writes the unified spirit.duckdb file.
Live row counts and column lists from the running DuckDB connection
retailersap_retailers.xlsxRetail outlets — TS+SS+TP+CS shops with status, type, district, geo
brandsap_brands.xlsxBrand catalogue with strength, MRP, supplier
labelsap_labels.xlsxApproved label registry for FY2025-26
sales_yearwiseap_sales_yearwise.xlsxYear-wise retail sales by brand · 4Q rollup
sales_inflowap_sales_inflow.xlsxDaily inflow ledger · brand-level supply to retailers
distillery_quotaap_distillery_quota.xlsxQuarterly allotted vs lifted by distillery unit
seizuresap_seizures.xlsxEnforcement seizures since 2019 (ID/NDPL/DPL/Ganja)