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.
Click an option to include it, again to exclude it, again to clear.
What datasets are here?
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.
Counts of triples in a specific graph
Returns the total number of triples in one named graph. Pick a different dataset to count it instead.
Counts of triples in all graphs
Returns a count of every triple in each named graph across the LINCS triplestore. Useful for a quick size overview of all datasets.
What kinds of things are in here and how many of each?
Counts instances of every RDF type across all graphs, ordered by frequency. A quick way to understand the class distribution of the entire triplestore.
What specific categories of things are here?
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").
What sorts of properties does this class have?
Lists all properties associated with a given CIDOC class in descending order of frequency. Pick a different class to inspect it instead.
What properties does this category of thing have?
Returns all distinct properties associated with a specific crm:E55_Type value. Pick a different vocabulary term to inspect it instead.
Show me instances of a particular vocabulary term
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.
What categories of things are in a particular dataset?
Returns all crm:E55_Type values within a specific named graph (USask Art Collection shown). Pick a different dataset to inspect it instead.
In what ways has a property been categorized?
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.
Basic query of instances across datasets
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.
Find coordinates for specific MoEML places
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.
All people in Yellow Nineties data with biographical information
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.
Count of isAbout relationships by dataset
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.
Authors' birth & death dates and places (Orlando)
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.
Cabinet Conclusion pages mentioning Quebec per month
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.
Topics co-mentioned with Quebec in Cabinet Conclusions (1970)
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.
Where did xDX events take place?
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.
Where did xDX production take place?
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.
Which places have more than 10 production events?
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.
Where did xDX design and creation take place?
Counts places by crm:E65_Creation event — the design activity behind a product, as distinct from its physical manufacture (crm:E12_Production).
What xDX events took place in a particular place?
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.
What else was made in the same place as a given product?
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.
Which xDX objects were produced in the 1960s?
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.
Which of two products came first?
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.
Which design firms, designers, and products are linked by intellectual property?
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.
What kettles did Fred Moffatt design?
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.
What is the earliest kettle Fred Moffatt designed?
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.
How many products did each designer design?
Counts products per person holding the industrial designer role (AAT 300025190), ordered by count.
What did Thomas Lamb design, and in what cultural context?
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.
What brands and designers are attached to xDX radios?
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.
How many unknown designers are in the xDX data?
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.
What objects were designed by an unknown designer?
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.
Which manufacturers produced the most xDX products?
Counts products per actor holding the manufacturer role (relators:mfr), ordered by count.
What products combine a given material and production technique?
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.
Which materials appear most often in xDX objects?
Counts human-made objects per material (crm:P45_consists_of), ordered by frequency.
Which production techniques are most common in xDX?
Counts crm:E12_Production events per general technique used, ordered by frequency.
Which products are made of metal or any narrower kind of metal?
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.
How many products are made of each kind of metal?
The metal products query grouped by material, giving a count for each specific metal that falls under the broader metal term.
What prototypes are in the xDX collection?
Human-made objects typed as prototypes (AAT 300166391). Pick or enter another type URI to list a different category of object.
Which xDX objects have archival files associated with them?
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.
What packaging is in the xDX collection?
Artefacts typed as packaging (AAT 300055100).
Who donated artefacts to the Design Exchange, and when?
Gift acquisitions (AAT 300417637) that transferred title to the Design Exchange (Wikidata Q5264264), showing the item, the previous keeper, and the year, sorted chronologically.
How many artefacts did each donor give to the Design Exchange?
Counts gift acquisitions per previous keeper, ordered by count.
How many artefacts did each donor give in a particular year?
The per-donor donation counts filtered to a single year (1999 as shown). Change the year to look at a different one.
How many donations did the Design Exchange receive each year?
Totals gift acquisitions by year, giving the shape of the collection's growth over time.
What was donated to the Design Exchange in a particular year?
Lists the individual items and their donors for one year (1999 as shown). Change the year to look at a different one.
Excerpts related to authors' mental health
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.
Excerpts about authors' relationships to a particular place
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.
People in one specific named graph
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.
Orlando and Yellow Nineties prosopography query
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.
Federated query using the Getty vocabulary
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.
Entities that are in xDX and another dataset
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.
All vocabulary namespace URIs used in a particular dataset
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.
LINCS vocabulary namespaces used by a particular dataset
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.
How many unique terms used per vocabulary by a particular dataset?
Counts distinct vocabulary term URIs per namespace in the Orlando graph, ordered by frequency. Pick a different dataset to inspect it instead.
All vocabulary terms used by all datasets ordered by use
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.
Vocabulary term counts and term list for a particular dataset
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.
How many times each vocabulary is used by a particular 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. Pick a different dataset to inspect it instead.
Vocabulary term counts and terms used by each 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.
Vocabulary term counts and terms used across all datasets
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.
Find entities missing rdfs:label in a named graph
Returns all subject URIs in the Yellow Nineties graph that have no rdfs:label triple. Pick a different dataset to check it instead.
Find entities missing rdf:type in a named graph
Returns all subject URIs in the Yellow Nineties graph that have no rdf:type triple. Pick a different dataset to check it instead.
Find entities that have at least two rdf:type values
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.
Entities with 2 or more rdf:type values across all graphs
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.
E55_Type entities with multiple distinct labels
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.
All geographic coordinates in a dataset
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.
All predicates used in a dataset
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.
Entities without an English-tagged rdfs:label
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.
Relationships where the same entity is subject and object
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.
rdfs:label values that contain semicolons or commas
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.
Entities classified as both a person and a group
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.
All temp.lincsproject.ca URIs in a dataset
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.