musiccaps_details (view)
2 rows where musiccaps_aspects contains "guitar lead" and musiccaps_aspects contains "keyboard accompaniment" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- groovy rhythm 2
- guitar lead · 2 ✖
- keyboard accompaniment · 2 ✖
- adrenaline rush 1
- average audio quality 1
- backup singers 1
- bad audio quality 1
- bouncy drum rhythm 1
- cheerful 1
- cymbals crashing 1
- distorted guitar rhythm 1
- entertaining 1
- fast metal drumming 1
- fast tempo 1
- groovy bass line 1
- guitar accompaniment 1
- heavy metal music 1
- instrumental music 1
- keybiard accompaniment 1
- latin dance song 1
- latin pop song 1
- love song 1
- male latin singer 1
- passionate 1
- percussive bass line 1
- rebellious 1
- reggae music influences 1
- romantic 1
- song ending 1
- song fade 1
- spirited 1
- vocal harmony 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Happy music 1
- Heavy metal 1
- Rock music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bowl for Two - The Expendables | A male singer sings this cheerful melody with backup singers in vocal harmony. The song is medium tempo with a reggae style drum and guitar accompaniment, guitar lead and a groovy bass line. The song is romantic and cheerful . The song is a Latin pop dance song. The audio quality is average. | 2007-09-02T03:29:08Z | P3DRO2 | lovin it | ["Music", "Happy music"] | ["male latin singer", "backup singers", "vocal harmony", "keyboard accompaniment", "average audio quality", "groovy bass line", "guitar accompaniment", "guitar lead", "bouncy drum rhythm", "reggae music influences", "keybiard accompaniment", "entertaining", "cheerful", "romantic", "love song", "latin pop song", "latin dance song", "groovy rhythm"] | 1 | euAQCWBX6ns | 3904 | |
W.A.S.P. - My Tortured Eyes LYRICS | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | 2011-08-19T16:13:10Z | nagito11 | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | 1 | nbb8vmfjHJs | 4563 |
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;