Skip to main content

​
Investment Research

Find mid-sized tech companies in major hubs:
(State IN ['Maharashtra', 'Karnataka', 'Tamil Nadu']) AND
(NICDesc CONTAINS 'software' OR NICDesc CONTAINS 'technology') AND
(paidUpCapital > 1000000 AND paidUpCapital < 50000000) AND
dateOfIncorporation > '2018-01-01' AND
llpStatus == 'Active'
Use Case: Target recently incorporated tech companies with growth potential.
Find publicly listed companies with significant capital:
Listed == 'Listed' AND paidUpCapital > 100000000 AND State == 'Maharashtra'
Find private companies with high capital, recently incorporated:
classOfCompany == 'Private' AND
paidUpCapital > 50000000 AND
dateOfIncorporation > '2020-01-01' AND
llpStatus == 'Active'

​
Lead Generation

NICDesc CONTAINS 'manufacturing' AND
City IN ['Pune', 'Chennai', 'Ahmedabad'] AND
paidUpCapital > 5000000 AND
llpStatus == 'Active'

(NICCode IN [62011, 62012, 62013]) AND
City IN ['Bangalore', 'Hyderabad', 'Pune'] AND
paidUpCapital > 1000000

NICDesc CONTAINS 'retail' AND
State == 'Delhi' AND
llpStatus == 'Active'

​
Compliance Monitoring

Identify entities with potential compliance issues:
(Status != 'Active' OR TaxpayerType == 'Composition') AND
Turnover > 20000000 AND
(ConstitutionBusiness == 'Proprietorship' OR ConstitutionBusiness == 'Partnership')

Status == 'Suspended' AND state == 'Maharashtra'

llpStatus == 'Dormant' AND State == 'Maharashtra'

​
Market Research

Companies incorporated in the last year:
dateOfIncorporation > '2024-01-01' AND
State == 'Karnataka' AND
llpStatus == 'Active'

(NICDesc CONTAINS 'e-commerce' OR NICDesc CONTAINS 'electronic commerce') AND
paidUpCapital > 1000000

(NICCode IN [64191, 64192, 65110]) AND
llpStatus == 'Active' AND
paidUpCapital > 10000000

​
Regional Analysis

City IN ['Jaipur', 'Lucknow', 'Indore', 'Kochi', 'Chandigarh'] AND
dateOfIncorporation > '2022-01-01' AND
llpStatus == 'Active'
Compare tech companies across states:
(State IN ['Maharashtra', 'Karnataka', 'Tamil Nadu', 'Telangana']) AND
NICDesc CONTAINS 'software' AND
paidUpCapital > 5000000

​
Query Optimization Tips

Filter Early

Put most selective conditions first:
Turnover > 100000000 AND City == 'Mumbai'

Use IN for Multiple Values

More efficient than multiple OR conditions:
City IN ['Mumbai', 'Delhi', 'Bangalore']

Indexed Fields First

Fields like City, State, Status are indexed and faster to query.

Limit Date Ranges

Narrow date ranges improve performance:
dateOfIncorporation > '2023-01-01' AND dateOfIncorporation < '2024-01-01'