Social Media Events viewer

Reload view
 

Reddit discussing science (year)

Data originates from 16 november 2017 17:25:02. |  Update data  | Download as Excel  | Download as HTML table
 
Database query: SELECT substr(timestamp,1,4) AS `year`,concat(substr(timestamp,1,4),'Q',quarter(timestamp)) AS `quarter`,concat(substr(timestamp,1,4),'W',lpad(week(timestamp,0),2,'0')) AS `week`, CONCAT(UCASE(LEFT(substring_index( substring_index(url, '/', 5), '/', -1), 1)), SUBSTRING(lcase(substring_index( substring_index(url, '/', 5), '/', -1)), 2)) AS `source`, count(distinct doi) AS `no_of_doi`, count(distinct url) AS `no_of_url`, count(distinct substring_index( substring_index(doi, '/', 4), '/', -1)) as `no_of_pub` FROM `socialmediaevents` group by substr(timestamp,1,4), CONCAT(UCASE(LEFT(substring_index( substring_index(url, '/', 5), '/', -1), 1)), SUBSTRING(lcase(substring_index( substring_index(url, '/', 5), '/', -1)), 2))