musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic rhythm guitar" and musiccaps_aspects contains "electric guitar melody" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic rhythm guitar · 2 ✖
- electric guitar melody · 2 ✖
- low quality 2
- ballad 1
- compressed 1
- country 1
- emotional 1
- flat male vocal 1
- groovy bass 1
- heartfelt 1
- mellow 1
- mellow harmonizing reverberant female vocals 1
- mellow keys melody 1
- passionate 1
- passionate male vocal 1
- shimmering hi hats 1
- soft kick hits 1
- soft rimshots 1
- uptempo 1
musiccaps_names (array) 4 ✖
- Music 1
- Singing 1
- Soul music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Dassin - Et si tu n ' existais pas | The low quality recording features a ballad that contains a flat male vocal, alongside mellow harmonizing, reverberant female vocals, singing over acoustic rhythm guitar located in the left channel, electric guitar melody in the right channel of the stereo image, groovy bass, shimmering hi hats, soft rimshots, soft kick hits and mellow keys melody. It sounds mellow, emotional, passionate and heartfelt. | 2008-12-02T21:40:48Z | melenia1 | Tu es mon amour... | ["Soul music"] | ["low quality", "ballad", "flat male vocal", "mellow harmonizing reverberant female vocals", "groovy bass", "acoustic rhythm guitar", "electric guitar melody", "shimmering hi hats", "soft rimshots", "soft kick hits", "mellow keys melody", "mellow", "emotional", "passionate", "heartfelt"] | 4 | 4kZ0EZg5JRU | 600 | |
Dr Hook and the medicine show - Yodel Song | The low quality recording features an uptempo country song sung by passionate male vocalists, followed by acoustic rhythm guitar and electric guitar melody. It sounds really bad and imbalanced, as the left channel is louder than the right. | 2009-03-05T00:21:41Z | chiefskis | Dr Hook and the medicine show - Yodel Song | ["Singing", "Yodeling", "Music"] | ["low quality", "country", "acoustic rhythm guitar", "passionate male vocal", "compressed", "electric guitar melody", "uptempo"] | 4 | CHufyCHSF1U | 1348 |
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;