musiccaps_details (view)
5 rows where musiccaps_aspects contains "folk", musiccaps_aspects contains "soulful" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- folk · 5 ✖
- low quality 5
- soulful · 5 ✖
- passionate 4
- live performance 3
- noisy 3
- acoustic rhythm guitar 2
- mono 2
- shimmering shakers 2
- wooden percussions 2
- accordion melody 1
- acoustic guitar melody 1
- acoustic rhythm guitar melody 1
- crowd noises 1
- electric guitar melody 1
- emotional 1
- energetic 1
- flat male vocal 1
- flute melody 1
- groovy bass 1
- groovy piano melody 1
- happy 1
- harmonica melody 1
- joyful 1
- metallic percussive melody 1
- passionate male vocal 1
- punchy snare 1
- saxophone solo melody 1
- shimmering cymbals 1
- smooth bass 1
- steel guitar solo melody 1
- sustained strings melody 1
- upbeat 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 10 ✖
- Music 3
- Accordion 1
- Banjo 1
- Guitar 1
- Music of Asia 1
- Musical instrument 1
- Orchestra 1
- Plucked string instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
Omar Faruk Tekbilek Ensemble ~ "LAZ" | The low quality recording features a live performance of a folk song and it consists of a metallic percussive melody, wooden percussions, acoustic guitar melody and flute melody. It sounds soulful, upbeat and passionate and the recording is noisy. | 2010-03-19T23:48:08Z | Anthony Mazzella | Omar Faruk Tekbilek Ensemble featuring Anthony Mazzella, River Guerguerian, Bahadir Sener, Murat Tekbilek, Yannis Dimitriadis. Recorded on March 16, 2010in Trento Italy. | ["Orchestra"] | ["low quality", "folk", "noisy", "live performance", "metallic percussive melody", "wooden percussions", "acoustic guitar melody", "flute melody", "soulful", "upbeat", "passionate"] | 4 | 8kx5ST65Fog | 941 | |
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 | |
Foggy Mtn Breakdown (Must-Own DVD) | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | 2009-07-15T05:50:54Z | jamesarthurjohnson | From All-Star Bluegrass Celebration DVD - Ricky Skaggs, Earl Scruggs, Vince Gill, Travis Tritt, Jerry Douglas, and on and on... | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | 4 | GuHDy--gWiM | 1758 | |
Kaun Hai Jo Sapnon Mein Aaya | Rajendra Kumar | Saira Banu | Jhuk Gaya Aasman Songs {HD}| Mohd. Rafi | The low quality recording features a folk song that consists of passionate male vocal singing over shimmering shakers, smooth bass, sustained strings melody and groovy piano melody. It sounds emotional, soulful and passionate - like something you would hear in movies. | 2012-06-20T08:40:04Z | Shemaroo Filmi Gaane | Movie : Jhuk Gaya Aasman (1968) Song: Kaun Hai Jo Sapnon Mein Aaya Starcast: Rajendra Kumar, Saira Banu Music Director: Shanker Jaikishan Singers: Mohammad Rafi Director: Lekh Tandon SUBSCRIBE now to FilmiGaane: https://goo.gl/mx4zPe To see all the latest music playlists that we've created just for you, click here https://www.youtube.com/user/filmigaane/playlists Download FilmiGaane App - http://twd.bz/fg Connect with us on:- Facebook - http://www.Facebook.com/FilmiGaane Twitter - http://Twitter.com/FilmiGaane Join us on Pinterest - http://pinterest.com/shemaroo Circle & Follow us on google.com/+filmigaane Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more: http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at connect@shemaroo.com Download the app now and share it with all the asli fans https://shemaroome.app.link/fjmW99wk3W Give a missed call on 18002665151 www.shemaroome.com Your one-stop destination for authentic Indian content now with the biggest cashback offer! Get upto 100% Paytm cashback on purchasing any pack worth Rs.129 or more! Hurry & subscribe now:https://shemaroome.app.link/Liw2f3z14bb | ["Music of Asia", "Music"] | ["low quality", "folk", "noisy", "mono", "passionate male vocal", "sustained strings melody", "shimmering shakers", "smooth bass", "groovy piano melody", "emotional", "passionate", "soulful"] | 4 | exD5okdopWc | 3911 | |
Mircea Gutanu & Romica Raiu | The low quality recording features a live performance of a folk song that consists of a saxophone solo melody, accordion melody and acoustic rhythm guitar. It sounds passionate and soulful. The recording is mono and noisy. | 2013-02-27T22:35:33Z | 5555kinder | ["Accordion"] | ["low quality", "live performance", "folk", "noisy", "mono", "saxophone solo melody", "accordion melody", "acoustic rhythm guitar", "passionate", "soulful"] | 4 | vpcEBryyej4 | 5209 |
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;