musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "joyful", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "wooden percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- happy 2
- joyful · 2 ✖
- low quality · 2 ✖
- wooden percussions · 2 ✖
- acoustic rhythm guitar 1
- flat male vocal 1
- folk 1
- fun 1
- harmonica melody 1
- mellow kick hits 1
- passionate male vocal 1
- pop 1
- shimmering hi hats 1
- shimmering shakers 1
- soulful 1
- syncopated snare 1
- wide electric guitar melody 1
musiccaps_names (array) 4 ✖
- Music 2
- Blues 1
- Speech 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sayang Kinabalu Music Video by Nikki and Jimmy Palikat | The low quality recording features a pop song that consists of a passionate male vocal singing over mellow kick hits, shimmering hi hats, wide electric guitar melody, syncopated snare and wooden percussion. The first half of the loop does not consist of the vocal, snare and hi hats. It sounds happy, fun and joyful. | 2014-07-23T10:21:33Z | Hotlink | Kepada saudara-saudari dari Sabah, terima kasih atas sokongan anda. Kami harap anda seronok mendengar lagu SAYANG KINABALU dinyanyikan oleh Jimmy & Nikki Palikat. Dapatkan muat turun lagu penuh PERCUMA dengan hantar GET SYGKINABALUFS ke 29000 atau dapatkan Caller Ringtone PERCUMA dengan hantar GET SYGKINABALUCRT ke 29000. Untuk maklumat lanjut #Hotlink, sila dapatkan di www.hotlink.com.my/sabah | ["Blues", "Music"] | ["low quality", "pop", "passionate male vocal", "happy", "fun", "joyful", "mellow kick hits", "shimmering hi hats", "wide electric guitar melody", "wooden percussions", "syncopated snare"] | 4 | -rAhS48FkYw | 92 | |
Fieldsports Britain - The pigeons are back | The low quality recording features a folk song playing in the background while the flat male vocalist is speaking. The song contains shimmering shakers, acoustic rhythm guitar, wooden percussion and harmonica melody. The song sounds happy, joyful and soulful. | 2013-12-04T19:00:01Z | Fieldsports Channel | Two of Britain's most sporting birds are in the frame this week. After months of waiting, Andy Crow has thousands of pigeons on his farm, and he has some of the best pigeon shooters in the South-East of England to go and shoot them. We are dove-hunting British style. Meanwhile, a team of guns in Inverness-shire are pitting their wits, their shooting and the benefits of Hull Cartridges against end-of-season grouse, some of the fastest flying, most difficult birds in the world. That's not all: there is News Stump, Hunting YouTube, Skinner's gundog training tips and 'Hallo Charlie!' - another programme full to bursting with meaty goodness. If you want to go driven grouse shooting, email Lachie Smith ls@highlandsporting.com And if you want to find out about good grouse cartridges, visit http://www.hullcartridge.co.uk Here are the links for Hunting YouTube: James Purdey http://www.youtube.com/watch?v=8ldcyE3NGgA AirGunHuntersTV http://www.youtube.com/watch?v=GdjJGXcX3HM Kevin Olsson http://www.youtube.com/watch?v=7AstUAwTO2I FromField2StreamTV http://www.youtube.com/watch?v=w12RnGMFUpY DizzyFishUK http://www.youtube.com/watch?v=uz_WWN-Wbjo AirArmsHuntingSA http://www.youtube.com/watch?v=ZHl3lYTY-6g Andrew Ucles http://www.youtube.com/watch?v=m-KlCjm2YQo Приключения рыбака и охотника http://www.youtube.com/watch?v=3I8DVBidtb4 ▶ Shares To find out how to join the Fieldsports Nation, visit FieldsportsChannel.tv/shares or to sign up and pledge, go to fieldsports.envestry.com We’re proud to promote enjoyment of fieldsports and the countryside. There are three guiding principles to everything we do on Fieldsports Channel: ▶ Shoot responsibly ▶ Respect the quarry ▶ Ensure a humane, clean and quick kill Take part in nature. Join the Fieldsports Nation Fcha.nl Risk warning: investments of this nature carry risks to your capital as well as potential rewards. Approved as a financial promotion by Envestors Limited. Which is authorised and regulated by the Financial Conduct Authority (No. 07236828.) Sign up for our weekly… | ["Traditional music", "Music", "Speech"] | ["low quality", "folk", "flat male vocal", "shimmering shakers", "acoustic rhythm guitar", "wooden percussions", "harmonica melody", "happy", "joyful", "soulful"] | 4 | BN63M3_lPCQ | 1234 |
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;