Data Dictionary

ID
INVESTIGATION_ID
Type
text
Description

Can be used to link addresses and deficiency

ID
INVESTIGATION#
Type
text
Description

Investigation reference/file number

ID
INVESTIGATION_TYPE
Type
text
Description

Type of Investigation

ID
IN_DATE
Type
text
Description

Investigation start date- "In Date" (File creation date)

ID
NOTICE_OR_ORDER_DATE
Type
text
Description

Date Notice of Violation or Order issued

ID
NEXT_INSPECTION
Type
text
Description

Next scheduled inspection date

ID
EXPIRY_DATE
Type
text
Description

Date Notice or Order will expire (by which issues noted on Order must be resolved)

ID
ISSUE
Type
text
Description

Issue which prompted the investigation

ID
CURRENT_STATUS
Type
text
Description

Description of current status of the investigation

Additional Information

Field Value
Data last updated Agosto 27, 2026
Metadata last updated Setyembre 21, 2026
Created Agosto 27, 2026
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '05994276-0021-47e1-afa0-ca874733b98f', 'XML': 'bc884160-acce-41fb-bfa4-db7127bb3565', 'JSON': '8c0b4a9f-173b-4298-9b38-546be6f8af07'}
Datastore cache last update19 oras ang nakalipas
Extract jobAirflow: Integration Pipeline municipal-licensing-and-standards-investigation-activity
Has viewsTrue
Idfbaaf87a-558d-4437-95b3-7d8a6c6db7eb
Is previewTrue
Mimetypetext/csv
Package id5da2e2e8-659e-4850-ae43-47b7f7ad6b62
Position2
Record count139,865
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline municipal-licensing-and-standards-investigation-activity
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID