musiccaps_details (view)
5 rows where musiccaps_aspects contains "adventurous", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "instrumental music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 82 ✖
- adventurous · 5 ✖
- exciting · 5 ✖
- instrumental music · 5 ✖
- medium tempo 4
- bad audio quality 3
- passionate 3
- guitar rhythm 2
- guitar solo 2
- home video 2
- poor audio quality 2
- adventure music 1
- ambient crowd noises 1
- ambient echoes 1
- backing track 1
- blue band 1
- blues harmonica 1
- blues harp 1
- blues legends 1
- blues progression 1
- blues turn around 1
- brass instruments playing triumphantly 1
- christmas presents 1
- christmas song 1
- church organ 1
- conductor 1
- country music 1
- cymbals crashing 1
- diva 1
- electric rhythm guitar playing 1
- emotional 1
- female guitarist 1
- gain issues 1
- great adventure 1
- groovy 1
- groovy bass line 1
- guitar amplifier 1
- guitar demo 1
- guitar played accompaniment style 1
- hard rock 1
- harmonica player 1
- harpist 1
- horn section 1
- live concert video 1
- live performance 1
- marching rhythm 1
- medium fast tempo 1
- medium fats tempo 1
- movie soundtrack 1
- movie themes 1
- opera hall 1
- organ accompaniment 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- philharmonic orchestra 1
- poor audio recording 1
- retro classics 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- romantic 1
- santa claus 1
- slow dance 1
- soaring harmonies 1
- soaring melody 1
- solo violin 1
- soloist 1
- spirited 1
- steady drumming 1
- string section 1
- subtle bass line 1
- tambourine percussion 1
- testosterone driven 1
- the blues 1
- tone generator 1
- trumelts playing 1
- trumpets playing 1
- vintage hits 1
- vintage pop 1
- walking bass line 1
- youthful 1
- youtube music video 1
musiccaps_names (array) 19 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
d85 yamaha organ solo one man band | The song is an instrumental. The tempo is medium with a church organ playing melody, steady drumming rhythm, cymbals crashing, tambourine percussion, steady bass, and guitar playing rhythm. The song is exciting and retro nostalgia. The audio quality is poor. | 2009-02-01T04:39:30Z | fathau | one man band | ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ", "country music", "backing track", "medium tempo", "instrumental music", "tambourine percussion", "cymbals crashing", "guitar rhythm", "organ accompaniment", "vintage hits", "bad audio quality", "gain issues", "exciting", "adventurous", "retro classics", "passionate", "great adventure", "romantic", "movie themes", "vintage pop"] | 1 | A_Yd5huF2Pg | 1136 | |
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
American Folk Blues Festival 1983 feat. Carey Bell | The song is an instrumental blues song. The song is medium tempo with a blues harmonica playing a cool melody, walking bass line, guitar accompaniment , steady drumming rhythm and other percussion hits. The song is exciting and groovy. The song has a bad audio quality. | 2006-06-16T20:47:21Z | Harpsucker | Carey Bell-voc/harmonica Louisiana Red-git Jimmy Rodgers-git Lovie Lee-piano Queen Sylvia Embry-bass Charles"Honey Boy"Otis-drums rec-live in germany 1983 | ["Blues", "Music"] | ["blues harmonica", "blues harp", "harpist", "instrumental music", "harmonica player", "groovy bass line", "guitar rhythm", "steady drumming", "the blues", "blues progression", "instrumental music", "soaring melody", "bad audio quality", "blue band", "walking bass line", "blues turn around", "blues legends", "medium tempo", "adventurous", "exciting", "groovy", "slow dance", "passionate", "spirited"] | 1 | GT9g4uqK9G8 | 1725 | |
Jingle All the Way OST 18. Turbo Tom Marching Band #2 | The song is an instrumental song. The song is medium tempo with a marching drum rhythm, string section harmony, brass instruments playing and a horn section playing various harmonies. The song is exciting and adventurous in nature. The song is a movie soundtrack, and the audio quality is quite poor. | 2011-08-21T20:50:43Z | 1991Nukem | All rights go to 20th Century Fox & 1492 Pictures. | ["Theme music", "Music"] | ["movie soundtrack", "poor audio quality", "instrumental music", "trumpets playing", "soaring harmonies", "conductor", "santa claus", "christmas presents", "opera hall", "philharmonic orchestra", "string section", "solo violin", "trumelts playing", "medium tempo", "marching rhythm", "exciting", "adventurous", "christmas song", "horn section", "brass instruments playing triumphantly"] | 1 | JHkcCXF5vII | 1986 |
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;