boludo CV

boludo_cv.json

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "height": "container",
  "data": {
    "url": "https://fullfatsearch.fly.dev/youtube.csv?sql=select%0D%0A++v.upload_date%2C%0D%0A++SUM%28%0D%0A++++%28LENGTH%28s.text%29+-+LENGTH%28REPLACE%28s.text%2C+%3Asearch%2C+%27%27%29%29%29+%2F+LENGTH%28%3Asearch%29%0D%0A++%29+AS+boludo%2C%0D%0A++s.video_id%2C%0D%0A++s.video_title%2C%0D%0A++v.video_url%0D%0Afrom%0D%0A++subtitles_with_videos+s%0D%0A++join+videos+v+on+s.video_id+%3D+v.video_id%0D%0Awhere%0D%0A++subtitle_id+in+%28%0D%0A++++select%0D%0A++++++rowid%0D%0A++++from%0D%0A++++++subtitles_fts%0D%0A++++where%0D%0A++++++subtitles_fts+match+%3Asearch%0D%0A++%29%0D%0Agroup+by%0D%0A++s.video_id%2C%0D%0A++s.video_title%2C%0D%0A++v.video_url%0D%0Aorder+by%0D%0A++v.upload_date+asc&search=boludo",
    "format": {
      "type": "csv"
    }
  },
  "mark": {
    "type": "bar",
    "cursor": "pointer",
    "tooltip": {
      "content": "data"
    }
  },
  "encoding": {
    "href": {
      "field": "video_url"
    },
    "x": {
      "field": "video_title",
      "type": "nominal",
      "sort": {
        "field": "upload_date"
      },
      "scale": {
        "type": "linear",
        "zero": true
      }
    },
    "y": {
      "field": "boludo",
      "type": "quantitative",
      "scale": {
        "type": "linear",
        "zero": true
      }
    }
  }
}