25 October 2026 17:42
RDF/XMLTurtleJSON-LD

All categories

View

Backlinks

beverages.jpg

File

Backlinks

FileName
beverages.jpg
Format
jpeg
Sha1sum (hex)
ec56b79671b30ecb98316d9b766fba198286b3b6
Title
beverages.jpg

Categories

CSV import

Backlinks

Delimiter
,
EndedAtTime
25 October 2026 17:42
File
Categories
Query
Categories
StartedAtTime
25 October 2026 17:42
Title
Categories

Categories

CONSTRUCT

Backlinks

Text
PREFIX foaf:       <http://xmlns.com/foaf/0.1/>
PREFIX dct:        <http://purl.org/dc/terms/>
PREFIX schema:     <https://schema.org/>

CONSTRUCT
{
    GRAPH ?graph
    {
        ?graph dct:title ?categoryName ;
            foaf:primaryTopic ?category .

        ?category a schema:ProductGroup ;
            schema:name ?categoryName ;
            schema:identifier ?categoryID ;
            schema:description ?description ;
            foaf:depiction ?picture .
    }
}
WHERE
{
    ?category_row <#categoryID> ?categoryID ;
        <#description> ?description ;
        <#categoryName> ?categoryName ;
        <#pictureHash> ?pictureHash .

    BIND(uri(concat(str($base), "categories/")) AS ?container)
    BIND(uri(concat(str(?container), encode_for_uri(?categoryID), "/")) AS ?graph)
    BIND(uri(concat(str(?graph), "#this")) AS ?category)
    BIND(uri(concat(str($base), "uploads/", encode_for_uri(?pictureHash))) AS ?picture)
}
Title
Categories

Categories

File

Backlinks

FileName
categories.csv
Format
csv
Sha1sum (hex)
58ee67ce53cfb3ad73368eda24a089314bb0bf41
Title
Categories

categories.rq

File

Backlinks

FileName
categories.rq
Format
octet-stream
Sha1sum (hex)
f9d9158c1eca2812af56d0c72d1cbc978b95c8a8
Title
categories.rq

Category revenue

SELECT

Backlinks

Text
PREFIX schema: <https://schema.org/>

SELECT ?categoryName (SUM(?sale) AS ?revenue)
WHERE {
    GRAPH ?orderGraph {
        ?order schema:orderedItem ?orderItem .
        ?orderItem schema:orderedItem ?product ;
                   schema:price ?sale .
    }
    GRAPH ?productGraph {
        ?product schema:category ?category .
    }
    GRAPH ?categoryGraph {
        ?category schema:name ?categoryName .
    }
}
GROUP BY ?category ?categoryName
ORDER BY DESC(?revenue)
Title
Category revenue

cereals.jpg

File

Backlinks

FileName
cereals.jpg
Format
jpeg
Sha1sum (hex)
8a3112b3c6691588d47028fd3907f45d24f47784
Title
cereals.jpg

condiments.jpg

File

Backlinks

FileName
condiments.jpg
Format
jpeg
Sha1sum (hex)
7e9f535a3bf693ec856702856fffd3be5a3df4f1
Title
condiments.jpg

confections.jpg

File

Backlinks

FileName
confections.jpg
Format
jpeg
Sha1sum (hex)
e781b6c8e83be3f23aa241416f92447a66dc35e4
Title
confections.jpg

diary.jpg

File

Backlinks

FileName
diary.jpg
Format
jpeg
Sha1sum (hex)
ee14378aa9de087150576af322146ba26552d2e1
Title
diary.jpg

id3928cbf6-f145-4413-9f81-6f72b7adf6ec

Dataset

Backlinks

DistinctSubjects
8
Triples
32
WasGeneratedBy
Categories

meat.jpg

File

Backlinks

FileName
meat.jpg
Format
jpeg
Sha1sum (hex)
11885d9b63b4fdac96dad23d4974df0d28bb8b26
Title
meat.jpg

produce.jpg

File

Backlinks

FileName
produce.jpg
Format
jpeg
Sha1sum (hex)
7c70989e58855ffd8628e0a7d5144a10fd70a1ee
Title
produce.jpg

Products per category

Result set chart

Backlinks

Category variable name
categoryName
Chart type
Bar chart
Query
Products per category
Series variable name
productCount
Title
Products per category

Products per category

SELECT

Backlinks

Text
PREFIX schema: <https://schema.org/>

SELECT ?categoryName (COUNT(DISTINCT ?product) AS ?productCount)
WHERE {
    GRAPH ?productGraph {
        ?product a schema:Product ;
                 schema:category ?category .
    }
    GRAPH ?categoryGraph {
        ?category schema:name ?categoryName .
    }
}
GROUP BY ?category ?categoryName
ORDER BY DESC(?productCount)
Title
Products per category

Revenue by category

Result set chart

Backlinks

Category variable name
categoryName
Chart type
Bar chart
Query
Category revenue
Series variable name
revenue
Title
Revenue by category

seafood.jpg

File

Backlinks

FileName
seafood.jpg
Format
jpeg
Sha1sum (hex)
778dd323b4e1923b8e0c0166b64913fb255b97a8
Title
seafood.jpg

Select categories

SELECT

Backlinks

Text
PREFIX  schema: <https://schema.org/>

  SELECT DISTINCT  ?category
  WHERE
    { GRAPH ?doc
        { ?category  a           schema:ProductGroup ;
                    schema:name  ?categoryName
        }
    }
  ORDER BY ?categoryName
Title
Select categories