othersyntheticorderscsvjsonlsqliteinteger-centsdecimal-roundingqapython

Synthetic order totals QA: 10,000 CSV/JSONL rows + SQLite demo and 11 tests

Updated Nov 10, 2026

Fixed price

Sample structure: Not assessed

0 download links issued

Seller: Alan

Already have an account? Log in

Have an API key? Use the REST API →

Source, license and coverage

Supplier documentation. These claims are separate from the automated sample score. A listing edit date is not a data freshness date.

License: Internal personal/commercial testing and demos only; modification allowed. No resale, redistribution or sublicensing of data or generator. No warranty, future updates or support SLA. See README.
Source / creator: Alan
Collection method: Original deterministic Python standard-library generator, seed20261109. No third-party source data. Creator: Alan. Fully synthetic QA records.
Coverage start: Not applicable
Coverage end: Not applicable
Data last updated: Not documented
Update schedule: Fixed snapshot. No future updates included or promised.

Artificial QA fixture, not business observations. Dates2030, days1-28 only. Status independent of totals. No tax/payment model, statistical fidelity or application compatibility guaranteed. Not for predictive modeling or financial decisions. Only25preview rows public.

Sample structure score: Not assessed

This automated check describes the inspected sample, not factual accuracy, legal rights, representativeness, or the quality of the entire dataset. It is not a customer rating.

No sample has been provided

How the score is calculated, its limitations, and how to correct an assessment →

About this data

Test an order importer and decimal-total calculations with 10,000 artificial order rows and supplied expected totals. CSV + JSONL, 10 fields, 500 repeating fictional customer IDs and unique order IDs. AI-assisted QA fixture, not real sales data. ZIP includes both data formats, schema, deterministic Python standard-library generator, validator, SQLite importer, QA SQL queries, quickstart and 11 tests. SQLite demo imports the fixture into typed columns with integer-cent money amounts and refuses to overwrite an existing database. Clean extraction passes tests and imports 10,000 rows. Suggested checks: import CSV/JSONL and compare records; recompute expected totals using round-half-up; test zero quantities/prices, one-cent prices and 100% discounts; run the bundled SQLite checks. Formula: round_half_up(quantity x unit_price_cents x (100-discount_pct)/100) + shipping_cents. Shipping still applies at 100% discount. Limits: currency always USD. Dates are fictional 2030 dates, days 1-28 only. Status is independent of totals: cancelled/refunded rows retain hypothetical amounts. No tax, actual payments, linked tables or statistical fidelity. Grouped totals are NOT revenue. No customer names, emails, addresses or phone numbers; no source business records. Not for model training, forecasting, fraud research or financial decisions. Internal lawful testing/demos only; no redistribution, resale or sublicensing. No warranty, support SLA, future updates or production compatibility. Full terms in README.txt. Automatic public file samples remain disabled; full files are paid.

Retrieve with your agent or Python

Create an account and configure DATABAZAAR_API_KEY. This example retrieves free or already purchased data; it never makes a purchase. For a multi-file dataset, choose a file index from the manifest.

Download the Python example

python3 retrieve-dataset.py a9b6192f-cebc-4798-858b-24d80e5607b4 --output dataset.bin

Schema

Schema not available

Sample Data

No preview available

The seller has not provided a sample preview for this listing.

For AI Agents

Via MCP Server

# 1. Add to your agent's MCP config (claude_desktop_config.json or similar):
{
  "mcpServers": {
    "databazaar": { "command": "npx", "args": ["databazaar-mcp"] }
  }
}

# 2. Your agent can then call:
search_datasets({ query: "Synthetic order totals QA: 10," })
// Found: a9b6192f-cebc-4798-858b-24d80e5607b4
buy_now({ dataset_id: "a9b6192f-cebc-4798-858b-24d80e5607b4" })  // uses your saved card

Via REST API

# Authenticate with your API key:
curl https://api.databazaar.io/datasets/a9b6192f-cebc-4798-858b-24d80e5607b4 \
  -H "Authorization: Bearer YOUR_API_KEY"

# Purchase:
curl -X POST https://api.databazaar.io/datasets/a9b6192f-cebc-4798-858b-24d80e5607b4/buy \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"dataset_id": "a9b6192f-cebc-4798-858b-24d80e5607b4"}'