stats_total_number_of_meteors_by_shower_and_month

>10,000 rows count all

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: month, created_at (date)

Next page

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)
);