musiccaps_details (view)
3 rows where search matches "guitar" and "youtube_published" is on date 2009-10-25 sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- 2000s rock 1
- acoustic drums 1
- acoustic guitar riff 1
- alternative 1
- boomy bass line 1
- club music 1
- complex arrangement 1
- contemporary hip-hop 1
- dance groover 1
- dance music 1
- dance pop 1
- digital drums 1
- dj 1
- drum machine 1
- e-bass 1
- e-guitars 1
- eastern scale 1
- electric bass 1
- emotional 1
- enthusiastic vocal backup 1
- female background harmonies 1
- female lead vocalist 1
- fiery 1
- finger cymbals 1
- flute 1
- full band melodies 1
- groovy 1
- hip-hop 1
- male vocalist 1
- medium tempo 1
- …
musiccaps_names (array) 6 ✖
- Music 3
- /t/dd00032 1
- Grunge 1
- Hip hop 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 |
---|---|---|---|---|---|---|---|---|---|---|
Francis Magalona - Kaleidoscope World | Someone is playing an acoustic drum groove with a slightly open hi hat while an e-guitar is strumming chords along with an e-bass playing the root note walking up the fretboard. Another e-guitar is playing the lead melody. A male voice is singing a short phrase. This song may be playing at home sitting in your room and enjoying music and memories. | 2009-10-25T19:29:37Z | FrancisMagalonaVEVO | Music video by Francis Magalona performing Kaleidoscope World. (C) 2000 BMG Records Pilipinas Inc. | ["Music", "Grunge"] | ["2000s rock", "e-guitars", "e-bass", "acoustic drums", "slow tempo", "melancholic and light"] | 6 | ClNTn1wtq7E | 1400 | |
Anna Vissi - Travma | Full band playing a complex arrangement, possibly south asian or middle eastern. The music features odd meters and polyrhythmic full band melodies played by electric bass guitar, synthesizer, flute, and a female vocalist singing an eastern scale with female background harmonies. The drum ensemble is thunderous and fiery with percussion from finger cymbals and tambourine. | 2009-10-25T08:23:26Z | AnnaVissiVEVO | Music video by Anna Vissi performing Travma. (C) 1997 Sony Music Entertainment (Greece) A.E. | ["Music", "/t/dd00032"] | ["south asian", "middle eastern", "eastern scale", "fiery", "finger cymbals", "odd meter", "electric bass", "polyrhythms", "complex arrangement", "full band melodies", "tambourine", "thunderous drums", "synthesizer", "female lead vocalist", "female background harmonies", "flute"] | 8 | L9j9fCHHPeg | 2155 | |
I'm N Luv (Wit A Stripper) 2 -Tha Remix (Official HD Video) | A male vocalist sings this catchy Hip-Hop. The tempo is medium with an acoustic guitar riff, boomy bass drops, punchy drumming, digital beats and synthesiser arrangement with enthusiastic vocal backup. The song is youthful, buoyant, punchy, groovy, pulsating with a dance groove. This song is Contemporary Hip-Hop. | 2009-10-25T19:59:01Z | TPainVEVO | "I’m In Luv With A Stripper" by T-Pain (Remix) Listen to T-Pain: https://tpain.lnk.to/listenYD Watch more T-Pain videos: https://tpain.lnk.to/listenYD/youtube Subscribe to the official T-Pain YouTube channel: https://tpain.lnk.to/subscribeYD Follow T-Pain: Facebook: https://tpain.lnk.to/followFI Instagram: https://tpain.lnk.to/followII Twitter: https://tpain.lnk.to/followTI Website: https://tpain.lnk.to/followWI Spotify: https://tpain.lnk.to/followSI YouTube: https://tpain.lnk.to/subscribeYD Lyrics: She poppin, she rollin, she rollin She climbin that pole and I'm in love with a stripper She trippin, she playin, she playin I'm not goin nowhere girl, I'm stayin, I'm in love with a stripper She poppin, she rollin, she rollin She climbin that pole and I'm in love with a stripper She trippin, she playin, she playin I'm not goin nowhere girl, I'm stayin, I'm in love with a stripper #TPain #ImInLuvWithAStripper #OfficialHDVideo #HD | ["Singing", "Music", "Rhythm and blues", "Hip hop music"] | ["male vocalist", "medium tempo", "emotional", "passioante", "rhythmic patter", "groovy", "dance pop", "dance groover", "dj", "club music", "dance music", "enthusiastic vocal backup", "digital drums", "punchy drums", "drum machine", "boomy bass line", "acoustic guitar riff", "synthesiser arrangement", "hip-hop", "rap", "contemporary hip-hop", "alternative"] | 7 | vqRFzhWik2c | 5210 |
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;