meteor

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

>10,000 rows count all where shower_iau_no = 4 sorted by beginning_utc_time descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Next page

CREATE TABLE meteor
(
    unique_trajectory_identifier text     NOT NULL PRIMARY KEY,
    beginning_utc_time           datetime NOT NULL,
    shower_iau_no                integer  NOT NULL,
    sol_lon_deg                  float,
    app_lst_deg                  float,
    rageo_deg                    float,
    decgeo_deg                   float,
    lamgeo_deg                   float,
    betgeo_deg                   float,
    vgeo_km_s                    float,
    lamhel_deg                   float,
    bethel_deg                   float,
    vhel_km_s                    float,
    a_au                         float,
    e                            float,
    i_deg                        float,
    peri_deg                     float,
    node_deg                     float,
    pi_deg                       float,
    b_deg                        float,
    q_au                         float,
    f_deg                        float,
    m_deg                        float,
    q_au_                        float,
    n_deg_day                    float,
    t_years                      float,
    tisserandj                   float,
    raapp_deg                    float,
    decapp_deg                   float,
    azim_e_of_n_deg              float,
    elev_deg                     float,
    vinit_km_s                   float,
    vavg_km_s                    float,
    latbeg_n_deg                 float,
    lonbeg_e_deg                 float,
    htbeg_km                     float,
    latend_n_deg                 float,
    lonend_e_deg                 float,
    htend_km                     float,
    duration_sec                 float,
    peak_absmag                  float,
    peak_ht_km                   float,
    f_param                      float,
    mass_kg_tau_0_7              float,
    qc_deg                       float,
    medianfiterr_arcsec          float,
    beg_in_fov                   boolean,
    end_in_fov                   boolean,
    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 (shower_iau_no) REFERENCES shower (iau_no)
);
CREATE INDEX meteor_beginning_utc_time_covering_index ON meteor (beginning_utc_time,
                                                                               unique_trajectory_identifier,
                                                                               shower_iau_no,
                                                                               latbeg_n_deg,
                                                                               lonbeg_e_deg,
                                                                               latend_n_deg,
                                                                               lonend_e_deg);
CREATE INDEX meteor_shower_iau_covering_index ON meteor (shower_iau_no,
                                                                       unique_trajectory_identifier,
                                                                       beginning_utc_time,
                                                                       latbeg_n_deg,
                                                                       lonbeg_e_deg,
                                                                       latend_n_deg,
                                                                       lonend_e_deg);
CREATE INDEX meteor_sol_lon_deg_covering_index ON meteor (sol_lon_deg, unique_trajectory_identifier);
CREATE INDEX meteor_app_lst_deg_covering_index ON meteor (app_lst_deg, unique_trajectory_identifier);
CREATE INDEX meteor_rageo_deg_covering_index ON meteor (rageo_deg, unique_trajectory_identifier);
CREATE INDEX meteor_decgeo_deg_covering_index ON meteor (decgeo_deg, unique_trajectory_identifier);
CREATE INDEX meteor_lamgeo_deg_covering_index ON meteor (lamgeo_deg, unique_trajectory_identifier);
CREATE INDEX meteor_betgeo_deg_covering_index ON meteor (betgeo_deg, unique_trajectory_identifier);
CREATE INDEX meteor_vgeo_km_s_covering_index ON meteor (vgeo_km_s, unique_trajectory_identifier);
CREATE INDEX meteor_lamhel_deg_covering_index ON meteor (lamhel_deg, unique_trajectory_identifier);
CREATE INDEX meteor_bethel_deg_covering_index ON meteor (bethel_deg, unique_trajectory_identifier);
CREATE INDEX meteor_vhel_km_s_covering_index ON meteor (vhel_km_s, unique_trajectory_identifier);
CREATE INDEX meteor_a_au_covering_index ON meteor (a_au, unique_trajectory_identifier);
CREATE INDEX meteor_e_covering_index ON meteor (e, unique_trajectory_identifier);
CREATE INDEX meteor_i_deg_covering_index ON meteor (i_deg, unique_trajectory_identifier);
CREATE INDEX meteor_peri_deg_covering_index ON meteor (peri_deg, unique_trajectory_identifier);
CREATE INDEX meteor_node_deg_covering_index ON meteor (node_deg, unique_trajectory_identifier);
CREATE INDEX meteor_pi_deg_covering_index ON meteor (pi_deg, unique_trajectory_identifier);
CREATE INDEX meteor_b_deg_covering_index ON meteor (b_deg, unique_trajectory_identifier);
CREATE INDEX meteor_q_au_covering_index ON meteor (q_au, unique_trajectory_identifier);
CREATE INDEX meteor_f_deg_covering_index ON meteor (f_deg, unique_trajectory_identifier);
CREATE INDEX meteor_m_deg_covering_index ON meteor (m_deg, unique_trajectory_identifier);
CREATE INDEX meteor_q_au__covering_index ON meteor (q_au_, unique_trajectory_identifier);
CREATE INDEX meteor_n_deg_day_covering_index ON meteor (n_deg_day, unique_trajectory_identifier);
CREATE INDEX meteor_t_years_covering_index ON meteor (t_years, unique_trajectory_identifier);
CREATE INDEX meteor_tisserandj_covering_index ON meteor (tisserandj, unique_trajectory_identifier);
CREATE INDEX meteor_raapp_deg_covering_index ON meteor (raapp_deg, unique_trajectory_identifier);
CREATE INDEX meteor_decapp_deg_covering_index ON meteor (decapp_deg, unique_trajectory_identifier);
CREATE INDEX meteor_azim_e_of_n_deg_covering_index ON meteor (azim_e_of_n_deg, unique_trajectory_identifier);
CREATE INDEX meteor_elev_deg_covering_index ON meteor (elev_deg, unique_trajectory_identifier);
CREATE INDEX meteor_vinit_km_s_covering_index ON meteor (vinit_km_s, unique_trajectory_identifier);
CREATE INDEX meteor_vavg_km_s_covering_index ON meteor (vavg_km_s, unique_trajectory_identifier);
CREATE INDEX meteor_latbeg_n_deg_covering_index ON meteor (latbeg_n_deg,
                                                                         unique_trajectory_identifier,
                                                                         shower_iau_no,
                                                                         beginning_utc_time,
                                                                         latend_n_deg,
                                                                         lonend_e_deg,
                                                                         lonbeg_e_deg);
CREATE INDEX meteor_lonbeg_e_deg_covering_index ON meteor (lonbeg_e_deg,
                                                                         unique_trajectory_identifier,
                                                                         shower_iau_no,
                                                                         beginning_utc_time,
                                                                         latend_n_deg,
                                                                         lonend_e_deg,
                                                                         latbeg_n_deg);
CREATE INDEX meteor_htbeg_km_covering_index ON meteor (htbeg_km, unique_trajectory_identifier);
CREATE INDEX meteor_latend_n_deg_covering_index ON meteor (latend_n_deg,
                                                                         unique_trajectory_identifier,
                                                                         shower_iau_no,
                                                                         beginning_utc_time,
                                                                         latbeg_n_deg,
                                                                         lonbeg_e_deg,
                                                                         lonend_e_deg);
CREATE INDEX meteor_lonend_e_deg_covering_index ON meteor (lonend_e_deg,
                                                                         unique_trajectory_identifier,
                                                                         shower_iau_no,
                                                                         beginning_utc_time,
                                                                         latbeg_n_deg,
                                                                         lonbeg_e_deg,
                                                                         latend_n_deg);
CREATE INDEX meteor_htend_km_covering_index ON meteor (htend_km, unique_trajectory_identifier);
CREATE INDEX meteor_duration_sec_covering_index ON meteor (duration_sec, unique_trajectory_identifier);
CREATE INDEX meteor_peak_absmag_covering_index ON meteor (peak_absmag, unique_trajectory_identifier);
CREATE INDEX meteor_peak_ht_km_covering_index ON meteor (peak_ht_km, unique_trajectory_identifier);
CREATE INDEX meteor_f_param_covering_index ON meteor (f_param, unique_trajectory_identifier);
CREATE INDEX meteor_mass_kg_tau_0_7_covering_index ON meteor (mass_kg_tau_0_7, unique_trajectory_identifier);
CREATE INDEX meteor_qc_deg_covering_index ON meteor (qc_deg, unique_trajectory_identifier);
CREATE INDEX meteor_medianfiterr_arcsec_covering_index ON meteor (medianfiterr_arcsec, unique_trajectory_identifier);
CREATE INDEX meteor_beg_in_fov_covering_index ON meteor (beg_in_fov, unique_trajectory_identifier);
CREATE INDEX meteor_end_in_fov_covering_index ON meteor (end_in_fov, unique_trajectory_identifier);
CREATE INDEX meteor_created_at_index ON meteor (created_at);
CREATE INDEX meteor_updated_at_index ON meteor (updated_at);