Can someone show me how to make use of wikidata and save following 2D table in a structured day (properties???) so that it can later be retrieved via queries into a list?


2014-06-16 10:35 GMT+02:00 Joe Filceolaire <>:

My mistake. The properties I proposed weren't the ones approved. :(

The property proposals are at 


On Sun, Jun 15, 2014 at 9:15 PM, Gerard Meijssen <> wrote:
Do you have a link and an example of a fleshed out use of these properties?

On 15 June 2014 21:49, Joe Filceolaire <> wrote:

If the data in the table cannot be expressed as a set of statements (probably with a qualifier for each column of the table) then why would we include it?

See my recently approved proposals for properties needed for recording sports league tables (and World Cup groups) as statements - listed in this weeks weekly summary. 

What advantage would there be for recording these results in a table rather than as statements? If the answer is to ensure consistent formatting then we need to look at templates and tools for entering and editing data, not new datatypes.


On Sun, Jun 15, 2014 at 1:24 PM, Yury Katkov <> wrote:
Probably the CSV exporters to the wikidata can be a suitable answer to this problem. For example we have the table of all mayors in Rome (there were a lot of them) with their titles and years of begin and end. It shouldn't be very hard to write a convertor that will create the property values of "head of government" property and populate all these mayors like here: 

Yury Katkov

On Sun, Jun 15, 2014 at 1:56 PM, Thomas Douillard <> wrote:
Hi yan, simple 2d tables are just really an implementation of a set of relations.

For example the tabular datas like an adress book like
Name  Phone-Number City
John  12345        New York
Katie 23456        Paris

can totally be implemented in Wikidata with two properties and some conventions :
* A "Phone number" property
* A "living place" property
and conventions that they plly to persons. Some may also requires qualifiers.

But giving that it's always possible to implement "tabular datas" (what are these ?) the Wikidata way, is this a problem that they don't have a specficic treatment ?

2014-06-15 13:43 GMT+02:00 Jan Kučera <>:

I am really disappointed to see simple 2d tables still are not reality... the issue probably is related to the original PHASE #3...

2014-06-03 23:50 GMT+02:00 Jan Kučera <>:

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

Wikidata-l mailing list

Wikidata-l mailing list

Wikidata-l mailing list

Wikidata-l mailing list

Wikidata-l mailing list

Wikidata-l mailing list