hth

Custom SQL query returning 101 rows (hide)

This data as json, CSV

idnamecitywebsiteaddresslatitudelongitude
2 The Middle East Downstairs Cambridge, MA http://www.mideastclub.com/ 472-480 Massachusetts Ave, Cambridge, MA 02139, USA 42.3637874 -71.10140109999999
3 Southpaw Brooklyn, NY http://www.spsounds.com/ 125 5th Ave, Brooklyn, NY 11217, USA 40.6787013 -73.9785821
4 Ralph's Diner Worcester, MA http://www.ralphsrockdiner.com/ 148 Grove St, Worcester, MA 01605, USA 42.27763520000001 -71.80088959999999
5 The Mercury Lounge New York, NY http://www.mercuryloungenyc.com 217 E Houston St, New York, NY 10002, USA 40.7221 -73.98679369999999
6 TT The Bear's Place Cambridge, MA http://www.ttthebears.com/ 10 Brookline St, Cambridge, MA 02139, USA 42.3634557 -71.1016531
7 The Auld Sod Dedham, MA http://www.theauldsodpub.com/ 274 Washington St, Dedham, MA 02026, USA 42.250437 -71.1703211
8 The Paradise Rock Club Boston, MA http://www.thedise.com/ 967 Commonwealth Avenue, Boston, MA 02215, USA 42.3520542 -71.1194668
9 Great Scott Allston, MA http://www.greatscottboston.com 1222 Commonwealth Avenue, Allston, MA 02134, USA 42.3500779 -71.13060159999999
10 Highline Ballroom New York, NY http://www.highlineballroom.com/ 431 W 16th St, New York, NY 10011, USA 40.7430346 -74.0058784
11 Cake Shop New York, NY http://cake-shop.com/ 152 Ludlow St, New York, NY 10002, USA 40.720832 -73.9878004
12 La Sala Rossa Montreal, QC http://casadelpopolo.com/salaconcert/home.shtml 4848 Boul St-Laurent, Montréal, QC H2T 1R5, Canada 45.5217929 -73.5904473
13 Lee's Palace Toronto, ON http://www.leespalace.com/ 529 BLOOR STREET W, Toronto, ON M5S 1Y5, Canada 43.6653396 -79.4094732
14 The Basement Northampton, MA http://www.iheg.com/basement_main.asp 21 Center St, Northampton, MA 01060, USA 42.3193577 -72.631837
15 Mayfair Cambridge, MA   Massachusetts Avenue & Brattle Street Cambridge, Cambridge, MA 02138, USA 42.3735695 -71.1189662
16 Loftasaurus Rex Brooklyn, NY   Bushwick, Brooklyn, NY, USA 40.69442819999999 -73.92128579999999
17 Cafe Bourbon Street Columbus, OH http://www.myspace.com/cafebourbonstreet 2216 Summit St, Columbus, OH 43201, USA 40.008639 -83.0002007
18 The Venue Lafayette, IN http://www.myspace.com/venuedowntown 210 N 6th St, Lafayette, IN 47901, USA 40.419559 -86.8907905
19 The Rudyard Kipling Louisville, KY http://www.therudyardkipling.com 422 W Oak St, Louisville, KY 40203, USA 38.23484250000001 -85.7615223
20 The Dame Lexington, KY http://www.dameky.com/ 168 W Main St, Lexington, KY 40507, USA 38.0470894 -84.4978441
21 Springwater Supper Club Nashville, TN http://www.springwatersupperclub.com 115 27th Ave N, Nashville, TN 37203, USA 36.14640379999999 -86.81228660000001
22 Grimey's Nashville, TN http://www.grimeys.com/ 1702 8th Ave S, Nashville, TN 37203, USA 36.136849 -86.7784212
23 Low Key Arts Building Hot Springs, AR http://www.valleyofthevapors.com/home.html 118 Arbor St, Hot Springs, AR 71901, USA 34.5205089 -93.0544432
24 Jackrabbit Lounge Shreveport, LA http://www.myspace.com/liljoes Shreveport, LA, USA 32.5251516 -93.7501789
25 The Alamo Drafthouse Austin, TX http://www.drafthouse.com/ 1120 S Lamar Blvd, Austin, TX 78704, USA 30.2560786 -97.7635091
26 Friends Bar Austin, TX http://www.friendsbar.com/ 208 E 6th St, Austin, TX 78701, USA 30.2677069 -97.7409983
27 The New Deli Fayetteville, AR   Fayetteville, AR, USA 36.0625795 -94.1574263
28 Crosstown Station Kansas City, MO http://www.crosstownstation.com 1522 McGee St, Kansas City, MO 64108, USA 39.0949704 -94.5801418
29 Vaudeville Mews Des Moines, IA http://www.vaudevillemews.com 212 4th St, Des Moines, IA 50309, USA 41.5855506 -93.6219768
30 The Maintenance Shop Ames, IA http://www.m-shop.com Memorial Union, 2229 Lincoln Way, Ames, IA 50011, USA 42.0235863 -93.6455794
31 Nomad World Pub Minneapolis, MN http://nomadpub.com 501 Cedar Ave, Minneapolis, MN 55454, USA 44.9687293 -93.2470043
32 The Annex Madison, WI http://www.intheannex.com 1212 Regent St, Madison, WI 53715, USA 43.0680606 -89.40621
33 The Abbey Pub Chicago, IL http://www.abbeypub.com/ 3420 W Grace St, Chicago, IL 60615, USA 41.95038100000001 -87.7136918
34 The Elbow Room Yspsilanti, MI http://www.ypsielbow.com 1276 N Huron River Dr, Ypsilanti, MI 48197, USA 42.2573099 -83.63311
35 The Beachland Tavern Cleveland, OH http://www.beachlandballroom.com/ 15711 Waterloo Rd, Cleveland, OH 44110, USA 41.5714111 -81.5704402
36 Garfield Art Works Pittsburgh, PA http://www.garfieldartworks.com/ 4931 Penn Ave, Pittsburgh, PA 15224, USA 40.4653277 -79.9440182
37 Sound Fix Brooklyn, NY http://www.soundfixrecords.com/ 44 Berry St, Brooklyn, NY 11211, USA 40.721095 -73.9565155
38 Union Hall Brooklyn, NY http://unionhallny.com/ 702 Union St, Brooklyn, NY 11215, USA 40.6760325 -73.9801012
39 The Milky Way Jamaica Plain, MA http://www.milkywayjp.com 284 Amory St, Jamaica Plain, MA 02130, USA 42.3144835 -71.10380789999999
40 The Middle East Upstairs Cambridge, MA http://www.mideastclub.com 472-480 Massachusetts Ave, Cambridge, MA 02139, USA 42.3637874 -71.10140109999999
41 Pearl Street Nightclub Northampton, MA http://www.iheg.com/pearl_street_main.asp 10 Pearl St, Northampton, MA 01060, USA 42.31889 -72.62746
42 Arlene's Grocery New York, NY http://www.arlenesgrocery.net/main.html 95 Stanton St, New York, NY 10002, USA 40.721282 -73.988371
43 Cafe Nine New Haven, CT http://www.cafenine.com/ 250 State St, New Haven, CT 06510, USA 41.3036408 -72.92383459999999
44 Galaxy Hut Arlington, VA http://www.galaxyhut.com/ 2711 Wilson Blvd, Arlington, VA 22201, USA 38.8896372 -77.09103929999999
45 3rd Floor Studio Fredericksburg, VA   3rd St, Fredericksburg, VA 22408, USA 38.27807059999999 -77.4408215
47 The Reservoir Carrboro, NC http://reservoirbar.net/ 100 Brewer Ln, Carrboro, NC 27510, USA 35.90954110000001 -79.06589129999999
48 The Caledonia Lounge Athens, GA http://www.caledonialounge.com/ 256 W Clayton St, Athens, GA 30601, USA 33.9578326 -83.3796503
49 The World Grotto Knoxville, TN http://www.worldgrotto.com/ 16 Market Square, Knoxville, TN 37902, USA 35.9651723 -83.9196948
50 P.A.'s Lounge Somerville, MA http://www.paslounge.com/ 345 Somerville Ave, Somerville, MA 02143, USA 42.3808351 -71.09820739999999
51 O'Brien's Pub Allston, MA http://www.obrienspubboston.com/ 3 Harvard Ave, Allston, MA 02134, USA 42.3552596 -71.1328683
52 Piano's New York, NY http://www.pianosnyc.com/ 158 Ludlow St, New York, NY 10002, USA 40.721025 -73.987692
53 ArtBeat Somerville, MA http://www.somervilleartscouncil.org/programs/artbeat/ Davis Square, Somerville, MA, USA 42.3967172 -71.1223151
54 Eagles Nest Northampton, MA http://www.myspace.com/eaglesnestling 270 Pleasant St, Northampton, MA 01060, USA 42.316896 -72.625846
55 Valentine's Albany, NY http://www.valentinesalbany.com/ 17 New Scotland Ave, Albany, NY 12208, USA 42.6542206 -73.7729964
56 Bloomfield Bridge Tavern Pittsburgh, PA http://www.myspace.com/polishpartyhouse 4412 Liberty Ave, Pittsburgh, PA 15224, USA 40.4632647 -79.952581
57 Parish Hall Cleveland, OH http://parishhall.wordpress.com/ 6205 Detroit Ave, Cleveland, OH 44102, USA 41.48415 -81.72858599999999
58 South Union Arts Chicago, IL http://www.southunionarts.com/ 1352 S Union Ave, Chicago, IL 60607, USA 41.863892 -87.64529890000001
59 The Triple Rock Social Club Minneapolis, MN http://www.triplerocksocialclub.com/ 629 Cedar Ave, Minneapolis, MN 55454, USA 44.96676699999999 -93.2469655
60 Points East Pub Milwaukee, WI http://www.pointseastpub.com/ 1501 N Jackson St, Milwaukee, WI 53202, USA 43.04951700000001 -87.9048972
61 The Note Chicago, IL http://www.thenotechicago.com/ 1565 N Milwaukee Ave, Chicago, IL 60622, USA 41.9099569 -87.6766961
62 Otto's Dekalb, IL http://www.ottosdekalb.com/ 118 E Lincoln Hwy, DeKalb, IL 60115, USA 41.930384 -88.7537712
63 Canal Street Tavern Dayton, OH http://www.canalstreettavern.com/ 308 E 1st St, Dayton, OH 45402, USA 39.76302039999999 -84.1866634
64 Castle Gayskull Chapel Hill, NC   Chapel Hill, NC, USA 35.91319960000001 -79.0558445
65 Current Gallery Baltimore, MD http://www.currentspace.com/ 421 N Howard St, Baltimore, MD 21201, USA 39.29475219999999 -76.61952
66 The Khyber Philadelphia, PA http://www.thekhyber.com/ 56 S 2nd St, Philadelphia, PA 19106, USA 39.9486287 -75.1441153
67 The Annex New York, NY http://www.theannexnyc.com/ 248 Roebling St, Brooklyn, NY 11211, USA 40.711226 -73.959969
68 The Coolidge Corner Theater Brookline, MA http://www.coolidge.org/ 290 Harvard St, Brookline, MA 02446, USA 42.342582 -71.12242549999999
69 Brandeis University Waltham, MA http://www.brandeis.edu/ 415 South St, Waltham, MA 02453, USA 42.3662392 -71.25854799999999
70 WMBR 88.1 FM Pipeline Cambridge, MA http://www.oscillations.org/pipeline/ 3 Ames St, Cambridge, MA 02142, USA 42.3603308 -71.0880604
71 Charlie's Kitchen Cambridge, MA   10 Eliot St, Cambridge, MA 02138, USA 42.3724215 -71.1215319
72 Midway Cafe Jamaica Plain, MA http://www.midwaycafe.com 3496 Washington St, Boston, MA 02130, USA 42.30622639999999 -71.10748629999999
73 The Abbey Lounge Somerville, MA http://www.abbeylounge.com 3 Beacon St, Somerville, MA 02143, USA 42.374514 -71.10145399999999
74 Bill's Bar Boston, MA http://www.billsbar.com 5 Lansdowne St, Boston, MA 02215, USA 42.3474133 -71.0949684
75 Lizard Lounge Cambridge, MA http://www.lizardloungeclub.com 1667 Massachusetts Ave, Cambridge, MA 02138, USA 42.38211250000001 -71.11942479999999
76 Sin-E New York, NY http://www.sin-e.com 148 Attorney St, New York, NY 10002, USA 40.7202259 -73.9834096
77 Brattle Theater Cambridge, MA   40 Brattle St, Cambridge, MA 02138, USA 42.3735927 -71.1213969
78 Plough & Stars Cambridge, MA http://www.ploughandstars.com/ 912 Massachusetts Ave, Cambridge, MA 02139, USA 42.3682265 -71.1088287
79 The Space Hamden, CT http://www.thespace.tk/ 295 Treadwell St, Hamden, CT 06514, USA 41.3539092 -72.92535219999999
80 Cousin Larry's Danbury, CT http://www.myspace.com/larrysdanbury 1 Elm St, Danbury, CT 06810, USA 41.3962315 -73.4544349
81 Bruar Falls Brooklyn, NY http://www.bruarfalls.com/ 245 Grand St, Brooklyn, NY 11211, USA 40.713682 -73.95871199999999
82 River Gods Cambridge, MA http://www.rivergodsonline.com/ 125 River St, Cambridge, MA 02139, USA 42.36404789999999 -71.10870229999999
84 Ursinus College Collegeville, PA http://www.ursinus.edu 601 E Main St, Collegeville, PA 19426, USA 40.194207 -75.458023
85 The Red And The Black Washington, DC http://www.redandblackbar.com 1212 H St NE, Washington, DC 20002, USA 38.9003936 -76.9897307
86 Tea Bazaar Charlottesville, VA http://www.teabazaar.com 414 E Main St, Charlottesville, VA 22902, USA 38.02983439999999 -78.4789021
87 Local 506 Chapel Hill, NC http://www.local506.com 506 W Franklin St, Chapel Hill, NC 27516, USA 35.9102512 -79.0638479
88 The Milestone Charlotte, NC http://themilestoneclub.com 3400 Tuckaseegee Rd, Charlotte, NC 28208, USA 35.24465499999999 -80.8834512
89 Caledonia Lounge Athens, GA http://www.caledonialounge.com 256 W Clayton St, Athens, GA 30601, USA 33.9578326 -83.3796503
90 The Mink Houston, TX http://www.minkonmain.com/backroom/ 3718 Main St, Houston, TX 77002, USA 29.7381982 -95.37990769999999
91 The Mohawk Austin, TX http://www.mohawkaustin.com 912 Red River St, Austin, TX 78701, USA 30.270148 -97.7360346
92 Trees Dallas, TX http://treesdallas.com 2709 Elm St, Dallas, TX 75226, USA 32.7846208 -96.7843848
93 The Bootleg Los Angeles, CA http://www.foldsilverlake.com/ 2220 Beverly Blvd, Los Angeles, CA 90057, USA 34.0672117 -118.2723023
94 The Blank Club San Jose, CA http://www.theblankclub.com/ 44 S Almaden Ave, San Jose, CA 95113, USA 37.3339314 -121.8932037
95 Hemlock Tavern San Francisco, CA http://www.hemlocktavern.com 1131 Polk St, San Francisco, CA 94109, USA 37.7873773 -122.4203093
96 Luigi's Slice Sacramento, CA http://www.myspace.com/luigisslice 1050 20th St #150, Sacramento, CA 95814, USA 38.5761714 -121.4804028
97 Stillwater Ashland, OR http://www.stillwaterashland.com/ 1951 Ashland St, Ashland, OR 97520, USA 42.1856233 -122.6799031
98 Berbati's Pan Portland, OR http://www.berbati.com/ 10 SW 3rd Ave, Portland, OR 97204, USA 45.5226507 -122.6730555
99 Sunset Tavern Seattle, WA http://www.sunsettavern.com 5433 Ballard Ave NW, Seattle, WA 98107, USA 47.6681134 -122.3859886
100 Muse Music Provo, UT http://www.musemusiconline.com 247 Center St, Provo, UT 84601, USA 40.233291 -111.663053
101 Hi-Dive Denver, CO http://www.hi-dive.com 7 S Broadway, Denver, CO 80223, USA 39.71633800000001 -104.9878562
102 Replay Lounge Lawrence, KS http://www.myspace.com/replaylounge 946 Massachusetts St, Lawrence, KS 66044, USA 38.965828 -95.23552699999999
103 The Mill Iowa City, IA http://www.icmill.com 120 E Burlington St, Iowa City, IA 52240, USA 41.6582275 -91.53380589999999
104 501 Club Minneapolis, MN http://www.501.mn/ 501 S Washington Ave, Minneapolis, MN 55415, USA 44.9785589 -93.26100249999999