Synthetic dataset

Commercial Plumbing Camera Inspection & Estimate (Synthetic): Field Dictionary and 100-Row Sample

Sukhrobjon (Rob) Ismoilov
Sukhrobjon (Rob) Ismoilov
Founder & Principal, Main Street Wealth

One row per sewer-camera inspection, linking pipe material and age, the coded defect found and where, severity, the recommendation and whether the estimate was accepted. Every value is synthetic.

Last Updated November 16, 2026
3 min read
Share:
Quick facts
VerticalPlumbing
Fields14
Rows100, synthetic
LicenseCC BY 4.0

Dataset

Field dictionary and sample

100-row synthetic sample:CSVJSONCC BY 4.0 — cite “Main Street Wealth” with a link to this page.
FieldTypeMeaningWhat it replaces in real data
inspection_idstringInspection identifierInternal ID
job_idstringParent jobInternal ID
customer_tokenstringConsistent pseudonym for the property ownerReplaces name and contact detail
zip3stringThree-digit ZIPGeneralised from the address
property_typeenumProperty use—
pipe_materialenumMain line material—
pipe_age_bandenumEstimated installation era—
footage_inspected_ftintegerLength inspected—
defect_typeenumPrimary defectReplaces technician narration
defect_distance_ftintegerDistance from access point—
severityinteger1 (minor) to 5 (failure)—
recommendationenumRecommended remedy—
estimate_totalnumberEstimate amount (USD)Commercial
acceptedbooleanCustomer accepted the estimate—
Field dictionary.
inspection_idjob_idcustomer_tokenzip3property_typepipe_materialpipe_age_bandfootage_inspected_ftdefect_typedefect_distance_ftseverityrecommendationestimate_totalaccepted
I-300000J-400000cust_36da83606warehousecast iron1970s31root intrusion1293hydro-jet644.38true
I-300001J-400001cust_d6e661752multifamilycast ironpre-1950116none1no action0false
I-300002J-400002cust_368629972retailOrangeburgpre-1950179none1no action0false
I-300003J-400003cust_c3dd1a972warehousecast iron1960s185grease buildup1293spot repair5584.1true
I-300004J-400004cust_a5324b301warehouseclaypre-1950105crack1464spot repair5039.05true
I-300005J-400005cust_c68d42339officeOrangeburg1960s173none1no action0false
I-300006J-400006cust_a5d40c339officeclay1970s162offset joint362hydro-jet571.2true
I-300007J-400007cust_bb7229972multifamilyOrangeburgpre-195061crack1212hydro-jet948.3false
First 8 of 100 synthetic rows. Every row is generated from a seeded random-number generator. No row is derived from any real company’s records, and the value distributions are invented for illustration — they are not market statistics.

Section 2

How to use this schema

  1. Map each field to the column in your own export that feeds it.
  2. Apply the “what it replaces” column: tokens for people, three-digit ZIPs for addresses, coded values for free-text notes.
  3. Keep the identifiers that link records across systems — that chain is what buyers price.
  4. Run a sample of your mapped output through the PII scanner before anyone else sees it.

Frequently asked questions

Is this real data?
Every row is generated from a seeded random-number generator. No row is derived from any real company’s records, and the value distributions are invented for illustration — they are not market statistics.

Want a straight read on what your records are worth?

Send us the systems, years and rough record counts. We tell you what is licensable, get competing written quotes, and you pay nothing if buyers pass.

Request the evaluation form
Calendar

This article is provided for general educational purposes and is not legal, tax, investment, or accounting advice. Multiples, fee ranges, and timelines are illustrative ranges compiled from third-party sources current as of November 16, 2026 and will vary by transaction and market conditions. Consult qualified counsel before acting on any information contained here.