/
api.Stubhubactive

api.Stubhubactive

Owned by Logan Bird (Unlicensed)
Last updated: Jul 15, 2019

Information

  • Type: MS SQL Table.

  • Schema: api.

  • Data Origin: Stubhub api after being parsed by in house systems

  • Refresh Schedule: Constantly

  • Script File Locations 

    • Script 1: F:\TB-Applications\Tableau\File.py

    • Script 2: F:\TB-Applications\Tableau\File.R

Data Dictionary

Column NameData TypeDescription

stubhubactiveid

bigintPrimary key.
eventid

int

key that connects with EIBoxOffice eventid
sectionvarchar(100)Section of seating
pricemoney Cost of tickets
row varchar(30) row of seating 
quantity int Amount of tickets in package. (Ticket price is individual. To get the price of a group of tickets multiply quantity by price) 
delivery varchar(30) delivery method for the tickets. Represented here as a number that links to (((INSERT DATABASE)))
 listdatedatetime Date and time that the item was listed on Stubhub. (((AMBIGUOUS))) 
sectionid int ID Associated with the seating section
 zoneidint ID Associated with the seating zone
listingid int ID associated with the listing displayed on Stubhub.com
lastdatetime datetime The last time the listing was altered. 

Schema Diagram

  • Only include if data source is not a single raw data source

Related content