musiccaps_details (view)
12 rows where musiccaps_aspects contains "romantic" and musiccaps_aspects contains "story telling" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 150 ✖
- romantic · 12 ✖
- story telling · 12 ✖
- emotional 8
- male singer 8
- medium tempo 8
- groovy bass line 5
- guitar rhythm 5
- love song 4
- passionate 4
- bad audio quality 3
- exciting 3
- female singer 3
- hip hop dance music 3
- hip hop music 3
- inspiring 3
- motivational 3
- people dancing 3
- cheerful 2
- dance rhythm 2
- groovy rhythm 2
- keyboard accompaniment 2
- latin percussions 2
- male backup singers 2
- medium fast tempo 2
- melancholic 2
- piano accompaniment 2
- poor audio quality 2
- sentimental 2
- slow tempo 2
- spirited 2
- string harmony 2
- strong bass line 2
- vocal harmony 2
- acoustic guitar 1
- adventurous 1
- ambient room noise 1
- american country music 1
- animated singing 1
- average audio quality 1
- backup singers 1
- bass guitar solo 1
- big band 1
- cello 1
- country folk musical folk singer 1
- country folk song 1
- country hits 1
- country music 1
- country music band 1
- country music hits 1
- country pop 1
- dance all night long 1
- dance club 1
- dance floor 1
- dance groove 1
- distorted guitar lead 1
- double bass 1
- dreamy 1
- dulcet 1
- emphatic vocals 1
- energetic 1
- energetic acoustic guitar 1
- entertaining 1
- fiddle 1
- gentle music 1
- groovy 1
- groovy music 1
- guiro percussions 1
- guitar accompaniment 1
- guitar band 1
- guitar lead 1
- guitars rhyme 1
- head bangers 1
- high spirits 1
- jealous 1
- keyboard harmony 1
- latin dance band 1
- latin dance groove 1
- latin dance hits 1
- latin dance music 1
- latin folk singer 1
- latin pop star 1
- latin singer 1
- life is good 1
- life lessons 1
- lilting melody 1
- live performance 1
- lively piano accompaniment 1
- madly in love 1
- male latin singer 1
- mandolin 1
- mellifluous 1
- mellow 1
- memdium tempo 1
- missing you 1
- modern hip hop hits 1
- modern love 1
- modern pop hits 1
- modern r&b hits 1
- never give up on you 1
- noir style 1
- nostalgia 1
- nostalgic 1
- nylon string guitar 1
- old classics 1
- orchestra 1
- orchestral string harmony 1
- organ accompaniment 1
- party time 1
- people screaming 1
- percussion hits 1
- percussions 1
- percussive bass line 1
- performance 1
- pop song 1
- positive 1
- r&b 1
- rapping vocals 1
- reggae hip hops music 1
- regional pop 1
- relaxing playlists 1
- retro classic rock 1
- retro dance hits 1
- retro hits 1
- retro pop hits 1
- rhythm guitar 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- screaming vocals 1
- self discovery 1
- sentimental nostalgic 1
- soaring vocals 1
- soul singer 1
- spirited spanish guitar 1
- steady drumming rhythm 1
- steady percussive rhythm 1
- string orchestra 1
- string section harmony 1
- string symphony 1
- strong bass guitar 1
- tambourine percussions 1
- together forever 1
- ukulele accompaniment 1
- vibrant ukelele harmony 1
- vibrato 1
- viola 1
- violin 1
- walking bass line 1
- youthful 1
musiccaps_names (array) 21 ✖
- Music 9
- Music of Africa 2
- Rhythm and blues 2
- Singing 2
- Afrobeat 1
- Blues 1
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Mandolin 1
- Music of Asia 1
- Progressive rock 1
- Psychedelic rock 1
- Reggae 1
- Rock music 1
- Ska 1
- Song 1
- Tender music 1
- Ukulele 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J. Cole - Too Deep For The Intro | Friday Night Lights | A female singer sings this cool melody with male backup singer in harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is groovy with a story telling nature. The song is a retro hip hop dance hit. | 2010-11-12T23:44:00Z | Archive | J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro http://coastingonadream.tumblr.com/ | ["Music", "Rhythm and blues"] | ["female singer", "male backup singers", "hip hop music", "retro dance hits", "keyboard harmony", "groovy bass line", "rapping vocals", "story telling", "romantic", "groovy music", "energetic", "spirited", "passionate", "life lessons", "melancholic", "cheerful", "life is good", "relaxing playlists", "hip hop dance music", "medium tempo"] | 1 | UfEGX0rNOvA | 2932 | |
Country Poor and Country Proud - Bluegrass Brothers | A male singer sings this gentle country music melody. The song is slow tempo with banjo, mandolin and guitar accompaniment and a double bass playing the lower register harmony. The song is emotional and nostalgic. The song is a country music hit with an average audio quality. | 2009-03-07T02:47:45Z | BGRTV | This is an older clip of the Bluegrass Brothers during a show at Hoofer's Gospel Barn in LaGrange GA. The Bluegrass Brothers are a lot of fun to watch... | ["Music", "Mandolin"] | ["male singer", "country music band", "double bass", "mandolin", "american country music", "nostalgic", "story telling", "average audio quality", "live performance", "ambient room noise", "ukulele accompaniment", "guitars rhyme", "guitar band", "country folk musical folk singer", "slow tempo", "gentle music", "country music hits", "romantic", "emotional", "lilting melody"] | 1 | O0sDg-yLvlE | 2388 | |
A time for us ~ lyrics ***there is a mistake with the name of singer. This is not Loreena*** | A female singer sings this lilting melody. The song is medium tempo with an acoustic guitar accompaniment, strong bass line, steady rhythm and piano accompaniment. The song has a bad audio quality. The song is emotional and nostalgic in nature. | 2010-08-25T18:09:52Z | CathCthrn | (Love Theme from Romeo and Juliet) (Words by Larry Kusik, Eddie Snyder / Music by Nino Rota) Lyrics A time for us, some day there'll be When chains are torn by courage born of a love that's free A time when dreams so long denied can flourish As we unveil the love we now must hide A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me A time for us, at last to see A life worthwhile for you and me And with our love, through tears and thorns We will endure as we pass surely through every storm A time for us, some day there'll be a new world A world of shining hope for you and me | ["Music", "Tender music"] | ["female singer", "bad audio quality", "medium tempo", "strong bass line", "guitar accompaniment", "pop song", "vibrato", "piano accompaniment", "string section harmony", "old classics", "retro hits", "story telling", "inspiring", "motivational", "emotional", "romantic", "nostalgia"] | 1 | 5Tq56BN8PCQ | 661 | |
*NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | 2014-07-16T20:50:50Z | OffDaGroundTV | Pre-Order "New Africa Nation" the Album now here: https://fuseodg.tmstor.es Shop for New Africa Nation Clothing online here : https://newafricanation.bigcartel.com/ / Fuse ODG's Album 'T.I.N.A' on iTunes: http://smarturl.it/FuseODGTINA *NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | ["Music", "Reggae"] | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | 1 | jQYSfy4DzIc | 4253 | |
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Pumped up Kicks Jazz Style | A male vocalist sings this mellow country song. The tempo is medium with fiddle, cello and viola harmony with acoustic guitar rhythm.The song is mellow, soft, dulcet,emotional , melancholic and nostalgic . This song is Country Pop. | 2013-07-10T00:12:19Z | Red Soda Band | A jazz style cover of Pumped up Kicks by Foster the People. This is quite a controversial tune but has been very popular for a long time which is why we recorded a cover version of it. Pumped Up Kicks Lyrics (Foster the People) Robert's got a quick hand. He'll look around the room, he won't tell you his plan. He's got a rolled cigarette hanging out his mouth, he's a cowboy kid. Yeah, he found a six shooter gun in his dad's closet hidden with a box of fun things. And I don't even know what but he's coming for you, yeah, he's coming for you. [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Dad -- he works a long day. He'll be coming home late, he's coming home late. And he's bringing me a dark surprise. 'Cause dinner's in the kitchen and it's packed in ice. I've waited for a long time. Yeah, the sleight of my hand is now a quick-pull trigger. I reason with my cigarette And say, "Your hair's on fire, you must have lost your wits, yeah." [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Ru-ru-run, run, run, run [4x] [Whistling] [Chorus 4x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Live Wedding Band: https://redsoda.com Wedding Entertainment: https://www.facebook.com/RedSodaBand/ Wedding Singers: https://www.instagram.com/redsodaband/ Sydney Wedding Band: https://www.google.com/maps/place/Red+Soda+Band+Sydney/@-33.9118834,151.1329694,15z/data=!4m2!3m1!1s0x0:0xb2508b5ae82a53cf?sa=X&ved=2ahUKEwjuvcT3pbbwAhXpwjgGHVUtCfMQ_BIwGHoECCMQBQ Phone: 02 8006 2234 | ["Music", "Wedding music"] | ["male singer", "medium tempo", "violin", "country music", "sentimental", "melancholic", "string orchestra", "string harmony", "country folk song", "country hits", "country pop", "regional pop", "fiddle", "cello", "viola", "acoustic guitar", "dulcet", "mellifluous", "mellow", "emotional", "romantic", "dreamy", "sentimental nostalgic", "story telling", "performance"] | 7 | 40xkia7fwEM | 534 | |
15. 1MILLION SOUNDS - JUNIO 2016 (BRUNO TORRES) | A male singer sings this exciting melody. The song is medium fast tempo with a groovy bass line, latin percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is exciting and fun. The song is a modern Latin pop dance hit. | 2016-06-02T12:05:11Z | TemazosMusic TV | Temazos Music 2.0: https://www.youtube.com/channel/UCjCqUvKSd1A8aUnhZekclvA Descargar: http://www92.zippyshare.com/v/pdlnpgp4/file.html FACEBOOK: https://www.facebook.com/TemazosMusicTV TWITTERS: https://twitter.com/TemazosMusicYT https://twitter.com/puchidj | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "latin singer", "latin pop star", "latin percussions", "story telling", "medium fast tempo", "latin dance music", "latin dance groove", "strong bass line", "guitar rhythm", "people dancing", "dance club", "dance floor", "passionate", "cheerful", "exciting", "romantic", "dance all night long", "party time", "latin dance hits", "keyboard accompaniment"] | 1 | L1s-oPHsOac | 2144 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 | |
Mavericks - Things You Said To Me (Live In Austin) | A male singer sings this cool melody. The song is medium tempo with a groovy guitar lead and steady drumming with tambourine percussion. The song is cool and sophisticated. The audio quality is bad. | 2009-08-31T06:32:02Z | leshumphrey | ["Blues", "Singing"] | ["bass guitar solo", "male singer", "guitar lead", "retro pop hits", "noir style", "rhythm guitar", "percussion hits", "love song", "missing you", "together forever", "strong bass guitar", "percussions", "big band", "story telling", "romantic", "emotional", "groovy", "tambourine percussions", "medium tempo", "bad audio quality"] | 1 | FXVu-YwjhxM | 1646 | ||
Won-G feat. Rick Ross and Dwyntercold "Rich Together" OFFICIAL VIDEO | A female singer sings this passionate melody backed up by singers in vocal harmony. The tempo is slow with a strong bass line, steady percussive rhythm and keyboard accompaniment. The song is emotional and spirited. The song is a modern hip hop hit. | 2015-10-10T14:09:19Z | officialwong | ["Rhythm and blues"] | ["female singer", "hip hop music", "backup singers", "modern hip hop hits", "slow tempo", "groovy bass line", "steady percussive rhythm", "keyboard accompaniment", "story telling", "emotional", "motivational", "inspiring", "groovy rhythm", "hip hop dance music", "emotional", "romantic", "love song", "high spirits", "self discovery"] | 1 | PBMfPDei93s | 2516 | ||
The Ukulele Orchestra of Great Britain - "Wuthering Heights" | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | 2010-01-22T08:50:38Z | rud1e | The Ukulele Orchestra of Great Britain - "Wuthering Heights" from the DVD 'Anarchy in the Ukulele', available to buy from http://www.ukuleleorchestra.com | ["Singing", "Music", "Ukulele"] | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | 7 | FF0VaBxb27w | 1629 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;