musiccaps_details (view)
5 rows where musiccaps_aspects contains "good mood" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- good mood · 5 ✖
- uptempo 3
- accordion 2
- acoustic drums 2
- upright bass 2
- acoustic guitars 1
- amateur recording 1
- banjo 1
- crowd clapping 1
- e-bass 1
- e-guitar 1
- fast tempo 1
- folk/country 1
- higher register yodeling 1
- male voice 1
- male voice yodeling 1
- male voices singing 1
- mandolin 1
- medium to uptempo 1
- organ 1
- percussion 1
- piano 1
- pop 1
- rock&roll 1
- string instrument 1
- upright/e-bass 1
- violin 1
- yodel/folkmusic 1
- yodeling/folk 1
musiccaps_names (array) 9 ✖
- Music 5
- Yodeling 2
- Bluegrass 1
- Chorus effect 1
- Country 1
- Rock and roll 1
- Roll 1
- Singing 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Androma - Gunjule | This song contains a loud organ sound playing a chord melody in the mid-higher register along with a piano panned to the left side of the speakers. The organ is slightly pulsating. A loud e- guitar is playing a simple short and monotone melody with a delay on the right side of the speakers. All the instruments use reverb. This song may be playing on a beach bar. | 2013-04-08T18:57:33Z | TheSoundYouNeed | TheSoundYouNeed - Music at its finest ll Website : http://www.thesoundyouneed.net ll Facebook : http://on.fb.me/12s8hhw ll Soundcloud : http://bit.ly/Ud6RVg For copyright issues, mail us here : tsyn.thesoundyouneed@gmail.com ☞ Follow Androma https://soundcloud.com/andromamusic http://www.facebook.com/pages/Androma/300297440004983?ref=hl# ☞ Download Here https://soundcloud.com/andromamusic/androma-gunjule ✖ Picture by Emman Montalvan http://emmanfotos.tumblr.com Andromeda gunjule | ["Music", "Chorus effect"] | ["pop", "e-guitar", "organ", "piano", "uptempo", "good mood"] | 6 | 6SB2FIU9SBc | 757 | |
Justin BIEBER YODELLING! | A male voice is singing/yodeling along to an accordion playing a melody and chords while an upright bass is playing a simple line along with a minimal drum playing along. In the background the crowd is clapping along to the beat. This song may be playing at a folk fest. | 2010-04-23T22:06:18Z | nikhil5556 | OMG ITS JUSTIN BIEBER YODELING FOR ESMEE DENTERS!!!! - I do not hate Justin Bieber in anyway this is just a JOKE. The actual song is franz lang - einin jodler hor I gern ... Are you stupid writing Fake? Of course it's not real... | ["Singing", "Yodeling", "Music"] | ["yodeling/folk", "male voice yodeling", "accordion", "upright bass", "crowd clapping", "percussion", "medium to uptempo", "good mood"] | 6 | Es9FNjZ-SHI | 1595 | |
Тирольские напевы / JODELN / Йодль | An accordion is playing short notes on the offbeat along with soft snare hits being played with brushes. A bass is playing straight, changing the note on every beat. Another accordion is answering the yodeling male voice with a short melody. The male voice is loud, clear and sings a melody in the higher register. A guitar-like instrument is strumming chords in the higher register. The instruments are panned to the left and right side of the speakers. This song may be playing at a concert in the countryside. | 2013-04-27T14:32:58Z | Prometheus | ["Swing music", "Yodeling", "Music"] | ["yodel/folkmusic", "accordion", "acoustic drums", "upright/e-bass", "string instrument", "male voice", "higher register yodeling", "fast tempo", "good mood"] | 6 | IyJ3a5uuCOs | 1956 | ||
Cherokee Shuffle & Sled Ride - Townsend Bluegrass Jam, 5 5 12 | This song contains people strumming chords on acoustic guitars while a banjo and a mandolin are taking turns playing a lead melody. In the background you can hear an upright bass playing a fitting bassline. This song may be playing live while having a BBQ with friends. | 2012-06-25T22:02:35Z | gingermc2 | I know the name of only two people in this jam session; McCoy Borg, the banjo player & Josh-mandolin.. I think the woman playing bass is from Ohio. Spring Festival @ Townsend, TN 5-5-12. | ["Country", "Music", "Bluegrass"] | ["amateur recording", "folk/country", "acoustic guitars", "mandolin", "banjo", "upright bass", "uptempo", "good mood"] | 6 | Ok-ia7ziJy0 | 2465 | |
Bionic Man - Fabulous Poodles - Urgente Rock and Roll | An acoustic drum is playing a light Rock&Roll groove with crash hits and emphasis on kick and snare along with a e-bass enhancing the fast paces mood and giving reasons to move the body along to the beat. Strings like a violin are adding some atmosphere with hits in the background and playing a crescendo to break into the next part of the song while male voices are singing together. This song may be playing when having or wanting a good mood. | 2008-12-27T03:00:04Z | opentaker | hay les dejo otra rola de los poodles muy buena esta la encontre en el cd de his masters choice | ["Music", "Roll", "Rock and roll"] | ["rock&roll", "e-bass", "acoustic drums", "male voices singing", "violin", "uptempo", "good mood"] | 6 | Vt3HzkNtOP4 | 3039 |
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;