musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "relaxing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- groovy bass · 2 ✖
- low quality 2
- relaxing · 2 ✖
- calming 1
- chill 1
- distorted 1
- easygoing 1
- electric guitar solo melody 1
- flat male vocal 1
- funky electric guitar chords 1
- harsh 1
- mellow snare hits 1
- mellow synth pad 1
- mono 1
- noisy 1
- reverberant tinny bells 1
- soft kick hits 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 |
---|---|---|---|---|---|---|---|---|---|---|
1kw am dds pwm transmitter broadcast class d | The low quality recording features funky electric guitar chords, electric guitar solo melody and groovy bass playing in the background. The recording is very noisy, distorted and harsh, but it is still easygoing and chill - like something you would listen to when you are trying to relax. | 2014-04-26T14:11:17Z | amhercules | High quality broadcast transmitter 1kw ,class D ,PWM,DDS | ["Music", "Radio", "Rock and roll", "Plucked string instrument"] | ["low quality", "noisy", "mono", "funky electric guitar chords", "electric guitar solo melody", "groovy bass", "easygoing", "distorted", "harsh", "chill", "relaxing"] | 4 | AVuh8-CucrE | 1130 | |
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 |
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;