musiccaps_details (view)
2 rows where "youtube_published" is on date 2008-12-20 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic drums 2
- bass guitar 2
- electric guitar 2
- amateur recording 1
- danceable 1
- disco 1
- easygoing 1
- fans shouting 1
- funk 1
- groovy 1
- keyboard 1
- live performance 1
- male vocal 1
- melodic singing 1
- rock music 1
- screams 1
musiccaps_names (array) 4 ✖
- Music 2
- Inside, public space 1
- Soul music 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Michael Jackson - Off The Wall - Girlfriend | This is a funk/disco music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the keyboard with the backing of the electric guitar and the bass guitar. The rhythm is being played by the acoustic drums. The atmosphere is groovy. This piece could be played at a retro-themed party at a dance club. | 2008-12-20T19:44:15Z | Sccuderia | Sorry for the HUGE delay but youtube wouldn't let me log in...anyway...Enjoy! Lyrics: [1st Verse] Girlfriend I'm Gonna Tell Your Boyfriend (Yeah) Tell Him (Woo Hoo) Exactly What We're Doin' (Yeah) Tell Him What You Do To Me Late At Night When The Wind Is Free [2nd Verse] Girlfriend I'm Gonna Show Your Boyfriend (Yeah) Show Him (Woo Hoo) The Letters I've Been Savin' (Yeah) Show Him How You Feel Inside An' How Love Could Not Be Denied (Oh No) [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do, [Etc.] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine [3rd Verse] Girlfriend You Better Tell Your Boyfriend (Yeah) Tell Him (Woo Hoo) Exactly What We're Doin' (Yeah) Tell Him What He Needs To Know Or He May Never Let You Go [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do, [Etc.] [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do.. [Ad-Lib To Fade] | ["Music", "Soul music"] | ["funk", "disco", "male vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "easygoing", "danceable"] | 9 | l6LUPlmua6I | 4375 | |
Crazy Fan at Miranda Lambert's Concert | This is an amateur recording of a rock music concert. There is an electric guitar playing the main tune while another electric guitar is starting to play a solo. A bass guitar can be heard in the background playing the root notes of the tune. There is a loud acoustic drum beat in the rhythmic background. The recording is a bit outdated so the quality is pretty low. | 2008-12-20T21:42:01Z | soonerbme | Watch the clip at the end. A crazy fan makes her mad & she leaves the stage. We missed the last song, but it was a great concert anyway! | ["Music", "Whoop", "Inside, public space"] | ["amateur recording", "live performance", "rock music", "electric guitar", "bass guitar", "acoustic drums", "fans shouting", "screams"] | 9 | 7PtHb9jQCtg | 844 |
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;