New and Updated - UK Golf Courses Database vol.3
This database is the
new and
updated version of the previous one(vol.2)
So, this one is the third(vol.3) and the last updated version with
LOTS OF FIELDS!!!
Fields:
1) ID
2) CAT
3) CLUB NAME
4) ADDRESS1
5) ADDRESS2 EXTRA
6) TOWN
7) POSTCODE
8) SECRETARY NAME
9) SECRETARY TELEPHONE
10) WEBSITE
11) EMAIL
12) GREENKEEPER
13) PROFESSIONAL
14) PROFESSIONAL TELEPHONE
15) MANAGER
16) MANAGER TELEPHONE
17) NUMBER OF HOLES
18) YARDAGE
19) PAR
20) YARDAGE MARKERS ON COURSE
21) CHANGING ROOM FACILITIES
22) HANDICAP CERTIFICATES REQUIRED
23) DRIVING RANGE
24) SOFT SPIKES REQUIRED
25) SOCIETY DAYS
26) CLUB TYPE
27) COURSE TYPE
28) PROSHOP AVAILABLE
29) CLUB HIRE AVAILABLE
30) CLUB REPAIRS AVAILABLE
31) CUSTOM CLUB FITTING SERVICE
32) TROLLEY HIRE AVAILABLE
33) ELETRIC ROLLEY REPAIR
34) BUGGY HIRE AVAILABLE
35) LESSONS AVAILABLE
36) COURSE PLANNER AVAILABLE
37) BAR AVAILABLE
38) BREAKFAST AVAILABLE
39) LUNCH AVAILABLE
40) AFTERNOON TEA AVAILABLE
41) DINNER AVAILABLE
42) ACCOMODATION AVAILABLE
address2,
manager,
managerphone and
greenkeeper fields are extra for you.
All towns that the db includes:
Abbeyfeale
Abbeyleix
Aberdare
Aberdeen
Aberdour
Aberdovey
Aberfeldy
Aberfoyle
Abergavenny
Abergele
Aberlady
Aberlour
Abersoch
Aberystwyth
Abingdon
Aboyne
Accrington
Achill
Adare
Addlestone
Aghadowey
Aintree
Airdrie
Albufeira
Aldbury
Aldeburgh
Alderney
Aldershot
Alexandria
Alford
Alfreton
Alloa
Almancil
Alness
Alnmouth
Alnwick
Alresford
Alston
Alton
Altrincham
Alva
Alvechurch
Alvor
Alyth
Amersham
Amlwch
Ammanford
Ampthill
Andover
Annan
Anstruther
Antrim
Appleton
Arbroath
Archerstown
Ardagh
Ardee
Ardfert
Ardglass
Argyll
Arklow
Armagh
Arnold
Ascot
Ashbourne
Ashford
Ashkirk
Ashton in Makerfield
Ashton-under-Lyne
Askham in Furness
Athlone
Athy
Auchenblae
Auchterarder
Aughnacloy
Authterarder
Aylesbury
Ayr
Ayrshire
Bacup
Bagshot
Bala
Balbriggan
Ballaghaderreen
Ballater
Ballina
Ballinamore
Ballinasloe
Ballinrobe
Ballyboughal
Ballybunion
Ballycastle
Ballyclare
Ballyconnell
Ballyferriter
Ballyhale
Ballyhaunis
Ballyliffin
Ballymena
Ballymoney
Ballymote
Ballynahinch
Baltinglass
Bamburgh
Banbridge
Banbury
Banchory
Bandon
Banff
Bangor
Banstead
Bargoed
Barnet
Barnsley
Barrhead
Barrow in Furness
Barry
Basildon
Basingstoke
Bath
Bathgate
Battle
Bawburgh
Beaconsfield
Bearna
Bearsden
Beauly
Beaumaris
Beccles
Beckenham
Bedale
Bedford
Bedlington
Beith
Belas
Belfast
Belford
Bellshill
Belmullet
Belturbet
Benburb
Berkhamstead
Berwick
Berwick-upon-Tweed
Betws y Coed
Beverley
Bexhill-on-Sea
Bicester
Bickerstaffe
Biddenham
Bideford
Bierton
Bigbury on Sea
Biggar
Biggleswade
Billingham
Billlingham
Binfield
Bingley
Birkenhead
Birmingham
Birr
Bishop
Bishops Stortford
Bishopton
Blaby
Blackburn
Blacklion
Blackpool
Blackrock
Blackwood
Blainroe
Blair Atholl
Blairgowrie
Blessington
Blyth
Blythe Bridge
Boat-of-Garten
Bodenham
Bodmin
Bodyke
Bognor Regis
Bolton
Bonnybridge
Bonnyrigg
Bootle
Bordon
Borehamwood
Borris
Borth
Boston
Botcheston
Botley
Bourne
Bournemouth
Boyle
Bradford
Bradford on Avon
Braemar
Braintree
Braunstone Frith
Braunton
Bray
Brechin
Brecon
Brentwood
Bridge of Allan
Bridge of Weir
Bridgend
Bridgnorth
Bridgwater
Bridlington
Bridport
Brigg
Brighouse
Brighton
Bristol
Brittas
Brixham
Broadstone
Broadway
Brockenhurst
Brockham
Bromley
Bromsgrove
Brora
Brough
Broxbourne
Brynteg
Buckie
Buckingham
Bude
Budleigh Salterton
Builth Wells
Bulphan
Bulwell
Buncrana
Bundoran
Bungay
Buntingford
Burford
Burgess Hill
Burnham-on-Crouch
Burnham-on-Sea
Burnley
Burntisland
Burry Port
Burton upon Trent
Bury
Bury Saint Edmunds
Bushey
Bushey Heath
Bushy Park
Buxton
Caerleon
Caernafon
Caerphilly
Cahir
Caldicot
Callan
Callander
Calne
Camarthen
Camberley
Camborne
Cambridge
Cambuslang
Camelford
Campbeltown
Cannock
Canterbury
Canvey Island
Carbury
Cardenden
Cardiff
Cardigan
Carlisle
Carlow
Carluke
Carnforth
Carnlough
Carnoustie
Carrbridge
Carrickfergus
Carrickmacross
Carrick-on-Shannon
Carrick-on-Suir
Carrigrohane
Carrigtwohill
Carshalton
Cascais
Cashel
Castle Combe
Castle Douglas
Castlebar
Castleblayney
Castlecomer
Castledawson
Castledermot
Castlegregory
Castlerea
Castlerock
Castletownbere
Caterham
Cavan
Celbridge
Chalfont Saint Giles
Chapel en le Frith
Chard
Charleville
Cheadle
Chelmsford
Cheltenham
Chepstow
Chertsey
Chesham
Chessington
Chester
Chesterfield
Chichester
Chigwell
Chilworth
Chingford
Chippenham
Chipping Norton
Chislehurst
Chorley
Chorleywood
Church Stretton
Cirencester
Clacton
Claines
Clane
Claremorris
Clatt
Cleethorpes
Clevedon
Clifden
Clitheroe
Cloghran
Clonakilty
Clones
Clonlara
Clonmel
Clonmellon
Clydebank
Co Kildare
Co. Cork
Coalburn
Coalville
Coatbridge
Cobh
Cobham
Cockermouth
Colchester
Coldstream
Coleford
Coleraine
Colmworth
Colne
Comrie
Cong
Congleton
Connemara
Conwy
Cookstown
Corby
Cork
Corsham
Cosby
Cottingham
Coulsdon
County Durham
Coventry
Cowdenbeath
Cowes
Cradley Heath
Craigavon
Cramlington
Cranbrook
Cranleigh
Crawley
Crediton
Crewe
Criccieth
Cricklade
Crieff
Cromer
Crossagalla
Crowborough
Croydon
Cuckfield
Culdrose
Cullompton
Cumbernauld
Cumbria
Cupar
Cushendall
Cwmbran
Dailly
Daingean
Dalbeattie
Dalkeith
Dalmally
Darlington
Dartford
Dartmouth
Daventry
Dawlish
Deal
Deepcar
Deeside
Delgany
Delvin
Denbigh
Denham
Denstone
Derby
Dereham
Derry
Devizes
Devon
Dewsbury
Dibden
Didcot
Dinas Powis
Diss
Dolgellau
Dollar
Donabate
Donaghadee
Doncaster
Doneraile
Dorchester
Dorking
Dornoch
Dorset
Douglas
Downham Market
Downpatrick
Driffield
Drogheda
Droitwich
Dublin
Dudley
Dufftown
Dukinfield
Dulwich
Dumbarton
Dumfries
Dun Laoghaire
Dunbar
Dunbartonshire
Dunblane
Dundalk
Dundee
Dundonald
Dunfermline
Dungannon
Dungarvan
Dunglow
Dunkeld
Dunlavin
Dunmore
Dunmurry
Dunoon
Duns
Dunshaughlin
Dunstable
Durham
Durness
Dursley
Dymock
Easingwold
East Boldon
East Cowes
East Grinstead
East Horsley
East Kilbride
East Lothian
East Morton
Eastbourne
Eastern Road
Eastleigh
Eccles
Edenbridge
Edenderry
Edinburgh
Edmonton
Edzell
Effingham
Elderslie
Elgin
Ellesmere
Ellon
Elstree
Eltham
Enderby
Enfield
Ennis
Enniscorthy
Enniscrone
Enniskerry
Enniskillen
Epping
Epsom
Esher
Essex
Estoril
Exeter
Eyemouth
Fahan
Failsworth
Fakenham
Falcarragh
Falkirk
Falkland
Falmouth
Fanad
Fareham
Faringdon
Farleigh
Farnborough
Farnham
Faversham
Fawkham
Felixstowe
Feltwell
Fermoy
Ffestiniog
Fife
Filey
Finchley
Fintona
Fleet
Fleetwood
Flint
Flixton
Fochabers
Folkstone
Forfar
Forres
Fort Augustus
Fort William
Fortrose
Fraserburgh
Freshwater
Frodsham
Frome
Gainsborough
Gairloch
Galashiels
Galston
Galway
Gateshead
Gerrards Cross
Gillingham
Girvan
Glasgow
Glenalmond
Glenbeigh
Glencullen
Glengarriff
Glenrothes
Glossop
Gloucester
Glynneath
Godalming
Golspie
Gorey
Gormanston
Gort
Gosport
Gourock
Grange over Sands
Grantham
Grantown-on-Spey
Gravesend
Great Totham
Great Yarmouth
Greencastle
Greenford
Greenock
Greenore
Gretna
Greystones
Grimsby
Guernsey
Guildford
Guilgford
Gullane
Haddington
Hadzor
Halesowen
Halesworth
Halifax
Halstead
Hamilton
Hampstead
Hampton
Hants
Hanwell
Harlech
Harlow
Harpenden
Harrogate
Harrow
Hartford
Hartlepool
Harwood
Haslar
Hatfield
Haverfordwest
Haverhill
Hawick
Hawkhurst
Hayling Island
Haywards Heath
Headcorn
Helensburgh
Hellingly
Helmsdale
Helston
Hemel Hempstead
Hemingford Abbots
Hempstead
Hengoed
Henley in Arden
Henley on Thames
Henlow
Hereford
Hertford
Hertfordshire
Hever
Hexham
High Wycombe
Highgate
Highnam
Highworth
Hinckley
Hindhead
Hitchin
Hollystown
Holsworthy
Holyhead
Holywell
Holywood
Honiton
Hope
Horam
Horne
Hornsea
Horsforth
Horsham
Horsley
Houghton-le-Spring
Hounslow
Hove
Howth
Hucknall
Huddersfield
Hull
Hunstanton
Huntingdon
Huntly
Huthwaite
Huyton
Hyde
Hythe
Ifield
Ilford
Ilfracombe
Ilkeston
Ilkley
Immingham
Insch
Invergordon
Inverness
Inverurie
Ipswich
Irvine
Islandmagee
Isle of Arran
Isle of Benbecula
Isle of Bute
Isle of Colonsay
Isle of Cumbrae
Isle of Harris
Isle of Islay
Isle of Lewis
Isle of Man
Isle of Mull
Isle of Skye
Isle of Tiree
Isles of Scilly
Isleworth
Iver
Ivybridge
Jedburgh
Jersey
Johnstone
Kanturk
Keighley
Keith
Kells
Kelso
Kemnay
Kendal
Kenilworth
Kenmare
Kenmore
Kenningston
Kensington
Keswick
Kettering
Kibworth Beauchamp
Kidderminster
Kidwelly
Kilbirnie
Kilcock
Kilcoole
Kildare
Kilkee
Kilkeel
Kilkenny
Kill
Killarney
Killin
Killiney
Killorglin
Kilmacolm
Kilmarnock
Kilrea
Kilrush
Kilsallaghan
Kilsyth
Kilternan
Kinghorn
Kings Lynn
Kingsbridge
Kingscourt
Kingston-upon-Thames
Kingussie
Kinross
Kinsale
Kintore
Kintyre
Kirdford
Kirkby in Ashfield
Kirkcaldy
Kirkcubright
Kirkcudbright
Kirkintilloch
Kirknewton
Kirtlington
Knaresborough
Knebworth
Knighton
Knottingley
Knutsford
Ladybank
Laghey
Lagoa
Lagos
Lahinch
Lamberhurst
Lampeter
Lanark
Lancaster
Landford
Langbank
Langho
Langholm
Langport
Larbert
Largs
Larkhall
Larne
Lauder
Launceston
Lea
Leamington
Leatherhead
Leeds
Leek
Lee-on-the-Solent
Leicester
Leigh
Leigh on Sea
Leighton Buzzard
Leiston
Lenzie
Leominster
Letchworth
Letterkenny
Leuchars
Leven
Leyland
Lichfield
Limavady
Limerick
Lincoln
Lindfield
Lingfield
Linlithgow
Liphook
Lisbon
Lisburn
Lismore
Liss
Listowel
Little Houghton
Little Island
Liverpool
Livingston
Llandudno
Llandysul
Llanfairfechan
Llangefni
Llangollen
Llanidloes
Llantrisant
Llanwern
Lochgelly
Lochgilphead
Lochwinnoch
Lockerbie
London
Londonderry
Long Eaton
Longford
Longniddry
Longridge
Looe
Lossiemouth
Lostwithiel
Loughborough
Loughrea
Loughton
Louth
Lowestoft
Lucan
Ludlow
Lundin
Lurgan
Luton
Lutterworth
Lybster
Lydney
Lyme Regis
Lymm
Lyndhurst
Lytham Saint Annes
Macclesfield
Macduff
Machynlleth
Macroom
Maesteg
Magherafelt
Maidenhead
Maidstone
Malahide
Mallow
Malmesbury
Malvern
Manchester
Mansfield
Mapperley
March
Margaretting
Market Drayton
Market Harborough
Market Rasen
Marlborough
Marlow
Matlock
Mauchliine
Maybole
Melrose
Melton Mowbray
Merseyside
Merthyr Tydfil
Metheringham
Mickleover
Middlesborough
Middleton
Middletown
Midhurst
Midleton
Midlothian
Milford Haven
Mill Hill
Millum
Milton Keynes
Miltown Malbay
Minehead
Mirfield
Mitchelstown
Moate
Moffat
Mold
Monaghan
Monkstown
Monmouth
Montrose
Moray
Morecambe
Moretonhampstead
Morley
Morpeth
Motherwell
Mountain Ash
Mountrath
Moville
Muir of Ord
Muirkirk
Mullaghbawn
Mullingar
Mundesley
Musselburgh
Naas
Nairn
Nantwich
Nantyglo
Navan
Neath
Nelson
Nenagh
Nethy Bridge
New Cumnock
New Malden
New Romney
New Ross
Newark
Newbridge
Newburgh
Newbury
Newcastle
Newcastle under Lyme
Newcastle upon Tyne
Newcastleton
Newdigate
Newent
Newmarket On Fergus
Newport
Newquay
Newry
Newton Abbot
Newton Aycliffe
Newton Mearns
Newton Stewart
Newtonards
Newton-le-Willows
Newtonmore
Newtown
Newtown Stewart
Newtownabbey
Newtownards
Newtownmountkennedy
North Berwick
North Kildare
North Ockendon
North Shields
Northallerton
Northampton
Northenden
Northolt
Northumberland
Northwich
Northwood
Norton
Norwich
Nottingham
Nuneaton
Oadby
Oakdale
Oakham
Oban
Obidos
Okehampton
Old Colwyn
Old Hunstanton
Oldham
Omagh
Ombersley
Oranmore
Orkney
Ormskirk
Orpington
Orsett
Ossett
Osterley
Oswestry
Ottershaw
Oughterard
Oulton
Ovens
Oxford
Oxted
Padgate
Padstow
Paisley
Peebles
Pembroke
Penarth
Penicuik
Penmaenmawr
Penzance
Perivale
Perranporth
Pershore
Perth
Peterborough
Peterculter
Peterhead
Pewsey
Pinner
Pitlochry
Plymouth
Plympton
Pocklington
Polmont
Pontefract
Ponteland
Pontypool
Pontypridd
Poole
Port Glasgow
Portadown
Portaferry
Portarlington
Portballintrae
Porthcawl
Portimao
Portlaoise
Portmadog
Portmarnock
Portnoo
Portpatrick
Portrush
Portsmouth
Portstewart
Portumna
Prescot
Prestatyn
Preston
Prestonpans
Prestwich
Prestwick
Prudhoe-on-Tyne
Pudsey
Pulborough
Pumpherston
Pwllheli
Radcliffe on Trent
Radlett
Raglan
Ramsey
Ramsgate
Rathcoole
Rathdowney
Rathdrum
Rathmoylan
Rayleigh
Reading
Redcar
Redcross
Redditch
Redhill
Redruth
Reigate
Renfrew
Renishaw
Retford
Rhondda
Rhosneigr
Rhyl
Richmond
Rickmansworth
Ringaskiddy
Ringwood
Ripley
Ripon
Rishton
Rochdale
Rochester
Rochford
Roehampton
Romford
Romney Marsh
Romsey
Rosapenna
Roscommon
Roscrea
Ross on Wye
Rossendale
Rosses Point
Rosslare Harbour
Rothbury
Rotherham
Rothesay
Rothley
Roundwood
Royston
Ruddington
Rugby
Rugeley
Ruislip
Runcorn
Rush
Rushden
Ruthin
Ryde
Rye
Ryton
Saggart
Saint Albans
Saint Andrews
Saint Annes on Sea
Saint Austell
Saint Bees
Saint Brelade
Saint Clement
Saint Davids
Saint Fillans
Saint Helens
Saint Ives
Saint Leonards on Sea
Saint Margarets
Saint Neots
Sale
Saline
Salisbury
Sallins
Saltash
Saltburn by the Sea
Saltcoats
Sandown
Sandwich
Scarborough
Scarisbrick
Schull
Scone
Scraptoft
Scunthorpe
Seaham
Seascale
Seaton
Sedbergh
Sedgefield
Sedlescombe
Selby
Selkirk
Selsey
Sevenoaks
Shadwell
Shannon
Sheerness
Sheffield
Shefford
Shepperton
Sherborne
Sheringham
Shetland
Shifnal
Shillelagh
Shipley
Shipton
Shiremoor
Shoreham
Shotts
Shrewsbury
Sidmouth
Sintra
Sittingbourne
Skegness
Skelmersdale
Skelmorlie
Skene
Skerries
Skibbereen
Skipton
Sleaford
Sligo
Slough
Sneem
Solihull
Somerton
South Benfleet
South Brent
South Bucks
South Croydon
South Kyme
South Ockendon
South Oxhey
South Shields
South Uist
South Wirral
Southall
Southampton
Southend on Sea
Southfield
Southgate
Southport
Southwell
Spalding
Spilsby
ST Andrews
St Austell
St Helens
Stafford
Stalybridge
Stamford
Stanford-le-Hope
Stanmore
Stanstead Abbotts
Stapleford Abbotts
Staplehurst
Stevenage
Stevenston
Stirling
Stockport
Stocksbridge
Stocksfield
Stockton on Tees
Stoke Poges
Stoke-On-Trent
Stone
Stonehaven
Stourbridge
Stowe
Stowmarket
Strabane
Straffan
Stranorlar
Stranraer
Stratford upon Avon
Strathaven
Strathcarron
Strathpeffer
Street
Strokestown
Stroud
Sunbury on Thames
Sunderland
Sunningdale
Surrey
Sutherland
Sutton
Sutton Coldfield
Sutton in Ashfield
Sutton Weaver
Sutton-on-Sea
Swaffham
Swanage
Swanley
Swansea
Swindon
Swinford
Swinton
Swords
Tadcaster
Tadworth
Tain
Tallaght
Tamworth
Tandragee
Taunton
Taverham
Tavira
Tavistock
Tayport
Teignmouth
Telford
Templemore
Templepatrick
Tenbury Wells
Tenby
Tenterden
Tetbury
Tewkesbury
Thame
Thetford
Thirsk
Thomastown
Thornhill
Thornton
Thurles
Thurso
Tidworth
Tighnabruaich
Tillicoultry
Tipperary
Tobermory
Todmorden
Tonbridge
Torphins
Torpoint
Torquay
Torrance
Torrington
Totteridge
Towcester
Tralee
Tredegar
Treharris
Trim
Troon
Truro
Tuam
Tubbercurry
Tullamore
Tullow
Tunbridge Wells
Turnberry
Turriff
Twickenham
Two Mile Ash
Tyne and Wear
Uckfield
Uddingston
Ufford
Ullapool
Ulverston
Umberleigh
Uphall
Uplawmoor
Upminster
Uppermill
Usk
Utley
Uttoxeter
Uxbridge
Ventnor
Vila do Bispo
Vilamoura
Virginia
Wadebridge
Wadhurst
Wakefield
Wallasey
Wallingford
Wallsend
Walsall
Walton on Thames
Ware
Wareham
Wargrave
Warley
Warminster
Warrenpoint
Warrington
Warwick
Washington
Waterford
Waterlooville
Waterville
Watford
Wellingborough
Wells
Welshpool
Welton
Welwyn
Welwyn Garden City
Wembley
West Bromwich
West Byfleet
West Caldar
West Chiltington
West Cork
West Didsbury
West Drayton
West Hove
West Kilbride
west Linton
West Lothians
West Lothlan
West Malling
West Sussex
Westbury
Westerham
Weston-Super-Mare
Westport
Wetherby
Wexford
Weybridge
Weymouth
Whalley
Whetstone
Whitby
Whitchurch
Whitefield
Whitehead
Whitley Bay
Whitwood
Wick
Wickham
Wicklow
Widnes
Wigan
Wigginton
Wigton
Wilmslow
Wimbledon
Wimborne
Wincanton
Winchburgh
Winchester
Windermere
Windsor
Winsford
Wirral
Wirrall
Wisbech
Wishaw
Witham
Withernsea
Witney
Woking
Wokingham
Wolverhampton
Wooburn Common
Woodbridge
Woodhall Spa
Wooler
Worcester
Worcestershire
Workington
Worksop
Wormsley
Worsley
Worthing
Wotton-Under-Edge
Wrexham
Wyboston
Yateley
Yealmpton
Yeovil
York
Youghal
Structure:
PHP Code:
CREATE TABLE `UKgolfcourses` (
`id` bigint(20) NOT NULL auto_increment,
`cat` varchar(50) NOT NULL default '',
`clubname` varchar(255) NOT NULL default '',
`address1` text NOT NULL,
`address2extra` text,
`town` text,
`postcode` text,
`secretaryname` text,
`secretarytelephone` text,
`website` text,
`email` text,
`greenkeeper` text,
`professional` text,
`professionaltelephone` text,
`manager` text,
`managertelephone` text,
`numberofholes` text,
`yardage` text,
`par` text,
`yardagemarkersoncourse` text,
`changingroomfacilities` text,
`handicapcertificatesrequired` text,
`drivingrange` text,
`softspikesrequired` text,
`societydays` text,
`clubtype` text,
`coursetype` text,
`proshopavailable` text,
`clubhireavailable` text,
`clubrepairsavailable` text,
`customclubfittingservice` text,
`trolleyhireavailable` text,
`electrictrolleyrepair` text,
`buggyhireavailable` text,
`lessonsavailable` text,
`courseplanneravailable` text,
`baravailable` text,
`breakfastavailable` text,
`lunchavailable` text,
`afternoonteaavailable` text,
`dinneravailable` text,
`accomodationavailable` text,
PRIMARY KEY (`id`),
KEY `cat_index` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3030 ;
Records: 3.029
Price: 49$
New and Updated - UK Golf Courses Database vol.3
