musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "country music" and musiccaps_aspects contains "romantic" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- country music · 2 ✖
- medium tempo 2
- romantic · 2 ✖
- acoustic guitar 1
- adventurous 1
- backing track 1
- bad audio quality 1
- cello 1
- church organ 1
- country folk song 1
- country hits 1
- country pop 1
- cymbals crashing 1
- dreamy 1
- dulcet 1
- emotional 1
- exciting 1
- fiddle 1
- gain issues 1
- great adventure 1
- guitar rhythm 1
- instrumental music 1
- male singer 1
- melancholic 1
- mellifluous 1
- mellow 1
- movie themes 1
- organ accompaniment 1
- passionate 1
- performance 1
- regional pop 1
- retro classics 1
- sentimental 1
- sentimental nostalgic 1
- story telling 1
- string harmony 1
- string orchestra 1
- tambourine percussion 1
- vintage hits 1
- vintage pop 1
- viola 1
- violin 1
musiccaps_names (array) 8 ✖
- Electric piano 1
- Electronic organ 1
- Hammond organ 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
d85 yamaha organ solo one man band | The song is an instrumental. The tempo is medium with a church organ playing melody, steady drumming rhythm, cymbals crashing, tambourine percussion, steady bass, and guitar playing rhythm. The song is exciting and retro nostalgia. The audio quality is poor. | 2009-02-01T04:39:30Z | fathau | one man band | ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ", "country music", "backing track", "medium tempo", "instrumental music", "tambourine percussion", "cymbals crashing", "guitar rhythm", "organ accompaniment", "vintage hits", "bad audio quality", "gain issues", "exciting", "adventurous", "retro classics", "passionate", "great adventure", "romantic", "movie themes", "vintage pop"] | 1 | A_Yd5huF2Pg | 1136 |
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;