# I wrote a statistics page of asciinema.org/explore

**URL:** <https://discourse.asciinema.org/t/i-wrote-a-statistics-page-of-asciinema-org-explore/226>\
**Category:** Show and tell\
**Created:** [May 1, 2019, 5:40am UTC](https://discourse.asciinema.org/t/i-wrote-a-statistics-page-of-asciinema-org-explore/226 "2019-05-01T05:40:46Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![goreliu](https://yyz1.discourse-cdn.com/flex027/user_avatar/discourse.asciinema.org/goreliu/32/102_2.png) [@goreliu](https://discourse.asciinema.org/u/goreliu)\
**Post date:** [May 1, 2019, 5:40am UTC](https://discourse.asciinema.org/t/i-wrote-a-statistics-page-of-asciinema-org-explore/226/1 "2019-05-01T05:40:46Z")

</div>

Hi, I wrote a statistics page of `Watch -> All Public`.

Url: [https://goreliu.github.io/asciinema\_statistics/](https://goreliu.github.io/asciinema_statistics/)

Here is a screenshot:

 ![screenshot](https://canada1.discourse-cdn.com/flex027/uploads/asciinema/original/1X/7a407d3898ada8646d5ded53b00e7577edc9ea6d.png)

And there are some tools in it.

```auto
bin/playrandom: play a random asciinema cast from asciinema.org in terminal

bin/generate: generate index.html

bin/update: pull new data from asciinema.org and update index.html

bin/autoupdate: run bin/update every 600s

bin/savetosqlite: save data to a sqlite3 format database file(data/asciinema.db)

$ ./bin/savetosqlite
saved data to /home/goreliu/asciinema_statistics/data/asciinema.db
$ sqlite3 data/asciinema.db
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
sqlite> .schema data
CREATE TABLE data (id int, os varchar(20), shell varchar(20), term varchar(50), user varchar(50));
sqlite> select count(*) from data where os = "Linux" and shell = "zsh";
3449
sqlite> select count(*) from data where os = "macOS" and shell = "zsh";
3265

```

I hope someone will be interested in it.

Source code: [https://github.com/goreliu/asciinema\_statistics](https://github.com/goreliu/asciinema_statistics)

Thanks.