musiccaps_details (view)
3 rows where "youtube_published" is on date 2010-01-22 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- male singer 2
- acoustic guitar arpeggios 1
- animated singing 1
- atmospheric sounds 1
- dolphin-like sounds 1
- drums 1
- electronic sounds 1
- emphatic vocals 1
- energetic acoustic guitar 1
- groovy bass line 1
- half time feel 1
- jealous 1
- lively piano accompaniment 1
- love song 1
- medium fast tempo 1
- medium tempo 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony 1
- passionate 1
- piano chords 1
- quiet 1
- rock beat 1
- romantic 1
- sentimenal 1
- sentimental 1
- spirited spanish guitar 1
- story telling 1
- string symphony 1
- strummed string 1
- two chords 1
- vibrant ukelele harmony 1
- whispers 1
musiccaps_names (array) 5 ✖
- Music 3
- Music for children 1
- Singing 1
- Ukulele 1
- Whale vocalization 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra of Great Britain - "Wuthering Heights" | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | 2010-01-22T08:50:38Z | rud1e | The Ukulele Orchestra of Great Britain - "Wuthering Heights" from the DVD 'Anarchy in the Ukulele', available to buy from http://www.ukuleleorchestra.com | ["Singing", "Music", "Ukulele"] | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | 7 | FF0VaBxb27w | 1629 | |
Hachiko video with Tunde Bayewu.Dog at work in Belgium.Good cause. | Medium tempo rock drum beat with a half time feel, using only two chords played by acoustic guitar arpeggios, piano chords and a male singer. The mood is sentimental. | 2010-01-22T15:38:38Z | Hachikosupport | Music by Tunde Bayewu (beautiful song anaesthetic) Ann and her dog from hachiko demonstrate perfectly how they have a good band at home and the dog is happy to do his best. A dog trained by Hachiko helps people to be independent and much more. For more info and if you want to support visit the website www.hachiko.org. You can also add hachiko on facebook and twitter. | ["Music", "Music for children"] | ["medium tempo", "rock beat", "half time feel", "drums", "acoustic guitar arpeggios", "piano chords", "two chords", "male singer", "sentimenal"] | 8 | ev_YCCuGVSs | 3906 | |
Surfing Dolphins Trailer | The excerpt features for most part atmospheric sounds like whispers, a string being strummed, and electronic sounds. Some of the sounds kind of imitate the sounds dolphins make. The atmosphere is somewhat quiet. | 2010-01-22T04:50:32Z | Greg Huglin | See the 20 minute film Surfing Dolphins on DVD at TheSurfNetwork.com! http://www.thesurfnetwork.com/product?ID=ca11131219549be63b90dcd81565154c Learn about this film and other Greg Huglin Films at http://www.GregHuglin.com | ["Whale vocalization", "Music"] | ["electronic sounds", "dolphin-like sounds", "atmospheric sounds", "whispers", "strummed string", "quiet"] | 2 | 2KGnpMYHBGI | 354 |
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;