DATASET / PAGINATION

103 records for pagination boundary tests

An uneven number of records with contiguous IDs. Verify final partial pages, termination, completeness and stable ordering.

103 ROWS · GENERATED FIXTURE · CC0 · VERSION 2026-10-01.1

Use the complete fixture

Download all rows as CSV ↓ · Download JSON ↓ · Paginated API →

GET /api/fixtures/pagination?offset=0&limit=20

Schema

Column	Type
`id`	integer
`group`	string
`value`	integer
`synthetic`	boolean

Expected results

rows	103
id min	1
id max	103
id sum	5356
pages at limit 20	6
last page rows at limit 20	3

Preview

[
  {
    "id": 1,
    "group": "alpha",
    "value": 0,
    "synthetic": true
  },
  {
    "id": 2,
    "group": "beta",
    "value": 17,
    "synthetic": true
  }
]

Reproducibility

Compare exact downloaded bytes against the SHA-256 manifest. CSV uses UTF-8 and CRLF record terminators; embedded newlines are quoted. JSON uses null; CSV represents null as an empty field.