musiccaps_details (view)
2 rows where musiccaps_aspects contains "drums" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- drums · 2 ✖
- traditional · 2 ✖
- amateur recording 1
- bagpipes 1
- bass 1
- celticmusic 1
- epic 1
- guitarlike instrument 1
- medium tempo 1
- slower tempo 1
- violins 1
musiccaps_names (array) 4 ✖
youtube_published (date) 2 ✖
- 2012-08-11 1
- 2012-09-21 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Celtic Music - The Gael (Promontory) | This audio contains a big soft kick drum hit along with a soft bassline changing into an even deeper octave. On top of that, violins and an acoustic guitar-like instrument are playing a melody. This recording has some reverb on it. This song may be playing in an adventure movie scene. | 2012-09-21T09:09:07Z | Serendipity | The music from The last of the Mohicans movie | ["Blues", "Music"] | ["celticmusic", "violins", "drums", "bass", "guitarlike instrument", "medium tempo", "traditional", "epic"] | 6 | 7B1OAtD_VIA | 818 | |
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;