musiccaps_details (view)
1 row where musiccaps_aspects contains "funny female vocal", musiccaps_aspects contains "happy" and "youtube_published" is on date 2011-06-03
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 |
---|---|---|---|---|---|---|---|---|---|---|
Big Bird, Cookie Monster, and Oscar the Grouch by Ideal | The low quality recording features a children's song played on TV that consists of funny male and female vocal singing over mellow piano chord progression and happy sounding bells melody. It is really noisy and in mono, but it sounds happy and fun - like something kids would listen to. | 2011-06-03T18:54:14Z | whitgreene1 | This is one of my two sets of "The Trio" telling a story. This set will find a new home soon. This set is not playing from a cassette tape, rather a digitized version of the cassette tape playing from a MP3 player. All ten of the "trio" stories that I have are contained in the MP3 player as well as a few that only animate Big Bird. These guys always bring a smile to your face. | ["Music", "Synthetic singing", "Inside, small room"] | ["low quality", "thin", "noisy", "funny male vocal", "funny female vocal", "fun", "happy", "happy sounding bells melody", "mellow piano chord progression", "children song", "mono"] | 4 | xxCnmao8FAs | 5367 |
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;