CSV/Parquet Data Structure for ADX
Data can be provided as NDJSON, CSV or Parquet. This document describes the CSV/Parquet data structure.
Last updated
Was this helpful?
Data can be provided as NDJSON, CSV or Parquet. This document describes the CSV/Parquet data structure.
Last updated
Was this helpful?
© 2024 PredictHQ Ltd
| Field | Description |
|---|
| The unique identifier of the event. |
| The date and time the event was first seen by PredictHQ in your Snowflake session timezone. Also called |
| The date and time the event was last updated in your Snowflake session timezone. |
| The title of the event. |
| The category of the event. |
|
| The description of the event. |
| The date and time that the event starts in your Snowflake session timezone. If timezone is not considered relevant (e.g., Independence Day) then this is recorded in UTC and is the same relative time in all timezones and the Additionally, if an event has a start time of midnight (in the event time zone) this is an indication that the actual time may be unknown. You may wish to omit the time when displaying these events. |
| The date and time that the event ends in your Snowflake session timezone. If timezone is not considered relevant (e.g., Independence Day) then this is recorded in UTC and is the same relative time in all timezones and the |
| The date and time that PredictHQ predicts that the event will end, in the timezone of the event. |
| The time zone of the event in TZ Database format. This is helpful so you know which time zone to convert the dates to (if needed). If the time zone is |
|
| The geographic details (location) of the event. |
| The geographical scope the events apply to. Possible values are:
|
|
| The country code in ISO 3166-1 alpha-2 format. Note that the country value will usually be present but in some cases where the event location is not within a country (e.g., an earthquake in the middle of the ocean) it can be empty. |
| An array of place hierarchies for the event. Each hierarchy is an array of place ids. The final place in a hierarchy is a specific place the event applies to. Each place is a sub-place of the place immediately preceding it in the hierarchy. An empty array is possible and valid. |
| A numerical value that reflects the predicted attendance number for supported attendance-based categories. The following categories are supported: concerts, performing arts, sports, expos, conferences, community, and festivals.
|
| A log scale numerical value between 0 and 100 with a five-level hierarchical impact schema. It is designed to represent the potential impact of an event independent of its geographical location. |
| Similar to PHQ Rank, this is a log scale numerical value between 0 and 100 with a five-level hierarchical impact schema. It is designed to represent the potential impact of an event on its local geographical area. Local Rank is calculated for events in the categories community, concerts, conferences, expos, sports, festivals, performing-arts. If local_rank is not intended to be available for an event, this field will be |
| A log scale numerical value between 0 and 100 with a five-level hierarchical impact schema. Aviation Rank indicates how much an event will impact flight bookings by considering both domestic and international travel. It can be mapped to the predicted increase in demand based on people flying to an event. Therefore, events with higher Aviation Rank are expected to result in more people taking flights than lower Aviation Rank events. Aviation Rank is calculated for events in the categories concerts, conferences, expos, sports, festivals, performing-arts, observances, public-holidays, and school-holidays. If aviation_rank is not intended to be available for an event or we couldn't calculate it, this field will be null. |
| The publication state of the event. Possible values:
|
| Whether or not this event is considered brand-safe. Examples of brand-unsafe events include content that promotes hate, violence, or discrimination, coarse language, content that is sexually suggestive or explicit, etc. |
|
| The date and time the event was set to cancelled presented in your Snowflake session timezone. This field will be |
| The date and time the event was set to postponed presented in your Snowflake session timezone. This field will be |
| Also known as “Demand impact patterns”. This field shows impact for leading days (days before the event), lagging days (days after an event) and the days the event occurs. It contains details such as the industry vertical the impact pattern applies to, the type of impact shown in the impact pattern, and an array of objects for each day showing the date in the local timezone of the event and the value of the impact_type for that given day. |
| The total predicted event spend for the accommodation industry. This field will be |
| The total predicted event spend for the hospitality industry. This field will be |
| The total predicted event spend for the transportation industry. This field will be |
| The PHQ Labels associated with the event. This field will be |
| All alternate IDs for the event. Any event IDs that may have been used for this event in the past will be included here. It does not include the current event ID. |
| The date and time this row was inserted in your local Snowflake session timezone. The row may have been deleted and inserted multiple times so it does not reflect when a broadcast is first seen, use |
| The date and time this row was last updated in your local Snowflake session timezone. |
The labels associated with the event. Use the to fetch a list of available labels.
An array of entities linked to the event. This is a complex data type, please see for details.
The Placekey identifier for the physical address where the event takes place. See . This field will be null if the What part or the Where part of the Placekey for the event address couldn't be retrieved.
See also the .
For details see our .
See also our .
See also our .
See also our .
Used to indicate if this event is part of a larger event. These types of events are called umbrella events in the system. For example, a large multi-day parent umbrella event may have individual child events for sessions on different days. This field only shows if a child event has a parent id. It does not indicate if a parent event has child events. For details see our .