search

WolfgangFahl / PyGenericSpreadSheet

Generic Spreadsheet Editing API
Apache License 2.0
0 stars 0 forks source link

add WikibaseQuery #3

Closed WolfgangFahl closed 2 years ago

WolfgangFahl commented 2 years ago
allow to specify queries with spreadsheet content such as Entity Column PropertyName PropertyId Type Value Lookup Qualifier
Event series instanceof P31 Q47258130
Event series Acronym short name P1813 text
Event series Title title P1476 text
Event series Homepage official website P856 url
Event instanceof P31 Q2020153
Event series part of the series P179
Event Ordinal series ordinal P1545 string part of the series
Event Acronym short name P1813 text
Event Title title P1476 text
Event Country country P17 Q3624078
Event City location P276 Q515
Event Start date start time P580 date
Event End date end time P582 date
Event gndId GND ID P227 extid
Event dblpUrl describedAt P973 url
Event Homepage official website P856 url
Event wikicfpId WikiCFP event ID P5124 extid
Proceedings instanceof P31 Q1143604
Proceedings Acronym short name P1813 text
Proceedings Title title P1476 text
Proceedings OpenLibraryId Open Library ID P648 extid
Proceedings ppnId K10plus PPN ID P6721 extid
Proceedings Event is proceedings from P4745 Q2020153
WolfgangFahl commented 2 years ago
Combined with input from data table such as: label description Series Ordinal Year Acronym City Country Start date End date
ACISP 1996 Q105695401 1 1996 ACISP 1996
ACISP 1997 Q105695401 2 1997 ACISP 1997
ACISP 1998 Q105695401 3 1998 ACISP 1998
ACISP 1999 Q105695401 4 1999 ACISP 1999
ACISP 2000 Q105695401 5 2000 ACISP 2000
ACISP 2001 Q105695401 6 2001 ACISP 2001
ACISP 2002 Q105695401 7 2002 ACISP 2002
ACISP 2003 Q105695401 8 2003 ACISP 2003
ACISP 2004 Q105695401 9 2004 ACISP 2004
ACISP 2005 Q105695401 10 2005 ACISP 2005
ACISP 2006 Q105695401 11 2006 ACISP 2006
ACISP 2007 Q105695401 12 2007 ACISP 2007
ACISP 2008 Q105695401 13 2008 ACISP 2008
ACISP 2009 Q105695401 14 2009 ACISP 2009
ACISP 2010 Q105695401 15 2010 ACISP 2010
ACISP 2011 Q105695401 16 2011 ACISP 2011
ACISP 2012 Q105695401 17 2012 ACISP 2012
ACISP 2013 Q105695401 18 2013 ACISP 2013
ACISP 2014 Q105695401 19 2014 ACISP 2014
ACISP 2015 Q105695401 20 2015 ACISP 2015
ACISP 2016 Q105695401 21 2016 ACISP 2016
ACISP 2017 Q105695401 22 2017 ACISP 2017
ACISP 2018 Q105695401 23 2018 ACISP 2018
ACISP 2019 Q105695401 24 2019 ACISP 2019
ACISP 2020 Q105695401 25 2020 ACISP 2020
ACISP 2021 Q105695401 26 2021 ACISP 2021

a Query should be generated: sparqlquery -qp wikidata.yaml -qn ACISP-Series -f github

ACISP series example

query

# 
# get Event records 
#  
SELECT ?item ?itemLabel

  ?part_of_the_series
  ?series_ordinal
  ?short_name
  ?title
  ?country
  ?location
  ?start_time
  ?end_time
  ?GND_ID
  ?describedAt
  ?official_website
  ?WikiCFP_event_ID
WHERE {
  ?item rdfs:label ?itemLabel.
  FILTER(LANG(?itemLabel) = "en")

  ?item wdt:P31 wd:Q2020153.
  OPTIONAL { ?item wdt:P179 ?part_of_the_series. }
  OPTIONAL { ?item wdt:P1545 ?series_ordinal. }
  OPTIONAL { ?item wdt:P1813 ?short_name. }
  OPTIONAL { ?item wdt:P1476 ?title. }
  OPTIONAL { ?item wdt:P17 ?country. }
  OPTIONAL { ?item wdt:P276 ?location. }
  OPTIONAL { ?item wdt:P580 ?start_time. }
  OPTIONAL { ?item wdt:P582 ?end_time. }
  OPTIONAL { ?item wdt:P227 ?GND_ID. }
  OPTIONAL { ?item wdt:P973 ?describedAt. }
  OPTIONAL { ?item wdt:P856 ?official_website. }
  OPTIONAL { ?item wdt:P5124 ?WikiCFP_event_ID. }

  FILTER(?short_name IN(
    'ACISP 1996'@en,
    'ACISP 1997'@en,
    'ACISP 1998'@en,
    'ACISP 1999'@en,
    'ACISP 2000'@en,
    'ACISP 2001'@en,
    'ACISP 2002'@en,
    'ACISP 2003'@en,
    'ACISP 2004'@en,
    'ACISP 2005'@en,
    'ACISP 2006'@en,
    'ACISP 2007'@en,
    'ACISP 2008'@en,
    'ACISP 2009'@en,
    'ACISP 2010'@en,
    'ACISP 2011'@en,
    'ACISP 2012'@en,
    'ACISP 2013'@en,
    'ACISP 2014'@en,
    'ACISP 2015'@en,
    'ACISP 2016'@en,
    'ACISP 2017'@en,
    'ACISP 2018'@en,
    'ACISP 2019'@en,
    'ACISP 2020'@en,
    'ACISP 2021'@en
  )).
}
ORDER BY ?short_name

try it!

result

item itemLabel part_of_the_series short_name title country location start_time end_time GND_ID describedAt
http://www.wikidata.org/entity/Q106067066 Information Security and Privacy, First Australasian Conference, ACISP'96, Wollongong, NSW, Australia, June 24-26, 1996 http://www.wikidata.org/entity/Q105695401 ACISP 1996 Information Security and Privacy, First Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q187861 1996-06-24 00:00:00 1996-06-26 00:00:00 2159559-8 https://dblp.org/db/conf/acisp/acisp1996.html
http://www.wikidata.org/entity/Q106067060 Information Security and Privacy, Second Australasian Conference, ACISP'97, Sydney, NSW, Australia, July 7-9, 1997 http://www.wikidata.org/entity/Q105695401 ACISP 1997 Information Security and Privacy, Second Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q3130 1997-07-07 00:00:00 1997-07-09 00:00:00 2164018-X https://dblp.org/db/conf/acisp/acisp1997.html
http://www.wikidata.org/entity/Q106242954 Information Security and Privacy, Third Australasian Conference, ACISP'98, Brisbane, Queensland, Australia, July 1998 http://www.wikidata.org/entity/Q105695401 ACISP 1998 Information Security and Privacy, Third Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q34932 2170923-3 https://dblp.org/db/conf/acisp/acisp1998.html
http://www.wikidata.org/entity/Q106067058 Information Security and Privacy, 4th Australasian Conference, ACISP'99, Wollongong, NSW, Australia, April 7-9, 1999 http://www.wikidata.org/entity/Q105695401 ACISP 1999 Information Security and Privacy, 4th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q187861 1999-04-07 00:00:00 1999-04-09 00:00:00 2175582-6 https://dblp.org/db/conf/acisp/acisp1999.html
http://www.wikidata.org/entity/Q106242953 Information Security and Privacy, 7th Australian Conference, ACISP 2002, Melbourne, Australia, July 3-5, 2002 http://www.wikidata.org/entity/Q105695401 ACISP 2002 Information Security and Privacy, 7th Australian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q3141 2002-07-03 00:00:00 2002-07-05 00:00:00 10038863-2 https://dblp.org/db/conf/acisp/acisp2002.html
http://www.wikidata.org/entity/Q106242952 Information Security and Privacy, 8th Australasian Conference, ACISP 2003, Wollongong, Australia, July 9-11, 2003 http://www.wikidata.org/entity/Q105695401 ACISP 2003 Information Security and Privacy, 8th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q187861 2003-07-09 00:00:00 2003-07-11 00:00:00 10059290-9 https://dblp.org/db/conf/acisp/acisp2003.html
http://www.wikidata.org/entity/Q106067054 Information Security and Privacy: 9th Australasian Conference, ACISP 2004, Sydney, Australia, July 13-15, 2004 http://www.wikidata.org/entity/Q105695401 ACISP 2004 Information Security and Privacy: 9th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q3130 2004-07-13 00:00:00 2004-07-15 00:00:00 10082551-5 https://dblp.org/db/conf/acisp/acisp2004.html
http://www.wikidata.org/entity/Q106242951 Information Security and Privacy, 10th Australasian Conference, ACISP 2005, Brisbane, Australia, July 4-6, 2005 http://www.wikidata.org/entity/Q105695401 ACISP 2005 Information Security and Privacy, 10th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q34932 2005-07-04 00:00:00 2005-07-06 00:00:00 16033855-4 https://dblp.org/db/conf/acisp/acisp2005.html
http://www.wikidata.org/entity/Q106242950 Information Security and Privacy, 11th Australasian Conference, ACISP 2006, Melbourne, Australia, July 3-5, 2006 http://www.wikidata.org/entity/Q105695401 ACISP 2006 Information Security and Privacy, 11th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q3141 2006-07-03 00:00:00 2006-07-05 00:00:00 6056596-2 https://dblp.org/db/conf/acisp/acisp2006.html
http://www.wikidata.org/entity/Q106242949 Information Security and Privacy - 16th Australasian Conference, ACISP 2011, Melbourne, Australia, July 11-13, 2011 http://www.wikidata.org/entity/Q105695401 ACISP 2011 Information Security and Privacy - 16th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q3141 2011-07-11 00:00:00 2011-07-13 00:00:00 16163914-8 https://dblp.org/db/conf/acisp/acisp2011.html
http://www.wikidata.org/entity/Q106242948 Information Security and Privacy - 18th Australasian Conference, ACISP 2013, Brisbane, Australia, July 1-3, 2013 http://www.wikidata.org/entity/Q105695401 ACISP 2013 Information Security and Privacy - 18th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q34932 2013-07-01 00:00:00 2013-07-03 00:00:00 1036717933 https://dblp.org/db/conf/acisp/acisp2013.html
http://www.wikidata.org/entity/Q106242946 Information Security and Privacy - 19th Australasian Conference, ACISP 2014, Wollongong, NSW, Australia, July 7-9, 2014 http://www.wikidata.org/entity/Q105695401 ACISP 2014 Information Security and Privacy - 19th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q187861 2014-07-07 00:00:00 2014-07-09 00:00:00 1054616329 https://dblp.org/db/conf/acisp/acisp2014.html
http://www.wikidata.org/entity/Q106242945 Information Security and Privacy - 20th Australasian Conference, ACISP 2015, Brisbane, QLD, Australia, June 29 - July 1, 2015 http://www.wikidata.org/entity/Q105695401 ACISP 2015 Information Security and Privacy - 20th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q34932 2015-06-29 00:00:00 2015-07-01 00:00:00 1072487039 https://dblp.org/db/conf/acisp/acisp2015.html
http://www.wikidata.org/entity/Q106067051 Information Security and Privacy - 22nd Australasian Conference, ACISP 2017, Auckland, New Zealand, July 3-5, 2017 http://www.wikidata.org/entity/Q105695401 ACISP 2017 Information Security and Privacy - 22nd Australasian Conference http://www.wikidata.org/entity/Q664 http://www.wikidata.org/entity/Q37100 2017-07-03 00:00:00 2017-07-05 00:00:00 1135628742 https://dblp.org/db/conf/acisp/acisp2017-1.html
http://www.wikidata.org/entity/Q106242943 Information Security and Privacy - 24th Australasian Conference, ACISP 2019, Christchurch, New Zealand, July 3-5, 2019 http://www.wikidata.org/entity/Q105695401 ACISP 2019 Information Security and Privacy - 24th Australasian Conference http://www.wikidata.org/entity/Q664 http://www.wikidata.org/entity/Q79990 2019-07-03 00:00:00 2019-07-05 00:00:00 1188659006 https://dblp.org/db/conf/acisp/acisp2019.html
http://www.wikidata.org/entity/Q106242942 Information Security and Privacy - 25th Australasian Conference, ACISP 2020, Perth, WA, Australia, November 30 - December 2, 2020 http://www.wikidata.org/entity/Q105695401 ACISP 2020 Information Security and Privacy - 25th Australasian Conference http://www.wikidata.org/entity/Q408 http://www.wikidata.org/entity/Q3183 2020-11-30 00:00:00 2020-12-02 00:00:00 1217872477 https://dblp.org/db/conf/acisp/acisp2020.html