musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality", musiccaps_aspects contains "powerful", musiccaps_author = 4, musiccaps_names contains "Music" and musiccaps_names contains "Speech"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Sexy Sound Served on a Plate | The low quality recording features a classical song that consists of passionate male opera vocal singing over wide strings melody, wide brass melody and woodwinds melody, over which there is a fruity male vocal talking. It sounds passionate, epic and powerful - like something for commercial. | 2013-12-20T09:02:07Z | LG TV | Slim, stylish, considerate of your needs, full-bodied... we're not talking about your ideal woman; we're talking about LG's latest product, SoundPlate (LAP340). We are proud to introduce you to the LG SoundPlate, a slim base-type speaker system that enhances the TV viewing experience with immersive audio. For more product information, please visit our websites! LG.com: http://www.lg.com/uk/speakers-sound-systems/lg-LAP340 Blog: http://whylgtv.lge.com/archives/6183 | ["Music", "Opera", "Orchestra", "Speech", "Classical music"] | ["low quality", "classical", "fruity male vocal", "passionate male opera vocal", "wide strings melody", "wide brass melody", "woodwinds melody", "passionate", "epic", "powerful", "commercial"] | 4 | YK1AEw1kf28 | 3275 |
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;