Data Dictionary

Column Type Label Description
Ticket Id text

Unique identifier for a ticket in the city's internal system

Ticket Name text

Working, plain-English name given to the ticket. These are not unique IDs and can change at the discretion of the Open Data team

Inquiry Source text

Where the request/inquiry originated (Public, Private Business, Academia, City Division, City Council, etc)

Division text

Which city division this request is associated with.

Public Description text

A short description of the dataset.

Request Type text

Open Data Inquiry is where most intake starts; it's where Open Data staff investigate the existance of a requested dataset and feasibility of publishing it. From there, it can become a Publish New Open Dataset Page, which is the process of connecting to city systems containing data to be published, and reviewing the content and context on an open dataset page before it's published. Update Existing Open Dataset Page tickets are the process of making and validating changes to the schema, source system or metadata of an existing page. Some of these values are 'Unknown' because these statuses were introduced after these tickets were made.

Created timestamp

The ticket's original creation time

First Response timestamp

When open data team first replied to this ticket

From Status text

Ticket's status before its current status, if any

To Status text

Ticket's current status

Status Timestamp text

When the ticket changed to this record's status

Linked Ticket Id text

Tickets are often linked to other tickets. When an Open Data Inquiry ticket is completed, it can become a 'Publish New Open Dataset Page' ticket or an 'Update Existing Open Dataset Page' ticket

Additional Information

Field Value
Data last updated May 17, 2024
Metadata last updated May 10, 2025
Created May 17, 2024
Format CSV
License License not specified
Datastore activeTrue
Datastore cache{'CSV': '756e9577-2c38-4d50-aee2-1a6e7ecb024a', 'XML': '98fe422b-9f2c-465f-aaac-5145977b26e9', 'JSON': '12ccabb5-eb4f-4952-92f3-270071c4ece6'}
Datastore cache last update4 hours ago
Extract jobAirflow: open-data-intake
Has viewsTrue
Id1b1cd078-df59-449b-801b-da478c4c8ffb
Is previewTrue
Package idopen-data-intake
Package name or idopen-data-intake
Position0
Stateactive
Url typedatastore
Extract Job Airflow: open-data-intake
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID