musiccaps_details (view)
1 row where musiccaps_author = 6, musiccaps_names contains "Bagpipes" and "youtube_published" is on date 2012-08-11
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Edinburgh Military Tattoo 2012 - Massed Pipes and Drums (1 of 3) | This audio contains a huge amount of people playing a melody on the bagpipes while others are playing a kick sound on every beat. This song may be playing live during a big public event. | 2012-08-11T14:29:06Z | darm49 | Edinburgh Military Tattoo - Wednesday 8th August 2012 Tunes: The Crofter Colin's Cattle The Herding Song Cutting Bracken Clean Please Strae The Wind that Shakes the Barley Na Goisidich Speed the Plough Bands: The Royal Scots Dragoon Guards The Royal Corps of Signals The Royal Highland Fusiliers, 2nd Battalion The Royal Regiment of Scotland The Black Watch, 3rd Battalion The Royal Regiment of Scotland The Highlanders, 4th Battalion The Royal Regiment of Scotland The Rats of Tobruk, Melbourne, Australia Australian Federal Police Pipes & Drums, Canberra, Australia The Manly Warringah Pie Band, Sydney, Australia The Cape Town Highlanders, South Africa The Canadian Army Pipes & Drums The Scots College Pipes & Drums, Sydney, Australia Queen Victoria School Pipes, Drums & Dancers, Dunblane, Scotland | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "bagpipes", "drums", "traditional", "slower tempo"] | 6 | w2MeQg3W7Po | 5231 |
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;