Usage Examples

How to subscribe to and utilize the Consumer Demographics dataset

Retrieve all of it

select * from tiki.demographics

Target specific states

select *
from tiki.demographics
where user_state in ('Alabama', 'Georgia', 'Kentucky', 'Tennessee')

Target zip codes (generate a sha256 hash of the zip codes you are interested in)

select *
from tiki.demographics
where user_zip = '94169b53e3b85fffe76900e05b070fb91cfd614729faad69303b949b275aa8a2'

Target users in an arbitrary age range

select *
from tiki.demographics
where estimated_age between 30 and 40