hose
datasets
Chinook The Chinook database that didn't stop in 2013. Jaffle Shop The jaffle shop didn't close when the tutorial ended. Northwind Northwind is still taking orders. Overwater A plant store with a funnel, not just an orders table. Quenchly A SaaS whose MRR you can audit down to the invoice.
use cases
Sales demos Demo data that moves during the call. Testing Test data with known answers, free to download. Benchmarks Benchmark data with a skew and a clock. Teaching Course datasets with the answer key included.
Demo data with a pulse

A hose dataset · canonical

The Chinook database that didn't stop in 2013.

The same music store, the same tables you know. The invoices kept coming.

SQLite one file, ready to query CSV tar.gz, one file per table

3,953,160 rows · last row 3 minutes ago

hose → chinook 3,953,160 rows live
Rows as the generator writes them, straight from the API. Real speed. Quiet hours are quiet, the way a real business is.

The receipt

seed
42
scale
250
start
2022-01-01
fingerprint
04b4f7abb248
license
MIT

The whole dataset grows from this one seed. Everyone who downloads it gets the same rows with the same ids, today and next month, so whatever you build on it keeps working after the data refreshes.

The schema is Luis Rocha's Chinook, reused under the MIT License. The license includes its notice. This dataset is not affiliated with or endorsed by Luis Rocha.

Invoices per day, last 90 days

2026-08-07: 8612026-08-08: 8462026-08-09: 7932026-08-10: 4302026-08-11: 3592026-08-12: 4272026-08-13: 5402026-08-14: 9402026-08-15: 9602026-08-16: 8682026-08-17: 4962026-08-18: 3692026-08-19: 4652026-08-20: 5122026-08-21: 8622026-08-22: 9742026-08-23: 9252026-08-24: 4482026-08-25: 4362026-08-26: 4592026-08-27: 5972026-08-28: 9842026-08-29: 11222026-08-30: 10232026-08-31: 4392026-09-01: 5242026-09-02: 6092026-09-03: 7792026-09-04: 10732026-09-05: 13162026-09-06: 12492026-09-07: 3632026-09-08: 5592026-09-09: 6152026-09-10: 7442026-09-11: 11852026-09-12: 13542026-09-13: 12822026-09-14: 6072026-09-15: 5942026-09-16: 7202026-09-17: 8872026-09-18: 14922026-09-19: 15452026-09-20: 14352026-09-21: 6802026-09-22: 6502026-09-23: 7502026-09-24: 7852026-09-25: 12832026-09-26: 14502026-09-27: 13132026-09-28: 6082026-09-29: 5872026-09-30: 7162026-10-01: 8722026-10-02: 13222026-10-03: 12692026-10-04: 14072026-10-05: 6752026-10-06: 6952026-10-07: 7432026-10-08: 8242026-10-09: 13892026-10-10: 15552026-10-11: 13922026-10-12: 3992026-10-13: 6672026-10-14: 7222026-10-15: 9192026-10-16: 13732026-10-17: 15782026-10-18: 14152026-10-19: 7192026-10-20: 6152026-10-21: 7762026-10-22: 9462026-10-23: 13312026-10-24: 15022026-10-25: 13242026-10-26: 6922026-10-27: 5882026-10-28: 7212026-10-29: 8702026-10-30: 13682026-10-31: 15782026-11-01: 13622026-11-02: 7252026-11-03: 6372026-11-04: 702

Schema · 11 tables

Artist

180 rows

  • ArtistIdint · key
  • Nametext

Album

903 rows

  • AlbumIdint · key
  • Titletext
  • ArtistIdint

Track

10,793 rows

  • TrackIdint · key
  • Nametext
  • AlbumIdint
  • MediaTypeIdint
  • GenreIdint
  • Composertext
  • Millisecondsint
  • Bytesint
  • UnitPricereal

Genre

6 rows

  • GenreIdint · key
  • Nametext

MediaType

5 rows

  • MediaTypeIdint · key
  • Nametext

Playlist

18 rows

  • PlaylistIdint · key
  • Nametext

PlaylistTrack

2,904 rows

  • idtext · key
  • PlaylistIdint
  • TrackIdint

Employee

4 rows

  • EmployeeIdint · key
  • LastNametext
  • FirstNametext
  • Titletext
  • ReportsToint
  • BirthDatetime
  • HireDatetime
  • Addresstext
  • Citytext
  • Statetext
  • Countrytext
  • PostalCodetext
  • Phonetext
  • Faxtext
  • Emailtext

Customer

25,249 rows

  • CustomerIdint · key
  • FirstNametext
  • LastNametext
  • Companytext
  • Addresstext
  • Citytext
  • Statetext
  • Countrytext
  • PostalCodetext
  • Phonetext
  • Faxtext
  • Emailtext
  • SupportRepIdint

Invoice

823,138 rows

  • InvoiceIdint · key
  • CustomerIdint
  • InvoiceDatetime
  • BillingAddresstext
  • BillingCitytext
  • BillingStatetext
  • BillingCountrytext
  • BillingPostalCodetext
  • Totalreal

InvoiceLine

3,089,960 rows

  • InvoiceLineIdint · key
  • InvoiceIdint
  • TrackIdint
  • UnitPricereal
  • Quantityint

Why this one

The Chinook everyone downloads was frozen in 2013. Every tutorial built on it teaches from a business where nothing has happened in over a decade, and every chart it produces falls off the same cliff.

This one runs on hose. The catalogue and the sales pattern match the original, and the sales continue through this morning. Retention curves have a today. Month-over-month comparisons include this month. Regenerate it with the same seed and every id and timestamp returns exactly as it was, so anything you build against it keeps reconciling.

Chinook was published with scripts for several engines, including SQL Server. The CSV bundle has one file per table that SQL Server’s flat-file import can load, and the schema above lists their columns and types.

The other datasets