query-0e801719bddd813f2ee9bede0df9daf2
]reply[01:34, 26 May 2018 (UTC)) talk (Tagishsimon), then each of the 351 teams could have a P31 of whatever is the Qid of "NCAA Division I women's basketball team" (and would not need the P31s they currently have); and we would then have an absolute handle on the teams. Right now it is possible that a team which is not part of the NCAA Division I women's could be given the three values we're using to distinguish the 351. Hope that makes sense? --(Q2367225)university and college sports club and (Q13393265)basketball team values of (P279)subclass of which appears twice in the report that has the league column, since there are two leagues associated with this team. It appears only once in the report without the league column. So, we have a handle, of a sort, on the 351. I kinda feel we're missing an item such as "NCAA Division I women's basketball team" ... if we had such an item (which would have the (Q29468783)Fordham Rams women's basketball : I've tracked down the 352 / 351 difference to Sphilbrick@. So, you can turn things on or off with this report by adding or removing the #. (Q29468783)Fordham Rams women's basketball to set out their link with the university). Right now I've commented (#) out some of the optionals, since if you fetch all values, the results switch from a grid to a list ... albeit you can export the list as CSV and it'll be back in grid format in your spreadsheet. Where an item has more than one value for a property, you will get one row per item/value, as we saw with (P361)part of rather than (P1268)represents Here's an uber report which selects for all of the properties I've found (and note the three that were 'found' this evening use ?item wdt:P31 wd:Q54190181 . So now we can just search for .(Q54190181)NCAA Division I women's basketball team Late news: I've implemented
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?item ?P361Label ?P571 ?P1449 ?P17Label ?P118Label ?P115Label ?P2094Label ?P641Label ?P856 ?P910Label ?P1268Label
WHERE
{ ?item wdt:P31 wd:Q54190181 . #instance of: NCAA Division I women's basketball team
optional {?item wdt:P361 ?P361 .}
optional {?item wdt:P571 ?P571 .}
optional {?item wdt:P1449 ?P1449 .}
optional {?item wdt:P17 ?P17 .}
optional {?item wdt:P118 ?P118 .}
optional {?item wdt:P115 ?P115 .}
optional {?item wdt:P2094 ?P2094 .}
optional {?item wdt:P641 ?P641 .}
# optional {?item wdt:P856 ?P856 .}
# optional {?item wdt:P910 ?P910 .}
# optional {?item wdt:P1268 ?P1268 .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # get labels
}