Open Data

Benvenuto nella pagina Open Data di partecipa. Qui troverai file di dati generati periodicamente dai processi partecipativi e decisionali di partecipa. Questi file sono messi a disposizione per promuovere trasparenza, accessibilità e collaborazione. Di seguito troverai informazioni dettagliate sul contenuto dei file, su come aprirli e utilizzarli e sulla struttura dei dati.

Questi file contengono i dati esportati dai processi partecipativi di partecipa, come proposte, commenti e incontri. Si tratta di dati grezzi e strutturati che possono essere utilizzati per analisi, ricerca o integrazione con altri strumenti. I dati vengono aggiornati automaticamente ogni 24 ore, garantendo l'accesso alle informazioni più recenti.

I file sono in formato CSV (Comma-Separated Values), uno standard ampiamente utilizzato che può essere aperto ed elaborato con fogli di calcolo, editor di testo e strumenti di analisi dei dati.

1. Scaricare i file

Fai clic sui collegamenti riportati di seguito per scaricare i file CSV sul tuo computer.

2. Aprire i file

Fogli di calcolo: puoi aprire i file CSV con applicazioni come Microsoft Excel, Google Sheets o LibreOffice Calc. Apri l'applicazione, seleziona Apri dal menu File e scegli il file CSV scaricato.
Editor di testo: i file CSV possono essere aperti anche con qualsiasi editor di testo, come Blocco Note o Sublime Text. Verranno visualizzati i dati grezzi, con ogni riga che rappresenta un record e ogni valore separato da una virgola.
Strumenti di analisi dei dati: se utilizzi strumenti come Python (con pandas), R o database SQL, puoi importare direttamente questi file CSV per elaborarli e analizzarli.

3. Lavorare con i dati

Filtrare e ordinare: nelle applicazioni per fogli di calcolo puoi filtrare e ordinare i dati per concentrarti sulle informazioni di tuo interesse.
Analizzare: utilizza i dati per eseguire analisi, ad esempio contare le proposte, studiare l'andamento dei commenti o valutare la partecipazione agli incontri.
Visualizzare: crea grafici, diagrammi e altre rappresentazioni visive per interpretare meglio i dati.

Di seguito è riportata la descrizione di ciascun dataset, inclusi lo schema (struttura) e il tipo di informazioni contenute:

Componenti

results

address: L'indirizzo dell'eventuale risultato
children_count: Il numero di risultati figli
comments_count: Il numero di commenti che questo risultato ha
component: Il componente a cui il risultato appartiene
created_at: La data in cui il risultato è stato creato
description: La descrizione del risultato
end_date: La data in cui il risultato termina l'esecuzione ed è finito
id: L'identificatore univoco del risultato
latitude: La latitudine del risultato nel caso in cui abbia un luogo fisico
longitude: La longitudine del risultato nel caso in cui abbia una luogo fisico
parent: Il risultato principale (se presente) del risultato
progress: La percentuale di esecuzione del risultato
proposal_urls: Gli URL delle proposte che sono incluse in questo risultato
reference: L'identificatore univoco del risultato
start_date: La data in cui il risultato inizia l'esecuzione
status: Lo stato attuale di questo risultato
taxonomies: Le tassonomie del risultato
title: Il titolo del risultato
updated_at: L'ultima data in cui questo risultato è stato aggiornato
url: L'URL dove questo risultato può essere trovato

result_comments

alignment: Se questo commento è stato a favore, contro o neutrale
author: Il nome del partecipante che ha fatto questo commento
body: Il commento stesso
commentable_id: L'id unico del commentabile
commentable_type: Il tipo di commentabile (se è stato un risultato, una proposta, ecc.)
created_at: La data in cui questo commento è stato creato
depth: Il luogo in cui tale commento figura nel tre dei commenti (se si tratta di una risposta o di una risposta)
id: L'id di questo commento
locale: Il Locale (lingua) che il partecipante aveva quando ha lasciato questo commento
root_commentable_url: L'URL della risorsa che si lega a questo commento

posts

author: The information of the author
body: The body of the post
comments_count: The number of comments this post has
component: The component that the post belongs to
created_at: The date this post was created
follows_count: The number of follows this post has
id: The unique identifier of this post
likes_count: The number of likes this post has
participatory_space: To which space (e.g. Participatory Process, or Assembly) this post belongs to
published_at: The date this post was published
title: The title of the post
updated_at: The last date this post was updated
url: The URL for this post

post_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

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

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
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 embedded 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 a response or a response of a response)
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

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: The content of the response
created_at: Timestamp when the response was created
id: Unique identifier for the survey response
ip_hash: Hashed IP address of the respondent for privacy
question: The question that was Responded
registered: Registered participant
unregistered: Unregistered participant
user_status: Status of the user who submitted the response

Spazi partecipativi

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

area: L'area dell'assemblea
assembly_type: Il tipo di assemblea
closing_date: La data di chiusura dell'assemblea
closing_date_reason: Perché l'assemblea è stata chiusa
composition: La composizione dell'assemblea
created_at: La data in cui questo spazio è stato creato
created_by: Chi ha creato questa assemblea
created_by_other: Altro creatore dell'assemblea
creation_date: La data di creazione di questa assemblea
decidim_scope_id: L'ambito tematico dell'assemblea
description: Una lunga descrizione dell'assemblea
developer_group: Il gruppo sviluppatore dell'assemblea
duration: La durata dell'assemblea
facebook_handler: Responsabile dei social media per Facebook
follows_count: Il numero di utenti che seguono questo spazio
github_handler: Gestore di social media per GitHub
id: L'identificatore univoco per questa assemblea
included_at: La data in cui l'assemblea è stata inclusa
instagram_handler: Gestore di social media per Instagram
internal_organisation: L'organizzazione interna di questa assemblea
is_transparent: Dove l'asseblea è trasparente o non trasparente
local_area: La zona locale dell'assemblea
meta_scope: I metadati di ambito dell'assemblea
participatory_scope: L'ambito partecipativo dell'assemblea
participatory_structure: La struttura partecipativa dell'assemblea
promoted: Promosse
published_at: La data di pubblicazione di questo spazio
purpose_of_action: Lo scopo dell'azione dell'assemblea
reference: Il riferimento unico dello spazio
remote_banner_image_url: L'URL dell'immagine banner dell'assemblea
remote_hero_image_url: L'URL dell'immagine principale dell'assemblea
scope: L'ambito tematico dell'assemblea
scopes_enabled: Se gli ambiti tematici sono abilitati o meno
short_description: Breve descrizione dell'assemblea
slug: Slug url dell'assemblea (Usato per identificare l'url corretto)
special_features: Quali caratteristiche speciali ha questa assemblea
subtitle: Il sottotitolo dell'assemblea
target: Il target dell'assemblea
taxonomies: Le categorizzazioni dello spazio
title: Il titolo dell'assemblea
twitter_handler: Gestore di social media per X
updated_at: L'ultima data in cui questo spazio è stato aggiornato
url: L'URL dello spazio
youtube_handler: Gestore di social media per YouTube

Dati principali

moderated_users

about: Testo "Informazioni" dell'utente
block_reasons: Motivo per cui l'amministratore ha bloccato l'utente
blocked_at: Data e ora del blocco dell'utente
blocking_user: Nome dell'amministratore che ha effettuato il blocco
details: Dettagli delle segnalazioni
reasons: Elenco dei motivi della segnalazione del profilo
user_id: Identificativo univoco dell'utente segnalato

moderations

hidden_at: Data e ora in cui il contenuto è stato nascosto
id: Identificativo univoco della moderazione
report_count: Numero di segnalazioni ricevute
reportable_id: Identificativo univoco dell'elemento segnalato
reportable_type: Tipo dell'elemento segnalato
reported_content: Contenuto segnalato
reported_url: URL della risorsa segnalata
reports: Elenco dei motivi della segnalazione

users

about: Testo di presentazione dell'utente
avatar_url: Avatar dell'utente
badge: Badge dell'utente
deleted: Indica se l'utente è stato eliminato
direct_messages_enabled: Indica se l'utente consente i messaggi diretti
groups: Identificativo e nome del gruppo utenti
id: Identificativo univoco dell'utente
name: Nome visualizzato dell'utente
nickname: Nome utente
profile_url: URL del profilo

taxonomies

children_count: Numero di tassonomie figlie
created_at: Data di creazione della tassonomia
filter_items_count: Numero di elementi filtro che utilizzano questa tassonomia
filters_count: Numero di filtri che utilizzano questa tassonomia
id: Identificativo univoco della tassonomia
is_root: Indica se la tassonomia è principale (senza padre)
name: Nome della tassonomia
parent_id: Identificativo della tassonomia padre (se presente)
part_of: Indica se la tassonomia fa parte di un'altra tassonomia
taxonomizations_count: Numero di risorse che utilizzano questa tassonomia
updated_at: Data dell'ultimo aggiornamento della tassonomia
weight: Ordine di visualizzazione della tassonomia

Open Data

Cosa contengono questi file?

Come aprire e utilizzare questi file

1. Scaricare i file

2. Aprire i file

3. Lavorare con i dati