Jump to content

Topic on Help talk:Tabular data

Zebulon84 (talkcontribs)

Is there a way to indicate the date of the data in the table, other than adding a column with the same date everywhere, or hacking the description with a fake "date" language ?

In general, could we be allowed to add personalized metadata in the JSON, even if that means names with specific prefix, or in an optional metadata object.

Yurik (talkcontribs)

@zebulon84 i'm not sure i understand, could you give an example of the data you are trying to store, and what it may look like? Thx

Zebulon84 (talkcontribs)

Data I store (for test purpose at the moment): c:Data:Sandbox/Zebulon84/Communes Grand Est.tab

My goal is to use this data to generate with lua various lists with data coming from other sources (like this one) automatically (today we have to give the names in the list in as much parameters).

I'd like to know the when is the data have been update (not the date of the upload on commons, but the date of the source) to be able to compare that with date coming from other file when using this data in a lua module, and indicate it in the list title.

Yurik (talkcontribs)

@Zebulon84 if i understood you correctly: you are trying to add a timestamp (date), when the data was last refreshed for a given row? If so, just add it as a new string column, and parse it in Lua as a date. A different issue -- in the c:Data:Sandbox/Zebulon84/Communes Grand Est.tab sample, you have a string column "name". I think it is better to use Wikidata for that, unless you keep it for debugging? But looks good otherwise!

Zebulon84 (talkcontribs)

Not for a given row, but for the complete table. The source of this data updates it once per year, and the publish date is different from the update date. I'd like to have this update date. I'm going to include it in the description, but it would be easier to use if I can have it separately.

For the names, I may remove them, but I need to check if Wikidata is accurate first (will do it soon).

Reply to "Date"