musiccaps_details (view)

2 rows where "youtube_published" is on date 2010-06-29

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Θα κάνω φασαρία-Γιαννούλης Βαζαίος A male vocalist sings this animated song in a foreign language. The tempo is fast with a bright applied violin accompaniment, lively drumming, groovy bass line, tambourine beats, rhythmic mandolin and acoustic guitar accompany net. The song is lively, energetic, vibrant, happy, vivacious and merry with a dance groove. This song is a Folk Pop/Regional Pop. 2010-06-29T13:03:59Z mike gr από το cd ''να μαστε πάλι[πιτσιρίκα]'' ["Jingle (music)", "Music"] ["male singer", "fast tempo", "regional pop", "folk pop", "emphatic vocals", "foreign language", "bright violin", "energetic", "animated percussions", "lively mandolin", "acoustic guitar", "groovy bass line", "folk song", "folk music", "world music", "pop", "pop hits", "youthful", "dance music", "celebration", "merry", "happy"] 7 40D4L5Ndi6k 529
AIREDALE PUPPY AT 12 WEEKS This is a live recording to which music was later added. The main audio in the clip includes a squeaky toy being repeatedly pressed. The song that was later added is a slow ballad that includes piano and violin. 2010-06-29T00:01:44Z heiliner What YOU can expect a 12 week Airedale to do. Enjoy because things will get much wilder in the weeks to follow...hang on...an adolescent Airedale will give their owner quite a ride. ["Music", "Squeak", "Inside, small room"] ["squeaky toy sound", "live recording outside", "background music", "piano", "violin", "simple drumming", "positive and happy music", "slow tempo"] 3 efTVnvwI2PQ 3890

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;