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

3,546 rows where station_code = "RU0019" 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
9594849 9594849 20260329004403_T3f31 RU0019 2026-03-30T12:10:25.499Z 2026-04-01T12:18:08.722Z
9594527 9594527 20260328225113_3ElLH RU0019 2026-03-30T12:09:45.942Z 2026-04-01T12:17:52.487Z
9594474 9594474 20260328223626_OO1tG RU0019 2026-03-30T12:09:39.694Z 2026-04-01T12:17:49.860Z
9592361 9592361 20260329015740_RqSfL RU0019 2026-03-30T12:00:47.261Z 2026-04-01T12:12:07.708Z
9575681 9575681 20260322211916_g1XCD RU0019 2026-03-25T12:26:56.136Z 2026-03-30T12:30:42.710Z
9575669 9575669 20260322184205_7dV3d RU0019 2026-03-25T12:26:33.312Z 2026-03-30T12:30:25.755Z
9574640 9574640 20260323010751_qPVmA RU0019 2026-03-25T12:11:44.306Z 2026-03-31T12:25:58.150Z
9530477 9530477 20260318205958_91VZ2 RU0019 2026-03-20T12:24:25.668Z 2026-03-26T12:39:12.791Z
9529657 9529657 20260318190354_fzFlN RU0019 2026-03-20T12:23:31.221Z 2026-03-26T12:39:05.224Z
9519605 9519605 20260319022120_BXj6E RU0019 2026-03-20T12:04:43.169Z 2026-03-27T12:40:33.186Z
9518920 9518920 20260319013506_2AdrJ RU0019 2026-03-20T12:03:36.006Z 2026-03-27T12:40:16.421Z
9518464 9518464 20260319010232_Rf8rD RU0019 2026-03-20T12:02:38.314Z 2026-03-27T12:40:10.139Z
9517857 9517857 20260319000649_l6vGV RU0019 2026-03-20T12:01:24.805Z 2026-03-27T12:40:04.129Z
9516944 9516944 20260317221819_2OxMq RU0019 2026-03-19T12:26:56.176Z 2026-03-25T12:43:07.667Z
9493127 9493127 20260314224940_J2JpR RU0019 2026-03-16T12:29:28.226Z 2026-03-22T12:42:56.885Z
9492712 9492712 20260314214403_AhI4q RU0019 2026-03-16T12:28:58.139Z 2026-03-22T12:42:54.054Z
9492484 9492484 20260314210013_GMffl RU0019 2026-03-16T12:28:36.916Z 2026-03-22T12:42:52.657Z
9492456 9492456 20260314205142_ghJTt RU0019 2026-03-16T12:28:35.304Z 2026-03-22T12:42:52.445Z
9492285 9492285 20260314200815_IQ2jb RU0019 2026-03-16T12:28:15.992Z 2026-03-22T12:42:51.480Z
9492268 9492268 20260314200207_5m2XY RU0019 2026-03-16T12:28:15.142Z 2026-03-22T12:42:51.426Z
9482875 9482875 20260313193349_6pECV RU0019 2026-03-15T12:25:24.228Z 2026-03-21T12:50:05.624Z
9482766 9482766 20260313173029_zDsPT RU0019 2026-03-15T12:24:55.790Z 2026-03-21T12:49:58.816Z
9475414 9475414 20260314012415_I6EKa RU0019 2026-03-15T12:03:05.545Z 2026-03-22T12:41:38.009Z
9475373 9475373 20260314011959_GpDV3 RU0019 2026-03-15T12:02:59.397Z 2026-03-22T12:41:37.314Z
9475221 9475221 20260314005858_BwvZm RU0019 2026-03-15T12:02:33.314Z 2026-03-22T12:41:28.374Z
9475118 9475118 20260314004237_2L63x RU0019 2026-03-15T12:02:17.476Z 2026-03-22T12:41:27.115Z
9474932 9474932 20260314001636_G2kwK RU0019 2026-03-15T12:01:46.895Z 2026-03-22T12:41:25.539Z
9474721 9474721 20260313234345_Fc6qR RU0019 2026-03-15T12:01:08.592Z 2026-03-22T12:41:23.695Z
9474645 9474645 20260313233049_3jNTp RU0019 2026-03-15T12:00:49.906Z 2026-03-22T12:41:22.981Z
9474167 9474167 20260312211918_bOOdx RU0019 2026-03-14T12:22:14.738Z 2026-03-20T12:37:16.506Z
9474080 9474080 20260312202542_pU13F RU0019 2026-03-14T12:21:56.401Z 2026-03-20T12:37:15.570Z
9474030 9474030 20260312194219_TqOem RU0019 2026-03-14T12:21:47.080Z 2026-03-20T12:37:14.925Z
9473986 9473986 20260312185956_Ccs2w RU0019 2026-03-14T12:21:38.982Z 2026-03-20T12:37:14.277Z
9473977 9473977 20260312184335_YtV73 RU0019 2026-03-14T12:21:36.628Z 2026-03-20T12:37:14.059Z
9473965 9473965 20260312183058_2xtqF RU0019 2026-03-14T12:21:32.051Z 2026-03-20T12:37:13.799Z
9473942 9473942 20260312174823_wsCWG RU0019 2026-03-14T12:21:22.337Z 2026-03-20T12:37:13.008Z
9469165 9469165 20260313020611_eNqn9 RU0019 2026-03-14T12:03:12.331Z 2026-03-21T12:48:34.533Z
9469027 9469027 20260313013242_2or9C RU0019 2026-03-14T12:02:41.822Z 2026-03-21T12:48:32.673Z
9468554 9468554 20260312232958_OU530 RU0019 2026-03-14T12:00:40.288Z 2026-03-21T12:48:26.325Z
9468460 9468460 20260312225006_wFgd0 RU0019 2026-03-14T12:00:15.969Z 2026-03-21T12:48:24.912Z
9467547 9467547 20260311220810_reS2T RU0019 2026-03-13T12:19:25.170Z 2026-03-19T12:45:53.108Z
9467471 9467471 20260311214930_ZD9pl RU0019 2026-03-13T12:19:17.426Z 2026-03-19T12:45:52.585Z
9467163 9467163 20260311202531_wEE6B RU0019 2026-03-13T12:18:34.841Z 2026-03-19T12:45:49.595Z
9466959 9466959 20260311190741_BCHd1 RU0019 2026-03-13T12:17:47.852Z 2026-03-19T12:45:45.184Z
9466927 9466927 20260311184415_dv70n RU0019 2026-03-13T12:17:37.704Z 2026-03-19T12:45:43.957Z
9463634 9463634 20260312021611_3xIEa RU0019 2026-03-13T12:04:44.684Z 2026-03-20T12:36:23.659Z
9463228 9463228 20260312011836_5CxIe RU0019 2026-03-13T12:03:32.458Z 2026-03-20T12:36:21.386Z
9462946 9462946 20260312004005_GfDI2 RU0019 2026-03-13T12:02:42.400Z 2026-03-20T12:36:19.069Z
9462584 9462584 20260311234135_in99p RU0019 2026-03-13T12:01:31.008Z 2026-03-20T12:36:16.960Z
9462432 9462432 20260311231831_TAGws RU0019 2026-03-13T12:00:59.720Z 2026-03-20T12:36:15.989Z
9462305 9462305 20260311225231_UNCr6 RU0019 2026-03-13T12:00:25.212Z 2026-03-20T12:36:14.975Z
9460755 9460755 20260310221138_6lhpK RU0019 2026-03-12T12:15:03.244Z 2026-03-18T12:40:18.956Z
9460564 9460564 20260310203914_Ae7o0 RU0019 2026-03-12T12:14:34.323Z 2026-03-18T12:40:13.741Z
9460397 9460397 20260310190125_HZiRA RU0019 2026-03-12T12:14:00.130Z 2026-03-18T12:39:56.344Z
9460376 9460376 20260310184242_Zp22Y RU0019 2026-03-12T12:13:52.155Z 2026-03-18T12:39:54.896Z
9460362 9460362 20260310183135_irxrV RU0019 2026-03-12T12:13:49.419Z 2026-03-18T12:39:54.353Z
9460353 9460353 20260310182341_GyQfG RU0019 2026-03-12T12:13:46.292Z 2026-03-18T12:39:52.846Z
9457137 9457137 20260311024223_YYHHe RU0019 2026-03-12T12:02:59.027Z 2026-03-19T12:44:28.999Z
9457001 9457001 20260311020337_HmR0S RU0019 2026-03-12T12:02:32.951Z 2026-03-19T12:44:24.637Z
9456843 9456843 20260311011650_NEkqM RU0019 2026-03-12T12:01:57.731Z 2026-03-19T12:44:22.717Z
9456573 9456573 20260310235924_3BRit RU0019 2026-03-12T12:01:07.817Z 2026-03-19T12:44:18.561Z
9456569 9456569 20260310235802_9oA3f RU0019 2026-03-12T12:01:06.913Z 2026-03-19T12:44:18.486Z
9456109 9456109 20260309215017_HAOaZ RU0019 2026-03-11T12:15:40.694Z 2026-03-17T12:42:53.194Z
9455783 9455783 20260309201204_TObu8 RU0019 2026-03-11T12:15:01.639Z 2026-03-17T12:42:38.953Z
9455490 9455490 20260309171321_ni2sX RU0019 2026-03-11T12:14:21.303Z 2026-03-17T12:42:32.915Z
9455486 9455486 20260309162250_ElK1p RU0019 2026-03-11T12:14:08.714Z 2026-03-17T12:42:30.942Z
9451072 9451072 20260310003729_vP3P7 RU0019 2026-03-11T12:01:39.016Z 2026-03-18T12:38:40.113Z
9450823 9450823 20260309232241_uMsGe RU0019 2026-03-11T12:00:48.420Z 2026-03-18T12:38:36.372Z
9450795 9450795 20260309231928_qhi6e RU0019 2026-03-11T12:00:42.468Z 2026-03-18T12:38:35.874Z
9450793 9450793 20260309231854_jyS4I RU0019 2026-03-11T12:00:42.063Z 2026-03-18T12:38:35.847Z
9445814 9445814 20260307220423_Knh3C RU0019 2026-03-09T12:20:54.851Z 2026-03-15T12:42:14.644Z
9445426 9445426 20260307191955_4JDQW RU0019 2026-03-09T12:19:03.263Z 2026-03-15T12:42:08.363Z
9430332 9430332 20260304172645_y5LRe RU0019 2026-03-06T14:22:30.024Z 2026-03-12T12:33:28.674Z
9409228 9409228 20260228021620_n4hLg RU0019 2026-03-01T14:00:58.628Z 2026-03-08T12:41:01.480Z
9381450 9381450 20260222224425_P6BfS RU0019 2026-02-24T14:24:45.895Z 2026-02-24T14:24:45.895Z
9358147 9358147 20260219235738_VK3sV RU0019 2026-02-21T14:17:48.397Z 2026-02-28T14:44:49.484Z
9358145 9358145 20260219235722_N6kXM RU0019 2026-02-21T14:17:47.825Z 2026-02-28T14:44:49.375Z
9358088 9358088 20260219225808_4QC2m RU0019 2026-02-21T14:17:37.457Z 2026-02-28T14:44:48.372Z
9358056 9358056 20260219222929_wMzXp RU0019 2026-02-21T14:17:31.325Z 2026-02-28T14:44:47.846Z
9358028 9358028 20260219215723_FViFq RU0019 2026-02-21T14:17:24.157Z 2026-02-28T14:44:46.750Z
9357836 9357836 20260219201918_8wUwM RU0019 2026-02-21T14:16:59.414Z 2026-02-28T14:44:43.621Z
9352020 9352020 20260220002904_eoqde RU0019 2026-02-21T14:00:12.832Z 2026-03-01T14:21:30.822Z
9319306 9319306 20260212004531_1Rcrf RU0019 2026-02-13T14:22:57.257Z 2026-02-20T14:05:30.298Z
9319286 9319286 20260212001201_vFCgk RU0019 2026-02-13T14:22:51.790Z 2026-02-20T14:05:30.149Z
9319275 9319275 20260211235904_3ds3c RU0019 2026-02-13T14:22:46.037Z 2026-02-20T14:05:30.138Z
9316753 9316753 20260211021553_Dpv51 RU0019 2026-02-12T14:18:58.030Z 2026-02-18T14:58:00.766Z
9316739 9316739 20260211013444_1wLeE RU0019 2026-02-12T14:18:51.206Z 2026-02-18T14:57:59.663Z
9316729 9316729 20260211010653_yt5fC RU0019 2026-02-12T14:18:45.810Z 2026-02-18T14:57:58.861Z
9316716 9316716 20260211001025_R7SgC RU0019 2026-02-12T14:18:42.471Z 2026-02-18T14:57:57.891Z
9316696 9316696 20260210223512_jVQiC RU0019 2026-02-12T14:18:36.102Z 2026-02-18T14:57:54.727Z
9316692 9316692 20260210223303_wFP5v RU0019 2026-02-12T14:18:34.862Z 2026-02-18T14:57:54.399Z
9316654 9316654 20260210162623_T3332 RU0019 2026-02-12T14:18:12.851Z 2026-02-18T14:57:48.508Z
9316652 9316652 20260210155519_MeziM RU0019 2026-02-12T14:18:04.910Z 2026-02-18T14:57:43.902Z
9314003 9314003 20260211025219_9yhN4 RU0019 2026-02-12T14:00:18.643Z 2026-02-20T14:04:58.736Z
9314001 9314001 20260211024937_sjUFr RU0019 2026-02-12T14:00:17.438Z 2026-02-20T14:04:58.734Z
9313865 9313865 20260210024131_a23z6 RU0019 2026-02-11T14:19:10.504Z 2026-02-18T15:02:29.160Z
9313799 9313799 20260210011416_9mWaA RU0019 2026-02-11T14:18:50.727Z 2026-02-18T15:02:25.564Z
9311700 9311700 20260210030200_QPV1V RU0019 2026-02-11T14:00:27.472Z 2026-02-18T14:55:15.790Z
9298225 9298225 20260205223705_ae74M RU0019 2026-02-07T14:22:10.808Z 2026-02-14T15:06:10.206Z
9294279 9294279 20260204182052_2EfTQ RU0019 2026-02-06T14:18:21.764Z 2026-02-13T14:57:04.503Z

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