musiccaps_details (view)
3 rows where musiccaps_aspects contains "joyful", musiccaps_author = 9 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- joyful · 3 ✖
- live performance 2
- piano 2
- acoustic drums 1
- arpa jarocha 1
- bass guitar 1
- educational 1
- female vocal 1
- female voice 1
- introduction 1
- kids song 1
- lively 1
- male vocals 1
- melodic singing 1
- mexican folk music 1
- playful 1
- playful singing 1
- pop rock 1
- relaxed 1
- spanish 1
- ukulele 1
- upbeat 1
- vibrant 1
- xylophone 1
musiccaps_names (array) 9 ✖
- Music 3
- Speech · 3 ✖
- Bowed string instrument 1
- Harp 1
- Mandolin 1
- Music for children 1
- Musical instrument 1
- Singing 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Good Morning, Mr. Rooster | Super Simple Songs | This is an educational kids song. There is a female vocalist singing playfully. The piano and the xylophone are playing a simple melody. The rhythm is a basic acoustic drum beat. The atmosphere is joyful. This piece can be used in the soundtrack of a kids TV show. | 2012-05-11T22:39:22Z | Super Simple Songs - Kids Songs | More great Super Simple videos in the Super Simple App for iOS ► http://apple.co/2nW5hPd Time to wake up! Playing this song after a good night's sleep or an afternoon nap will help young children get up bright-eyed and ready to go! 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 ****** Good … | ["Music", "Music for children", "Speech"] | ["educational", "kids song", "female vocal", "playful singing", "piano", "xylophone", "acoustic drums", "joyful"] | 9 | 1Ziku4FLka4 | 288 | |
CAÑA DULCE Y CAÑA BRAVA - EL BUSCAPIÉ (BalconyTV) | This is the live performance of a Mexican folk music piece. In the beginning, there is a female voice giving an introductory speech in the Spanish language. Then, the arpa jarocha (which is a Mexican harp) and the ukulele start playing a lively and relaxed tune. The atmosphere is vibrant. This piece could be used in the soundtrack of a Mexican soap opera during scenes of calmer temperament. | 2011-02-07T06:44:14Z | BALCONY | Caña Dulce y Caña Brava perform El Buscapié on BalconyTV. Subscribe to us right now at - http://bit.ly/subscribetoBalconyTV Sigue http://BalconyTV.com.MX en las redes sociales! Facebook http://on.fb.me/ruwZgh Twitter http://t.co/AmbmQvTF PRESENTADO POR LETICIA SERVÍN ENGLISH - http://www.facebook.com/note.php?note_id=150310895026398 Nació como grupo en el año 2008, reuniendo el trabajo de tres mujeres emprendedoras, con una importante trayectoria dentro del arte musical, formando así, una de las pocas agrupaciones femeninas de son jarocho. Caña Dulce y Caña Brava, sembrando alegría y pasión por la música, abriga con frecuencia el decir de trovadores y versadores, enriqueciendo sus presentaciones y mostrándose como una propuesta cálida e innovadora. Actualmente, gracias a su trabajo y a la aceptación del público, han sido invitadas a participar en diversos foros nacionales e internacionales. Adriana Cao Romero, arpista reconocida internacionalmente, ha formado parte de grupos como Zacamandú, y Chuchumbé; asimismo, también ha sido partícipe de presentaciones junto a grandes talentos como El "Negro" Ojeda, don Arcadio Hidalgo, Antonio García de León, y la reconocida gambista, Hille Pearl. Raquel Palacios Vega, viene de una familia sonera por tradición. Nieta de don Andrés Vega Delfín, uno de los requinteros más grandes de Veracruz. Desde los 12 años, acompañada de su voz, la jarana y el zapateado, ha recorrido las llanuras de las regiones bajas de la cuenca del río San Juan; además de haber colaborado con grupos como Los Vega, Teterete y Los Utrera, habiéndose presentado tanto en México como en el extranjero. Norma Carrillo, originaria del Distrito Federal, tuvo su formación musical en la escuela "Vida y Movimiento". Durante 17 años formó parte de La Orquesta Sinfónica Carlos Chávez. También ha incursionado en diferentes géneros musicales como el danzón, la charanga y el son jarocho tradicional. En las siguientes páginas podrán encontrar más información sobre la agrupación de Caña Dulce y Caña Brava.… | ["Harp", "Music", "Mandolin", "Musical instrument", "Speech", "Bowed string instrument"] | ["mexican folk music", "live performance", "female voice", "introduction", "spanish", "arpa jarocha", "ukulele", "lively", "relaxed", "joyful", "vibrant"] | 9 | i70a79YhlMk | 4161 | |
Chas and Dave - Gertcha (1979) | This is a live performance of a pop rock music piece. Two male vocals are singing melodically at the same time. There is a piano playing an upbeat melody while the bass guitar plays a simple bass line in the background. The piece has a joyful aura to it. This piece could be used in the soundtrack of a sit-com during the scenes of a character happily walking through the city. | 2013-07-27T13:24:08Z | Chas and Dave Videos | Chas and Dave on 'Top Of The Pops', in 1979... they performed this song 3 times on TOTP, 31st May, 14th June & 28th June. This is probably either the 2nd or 3rd appearance. | ["Singing", "Music", "Ska", "Speech"] | ["pop rock", "live performance", "male vocals", "melodic singing", "piano", "bass guitar", "playful", "joyful", "upbeat"] | 9 | q87TmUmVg0Y | 4756 |
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;