🌱 Seed-URLs (9) · 📞 14 Kontakte (📧 14 / 📱 10)
active
#819 WEALTH-IN-1261481-FAMILY_OFFICE — New Delhi — Family Offices (Atlas)
Region: IN / New Delhi
✏️ Projekt bearbeiten
Fragestellung: Welche Family Offices haben aktiven Sitz in New Delhi und bedienen vermögende Privatkunden?
Ziel: Echte Firmen (keine LinkedIn-Profile, keine Verzeichnis-Listings, keine Job-Portale). Pro Firma: Name, Webseite, Adresse, Hauptkontakt-E-Mail/Telefon, Gründungsjahr wenn auffindbar, Regulator/Aufsicht, Mitgliedschaften wenn ersichtlich, Klientelfokus. Max. 15 valide Kandidaten.
Seeds in Auswahl
9
alle Zeiträume
davon legit
9
100% der Auswahl
Seeds mit Kontakten
9
14 Kontakte auf diesen Seeds
Kontakte gesamt
14
alle Kontakte im Projekt
SQL der Abfrage anzeigen
SELECT s.*, p.project_code, p.question,
(SELECT COUNT(*) FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id) AS contact_count,
EXISTS(SELECT 1 FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id AND COALESCE(c.email,'') <> '') AS has_email,
EXISTS(SELECT 1 FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id AND COALESCE(c.phone,'') <> '') AS has_phone,
(SELECT COUNT(*) FROM COMMUNICATION_EVENTS_events e
JOIN WEBRESEARCH_contacts c2 ON c2.id = e.contact_id
WHERE c2.seed_url_id = s.id AND e.channel = 'email' AND e.sent_at IS NOT NULL) AS attempt_count,
(SELECT COUNT(DISTINCT c3.id) FROM WEBRESEARCH_contacts c3
JOIN EMail_blocklist b3 ON LOWER(b3.email) = LOWER(c3.email)
WHERE c3.seed_url_id = s.id
AND (b3.expires_at IS NULL OR b3.expires_at > NOW())) AS blocked_count,
(SELECT c4.email FROM WEBRESEARCH_contacts c4
JOIN EMail_blocklist b4 ON LOWER(b4.email) = LOWER(c4.email)
WHERE c4.seed_url_id = s.id
AND (b4.expires_at IS NULL OR b4.expires_at > NOW())
ORDER BY c4.id ASC LIMIT 1) AS blocked_sample_email
FROM WEBRESEARCH_seed_urls s
LEFT JOIN WEBRESEARCH_projects p ON p.id = s.project_id
WHERE s.is_craweled >= 1 AND NOT EXISTS (SELECT 1 FROM EMail_blocklist b
JOIN WEBRESEARCH_contacts c5 ON LOWER(b.email) = LOWER(c5.email)
WHERE c5.seed_url_id = s.id
AND (b.expires_at IS NULL OR b.expires_at > NOW())) AND s.project_id = 819 AND (SELECT COUNT(*) FROM WEBRESEARCH_contacts c WHERE c.seed_url_id = s.id) > 0
ORDER BY s.id DESC
LIMIT 50 OFFSET 0
| ID | Erstellt | Status | URL | Projekt | Firma | Kurztext | Contacts | Versuche | 🚫 | Kontakt | Crawl | ✉️ Draft | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14486 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | RNM Capital Advisors |
Boutique investment banking and family office advisory firm in New Delhi, focused on M&A, valuation, fund mobilization, …
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 14485 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | Equalifi (ehemals AIWMI) |
Equalifi ist ein globales Mitgliedernetzwerk für Finanzdienstleistungs-Organisationen, Führungskräfte, Fachleute und Nac…
Ganz ansehen
|
1 Contact | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 14484 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | Dewan P.N. Chopra & Co. |
Professional services firm in New Delhi offering family office services, tax and regulatory advisory, succession plannin…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 14483 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | Vistra ITCL (India) Limited |
Vistra ITCL (India) Limited ist der größte unabhängige Private-Trust-Dienstleister in Indien und Teil der globalen Vistr…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 14482 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | Waterfield Advisors |
India-focused multi-family office and wealth advisory firm in Mumbai providing comprehensive family office services, leg…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 14480 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | SKG Family Office |
Family office in New Delhi founded in 2022 by Sanjay, focused on managing investments and supporting social and economic…
Ganz ansehen
|
1 Contact | 0 | — | Email 🌐 EN | gecrawlt+✓ | |||
| 14479 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | Treelife |
The site belongs to Treelife, a professional services firm offering legal, tax, and compliance services.
|
3 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 14478 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | TAM India Family Office Advisors LLP |
Full-service multi-family office advisory firm serving business owners, professionals and NRIs. It covers taxation, regu…
Ganz ansehen
|
1 Contact | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ | |||
| 14477 | 27.05.2026 03:15 |
legit | WEALTH-IN-1261481-FAMILY_OFFICE | AKCJ Ventures LLP |
AKCJ Ventures ist ein Family Office mit Sitz in New Delhi, Connaught Place (612, Kailash Building, 26 KG Marg). Das Unte…
Ganz ansehen
|
2 Contacts | 0 | — | Email Phone 🌐 EN | gecrawlt+✓ |