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,517 rows where station_code = "RU000E" 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
9253005 9253005 20260121224657_d4Kcs RU000E 2026-01-24T14:23:58.639Z 2026-01-29T14:57:11.937Z
9253003 9253003 20260121215928_veYfO RU000E 2026-01-24T14:23:46.466Z 2026-01-29T14:57:06.316Z
9253001 9253001 20260121184009_9As3d RU000E 2026-01-24T14:22:28.979Z 2026-01-29T14:56:10.625Z
9241028 9241028 20260120185121_nfYWL RU000E 2026-01-22T14:11:25.212Z 2026-01-29T15:02:09.764Z
9240668 9240668 20260120172032_NkHqH RU000E 2026-01-22T14:09:26.122Z 2026-01-29T15:01:37.674Z
9240658 9240658 20260120171642_PEBLL RU000E 2026-01-22T14:09:21.441Z 2026-01-29T15:01:37.050Z
9234860 9234860 20260119234314_NSMMt RU000E 2026-01-21T14:16:30.513Z 2026-01-28T14:58:17.648Z
9234852 9234852 20260119234103_ssdqe RU000E 2026-01-21T14:16:29.233Z 2026-01-28T14:58:17.315Z
9207363 9207363 20260115011107_VqY4L RU000E 2026-01-16T14:08:25.534Z 2026-01-22T15:03:19.883Z
9207316 9207316 20260115005338_VBaoC RU000E 2026-01-16T14:08:15.949Z 2026-01-22T15:03:18.556Z
9147832 9147832 20260103163258_7p3ms RU000E 2026-01-05T14:29:47.425Z 2026-01-10T15:03:50.912Z
9147802 9147802 20260103153937_oUy9t RU000E 2026-01-05T14:29:42.092Z 2026-01-10T15:03:45.255Z
9130327 9130327 20260103030753_5Cy14 RU000E 2026-01-04T14:09:34.610Z 2026-01-10T14:59:02.517Z
9130169 9130169 20260103022440_6K1T8 RU000E 2026-01-04T14:08:45.725Z 2026-01-10T14:58:49.351Z
9130146 9130146 20260103021643_OX7N2 RU000E 2026-01-04T14:08:37.966Z 2026-01-10T14:58:47.212Z
9130080 9130080 20260103020101_KVn2c RU000E 2026-01-04T14:08:14.737Z 2026-01-10T14:58:41.589Z
9073847 9073847 20251225183646_23H5U RU000E 2025-12-29T14:59:55.669Z 2026-01-02T15:47:59.112Z
9062092 9062092 20251226014855_DvgNX RU000E 2025-12-29T14:32:44.445Z 2026-01-03T15:34:08.132Z
9059793 9059793 20251225225843_X24K7 RU000E 2025-12-29T14:27:58.626Z 2026-01-03T15:32:19.045Z
9051997 9051997 20251227002541_ZWHnr RU000E 2025-12-29T14:08:41.287Z 2026-01-04T15:25:08.020Z
9051130 9051130 20251226232351_SPE0l RU000E 2025-12-29T14:05:47.454Z 2026-01-04T15:24:17.242Z
9050347 9050347 20251226221533_OFwjJ RU000E 2025-12-29T14:02:48.032Z 2026-01-04T15:23:35.653Z
9023552 9023552 20251220203913_7SR48 RU000E 2025-12-27T15:09:09.832Z 2025-12-29T15:26:20.717Z
9005813 9005813 20251221032306_b33s5 RU000E 2025-12-27T14:35:44.468Z 2025-12-27T14:35:44.468Z
9005739 9005739 20251221025311_nizOk RU000E 2025-12-27T14:35:35.963Z 2025-12-27T14:35:35.963Z
8993968 8993968 20251219000413_ByduB RU000E 2025-12-26T14:53:56.773Z 2025-12-27T15:28:45.790Z
8993703 8993703 20251218232010_lZZ9i RU000E 2025-12-26T14:53:29.359Z 2025-12-27T15:28:08.850Z
8984020 8984020 20251219225218_F7FoS RU000E 2025-12-26T14:30:10.024Z 2025-12-28T15:23:47.018Z
8983949 8983949 20251219224426_Nw9pp RU000E 2025-12-26T14:30:00.959Z 2025-12-28T15:23:45.810Z
8983431 8983431 20251219215033_Imm3M RU000E 2025-12-26T14:29:03.541Z 2025-12-28T15:23:39.131Z
8982806 8982806 20251219203731_dnSm1 RU000E 2025-12-26T14:27:49.616Z 2025-12-28T15:22:16.384Z
8981694 8981694 20251219180711_06p5H RU000E 2025-12-26T14:25:24.068Z 2025-12-27T15:16:30.584Z
8981678 8981678 20251219180530_5lXq1 RU000E 2025-12-26T14:25:21.612Z 2025-12-28T15:21:59.296Z
8976681 8976681 20251219032906_VEtJZ RU000E 2025-12-26T14:10:29.528Z 2025-12-28T15:17:27.306Z
8975365 8975365 20251219010134_0zb12 RU000E 2025-12-26T14:06:46.253Z 2025-12-28T15:16:58.875Z
8975360 8975360 20251219010021_gQdCc RU000E 2025-12-26T14:06:45.474Z 2025-12-28T15:16:57.618Z
8974316 8974316 20251220021821_vrdSS RU000E 2025-12-26T14:04:12.983Z 2025-12-29T15:22:41.122Z
8973884 8973884 20251220014431_1fLYb RU000E 2025-12-26T14:03:16.589Z 2025-12-29T15:22:37.217Z
8973728 8973728 20251220013358_2r2q2 RU000E 2025-12-26T14:02:53.431Z 2025-12-29T15:22:36.054Z
8972844 8972844 20251220003843_soB6W RU000E 2025-12-26T14:00:40.125Z 2025-12-29T15:22:30.186Z
8889059 8889059 20251214014132_5OfIS RU000E 2025-12-22T14:11:35.272Z 2025-12-23T14:27:42.940Z
8870470 8870470 20251214004547_6IMI1 RU000E 2025-12-21T14:10:35.381Z 2025-12-23T14:27:32.374Z
8866624 8866624 20251214001405_MjvRx RU000E 2025-12-21T14:09:59.373Z 2025-12-23T14:27:07.065Z
8866407 8866407 20251214000916_cEirr RU000E 2025-12-21T14:09:57.640Z 2025-12-23T14:27:01.784Z
8865800 8865800 20251213235939_I2Mn2 RU000E 2025-12-21T14:09:53.376Z 2025-12-23T14:26:42.917Z
8865752 8865752 20251213235853_RXrpz RU000E 2025-12-21T14:09:52.976Z 2025-12-23T14:26:42.279Z
8865681 8865681 20251213235714_2DDaU RU000E 2025-12-21T14:09:52.234Z 2025-12-23T14:26:41.183Z
8865111 8865111 20251213234742_FsMPM RU000E 2025-12-21T14:09:47.299Z 2025-12-23T14:26:27.467Z
8864182 8864182 20251213233124_qbXZt RU000E 2025-12-21T14:09:40.743Z 2025-12-23T14:25:55.141Z
8864140 8864140 20251213233041_4PKjr RU000E 2025-12-21T14:09:40.386Z 2025-12-23T14:25:54.818Z
8862827 8862827 20251213230549_ATTEO RU000E 2025-12-21T14:09:02.165Z 2025-12-23T14:25:29.211Z
8862812 8862812 20251213230528_PuOOX RU000E 2025-12-21T14:09:02.088Z 2025-12-23T14:25:29.061Z
8862338 8862338 20251213225318_iX02c RU000E 2025-12-21T14:08:49.738Z 2025-12-23T14:25:23.154Z
8862334 8862334 20251213225303_TU3Yx RU000E 2025-12-21T14:08:49.391Z 2025-12-23T14:25:23.058Z
8859131 8859131 20251213212813_izM92 RU000E 2025-12-21T14:07:01.603Z 2025-12-23T14:25:05.954Z
8790012 8790012 20251213031628_gxRpg RU000E 2025-12-15T14:40:36.278Z 2025-12-21T14:17:38.377Z
8789895 8789895 20251213031525_fBDcq RU000E 2025-12-15T14:40:05.021Z 2025-12-21T14:17:38.352Z
8788447 8788447 20251213025742_oAm02 RU000E 2025-12-15T14:38:49.817Z 2025-12-21T14:17:37.762Z
8786401 8786401 20251213023019_02JoW RU000E 2025-12-15T14:37:34.578Z 2025-12-21T14:17:36.719Z
8752717 8752717 20251209232926_WID8w RU000E 2025-12-13T15:41:01.250Z 2025-12-17T15:27:33.475Z
8752229 8752229 20251209223828_K6Xgh RU000E 2025-12-13T15:40:43.644Z 2025-12-17T15:27:26.829Z
8752084 8752084 20251209222126_e722K RU000E 2025-12-13T15:40:18.520Z 2025-12-17T15:27:25.784Z
8751884 8751884 20251209220102_d5AqE RU000E 2025-12-13T15:39:52.997Z 2025-12-17T15:27:23.780Z
8751792 8751792 20251209215648_vxFP1 RU000E 2025-12-13T15:39:50.881Z 2025-12-17T15:27:23.020Z
8751543 8751543 20251209212254_J0w22 RU000E 2025-12-13T15:39:41.109Z 2025-12-17T15:27:20.261Z
8751489 8751489 20251209211526_e1oaC RU000E 2025-12-13T15:39:39.854Z 2025-12-17T15:27:19.721Z
8750810 8750810 20251209193419_QWoEu RU000E 2025-12-13T15:38:44.234Z 2025-12-17T15:27:10.126Z
8750724 8750724 20251209192014_8NrbM RU000E 2025-12-13T15:38:40.918Z 2025-12-17T15:27:02.100Z
8750246 8750246 20251209175003_9PDoR RU000E 2025-12-13T15:37:52.752Z 2025-12-17T15:26:22.751Z
8750089 8750089 20251209170929_WGBie RU000E 2025-12-13T15:37:32.991Z 2025-12-17T15:26:18.301Z
8749845 8749845 20251209160237_3DZla RU000E 2025-12-13T15:37:00.651Z 2025-12-17T15:26:14.343Z
8737428 8737428 20251212005035_IK0bQ RU000E 2025-12-13T14:59:21.493Z 2025-12-20T14:25:27.230Z
8737350 8737350 20251212004105_9Ci1y RU000E 2025-12-13T14:59:15.495Z 2025-12-20T14:25:26.869Z
8736931 8736931 20251211234409_j70YG RU000E 2025-12-13T14:58:10.549Z 2025-12-20T14:25:24.268Z
8736667 8736667 20251211231128_1MPVS RU000E 2025-12-13T14:57:33.938Z 2025-12-20T14:25:21.859Z
8736535 8736535 20251211225559_Ib82I RU000E 2025-12-13T14:56:59.109Z 2025-12-20T14:25:21.357Z
8736467 8736467 20251211224316_k0wg1 RU000E 2025-12-13T14:56:50.457Z 2025-12-20T14:25:20.990Z
8712168 8712168 20251208205543_wp2Hz RU000E 2025-12-10T14:13:17.597Z 2025-12-17T15:33:32.475Z
8698811 8698811 20251206172757_5FbE3 RU000E 2025-12-08T14:19:02.981Z 2025-12-15T15:29:57.112Z
8698678 8698678 20251206150327_o6Kyi RU000E 2025-12-08T14:18:21.301Z 2025-12-15T15:29:19.127Z
8694223 8694223 20251206020719_NwN8d RU000E 2025-12-07T14:14:00.875Z 2025-12-14T16:07:12.764Z
8694090 8694090 20251205225335_QJmrA RU000E 2025-12-07T14:13:25.679Z 2025-12-14T16:06:53.397Z
8689988 8689988 20251204192656_O0Ox4 RU000E 2025-12-06T14:12:53.324Z 2025-12-13T16:03:38.861Z
8689958 8689958 20251204190621_mfpj2 RU000E 2025-12-06T14:12:46.188Z 2025-12-13T16:03:38.339Z
8689825 8689825 20251204163425_HLI27 RU000E 2025-12-06T14:12:13.226Z 2025-12-13T16:03:35.735Z
8689821 8689821 20251204162040_LeTBv RU000E 2025-12-06T14:12:08.387Z 2025-12-13T16:03:35.601Z
8687088 8687088 20251204032129_ir3bx RU000E 2025-12-05T14:13:51.422Z 2025-12-11T14:42:01.048Z
8687072 8687072 20251204030711_xp3ae RU000E 2025-12-05T14:13:48.810Z 2025-12-11T14:42:00.360Z
8687064 8687064 20251204025835_9v222 RU000E 2025-12-05T14:13:47.120Z 2025-12-11T14:42:00.060Z
8687056 8687056 20251204023418_vXSuU RU000E 2025-12-05T14:13:45.466Z 2025-12-11T14:41:59.827Z
8687052 8687052 20251204022822_a6oV1 RU000E 2025-12-05T14:13:44.585Z 2025-12-11T14:41:59.646Z
8686999 8686999 20251204004128_6lgQ1 RU000E 2025-12-05T14:13:21.536Z 2025-12-11T14:41:57.587Z
8686992 8686992 20251204002423_yKNOr RU000E 2025-12-05T14:13:20.670Z 2025-12-11T14:41:57.300Z
8667655 8667655 20251130030943_qyB4g RU000E 2025-12-02T14:39:37.584Z 2025-12-08T14:55:10.217Z
8667631 8667631 20251130025425_qQbfv RU000E 2025-12-02T14:39:29.720Z 2025-12-08T14:55:06.590Z
8667627 8667627 20251130025321_pDH2X RU000E 2025-12-02T14:39:29.133Z 2025-12-08T14:55:06.441Z
8667606 8667606 20251130024610_VPeDN RU000E 2025-12-02T14:39:25.454Z 2025-12-08T14:55:03.528Z
8667588 8667588 20251130022702_gt1VW RU000E 2025-12-02T14:38:59.755Z 2025-12-08T14:54:59.147Z
8667468 8667468 20251130014442_1jUme RU000E 2025-12-02T14:38:21.924Z 2025-12-08T14:54:43.806Z
8667393 8667393 20251130005655_qEBfp RU000E 2025-12-02T14:37:56.768Z 2025-12-08T14:54:15.838Z

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