musiccaps_details (view)
1 row where musiccaps_aspects contains "joyful", musiccaps_aspects contains "shimmering shakers", musiccaps_names contains "Music" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 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;