musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2014-04-12
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 |
---|---|---|---|---|---|---|---|---|---|---|
Pachelbel in the Garden (relaxing music, sounds of nature) | The low quality recording features a wide sustained strings melody and natural sound effects in the background that consist of reverberant birds chirping and water flowing sound effects. It sounds calming, relaxing and emotional. | 2014-04-12T05:02:26Z | Andrea Johnson | Dan Gibson's Solitudes: Pachelbel in the Garden. Solitudes (2003). A New Age interpretation of Pachelbel's Canon accompanied by the sounds of nature. Michael Francis (guitar); Sharlene Wallace (harp); Marie Berard, Carol Fujino (violin); Douglas Perry (viola); Bryan Epperson, Simon Fryer (cello); Leslie Allt (flute); Lesley Young (oboe, English horn); Michael Maxwell (piano, midi keyboard). Track list below. Enjoy the music! [00:00] Serenade [08:15] Pastoral [16:13] Pavan [24:13] Serenity [31:47] Elegy [39:14] Songbirds | ["Music", "Sad music"] | ["low quality", "reverberant birds chirping sound effects", "water flowing sound effect", "wide sustained strings melody", "nature", "emotional", "calming", "relaxing"] | 4 | UzDVZzIIcy8 | 2965 | |
Chaba sousou Duo Faycal Lmignon - Khalouhe rahe mjarjarni (Jdida Live 2014) by Lamia Malahi | The low quality recording features an Eastern pop song that contains echoing autotune male vocal singing over wooden percussion and shimmering shakers. It sounds distorted, crushed, harsh and messy, as it was probably recorded with a poor quality microphone. | 2014-04-12T22:48:05Z | Lamia Malahi | ["Music", "Rattle (instrument)"] | ["eastern pop", "low quality", "shimmering shakers", "wooden percussions", "echoing autotune male vocal", "harsh", "groovy", "distorted", "crushed", "messy"] | 4 | nEOPm7TeydY | 4526 |
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;