indecis.it data

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/categories.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/sources.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/lists.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/parties.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/coalitions.csv
• Delimiter: ,
• Encoding: UTF-8

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

📄 leaders.csv

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/leaders.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/items.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/glossary.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/endorsements.csv
• Delimiter: ,
• Encoding: UTF-8

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

• Path: data/
• URL: https://raw.githubusercontent.com/indecis-it/data/main/data/press.csv
• Delimiter: ,
• Encoding: UTF-8

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