a ; "830"^^; "11073"^^; . a ; "Select orders"; "PREFIX schema: \n\n SELECT DISTINCT ?order\n WHERE\n { GRAPH ?doc\n { ?order a schema:Order ;\n schema:identifier ?orderID ;\n schema:orderDate ?orderDate ;\n schema:customer ?customer ;\n schema:broker ?employee ;\n schema:orderStatus ?status\n }\n }\n ORDER BY DESC(?orderDate)" . a ; "Late shipments by carrier"; "PREFIX schema: \n\nSELECT ?carrier (ROUND(SUM(IF(?status = schema:OrderProblem, 1, 0)) * 1000 / COUNT(?order)) / 10 AS ?latePercent)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderStatus ?status ;\n schema:orderDelivery ?delivery .\n ?delivery schema:provider ?shipper .\n }\n GRAPH ?shipperGraph {\n ?shipper schema:legalName ?carrier .\n }\n # not yet dispatched is not the same as delivered late\n FILTER (?status != schema:OrderProcessing)\n}\nGROUP BY ?carrier\nORDER BY DESC(?latePercent)" . a ; ; ; ; ; ; ; ; ; ; ; "2026-10-25T16:42:20.166Z"^^; ; "2026-10-25T16:49:00.785Z"^^; "Orders"; ; . a ; ; "orders.rq"; "orders.rq"; "3740deadaa030994491fe869f07d6fdb13293740" . a ; ; "Order details"; "order_details.csv"; "6818fb4a761468a0ceb2ee7a224b0fa84859e491" . a ; ; "Orders"; "orders.csv"; "3c23e13529beb208a8b24d1eb7f6737d846355b5" . a ; "Orders"; "PREFIX foaf: \nPREFIX dct: \nPREFIX schema: \nPREFIX xsd: \n\nCONSTRUCT\n{\n GRAPH ?graph\n {\n ?graph dct:title ?orderID ;\n foaf:primaryTopic ?order ;\n foaf:topic ?orderDelivery, ?deliveryAddress, ?shipment,\n ?shippingOffer, ?freightCharge .\n\n ?order a schema:Order ;\n schema:identifier ?orderID ;\n schema:name ?orderID ;\n schema:customer ?customer ;\n schema:broker ?employee ;\n schema:orderDate ?orderDate ;\n schema:orderStatus ?status ;\n schema:acceptedOffer ?shippingOffer ;\n schema:orderDelivery ?orderDelivery .\n\n ?orderDelivery a schema:ParcelDelivery ;\n foaf:page ?graph ;\n schema:partOfOrder ?order ;\n schema:expectedArrivalUntil ?requiredDate ;\n schema:deliveryStatus ?shipment ;\n schema:deliveryAddress ?deliveryAddress ;\n schema:provider ?shipper .\n\n # schema:ParcelDelivery has no price property either. A delivery charge is a\n # schema:DeliveryChargeSpecification, and the only way into a PriceSpecification\n # is schema:priceSpecification from an Offer - so the freight the customer\n # accepted is spelled out as exactly that.\n ?shippingOffer a schema:Offer ;\n foaf:page ?graph ;\n schema:name \"Shipping\" ;\n schema:priceSpecification ?freightCharge .\n\n ?freightCharge a schema:DeliveryChargeSpecification ;\n foaf:page ?graph ;\n schema:name \"Freight\" ;\n schema:price ?freight ;\n schema:priceCurrency \"USD\" ;\n schema:appliesToDeliveryMethod schema:ParcelService .\n\n # schema:ParcelDelivery has no date of its own for \"when did this leave the warehouse\".\n # The vocabulary models the journey as a series of schema:DeliveryEvent legs hanging\n # off schema:deliveryStatus; Northwind knows exactly one leg, the dispatch.\n ?shipment a schema:DeliveryEvent ;\n foaf:page ?graph ;\n schema:name ?shipmentName ;\n schema:startDate ?shippedDate .\n\n ?deliveryAddress a schema:PostalAddress ;\n foaf:page ?graph ;\n schema:addressCountry ?shipCountry ;\n schema:addressLocality ?shipCity ;\n schema:postalCode ?shipPostalCode ;\n schema:streetAddress ?shipAddress ;\n schema:addressRegion ?shipRegion .\n }\n}\nWHERE\n{\n ?order_row <#orderID> ?orderID ;\n <#customerID> ?customerID ;\n <#employeeID> ?employeeID ;\n <#orderDate> ?orderDateString ;\n <#requiredDate> ?requiredDateString ;\n <#shipVia> ?shipVia ;\n <#freight> ?freightString ;\n <#shipName> ?shipName ;\n <#shipAddress> ?shipAddress ;\n <#shipCity> ?shipCity ;\n <#shipCountry> ?shipCountry .\n\n # ?shipment is bound inside the OPTIONAL so that the 21 orders that were never\n # dispatched get no DeliveryEvent at all, rather than an empty one. It is built from\n # $base (a constant, substituted before execution) and a re-matched ?orderID rather\n # than from ?graph: an OPTIONAL group is evaluated standalone, so variables BINDed in\n # the enclosing group are not in scope inside it.\n OPTIONAL {\n ?order_row <#orderID> ?orderID ;\n <#shippedDate> ?shippedDateString .\n BIND(strdt(?shippedDateString, xsd:date) AS ?shippedDate)\n BIND(uri(concat(str($base), \"orders/\", encode_for_uri(?orderID), \"/#shipment\")) AS ?shipment)\n BIND(concat(\"Shipped \", ?shippedDateString) AS ?shipmentName)\n }\n OPTIONAL {\n ?order_row <#shipRegion> ?shipRegion\n }\n # 19 orders carry no postal code; requiring one here dropped them from the import\n OPTIONAL {\n ?order_row <#shipPostalCode> ?shipPostalCode\n }\n\n BIND(uri(concat(str($base), \"orders/\")) AS ?container)\n BIND(uri(concat(str(?container), encode_for_uri(?orderID), \"/\")) AS ?graph)\n BIND(uri(concat(str(?graph), \"#this\")) AS ?order)\n BIND(uri(concat(str(?graph), \"#delivery\")) AS ?orderDelivery)\n BIND(uri(concat(str(?graph), \"#delivery-address\")) AS ?deliveryAddress)\n BIND(uri(concat(str(?graph), \"#shipping\")) AS ?shippingOffer)\n BIND(uri(concat(str(?graph), \"#freight\")) AS ?freightCharge)\n BIND(uri(concat(str($base), \"employees/\", encode_for_uri(?employeeID), \"/#this\")) AS ?employee)\n BIND(uri(concat(str($base), \"customers/\", encode_for_uri(?customerID), \"/#this\")) AS ?customer)\n BIND(uri(concat(str($base), \"shippers/\", encode_for_uri(?shipVia), \"/#this\")) AS ?shipper)\n BIND(strdt(?orderDateString, xsd:date) AS ?orderDate)\n BIND(strdt(?requiredDateString, xsd:date) AS ?requiredDate)\n BIND(strdt(?freightString, xsd:float) AS ?freight)\n BIND(IF(BOUND(?shippedDate),\n IF(?shippedDate > ?requiredDate, schema:OrderProblem, schema:OrderDelivered),\n schema:OrderProcessing) AS ?status)\n}\n" . a ; "
\n
\n

Order analytics

\n

Beyond the individual records, how has order volume developed over time?

\n
\n
"^^ . a ; "Revenue by carrier"; ; "month"; ; "federalShipping" , "unitedPackage" , "speedyExpress" . a ; "Days to ship"; ; "month"; ; "daysToShip" . a ; ; "Days to ship" . a ; "Order details"; ; "2026-10-25T17:10:38.079Z"^^; "2026-10-25T16:49:00.919Z"^^; ","; . a ; "
\n
\n

The order book

\n

Every order links a customer, the sales rep who booked it, the shipper that delivered it and the\n products it contains. Orders are listed newest first with their status — sort any column or\n filter with the facets. Open one for its full master–detail view: line items with their\n quantities and line totals, the catalogue price each was struck against, the delivery\n and its address, and the people and companies involved.

\n
\n
"^^ . a ; "Order details"; "PREFIX foaf: \nPREFIX dct: \nPREFIX schema: \nPREFIX xsd: \n\nCONSTRUCT\n{\n GRAPH ?graph\n {\n # the order's title, exactly as orders.rq writes it: the two imports run concurrently, and whichever\n # reaches an order's document first creates it, which a document without a dct:title cannot be\n ?graph dct:title ?orderID ;\n foaf:topic ?orderItem, ?listPrice .\n\n ?order schema:orderedItem ?orderItem .\n\n # schema:OrderItem carries no price in schema.org - its only properties are\n # orderedItem, orderQuantity, orderItemNumber, orderItemStatus and orderDelivery.\n # Prices belong to schema:Offer, so the line is both: the item that was ordered\n # and the offer that was accepted for it. schema:Offer's own schema:price is the\n # price of the offer as a whole, i.e. what this line came to.\n ?orderItem a schema:OrderItem, schema:Offer ;\n schema:orderedItem ?product ;\n schema:itemOffered ?product ;\n schema:orderQuantity ?quantity ;\n schema:price ?lineTotal ;\n schema:priceCurrency \"USD\" ;\n schema:priceSpecification ?listPrice .\n\n # Northwind's per-line discount rate has no home in schema.org - schema:discount\n # is an Order-level property. Nothing is lost by dropping it: the undiscounted\n # unit price below, the quantity above and the line total pin the rate exactly,\n # and unlike a stored rate they cannot disagree with each other.\n ?listPrice a schema:UnitPriceSpecification ;\n schema:name \"List price\" ;\n schema:priceType schema:ListPrice ;\n schema:price ?price ;\n schema:priceCurrency \"USD\" .\n }\n}\nWHERE\n{\n ?order_detail_row <#orderID> ?orderID ;\n <#productID> ?productID ;\n <#unitPrice> ?unitPrice ;\n <#quantity> ?quantityString ;\n <#discount> ?discountString .\n\n BIND(uri(concat(str($base), \"orders/\", encode_for_uri(?orderID), \"/\")) AS ?graph)\n BIND(uri(concat(str(?graph), \"#this\")) AS ?order)\n # a line is identified by its order and product (an order has at most one line per product), so re-running\n # the import writes the same resources rather than minting a second copy of every line\n BIND(uri(concat(str(?graph), \"#\", sha1(concat(?orderID, \"/\", ?productID)))) AS ?orderItem)\n BIND(uri(concat(str(?orderItem), \"-list-price\")) AS ?listPrice)\n BIND(uri(concat(str($base), \"products/\", encode_for_uri(?productID), \"/#this\")) AS ?product)\n BIND (STRDT(?unitPrice, xsd:float) AS ?price)\n BIND (STRDT(?quantityString, xsd:integer) AS ?quantity)\n BIND (STRDT(?discountString, xsd:float) AS ?discount)\n BIND (STRDT(str(round(?quantity * ?price * (1 - ?discount) * 100) / 100), xsd:float) AS ?lineTotal)\n}\n" . a ; "On-time rate by month"; "PREFIX schema: \n\nSELECT ?month (ROUND(SUM(IF(?status = schema:OrderDelivered, 1, 0)) * 1000 / COUNT(?order)) / 10 AS ?onTimePercent)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderDate ?orderDate ;\n schema:orderStatus ?status .\n BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)\n }\n # an order still awaiting dispatch has no outcome yet - counting it as a miss would\n # drag the rate down for the months at the end of the book\n FILTER (?status != schema:OrderProcessing)\n # The order book stops part-way through its final month, which would render as a\n # cliff rather than a trend. Drop that month — derived from the data, not pinned\n # to a date, so it stays correct if the dataset grows.\n {\n SELECT (SUBSTR(STR(MAX(?anyDate)), 1, 7) AS ?partialMonth)\n WHERE {\n GRAPH ?g { ?anyOrder a schema:Order ; schema:orderDate ?anyDate }\n }\n }\n FILTER (?month < ?partialMonth)\n}\nGROUP BY ?month\nORDER BY ?month" . a ; "Days to ship by month"; "PREFIX schema: \nPREFIX xsd: \n\nSELECT ?month (ROUND(AVG(?days) * 10) / 10 AS ?daysToShip)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderDate ?orderDate ;\n schema:orderDelivery ?delivery .\n # the dispatch is a DeliveryEvent leg of the parcel's journey, so orders that\n # never shipped simply have no event and drop out of the average\n ?delivery schema:deliveryStatus ?shipment .\n ?shipment schema:startDate ?shippedDate .\n BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)\n BIND((?shippedDate - ?orderDate) / xsd:dayTimeDuration(\"P1D\") AS ?days)\n }\n # The order book stops part-way through its final month, which would render as a\n # cliff rather than a trend. Drop that month — derived from the data, not pinned\n # to a date, so it stays correct if the dataset grows.\n {\n SELECT (SUBSTR(STR(MAX(?anyDate)), 1, 7) AS ?partialMonth)\n WHERE {\n GRAPH ?g { ?anyOrder a schema:Order ; schema:orderDate ?anyDate }\n }\n }\n FILTER (?month < ?partialMonth)\n}\nGROUP BY ?month\nORDER BY ?month" . a ; ; "Shipped on time" . a ; "2155"^^; "10775"^^; . a ; "Shipped on time"; ; "month"; ; "onTimePercent" . a ; "All orders"; ; . a ; ; "Revenue by carrier" . a ; ; "Orders per month" . a ; "Orders per month"; ; "month"; ; "orderCount" . a ; ; "Late shipments by carrier" . a ; "
\n
\n

Who carries the freight

\n

Three carriers deliver every order, which makes them worth comparing on two\n axes. How often does a carrier miss the date the customer was promised, and\n how much revenue does each one move month to month? The first is a question\n about reliability, the second about how the shipping mix has shifted.

\n
\n
"^^ . a ; ; "order_details.rq"; "order_details.rq"; "66a1c3c8ae823c3342ab23d4951a2640af80f321" . a ; ; "All orders" . a ; "Orders"; ; "2026-10-25T16:48:53.458Z"^^; "2026-10-25T16:44:06.248Z"^^; ","; . a ; "Orders by month"; "PREFIX schema: \n\nSELECT ?month (COUNT(DISTINCT ?order) AS ?orderCount)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderDate ?orderDate .\n BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)\n }\n}\nGROUP BY ?month\nORDER BY ?month" . a ; "
\n
\n

From order to doorstep

\n

Every order records three dates: the day it was placed, the day the customer needed it\n by, and — once the parcel actually leaves the warehouse — the day it was dispatched.\n Two questions fall out of those. How quickly does Northwind get an order out of the\n door, and how often does it beat the date it promised? Orders still waiting to ship\n are left out of the second chart, since they have no outcome yet.

\n
\n
"^^ . a ; "Revenue by carrier"; "PREFIX schema: \n\nSELECT ?month\n (ROUND(SUM(IF(?carrier = \"Speedy Express\", ?lineTotal, 0))) AS ?speedyExpress)\n (ROUND(SUM(IF(?carrier = \"United Package\", ?lineTotal, 0))) AS ?unitedPackage)\n (ROUND(SUM(IF(?carrier = \"Federal Shipping\", ?lineTotal, 0))) AS ?federalShipping)\nWHERE {\n GRAPH ?orderGraph {\n ?order a schema:Order ;\n schema:orderDate ?orderDate ;\n schema:orderDelivery ?delivery ;\n schema:orderedItem ?orderItem .\n ?orderItem schema:price ?lineTotal .\n ?delivery schema:provider ?shipper .\n }\n GRAPH ?shipperGraph {\n ?shipper schema:legalName ?carrier .\n }\n BIND(SUBSTR(STR(?orderDate), 1, 7) AS ?month)\n # Drop the final, incomplete month - derived from the data rather than pinned to a date.\n {\n SELECT (SUBSTR(STR(MAX(?anyDate)), 1, 7) AS ?partialMonth)\n WHERE {\n GRAPH ?g { ?anyOrder a schema:Order ; schema:orderDate ?anyDate }\n }\n }\n FILTER (?month < ?partialMonth)\n}\nGROUP BY ?month\nORDER BY ?month" . a ; "Late shipments by carrier"; ; "carrier"; ; "latePercent" .