JAZZ_table.sql

--JAZZ STANDARDS DATABASE
--Kristina Gavin Bigsby 
--Data collected from Jazz Standard Repertoire (https://standardrepertoire.com/) and Jazz Standards (https://www.jazzstandards.com/)

--DROP TABLES
DROP TABLE CREDITS;
DROP TABLE WRITERS;
DROP TABLE SONGS;
DROP TABLE WORKS;

--CREATE TABLES
CREATE TABLE WORKS (
    WorkID CHAR(5) NOT NULL,
    Title VARCHAR2(100) NOT NULL,
    WorkType VARCHAR2(25) NOT NULL CHECK (WorkType IN ('Film','Musical','Opera','Operetta')),
    CONSTRAINT WORKS_PK PRIMARY KEY (WorkID)
);

CREATE TABLE SONGS (
    SongID CHAR(5) NOT NULL,
    Song VARCHAR2(100) NOT NULL,
    Year NUMBER(4,0) NOT NULL CHECK (Year BETWEEN 1000 AND 9999),
    WorkID CHAR(5),
    TimeSignature NUMBER(2,0) NOT NULL CHECK (TimeSignature > 0),
    KeySignature VARCHAR2(25) NOT NULL CHECK (KeySignature IN ('A', 'A minor', 'Ab', 'Ab minor', 'B', 'B minor', 'Bb', 'Bb minor', 'C', 'C minor', 'C#', 'C# minor', 'D', 'D minor', 'Db', 'Db minor', 'E', 'E minor', 'Eb', 'Eb minor', 'F', 'F minor', 'F#', 'F# minor', 'G', 'G minor', 'Gb', 'Gb minor')),
    Bars NUMBER(2,0) NOT NULL CHECK (Bars > 0),
    Form VARCHAR2(10),
    Style VARCHAR2(10) NOT NULL CHECK (Style IN ('Bossa','Latin','Waltz','Bebop','Ballad','Gospel','Blues','Mambo','Modal','Funk','Swing')),
    Lyrics VARCHAR2(25),
    Ranking NUMBER(4,0) CHECK (Ranking BETWEEN 1 AND 1000),
    Calls NUMBER(3,0) NOT NULL CHECK (Calls >= 0),
    ContrafactID CHAR(5),
    CONSTRAINT SONGS_PK PRIMARY KEY (SongID),
    CONSTRAINT SONGS_FK1 FOREIGN KEY (WorkID) REFERENCES WORKS (WorkID),
    CONSTRAINT SONGS_FK2 FOREIGN KEY (ContrafactID) REFERENCES SONGS (SongID)
);

CREATE TABLE WRITERS (
    WriterID CHAR(5) NOT NULL,
    FirstName VARCHAR2(25) NOT NULL,
    MiddleName VARCHAR2(25),
    LastName VARCHAR2(25) NOT NULL,
    SuffixName VARCHAR2(5),
    Born NUMBER(4,0) CHECK (Born BETWEEN 1000 AND 9999),
    Died NUMBER(4,0) CHECK (Died BETWEEN 1000 AND 9999),
    Sex CHAR(1),
    Race VARCHAR2(25),
    Birthplace VARCHAR2(25),
    CONSTRAINT WRITERS_PK PRIMARY KEY (WriterID)
);

CREATE TABLE CREDITS (
    SongID CHAR(5) NOT NULL,
    WriterID CHAR(5) NOT NULL,
    Credit VARCHAR2(10) NOT NULL CHECK (Credit IN ('Music','Lyrics')),
    CONSTRAINT CREDITS_PK PRIMARY KEY (SongID, WriterID, Credit),
    CONSTRAINT CREDITS_FK1 FOREIGN KEY (SongID) REFERENCES SONGS (SongID),
    CONSTRAINT CREDITS_FK2 FOREIGN KEY (WriterID) REFERENCES WRITERS (WriterID)
);

--INSERT DATA
INSERT INTO WORKS VALUES ('W0001','Lady, Be Good','Musical');
INSERT INTO WORKS VALUES ('W0002','No, No, Nanette','Musical');
INSERT INTO WORKS VALUES ('W0003','Oh, Kay!','Musical');
INSERT INTO WORKS VALUES ('W0004','Betsy','Musical');
INSERT INTO WORKS VALUES ('W0005','Funny Face','Musical');
INSERT INTO WORKS VALUES ('W0006','The Threepenny Opera','Opera');
INSERT INTO WORKS VALUES ('W0007','The New Moon','Operetta');
INSERT INTO WORKS VALUES ('W0008','Whoopee!','Musical');
INSERT INTO WORKS VALUES ('W0009','Wake Up and Dream','Musical');
INSERT INTO WORKS VALUES ('W0010','Marianne','Film');
INSERT INTO WORKS VALUES ('W0011','Great Day','Musical');
INSERT INTO WORKS VALUES ('W0012','Girl Crazy','Musical');
INSERT INTO WORKS VALUES ('W0013','The New Yorkers','Musical');
INSERT INTO WORKS VALUES ('W0014','Everybody''s Welcome','Musical');
INSERT INTO WORKS VALUES ('W0015','Music in the Air','Musical');
INSERT INTO WORKS VALUES ('W0016','Flying Colors','Musical');
INSERT INTO WORKS VALUES ('W0017','Gay Divorce','Musical');
INSERT INTO WORKS VALUES ('W0018','Dinner at Eight','Film');
INSERT INTO WORKS VALUES ('W0019','Let''s Fall in Love','Film');
INSERT INTO WORKS VALUES ('W0020','Roberta','Musical');
INSERT INTO WORKS VALUES ('W0021','The Hollywood Revue','Film');
INSERT INTO WORKS VALUES ('W0022','Thumbs Up!','Musical');
INSERT INTO WORKS VALUES ('W0023','Porgy and Bess','Opera');
INSERT INTO WORKS VALUES ('W0024','Jumbo','Musical');
INSERT INTO WORKS VALUES ('W0025','Top Hat','Film');
INSERT INTO WORKS VALUES ('W0026','Jubilee','Musical');
INSERT INTO WORKS VALUES ('W0027','Swing Time','Film');
INSERT INTO WORKS VALUES ('W0028','Pennies from Heaven','Film');
INSERT INTO WORKS VALUES ('W0029','Shall We Dance','Film');
INSERT INTO WORKS VALUES ('W0030','Babes in Arms','Musical');
INSERT INTO WORKS VALUES ('W0031','A Damsel in Distress','Film');
INSERT INTO WORKS VALUES ('W0032','I''d Rather Be Right','Musical');
INSERT INTO WORKS VALUES ('W0033','Goldwyn Follies','Film');
INSERT INTO WORKS VALUES ('W0034','Snow White and the Seven Dwafs','Film');
INSERT INTO WORKS VALUES ('W0035','Easy Living','Film');
INSERT INTO WORKS VALUES ('W0036','Going Places','Film');
INSERT INTO WORKS VALUES ('W0037','The Wizard of Oz','Film');
INSERT INTO WORKS VALUES ('W0038','Knickerbocker Holiday','Musical');
INSERT INTO WORKS VALUES ('W0039','Too Many Girls','Musical');
INSERT INTO WORKS VALUES ('W0040','Yokel Boy','Musical');
INSERT INTO WORKS VALUES ('W0041','Very Warm for May','Musical');
INSERT INTO WORKS VALUES ('W0042','Pal Joey','Musical');
INSERT INTO WORKS VALUES ('W0043','Keep ''Em Flying','Film');
INSERT INTO WORKS VALUES ('W0044','The Fleet''s In','Film');
INSERT INTO WORKS VALUES ('W0045','Sun Valley Serenade','Film');
INSERT INTO WORKS VALUES ('W0046','Iceland','Film');
INSERT INTO WORKS VALUES ('W0047','I Dood It','Film');
INSERT INTO WORKS VALUES ('W0048','One Touch of Venus','Musical');
INSERT INTO WORKS VALUES ('W0049','The Sky''s the Limit','Film');
INSERT INTO WORKS VALUES ('W0050','Mexican Hayride','Musical');
INSERT INTO WORKS VALUES ('W0051','Thrill of a Romance','Film');
INSERT INTO WORKS VALUES ('W0052','Belle of the Yukon','Film');
INSERT INTO WORKS VALUES ('W0053','And the Angels Sing','Film');
INSERT INTO WORKS VALUES ('W0054','State Fair','Film');
INSERT INTO WORKS VALUES ('W0055','Laura','Film');
INSERT INTO WORKS VALUES ('W0056','Les Portes de la nuit','Film');
INSERT INTO WORKS VALUES ('W0057','Jennifer','Film');
INSERT INTO WORKS VALUES ('W0058','St. Louis Woman','Musical');
INSERT INTO WORKS VALUES ('W0059','The Uninvited','Film');
INSERT INTO WORKS VALUES ('W0060','Road to Rio','Film');
INSERT INTO WORKS VALUES ('W0061','Romance on the High Seas','Film');
INSERT INTO WORKS VALUES ('W0062','Night Has a Thousand Eyes','Film');
INSERT INTO WORKS VALUES ('W0063','My Foolish Heart','Film');
INSERT INTO WORKS VALUES ('W0064','Guys and Dolls','Musical');
INSERT INTO WORKS VALUES ('W0065','A Life of Her Own','Film');
INSERT INTO WORKS VALUES ('W0066','Carnival in Flanders','Musical');
INSERT INTO WORKS VALUES ('W0067','Silk Stockings','Musical');
INSERT INTO WORKS VALUES ('W0068','The Sound of Music','Musical');
INSERT INTO WORKS VALUES ('W0069','Orfeu Negro','Film');
INSERT INTO WORKS VALUES ('W0070','Days of Wine and Roses','Film');
INSERT INTO WORKS VALUES ('W0071','The Sandpiper','Film');

INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0001','Greensleeves',1580,'',3,'G',32,'AABB','Ballad','Original',403,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0002','When the Saints Go Marching In',1896,4,'C',16,'Gospel','Original',282,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0003','St. Louis Blues',1914,4,'G',12,'ABC','Blues','Original',20,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0004','Back Home Again in Indiana',1917,4,'F',32,'AB','Swing','Original',41,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0005','Rose Room',1917,4,'G',32,'ABAB','Swing','Added',199,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0006','After You''ve Gone',1918,4,'Bb',20,'ABAC','Blues','Original',34,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0007','Ja-Da',1918,4,'F',32,'AABA','Ballad','Original',658,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0008','Whispering',1920,4,'Eb',48,'ABB','Ballad','Original',540,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0009','It Had to Be You',1924,4,'G',32,'ABAC','Swing','Added',361,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0010','Oh, Lady Be Good!',1924,'W0001',4,'G',32,'AABA','Ballad','Original',22,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0011','Tea for Two',1924,'W0002',4,'Ab',48,'AAAB','Ballad','Original',59,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0012','The Man I Love',1924,'W0001',4,'G',32,'AABA','Ballad','Original',18,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0013','Sweet Georgia Brown',1925,4,'Ab',48,'AAB','Swing','Original',16,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0014','Someone to Watch Over Me',1926,'W0003',4,'Eb',32,'AABA','Swing','Original',77,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0015','Bye Bye Blackbird',1926,4,'F',32,'AABA','Swing','Original',126,16);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0016','I''ve Found a New Baby',1926,4,'D minor',32,'AABA','Swing','Original',78,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0017','Blue Skies',1927,'W0004',4,'D minor',32,'AABA','Ballad','Original',129,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0018','''S Wonderful!',1927,'W0005',4,'Eb',32,'AABA','Ballad','Original',98,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0019','Mack the Knife',1928,'W0006',4,'Bb',16,'AB','Swing','Original',110,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0020','St. James Infirmary',1928,4,'D minor',16,'Blues','Original',239,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0021','Basin Street Blues',1928,4,'Bb',32,'AABB','Blues','Added',182,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0022','Softly As in A Morning Sunrise',1928,'W0007',4,'C minor',32,'AABA','Swing','Original',132,24);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0023','If I Had You',1928,4,'Bb',32,'AABA','Ballad','Original',65,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0024','Love Me or Leave Me',1928,'W0008',4,'D minor',32,'AABA','Ballad','Original',206,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0025','Lover Come Back to Me',1928,'W0007',4,'Ab',32,'AABA','Ballad','Original',69,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0026','Sweet Lorraine',1928,4,'F',32,'AABA','Ballad','Original',37,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0027','Stardust',1929,4,'Db',32,'AB','Ballad','Original',12,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0028','Aint Misbehavin''',1929,4,'C',32,'AABA','Swing','Original',32,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0029','Mean To Me',1929,4,'G',32,'AABA','Ballad','Original',75,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0030','Gee Baby Ain''t I Good To You',1929,4,'F',16,'AABAC','Blues','Original',150,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0031','Honeysuckle Rose',1929,4,'F',32,'AABA','Swing','Original',15,9);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0032','What Is This Thing Called Love',1929,'W0009',4,'C',32,'AABA','Swing','Original',8,19);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0033','Just You, Just Me',1929,'W0010',4,'C',32,'AABA','Ballad','Original',90,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0034','More Than You Know',1929,'W0011',4,'Ab',32,'AABA','Ballad','Original',72,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0035','Exactly Like You',1930,4,'C',32,'AABA','Ballad','Original',113,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0036','Embraceable You',1930,'W0012',4,'G',32,'ABAC','Swing','Original',24,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0037','But Not For Me',1930,'W0012',4,'Eb',32,'ABAC','Swing','Original',54,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0038','I Got Rhythm',1930,'W0012',4,'Bb',32,'AABA','Swing','Original',73,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0039','Mood Indigo',1930,4,'Ab',32,'AB','Ballad','Added',161,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0040','Georgia',1930,4,'F',32,'AABA','Swing','Original',44,7);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0041','Love For Sale',1930,'W0013',4,'Eb',64,'AABA','Swing','Original',30,7);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0042','Body And Soul',1930,4,'C#',32,'AABA','Ballad','Original',1,15);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0043','On the Sunny Side of the Street',1930,4,'C',32,'AABA','Swing','Original',55,20);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0044','Memories of You',1930,4,'Eb',32,'AABA','Ballad','Original',83,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0045','You''re Driving Me Crazy (What Did I Do?)',1930,4,'F',32,'AABA','Ballad','Original',243,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0046','As Time Goes By',1931,'W0014',4,'Eb',32,'AABA','Ballad','Original',266,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0047','Out of Nowhere',1931,4,'G',32,'ABAC','Swing','Original',68,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0048','Just Friends',1931,4,'G',32,'ABAC','Swing','Original',85,8);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0049','Beautiful Love',1931,4,'D minor',32,'ABAC','Swing','Original',592,17);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0050','All of Me',1931,4,'C',32,'ABAC','Swing','Original',71,25);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0051','I Surrender Dear',1931,4,'C',24,'AABA','Ballad','Original',95,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0052','The Song Is You',1932,'W0015',4,'C',64,'AABA','Swing','Original',159,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0053','Willow Weep for Me',1932,4,'G',32,'AABA','Swing','Original',13,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0054','April in Paris',1932,4,'C',32,'AABC','Ballad','Original',130,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0055','Alone Together',1932,'W0016',4,'D minor',44,'AABA','Swing','Original',89,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0056','How Deep Is the Ocean',1932,4,'Eb',32,'ABAC','Swing','Original',49,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0057','Sophisticated Lady',1932,4,'Ab',32,'AABA','Ballad','Added',31,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0058','It Don''t Mean A Thing',1932,4,'Bb',32,'AABA','Swing','Original',84,5);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0059','Night and Day',1932,'W0017',4,'C',48,'AAB','Swing','Original',33,7);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0060','(I Don''t Stand A) Ghost of a Chance',1932,4,'C',32,'AABA','Ballad','Original',66,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0061','Don''t Blame Me',1932,'W0018',4,'C',32,'AABA','Ballad','Original',38,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0062','Moten Swing',1932,4,'Eb',32,'AABA','Swing',NULL,249,0,'S0045');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0063','Moonglow',1933,4,'G',32,'AABA','Swing','Original',128,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0064','Let''s Fall in Love ',1933,'W0019',4,'C minor',32,'AABA','Swing','Original',480,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0065','Yesterdays',1933,'W0020',4,'C minor',16,'ABAB','Swing','Original',9,6);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0066','I Cover the Waterfront',1933,4,'G',32,'AABA','Ballad','Original',50,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0067','Rosetta',1933,4,'F',40,'AABA','Ballad','Original',203,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0068','Smoke Gets in Your Eyes',1933,'W0020',4,'Eb',32,'AABA','Ballad','Original',99,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0069','Blue Moon',1934,'W0021',4,'Eb',32,'AABA','Ballad','Original',94,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0070','Autumn in New York',1934,'W0022',4,'F',32,'ABAC','Ballad','Original',121,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0071','What A Difference A Day Makes',1934,4,'C',32,'AB','Ballad','Original',367,3);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0072','Summertime',1934,'W0023',4,'A minor',16,'ABAC','Swing','Original',3,17);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0073','My Romance',1935,'W0024',4,'C',32,'ABAC','Swing','Original',91,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0074','I Can''t Get Started',1935,4,'C',32,'AABA','Swing','Original',5,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0075','Cheek To Cheek',1935,'W0025',4,'C',56,'AABCA','Ballad','Original',187,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0076','In A Sentimental Mood',1935,4,'D minor',32,'AABA','Ballad','Added',19,4);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0077','Just One of Those Things',1935,'W0026',4,'D minor',32,'AABA','Ballad','Original',74,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0078','The Way You Look Tonight',1936,'W0027',4,'F',68,'AABAC','Swing','Original',27,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0079','Pennies From Heaven',1936,'W0028',4,'C',56,'ABAC','Swing','Original',81,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0080','Stompin'' At the Savoy',1936,4,'Db',32,'AABA','Swing','Added',48,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0081','There Is No Greater Love',1936,4,'Bb',32,'AABA','Swing','Original',52,17);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0082','Caravan',1936,4,'G',64,'AABA','Swing','Added',17,45);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0083','These Foolish Things',1936,4,'Eb',32,'AABA','Ballad','Original',28,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0084','Can''t Take That Away From Me',1937,'W0029',4,'Eb',32,'AABA','Ballad','Original',86,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0085','The Lady Is A Tramp',1937,'W0030',4,'C',48,'AAB','Swing','Original',336,3);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0086','My Funny Valentine',1937,'W0030',4,'Eb',36,'AABC','Swing','Original',6,5);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0087','Foggy Day',1937,'W0031',4,'F',34,'ABAC','Swing','Original',88,6);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0088','Have You Met Miss Jones',1937,'W0032',4,'F',32,'AABA','Swing','Original',222,6);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0089','Our Love Is Here To Stay',1937,'W0033',4,'F',32,'ABAC','Swing','Original',57,7);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0090','Some Day My Prince Will Come',1937,'W0034',3,'Bb',32,'ABAC','Waltz','Original',240,12);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0091','Easy Living',1937,'W0035',4,'Eb',32,'AABA','Ballad','Original',80,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0092','Prelude to a Kiss',1938,4,'C',32,'AABA','Ballad','Original',46,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0093','Jumpin'' At the Woodside',1938,4,'Bb',32,'AABA','Swing',NULL,436,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0094','The Nearness of You',1938,4,'F',36,'AABC','Ballad','Original',64,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0095','Cherokee',1938,4,'Bb',64,'AABA','Swing','Original',39,21);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0096','Don''t Be That Way',1938,4,'Eb',32,'AABA','Swing','Original',183,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0097','Jeepers Creepers',1938,'W0036',4,'Bb',32,'AABA','Ballad','Original',308,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0098','Over the Rainbow',1938,'W0037',4,'G',32,'AABA','Ballad','Original',63,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0099','September Song',1938,'W0038',4,'C',32,'AABA','Ballad','Original',76,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0100','You Go to My Head',1938,4,'Eb',42,'AABA','Ballad','Original',42,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0101','I Didn''t Know What Time It Was',1939,'W0039',4,'E minor',32,'AABA','Ballad','Original',82,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0102','Darn That Dream',1939,4,'G',32,'AABA','Swing','Original',70,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0103','What''s New',1939,4,'C',32,'AABA','Ballad','Added',14,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0104','I Thought About You',1939,4,'F',32,'ABAC','Swing','Original',108,4);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0105','Comes Love',1939,'W0040',4,'A minor',32,'AABA','Ballad','Original',802,8);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0106','All the Things You Are',1939,'W0041',4,'Ab',36,'ABCD','Swing','Original',2,14);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0107','Take the A Train',1939,4,'C',32,'AABA','Swing','Original',23,21);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0108','I Could Write a Book',1940,'W0042',4,'C',32,'ABAC','Swing','Original',455,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0109','Polka Dots and Moonbeams',1940,4,'F',32,'AABA','Ballad','Original',79,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0110','Cottontail ',1940,4,'Bb',32,'AABA','Swing','Added',233,1,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0111','You Stepped Out of A Dream',1940,4,'C',32,'ABAC','Swing','Original',96,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0112','In A Mellow Tone ',1940,4,'Ab',32,'ABAC','Swing','Original',140,4,'S0005');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0113','Don''t Get Around Much Any More',1940,4,'C',32,'AABA','Swing','Added',104,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0114','I Hear A Rhapsody',1940,4,'Eb',32,'AABA','Swing','Original',227,7);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0115','How High the Moon',1940,4,'G',32,'ABAC','Swing','Original',21,10);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0116','Broadway',1940,4,'C',32,'AABA','Swing','Original',366,11);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0117','Lester Leaps In',1940,4,'Bb',32,'AABA','Swing','Added',219,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0118','Seven Come Eleven',1940,4,'Ab',32,'AABA','Swing',NULL,562,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0119','I''ll Remember April',1941,4,'G',32,'AB','Swing','Original',29,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0120','I Got It Bad And That Ain''t Good',1941,4,'G',32,'AABA','Ballad','Original',61,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0121','Besame Mucho',1941,4,'D minor',32,'AABA','Latin','Original',294,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0122','Everything Happens To Me',1941,4,'Bb',32,'AABA','Ballad','Original',102,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0123','Skylark',1941,4,'Eb',32,'AABA','Ballad','Original',62,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0124','You Don''t Know What Love Is',1941,'W0043',4,'F minor',32,'AABA','Ballad','Original',53,14);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0125','Night in Tunisia',1941,4,'D minor',32,'AABA','Bebop','Added',40,44);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0126','Salt Peanuts',1941,4,'F',32,'AABA','Bebop','Original',796,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0127','I Remember You',1942,4,'F',32,'AABA','Swing','Original',116,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0128','Things Ain''t What They Used to Be',1942,4,'Db',12,'Blues','Original',92,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0129','Tangerine',1942,'W0044',4,'G minor',32,'AABA','Latin','Original',212,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0130','Perdido',1942,4,'Bb',32,'AABA','Swing','Added',58,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0131','At Last',1942,'W0045',4,'F',32,'AABC','Ballad','Original',869,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0132','C Jam Blues',1942,4,'C',12,'Blues',NULL,148,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0133','Lover Man',1942,4,'F',32,'AABA','Ballad','Original',7,6);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0134','There Will Never Be Another You',1942,'W0046',4,'Eb',32,'ABAC','Swing','Original',43,31);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0135','Epistrophy',1942,4,'C#',32,'ABCB','Bebop',NULL,346,35);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0136','Star Eyes',1943,'W0047',4,'Eb',36,'AABA','Swing','Original',87,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0137','Speak Low',1943,'W0048',4,'F',56,'AABAC','Swing','Original',120,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0138','My Shining Hour',1943,'W0049',4,'Eb',32,'AB','Swing','Original',307,6);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0139','Do Nothin'' Till You Hear from Me',1943,4,'G',24,'AABA','Ballad','Added',93,6);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0140','I Love You',1944,'W0050',4,'F',32,'AB','Swing','Original',119,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0141','Good Bait',1944,4,'Bb',32,'AABA','Swing',NULL,277,1,'S0038');
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0142','I Should Care',1944,'W0051',4,'C',32,'ABAC','Swing','Original',47,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0143','Like Someone in Love ',1944,'W0052',4,'Eb',32,'ABAC','Swing','Original',147,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0144','Groovin'' High',1944,4,'Eb',32,'AB','Bebop',NULL,186,3,'S0008');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0145','Round Midnight',1944,4,'Eb',32,'AABA','Ballad','Added',4,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0146','Moonlight in Vermont',1944,4,'Eb',26,'AABA','Swing','Original',141,7);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0147','It Could Happen To You',1944,'W0053',4,'Eb',32,'ABAC','Swing','Original',60,20);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0148','Well You Needn''t',1944,4,'F',32,'AABA','Swing','Added',313,41);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0149','52nd Street Theme',1944,4,'C',32,'AABA','Bebop',NULL,433,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0150','Dizzy Atmosphere',1944,4,'Bb',32,'AABA','Bebop',NULL,881,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0151','It Might as Well Be Spring',1945,'W0054',4,'G',80,'AABAC','Swing','Original',114,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0152','Laura',1945,'W0055',4,'C',32,'ABAC','Ballad','Original',35,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0153','Hot House',1945,4,'C',32,'AABA','Bebop',NULL,383,2,'S0032');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0154','Now''s the Time',1945,4,'F',12,'Blues',NULL,354,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0155','Autumn Leaves',1945,'W0056',4,'G minor',32,'AABC','Swing','Original',11,22);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0156','Red Cross',1945,4,'Bb',32,'AABA','Bebop',NULL,978,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0157','Shaw ''Nuff',1945,4,'Bb',32,'AABA','Bebop',NULL,601,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0158','Confirmation',1946,4,'F',32,'AABA','Bebop',NULL,218,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0159','Tenderly',1946,4,'Eb',32,'ABAC','Ballad','Original',26,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0160','Yardbird Suite',1946,4,'C',32,'AABA','Bebop',NULL,168,1,'S0067');
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0161','Angel Eyes',1946,'W0057',4,'C minor',32,'AABA','Swing','Original',67,2);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0162','Come Rain Or Come Shine',1946,'W0058',4,'F',32,'AB','Swing','Original',51,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0163','For Heaven''s Sake',1946,4,'F',32,'AABA','Ballad','Original',456,6);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0164','Anthropology',1946,4,'Bb',32,'AABA','Bebop',NULL,483,10);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0165','Stella By Starlight',1946,'W0059',4,'Bb',36,'ABCA','Ballad','Added',10,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0166','Ornithology',1946,4,'G',32,'ABAC','Bebop',NULL,462,25,'S0115');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0167','Moose the Mooche',1946,4,'Bb',32,'AABA','Bebop',NULL,699,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0168','Beyond the Sea',1946,4,'F',48,'AABA','Ballad','Original',2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0169','I Mean You',1947,4,'F',32,'AABA','Swing','Added',625,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0170','But Beautiful ',1947,'W0060',4,'G',32,'ABAC','Ballad','Original',133,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0171','Lady Bird',1947,4,'C',16,'Bebop','Added',458,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0172','Donna Lee',1947,4,'Ab',32,'AB','Bebop',NULL,194,6,'S0004');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0173','In Walked Bud',1947,4,'F minor',32,'AABA','Bebop',NULL,495,10,'S0017');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0174','Scrapple From the Apple',1947,4,'F',32,'AABA','Bebop',NULL,271,12,'S0031');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0175','On Green Dolphin Street',1947,4,'Eb',32,'ABAC','Swing','Original',25,33);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0176','Chasin'' the Bird',1947,4,'F',32,'AABA','Bebop',NULL,799,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0177','Dexterity',1947,4,'Bb',32,'AABA','Bebop',NULL,859,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0178','Ow!',1947,4,'Bb',32,'AABA','Bebop',NULL,858,0,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0179','Half Nelson',1948,4,'C',24,'Swing',NULL,894,0,'S0171');
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0180','It''s You or No One',1948,'W0061',4,'F',32,'ABAC','Swing','Original',372,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0181','The Night Has a Thousand Eyes',1948,'W0062',4,'G',48,'AAB','Latin','Original',273,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0182','Manteca',1948,4,'Bb',48,'ABBA','Latin',NULL,490,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0183','Nature Boy',1948,4,'E minor',32,'ABAB','Ballad','Original',115,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0184','Evidence',1948,4,'Eb',32,'AABA','Bebop',NULL,497,0,'S0033');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0185','Four Brothers',1948,4,'F',32,'AABA','Bebop','Added',942,0,'S0097');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0186','Jumpin'' With Symphony Sid',1949,4,'D',32,'ABC','Swing','Original',712,1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0187','My Foolish Heart',1949,'W0063',4,'Bb',32,'ABAC','Ballad','Original',103,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0188','Walkin''',1949,4,'F',12,'Blues',NULL,341,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0189','Afternoon in Paris',1949,4,'C',32,'AABA','Swing',NULL,532,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0190','Lush Life',1949,4,'Db',42,'AABCC','Ballad','Added',36,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0191','Tempus Fugit',1949,4,'D minor',32,'AABA','Bebop',NULL,6);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0192','If I Were A Bell',1950,'W0064',4,'F',32,'ABAC','Swing','Original',466,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0193','Au Privave',1951,4,'F',12,'Blues',NULL,523,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0194','Blues For Alice',1951,4,'F',12,'Blues',NULL,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0195','My Little Suede Shoes',1951,4,'Eb',32,'AABA','Latin',NULL,587,6,'S0097');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0196','Straight No Chaser',1951,4,'F',12,'Blues','Added',163,7);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0197','Birk''s Works',1951,4,'F minor',12,'Blues',NULL,603,8);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0198','When I Fall in Love',1952,4,'Eb',32,'ABAC','Ballad','Original',137,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0199','Reflections',1952,4,'Ab',32,'AABA','Ballad','Added',706,6);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0200','Lullaby of Birdland',1952,4,'Bb',32,'AABA','Swing','Original',153,12,'S0024');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0201','Bernie''s Tune',1952,4,'D minor',32,'AABA','Swing','Added',394,13);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0202','Invitation',1952,'W0065',4,'C minor',48,'ABC','Swing','Original',252,26);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0203','Here''s That Rainy Day',1953,'W0066',4,'G',32,'AABA','Swing','Original',100,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0204','My One And Only Love',1953,4,'C',32,'AABA','Ballad','Original',97,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0205','Tune up',1953,4,'Bb',32,'AB','Bebop',NULL,652,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0206','Satin Doll',1953,4,'C',32,'AABA','Swing','Added',45,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0207','Sway',1953,4,'E minor',32,'AABA','Mambo','Original',1);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0208','All of You',1954,'W0067',4,'Eb',32,'ABAC','Swing','Original',356,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0209','Airegin',1954,4,'F minor',36,'ABAC','Bebop','Added',293,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0210','Oleo',1954,4,'Bb',32,'AABA','Swing',NULL,280,1,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0211','Joy Spring',1954,4,'F',32,'ABCA','Swing','Original',511,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0212','Fly Me To the Moon',1954,4,'C',32,'ABAC','Swing','Original',352,8);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0213','Nica''s Dream',1954,4,'Bb minor',48,'AAB','Latin','Added',418,9);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0214','Misty',1954,4,'Eb',32,'AABA','Ballad','Added',56,10);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0215','Bags'' Groove',1954,4,'F',12,'Blues',NULL,343,16);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0216','Doxy',1954,4,'Bb',16,'AABA','Swing',NULL,691,17,'S0007');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0217','Solar',1954,4,'C minor',12,'Swing',NULL,402,18);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0218','Blue Monk',1954,4,'Bb',12,'Blues',NULL,185,19);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0219','Four',1954,4,'Eb',32,'ABAC','Swing',NULL,537,21);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0220','Billie''s Bounce',1954,4,'F',12,'Blues','Added',112,37);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0221','Stablemates',1955,4,'Db',36,'ABA','Swing',NULL,424,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0222','In Your Own Sweet Way',1955,4,'Eb',46,'AABAC','Swing','Added',223,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0223','Sandu',1955,4,'Eb',12,'Blues',NULL,8);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0224','Blues in the Closet',1955,4,'G',12,'Blues',NULL,543,9);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0225','Whisper Not',1956,4,'C minor',32,'AABA','Swing','Added',297,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0226','Blues By Five',1956,4,'C',12,'Blues',NULL,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0227','Tenor Madness',1956,4,'Bb',12,'Blues',NULL,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0228','St. Thomas',1956,4,'C',16,'Latin',NULL,371,29);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0229','Valse Hot',1956,3,'Bb',24,'Waltz',NULL,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0230','Moment''s Notice',1957,4,'Eb',38,'ABAC','Swing',NULL,576,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0231','Lazy Bird',1957,4,'G',32,'AABA','Swing',NULL,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0232','Blue Train',1957,4,'Eb',12,'Blues',NULL,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0233','Along Came Betty',1958,4,'Ab',50,'ABC','Swing',NULL,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0234','Milestones',1958,4,'G minor',32,'AABA','Swing',NULL,287,10);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0235','Nardis',1958,4,'E minor',32,'AABA','Swing',NULL,633,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0236','Rhythm-A-Ning',1958,4,'Bb',32,'AABA','Bebop',NULL,347,2,'S0038');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0237','One For Daddy-O',1958,4,'Ab',12,'Bebop',NULL,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls,ContrafactID) VALUES ('S0238','Freight Trane',1958,4,'Ab',12,'Blues',NULL,3,'S0194');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0239','Killer Joe',1959,4,'C',32,'AABA','Swing',NULL,628,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0240','Peace',1959,4,'Bb',10,'Ballad',NULL,923,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls,ContrafactID) VALUES ('S0241','Countdown',1959,4,'Bb',16,'Bebop',NULL,1,'S0205');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0242','Giant Steps',1959,4,'Eb',24,'Swing',NULL,254,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0243','Goodbye Pork Pie Hat',1959,4,'Eb minor',24,'Ballad',NULL,610,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0244','Naima',1959,4,'Eb',20,'AABC','Ballad',NULL,263,4);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0245','Blue in Green',1959,4,'D minor',10,'Ballad',NULL,426,4);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0246','My Favourite Things',1959,'W0068',3,'E minor',72,'ABC','Waltz','Original',333,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0247','Take Five',1959,5,'Eb minor',24,'ABA','Swing','Added',656,10);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0248','So What',1959,4,'D minor',36,'AABA','Swing',NULL,435,11);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0249','Freddie Freeloader',1959,4,'Bb',12,'Blues','Added',13);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0250','Afro Blue',1959,3,'F minor',16,'Waltz','Added',772,14);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0251','Desafinado',1959,4,'F',68,'AABC','Bossa','Added',713,17);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0252','Moanin''',1959,4,'F minor',32,'AABA','Swing','Added',565,17);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0253','All Blues',1959,3,'G',24,'Waltz','Added',248,18);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0254','Mr P.C.',1959,4,'C minor',12,'Blues',NULL,22);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0255','Black Orpheus',1959,'W0069',4,'A minor',32,'AB','Bossa','Original',41);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0256','Samba De Orfeu',1959,'W0069',4,'C',40,'AABA','Bossa','Original',2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0257','Once I Loved',1960,4,'D minor',44,'AAB','Bossa','Original',683,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0258','Equinox',1960,4,'C# minor',12,'Blues',NULL,903,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0259','Work Song',1960,4,'F minor',16,'Swing','Added',350,13);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0260','Corcovado',1960,4,'A minor',34,'ABAC','Bossa','Added',382,18);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0261','This I Dig of You',1960,4,'Bb',32,'ABAC','Swing',NULL,24);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0262','Bluesette',1961,3,'Bb',24,'Waltz','Added',0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls,ContrafactID) VALUES ('S0263','Impressions',1961,4,'D minor',32,'AABA','Swing',NULL,771,2,'S0248');
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0264','One Note Samba',1961,4,'Bb',40,'ABA','Bossa','Original',533,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0265','Stolen Moments',1961,4,'C minor',23,'AB','Blues','Added',853,6);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0266','Meditation',1962,4,'C',56,'AABC','Bossa','Original',685,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0267','Days of Wine And Roses',1962,'W0070',4,'F',32,'ABAC','Swing','Original',135,11);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0268','Watermelon Man',1962,4,'F',16,'Swing','Added',609,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0269','Girl From Ipanema',1962,4,'F',40,'AABA','Bossa','Original',479,16);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0270','Seven Steps to Heaven',1963,4,'F',32,'AABA','Swing','Added',0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0271','How Insensitive',1963,4,'D minor',32,'AB','Bossa','Original',552,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0272','I Wish I Knew How It Would Feel To Be Free',1963,4,'F',16,'Gospel','Original',8);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0273','Blue Bossa',1963,4,'C minor',16,'Bossa',NULL,557,32);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0274','Recorda Me',1963,4,'A minor',16,'Bossa','Added',52);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0275','Chitlins Con Carne',1963,4,'C',48,'Blues',NULL,9);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0276','Inner Urge',1964,4,'G',24,'Swing',NULL,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0277','Bessies Blues',1964,4,'Eb',12,'Blues',NULL,1);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0278','Beatrice',1964,4,'F',16,'Swing',NULL,9);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0279','Bye-Ya',1964,4,'F minor',16,'Modal',NULL,10);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0280','Isfahan',1964,4,'Db',32,'ABAB','Ballad',NULL,718,12);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0281','Song For My Father',1964,4,'F minor',24,'AAB','Latin',NULL,13);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0282','Black Nile',1964,4,'D minor',32,'AABA','Bebop',NULL,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0283','Ceora',1965,4,'Ab',32,'AB','Bossa',NULL,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0284','Freedom Jazz Dance',1965,4,'Bb',16,'Funk',NULL,0);
INSERT INTO SONGS (SongID,Song,Year,WorkID,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0285','The Shadow of Your Smile',1965,'W0071',4,'G',32,'AABA','Swing','Original',276,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0286','ESP',1965,4,'F',32,'ABAC','Swing',NULL,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0287','Maiden Voyage',1965,4,'D',32,'AABA','Swing',NULL,952,3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0288','Triste',1966,4,'A',36,'AB','Bossa','Original',879,0);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0289','Dolphin Dance',1966,4,'E minor',32,'ABCD','Swing',NULL,742,2);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0290','Mercy Mercy Mercy',1966,4,'Bb',20,'AB','Funk','Added',5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0291','Speak No Evil',1966,4,'C minor',50,'AABA','Swing',NULL,5);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0292','Fee Fi Fo Fum',1966,4,'Bb',24,'ABA','Swing',NULL,6);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Ranking,Calls) VALUES ('S0293','Footprints',1966,3,'C minor',24,'Waltz',NULL,618,16);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Calls) VALUES ('S0294','Little Sunflower',1967,4,'D minor',32,'AABA','Latin',NULL,7);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Form,Style,Lyrics,Ranking,Calls) VALUES ('S0295','Wave',1967,4,'D',44,'AABA','Bossa','Added',216,14);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0296','Moondance',1970,4,'A minor',16,'Swing','Original',3);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0297','Chameleon',1973,4,'Bb',32,'Funk',NULL,11);
INSERT INTO SONGS (SongID,Song,Year,TimeSignature,KeySignature,Bars,Style,Lyrics,Calls) VALUES ('S0298','The Chicken',1979,4,'Bb',40,'Funk',NULL,8);

INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0001','W.','C.','Handy',1873,1953,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0002','James','Hanley',1892,1942,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0003','Ballard','MacDonald',1882,1935,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0004','Art','Hickman',1886,1930,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0005','Harry','Williams',1879,1922,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0006','Turner','Layton',1894,1978,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0007','Henry','Creamer',1879,1930,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0008','Bob','Carleton',1894,1956,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0009','John','Schonberger',1892,1983,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0010','Richard','Coburn',1886,1952,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0011','Isham','Jones',1894,1956,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0012','Gus','Kahn',1886,1941,'M','White','Germany');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0013','George','Gershwin',1898,1937,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0014','Ira','Gershwin',1896,1983,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0015','Vincent','Youmans',1898,1946,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0016','Irving','Caesar',1895,1996,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0017','Ben','Bernie',1891,1943,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0018','Ken','Casey',1899,1965,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0019','Maceo','Pinkard',1897,1962,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0020','Ray','Henderson',1896,1970,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0021','Mort','Dixon',1892,1956,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0022','Jack','Palmer',1899,1976,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0023','Spencer','Williams',1889,1965,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0024','Irving','Berlin',1888,1989,'M','White','Russia');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0025','Kurt','Weill',1900,1950,'M','White','Germany');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0026','Bertolt','Brecht',1898,1956,'M','White','Germany');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0027','Glenn','Miller',1904,1944,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0028','Jack','Teagarden',1905,1964,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0029','Sigmund','Romberg',1887,1951,'M','White','Hungary');
INSERT INTO WRITERS (WriterID,FirstName,LastName,SuffixName,Born,Died,Sex,Race,Birthplace) VALUES ('P0030','Oscar','Hammerstein','II',1895,1960,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0031','James','Campbell',1903,1967,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0032','Reginald','Connelly',1895,1963,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0033','Ted','Shapiro',1899,1980,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0034','Walter','Donaldson',1893,1947,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0035','Cliff','Burwell',1898,1976,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0036','Mitchell','Parish',1900,1993,'M','White','Lithuania');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0037','Hoagy','Carmichael',1899,1981,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0038','Fats','Waller',1904,1943,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0039','Harry','Brooks',1895,1970,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0040','Andy','Razaf',1895,1973,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0041','Fred','Ahlert',1892,1953,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0042','Roy','Turk',1892,1934,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0043','Don','Redman',1900,1964,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0044','Cole','Porter',1891,1964,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0045','Jesse','Greer',1896,1970,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0046','Raymond','Klages',1888,1947,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0047','Billy','Rose',1899,1966,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0048','Edward','Eliscu',1902,1998,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0049','Jimmy','McHugh',1894,1969,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0050','Dorothy','Fields',1904,1974,'F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0051','Barney','Bigard',1906,1980,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0052','Duke','Ellington',1899,1974,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0053','Irving','Mills',1894,1985,'M','White','Ukraine');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0054','Stuart','Gorrell',1901,1963,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0055','Johnny','Green',1908,1989,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0056','Frank','Eyton',1894,1962,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0057','Edward','Heyman',1907,1981,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0058','Robert','Sour',1905,1985,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0059','Eubie','Blake',1887,1983,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0060','Herman','Hupfeld',1894,1951,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0061','John','Klenner',1899,1955,'M','White','Germany');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0062','Sam','M.','Lewis',1885,1959,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0063','Wayne','King',1901,1985,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0064','Egbert','Van Alstyne',1878,1951,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0065','Victor','Young',1899,1956,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0066','Haven','Gillespie',1888,1975,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0067','Gerald','Marks',1900,1997,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0068','Seymour','Simons',1896,1949,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0069','Harry','Barris',1905,1962,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0070','Gordon','Clifford',1902,1968,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0071','Jerome','Kern',1885,1945,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0072','Ann','Ronell',1905,1993,'F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0073','Vernon','Duke',1903,1969,'M','White','Russia');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0074','Yip','Harburg',1896,1981,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0075','Arthur','Schwartz',1900,1984,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0076','Howard','Dietz',1896,1983,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0077','Ned','Washington',1901,1976,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0078','Bing','Crosby',1903,1977,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0079','Bennie','Moten',1883,1935,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0080','Buster','Moten',1903,1965,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0081','Will','Hudson',1908,1981,'M','White','Canda');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0082','Eddie','De Lange',1904,1949,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0083','Harold','Arlen',1905,1986,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0084','Ted','Koehler',1894,1973,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0085','Otto','Harbach',1873,1963,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0086','Henri','Woode',1909,1994,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0087','Earl','Hines',1903,1983,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0088','Richard','Rodgers',1902,1979,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0089','Lorenz','Hart',1895,1943,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0090','Maria','Grever',1885,1951,'F','Latin','Mexico');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0091','Stanley','Adams',1907,1994,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0092','DuBose','Heyward',1885,1940,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0093','Manny','Kurtz',1911,1984,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0094','Arthur','Johnston',1898,1954,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0095','Johnny','Burke',1908,1964,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0096','Benny','Goodman',1909,1986,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0097','Edgar','Sampson',1907,1973,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0098','Chick','Webb',1905,1939,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0099','Marty','Symes',1904,1953,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0100','Juan','Tizol',1900,1984,'M','Latin','Puerto Rico');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0101','Harry','Link',1896,1956,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0102','Jack','Strachey',1894,1972,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0103','Eric','Maschwitz',1901,1961,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0104','Frank','Churchill',1901,1942,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0105','Larry','Morey',1905,1971,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0106','Ralph','Rainger',1901,1942,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0107','Leo','Robin',1900,1984,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0108','Irving','Gordon',1915,1996,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0109','Count','Basie',1904,1984,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0110','Ray','Noble',1903,1978,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0111','Harry','Warren',1893,1981,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0112','Johnny','Mercer',1909,1976,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0113','Maxwell','Anderson',1888,1959,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0114','J.','Fred','Coots',1897,1985,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0115','Jimmy','Van Heusen',1913,1990,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0116','Bob','Haggart',1914,1998,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0117','Sam','H.','Stept',1897,1964,'M','White','Ukraine');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0118','Charles','Tobias',1898,1970,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0119','Lew','Brown',1893,1958,'M','White','Ukraine');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0120','Billy','Strayhorn',1915,1967,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0121','Jon','Hendricks',1921,2017,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0122','Nacio','Herb','Brown',1896,1964,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0123','Milt','Gabler',1911,2001,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0124','Bob','Russell',1914,1970,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Sex,Birthplace) VALUES ('P0125','Jack','Baker','M','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0126','George','Fragos',1919,2001,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0127','Dick','Gasparre',1899,1971,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0128','Morgan','Lewis',1906,1968,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0129','Nancy','Hamilton',1908,1985,'F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Sex) VALUES ('P0130','Wilbur','H.','Bird','M');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0131','Teddy','McRae',1908,1999,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0132','Lester','Young',1909,1959,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0133','Eddie','Jefferson',1918,1979,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0134','Charlie','Christian',1916,1942,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0135','Gene','De Paul',1919,1988,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0136','Patricia','Johnston',1922,1953,'F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0137','Don','Raye',1909,1985,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0138','Paul','Francis','Webster',1907,1984,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0139','Consuelo','Velazquez',1916,2005,'F','Latin','Mexico');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0140','Sunny','Skylar',1913,2009,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0141','Matt','Dennis',1914,2002,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0142','Thomas','Adair',1913,1988,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0143','Dizzy','Gillespie',1917,1993,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0144','Frank','Paparelli',1917,1973,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0145','Raymond','Leveen',1893,1984,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0146','Kenny','Clarke',1914,1985,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0147','Victor','Schertzinger',1888,1941,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0148','Mercer','Ellington',1919,1996,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0149','Ted','Persons',1909,1988,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0150','Ervin','Drake',1919,2015,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0151','Hans','Jan','Lengsfelder',1903,1979,'M','White','Austria');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0152','Mack','Gordon',1904,1959,'M','White','Poland');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0153','James','Edward','Davis',1915,1997,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0154','Ram','Ramirez',1913,1994,'M','Latin','Puerto Rico');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0155','Jimmy','Sherman',1908,1975,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0156','Thelonious','Monk',1917,1982,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0157','Cootie','Williams',1911,1985,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0158','Ogden','Nash',1902,1971,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0159','Tadd','Dameron',1917,1965,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0160','Sammy','Cahn',1913,1993,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0161','Axel','Stordahl',1913,1963,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0162','Paul','Weston',1912,1996,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0163','Bernie','Hanighen',1908,1976,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0164','Karl','Suessdorf',1911,1982,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0165','John','M.','Blackburn',1913,2006,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Sex) VALUES ('P0166','Mike','Ferro','M');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0167','David','Raskin',1912,2004,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0168','Charlie','Parker',1920,1955,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0169','Joseph','Kosma',1905,1969,'M','White','Hungary');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0170','Jacques','Prevert',1900,1977,'M','White','France');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0171','Walter','Gross',1909,1967,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0172','Jack','Lawrence',1912,2009,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0173','Earl','K.','Brent',1914,1977,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Sex,Race,Birthplace) VALUES ('P0174','Elise','Bretton','F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0175','Sherman','Edwards',1919,1981,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Sex) VALUES ('P0176','Donald','Meyer','M');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0177','Bennie','Harris',1919,1975,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0178','Albert','Lasry',1903,1975,'M','White','Algeria');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0179','Charles','Trenet',1913,2001,'M','White','France');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0180','Coleman','Hawkins',1904,1969,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Sex,Birthplace) VALUES ('P0181','Stanley','Cornfield','M','Canada');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0182','Miles','Davis',1928,1991,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0183','Bronislau','Kaper',1902,1983,'M','White','Poland');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0184','Jule','Styne',1905,1994,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0185','Jerry','Brainin',1916,2000,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0186','Buddy','Bernier',1910,1983,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0187','Chano','Pozo',1915,1948,'M','Black','Cuba');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0188','Walter','Gilbert','Fuller',1920,1994,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0189','Eden','Ahbez',1908,1995,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0190','Jimmy','Giuffre',1921,2008,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0191','Buddy','Feyne',1912,1998,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0192','John','Lewis',1920,2001,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0193','Bud','Powell',1924,1966,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0194','Frank','Loesser',1910,1969,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Sex) VALUES ('P0195','Sally','Swisher','F');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0196','George','Shearing',1919,2011,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0197','George','Weiss',1921,2010,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0198','Bernie','Miller',1919,1945,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0199','Jerry','Leiber',1933,2011,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0200','Mike','Stoller',1933,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0201','Robert','Mellin',1902,1994,'M','White','Ukraine');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0202','Guy','Wood',1911,2001,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0203','Luis','Demetrio',1931,2007,'M','Latin','Mexico');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0204','Pablo','Beltran','Ruiz',1915,2008,'M','Latin','Mexico');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0205','Norman','Gimbel',1927,2018,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0206','Sonny','Rollins',1930,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0207','Clifford','Brown',1930,1956,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0208','Bart','Howard',1915,2004,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0209','Horace','Silver',1928,2014,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0210','Leonard','Feather',1914,1994,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0211','Erroll','Garner',1921,1977,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0212','Milt','Jackson',1923,1999,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0213','Benny','Golson',1929,NULL,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0214','Dave','Brubeck',1920,2012,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0215','Iola','Brubeck',1923,2014,'F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0216','Harry','Babasin',1921,1988,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0217','Oscar','Pettiford',1922,1960,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0218','Red','Garland',1923,1984,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0219','John','Coltrane',1926,1967,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0220','Nat','Adderley',1931,2000,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0221','Tommy','Flanagan',1930,2001,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0222','Charles','Mingus',1922,1979,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0223','Bill','Evans',1929,1980,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0224','Paul','Desmond',1924,1977,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0225','Mongo','Santamaria',1917,2003,'M','Latin','Cuba');
INSERT INTO WRITERS (WriterID,FirstName,LastName,SuffixName,Born,Died,Sex,Race,Birthplace) VALUES ('P0226','Oscar','Brown','Jr',1926,2005,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,MiddleName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0227','Antonio','Carlos','Jobim',1927,1994,'M','Latin','Brazil');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0228','Newton','Mendonca',1927,1960,'M','Latin','Brazil');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0229','Bobby','Timmons',1935,1974,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0230','Luiz','Bonfa',1922,2001,'M','Latin','Brazil');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0231','Antonio','Maria',1921,1964,'M','Latin','Brazil');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0232','Vinicius','De Moraes',1913,1980,'M','Latin','Brazil');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0233','Ray','Gilbert',1912,1976,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0234','Gene','Lees',1928,2010,'M','White','Canada');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0235','Hank','Mobley',1930,1986,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0236','Toots','Thielemans',1922,2016,'M','White','Belgium');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0237','Oliver','Nelson',1932,1975,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0238','Mark','Murphy',1932,2015,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0239','Henry','Mancini',1924,1994,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0240','Herbie','Hancock',1940,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0241','Victor','Feldman',1934,1987,'M','White','United Kingdom');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0242','Billy','Taylor',1921,2010,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0243','Kenny','Dorham',1924,1972,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0244','Joe','Henderson',1937,2001,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0245','Kelley','Johnson',1958,'F','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0246','Kenny','Burrell',1931,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0247','Sam','Rivers',1923,2011,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0248','Wayne','Shorter',1933,2023,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0249','Lee','Morgan',1938,1972,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0250','Eddie','Harris',1934,1996,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0251','Johnny','Mandel',1925,2020,'M','White','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0252','Joe','Zawinul',1932,2007,'M','White','Austria');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0253','Johnny','Watson',1935,1996,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0254','Larry','Williams',1935,1980,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0255','Freddie','Hubbard',1938,2008,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0256','Van','Morrison',1945,'M','White','Northern Ireland');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0257','Bennie','Maupin',1940,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Sex,Race,Birthplace) VALUES ('P0258','Harvey','Mason',1947,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0259','Paul','Jackson',1947,2021,'M','Black','United States');
INSERT INTO WRITERS (WriterID,FirstName,LastName,Born,Died,Sex,Race,Birthplace) VALUES ('P0260','Pee Wee','Ellis',1941,2021,'M','Black','United States');

INSERT INTO CREDITS VALUES ('S0003','P0001','Lyrics');
INSERT INTO CREDITS VALUES ('S0003','P0001','Music');
INSERT INTO CREDITS VALUES ('S0004','P0003','Lyrics');
INSERT INTO CREDITS VALUES ('S0004','P0002','Music');
INSERT INTO CREDITS VALUES ('S0005','P0004','Lyrics');
INSERT INTO CREDITS VALUES ('S0005','P0005','Lyrics');
INSERT INTO CREDITS VALUES ('S0005','P0004','Music');
INSERT INTO CREDITS VALUES ('S0005','P0005','Music');
INSERT INTO CREDITS VALUES ('S0006','P0007','Lyrics');
INSERT INTO CREDITS VALUES ('S0006','P0006','Music');
INSERT INTO CREDITS VALUES ('S0007','P0008','Lyrics');
INSERT INTO CREDITS VALUES ('S0007','P0008','Music');
INSERT INTO CREDITS VALUES ('S0008','P0010','Lyrics');
INSERT INTO CREDITS VALUES ('S0008','P0009','Music');
INSERT INTO CREDITS VALUES ('S0009','P0012','Lyrics');
INSERT INTO CREDITS VALUES ('S0009','P0011','Music');
INSERT INTO CREDITS VALUES ('S0010','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0010','P0013','Music');
INSERT INTO CREDITS VALUES ('S0011','P0016','Lyrics');
INSERT INTO CREDITS VALUES ('S0011','P0015','Music');
INSERT INTO CREDITS VALUES ('S0012','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0012','P0013','Music');
INSERT INTO CREDITS VALUES ('S0013','P0017','Lyrics');
INSERT INTO CREDITS VALUES ('S0013','P0018','Lyrics');
INSERT INTO CREDITS VALUES ('S0013','P0019','Lyrics');
INSERT INTO CREDITS VALUES ('S0013','P0017','Music');
INSERT INTO CREDITS VALUES ('S0013','P0018','Music');
INSERT INTO CREDITS VALUES ('S0013','P0019','Music');
INSERT INTO CREDITS VALUES ('S0014','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0014','P0013','Music');
INSERT INTO CREDITS VALUES ('S0015','P0021','Lyrics');
INSERT INTO CREDITS VALUES ('S0015','P0020','Music');
INSERT INTO CREDITS VALUES ('S0016','P0022','Lyrics');
INSERT INTO CREDITS VALUES ('S0016','P0023','Lyrics');
INSERT INTO CREDITS VALUES ('S0016','P0022','Music');
INSERT INTO CREDITS VALUES ('S0016','P0023','Music');
INSERT INTO CREDITS VALUES ('S0017','P0024','Lyrics');
INSERT INTO CREDITS VALUES ('S0017','P0024','Music');
INSERT INTO CREDITS VALUES ('S0018','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0018','P0013','Music');
INSERT INTO CREDITS VALUES ('S0019','P0026','Lyrics');
INSERT INTO CREDITS VALUES ('S0019','P0025','Music');
INSERT INTO CREDITS VALUES ('S0021','P0027','Lyrics');
INSERT INTO CREDITS VALUES ('S0021','P0028','Lyrics');
INSERT INTO CREDITS VALUES ('S0021','P0023','Music');
INSERT INTO CREDITS VALUES ('S0022','P0030','Lyrics');
INSERT INTO CREDITS VALUES ('S0022','P0029','Music');
INSERT INTO CREDITS VALUES ('S0023','P0032','Lyrics');
INSERT INTO CREDITS VALUES ('S0023','P0033','Lyrics');
INSERT INTO CREDITS VALUES ('S0023','P0031','Music');
INSERT INTO CREDITS VALUES ('S0024','P0012','Lyrics');
INSERT INTO CREDITS VALUES ('S0024','P0034','Music');
INSERT INTO CREDITS VALUES ('S0025','P0030','Lyrics');
INSERT INTO CREDITS VALUES ('S0025','P0029','Music');
INSERT INTO CREDITS VALUES ('S0026','P0036','Lyrics');
INSERT INTO CREDITS VALUES ('S0026','P0035','Music');
INSERT INTO CREDITS VALUES ('S0027','P0036','Lyrics');
INSERT INTO CREDITS VALUES ('S0027','P0037','Music');
INSERT INTO CREDITS VALUES ('S0028','P0040','Lyrics');
INSERT INTO CREDITS VALUES ('S0028','P0038','Music');
INSERT INTO CREDITS VALUES ('S0028','P0039','Music');
INSERT INTO CREDITS VALUES ('S0029','P0042','Lyrics');
INSERT INTO CREDITS VALUES ('S0029','P0041','Music');
INSERT INTO CREDITS VALUES ('S0030','P0040','Lyrics');
INSERT INTO CREDITS VALUES ('S0030','P0043','Music');
INSERT INTO CREDITS VALUES ('S0031','P0040','Lyrics');
INSERT INTO CREDITS VALUES ('S0031','P0038','Music');
INSERT INTO CREDITS VALUES ('S0032','P0044','Lyrics');
INSERT INTO CREDITS VALUES ('S0032','P0044','Music');
INSERT INTO CREDITS VALUES ('S0033','P0046','Lyrics');
INSERT INTO CREDITS VALUES ('S0033','P0045','Music');
INSERT INTO CREDITS VALUES ('S0034','P0047','Lyrics');
INSERT INTO CREDITS VALUES ('S0034','P0048','Lyrics');
INSERT INTO CREDITS VALUES ('S0034','P0015','Music');
INSERT INTO CREDITS VALUES ('S0035','P0050','Lyrics');
INSERT INTO CREDITS VALUES ('S0035','P0049','Music');
INSERT INTO CREDITS VALUES ('S0036','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0036','P0013','Music');
INSERT INTO CREDITS VALUES ('S0037','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0037','P0013','Music');
INSERT INTO CREDITS VALUES ('S0038','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0038','P0013','Music');
INSERT INTO CREDITS VALUES ('S0039','P0053','Lyrics');
INSERT INTO CREDITS VALUES ('S0039','P0051','Music');
INSERT INTO CREDITS VALUES ('S0039','P0052','Music');
INSERT INTO CREDITS VALUES ('S0040','P0054','Lyrics');
INSERT INTO CREDITS VALUES ('S0040','P0037','Music');
INSERT INTO CREDITS VALUES ('S0041','P0044','Lyrics');
INSERT INTO CREDITS VALUES ('S0041','P0044','Music');
INSERT INTO CREDITS VALUES ('S0042','P0056','Lyrics');
INSERT INTO CREDITS VALUES ('S0042','P0057','Lyrics');
INSERT INTO CREDITS VALUES ('S0042','P0058','Lyrics');
INSERT INTO CREDITS VALUES ('S0042','P0055','Music');
INSERT INTO CREDITS VALUES ('S0043','P0050','Lyrics');
INSERT INTO CREDITS VALUES ('S0043','P0049','Music');
INSERT INTO CREDITS VALUES ('S0044','P0040','Lyrics');
INSERT INTO CREDITS VALUES ('S0044','P0059','Music');
INSERT INTO CREDITS VALUES ('S0045','P0034','Lyrics');
INSERT INTO CREDITS VALUES ('S0045','P0034','Music');
INSERT INTO CREDITS VALUES ('S0046','P0060','Lyrics');
INSERT INTO CREDITS VALUES ('S0046','P0060','Music');
INSERT INTO CREDITS VALUES ('S0047','P0057','Lyrics');
INSERT INTO CREDITS VALUES ('S0047','P0055','Music');
INSERT INTO CREDITS VALUES ('S0048','P0062','Lyrics');
INSERT INTO CREDITS VALUES ('S0048','P0061','Music');
INSERT INTO CREDITS VALUES ('S0049','P0066','Lyrics');
INSERT INTO CREDITS VALUES ('S0049','P0063','Music');
INSERT INTO CREDITS VALUES ('S0049','P0064','Music');
INSERT INTO CREDITS VALUES ('S0049','P0065','Music');
INSERT INTO CREDITS VALUES ('S0050','P0067','Lyrics');
INSERT INTO CREDITS VALUES ('S0050','P0068','Lyrics');
INSERT INTO CREDITS VALUES ('S0050','P0067','Music');
INSERT INTO CREDITS VALUES ('S0050','P0068','Music');
INSERT INTO CREDITS VALUES ('S0051','P0070','Lyrics');
INSERT INTO CREDITS VALUES ('S0051','P0069','Music');
INSERT INTO CREDITS VALUES ('S0052','P0030','Lyrics');
INSERT INTO CREDITS VALUES ('S0052','P0071','Music');
INSERT INTO CREDITS VALUES ('S0053','P0072','Lyrics');
INSERT INTO CREDITS VALUES ('S0053','P0072','Music');
INSERT INTO CREDITS VALUES ('S0054','P0074','Lyrics');
INSERT INTO CREDITS VALUES ('S0054','P0073','Music');
INSERT INTO CREDITS VALUES ('S0055','P0076','Lyrics');
INSERT INTO CREDITS VALUES ('S0055','P0075','Music');
INSERT INTO CREDITS VALUES ('S0056','P0024','Lyrics');
INSERT INTO CREDITS VALUES ('S0056','P0024','Music');
INSERT INTO CREDITS VALUES ('S0057','P0036','Lyrics');
INSERT INTO CREDITS VALUES ('S0057','P0053','Lyrics');
INSERT INTO CREDITS VALUES ('S0057','P0052','Music');
INSERT INTO CREDITS VALUES ('S0058','P0053','Lyrics');
INSERT INTO CREDITS VALUES ('S0058','P0052','Music');
INSERT INTO CREDITS VALUES ('S0059','P0044','Lyrics');
INSERT INTO CREDITS VALUES ('S0059','P0044','Music');
INSERT INTO CREDITS VALUES ('S0060','P0077','Lyrics');
INSERT INTO CREDITS VALUES ('S0060','P0078','Lyrics');
INSERT INTO CREDITS VALUES ('S0060','P0065','Music');
INSERT INTO CREDITS VALUES ('S0061','P0050','Lyrics');
INSERT INTO CREDITS VALUES ('S0061','P0049','Music');
INSERT INTO CREDITS VALUES ('S0062','P0079','Music');
INSERT INTO CREDITS VALUES ('S0062','P0080','Music');
INSERT INTO CREDITS VALUES ('S0063','P0082','Lyrics');
INSERT INTO CREDITS VALUES ('S0063','P0053','Music');
INSERT INTO CREDITS VALUES ('S0063','P0081','Music');
INSERT INTO CREDITS VALUES ('S0064','P0084','Lyrics');
INSERT INTO CREDITS VALUES ('S0064','P0083','Music');
INSERT INTO CREDITS VALUES ('S0065','P0085','Lyrics');
INSERT INTO CREDITS VALUES ('S0065','P0071','Music');
INSERT INTO CREDITS VALUES ('S0066','P0057','Lyrics');
INSERT INTO CREDITS VALUES ('S0066','P0055','Music');
INSERT INTO CREDITS VALUES ('S0067','P0086','Lyrics');
INSERT INTO CREDITS VALUES ('S0067','P0087','Lyrics');
INSERT INTO CREDITS VALUES ('S0067','P0086','Music');
INSERT INTO CREDITS VALUES ('S0067','P0087','Music');
INSERT INTO CREDITS VALUES ('S0068','P0085','Lyrics');
INSERT INTO CREDITS VALUES ('S0068','P0071','Music');
INSERT INTO CREDITS VALUES ('S0069','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0069','P0088','Music');
INSERT INTO CREDITS VALUES ('S0070','P0073','Lyrics');
INSERT INTO CREDITS VALUES ('S0070','P0073','Music');
INSERT INTO CREDITS VALUES ('S0071','P0090','Lyrics');
INSERT INTO CREDITS VALUES ('S0071','P0091','Lyrics');
INSERT INTO CREDITS VALUES ('S0071','P0090','Music');
INSERT INTO CREDITS VALUES ('S0072','P0092','Lyrics');
INSERT INTO CREDITS VALUES ('S0072','P0013','Music');
INSERT INTO CREDITS VALUES ('S0073','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0073','P0088','Music');
INSERT INTO CREDITS VALUES ('S0074','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0074','P0073','Music');
INSERT INTO CREDITS VALUES ('S0075','P0024','Lyrics');
INSERT INTO CREDITS VALUES ('S0075','P0024','Music');
INSERT INTO CREDITS VALUES ('S0076','P0053','Lyrics');
INSERT INTO CREDITS VALUES ('S0076','P0093','Lyrics');
INSERT INTO CREDITS VALUES ('S0076','P0052','Music');
INSERT INTO CREDITS VALUES ('S0077','P0044','Lyrics');
INSERT INTO CREDITS VALUES ('S0077','P0044','Music');
INSERT INTO CREDITS VALUES ('S0078','P0050','Lyrics');
INSERT INTO CREDITS VALUES ('S0078','P0071','Music');
INSERT INTO CREDITS VALUES ('S0079','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0079','P0094','Music');
INSERT INTO CREDITS VALUES ('S0080','P0040','Lyrics');
INSERT INTO CREDITS VALUES ('S0080','P0096','Music');
INSERT INTO CREDITS VALUES ('S0080','P0097','Music');
INSERT INTO CREDITS VALUES ('S0080','P0098','Music');
INSERT INTO CREDITS VALUES ('S0081','P0099','Lyrics');
INSERT INTO CREDITS VALUES ('S0081','P0011','Music');
INSERT INTO CREDITS VALUES ('S0082','P0053','Lyrics');
INSERT INTO CREDITS VALUES ('S0082','P0052','Music');
INSERT INTO CREDITS VALUES ('S0082','P0100','Music');
INSERT INTO CREDITS VALUES ('S0083','P0103','Lyrics');
INSERT INTO CREDITS VALUES ('S0083','P0101','Music');
INSERT INTO CREDITS VALUES ('S0083','P0102','Music');
INSERT INTO CREDITS VALUES ('S0084','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0084','P0013','Music');
INSERT INTO CREDITS VALUES ('S0085','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0085','P0088','Music');
INSERT INTO CREDITS VALUES ('S0086','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0086','P0088','Music');
INSERT INTO CREDITS VALUES ('S0087','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0087','P0013','Music');
INSERT INTO CREDITS VALUES ('S0088','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0088','P0088','Music');
INSERT INTO CREDITS VALUES ('S0089','P0014','Lyrics');
INSERT INTO CREDITS VALUES ('S0089','P0013','Music');
INSERT INTO CREDITS VALUES ('S0090','P0105','Lyrics');
INSERT INTO CREDITS VALUES ('S0090','P0104','Music');
INSERT INTO CREDITS VALUES ('S0091','P0107','Lyrics');
INSERT INTO CREDITS VALUES ('S0091','P0106','Music');
INSERT INTO CREDITS VALUES ('S0092','P0053','Lyrics');
INSERT INTO CREDITS VALUES ('S0092','P0108','Lyrics');
INSERT INTO CREDITS VALUES ('S0092','P0052','Music');
INSERT INTO CREDITS VALUES ('S0093','P0109','Lyrics');
INSERT INTO CREDITS VALUES ('S0093','P0109','Music');
INSERT INTO CREDITS VALUES ('S0094','P0077','Lyrics');
INSERT INTO CREDITS VALUES ('S0094','P0037','Music');
INSERT INTO CREDITS VALUES ('S0095','P0110','Lyrics');
INSERT INTO CREDITS VALUES ('S0095','P0110','Music');
INSERT INTO CREDITS VALUES ('S0096','P0036','Lyrics');
INSERT INTO CREDITS VALUES ('S0096','P0096','Music');
INSERT INTO CREDITS VALUES ('S0096','P0097','Music');
INSERT INTO CREDITS VALUES ('S0097','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0097','P0111','Music');
INSERT INTO CREDITS VALUES ('S0098','P0074','Lyrics');
INSERT INTO CREDITS VALUES ('S0098','P0083','Music');
INSERT INTO CREDITS VALUES ('S0099','P0113','Lyrics');
INSERT INTO CREDITS VALUES ('S0099','P0025','Music');
INSERT INTO CREDITS VALUES ('S0100','P0066','Lyrics');
INSERT INTO CREDITS VALUES ('S0100','P0114','Music');
INSERT INTO CREDITS VALUES ('S0101','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0101','P0088','Music');
INSERT INTO CREDITS VALUES ('S0102','P0082','Lyrics');
INSERT INTO CREDITS VALUES ('S0102','P0115','Music');
INSERT INTO CREDITS VALUES ('S0103','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0103','P0116','Music');
INSERT INTO CREDITS VALUES ('S0104','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0104','P0115','Music');
INSERT INTO CREDITS VALUES ('S0105','P0118','Lyrics');
INSERT INTO CREDITS VALUES ('S0105','P0119','Lyrics');
INSERT INTO CREDITS VALUES ('S0105','P0117','Music');
INSERT INTO CREDITS VALUES ('S0106','P0030','Lyrics');
INSERT INTO CREDITS VALUES ('S0106','P0071','Music');
INSERT INTO CREDITS VALUES ('S0107','P0120','Lyrics');
INSERT INTO CREDITS VALUES ('S0107','P0120','Music');
INSERT INTO CREDITS VALUES ('S0108','P0089','Lyrics');
INSERT INTO CREDITS VALUES ('S0108','P0088','Music');
INSERT INTO CREDITS VALUES ('S0109','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0109','P0115','Music');
INSERT INTO CREDITS VALUES ('S0110','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0110','P0052','Music');
INSERT INTO CREDITS VALUES ('S0111','P0012','Lyrics');
INSERT INTO CREDITS VALUES ('S0111','P0122','Music');
INSERT INTO CREDITS VALUES ('S0112','P0123','Lyrics');
INSERT INTO CREDITS VALUES ('S0112','P0052','Music');
INSERT INTO CREDITS VALUES ('S0113','P0124','Lyrics');
INSERT INTO CREDITS VALUES ('S0113','P0052','Music');
INSERT INTO CREDITS VALUES ('S0114','P0125','Lyrics');
INSERT INTO CREDITS VALUES ('S0114','P0126','Lyrics');
INSERT INTO CREDITS VALUES ('S0114','P0127','Lyrics');
INSERT INTO CREDITS VALUES ('S0114','P0125','Music');
INSERT INTO CREDITS VALUES ('S0114','P0126','Music');
INSERT INTO CREDITS VALUES ('S0114','P0127','Music');
INSERT INTO CREDITS VALUES ('S0115','P0129','Lyrics');
INSERT INTO CREDITS VALUES ('S0115','P0128','Music');
INSERT INTO CREDITS VALUES ('S0116','P0086','Lyrics');
INSERT INTO CREDITS VALUES ('S0116','P0130','Lyrics');
INSERT INTO CREDITS VALUES ('S0116','P0131','Lyrics');
INSERT INTO CREDITS VALUES ('S0116','P0086','Music');
INSERT INTO CREDITS VALUES ('S0116','P0130','Music');
INSERT INTO CREDITS VALUES ('S0116','P0131','Music');
INSERT INTO CREDITS VALUES ('S0117','P0133','Lyrics');
INSERT INTO CREDITS VALUES ('S0117','P0132','Music');
INSERT INTO CREDITS VALUES ('S0118','P0096','Music');
INSERT INTO CREDITS VALUES ('S0118','P0134','Music');
INSERT INTO CREDITS VALUES ('S0119','P0136','Lyrics');
INSERT INTO CREDITS VALUES ('S0119','P0137','Lyrics');
INSERT INTO CREDITS VALUES ('S0119','P0135','Music');
INSERT INTO CREDITS VALUES ('S0120','P0138','Lyrics');
INSERT INTO CREDITS VALUES ('S0120','P0052','Music');
INSERT INTO CREDITS VALUES ('S0121','P0139','Lyrics');
INSERT INTO CREDITS VALUES ('S0121','P0140','Lyrics');
INSERT INTO CREDITS VALUES ('S0121','P0139','Music');
INSERT INTO CREDITS VALUES ('S0122','P0142','Lyrics');
INSERT INTO CREDITS VALUES ('S0122','P0141','Music');
INSERT INTO CREDITS VALUES ('S0123','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0123','P0037','Music');
INSERT INTO CREDITS VALUES ('S0124','P0135','Lyrics');
INSERT INTO CREDITS VALUES ('S0124','P0137','Lyrics');
INSERT INTO CREDITS VALUES ('S0124','P0135','Music');
INSERT INTO CREDITS VALUES ('S0124','P0137','Music');
INSERT INTO CREDITS VALUES ('S0125','P0145','Lyrics');
INSERT INTO CREDITS VALUES ('S0125','P0143','Music');
INSERT INTO CREDITS VALUES ('S0125','P0144','Music');
INSERT INTO CREDITS VALUES ('S0126','P0143','Lyrics');
INSERT INTO CREDITS VALUES ('S0126','P0143','Music');
INSERT INTO CREDITS VALUES ('S0126','P0146','Music');
INSERT INTO CREDITS VALUES ('S0127','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0127','P0147','Music');
INSERT INTO CREDITS VALUES ('S0128','P0149','Lyrics');
INSERT INTO CREDITS VALUES ('S0128','P0148','Music');
INSERT INTO CREDITS VALUES ('S0129','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0129','P0147','Music');
INSERT INTO CREDITS VALUES ('S0130','P0150','Lyrics');
INSERT INTO CREDITS VALUES ('S0130','P0151','Lyrics');
INSERT INTO CREDITS VALUES ('S0130','P0100','Music');
INSERT INTO CREDITS VALUES ('S0131','P0111','Lyrics');
INSERT INTO CREDITS VALUES ('S0131','P0152','Lyrics');
INSERT INTO CREDITS VALUES ('S0131','P0111','Music');
INSERT INTO CREDITS VALUES ('S0131','P0152','Music');
INSERT INTO CREDITS VALUES ('S0132','P0052','Music');
INSERT INTO CREDITS VALUES ('S0133','P0153','Lyrics');
INSERT INTO CREDITS VALUES ('S0133','P0154','Lyrics');
INSERT INTO CREDITS VALUES ('S0133','P0155','Lyrics');
INSERT INTO CREDITS VALUES ('S0133','P0153','Music');
INSERT INTO CREDITS VALUES ('S0133','P0154','Music');
INSERT INTO CREDITS VALUES ('S0133','P0155','Music');
INSERT INTO CREDITS VALUES ('S0134','P0152','Lyrics');
INSERT INTO CREDITS VALUES ('S0134','P0111','Music');
INSERT INTO CREDITS VALUES ('S0135','P0146','Music');
INSERT INTO CREDITS VALUES ('S0135','P0156','Music');
INSERT INTO CREDITS VALUES ('S0135','P0157','Music');
INSERT INTO CREDITS VALUES ('S0136','P0135','Lyrics');
INSERT INTO CREDITS VALUES ('S0136','P0137','Lyrics');
INSERT INTO CREDITS VALUES ('S0136','P0135','Music');
INSERT INTO CREDITS VALUES ('S0136','P0137','Music');
INSERT INTO CREDITS VALUES ('S0137','P0158','Lyrics');
INSERT INTO CREDITS VALUES ('S0137','P0025','Music');
INSERT INTO CREDITS VALUES ('S0138','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0138','P0083','Music');
INSERT INTO CREDITS VALUES ('S0139','P0124','Lyrics');
INSERT INTO CREDITS VALUES ('S0139','P0052','Music');
INSERT INTO CREDITS VALUES ('S0140','P0044','Lyrics');
INSERT INTO CREDITS VALUES ('S0140','P0044','Music');
INSERT INTO CREDITS VALUES ('S0141','P0109','Music');
INSERT INTO CREDITS VALUES ('S0141','P0159','Music');
INSERT INTO CREDITS VALUES ('S0142','P0160','Lyrics');
INSERT INTO CREDITS VALUES ('S0142','P0161','Lyrics');
INSERT INTO CREDITS VALUES ('S0142','P0162','Lyrics');
INSERT INTO CREDITS VALUES ('S0142','P0160','Music');
INSERT INTO CREDITS VALUES ('S0142','P0161','Music');
INSERT INTO CREDITS VALUES ('S0142','P0162','Music');
INSERT INTO CREDITS VALUES ('S0143','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0143','P0115','Music');
INSERT INTO CREDITS VALUES ('S0144','P0143','Music');
INSERT INTO CREDITS VALUES ('S0145','P0163','Lyrics');
INSERT INTO CREDITS VALUES ('S0145','P0156','Music');
INSERT INTO CREDITS VALUES ('S0145','P0157','Music');
INSERT INTO CREDITS VALUES ('S0146','P0165','Lyrics');
INSERT INTO CREDITS VALUES ('S0146','P0164','Music');
INSERT INTO CREDITS VALUES ('S0147','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0147','P0115','Music');
INSERT INTO CREDITS VALUES ('S0148','P0166','Lyrics');
INSERT INTO CREDITS VALUES ('S0148','P0156','Music');
INSERT INTO CREDITS VALUES ('S0149','P0156','Music');
INSERT INTO CREDITS VALUES ('S0150','P0143','Music');
INSERT INTO CREDITS VALUES ('S0151','P0030','Lyrics');
INSERT INTO CREDITS VALUES ('S0151','P0088','Music');
INSERT INTO CREDITS VALUES ('S0152','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0152','P0167','Music');
INSERT INTO CREDITS VALUES ('S0153','P0159','Music');
INSERT INTO CREDITS VALUES ('S0154','P0168','Music');
INSERT INTO CREDITS VALUES ('S0155','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0155','P0170','Lyrics');
INSERT INTO CREDITS VALUES ('S0155','P0169','Music');
INSERT INTO CREDITS VALUES ('S0156','P0168','Music');
INSERT INTO CREDITS VALUES ('S0157','P0143','Music');
INSERT INTO CREDITS VALUES ('S0157','P0168','Music');
INSERT INTO CREDITS VALUES ('S0158','P0168','Music');
INSERT INTO CREDITS VALUES ('S0159','P0172','Lyrics');
INSERT INTO CREDITS VALUES ('S0159','P0171','Music');
INSERT INTO CREDITS VALUES ('S0160','P0168','Music');
INSERT INTO CREDITS VALUES ('S0161','P0173','Lyrics');
INSERT INTO CREDITS VALUES ('S0161','P0141','Music');
INSERT INTO CREDITS VALUES ('S0162','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0162','P0083','Music');
INSERT INTO CREDITS VALUES ('S0163','P0174','Lyrics');
INSERT INTO CREDITS VALUES ('S0163','P0175','Lyrics');
INSERT INTO CREDITS VALUES ('S0163','P0176','Lyrics');
INSERT INTO CREDITS VALUES ('S0163','P0174','Music');
INSERT INTO CREDITS VALUES ('S0163','P0175','Music');
INSERT INTO CREDITS VALUES ('S0163','P0176','Music');
INSERT INTO CREDITS VALUES ('S0164','P0143','Music');
INSERT INTO CREDITS VALUES ('S0164','P0168','Music');
INSERT INTO CREDITS VALUES ('S0165','P0077','Lyrics');
INSERT INTO CREDITS VALUES ('S0165','P0065','Music');
INSERT INTO CREDITS VALUES ('S0166','P0168','Music');
INSERT INTO CREDITS VALUES ('S0166','P0177','Music');
INSERT INTO CREDITS VALUES ('S0167','P0168','Music');
INSERT INTO CREDITS VALUES ('S0168','P0172','Lyrics');
INSERT INTO CREDITS VALUES ('S0168','P0179','Lyrics');
INSERT INTO CREDITS VALUES ('S0168','P0178','Music');
INSERT INTO CREDITS VALUES ('S0168','P0179','Music');
INSERT INTO CREDITS VALUES ('S0169','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0169','P0156','Music');
INSERT INTO CREDITS VALUES ('S0169','P0180','Music');
INSERT INTO CREDITS VALUES ('S0170','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0170','P0115','Music');
INSERT INTO CREDITS VALUES ('S0171','P0181','Lyrics');
INSERT INTO CREDITS VALUES ('S0171','P0159','Music');
INSERT INTO CREDITS VALUES ('S0172','P0182','Music');
INSERT INTO CREDITS VALUES ('S0173','P0156','Music');
INSERT INTO CREDITS VALUES ('S0174','P0168','Music');
INSERT INTO CREDITS VALUES ('S0175','P0077','Lyrics');
INSERT INTO CREDITS VALUES ('S0175','P0183','Music');
INSERT INTO CREDITS VALUES ('S0176','P0168','Music');
INSERT INTO CREDITS VALUES ('S0177','P0168','Music');
INSERT INTO CREDITS VALUES ('S0178','P0143','Music');
INSERT INTO CREDITS VALUES ('S0179','P0182','Music');
INSERT INTO CREDITS VALUES ('S0180','P0160','Lyrics');
INSERT INTO CREDITS VALUES ('S0180','P0184','Music');
INSERT INTO CREDITS VALUES ('S0181','P0186','Lyrics');
INSERT INTO CREDITS VALUES ('S0181','P0185','Music');
INSERT INTO CREDITS VALUES ('S0182','P0143','Music');
INSERT INTO CREDITS VALUES ('S0182','P0187','Music');
INSERT INTO CREDITS VALUES ('S0182','P0188','Music');
INSERT INTO CREDITS VALUES ('S0183','P0189','Lyrics');
INSERT INTO CREDITS VALUES ('S0183','P0189','Music');
INSERT INTO CREDITS VALUES ('S0184','P0156','Music');
INSERT INTO CREDITS VALUES ('S0185','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0185','P0190','Music');
INSERT INTO CREDITS VALUES ('S0186','P0191','Lyrics');
INSERT INTO CREDITS VALUES ('S0186','P0132','Music');
INSERT INTO CREDITS VALUES ('S0187','P0077','Lyrics');
INSERT INTO CREDITS VALUES ('S0187','P0065','Music');
INSERT INTO CREDITS VALUES ('S0188','P0182','Music');
INSERT INTO CREDITS VALUES ('S0189','P0192','Music');
INSERT INTO CREDITS VALUES ('S0190','P0120','Lyrics');
INSERT INTO CREDITS VALUES ('S0190','P0120','Music');
INSERT INTO CREDITS VALUES ('S0191','P0193','Music');
INSERT INTO CREDITS VALUES ('S0192','P0194','Lyrics');
INSERT INTO CREDITS VALUES ('S0192','P0194','Music');
INSERT INTO CREDITS VALUES ('S0193','P0168','Music');
INSERT INTO CREDITS VALUES ('S0194','P0168','Music');
INSERT INTO CREDITS VALUES ('S0195','P0168','Music');
INSERT INTO CREDITS VALUES ('S0196','P0195','Lyrics');
INSERT INTO CREDITS VALUES ('S0196','P0156','Music');
INSERT INTO CREDITS VALUES ('S0197','P0143','Music');
INSERT INTO CREDITS VALUES ('S0198','P0057','Lyrics');
INSERT INTO CREDITS VALUES ('S0198','P0065','Music');
INSERT INTO CREDITS VALUES ('S0199','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0199','P0156','Music');
INSERT INTO CREDITS VALUES ('S0200','P0197','Lyrics');
INSERT INTO CREDITS VALUES ('S0200','P0196','Music');
INSERT INTO CREDITS VALUES ('S0201','P0199','Lyrics');
INSERT INTO CREDITS VALUES ('S0201','P0200','Lyrics');
INSERT INTO CREDITS VALUES ('S0201','P0198','Music');
INSERT INTO CREDITS VALUES ('S0202','P0138','Lyrics');
INSERT INTO CREDITS VALUES ('S0202','P0183','Music');
INSERT INTO CREDITS VALUES ('S0203','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0203','P0115','Music');
INSERT INTO CREDITS VALUES ('S0204','P0201','Lyrics');
INSERT INTO CREDITS VALUES ('S0204','P0202','Lyrics');
INSERT INTO CREDITS VALUES ('S0204','P0201','Music');
INSERT INTO CREDITS VALUES ('S0204','P0202','Music');
INSERT INTO CREDITS VALUES ('S0205','P0182','Music');
INSERT INTO CREDITS VALUES ('S0206','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0206','P0052','Music');
INSERT INTO CREDITS VALUES ('S0206','P0120','Music');
INSERT INTO CREDITS VALUES ('S0207','P0203','Lyrics');
INSERT INTO CREDITS VALUES ('S0207','P0205','Lyrics');
INSERT INTO CREDITS VALUES ('S0207','P0203','Music');
INSERT INTO CREDITS VALUES ('S0207','P0204','Music');
INSERT INTO CREDITS VALUES ('S0208','P0044','Lyrics');
INSERT INTO CREDITS VALUES ('S0208','P0044','Music');
INSERT INTO CREDITS VALUES ('S0209','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0209','P0206','Music');
INSERT INTO CREDITS VALUES ('S0210','P0206','Music');
INSERT INTO CREDITS VALUES ('S0211','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0211','P0207','Music');
INSERT INTO CREDITS VALUES ('S0212','P0208','Lyrics');
INSERT INTO CREDITS VALUES ('S0212','P0208','Music');
INSERT INTO CREDITS VALUES ('S0213','P0210','Lyrics');
INSERT INTO CREDITS VALUES ('S0213','P0209','Music');
INSERT INTO CREDITS VALUES ('S0214','P0095','Lyrics');
INSERT INTO CREDITS VALUES ('S0214','P0211','Music');
INSERT INTO CREDITS VALUES ('S0215','P0212','Music');
INSERT INTO CREDITS VALUES ('S0216','P0206','Music');
INSERT INTO CREDITS VALUES ('S0217','P0182','Music');
INSERT INTO CREDITS VALUES ('S0218','P0156','Music');
INSERT INTO CREDITS VALUES ('S0219','P0182','Music');
INSERT INTO CREDITS VALUES ('S0220','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0220','P0133','Lyrics');
INSERT INTO CREDITS VALUES ('S0220','P0168','Music');
INSERT INTO CREDITS VALUES ('S0221','P0213','Music');
INSERT INTO CREDITS VALUES ('S0222','P0215','Lyrics');
INSERT INTO CREDITS VALUES ('S0222','P0214','Music');
INSERT INTO CREDITS VALUES ('S0223','P0207','Music');
INSERT INTO CREDITS VALUES ('S0224','P0216','Music');
INSERT INTO CREDITS VALUES ('S0224','P0217','Music');
INSERT INTO CREDITS VALUES ('S0225','P0210','Lyrics');
INSERT INTO CREDITS VALUES ('S0225','P0213','Music');
INSERT INTO CREDITS VALUES ('S0226','P0218','Music');
INSERT INTO CREDITS VALUES ('S0227','P0206','Music');
INSERT INTO CREDITS VALUES ('S0228','P0206','Music');
INSERT INTO CREDITS VALUES ('S0229','P0206','Music');
INSERT INTO CREDITS VALUES ('S0230','P0219','Music');
INSERT INTO CREDITS VALUES ('S0231','P0219','Music');
INSERT INTO CREDITS VALUES ('S0232','P0219','Music');
INSERT INTO CREDITS VALUES ('S0233','P0213','Music');
INSERT INTO CREDITS VALUES ('S0234','P0182','Music');
INSERT INTO CREDITS VALUES ('S0235','P0182','Lyrics');
INSERT INTO CREDITS VALUES ('S0235','P0182','Music');
INSERT INTO CREDITS VALUES ('S0236','P0156','Music');
INSERT INTO CREDITS VALUES ('S0237','P0220','Music');
INSERT INTO CREDITS VALUES ('S0238','P0221','Music');
INSERT INTO CREDITS VALUES ('S0239','P0213','Music');
INSERT INTO CREDITS VALUES ('S0240','P0209','Music');
INSERT INTO CREDITS VALUES ('S0241','P0219','Music');
INSERT INTO CREDITS VALUES ('S0242','P0219','Music');
INSERT INTO CREDITS VALUES ('S0243','P0222','Music');
INSERT INTO CREDITS VALUES ('S0244','P0219','Music');
INSERT INTO CREDITS VALUES ('S0245','P0182','Music');
INSERT INTO CREDITS VALUES ('S0245','P0223','Music');
INSERT INTO CREDITS VALUES ('S0246','P0030','Lyrics');
INSERT INTO CREDITS VALUES ('S0246','P0088','Music');
INSERT INTO CREDITS VALUES ('S0247','P0215','Lyrics');
INSERT INTO CREDITS VALUES ('S0247','P0224','Music');
INSERT INTO CREDITS VALUES ('S0248','P0182','Music');
INSERT INTO CREDITS VALUES ('S0249','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0249','P0182','Music');
INSERT INTO CREDITS VALUES ('S0250','P0226','Lyrics');
INSERT INTO CREDITS VALUES ('S0250','P0225','Music');
INSERT INTO CREDITS VALUES ('S0251','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0251','P0228','Lyrics');
INSERT INTO CREDITS VALUES ('S0251','P0227','Music');
INSERT INTO CREDITS VALUES ('S0252','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0252','P0229','Music');
INSERT INTO CREDITS VALUES ('S0253','P0226','Lyrics');
INSERT INTO CREDITS VALUES ('S0253','P0182','Music');
INSERT INTO CREDITS VALUES ('S0254','P0219','Music');
INSERT INTO CREDITS VALUES ('S0255','P0231','Lyrics');
INSERT INTO CREDITS VALUES ('S0255','P0230','Music');
INSERT INTO CREDITS VALUES ('S0256','P0231','Lyrics');
INSERT INTO CREDITS VALUES ('S0256','P0230','Music');
INSERT INTO CREDITS VALUES ('S0257','P0232','Lyrics');
INSERT INTO CREDITS VALUES ('S0257','P0233','Lyrics');
INSERT INTO CREDITS VALUES ('S0257','P0227','Music');
INSERT INTO CREDITS VALUES ('S0258','P0219','Music');
INSERT INTO CREDITS VALUES ('S0259','P0226','Lyrics');
INSERT INTO CREDITS VALUES ('S0259','P0220','Music');
INSERT INTO CREDITS VALUES ('S0260','P0234','Lyrics');
INSERT INTO CREDITS VALUES ('S0260','P0227','Music');
INSERT INTO CREDITS VALUES ('S0261','P0235','Music');
INSERT INTO CREDITS VALUES ('S0262','P0205','Lyrics');
INSERT INTO CREDITS VALUES ('S0262','P0236','Music');
INSERT INTO CREDITS VALUES ('S0263','P0219','Music');
INSERT INTO CREDITS VALUES ('S0264','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0264','P0228','Lyrics');
INSERT INTO CREDITS VALUES ('S0264','P0227','Music');
INSERT INTO CREDITS VALUES ('S0265','P0238','Lyrics');
INSERT INTO CREDITS VALUES ('S0265','P0237','Music');
INSERT INTO CREDITS VALUES ('S0266','P0205','Lyrics');
INSERT INTO CREDITS VALUES ('S0266','P0228','Lyrics');
INSERT INTO CREDITS VALUES ('S0266','P0227','Music');
INSERT INTO CREDITS VALUES ('S0267','P0112','Lyrics');
INSERT INTO CREDITS VALUES ('S0267','P0239','Music');
INSERT INTO CREDITS VALUES ('S0268','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0268','P0240','Music');
INSERT INTO CREDITS VALUES ('S0269','P0205','Lyrics');
INSERT INTO CREDITS VALUES ('S0269','P0232','Lyrics');
INSERT INTO CREDITS VALUES ('S0269','P0227','Music');
INSERT INTO CREDITS VALUES ('S0270','P0121','Lyrics');
INSERT INTO CREDITS VALUES ('S0270','P0182','Music');
INSERT INTO CREDITS VALUES ('S0270','P0241','Music');
INSERT INTO CREDITS VALUES ('S0271','P0205','Lyrics');
INSERT INTO CREDITS VALUES ('S0271','P0232','Lyrics');
INSERT INTO CREDITS VALUES ('S0271','P0227','Music');
INSERT INTO CREDITS VALUES ('S0272','P0242','Lyrics');
INSERT INTO CREDITS VALUES ('S0272','P0242','Music');
INSERT INTO CREDITS VALUES ('S0273','P0243','Music');
INSERT INTO CREDITS VALUES ('S0274','P0245','Lyrics');
INSERT INTO CREDITS VALUES ('S0274','P0244','Music');
INSERT INTO CREDITS VALUES ('S0275','P0246','Music');
INSERT INTO CREDITS VALUES ('S0276','P0244','Music');
INSERT INTO CREDITS VALUES ('S0277','P0219','Music');
INSERT INTO CREDITS VALUES ('S0278','P0247','Music');
INSERT INTO CREDITS VALUES ('S0279','P0240','Music');
INSERT INTO CREDITS VALUES ('S0280','P0052','Music');
INSERT INTO CREDITS VALUES ('S0280','P0120','Music');
INSERT INTO CREDITS VALUES ('S0281','P0209','Music');
INSERT INTO CREDITS VALUES ('S0282','P0248','Music');
INSERT INTO CREDITS VALUES ('S0283','P0249','Music');
INSERT INTO CREDITS VALUES ('S0284','P0250','Music');
INSERT INTO CREDITS VALUES ('S0285','P0138','Lyrics');
INSERT INTO CREDITS VALUES ('S0285','P0251','Music');
INSERT INTO CREDITS VALUES ('S0286','P0248','Music');
INSERT INTO CREDITS VALUES ('S0287','P0240','Music');
INSERT INTO CREDITS VALUES ('S0288','P0227','Lyrics');
INSERT INTO CREDITS VALUES ('S0288','P0227','Music');
INSERT INTO CREDITS VALUES ('S0289','P0240','Music');
INSERT INTO CREDITS VALUES ('S0290','P0253','Lyrics');
INSERT INTO CREDITS VALUES ('S0290','P0254','Lyrics');
INSERT INTO CREDITS VALUES ('S0290','P0252','Music');
INSERT INTO CREDITS VALUES ('S0291','P0248','Music');
INSERT INTO CREDITS VALUES ('S0292','P0248','Music');
INSERT INTO CREDITS VALUES ('S0293','P0248','Music');
INSERT INTO CREDITS VALUES ('S0294','P0255','Music');
INSERT INTO CREDITS VALUES ('S0295','P0227','Lyrics');
INSERT INTO CREDITS VALUES ('S0295','P0227','Music');
INSERT INTO CREDITS VALUES ('S0296','P0256','Lyrics');
INSERT INTO CREDITS VALUES ('S0296','P0256','Music');
INSERT INTO CREDITS VALUES ('S0297','P0240','Music');
INSERT INTO CREDITS VALUES ('S0297','P0257','Music');
INSERT INTO CREDITS VALUES ('S0297','P0258','Music');
INSERT INTO CREDITS VALUES ('S0297','P0259','Music');
INSERT INTO CREDITS VALUES ('S0298','P0260','Music');