WolfgangFahl
commented
1 year ago Example:
sparqlquery -qp resources/queries.yaml -qn AllEvents --limit 7 -f mediawikiAllEvents
query
SELECT DISTINCT ?event
(SAMPLE(?_title) as ?title)
(SAMPLE(?_acronym) as ?acronym)
(SAMPLE(?_startTime) as ?startTime)
(SAMPLE(?_endTime) as ?endTime)
(SAMPLE(?_country) as ?country)
(SAMPLE(?_location) as ?location)
(SAMPLE(?_officialWebsite) as ?officialWebsite)
(SAMPLE(?_colocatedWith) as ?colocatedWith)
(SAMPLE(?_dblpEventId) as ?dblpEventId)
(SAMPLE(?_wikiCfpId) as ?wikiCfpId)
(SAMPLE(?_series) as ?series)
(SAMPLE(?_ordinal) as ?ordinal)
WHERE{
?proceeding wdt:P31 wd:Q1143604.
?proceeding wdt:P179 wd:Q27230297.
?proceeding p:P179/pq:P478 ?volumeNumber.
?proceeding wdt:P4745 ?event.
OPTIONAL{?event wdt:P1476 ?_title. Filter(lang(?_title)="en")}
OPTIONAL{?event wdt:P580 ?_startTime.}
OPTIONAL{?event wdt:P582 ?_endTime.}
OPTIONAL{?event wdt:P17 ?_country.}
OPTIONAL{?event wdt:location ?_location.}
OPTIONAL{?event wdt:P856 ?_officialWebsite.}
OPTIONAL{?event wdt:P31 ?_instanceOf.}
OPTIONAL{?event wdt:P1813 ?_acronym.}
OPTIONAL{?event wdt:P11633 ?_colocatedWith.}
OPTIONAL{?event wdt:P10692 ?_dblpEventId.}
OPTIONAL{?event wdt:P5124 ?_wikiCfpId.}
OPTIONAL{?event wdt:P179 ?_series.}
OPTIONAL{?event p:P179/pq:P1545 ?_ordinal.}
}
GROUP BY ?event
ORDER BY DESC(?startTime)
result
| event | title | acronym | startTime | endTime | country | dblpEventId |
|---|---|---|---|---|---|---|
| http://www.wikidata.org/entity/Q117190515 | IUI 2023 Workshops: HAI-GEN, ITAH, MILC, SHAI, SketchRec, SOCIALIZE | IUI-WS 23 | 2023-03-27 00:00:00 | 2023-03-31 00:00:00 | http://www.wikidata.org/entity/Q408 | |
| http://www.wikidata.org/entity/Q117190510 | 4th Crowd Science Workshop on Collaboration of Humans and Learning Algorithms for Data Labeling | CSW 2023 | 2023-03-03 00:00:00 | 2023-03-03 00:00:00 | http://www.wikidata.org/entity/Q334 | |
| http://www.wikidata.org/entity/Q116875513 | 26th Computer Vision Winter Workshop (CVWW 2023) | CVWW 2023 | 2023-02-15 00:00:00 | 2023-02-17 00:00:00 | ||
| http://www.wikidata.org/entity/Q117190512 | 10th Illia O. Teplytskyi Workshop on Computer Simulation in Education, and Workshop on Cloud-based Smart Technologies for Open Education (CoSinEi and CSTOE 2022) | CoSinE and CSTOE 2022 | 2022-12-22 00:00:00 | 2022-12-22 00:00:00 | http://www.wikidata.org/entity/Q212 | |
| http://www.wikidata.org/entity/Q116156374 | 2nd Workshop on sociAL roboTs for peRsonalized, continUous and adaptIve aSsisTance (ALTRUIST) | ALTRUIST 2022 | 2022-12-16 00:00:00 | 2022-12-16 00:00:00 | http://www.wikidata.org/entity/Q38 | |
| http://www.wikidata.org/entity/Q116797018 | Tunisian-Algerian Joint Conference on Applied Computing (TACC 2022) | TACC 2022 | 2022-12-13 00:00:00 | 2022-12-14 00:00:00 | http://www.wikidata.org/entity/Q262 | conf/tacc/tacc2022 |
| http://www.wikidata.org/entity/Q115616451 | Computational Humanities Research Conference 2022 | CHR 2022 | 2022-12-12 00:00:00 | 2022-12-14 00:00:00 | http://www.wikidata.org/entity/Q31 | conf/chr/chr2022 |
See #859 The Queries in
have links to the WikidataQuery Service and QLever. Some queries fail with errors and some with memory problems.
The "named query" yaml file that may be used with pyLodStorage's sparqlquery is available at: https://github.com/WolfgangFahl/pyCEURmake/blob/main/resources/queries.yaml