musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "shimmering shakers" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- groovy · 2 ✖
- low quality 2
- shimmering shakers · 2 ✖
- uptempo · 2 ✖
- alternative/indie 1
- brass melody 1
- electric guitar chords 1
- energetic 1
- groovy double bass 1
- groovy repetitive bass guitar 1
- harsh 1
- harsh electric guitar solo melody 1
- hollow snare 1
- jazz 1
- muffled 1
- noisy 1
- passionate 1
- percussive toms 1
- reverberant 1
- saxophone solo melody 1
- shimmering hi hats 1
musiccaps_names (array) 7 ✖
- Brass instrument 1
- Funk 1
- Music 1
- Psychedelic rock 1
- Rock music 1
- Saxophone 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 |
---|---|---|---|---|---|---|---|---|---|---|
Dragon Slayer - Classic Finish | The low quality recording features a jazz song that consists of a saxophone solo melody played over hollow snare, groovy double bass, shimmering hi hats, shimmering shakers and brass melody. It sounds uptempo, groovy and passionate - like something you would hear in a jazz club. | 2008-02-17T22:26:33Z | Nathan | Get all pieces of the runescape triforce... um ya I mean map. Fix up broken boat check, own Elvarg Dragon in classic who is lv 110 perhaps =o. Either way one of us must fall!!! Would or released this videos sooner but I had to lv smithing to 33 in classic =p I do the video in one run, so what you see is what I saw for the very first time while I attempt to beat quests... | ["Brass instrument", "Saxophone"] | ["low quality", "jazz", "uptempo", "groovy", "passionate", "saxophone solo melody", "hollow snare", "groovy double bass", "shimmering hi hats", "shimmering shakers", "brass melody", "energetic"] | 4 | bxZeGrM_0ac | 3667 | |
Old file.........new knife | The low quality recording features an alternative/indie song that consists of electric guitar chords, groovy repetitive bass guitar, harsh electric guitar solo, percussive toms and shimmering shakers. It sounds muffled, harsh, groovy and it is uptempo and noisy. | 2013-08-16T09:47:12Z | Toothbeard knives | A start to finish slideshow of my last 2 knives aug 2013 | ["Swing music", "Funk", "Music", "Psychedelic rock", "Rock music"] | ["low quality", "alternative/indie", "muffled", "harsh", "noisy", "electric guitar chords", "groovy repetitive bass guitar", "harsh electric guitar solo melody", "percussive toms", "shimmering shakers", "reverberant", "uptempo", "groovy"] | 4 | xrqDoBor2dk | 5356 |
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;