musiccaps_details (view)
2 rows where musiccaps_author = 7 and "youtube_published" is on date 2008-08-12
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- ambient nature sounds 1
- blues 1
- breeze 1
- cheering 1
- classic acoustic string instrument 1
- dense 1
- dobro 1
- double elcetric bass 1
- energetic 1
- energetic vocals 1
- enthusiastic 1
- falsetto 1
- fast tempo 1
- female vocalist 1
- fiddle 1
- full bodied 1
- high notes 1
- instrumental 1
- intense 1
- intense bass 1
- jazz 1
- mandolin 1
- medium tempo 1
- normal voice to falsetto 1
- people clapping 1
- rapid change in pitch 1
- rapid singing 1
- resonator 1
- rich 1
- rock and roll 1
- spirited 1
- spirited drumming 1
- vigorous banjo accompaniment 1
- vocalisation 1
musiccaps_names (array) 7 ✖
- Bowed string instrument 1
- Double bass 1
- Music 1
- Pizzicato 1
- Singing 1
- Song 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lydia 5 yrs.old wins the Taylor Ware Yodel On Contest!! | A female vocalist sings this rather vigorous country song. The tempo is fast with vocalisation. The vocalist is yodelling vigorously and rhythmically to the accompaniment of an animated banjo, fiddle, resonator and mandolin harmony, vibrant drumming and. | 2008-08-12T02:50:34Z | Epps Music | Lydia yodeling Cowboy Sweetheart at Taylor Ware's Yodel On Contest in Tenn. | ["Singing", "Yodeling", "Music", "Song"] | ["female vocalist", "fast tempo", "falsetto", "high notes", "resonator", "people clapping", "cheering", "breeze", "ambient nature sounds", "energetic vocals", "spirited drumming", "vigorous banjo accompaniment", "mandolin", "fiddle", "dobro", "rapid singing", "energetic", "vocalisation", "spirited", "enthusiastic", "normal voice to falsetto", "rapid change in pitch"] | 7 | GuQFhmGqdog | 1760 | |
A First Look At The Stagg Electric Upright Bass | This music is instrumental. The tempo is medium with an intense electric upright double bass harmony. The music is dense, deep, powerful, full bodied and vibrant. | 2008-08-12T11:27:12Z | roger alcantara | The Stagg Electric Upright Bass | ["Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "medium tempo", "intense bass", "dense", "rich", "double elcetric bass", "classic acoustic string instrument", "jazz", "blues", "rock and roll", "intense", "full bodied"] | 7 | RJViDdqUYyo | 2692 |
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;