musiccaps_details (view)
1 row where musiccaps_aspects contains "crowd cough", musiccaps_aspects contains "flat male vocal" and musiccaps_aspects contains "parody"
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 |
---|---|---|---|---|---|---|---|---|---|---|
funny video nivaaran cough syrup ad film | The low quality recording features a parody that contains metallic detuned percussion, funny synth lead, wide sustained string melody in the background, male and crow cough, wooden percussion hits layered with coughs and flat male vocals, alongside harmonized mixed vocals, singing over it. It sounds funny and weird - almost like a TV commercial. | 2011-09-06T16:05:17Z | cinebharathnews | its a funny creative ad | ["Carnatic music", "Mantra", "Music", "Throat clearing"] | ["low quality", "metallic detuned percussion", "funny synth lead", "wide sustained strings melody", "male cough", "crowd cough", "harmonized mixed vocal", "flat male vocal", "wooden percussion hits", "funny", "parody", "weird"] | 4 | Z7V7Curou7s | 3342 |
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;