Skip to main content

sqllocks-shape-domains

Shape plugin: industry domains with their reference data (shape.domains).

Domain Tables Reference data
retail customer, address, product_category, product, store, promotion, order, order_line, return (3NF) product categories, product and promotion names, 40,977 US ZIP locations
capital_markets exchange, sector, industry, company, daily_price, dividend, earnings, insider_transaction, split, trade exchanges, GICS sectors, index memberships, 123 S&P 500 constituents
education department, course, instructor, student, course_section, academic_standing, enrollment, financial_aid, grade_appeal aid types, course catalog, department names
financial branch, transaction_category, customer, account, loan, card, loan_payment, statement, transaction, fraud_flag branch, merchant and transaction category names; the retail ZIP locations
healthcare provider, facility, patient, encounter, diagnosis, procedure, medication, claim, claim_line CPT and ICD-10 codes, insurance plans, medication names, specialties; the retail ZIP locations
hr department, position, employee, compensation, performance_review, time_off_request, training, training_enrollment, termination department names, position titles, training courses
insurance agent, policyholder, policy_type, policy, coverage, claim, claim_payment, premium_payment, underwriting claim categories, peril types, policy types; the retail ZIP locations
iot device_type, location, device, sensor, reading, alert, maintenance_log, command alert severity levels, device types, sensor types; the retail ZIP locations
manufacturing production_line, product, bom, work_order, quality_check, defect, equipment, downtime_event, production_metric defect codes, material types, operation types
marketing campaign_type, industry, campaign, lead_source, contact, lead, opportunity, email_send, web_visit, conversion campaign types, industry names, lead sources
pulse rider, driver, vehicle, trip (ride-hailing) none
real_estate neighborhood, agent, property, listing, showing, offer, transaction, inspection, appraisal inspection items, neighborhoods, property types; the retail ZIP locations
supply_chain warehouse, supplier, material, purchase_order, purchase_order_line, inventory, shipment, shipment_event, quality_inspection, demand_forecast carrier names, material categories, shipping methods; the retail ZIP locations
telecom plan, device_model, subscriber, service_line, usage_record, billing, payment, network_event, churn_indicator device models, network event types, plan types; the retail ZIP locations
from shape.generation.domains import load_domain
from shape.generation.engine import Engine

domain = load_domain("retail")  # schema + reference data registered
tables = Engine(domain.schema, scale="medium", seed=1).generate().tables

Scales: small, medium, large and xlarge (and the other presets in the schema). Every domain also offers a star schema (load_domain(name, mode="star")). The ZIP locations are derived from GeoNames (CC BY 4.0), and the other reference data is carried over under the MIT license; see THIRD_PARTY_NOTICES.md in the repository.

Composites: shape composite enterprise (or retail+hr+financial) generates several domains as one dataset. The package names the six presets (enterprise, healthcare_system, smart_factory, digital_commerce, campus, telecom_bundle) and the table that plays a person, a location or an organisation in each domain (shape_domains.composition); core merges the schemas (docs/GENERATION_ENGINE.md).

It also ships the reference pack us-zip-city (dataset us_zip_city: ZIP as five-character text, city, state code and county; GeoNames, CC BY 4.0), which shape profile --reference-pair, the reference_pair contract rule and the generation strategies read by name; see docs/REFERENCE_PACKS.md in the repository.

Its version always equals core's (sqllocks-shape), and it is released together with core. How plugins are written: docs/plugins/authoring.md in the repository.

Metadata

Release files for sqllocks-shape-domains 0.9.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqllocks-shape-domains 0.9.1
File Size Uploaded Provenance
sqllocks_shape_domains-0.9.1.tar.gz 1.3 MB With provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for sqllocks-shape-domains 0.9.1
File Interpreter ABI Platform
sqllocks_shape_domains-0.9.1-py3-none-any.whl Python 3 none any Details

Total release size: 2.6 MB

Release files / sqllocks_shape_domains-0.9.1.tar.gz

Download URL sqllocks_shape_domains-0.9.1.tar.gz
Size 1.3 MB
Tags Source
SHA-256 checksum
How to use checksums
1a1c93cece802ea53ec7890c1ee195b65b5d4dcd938f786941af12e585c026ea
BLAKE2b-256 checksum
How to use checksums
e7652345112f4aa023c6ea79b5e5dd8097716fa3352212f01eadd75cc5800ed5
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 11, 2026.

Transparency log

Release files / sqllocks_shape_domains-0.9.1-py3-none-any.whl

Download URL sqllocks_shape_domains-0.9.1-py3-none-any.whl
Size 1.3 MB
Tags Python 3
SHA-256 checksum
How to use checksums
cc13dc8d6910b26c6e034ae107eaafcbe6acda099daab187f4eff21024619676
BLAKE2b-256 checksum
How to use checksums
c8765b1e857386e85414625c85424be7e1261859d0c5c94d676637e3fef4cf12
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.14

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 11, 2026.

Transparency log

Security for sqllocks-shape-domains 0.9.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

All 2 files in this release have been uploaded with provenance metadata.

Select from 2 files

Attestation for sqllocks_shape_domains-0.9.1.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 11, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.9.1 This release

2 release files Full provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page