stats_total_number_of_meteors_by_shower_and_month
767,929 rows
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date)
Link | created_at | month | shower_iau_no | count |
---|---|---|---|---|
2024-01-06T00:07:51.485Z,2018-12,-1 | 2024-01-06T00:07:51.485Z | 2018-12 | -1 -1 | 294 |
2024-01-06T00:07:51.485Z,2018-12,4 | 2024-01-06T00:07:51.485Z | 2018-12 | 4 4 | 130 |
2024-01-06T00:07:51.485Z,2018-12,15 | 2024-01-06T00:07:51.485Z | 2018-12 | 15 15 | 4 |
2024-01-06T00:07:51.485Z,2018-12,16 | 2024-01-06T00:07:51.485Z | 2018-12 | 16 16 | 4 |
2024-01-06T00:07:51.485Z,2018-12,19 | 2024-01-06T00:07:51.485Z | 2018-12 | 19 19 | 8 |
2024-01-06T00:07:51.485Z,2018-12,20 | 2024-01-06T00:07:51.485Z | 2018-12 | 20 20 | 13 |
2024-01-06T00:07:51.485Z,2018-12,97 | 2024-01-06T00:07:51.485Z | 2018-12 | 97 97 | 2 |
2024-01-06T00:07:51.485Z,2018-12,253 | 2024-01-06T00:07:51.485Z | 2018-12 | 253 253 | 1 |
2024-01-06T00:07:51.485Z,2018-12,256 | 2024-01-06T00:07:51.485Z | 2018-12 | 256 256 | 3 |
2024-01-06T00:07:51.485Z,2018-12,257 | 2024-01-06T00:07:51.485Z | 2018-12 | 257 257 | 2 |
2024-01-06T00:07:51.485Z,2018-12,288 | 2024-01-06T00:07:51.485Z | 2018-12 | 288 288 | 1 |
2024-01-06T00:07:51.485Z,2018-12,308 | 2024-01-06T00:07:51.485Z | 2018-12 | 308 308 | 1 |
2024-01-06T00:07:51.485Z,2018-12,334 | 2024-01-06T00:07:51.485Z | 2018-12 | 334 334 | 2 |
2024-01-06T00:07:51.485Z,2018-12,340 | 2024-01-06T00:07:51.485Z | 2018-12 | 340 340 | 1 |
2024-01-06T00:07:51.485Z,2018-12,390 | 2024-01-06T00:07:51.485Z | 2018-12 | 390 390 | 8 |
2024-01-06T00:07:51.485Z,2018-12,394 | 2024-01-06T00:07:51.485Z | 2018-12 | 394 394 | 1 |
2024-01-06T00:07:51.485Z,2018-12,395 | 2024-01-06T00:07:51.485Z | 2018-12 | 395 395 | 1 |
2024-01-06T00:07:51.485Z,2018-12,428 | 2024-01-06T00:07:51.485Z | 2018-12 | 428 428 | 2 |
2024-01-06T00:07:51.485Z,2018-12,502 | 2024-01-06T00:07:51.485Z | 2018-12 | 502 502 | 2 |
2024-01-06T00:07:51.485Z,2018-12,529 | 2024-01-06T00:07:51.485Z | 2018-12 | 529 529 | 2 |
2024-01-06T00:07:51.485Z,2018-12,561 | 2024-01-06T00:07:51.485Z | 2018-12 | 561 561 | 1 |
2024-01-06T00:07:51.485Z,2018-12,563 | 2024-01-06T00:07:51.485Z | 2018-12 | 563 563 | 1 |
2024-01-06T00:07:51.485Z,2018-12,585 | 2024-01-06T00:07:51.485Z | 2018-12 | 585 585 | 1 |
2024-01-06T00:07:51.485Z,2018-12,601 | 2024-01-06T00:07:51.485Z | 2018-12 | 601 601 | 1 |
2024-01-06T00:07:51.485Z,2018-12,633 | 2024-01-06T00:07:51.485Z | 2018-12 | 633 633 | 2 |
2024-01-06T00:07:51.485Z,2018-12,638 | 2024-01-06T00:07:51.485Z | 2018-12 | 638 638 | 1 |
2024-01-06T00:07:51.485Z,2018-12,644 | 2024-01-06T00:07:51.485Z | 2018-12 | 644 644 | 4 |
2024-01-06T00:07:51.485Z,2018-12,726 | 2024-01-06T00:07:51.485Z | 2018-12 | 726 726 | 3 |
2024-01-06T00:07:51.485Z,2018-12,886 | 2024-01-06T00:07:51.485Z | 2018-12 | 886 886 | 1 |
2024-01-06T00:07:51.485Z,2019-01,-1 | 2024-01-06T00:07:51.485Z | 2019-01 | -1 -1 | 491 |
2024-01-06T00:07:51.485Z,2019-01,10 | 2024-01-06T00:07:51.485Z | 2019-01 | 10 10 | 13 |
2024-01-06T00:07:51.485Z,2019-01,20 | 2024-01-06T00:07:51.485Z | 2019-01 | 20 20 | 4 |
2024-01-06T00:07:51.485Z,2019-01,89 | 2024-01-06T00:07:51.485Z | 2019-01 | 89 89 | 1 |
2024-01-06T00:07:51.485Z,2019-01,96 | 2024-01-06T00:07:51.485Z | 2019-01 | 96 96 | 12 |
2024-01-06T00:07:51.485Z,2019-01,97 | 2024-01-06T00:07:51.485Z | 2019-01 | 97 97 | 3 |
2024-01-06T00:07:51.485Z,2019-01,101 | 2024-01-06T00:07:51.485Z | 2019-01 | 101 101 | 4 |
2024-01-06T00:07:51.485Z,2019-01,110 | 2024-01-06T00:07:51.485Z | 2019-01 | 110 110 | 2 |
2024-01-06T00:07:51.485Z,2019-01,256 | 2024-01-06T00:07:51.485Z | 2019-01 | 256 256 | 1 |
2024-01-06T00:07:51.485Z,2019-01,288 | 2024-01-06T00:07:51.485Z | 2019-01 | 288 288 | 1 |
2024-01-06T00:07:51.485Z,2019-01,322 | 2024-01-06T00:07:51.485Z | 2019-01 | 322 322 | 1 |
2024-01-06T00:07:51.485Z,2019-01,331 | 2024-01-06T00:07:51.485Z | 2019-01 | 331 331 | 2 |
2024-01-06T00:07:51.485Z,2019-01,340 | 2024-01-06T00:07:51.485Z | 2019-01 | 340 340 | 1 |
2024-01-06T00:07:51.485Z,2019-01,428 | 2024-01-06T00:07:51.485Z | 2019-01 | 428 428 | 2 |
2024-01-06T00:07:51.485Z,2019-01,429 | 2024-01-06T00:07:51.485Z | 2019-01 | 429 429 | 4 |
2024-01-06T00:07:51.485Z,2019-01,501 | 2024-01-06T00:07:51.485Z | 2019-01 | 501 501 | 2 |
2024-01-06T00:07:51.485Z,2019-01,506 | 2024-01-06T00:07:51.485Z | 2019-01 | 506 506 | 3 |
2024-01-06T00:07:51.485Z,2019-01,530 | 2024-01-06T00:07:51.485Z | 2019-01 | 530 530 | 5 |
2024-01-06T00:07:51.485Z,2019-01,544 | 2024-01-06T00:07:51.485Z | 2019-01 | 544 544 | 3 |
2024-01-06T00:07:51.485Z,2019-01,569 | 2024-01-06T00:07:51.485Z | 2019-01 | 569 569 | 2 |
2024-01-06T00:07:51.485Z,2019-01,590 | 2024-01-06T00:07:51.485Z | 2019-01 | 590 590 | 1 |
2024-01-06T00:07:51.485Z,2019-01,858 | 2024-01-06T00:07:51.485Z | 2019-01 | 858 858 | 2 |
2024-01-06T00:07:51.485Z,2019-02,-1 | 2024-01-06T00:07:51.485Z | 2019-02 | -1 -1 | 1235 |
2024-01-06T00:07:51.485Z,2019-02,101 | 2024-01-06T00:07:51.485Z | 2019-02 | 101 101 | 8 |
2024-01-06T00:07:51.485Z,2019-02,110 | 2024-01-06T00:07:51.485Z | 2019-02 | 110 110 | 1 |
2024-01-06T00:07:51.485Z,2019-02,427 | 2024-01-06T00:07:51.485Z | 2019-02 | 427 427 | 1 |
2024-01-06T00:07:51.485Z,2019-02,429 | 2024-01-06T00:07:51.485Z | 2019-02 | 429 429 | 2 |
2024-01-06T00:07:51.485Z,2019-02,506 | 2024-01-06T00:07:51.485Z | 2019-02 | 506 506 | 2 |
2024-01-06T00:07:51.485Z,2019-02,515 | 2024-01-06T00:07:51.485Z | 2019-02 | 515 515 | 1 |
2024-01-06T00:07:51.485Z,2019-02,516 | 2024-01-06T00:07:51.485Z | 2019-02 | 516 516 | 1 |
2024-01-06T00:07:51.485Z,2019-02,569 | 2024-01-06T00:07:51.485Z | 2019-02 | 569 569 | 7 |
2024-01-06T00:07:51.485Z,2019-02,570 | 2024-01-06T00:07:51.485Z | 2019-02 | 570 570 | 3 |
2024-01-06T00:07:51.485Z,2019-02,571 | 2024-01-06T00:07:51.485Z | 2019-02 | 571 571 | 1 |
2024-01-06T00:07:51.485Z,2019-02,591 | 2024-01-06T00:07:51.485Z | 2019-02 | 591 591 | 3 |
2024-01-06T00:07:51.485Z,2019-02,712 | 2024-01-06T00:07:51.485Z | 2019-02 | 712 712 | 1 |
2024-01-06T00:07:51.485Z,2019-02,732 | 2024-01-06T00:07:51.485Z | 2019-02 | 732 732 | 3 |
2024-01-06T00:07:51.485Z,2019-02,734 | 2024-01-06T00:07:51.485Z | 2019-02 | 734 734 | 1 |
2024-01-06T00:07:51.485Z,2019-02,750 | 2024-01-06T00:07:51.485Z | 2019-02 | 750 750 | 4 |
2024-01-06T00:07:51.485Z,2019-02,807 | 2024-01-06T00:07:51.485Z | 2019-02 | 807 807 | 5 |
2024-01-06T00:07:51.485Z,2019-02,816 | 2024-01-06T00:07:51.485Z | 2019-02 | 816 816 | 1 |
2024-01-06T00:07:51.485Z,2019-02,858 | 2024-01-06T00:07:51.485Z | 2019-02 | 858 858 | 1 |
2024-01-06T00:07:51.485Z,2019-02,890 | 2024-01-06T00:07:51.485Z | 2019-02 | 890 890 | 1 |
2024-01-06T00:07:51.485Z,2019-02,891 | 2024-01-06T00:07:51.485Z | 2019-02 | 891 891 | 2 |
2024-01-06T00:07:51.485Z,2019-03,-1 | 2024-01-06T00:07:51.485Z | 2019-03 | -1 -1 | 508 |
2024-01-06T00:07:51.485Z,2019-03,11 | 2024-01-06T00:07:51.485Z | 2019-03 | 11 11 | 2 |
2024-01-06T00:07:51.485Z,2019-03,40 | 2024-01-06T00:07:51.485Z | 2019-03 | 40 40 | 2 |
2024-01-06T00:07:51.485Z,2019-03,345 | 2024-01-06T00:07:51.485Z | 2019-03 | 345 345 | 1 |
2024-01-06T00:07:51.485Z,2019-03,346 | 2024-01-06T00:07:51.485Z | 2019-03 | 346 346 | 3 |
2024-01-06T00:07:51.485Z,2019-03,448 | 2024-01-06T00:07:51.485Z | 2019-03 | 448 448 | 3 |
2024-01-06T00:07:51.485Z,2019-03,571 | 2024-01-06T00:07:51.485Z | 2019-03 | 571 571 | 1 |
2024-01-06T00:07:51.485Z,2019-03,647 | 2024-01-06T00:07:51.485Z | 2019-03 | 647 647 | 4 |
2024-01-06T00:07:51.485Z,2019-03,648 | 2024-01-06T00:07:51.485Z | 2019-03 | 648 648 | 2 |
2024-01-06T00:07:51.485Z,2019-03,651 | 2024-01-06T00:07:51.485Z | 2019-03 | 651 651 | 4 |
2024-01-06T00:07:51.485Z,2019-03,750 | 2024-01-06T00:07:51.485Z | 2019-03 | 750 750 | 2 |
2024-01-06T00:07:51.485Z,2019-03,807 | 2024-01-06T00:07:51.485Z | 2019-03 | 807 807 | 2 |
2024-01-06T00:07:51.485Z,2019-03,859 | 2024-01-06T00:07:51.485Z | 2019-03 | 859 859 | 2 |
2024-01-06T00:07:51.485Z,2019-03,862 | 2024-01-06T00:07:51.485Z | 2019-03 | 862 862 | 1 |
2024-01-06T00:07:51.485Z,2019-04,-1 | 2024-01-06T00:07:51.485Z | 2019-04 | -1 -1 | 759 |
2024-01-06T00:07:51.485Z,2019-04,6 | 2024-01-06T00:07:51.485Z | 2019-04 | 6 6 | 30 |
2024-01-06T00:07:51.485Z,2019-04,21 | 2024-01-06T00:07:51.485Z | 2019-04 | 21 21 | 10 |
2024-01-06T00:07:51.485Z,2019-04,27 | 2024-01-06T00:07:51.485Z | 2019-04 | 27 27 | 2 |
2024-01-06T00:07:51.485Z,2019-04,31 | 2024-01-06T00:07:51.485Z | 2019-04 | 31 31 | 1 |
2024-01-06T00:07:51.485Z,2019-04,40 | 2024-01-06T00:07:51.485Z | 2019-04 | 40 40 | 8 |
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,2019-04,343 | 2024-01-06T00:07:51.485Z | 2019-04 | 343 343 | 6 |
2024-01-06T00:07:51.485Z,2019-04,348 | 2024-01-06T00:07:51.485Z | 2019-04 | 348 348 | 4 |
2024-01-06T00:07:51.485Z,2019-04,450 | 2024-01-06T00:07:51.485Z | 2019-04 | 450 450 | 3 |
2024-01-06T00:07:51.485Z,2019-04,517 | 2024-01-06T00:07:51.485Z | 2019-04 | 517 517 | 1 |
2024-01-06T00:07:51.485Z,2019-04,518 | 2024-01-06T00:07:51.485Z | 2019-04 | 518 518 | 1 |
2024-01-06T00:07:51.485Z,2019-04,581 | 2024-01-06T00:07:51.485Z | 2019-04 | 581 581 | 5 |
2024-01-06T00:07:51.485Z,2019-04,599 | 2024-01-06T00:07:51.485Z | 2019-04 | 599 599 | 4 |
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) );