# Open Data files for Citizens' Engagement Platform


This ZIP file contains files for studying and researching about this participation platform.


## Core

### moderated_users

* user_id: The unique ID of the reported user
* blocked_at: Date and time when the user has been blocked
* about: The about field of the user
* reasons: A list of the reasons why the profile has been reported
* details: The details of the reports
* block_reasons: The reason why the admin user blocked the user
* blocking_user: The name of the user that has performed the blocking


### moderations

* id: The unique identifier of the moderation
* hidden_at: Date and time when the content has been hidden
* report_count: The number of times it has been reported
* reported_url: The url of the reported resource
* reportable_type: Type of the reportable
* reportable_id: The unique id of the reportable
* reported_content: The content that has been reported
* reports: A list of reasons for which the resource has been reported


### users

* id: The unique identifier of the user
* name: The display name of user
* nickname: The username of the user
* about: The about text of the user
* avatar_url: The avatar of the user
* profile_url: The profile url
* direct_messages_enabled: Whether the user allows direct messages
* deleted: Whether the user is deleted or not
* badge: The badge of the user
* groups: The id and name of the user group


### metrics

* day: The day this metric was created
* metric_type: The type of the metric
* cumulative: The total number of the metric at this day
* quantity: The number of the metrics for this day



## Spaces

### participatory_processes

* id: The unique identifier of this process
* title: The process title
* slug: The process slug (used for identification purposes, for the URL)
* reference: The unique reference of the space
* created_at: The date this space was created
* updated_at: The last date this space was updated
* published_at: The date this space was published
* follows_count: The number of users following this space
* hashtag: The process hashtag, used for Twitter/X
* short_description: A short description of the process
* description: A long description of the process
* promoted: Wheter the process is promoted or not
* url: The URL of the space
* subtitle: The subtitle of the process
* remote_hero_image_url: The URL of the process hero image
* announcement: The announcement (callout) information
* start_date: The start date of the process
* end_date: The end date of the process
* developer_group: The developer group of the process. This is the organization that is promoting the 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_scope: The participatory scope of the process
* participatory_structure: The participatory structure of the process. This is how the process is decided.
* target: The target of the process. This is who is called to participate in the process.
* area: The area where the process is taking place
* participatory_process_group: The group of the process, if there is any
* scope: The scope of the process
* scopes_enabled: Whether the scopes are enabled or not
* participatory_process_type: The type of the process



## Components

### meetings

* id: The unique identifier of the meeting
* author: The data for the author of this meeting
* participatory_space: To which space (e.g. Participatory Process, or Assembly) this meeting belongs to
* taxonomies: The taxonomies that this meeting belongs to
* component: The component that the meeting belongs to
* title: The title of the meeting
* description: The description of the meeting
* start_time: The date and time that this meeting starts
* end_time: The date and time that this meeting ends
* attendees: The number of people attending this meeting
* contributions: The number of contributions in this meeting made by the atteendes
* organizations: The organizations attending this meeting
* address: The address of the meeting in case it is in person and has a physical location
* location: The location of the meeting
* reference: The unique identifier of the resource in this platform
* attachments: The number of attachments in this meeting
* url: The URL of the meeting
* related_proposals: The proposals related to this meeting
* related_results: The results related to this meeting
* published: When the meeting has been published
* withdrawn: Whether this meeting has been withdrawn
* withdrawn_at: When this meeting was withdrawn
* location_hints: A hint of the location in which the meeting is taking place
* created_at: The date at which the meeting was created
* updated_at: The time at which the meeting was last updated
* latitude: The latitude of the meeting
* longitude: The longitude of the meeting
* follows_count: The number of follows the meeting has
* private_meeting: To indicate whether the meeting is private or not
* transparent: The visabilty of the meetng for non-members
* registration_form_enabled: Whether the registration form was enabled or not
* comments: The comments data of the meeting
* online_meeting_url: The URL of the online meeting
* closing_visible: The visibilty of the meeting
* closing_report: Report of the closed meeting
* attending_organizations: The organizations attending the meeting
* registration_url: URL of the meeting registration
* decidim_user_group_id: User group ID of people involved in the meeting
* decidim_author_type: Author type of the meeting's author
* video_url: Video recording of the meeting
* audio_url: Audio recording of the meeting
* closed_at: The date at which the meeting closed
* registration_terms: The terms agreed prior to meeting participation
* available_slots: The number of slots available in a meeting
* registrations_enabled: Whether registrations were permitted
* customize_registration_email: The ability to allow a custom email at registration
* type_of_meeting: The meeting type
* iframe_access_level: The iframe access level of the meeting
* iframe_embed_type: The type of iframe embeded in the meeting
* reserved_slots: The number of reserved slots the meeting has
* registration_type: The type of registration of the meeting


### proposals

* id: The unique identifier for the proposal
* author: The data for the author of this proposal
* taxonomies: The taxonomies that this proposal belongs to
* participatory_space: To which space (e.g. Participatory Process, or Assembly) this proposal belongs to
* component: The component that the proposal belongs to
* title: The proposal title
* body: The proposal body
* address: The address of the proposal in case the proposal has a physical location
* 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
* state: The status of this proposal (e.g. "Accepted")
* state_published_at: A time stamp of the state of the proposal when published
* reference: The unique identifier of the resource in this platform
* answer: The answer to the proposal in the case it has been answered
* answered_at: The date when this proposal was answered
* votes: The number of votes this proposal has
* endorsements: The number of endorsements ("likes") this proposal has
* comments: The number of comments this proposal has
* attachments: The number of attachments this proposal has
* follows_count: The number of followers this proposal has
* published_at: The date when this proposal was published
* url: The URL where this proposal can be found
* meeting_urls: The URLs of the meetings where this proposal was presented or discussed in
* related_proposals: The proposals related to this proposal
* is_amend: Wheter this proposal is ammedning another proposal
* original_proposal: The reference of the original proposal if this is an amendment
* withdrawn: Wheter this proposal has been withdrawn
* withdrawn_at: When this proposal was withdrawn
* created_at: The date the proposal was created
* updated_at: The date the proposal was last updated
* created_in_meeting: Whether the proposal was created in a meeting
* coauthorships_count: The number of co-authorships the proposal represents
* cost: The total cost of the proposal in question
* cost_report: A report of costs for the proposal
* execution_period: The period at which the proposal ran from beginning to end


### proposal_comments

* id: The id for this comment
* created_at: The date when this comment was created
* body: The comment itself
* locale: The locale (language) that the participant had when leaving this comment
* author: The name of the participant that made this comment
* alignment: If this comment was a favour, against or neutral
* depth: The place where this comment is in the three of comments (if it is an answer or an answer of an answer)
* user_group: The name of the user group that made this comment (if any)
* commentable_id: The unique id of the commentable
* commentable_type: The type of the commentable (if it was a result, a proposal, etc.)
* root_commentable_url: The URL of the resource that ties to this comment



