Open Data
Welcome to the Lisboa Heritage Lab Participatory Platform Open Data page. Here, you will find data files that are regularly generated from various deliberative and governance processes within Lisboa Heritage Lab Participatory Platform. These files are made available to promote transparency, accessibility, and collaboration. Below, you will find detailed information on what these files are, how to open and work with them, and a description of the content and structure of each file.
These files are datasets exported from Lisboa Heritage Lab Participatory Platform's participatory processes, such as proposals, comments, and meetings. They provide raw, structured data that can be used for analysis, research, or integration with other tools. The data is updated automatically every 24 hours, ensuring that you have access to the most recent information.
These files are in CSV (Comma-Separated Values) format, which is a widely-used file format that can be opened and processed by a variety of software applications, including spreadsheet programs, text editors, and data analysis tools.
1. Download the files
Click on the links provided below to download the CSV files to your computer.2. Open the files
- Spreadsheet Applications: You can open CSV files using applications like Microsoft Excel, Google Sheets, or LibreOffice Calc. Simply open the application, then select "Open" from the File menu, and choose the downloaded CSV file.
- Text Editors: CSV files can also be opened in any text editor, such as Notepad or Sublime Text. This will display the raw data, with each line representing a row and each value separated by a comma.
- Data Analysis Tools: If you are familiar with data analysis tools like Python (with pandas), R, or SQL databases, you can import these CSV files directly for processing and analysis.
3. Working with the data
- Filtering and Sorting: In spreadsheet applications, you can filter and sort the data to focus on specific subsets of information.
- Analysis: Use the data to perform various analyses, such as counting the number of proposals, analyzing trends in comments, or evaluating participation in meetings.
- Visualization: You can create charts, graphs, and other visualizations to help interpret the data.
Below is a description of each dataset, including its schema (structure) and the type of information it contains:
Components
results
- address: O endereço do resultado (se houver)
- children_count: O número de sub-resultados
- comments_count: O número de comentários que este resultado tem
- component: A funcionalidade a qual o resultado pertence
- created_at: A data em que o resultado foi criado
- end_date: A data de quando o resultado está concluída
result_comments
- alignment: Se este comentário foi em favor, contra ou neutro
- created_at: A data em que este comentário foi criado
- depth: O lugar onde este comentário se encontra na hierarquia de comentários (se é uma resposta ou uma resposta de outra resposta).
- locale: A linguagem que o participante teve ao deixar este comentário
- root_commentable_url: A URL do recurso ligado a este comentário
posts
- author: Informações sobre o autor
- body: O corpo da publicação
- comments_count: O número de comentários que esta publicação tem
- component: O componente a que a publicação pertence
- created_at: A data em que esta publicação foi criada
- endorsements_count: O número de recomendações que esta publicação tem
- follows_count: O número de seguidores que esta publicação tem
- id: O identificador único desta publicação
- participatory_space: A que espaço (por exemplo, Processo Participativo ou Assembleia) pertence esta publicação
- published_at: A data em que esta publicação foi publicada
- title: O título da publicação
- updated_at: A última data em que esta publicação foi actualizada
- url: O URL desta publicação
post_comments
- alignment: Se este comentário foi a favor, contra ou neutro
- author: O nome do participante que fez este comentário
- body: O comentário em si
- commentable_id: O identificador único do comentável
- commentable_type: O tipo do comentável (se foi um resultado, uma proposta, etc.)
- created_at: A data em que este comentário foi criado
- depth: O lugar onde este comentário está nos três comentários (se for uma resposta ou uma resposta de uma resposta)
- id: O ID deste comentário
- locale: O idioma que o participante tinha ao deixar este comentário
- root_commentable_url: A URL do recurso vinculado a este comentário
projects
- address: The address of the project (if any)
- budget: Data regarding the budget (e.g. "2021 Budget") of the project
- budget_amount: The total amount of the budget for this project
- comments: The number of comments this project has received
- component: The component that the project belongs to
- confirmed_votes: The number of confirmed votes this project has received
- created_at: The date and time when the project was created
- description: The description of the project
- follows_count: The number of follows the project has
- id: The unique identifier of the project
- latitude: The latitude of the project in case it has a physical location
- longitude: The longitude of the project in case it has a physical location
- participatory_space: To which space (e.g. Participatory Process, or Assembly) this project belongs to
- reference: The unique reference of the project
- related_proposal_titles: The titles of the related proposals
- related_proposal_urls: The URLs of the related proposals
- related_proposals: The related proposals to this project
- selected_at: The time at which the project was selected
- taxonomies: The taxonomies of the project
- title: The title of the project
- updated_at: The last date the project was updated
- url: The URL of the project
debates
- author: Os dados do autor deste debate
- closed_at: A data em que este debate foi encerrado
- comments: O número de comentários que este debate tem
- comments_enabled: Se este debate tem comentários ativados ou não
- component: O componente a que o debate pertence
- conclusions: As conclusões do debate se ele fosse encerrado
- created_at: A data e a hora em que o debate foi criado
- description: Descrição do debate
- end_time: Quando este debate termina, se for um debate aberto e tiver um tempo limitado
- endorsements_count: O número de recomendações que este debate tem
- follows_count: O número de seguidores que este debate tem
- id: O identificador único do debate
- information_updates: As atualizações que o autor fez no debate
- instructions: Quais são as instruções para comentar neste debate
- last_comment_at: A data em que este debate foi comentado pela última vez
- last_comment_by: O conteúdo do último comentário feito no debate
- participatory_space: A que espaço (por exemplo, Processo Participativo ou Assembleia) pertence este debate
- reference: O identificador único do recurso nesta plataforma
- start_time: Quando este debate começa, se for um debate aberto e tiver um tempo limitado
- taxonomies: As taxonomias do projeto
- title: O título do debate
- updated_at: A data em que o debate foi actualizado pela última vez
- url: A URL onde este debate pode ser encontrado
debate_comments
- alignment: Se este comentário foi a favor, contra ou neutro
- author: O nome do participante que fez este comentário
- body: O comentário em si
- commentable_id: O identificador único do comentável
- commentable_type: O tipo do comentável (se foi um resultado, uma proposta, etc.)
- created_at: A data em que este comentário foi criado
- depth: O lugar onde este comentário está nos três comentários (se for uma resposta ou uma resposta de uma resposta)
- id: O ID deste comentário
- locale: O idioma que o participante tinha ao deixar este comentário
- root_commentable_url: A URL do recurso vinculado a este comentário
meetings
- address: The address of the meeting in case it is in person and has a physical location
- attachments: The number of attachments in this meeting
- attendees: The number of people attending this meeting
- attending_organizations: The organizations attending the meeting
- audio_url: Audio recording of the meeting
- author: The data for the author of this meeting
- available_slots: The number of slots available in a meeting
- closed_at: The date at which the meeting closed
- closing_report: Report of the closed meeting
- closing_visible: The visibilty of the meeting
- comments: The comments data of the meeting
- component: The component that the meeting belongs to
- contributions: The number of contributions in this meeting made by the atteendes
- created_at: The date at which the meeting was created
- customize_registration_email: The ability to allow a custom email at registration
- decidim_author_type: Author type of the meeting's author
- decidim_user_group_id: User group ID of people involved in the meeting
- description: The description of the meeting
- end_time: The date and time that this meeting ends
- follows_count: The number of follows the meeting has
- id: The unique identifier of the meeting
- iframe_access_level: The iframe access level of the meeting
- iframe_embed_type: The type of iframe embeded in the meeting
- latitude: The latitude of the meeting
- location: The location of the meeting
- location_hints: A hint of the location in which the meeting is taking place
- longitude: The longitude of the meeting
- online_meeting_url: The URL of the online meeting
- organizations: The organizations attending this meeting
- participatory_space: To which space (e.g. Participatory Process, or Assembly) this meeting belongs to
- private_meeting: To indicate whether the meeting is private or not
- published: When the meeting has been published
- reference: The unique identifier of the resource in this platform
- registration_form_enabled: Whether the registration form was enabled or not
- registration_terms: The terms agreed prior to meeting participation
- registration_type: The type of registration of the meeting
- registration_url: URL of the meeting registration
- registrations_enabled: Whether registrations were permitted
- related_proposals: The proposals related to this meeting
- related_results: The results related to this meeting
- reserved_slots: The number of reserved slots the meeting has
- start_time: The date and time that this meeting starts
- taxonomies: The taxonomies that this meeting belongs to
- title: The title of the meeting
- transparent: The visabilty of the meetng for non-members
- type_of_meeting: The meeting type
- updated_at: The time at which the meeting was last updated
- url: The URL of the meeting
- video_url: Video recording of the meeting
- withdrawn: Whether this meeting has been withdrawn
- withdrawn_at: When this meeting was withdrawn
meeting_comments
- alignment: If this comment was a favour, against or neutral
- author: The name of the participant that made this comment
- body: The comment itself
- commentable_id: The unique id of the commentable
- commentable_type: The type of the commentable (if it was a result, a proposal, etc.)
- comments: The comments data of the meeting
- created_at: The date when this comment was created
- depth: The place where this comment is in the three of comments (if it is an answer or an answer of an answer)
- id: The id for this comment
- locale: The locale (language) that the participant had when leaving this comment
- root_commentable_url: The URL of the resource that ties to this comment
- user_group: The name of the user group that made this comment (if any)
pages
- body: O corpo da página
- component: O componente a que a página pertence
- created_at: A data em que esta página foi criada
- id: O identificador único desta página
- participatory_space: A que espaço (por exemplo, Processo Participativo ou Assembleia) pertence esta página
- title: O título da página
- updated_at: A última data em que esta página foi actualizada
- url: O URL desta página
proposals
- address: The address of the proposal in case the proposal has a physical location
- answer: The answer to the proposal in the case it has been answered
- answered_at: The date when this proposal was answered
- attachments: The number of attachments this proposal has
- author: The data for the author of this proposal
- body: The proposal body
- coauthorships_count: The number of co-authorships the proposal represents
- comments: The number of comments this proposal has
- component: The component that the proposal belongs to
- cost: The total cost of the proposal in question
- cost_report: A report of costs for the proposal
- created_at: The date the proposal was created
- created_in_meeting: Whether the proposal was created in a meeting
- endorsements: The number of endorsements ("likes") this proposal has
- execution_period: The period at which the proposal ran from beginning to end
- follows_count: The number of followers this proposal has
- id: The unique identifier for the proposal
- is_amend: Wheter this proposal is ammedning another proposal
- latitude: The latitude of the proposal in case it has a physical location
- longitude: The longitude of the proposal in case it has a physical location
- meeting_urls: The URLs of the meetings where this proposal was presented or discussed in
- original_proposal: The reference of the original proposal if this is an amendment
- participatory_space: To which space (e.g. Participatory Process, or Assembly) this proposal belongs to
- published_at: The date when this proposal was published
- reference: The unique identifier of the resource in this platform
- related_proposals: The proposals related to this proposal
- state: The status of this proposal (e.g. "Accepted")
- state_published_at: A time stamp of the state of the proposal when published
- taxonomies: The taxonomies that this proposal belongs to
- title: The proposal title
- updated_at: The date the proposal was last updated
- url: The URL where this proposal can be found
- votes: The number of votes this proposal has
- withdrawn: Wheter this proposal has been withdrawn
- withdrawn_at: When this proposal was withdrawn
proposal_comments
- alignment: If this comment was a favour, against or neutral
- author: The name of the participant that made this comment
- body: The comment itself
- commentable_id: The unique id of the commentable
- commentable_type: The type of the commentable (if it was a result, a proposal, etc.)
- created_at: The date when this comment was created
- depth: The place where this comment is in the three of comments (if it is an answer or an answer of an answer)
- id: The id for this comment
- locale: The locale (language) that the participant had when leaving this comment
- root_commentable_url: The URL of the resource that ties to this comment
- user_group: The name of the user group that made this comment (if any)
Participatory spaces
participatory_processes
- announcement: The announcement (callout) information
- area: The area where the process is taking place
- created_at: The date this space was created
- description: A long description of the process
- developer_group: The developer group of the process. This is the organization that is promoting the process.
- end_date: The end date of the process
- follows_count: The number of users following this space
- hashtag: The process hashtag, used for Twitter/X
- id: The unique identifier of this process
- local_area: The local area of the process. This is the organization area where the process is taking place.
- meta_scope: The scope metadata of the process
- participatory_process_group: The group of the process, if there is any
- participatory_process_type: The type of the process
- participatory_scope: The participatory scope of the process
- participatory_structure: The participatory structure of the process. This is how the process is decided.
- promoted: Wheter the process is promoted or not
- published_at: The date this space was published
- reference: The unique reference of the space
- remote_hero_image_url: The URL of the process hero image
- scope: The scope of the process
- scopes_enabled: Whether the scopes are enabled or not
- short_description: A short description of the process
- slug: The process slug (used for identification purposes, for the URL)
- start_date: The start date of the process
- subtitle: The subtitle of the process
- target: The target of the process. This is who is called to participate in the process.
- title: The process title
- updated_at: The last date this space was updated
- url: The URL of the space
assemblies
- announcement: As informações do anúncio (chamada)
- area: A área da reunião
- assembly_type: O tipo de reunião
- closing_date: Data de encerramento da reunião
- closing_date_reason: Por que a assembleia foi fechada
- composition: A composição de reunião
- created_at: A data em que este espaço foi criado
- created_by: Quem criou esta reunião
- created_by_other: Outro criador da reunião
- creation_date: A data de criação desta reunião
- decidim_scope_id: O objetivo da reunião
- description: Uma descrição longa da reunião
- developer_group: O grupo de desenvolvimento da reunião
- duration: A duração da reunião
- facebook_handler: Responsável de redes sociais para o Facebook
- follows_count: O número de utilizadores que seguem este espaço
- github_handler: Responsável de redes sociais para o GitHub
- hashtag: A hashtag da reunião, usada para o Twitter/X
- id: O identificador exclusivo desta reunião
- included_at: A data em que a reunião foi incluída
- instagram_handler: Responsável de redes sociais para o Instagram
- internal_organisation: A organização interna desta reunião
- is_transparent: Onde a reunião é transparente ou não
- local_area: A localização da reunião
- meta_scope: Os metadados objetivo da reunião
- participatory_scope: O objetivo participativo da reunião
- participatory_structure: A estrutura participativa da reunião
- promoted: Se a reunião é promovida ou não
- published_at: A data em que este espaço foi publicado
- purpose_of_action: O objetivo da ação da reunião
- reference: A referência única do espaço
- remote_banner_image_url: A URL da imagem do banner da reunião
- remote_hero_image_url: A URL da imagem do herói da reunião
- scope: O objetivo da reunião
- scopes_enabled: Se os objetivos estão ou não ativados
- short_description: Uma descrição breve da reunião
- slug: O slug da reunião (usado para fins de identificação, para a URL)
- special_features: Quais são as características especiais desta reunião
- subtitle: O subtítulo da reunião
- target: O alvo da reunião
- taxonomies: As taxonomias do projeto
- title: O título da reunião
- twitter_handler: Responsável de redes sociais para o Twitter
- updated_at: A última data em que este espaço foi atualizado
- url: O URL do espaço
- youtube_handler: Responsável de redes sociais para o YouTube
conferences
- created_at: The date this space was created
- decidim_scope_id: The scope of the conference
- description: A long description of the conference
- end_date: The date when this conference ends.
- follows_count: The number of users following this space
- hashtag: The conference hashtag, used for Twitter/X
- id: The unique identifier of this conference
- location: The conference location. Where this conference will take place.
- objectives: The objectives for this conference. What is the goal.
- promoted: Wheter the conference is promoted or not
- published_at: The date this space was published
- reference: The unique reference of the space
- remote_banner_image_url: The URL of the conference banner image
- remote_hero_image_url: The URL of the conference hero image
- scope: The scope of the conference
- scopes_enabled: Weather the scopes are enabled or not
- short_description: A short description of the conference
- slogan: The slogan for this conference
- slug: The conference slug (used for identification purposes, for the URL)
- start_date: The date when this conference starts.
- taxonomies: The taxonomies of the conference
- title: The conference title
- updated_at: The last date this space was updated
- url: The URL of the space
Core
moderated_users
- about: The about field of the user
- block_reasons: The reason why the admin user blocked the user
- blocked_at: Date and time when the user has been blocked
- blocking_user: The name of the user that has performed the blocking
- details: The details of the reports
- reasons: A list of the reasons why the profile has been reported
- user_id: The unique ID of the reported user
moderations
- hidden_at: Date and time when the content has been hidden
- id: The unique identifier of the moderation
- report_count: The number of times it has been reported
- reportable_id: The unique id of the reportable
- reportable_type: Type of the reportable
- reported_content: The content that has been reported
- reported_url: The url of the reported resource
- reports: A list of reasons for which the resource has been reported
users
- about: The about text of the user
- avatar_url: The avatar of the user
- badge: The badge of the user
- deleted: Whether the user is deleted or not
- direct_messages_enabled: Whether the user allows direct messages
- groups: The id and name of the user group
- id: The unique identifier of the user
- name: The display name of user
- nickname: The username of the user
- profile_url: The profile url
user_groups
- avatar_url: The avatar of the user group
- badge: The badge of the user group
- deleted: Whether the user is deleted or not
- id: The unique identifier of the user group
- members: The id and name of the users belonging to the group
- members_count: The number of the users belonging to the user group
- name: The display name of user group
- nickname: The username of the user group
- profile_url: The profile url
metrics
- cumulative: The total number of the metric at this day
- day: The day this metric was created
- metric_type: The type of the metric
- quantity: The number of the metrics for this day
taxonomies
- children_count: The count of the children that this taxonomy has
- created_at: The date when this taxonomy was created
- filter_items_count: The number of items filters that are using this taxonomy
- filters_count: The number of filters that is using this taxonomy
- id: The unique identifier of this taxonomy
- is_root: True if this taxonomy do not have any parent
- name: The name of this taxonomy
- parent_id: The unique identifiers of this taxonomy parent (if any)
- part_of: Used to detect if this taxonomy is part of another taxonomy
- taxonomizations_count: The count of the resources that use this taxonomy
- updated_at: The date when this taxonomy was updated for the last time
- weight: The order in which this taxonomy is shown
This Lisboa Heritage Lab Participatory Platform database is made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.
Download resources
Components
- Download results in CSV format
- Download result_comments in CSV format
- Download posts in CSV format
- Download post_comments in CSV format
- Download projects in CSV format
- Download debates in CSV format
- Download debate_comments in CSV format
- Download meetings in CSV format
- Download meeting_comments in CSV format
- Download pages in CSV format
- Download proposals in CSV format
- Download proposal_comments in CSV format
Participatory spaces
- Download participatory_processes in CSV format
- Download assemblies in CSV format
- Download conferences in CSV format