musiccaps_details (view)
2 rows where musiccaps_aspects contains "inferior audio quality", musiccaps_aspects contains "male singer" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- amateur recording 2
- inferior audio quality · 2 ✖
- male singer · 2 ✖
- steady drumming 2
- cheering 1
- chirpy 1
- classic melody 1
- classic rock 1
- distorted sound 1
- emotional 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- folk song 1
- foreign language 1
- guitar accompaniment 1
- happy 1
- home video 1
- hooting 1
- inaudible lyrics 1
- indistinct chatter 1
- keyboard arrangement 1
- keyboard harmony 1
- lively trumpets 1
- melodic 1
- muffled vocals 1
- party songs 1
- people talking 1
- peppy 1
- pop 1
- popular songs 1
- regional music 1
- retro 1
- retro rock and roll 1
- rock and rock 1
- rustling 1
- slow tempo 1
- soft melody 1
- straight bass lines 1
- violin symphony 1
- vocal backup 1
musiccaps_names (array) 6 ✖
- Music 2
- Singing 2
- Gospel music 1
- Music of Latin America 1
- Ska 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 |
---|---|---|---|---|---|---|---|---|---|---|
Shira Choir Rocking it away with Pinky Weber Music by Pinny Ostreicher | A male vocalist sings this spirited song. The tempo is fast with trumpets, keyboard harmony, steady drumming and simple bass lines along with vocal backup. The song is happy, energetic, enthusiastic, popular, peppy, vivacious and celebratory. There are sounds in the background of people talking, hooting, cheering and scuttling and rustling. This is a popular Folk/Regional song. | 2015-09-04T19:04:46Z | Go Jewish Music | At a Siyem in Upstate! | ["Singing", "Music", "Ska", "Music of Latin America"] | ["male singer", "fast tempo", "vocal backup", "popular songs", "hooting", "rustling", "home video", "amateur recording", "party songs", "foreign language", "lively trumpets", "keyboard harmony", "steady drumming", "straight bass lines", "vocal backup", "people talking", "cheering", "energetic", "happy", "enthusiastic", "home video", "inferior audio quality", "folk song", "regional music", "happy", "peppy", "chirpy"] | 7 | 1hABzqBHh7w | 297 | |
BJ Thomas ~ Rock And Roll Lullaby | A male vocalist sings this melodic song. The tempo is medium with muffled vocals, violin harmony, rhythmic guitar , steady drumming and straight bass lines. The language and lyrics of the song are inaudible because of the amateur recording.This song is a Classic Rock and Roll. | 2011-06-25T22:02:46Z | IP Casino Resort Spa | BJ Thomas sings "Rock And Roll Lullaby" in Studio A in the IP Casino Resort Spa on June 24, 2011 | ["Singing", "Gospel music", "Music", "Wedding music"] | ["male singer", "slow tempo", "inaudible lyrics", "amateur recording", "melodic", "indistinct chatter", "soft melody", "emotional", "distorted sound", "violin symphony", "guitar accompaniment", "keyboard arrangement", "muffled vocals", "inferior audio quality", "rock and rock", "classic melody", "pop", "classic rock", "retro", "retro rock and roll", "steady drumming"] | 7 | BUzsQ6WohH4 | 1245 |
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;