musiccaps_details (view)
3 rows where musiccaps_aspects contains "quick tempo" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- quick tempo · 3 ✖
- acoustic guitar solo 1
- bass drum 1
- brass 1
- brass ensemble 1
- complex chords 1
- electric guitar 1
- fast 1
- fast beat 1
- fast strumming acoustic guitar 1
- flamenco influence 1
- forceful 1
- guiro 1
- hand claps 1
- hand percussion 1
- horn solo 1
- latin 1
- lively 1
- low tuned bass drum 1
- male voice over 1
- modern electric bass 1
- passionate female singer 1
- snare drum 1
- tambourine 1
- tuba 1
- virtuosity 1
- wah 1
- wind ensemble 1
musiccaps_names (array) 11 ✖
- Brass instrument 2
- Music 2
- Trumpet 2
- Classical music 1
- Flamenco 1
- Foghorn 1
- French horn 1
- Music of Latin America 1
- Musical instrument 1
- Orchestra 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Canadian Brass: "Perfect Landing" CD Discussion | A brass ensemble playing a fast piece with a quick tempo and virtuosity. Male voice over. | 2015-11-05T14:10:33Z | Canadian Brass | "Perfect Landing," the new Canadian Brass album to be released Nov. 6th by Opening Day Entertainment, comes after the wildly successful album "Takes Flight". This discussion is a rare insight into the making of a groundbreaking album which will feature a slew of new compositions, new arrangements and audience favourites. | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["fast", "quick tempo", "brass ensemble", "male voice over", "virtuosity"] | 8 | 86YDiQjYU1U | 897 | |
Euphonium Solo | Quick, forceful wind ensemble music featuring a horn solo with brass, tuba, bass drum and snare drum accompanying. | 2007-09-17T18:54:27Z | tubajs | Barry Morrison playing with Imperial Brass (Jeff Schultz-Conductor) "A Better World | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Orchestra", "Trumpet", "Classical music"] | ["horn solo", "wind ensemble", "brass", "bass drum", "snare drum", "tuba", "quick tempo", "forceful"] | 8 | DTkKGYCRMlc | 1478 | |
( Rumba ) Parrita & Canelita " Remix " Dj Barajero | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | 2011-05-27T11:41:49Z | DJ Barajero | Parrita Canelita Remix Dj Barajero Flamenco Rumba Salsa Reggueton Verano Nuevo 2011 2012 2013 | ["Flamenco", "Music", "Music of Latin America"] | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | 8 | YzpzKyzyL0Y | 3331 |
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;