issue_comments: 786840734

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/1246#issuecomment-786840734 https://api.github.com/repos/simonw/datasette/issues/1246 786840734 MDEyOklzc3VlQ29tbWVudDc4Njg0MDczNA== 9599 2021-02-26T19:12:39Z 2021-02-26T19:12:47Z OWNER

Could I take this part: python suggested_facet_sql = """ select distinct json_type({column}) from ({sql}) """.format( column=escape_sqlite(column), sql=self.sql ) And add where {column} is not null and {column} != '' perhaps?

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 817597268