musiccaps_details (view)
3 rows where musiccaps_aspects contains "animated" and musiccaps_aspects contains "funny" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- animated · 3 ✖
- funny · 3 ✖
- amateur singing 1
- animated electronic sound 1
- auto tune 1
- bee buzzing 1
- brass section 1
- bumblebee 1
- childish lyrics 1
- children’s song 1
- composer 1
- concert hall 1
- conductor 1
- energetic 1
- exciting 1
- fast tempo 1
- foreign language 1
- four stringed instrument 1
- great journey 1
- guitar 1
- home video 1
- homer simpson cover 1
- horn section 1
- instrumental 1
- instrumental music 1
- keyboard harmony 1
- magical 1
- male vocalist 1
- male voice talking 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- mysterious 1
- off key singing 1
- opera hall 1
- orchestra 1
- positive 1
- pulsating 1
- relatable 1
- rhythmic acoustic 1
- simple bass lines 1
- simple melody 1
- soft 1
- steady drumming 1
- string section harmony 1
- twists and turns 1
- ukelele melody 1
- violin accompaniment 1
- virtuoso 1
- wondrous 1
- wooden xylophone 1
musiccaps_names (array) 10 ✖
- Music 2
- /t/dd00003 1
- Guitar 1
- Musical instrument 1
- Orchestra 1
- Plucked string instrument 1
- Singing 1
- Speech 1
- Synthetic singing 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Homer Simpson singing poker face | A male vocalist sings this animated song. The tempo is medium fast with keyboard harmony, acoustic guitar , steady drumming and simple bass lines. The song is simple, catchy, funny, spirited, animated and easy to sing along. The lyrics are funny. | 2012-05-22T09:02:36Z | Mindaugas Paskauskas | ["Music", "/t/dd00003", "Synthetic singing"] | ["male vocalist", "medium fast tempo", "off key singing", "relatable", "simple melody", "funny", "homer simpson cover", "home video", "amateur singing", "animated", "childish lyrics", "keyboard harmony", "steady drumming", "simple bass lines", "auto tune", "rhythmic acoustic", "guitar"] | 7 | 4W8IZxn3nEI | 581 | ||
Chikungunya | This music is a ukelele instrumental. The tempo is medium with the sound of a bee buzzing and an animated sound followed by a dialogue between two men in a foreign language. The music is mellow, soft and simple like it's meant for children. | 2014-10-04T21:51:37Z | Sancocho | Chinkungunya by Sancocho De los Creadores de "Ser Boricua Esta Brutal" Ahora les traemos Un tema exclusivo para internet Chinkungunya. Pronto Esperen el Disco Entero, pronto en Algun Momento y Despues las Presentaciones en Vivo, Creemos! WHAT!?! Composicion por Andre Caro y Osvaldo Friger con la Ayuda de Lejos de Dwella | ["Singing", "Guitar", "Music", "Musical instrument", "Ukulele", "Speech", "Plucked string instrument"] | ["instrumental", "medium tempo", "male voice talking", "soft", "mellow", "animated", "foreign language", "four stringed instrument", "bee buzzing", "ukelele melody", "animated electronic sound", "funny", "animated", "children’s song"] | 7 | I_wT76iYBdQ | 1920 | |
"Flight of the Bumblebee" - Patrick De Smet, Carlo Willems & Il Novecento | The song is an instrumental. The tempo is fast , with a philharmonic orchestra consisting of string section, rhythm section and horns accompanying a virtuoso wooden xylophone playing this western classical hit. The song is energetic and exciting. | 2009-01-14T18:27:23Z | NOTPvids | Patrick De Smet, Carlo Willems & Il Novecento - "Flight of the Bumblebee" Night of the Proms (France, 2007) | ["Orchestra"] | ["violin accompaniment", "virtuoso", "wooden xylophone", "orchestra", "instrumental music", "horn section", "brass section", "conductor", "composer", "opera hall", "concert hall", "fast tempo", "exciting", "bumblebee", "funny", "animated", "wondrous", "magical", "great journey", "twists and turns", "energetic", "pulsating", "mysterious", "positive", "string section harmony", "fast tempo"] | 1 | uZHE9b1WDuM | 5124 |
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;