Minnesota Department of Labor and Industry Licenses · source-native record
C A CORRIN PLUMBING AND HEATING LLC
Publisher facts, preserved source payload, and DataFlow relationship decisions remain separate. A retained historical record is never silently substituted for the current publication.
Source-native
Published record fields
dli_licenses · 2
- Record keyderived neutral
- a62a2a08030db378fb9f38e58851f001a3f808390fd9294f96086ab7e39fa0ba
- Sourcederived neutral
- mn_dli_license_snapshot
- Publisher license numberraw
- PC785356
- Cleaned license identifiernormalized
- PC785356
- Nameraw
- C A CORRIN PLUMBING AND HEATING LLC
- Normalized namenormalized
- C A CORRIN PLUMBING AND HEATING
- Doing business asraw
- Blank
- Normalized doing business asnormalized
- Not supplied
- Business or personraw
- Business
- License typeraw
- Plumbing
- License subtyperaw
- Plumbing Contractor
- Statusraw
- Issued
- Normalized statusnormalized
- issued
- Addressderived neutral
- PO BOX 896
- Cityraw
- INTL FALLS
- Stateraw
- MN
- Postal coderaw
- 56649
- Publisher expiration valueraw
- 12/31/2027
- License expiration datederived neutral
- 2027-12-31
- Expiration parse statusderived neutral
- parsed
- Expiration presencederived neutral
- present
- Original dateraw
- 08/24/2021
- Enforcement actionsource native judgment
- 0
- Renewal in progressraw
- Blank
- Raw publisher rowraw
- {"Addr1": "PO BOX 896", "Addr2": "", "Bus_Pers": "Business", "City": "INTL FALLS", "DBA_Name": "", "Email_Address": "", "Enforcement_Action": "0", "Exp_Date": "12/31/2027", "Lic_Number": "PC785356", "License_Subtype": "Plumbing Contractor", "License_Type": "Plumbing", "Name": "C A CORRIN PLUMBING AND HEATING LLC", "Orig_Date": "08/24/2021", "Phone_No": "2183410604", "Renewal_in_Progress": "", "St": "MN", "Status": "Issued", "Zip": "56649"}
- DataFlow detail URLderived neutral
- https://dataflow.sotagent.com/records/dli-licenses/a62a2a08030db378fb9f38e58851f001a3f808390fd9294f96086ab7e39fa0ba
- Open recordderived neutral
- <a href="/records/dli-licenses/a62a2a08030db378fb9f38e58851f001a3f808390fd9294f96086ab7e39fa0ba">Open record</a>
- Snapshot keyderived neutral
- Not supplied
Publication receipt
Scope and preservation
- Build key
cf78fc44c1be001bc3cef40d8d91200348f5a29ecda05e9fbf4f8cb5d910ed66- Activated
- 2026-07-15 08:11:38.796076+00:00
- History mode
- current state only
- Registry version
- 2
- Registry hash
bc13234d965a38f1f72da8d8f5d897ba71a0c9922f84a394f0ec601393842738- Source cutoffs
{"exact_artifact_binding": {"artifact_row_count": 256883, "artifact_slot": ".data/downloads/mn-dept-of-labor-industry/LIC_SNAP_07_09_2026.csv", "content_hash": "03779a2bcee9d4d9668eed39db70572ec64b6f6b3a14316d2116f94bc5a5cc37", "publisher_key_validation": {"basis": "exact decoded Lic_Number cells", "distinct_key_count": 256883, "missing_key_count": 0, "passed": true, "row_count": 256883}, "raw_cell_source": "exact decoded cells from hash-verified artifact", "size_bytes": 50901575, "source_relation_reconciliation": {"artifact_fields": {"cleaned_identifier": "cleaned_license_number", "exact_identifier": "publisher_license_number", "source_row_number": "source_row_number"}, "artifact_projection": "explorer_dli_exact_cells", "artifact_row_count": 256883, "identity_fields": {"cleaned_identifier": "license_number", "exact_identifier": "publisher_license_number", "source_row_number": "source_row_number"}, "identity_mismatch_count": 0, "passed": true, "source_relation": "public.dli_license_rows", "source_row_count": 256883}}, "max_imported_at": "2026-07-10T00:00:11.969862+00:00", "snapshot_hash": "03779a2bcee9d4d9668eed39db70572ec64b6f6b3a14316d2116f94bc5a5cc37", "source_keys": ["mn_dli_license_snapshot"]}- Scope note
- Current-state projection of the latest immutable publisher artifact.
- Scope note
- Every field labeled raw is decoded directly from the hash-verified artifact; cleaned and normalized annotations are labeled separately.
Preserved source payload
{
"Addr1": "PO BOX 896",
"Addr2": "",
"Bus_Pers": "Business",
"City": "INTL FALLS",
"DBA_Name": "",
"Email_Address": "",
"Enforcement_Action": "0",
"Exp_Date": "12/31/2027",
"Lic_Number": "PC785356",
"License_Subtype": "Plumbing Contractor",
"License_Type": "Plumbing",
"Name": "C A CORRIN PLUMBING AND HEATING LLC",
"Orig_Date": "08/24/2021",
"Phone_No": "2183410604",
"Renewal_in_Progress": "",
"St": "MN",
"Status": "Issued",
"Zip": "56649"
}