Data Dictionary

ID
unique_id
Type
text
Description

Unique id for this record, used for internal technical purposes

ID
case_id
Type
text
Description

Unique id for this case

ID
case_type
Type
text
Description

Type of case

ID
address
Type
text
Description

Address related to the record

ID
geo_id
Type
text
Description

Unique identifier for the address

ID
investigation_type
Type
text
Description

Investigation category for record.

ID
investigation_date
Type
date
Description

Start date of investigation.

ID
last_updated_date
Type
date
Description

Date of most recent investigation update.

ID
info_code
Type
text
Description

Investigation Sub-Category code.

ID
hazard_type
Type
text
Description

Investigation Sub-Category.

ID
violation
Type
text
Description

Type of complaint under investigation.

ID
status_desc
Type
text
Description

Status if the investigation.

ID
file_extract_date
Type
date
Description

Date of file extract.

Additional Information

Field Value
Data last updated 20 May 2026
Metadata last updated 23 May 2026
Created 20 May 2026
Format JSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': 'e6989d5e-ccb7-469f-b7b2-9882503a79c9', 'XML': '0dcf6399-1a1e-4906-85de-5f347d6070ee', 'JSON': 'a8e2fe29-e657-41e3-ae8f-beae209971f2'}
Datastore cache last update3 hours ago
Extract jobAirflow: Integration Pipeline residential-health-hazards
Has viewsTrue
Id76c53509-3278-4869-9080-7536a8f4a18b
Is previewTrue
Package id3270d20e-ef2f-4ff6-90b8-a9fcffd2afd4
Position7
Record count582
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline residential-health-hazards
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID