meteor
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2 rows where elev_deg = "19.18421" and shower_iau_no = 7 sorted by beginning_utc_time descending
This data as json, copyable, CSV (advanced)
Suggested facets: beginning_utc_time (date), created_at (date), updated_at (date)
| unique_trajectory_identifier | beginning_utc_time ▲ | shower_iau_no | sol_lon_deg | app_lst_deg | rageo_deg | decgeo_deg | lamgeo_deg | betgeo_deg | vgeo_km_s | lamhel_deg | bethel_deg | vhel_km_s | a_au | e | i_deg | peri_deg | node_deg | pi_deg | b_deg | q_au | f_deg | m_deg | q_au_ | n_deg_day | t_years | tisserandj | raapp_deg | decapp_deg | azim_e_of_n_deg | elev_deg | vinit_km_s | vavg_km_s | latbeg_n_deg | lonbeg_e_deg | htbeg_km | latend_n_deg | lonend_e_deg | htend_km | duration_sec | peak_absmag | peak_ht_km | f_param | mass_kg_tau_0_7 | qc_deg | medianfiterr_arcsec | beg_in_fov | end_in_fov | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20250813034356_zj2Ny | 2025-08-13 03:43:56.495738 | 7 7 | 140.314578 | 286.059412 | 48.56025 | 58.4404 | 63.63602 | 38.73593 | 59.17042 | 83.98446 | 63.25772 | 41.46217 | 27.618325 | 0.965639 | 112.750017 | 150.584531 | 140.312404 | 290.896935 | 26.931746 | 0.949 | 29.411107 | 0.139654 | 54.28765 | 0.006791 | 145.143182 | -0.274608 | 47.76474 | 58.78887 | 27.82554 | 19.18421 | 60.36209 | 58.16232 | 39.137738 | -91.765294 | 110.4224 | 38.820963 | -91.978995 | 96.509 | 0.73 | -1.7 | 101.9132 | 0.612 | 0.000209 | 69.61 | 38.89 | 1 | 1 | 2025-08-15T12:54:35.761Z | 2025-08-21T12:47:49.065Z |
| 20250812185220_sSsQ4 | 2025-08-12 18:52:20.649028 | 7 7 | 139.960276 | 271.713974 | 47.1676 | 58.21221 | 62.65482 | 38.77173 | 59.1732 | 82.18744 | 63.51002 | 41.40497 | 24.127985 | 0.960431 | 112.859034 | 151.90299 | 139.957821 | 291.860811 | 25.720267 | 0.954722 | 28.092487 | 0.164388 | 47.301248 | 0.008316 | 118.51743 | -0.250231 | 46.49912 | 58.70809 | 22.97444 | 19.18421 | 60.32876 | 60.03765 | 43.855924 | 27.137933 | 111.5837 | 43.516117 | 26.940192 | 97.2578 | 0.8 | -0.63 | 99.682 | 0.831 | 8.43e-05 | 64.73 | 41.85 | 1 | 1 | 2025-08-14T12:32:48.684Z | 2025-08-20T13:07:59.191Z |
Advanced export
JSON shape: default, array, newline-delimited, object
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);