<div class="h8iICe">Hi, we're not building a site just yet, but we need to gather some information from sites to figure out if we want to build the site. &nbsp;<br /><br />Here's what we need:<br />1. Use a combination of offered information from API's and scraping of theses sites:  Stub Hub, Razorgator, ebay, and barrystickets.com.   Information gathered will be put in the SQL tables <span dir="ltr">that I've outlined below<br /><br />2. After you have the scrape and API manipulation working, we'll need to dump parts of the information into a spreadsheet for our manipulation.  Ideally I'd like to use a Google Docs spreadsheet for this, but a CSV would be ok.<br /></span><br /><br />***The Tables</strong>***</strong><br />The first two should be a one time capture from Stub Hub's API (would be nice if you were to build the script so that we can use it to update the DB from time to time though).  You might be able to use the CSV they put out, not sure what's easiest.  You can also use Stub Hub's ID numbers, no sense in creating our own, but do what's easiest.<br />1. City information</strong></div><div class="h8iICe"><ul><li>City name</li><li>ID#</li></ul></div><div class="h8iICe"><br />2. Venue information</strong><ul><li>Corresponding city ID#</li><li>Venue ID#</li><li>Venue name</li></ul><br /><span dir="ltr"><br /></span><span dir="ltr">3. Event information </strong>(can get this from SH api)<br /></strong></span><ul><li>Venue ID#</li><li>Event ID#</li><li>Name of event</li><li>Date of event</li><li>Date tickets went on sale<ul><li>For a show running more than one day, create new line in the table</li></ul></li><li>Number of seats required for the event to be sold out<ul><li>This will differ for different types of events, e.g. basketball games have more seats available than ice Hockey</li></ul></li><li>Number of tickets available</li><li>Highest/lowest ticket prices</li><li>Event Scarcity: ie, is this the only event of its kind (1 night performance by Billy Joel) or one of many (66th home game for mets)</li></ul><span dir="ltr"><br /><br />4. Information of individual tickets</strong> (will need to scrape SH for this)</span><ul><li>Event ID#</li><li>Has ticket been sold yet?</li></ul><ul><li>Date ticket listed</li><li>Date ticket sold</li><li>Face value of ticket<ul><li>Not sure yet where we'll be getting this data from as SH doesn't have it, might get it from Ticket master.</li></ul></li><li>Original price of ticket listed</li><li>Price ticket eventaully sold at</li><li>Type of seat<ul><li>General admission, luxury-box, bleacher</li></ul></li><li>Location of seat<ul><li>Section, row, seat number... NA for general admission</li></ul></li><li>Available seats remaining in venue when seat was sold (not sure if this should be in the DB...)</li></ul></div>