Overview
Statistics for the entire archiving period since 2006-01-01
| Archive size [PiB] | |
|---|---|
Number of fields |
last updated:
Statistics for the period since 2014-01-01
| Number of active users | |
|---|---|
Delivered data volume [TiB] | |
| Number of retrieved fields | |
| Number of requests |
last updated:
Graphs
Users per country
- only countries with at least 5 active users are shown

SELECT profile_country.name, count(DISTINCT auth_user.username) as total_users
FROM profile_country
RIGHT JOIN profile_profile ON profile_profile.country_id = profile_country.id
RIGHT JOIN auth_user ON auth_user.id = profile_profile.user_id
RIGHT JOIN users_stats_monthly ON users_stats_monthly.username = auth_user.username
WHERE users_stats_monthly.dataset='tigge-global' and users_stats_monthly.month>=date'2006-01-01'
GROUP BY profile_country.name
HAVING count(DISTINCT auth_user.username)>=50
ORDER BY total_users DESC






