meteor_sigma

Each row represents a meteor sighting.

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

1 row where unique_trajectory_identifier = "20240413140145_G5LoE" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

unique_trajectory_identifier sigma sigma_1 sigma_2 sigma_3 sigma_4 sigma_5 sigma_6 sigma_7 sigma_8 sigma_9 sigma_10 sigma_11 sigma_12 sigma_13 sigma_14 sigma_15 sigma_16 sigma_17 sigma_18 sigma_19 sigma_20 sigma_21 sigma_22 sigma_23 sigma_24 sigma_25 sigma_26 sigma_27 sigma_28 sigma_29 sigma_30 sigma_31 sigma_32 sigma_33 created_at ▲ updated_at
20240413140145_G5LoE 0.8944 0.9232 1.0655 0.6195 0.474 1.4649 1.3579 0.4738 380.0 0.0361 0.7859 2.2908 0.0001 2.2907 0.94 0.0187 2.2908   770.0 0.0104   0.2441 0.8968 0.9096 0.4408 1.0468 0.4669 0.552 0.0001 0.0014 0.17 0.0005 0.003 0.28 2024-04-14T12:12:31.227Z 2024-04-21T12:21:58.550Z

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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