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 = "UK009G" 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
8682701 8682701 20251203060028_j3Whj UK009G 2025-12-04T14:17:55.528Z 2025-12-05T14:22:47.999Z
8682594 8682594 20251203054818_rl3eQ UK009G 2025-12-04T14:17:40.188Z 2025-12-05T14:22:44.020Z
8682214 8682214 20251203050246_iIocV UK009G 2025-12-04T14:16:38.383Z 2025-12-05T14:22:18.933Z
8682140 8682140 20251203045452_RaBBZ UK009G 2025-12-04T14:16:29.961Z 2025-12-05T14:22:15.709Z
8682082 8682082 20251203044702_c94mT UK009G 2025-12-04T14:16:22.115Z 2025-12-05T14:22:13.699Z
8680367 8680367 20251202233838_yxAUi UK009G 2025-12-04T14:11:52.432Z 2025-12-05T14:20:35.969Z
8680213 8680213 20251202223051_kgls3 UK009G 2025-12-04T14:11:25.676Z 2025-12-05T14:20:24.164Z
8680210 8680210 20251202223051_FKn4q UK009G 2025-12-04T14:11:25.363Z 2025-12-05T14:20:24.058Z
8680192 8680192 20251202222349_iEo6e UK009G 2025-12-04T14:11:23.954Z 2025-12-05T14:20:23.501Z
8679691 8679691 20251202203953_EUe3a UK009G 2025-12-04T14:10:16.572Z 2025-12-05T14:19:53.941Z
8677047 8677047 20251202064220_Unh26 UK009G 2025-12-03T14:26:13.271Z 2025-12-05T14:29:19.128Z
8676981 8676981 20251202063619_F3JS8 UK009G 2025-12-03T14:25:59.174Z 2025-12-05T14:29:17.374Z
8676754 8676754 20251202062049_J6dUj UK009G 2025-12-03T14:25:32.615Z 2025-12-05T14:29:12.495Z
8676469 8676469 20251202055341_ruDut UK009G 2025-12-03T14:25:13.513Z 2025-12-05T14:28:56.872Z
8676330 8676330 20251202054713_jIsPp UK009G 2025-12-03T14:25:06.643Z 2025-12-05T14:28:54.549Z
8676265 8676265 20251202054246_u2aGA UK009G 2025-12-03T14:24:52.128Z 2025-12-05T14:28:51.124Z
8676053 8676053 20251202053410_JoXh5 UK009G 2025-12-03T14:24:38.312Z 2025-12-05T14:28:47.152Z
8676039 8676039 20251202053352_VIO33 UK009G 2025-12-03T14:24:37.831Z 2025-12-05T14:28:46.960Z
8676033 8676033 20251202053346_SH1c8 UK009G 2025-12-03T14:24:37.479Z 2025-12-05T14:28:46.821Z
8675943 8675943 20251202052534_V539f UK009G 2025-12-03T14:24:32.299Z 2025-12-05T14:28:44.827Z
8675592 8675592 20251202045910_IXOSp UK009G 2025-12-03T14:23:53.989Z 2025-12-05T14:28:36.515Z
8675465 8675465 20251202044357_Kx77Z UK009G 2025-12-03T14:23:45.215Z 2025-12-05T14:28:32.752Z
8675216 8675216 20251202041801_1TvKz UK009G 2025-12-03T14:23:21.465Z 2025-12-05T14:28:17.003Z
8675207 8675207 20251202041758_3s3pA UK009G 2025-12-03T14:23:20.656Z 2025-12-05T14:28:16.802Z
8658104 8658104 20251130063823_OCP6r UK009G 2025-12-01T14:34:55.034Z 2025-12-05T14:46:02.323Z
8658091 8658091 20251130063643_VAtuD UK009G 2025-12-01T14:34:54.056Z 2025-12-05T14:46:02.039Z
8658057 8658057 20251130063254_ISE9l UK009G 2025-12-01T14:34:53.076Z 2025-12-05T14:46:01.583Z
8657958 8657958 20251130062207_DRvvX UK009G 2025-12-01T14:34:47.456Z 2025-12-05T14:45:59.260Z
8657843 8657843 20251130061122_kvhIi UK009G 2025-12-01T14:34:42.882Z 2025-12-05T14:45:42.237Z
8657435 8657435 20251130054522_D8Im5 UK009G 2025-12-01T14:34:26.053Z 2025-12-05T14:45:30.113Z
8657398 8657398 20251130054122_ygds5 UK009G 2025-12-01T14:34:22.022Z 2025-12-05T14:45:29.283Z
8657344 8657344 20251130053946_Tq5TP UK009G 2025-12-01T14:34:07.577Z 2025-12-05T14:45:28.409Z
8657310 8657310 20251130053829_nOJs2 UK009G 2025-12-01T14:34:04.096Z 2025-12-05T14:45:28.098Z
8657198 8657198 20251130053332_Eb2AW UK009G 2025-12-01T14:34:00.336Z 2025-12-05T14:45:26.665Z
8657012 8657012 20251130052408_RUpO5 UK009G 2025-12-01T14:33:51.846Z 2025-12-05T14:45:24.545Z
8656926 8656926 20251130051818_GEpgT UK009G 2025-12-01T14:33:49.195Z 2025-12-05T14:45:23.290Z
8656862 8656862 20251130051453_AeqmQ UK009G 2025-12-01T14:33:47.123Z 2025-12-05T14:45:22.544Z
8656669 8656669 20251130050557_M6v3F UK009G 2025-12-01T14:28:53.505Z 2025-12-05T14:45:19.766Z
8656241 8656241 20251130044514_ngvLX UK009G 2025-12-01T14:28:13.088Z 2025-12-01T14:28:13.088Z
8655535 8655535 20251130040641_WGfTZ UK009G 2025-12-01T14:27:02.468Z 2025-12-05T14:44:35.004Z
8655434 8655434 20251130040215_I95H7 UK009G 2025-12-01T14:26:53.856Z 2025-12-05T14:44:33.611Z
8655220 8655220 20251130034916_Tx8xv UK009G 2025-12-01T14:26:39.797Z 2025-12-05T14:44:29.903Z
8655122 8655122 20251130034514_3lwWx UK009G 2025-12-01T14:26:24.055Z 2025-12-05T14:44:28.100Z
8655023 8655023 20251130034109_FqO69 UK009G 2025-12-01T14:26:16.337Z 2025-12-05T14:44:26.922Z
8655010 8655010 20251130034107_Lz1dP UK009G 2025-12-01T14:26:15.888Z 2025-12-05T14:44:26.808Z
8654743 8654743 20251130033016_kD0nF UK009G 2025-12-01T14:25:57.362Z 2025-12-05T14:44:22.706Z
8654654 8654654 20251130032444_VbTDs UK009G 2025-12-01T14:25:40.688Z 2025-12-05T14:44:19.882Z
8654358 8654358 20251130031218_pGtiW UK009G 2025-12-01T14:25:11.337Z 2025-12-05T14:43:54.226Z
8654069 8654069 20251130025552_L2iKl UK009G 2025-12-01T14:24:48.352Z 2025-12-05T14:43:45.985Z
8651780 8651780 20251130001756_3yTNn UK009G 2025-12-01T14:19:52.385Z 2025-12-05T14:42:05.845Z
8651773 8651773 20251130001756_Vdyva UK009G 2025-12-01T14:19:51.998Z 2025-12-05T14:42:05.661Z
8651436 8651436 20251129234156_XcS3w UK009G 2025-12-01T14:19:07.301Z 2025-12-05T14:41:57.861Z
8651143 8651143 20251129224750_LeNV8 UK009G 2025-12-01T14:18:07.167Z 2025-12-05T14:41:50.068Z
8651092 8651092 20251129224047_GQ1jf UK009G 2025-12-01T14:17:59.429Z 2025-12-05T14:41:48.713Z
8651061 8651061 20251129223706_CWmuF UK009G 2025-12-01T14:17:55.841Z 2025-12-05T14:41:48.091Z
8650993 8650993 20251129222245_B4khd UK009G 2025-12-01T14:17:44.684Z 2025-12-01T14:35:21.449Z
8650951 8650951 20251129221105_8AxUw UK009G 2025-12-01T14:17:36.338Z 2025-12-05T14:41:23.381Z
8650903 8650903 20251129220028_yGl4v UK009G 2025-12-01T14:17:29.679Z 2025-12-05T14:41:22.240Z
8650854 8650854 20251129214109_NhG0M UK009G 2025-12-01T14:17:18.536Z 2025-12-05T14:41:20.912Z
8650805 8650805 20251129213347_67EGO UK009G 2025-12-01T14:17:12.563Z 2025-12-05T14:41:17.977Z
8650772 8650772 20251129212357_nId2x UK009G 2025-12-01T14:17:07.493Z 2025-12-05T14:41:16.772Z
8650702 8650702 20251129211154_Q4kBC UK009G 2025-12-01T14:17:00.172Z 2025-12-05T14:41:15.122Z
8650618 8650618 20251129205122_Ry1Ok UK009G 2025-12-01T14:16:43.447Z 2025-12-05T14:41:12.317Z
8650566 8650566 20251129204119_ZnC7J UK009G 2025-12-01T14:16:28.898Z 2025-12-05T14:41:10.849Z
8650554 8650554 20251129204113_amqYp UK009G 2025-12-01T14:16:28.225Z 2025-12-05T14:41:10.736Z
8650491 8650491 20251129203132_zvKTS UK009G 2025-12-01T14:16:19.149Z 2025-12-05T14:41:08.823Z
8650466 8650466 20251129202513_942aj UK009G 2025-12-01T14:16:16.291Z 2025-12-05T14:41:08.461Z
8650346 8650346 20251129195746_0niLL UK009G 2025-12-01T14:15:51.825Z 2025-12-05T14:41:04.545Z
8650142 8650142 20251129192858_F0TFJ UK009G 2025-12-01T14:15:13.784Z 2025-12-05T14:40:57.490Z
8650129 8650129 20251129192835_3abtN UK009G 2025-12-01T14:15:08.605Z 2025-12-05T14:40:57.235Z
8646229 8646229 20251129012801_ARqUb UK009G 2025-11-30T14:25:30.511Z 2025-12-05T14:51:36.414Z
8643885 8643885 20251128183543_HIFuH UK009G 2025-11-30T14:20:46.908Z 2025-12-05T14:49:58.294Z
8643434 8643434 20251128175527_TyO7q UK009G 2025-11-30T14:20:01.472Z 2025-12-05T14:49:17.870Z
8643311 8643311 20251128174257_wg7i4 UK009G 2025-11-30T14:19:52.907Z 2025-12-05T14:49:15.501Z
8637586 8637586 20251128055558_H61gU UK009G 2025-11-29T14:27:36.175Z 2025-12-05T15:00:05.820Z
8637287 8637287 20251128052524_wBc37 UK009G 2025-11-29T14:27:03.044Z 2025-12-05T14:59:39.851Z
8635679 8635679 20251128023715_QKJUo UK009G 2025-11-29T14:24:00.416Z 2025-12-05T14:59:13.063Z
8635641 8635641 20251128023423_8F4ca UK009G 2025-11-29T14:23:58.182Z 2025-12-05T14:59:12.463Z
8635334 8635334 20251128020416_QNk0Z UK009G 2025-11-29T14:23:03.982Z 2025-12-05T14:58:34.167Z
8634709 8634709 20251128011113_g8ON2 UK009G 2025-11-29T14:21:57.595Z 2025-12-05T14:58:23.908Z
8634572 8634572 20251128005951_c1TOJ UK009G 2025-11-29T14:21:34.446Z 2025-12-05T14:58:22.253Z
8634536 8634536 20251128005545_C2UPK UK009G 2025-11-29T14:21:30.716Z 2025-12-05T14:58:21.582Z
8634447 8634447 20251128005118_qbS39 UK009G 2025-11-29T14:21:22.050Z 2025-12-05T14:58:20.829Z
8634351 8634351 20251128004133_5vxQ3 UK009G 2025-11-29T14:21:14.540Z 2025-12-05T14:58:19.489Z
8634184 8634184 20251128002945_eRnL2 UK009G 2025-11-29T14:20:52.551Z 2025-12-05T14:58:17.184Z
8634129 8634129 20251128002302_SL3a4 UK009G 2025-11-29T14:20:48.161Z 2025-12-05T14:58:16.632Z
8633802 8633802 20251127235555_7Qcng UK009G 2025-11-29T14:20:24.029Z 2025-12-05T14:57:59.111Z
8633529 8633529 20251127233002_eSqpX UK009G 2025-11-29T14:19:50.875Z 2025-12-05T14:57:44.716Z
8616376 8616376 20251126055414_THab2 UK009G 2025-11-27T14:31:07.710Z 2025-12-04T15:11:38.550Z
8616105 8616105 20251126053915_evORd UK009G 2025-11-27T14:30:31.055Z 2025-12-04T15:11:35.753Z
8616000 8616000 20251126053127_ddSVN UK009G 2025-11-27T14:30:20.761Z 2025-12-04T15:11:34.439Z
8615694 8615694 20251126051305_9eqfH UK009G 2025-11-27T14:30:05.446Z 2025-12-04T15:11:31.279Z
8615566 8615566 20251126050938_sFyVH UK009G 2025-11-27T14:29:41.124Z 2025-12-04T15:11:30.339Z
8615484 8615484 20251126050451_h3xiS UK009G 2025-11-27T14:29:35.805Z 2025-12-04T15:11:29.339Z
8615392 8615392 20251126050139_moQK8 UK009G 2025-11-27T14:29:29.991Z 2025-12-04T15:11:28.299Z
8615373 8615373 20251126050051_iOx22 UK009G 2025-11-27T14:29:29.300Z 2025-12-04T15:11:28.199Z
8615331 8615331 20251126045704_d4qFL UK009G 2025-11-27T14:29:27.808Z 2025-12-04T15:11:27.944Z
8615008 8615008 20251126044146_7q56z UK009G 2025-11-27T14:28:53.485Z 2025-12-04T15:11:25.187Z
8614893 8614893 20251126043436_7j4Es UK009G 2025-11-27T14:28:41.554Z 2025-12-04T15:11:17.759Z
8614785 8614785 20251126042721_0fn3j UK009G 2025-11-27T14:28:33.005Z 2025-12-04T15:11:08.300Z

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