musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "mellow synth pad" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- low quality · 3 ✖
- mellow synth pad · 3 ✖
- energetic 2
- groovy bass 2
- addictive synth lead melody 1
- background harmonizing vocals 1
- bright wide steel guitar melody 1
- calming 1
- claps 1
- dull 1
- energetic drums 1
- flat male vocal 1
- fun 1
- groovy 1
- groovy thin bass 1
- happy 1
- hip hop 1
- live performance 1
- mellow snare hits 1
- mono 1
- noisy 1
- passionate female vocal 1
- pop 1
- relaxing 1
- reverberant flute melody 1
- reverberant tinny bells 1
- shimmering triangle 1
- soft kick 1
- soft kick hits 1
- tinny muffled percussive elements 1
- tropical 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Seeing Earth from Space: New International Space Station Time-lapse | The low quality recording features a mellow synth pad, mellow snare hits, soft kick hits, reverberant tinny bells, groovy bass and there is a flat male vocal singing over it. It sounds calming and relaxing. | 2012-03-06T17:51:09Z | SpaceRip | We've all seen pictures of Earth from space, but have we really taken the time to appreciate what our planet looks like against the starscapes of the Milky Way galaxy? Here, we beckon viewers to see Earth in its cosmic context, which includes the stars, interstellar gases, the moon, the sun, and the solar winds. Be sure to watch in full HD, 1080p, and imagine you're an astronaut aboard the International Space Station with a little time on your hands. | ["New-age music"] | ["low quality", "mellow synth pad", "mellow snare hits", "reverberant tinny bells", "groovy bass", "soft kick hits", "flat male vocal", "calming", "relaxing"] | 4 | BEhIGoq9tow | 1221 | |
Antaeus - Kyrie (Official Music) | The low quality recording features a hip hop song that consists bright, widely spread steel guitar melody, tinny muffled percussive elements, shimmering triangle, reverberant flute melody, claps, soft kick hits, mellow synth pad and groovy bass that glues everything together. It sounds kind of dull, but groovy, energetic and tropical - thanks to those flute and guitar melodies. | 2015-02-12T11:31:28Z | A L P H A | ["Traditional music", "Music"] | ["low quality", "hip hop", "tinny muffled percussive elements", "bright wide steel guitar melody", "shimmering triangle", "reverberant flute melody", "claps", "soft kick", "groovy bass", "mellow synth pad", "dull", "energetic", "tropical", "groovy"] | 4 | HS_ikHx4LIQ | 1803 | ||
Melissa Manchester - You Should Hear How She Talks About You | The low quality recording features a live performance of a pop song that consists of passionate female vocals, alongside background harmonizing vocals, singing over energetic drums, groovy, thin bass, mellow synth pad and addictive synth lead melody. Even though the recording is noisy and in mono, it sounds energetic, happy and fun. | 2007-05-21T17:06:41Z | Guido Antonio Di Carlo | Melissa Manchester - You Should Hear How She Talks About You live at Solid Gold 1982 | ["Singing", "Independent music"] | ["low quality", "mono", "noisy", "pop", "live performance", "energetic drums", "groovy thin bass", "mellow synth pad", "addictive synth lead melody", "passionate female vocal", "background harmonizing vocals", "energetic", "happy", "fun"] | 4 | W_MZo88gzrA | 3107 |
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;