musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy" and musiccaps_aspects contains "groovy double bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- groovy · 3 ✖
- groovy double bass · 3 ✖
- jazz 2
- low quality 2
- passionate 2
- uptempo 2
- acoustic rhythm guitar 1
- brass melody 1
- emotional 1
- energetic 1
- groovy piano melody 1
- hollow snare 1
- passionate male vocal 1
- plucked violin melody 1
- reverberant 1
- reverberant saxophone 1
- rock 1
- saxophone solo melody 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- simple piano keys chords 1
- smooth 1
- soft kick hits 1
- trumpet melody 1
musiccaps_names (array) 8 ✖
- Music 2
- Bluegrass 1
- Brass instrument 1
- Jazz 1
- Saxophone 1
- Singing 1
- Song 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dragon Slayer - Classic Finish | The low quality recording features a jazz song that consists of a saxophone solo melody played over hollow snare, groovy double bass, shimmering hi hats, shimmering shakers and brass melody. It sounds uptempo, groovy and passionate - like something you would hear in a jazz club. | 2008-02-17T22:26:33Z | Nathan | Get all pieces of the runescape triforce... um ya I mean map. Fix up broken boat check, own Elvarg Dragon in classic who is lv 110 perhaps =o. Either way one of us must fall!!! Would or released this videos sooner but I had to lv smithing to 33 in classic =p I do the video in one run, so what you see is what I saw for the very first time while I attempt to beat quests... | ["Brass instrument", "Saxophone"] | ["low quality", "jazz", "uptempo", "groovy", "passionate", "saxophone solo melody", "hollow snare", "groovy double bass", "shimmering hi hats", "shimmering shakers", "brass melody", "energetic"] | 4 | bxZeGrM_0ac | 3667 | |
The Infamous Stringdusters Here Comes The Sun into Chopping Can at nTelos Pavilion 5/12/12 | The low quality recording features a live performance of a rock song and it features a passionate male vocal singing over groovy double bass, acoustic rhythm guitar, plucked violin melody and simple piano chords. It sounds reverberant, emotional, groovy and smooth - like something you would sing along to at the concert. | 2012-08-31T10:03:14Z | ConcertCasters | Check out the jam half way through! The Infamous Stringdusters cover Here Comes The Sun into Chopping Can at Charlottesville Virginia "nTelos Pavilion" 5/12/12 bluegrass live concert stage banjo slide guitar bass "blue mountain sports" "sound board mix" | ["Singing", "Music", "Song", "Bluegrass"] | ["low quality", "rock", "reverberant", "passionate male vocal", "acoustic rhythm guitar", "groovy double bass", "plucked violin melody", "simple piano keys chords", "smooth", "groovy", "emotional"] | 4 | dW4eW0Xreik | 3795 | |
Monster Hunter Swing ~Big Band Jazz Arrange~ | High Quality | Zac Zinger | The Jazz song features reverberant saxophones and trumpet melodies playing over groovy double bass, groovy piano melody, shimmering cymbals and soft kick hits. It sounds uptempo, groovy and passionate, like something you would hear in traditional jazz bars. | 2014-06-30T23:16:06Z | Tonal Revelations | Various traks from the various Monster Hunter titles have been arranged into some pretty sweet big band tunes. Definitely a great listen! Enjoy~ Available for purchase at: http://www.cdjapan.co.jp/product/CPCA-10258 Saxophones: Zac Zinger Flute & Clarinet: Zac Zinger Electric Bass: Kellan Thomas Electric Guitar: Rob O'Block Baritone Saxophone: Ben Whiting Trumpet: Matt Joseph - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 00:00:03 - Proof of a Hero 00:04:11 - Sparkling Blue Light / Jin'ouga 00:08:22 - Empress of Flame / Lunastra & Teostra 00:13:11 - Pokke Village Theme 00:18:50 - Dance of The Snow Village 00:23:48 - Scat Cat Fever 00:28:59 - Searching for the Secret Hot Spring 00:33:46 - Tremble of the Sea and Land / Lagiacrus 00:38:38 - Brave Icon ~ Bracchidios 00:42:51 - Hunter, Go Forth - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | ["Swing music", "Jazz", "Music"] | ["jazz", "reverberant saxophone", "trumpet melody", "shimmering cymbals", "soft kick hits", "groovy double bass", "groovy piano melody", "groovy", "uptempo", "passionate"] | 4 | oBwt8T8P8Zs | 4609 |
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;