Minnesota Department of Labor and Industry Licenses · source-native record

Home Care Heating and Air LLC

Publisher facts, preserved source payload, and DataFlow relationship decisions remain separate. A retained historical record is never silently substituted for the current publication.

Publication state: active
Publication: a38924ca01b1da85ff11575710a41d602c39483f7f1c0dce85459d378ca5c386
Stable key: 816b901a784fa550b643833ee45a94066035cef734e0a6146219c1a8d326d9cc

Source-native

Published record fields

dli_licenses · 2

Record keyderived neutral: 816b901a784fa550b643833ee45a94066035cef734e0a6146219c1a8d326d9cc
Sourcederived neutral: mn_dli_license_snapshot
Publisher license numberraw: EA807680
Cleaned license identifiernormalized: EA807680
Nameraw: Home Care Heating and Air LLC
Normalized namenormalized: HOME CARE HEATING AND AIR
Doing business asraw: Home Care Heating and Air
Normalized doing business asnormalized: HOME CARE HEATING AND AIR
Business or personraw: Business
License typeraw: Electrical
License subtyperaw: Class A Electrical Contractor
Statusraw: Issued
Normalized statusnormalized: issued
Addressderived neutral: 14450 Ewing Ave S Suite 150
Cityraw: Burnsville
Stateraw: MN
Postal coderaw: 55306
Publisher expiration valueraw: 02/29/2028
License expiration datederived neutral: 2028-02-29
Expiration parse statusderived neutral: parsed
Expiration presencederived neutral: present
Original dateraw: 01/29/2026
Enforcement actionsource native judgment: 0
Renewal in progressraw: Blank
Raw publisher rowraw: {"Addr1": "14450 Ewing Ave S", "Addr2": "Suite 150", "Bus_Pers": "Business", "City": "Burnsville ", "DBA_Name": "Home Care Heating and Air", "Email_Address": "", "Enforcement_Action": "0", "Exp_Date": "02/29/2028", "Lic_Number": "EA807680", "License_Subtype": "Class A Electrical Contractor", "License_Type": "Electrical", "Name": "Home Care Heating and Air LLC", "Orig_Date": "01/29/2026", "Phone_No": "9523778774", "Renewal_in_Progress": "", "St": "MN", "Status": "Issued", "Zip": "55306"}
DataFlow detail URLderived neutral: https://dataflow.sotagent.com/records/dli-licenses/816b901a784fa550b643833ee45a94066035cef734e0a6146219c1a8d326d9cc
Open recordderived neutral: <a href="/records/dli-licenses/816b901a784fa550b643833ee45a94066035cef734e0a6146219c1a8d326d9cc">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": "14450 Ewing Ave S",
  "Addr2": "Suite 150",
  "Bus_Pers": "Business",
  "City": "Burnsville ",
  "DBA_Name": "Home Care Heating and Air",
  "Email_Address": "",
  "Enforcement_Action": "0",
  "Exp_Date": "02/29/2028",
  "Lic_Number": "EA807680",
  "License_Subtype": "Class A Electrical Contractor",
  "License_Type": "Electrical",
  "Name": "Home Care Heating and Air LLC",
  "Orig_Date": "01/29/2026",
  "Phone_No": "9523778774",
  "Renewal_in_Progress": "",
  "St": "MN",
  "Status": "Issued",
  "Zip": "55306"
}