kenya

Custom SQL query

Tables

aggregations

subject_id, workflow_id, task, reducer, data.choice, data.total_vote_count, data.choice_count, data.answers.whatbehaviorsdoyousee.standing, data.answers.whatbehaviorsdoyousee.interacting, data.answers.whatbehaviorsdoyousee.moving, data.answers.howmany.2, data.answers.arethereanyyoungpresent.no, data.answers.howmany.1, data.answers.whatbehaviorsdoyousee.resting, data.answers.howmany.3, data.answers.arethereanyyoungpresent.yes, data.answers.whatbehaviorsdoyousee.eating, data.answers.howmany.5, data.answers.howmany.4, data.answers.howmany.6, data.answers.howmany.7, data.answers.howmany.1150, data.answers.howmany.8, data.answers.howmany.10, data.answers.howmany.51, data.answers.howmany.9

163,936 rows

cameras

id, camera_name, latitude, longitude, season

71 rows

subjects

subject_id, kenya_id, camera, location, subject_set_id, workflow_id, project_id, camera_name, year, month

123,721 rows

Download SQLite DB: kenya.db 33.7 MB