musiccaps_details (view)
2 rows where musiccaps_aspects contains "shimmering shaker" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- shimmering shaker · 2 ✖
- uptempo · 2 ✖
- 4 on the floor kick 1
- addictive 1
- clapping 1
- crowd chattering 1
- didgeridoo melody 1
- echoing male vocal 1
- energetic 1
- groovy bass 1
- low quality 1
- noisy 1
- reverberant 1
- synth flute melody 1
- synth keys melody 1
- urban latin 1
- wide reverberant percussive elements 1
- wooden percussion 1
musiccaps_names (array) 4 ✖
- Music 2
- Afrobeat 1
- Didgeridoo 1
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Richard Bridge - Didjeridu Reading Didje club | The low quality recording features a didgeridoo melody played over wooden percussion and shimmering shaker. There are some crowd chattering noises in the background. It is reverberant, due to the fact that it was performed in a medium size room, uptempo and the recording is noisy. | 2007-12-19T09:15:09Z | didjedude | This is Richard Bridge a good friend of mine playing at the Reading Didje club (UK).... Enjoy! Richards album is available from Anticearthworks.co.uk under sales, £10 but well worth it. Added 16th August 2012: Rich has a spanking new website of his own now www.richardbridgemusic.com check it out, it's all peace, love and happiness :0) | ["Didgeridoo", "Music"] | ["wooden percussion", "shimmering shaker", "didgeridoo melody", "reverberant", "crowd chattering", "uptempo", "low quality", "noisy"] | 4 | U0sjbOT6hY4 | 2882 | |
Davido -Skelewu lyrics | The Urban Latin song features an echoing male vocal singing repetitive lyrics over wide reverberant percussive elements, synth flute melody, claps, "4 on the floor" kick pattern, shimmering shaker, groovy bass and synth keys melody. It is uptempo and it sounds energetic and addictive, like something you would hear in clubs a lot. | 2013-10-25T20:55:09Z | Tai Kenny | I DO NOT CLAIM TO OWN ANY OF THE AUDIO USED IN THIS VIDEO. NO COPYRIGHT INTENDED!!!! | ["Afrobeat", "Music of Africa", "Music"] | ["urban latin", "wide reverberant percussive elements", "echoing male vocal", "synth flute melody", "clapping", "4 on the floor kick", "shimmering shaker", "groovy bass", "synth keys melody", "uptempo", "energetic", "addictive"] | 4 | ax8hXst_b5g | 3588 |
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;