musiccaps_details (view)
1 row where musiccaps_aspects contains "calming", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "sentimental"
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 |
---|---|---|---|---|---|---|---|---|---|---|
sea going motorboat bateauxdumidi@gmail.com | This music is an instrumental with a melancholic piano melody, mesmerising sound of chimes, simple keyboard harmony and a burgeoning cello note. The music is calming, meditative, nostalgic, emotional, sentimental, mellow, soothing and ambient. | 2010-02-22T15:55:55Z | bateauxdumidi | Formidable navire Mer - Riviere pour faire le boucle danube et retour par la mediterranee Spacieux bateau grace a sa largeur de 4 metre un fond en 6 mm cote 5/4 mm Large plabord et bastingage en inox Base sur les linge des bateaux de peche du mer de nord Description; a l'avant grand lit double a la francaise beaucoup de rangement . Salle de bain avec douche lave main et wc marine. Grande cuisine avec frigo neuf "compresseur 24 volt " dinette avec table et rangement , tres gande salon timonnerie , chauffage central avec radiateur. salle de bain avec douche et wc marine electrique enorme cocpit- plage de au moins 4 x 4 m avec en acces au cave/debarasse equipement tres complet avec radar auto pilot sondeur gps | ["New-age music", "Music", "Soul music"] | ["instrumental", "piano harmony", "cheerful chimes", "burgeoning note", "keyboard accompaniment", "soft", "calming", "meditative", "cello", "ambient", "sentimental", "nostalgic", "emotional", "mellow"] | 7 | ndjLkbP6Y9Y | 4566 |
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;