musiccaps_details (view)
2 rows where musiccaps_aspects contains "jarring tones" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- jarring tones · 2 ✖
- aggressive 1
- amateur recording 1
- audio buzz noises 1
- audio quality deterioration 1
- bad quality recording 1
- bell tones 1
- children’s church choir 1
- choral harmony 1
- choral music 1
- christian classical music 1
- church choir 1
- church organ playing 1
- distorted tones 1
- electric guitar lead 1
- emotional 1
- exciting 1
- experimental 1
- goofing around 1
- guitar overtones 1
- guitar practice routine 1
- hard metal 1
- heavenly 1
- home video recording 1
- inspiring 1
- instrumental music 1
- male and female singers 1
- meditational 1
- medium tempo 1
- no 1
- no other instrumentation 1
- no percussion instrumentation 1
- no percussion instruments 1
- passionate 1
- percussion instruments 1
- playing alone 1
- playing rhythmically 1
- prayerful 1
- rebellious 1
- rock music 1
- slow tempo 1
- spirited 1
- western classical music 1
musiccaps_names (array) 5 ✖
- Music 2
- Sad music 2
- Background music 1
- Distortion 1
- Electric guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kirby's Epic Yarn: Fanmade boss battle music (intro) | The song is an instrumental. The song is medium tempo with an overdriven guitar playing a jarring lead in rhythmic fashion and guitar over tones that sound like bell tones. The song is aggressive and experimental. The song is a modern rock intro. | 2010-06-20T16:06:40Z | joinmebowser9000 | the title says it all. maybe its to heavy for this kirby game xD | ["Electric guitar", "Music", "Distortion", "Sad music"] | ["electric guitar lead", "distorted tones", "experimental", "playing alone", "guitar practice routine", "no percussion instrumentation", "goofing around", "instrumental music", "playing rhythmically", "guitar overtones", "no", "percussion instruments", "jarring tones", "bell tones", "rock music", "exciting", "spirited", "rebellious", "aggressive", "no other instrumentation", "medium tempo", "hard metal"] | 1 | rfah0bhmYkc | 4893 | |
XAVER VARNUS: MY LIFE IS THE ORGAN - 18TH PART (SONY MUSIC, 2007) | The song is a vintage recording of a church choir singing in vocal harmony. The song is medium tempo with a church organ accompanying the choir with no other instrumentation. The song is devotional and prayerful. The audio quality is highly deteriorated and is probably an amateur home video recording. The song is a classic church choir harmony. | 2011-08-28T23:36:51Z | Xaver Varnus | "The film about the incomparable Hungarian-Canadian organist Xaver Varnus is an experience for all, who have been deeply affected by this man's art. Varnus was often called "the Horowitz of the organ" - and not just by the press, but by many leading organists themselves. This film contains treasures of archival footage of Varnus in recitals, his own recollections of his fascinating life and the on-camera interviews given in 2008. The film is very well-made, balancing as it does Varnus' voice-over narration with historical footage of many events in Europe. It is incredible to follow the life of one human being, who rises to world prominence out of the circumstances, which made his very survival questionable and to sense in all of it the Guidance of a Higher Power. The Guidance, which is available to every human being, but which is simply more noticeable in Varnus' case." (Francois Fejto, journalist of Le Figaro) A film by Mate Vargha. Sony Music, 2007 (233 min.) 1st part: http://www.youtube.com/watch?v=x5rbXWfxz7k 2nd part: http://www.youtube.com/watch?v=yvqw4ZLR52Y 3rd part: http://www.youtube.com/watch?v=vEQHe-nXkns 4th part: http://www.youtube.com/watch?v=Ho5CiI_w02o 5th part: http://www.youtube.com/watch?v=RY09aVHM8Yg 6th part: http://www.youtube.com/watch?v=DqIcF2fMEbk 7th part: http://www.youtube.com/watch?v=2xwv-SOML7s 8th part: http://www.youtube.com/watch?v=XiZmkolLkZ0 9th part: http://www.youtube.com/watch?v=uwgsy-ZWhpk 10th part: http://www.youtube.com/watch?v=oFRyKnp5vNo 11th part: http://www.youtube.com/watch?v=j1AFilIqCn0 12th part: http://www.youtube.com/watch?v=PMWsILDGrmg 13th part: http://www.youtube.com/watch?v=J7sf8UR5c64 14th part: http://www.youtube.com/watch?v=Cz3c-0era7M 15th part: http://www.youtube.com/watch?v=4EXUu-Lf37k 16th part: http://www.youtube.com/watch?v=4r8v4CIufVA 17th part: http://www.youtube.com/watch?v=9qOj6pvDCQE 18th part: http://www.youtube.com/watch?v=tGv_L09pf6E | ["Background music", "Music", "Sad music"] | ["choral music", "bad quality recording", "western classical music", "audio buzz noises", "audio quality deterioration", "church choir", "children’s church choir", "amateur recording", "no percussion instruments", "heavenly", "meditational", "inspiring", "jarring tones", "inspiring", "christian classical music", "choral harmony", "male and female singers", "passionate", "prayerful", "emotional", "home video recording", "church organ playing", "slow tempo"] | 1 | tGv_L09pf6E | 5023 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;