musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "female voice" and musiccaps_names contains "Happy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- bass guitar · 5 ✖
- female voice · 5 ✖
- electric guitar 4
- drums 2
- acoustic drums 1
- catchy 1
- china cymbal 1
- congas 1
- country song 1
- easygoing 1
- electric piano 1
- female backing vocals 1
- flute 1
- medium tempo 1
- moderate tempo 1
- pedal steel guitar 1
- pop genreș 1
- pop music 1
- ride cymbal 1
- romantic mood 1
- sentimental 1
- shouting-like singing 1
- simple percussion 1
- strings 1
- synth sounds 1
- tambourine 1
youtube_published (date) 4 ✖
- 2009-01-11 1
- 2009-10-27 1
- 2011-06-01 1
- 2014-12-07 1
musiccaps_names (array) 4 ✖
- Happy music · 5 ✖
- Music 5
- Dance music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[NEW] All SNSD Music Videos 2007-2014 (OFFICIAL) | The pop music features a female voice singing and being accompanied by other female voices. The drums and bass guitar play a simple and repetitive groove and drive the pulsation of the music. An electric guitar is playing a funky accompaniment. A group of strings play a repetitive melody that ascends in pitch with each repetition. | 2014-12-07T18:59:58Z | soshistars | This is all the Music Videos SNSD has made from 2007 to 2014! Lets hope they make more in the future! Thanks for watching please like, comment, share & SUBSCRIBE! (if you havent already!) New Videos Every week of Kpop girl groups (especially SNSD) and SM boy groups! | ["Music", "Dance music", "Happy music"] | ["female voice", "female backing vocals", "drums", "bass guitar", "strings", "electric guitar", "pop genreș"] | 2 | 32C6w8V7TX8 | 435 | |
Hengameh - Khalkoobi | The music features a female voice singing an ascending melody. The rhythm section consists of a bass guitar, a pair of congas and a ride cymbal. An electric piano accompanies the singer with chords. In the background an electric guitar plays an accompaniment that combines melody and chords. Right at the end of the music excerpt a China cymbal can be heard. | 2011-06-01T21:33:00Z | shan5400 | ["Music", "Happy music"] | ["female voice", "electric guitar", "congas", "ride cymbal", "china cymbal", "bass guitar", "electric piano"] | 2 | 6N1LWG4aztA | 748 | ||
Laura Veirs - Galaxies (Video) | The music features a female voice singing a long note melody for the first half of the excerpt. The drums play a steady rhythm and together with the bass guitar and tambourine drive the pulse of the music. A synth sound is playing a wobbly melody. | 2009-10-27T01:54:06Z | Warner Records Vault | © 2006 WMG Galaxies (Video) | ["Music", "Happy music"] | ["female voice", "drums", "tambourine", "bass guitar", "synth sounds", "electric guitar"] | 2 | PE1ges9nn6A | 2518 | |
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 | |||||
LaLa - Lost Ones ♪ | This is a pop music piece. There is a female vocalist singing in a shout-like style. There is a flute and an electric guitar playing the melody with the bass guitar playing in the background. The rhythm is provided by a medium tempo acoustic drum beat. The tune is catchy. The piece is in the major key and there is an easygoing atmosphere to it. This piece could be used in the soundtrack of a sit-com during the credits section. | 2009-01-11T02:11:54Z | Hysteria | LaLa - Lost Ones DJ Vida V Presents American Mija no copyright to this video | ["Music", "Soul music", "Happy music"] | ["pop music", "female voice", "shouting-like singing", "flute", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "catchy", "sentimental", "medium tempo"] | 9 | svNayU6q3Dg | 4987 |
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;