musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-09-12 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- acoustic drums 2
- acoustic guitars 1
- amateur recording 1
- bass guitar 1
- blues rock 1
- crowd cheering 1
- drum & bass 1
- eerie 1
- electric guitar 1
- electronic dance music 1
- electronic drums 1
- energetic 1
- groovy 1
- hard rock 1
- hollering sample 1
- live performance 1
- male voice singing 1
- mandolin 1
- pop/singer-songwriter 1
- scratching 1
- synth 1
- upbeat 1
- uplifting energy 1
- uptempo 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
posdata te quiero galway girl | Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. | 2009-09-12T14:37:30Z | Adri Terroba | galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY | ["Singing", "Banjo", "Country", "Music"] | ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] | 6 | BhJa0kTUdGY | 1276 | |
Jeff Beck - She's A Woman (Live) (High Quality) | This is the live performance of a blues rock piece. There is an electric guitar playing the melody with a bass guitar playing in the background. The acoustic drums are playing a rock beat. There is a groovy atmosphere to this piece. It could be playing in the background of a rock bar. | 2009-09-12T09:51:27Z | Davebritbrat | Jeff Beck - She's A Woman (Live) from the BBC's 'Sing The Beatles' | ["Reverberation", "Guitar", "Music", "Plucked string instrument"] | ["live performance", "blues rock", "hard rock", "electric guitar", "bass guitar", "acoustic drums", "groovy"] | 9 | TZlFTbvfKPE | 2845 | |
tenminmix 2009 jump up drum and bass | This is a drum & bass music piece. There is a constantly repeating hollering sample accompanied by rapid turntable scratching. A synth sound can be heard playing an ominous tune. The rhythmic background consists of a fast-tempo electronic drum beat. The atmosphere is energetic. This piece could be used in the soundtrack of a car racing game. It could also be playing at nightclubs during early-2000s themed parties. | 2009-09-12T09:36:43Z | morbid1980 | another fresh mini mix from myself....little bit of scratching at the start as well tracklisting tantrum desire - electric brain cabbie - come in cabbie - woke up erb n dub - bass deli j - fight club DP - day off catch my sets on www.reflectfm.net | ["Scratching (performance technique)", "Drum and bass", "Music", "Scratch"] | ["drum & bass", "electronic dance music", "hollering sample", "scratching", "synth", "electronic drums", "upbeat", "energetic", "eerie"] | 9 | -Dtir74TiUM | 28 |
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;