SPARQL Query Catalog
A searchable index of pre-written SPARQL queries for discovering, exploring, and auditing LINCS linked open data. Filter by tag or search by keyword, then expand a query to view the SPARQL and run it directly on the page.
Returns named graphs with their URIs, filtered to LINCS graph and vocabulary namespaces. Note: ResearchSpace does not return vocabulary graphs while Yasgui and Fuseki do.
Returns the total number of triples in one named graph. Replace the bound URI with any http://graph.lincsproject.ca/ graph URI.
Returns a count of every triple in each named graph across the LINCS triplestore. Useful for a quick size overview of all datasets.
Counts instances of every RDF type across all graphs, ordered by frequency. A quick way to understand the class distribution of the entire triplestore.
Returns all crm:E55_Type values in descending order of frequency. E55 types add domain-specific classification on top of the base CIDOC-CRM classes (e.g. "painting", "catholicism").
Lists all properties associated with a given CIDOC class in descending order of frequency. Replace the bound URI with any RDF class URI to inspect a different class (e.g. crm:E53_Place, frbroo:F1_Work).
Returns all distinct properties associated with a specific crm:E55_Type value. Replace the bound URI with any E55 vocabulary term URI.
Finds all entities associated with a specific crm:E55_Type value. Replace the bound URI with any E55 vocabulary term URI. Works well with LINCS vocabulary terms (e.g. http://id.lincsproject.ca/cwrc/editing).
Returns all crm:E55_Type values within a specific named graph (USask Art Collection shown). Replace the graph URI to inspect any other LINCS dataset.
Returns all crm:E55_Type values applied to crm:E7_Activity instances across the triplestore, grouped by frequency. Useful for understanding how activities are classified.
Finds all frbroo:F1_Work instances across all named graphs and groups results by graph. A simple cross-dataset query useful as a starting point for multi-dataset exploration.
Retrieves coordinate locations for named places in the Map of Early Modern London (MoEML) dataset. Replace the VALUES list with different MoEML entity URIs to look up other locations.
Returns every crm:E21_Person in the Yellow Nineties graph with their birth/death dates and places, and any alternate names. All fields are aggregated with GROUP_CONCAT.
Counts instances of crm:P129_is_about pointing to crm:E33_E41_Linguistic_Appellation objects, grouped by named graph. Useful for comparing how the isAbout property is used across datasets.
Lists all people in the Orlando dataset with their birth start dates, death end dates, and the person URI. Uses crm:E67_Birth and optional death event triples.
Counts how many Cabinet Conclusion pages mentioned the province of Quebec (GeoNames 6115047) each month, grouped by year-month. Uses BIND(SUBSTR(...)) to extract the year-month portion of the datetime.
Finds all other topics mentioned alongside Quebec in Cabinet Conclusion pages from March and April 1970. Returns the page URI, the co-mentioned topic, and the year-month. Filter the ?yearMonth values to explore other time periods.
Returns text snippets from the Orlando dataset where a context is typed as cwrc:MentalHealthContext. Uses Web Annotation property paths (oa:hasTarget/oa:hasSelector/oa:refinedBy/oa:exact) to extract the actual text excerpt.
Returns text snippets where an annotation body points to a specific GeoNames place URI. Replace the GeoNames URI (Wales shown here) with any other place to filter excerpts by location.
Finds crm:E21_Person entities that appear in both the Cabinet Conclusions graph and at least one other LINCS named graph. Useful for identifying shared entities across datasets.
Joins the Orlando and Yellow Nineties graphs to return persons with their names, birth/death dates and places, and occupations. Results are filtered to people who have both birth and death data to reduce noise.
Returns persons with their aggregated occupation labels from both the Orlando and Yellow Nineties graphs. Requires birth and death data to be present (to filter out incomplete person records).
Demonstrates the SPARQL SERVICE keyword to query the external Getty Art & Architecture Thesaurus (AAT) endpoint from within the LINCS triplestore. Returns concepts matching a term with their preferred labels and scope notes.
Finds crm:E21_Person, crm:E74_Group, crm:E53_Place, and crm:E22_Human-Made_Object entities that appear in both the xDX graph and at least one other LINCS named graph. Results include the entity URI, type, and a comma-separated list of the other graphs.
Extracts the distinct namespace URIs of all crm:E55_Type and skos:Concept values in the Orlando graph. Uses BIND(REPLACE(...)) to strip the local name and return only the namespace prefix. Replace the graph URI in the GRAPH clause to inspect a different dataset.
Same as the all-namespaces query but filtered to URIs containing lincsproject. Returns only LINCS-owned vocabulary namespaces used in the Orlando graph. Replace the graph URI in the GRAPH clause to inspect a different dataset.
Counts distinct vocabulary term URIs per namespace in the Orlando graph, ordered by frequency. Replace the graph URI in the GRAPH clause to inspect a different dataset.
Returns every E55_Type used across all graph.lincsproject.ca named graphs with its label and usage count, ordered by frequency. Requires rdfs:label or skos:PrefLabel to be present on the term.
Returns vocabulary namespaces, unique term count, and a concatenated list of all term local names for the Orlando graph. Replace the graph URI in the GRAPH clause to inspect a different dataset.
Counts total usage occurrences (not just distinct terms) per vocabulary namespace in the Orlando graph. Includes all instances where crm:P2_has_type, crm:E55_Type, or skos:Concept are used. Replace the graph URI in the GRAPH clause to inspect a different dataset.
Groups vocabulary namespace usage by both namespace and named graph, returning term counts and a concatenated term list for each combination. Filters to graph.lincsproject.ca graphs only.
Same as the per-graph query but aggregated across all graph.lincsproject.ca named graphs — grouped only by namespace. Returns a global view of which vocabulary namespaces are used most and which terms they contribute.
Returns all subject URIs in the Yellow Nineties graph that have no rdfs:label triple. Replace the graph URI in the GRAPH clause with any named graph of interest.
Returns all subject URIs in the Yellow Nineties graph that have no rdf:type triple. Replace the graph URI in the GRAPH clause with any named graph of interest.
Returns pairs of distinct types for any entity that has been assigned more than one rdf:type in the Yellow Nineties graph. Replace the graph URI in the GRAPH clause with any named graph of interest.
Finds every entity across all LINCS named graphs that has been assigned two or more rdf:type values, grouped by entity and graph, with the full list of types and a count.
Finds all crm:E55_Type instances in the Yellow Nineties graph that have at least two distinct English labels. Useful for catching duplicate or inconsistent type definitions. Replace the graph URI in the GRAPH clause with any named graph of interest.
Returns all places and their crm:P168_place_is_defined_by coordinate values in the MoEML graph. Replace the graph URI in the GRAPH clause with any dataset that records geographic coordinates.
Returns every distinct predicate URI used in the MoEML graph. Useful for understanding what properties are actually present in a dataset. Replace the graph URI in the GRAPH clause with any named graph of interest.
Finds entities in the MoEML graph that have at least one rdfs:label but none of them are tagged with the en language code. Replace "en" and the graph URI in the GRAPH clause to check other graphs or languages.
Returns triples where the subject and object refer to the same entity (by string value) in the MoEML graph. Helps identify circular or reflexive relationships that may be data errors. Replace the graph URI in the GRAPH clause with any named graph of interest.
Finds entities whose rdfs:label contains a comma or semicolon — characters that sometimes indicate incorrectly combined labels. Replace the graph URI in the GRAPH clause with any named graph of interest.
Finds entities typed as both crm:E21_Person and crm:E74_Group across all named graphs. Replace either type with crm:E39_Actor to find entities with both a superclass and a subclass assigned.
Returns every http://temp.lincsproject.ca/ URI that appears as either a subject or object in the MoEML graph. Temporary URIs indicate entities that still need minting or reconciliation against authoritative identifiers. Replace the graph URI in the GRAPH clause with any named graph of interest.