musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "foreign language" and musiccaps_aspects contains "happy mood" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- foreign language · 2 ✖
- happy mood · 2 ✖
- male voice 2
- celebration song 1
- disco song 1
- fast guitar strums 1
- fast tempo 1
- funk bass 1
- guitar strums 1
- hand claps 1
- moderate tempo 1
- organ 1
- simple percussion 1
- spanish rock 1
- synth string backing 1
- trumpets 1
- upbeat 1
- vocal harmony 1
musiccaps_names (array) 4 ✖
- Music 2
- Jingle (music) 1
- Pop music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Inspector - Me Estoy Enamorando (Video Oficial) | This Spanish rock song features a male voice singing the main melody. This is accompanied by rock percussion playing a simple beat. The bass plays the root notes of the chords. A guitar strums chords with upstrokes. A trumpet, saxophone and trombone plays fills in between verses. An organ pays fills at every alternate count. The mood of this song is happy and upbeat. This song can be played in a comedy movie. | 2014-05-14T20:37:22Z | Inspector Oficial | EL PRIMER SENCILLO DEL DISCO "SKA A LA CARTA" Escucha a Inspector en todas las plataformas digitales: https://ONErpm.lnk.to/inspector Escucha la playlist Mucho Ska https://ONErpm.lnk.to/MuchoSka | ["Music", "Ska"] | ["spanish rock", "fast guitar strums", "organ", "trumpets", "simple percussion", "male voice", "fast tempo", "happy mood", "foreign language"] | 0 | oswsd_r-GI8 | 4660 | |
4545 - Duarte Nogueira | This disco song features male voices singing the main melody in harmony. This is accompanied by programmed percussion playing a simple beat. The bass plays funk style bass notes. A synth plays a string voice in the background with short bursts of chords. After the first line, a guitar strum is played. This song is uptempo and has a happy mood. This song can be played in a celebratory event. | 2014-08-21T16:25:06Z | Duarte Nogueira | Jingle da campanha do deputado federal Duarte Nogueira! | ["Jingle (music)", "Music", "Pop music"] | ["disco song", "male voice", "vocal harmony", "foreign language", "funk bass", "guitar strums", "hand claps", "happy mood", "synth string backing", "upbeat", "moderate tempo", "celebration song"] | 0 | yPzhMx3NPW4 | 5407 |
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;