musiccaps_details (view)
3 rows where "youtube_published" is on date 2015-04-07 sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- acoustic guitar tuning 1
- bells 1
- birds chirping 1
- chill 1
- danceable 1
- deep house 1
- disco pop 1
- electronic dance music 1
- enthusiastic drumming 1
- female vocal sample 1
- female vocalist 1
- hopeful 1
- keyboard 1
- low quality 1
- male vocal sample 1
- medium tempo 1
- mellow 1
- melodic acoustic guitar 1
- mono 1
- multi genre soundscape 1
- noisy 1
- pleasant 1
- pop 1
- pop rap 1
- reggae 1
- soft 1
- soothing 1
- sound effects electronic drums 1
- steel pan 1
- synthesiser arrangements 1
- tutorial 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Guitar Tuner Basic: การตั้งสายกีต้าร์ แบบใช้โปรแกรม | The low quality recording features an acoustic guitar tuning tutorial. The recording is in mono and very noisy. | 2015-04-07T16:14:50Z | ซื้อแว่นแฟชั่น ร้าน Cheappyshop | ทดสอบการตั้งสายกีต้าร์ โดยใช้โปรแกรม DaTuner และ การตั้งสายกีต้าร์ แบบง่ายๆ ด้วยตัวเอง. | ["Guitar", "Music", "Electronic tuner"] | ["low quality", "noisy", "acoustic guitar tuning", "tutorial", "mono"] | 4 | M27mIdPCZEY | 2237 | |
Marla Brown - Better Days [Official Video 2015] | A female vocalist sings this pleasant pop song. The tempo is medium with a keyboard harmony, melodious acoustic guitar harmony, bright drumming , steel pan and the sound of birds chirping. The song is mellow, soft, pleasant, soothing, hopeful, sentimental, sweet and cheerful.this song is a Reggae Pop. | 2015-04-07T15:16:07Z | Reggaeville | ⏩ SUBSCRIBE http://bit.ly/yt-reggaeville 🔔 GET NOTIFIED about new videos! ✅ Log on https://www.REGGAEVILLE.com 🅵🅱 https://www.fb.com/reggaeville 🅸🅶 https://www.instagram.com/reggaeville 🆃🆃 https://www.tiktok.com/@reggaeville Marla Brown - Better Days [Royal Order Music] SINGLE OUT April 14th 2015 BUY @ https://itunes.apple.com/album/better-days-single/id978513329 Produced by: Royal Order Music and Green Stone Music Video Director and Editor: Dennis Brown/Visually Sound Media Production © #MarlaBrown #Reggaeville #Reggae | ["Bird vocalization, bird call, bird song", "Music", "Reggae", "Chirp, tweet", "Outside, rural or natural"] | ["female vocalist", "medium tempo", "birds chirping", "melodic acoustic guitar", "steel pan", "enthusiastic drumming", "synthesiser arrangements", "soft", "mellow", "pleasant", "hopeful", "pop", "pop rap", "disco pop", "reggae", "multi genre soundscape", "soothing"] | 7 | ZPK1hSPI540 | 3374 | |
Freeline Skates are Strangely Awesome | This is a deep house piece. There is a repeating female vocal sample playing while the keyboard and bells are carrying the melody playing the same two chords repeatedly. There is also a nice sound effect. The electronic drum beat is in a crescendo movement creating a hyped-up atmosphere. A male vocal uttering a few words can be heard later on. The piece has a danceable but chill aura to it. It could be used at house parties, dance clubs and tourism advertisements. | 2015-04-07T19:56:18Z | Kuma Films | If rollerblades and ripsticks had a baby, this is what they would look like. These crazy inline skates are like mini skateboards for each foot! Snag Some Freeline Skates Here!: http://amzn.to/1ThrUCG We spent a day with Light and 曾昱暠 cruising the streets of Taipei on their freeline skates. These guys kill it on a longboard as well. Subscribe! http://bit.ly/1tLVDYk Click to Facebook: http://on.fb.me/1E1aCnt http://www.KumaFilms.com Behind the Scenes: http://bit.ly/1FOaeYB Like us on Facebook! https://www.facebook.com/KumaFilms Follow us on Instagram! http://instagram.com/KumaFilms @KumaFilms Follow us on Twitter! https://twitter.com/kumakumafilms @kumakumafilms Follow us on Soundcloud! https://soundcloud.com/kuma-films Contact us at kumakumafilms@live.com Featuring: Light Liu & 曾昱暠 Facebook: https://www.facebook.com/sk7777777 Facebook: http://on.fb.me/1C7Nj6E Music: Arman Cekin - Smooth Waves FREE Download: https://soundcloud.com/mrsuicidesheep... Soundcloud: https://soundcloud.com/armancekin Facebook: https://www.facebook.com/arman.cekin Twitter: https://twitter.com/CekinArman Instagram: https://instagram.com/armancekin/ | ["Music", "Skateboard"] | ["electronic dance music", "deep house", "female vocal sample", "keyboard", "bells", "sound effects electronic drums", "male vocal sample", "danceable", "chill"] | 9 | BlhUt8AJJO8 | 1289 |
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;