# Open Data files for Viladecans Participa


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


## Core

### 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


### user_groups

* id: The unique identifier of the user group
* name: The display name of user group
* nickname: The username of the user group
* avatar_url: The avatar of the user group
* profile_url: The profile url
* deleted: Whether the user is deleted or not
* badge: The badge of the user group
* members_count: The number of the users belonging to the user group
* members: The id and name of the users belonging to the 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


### taxonomies

* id: The unique identifier of this taxonomy
* name: The name of this taxonomy
* parent_id: The unique identifiers of this taxonomy parent (if any)
* weight: The order in which this taxonomy is shown
* children_count: The count of the children that this taxonomy has
* taxonomizations_count: The count of the resources that use this taxonomy
* created_at: The date when this taxonomy was created
* updated_at: The date when this taxonomy was updated for the last time
* filters_count: The number of filters that is using this taxonomy
* filter_items_count: The number of items filters that are using this taxonomy
* part_of: Used to detect if this taxonomy is part of another taxonomy
* is_root: True if this taxonomy do not have any parent




## Components

### debates

* id: The unique identifier of the debate
* author: The data for the author of this debate
* title: The debate title
* description: The debate description
* instructions: Which are the instructions to comment in this debate
* start_time: When this debate starts, if it is an open debate and has a limited time
* end_time: When this debate ends, if it is an open debate and has a limited time
* information_updates: The updates that the author has made to the debate
* taxonomies: The taxonomies of the project
* participatory_space: To which space (e.g. Participatory Process, or Assembly) this debate belongs to
* component: The component that the debate belongs to
* reference: The unique identifier of the resource in this platform
* comments: The number of comments this debate has
* follows_count: The number of followers this debate has
* url: The URL where this debate can be found
* last_comment_at: The date when this debate was commented by the last time
* last_comment_by: The data of last comment made within the debate
* comments_enabled: Wether this debate has comments enabled or not
* conclusions: The conclusions of the debate if it was closed
* closed_at: The date when this debate was closed
* created_at: The date and time when the debate was created
* updated_at: The date of when the debate was last updated
* endorsements_count: The number of endorsements the debate has


### 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


### meeting_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


### pages

* id: The unique identifier of this page
* title: The page title
* body: The body of the page
* created_at: The date this page was created
* updated_at: The last date this page was updated
* participatory_space: To which space (e.g. Participatory Process, or Assembly) this page belongs to
* component: The component that the page belongs to
* url: The URL for this page


### 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



