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.