Training, Open Source computer languages

Perl • PHP • Python • MySQL • httpd / Tomcat • Tcl • Ruby • Java • C and C++ • Linux • CSS

Search our site for:
Print friendly page
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Please visit
http://www.wellho.net/data/index.php4
for the latest update to this page
Training course data
This page shows you the first few lines of each of the data files that we supply for you to use during Well House Consultants courses. As we encourage you to do practical exercises that are relevant to YOU, you'll find that different trainees will select different data sets in order to most closely match their own targetted applications, and we even encourage you to bring your own data.

INSTRUCTIONS FOR USE
If you are visiting our course server, you'll see that each file name is be a link any you can save a copy of the file to your desktop.

On our live Internet server that's visible from your own office, you'll be shown a sampling of the data in each file - we impose this limitation in order to prevent you accidentally downloading huge data files, and because of restricted rights on some of the data. Please email us if you need a complete data file for any reason.

• send coursework from training system to delegate's email address
• upload file from training system to course server
• Grab coursework off training server


The data itself ...
You can see more of each line if you turn navigation off, or if you select a smaller font.

acc.xyz
acc.xyz has a total size of 14309140 bytes
Sun Aug 31 10:20:01 PDT 2003

ol163-250.fibertel.com.ar - - [31/Aug/2003:00:09:26 -0700] "GET /resourc ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:09:27 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:09:29 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:09:30 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:09:30 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:11 -0700] "GET /net/cha ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:18 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:31 -0700] "GET /net/set ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:32 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:34 -0700] "GET /net/set ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:35 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:35 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:35 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:35 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:36 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:36 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:36 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:37 -0700] "GET /wellimg ...
ol163-250.fibertel.com.ar - - [31/Aug/2003:00:10:36 -0700] "GET /wellimg ...
access_log.xyz
access_log.xyz has a total size of 605455 bytes
Wed Jul 15 01:33:29 EDT 1998

seaweed - - [15/Jul/1998:08:32:38 -0400] "GET / HTTP/1.0" 200 1476

sealion - - [15/Jul/1998:08:32:48 -0400] "GET /perl/index.html HTTP/1.0" ...
flipper - - [15/Jul/1998:08:32:51 -0400] "GET /perl/interact HTTP/1.0" 3 ...
magnet - - [15/Jul/1998:08:32:51 -0400] "GET /perl/interact/ HTTP/1.0" 2 ...
aviemore - - [15/Jul/1998:08:32:55 -0400] "GET /perl/interact/wash.html  ...
seal - - [15/Jul/1998:08:33:30 -0400] "POST /cgi-bin/firstalt/weave.pl H ...
flipper - - [15/Jul/1998:08:35:14 -0400] "POST /cgi-bin/firstalt/weave.p ...
aviemore - - [15/Jul/1998:08:35:52 -0400] "POST /cgi-bin/firstalt/weave. ...
seaweed - - [15/Jul/1998:08:36:41 -0400] "POST /cgi-bin/firstalt/weave.p ...
magnet - - [15/Jul/1998:08:38:04 -0400] "GET /perl/interact/wool.html HT ...
aviemore - - [15/Jul/1998:08:38:14 -0400] "POST /cgi-bin/firstalt/wish.p ...
seaweed - - [15/Jul/1998:08:39:57 -0400] "POST /cgi-bin/firstalt/wish.pl ...
flipper - - [15/Jul/1998:12:33:33 -0400] "GET /perl/manual/perl.html HTT ...
magnet - - [15/Jul/1998:12:33:56 -0400] "GET /perl/manual/perlpod.html H ...
seaweed - - [15/Jul/1998:12:36:14 -0400] "GET /perl/all.html HTTP/1.0" 2 ...
seal - - [15/Jul/1998:13:02:45 -0400] "GET /pub/index.html HTTP/1.0" 200 ...
sealion - - [15/Jul/1998:13:02:47 -0400] "GET /pub/graham HTTP/1.0" 302  ...
flipper - - [15/Jul/1998:13:02:47 -0400] "GET /pub/graham/ HTTP/1.0" 200 ...
magnet - - [15/Jul/1998:13:02:48 -0400] "GET /pub/graham/wellho.gif HTTP ...
animal.xyz
animal.xyz has a total size of 266 bytes
use strict;

package animal;



sub new {

	my ($class,$name,$age) = @_;

	my @info;

	$info[0] = $name;

	$info[1] = $age;

	bless \@info, $class;

	}



sub getage {

	my ($which) = @_;

	return $$which[1] * 12;

	}



sub getname {

	my ($which) = @_;

	return $$which[0] ;

	}
france.xyz
france.xyz has a total size of 64 bytes
Plymouth

Poole

Southampton

Portsmouth

Newhaven

Folkestone

Dover
hosts.xyz
hosts.xyz has a total size of 9504 bytes
# Host Database

# 

# localhost is used to configure the loopback interface

# when the system is booting.  Do not change this entry.



127.0.0.1  localhost self aapself courseself traineeself expressself 

255.255.255.255	broadcasthost

192.168.200.140 sunday sun metre

192.168.200.141 monday mon furlong

192.168.200.142 tuesday tues tue kilometre

192.168.200.143 wednesday weds wed beer

192.168.200.144 thursday thurs thu cider

192.168.200.145 friday fri stout 

192.168.200.146 saturday sat cocoa eddie

192.168.200.147	flipper aaplocal #whc

192.168.200.148	brandy

192.168.200.149	tequila

192.168.200.150   elderberry bruno

192.168.200.151   earl

192.168.200.152	count
loginfo.xyz
loginfo.xyz has a total size of 5214 bytes
graham    ttyp2                     Wed Sep 24 06:19   still logged in

graham    ttyp2                     Wed Sep 24 06:19 - 06:19  (00:00)

graham    ttyp1                     Wed Sep 24 06:16   still logged in

graham    ttyp1                     Wed Sep 24 06:16 - 06:16  (00:00)

graham    ttyp1                     Tue Sep 23 16:54 - 06:16  (13:22)

graham    ttyp1                     Tue Sep 23 16:54 - 16:54  (00:00)

graham    console  Graham-Elliss-Co Tue Sep 23 16:53   still logged in

reboot    ~                         Tue Sep 23 16:31 

graham    ttyp2                     Tue Sep 23 12:31 - crash  (03:59)

graham    ttyp2                     Tue Sep 23 12:31 - 12:31  (00:00)

graham    ttyp1                     Tue Sep 23 09:48 - crash  (06:42)

graham    ttyp1                     Tue Sep 23 09:48 - 09:48  (00:00)

graham    console  Graham-Elliss-Co Tue Sep 23 09:48 - 16:04  (06:16)

reboot    ~                         Tue Sep 23 08:51 

graham    ttyp1                     Mon Sep 22 09:09 - crash  (23:41)

graham    ttyp1                     Mon Sep 22 09:09 - 09:09  (00:00)

graham    console  Graham-Elliss-Co Mon Sep 22 09:09 - 15:52  (06:42)

reboot    ~                         Mon Sep 22 07:52 

graham    console  Graham-Elliss-Co Sun Sep 21 19:08 - 19:18  (00:09)

reboot    ~                         Sun Sep 21 19:08
medline_xml.xyz
medline_xml.xyz has a total size of 84072 bytes
<!DOCTYPE MedlineCitationSet

PUBLIC "-//NLM//DTD MEDLINE, 11th December 2000//EN"

"http://www.nlm.nih.gov/databases/dtd/nlmmedline_001211.dtd">

<MedlineCitationSet>

<MedlineCitation>

<MedlineID>96264942</MedlineID>

<PMID>8655018</PMID>

<DateCreated>

<Year>1996</Year>

<Month>07</Month>

<Day>30</Day>

</DateCreated>

<DateCompleted>

<Year>1996</Year>

<Month>07</Month>

<Day>30</Day>

</DateCompleted>

<DateRevised>

<Year>2000</Year>

<Month>12</Month>
postcodes.xyz
postcodes.xyz has a total size of 114112 bytes
    ABERDEEN               Aberdeenshire        AB1,2        Aberdeen

    Abbey Wood             London               SE2          London SE

    Aberaeron              Dyfed                SA46         Swansea

    Aberdare               Glamorgan            CF44         Cardiff

    Aberdour               Fife                 KY3          Kirkcaldy

    Aberdovey              Gwynedd              LL35         Chester

    Aberfeldy              Perthshire           PH15         Perth

    Abergavenny            Gwent                NP7          Newport

    Abergele               Clwyd                LL22         Chester

    Aberlour               Banffshire           AB3          Aberdeen

    Abertillery            Gwent                NP3          Newport

    Aberystwyth            Dyfed                SY23         Shrewsbury

    Abingdon               Oxfordshire          OX13,14      Oxford

    Aboyne                 Aberdeenshire        AB3          Aberdeen

    Accrington             Lancashire           BB5          Preston

    Acheracle              Angus                PA36         Paisley

    Achnasheen             Ross                 IV22         Inverness

    Acton                  London               W3           London W

    Airdrie                Lanarkshire          ML6          Motherwell

    Alcester               Warwickshire         B49,50       Birmingham
requests.xyz
requests.xyz has a total size of 1388 bytes
antonia Perl XML PHP Tcl/Tk MySQL

barbara Tcl/Tk ASP Ruby Java

cherry Perl Java Ruby MySQL

delia XML PHP Java ASP

ethel MySQL Perl Tcl/Tk ASP

florence Ruby PHP Java ASP

gloria XML Perl Tcl/Tk MySQL

hazel PHP Python Perl Ruby ASP

iris  Perl MySQL Java Tcl/Tk

jenny XML Perl Ruby ASP

kerry Perl Tcl/Tk Ruby MySQL

leane PHP Python ASP Perl Java

margaret XML Perl Ruby MySQL Tcl/Tk

nina Tcl/Tk Perl ASP Ruby

olivia  MySQL Python ASP PHP

petra XML Tcl/Tk ASP Perl Ruby

queenie Ruby Perl ASP MySQL

rita PHP ASP Ruby Perl

sally Tcl/Tk Perl XML MySQL

tina Tcl/Tk Ruby Java
stdcodes.xyz
stdcodes.xyz has a total size of 91117 bytes
00 International

001 Canada

001 USA

001201 New Jersey

001202 District of Columbia

001203 Connecticut

001204 Manitoba

001205 Alabama

001206 Washington

001207 Maine

001208 Idaho

001209 California

001210 Texas

001212 New York

001213 California

001214 Texas

001215 Pennsylvania

001216 Ohio

001217 Illinois

001218 Minnesota
towns.xyz
towns.xyz has a total size of 57556 bytes
International

Canada

USA

New Jersey

District of Columbia

Connect*icut

Manitoba

Alabama

Washington

Maine

Idaho

California

Texas

New York

California

Texas

Pennsylvania

Ohio

Illinois

Minnesota
treetab.sql
treetab.sql has a total size of 778 bytes
# Example of creating a database and table within it, and then loading

# the table from a "comma separated variable" file.



# Some sample lines from our data file:



# Douglas Fir,"N America, UK","light, reddish brown",530,3,y,"plywood, c ...
# "Hemlock, Western",N America,pale brown,500,4,n,"construction, joinery ...


drop database if exists sawmill;

create database sawmill;

use sawmill;



create table timbers (

	type	text,

	origin	text,

	colour	text,

	density	int,

	hard	tinyint,

	sched	enum ("y","n"),

	useage	text,
wood.xyz
wood.xyz has a total size of 1586 bytes
Cedar of Lebanon,"Europe, UK",light brown,580,2,y,"garden furniture, dra ...
Douglas Fir,"N America, UK","light, reddish brown",530,3,y,"plywood, con ...
"Hemlock, Western",N America,pale brown,500,4,n,"construction, joinery"

"Larch, European",Europe,"pale, reddish",590,3,y,"boat planking, pit pro ...
"Larch, Japanese",Europe,reddish brown,560,3,n,"stakes, construction"

Parana Pine,S America,golden brown and red streaks,550,4,y,"interior joi ...
"Pine, Corsican", Europe,light yellow-brown,510,4,n,"joinery, constructi ...
"Pine, maritime",Europe, pale brown to yellow,510,3,n,"pallets,packaging ...
"Pine, pitch",South USA,yellow-brown to red-brown,670,3,n,heavy construc ...
"Pine, radiata","South Africa, Australia", yellow to pale brown,480,4,n, ...
"Pine, scots",UK,pale yellow brown to red-brown,510,4,n,"construction, j ...
"Pine, yellow",N America,pale yellow to light brown,420,4,n,"pattern mak ...
"Spruce, Canadian", Canada, white to pale yellow, 450,4,n,"construction, ...
"Spruce, sitka",UK,pinkish-brown,450,4,n,"construction, palletts, packag ...
"Spruce, western white",N America,white to pale yellow brown,450,4,n,"co ...
"Western Red Cedar (aka \"Cedar\")",N America,reddish-brown,390,2,y,"ext ...
"Whitewood, European","Europe, Scandinavia, USSR",white to pale yellow b ...
Yew,Europe,orange-brown to purple-brown, 670,2,y,"furniture, cabinetry,t ...
distances.short
distances.short has a total size of 4020 bytes
IM 4.0 54.0 Isle of Man +*

JE 2.0 49.0 Jersey +*

GY 2.1 49.0 Guernsey +*

AB 3.0 57.8 Aberdeen +

AL 0.4 51.7 St. Albans -

B 2.0 52.5 Birmingham -

BA 2.6 51.4 Bath

BB 2.6 53.8 Blackburn 0

BD 1.9 53.8 Bradford 0

BH 2.9 50.8 Bournemouth -

BL 2.5 53.6 Burnley 0

BN 0.2 50.8 Brighton -

BR 0.0 51.4 Bromley -

BS 2.9 51.5 Bristol

BT 6.0 54.7 Belfast *+

CA 3.0 54.9 Carlisle 0

CB -0.2 52.3 Cambridge 0

CF 3.2 51.5 Cardiff -

CH 3.0 53.2 Chester 0

CM -0.5 51.7 Chelmsford 0
distances.xyz
distances.xyz has a total size of 7461 bytes
IM 4.0 54.0 Isle of Man +*

JE 2.0 49.0 Jersey +*

GY 2.1 49.0 Guernsey +*

AB 3.0 57.8 Aberdeen +

AL 0.4 51.7 St. Albans -

B 2.0 52.5 Birmingham -

BA 2.6 51.4 Bath

BB 2.6 53.8 Blackburn 0

BD 1.9 53.8 Bradford 0

BH 2.9 50.8 Bournemouth -

BL 2.5 53.6 Burnley 0

BN 0.2 50.8 Brighton -

BR 0.0 51.4 Bromley -

BS 2.9 51.5 Bristol

BT 6.0 54.7 Belfast *+

CA 3.0 54.9 Carlisle 0

CB -0.2 52.3 Cambridge 0

CF 3.2 51.5 Cardiff -

CH 3.0 53.2 Chester 0

CM -0.5 51.7 Chelmsford 0
last.xyz
last.xyz has a total size of 14212 bytes
graham    ttyp5    tea              Tue Nov 18 17:12 - 09:00  (15:48)

graham    ttyp4                     Tue Nov 18 08:34   still logged in

graham    ttyp4                     Tue Nov 18 08:34 - 08:34  (00:00)

graham    ttyp4                     Sun Nov 16 05:40 - 08:34 (2+02:53)

graham    ttyp4                     Sun Nov 16 05:40 - 05:40  (00:00)

graham    ttyp3                     Sun Nov 16 05:27   still logged in

graham    ttyp3                     Sun Nov 16 05:27 - 05:27  (00:00)

graham    ttyp2                     Thu Nov 13 14:36   still logged in

graham    ttyp2                     Thu Nov 13 14:36 - 14:36  (00:00)

graham    ttyp1                     Thu Nov 13 06:39   still logged in

graham    ttyp1                     Thu Nov 13 06:39 - 06:39  (00:00)

graham    console  Graham-Elliss-Co Wed Nov 12 19:00   still logged in

reboot    ~                         Wed Nov 12 19:00 

graham    ttyp3    coffee           Wed Nov 12 14:18 - 14:48  (00:30)

graham    ttyp2                     Wed Nov 12 09:27 - crash  (09:32)

graham    ttyp2                     Wed Nov 12 09:27 - 09:27  (00:00)

graham    ttyp1                     Wed Nov 12 09:02 - crash  (09:57)

graham    ttyp1                     Wed Nov 12 09:02 - 09:02  (00:00)

graham    console  Graham-Elliss-Co Wed Nov 12 09:02 - 16:36  (07:34)

reboot    ~                         Wed Nov 12 08:59
login.xyz
login.xyz has a total size of 1486 bytes
<?php include ("$_SERVER[DOCUMENT_ROOT]/../include/stdphp.inc"); 



// Are we cookied?  What are we completing??

////////////////////////////////////////////



if (is_string($_COOKIE[myid])) {

		// Not a brand new visitor

	$completing = 1;

} else {

	$completing = 0;

	$myid = uniqid("my");

	setcookie("myid",$myid,time()+3600*24*365*5,"/");

			// To add for live site - domain

}



// Do the completion action

////////////////////////////////////////////



switch ($completing) {
rgb.xyz
rgb.xyz has a total size of 17371 bytes
! $Xorg: rgb.txt,v 1.3 2000/08/17 19:54:00 cpqbld Exp $

255 250 250		snow

248 248 255		ghost white

248 248 255		GhostWhite

245 245 245		white smoke

245 245 245		WhiteSmoke

220 220 220		gainsboro

255 250 240		floral white

255 250 240		FloralWhite

253 245 230		old lace

253 245 230		OldLace

250 240 230		linen

250 235 215		antique white

250 235 215		AntiqueWhite

255 239 213		papaya whip

255 239 213		PapayaWhip

255 235 205		blanched almond

255 235 205		BlanchedAlmond

255 228 196		bisque

255 218 185		peach puff
roads.xyz
roads.xyz has a total size of 3103 bytes
A1 London to Edinburgh (The Great North Road)

A10 London to King's Lynn

A11 London to Norwich

A12 London to Colchester

A13 London to Shoeburyness

A14 Felixstowe to M1/M6 junction near Rugby

A15 Hull to Peterborough

A16 Stamford to Grimsby

A17 King's Lynn to Newark-on-Trent

A18 Doncaster to Ludborough

A19 Doncaster to Seaton Burn

A2 London to Dover (Watling Street)

A20 London to Dover

A21 London to Hastings

A22 London to Eastbourne

A23 London to Brighton

A24 London to Worthing

A25 Wrotham Heath to Guildford

A26 Maidstone to Newhaven

A27 Whiteparish to Pevensey
stdcodes.old
stdcodes.old has a total size of 93360 bytes
00 International

001 Canada

001 USA

001201 New Jersey

001202 District of Columbia

001203 Connecticut

001204 Manitoba

001205 Alabama

001206 Washington

001207 Maine

001208 Idaho

001209 California

001210 Texas

001212 New York

001213 California

001214 Texas

001215 Pennsylvania

001216 Ohio

001217 Illinois

001218 Minnesota
whc_psc.xyz
whc_psc.xyz has a total size of 533 bytes
use strict;

package whc_standard;

sub new {

	my ($class,@others) = @_;

	my %object;

	# add from @others into %object HERE

	set(\%object,@others);

	bless \%object,$class;

	}

sub get {

	my ($object,$what) = @_;

	return $$object{$what};

	}

sub set {

	my ($object,%settings) ;

	if (ref($_[1]) eq "HASH") {

		$object = $_[0];

		%settings = %{$_[1]};

	} else {

		($object,%settings) = @_;

See also:
"Getting your examples my examples and the data files after your course" on "the Horse's Mouth"
Course Booking
Subject:
Further Resources
Our Home Page
Public Course Diary
Private Course Diary
Accommodation in Melksham, Wiltshire
About Well House Consultants
Technical Articles
Tips and techniques
A Daily update - "The Horse's Mouth"
For information, resources, training by subject, please select a link from the top banner. Other resources are linked from the button bar.
WELL HOUSE CONSULTANTS LTD.: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
+44 PH: (0) 1225 708 225 • FAX: (0) 1225 707 126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho