home / gmn_data_store / meteor_sigma

Menu
  • Dashboards

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 = "20251029071610_8t0lo" 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
20251029071610_8t0lo                                                                     2025-10-30T12:53:48.368Z 2025-10-30T12:53:48.368Z

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network