musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "no percussions" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- instrumental music · 3 ✖
- no percussions · 3 ✖
- passionate · 3 ✖
- bad audio quality 2
- medium tempo 2
- no other instrumentation 2
- poor audio quality 2
- amateur play 1
- classical music 1
- customary 1
- dance music 1
- deer horn 1
- devotional 1
- disc scratching tones 1
- dj 1
- dj face off 1
- dj maestro 1
- eerie tones 1
- emotional 1
- enthusiastic 1
- exciting 1
- exorcism sounds 1
- groovy music 1
- hebrew music 1
- home video 1
- horn player 1
- inspiring 1
- jewish customs 1
- jewish music 1
- learner 1
- legato playing 1
- live audience 1
- live performance 1
- man talking 1
- meditational 1
- no harmonies 1
- recital 1
- religious customs 1
- retro dj music 1
- romantic 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- soloist 1
- spirited 1
- spiritual 1
- syncopated music 1
- techno dance music 1
- tenor sax 1
- vibrato style 1
- youtube music video 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 | |
Shofar Lesson 1: Types of Horns | The song is an instrumental. The song is medium tempo with a horn player playing a deer horn in a repeated manner. The song is spiritual and customary. The song has bad audio quality. | 2010-11-17T17:20:02Z | Jewish Voice | Dwight Carrell of Messianic Jewish ministry Jewish Voice demonstrates the sounds of three shofars (animal horn trumpets), which are blown in Messianic congregations - the sound of the traditional ram's horn, the sound of the oryx, and the sound of the kudu. He also explains how to blow a shofar correctly. http://www.jewishvoice.org To purchase a shofar, got to http://www.jewishvoice.org, click on "Store," and then search for "shofar" in the search field. | ["Wind instrument, woodwind instrument", "Shofar"] | ["deer horn", "horn player", "hebrew music", "customary", "no percussions", "no other instrumentation", "soloist", "instrumental music", "medium tempo", "man talking", "poor audio quality", "religious customs", "meditational", "inspiring", "devotional", "jewish customs", "passionate", "inspiring", "meditational", "spiritual", "jewish music"] | 1 | qh-4EDX4agQ | 4808 | |
1997 World ITF DJ Finals - Scratching Final - DJ Babu vs Tony Vegas | The song is an instrumental. The song is medium with a DJ creating scratchy tones by scratching vinyl on a turntable. The DJ creates an eerie and syncopated rhythm. The audio is bad quality. | 2012-12-14T20:20:54Z | DJ_Fobtronics | Babu as always, great on the cut. Tony Vegas, some nice stuff, but errors cost him. Mis calc'd the encode slightly, chopped the last 4 seconds. Classic Beat Juggling Final here: https://www.youtube.com/watch?v=ZYWhurwQajU | ["Scratching (performance technique)", "Music"] | ["disc scratching tones", "dj", "dance music", "retro dj music", "no harmonies", "exorcism sounds", "no percussions", "eerie tones", "dj maestro", "techno dance music", "instrumental music", "bad audio quality", "groovy music", "live performance", "exciting", "enthusiastic", "passionate", "dj face off", "live audience", "syncopated music"] | 1 | y4vtzCAPv84 | 5378 |
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;