musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate" and "youtube_published" is on date 2009-04-12
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- passionate · 3 ✖
- low quality 2
- acoustic guitar melody 1
- cheerleaders 1
- college band 1
- crowd cheering 1
- dance rhythm 1
- distant woodwinds melody 1
- drum sticks 1
- drums 1
- echoing passionate male vocal 1
- emotional 1
- energetic 1
- enthusiastic 1
- folk 1
- groovy rhythm 1
- high on adrenaline 1
- instrumental music 1
- joyful 1
- live performance 1
- marching band 1
- medium tempo 1
- poor audio quality 1
- samba 1
- snares 1
- soulful 1
- steady drum rhythm 1
- strummed strings melody 1
- sustained strings melody 1
- traditional 1
- various percussion hits 1
- various percussion instruments 1
- whistling 1
- wooden low percussions 1
musiccaps_names (array) 5 ✖
- Music 3
- Folk music 1
- Music of Asia 1
- Roll 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Drumline Final Battle By Hicham (High Sound Quality) | The song is an instrumental. The song is medium tempo with various marching band drums playing in sync. The song is highly energetic and spirited. The song is bad in audio quality. The song is a college marching band playing enthusiastically. | 2009-04-12T21:32:52Z | oferighe | Drumline Soundtrack | ["Music", "Roll"] | ["poor audio quality", "medium tempo", "instrumental music", "groovy rhythm", "various percussion instruments", "steady drum rhythm", "various percussion hits", "snares", "drums", "drum sticks", "dance rhythm", "samba", "cheerleaders", "college band", "marching band", "enthusiastic", "passionate", "energetic", "high on adrenaline"] | 1 | 0pewITE1550 | 211 | |
Hungarian music from the 17th century | The low quality recording features a traditional song that consists of a distant woodwinds melody playing over wooden low percussion and strummed strings melody. It sounds soulful and passionate. | 2009-04-12T19:15:56Z | Arany Zoltán | #hungary #music #aranyzoltan https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ | ["Folk music", "Music"] | ["low quality", "traditional", "distant woodwinds melody", "wooden low percussions", "strummed strings melody", "soulful", "passionate"] | 4 | I2yA-F-_A2E | 1867 | |
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 |
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;