musiccaps_details (view)
3 rows where musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Swing music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- slow tempo · 3 ✖
- male voice 2
- romantic mood 2
- trumpets 2
- tuba 2
- acoustic guitar accompaniment 1
- ambient 1
- crowd sound 1
- cymbal 1
- dulcet 1
- emphatic lead 1
- fluid 1
- groovy bass lines 1
- instrumental 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- mood 1
- no string instruments 1
- nostalgic 1
- pleasant 1
- pop song 1
- regional mexican 1
- retro pop 1
- rock and roll 1
- romantic 1
- simple melody 1
- simple percussion 1
- slow song 1
- soft 1
- steady drumming 1
musiccaps_names (array) 3 ✖
- Music 3
- Swing music · 3 ✖
- Music of Latin America 2
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Musica Romantica | This pop song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. The hi-hat is played in eighth notes. The bass is played on a tuba. The root notes of the chords are played. Trumpets play a staccato note at every alternate beat. A brass instrument plays a fill after the first two bars. The mood of this song is romantic. This song can be played in a romantic movie. | 2012-10-15T23:45:23Z | El Guapo | Musica Romantica | ["Swing music", "Music", "Music of Latin America"] | ["slow song", "pop song", "romantic mood", "male voice", "slow tempo", "tuba", "trumpets", "simple percussion"] | 0 | MeA8CSKAuvw | 2285 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 | |
recuerdos la arrolladora | This Regional Mexican song features a live recording of a male voice singing the main melody. The song starts with the cymbal played once and held so that it does not ring. Then the male voice sings one line with the crowd. The crowd shouts out in joy after a line is sung. The bass is played on a tuba. This is followed by trumpets playing a high pitched melody. This song is at a slow tempo. Apart from the initial cymbal sound, no other percussion is played. This song can be played in a romantic movie. | 2009-09-24T06:59:11Z | Luck Jimenez | ["Swing music", "Music", "Music of Latin America"] | ["regional mexican", "male voice", "crowd sound", "tuba", "trumpets", "cymbal", "slow tempo", "no string instruments", "romantic mood"] | 0 | JbWaSZPOh18 | 2023 |
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;