stats_total_number_of_meteors_by_shower_and_month
1,376 rows where shower_iau_no = 47
This data as json, copyable, CSV (advanced)
Suggested facets: month, count, created_at (date)
Link | created_at | month | shower_iau_no | count |
---|---|---|---|---|
2024-01-06T00:07:51.485Z,2019-04,47 | 2024-01-06T00:07:51.485Z | 2019-04 | 47 47 | 4 |
2024-01-06T00:07:51.485Z,2020-04,47 | 2024-01-06T00:07:51.485Z | 2020-04 | 47 47 | 56 |
2024-01-06T00:07:51.485Z,2021-04,47 | 2024-01-06T00:07:51.485Z | 2021-04 | 47 47 | 33 |
2024-01-06T00:07:51.485Z,2022-04,47 | 2024-01-06T00:07:51.485Z | 2022-04 | 47 47 | 143 |
2024-01-06T00:07:51.485Z,2023-04,47 | 2024-01-06T00:07:51.485Z | 2023-04 | 47 47 | 205 |
2024-01-06T01:02:12.282Z,2019-04,47 | 2024-01-06T01:02:12.282Z | 2019-04 | 47 47 | 4 |
2024-01-06T01:02:12.282Z,2020-04,47 | 2024-01-06T01:02:12.282Z | 2020-04 | 47 47 | 56 |
2024-01-06T01:02:12.282Z,2021-04,47 | 2024-01-06T01:02:12.282Z | 2021-04 | 47 47 | 33 |
2024-01-06T01:02:12.282Z,2022-04,47 | 2024-01-06T01:02:12.282Z | 2022-04 | 47 47 | 143 |
2024-01-06T01:02:12.282Z,2023-04,47 | 2024-01-06T01:02:12.282Z | 2023-04 | 47 47 | 205 |
2024-01-06T14:22:35.743Z,2019-04,47 | 2024-01-06T14:22:35.743Z | 2019-04 | 47 47 | 4 |
2024-01-06T14:22:35.743Z,2020-04,47 | 2024-01-06T14:22:35.743Z | 2020-04 | 47 47 | 56 |
2024-01-06T14:22:35.743Z,2021-04,47 | 2024-01-06T14:22:35.743Z | 2021-04 | 47 47 | 33 |
2024-01-06T14:22:35.743Z,2022-04,47 | 2024-01-06T14:22:35.743Z | 2022-04 | 47 47 | 143 |
2024-01-06T14:22:35.743Z,2023-04,47 | 2024-01-06T14:22:35.743Z | 2023-04 | 47 47 | 205 |
2024-01-07T14:26:35.585Z,2019-04,47 | 2024-01-07T14:26:35.585Z | 2019-04 | 47 47 | 4 |
2024-01-07T14:26:35.585Z,2020-04,47 | 2024-01-07T14:26:35.585Z | 2020-04 | 47 47 | 56 |
2024-01-07T14:26:35.585Z,2021-04,47 | 2024-01-07T14:26:35.585Z | 2021-04 | 47 47 | 33 |
2024-01-07T14:26:35.585Z,2022-04,47 | 2024-01-07T14:26:35.585Z | 2022-04 | 47 47 | 143 |
2024-01-07T14:26:35.585Z,2023-04,47 | 2024-01-07T14:26:35.585Z | 2023-04 | 47 47 | 205 |
2024-01-08T14:27:49.935Z,2019-04,47 | 2024-01-08T14:27:49.935Z | 2019-04 | 47 47 | 4 |
2024-01-08T14:27:49.935Z,2020-04,47 | 2024-01-08T14:27:49.935Z | 2020-04 | 47 47 | 56 |
2024-01-08T14:27:49.935Z,2021-04,47 | 2024-01-08T14:27:49.935Z | 2021-04 | 47 47 | 33 |
2024-01-08T14:27:49.935Z,2022-04,47 | 2024-01-08T14:27:49.935Z | 2022-04 | 47 47 | 143 |
2024-01-08T14:27:49.935Z,2023-04,47 | 2024-01-08T14:27:49.935Z | 2023-04 | 47 47 | 205 |
2024-01-09T14:34:32.932Z,2019-04,47 | 2024-01-09T14:34:32.932Z | 2019-04 | 47 47 | 4 |
2024-01-09T14:34:32.932Z,2020-04,47 | 2024-01-09T14:34:32.932Z | 2020-04 | 47 47 | 56 |
2024-01-09T14:34:32.932Z,2021-04,47 | 2024-01-09T14:34:32.932Z | 2021-04 | 47 47 | 33 |
2024-01-09T14:34:32.932Z,2022-04,47 | 2024-01-09T14:34:32.932Z | 2022-04 | 47 47 | 143 |
2024-01-09T14:34:32.932Z,2023-04,47 | 2024-01-09T14:34:32.932Z | 2023-04 | 47 47 | 205 |
2024-01-10T14:34:19.665Z,2019-04,47 | 2024-01-10T14:34:19.665Z | 2019-04 | 47 47 | 4 |
2024-01-10T14:34:19.665Z,2020-04,47 | 2024-01-10T14:34:19.665Z | 2020-04 | 47 47 | 56 |
2024-01-10T14:34:19.665Z,2021-04,47 | 2024-01-10T14:34:19.665Z | 2021-04 | 47 47 | 33 |
2024-01-10T14:34:19.665Z,2022-04,47 | 2024-01-10T14:34:19.665Z | 2022-04 | 47 47 | 143 |
2024-01-10T14:34:19.665Z,2023-04,47 | 2024-01-10T14:34:19.665Z | 2023-04 | 47 47 | 205 |
2024-01-11T14:41:46.283Z,2019-04,47 | 2024-01-11T14:41:46.283Z | 2019-04 | 47 47 | 4 |
2024-01-11T14:41:46.283Z,2020-04,47 | 2024-01-11T14:41:46.283Z | 2020-04 | 47 47 | 56 |
2024-01-11T14:41:46.283Z,2021-04,47 | 2024-01-11T14:41:46.283Z | 2021-04 | 47 47 | 33 |
2024-01-11T14:41:46.283Z,2022-04,47 | 2024-01-11T14:41:46.283Z | 2022-04 | 47 47 | 143 |
2024-01-11T14:41:46.283Z,2023-04,47 | 2024-01-11T14:41:46.283Z | 2023-04 | 47 47 | 205 |
2024-01-12T14:27:49.692Z,2019-04,47 | 2024-01-12T14:27:49.692Z | 2019-04 | 47 47 | 4 |
2024-01-12T14:27:49.692Z,2020-04,47 | 2024-01-12T14:27:49.692Z | 2020-04 | 47 47 | 56 |
2024-01-12T14:27:49.692Z,2021-04,47 | 2024-01-12T14:27:49.692Z | 2021-04 | 47 47 | 33 |
2024-01-12T14:27:49.692Z,2022-04,47 | 2024-01-12T14:27:49.692Z | 2022-04 | 47 47 | 143 |
2024-01-12T14:27:49.692Z,2023-04,47 | 2024-01-12T14:27:49.692Z | 2023-04 | 47 47 | 205 |
2024-01-13T14:28:42.974Z,2019-04,47 | 2024-01-13T14:28:42.974Z | 2019-04 | 47 47 | 4 |
2024-01-13T14:28:42.974Z,2020-04,47 | 2024-01-13T14:28:42.974Z | 2020-04 | 47 47 | 56 |
2024-01-13T14:28:42.974Z,2021-04,47 | 2024-01-13T14:28:42.974Z | 2021-04 | 47 47 | 33 |
2024-01-13T14:28:42.974Z,2022-04,47 | 2024-01-13T14:28:42.974Z | 2022-04 | 47 47 | 143 |
2024-01-13T14:28:42.974Z,2023-04,47 | 2024-01-13T14:28:42.974Z | 2023-04 | 47 47 | 205 |
2024-01-14T14:25:17.329Z,2019-04,47 | 2024-01-14T14:25:17.329Z | 2019-04 | 47 47 | 4 |
2024-01-14T14:25:17.329Z,2020-04,47 | 2024-01-14T14:25:17.329Z | 2020-04 | 47 47 | 56 |
2024-01-14T14:25:17.329Z,2021-04,47 | 2024-01-14T14:25:17.329Z | 2021-04 | 47 47 | 33 |
2024-01-14T14:25:17.329Z,2022-04,47 | 2024-01-14T14:25:17.329Z | 2022-04 | 47 47 | 143 |
2024-01-14T14:25:17.329Z,2023-04,47 | 2024-01-14T14:25:17.329Z | 2023-04 | 47 47 | 205 |
2024-01-15T14:26:42.483Z,2019-04,47 | 2024-01-15T14:26:42.483Z | 2019-04 | 47 47 | 4 |
2024-01-15T14:26:42.483Z,2020-04,47 | 2024-01-15T14:26:42.483Z | 2020-04 | 47 47 | 56 |
2024-01-15T14:26:42.483Z,2021-04,47 | 2024-01-15T14:26:42.483Z | 2021-04 | 47 47 | 33 |
2024-01-15T14:26:42.483Z,2022-04,47 | 2024-01-15T14:26:42.483Z | 2022-04 | 47 47 | 143 |
2024-01-15T14:26:42.483Z,2023-04,47 | 2024-01-15T14:26:42.483Z | 2023-04 | 47 47 | 205 |
2024-01-16T14:29:21.733Z,2019-04,47 | 2024-01-16T14:29:21.733Z | 2019-04 | 47 47 | 4 |
2024-01-16T14:29:21.733Z,2020-04,47 | 2024-01-16T14:29:21.733Z | 2020-04 | 47 47 | 56 |
2024-01-16T14:29:21.733Z,2021-04,47 | 2024-01-16T14:29:21.733Z | 2021-04 | 47 47 | 33 |
2024-01-16T14:29:21.733Z,2022-04,47 | 2024-01-16T14:29:21.733Z | 2022-04 | 47 47 | 143 |
2024-01-16T14:29:21.733Z,2023-04,47 | 2024-01-16T14:29:21.733Z | 2023-04 | 47 47 | 205 |
2024-01-17T14:26:12.584Z,2019-04,47 | 2024-01-17T14:26:12.584Z | 2019-04 | 47 47 | 4 |
2024-01-17T14:26:12.584Z,2020-04,47 | 2024-01-17T14:26:12.584Z | 2020-04 | 47 47 | 56 |
2024-01-17T14:26:12.584Z,2021-04,47 | 2024-01-17T14:26:12.584Z | 2021-04 | 47 47 | 33 |
2024-01-17T14:26:12.584Z,2022-04,47 | 2024-01-17T14:26:12.584Z | 2022-04 | 47 47 | 143 |
2024-01-17T14:26:12.584Z,2023-04,47 | 2024-01-17T14:26:12.584Z | 2023-04 | 47 47 | 205 |
2024-01-18T14:28:01.592Z,2019-04,47 | 2024-01-18T14:28:01.592Z | 2019-04 | 47 47 | 4 |
2024-01-18T14:28:01.592Z,2020-04,47 | 2024-01-18T14:28:01.592Z | 2020-04 | 47 47 | 56 |
2024-01-18T14:28:01.592Z,2021-04,47 | 2024-01-18T14:28:01.592Z | 2021-04 | 47 47 | 33 |
2024-01-18T14:28:01.592Z,2022-04,47 | 2024-01-18T14:28:01.592Z | 2022-04 | 47 47 | 143 |
2024-01-18T14:28:01.592Z,2023-04,47 | 2024-01-18T14:28:01.592Z | 2023-04 | 47 47 | 205 |
2024-01-19T14:30:31.451Z,2019-04,47 | 2024-01-19T14:30:31.451Z | 2019-04 | 47 47 | 4 |
2024-01-19T14:30:31.451Z,2020-04,47 | 2024-01-19T14:30:31.451Z | 2020-04 | 47 47 | 56 |
2024-01-19T14:30:31.451Z,2021-04,47 | 2024-01-19T14:30:31.451Z | 2021-04 | 47 47 | 33 |
2024-01-19T14:30:31.451Z,2022-04,47 | 2024-01-19T14:30:31.451Z | 2022-04 | 47 47 | 143 |
2024-01-19T14:30:31.451Z,2023-04,47 | 2024-01-19T14:30:31.451Z | 2023-04 | 47 47 | 205 |
2024-01-20T14:24:59.302Z,2019-04,47 | 2024-01-20T14:24:59.302Z | 2019-04 | 47 47 | 4 |
2024-01-20T14:24:59.302Z,2020-04,47 | 2024-01-20T14:24:59.302Z | 2020-04 | 47 47 | 56 |
2024-01-20T14:24:59.302Z,2021-04,47 | 2024-01-20T14:24:59.302Z | 2021-04 | 47 47 | 33 |
2024-01-20T14:24:59.302Z,2022-04,47 | 2024-01-20T14:24:59.302Z | 2022-04 | 47 47 | 143 |
2024-01-20T14:24:59.302Z,2023-04,47 | 2024-01-20T14:24:59.302Z | 2023-04 | 47 47 | 205 |
2024-01-21T14:29:49.871Z,2019-04,47 | 2024-01-21T14:29:49.871Z | 2019-04 | 47 47 | 4 |
2024-01-21T14:29:49.871Z,2020-04,47 | 2024-01-21T14:29:49.871Z | 2020-04 | 47 47 | 56 |
2024-01-21T14:29:49.871Z,2021-04,47 | 2024-01-21T14:29:49.871Z | 2021-04 | 47 47 | 33 |
2024-01-21T14:29:49.871Z,2022-04,47 | 2024-01-21T14:29:49.871Z | 2022-04 | 47 47 | 143 |
2024-01-21T14:29:49.871Z,2023-04,47 | 2024-01-21T14:29:49.871Z | 2023-04 | 47 47 | 205 |
2024-01-22T14:25:21.879Z,2019-04,47 | 2024-01-22T14:25:21.879Z | 2019-04 | 47 47 | 4 |
2024-01-22T14:25:21.879Z,2020-04,47 | 2024-01-22T14:25:21.879Z | 2020-04 | 47 47 | 56 |
2024-01-22T14:25:21.879Z,2021-04,47 | 2024-01-22T14:25:21.879Z | 2021-04 | 47 47 | 33 |
2024-01-22T14:25:21.879Z,2022-04,47 | 2024-01-22T14:25:21.879Z | 2022-04 | 47 47 | 143 |
2024-01-22T14:25:21.879Z,2023-04,47 | 2024-01-22T14:25:21.879Z | 2023-04 | 47 47 | 205 |
2024-01-23T14:27:26.947Z,2019-04,47 | 2024-01-23T14:27:26.947Z | 2019-04 | 47 47 | 4 |
2024-01-23T14:27:26.947Z,2020-04,47 | 2024-01-23T14:27:26.947Z | 2020-04 | 47 47 | 56 |
2024-01-23T14:27:26.947Z,2021-04,47 | 2024-01-23T14:27:26.947Z | 2021-04 | 47 47 | 33 |
2024-01-23T14:27:26.947Z,2022-04,47 | 2024-01-23T14:27:26.947Z | 2022-04 | 47 47 | 143 |
2024-01-23T14:27:26.947Z,2023-04,47 | 2024-01-23T14:27:26.947Z | 2023-04 | 47 47 | 205 |
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) );