musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "wooden percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- groovy bass · 4 ✖
- passionate · 4 ✖
- wooden percussions · 4 ✖
- joyful 3
- low quality 3
- happy 2
- punchy kick 2
- sustained strings melody 2
- acoustic rhythm guitar 1
- addictive 1
- addictive female vocal 1
- breathy flute melody 1
- bright brass melody 1
- distorted 1
- echoing flat male vocal 1
- electric guitar melody 1
- energetic 1
- folk 1
- groovy piano melody 1
- guiro percussion 1
- harmonizing male vocal 1
- harsh 1
- live performance 1
- messy 1
- passionate male vocal 1
- punchy snare 1
- regional mexican 1
- shimmering cymbals 1
- shimmering open hats 1
- shimmering shakers 1
- snare roll 1
- string melody 1
- traditional 1
- traditional pop 1
musiccaps_names (array) 6 ✖
- Music 4
- Salsa music 2
- Happy music 1
- Jazz 1
- Music of Asia 1
- Music of Latin America 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sozan Namo ( Seny Pr Ihm )* kurdish Music * | The low quality recording features a folk song that consists of a wooden percussion, groovy bass, breathy flute melody, groovy piano melody, shimmering shakers and sustained strings melody. It sounds passionate, joyful and happy. | 2010-05-10T13:43:42Z | Hemmen A M | Best Song .......... | ["Music", "Happy music"] | ["low quality", "folk", "wooden percussions", "groovy bass", "breathy flute melody", "groovy piano melody", "sustained strings melody", "shimmering shakers", "passionate", "happy", "joyful"] | 4 | -mA_bqD1tgU | 83 | |
Shukri Jamal - Abbaan lafaa dhabe lafasaa (Oromo Music 2014 New) | The low quality recording features an echoing flat male vocal, alongside harmonizing male vocal, singing over sustained strings melody, shimmering open hats, wooden percussions, punchy kick and groovy bass. It sounds traditional and passionate. | 2014-04-18T18:56:19Z | Oromp3 | Check http://www.oromp3.com/ for more Oromo music, comedy, drama & MP3 Songs. | ["Jazz", "Music"] | ["low quality", "echoing flat male vocal", "wooden percussions", "shimmering open hats", "sustained strings melody", "punchy kick", "groovy bass", "joyful", "passionate", "traditional", "harmonizing male vocal"] | 4 | Bap5P9buB0Y | 1264 | |
Chango - Henry Fiol | The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. | 2009-09-17T01:58:57Z | Pedro Velazco | ["Music", "Music of Latin America", "Salsa music"] | ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] | 4 | UJA5AWbt6HM | 2905 | ||
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 |
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;