musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-04-05 sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- arabian nights 1
- arabic music 1
- arabic percussions 1
- asanas 1
- backup singer 1
- bell harmony 1
- crushed 1
- desert sands 1
- distorted 1
- emotional connection 1
- en wage hits 1
- energetic muffled instrumental 1
- explore nature 1
- female singer 1
- folk instrumental music 1
- folk music 1
- gets adventure 1
- healing 1
- hissing noise 1
- historical 1
- instrumental music 1
- keyboard accompaniment 1
- life’s meanings 1
- live performance 1
- loud 1
- low quality 1
- meditational 1
- medium tempo 1
- memdium tempo 1
- metal 1
- mono 1
- new age 1
- new age hits 1
- no percussions 1
- poignant 1
- poor audio quality 1
- prayerful 1
- relaxing playlist 1
- retro new age hits 1
- screaming male vocal 1
- sensory experiences 1
- slow tempo 1
- string synth pad harmony 1
- stringed instruments 1
- strong bass line 1
- subtle percussion rhythm 1
- traditional muscle 1
- traditional music 1
- vocal chanting 1
- vocal harmony 1
- workout playlist 1
- yoga 1
musiccaps_names (array) 8 ✖
- Music 3
- Acoustic guitar 1
- Cacophony 1
- Guitar 1
- Mandolin 1
- New-age music 1
- Plucked string instrument 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
New Age Music | Va - Celtic Dreams (High Definition Available) | A female singer sings this chanting vocals with backup singers in vocal harmony. The song is medium tempo with bell harmony, keyboard accompaniment, steady rhythm and a string pad harmony. The song is healing and a new age in nature. | 2009-04-05T15:09:10Z | MelancholicDestiny | New Age Music | ["New-age music", "Music"] | ["new age", "female singer", "backup singer", "new age hits", "workout playlist", "medium tempo", "emotional connection", "explore nature", "life’s meanings", "relaxing playlist", "vocal harmony", "bell harmony", "keyboard accompaniment", "string synth pad harmony", "en wage hits", "meditational", "prayerful", "healing", "sensory experiences", "memdium tempo", "retro new age hits", "yoga", "asanas", "vocal chanting", "medium tempo"] | 1 | L_KkjB0Wt_Q | 2198 | |
portrait pinting withe water colors A sheiko | The song is an instrumental. The song is a slow tempo with a stringed instrument playing a poignant melody, a strong bass line and a subtle percussive rhythm. The song is rich in tradition and poignant. The song has poor audio quality with hissing disturbances. | 2009-04-05T11:05:58Z | dilba m | slid show | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Strum", "Plucked string instrument"] | ["instrumental music", "slow tempo", "arabic music", "poor audio quality", "hissing noise", "folk music", "folk instrumental music", "arabic percussions", "stringed instruments", "traditional muscle", "subtle percussion rhythm", "poignant", "desert sands", "arabian nights", "gets adventure", "historical", "traditional music", "strong bass line", "no percussions"] | 1 | VeAomElRCJc | 3016 | |
dsce rock band cacophony at "furore 09" | The low quality recording features a live performance of a metal song and it consists of screaming male vocal singing over energetic, muffled instrumental. The recording is crushed, loud, distorted and mono - everything that the metal live performance should be. | 2009-04-05T07:09:35Z | Puneet J | the very own band of dayananda sagar colg....!! awesome show by them at furore 2009..!! | ["Music", "Cacophony"] | ["low quality", "metal", "live performance", "screaming male vocal", "energetic muffled instrumental", "mono", "loud", "crushed", "distorted"] | 4 | IT5hcf0KhYE | 1908 |
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;