Query taxpayer records (2013-2018) directly in your browser
using DuckDB-WASM
NTN/CNIC Lookup
Initializing database...
Enter an NTN (7 digits) or CNIC (13 digits) to
search across all years (2013-2018) and entity
types. NTN searches match on the first 7 digits to
find records even if the 8th digit changed. Uses
the optimized consolidated file with a single HTTP
range request (sorted by ID type for fast row group
skipping).
Select Parquet Files to Load
Loaded Tables
No files loaded yet
SQL Query
Initializing database...
Example Queries (click to load)
Consolidated File (all_years table)
SELECT * FROM all_years WHERE ntn_7 = '0787223'
ORDER BY year
SELECT name, SUM(tax_paid) as total FROM all_years
WHERE category = 'company' GROUP BY ntn_7, name
ORDER BY total DESC LIMIT 10
SELECT year, category, COUNT(*) as count,
SUM(tax_paid) as total FROM all_years GROUP BY year,
category ORDER BY year, category
Individual Year Files
SELECT * FROM companies_2018 ORDER BY tax_paid DESC
LIMIT 10
SELECT * FROM aop_2018 ORDER BY tax_paid DESC LIMIT
10
SELECT * FROM individuals_2018 ORDER BY tax_paid
DESC LIMIT 10
SELECT COUNT(*), SUM(tax_paid) as total_tax FROM
companies_2018 WHERE tax_paid > 0
SELECT * FROM companies_2018 WHERE name LIKE
'%BANK%' ORDER BY tax_paid DESC LIMIT 20
SELECT * FROM individuals_2018 WHERE name LIKE
'%MUHAMMAD%' ORDER BY tax_paid DESC LIMIT 20
SELECT * FROM companies_2013 UNION ALL SELECT * FROM
companies_2014 ORDER BY tax_paid DESC LIMIT 20