musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate", musiccaps_aspects contains "simple bass" and musiccaps_aspects contains "sustained strings melody"
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 |
---|---|---|---|---|---|---|---|---|---|---|
St Julian's School flashmob | The low quality recording features a crowd talking and clapping to a soul song that is played on a playback. The song consists of a passionate female vocal, alongside mixed harmonizing vocals, singing over sustained strings melody, simple bass and harp melody. It sounds emotional and passionate. | 2015-07-16T19:47:33Z | SouthWalesArgus | St Julian's School flashmob for Mrs Gabica | ["Singing", "Music of Asia", "Music"] | ["low quality", "crowd talking", "crowd clapping", "simple bass", "harp melody", "passionate female vocal", "mixed harmonized vocals", "sustained strings melody", "soul", "passionate", "emotional", "live performance", "playback"] | 4 | PuJxL6tLxm4 | 2575 | |
the origin of the white race | The low quality recording features an acoustic rhythm guitar melody, arpeggiated harp melody, simple bass and sustained strings melody. It sounds soulful and passionate - like a traditional song. | 2011-06-17T13:50:28Z | sicarevoluta | http://lasxtribus.wordpress.com/ Only countries whose populations have at least fifty percent of R1b haplogroup may be "sensu stricto" western european white people. that is, Only from Germany to the atlantic coast. The rest of Eastern Europe were mixed with asian and mongol people and these populations are distinctly Asian nonwhite. | ["Music", "Tender music"] | ["low quality", "acoustic rhythm guitar melody", "arpeggiated harp melody", "simple bass", "sustained strings melody", "soulful", "passionate", "traditional"] | 4 | cGrQw46ftj0 | 3694 |
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;