musiccaps_details (view)
3 rows where "youtube_published" is on date 2008-08-12 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- 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
- epic 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
- live performance 1
- loud brass section melody 1
- low quality 1
- mandolin 1
- medium tempo 1
- mellow woodwinds melody 1
- mono 1
- muffled 1
- muffled percussion 1
- noisy 1
- normal voice to falsetto 1
- orchestra 1
- passionate 1
- people clapping 1
- powerful 1
- rapid change in pitch 1
- rapid singing 1
- resonator 1
- reverberant 1
- rich 1
- rock and roll 1
- spirited 1
- spirited drumming 1
- suspenseful violin melody 1
- vigorous banjo accompaniment 1
- vocalisation 1
musiccaps_names (array) 9 ✖
- Bowed string instrument 1
- Double bass 1
- Music 1
- Orchestra 1
- Pizzicato 1
- Singing 1
- Song 1
- String section 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 | |
Ennio Morricone Vienna 12.12.2007 (part 4) | The low quality recording features a live performance of an orchestra and it consists of loud brass melody, mellow woodwinds melody, suspenseful violin melody and muffled percussion. It sounds epic, powerful and passionate. The recording is in mono, a bit noisy and it is reverberant as it was performed in a large concert hall. | 2008-08-12T15:10:07Z | Tomáš Vlček | Ennio Morricone conducts his own music at Vienna Stadthalle - Ecstasy of gold (reprise). | ["String section", "Orchestra"] | ["low quality", "live performance", "noisy", "mono", "reverberant", "orchestra", "muffled", "epic", "powerful", "passionate", "suspenseful violin melody", "muffled percussion", "loud brass section melody", "mellow woodwinds melody"] | 4 | cJ80eZY03Yg | 3697 | |
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;