musiccaps_details (view)
1 row where musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "trumpets playing harmony" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Dede Bayi Asik Berenang di Kolam Renang Hotel Nirwana Garden Resort Lifia Niala Elsa | The song is an instrumental with a baby making noises while paddling in a pool. The song is medium tempo with steady drumming, latin percussion, guitar accompaniment, trumpets playing in harmony and keyboard accompaniment. The song is a soundtrack for a home video and the audio quality is bad due to varying noise levels. | 2016-01-31T09:30:00Z | Lifia Niala | Lifia Niala Elsa Liburan Sekolah Berenang kolam renang Hotel Nirwana Garden Resort - Nirwana Resort Bintan Lagoi Kepri. Kawasan Lagoi dikenal oleh banyak orang sebagai kawasan eksklusif dengan resort-resort mewah yang menawarkan private beachnya. Dulu bahkan sebelum Lagoi Bay (public beach yang ada di Lagoi) ini dibuka untuk umum, pengunjung yang bisa masuk ke dalam kawasan Lagoi ini hanya tamu resort saja. Tapi sekarang, siapa pun bisa masuk ke dalam kawasan ini. Dan, kita tetap bisa berhemat lho kalo mau liburan ke sini. Cari tau di google, gimana caranya berlibur murah dan hemat ke Lagoi, Bintan – Kepulauan Riau. 🙂 Transportasi Untuk sampai ke Lagoi, memang sebaiknya disarankan untuk menyewa mobil. Kami sekeluarga saat itu memutuskan untuk rental mobil di Tanjung Uban. Biaya rentalnya Rp400.000 per hari untuk mobil Avanza, lepas kunci dan di luar bensin. Di cerita kali ini kami ke Lagoi naik kapal Feri dari Batam ke Tanjung Pinang lalu dari Tanjung Pinang menuju ke arah Lagoi menggunakan Mobil/Taxi. Biayanya Rp20.000 per orang dengan waktu tempuh kurang lebih 1 jam. Jika mau lebih cepat, bisa naik speedboat dengan biaya Rp50.000 per orang dengan waktu tempuh kurang lebih 20 menit. Warning: This game / toys is safe and under supervision of the parents! ✓ Jangan lupa Subscribe, Like, Comment dan Share ya teman-teman. Biar LifiaNiala tambah semangat buat video baru lagi di Youtube : 👍Like, Comment and Share Ya 👍 Don't forget to subscribe. FREE... ✓ Subsribe ▶︎ https://goo.gl/XVJq33 💕Please follow us on : Instagram : @ lifiatubehd Facebook : @ Lifia Niala Facebook Fan Page : @ LifiaTubeHD ✓ Most Popular Upload https://goo.gl/oX1Ptx ✓ Channel Page Link https://goo.gl/WdyhiH ✓ Es Krim Paddle Pop Octopus Rasa Strawberry Rasa Anggur Saus Coklat https://goo.gl/Z7fiuM ✓ Daftar 5 Nama Anak Kitty - Anak Kucing Kesayangan Lifia Niala Elsa disini ya : https://goo.gl/zP56nn ✓ Kisah Lifia Niala selamatkan Anak Kucing Malang bernama Kitty - https://goo.gl/ZEjWfL Warning: This game / toys is safe and under superv… | ["Music", "Splash, splatter"] | ["baby noises", "instrumental music", "fun", "frolic", "baby home video", "medium tempo", "latin music", "party time", "amateur production", "water splashing sounds", "volume changes", "latin dance music", "memdium tempo", "ambient swimming pool sounds", "baby cooing", "steady drumming", "trumpets playing harmony", "guitar accompaniment", "groovy bass line", "home video soundtrack"] | 1 | 4--05CAaDsg | 528 |
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;