dave

26 Jan 2015

I scraped data about the top 100 chain restaurants by sales at each of the many locations throughout the US. Top 100 restaurants came from http://nrn.com/us-top-100/top-100-chains-us-sales. The data is loaded from Factual through Temboo. I tried to use Corpwatch first, but their API was having problems giving me queries, so I switched to something that would produce a massive amounts of data that I can have more choices working with. I learned to drop my ideas when APIs do not go my way.

tembooSketch

 

Sample Data:

{“accessible_wheelchair”:true,”address”:”1912 Pike Pl”,”alcohol”:false,”alcohol_bar”:false,”alcohol_beer_wine”:false,”alcohol_byob”:false,”attire”:”streetwear”,”category_ids”:[342],”category_labels”:[[“Social”,”Food and Dining”,”Cafes, Coffee and Tea Houses”]],”chain_id”:”ab4c54c0-d68a-012e-5619-003048cad9da”,”chain_name”:”Starbucks”,”country”:”us”,”cuisine”:[“Coffee”,”Tea”,”Cafe”,”American”,”Fast Food”],”email”:”info@starbucks.com”,”factual_id”:”df48ccb9-23cf-4a08-83ed-8d9b9176f6e3″,”hours”:{“monday”:[[“6:00″,”21:00″]],”tuesday”:[[“6:00″,”21:00″]],”wednesday”:[[“6:00″,”21:00″]],”thursday”:[[“6:00″,”21:00″]],”friday”:[[“6:00″,”21:00″]],”saturday”:[[“6:00″,”21:00″]],”sunday”:[[“6:00″,”21:00″]]},”hours_display”:”Open Daily 6:00 AM-9:00 PM”,”kids_goodfor”:true,”kids_menu”:true,”latitude”:47.609987,”locality”:”Seattle”,”longitude”:-122.342521,”meal_breakfast”:true,”meal_deliver”:true,”meal_dinner”:true,”meal_lunch”:true,”meal_takeout”:true,”name”:”Starbucks”,”neighborhood”:[“Downtown”,”Pine Market”,”Pike Place Market”],”open_24hrs”:false,”options_glutenfree”:true,”options_healthy”:true,”options_organic”:true,”options_vegetarian”:true,”parking”:true,”parking_street”:true,”payment_cashonly”:false,”postcode”:”98101″,”price”:1,”rating”:4,”region”:”WA”,”reservations”:false,”tel”:”(206) 448-8762″,”website”:”http://www.starbucks.com/”,”wifi”:true},{“accessible_wheelchair”:true,”address”:”177 Marshall St”,”alcohol”:false,”alcohol_bar”:false,”alcohol_beer_wine”:false,”alcohol_byob”:false,”attire”:”streetwear”,”category_ids”:[342],”category_labels”:[[“Social”,”Food and Dining”,”Cafes, Coffee and Tea Houses”]],”chain_id”:”ab4c54c0-d68a-012e-5619-003048cad9da”,”chain_name”:”Starbucks”,”country”:”us”,”cuisine”:[“Coffee”,”Tea”,”Cafe”,”American”,”cafe”],”email”:”ordersupport@starbuckscardb2b.com”,”factual_id”:”67dc42f3-9948-4fda-8e82-26fb5d74dd0e”,”hours”:{“monday”:[[“5:00″,”23:00″]],”tuesday”:[[“5:00″,”23:00″]],”wednesday”:[[“5:00″,”23:00″]],”thursday”:[[“5:00″,”23:00″]],”friday”:[[“5:00″,”23:00″]],”saturday”:[[“5:30″,”23:00″]],”sunday”:[[“6:00″,”22:00″]]},”hours_display”:”Mon-Fri 5:00 AM-11:00 PM; Sat 5:30 AM-11:00 PM; Sun 6:00 AM-10:00 PM”,”kids_goodfor”:true,”kids_menu”:true,”latitude”:43.041707,”locality”:”Syracuse”,”longitude”:-76.134737,”meal_breakfast”:true,”meal_cater”:true,”meal_deliver”:false,”meal_lunch”:true,”meal_takeout”:true,”name”:”Starbucks”,”neighborhood”:[“University Hill”],”open_24hrs”:false,”options_glutenfree”:true,”options_healthy”:true,”options_organic”:true,”options_vegetarian”:true,”parking”:true,”parking_street”:true,”payment_cashonly”:false,”postcode”:”13210″,”price”:1,”rating”:3.5,”region”:”NY”,”reservations”:false,”smoking”:false,”tel”:”(315) 474-2863″,”website”:”http://www.starbucks.com/”,”wifi”:true},{“accessible_wheelchair”:true,”address”:”867 Peachtree St NE”,”alcohol”:false,”alcohol_bar”:false,”alcohol_beer_wine”:false,”alcohol_byob”:false,”attire”:”streetwear”,”category_ids”:[342],”category_labels”:[[“Social”,”Food and Dining”,”Cafes, Coffee and Tea Houses”]],”chain_id”:”ab4c54c0-d68a-012e-5619-003048cad9da”,”chain_name”:”Starbucks”,”country”:”us”,”cuisine”:[“Coffee”,”Tea”,”Cafe”,”American”,”cafe”],”email”:”info@starbucks.com.gr”,”factual_id”:”5d7119ee-ea41-44dc-8263-18fe560b70eb”,”hours”:{“monday”:[[“5:00″,”23:30″]],”tuesday”:[[“5:00″,”23:30″]],”wednesday”:[[“5:00″,”23:30″]],”thursday”:[[“5:00″,”23:30″]],”friday”:[[“5:00″,”23:59″]],”saturday”:[[“5:30″,”23:59″]],”sunday”:[[“6:00″,”23:30″]]},”hours_display”:”Mon-Thu 5:00 AM-11:30 PM; Fri 5:00 AM-11:59 PM; Sat 5:30 AM-11:59 PM; Sun 6:00 AM-11:30 PM”,”kids_goodfor”:true,”kids_menu”:true,”latitude”:33.778356,”locality”:”Atlanta”,”longitude”:-84.384124,”meal_breakfast”:true,”meal_deliver”:false,”meal_lunch”:true,”meal_takeout”:true,”name”:”Starbucks”,”neighborhood”:[“Midtown”],”open_24hrs”:false,”options_glutenfree”:true,”options_healthy”:true,”options_organic”:true,”options_vegetarian”:true,”payment_cashonly”:false,”postcode”:”30308″,”price”:1,”rating”:2,”region”:”GA”,”reservations”:false,”tel”:”(404) 876-7466″,”website”:”http://www.starbucks.com/”,”wifi”:true}