--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;

--
-- TOC entry 2 (OID 0)
-- Name: Max OID; Type: <Init>; Schema: -; Owner: 
--

CREATE TEMPORARY TABLE pgdump_oid (dummy integer);
COPY pgdump_oid WITH OIDS FROM stdin;
61645	0
\.
DROP TABLE pgdump_oid;


SET SESSION AUTHORIZATION 'lconrad';

SET search_path = public, pg_catalog;

--
-- Data for TOC entry 6 (OID 42216)
-- Name: pga_queries; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_queries (queryname, querytype, querycommand, querytables, querylinks, queryresults, querycomments) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 7 (OID 42221)
-- Name: pga_forms; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_forms (formname, formsource) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 8 (OID 42226)
-- Name: pga_scripts; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_scripts (scriptname, scriptsource) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 9 (OID 42231)
-- Name: pga_reports; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_reports (reportname, reportsource, reportbody, reportprocs, reportoptions) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 10 (OID 42241)
-- Name: piece; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY piece (id, title, "composer id", copyright, "Directory name", "pdf filename", "ABC filename", "MIDI filename", "lilypond filename", comments, "lilypond information?") WITH OIDS FROM stdin;
17129	4	See, see, myne own sweet jewel	1	\N	music/morley/jewel	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17130	5	Joy, joy doth so arise	1	\N	music/morley/joy	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17131	7	Crewell you pull away to soone	1	\N	music/morley/cruel	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17132	9	Ladie, those eies	1	\N	music/morley/eyes	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17133	10	Hould out my hart	1	\N	music/morley/hart	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17134	12	God morrow, Fayre Ladies	1	\N	music/morley/morrow	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17135	13	Whither awaie so fast	1	\N	music/morley/whether	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17136	14	Blow, Shepherds, blow	1	\N	music/morley/blow	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17137	15	Deep lamenting	1	\N	music/morley/deep	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17138	16	Farewell disdainfull	1	\N	music/morley/farewell	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17139	17	O flye not	1	\N	music/morley/flyenot	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17140	18	Thirsis	1	\N	music/morley/thirsis	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17141	19	Now must I dye	1	\N	music/morley/now	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17142	20	Lady if I through griefe	1	\N	music/morley/lady	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17143	21	Cease mine eyes	1	\N	music/morley/cease	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17144	22	Doe you not know?	1	\N	music/morley/doeyou	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17145	23	Where art thou wanton?	1	\N	music/morley/wanton	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17146	24	What ayles my darling?	1	\N	music/morley/ayles	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17147	25	Say deere, will you not have mee?	1	\N	music/morley/deere	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17148	26	Arise, get up my deere,	1	\N	music/morley/arise	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17182	28	It was a lover and his lass	1	\N	music/morley/loverlass	allparts.pdf	allparts.abc	score.mid	\N	Trio arrangement from a lute song.	\N
17183	29	Now is the month of Maying	1	\N	music/morley/maying	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17189	31	Goe yee my canzonets	1	\N	music/morley/goye	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17190	33	When loe by break of morning	1	\N	music/morley/breakmorn	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17191	34	Sweet nymph	1	\N	music/morley/nymph	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17192	35	Fantasie: Il Doloroso	1	\N	music/morley/doloroso	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17193	36	I goe before my darling	1	\N	music/morley/igoe	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17194	37	La Girandola	1	\N	music/morley/girandola	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17195	38	Miraculous loves wounding	1	\N	music/morley/miraculous	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17196	39	Lo heere another love	1	\N	music/morley/lohere	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17197	40	Fantasie: La Rondinella	1	\N	music/morley/rondinella	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17198	41	Leave now mine eyes	1	\N	music/morley/leavenow	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17199	42	Fyre and Lightning	1	\N	music/morley/fyre	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	This is the one I used as an example in the BRS article.	\N
17200	43	Fantasie: Il Grillo?	1	\N	music/morley/grillo	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17201	44	Flora wilt thou torment mee	1	\N	music/morley/flora	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17202	45	Fantasie: Il Lamento?	1	\N	music/morley/lamento	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17203	46	In nets of golden wyers	1	\N	music/morley/wyers	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17204	47	Fantasie: La Caccia?	1	\N	music/morley/caccia	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17206	49	Fantasie: La Sampogna?	1	\N	music/morley/sampogna	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17205	48	O thou that art so cruell	1	\N	music/morley/thouthat	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17207	50	I should for griefe and anguish	1	\N	music/morley/greife	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17208	51	Fantasie: La Sirena?	1	\N	music/morley/sirena	lily/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17209	52	Fantasie: La Torello	1	\N	music/morley/torello	lilly/allparts.pdf	allparts.abc	score.mid	lily/allparts.zip	\N	\N
17231	53	Come come lets begin	2	\N	music/weelkes/begin	allparts.pdf	allparts.abc	score.mid	null	\N	\N
17232	54	Jockey thine horne pipes dull	2	\N	music/weelkes/jockey	allparts.pdf	allparts.abc	score.mid	null	\N	\N
17233	55	Some men desire spouses	2	\N	music/weelkes/spouses	allparts.pdf	allparts.abc	score.mid	null	\N	\N
17234	56	The Nightingale	2	\N	music/weelkes/nightingale	allparts.pdf	allparts.abc	score.mid	null	This is a good example of a piece which is much easier to\n\tplay if you leave the barlines out.  The bar lines make\n\tit look like there are wierd rhythms you have to count, but\n\twithout the bars, there are only notes on and off the beat.\n\tIf you listen to the MIDI file, you will hear that the rhythm\n\tis actually quite square and conventional, except that any\n\tgiven voice is playing only part of it.  It's much the hardest \n      piece to play in the London Pro Musica modern edition with\n\tscore, but if you play from facsimile or from my abc edition,\n\tit's no harder than anything else with a few eight note rests.	\N
17302	57	Never weather-beaten saile	3	f	music/campian/saile	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17309	58	Una Canzon Francese doulce memoire	5	f	music/ortiz/douce	allparts.pdf	allparts.abc	score.mid	allparts.zip	\N	\N
17311	60	Come to me grief forever	6	f	music/byrd/grief	allparts.pdf	allparts.abc	score.mid	allparts.zip	written for the funeral of Sir Philip Sydney	\N
17320	61	Die bruenlin die da fliessen	23	\N	music/bruenlin	allparts.pdf	allparts.abc	score.mid	N	\N	\N
17324	62	Conzon Terza	13	\N	music/gabrielli/terza	allparts.pdf	allparts.abc	score.mid	N	\N	\N
17328	63	Dont vient cela	9	f	music/susato/1	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17329	64	Bergeret sans roch	9	f	music/susato/2	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17336	65	Bergeret sans roch, Reprise 1	9	f	music/susato/2r1	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17338	66	Bergeret sans roch, Reprise II	9	f	music/susato/2r2	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17340	67	Reprise - Cest une dure despartie	9	f	music/susato/3	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17342	68	XIV. All ye, whom love or fortune hath betraid;	4	f	music/dowland/allye	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17344	69	1. Lacrimae Antiquae.	4	f	music/dowland/antiquae	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17346	70	XIX. Awake, sweet love, thou art returnd:	4	f	music/dowland/awake	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17348	71	XXI. Away with these selfe loving lads	4	f	music/dowland/away	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17350	72	XVIII. It was a time when silly Bees could speake,	4	f	music/dowland/bees	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17352	73	III. Behold a wonder here	4	f	music/dowland/behold	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17354	74	IX. Praise blindness eies,	4	f	music/dowland/blindness	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17356	75	VIII. Burst forth my tears	4	f	music/dowland/burst	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17358	76	IX. Goe nightly cares,	4	f	music/dowland/cares	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17360	77	VII. Deare, if you change	4	f	music/dowland/change	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17362	78	5. Lachrimae Coactae	4	f	music/dowland/coactae	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17364	79	XVII. Come again:	4	f	music/dowland/come	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17366	80	XI. Come away, come sweet love	4	f	music/dowland/comeaway	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17313	59	The eagle's force	6	\N	music/byrd/eagle	allparts.pdf	allparts.abc	score.mid		\N	\N
17368	81	IIII. If my complaints	4	f	music/dowland/complaints	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17370	82	XVI. Would my conceit, that first enforst my woe,	4	f	music/dowland/conceit	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17372	83	IX. Go crystall teares,	4	f	music/dowland/crystal	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17374	84	IIII. Daphne was not so chaste as she was changing,	4	f	music/dowland/daphne	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17376	85	IIII. Dye not beefore thy day,	4	f	music/dowland/dyenot	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17378	86	The Earle of Essex Galiard.	4	f	music/dowland/essex	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17380	87	XIII. Now cease my wandring eies,	4	f	music/dowland/eyes	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17382	88	I. Farewell too faire,	4	f	music/dowland/farewell	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17384	89	X. Thinkst thou then by thy fayning	4	f	music/dowland/fayning	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17386	90	X. If floods of teares could cleanse my follies past,	4	f	music/dowland/floods	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17388	91	II. Flow my tears	4	f	music/dowland/flow	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17390	92	II. Time stands still with gazing on her face,	4	f	music/dowland/gazing	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17392	93	3. Lachrimae Gementes	4	f	music/dowland/gementes	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17394	94	XX. Come heavy sleepe the image of true death;	4	f	music/dowland/heavy	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17396	95	XII. Fine knacks for ladies,	4	f	music/dowland/knacks	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17398	96	10. M. John Langtons Pavan	4	f	music/dowland/langton	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17400	97	XVIII. His golden locks time hath to silver turnde	4	f	music/dowland/locks	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17402	98	V. Mourne, mourne,,	4	f	music/dowland/mourne	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17404	99	2. Lachrimae Antiquae Novae	4	f	music/dowland/novae	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17406	100	VI. Now, O now, I needs must part,	4	f	music/dowland/nowonow	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17408	101	VIII. When others sings Venite exaltemus,	4	f	music/dowland/others	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17410	102	18. Captaine Digorie Piper his Galiard	4	f	music/dowland/piper	allparts.pdf	allparts.abc	score.mid		N	\N
17412	103	XII. Rest a while, you cruell cares	4	f	music/dowland/rest	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17414	104	I. I saw my Lady weepe,	4	f	music/dowland/saw	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17416	105	XVII. A shepheard in a shade	4	f	music/dowland/shepherd	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17418	106	VII. Then sit thee downe,	4	f	music/dowland/sit	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17420	107	XIII. Sleep, waiward thoughts	4	f	music/dowland/sleep	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17422	108	III. Sorrow sorrow stay,	4	f	music/dowland/sorrow	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17424	109	13. Sir John Souch his Galiard	4	f	music/dowland/souch	allparts.pdf	allparts.abc	score.mid		N	\N
17426	110	IX. What if I never speede,	4	f	music/dowland/speed	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17428	111	III.My thoughts are wingd with hopes	4	f	music/dowland/thoughts	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17430	112	VI. Times eldest sonne,	4	f	music/dowland/time	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17432	113	4. Lachrimae Tristes	4	f	music/dowland/tristes	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17434	114	I. Unquiet thoughts, your civil slaughter stint	4	f	music/dowland/unquiet	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17436	115	II. Whoever thinks or hopes of love for love	4	f	music/dowland/whoever	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17438	116	XV. Wilt thou unkind thus reave me of my heart,	4	f	music/dowland/wilt	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17440	117	X. O sweet woods the delight of solitarinesse	4	f	music/dowland/wood	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17442	118	La Deploration de la morte de Johannes Ockeghem	8	f	music/josquin/deploration	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17443	119	Mon desir	9	f	music/susato/10	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17446	120	James,	10	f	music/domouton	allparts.pdf	allparts.abc	score.mid		N	\N
17448	121	Et la la la	11	f	music/ninon/etlala	allparts.pdf	allparts.abc	score.mid		N	\N
17470	122	Fantasia Septima.	25	f	music/bicinia/septima			score.mid		N	\N
17472	123	XIIII. Come yee heavy states of night,	4	f	music/dowland/states	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25850	127	Tyrolienne	21	\N	music/arban	tyrolienne-d.pdf	tyrolienne-d.abc	score.mid	allparts.zip	Arban originally wrote a "Famous method for the cornet".\n\tI have the version which was transposed for the trombone.\n\tI have transposed this one to the right key for my D serpent.	\N
25849	126	Carnival of Venice	21	\N	music/arban	carnival-serpent.pdf	carnival-serpent.abc	score.mid	allparts.zip	Arban originally wrote a "Famous method for the cornet".\n\tI have the version which was transposed for the trombone.\n\tI have transposed this one to the right key for my D serpent.	\N
25854	128	Erbarme Dich	28	\N	music/bach	erbarme.pdf	erbarme.abc	score.mid	allparts.zip	solo violin part only	\N
25857	129	38. C'est amour qui si rare en la terre se treuve,\\\\Tierce partie.	12	f	music/bicinia/amour	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25861	130	3v. Beatus homo	25	f	music/bicinia/beatushomo	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25862	131	2r. Beatus vir	25	f	music/bicinia/beatusvir	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25863	132	37v. Deux que le trait d'Amour touche bien vivement	29	f	music/bicinia/deux	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25864	133	5r. Expectatio justorum laetitia,	25	f	music/bicinia/expectatio	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25865	134	8r. Fulgebunt justi sicut lilium	25	f	music/bicinia/fulgebunt	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25866	135	6r. Justi tulerunt spolia impiorum	25	f	music/bicinia/justi	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25867	136	5v. Justus cor suum,	25	f	music/bicinia/justus	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25869	137	39. Lungi da voi mia vita	30	f	music/bicinia/lungi	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25870	138	3r. O Maria mater pia,	7	f	music/bicinia/maria	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25871	139	4r. Oculus non vidit,	25	f	music/bicinia/oculus	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25872	140	4v. Per illud ave prolatum,	8	f	music/bicinia/perillud	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25873	141	6v. Qui sequitur me,	25	f	music/bicinia/quisequitur	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25874	142	6v. Qui vult venire post me	25	f	music/bicinia/quivult	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25875	143	7v. Sancti mei	25	f	music/bicinia/sanctimei	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25876	144	8v. Serve bone	25	f	music/bicinia/serve	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25877	145	9v. Sicut rosa	25	f	music/bicinia/sicutrosa	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25878	146	40r. Dissi a l'amata mia lucida stella	30	f	music/bicinia/stella	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25879	147	37r. Ilz ont en mesme temps	29	f	music/bicinia/temps	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25880	148	40v. La vita fugge	29	f	music/bicinia/vita	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25881	149	Fantasia Prima.	25	f	music/bicinia/prima		allparts.abc	score.mid	allparts.zip	N	\N
25883	150	10. Fantasia secunda.	31	f	music/bicinia/secunda	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25885	151	11. Fantasia tertia.	32	f	music/bicinia/tertia	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25886	152	Fantasia Quarta.	25	f	music/bicinia/quarta	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25888	153	Fantasia Quinta.	33	f	music/bicinia/quinta	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25889	154	Fantasia Sexta.	25	f	music/bicinia/sexta	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25890	155	Fantasia Septima.	25	f	music/bicinia/septima	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25892	156	Fantasia Octava.	34	f	music/bicinia/octava					N	\N
25894	157	Fantasia Nona.	35	f	music/bicinia/nona					N	\N
25896	158	Amour partes	36	f	music/heurteur/amour	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25897	159	Ancor che col partire	17	f	music/rore/ancor	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25898	160	Ancor che col partire with divisions by Bassano, Dalla Cassa, and Spadi	17	\N	music/rore/ancor	divisions.pdf	divisions.abc	score.mid	divisions.ly	The way to practice these divisions is to play a piece of\n\tthe tune, and then see if you can play the corresponding piece\n\t  of the division so that it <em>enhances</em> the tune,\n\t  rather than detracting from it.  I find this difficult, even\n\t  if I know the tune by heart, when the correspondences aren't\n\t  indicated in the division.  Also, putting three divisions in\n\t  score like this lets you compare, contrast, and switch from\n\t  one to the other, so that you can play what lies more easily\n\t  under your fingers.	\N
25899	161	Lamentation over Boston	19	f	music/billings/lamentation	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25900	162	Africa	19	\N	music/billings/africa	bill-afr.pdf	allparts.abc	score.mid	bill-afr.ly	The notes are as transcribed by Rafel Ornes at <a\nhref="http://www.cpdl.org/">CPDL.org</a>.  But he only did one verse,\nand when we sang it at a party people complained, so Anne Kaslauskas\nsent me all six verses of the original Isaac Watts poem. (The Sacred\nHarp only used the first three, for obvious reasons, but our purposes\nare different from theirs.) The original\netf file and the MIDI file from that are available at cpdl.org; this is courtesy of etf2ly,\navailable as part of <a href="http://www.lilypond.org">lilypond</a>.	\N
25902	163	Watchman, tell us of the night	37	\N	music/carols/watchman/	score.pdf	score.abc	score.midi	score.ly	\N	\N
25904	164	Adoramus te	38	\N	music/carols/adoramus	pal-ador.pdf	allparts.abc	score.mid	pal-ador.ly	from http://cpdl.org, via etf2ly	\N
25906	165	Personent hodie	39	t	music/carols/personent	allparts.pdf	PersonentHodie.abc	score.mid	PersonentHodie.ly	\N	\N
25914	166	XXI. Cleare or cloudie sweet as Aprill showring,	4	f	stable-music/dowland/clear	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25916	167	XX. Tosse not my soule	4	f	stable-music/dowland/tosse	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25917	168	April is in my Mistress's face	1	f	music/morley/april	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25930	169	Courant, of Harte diefje vaerom zoo stil	40	\N	music/vaneyck	harte-d.pdf	harte-d.abc	score.mid	allparts.zip	van Eyck wrote some of the first music ever written for\n\tsoprano recorder.  The serpent likes this one in G better than\n\tin C.  It's the tune Dowland set as "Now, o\n\tnow I needs must part, which is also known as "The Frog\n\tGalliard".  The original transcription was by Frank Nordberg.	\N
25931	170	Maxixe	22	\N	music/dance/	maxixe.pdf	maxixe.abc	maxixe.mid	allparts.zip	This one I got on a scribbled sheet from my recorder teacher,\n    who can't quite remember where he got it from.  We were jamming on\n    Bergamasca (what some people in the Renaissance called the I IV V\n    I chord sequence), and he thought it would be fun to use some\n    material we didn't think up ourselves</p>\n    <p>I have no information about the copyright status of this\n    particular piece.  The dance was popular in Brazil in the 19th\n    century, and enjoyed a brief vogue in North America and Europe\n    during the ragtime era.  The references to published Maxixe's on\n    the web are from dates like 1912 and 1914.  So I'm guessing that\n    this is out of copyright, but if you have information to the\n    contrary (or any information about the source), please let me\n    know, and I will do the appropriate thing.</p>\n    <p>The chords in the MIDI file are automatically generated by abc2midi.	\N
25934	171	Der Ratten schwanz	22	f	music/glogauer/113	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25938	172	Hastu mir die laute bracht -- O rosa bella	22	f	music/glogauer/117	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25941	173	Wer da sorget -- O rosa bella	22	f	music/glogauer/118	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25944	174	In feuers hitz -- O rosa bella	22	f	music/glogauer/119	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25947	175	Die Katzenpfote	22	f	music/glogauer/13	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25950	176	Ich bins erfreut	22	f	music/glogauer/206	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25956	178	Carmen -- Paulus de Broda	22	f	music/glogauer/23					N	\N
25959	179	Elselein	22	f	music/glogauer/250	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25962	180	Die welt, die hat einen tummen sin	22	f	music/glogauer/256	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25965	181	Bruder konrad	22	f	music/glogauer/46	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25968	182	Ich sachs eins mals	22	f	music/glogauer/47					N	\N
25971	183	Es leit ein schlo_ss	22	f	music/glogauer/50	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25977	185	Du lenze gut	22	f	music/glogauer/92	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
17149	27	Love learns by laughing	1	\N	music/morley/lovelearns	allparts.pdf	allparts.abc	score.mid	allparts.zip	This one does not appear in the 1593 edition, and is taken from the 1606 edit\nion.	\N
17184	30	Leave alas this tormenting	1	\N	music/morley/tormenting	allparts.pdf	allparts.abc	score.mid		\N	\N
25980	186	Hastu mir die laute bracht -- O rosa bella (transposed a fourth up)	22	f	music/glogauer/117/fourthup	allparts.pdf	allparts.abc	score.mid		N	\N
25983	187	In feuers hitz -- O rosa bella (transposed a fourth up)	22	f	music/glogauer/119/fourthup	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
25986	188	Wer da sorget -- O rosa bella (transposed a fourth up)	22	f	music/glogauer/118/fourthup	allparts.pdf				N	\N
33891	189	La Deploration de la morte de Johannes Ockeghem (Original key)	8	f		allparts.pdf			allparts.zip	N	\N
33892	190	Riu, riu chiu	22	\N	music/villancicos/riu	riu.pdf	riu.abc	score.mid	allparts.zip	\N	\N
33895	191	[1] Jennette, Marion se vont jouer	22	f		allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
33899	192	[6] Au pre de vous secretement demeure (three parts)	42	f		allparts.pdf	allparts.abc	score.mid		N	\N
33902	193	Auprhs de vous (two parts)	42	f		allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
33903	194	[23] Si mon malheur my continue	42	f		allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
33907	195	Amy, souffrez que je vous aime (three parts)	22	f		allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
33910	196	Amy souffres que je vous aime (two parts)	22	f		allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
33911	197	A Division on a Ground by Mr. Finger	16	\N	music/divflute	finger.pdf	finger.abc	finger.mid	allparts.zip	\N	\N
33913	198	Cantabile from the C major Sonata	18	\N	music/telemann/cmajorsonata	cantabile.pdf	cantabile.abc	cantabile.mid	allparts.zip	\N	\N
33916	200	Knives and Forks	22	\N	music/dance	knivesforks.pdf	knivesforks.abc	knivesforks.mid	allparts.zip	Arranged by Laura Conrad and Frank Nordberg	\N
33915	199	Receuil de Contredances	43	\N	music/dance	feuillet.pdf	feuillet.abc	score.mid	allparts.zip	edited by Pat Shaw	\N
25848	125	Row, row, row your boat	7	\N	music/allkeys	allparts.pdf	row.abc	row.midi	row.ly	\N	\N
25847	124	Bransle	27	\N	music/allkeys		bransle.abc	bransle.midi	bransle.ly	\N	\N
33917	201	From Orchesographie	41	\N	music/dance	arbeau.pdf	arbeau.abc	score.mid	allparts.zip	<p>It's surprising that there isn't a performing edition of the\n    music in this book.  You can't play directly from the book no\n    matter how good you are at improvising arrangements or how much\n    you know about 16th century notation, because the notes are\n    sideways.  I found <a\n    href="http://users.erols.com/eacain/dance/Arbeau1.html">this\n    link</a> after transcribing some of this, so there are only bass\n    lines for the ones that I didn't already have.</p><p>Frank Nordberg, the webmaster of <a\n      href="http://www.musicaviva.com">musicaviva.com</a> has transcribed\n      a slightly different set of these dances: <a\n      href="music/dance/franks_arbeau.abc">ABC</a>,\n\t<a href="music/dance/franks_arbeau.pdf">PDF</a>.</li>\n      <li>And Steve Mansfield has made available an <a\n      href="http://www.lesession.demon.co.uk/Orchesography.abc">ABC\n      file</a> of all 50 tunes from the book.</p>\n    <ul>	\N
33921	202	Tappster,  dryngker	7	f	music/drinking/tappster	allparts.pdf	allparts.abc	score.midi	allparts.zip	N	\N
33953	230	Es wollt ein Fraw zum Weine gahn	53	f	music/drinking/fraw	allparts.pdf	allparts.abc	score.midi	allparts.zip	N	\N
33925	210	Down with Bacchus	44	\N	music/drinking/book	drinking.pdf	bacchus.abc	bacchus.midi	bacchus.ly	\N	\N
33927	212	Fie, nay, prithee, John	44	\N	music/drinking/book	drinking.pdf	fie.abc	fie.midi	fie.ly	\N	\N
33926	211	I gave her cakes and I gave her ale	44	\N	music/drinking/book	drinking.pdf	cakes.abc	cakes.midi	cakes.ly	\N	\N
33928	213	The glass was just timed	44	\N	music/drinking/book	drinking.pdf	glass.abc	glass.midi	glass.ly	\N	\N
33929	214	Here's a health, pray let it pass about,	44	\N	music/drinking/book	drinking.pdf	health.abc	health.midi	health.ly	\N	\N
33930	215	He that drinks is immortal	44	\N	music/drinking/book	drinking.pdf	immortal.abc	immortal.midi	immortal.ly	\N	\N
33931	216	Wine in a  morning	44	\N	music/drinking/book	drinking.pdf	morning.abc	morning.midi	morning.ly	\N	\N
33932	217	'Tis women	44	\N	music/drinking/book	drinking.pdf	women.abc	women.midi	women.ly	\N	\N
33934	218	Banbury Ale	45	\N	music/drinking/book	drinking.pdf	banbury.abc	banbury.midi	banbury.ly	\N	\N
33935	219	Hey Ho, nobody at home (3 parts)	45	\N	music/drinking/book	drinking.pdf	heyho3.abc	heyho3.midi	heyho3.ly	\N	\N
33936	220	Hey Ho, nobody at home (5 parts)	45	\N	music/drinking/book	drinking.pdf	heyho.abc	heyho.midi	heyho.ly	\N	\N
33941	223	Let us drink and be merry	47	\N	music/drinking/book	drinking.pdf	claret.abc	claret.midi	claret.ly	\N	\N
33939	222	Care, thou canker of our joys	46	\N	music/drinking/book	drinking.pdf	care.abc	care.midi	care.ly	From Kentish Harmony (1821)	\N
33943	224	Confusion to the pow'r of Cupid	48	\N	music/drinking/book	drinking.pdf	confusion.abc	confusion.midi	confusion.ly	\N	\N
33945	225	Call George againe	49	\N	music/drinking/book	drinking.pdf	george.abc	george.midi	george.ly	\N	\N
33947	226	Tom Jolly's nose	50	\N	music/drinking/book	drinking.pdf	jolly.abc	jolly.midi	jolly.ly	\N	\N
33949	228	Slaves are they that heap up mountains	51	\N	music/drinking/book	drinking.pdf	slaves.abc	slaves.midi	slaves.ly	\N	\N
33951	229	In Praise of White Wine	52	\N	music/drinking/book	drinking.pdf	whitewine.abc	whitewine.midi	whitewine.ly	\N	\N
33938	221	A boat, a boat!	46	\N	music/drinking/book	drinking.pdf	boat.abc	boat.midi	boat.ly	\N	\N
34003	232	[3] C'est une dure despartie (original key)	42	f	stable-music/gardane/despartie/original	allparts.pdf				N	\N
34000	231	[3] C'est une dure despartie (transposed up a fifth)	42	f	stable-music/gardane/despartie	allparts.pdf	allparts.abc	score.mid	allparts.zip		\N
34010	234	[30] Changeons propos, c'est trop chante d'amours (Original key)	42	f	music/gardane/propos/original	allparts.pdf			allparts.zip	N	\N
34014	235	[17] Quant je boy du vin claret tout tourne	36	f	music/gardane/vin	allparts.pdf	allparts.abc	score.midi	allparts.zip	N	\N
34020	236	[18] Vignon, vignon, vignon, vignette (original key)	42	f	music/gardane/vignon/original	allparts.pdf				N	\N
34021	237	[18] Vignon, vignon, vignon, vignette (transposed)	42	f	music/gardane/vignon	allparts.pdf	allparts.abc	score.mid	allparts.zip	N	\N
\.


--
-- Data for TOC entry 11 (OID 42253)
-- Name: pga_layout; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_layout (tablename, nrcols, colnames, colwidth) WITH OIDS FROM stdin;
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
42297	public.composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
42298	public.book	11	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments html	150 150 150 150 150 150 150 150 150 150 150
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
42330	public.piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
17088	composer	8	{composer id} {first name} {last name} {date of birth} {date of death} country website comments	150 150 150 150 150 150 150 150
17125	book	10	{book id} title author copyright date directory {pdf file} {MIDI file} {source file} comments	150 150 150 150 150 150 150 150 150 150
17160	Book Pieces Table	3	{Book ID} {Piece ID} {Ordinal}	150 150 150
17252	pg_database	9	datname datdba encoding datistemplate datallowconn datlastsysoid datvacuumxid datfrozenxid datpath	150 150 150 150 150 150 150 150 150
17253	pga_reports	5	reportname reportsource reportbody reportprocs reportoptions	150 150 150 150 150
17306	nolayoutneeded	2	{Book ID} {Piece ID}	150 150
17076	piece	11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} {comments} {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
25937	select title from piece where id  = 171	1	title	150
33975		11	id title {composer id} copyright {Directory name} {pdf filename} {ABC filename} {MIDI filename} {lilypond filename} comments {lilypond information?}	150 150 150 150 150 150 150 150 150 150 150
42333	public.Book Pieces Table	3	{Book ID} {Piece ID} Ordinal	150 150 150
\.


--
-- Data for TOC entry 12 (OID 42260)
-- Name: composer; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY composer ("composer id", "first name", "last name", "date of birth", "date of death", country, website, comments) WITH OIDS FROM stdin;
17089	1	Thomas	Morley	\N	\N	England	\N	\N
17091	2	Thomas	Weelkes	\N	\N	England	\N	\N
17095	5	Diego	Ortiz	\N	\N	Spain, Italy	\N	\N
17094	4	John	Dowland	\N	\N	England, Denmark	\N	\N
17092	3	Thomas	Campian	\N	\N	England, Scotland	\N	\N
17096	6	William	Byrd	\N	\N	England	\N	\N
17097	7		Anonymous	\N	\N	\N	\N	\N
17098	8	Josquin	des Prez	\N	\N	Flanders	\N	\N
17099	9	Tielman	Susato	\N	\N	\N	\N	\N
17100	10	\N	Petrucci	\N	\N	\N	\N	\N
17102	12	Petrus	Phalesius	\N	\N	\N	\N	He's not really a composer, so move him to publishers if there's ever a publisher's table
17103	13	Giovanni	Gabrielli	\N	\N	Italy	\N	\N
17104	14	\N	Gardane	\N	\N	France	\N	\N
17105	15	Le Roy	Ballard	\N	\N	France	\N	Also really publishers.
17106	16	\N	Finger	\N	\N	England	\N	\N
17107	17	Cipriano	da Rore	1515	1565	Italy	\N	\N
17108	18	Georg Phillip	Telemann	\N	\N	Germany, France	\N	\N
17109	19	William	Billings	\N	\N	USA	\N	\N
17111	21		Arban	\N	\N	France	\N	\N
17112	22	\N	Unknown	\N	\N	\N	\N	\N
17317	23	Balthazar	Arthopius	\N	\N	Germany	\N	\N
17327	24	Jacob	van Eyck	\N	\N	Netherlands	\N	\N
17110	20	John	Playford	\N	\N	England	\N	\N
17468	25	Roland	Lassus	\N	\N	Flanders, Italy	\N	\N
25811	26	Laura	Conrad	1951	0	USA	http://www.laymusic.org	really an editor
25846	27	Michael	Praetorius	\N	\N	Germany	\N	\N
25851	28	Johann Sebastian	Bach	1685	1750	Germany	\N	\N
25855	29	Andre	Pevernage	\N	\N	\N	\N	\N
25868	30	Cornelio	Vendonck	\N	\N	\N	\N	\N
25882	31	Giovanni	de Antiquis	\N	\N	\N	\N	\N
25884	32	B.	Lupachino	\N	\N	\N	\N	\N
25887	33	Giovanni Maria	Tasso	\N	\N	\N	\N	\N
25891	34	Fabritio	Facciola	\N	\N	\N	\N	\N
25893	35	Oratio	de Martino	\N	\N	\N	\N	\N
25895	36	\N	Heurteur	\N	\N	\N	\N	\N
25901	37	Joseph	Parry	\N	\N	\N	\N	\N
25903	38	\N	Palestrina	\N	\N	\N	\N	\N
25905	39	Gustav	Holst	\N	\N	England	\N	\N
25927	40	Jacob	van Eyck	1589	1657	Netherlands	http://www.fourwinds.demon.nl/jacobvaneyck.htm	\N
25932	41	Thoinet	Arbeau	\N	\N	\N	\N	\N
17101	11	\N	Ninot le petit	\N	\N	\N	\N	\N
33898	42	Claudin de	Sermisy	\N	\N	France	\N	\N
33914	43	\N	Feuillet	\N	\N	France	\N	\N
33924	44	Henry	Purcell	1659	1695	English	\N	\N
33933	45	Thomas	Ravenscroft	\N	\N	\N	\N	\N
33937	46	John	Jenkins	1592	1678	England	\N	\N
33940	47	George	Berg	\N	1771	England	\N	\N
33942	48	John	Eccles	1661	1735	England	\N	\N
33944	49	John	Hilton	1599	1657	England	\N	\N
33946	50	Henry	Aldrich	1647	1710	England	\N	\N
33948	51	John Stafford	Smith	1750	1826	England	\N	\N
33950	52	John	Reading	\N	\N	England	\N	\N
33952	53	Ludwig	Senfl	\N	\N	Germany	\N	\N
\.


--
-- Data for TOC entry 13 (OID 42270)
-- Name: book; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY book ("book id", title, author, copyright, date, directory, "pdf file", "MIDI file", "source file", comments, html) WITH OIDS FROM stdin;
17185	5	Ballets to Five Voyces	1	\N	\N	music/morley/5v	\N	\N	\N	\N	\N
17188	6	The First Booke of Canzonets to two voyces	1	\N	\N	music/morley/2v-lily	can2v-pdf.zip	\N	can2v-src.zip	\N	can2v.html
17230	7	Ayres or Phantastiicke Spirites for three voices	2	\N	\N	music/weelkes/aps	\N	\N	\N	\N	\N
17244	8	The First Booke of Songs or ayres of foure\n    parts, with Tableture for the Lute	4	\N	\N	music/dowland/book	dowland-I.pdf	dowland-MIDI.zip	dowland-source.zip	\N	dowland-I.html
17245	9	The Second Booke of Songs or Ayres of\n    2. 4. and 5.\n    parts, with Tableture for the Lute or Orpherian, with the Violl de Gamba	4	\N	\N	music/dowland/book	dowland.pdf	dowland-MIDI.zip	dowland-source.zip	\N	dowland-II.html
17246	10	The Third and Last Booke of Songs or Aires.\n    Newly composed to sing to the Lute, Orpharion, or viols, and a\n    dialogue for a base and meane Lute with five voices to sing\n    thereto	4	\N	\N	music/dowland/book	dowland.pdf	dowland-MIDI.zip	dowland-source.zip	\N	\N
17247	12	Lachrimae, or Seaven Teares figured in\n    Seaven Passionate Pavans, with divers other Pavans, Galiards, and\n    Almands, set forth for the Lute, Viols, or violons, in five\n    parts	4	\N	\N	music/dowland/book	dowland.pdf	dowland-MIDI.zip	dowland-source.zip	\N	\N
17248	13	A Pilgrimes Solace.  Wherein is contained\n    Musicall Harmonie fo 3. 4. and 5. parts, to be sung and plaid wiht\n    the Lute and Viols	4	\N	\N	music/dowland/book	dowland.pdf	dowland-MIDI.zip	dowland-source.zip	\N	\N
17301	14	Two books of Ayres	3	\N	\N	music/campian/ayres	\N	\N	\N	\N	\N
17307	15	El Primo Libro	5	\N	1553	music/ortiz/primo	\N	\N	\N	\N	\N
17308	17	Psalmes, Songs, and Sonnets	6	\N	1611	music/byrd/pss	\N	\N	\N	\N	\N
17318	18	Gassenhawerlin	23	\N	1535	music/arthopius/gassenhawerlin	\N	\N	\N	\N	\N
17333	19	Danseryes	9	\N	1551	music/susato/book	susato.pdf	susato-midi.zip	susato-src.zip	ABC transcription by Frank Nordberg, http://www.musicaviva.com	\N
17445	21	Odhecaton	10	\N	\N	music/petrucci/odhecaton	\N	\N	\N	\N	\N
17126	1	Canzonets or little short songs to three voyces	1	\N	\N	music/morley/3v	3v-pdf.zip	MIDI.zip	lilypond-src.zip	\N	\N
25813	23	Drinking Songs	26	\N	2002	music/drinking/book	drinking.pdf	\N	\N	\N	\N
25852	24	Famous Method for the Cornet	21	\N	\N	music/arban		\N	\N	\N	\N
25853	25	Saint Matthew Passion	28	\N	\N	music/bach	\N	\N	\N	\N	\N
25856	26	Bicinia -- Chansons	12	\N	1609	music/bicinia/chansons	chansons.pdf	chansons-midi.zip	chansons-src.zip	\N	bicinia.html
25860	27	Bicinia -- Motets	12	\N	1609	music/bicinia/motets	motets.pdf	motets-midi.zip	motets-src.zip	\N	bicinia.html
17469	22	Bicinia -- Fantasias	12	\N	1609	stable-music/bicinia/fantasias	fandasias.pdf	\N	\N	\N	bicinia.html
25907	28	Carols for parties	26	t	0	music/carols	carols.pdf	\N	\N	\N	\N
25928	29	Der fluyten lust-hof	40	\N	1644	music/fromweb/frank/vaneyck	\N	\N	\N	\N	\N
25933	30	Glogauer Liederbuch	22	\N	1480	music/glogauer/book	glogauer.pdf	glogauer-midi.zip	\N	\N	\N
33894	31	Three part chansons	14	\N	1541	music/gardane/book	\N	\N	\N	\N	\N
33906	32	Tiers livre de chansons	15	\N	1553	music/tierslivre/book	\N	\N	\N	\N	\N
\.


--
-- Data for TOC entry 14 (OID 42281)
-- Name: Book Pieces Table; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY "Book Pieces Table" ("Book ID", "Piece ID", "Ordinal") WITH OIDS FROM stdin;
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
17236	7	54	\N
17237	7	56	\N
17238	7	55	\N
17161	1	4	I
17162	1	5	II
17163	1	7	III
17164	1	9	IIII
17165	1	10	V
17166	1	12	VI
17167	1	13	VII
17168	1	14	VIII
17169	1	15	IX
17170	1	16	X
17171	1	17	XI
17172	1	18	XII
17173	1	19	XIII
17174	1	20	XIIII
17175	1	21	XV
17176	1	22	XVI
17177	1	23	XVII
17178	1	24	XVIII
17179	1	25	XVIIII
17180	1	26	XX
17181	1	27	XXI
17186	5	29	
17187	5	30	
17210	6	31	I
17211	6	33	II
17212	6	34	III
17213	6	35	IIII
17214	6	36	V
17215	6	37	VI
17216	6	38	VII
17217	6	39	VIII
17218	6	40	VIIII
17219	6	41	X
17220	6	42	XI
17221	6	43	XII
17222	6	44	XIII
17223	6	45	XIIII
17224	6	46	XV
17225	6	47	XVI
17228	6	50	XVII
17227	6	51	XVIII
17229	6	52	XVIIII
17235	7	53	
17303	14	57	\N
17310	15	58	\N
17312	16	60	\N
17334	19	63	1
17335	19	64	2
17337	19	65	2r1
17339	19	66	2r2
17341	19	67	3
17343	8	68	\N
17345	12	69	\N
17347	8	70	\N
17349	8	71	\N
17351	10	72	\N
17353	10	73	\N
17355	9	74	\N
17357	8	75	\N
17359	13	76	\N
17361	8	77	\N
17363	12	78	\N
17365	8	79	\N
17367	8	80	\N
17369	8	81	\N
17371	8	82	\N
17373	8	83	\N
17375	10	84	\N
17377	9	85	\N
17379	12	86	\N
17381	9	87	\N
17383	10	88	\N
17385	8	89	\N
17387	9	90	\N
17389	9	91	\N
17391	10	92	\N
17393	12	93	\N
17395	9	94	\N
17397	9	95	\N
17399	12	96	\N
17401	8	97	\N
17403	9	98	\N
17405	12	99	\N
17407	8	100	\N
17409	9	101	\N
17411	12	102	\N
17413	8	103	\N
17415	9	104	\N
17417	9	105	\N
17419	9	106	\N
17421	8	107	\N
17423	9	108	\N
17425	12	109	\N
17427	10	110	\N
17429	8	111	\N
17431	9	112	\N
17433	12	113	\N
17435	8	114	\N
17437	8	115	\N
17439	8	116	\N
17441	9	117	\N
17444	19	119	\N
17447	21	120	\N
17471	22	122	\N
17473	9	123	\N
25858	2	129	\N
25859	6	129	\N
25915	9	166	\N
25935	2	171	\N
25936	2	171	\N
25939	2	172	\N
25940	2	172	\N
25942	2	173	\N
25943	2	173	\N
25945	2	174	\N
25946	2	174	\N
25948	2	175	\N
25949	2	175	\N
25951	2	176	\N
25952	2	176	\N
25954	2	177	\N
25955	2	177	\N
25957	2	178	\N
25958	2	178	\N
25960	2	179	\N
25961	2	179	\N
25963	2	180	\N
25964	2	180	\N
25966	2	181	\N
25967	2	181	\N
25969	2	182	\N
25970	2	182	\N
25972	2	183	\N
25973	2	183	\N
25975	2	184	\N
25976	2	184	\N
25978	2	185	\N
25979	2	185	\N
25981	2	186	\N
25982	2	186	\N
25984	2	187	\N
25985	2	187	\N
25987	2	188	\N
25988	2	188	\N
33893	28	190	\N
33896	3	191	\N
33897	1	191	\N
33900	3	192	\N
33901	1	192	\N
33904	3	194	\N
33905	1	194	\N
33908	3	195	\N
33909	2	195	\N
33954	23	230	\N
33956	23	210	\N
33922	23	202	\N
33958	23	211	\N
33959	23	212	\N
33960	23	213	\N
33961	23	214	\N
33962	23	215	\N
33964	23	217	\N
33965	23	218	\N
33966	23	219	\N
33967	23	220	\N
33968	23	221	\N
33969	23	222	\N
33970	23	224	\N
33971	23	225	\N
33963	23	216	
33972	23	226	\N
33973	23	228	\N
33974	23	229	\N
34001	31	231	\N
34004	31	232	\N
34011	31	234	\N
34012	23	234	\N
34013	31	233	\N
34015	31	234	\N
34016	23	234	\N
34022	31	236	\N
34023	23	236	\N
\.


--
-- Data for TOC entry 15 (OID 42289)
-- Name: piece part table; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY "piece part table" ("piece id", "part name", range) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 16 (OID 42291)
-- Name: piece relationship table; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY "piece relationship table" (pieceid, related_pieceid, relationship) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 17 (OID 42299)
-- Name: pga_graphs; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_graphs (graphname, graphsource, graphcode) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 18 (OID 42306)
-- Name: pga_images; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_images (imagename, imagesource) WITH OIDS FROM stdin;
\.


--
-- Data for TOC entry 19 (OID 42313)
-- Name: pga_diagrams; Type: TABLE DATA; Schema: public; Owner: lconrad
--

COPY pga_diagrams (diagramname, diagramtables, diagramlinks) WITH OIDS FROM stdin;
\.


--
-- TOC entry 3 (OID 42258)
-- Name: composer_composer id_seq; Type: SEQUENCE SET; Schema: public; Owner: lconrad
--

SELECT pg_catalog.setval('"composer_composer id_seq"', 9, true);


--
-- TOC entry 4 (OID 42268)
-- Name: book_book id_seq; Type: SEQUENCE SET; Schema: public; Owner: lconrad
--

SELECT pg_catalog.setval('"book_book id_seq"', 22, true);


--
-- TOC entry 5 (OID 42293)
-- Name: piece_id_sequence; Type: SEQUENCE SET; Schema: public; Owner: lconrad
--

SELECT pg_catalog.setval('piece_id_sequence', 63, false);


