musiccaps_details (view)
4 rows where "youtube_published" is on date 2010-09-19 sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- acoustic rhythm guitar 2
- fast tempo 2
- low quality 2
- alternative rock 1
- catchy rhythm 1
- clapper 1
- clapping 1
- country pop 1
- crowd clapping 1
- dance groove 1
- dance music 1
- distorted 1
- edm 1
- electronic music 1
- emotional 1
- energetic 1
- enthusiastic 1
- flat female vocal 1
- folk rock 1
- groovy bass guitar 1
- harmonizing vocals 1
- incoherent lyrics 1
- indie pop 1
- indie rock 1
- instrumental 1
- keyboard harmony 1
- live performance 1
- lively 1
- lively acoustic guitar 1
- male vocalist 1
- messy 1
- muddy 1
- muffled audio 1
- muted audio 1
- passionate 1
- pop 1
- punchy beats 1
- punchy drumming 1
- recurring vocal riff 1
- reverberant 1
- rock 1
- shimmering hi hats 1
- sloppy 1
- snappy rimshots 1
- spirited 1
- steady bass line 1
- string instruments 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 4
- /t/dd00003 1
- Disco 1
- Jingle (music) 1
- Rhythm and blues 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ameen doing the shuffle | This song is a loud, energetic electronic instrumental. The audio quality is substandard making it hard to hear the song. One can tell that the song is vibrant , vivacious, bright, youthful and buoyant from the beat of punchy drumming and rapid incoherent vocals. Thesong sounds like EDM. | 2010-09-19T19:49:32Z | MeganJDBx | hayleys little brother doing the shuffle | ["Disco", "Music"] | ["instrumental", "fast tempo", "muffled audio", "edm", "electronic music", "dance music", "dance groove", "youthful", "punchy beats", "recurring vocal riff", "energetic", "enthusiastic", "electronic music", "muted audio", "incoherent lyrics"] | 7 | 8zDbEfC6Uf0 | 965 | |
Tracy Chapman and Bruce Springsteen - My Hometown (Live 2004) | The low quality recording features a live performance of a folk rock song that consists of harmonizing vocals singing over shimmering hi hats, snappy rimshots, groovy bass guitar and acoustic rhythm guitar, followed by some crowd claps. It sounds messy, muddy and distorted, but still emotional and passionate too. | 2010-09-19T11:10:04Z | Tracy Chapman Online | ♥ Subscribe our newsletter ► https://www.about-tracy-chapman.net/newsletter/ ♥ ♥ Subscribe Tracy Chapman Youtube Channel ► http://www.youtube.com/tchapmanfan ♥ See also ► Fan website : http://www.about-tracy-chapman.net/ ► Facebook: https://www.facebook.com/tracychapmanonline ► Instagram https://instagram.com/tracychapmanonline ► Twitter: https://twitter.com/tchapmanonline Order Tracy Chapman’s "Greatest Hits" on iTunes http://apple.co/1RtSdDu | Amazon: http://hyperurl.co/TC-GH Tracy Chapman and Bruce Springsteen perform "My hometown" in 2004. Low Quality rare video. | ["Singing", "Music", "/t/dd00003"] | ["low quality", "live performance", "folk rock", "distorted", "shimmering hi hats", "harmonizing vocals", "groovy bass guitar", "acoustic rhythm guitar", "snappy rimshots", "crowd clapping", "messy", "muddy", "emotional", "passionate"] | 4 | aPQTrv2B1sw | 3536 | |
Wedding Reception - Brides Surprise Music Video for Groom | The low quality recording features an acoustic rhythm guitar and flat female vocal singing on top of it. There is a lot of reverb on vocals, which makes it sound too separate from the guitar. The guitar, in the second half of the loop, is played a bit sloppy. | 2010-09-19T01:08:14Z | FoxiRandomPanda | Wedding Reception - Bride's surprise music video for groom "I wanna grow old with you" made famous by Adam Sandler. (I took a couple of singing lessons so hopefully it's not cringe worthy. The video is supposed to be sweet and funny. I wanted to do something unique and extra special for my husband to be. Hope you all enjoy.) | ["Jingle (music)", "Music"] | ["low quality", "acoustic rhythm guitar", "flat female vocal", "reverberant", "sloppy"] | 4 | hrOP9swUpyA | 4147 | |
The Cast of Degrassi the Boiling Point | A male vocalist sings this catchy pop song. The tempo is medium fast with funky drumming, spirited acoustic guitar accompaniment, rhythmic clapping, steady bass line and keyboard harmony. The song is melodic, perky, peppy, youthful, playful, enthusiastic and fun. This is Indie Pop/Indie Rock. | 2010-09-19T02:51:39Z | katilovessapphire | some r missing! i kno that but i did the best i could! not many picture of the ones i'm missing | ["Music", "Rhythm and blues"] | ["male vocalist", "fast tempo", "country pop", "keyboard harmony", "clapper", "steady bass line", "string instruments", "clapping", "punchy drumming", "lively acoustic guitar", "catchy rhythm", "lively", "spirited", "pop", "rock", "alternative rock", "indie pop", "indie rock"] | 7 | rLQ93N6RJC0 | 4868 |
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;