ClumsyMonkey.net

Crab Man, why do you need all of this info?

you're a hunter he's a gatherer

Axtech wrote:Queen's University, Kingston, ON, Canada
not sure exactly what you're looking for here, since this is a university, not a venue... If someone played there on a campus tour, it would have just been in a parking lot. There are a couple of venues on/around campus, though. If you want more info just let me know.

Don't worry about colleges for now... ideally I would want to list the actual venue at the college where OLP played but it may be difficult to find those details.

I basically just copied and pasted all of the rows from the venue table in the database, and some stuff in there doesn't make sense at all in terms of venues.

I need MS Office back
I'm trying to import these simple comma delimited fields in Open Office but it's not working.

SUNY Albany RACC Facility,
1400 Washington Avenue •
Albany, NY 12222 • USA
Phone: (518) 442-2562

WQBK, Q103
1241 Kings Rd, Schenectady, NY, 12303 

Office Phone: 518-881-1515 

Studio Line: 518-476-1039
USA
Baird Point - University at Buffalo
St Rita’s Lane
Amherst, New York 14260
United States Baird Point,
USA

Broome County Veterans Memorial Arena,
1 Stuart Street
Binghamton, NY
13901

Phone: 607.778.1528

Events Center Binghamton University
SUNY
Vestal Parkway East
Vestal New York
PO Box 6000 Binghamton,
NY, 13902
USA

Northsix,
66 north 6th street
Brooklyn, NY,
11211 USA

Warsaw,
261 Driggs Ave Greenpoint/Williamsburg Brooklyn, NY 11222
718 387-0505
USA

Alumni Arena, University at Buffalo,
Division of Athletics
102 Alumni Arena
Buffalo, NY 14260
716-645-3141
USA

Buffalo State Sports Center,
Buffalo State College
Buffalo, NY 14222
USA

Edge Conference Studio, Buffalo, NY, USA

Edge Sessions, Buffalo, NY, USA

Burt Flickinger Center,
Erie Community College,
21 Oak Street, Buffalo, NY 14203.
USA

La Salle Park
1 Porter Ave
Buffalo, NY
USA

The Pier,
325 Fuhrman Blvd.
Buffalo, NY 14203
716-332-6913
USA

Shea's Buffalo Theatre
646 Main Street
Buffalo, New York 14202
USA

Showplace Theater,
1063 Grant St
Buffalo, NY 14207
(716) 447-1271
USA

The Tralf Music Hall
622 Main St
Buffalo, NY 14202
(716) 852-2860
USA

Northern Lights,
1208 Route 146
Clifton Park, NY 12065
(518) 371-0012 USA

Darien Lake Performing Arts Center,
9993 Alleghany Rd, Darien Center, NY 14040
Darien, NY, USA

SUNY/Geneseo,
Geneseo, NY, USA

Continental, Manhattan,
25 3rd Avenue
New York, NY 10003
(212) 529-6924
NY, USA

Academy, New York, NY, USA

Bowery Ballroom,
6 Delancey St
New York, NY 10002
(212) 533-2111 USA


Bryant Park, midtown Manhattan, between 40th and 42nd Streets & Fifth and Sixth Avenues.New York, NY, USA

CBGB'
315 Bowery, New York, NY 10012 
at Bleecker St. 
212-982-4052 USA

Club Babyhead, New York, NY, USA you sure this isn’t the one in Providence RI?

Elbow Room,
144 Bleecker St,
New York, NY 10012
USA

Fez Under Time Cafe,
2330 BROADWAY @ 85TH STREET
NEW YORK, NY 10024
Call 212.579.5100
Although depending on when they played it could have been
380 LAFAYETTE STREET @ GREAT JONES
New York, NY, USA

Hammerstein Ballroom,
311 W 34th St
New York, NY 10001
(212) 279-7740 New York, NY, USA

The Fillmore New York Irving Plaza,
17 Irving Pl
New York, NY 10003
(212) 777-1224
New York, NY, USA

Joe's Pub,
425 Lafayette St
New York, NY 10003
(212) 539-877
USA

K-Rock,
There is also Krock 2 which is associated with the fillmore New York, NY, USA

Late Night with Conan O'Brien, New York, NY, USA
Late Show with David Letterman, New York, NY, USA

Madison Square Garden,
Madison Square Garden
4 Pennsylvania Plaza
New York, New York 10001 USA

Mercury Lounge,
217 E Houston St
New York, NY 10002
(212) 260-4700 USA

MSN 8 Dome, Wollman Rink, Central Park, New York, NY, USA

MTV,
770 Broadway
New York, NY 10003
(212) 654-9000
USA

Ok heres all of Ohio in a comma delimted file:
http://www.wright-onthe-web.com/olp/OLP-Ohio.csv

Do you want to add a 'Status' field?
There are alot of renamed or closed venues.

Wow, that is going to be a bitch of a project.

I just went and checked the few towns where I know the venues and three of them had changed their names.

Asbury Park Convention Hall
1300 Ocean Ave
Asbury Park, NJ 07712

The Saint
601 Main Street
Asbury Park, NJ 07712

Stone Pony
913 Ocean Ave
Asbury Park, NJ 07712

Borgata Hotel & Casino
One Borgata Way
Atlantic City, NJ 08401

Trump Marina Grand Cayman Ballroom
Huron & Brigantine Blvd.
Atlantic City, NJ 08401

Susquehanna Bank Center (renamed from Blockbuster/Sony Entertainment Center and Tweeter Center)
1 Harbour Blvd
Camden, NJ 08103

PNC Bank Arts Center (renamed from Garden State Arts Center)
Exit 116 Garden State Parkway
Holmdel, NJ 07733

Birch Hill Nightclub (found the address but it closed in 2003)
Route 9 South
Old Bridge, NJ

when i searched for the strand, the only venue that showed up was in RI and i'm pretty sure there isn't a providence in NJ so i think the states wrong on that one!

I'll do the UK and some Euro-venues as I've been to some of them

Exhibition Centre, Aberdeen, , UK
www.aecc.co.uk

Exhibition Av
Bridge of Don
Aberdeen
AB23 8BL


Academy, Birmingham, UK
note that OLP played at the Academy 2 in 2002 (headlining) and the Academy itself in 2003 when they supported Avril. Both are in the same building:
http://www.birmingham-academy.co.uk/
52-54 Dale End
Birmingham
B4 7LS


NEC, Birmingham, , UK
www.necarena.co.uk

Birmingham NEC
Birmingham
B40 1NT

Centre, Brighton, , UK
http://www.brightoncentre.co.uk/
The Brighton Centre
Kings Road
Brighton
BN1 2GR

International Arena, Cardiff, , UK
Cardiff International Arena
Mary Ann Street
Cardiff
CF10 2EQ

V2002, Chelmsford, , UK
Hylands Park
Chelmsford
Essex

Barrowlands, Glasgow, , UK
242 the Gallowgate
Glasgow
Lanarkshire

Garage, Glasgow, , UK
490 Sauchiehall Street
Glasgow
Lanarkshire


SECC, Glasgow, , UK
Finnieston
Glasgow
Lanarkshire
G3 8YW

Leeds Festival, Leeds, , UK
This has moved venues, so it depends what year it was.
1999-2001:
Temple Newsam
Leeds
Yorkshire
LS15 0AD

2002 onwards:
Bramham Park
Wetherby
West Yorkshire
LS23 6ND

Apollo Hammersmith, London, , UK
Queen Caroline Street
London
W6 9QH

Astoria, London, , UK
157 Charing Cross Road
London
WC2 0EN

BBC Studios, London, , UK
If these are at TV centre, then the address is:
BBC Television Centre
London
W12 7RJ

Borderline, London, , UK
Orange Yard
off Manette Street
London
W1D 4JB

Brit Awards, London, , UK
This doesn't have a fixed venue, so it would have to be done year by year.

Brixton Academy, London, , UK
211 Stockwell Road
London
SW9 9SL

Camden Palace, London, , UK
This is now called KOKO
1a Camden High Street
London
NW1 7JE

Electric Ballroom, London, , UK
184 Camden High Street
London
NW1 8QP

Forum, London, , UK
The Forum
9 - 17 Highgate RD
Kentish Town
London
NW5 1JY

Shepherd's Bush Empire, London, , UK
Shepherd's Bush Green
London
W12 8TT

Splash Club, London, , UK
Water Rats
328 Gray's Inn Road
King's Cross
London
WC1X 8BZ

Top of the Pops, London, , UK
BBC Television Centre
London
W12 7RJ

University of London Union, London, , UK
Malet Street
London
WC1E 7HY

Wembley Arena, London, , UK
Empire Way
Wembley
Middlesex
HA9 0DW

Academy, Manchester, , UK
There are actually 3 Academies: 1, 2 and 3 (how imaginative!) 1 is in a separate building, 3 is within the uni students' union next door and I don't know where 3 is, but I think it's also in the SU.
OLP played at the Academy 3 in 2002.
Oxford Road
Manchester
M13 9PR

Apollo, Manchester, , UK
Stockport Road
Manchester
Lancashire
M12 6AP

Evening News Arena, Manchester, , UK
Commonly referred to as the M.E.N. Arena and is called that on ticketmaster, so I'm not sure if that's its official name now.
Victoria Station
Hunts Bank
Manchester
M3 1AR

University, Manchester, , UK
See Manchester Academy.

Telewest Arena, Newcastle, , UK
Now called Metro Radio Arena
Arena Way
Newcastle Upon Tyne
NE4 7NA

Rock City, Nottingham, , UK
8 Talbot Street
Nottingham
NG1 5GG

Reading Festival, Reading, , UK
Little John's Farm
Richfield Avenue
Reading
RG1 8EQ

Arena, Sheffield, , UK
Broughton Lane
Sheffield
S9 2DF

Weston Park, Straffordshire, , UK
Should be Staffordshire not Straffordshire. This is most likely the V festival which runs over 2 sites (see V2002 info above for the other site's details)
Weston-Under-Lizard
NR Shifnal
TF11 8LE

Wulfrun Hall, Wolverhampton, , UK
Mitre Fold
North Street
Wolverhampton
WV1 1RQ
[/b]

i love that soozies list has emoticons

crustine wrote:Bands used to play the Jock Hardy Arena at Queen's University. I am pretty sure this was before Robbos time
Saw, Supertramp, Peter Tosh, Burton Cummings there, to name a few.

The Memorial Centre is still open and will remain open indefinitely but it wont have concerts, just hockey.


Josh I will take on NY tomorrow.

ohhh yes. jock hardy. remember it well i do. fucking exams :|

no kidding - years later it was still hard to run the track without remember the exams I bombed.

haha

my buddy back in the day got up during the middle of 1st year eng-chem and started singing "i am, i am, i am an engineer.. why you were all studying, i was drinking beer.. *mumbled next verse* so to all of you i say.. FUCK YOU SCI 02"

this was of course at 9 am
and he was utterly plastered.
hence the mumbling.
he climbed on his desk in the middle of jock hardy and did that. he had a hard time filling in the scan tron to get his name in.. then waited patiently till 10 am (or whatever the minimum wait time is? 30 or 40 mins?) and then did that and promptly got kicked out

I shortened the list on my initial post!

Some of the venues were places that Nickelback or Silverchair played so they don't need to be in the database, and I think I removed all of the ones that information was provided for.

Thanks for the help everyone