Source-native

Published record fields

dli_licenses · 2

Record keyderived neutral
37d12d9f905de6f55e4997d71cf967771dc6594688e4fcb6a8fd0f2328be8fd2
Sourcederived neutral
mn_dli_license_snapshot
Publisher license numberraw
PC662571
Cleaned license identifiernormalized
PC662571
Nameraw
HEARTH & HOME TECHNOLOGIES LLC
Normalized namenormalized
HEARTH AND HOME TECHNOLOGIES
Doing business asraw
FIRESIDE HEARTH & HOME
Normalized doing business asnormalized
FIRESIDE HEARTH AND HOME
Business or personraw
Business
License typeraw
Plumbing
License subtyperaw
Plumbing Contractor
Statusraw
Issued
Normalized statusnormalized
issued
Addressderived neutral
600 2ND ST E
Cityraw
MUSCATINE
Stateraw
IA
Postal coderaw
52761
Publisher expiration valueraw
12/31/2027
License expiration datederived neutral
2027-12-31
Expiration parse statusderived neutral
parsed
Expiration presencederived neutral
present
Original dateraw
02/11/2013
Enforcement actionsource native judgment
0
Renewal in progressraw
Blank
Raw publisher rowraw
{"Addr1": "600 2ND ST E", "Addr2": "", "Bus_Pers": "Business", "City": "MUSCATINE ", "DBA_Name": "FIRESIDE HEARTH & HOME", "Email_Address": "", "Enforcement_Action": "0", "Exp_Date": "12/31/2027", "Lic_Number": "PC662571", "License_Subtype": "Plumbing Contractor", "License_Type": "Plumbing", "Name": "HEARTH & HOME TECHNOLOGIES LLC", "Orig_Date": "02/11/2013", "Phone_No": "9529856601", "Renewal_in_Progress": "", "St": "IA", "Status": "Issued", "Zip": "52761"}
DataFlow detail URLderived neutral
https://dataflow.sotagent.com/records/dli-licenses/37d12d9f905de6f55e4997d71cf967771dc6594688e4fcb6a8fd0f2328be8fd2
Open recordderived neutral
<a href="/records/dli-licenses/37d12d9f905de6f55e4997d71cf967771dc6594688e4fcb6a8fd0f2328be8fd2">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": "600 2ND ST E",
  "Addr2": "",
  "Bus_Pers": "Business",
  "City": "MUSCATINE ",
  "DBA_Name": "FIRESIDE HEARTH & HOME",
  "Email_Address": "",
  "Enforcement_Action": "0",
  "Exp_Date": "12/31/2027",
  "Lic_Number": "PC662571",
  "License_Subtype": "Plumbing Contractor",
  "License_Type": "Plumbing",
  "Name": "HEARTH & HOME TECHNOLOGIES LLC",
  "Orig_Date": "02/11/2013",
  "Phone_No": "9529856601",
  "Renewal_in_Progress": "",
  "St": "IA",
  "Status": "Issued",
  "Zip": "52761"
}