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?

Joe

On Wed, May 28, 2014 at 9:12 PM, Jan Kučera <kozuch82@gmail.com> 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...

Jan

2014-05-27 14:24 GMT+02:00 David Cuenca <dacuetu@gmail.com>:

Please, leave your comments here too:

https://meta.wikimedia.org/wiki/Requests_for_comment/How_to_deal_with_open_datasets

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.

Thanks,

Micru

On Tue, May 27, 2014 at 2:12 PM, Ilario Valdelli <valdelli@gmail.com> 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.

Regards

On Tue, May 27, 2014 at 1:15 PM, Jan Kučera <kozuch82@gmail.com> wrote:

Hi there,

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

Jan

_______________________________________________
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

--

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

Tel: +41764821371
http://www.wikimedia.ch

_______________________________________________
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

--

Etiamsi omnes, ego non

_______________________________________________
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

_______________________________________________
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l

_______________________________________________
Wikidata-l mailing list
Wikidata-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-l