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

2,358 rows where station_code = "RU0017" 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
9519225 9519225 20260319015437_bzX8I RU0017 2026-03-20T12:04:07.030Z 2026-03-27T12:40:19.150Z
9518523 9518523 20260319010626_OR2uT RU0017 2026-03-20T12:02:45.910Z 2026-03-27T12:40:11.134Z
9518349 9518349 20260319005242_RVcOm RU0017 2026-03-20T12:02:20.986Z 2026-03-27T12:40:08.638Z
9474241 9474241 20260312215349_5AfMy RU0017 2026-03-14T12:22:22.357Z 2026-03-20T12:37:16.946Z
9474151 9474151 20260312210826_Cm71D RU0017 2026-03-14T12:22:11.793Z 2026-03-20T12:37:16.387Z
9474074 9474074 20260312201729_T53dI RU0017 2026-03-14T12:21:54.981Z 2026-03-20T12:37:15.498Z
9474018 9474018 20260312192801_aVjlL RU0017 2026-03-14T12:21:44.756Z 2026-03-20T12:37:14.641Z
9473959 9473959 20260312182313_SHSZW RU0017 2026-03-14T12:21:30.660Z 2026-03-20T12:37:13.593Z
9473936 9473936 20260312171150_YptkO RU0017 2026-03-14T12:21:13.161Z 2026-03-20T12:37:12.416Z
9469006 9469006 20260313013049_Orvae RU0017 2026-03-14T12:02:38.608Z 2026-03-21T12:48:32.500Z
9468954 9468954 20260313012307_P9ncq RU0017 2026-03-14T12:02:26.120Z 2026-03-21T12:48:31.851Z
9468657 9468657 20260313000728_QiI8z RU0017 2026-03-14T12:01:13.380Z 2026-03-21T12:48:27.539Z
9468500 9468500 20260312230409_p2n95 RU0017 2026-03-14T12:00:25.160Z 2026-03-21T12:48:25.311Z
9467705 9467705 20260311223533_vvnnS RU0017 2026-03-13T12:19:42.705Z 2026-03-19T12:45:54.367Z
9467459 9467459 20260311214813_DBmcJ RU0017 2026-03-13T12:19:16.174Z 2026-03-19T12:45:52.458Z
9467148 9467148 20260311202246_F2Jc9 RU0017 2026-03-13T12:18:31.858Z 2026-03-19T12:45:49.270Z
9463551 9463551 20260312020624_v8n84 RU0017 2026-03-13T12:04:29.911Z 2026-03-20T12:36:23.288Z
9463451 9463451 20260312015058_8S2yZ RU0017 2026-03-13T12:04:12.053Z 2026-03-20T12:36:22.611Z
9463336 9463336 20260312013342_3Ux0V RU0017 2026-03-13T12:03:53.056Z 2026-03-20T12:36:22.001Z
9463317 9463317 20260312013104_cnt2G RU0017 2026-03-13T12:03:49.612Z 2026-03-20T12:36:21.864Z
9463111 9463111 20260312010435_I7Zf3 RU0017 2026-03-13T12:03:09.798Z 2026-03-20T12:36:19.783Z
9462798 9462798 20260312001415_Qhcz3 RU0017 2026-03-13T12:02:10.030Z 2026-03-20T12:36:18.085Z
9462464 9462464 20260311232133_aVhI3 RU0017 2026-03-13T12:01:05.039Z 2026-03-20T12:36:16.140Z
9462369 9462369 20260311230408_GlD9L RU0017 2026-03-13T12:00:44.055Z 2026-03-20T12:36:15.515Z
9446056 9446056 20260308233604_v7lNf RU0017 2026-03-10T12:00:46.917Z 2026-03-17T12:41:19.875Z
9394054 9394054 20260224164347_Rkzts RU0017 2026-02-26T14:17:44.225Z 2026-03-04T14:19:09.002Z
9322097 9322097 20260212020956_U5YCm RU0017 2026-02-14T14:29:31.083Z 2026-02-20T14:05:30.694Z
9322092 9322092 20260212003937_5hbXu RU0017 2026-02-14T14:29:16.383Z 2026-02-20T14:05:30.229Z
9322090 9322090 20260211235141_JLaXz RU0017 2026-02-14T14:29:09.819Z 2026-02-20T14:05:30.126Z
9294672 9294672 20260205021618_yb2aB RU0017 2026-02-06T14:20:41.910Z 2026-02-13T14:57:58.030Z
9294653 9294653 20260205013102_bMnsl RU0017 2026-02-06T14:20:35.217Z 2026-02-13T14:57:56.133Z
9294622 9294622 20260204231443_0Dnas RU0017 2026-02-06T14:20:27.960Z 2026-02-13T14:57:53.183Z
9294308 9294308 20260204183737_hYvSw RU0017 2026-02-06T14:18:31.713Z 2026-02-13T14:57:07.671Z
9294238 9294238 20260204174414_p3BWm RU0017 2026-02-06T14:18:05.735Z 2026-02-13T14:57:00.686Z
9277790 9277790 20260129015829_0uotO RU0017 2026-01-30T14:23:11.363Z 2026-02-06T14:48:04.517Z
9277687 9277687 20260129002222_tWpWk RU0017 2026-01-30T14:22:46.928Z 2026-02-06T14:47:51.235Z
9277598 9277598 20260128231713_Aiw3b RU0017 2026-01-30T14:22:32.609Z 2026-02-06T14:47:46.722Z
9277558 9277558 20260128225034_yu7PG RU0017 2026-01-30T14:22:22.992Z 2026-02-06T14:47:44.641Z
9277461 9277461 20260128214952_QjTIw RU0017 2026-01-30T14:22:07.130Z 2026-02-06T14:47:39.947Z
9277161 9277161 20260128184647_ks6ha RU0017 2026-01-30T14:19:40.025Z 2026-02-06T14:46:45.688Z
9253006 9253006 20260121224657_d4Kcs RU0017 2026-01-24T14:23:58.639Z 2026-01-30T14:54:22.749Z
9253004 9253004 20260121215928_veYfO RU0017 2026-01-24T14:23:46.466Z 2026-01-30T14:54:17.720Z
9253002 9253002 20260121184009_9As3d RU0017 2026-01-24T14:22:29.011Z 2026-01-30T14:53:32.308Z
9248294 9248294 20260121224811_cfObw RU0017 2026-01-23T14:12:25.511Z 2026-01-30T14:54:22.946Z
9248264 9248264 20260121224011_nll5c RU0017 2026-01-23T14:12:21.978Z 2026-01-30T14:54:21.871Z
9248239 9248239 20260121222801_3zSF5 RU0017 2026-01-23T14:12:18.223Z 2026-01-30T14:54:20.765Z
9247816 9247816 20260121195914_fDHcJ RU0017 2026-01-23T14:11:11.768Z 2026-01-30T14:53:49.551Z
9247694 9247694 20260121192916_duQz2 RU0017 2026-01-23T14:10:48.886Z 2026-01-30T14:53:42.345Z
9246993 9246993 20260121160951_F8Iab RU0017 2026-01-23T14:08:41.405Z 2026-01-30T14:52:56.166Z
9241029 9241029 20260120185121_nfYWL RU0017 2026-01-22T14:11:25.212Z 2026-01-29T15:02:09.764Z
9240669 9240669 20260120172032_NkHqH RU0017 2026-01-22T14:09:26.122Z 2026-01-29T15:01:37.674Z
9240659 9240659 20260120171642_PEBLL RU0017 2026-01-22T14:09:21.462Z 2026-01-29T15:01:37.050Z
9234861 9234861 20260119234314_NSMMt RU0017 2026-01-21T14:16:30.513Z 2026-01-28T14:58:17.648Z
9234853 9234853 20260119234103_ssdqe RU0017 2026-01-21T14:16:29.245Z 2026-01-28T14:58:17.316Z
9234025 9234025 20260119191925_wXCRD RU0017 2026-01-21T14:11:55.713Z 2026-01-28T14:56:59.587Z
9230115 9230115 20260119032808_mqwOC RU0017 2026-01-20T14:26:02.276Z 2026-01-27T15:04:26.167Z
9229915 9229915 20260119025600_GY0Jh RU0017 2026-01-20T14:24:59.203Z 2026-01-27T15:04:14.670Z
9207628 9207628 20260115023153_y0XIO RU0017 2026-01-16T14:09:26.540Z 2026-01-22T15:03:28.284Z
9207364 9207364 20260115011107_VqY4L RU0017 2026-01-16T14:08:25.534Z 2026-01-22T15:03:19.883Z
9207317 9207317 20260115005338_VBaoC RU0017 2026-01-16T14:08:15.961Z 2026-01-22T15:03:18.556Z
9207264 9207264 20260115002831_aJqXJ RU0017 2026-01-16T14:08:01.024Z 2026-01-22T15:03:16.758Z
9207186 9207186 20260114233127_3HiUA RU0017 2026-01-16T14:07:34.697Z 2026-01-22T15:03:13.900Z
9207122 9207122 20260114222201_e7UrR RU0017 2026-01-16T14:07:13.833Z 2026-01-22T15:03:11.227Z
9162489 9162489 20260107030602_M6y6n RU0017 2026-01-08T14:05:28.926Z 2026-01-13T15:02:13.831Z
9162471 9162471 20260107030233_JQD0Z RU0017 2026-01-08T14:05:23.431Z 2026-01-13T15:02:12.307Z
9162442 9162442 20260107025136_e5UTe RU0017 2026-01-08T14:05:10.249Z 2026-01-13T15:02:10.158Z
9162323 9162323 20260107015756_pUUrS RU0017 2026-01-08T14:04:32.185Z 2026-01-13T15:02:01.348Z
9162297 9162297 20260107014419_lg5qB RU0017 2026-01-08T14:04:21.776Z 2026-01-13T15:01:59.489Z
9162265 9162265 20260107012238_wGkQ4 RU0017 2026-01-08T14:04:04.334Z 2026-01-13T15:01:57.117Z
9157480 9157480 20260105172454_E6355 RU0017 2026-01-07T14:02:12.148Z 2026-01-13T15:06:05.381Z
9147833 9147833 20260103163258_7p3ms RU0017 2026-01-05T14:29:47.425Z 2026-01-10T15:03:50.912Z
9147803 9147803 20260103153937_oUy9t RU0017 2026-01-05T14:29:42.111Z 2026-01-10T15:03:45.255Z
9147801 9147801 20260103152458_SEdSi RU0017 2026-01-05T14:29:40.196Z 2026-01-10T15:03:43.856Z
9130328 9130328 20260103030753_5Cy14 RU0017 2026-01-04T14:09:34.610Z 2026-01-10T14:59:02.517Z
9130170 9130170 20260103022440_6K1T8 RU0017 2026-01-04T14:08:45.725Z 2026-01-10T14:58:49.351Z
9130147 9130147 20260103021643_OX7N2 RU0017 2026-01-04T14:08:37.966Z 2026-01-10T14:58:47.212Z
9130136 9130136 20260103021227_aHGLI RU0017 2026-01-04T14:08:34.312Z 2026-01-10T14:58:45.386Z
9130081 9130081 20260103020101_KVn2c RU0017 2026-01-04T14:08:14.767Z 2026-01-10T14:58:41.589Z
9129801 9129801 20260103004851_kZu8W RU0017 2026-01-04T14:06:27.912Z 2026-01-10T14:58:16.880Z
9074046 9074046 20251225190534_c3lR3 RU0017 2025-12-29T15:00:03.633Z 2026-01-02T15:48:06.293Z
9073958 9073958 20251225185330_6h3iN RU0017 2025-12-29T15:00:00.132Z 2026-01-02T15:48:01.781Z
9073848 9073848 20251225183646_23H5U RU0017 2025-12-29T14:59:55.669Z 2026-01-02T15:47:59.112Z
9073102 9073102 20251225163616_RZE2l RU0017 2025-12-29T14:59:01.346Z 2026-01-02T15:47:44.994Z
9073051 9073051 20251225160106_LUjvK RU0017 2025-12-29T14:58:59.007Z 2026-01-02T15:47:43.672Z
9062093 9062093 20251226014855_DvgNX RU0017 2025-12-29T14:32:44.445Z 2026-01-03T15:34:08.132Z
9061052 9061052 20251226002802_X1YFE RU0017 2025-12-29T14:30:28.884Z 2026-01-03T15:33:25.149Z
9060116 9060116 20251225232756_Coubw RU0017 2025-12-29T14:28:55.202Z 2026-01-03T15:32:35.018Z
9059942 9059942 20251225231103_4p0xC RU0017 2025-12-29T14:28:28.019Z 2026-01-03T15:32:28.550Z
9059794 9059794 20251225225843_X24K7 RU0017 2025-12-29T14:27:58.626Z 2026-01-03T15:32:19.045Z
9051998 9051998 20251227002541_ZWHnr RU0017 2025-12-29T14:08:41.287Z 2026-01-04T15:25:08.020Z
9051131 9051131 20251226232351_SPE0l RU0017 2025-12-29T14:05:47.454Z 2026-01-04T15:24:17.253Z
9050573 9050573 20251226223816_OB1iV RU0017 2025-12-29T14:03:48.658Z 2026-01-04T15:23:45.709Z
9050465 9050465 20251226222715_twvjN RU0017 2025-12-29T14:03:17.949Z 2026-01-04T15:23:40.388Z
9050348 9050348 20251226221533_OFwjJ RU0017 2025-12-29T14:02:48.085Z 2026-01-04T15:23:35.653Z
9023916 9023916 20251220231959_wEGGK RU0017 2025-12-27T15:10:14.696Z 2025-12-27T15:10:14.696Z
9023861 9023861 20251220224900_H9j2G RU0017 2025-12-27T15:10:00.819Z 2025-12-29T15:26:23.730Z
9023817 9023817 20251220222313_Dy7ZZ RU0017 2025-12-27T15:09:50.771Z 2025-12-29T15:26:23.161Z
9023813 9023813 20251220222241_4L22p RU0017 2025-12-27T15:09:46.408Z 2025-12-29T15:26:23.091Z
9023805 9023805 20251220222024_s6CDk RU0017 2025-12-27T15:09:45.047Z 2025-12-29T15:26:22.964Z
9023788 9023788 20251220221442_JvN2I RU0017 2025-12-27T15:09:42.431Z 2025-12-29T15:26:22.756Z

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