Graph · dataset · registered
Chinook music store
What the Chinook sample database means: a digital music store that sells tracks to customers in 24 countries. Each concept is bound to the ModelSpec record type or field that holds it; concepts that are not specific to Chinook are reused from the core concepts.
Where it is, what shape it has, what it means. OVDB Directory: where the data is. ModelSpec: its shape. MeaningGraph: what it means.
Provenance
Where it lives
3e7bb316d8a438eb7e5930067997a4e4543a275cThe registry pins this commit; every concept below is read from it.meaning://github.com/demo-db/chinookchinook — ModelSpec registry model/chinook.modelspec.hcl at commit 3e7bb31 · View in CodeGrapher Concepts
What Chinook music store defines
An album by one artist, known by its title.
A recording artist or band, known by its name.
The country an invoice is billed to, as Chinook spells it ("USA", "Czech Republic"). Use this one when a question asks which countries buy or spend: it is recorded on the sale…
A person who buys music from the store. Some customers name a company.
The country in the customer's address, as Chinook spells it ("USA", "Czech Republic"). For questions about where music is bought, use billing-country instead.
A member of the store's staff. Employee.Title is the job title.
A music genre such as Rock or Jazz, assigned to tracks.
A billing invoice for tracks purchased by a customer. Chinook has 412 invoices dated from 2021-01-01 to 2025-12-22. It is an invoice record, not the request to supply represented…
The date of a purchase. The time part is always midnight.
One track bought on an invoice.
The amount charged on an invoice. It equals the sum of UnitPrice x Quantity over the invoice's lines (true for all 412 invoices).
The price of one copy of a track in the catalogue (0.99 or 1.99). The price actually charged is on the invoice line (see unit-price).
The employee someone reports to. Empty for the general manager.
The file format of a track, such as "MPEG audio file" or "Protected AAC audio file".
Money the store took for music. The data names no currency; Chinook's prices (0.99 and 1.99) are read as US dollars.
Music sales in a country divided by its population, per million people, so that small and large countries can be compared. Answers "Which countries buy the most music relative to…
A named list of tracks. A track can be on many playlists and a playlist holds many tracks; PlaylistTrack records which track is on which list.
Not in Chinook. The population of each billing country, from the World Bank, matched to Chinook's country names through the ISO 3166-1 alpha-2 code of the universal country…
Copies of a track bought on one invoice line (always 1 in Chinook).
The employee who looks after a customer.
One audio or video track that the store sells, usually on an album.
How long a track plays.
The price charged for one copy of a track on an invoice line.