stats_total_number_of_meteors_by_shower_and_month
3,919 rows where shower_iau_no = 26
This data as json, copyable, CSV (advanced)
Suggested facets: month, created_at (date)
Link | created_at | month | shower_iau_no | count |
---|---|---|---|---|
2024-01-06T00:07:51.485Z,2019-07,26 | 2024-01-06T00:07:51.485Z | 2019-07 | 26 26 | 1 |
2024-01-06T00:07:51.485Z,2019-08,26 | 2024-01-06T00:07:51.485Z | 2019-08 | 26 26 | 77 |
2024-01-06T00:07:51.485Z,2019-09,26 | 2024-01-06T00:07:51.485Z | 2019-09 | 26 26 | 21 |
2024-01-06T00:07:51.485Z,2020-07,26 | 2024-01-06T00:07:51.485Z | 2020-07 | 26 26 | 7 |
2024-01-06T00:07:51.485Z,2020-08,26 | 2024-01-06T00:07:51.485Z | 2020-08 | 26 26 | 341 |
2024-01-06T00:07:51.485Z,2020-09,26 | 2024-01-06T00:07:51.485Z | 2020-09 | 26 26 | 45 |
2024-01-06T00:07:51.485Z,2021-07,26 | 2024-01-06T00:07:51.485Z | 2021-07 | 26 26 | 6 |
2024-01-06T00:07:51.485Z,2021-08,26 | 2024-01-06T00:07:51.485Z | 2021-08 | 26 26 | 349 |
2024-01-06T00:07:51.485Z,2021-09,26 | 2024-01-06T00:07:51.485Z | 2021-09 | 26 26 | 121 |
2024-01-06T00:07:51.485Z,2022-07,26 | 2024-01-06T00:07:51.485Z | 2022-07 | 26 26 | 9 |
2024-01-06T00:07:51.485Z,2022-08,26 | 2024-01-06T00:07:51.485Z | 2022-08 | 26 26 | 633 |
2024-01-06T00:07:51.485Z,2022-09,26 | 2024-01-06T00:07:51.485Z | 2022-09 | 26 26 | 132 |
2024-01-06T00:07:51.485Z,2023-07,26 | 2024-01-06T00:07:51.485Z | 2023-07 | 26 26 | 9 |
2024-01-06T00:07:51.485Z,2023-08,26 | 2024-01-06T00:07:51.485Z | 2023-08 | 26 26 | 1047 |
2024-01-06T00:07:51.485Z,2023-09,26 | 2024-01-06T00:07:51.485Z | 2023-09 | 26 26 | 209 |
2024-01-06T01:02:12.282Z,2019-07,26 | 2024-01-06T01:02:12.282Z | 2019-07 | 26 26 | 1 |
2024-01-06T01:02:12.282Z,2019-08,26 | 2024-01-06T01:02:12.282Z | 2019-08 | 26 26 | 77 |
2024-01-06T01:02:12.282Z,2019-09,26 | 2024-01-06T01:02:12.282Z | 2019-09 | 26 26 | 21 |
2024-01-06T01:02:12.282Z,2020-07,26 | 2024-01-06T01:02:12.282Z | 2020-07 | 26 26 | 7 |
2024-01-06T01:02:12.282Z,2020-08,26 | 2024-01-06T01:02:12.282Z | 2020-08 | 26 26 | 341 |
2024-01-06T01:02:12.282Z,2020-09,26 | 2024-01-06T01:02:12.282Z | 2020-09 | 26 26 | 45 |
2024-01-06T01:02:12.282Z,2021-07,26 | 2024-01-06T01:02:12.282Z | 2021-07 | 26 26 | 6 |
2024-01-06T01:02:12.282Z,2021-08,26 | 2024-01-06T01:02:12.282Z | 2021-08 | 26 26 | 349 |
2024-01-06T01:02:12.282Z,2021-09,26 | 2024-01-06T01:02:12.282Z | 2021-09 | 26 26 | 121 |
2024-01-06T01:02:12.282Z,2022-07,26 | 2024-01-06T01:02:12.282Z | 2022-07 | 26 26 | 9 |
2024-01-06T01:02:12.282Z,2022-08,26 | 2024-01-06T01:02:12.282Z | 2022-08 | 26 26 | 633 |
2024-01-06T01:02:12.282Z,2022-09,26 | 2024-01-06T01:02:12.282Z | 2022-09 | 26 26 | 132 |
2024-01-06T01:02:12.282Z,2023-07,26 | 2024-01-06T01:02:12.282Z | 2023-07 | 26 26 | 9 |
2024-01-06T01:02:12.282Z,2023-08,26 | 2024-01-06T01:02:12.282Z | 2023-08 | 26 26 | 1047 |
2024-01-06T01:02:12.282Z,2023-09,26 | 2024-01-06T01:02:12.282Z | 2023-09 | 26 26 | 209 |
2024-01-06T14:22:35.743Z,2019-07,26 | 2024-01-06T14:22:35.743Z | 2019-07 | 26 26 | 1 |
2024-01-06T14:22:35.743Z,2019-08,26 | 2024-01-06T14:22:35.743Z | 2019-08 | 26 26 | 77 |
2024-01-06T14:22:35.743Z,2019-09,26 | 2024-01-06T14:22:35.743Z | 2019-09 | 26 26 | 21 |
2024-01-06T14:22:35.743Z,2020-07,26 | 2024-01-06T14:22:35.743Z | 2020-07 | 26 26 | 7 |
2024-01-06T14:22:35.743Z,2020-08,26 | 2024-01-06T14:22:35.743Z | 2020-08 | 26 26 | 341 |
2024-01-06T14:22:35.743Z,2020-09,26 | 2024-01-06T14:22:35.743Z | 2020-09 | 26 26 | 45 |
2024-01-06T14:22:35.743Z,2021-07,26 | 2024-01-06T14:22:35.743Z | 2021-07 | 26 26 | 6 |
2024-01-06T14:22:35.743Z,2021-08,26 | 2024-01-06T14:22:35.743Z | 2021-08 | 26 26 | 349 |
2024-01-06T14:22:35.743Z,2021-09,26 | 2024-01-06T14:22:35.743Z | 2021-09 | 26 26 | 121 |
2024-01-06T14:22:35.743Z,2022-07,26 | 2024-01-06T14:22:35.743Z | 2022-07 | 26 26 | 9 |
2024-01-06T14:22:35.743Z,2022-08,26 | 2024-01-06T14:22:35.743Z | 2022-08 | 26 26 | 633 |
2024-01-06T14:22:35.743Z,2022-09,26 | 2024-01-06T14:22:35.743Z | 2022-09 | 26 26 | 132 |
2024-01-06T14:22:35.743Z,2023-07,26 | 2024-01-06T14:22:35.743Z | 2023-07 | 26 26 | 9 |
2024-01-06T14:22:35.743Z,2023-08,26 | 2024-01-06T14:22:35.743Z | 2023-08 | 26 26 | 1047 |
2024-01-06T14:22:35.743Z,2023-09,26 | 2024-01-06T14:22:35.743Z | 2023-09 | 26 26 | 209 |
2024-01-07T14:26:35.585Z,2019-07,26 | 2024-01-07T14:26:35.585Z | 2019-07 | 26 26 | 1 |
2024-01-07T14:26:35.585Z,2019-08,26 | 2024-01-07T14:26:35.585Z | 2019-08 | 26 26 | 77 |
2024-01-07T14:26:35.585Z,2019-09,26 | 2024-01-07T14:26:35.585Z | 2019-09 | 26 26 | 21 |
2024-01-07T14:26:35.585Z,2020-07,26 | 2024-01-07T14:26:35.585Z | 2020-07 | 26 26 | 7 |
2024-01-07T14:26:35.585Z,2020-08,26 | 2024-01-07T14:26:35.585Z | 2020-08 | 26 26 | 341 |
2024-01-07T14:26:35.585Z,2020-09,26 | 2024-01-07T14:26:35.585Z | 2020-09 | 26 26 | 45 |
2024-01-07T14:26:35.585Z,2021-07,26 | 2024-01-07T14:26:35.585Z | 2021-07 | 26 26 | 6 |
2024-01-07T14:26:35.585Z,2021-08,26 | 2024-01-07T14:26:35.585Z | 2021-08 | 26 26 | 349 |
2024-01-07T14:26:35.585Z,2021-09,26 | 2024-01-07T14:26:35.585Z | 2021-09 | 26 26 | 121 |
2024-01-07T14:26:35.585Z,2022-07,26 | 2024-01-07T14:26:35.585Z | 2022-07 | 26 26 | 9 |
2024-01-07T14:26:35.585Z,2022-08,26 | 2024-01-07T14:26:35.585Z | 2022-08 | 26 26 | 633 |
2024-01-07T14:26:35.585Z,2022-09,26 | 2024-01-07T14:26:35.585Z | 2022-09 | 26 26 | 132 |
2024-01-07T14:26:35.585Z,2023-07,26 | 2024-01-07T14:26:35.585Z | 2023-07 | 26 26 | 9 |
2024-01-07T14:26:35.585Z,2023-08,26 | 2024-01-07T14:26:35.585Z | 2023-08 | 26 26 | 1047 |
2024-01-07T14:26:35.585Z,2023-09,26 | 2024-01-07T14:26:35.585Z | 2023-09 | 26 26 | 209 |
2024-01-08T14:27:49.935Z,2019-07,26 | 2024-01-08T14:27:49.935Z | 2019-07 | 26 26 | 1 |
2024-01-08T14:27:49.935Z,2019-08,26 | 2024-01-08T14:27:49.935Z | 2019-08 | 26 26 | 77 |
2024-01-08T14:27:49.935Z,2019-09,26 | 2024-01-08T14:27:49.935Z | 2019-09 | 26 26 | 21 |
2024-01-08T14:27:49.935Z,2020-07,26 | 2024-01-08T14:27:49.935Z | 2020-07 | 26 26 | 7 |
2024-01-08T14:27:49.935Z,2020-08,26 | 2024-01-08T14:27:49.935Z | 2020-08 | 26 26 | 341 |
2024-01-08T14:27:49.935Z,2020-09,26 | 2024-01-08T14:27:49.935Z | 2020-09 | 26 26 | 45 |
2024-01-08T14:27:49.935Z,2021-07,26 | 2024-01-08T14:27:49.935Z | 2021-07 | 26 26 | 6 |
2024-01-08T14:27:49.935Z,2021-08,26 | 2024-01-08T14:27:49.935Z | 2021-08 | 26 26 | 349 |
2024-01-08T14:27:49.935Z,2021-09,26 | 2024-01-08T14:27:49.935Z | 2021-09 | 26 26 | 121 |
2024-01-08T14:27:49.935Z,2022-07,26 | 2024-01-08T14:27:49.935Z | 2022-07 | 26 26 | 9 |
2024-01-08T14:27:49.935Z,2022-08,26 | 2024-01-08T14:27:49.935Z | 2022-08 | 26 26 | 633 |
2024-01-08T14:27:49.935Z,2022-09,26 | 2024-01-08T14:27:49.935Z | 2022-09 | 26 26 | 132 |
2024-01-08T14:27:49.935Z,2023-07,26 | 2024-01-08T14:27:49.935Z | 2023-07 | 26 26 | 9 |
2024-01-08T14:27:49.935Z,2023-08,26 | 2024-01-08T14:27:49.935Z | 2023-08 | 26 26 | 1047 |
2024-01-08T14:27:49.935Z,2023-09,26 | 2024-01-08T14:27:49.935Z | 2023-09 | 26 26 | 209 |
2024-01-09T14:34:32.932Z,2019-07,26 | 2024-01-09T14:34:32.932Z | 2019-07 | 26 26 | 1 |
2024-01-09T14:34:32.932Z,2019-08,26 | 2024-01-09T14:34:32.932Z | 2019-08 | 26 26 | 77 |
2024-01-09T14:34:32.932Z,2019-09,26 | 2024-01-09T14:34:32.932Z | 2019-09 | 26 26 | 21 |
2024-01-09T14:34:32.932Z,2020-07,26 | 2024-01-09T14:34:32.932Z | 2020-07 | 26 26 | 7 |
2024-01-09T14:34:32.932Z,2020-08,26 | 2024-01-09T14:34:32.932Z | 2020-08 | 26 26 | 341 |
2024-01-09T14:34:32.932Z,2020-09,26 | 2024-01-09T14:34:32.932Z | 2020-09 | 26 26 | 45 |
2024-01-09T14:34:32.932Z,2021-07,26 | 2024-01-09T14:34:32.932Z | 2021-07 | 26 26 | 6 |
2024-01-09T14:34:32.932Z,2021-08,26 | 2024-01-09T14:34:32.932Z | 2021-08 | 26 26 | 349 |
2024-01-09T14:34:32.932Z,2021-09,26 | 2024-01-09T14:34:32.932Z | 2021-09 | 26 26 | 121 |
2024-01-09T14:34:32.932Z,2022-07,26 | 2024-01-09T14:34:32.932Z | 2022-07 | 26 26 | 9 |
2024-01-09T14:34:32.932Z,2022-08,26 | 2024-01-09T14:34:32.932Z | 2022-08 | 26 26 | 633 |
2024-01-09T14:34:32.932Z,2022-09,26 | 2024-01-09T14:34:32.932Z | 2022-09 | 26 26 | 132 |
2024-01-09T14:34:32.932Z,2023-07,26 | 2024-01-09T14:34:32.932Z | 2023-07 | 26 26 | 9 |
2024-01-09T14:34:32.932Z,2023-08,26 | 2024-01-09T14:34:32.932Z | 2023-08 | 26 26 | 1047 |
2024-01-09T14:34:32.932Z,2023-09,26 | 2024-01-09T14:34:32.932Z | 2023-09 | 26 26 | 209 |
2024-01-10T14:34:19.665Z,2019-07,26 | 2024-01-10T14:34:19.665Z | 2019-07 | 26 26 | 1 |
2024-01-10T14:34:19.665Z,2019-08,26 | 2024-01-10T14:34:19.665Z | 2019-08 | 26 26 | 77 |
2024-01-10T14:34:19.665Z,2019-09,26 | 2024-01-10T14:34:19.665Z | 2019-09 | 26 26 | 21 |
2024-01-10T14:34:19.665Z,2020-07,26 | 2024-01-10T14:34:19.665Z | 2020-07 | 26 26 | 7 |
2024-01-10T14:34:19.665Z,2020-08,26 | 2024-01-10T14:34:19.665Z | 2020-08 | 26 26 | 341 |
2024-01-10T14:34:19.665Z,2020-09,26 | 2024-01-10T14:34:19.665Z | 2020-09 | 26 26 | 45 |
2024-01-10T14:34:19.665Z,2021-07,26 | 2024-01-10T14:34:19.665Z | 2021-07 | 26 26 | 6 |
2024-01-10T14:34:19.665Z,2021-08,26 | 2024-01-10T14:34:19.665Z | 2021-08 | 26 26 | 349 |
2024-01-10T14:34:19.665Z,2021-09,26 | 2024-01-10T14:34:19.665Z | 2021-09 | 26 26 | 121 |
2024-01-10T14:34:19.665Z,2022-07,26 | 2024-01-10T14:34:19.665Z | 2022-07 | 26 26 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE stats_total_number_of_meteors_by_shower_and_month ( created_at datetime NOT NULL, month text NOT NULL, -- YYYY-MM shower_iau_no integer NOT NULL, count integer NOT NULL, FOREIGN KEY (shower_iau_no) REFERENCES shower (iau_no), PRIMARY KEY (created_at, month, shower_iau_no) );