musiccaps_details (view)
1 row where musiccaps_aspects contains "slow tempo", musiccaps_author = 6 and "youtube_published" is on date 2011-08-01
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 |
---|---|---|---|---|---|---|---|---|---|---|
Eiffel Tower - Paris, France | This audio contains background noises of people talking. Then the music begins involving synth pad sounds playing long drones in the lower mid range to the higher register with little sparkling tones on top playing in a high pitch. This song may be playing for a meditation session. | 2011-08-01T22:41:01Z | pleasetakemeto | The Eiffel Tower was built to stand for just 20 years but has lured lovers and sightseers to her heights for more than 120 years! This beautiful tower was constructed for the 1889 Worlds Fair and at 324 metres high remained the tallest structure in the world until 1930. It is now the world's most visited man-made structure and it has been estimated that more than 200 million people have visited the tower - but it is anyone's guess how many proposals on bended knee have been made here! France Travel Guide: http://www.pleasetakemeto.com/france | ["New-age music", "Music", "Speech"] | ["amateur recording", "crowd talking", "synth pad sounds", "soothing", "slow tempo"] | 6 | pPOUg26EXiU | 4707 |
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;