# Chaomei Chen
# 10/10/2014
# generate burst.in from mysql
# # year uniq yearID
use comets;
select concat_ws(' ', '#', year, count(*), year-1976) from patent_citations_per_year where year < 2014 group by year order by year 
into outfile 'D:/research/papers/journals/2014/PNAS-PLOS-JASIST-ISSI/sql/burst_in_header' lines terminated by '\n';
select concat_ws(' ', year-1976, patent_id, citations) from patent_citations_per_year where year < 2014
into outfile 'D:/research/papers/journals/2014/PNAS-PLOS-JASIST-ISSI/sql/burst_in_body' lines terminated by '\n';
