musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "loud" and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 3 ✖
- loud · 3 ✖
- acoustic drums 1
- bass guitar 1
- bright 1
- child-like vocal 1
- crowd sounds 1
- dance 1
- dance music 1
- distorted guitar 1
- electric guitar 1
- electronic drums 1
- enthusiastic 1
- fast tempo 1
- female voice 1
- groovy bass line 1
- guitar solo 1
- inferior audio quality 1
- intense electric guitar 1
- jarring 1
- keyboard harmony 1
- live performance 1
- male vocalist 1
- people cheering 1
- people talking 1
- pop 1
- pop music 1
- pop rock 1
- punchy drumming 1
- rebellious 1
- …
musiccaps_names (array) 8 ✖
- Inside, large room or hall · 3 ✖
- Music 3
- Singing 2
- Cacophony 1
- Musical instrument 1
- Rock music 1
- Roll 1
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
Front Row for Britney Spears performing BIG FAT BASS on Jimmy Kimmel LIVE! HD | This is the live recording of a pop music piece. The track is being performed with playback. There is a female vocal with child-like characteristics. There is a strong electronic drum beat in the rhythmic background. A fuzzy synth bass is playing the melodic part. There are lots of beat repeat effects. The atmosphere is loud and energetic. There are sounds that can be heard coming from the crowd cheering. | 2011-03-31T06:43:19Z | Rene Carta | Steadiest hand yet, you won't get dizzy watching it! =D | ["Singing", "Music", "Synthetic singing", "Inside, large room or hall"] | ["pop music", "live performance", "female voice", "child-like vocal", "electronic drums", "synthesizer", "strong bass", "loud", "energetic", "dance", "crowd sounds"] | 9 | TTytcT_1dmY | 2838 | |
Chatmonchy - Donaru Denwa Doshaburi LIVE | This is a rock music piece consisting of three instruments. There is a distorted electric lead guitar playing a solo that is increasing from medium to high pitch. The bass guitar is providing tune in the background. There is a loud acoustic drum beat that includes a lot of fills. The song has a vigorous, high energy feel to it. This piece could be played at rock bars. | 2011-01-13T22:04:55Z | modus | I do not claim ownership of "Chatmonchy" or there music. reuploaded after fixing audio sync issue. | ["Music", "Cacophony", "Inside, large room or hall"] | ["rock music", "electric guitar", "guitar solo", "distorted guitar", "bass guitar", "acoustic drums", "loud", "energetic", "rebellious"] | 9 | a4jcJ7QZ-OQ | 3515 |
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;