Datasets · DuckDB · Read-only

Source data — seven xlsx files, 12,83,181 rows in DuckDB.

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.

Tables

Total rows

12,83,181

Largest table

sales_yearwise (6,42,955)

Source files

7 xlsx

Tables

Live row counts and column lists from the running DuckDB connection

retailersap_retailers.xlsx

Retail outlets — TS+SS+TP+CS shops with status, type, district, geo

Rows

4,899

snocodenameaddressdistrictcircledepot_codelatlonstatusvendor_typeborder_km

brandsap_brands.xlsx

Brand catalogue with strength, MRP, supplier

Rows

1,457

snoproduct_codebrand_codebrand_namesize_mlunits_per_casebasic_pricesuppliercategorybrand_typemrpissue_priceMain DistillerySupplier AddressSupplier TypeOffice Address

labelsap_labels.xlsx

Approved label registry for FY2025-26

Rows

1,373

snoapp_notypelabel_typelabel_categoryapproval_datemain_distilleryunitbrand_namesizepack_typebasic_price

sales_yearwiseap_sales_yearwise.xlsx

Year-wise retail sales by brand · 4Q rollup

Rows

6,42,955

dateretailer_coderetailerdepot_codecasesbottlestotal_bottlessale_value

sales_inflowap_sales_inflow.xlsx

Daily inflow ledger · brand-level supply to retailers

Rows

6,32,025

dateretailer_coderetailerdistrictcasesbottlestotal_bottlessale_value

distillery_quotaap_distillery_quota.xlsx

Quarterly allotted vs lifted by distillery unit

Rows

ac_officeunitbase_quota_plbase_quota_blopening_balanceallottedliftedbalanceyield_gapyield_gap_pct

seizuresap_seizures.xlsx

Enforcement seizures since 2019 (ID/NDPL/DPL/Ganja)

Rows

430

categoryyearmonthcases