Can tabular data be currently saved as a series of statements within wikidata? If so, how can I create such a series? Am I able to feed such a series into a wikitable on some wiki?

2014-05-30 11:19 GMT+02:00 Joe Filceolaire <>:
Simple tables that are in wikipedia:
* league tables with columns for games won, drawn, lost, goals for, goals against, points, rank  and rows for each of the teams in the league.
* election results with columns for votes for each party and seats won by each party and rows for each region, state etc.
* population numbers with columns for each tab (races, religion etc.) and rows for each census district.

In all of these cases I suspect that this information might be more useful as a series of statements. These could either be broken up with a statement corresponding to each column on the item for each row or alternatively with all the information in the table on one item, a statement for each row and qualifiers to each statement corresponding to each column.

What is the advantage to having this as a table instead?


On Wed, May 28, 2014 at 9:12 PM, Jan Kučera <> wrote:
Well what I meant was just an ordinary 2-dimensional table (rows vs. columns)... Excel was just an example to make it clear.

So I guess simple tables are not any roadmap yet right?

Further step would be an n-dimensional structures... arrays etc.

I wouldnt care about format.... CSV, JSON...


2014-05-27 14:24 GMT+02:00 David Cuenca <>:

Please, leave your comments here too:

I've been gathering comments from several people, and in the next days I will try to summarize these suggestions to be discussed on irc.


On Tue, May 27, 2014 at 2:12 PM, Ilario Valdelli <> wrote:
I am not an expert of Wikidata but I work a lot in integration of databases with several middlewares or tools.

I think that the best way is to ask a solution to store and to download data in a format compatible with datasheets like CSV.

Excel is considered also a tool to do some basic analysis, but it can be connected easily to a data source (if well structured).

Excel itself is not a good approach to store data, so it's not a good solution to keep the data in excel format in a database.

Doesn't make sense to store a 2D tables in a database in my opinion because the data have no sense and they are not helpful to anyone.

They can be stored like a text file, but I would not imagine the series of errors that can be generated importing these data again.


On Tue, May 27, 2014 at 1:15 PM, Jan Kučera <> wrote:
Hi there,

can tables be stored within wikidata database? I mean simple 2D tables like excel spreadsheets...


Wikidata-l mailing list

Ilario Valdelli
Wikimedia CH
Verein zur Förderung Freien Wissens
Association pour l’avancement des connaissances libre
Associazione per il sostegno alla conoscenza libera
Switzerland - 8008 Zürich
Wikipedia: Ilario
Facebook: Ilario Valdelli
Twitter: Ilario Valdelli
Linkedin: Ilario Valdelli

Wikidata-l mailing list

Etiamsi omnes, ego non

Wikidata-l mailing list

Wikidata-l mailing list

Wikidata-l mailing list