ProceedingsTitleParser/Queries

select 
    source,count(*) as count 
    from event
    group by source
union 
select 
    "TOTAL",count(*) as count
    from event
    order by count

pragma table_info('event');

pragma table_info('event_CEURWS');

pragma table_info('event_confref');

pragma table_info('event_dblp');

pragma table_info('event_crossref');

pragma table_info('event_or');

pragma table_info('event_wikicfp');

pragma table_info('event_wikidata');

select number,title,url from event_crossref
where number is not null and title like '%Anais%'
order by number

select count(*) as count,cast(number as integer) as enum,number from event_crossref
where number is not null
group by enum,number
having count>1
order by enum

select number,cast(number as integer) as enum,year,title 
from event_crossref
where  enum> 53 and enum<1952

select count(*) as count,country 
from event_confref
group by country
order by 1 desc

select year,count(*) as count
from event_wikicfp
group by year
order by year

select year,count(*) as count
from event_or
group by year
order by year

select count(*) as count,enum,ordinal 
from event_wikidata 
where enum is not null
group by enum,ordinal
union 
select count(*) as count,'total',''
from event_wikidata 
where enum is not null
order by 1 desc limit 20

select ci.*,co.*
from city_github ci join country_github co 
on ci.name=co.capital and co.isocode=ci.country
order by co.isocode