tiktok.creators

entity · one row = one creator

Every TikTok creator we have seen: profile, counts, verification, links, business info for tracked creators, and contact email (premium).

Coverage: ~5B creators worldwide, discovered through following lists. Business/category fields only for tracked creators (priority 1 ~3M US creators with >= 10k followers; priority 2 ~20M worldwide).
Refresh: Rolling rebuild; every row at most 6 h old.
Sorted by country, followers, creator_id. Filters on the leading columns are fastest.

Example

SELECT *
FROM tiktok.creators
LIMIT 100

Column	Type	Description
`creator_id`	`UInt64`
`username`	`String`
`nickname`	`String`
`bio`	`String`
`avatar_uri`	`String`
`country`	`LowCardinality(String)`
`language`	`LowCardinality(String)`
`followers`	`UInt32`
`following`	`UInt32`
`videos`	`UInt32`	0 on private = hidden
`likes`	`UInt64`	likes received
`sounds_created`	`UInt32`
`account_created_at`	`DateTime`
`handle_changed_at`	`DateTime`	only if within ~30 days; else 1970
`is_private`	`UInt8`
`is_active`	`UInt8`	0 = banned / deactivated (hint)
`is_verified`	`UInt8`
`verified_label`	`LowCardinality(String)`	‘verified account’, ‘popular creator’
`business_verified`	`LowCardinality(String)`	enterprise_verify_reason
`instagram`	`String`
`youtube_channel_id`	`String`
`youtube_channel_name`	`String`
`last_seen_at`	`DateTime`	newest read of this creator
`refreshed_at`	`DateTime`	when this row was built

Column	Type	Description
`priority`	`UInt8`	1 deep / 2 standard / 0 not tracked
`category`	`LowCardinality(String)`
`account_type`	`LowCardinality(String)`	‘personal’ \| ‘creator’ \| ‘business’ \| ‘’
`company_name`	`String`
`is_artist`	`UInt8`	sounds_created > 0 OR ‘Artist’ label OR show_artist_playlist

Column	Type	Description
`email` premium	`String`	revealed per query, costs more
`email_source`	`LowCardinality(String)`	‘bio’ \| ‘archive’ \| ‘’
`has_email`	`UInt8`	free
`email_domain`	`LowCardinality(String)`	free: ‘gmail.com’, ‘agency.co’, …