musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "passionate male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional · 4 ✖
- groovy bass · 4 ✖
- low quality · 4 ✖
- passionate male vocal · 4 ✖
- passionate 3
- pop 2
- punchy snare 2
- acoustic guitar melody 1
- blues 1
- brass melody 1
- electric guitar melody 1
- energetic 1
- harmonizing male vocals 1
- harmonizing vocals 1
- hopeful 1
- joyful 1
- live performance 1
- mellow snare 1
- mono 1
- muted acoustic guitar melody 1
- noisy 1
- playback instrumental 1
- poor quality mix 1
- punchy kick 1
- shimmering cymbals 1
- shimmering shakers 1
- shimmering tambourine 1
- soft kick hits 1
- soul 1
- soulful 1
- straight piano melody 1
- synth pad 1
- toms roll 1
- upbeat 1
- wide claps 1
- wide shimmering tambourine 1
musiccaps_names (array) 7 ✖
- Music 4
- /t/dd00003 1
- Blues 1
- Country 1
- Disco 1
- Happy music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ryszard Riedel i Nocna Zmiana Bluesa - Hotelowy Blues | The low quality recording features a blues song that consists of a passionate male vocal singing over acoustic guitar melody in the left channel, muted acoustic guitar melody in the right channel of the stereo image, groovy bass, mellow snare and shimmering cymbals. It sounds passionate and emotional. | 2008-01-12T15:37:19Z | paweuek92 | Fajny kawałek :) | ["Blues", "Country", "Music"] | ["low quality", "poor quality mix", "blues", "passionate male vocal", "acoustic guitar melody", "muted acoustic guitar melody", "groovy bass", "mellow snare", "shimmering cymbals", "passionate", "emotional"] | 4 | 9Rx57dlJtIA | 1008 | |
บาสโลบจังหวะดิสโก้ | The low quality recording features a pop song that consists of a passionate male vocal singing over punchy kick and snare hits, shimmering shakers, synth pad, groovy bass and brass melody. It sounds passionate, emotional, energetic and upbeat. | 2012-10-08T01:26:28Z | Tanwarat mu | เพลงนี้ใช่ท่าจังหวะบาสโลบที่ 3 ใช้เพลงจังหวะดิสโก้เป็นจังหวะที่สนุก ฝึกความจำและสมาธิในการเต้น | ["Disco", "Music"] | ["low quality", "pop", "punchy kick", "punchy snare", "groovy bass", "synth pad", "shimmering shakers", "passionate male vocal", "brass melody", "passionate", "emotional", "energetic", "upbeat"] | 4 | _x4a974Pl-A | 3500 | |
Charlie Puth - Marvin Gaye ft. Meghan Trainor | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing vocals, singing over wide claps, layered with shimmering tambourine, groovy bass and straight piano melody. It sounds emotional and passionate. | 2015-06-28T19:27:02Z | TheBlinkStudios | This video is dedicated to Mr. Charlie Puth... and Meghan Trainor. See you guys July 12th! | ["Singing", "Music", "Happy music"] | ["low quality", "pop", "straight piano melody", "harmonizing vocals", "passionate male vocal", "groovy bass", "wide claps", "wide shimmering tambourine", "passionate", "emotional"] | 4 | hrCf8rMBtA8 | 4146 | |
New York Subway's Danny Small aka Singing Dragon | The low quality recording features a live performance of a soul song and it consists of passionate male vocal singing over playback instrumentals. The instrumental consists of a shimmering tambourine layered with punchy snare hits, soft kick hits, some toms rolls, groovy bass, electric guitar melody and harmonizing male vocals. It sounds emotional, soulful, hopeful and joyful. | 2010-03-07T21:11:15Z | BayardStudios | He calls himself the "Singing Dragon", his name is Mitchell Hughes aka Danny Small of Gheechee Records LLC aka the Singing Dragon and he was performing at the 14th St/6th Ave station. Originally from South Carolina, there is logic to the moniker Singing Dragon, he was born the same year as Bruce Lee in the Chinese calendar year of the Dragon, of Puerto Rican, Dominican, Cuban, Brazilian, Mexican and Guyanese and even Chinese descent. A marvel amongst subway performers, what a wonderful way to end a walkabout. Shot with a Canon 5D Mark II, Canon 16-35mm f/2.8L, recorded with the in-camera mic and moderately mixed in Final Cut Pro 6. | ["Music", "/t/dd00003"] | ["low quality", "live performance", "noisy", "mono", "passionate male vocal", "soul", "playback instrumental", "shimmering tambourine", "punchy snare", "groovy bass", "electric guitar melody", "soft kick hits", "toms roll", "harmonizing male vocals", "emotional", "hopeful", "joyful", "soulful"] | 4 | l1coM570kVw | 4370 |
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;