musiccaps_details (view)
5 rows where musiccaps_author = 1 and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 82 ✖
- medium tempo 3
- percussive bass line 3
- cymbals crashing 2
- dance music 2
- dance rhythm 2
- groovy music 2
- instrumental music 2
- people dancing 2
- poor audio quality 2
- spirited 2
- a sense of low frequencies 1
- amateur band 1
- amateur home video 1
- ambient noises 1
- animated vocals 1
- arpeggiated sounds 1
- average audio quality 1
- bad audio quality 1
- bad recording 1
- bop tune 1
- brush drumming rhythm 1
- chaotic harmony 1
- children’s show 1
- college music festival 1
- comedy show 1
- couples slow dancing 1
- crowds cheering 1
- dissonant harmonies 1
- distorted audio 1
- dj 1
- double bass harmony 1
- drum rolls 1
- energetic 1
- exciting 1
- fast tempo 1
- female backup singer 1
- female pop star 1
- funny show 1
- groovy bass line 1
- groovy rhythm 1
- guitar lead 1
- guitar playing lead 1
- guitar strumming 1
- heavy metal drumming 1
- hissing noises 1
- jazz dance music 1
- jazz music 1
- keyboard accompaniment 1
- liens adventure 1
- live band 1
- live performance 1
- love performance 1
- low frequency deficiency 1
- male singer 1
- metal band 1
- morals 1
- passionate 1
- people singing along 1
- piano accompaniment 1
- retro hits 1
- retro pop songs 1
- retro rock and roll 1
- rock and roll music 1
- rock band 1
- rock concert 1
- rock song 1
- romantic 1
- small adventures 1
- sounds 1
- steady drum rhythm 1
- steady rock drumming 1
- strong drumming rhythm 1
- sunday tv shows 1
- swing music 1
- teen spirit 1
- treble overload 1
- trumpet playing percussively 1
- tv show soundtrack 1
- tv show tune 1
- very poor audio quality 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 5
- Rock and roll · 5 ✖
- Roll 3
- Burst, pop 1
- Funk 1
- Psychedelic rock 1
- Reggae 1
- Rock music 1
- Ska 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 |
---|---|---|---|---|---|---|---|---|---|---|
CloseHead - Heart Of Pop (percayalah) @SMAN 11 Jakarta | The song is instrumental.The tempo is fast with a strong metal drumming rhythm, groovy bass line, cymbals crashing, guitar lead and guitar rhythm. The song is chaotic and energetic. The song has very poor audio quality. | 2014-02-19T18:36:24Z | ricky t julianto | Closehead - Heart Of Pop (percayalah) Event NEOVECTOR @SMAN 11 Jakarta Video Rec & Editing : Ricky T Julianto | ["Music", "Burst, pop", "Rock and roll"] | ["live band", "very poor audio quality", "ambient noises", "chaotic harmony", "bad recording", "percussive bass line", "metal band", "college music festival", "heavy metal drumming", "guitar strumming", "guitar lead", "cymbals crashing", "chaotic harmony", "dissonant harmonies", "groovy music", "amateur band", "youthful", "energetic", "spirited", "teen spirit", "instrumental music", "fast tempo"] | 1 | DaeJYtWgcoI | 1497 | |
Groovy Live Musik : "We no speak americano" by 4 to the bar : jazzy swing and lounge music | A male singer sings this groovy bop tune. The song is medium tempo with a groovy double bass playing, piano accompaniment, trumpet playing percussively and brush drumming rhythm. The song is entertaining and exciting. The song is a jazz dance tune with an electronica twist. | 2011-02-01T14:48:22Z | loungemusicband | http://4tothebar.de : More groovy lounge music, swing sounds and jazzy live music for club, event and party. Lounge Music: Die Live Band 4 to the bar spielt Swing, Samba und Jazz mit Drums, Kontrabass, Piano und Sängerin und Deejay | ["Swing music", "Funk", "Music", "Reggae", "Ska", "Rock and roll"] | ["groovy music", "love performance", "dj", "dance music", "brush drumming rhythm", "groovy bass line", "steady drum rhythm", "piano accompaniment", "trumpet playing percussively", "male singer", "female backup singer", "vocal harmony", "bop tune", "double bass harmony", "jazz music", "jazz dance music", "poor audio quality", "people dancing", "dance rhythm"] | 1 | RtgHU1UMo5o | 2729 | |
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 | ||
Chipmunks & Chipettes Girls of Rock and Roll | Female singers sing in funny animated vocals. The song is medium tempo with a groovy bass line, keyboard accompaniment, arpeggiated harmony tones and steady drumming rhythm. The song is cheerful and energetic. The audio quality is average. | 2010-02-14T04:29:48Z | Stuart Danaher | A remake of the 1987 classic A Chipmunk Adventure. Summer 2009, Pioneer Museum Colorado Springs, CO. You could have done this.....but you didn't. Danielle, Sarah, E-mile-I, Justin, Taggart, Abel and Becca, thanks for making a boy's dream turn into an amazing reality. Crazy potatoes! | ["Music", "Roll", "Rock and roll"] | ["animated vocals", "medium tempo", "small adventures", "morals", "average audio quality", "tv show soundtrack", "comedy show", "tv show tune", "keyboard accompaniment", "percussive bass line", "arpeggiated sounds", "dance rhythm", "groovy rhythm", "funny show", "retro pop songs", "liens adventure", "sunday tv shows", "sounds", "children’s show"] | 1 | dEc7tV30KJo | 3771 | |
I Love Rock and Roll LIVE in HD Up Close - Miley Cyrus Portland Wonder World 2009 Tour HQ | The song is a modern pop song performed live performance. A female sings this melody with a strong drumming rhythm. The song is highly distorted with high noise levels and distortion. The song is a rock classic and performed live in front of a noisy audience. | 2009-09-22T03:01:44Z | Chris B | Miley Cyrus performing I Love Rock and Roll live in Portland. Filmed from 2nd Row with DSC-HX1 in HD quality. From her Wonder World 2009 concert LIVE in Portland. Opening Night! | ["Music", "Roll", "Rock and roll"] | ["poor audio quality", "distorted audio", "hissing noises", "low frequency deficiency", "rock concert", "live performance", "female pop star", "medium tempo", "rock song", "treble overload", "crowds cheering", "strong drumming rhythm", "a sense of low frequencies", "amateur home video", "people singing along"] | 1 | qXgSlhWbWLU | 4796 |
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;