musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "guitar rhythm" and musiccaps_aspects contains "retro pop hits" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- guitar rhythm · 2 ✖
- keyboard accompaniment 2
- retro pop hits · 2 ✖
- romantic 2
- classic rock band 1
- cymbal crashes 1
- cymbals crashing 1
- dance club mix 1
- dance groove 1
- dance hits 1
- emotional 1
- energetic 1
- female singer 1
- funky music 1
- groovy drum rhythm 1
- guitar accompaniment 1
- love song 1
- love songs 1
- male singer 1
- medium tempo 1
- passionate 1
- percussion hit 1
- percussive bass line 1
- reggae style influences 1
- rock band 1
- slick drumming 1
- steady drumming rhythm 1
- strong percussive bass line 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- Independent music 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
High Tone ft Pupajim - Rub a Dub Anthem | A female singer sings this cool melody. The song is medium tempo with a percussive bass line, slick drumming rhythm, guitar accompaniment , keyboard accompaniment and various percussion hits. The song has a strong dance groove and retro pop in style. | 2010-05-19T17:31:01Z | Smashing Sound | Out back (jarring effect 17-05-2010) | ["Music", "Reggae"] | ["female singer", "strong percussive bass line", "reggae style influences", "groovy drum rhythm", "guitar rhythm", "slick drumming", "keyboard accompaniment", "funky music", "guitar accompaniment", "dance groove", "retro pop hits", "cymbal crashes", "romantic", "love songs", "dance hits", "dance club mix", "percussion hit"] | 1 | TabaOeYq2ek | 2848 |
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;