digitalcorpora.org Reports
Available Reports:
- Last 50 corpora uploads
- Downloads over past week
- Downloads in the past 24 hours
- Failed downloads in past 24 hours
- Downloads per day for the past 30 days
Producing the Digital Body
SELECT s3key, round(sum(bytes_sent)/max(bytes)) as count, min(dtime) as first,max(dtime) as last FROM downloads LEFT JOIN downloadable ON downloads.did = downloadable.id WHERE dtime > DATE_ADD(NOW(), INTERVAL -7 DAY) GROUP BY s3key HAVING count>=1 ORDER BY count DESC
