Exploring the data on your own

In addition to browsing the data with the help of the four visualisation tools (where you can download the data used to create the chart in CSV and RDF), you are able to download the whole database in XLS, CSV and SQL. In the near future the complete database will be provided as a graph in RDF for download. Furthermore a Linked Data -/ SPARQL endpoint to explore the data directly will be created.

The database with the selected indicators of the Digital Agenda Scoreboard is made of three tables:
  • a data table, with codes for the indicators, countries, years and values
  • an indicators table, with labels for indicators' codes, definition and scope, and a source code
  • a sources table, with details about sources and links to more methodological information
The codes allow the creation of relations between the tables.

XLS and CSV download

The following xls file contains all the three tables:

There is a csv file for each one of the basic tables of the database:

SQL download

There is a sql file for each one of the basic tables of the database:

RDF model

The digital scoreboard data is accessible as linked open data in RDF following the DataCube vocabulary. DataCube standarizes the publishing of statistical information on the semantic web. It bases itself on other standards like SDMX.

In the DataCube vocabulary, an observation is a valuepoint in the datacube. Here an observation represents the value for one indicator for a country and a year. The indicator is the measure while the country and the year are the dimensions in the datacube. If an observation is not present for a combination the data has not been collected. Each observation comes with additional information such as the unit.

There are rdf files in different notations containing the full DataCube:

SPARQL Endpoint

The published digital scoreboard RDF data can be queried online via the SPARQL editor (human readable) or SPARQL endpoint (for machines regarding the SPARQL protocol for RDF). This SPARQL endpoint offers a public service to the statistical data allowing anyone to build applications based on the most recent data.

Some sample queries are:

  • Select 20 observations for the indicator "Total number of fixed broadband lines" [try it]
  • Select all observations for the indicator "Total number of fixed broadband lines" for the EU27 average [try it]
  • Select all observations for indicator "Total number of fixed broadband lines" and indicator "New entrants' share in fixed broadband lines" for the year 2010 [try it]
  • Select all observations for the country Belgium for the year 2010 [try it]
The data can also be browsed via the OntoWiki tool.

To explore the data in scoreboard, click one of the icons: