foursquare_checkins.json

[{"id":1,"user_id":1,"foursquare_id":"5313fb49498eaddbc72fbc28","shout":"with Juan C.","latitude":"33.6248941821904","longitude":"-84.45117885518563","venue_name":"Sheraton Gateway Hotel Atlanta Airport","address":"1900 Sullivan Rd","city":"Atlanta","state":"GA","venue_type":"Hotel"},{"id":2,"user_id":1,"foursquare_id":"531369a5498e762e980ae869","shout":"with Juan C.","latitude":"37.25608836765668","longitude":"-77.39258870743865","venue_name":"Applebee's","address":"449 S. Park Cir.","city":"Colonial Heights","state":"VA","venue_type":"American"},{"id":3,"user_id":1,"foursquare_id":"5313021e11d230e8fdd6f96a","shout":null,"latitude":"40.739943978226975","longitude":"-73.99397873738853","venue_name":"Spotify","address":"45 W 18th St","city":"New York","state":"NY","venue_type":"Tech Startup"},{"id":4,"user_id":1,"foursquare_id":"5312f645498ec97349c6c20c","shout":null,"latitude":"40.738676864716815","longitude":"-73.9958151502776","venue_name":"Hollywood Diner","address":"574 6th Ave. (Avenue of the Americas)","city":"New York","state":"NY","venue_type":"Diner"},{"id":5,"user_id":1,"foursquare_id":"523a64f611d2c47a23b53aae","shout":null,"latitude":"40.233827907244965","longitude":"-111.65874503818452","venue_name":"Gloria's Little Italy","address":"1 E Center St","city":"Provo","state":"UT","venue_type":"Italian"},{"id":6,"user_id":1,"foursquare_id":"5239f2fd11d2d8b7094bbf91","shout":null,"latitude":"40.376571","longitude":"-111.814388","venue_name":"Cafe Zupas","address":"599 W Main St","city":"American Fork","state":"UT","venue_type":"Soup"},{"id":7,"user_id":1,"foursquare_id":"51b405a7498e0b23b82d458c","shout":"Stagmerotten","latitude":"41.12927186684107","longitude":"-73.2440310716629","venue_name":"Seagrape Cafe","address":"1144 Reef Rd","city":"Fairfield","state":"CT","venue_type":"Bar"},{"id":8,"user_id":1,"foursquare_id":"519841f7498ee2ba6f9a1e0f","shout":null,"latitude":"40.1939942968661","longitude":"-74.01341512680237","venue_name":"Norwood inn","address":"618 2nd Ave","city":"Avon-by-the-Sea","state":"NJ","venue_type":"Hotel Bar"},{"id":9,"user_id":1,"foursquare_id":"51792456e4b037f7ff50542f","shout":null,"latitude":"39.58951793357715","longitude":"-104.8806381225586","venue_name":"Sheraton Denver Tech Center Hotel","address":"7007 S Clinton St","city":"Greenwood Village","state":"CO","venue_type":"Hotel"},{"id":10,"user_id":1,"foursquare_id":"517842b0e4b09dfb141f8a15","shout":null,"latitude":"40.773839","longitude":"-73.87122","venue_name":"LaGuardia Airport (LGA)","address":"Grand Central Pkwy","city":"East Elmhurst","state":"NY","venue_type":"Airport"},{"id":11,"user_id":1,"foursquare_id":"51586021e4b038a19ea81ca5","shout":null,"latitude":"39.362107916741714","longitude":"-74.41514253616333","venue_name":"Revel","address":"500 Boardwalk","city":"Atlantic City","state":"NJ","venue_type":"Casino"},{"id":12,"user_id":1,"foursquare_id":"51203630e4b048431e8dec24","shout":"Kwame and uptown shakedown","latitude":"40.72133109977113","longitude":"-73.98825705073803","venue_name":"Arlene's Grocery","address":"95 Stanton St.","city":"New York","state":"NY","venue_type":"Rock Club"},{"id":13,"user_id":1,"foursquare_id":"50b02d50e4b0d4508b6692d5","shout":"Log cabbining","latitude":"41.60952007734866","longitude":"-75.06163488227844","venue_name":"Narrowsburg, NY","address":null,"city":null,"state":null,"venue_type":"City"},{"id":14,"user_id":1,"foursquare_id":"4ff904cbe4b0f1abbc6bb41e","shout":null,"latitude":"40.756773","longitude":"-73.967124","venue_name":"Vero Midtown","address":"1004 2nd Ave","city":"New York","state":"NY","venue_type":"Wine Bar"},{"id":15,"user_id":1,"foursquare_id":"4fe69224e4b05b60fa52fb9c","shout":null,"latitude":"41.65045","longitude":"-70.274226","venue_name":"Trader Ed's At Hyannis Marina","address":"21 Arlington St","city":"West Yarmouth","state":"MA","venue_type":"Seafood"},{"id":16,"user_id":1,"foursquare_id":"4fe3b6b1e4b08820e9e8d9f8","shout":null,"latitude":"41.67979848197182","longitude":"-69.95708972322858","venue_name":"Chatham Squire Restaurant","address":"487 Main St","city":"Chatham","state":"MA","venue_type":"Bar"},{"id":17,"user_id":1,"foursquare_id":"4fd418d8e4b0a8f571640c00","shout":null,"latitude":"40.76798373928008","longitude":"-73.92051360047962","venue_name":"Don Coquí Astoria","address":"2818 31st St","city":"Astoria","state":"NY","venue_type":"Latin American"},{"id":18,"user_id":1,"foursquare_id":"4fc89c8ce4b053dd73690086","shout":null,"latitude":"40.750523319062694","longitude":"-73.93994017936863","venue_name":"Queens Plaza South","address":"Queens Plaza S","city":"Long Island City","state":"NY","venue_type":"Government"},{"id":19,"user_id":1,"foursquare_id":"4fc16063e4b0a06f8e87679a","shout":null,"latitude":"40.193102153052074","longitude":"-74.00949597358704","venue_name":"The Columns","address":"601 ocean avenue","city":"Bradley Beach","state":"NJ","venue_type":"Bar"},{"id":20,"user_id":1,"foursquare_id":"4fbecb29e4b0425aaabab58e","shout":null,"latitude":"40.756457364677075","longitude":"-73.8460636138916","venue_name":"Citi Field","address":"12301 Roosevelt Ave","city":"Flushing","state":"NY","venue_type":"Baseball"}]

us_states.json