SPARQL Query Catalog
A searchable index of pre-written SPARQL queries for discovering, exploring, and auditing LINCS linked open data. Filter by dataset or tag, or search by keyword, then expand a query to view the SPARQL and run it directly on the page.
TRANSLATION_NEEDED!Click a filter to include it, again to exclude it, again to clear.
TRANSLATION_NEEDED!Complexity
TRANSLATION_NEEDED!Dataset
TRANSLATION_NEEDED!Scope
TRANSLATION_NEEDED!Topic
TRANSLATION_NEEDED!Purpose
TRANSLATION_NEEDED!Schema
TRANSLATION_NEEDED!Features
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. Pick a different dataset to count it instead.
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. Pick a different class to inspect it instead.
Returns all distinct properties associated with a specific crm:E55_Type value. Pick a different vocabulary term to inspect it instead.
Finds all entities associated with a specific crm:E55_Type value. Pick a different vocabulary term, or enter any term URI — this works well with LINCS terms such as http://id.lincsproject.ca/cwrc/editing.
Returns all crm:E55_Type values within a specific named graph (USask Art Collection shown). Pick a different dataset to inspect it instead.
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 dates, death 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.
Counts every event in the xDX graph by the place it happened (crm:P7_took_place_at), ordered by frequency. Includes all event types — production, creation, acquisition — so it gives the broadest view of the collection's geography.
Narrows the all-events place counts to manufacturing only, by requiring each event to be a crm:E12_Production. Compare against the creation/design counts to see where things were made versus where they were designed.
The production place counts restricted with a HAVING clause, leaving only the most significant manufacturing centres. Change the threshold to widen or narrow the list.
Counts places by crm:E65_Creation event — the design activity behind a product, as distinct from its physical manufacture (crm:E12_Production).
Returns every event linked to one GeoNames place — Stratford, Ontario (6157977) as shown. Pick or enter another GeoNames URI to pivot to any location surfaced by the place-count queries.
Finds the production place of one product, then returns everything else produced there. Bound to the Baby Champ Northern Electric Radio — pick or enter another product URI to start from a different object. Note: the original version of this query used a http://temp.lincsproject.ca/ URI that has since been retired; this uses the minted id.lincsproject.ca equivalent.
Returns production events whose time-span begins in the 1960s, with start and end dates and the place where recorded. Change the year range to look at a different period.
Compares the production start dates of two products and returns whichever is earlier. Shown with the Clairtone 7001 Project G3 Tabletop Stereo Speaker (1966) and the Alexander Graham Bell Plane Phone, Model 450 (1977). Pick or enter a different pair to compare. Both default URIs were updated from retired temp.lincsproject.ca identifiers to their minted equivalents.
Joins a designer's role assignment to the design they created, the product that design is about, the firm that employs them and holds the intellectual property right (crm:P75_possesses), and the production start date where available.
Products typed as kettles (AAT 300195349) created by Fred Moffatt in the role of industrial designer, with their xDX identifier and — where recorded — materials, related notes, and production start date. Change the designer and product type to ask the same question of any other pairing.
The kettle query ordered by production start date and limited to a single result. The date binding is required rather than optional here, since a kettle with no recorded date cannot be ranked.
Counts products per person holding the industrial designer role (AAT 300025190), ordered by count.
Products designed by Thomas Lamb (Wikidata Q110562149) together with any cultural context note attached to them (AAT 300435428). Pick or enter another person URI to follow a different designer.
Products typed as radio receivers (AAT 300248664) with their xDX identifier, plus brand and designer where recorded. Brand is OPTIONAL because it is sparsely populated — 21 objects are typed as radio receivers but only one currently carries a brand link.
Counts distinct entities whose label contains unknown designer. Note this is a string match on rdfs:label rather than a typed relationship, so it depends on that labelling convention holding.
Lists objects linked to a person whose label contains unknown designer. Like the count query, this relies on a label string match rather than a typed relationship.
Counts products per actor holding the manufacturer role (relators:mfr), ordered by count.
Finds products made from a material (crm:P45_consists_of) whose production event used a particular technique (crm:P32_used_general_technique). Bound to fabric (AAT 300231565) and lining (AAT 300162124) — change either value to test a different combination.
Counts human-made objects per material (crm:P45_consists_of), ordered by frequency.
Counts crm:E12_Production events per general technique used, ordered by frequency.
Uses the property path crm:P127_has_broader_term* to walk up the AAT hierarchy, so a product made of aluminum or brass still matches a query for metal (AAT 300010900). Pick or enter another broad material term to walk a different hierarchy.
The metal products query grouped by material, giving a count for each specific metal that falls under the broader metal term.
Human-made objects typed as prototypes (AAT 300166391). Pick or enter another type URI to list a different category of object.
Links objects to archival files through the model they belong to: an object has a model type, and an crm:E73_Information_Object refers to that model.
Gift acquisitions (AAT 300417637) that transferred title to the Design Exchange (Wikidata Q5264264), showing the item, the previous keeper, and the year, sorted chronologically.
Counts gift acquisitions per previous keeper, ordered by count.
The per-donor donation counts filtered to a single year (1999 as shown). Change the year to look at a different one.
Totals gift acquisitions by year, giving the shape of the collection's growth over time.
Lists the individual items and their donors for one year (1999 as shown). Change the year to look at a different one.
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. Pick or enter another GeoNames URI (Wales shown here) to filter excerpts by a different location.
Returns all crm:E21_Person instances in one named graph (Orlando shown) and another dataset. Pick or enter another graph URI to list people in a different dataset.
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. Pick a different dataset to inspect it instead.
Same as the all-namespaces query but filtered to URIs containing lincsproject. Returns only LINCS-owned vocabulary namespaces used in the Orlando graph. Pick a different dataset to inspect it instead.
Counts distinct vocabulary term URIs per namespace in the Orlando graph, ordered by frequency. Pick a different dataset to inspect it instead.
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. Pick a different dataset to inspect it instead.
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. Pick a different dataset to inspect it instead.
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. Pick a different dataset to check it instead.
Returns all subject URIs in the Yellow Nineties graph that have no rdf:type triple. Pick a different dataset to check it instead.
Returns pairs of distinct types for any entity that has been assigned more than one rdf:type in the Yellow Nineties graph. Pick a different dataset to check it instead.
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. Pick a different dataset to check it instead.
Returns all places and their crm:P168_place_is_defined_by coordinate values in the MoEML graph. Pick any other 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. Pick a different dataset to inspect it instead.
Finds entities in the MoEML graph that have at least one rdfs:label but none of them are tagged with the en language code. Change the dataset or the language code 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. Pick a different dataset to check it instead.
Finds entities whose rdfs:label contains a comma or semicolon — characters that sometimes indicate incorrectly combined labels. Pick a different dataset to check it instead.
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. Pick a different dataset to check it instead.