musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "simple bass" and musiccaps_names contains "Tender music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- simple bass · 2 ✖
- acoustic guitar strumming 1
- acoustic rhythm guitar melody 1
- arpeggiated harp melody 1
- cello counter melody 1
- electric bass guitar 1
- low quality 1
- male singer 1
- melancholy 1
- passionate 1
- piano accompaniment 1
- slow rock drum beat 1
- soft rock 1
- soulful 1
- sustained strings melody 1
- sweet 1
- traditional 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Alan Parsons Project - Time | A sweet, melancholy sounding soft rock song with a male singer accompanied by acoustic guitar strumming, a cello counter melody, piano, simple electric bass, and a slow rock drum beat. | 2009-09-09T07:18:53Z | BachChannel | No description. | ["Singing", "Music", "Tender music"] | ["soft rock", "cello counter melody", "male singer", "melancholy", "acoustic guitar strumming", "piano accompaniment", "sweet", "slow rock drum beat", "simple bass", "electric bass guitar"] | 8 | too9MtXBwts | 5068 | |
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;