COP25 anonymized dataset

This postgresql file is the result of a collective intelligence experiment which took place in the framework of COP25 in Madrid in December 2019. The tables in the file are described below. answer_distances: No relevance. answers: Each answer given to a question by a user is logged. Each answer is composed of 5 different items, which are individual answers to the question. The same user can make several answers, at various times during the exercise, which is also recorded. answers_items: Each of the items is associated with the ID of the answer to which it belongs. answers_solutions: Each answer is associated to a solution, that is, the position in the network associated to the user for that project. ar_internal_metadata: Not relevant. delayed_jobs: Not relevant. delayed_jobs_id_seq: No relevance. event_logs: Each of the phases of the project, when they have started and what has happened in those phases. history_logs: No relevance. item_solutions: Each item is associated to a solution. item_swaps: No relevance. items: Each item is a participant's answer to the question asked in the project. neighbor_logs: Not relevant. net_logs: Not relevant. options: No relevance. projects: Each question asked to the participants is associated to a project ID. questions: The different questions that have been asked in different experiments of the tool are displayed. Only those related to SDG #6 and #13 are collected in this database. registration_requests: Not relevant. schema_migrations: Not relevant. solution_swaps: In some phases of the projects the solution assigned to a user can change, this is the equivalent to change the user's position, having different neighbors therefore. solutions: For each project the user receives a solution ID, this is located in an x,y matrix, so we can know which solutions are adjacent to each other (for x, y; x-1, x+1, y-1, y+1). users: Each participant receives a user ID that appears in this table.