Stats Page

[RyanTG]

I think stats help illustrate that there's a lot of cool stuff contained in the app.

If we made a new Stats page, it could show stuff like:

• Top 25: https://pinballmap.com/api/v1/location_machine_xrefs/top_n_machines.json
• Total machines, total locations: https://pinballmap.com/api/v1/regions/location_and_machine_counts.json
• Number of users: https://pinballmap.com/api/v1/users/total_user_count.json
• Total number of edits https://pinballmap.com/api/v1/user_submissions/total_user_submission_count.json
• Top 10 users https://pinballmap.com/api/v1/user_submissions/top_users.json
• Count of each location type https://pinballmap.com/api/v1/locations/type_count.json
• Top 10 cities by locations https://pinballmap.com/api/v1/locations/top_cities.json
• Top 10 cities by machines https://pinballmap.com/api/v1/locations/top_cities_by_machine.json

---

• List of countries (machines per country?). This one isn't great (so far) because the country names are abbreviations. So it looks like:

glowing-dusk-5085::HEROKU_POSTGRESQL_COBALT=> select country, count(*) as the_count from locations group by country order by the_count desc;
 country | the_count 
---------+-----------
 US      |      6468
 CA      |       428
 AU      |       243
 JP      |       100
 FI      |        80
 BE      |        76
 FR      |        56
 GB      |        43
 IT      |        36

But here's an endpoint for that https://pinballmap.com/api/v1/locations/countries.json