musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur band" and musiccaps_aspects contains "instrumental music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- amateur band · 3 ✖
- instrumental music · 3 ✖
- energetic 2
- metal band 2
- accordion melody 1
- amateur quality recording 1
- ambient noises 1
- average audio quality 1
- bad recording 1
- chaotic harmony 1
- cheerful 1
- childhood memories 1
- college music festival 1
- cymbals crashes 1
- cymbals crashing 1
- deteriorated audio quality 1
- dissonant harmonies 1
- distorted guitar rhythm 1
- distortion 1
- excitement 1
- fast 1
- fast tempo 1
- full of cheer 1
- groovy music 1
- guitar lead 1
- guitar strumming 1
- guitar strumming rhythm 1
- happy 1
- heavy metal drumming 1
- hissing tones 1
- live band 1
- medium tempo 1
- noise 1
- noisy ambience 1
- nostalgic 1
- percussive bass line 1
- pleasant 1
- poor audio quality 1
- spirited 1
- steady marching drumming rhythm 1
- teen spirit 1
- train journey 1
- very poor audio quality 1
- walking bass line 1
- wonder 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breed Sheep(Nirvana cover)territorial pissings and love buzz | The song is an instrumental. The song is fast tempo with distorted guitars playing in rhythm. The song is energetic and an amateurish performance. The song is of very poor quality with audio noise and hissing sound. | 2007-11-25T17:53:33Z | Kurt (Breed Sheep) | Breed Sheep playing territorial pissings and love buzz | ["Music", "Buzz"] | ["poor audio quality", "noise", "distortion", "hissing tones", "noisy ambience", "instrumental music", "distorted guitar rhythm", "fast", "amateur quality recording", "deteriorated audio quality", "metal band", "amateur band"] | 1 | 2ZB7DUGOdZw | 377 | |
LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) | The song is an instrumental. The song is medium tempo with a walking bass line, steady drumming rhythm with cymbal crashes, guitar strumming rhythm and an accordion playing melody. The song is background music for a toy hobbyist video. The song is cheerful and reminiscent of a childhood adventure. | 2016-07-12T20:16:51Z | TrainWorldTV | LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) http://www.trainworld.com The model railroad equipment & accessories we sell are not toys, and are not intended for use by children under the age of 14, | ["Christmas music", "Music"] | ["instrumental music", "steady marching drumming rhythm", "nostalgic", "full of cheer", "average audio quality", "wonder", "accordion melody", "cymbals crashes", "guitar strumming rhythm", "walking bass line", "pleasant", "cheerful", "happy", "energetic", "excitement", "train journey", "childhood memories", "medium tempo", "amateur band"] | 1 | BsLFQV8HVZE | 1298 | |
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 |
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;