This report measures structural characteristics of the LastDatabase consumer email dataset stored in ClickHouse. The analysis covers record volume, email-hash uniqueness, field completeness and geographic representation.
| Measurement | Result |
|---|---|
| Total records | 49,786,975 |
| Unique email hashes | 49,786,975 |
| Duplicate rows by email hash | 0 |
| Missing email values | 0 |
| Stored country values | 229 |
| Distinct source values | 1 |
The dataset contained 49,786,975 rows and 49,786,975 unique email hashes at measurement time. The measured difference was zero duplicate rows by email hash.
Hash uniqueness is a database deduplication measurement. It does not establish that every mailbox is active, deliverable or currently owned by the associated person.
| Field | Populated records | Coverage |
|---|---|---|
| First name | 49,786,975 | 100% |
| Last name | 49,786,975 | 100% |
| 49,786,975 | 100% | |
| LinkedIn URL | 49,786,816 | 99.9997% |
| Country | 49,786,975 | 100% |
| Source | 49,786,975 | 100% |
| Created timestamp | 49,786,975 | 100% |
| Updated timestamp | 49,786,975 | 100% |
LinkedIn URL was missing from 159 records. Empty state, city and postal-code fields are reported as measured rather than treated as inferred geographic information.
| Country label | Records | Share |
|---|---|---|
| USA | 21,123,770 | 42.43% |
| India | 3,842,547 | 7.72% |
| UK | 2,902,360 | 5.83% |
| Brazil | 2,092,865 | 4.20% |
| Canada | 1,821,171 | 3.66% |
| France | 1,223,111 | 2.46% |
| Australia | 1,056,526 | 2.12% |
| Netherlands | 1,041,340 | 2.09% |
| Italy | 1,017,779 | 2.04% |
| Spain | 753,742 | 1.51% |
| Mexico | 599,568 | 1.20% |
| Germany | 555,689 | 1.12% |
| China | 516,721 | 1.04% |
| South Africa | 504,740 | 1.01% |
| Argentina | 503,871 | 1.01% |
| Belgium | 376,839 | 0.76% |
| Sweden | 360,283 | 0.72% |
| Indonesia | 346,049 | 0.70% |
| United Arab Emirates | 344,310 | 0.69% |
| Colombia | 324,900 | 0.65% |
Country results represent stored country labels. They should not be interpreted as independently verified residence, citizenship or current physical location.
All 49,786,975 measured records contained a stored source value. Source coverage was therefore 100% across the measured dataset.
All consumer email records covered by this dataset are maintained as opt-in records. Supporting opt-in and consent records are maintained separately from the production ClickHouse table measured in this report.
Because the supporting opt-in records are stored separately, their absence from the fields measured in this profile should not be interpreted as an absence of opt-in documentation.
LastDatabase maintains this consumer dataset under its GDPR and CCPA compliance procedures, including applicable privacy and data-subject rights processes.
Customers remain responsible for using data in accordance with the laws and requirements applicable to their activities. See our Compliance information and Privacy Center.
Measurements were calculated directly from the
consumer_email_leads ClickHouse table.
Aggregate queries measured row count, unique email hashes,
missing values, field completeness, country distribution
and stored source values.
Email-hash uniqueness was measured by comparing total rows with the exact count of distinct stored email hashes. Field completeness represents whether a stored field was non-empty or non-null at measurement time.
B2B Email Data Profile 2026 · B2B Email Quality Benchmark 2026 · Methodology · Data Sources · Data Quality
