# Open Data files for 170-175 High Street West Collaborative Lab - Sunderland


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


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


### assemblies

* id: The unique identifier of this assembly
* title: The assembly title
* slug: The assembly 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 assembly hashtag, used for Twitter/X
* short_description: A short description of the assembly
* description: A long description of the assembly
* promoted: Wheter the assembly is promoted or not
* url: The URL of the space
* subtitle: The subtitle of the assembly
* remote_hero_image_url: The URL of the assembly hero image
* remote_banner_image_url: The URL of the assembly banner image
* announcement: The announcement (callout) information
* developer_group: The developer group of the assembly
* local_area: The local area of the assembly
* meta_scope: The scope metadata of the assembly
* participatory_scope: The participatory scope of the assembly
* purpose_of_action: The purpose of action of the assembly
* composition: The composition of the assembly
* duration: The duration of the assembly
* participatory_structure: The participatory structure of the assembly
* target: The target of the assembly
* decidim_scope_id: The scope of the assembly
* area: The area of the assembly
* scope: The scope of the assembly
* scopes_enabled: Weather the scopes are enabled or not
* included_at: The date when the assembly was included
* closing_date: The closing date of the assembly
* created_by: Who has created this assembly
* creation_date: The date of creation of this assembly
* closing_date_reason: Why the assembly was closed
* internal_organisation: The internal organisation of this assembly
* is_transparent: Where the assembly is transparent or not
* special_features: Which special features this assembly has
* twitter_handler: Social media handler for Twitter
* instagram_handler: Social media handler for Instagram
* facebook_handler: Social media handler for Facebook
* youtube_handler: Social media handler for YouTube
* github_handler: Social media handler for GitHub
* created_by_other: Other creator of the assembly
* assembly_type: The type of the assembly


### conferences

* id: The unique identifier of this conference
* title: The conference title
* slug: The conference 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 conference hashtag, used for Twitter/X
* short_description: A short description of the conference
* description: A long description of the conference
* promoted: Wheter the conference is promoted or not
* url: The URL of the space
* slogan: The slogan for this conference
* remote_hero_image_url: The URL of the conference hero image
* remote_banner_image_url: The URL of the conference banner image
* location: The conference location. Where this conference will take place.
* objectives: The objectives for this conference. What is the goal.
* start_date: The date when this conference starts.
* end_date: The date when this conference ends.
* scopes_enabled: Weather the scopes are enabled or not
* decidim_scope_id: The scope of the conference
* scope: The scope of the conference



## Components

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



