musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "keyboard" and musiccaps_aspects contains "rock music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- acoustic drums · 2 ✖
- bass guitar 2
- electric guitar 2
- keyboard · 2 ✖
- rock music · 2 ✖
- easygoing 1
- eclectic 1
- guitar solo 1
- loud 1
- male vocal 1
- psychedelic 1
- rebellious 1
- spanish 1
musiccaps_names (array) 3 ✖
- Music 2
- Roll 2
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Grateful Dead - Cream Puff War 1967 | This is a rock music piece. There is a medium-to-high pitched electric guitar solo at the forefront. In the melodic background, a keyboard and a bass guitar repeating the same pattern can be heard. The acoustic drums are playing a loud and slightly fast-paced rock drum beat. There is a rebellious atmosphere to this piece. It can be used in the soundtrack of a teenage drama or a crime shootout video game. | 2008-12-06T17:32:21Z | gratefulvideo | Quote from Jerry Garcia (with typo) Something's Happening 1967 | ["Music", "Roll"] | ["rock music", "electric guitar", "guitar solo", "keyboard", "bass guitar", "acoustic drums", "loud", "rebellious", "eclectic", "psychedelic"] | 9 | C1M5xqDQW58 | 1319 | |
SOY TU ROMANTICO ROCK AND ROLL | This is a rock music piece. The male vocalist is singing melodically in the Spanish language. The keyboard is playing the chords of the song while the electric guitar joins with the occasional fills. There is a relatively quiet bass guitar supporting them in the background. The acoustic drums provide a basic rock beat for the rhythm. It has an easygoing feeling. This piece could be used in a teenage drama taking place in a Spanish-speaking country. | 2011-07-13T23:21:03Z | Alejandro Emmanuel | ["Music", "Roll", "Rock and roll"] | ["rock music", "male vocal", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "spanish", "easygoing"] | 9 | deIj55UAxeo | 3806 |
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;