A word or phrase in titles, by year

Session and paper titles that contain the term, per year, with the share of that year's titles. Case-insensitive substring match.

Custom SQL query returning 26 rows (hide) 

with t as (
  select year, title as t from sessions where title is not null
  union all
  select year, paper_title from appearances where paper_title is not null
)
select year, count(*) as titles,
       sum(instr(lower(t), lower(:term)) > 0) as with_term,
       round(100.0 * sum(instr(lower(t), lower(:term)) > 0) / count(*), 2) as percent
from t group by year order by year

Query parameters

Edit SQL

This data as json, CSV

yeartitleswith_termpercent
1998 2029 2029 100.0
1999 1740 1740 100.0
2004 2275 2275 100.0
2005 2177 2177 100.0
2006 2347 2347 100.0
2007 2393 2393 100.0
2008 2229 2229 100.0
2009 2340 2340 100.0
2010 2513 2513 100.0
2011 2156 2156 100.0
2012 2024 2024 100.0
2013 2030 2030 100.0
2014 2131 2131 100.0
2015 2028 2028 100.0
2016 1903 1903 100.0
2017 2403 2403 100.0
2018 1976 1976 100.0
2019 1604 1604 100.0
2020 1916 1916 100.0
2021 795 795 100.0
2022 1162 1162 100.0
2023 1423 1423 100.0
2024 1653 1653 100.0
2025 979 979 100.0
2026 761 761 100.0
2027 829 829 100.0