home

results

Custom SQL query

Tables

agreements

id, language_id, red, green, blue, agreement

2,676 rows

joined_prolific_age_results

participant_id, partcipant_created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location, task_id, target_id, name, response_time, experiment_version, result_created_on, red, green, blue

10 rows

participants_prolific

id, created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location, task_id, prolific_id, study_id, session_id

26 rows

participants_prolific_age

id, created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location, task_id, prolific_id, study_id, session_id

17 rows

responses_colbg

id, participant_id, target_id, background_id, name, response_time, experiment_version, created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location

2,686 rows

responses_original

id, participant_id, target_id, name, response_time, experiment_version, created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location

358 rows

responses_prolific

id, participant_id, target_id, background_id, name, response_time, experiment_version, created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location, task_id

161 rows

responses_prolific_age

id, participant_id, target_id, name, response_time, experiment_version, created_on, greyscale_steps, browser_language, interface_language, user_agent, colour_vision_score, age, gender, gender_other, country_raised, country_resident, ambient_light, screen_light, screen_temperature, screen_distance, screen_resolution_w, screen_resolution_h, screen_colour_depth, device, device_orientation, education_level, language_experience, colour_experience, colour_target_disappeared, location, task_id

10 rows

Powered by Datasette · Queries took 18.977ms