musiccaps_details (view)
2 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "uplifting mood" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- moderate tempo · 2 ✖
- uplifting mood · 2 ✖
- background cheering and screaming 1
- caribbean influence 1
- e-bass 1
- e-guitar 1
- harmony 1
- instrumental 1
- low quality recording 1
- male voices singing 1
- no voices 1
- percussion 1
- rock&roll 1
- steel pan music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Precious Lord | This clip features a low quality recording of a song played using a steel pan. There are no voices in this song. Other percussion instruments are played to emulate shakers and kick drums. The mood of this song is uplifting and happy. The song has a Caribbean influence. This is a song that can be played at a party. | 2008-07-12T19:50:29Z | TrinidadAllStars | Performance of the Hymn 'Precious Lord', arranged by Leon 'Smooth' Edwards. Performed by Trinidad All Stars at the Folk Fair, Queen's Park Savannah, July 6th, 2008 | ["Music", "Steelpan"] | ["low quality recording", "steel pan music", "moderate tempo", "caribbean influence", "uplifting mood", "percussion", "no voices", "instrumental"] | 0 | WJORWlj6BW8 | 3084 | |
The Beatles - Twist and Shout, Live manchester 1963 | Two male voices are singing loudly together: One backing the other one. A e-guitar can be heard at the end of the phrase. In the background a e-bass and an acoustic drum can be heard but they get overthrown by the sound of the cheering and Screaming crowd. This song may be playing at a live concert. | 2014-05-27T15:54:55Z | Tesla Academy | Twist and Shout in HD | ["Music of Asia", "Music", "Pop music", "Yell"] | ["rock&roll", "male voices singing", "harmony", "background cheering and screaming", "e-bass", "e-guitar", "moderate tempo", "uplifting mood"] | 6 | kjcXM60HrRA | 4349 |
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;