musiccaps_details (view)
4 rows where musiccaps_aspects contains "home recording", musiccaps_aspects contains "keyboard harmony" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- home recording · 4 ✖
- keyboard harmony · 4 ✖
- amateur recording 3
- fast tempo 2
- acoustic guitar 1
- ambient background sounds 1
- animated 1
- animated guitar 1
- animated vocals 1
- catchy riff 1
- children vocals 1
- children’s ryymes 1
- children’s song 1
- choral harmony 1
- clicking sound 1
- digital drum beat 1
- dj 1
- dj mixer 1
- duet 1
- educational 1
- electric guitar riff 1
- emphatic vocals 1
- engaging 1
- enthusiastic drumming 1
- female singer 1
- happy 1
- inferior audio quality 1
- instrumental 1
- karaoke 1
- learning 1
- loud vocals 1
- male singer 1
- medium tempo 1
- mind stimulating 1
- muddled music 1
- muffled audio 1
- multi vocalists 1
- paino tutorial 1
- peppy 1
- scratching 1
- sharp sound 1
- simple melody 1
- slow tempo 1
- songs for children 1
- songs for kids 1
- static 1
- steady drumming 1
- subdued vocals 1
- toddlers 1
- vinyl records 1
- violin harmony 1
- vocal backup 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Bicchio "Scratching with Duca" | This music is an instrumental with a groovy rhythm. The audio is of inferior quality making the sound muddled and difficult to comprehend. There is a steady rhythm in the background with the sound of a turn table, scratching , a catchy riff on the electric guitar and some sound caused by disturbance in electrical energy. | 2007-10-17T21:52:00Z | sistahduka | Dj Bicchio "Scratching with Duca" | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "fast tempo", "keyboard harmony", "digital drum beat", "scratching", "catchy riff", "electric guitar riff", "muddled music", "home recording", "amateur recording", "sharp sound", "vinyl records", "scratching", "dj", "dj mixer", "clicking sound", "static"] | 7 | 5tt_GKV13G0 | 704 | |
Me singing: I'll Make A Man Out Of You [yeah! Female version!XD] | A female vocalist sings this enthusiastic song.The tempo is medium with loud , emphatic vocals and subdued music in the background .The song is a karaoke with enthusiastic drumming, melodious violin harmony, keyboard accompaniment, groovy bass line and rhythmic acoustic guitar. | 2009-11-29T00:14:20Z | Nekokumagoro | Just for fun!^^ I sung in the last 5 minutes before I going to go sleep^^ Enjoy Rights: Disney Videorights: Kingdom Hearts(c) Square enix Karaoke by HopefulActress09 | ["/m/02zsn", "Music", "Song", "/t/dd00004"] | ["female singer", "medium tempo", "karaoke", "loud vocals", "enthusiastic drumming", "keyboard harmony", "violin harmony", "home recording", "amateur recording", "emphatic vocals", "inferior audio quality"] | 7 | gEvCUcZ6w88 | 4019 | |
Renuevame Marcos Witt - Tutorial Piano Carlos | A male vocalist sings a soft melody in a foreign language. The tempo is slow with a piano harmony . The vocals are soft and subdued with ambient background sounds. The song is simple, mellow , melancholic and soft. This song is soft pop. | 2010-11-01T20:58:01Z | CarlosMotiff | https://www.paypal.com/donate/?token=W00LAy6mMt7CxoZZd2KeiULlwN4iwdinhYltfd162hwr8Tql6kSse5C6gV8qhCFxkg_YD0&country.x=CA&locale.x=CA cualquier donacion a este ministerio sera un abendicion ...y juntos podamos seguir con esta gran labor de seguir formando muchos mas musicos para el servicio de su obra https://www.paypal.com/donate/?token=W00LAy6mMt7CxoZZd2KeiULlwN4iwdinhYltfd162hwr8Tql6kSse5C6gV8qhCFxkg_YD0&country.x=CA&locale.x=CA | ["Electric piano", "Keyboard (musical)", "Piano"] | ["male singer", "slow tempo", "keyboard harmony", "subdued vocals", "ambient background sounds", "simple melody", "home recording", "amateur recording", "paino tutorial"] | 7 | gkB4KBHBV9g | 4051 | |
Care bears movie song" forest of feelings" | This song is an animated Children’s Song. The tempo is fast with many singing different parts. The song is simple and happy with spirited backup vocals, female, male and child vocals with an animated keyboard harmony, rhythmic drumming , acoustic guitar and choral harmony. The song is light, peppy, engaging and is designed for toddlers and children. The audio is a home recording and the song is muffled. | 2013-03-30T01:01:25Z | Kristy Rivera | Forest of feelings song when the care bears and Kim and jason get sent to earth buy instead get trapped between a world between care a lot and earth. | ["Music", "Rattle (instrument)"] | ["duet", "fast tempo", "multi vocalists", "engaging", "toddlers", "choral harmony", "peppy", "happy", "acoustic guitar", "muffled audio", "home recording", "animated", "muffled audio", "animated guitar", "vocal backup", "keyboard harmony", "steady drumming", "animated vocals", "children vocals", "children’s song", "children’s ryymes", "songs for kids", "songs for children", "educational", "learning", "mind stimulating", "animated"] | 7 | w3QIsHxQfPE | 5234 |
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;