musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- groovy bass line · 3 ✖
- keyboard harmony · 3 ✖
- slow tempo · 3 ✖
- male singer 2
- acoustic guitar 1
- amateur playing 1
- amateur rock band 1
- ambient music 1
- buoyant 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- echo tones 1
- electric guitar lead 1
- emotional 1
- filler music 1
- fingers snapping 1
- fog horn 1
- groovy 1
- guitar lead 1
- home recording 1
- male voice speaking 1
- modern pop 1
- out of time 1
- piano accompaniment 1
- pleasant 1
- punchy beats 1
- r&b 1
- reggae 1
- relaxing 1
- retro feel 1
- rock and roll 1
- rock music 1
- romantic 1
- soft melodious 1
- soft rock 1
- soothing 1
- soul 1
- sound of horn 1
- steady drumming 1
- steady drumming rhythm 1
- super imposed male voice 1
- syncopated harmony 1
- synthesiser arrangement 1
- synthesiser articulation 1
musiccaps_names (array) 9 ✖
- Music 3
- Distortion 1
- Electric guitar 1
- New-age music 1
- Reggae 1
- Rock music 1
- Song 1
- Soul music 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 | |
Missing from YouTube | A male vocalist sings this soft melody. The tempo is medium with smooth guitar, keyboard harmony, steady bass slide and synthesiser arrangements. The song is mellow, romantic, emotional, soothing; ambient. There is a hooting sound like a fog horn with a male voice talking over the song. This song is a R&B/Soul song. | ["Music", "Reggae", "Song"] | ["male singer", "slow tempo", "sound of horn", "fog horn", "super imposed male voice", "romantic", "emotional", "soothing", "pleasant", "r&b", "soul", "acoustic guitar", "keyboard harmony", "synthesiser articulation", "fingers snapping", "groovy bass line", "male voice speaking", "reggae", "soft melodious"] | 7 | 4427 | |||||
Ray Manzarek - 02 Solar Boat | A male vocalist sings this Soft Rock. The tempo is slow with electronic arrangements,steady drumming, groovy bass line , and syncopated keyboard harmony. The background instruments play a dissonant melody. This song is a mellow, youthful, punchy, buoyant, Soft Rock. | 2009-11-04T21:57:51Z | Simagga | Ray Manzarek - The Golden Scarab | ["Music", "Soul music"] | ["male singer", "slow tempo", "rock music", "soft rock", "keyboard harmony", "groovy bass line", "syncopated harmony", "piano accompaniment", "steady drumming", "electric guitar lead", "synthesiser arrangement", "rock and roll", "retro feel", "groovy", "soft rock", "buoyant", "punchy beats"] | 7 | n4PBoAedWVA | 4517 |
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;