musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "amateur band" and musiccaps_aspects contains "instrumental music" sorted by musiccaps_aspects
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 37 ✖
- amateur band · 2 ✖
- energetic 2
- instrumental music · 2 ✖
- accordion melody 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
- dissonant harmonies 1
- excitement 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
- live band 1
- medium tempo 1
- metal band 1
- nostalgic 1
- percussive bass line 1
- pleasant 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
musiccaps_names (array) 4 ✖
- Music 2
- Burst, pop 1
- Christmas music 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;