musiccaps_details (view)
1 row where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "mellow snare hits" and "youtube_published" is on date 2012-03-06
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;