meteor_sigma

Data license: CC BY 4.0 license · Data source: Global Meteor Network

>10,000 rows count all sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Next page

CREATE TABLE meteor_sigma
(
    unique_trajectory_identifier text     NOT NULL PRIMARY KEY,
    sigma                        float,
    sigma_1                      float,
    sigma_2                      float,
    sigma_3                      float,
    sigma_4                      float,
    sigma_5                      float,
    sigma_6                      float,
    sigma_7                      float,
    sigma_8                      float,
    sigma_9                      float,
    sigma_10                     float,
    sigma_11                     float,
    sigma_12                     float,
    sigma_13                     float,
    sigma_14                     float,
    sigma_15                     float,
    sigma_16                     float,
    sigma_17                     float,
    sigma_18                     float,
    sigma_19                     float,
    sigma_20                     float,
    sigma_21                     float,
    sigma_22                     float,
    sigma_23                     float,
    sigma_24                     float,
    sigma_25                     float,
    sigma_26                     float,
    sigma_27                     float,
    sigma_28                     float,
    sigma_29                     float,
    sigma_30                     float,
    sigma_31                     float,
    sigma_32                     float,
    sigma_33                     float,
    created_at                   datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                   datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier)
);
CREATE INDEX meteor_sigma_created_at_index ON meteor_sigma (created_at);
CREATE INDEX meteor_sigma_updated_at_index ON meteor_sigma (updated_at);