musiccaps_details (view)
1 row where musiccaps_aspects contains "plastic impacts" and "youtube_published" is on date 2012-11-27
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 |
---|---|---|---|---|---|---|---|---|---|---|
Joys of Laughter! | The low quality recording features a kid and a male laughing back and forth. There are some plastic impacts throughout it. The recording ends with a wide synth pad layered with sustained strings over which there is a low male vocal singing. It sounds joyful, happy and heartful. | 2012-11-27T20:14:46Z | Nandhiji | This is my little boy Anukash. Sharing his sacred laughter! www.nandhi.com Gratitude! Pranaams! Love! Book: Mastery of Consciousness- Awaken the Inner Prophet - Siddhar yogic mystic wisdom of Liberation. Break the limits of body, mind and circumstances. Sensitive Planet: Handsigned by Nandhi + Gift SivaSivaa Teachings Download: http://goo.gl/RDXehM Amazon: http://goo.gl/E6nDZd India: http://goo.gl/jLUEhf | ["Music", "Giggle", "Chuckle, chortle", "Baby laughter"] | ["low quality", "noisy", "kids laughing", "male laughing", "plastic impacts", "wide synth pad", "sustained strings", "low male vocal", "joyful", "happy", "heartful"] | 4 | RF3rog2YjYw | 2682 |
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;