musiccaps_details (view)
3 rows where musiccaps_aspects contains "wooden percussions", musiccaps_author = 4 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- low quality 3
- wooden percussions · 3 ✖
- acoustic rhythm guitar 1
- addictive 1
- bells melody 1
- brass melody 1
- commercial music 1
- echoing brass melody 1
- flat male vocal 1
- flat mel vocal 1
- folk 1
- funny processed male vocal 1
- happy 1
- harmonica melody 1
- harmonizing female vocal 1
- harmonizing male vocals 1
- joyful 1
- live performance 1
- noisy 1
- passionate 1
- pop 1
- punchy kick 1
- shimmering shakers 1
- soulful 1
- traditional 1
musiccaps_names (array) 6 ✖
- Music 3
- Speech · 3 ✖
- Folk music 1
- Middle Eastern music 1
- Rattle (instrument) 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 |
---|---|---|---|---|---|---|---|---|---|---|
Nivine Nasr - Yo2bosh - Video Clip | The low quality recording features a commercial music that consists of a funny processed male vocal, after which there is a harmonizing female vocal singing over punchy kick, brass melody, wooden percussion and echoing brass melody. It sounds addictive - like every commercial music should sound. | 2010-04-20T13:18:50Z | ArmVisions | Nivine Nasr Yo2bosh نيفين نصر يؤبش | ["Music", "Middle Eastern music", "Speech"] | ["low quality", "pop", "funny processed male vocal", "brass melody", "punchy kick", "wooden percussions", "echoing brass melody", "harmonizing female vocal", "addictive", "commercial music"] | 4 | 3QqVP0odOw4 | 467 | |
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 | |
Musik Tradisional Madura_Semut ireng | The low quality recording features a live performance of a traditional song and it consists of a bell melody, followed by wooden percussion. There are some flat male vocals talking, after which there are harmonizing male vocals singing over it. It sounds passionate, even though the recording is noisy. | 2013-12-11T10:31:53Z | Achmad Syauqi | Musik Tradisional Madura_Semut ireng | ["Folk music", "Music", "Rattle (instrument)", "Speech"] | ["low quality", "noisy", "live performance", "traditional", "bells melody", "wooden percussions", "flat mel vocal", "harmonizing male vocals", "passionate"] | 4 | bBy0NCoCEHc | 3611 |
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;