musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "exciting", musiccaps_aspects contains "harmonizing vocals" and musiccaps_author = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
LAUGHTER DA MASTER SEASON 2 SEMIFINAL EPISODE 18 PART 1 OF 8 | The low quality recording features a jingle that consists of harmonizing vocals talking over snare roll, toms roll, brass melody and groovy bass, after which there is a folk song that starts playing. The folk song contains strings melody, bouncy snare, shimmering hi hats and synth keys chords. It sounds energetic and exciting, and like something you would hear on some TV show. | 2013-01-08T17:16:36Z | LaughterDaMaster2 | ["Folk music", "Music", "Snicker"] | ["harmonizing vocals", "snare roll", "jingle", "tom roll", "brass melody", "groovy bass", "low quality", "mono", "folk", "bouncy snare", "strings melody", "synth keys chords", "energetic", "exciting"] | 4 | bzOeufhFITk | 3670 | ||
Far East Movement - She's On The Move HQ | The low quality recording features a pop song that consists of harmonizing vocals singing over punchy snare and kick hits and shimmering cymbals. It sounds energetic and exciting. | 2010-03-19T22:20:52Z | Paweł Szymański | Far East Movement - She's On The Move from Gossip Girl S03E14 'The Lady Vanished' I do not own any right to this video! | ["Music", "Exciting music"] | ["low quality", "pop", "harmonizing vocals", "punchy snare", "shimmering cymbals", "punchy kick", "energetic", "exciting"] | 4 | dT7uHHQEYHQ | 3789 |
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;