Open Data
Welcome to the Langosh, Kshlerin and Emmerich Open Data page. Here, you will find data files that are regularly generated from various deliberative and governance processes within Langosh, Kshlerin and Emmerich. 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 Langosh, Kshlerin and Emmerich'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. Descărcați fișierele
Dați click pe link-urile de mai jos pentru a descărca fișierele CSV în computer.2. Deschideți fișierele
- Aplicaţii Spreadsheet: Puteţi deschide fişiere CSV folosind aplicaţii precum Microsoft Excel, Google Sheets sau LibreOffice Calc. Pur şi simplu deschideţi aplicaţia, apoi selectaţi "Deschide" din meniul de fişiere, şi alegeţi fişierul CSV descărcat.
- Editori de Text: fişierele CSV pot fi deschise şi în orice editor de text, precum Notepad sau Text Sublime. Acest lucru va afișa datele brute, cu fiecare linie reprezentând un rând și fiecare valoare separate prin virgulă.
- Instrumente de analiză a datelor: Dacă sunteţi familiarizaţi cu instrumente de analiză a datelor precum Python (cu pandas), R, sau baze de date SQL, puteţi importa aceste fişiere CSV direct pentru procesare şi analiză.
3. Lucrul cu datele
- Filtrare și sortare: În aplicațiile tabelei de calcul puteți filtra și sorta datele pentru a vă concentra pe anumite subseturi de informații.
- Analiza: Utilizeazați datele pentru a efectua diverse analize, cum ar fi luarea în considerare a numărului de propuneri, analiza tendinţelor observaţiilor sau evaluarea participării la reuniuni.
- Vizualizare: Puteţi crea grafice, grafice şi alte vizualizări pentru a ajuta la interpretarea datelor.
Mai jos este prezentată o descriere a fiecărui set de date, inclusiv schema (structura) sa și tipul de informații pe care le conține:
Componente
results
- address: Adresa rezultatului (dacă există)
- children_count: Numărul rezultatelor copii
- comments_count: Numărul de comentarii pe care le are acest rezultat
- component: Componenta căreia îi aparține rezultatul
- created_at: Data când acest rezultat a fost creat
- description: Descrierea rezultatului
- end_date: Data la care încetează este terminat rezultatul și execuția încetează
- id: Identificatorul unic al acestui rezultat
- latitude: Latitudinea rezultatului în cazul în care acesta are o localizare fizică
- longitude: Longitudinea rezultatului în cazul în care are o localizare fizică
- parent: Rezultatul părinte (dacă există) al rezultatului
- progress: Procentul de execuție al rezultatului
- proposal_urls: URL-urile propunerilor care sunt incluse în acest rezultat
- reference: Referința unică a rezultatului
- start_date: Data la care începe execuția rezultatului
- status: Starea actuală a acestui rezultat
- taxonomies: Taxonomiile rezultatului
- title: Titlul rezultatului
- updated_at: Ultima dată când acest rezultat a fost actualizat
- url: URL-ul unde acest rezultat poate fi găsit
result_comments
- alignment: În cazul în care acest comentariu a fost favorabil, contrar sau neutru
- author: Numele participantului care a făcut acest comentariu
- body: Comentariul în sine
- commentable_id: Id-ul unic al comentariului
- commentable_type: Tipul resursei comentate (dacă este întâlnire, propunere etc.)
- created_at: Data când acest comentariu a fost creat
- depth: Locul în care acest comentariu este în arborele de comentarii (dacă este un răspuns sau un răspuns la un răspuns)
- id: Id-ul unic al comentariului
- locale: Localizarea (limba) pe care participantul a folosit-o atunci când a lăsat acest comentariu
- root_commentable_url: URL-ul resursei unde a fost lăsat acest comentariu
posts
- author: Informațiile autorului
- body: Conținutul postării
- comments_count: Numărul de comentarii pe care le are această postare
- component: Componenta căreia îi aparține postarea
- created_at: Data la care acestă postare a fost creată
- follows_count: Numărul de urmăritori al acestei postări
- id: Identificatorul unic al acestei postări
- likes_count: Numărul de aprecieri pe care le are această postare
- participatory_space: Cărui spațiu (de exemplu, proces participativ sau adunare) aparține această postare
- published_at: Data la care acestă postare a fost publicată
- title: Titlul postării
- updated_at: Ultima dată când această postare a fost actualizată
- url: URL-ul pentru această postare
post_comments
- alignment: Acest comentariu a fost favorabil, contrar sau neutru
- author: Numele participantului care a făcut acest comentariu
- body: Comentariul în sine
- commentable_id: Id-ul unic al resursei comentate
- commentable_type: Tipul resursei comentate (dacă este întâlnire, propunere etc.)
- created_at: Data la care acest comentariu a fost creat
- depth: Locul în care acest comentariu este în cele trei comentarii (dacă este un răspuns sau un răspuns la un răspuns)
- id: Id-ul unic al comentariului
- locale: Localizarea (limba) pe care participantul a folosit-o atunci când a lăsat acest comentariu
- root_commentable_url: URL-ul resursei care se leagă de acest comentariu
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: The data for the author of this debate
- closed_at: The date when this debate was closed
- comments: The number of comments this debate has
- comments_enabled: Wether this debate has comments enabled or not
- component: The component that the debate belongs to
- conclusions: The conclusions of the debate if it was closed
- created_at: The date and time when the debate was created
- description: The debate description
- end_time: When this debate ends, if it is an open debate and has a limited time
- follows_count: The number of followers this debate has
- id: The unique identifier of the debate
- information_updates: The updates that the author has made to the debate
- instructions: Which are the instructions to comment in this debate
- 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
- likes_count: The number of likes the debate has
- participatory_space: To which space (e.g. Participatory Process, or Assembly) this debate belongs to
- reference: The unique identifier of the resource in this platform
- start_time: When this debate starts, if it is an open debate and has a limited time
- taxonomies: The taxonomies of the project
- title: The debate title
- updated_at: The date of when the debate was last updated
- url: The URL where this debate can be found
debate_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
meetings
- attending_organizations: Organizațiile participante la întâlnire
- audio_url: Înregistrarea audio a întâlnirii
- iframe_embed_type: Tipul de iframe încorporat în ședință
- location_hints: O indicație a locului în care se desfășoară întâlnirea
- registration_type: Tipul de înregistrare pentru participare la întâlnire
- registration_url: URL-ul pentru înregistrare ca participant la întâlnire
- registrations_enabled: Dacă înregistrările participanților au fost permise
- reserved_slots: Numărul de locuri rezervate pe care le are întâlnirea
- type_of_meeting: Tipul întâlnirii
- updated_at: Data și ora la care întâlnirea a fost actualizată ultima dată
meeting_comments
- comments: Observațiile privind întâlnirea
pages
- body: Conținutul postării
- component: Componenta căreia îi aparține pagina
- created_at: Data la care a fost creată această pagină
- id: Identificatorul unic al acestei pagini
- participatory_space: Cărui spațiu (de exemplu, proces participativ sau adunare) aparține această pagină
- title: Titlul paginii
- updated_at: Ultima dată la care această pagină a fost actualizată
- url: URL-ul pentru această pagină
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
- 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
- likes: The number of likes ("likes") this proposal has
- 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
published_survey_user_responses
- body: Conținutul răspunsului
- created_at: Data și ora când a fost creat răspunsul
- id: Identificator unic pentru răspunsurile sondajului
- ip_hash: Semnătura adresei IP a respondentului pentru confidențialitate
- question: Întrebarea la care s-a răspuns
- registered: Participant înregistrat
- unregistered: Participant neînregistrat
- user_status: Starea participantului care a trimis răspunsul
Spatii participative
participatory_processes
- access_mode: Access mode. Wheter the process is open, restricted or transparent.
- area: The area where the process is taking place
- component_settings: The component settings of the process
- 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
- 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
- access_mode: Access mode. Whether the assembly is open, restricted, or transparent.
- area: The area of the assembly
- assembly_type: The type of the assembly
- closing_date: The closing date of the assembly
- closing_date_reason: Why the assembly was closed
- component_settings: The component settings of the assembly
- composition: The composition of the assembly
- created_at: The date this space was created
- created_by: Who has created this assembly
- created_by_other: Other creator of the assembly
- creation_date: The date of creation of this assembly
- decidim_scope_id: The scope of the assembly
- description: A long description of the assembly
- developer_group: The developer group of the assembly
- duration: The duration of the assembly
- facebook_handler: Social media handler for Facebook
- follows_count: The number of users following this space
- github_handler: Social media handler for GitHub
- id: The unique identifier of this assembly
- included_at: The date when the assembly was included
- instagram_handler: Social media handler for Instagram
- internal_organisation: The internal organisation of this assembly
- is_transparent: Where the assembly is transparent or not
- local_area: The local area of the assembly
- meta_scope: The scope metadata of the assembly
- participatory_scope: The participatory scope of the assembly
- participatory_structure: The participatory structure of the assembly
- promoted: Wheter the assembly is promoted or not
- published_at: The date this space was published
- purpose_of_action: The purpose of action of the assembly
- reference: The unique reference of the space
- remote_banner_image_url: The URL of the assembly banner image
- remote_hero_image_url: The URL of the assembly hero image
- scope: The scope of the assembly
- scopes_enabled: Weather the scopes are enabled or not
- short_description: A short description of the assembly
- slug: The assembly slug (used for identification purposes, for the URL)
- special_features: Which special features this assembly has
- subtitle: The subtitle of the assembly
- target: The target of the assembly
- taxonomies: The taxonomies of the project
- title: The assembly title
- twitter_handler: Social media handler for Twitter
- updated_at: The last date this space was updated
- url: The URL of the space
- youtube_handler: Social media handler for YouTube
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: Textul de descriere a participantului
- direct_messages_enabled: Dacă utilizatorul permite mesaje directe
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 Langosh, Kshlerin and Emmerich database is made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.
Descărcați resurse
Componente
- 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
- Download published_survey_user_responses in CSV format