musiccaps_details (view)
1 row where musiccaps_aspects contains "dance hall rhythm", musiccaps_aspects contains "happy", musiccaps_aspects contains "syncopated snare" and musiccaps_names contains "Jingle (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 |
---|---|---|---|---|---|---|---|---|---|---|
Punjabi jingle bell | The low quality recording features a dance hall rhythm Christmas song that consists of flat male vocals, alongside high pitched male vocals at the very beginning, singing over syncopated snare, plucked sitar melody, "4 on the floor" kick pattern and simple bass. It sounds fun and happy, like something kids would listen to. | 2009-04-16T13:09:36Z | Basis Morse | Punjabi jingle bell | ["Jingle (music)", "Music"] | ["low quality", "dance hall rhythm", "flat male vocal", "high pitched male vocal", "male chants", "plucked sitar melody", "syncopated snare", "simple bass", "\"4 on the floor\" kick pattern", "fun", "happy"] | 4 | MHkfPjW0aRg | 2253 |
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;