musiccaps_details (view)
2 rows where "youtube_published" is on date 2013-11-23
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lotería de Navidad (PARODIA ERUCTOS) | A classical, slightly jazzy piano is playing a lovely composition with a lot of reverb. During the song you can hear footsteps. Someone is running through water. Then at the end someone is burping really loud. This whole composition with the burping could be part of a funny embarrassing scene in a movie. | 2013-11-23T14:01:30Z | CarliRih | Lotería de Navidad (PARODIA ERUCTOS) | ["Burping, eructation", "Music"] | ["classical/jazzy/piano-composition", "big burp", "footsteps sample", "slow to medium tempo", "sincere to disgusting atmosphere"] | 6 | SrLhnoBMyWM | 2792 | |
Robbie Williams I Wan'na Be Like You feat Olly Murs The Graham Norton | A male voice is singing in the midrange then another male voice joins singing in a lower harmony. In the background you can hear a jazz drum playing along with an upright bass and a flute. An acoustic piano is playing jazzy licks. Then the drum breaks the beat with strong fill-ins before a brass section elevates the piece. This song may be playing live during a jazz performance. | 2013-11-23T09:37:56Z | Jenny Ocean | ["Singing", "Music", "Ska"] | ["jazz/pop", "male voices singing", "acoustic piano", "flute", "upright bass", "brass section", "uptempo", "funny"] | 6 | XhV4zf-Xlmk | 3213 |
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;