musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "country song" and musiccaps_aspects contains "female voice" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- country song · 3 ✖
- female voice · 3 ✖
- moderate tempo 3
- romantic mood 3
- bass 2
- guitar 2
- bass guitar 1
- female backing voice 1
- kick drum 1
- low quality audio 1
- pedal steel guitar 1
- percussion 1
- simple percussion 1
- synth 1
- tambourine 1
musiccaps_names (array) 4 ✖
- Music 2
- Blues 1
- Happy music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | This country song features a female voice singing the main melody. This is accompanied by percussion playing a simple beat in common time. A pedal steel guitar plays sliding licks in the background. The bass plays the root and fifth of the chords. The mood of this song is romantic. This song can be played in a romantic movie. | ["Music", "Happy music"] | ["country song", "female voice", "pedal steel guitar", "bass guitar", "simple percussion", "moderate tempo", "romantic mood"] | 0 | 2699 | |||||
I'm Sorry I Love You - The Magnetic Fields | This country song features a female voice singing the main melody. Another female voice sings backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat in common time. A guitar strums chords. The bass plays the root notes of the chords. After the voices pause, a guitar solo is played in a repetitive pattern. The mood of this song is romantic. Other instruments cannot be heard due to low quality of audio. This song can be played in a romantic movie. | 2009-01-29T20:00:09Z | mojorisin1986 | I'm Sorry I Love You - The Magnetic Fields | ["Vocal music"] | ["country song", "female voice", "female backing voice", "guitar", "percussion", "low quality audio", "bass", "moderate tempo", "tambourine", "romantic mood"] | 0 | W00eTCOgUNs | 3053 | |
Riana Nel - Tweede Kans [Official Music Video] | This country song features a female voice singing the main melody. The melody is a contemporary country song melody. This is accompanied by the kick drum playing on every count. A synth is playing a repetitive melody in the background using two note groups. A guitar plays chords in the background. The bass plays the root notes of the chords. The mood of this song is romantic. This song can be played in a romantic movie. | 2014-09-04T13:16:41Z | Afrikaans is Groot | Riana Nel - Tweede Kans Music Video, Director: Gerhard van Rooyen, Production Company: Spheratical Productions, Record Label: Coleske Artists, 2014 | ["Blues", "Music"] | ["country song", "female voice", "bass", "kick drum", "guitar", "synth", "romantic mood", "moderate tempo"] | 0 | 75UH33tO0Bo | 809 |
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;