musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass", musiccaps_author = 4 and musiccaps_names contains "New-age music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- groovy bass · 2 ✖
- low quality 2
- soft kick hits 2
- calming 1
- flat male vocal 1
- groovy organ keys melody 1
- happy 1
- joyful 1
- mellow snare hits 1
- mellow synth pad 1
- organ keys lead melody 1
- relaxing 1
- reverberant tinny bells 1
- shimmering hi hats 1
musiccaps_names (array) 3 ✖
- New-age music · 2 ✖
- Music 1
- Swing music 1
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 | |
Musical Medley | The low quality recording features a groovy piano organ keys in the left channel and organ keys lead melody played in the right and the middle channel of the stereo image, followed by groovy bass, shimmering hi hats and soft kick hits. It sounds happy and joyful. | 2011-09-13T03:52:37Z | Florian Hutter | ► CD-Shop: https://www.florianhutter.com ► Facebook: https://www.facebook.com/florianhuttermusic/ ► Instagram: https://www.instagram.com/florianhuttermusic ► Twitter: https://twitter.com/galatm900 Florian Hutter - Wersi Gala | ["Swing music", "New-age music", "Music"] | ["low quality", "groovy organ keys melody", "organ keys lead melody", "groovy bass", "shimmering hi hats", "soft kick hits", "happy", "joyful"] | 4 | l0fCHZhKEDA | 4369 |
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;