musiccaps_details (view)
2 rows where musiccaps_aspects contains "high gain volume" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- high gain volume · 2 ✖
- medium tempo · 2 ✖
- alto saxophone 1
- amateur recording 1
- ambient noises 1
- bad audio quality 1
- classical music 1
- crowd noise 1
- flourishes 1
- groovy 1
- groovy bass line 1
- hissing tones 1
- home video 1
- keyboard accompaniment 1
- kids dancing 1
- live performance 1
- male singer 1
- music tutor 1
- music tutorial 1
- no other instrumentation 1
- noise 1
- noisy crowds 1
- poor audio quality 1
- sax solo 1
- saxophone 1
- saxophonist 1
- school dance program 1
- school program 1
- song tutorial 1
- song walk through 1
- techno dance rhythm 1
- techno dance song 1
- youtube saxophone lessons 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maracas dance of h.bautista elem school | A male singer sings this groovy melody. The song is a techno dance song with a groovy bass line, strong drumming rhythm and a keyboard accompaniment. The song is so groovy and serves as a dance track for the dancing children. The audio quality is very poor with high gains and hissing noise. | 2013-10-27T02:32:22Z | Alma Flores | Teacher's day | ["Music", "Maraca"] | ["live performance", "poor audio quality", "ambient noises", "school dance program", "crowd noise", "high gain volume", "hissing tones", "medium tempo", "techno dance song", "male singer", "groovy bass line", "techno dance rhythm", "keyboard accompaniment", "kids dancing", "noisy crowds", "home video", "school program", "noise"] | 1 | -1UWSisR2zo | 7 | |
OMI - CHEERLEADER - (TRUMPET PART ON ALTO SAX) SANTIAGO PACHECO | A saxophonist plays a phrase on the alto sax and explains the movement. The song is medium tempo with no other instrumentation. The audio quality is poor and serves as an online music tutorial. | 2015-08-28T07:11:42Z | santiago pacheco | Hi! My name is Santiago Pacheco, and make sax tutorials. This tutorial is on the trumpet part on OIM's Cheerleader song, I hope you like it. Facebook link https://www.facebook.com/santiagosaxtutorials?ref=hl | ["Brass instrument", "Saxophone"] | ["saxophonist", "saxophone", "alto saxophone", "groovy", "classical music", "flourishes", "music tutorial", "song tutorial", "bad audio quality", "music tutor", "song walk through", "amateur recording", "medium tempo", "sax solo", "no other instrumentation", "high gain volume", "youtube saxophone lessons"] | 1 | iUxy2s5d60o | 4192 |
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;