Wikidata - English descriptions starting with "a .."

SQL

%%capture
%set_env http_proxy=http://webproxy.eqiad.wmnet:8080
%set_env https_proxy=https://webproxy.eqiad.wmnet:8080
%set_env no_proxy=localhost,127.0.0.1

import wmfdata
wmfdata.utils.insert_code_toggle()

from wmfdata import hive, mariadb
import pandas as pd
from datetime import datetime, timedelta, date

%matplotlib inline
import matplotlib.pyplot as plt
import matplotlib.ticker as ticker

@ticker.FuncFormatter
def million_formatter(x, pos):
    return "%d M" % round(x/1000000)
@ticker.FuncFormatter
def thousand_formatter(x, pos):
    return "%d K" % round(x/1000)

now = pd.Timestamp.utcnow()
today=now.date()

last_Sunday=(today - timedelta(days=today.weekday()+1)).strftime("%Y-%m-%d")
month_1st_day= datetime.today().replace(day=1).strftime("%Y-%m-%d")

start_date_YYYY_MM_DD = '2021-01-04'
end_date_YYYY_MM_DD=last_Sunday
yr='2021'

pre_yr='2020'

start_date_YYYYMMDD = '20210104'
#end_date_YYYYMMDD=datetime.today().replace(day=1).strftime("%Y%m%d")

end_date_YYYYMMDD=(today - timedelta(days=today.weekday()+1)).strftime("%Y%m%d")

if datetime.today().day < 7:
    snapshot = datetime.today().replace(month=datetime.today().month-2).strftime("%Y-%m")
else:
    snapshot = datetime.today().replace(month=datetime.today().month-1).strftime("%Y-%m")

lastyear_start_date_YYYY_MM_DD = '2020-01-01'
lastyear_end_date_YYYY_MM_DD='2020-12-31'
lastyear_start_date_YYYYMMDD = '20200101'
lastyear_end_date_YYYYMMDD='20201231'
last2years_start_date_YYYY_MM_DD = '2019-01-01'
last2years_end_date_YYYY_MM_DD='2019-12-31'
last2years_start_date_YYYYMMDD = '20190101'
last2years_end_date_YYYYMMDD='20191231'
SQL

Checking query status...
