Data Dictionary

ID
Ticket Id
Type
text
Aprašymas

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

ID
Ticket Name
Type
text
Aprašymas

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

ID
Inquiry Source
Type
text
Aprašymas

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

ID
Division
Type
text
Aprašymas

Which city division this request is associated with.

ID
Public Description
Type
text
Aprašymas

A short description of the dataset.

ID
Request Type
Type
text
Aprašymas

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.

ID
Created
Type
timestamp
Aprašymas

The ticket's original creation time

ID
First Response
Type
timestamp
Aprašymas

When open data team first replied to this ticket

ID
Ticket Resolved?
Type
text
Aprašymas

Whether the ticket is considered 'finished' by the Open Data team

ID
From Status
Type
text
Aprašymas

Ticket's status before its current status, if any

ID
To Status
Type
text
Aprašymas

Ticket's current status

ID
Status Timestamp
Type
text
Aprašymas

When the ticket changed to this record's status

ID
Linked Ticket Id
Type
text
Aprašymas

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

Papildoma informacija

Laukas Reikšmė
Data last updated 2025 m. birželio 30 d.
Metadata last updated 2026 m. birželio 30 d.
Sukurtas 2025 m. birželio 30 d.
Formatas CSV
Licencija License not specified
Datastore activeTrue
Datastore cache{'CSV': 'cd11c4fa-090c-44ac-baf7-9977d4e5d3c7', 'XML': '8a6ea60c-e477-4a41-b657-b1e91a637209', 'JSON': '15ba531c-8028-44de-b9e5-b6576b7fbdf9'}
Datastore cache last updateprieš 1 dieną
Extract jobAirflow: open-data-intake
Has viewsTrue
Id669a3ff2-af72-4eb7-a82c-b8ec3a28e2e4
Is previewTrue
Package id5c260b48-821d-4a64-98f3-fa042e9cfeec
Position0
Record count2 307
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