musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "drum rolls", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "instrumental music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 38 ✖
- drum rolls · 2 ✖
- exciting · 2 ✖
- instrumental music · 2 ✖
- passionate 2
- bad audio quality 1
- bells percussion tones 1
- couples slow dancing 1
- cymbals crashing 1
- dance music 1
- electric guitar solo 1
- emotional 1
- emphatic cries 1
- energetic 1
- funk jazz 1
- funky jazz drumming 1
- groovy bass line 1
- groovy rhythm 1
- guitar playing lead 1
- jazz band 1
- jazz festival 1
- jazz improvisation 1
- live improvisation 1
- medium fast tempo 1
- medium tempo 1
- modern jazz hits 1
- people dancing 1
- percussive bass line 1
- retro hits 1
- retro rock and roll 1
- rock and roll music 1
- rock band 1
- romantic 1
- saxophone playing 1
- spirited 1
- steady rock drumming 1
- swing music 1
- various percussion hits 1
- xylophone playing 1
musiccaps_names (array) 7 ✖
- Music 2
- Psychedelic rock 1
- Rock and roll 1
- Rock music 1
- Roll 1
- Ska 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Etiqueta Rock and Roll Yo estare aqui.wmv | The song is an instrumental. The tempo is medium with a guitar playing a romantic lead, steady drumming, rock drumming, percussive bass line, cymbals crashing and guitar strumming rhythm. The song is exciting and youthful. The song has a bad audio quality. | 2011-06-08T22:05:27Z | TheMugriento25 | ["Music", "Psychedelic rock", "Rock music", "Roll", "Rock and roll"] | ["rock and roll music", "medium tempo", "steady rock drumming", "guitar playing lead", "cymbals crashing", "drum rolls", "swing music", "percussive bass line", "rock band", "romantic", "exciting", "retro rock and roll", "dance music", "people dancing", "couples slow dancing", "passionate", "spirited", "retro hits", "instrumental music", "bad audio quality"] | 1 | YDBxdZchOuM | 3265 | ||
Gong - Esnuria | The song is an instrumental improvisation. The song is medium fast tempo with a groovy bass line, electric guitar playing, saxophone playing, jazz drumming with percussive hits and a xylophone playing. The song is highly improvisational and energetic. The song is a modern jazz fusion or improvisation jam. | 2009-07-23T20:02:28Z | funkdigger91 | LP: Gong - Gazeuse! (1976) Bass, Piano, Gong - Francis Moze Congas, Percussion - Mino Cinelu Drums, Vibraphone, Marimba, Glockenspiel - Pierre Moerlen Guitar - Allan Holdsworth Producer - Dennis MacKay Saxophone, Flute - Didier Malherbe Vibraphone - Benoit Moerlen Vibraphone, Marimba, Glockenspiel - Mireille Bauer Maybe heard on: DJ Pogo - Block Party Breaks Vol. 2 (2002) | ["Music", "Ska", "Vibraphone"] | ["funk jazz", "medium fast tempo", "instrumental music", "saxophone playing", "electric guitar solo", "funky jazz drumming", "groovy bass line", "drum rolls", "various percussion hits", "live improvisation", "bells percussion tones", "xylophone playing", "jazz improvisation", "energetic", "exciting", "jazz band", "modern jazz hits", "groovy rhythm", "jazz festival", "emphatic cries", "emotional", "passionate"] | 1 | ylKvglDzBU4 | 5436 |
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;