home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

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

>10,000 rows count all where station_code = "US005X" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
9609978 9609978 20260405113722_SykZN US005X 2026-04-06T12:05:05.155Z 2026-04-06T12:05:05.155Z
9609950 9609950 20260405112519_X6JNN US005X 2026-04-06T12:04:55.047Z 2026-04-06T12:04:55.047Z
9609873 9609873 20260405104316_nc7z0 US005X 2026-04-06T12:04:25.891Z 2026-04-06T12:04:25.891Z
9609818 9609818 20260405101802_TvVuW US005X 2026-04-06T12:04:02.336Z 2026-04-06T12:04:02.336Z
9609775 9609775 20260405095607_srMyc US005X 2026-04-06T12:03:50.162Z 2026-04-06T12:03:50.162Z
9609766 9609766 20260405094808_bN2H4 US005X 2026-04-06T12:03:47.687Z 2026-04-06T12:03:47.687Z
9609742 9609742 20260405093850_N30b3 US005X 2026-04-06T12:03:37.726Z 2026-04-06T12:03:37.726Z
9609723 9609723 20260405093117_qjUr0 US005X 2026-04-06T12:03:30.196Z 2026-04-06T12:03:30.196Z
9609710 9609710 20260405092949_BIQg1 US005X 2026-04-06T12:03:27.153Z 2026-04-06T12:03:27.153Z
9609605 9609605 20260405083508_zIzDF US005X 2026-04-06T12:02:53.188Z 2026-04-06T12:02:53.188Z
9609593 9609593 20260405083255_96Ar3 US005X 2026-04-06T12:02:50.227Z 2026-04-06T12:02:50.227Z
9609584 9609584 20260405082819_VAsrR US005X 2026-04-06T12:02:43.368Z 2026-04-06T12:02:43.368Z
9609582 9609582 20260405082720_dAOEn US005X 2026-04-06T12:02:42.781Z 2026-04-06T12:02:42.781Z
9609441 9609441 20260405063150_9uPFj US005X 2026-04-06T12:01:46.288Z 2026-04-06T12:01:46.288Z
9609411 9609411 20260405060514_hGfFh US005X 2026-04-06T12:01:41.116Z 2026-04-06T12:01:41.116Z
9609387 9609387 20260405054532_fDjvy US005X 2026-04-06T12:01:35.940Z 2026-04-06T12:01:35.940Z
9609325 9609325 20260405043700_ag0Ag US005X 2026-04-06T12:01:14.380Z 2026-04-06T12:01:14.380Z
9607668 9607668 20260404114147_j51Jy US005X 2026-04-05T12:03:23.957Z 2026-04-06T12:16:14.486Z
9607632 9607632 20260404112536_HPhnR US005X 2026-04-05T12:03:16.861Z 2026-04-06T12:16:14.480Z
9607588 9607588 20260404110907_umrCX US005X 2026-04-05T12:03:06.013Z 2026-04-06T12:16:14.470Z
9607580 9607580 20260404110245_kK34H US005X 2026-04-05T12:03:00.246Z 2026-04-06T12:16:14.467Z
9607552 9607552 20260404105208_zfVp7 US005X 2026-04-05T12:02:54.925Z 2026-04-06T12:16:14.463Z
9607482 9607482 20260404094605_q2Ibv US005X 2026-04-05T12:02:28.704Z 2026-04-06T12:16:14.447Z
9607479 9607479 20260404094540_VKvs0 US005X 2026-04-05T12:02:28.099Z 2026-04-06T12:16:14.446Z
9607472 9607472 20260404094519_z3SMm US005X 2026-04-05T12:02:27.408Z 2026-04-06T12:16:14.446Z
9607433 9607433 20260404090945_UdTB6 US005X 2026-04-05T12:02:15.766Z 2026-04-06T12:16:14.435Z
9607425 9607425 20260404090806_L3TeA US005X 2026-04-05T12:02:11.145Z 2026-04-06T12:16:14.434Z
9607423 9607423 20260404090525_b0fkz US005X 2026-04-05T12:02:10.424Z 2026-04-06T12:16:14.434Z
9607419 9607419 20260404090112_B2ops US005X 2026-04-05T12:02:08.993Z 2026-04-06T12:16:14.432Z
9607355 9607355 20260404080800_6Q3Ky US005X 2026-04-05T12:01:51.008Z 2026-04-06T12:16:14.418Z
9607335 9607335 20260404075259_qQB7F US005X 2026-04-05T12:01:42.457Z 2026-04-06T12:16:14.413Z
9607329 9607329 20260404074301_2o2Zy US005X 2026-04-05T12:01:41.284Z 2026-04-06T12:16:14.412Z
9607317 9607317 20260404072857_1iuMy US005X 2026-04-05T12:01:35.296Z 2026-04-06T12:16:14.410Z
9607141 9607141 20260404035048_0wb43 US005X 2026-04-05T12:00:34.345Z 2026-04-06T12:16:14.371Z
9605847 9605847 20260403121837_heVZz US005X 2026-04-04T12:04:08.115Z 2026-04-06T12:18:27.908Z
9605462 9605462 20260403100838_qKwnz US005X 2026-04-04T12:02:26.770Z 2026-04-06T12:17:54.202Z
9605459 9605459 20260403100606_Km0IL US005X 2026-04-04T12:02:26.037Z 2026-04-06T12:17:53.926Z
9605276 9605276 20260403081904_6Kqsk US005X 2026-04-04T12:01:31.195Z 2026-04-06T12:17:38.838Z
9605235 9605235 20260403080630_ac3Pb US005X 2026-04-04T12:01:21.292Z 2026-04-06T12:17:35.112Z
9605187 9605187 20260403073645_zh63G US005X 2026-04-04T12:01:03.210Z 2026-04-06T12:17:17.688Z
9605166 9605166 20260403072421_eKRMm US005X 2026-04-04T12:00:58.023Z 2026-04-06T12:17:04.032Z
9605120 9605120 20260403065612_Jjl0D US005X 2026-04-04T12:00:49.283Z 2026-04-06T12:16:44.015Z
9605115 9605115 20260403065315_e10Ej US005X 2026-04-04T12:00:48.279Z 2026-04-06T12:16:42.398Z
9605086 9605086 20260403060721_2rMCj US005X 2026-04-04T12:00:41.001Z 2026-04-06T12:16:30.333Z
9605078 9605078 20260403055857_rZsWL US005X 2026-04-04T12:00:40.004Z 2026-04-06T12:16:27.534Z
9603699 9603699 20260402115333_gF3x3 US005X 2026-04-03T12:04:13.566Z 2026-04-06T12:22:22.916Z
9603690 9603690 20260402115115_xEw7R US005X 2026-04-03T12:04:11.637Z 2026-04-06T12:22:22.314Z
9603552 9603552 20260402110148_UT0sS US005X 2026-04-03T12:03:30.460Z 2026-04-06T12:22:12.929Z
9603490 9603490 20260402103517_9u21A US005X 2026-04-03T12:03:13.262Z 2026-04-06T12:22:05.661Z
9603242 9603242 20260402090301_QCYpr US005X 2026-04-03T12:02:16.612Z 2026-04-06T12:21:48.946Z
9603190 9603190 20260402083917_qjM5o US005X 2026-04-03T12:02:06.039Z 2026-04-06T12:21:43.592Z
9603117 9603117 20260402075729_22Oi9 US005X 2026-04-03T12:01:53.030Z 2026-04-06T12:21:38.090Z
9603097 9603097 20260402074836_9H4c1 US005X 2026-04-03T12:01:44.162Z 2026-04-06T12:21:36.696Z
9603000 9603000 20260402055809_UdYCp US005X 2026-04-03T12:01:27.332Z 2026-04-06T12:21:25.760Z
9596248 9596248 20260330115745_AEf0x US005X 2026-03-31T12:03:50.513Z 2026-04-06T12:31:05.598Z
9596134 9596134 20260330112408_X83TX US005X 2026-03-31T12:03:34.232Z 2026-04-06T12:30:59.841Z
9596069 9596069 20260330105946_RZg35 US005X 2026-03-31T12:03:20.165Z 2026-04-06T12:30:50.893Z
9593615 9593615 20260329121225_Kw67q US005X 2026-03-30T12:04:32.136Z 2026-04-06T12:35:30.304Z
9593576 9593576 20260329115958_S2qx2 US005X 2026-03-30T12:04:25.824Z 2026-04-06T12:35:26.808Z
9593557 9593557 20260329114958_uqEyD US005X 2026-03-30T12:04:22.795Z 2026-04-06T12:35:25.991Z
9593442 9593442 20260329104646_ea3q1 US005X 2026-03-30T12:03:58.770Z 2026-04-06T12:35:19.067Z
9593112 9593112 20260329062224_peNCx US005X 2026-03-30T12:02:58.866Z 2026-04-06T12:34:51.108Z
9591004 9591004 20260328122157_eh53C US005X 2026-03-29T12:03:38.394Z 2026-04-06T12:38:46.188Z
9590458 9590458 20260328091832_sg8Oe US005X 2026-03-29T12:02:42.139Z 2026-04-06T12:38:10.650Z
9590425 9590425 20260328090928_9PSJa US005X 2026-03-29T12:02:37.303Z 2026-04-06T12:38:07.306Z
9590418 9590418 20260328090523_zMqr4 US005X 2026-03-29T12:02:36.372Z 2026-04-06T12:38:07.014Z
9590381 9590381 20260328084204_Xn2xb US005X 2026-03-29T12:02:31.133Z 2026-04-06T12:38:04.136Z
9590215 9590215 20260328073406_uHCpK US005X 2026-03-29T12:02:14.128Z 2026-04-06T12:37:56.653Z
9590128 9590128 20260328063944_a2Kmy US005X 2026-03-29T12:02:03.475Z 2026-04-06T12:37:52.046Z
9590125 9590125 20260328063935_NLxnq US005X 2026-03-29T12:02:03.144Z 2026-04-06T12:37:51.883Z
9590119 9590119 20260328063833_kfmtv US005X 2026-03-29T12:02:02.487Z 2026-04-06T12:37:51.627Z
9590113 9590113 20260328063042_Gnq8G US005X 2026-03-29T12:02:01.666Z 2026-04-06T12:37:51.204Z
9590083 9590083 20260328045805_9iQS2 US005X 2026-03-29T12:01:58.526Z 2026-04-06T12:37:49.967Z
9587392 9587392 20260327122446_kaYpU US005X 2026-03-28T12:05:25.015Z 2026-04-05T12:34:24.788Z
9587358 9587358 20260327121545_tI634 US005X 2026-03-28T12:05:21.135Z 2026-04-05T12:34:23.501Z
9587285 9587285 20260327115940_w02E2 US005X 2026-03-28T12:05:11.711Z 2026-04-05T12:34:11.416Z
9587216 9587216 20260327114440_Mbwci US005X 2026-03-28T12:05:02.605Z 2026-04-05T12:34:08.719Z
9587179 9587179 20260327113719_xnd2U US005X 2026-03-28T12:04:57.061Z 2026-04-05T12:34:05.487Z
9587169 9587169 20260327113056_vUym8 US005X 2026-03-28T12:04:55.944Z 2026-04-05T12:34:05.094Z
9587104 9587104 20260327111208_LdroS US005X 2026-03-28T12:04:46.212Z 2026-04-05T12:34:01.692Z
9587086 9587086 20260327110659_WMKMl US005X 2026-03-28T12:04:44.762Z 2026-04-05T12:34:01.249Z
9587038 9587038 20260327105521_0yYej US005X 2026-03-28T12:04:39.439Z 2026-04-05T12:33:59.379Z
9586993 9586993 20260327104002_WpbzN US005X 2026-03-28T12:04:30.787Z 2026-04-05T12:33:57.674Z
9586952 9586952 20260327102523_SVm37 US005X 2026-03-28T12:04:25.893Z 2026-04-05T12:33:55.714Z
9586914 9586914 20260327101718_uL1ic US005X 2026-03-28T12:04:21.105Z 2026-04-05T12:33:54.069Z
9586874 9586874 20260327100249_Df3rK US005X 2026-03-28T12:04:16.119Z 2026-04-05T12:33:52.691Z
9586869 9586869 20260327100224_w9RYr US005X 2026-03-28T12:04:15.651Z 2026-04-05T12:33:52.526Z
9586757 9586757 20260327092717_r2g3z US005X 2026-03-28T12:03:56.230Z 2026-04-05T12:33:46.917Z
9586734 9586734 20260327092048_KyUOJ US005X 2026-03-28T12:03:52.704Z 2026-04-05T12:33:39.623Z
9586686 9586686 20260327090759_rWNWg US005X 2026-03-28T12:03:45.741Z 2026-04-05T12:33:37.463Z
9586613 9586613 20260327084154_y4wuP US005X 2026-03-28T12:03:32.945Z 2026-04-05T12:33:32.658Z
9586606 9586606 20260327083849_F5gGY US005X 2026-03-28T12:03:32.502Z 2026-04-05T12:33:32.529Z
9586267 9586267 20260327053403_6O5b9 US005X 2026-03-28T12:02:40.780Z 2026-04-05T12:33:18.281Z
9586215 9586215 20260327045750_e4blm US005X 2026-03-28T12:02:32.258Z 2026-04-05T12:33:08.338Z
9586191 9586191 20260327044512_76hSn US005X 2026-03-28T12:02:29.352Z 2026-04-05T12:33:07.469Z
9585864 9585864 20260327025226_3MdLY US005X 2026-03-28T12:01:36.037Z 2026-04-05T12:32:50.089Z
9583320 9583320 20260326122149_wunN2 US005X 2026-03-27T12:08:24.467Z 2026-04-04T12:41:02.563Z
9583292 9583292 20260326121044_9NGuJ US005X 2026-03-27T12:08:18.449Z 2026-04-04T12:41:00.973Z
9583279 9583279 20260326120750_yO51U US005X 2026-03-27T12:08:16.710Z 2026-04-04T12:41:00.023Z
9583276 9583276 20260326120719_YN3jL US005X 2026-03-27T12:08:16.180Z 2026-04-04T12:40:59.826Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    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 (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network