Skip to content

Latest commit

 

History

History
234 lines (194 loc) · 10.4 KB

README.md

File metadata and controls

234 lines (194 loc) · 10.4 KB

indecis.it data

Frictionless License: CC BY 4.0

This dataset was created during the italian election campaign of 2022. indecis.it website fetches and display these data in order to highlight differences in electoral programs.

Data are downloaded from this Google Sheet and are available thanks to these wonderful people.

Repository structure

root
├── 📂 data
│   ├── 📄 categories.csv
│   ├── 📄 categories.json
│   ├── 📄 file.csv
│   └── 📄 file.json
├── 📂 script
│   └── 📄 download.sh
├── 📄 datapackage.yaml
├── 📄 README.md
└── 📄 LICENSE

Data dictionary and metadata

Every file in data folder is described according to frictionless data standards in the datapackage.yaml

📄 categories.csv

field type description example
id integer Category ID 1
slug string Category slug economic-affairs
name string Italian name of the category Affari economici
description string Italian description of the category Lorem ipsum

📄 sources.csv

field type description example
id integer Source ID 1
title string Source title Programma elettorale PD
slug string Source slug programma-elettorale-pd
type string Source type programma
url URL Source URL https://www.indecis.it
list string Electoral list name Partito Democratico
list_id integer Electoral list ID 1

📄 lists.csv

field type description example
id integer Electoral list ID 1
list string Electoral list name Partito Democratico
slug string Electoral list slug programma-elettorale-pd
symbol_name string Symbol filename pd.jpg
symbol_url URL Symbol URL https://raw.githubusercontent.com/indecis-it/indecis.it/main/public/symbols/pd.jpg

📄 parties.csv

field type description example
id integer Party ID 1
party string Party name Partito Democratico
list_id integer Electoral list ID 5
list string Electoral list name Partito Democratico
coalition_id integer Coalition ID 1
coalition string Coalition name Centro-sinistra

📄 coalitions.csv

field type description example
id integer Coalition ID 1
coalition string Coalition name Centro-sinistra

📄 leaders.csv

field type description example
id integer Leader ID 1
name string Leader name Giorgia
surname string Leader surname Meloni
list string Electoral list name Fratelli d'Italia
list_id string Electoral list ID 1
profile_pic URL Profile image URL https://www.indecis.it
wikipedia_url URL Wikipedia page URL https://www.indecis.it

📄 items.csv

field type description example
id integer Item ID 3
category string Category name in Italian Social protection
category_id integer Category ID 10
subject string Subject name Alloggi popolari
subject_slug string Subject slug alloggi-popolari
subject_id string Subject ID  
source string Source title Programma elettorale AVS
source_slug string Source slug programma-elettorale-avs
list string Electoral list name Alleanza Verdi e Sinistra
list_id integer Electoral list ID 6
endorsement string Endorsement referred to the subject. See endorsements file for more information green
description string Description of the position taken by the list Lorem ipsum

📄 glossary.csv

field type description example
id integer Subject ID 1
subject string Subject name Alloggi popolari
slug string Subject slug alloggi-popolari
url URL URL of an external reference https://it.wikipedia.org/wiki/Tariffe_del_gas
source string External source name Wikipedia
title string Title of the web page Tariffe del gas
description string Explanation of the subject Lorem ipsum

📄 endorsements.csv

field type description example
id integer Endorsement ID 1
description string Description of endorsement types Lorem ipsum
icon string Color of the icon to display green
color_code string HEX code #50CEBB

📄 press.csv

field type description example
id integer Row ID 1
post_id integer Post ID 1
url string Post URL https://indecis.it
post_title string Post title Lorem ipsum
post_subtitle string Post subtitle Lorem ipsum
type string Post type articolo
source string Post source Lorem ipsum
subject string Subject name Nucleare
list string Electoral list name Partito Democratico
subject_id integer Subject ID 1
list_id integer Electoral list ID 1

How to access data

If you wanna use indecis.it data in your works, you can follow these easy instructions. Locate the raw URL of the file you are interested in and use it as follows

Google Sheets

You can import a CSV file in your Google Spreadsheet by entering this formula in a cell

=IMPORTDATA("https://raw.githubusercontent.com/indecis-it/data/main/data/categories.csv")

R

You can import the entire dataset in R using this code

categories <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/categories.csv")
coalitions <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/coalitions.csv")
endorsements <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/endorsements.csv")
glossary <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/glossary.csv")
items <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/items.csv")
leaders <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/leaders.csv")
lists <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/lists.csv")
parties <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/parties.csv")
press <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/press.csv")
relic <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/relic.csv")
sources <- read.csv("https://raw.githubusercontent.com/indecis-it/data/main/data/sources.csv")

MATLAB

You can import the entire dataset in MATLAB using this code

categories = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/categories.csv")
coalitions = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/coalitions.csv")
endorsements = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/endorsements.csv")
glossary = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/glossary.csv")
items = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/items.csv")
leaders = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/leaders.csv")
lists = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/lists.csv")
parties = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/parties.csv")
press = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/press.csv")
relic = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/relic.csv")
sources = readtable("https://raw.githubusercontent.com/indecis-it/data/main/data/sources.csv")

License