musiccaps_details (view)
3 rows where musiccaps_aspects contains "catchy" and musiccaps_aspects contains "duet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- catchy · 3 ✖
- duet · 3 ✖
- animated 2
- energetic 2
- spirited 2
- acoustic guitar 1
- bongos 1
- brass instrument 1
- bright 1
- bright drumming 1
- buoyant 1
- cheerful 1
- children music 1
- chimes 1
- colourful 1
- congas 1
- descriptive words 1
- enthusiastic 1
- enthusiastic spanish guitar 1
- expressive 1
- fast tempo 1
- flageolet 1
- folk 1
- foreign language 1
- galloping rhythm 1
- groovy bass lines 1
- hand percussion 1
- high-spirited 1
- infectious 1
- infectious drumming 1
- insistent rhythm 1
- keyboard arrangement 1
- keyboard harmony 1
- latin dance 1
- latin dance music 1
- latin pop 1
- latin regional 1
- latin song 1
- learning for kids 1
- listening and learning 1
- nursery rhyme 1
- parade 1
- piano harmony 1
- pop 1
- receptive language 1
- regional music 1
- rhyming 1
- rhythmic acoustic guitar 1
- rock 1
- scissors paper 1
- simple 1
- simple melody 1
- slow tempo 1
- synthesiser arrangement 1
- trombone 1
- trumpet 1
- ukrainian song 1
- upbeat 1
- vibrant 1
- vocal backup 1
- whistle 1
- wind instrument 1
- world music 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Jazz 1
- Music for children 1
- Reggae 1
- Rhythm and blues 1
- Salsa music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Українська Весільна Музика 9 (Ukrainian Wedding Music 9) | This song is a lively Ukrainian duet. The tempo is fast and upbeat with a bright keyboard harmony, infectious drumming , groovy bass line and rhythmic acoustic guitar. The music is energetic, enthusiastic, lively, high-spirited , cheerful, happy, warm, buoyant and catchy with a simple melody. This song is a Ukrainian Pop song. | 2009-11-29T18:52:15Z | UAWaveofMusic | Українська Весільна Музика!!!!! ENJOY AND PLEASE SUBSCRIBE!!!!!! | ["Jazz", "Music", "Wedding music", "Rhythm and blues"] | ["duet", "fast tempo", "upbeat", "ukrainian song", "spirited", "enthusiastic", "energetic", "buoyant", "bright", "colourful", "catchy", "simple melody", "cheerful", "high-spirited", "pop", "foreign language", "infectious", "folk", "regional music", "keyboard harmony", "groovy bass lines", "infectious drumming", "galloping rhythm", "rhythmic acoustic guitar"] | 7 | 0ADP-O_V3vA | 129 | |
Rock Scissors Paper #1 | Finger Play Song | Super Simple Songs | This song is an animated duo in a male and female volume. The tempo is slow with a Pisano harmony, synthesiser arrangement and a small hand percussion. The song is a lively, simple, expressive,animated, rhythmic and informational children’s song/ nursery rhyme . | 2015-05-30T11:56:05Z | Super Simple Songs - Kids Songs | More great Super Simple videos in the Super Simple App for iOS ► http://apple.co/2nW5hPd Rock Scissors Paper, Rock Scissors Paper, 1,2,3...play with me! Put your hands together for a fun and creative fingerplay song for kids. What is it? Listen to Super Simple Songs on Spotify: https://spoti.fi/2ofnaZg Listen to Super Simple Songs on Apple Music: https://apple.co/2pBcg0j Or, just ask your smart speaker to play Super Simple Songs! PARENTS AND TEACHERS: Thank you so much for watching Super Simple Songs with your families and/or students. If your young ones are watching without supervision, we recommend some of the following viewing options: ► SUPER SIMPLE APP -- http://bit.ly/SuperSimpleApp Be the first to watch new Super Simple videos in the Super Simple App! Ad-free and designed for young learners. ► DOWNLOAD -- http://bit.ly/SuperSimpleShop Videos from all Super Simple channels are available for purchase at the Super Simple online shop. You can also find some DVDs there. ► YOUTUBE KIDS -- http://bit.ly/You-Tube-Kids Designed to make it safer and simpler for young ones to watch online video, YouTube Kids includes a suite of parental controls so you can tailor the experience to suit your family’s needs. ► AMAZON VIDEO Are you an Amazon Prime member? Watch Super Simple videos ad-free on Amazon Prime Video. Just search for “Super Simple.” ► KHAN ACADEMY KIDS -- http://bit.ly/KhanKids-App Super Simple has partnered with Khan Academy on their latest app designed for preschoolers. You’ll find Super Simple Songs worked into the curriculum throughout the app. ► PLAYKIDS -- http://bit.ly/Play-Kids Do you have the PlayKids app? You can find many of our Super Simple Songs and programs in the app! FREE SUPER SIMPLE TEACHING RESOURCES: http://bit.ly/SSFree-Resources SOCIAL MEDIA: Super Simple Newsletter Sign Up: http://bit.ly/SuperSimpleSignUp Facebook: http://bit.ly/SuperSimpleFacebook Instagram: http://bit.ly/SuperSimpleInsta Twitter: http://bit.ly/SuperSimpleTwitter Pinterest: http://bit.ly/SuperSimplePinterest *****… | ["Music", "Music for children"] | ["duet", "slow tempo", "piano harmony", "vocal backup", "expressive", "receptive language", "rhyming", "descriptive words", "listening and learning", "chimes", "synthesiser arrangement", "children music", "nursery rhyme", "rock", "scissors paper", "simple", "catchy", "learning for kids", "animated", "hand percussion"] | 7 | P65yE_EXLd8 | 2508 | |
Salsa Urbana Remix Con Lilatuns ( i echo Por Mi Lilatuns el musico ) | This song is a Latin duet. The tempo is fast with an ensemble of Latin instruments like Spanish guitar accompaniment, bright drums, congas and bongos rhythm, trombone and trumpets playing an animated melody and a whistle like wind instrument. The song is vibrant, energetic,engaging, upbeat and youthful. This song is Latin pop. | 2014-08-15T17:03:02Z | Lilatuns-elMusico Official | eaki esdejo este remix que ije con el acapela del hector el father piano trompetas echo por mi | ["Music", "Reggae", "Salsa music"] | ["duet", "latin song", "latin dance", "flageolet", "wind instrument", "vibrant", "catchy", "youthful", "parade", "trombone", "trumpet", "brass instrument", "congas", "spirited", "bongos", "whistle", "animated", "energetic", "latin pop", "latin regional", "keyboard arrangement", "latin dance music", "world music", "insistent rhythm", "enthusiastic spanish guitar", "acoustic guitar", "bright drumming"] | 7 | ZwfzBagtpV0 | 3428 |
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;