musiccaps_details (view)
3 rows where musiccaps_aspects contains "pop", musiccaps_aspects contains "pop hits" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- pop · 3 ✖
- pop hits · 3 ✖
- dance music 2
- fast tempo 2
- male singer 2
- youthful 2
- acoustic guitar 1
- amateur drumming 1
- animated percussions 1
- bright violin 1
- buoyant 1
- celebration 1
- dj 1
- electro pop 1
- emotional 1
- emphatic vocals 1
- energetic 1
- folk music 1
- folk pop 1
- folk song 1
- foreign language 1
- funky 1
- groovy bass line 1
- happy 1
- house 1
- instrumental 1
- lively mandolin 1
- medium tempo 1
- melodic 1
- merry 1
- nostalgic 1
- pleasant 1
- punchy 1
- punchy bass lines 1
- recurring vocal riff 1
- regional pop 1
- rhythmic acoustic guitar 1
- romantic 1
- sentimental 1
- soft keyboard harmony 1
- soft pop 1
- steady drumming 1
- straight drumming 1
- subtle bass line 1
- synth pop 1
- synthesiser arrangement 1
- tambourine 1
- vocal backup 1
- world music 1
musiccaps_names (array) 10 ✖
- Music 3
- /t/dd00004 1
- Dance music 1
- Disco 1
- Electronic dance music 1
- Electronica 1
- House music 1
- Jingle (music) 1
- Singing 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 |
---|---|---|---|---|---|---|---|---|---|---|
Θα κάνω φασαρία-Γιαννούλης Βαζαίος | A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. | 2010-06-29T13:03:59Z | mike gr | από το cd ''να μαστε πάλι[πιτσιρίκα]'' | ["Jingle (music)", "Music"] | ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] | 7 | 40D4L5Ndi6k | 529 | |
Mix Musica Electronica 2013 (Electro House) VOL 14 | This song is an energetic electronic instrumental. The song is medium fast tempo with an insistent synthesiser rhythm, dissonant tambourine funky bass and basic , amateur drumming, recurring vocal riff and vocal backup . The song is youthful, spirited, punchy and catchy with a dance groove. This song is an Electro Pop song. | 2013-08-16T21:54:34Z | leonel ybarra | Dj L30- Electro House 2013 , Mix de los mejores temas de electro: VOL 14 (Mix agosto 2013) Tracklist: 1-MACKLEMORE RYAN LEWIS THRIFT SHOP (DFM MIX) 2-Michael Woods Clanga (Original Mix) 3-Will Moore Super Jam (Original Mix) 4-Carnage Borgore Incredible (Original Mix) Seguime en SOUNDCLOUD: https://soundcloud.com/leonel-ybarra ----------------------------------------------------------------------------- DESCARGÁ el Mix: http://www.mediafire.com/download/6d61k3dtdz1onws/14- Si te gusto click en Mg.. :D Y SUSCRIBITE.... Best Electro & House 2014 New Years Party Mix Best Dance Music 2014 New Electro House House 2014 (Winter Love #5) Dj D3evice & MindOneBG The Best Electro House -- Dance Mix 2014 Sexy Girl ( FreeYoutube ) Electro House 2014 ! THE Best Dance Music New Electro House Hand UP 2014 #49 New Best of electro progressive House Music ( Club Mix Remix 2014 ) Electro House Mix 2014 Electro & House Club Mix 2014 | Bangerbeatz Ep.49 (PeeTee vs Merk & Kremont) New Techno & Electro House Hands Up 2014 { Sexy DIRTY House Music } #32 Electro & House 2014 Dance Mix #57 New Best Electro House Techno 2014 #28 NEW BEST ELECTRO HOUSE MUSİC MIX 2013/2014 CLUB MİX NEW DANCE MUSİC ELECTRO HOUSE MUSIC MIX 2013 NEW ELECTRONIC DUBSTEP MUSIC 2013 [EP.2] BEST ELECTRO HOUSE MIX OF 2012 / SPECIAL ELECTRO MIX / [EP.24] - By Dj Epsilon BEST OF 2013 ELECTRO HOUSE MIX - NEW #23 BEST DAMN ELECTRO HOUSE MIX OF 2013 / SPECIAL ELECTRO DANCE MIX / [EP.47] - By Dj Epsilon Dirty Electro House Music Mix 2014 The best Mix Electro House MUSIC 2014 #27 Electro & House Club Mix 2014 | Bangerbeatz Ep.49 (PeeTee vs Merk & Kremont) THE BEST ELECTRO HOUSE MUSIC HAPPY NEW YEAR MIX 2014 Best Dance Music 2014 New Electro House House 2014 (Winter Love #5) Dj D3evice & MindOneBG Electro House New Best Club Mix Remix Radio Edit 2014 Music { Sexy Hot Girl } BEST Electro & House Dance Charts Party Mix 2014 #53 BEST ELECTRO HOUSE & CLUB PROGRESSIVE DANCE MUSIC MEGAMIX 2013 [100 MIN] | DJ Adi-G Musica Electronica 2014 2013 NEW The Best Of The Ele… | ["Disco", "House music", "Music", "Electronic dance music", "Dance music", "Electronica"] | ["instrumental", "fast tempo", "electro pop", "amateur drumming", "house", "dj", "dance music", "punchy", "funky", "youthful", "buoyant", "synthesiser arrangement", "tambourine", "punchy bass lines", "straight drumming", "recurring vocal riff", "dance music", "synth pop", "pop", "pop hits", "vocal backup"] | 7 | UUJ1DNycpiQ | 2919 | |
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 |
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;