musiccaps_details (view)
1 row where musiccaps_aspects contains "calming", musiccaps_aspects contains "mellow synth pad", musiccaps_aspects contains "soft kick hits" and musiccaps_names contains "New-age music"
This data as json, CSV (advanced)
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 |
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;