musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality" and musiccaps_names contains "Classical music" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 18 ✖
- low quality · 2 ✖
- cover 1
- emotional 1
- energetic 1
- energetic crash cymbals 1
- epic 1
- groovy bass 1
- harmonizing male vocals 1
- noisy 1
- passionate male vocal 1
- phone recording 1
- powerful 1
- punchy kick 1
- punchy snare 1
- rock orchestra 1
- simple acoustic guitar chords 1
- simple strings melody 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Banana Boat Song ukulele cover with chords and lyrics - Harry Belafonte style (hopefully).wmv | The low quality recording features a cover of a song and it consists of passionate male vocals that together with the actual song's vocal, sounds harmonizing. There are simple acoustic guitar chords too. The recording is very noisy as it was probably recorded with a phone, but regardless it sounds emotional. | 2012-07-30T15:21:15Z | raffaport | Some calypso fun from a bygone age ... too piercing, man! | ["Music", "Classical music", "A capella"] | ["low quality", "cover", "harmonizing male vocals", "simple acoustic guitar chords", "emotional", "noisy", "phone recording", "passionate male vocal"] | 4 | BfMKdrK9D8M | 1272 | |
not ashamed - boundless worship band | The Rock Orchestra song features energetic crash cymbals, punchy kick and snare hits, groovy bass, wide electric guitar chords and simple strings melody. It sounds epic, powerful and energetic - like a theme song for an opening track of some anime. | 2008-06-20T12:19:31Z | awaefler | not ashamed got very famous in the first weeks. Now we're starting with youtube. | ["Music", "Opera", "Song", "Classical music"] | ["low quality", "rock orchestra", "energetic crash cymbals", "punchy kick", "punchy snare", "groovy bass", "wide electric guitar melody", "simple strings melody", "energetic", "epic", "powerful"] | 4 | qwGT6wvYdLo | 4834 |
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;