musiccaps_details (view)
1 row where musiccaps_aspects contains "deep voices", musiccaps_aspects contains "hissing sounds" and musiccaps_aspects contains "moderate tempo"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Halloween Horror - Scary Images, Sounds and Music | This instrumental song features a piano melody playing at an odd time signature. After two bars, the piano melody shifts by one semi-tone. This is accompanied by the sound of hissing and crying voices. There are ghostly sounds being played in the background. The theme of this song is scary. This song can be used in a horror movie. A sound like that of a fast clock is played in the background. | 2010-10-26T18:09:40Z | grannycleo52 | This is a mix of scary sounds: http://www.mediafire.com/?ltnktunymuk and the Theme Song from the film "Halloween". I used the free open-source editor "Audacity", which is very easy to use. ENJOY ;-) Dit is een mix van enge geluiden: http://www.mediafire.com/?ltnktunymuk en de Theme Song van de film "Halloween". Ik heb hiervoor het open-source geluidsbewerkingsprogramma "Audacity" gebruikt, dat heel gebruiksvriendelijk is. LUISTER, KIJK EN HUIVER!! | ["Music", "Scary music"] | ["piano music", "crying voices", "hissing sounds", "ghostly sounds", "horror theme", "evil melody", "moderate tempo", "deep voices", "haunting theme"] | 0 | iMmYVLSb1IY | 4179 |
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;