Open Data
Benvenuto nella pagina Open Data di Nonantola Partecipa - DEMO non ufficiale. Qui trovi i file di dati generati periodicamente dai processi deliberativi e di governo di Nonantola Partecipa - DEMO non ufficiale, resi disponibili per favorire trasparenza, accessibilità e collaborazione. Più sotto trovi informazioni su cosa sono questi file, come aprirli e usarli, e la descrizione del contenuto e della struttura di ciascuno.
Questi file sono dataset esportati dai processi partecipativi di Nonantola Partecipa - DEMO non ufficiale, come proposte, commenti e incontri. Contengono dati grezzi e strutturati utilizzabili per analisi, ricerche o integrazione con altri strumenti. I dati vengono aggiornati automaticamente ogni 24 ore.
I file sono in formato CSV (valori separati da virgola), un formato molto diffuso che si apre con molti programmi: fogli di calcolo, editor di testo e strumenti di analisi dati.
1. Scarica i file
Clicca sui link qui sotto per scaricare i file CSV sul tuo computer.2. Apri i file
- Fogli di calcolo: puoi aprire i file CSV con Microsoft Excel, Google Sheets o LibreOffice Calc. Apri il programma, scegli "Apri" dal menu File e seleziona il file CSV scaricato.
- Editor di testo: i file CSV si aprono anche con qualsiasi editor di testo, come Blocco note o Sublime Text. Vedrai i dati grezzi, con una riga per record e i valori separati da virgole.
- Strumenti di analisi dati: se usi strumenti come Python (con pandas), R o database SQL, puoi importare direttamente questi file CSV per elaborarli e analizzarli.
3. Lavorare con i dati
- Filtri e ordinamento: nei fogli di calcolo puoi filtrare e ordinare i dati per concentrarti su sottoinsiemi specifici.
- Analisi: usa i dati per varie analisi, come contare le proposte, studiare l'andamento dei commenti o valutare la partecipazione agli incontri.
- Visualizzazione: puoi creare grafici e altre visualizzazioni per interpretare i dati.
Di seguito la descrizione di ogni dataset, con il relativo schema (struttura) e il tipo di informazioni che contiene:
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 embeded 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
pages
- body: The body of the page
- component: The component that the page belongs to
- created_at: The date this page was created
- id: The unique identifier of this page
- participatory_space: To which space (e.g. Participatory Process, or Assembly) this page belongs to
- title: The page title
- updated_at: The last date this page was updated
- url: The URL for this page
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
Spazi partecipativi
participatory_processes
- announcement: The announcement (callout) information
- area: The area where the process is taking place
- 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
- announcement: Informazioni sull'annuncio (callout)
- 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
Base
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: The about text of the user
- avatar_url: The avatar of the user
- badge: The badge of the user
- deleted: Whether the user is deleted or not
- direct_messages_enabled: Whether the user allows direct messages
- groups: The id and name of the user group
- id: The unique identifier of the user
- name: The display name of user
- nickname: The username of the user
- profile_url: The profile url
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
Questo database di Nonantola Partecipa - DEMO non ufficiale è reso disponibile con licenza Open Database License. Gli eventuali diritti sui singoli contenuti del database sono concessi con licenza Database Contents License.
Scarica le risorse
Componenti
- Scarica results in formato CSV
- Scarica result_comments in formato CSV
- Scarica posts in formato CSV
- Scarica post_comments in formato CSV
- Scarica projects in formato CSV
- Scarica debates in formato CSV
- Scarica debate_comments in formato CSV
- Scarica meetings in formato CSV
- Scarica meeting_comments in formato CSV
- Scarica pages in formato CSV
- Scarica proposals in formato CSV
- Scarica proposal_comments in formato CSV