Truly Tabular RDF/AcademicConferencesSeries

From BITPlan Wiki
Jump to navigation Jump to search

non tabular entries for scientific conference series/GND ID:frequencies

query

SELECT ?count (COUNT(?count) AS ?frequency) WHERE {

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given GND ID(P227) https://www.wikidata.org/wiki/Property:P227 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # GND ID
  ?item wdt:P227 ?value.
} GROUP by ?item ?itemLabel

}
GROUP BY ?count
ORDER BY DESC (?frequency)

try it!

result

count frequency
1 1796
2 6
3 1

non tabular entries for scientific conference series/GND ID:records

query

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given GND ID(P227) https://www.wikidata.org/wiki/Property:P227 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # GND ID
  ?item wdt:P227 ?value.
} GROUP by ?item ?itemLabel

HAVING (COUNT (?value) > 1)
ORDER BY DESC(?count)

try it!

result

item itemLabel count
http://www.wikidata.org/entity/Q17085601 European Symposium on Programming 3
http://www.wikidata.org/entity/Q101195130 Foundations of Software Science and Computation Structures 2
http://www.wikidata.org/entity/Q679325 International Conference on Computer Graphics and Interactive Techniques 2
http://www.wikidata.org/entity/Q863401 International Joint Conference on Artificial Intelligence 2
http://www.wikidata.org/entity/Q6049675 International Conference on Robotics and Automation 2
http://www.wikidata.org/entity/Q6053791 International Symposium Graph Drawing and Network Visualization 2
http://www.wikidata.org/entity/Q17087987 International Symposium on Symbolic and Algebraic Computation 2

non tabular entries for scientific conference series/inception:frequencies

query

SELECT ?count (COUNT(?count) AS ?frequency) WHERE {

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given inception(P571) https://www.wikidata.org/wiki/Property:P571 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # inception
  ?item wdt:P571 ?value.
} GROUP by ?item ?itemLabel

}
GROUP BY ?count
ORDER BY DESC (?frequency)

try it!

result

count frequency
1 954

non tabular entries for scientific conference series/inception:records

query

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given inception(P571) https://www.wikidata.org/wiki/Property:P571 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # inception
  ?item wdt:P571 ?value.
} GROUP by ?item ?itemLabel

HAVING (COUNT (?value) > 1)
ORDER BY DESC(?count)

try it!

result

non tabular entries for scientific conference series/title:frequencies

query

SELECT ?count (COUNT(?count) AS ?frequency) WHERE {

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given title(P1476) https://www.wikidata.org/wiki/Property:P1476 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # title
  ?item wdt:P1476 ?value.
} GROUP by ?item ?itemLabel

}
GROUP BY ?count
ORDER BY DESC (?frequency)

try it!

result

count frequency
1 4129
2 3
3 2

non tabular entries for scientific conference series/title:records

query

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given title(P1476) https://www.wikidata.org/wiki/Property:P1476 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # title
  ?item wdt:P1476 ?value.
} GROUP by ?item ?itemLabel

HAVING (COUNT (?value) > 1)
ORDER BY DESC(?count)

try it!

result

item itemLabel count
http://www.wikidata.org/entity/Q288546 ACM Multimedia 3
http://www.wikidata.org/entity/Q105700310 International Workshop on Software Engineering in Healthcare 3
http://www.wikidata.org/entity/Q105699346 Brazilian Symposium on Programming Languages 2
http://www.wikidata.org/entity/Q5159889 Conference and Labs of the Evaluation Forum 2
http://www.wikidata.org/entity/Q105710038 International Symposium on String Processing and Information Retrieval 2

non tabular entries for scientific conference series/short name:frequencies

query

SELECT ?count (COUNT(?count) AS ?frequency) WHERE {

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given short name(P1813) https://www.wikidata.org/wiki/Property:P1813 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # short name
  ?item wdt:P1813 ?value.
} GROUP by ?item ?itemLabel

}
GROUP BY ?count
ORDER BY DESC (?frequency)

try it!

result

count frequency
1 3981
2 1

non tabular entries for scientific conference series/short name:records

query

# Count all scientific conference series(Q47258130) https://www.wikidata.org/wiki/Q47258130 items
# with the given short name(P1813) https://www.wikidata.org/wiki/Property:P1813 
SELECT ?item ?itemLabel (COUNT (?value) AS ?count)
WHERE
{
  # instance of scientific conference series
  ?item wdt:P31 wd:Q47258130.
  ?item rdfs:label ?itemLabel.
  filter (lang(?itemLabel) = "en").
  # short name
  ?item wdt:P1813 ?value.
} GROUP by ?item ?itemLabel

HAVING (COUNT (?value) > 1)
ORDER BY DESC(?count)

try it!

result

item itemLabel count
http://www.wikidata.org/entity/Q22032360 Relational and Algebraic Methods in Computer Science RAMiCS 2
Retrieved from "https://wiki.bitplan.com/index.php?title=Truly_Tabular_RDF/AcademicConferencesSeries&oldid=15284"