Hi! > Hi! I'm Felipe Hoffa at Google, and I've been playing with Wikidata's > data in BigQuery:
This looks pretty cool! > (Wikidata has 54 cats) query.wikidata.org has 59: http://tinyurl.com/ju7xsn2 I wonder why the difference? Also, looks like your query: WHERE JSON_EXTRACT_SCALAR(item, '$.claims.P31[0].mainsnak.datavalue.value.numeric-id')='146' #cats only checks the first claim. But there could be more than one P31 claims in Wikidata. > - Advice, feedback? More cool examples! :) > - My "raw to table" javascript code is incomplete and not very pretty - > which columns would you want extracted? > https://github.com/fhoffa/code_snippets/blob/master/wikidata/create_wiki_en_table.sql That's hard to say - properties can vary a lot, especially depending on kind of items (birth date useful for humans, less so for buildings or paintings :) So it probably has to be rather flexible to cover varied cases. -- Stas Malyshev [email protected] _______________________________________________ Wikidata mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata
