musiccaps_details (view)
2 rows where musiccaps_aspects contains "hand percussion" and musiccaps_names contains "Rattle (instrument)" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- hand percussion · 2 ✖
- acordion harmony 1
- amateur recording 1
- animated piano 1
- arabic music 1
- bass drums 1
- bustling 1
- cello 1
- classical 1
- egyptian oud 1
- enthusiastic vocals 1
- fast tempo 1
- female vocalisation 1
- folk music 1
- funky bass lines 1
- gig 1
- hard hitting drums 1
- inferior audio quality 1
- instrumental 1
- lilting 1
- live performance 1
- medium fast 1
- middle eastern cultural music 1
- minimalist 1
- oud melody 1
- people talking 1
- poor audio quality 1
- regional musc 1
- rich 1
- shakers 1
- static 1
- stringed instrument 1
- traditional music 1
- xylophone 1
musiccaps_names (array) 7 ✖
- Music 2
- Rattle (instrument) · 2 ✖
- Jazz 1
- Middle Eastern music 1
- Musical instrument 1
- Singing 1
- Ukulele 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HESTER GOODMAN...HAT SONG.. | This song is an animated vocalisation. The tempo is fast with a lively piano accompaniment, accordion harmony, cello rhythm, hard hitting drums, groovy bass lines, hand percussion beats and xylophone. The music is upbeat, energetic,enthusiastic, high-spirited and vivacious. This is a live performance with ambient sounds of people talking and general bustling. The audio quality is inferior. This song is a live Pop. | 2010-10-21T17:54:37Z | spaceritual72 | ...HAT SONG.....from "you could at least smile" album launch night...by HESTER GOODMAN..available at.......www.ukuleleorchestra.com | ["Singing", "Jazz", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele"] | ["female vocalisation", "fast tempo", "cello", "hand percussion", "bass drums", "xylophone", "hard hitting drums", "animated piano", "shakers", "funky bass lines", "amateur recording", "live performance", "gig", "poor audio quality", "people talking", "bustling", "acordion harmony", "enthusiastic vocals"] | 7 | qXSG2uq2tNw | 4795 | |
فهد بن سعيد + هذي مفاتيح حبي + موال + لمين ابشكي غرامك + ياناعم العود انا شاكي هواك | This music is an Arabic instrumental. The tempo is medium fast with a harmonious oud and Arabic hand percussion. The music is lilting, spirited, engaging, pleasant, traditional , middle eastern folk music. | 2014-05-01T19:13:20Z | علوؤش الجابري | مشتركه | ["Music", "Rattle (instrument)", "Middle Eastern music"] | ["instrumental", "medium fast", "arabic music", "minimalist", "traditional music", "egyptian oud", "stringed instrument", "lilting", "rich", "middle eastern cultural music", "regional musc", "folk music", "classical", "static", "inferior audio quality", "oud melody", "hand percussion"] | 7 | OS4YFp3DiEE | 2442 |
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;