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 = "UK001L" 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
8683124 8683124 20251203062811_RdLIS UK001L 2025-12-04T14:18:35.382Z 2025-12-05T14:23:08.127Z
8683110 8683110 20251203062758_iS9Fv UK001L 2025-12-04T14:18:35.016Z 2025-12-05T14:23:07.935Z
8682994 8682994 20251203061840_vjAu6 UK001L 2025-12-04T14:18:26.442Z 2025-12-05T14:23:04.763Z
8682898 8682898 20251203061549_VkLiS UK001L 2025-12-04T14:18:18.553Z 2025-12-05T14:22:56.106Z
8682681 8682681 20251203055818_aI80l UK001L 2025-12-04T14:17:53.938Z 2025-12-05T14:22:47.503Z
8680108 8680108 20251202214107_8tqR9 UK001L 2025-12-04T14:11:07.114Z 2025-12-05T14:20:17.820Z
8680099 8680099 20251202213446_ifQ7y UK001L 2025-12-04T14:11:03.684Z 2025-12-05T14:20:17.136Z
8680052 8680052 20251202212803_Czu3X UK001L 2025-12-04T14:10:59.676Z 2025-12-05T14:20:15.579Z
8680019 8680019 20251202211719_s2wEu UK001L 2025-12-04T14:10:54.555Z 2025-12-05T14:20:13.709Z
8679972 8679972 20251202211301_tqBsS UK001L 2025-12-04T14:10:49.817Z 2025-12-05T14:20:11.764Z
8679960 8679960 20251202211301_Pndr2 UK001L 2025-12-04T14:10:49.384Z 2025-12-05T14:20:11.558Z
8679907 8679907 20251202210746_YONYx UK001L 2025-12-04T14:10:45.362Z 2025-12-05T14:20:10.180Z
8676935 8676935 20251202063126_hh3Xs UK001L 2025-12-03T14:25:56.698Z 2025-12-05T14:29:16.357Z
8676921 8676921 20251202063108_mb3Ug UK001L 2025-12-03T14:25:56.392Z 2025-12-05T14:29:16.273Z
8676844 8676844 20251202062759_i9Ph2 UK001L 2025-12-03T14:25:52.815Z 2025-12-05T14:29:14.703Z
8676738 8676738 20251202062030_g0RX2 UK001L 2025-12-03T14:25:32.283Z 2025-12-05T14:29:12.354Z
8676673 8676673 20251202061146_hjmEM UK001L 2025-12-03T14:25:25.849Z 2025-12-05T14:29:10.563Z
8676341 8676341 20251202054739_2BFSM UK001L 2025-12-03T14:25:07.293Z 2025-12-05T14:28:54.786Z
8676162 8676162 20251202053942_XoT3u UK001L 2025-12-03T14:24:47.968Z 2025-12-05T14:28:49.808Z
8674085 8674085 20251202012803_dtxbC UK001L 2025-12-03T14:20:55.738Z 2025-12-05T14:27:28.593Z
8674073 8674073 20251202012433_yq36s UK001L 2025-12-03T14:20:54.823Z 2025-12-05T14:27:28.361Z
8662843 8662843 20251130193908_85Fw2 UK001L 2025-12-02T14:16:50.692Z 2025-12-05T14:33:49.908Z
8658468 8658468 20251126000515_PDd8W UK001L 2025-12-01T15:02:16.273Z 2025-12-04T15:07:57.339Z
8657972 8657972 20251130062416_HXXzu UK001L 2025-12-01T14:34:48.656Z 2025-12-05T14:45:59.878Z
8657881 8657881 20251130061417_O8PyF UK001L 2025-12-01T14:34:44.661Z 2025-12-05T14:45:52.326Z
8657782 8657782 20251130060814_vc7zj UK001L 2025-12-01T14:34:41.120Z 2025-12-05T14:45:36.730Z
8657737 8657737 20251130060420_J1Vss UK001L 2025-12-01T14:34:39.618Z 2025-12-05T14:45:36.278Z
8657368 8657368 20251130054052_cl2tE UK001L 2025-12-01T14:34:18.798Z 2025-12-05T14:45:28.885Z
8657337 8657337 20251130053946_Tq5TP UK001L 2025-12-01T14:34:07.576Z 2025-12-05T14:45:28.409Z
8657262 8657262 20251130053750_du4EE UK001L 2025-12-01T14:34:02.932Z 2025-12-05T14:45:27.696Z
8656767 8656767 20251130050920_oDi0z UK001L 2025-12-01T14:28:59.865Z 2025-12-05T14:45:21.023Z
8656741 8656741 20251130050820_tcZTv UK001L 2025-12-01T14:28:59.153Z 2025-12-05T14:45:20.527Z
8656684 8656684 20251130050602_PkhPV UK001L 2025-12-01T14:28:54.117Z 2025-12-05T14:45:19.994Z
8656590 8656590 20251130050049_v70Ll UK001L 2025-12-01T14:28:46.613Z 2025-12-05T14:45:18.175Z
8656203 8656203 20251130044349_H96M9 UK001L 2025-12-01T14:28:10.677Z 2025-12-05T14:44:47.962Z
8656146 8656146 20251130044007_nc34g UK001L 2025-12-01T14:28:06.758Z 2025-12-05T14:44:46.798Z
8655932 8655932 20251130042541_Zo7Ss UK001L 2025-12-01T14:27:41.515Z 2025-12-05T14:44:41.278Z
8655864 8655864 20251130042122_4iK7M UK001L 2025-12-01T14:27:33.669Z 2025-12-05T14:44:40.185Z
8655839 8655839 20251130042046_TKwdn UK001L 2025-12-01T14:27:32.709Z 2025-12-05T14:44:39.931Z
8655827 8655827 20251130042032_6po1V UK001L 2025-12-01T14:27:31.976Z 2025-12-05T14:44:39.710Z
8655808 8655808 20251130041955_OHKix UK001L 2025-12-01T14:27:31.201Z 2025-12-05T14:44:39.447Z
8655699 8655699 20251130041158_vrx7E UK001L 2025-12-01T14:27:21.691Z 2025-12-05T14:44:37.255Z
8655591 8655591 20251130040815_GqLlJ UK001L 2025-12-01T14:27:15.360Z 2025-12-05T14:44:36.044Z
8655577 8655577 20251130040801_k1Ebi UK001L 2025-12-01T14:27:11.633Z 2025-12-05T14:44:35.800Z
8655539 8655539 20251130040648_Wzx2z UK001L 2025-12-01T14:27:02.794Z 2025-12-05T14:44:35.174Z
8655517 8655517 20251130040628_6jytl UK001L 2025-12-01T14:27:02.137Z 2025-12-05T14:44:34.902Z
8655438 8655438 20251130040216_pg5fn UK001L 2025-12-01T14:26:54.316Z 2025-12-05T14:44:33.693Z
8655181 8655181 20251130034811_k6b52 UK001L 2025-12-01T14:26:37.496Z 2025-12-05T14:44:29.460Z
8654962 8654962 20251130033957_fpa8l UK001L 2025-12-01T14:26:13.537Z 2025-12-05T14:44:26.484Z
8654930 8654930 20251130033844_ZvoEJ UK001L 2025-12-01T14:26:11.181Z 2025-12-05T14:44:25.990Z
8654659 8654659 20251130032455_hrwcX UK001L 2025-12-01T14:25:42.516Z 2025-12-05T14:44:19.991Z
8654617 8654617 20251130032306_ZD4zb UK001L 2025-12-01T14:25:38.121Z 2025-12-05T14:44:15.781Z
8654566 8654566 20251130032031_09TIJ UK001L 2025-12-01T14:25:35.074Z 2025-12-05T14:44:12.321Z
8654449 8654449 20251130031725_N2xbm UK001L 2025-12-01T14:25:26.679Z 2025-12-05T14:43:59.529Z
8654192 8654192 20251130030237_TlqLz UK001L 2025-12-01T14:24:57.176Z 2025-12-05T14:43:48.627Z
8654179 8654179 20251130030236_i5D2b UK001L 2025-12-01T14:24:56.912Z 2025-12-05T14:43:48.584Z
8654142 8654142 20251130030122_P3pIF UK001L 2025-12-01T14:24:54.890Z 2025-12-05T14:43:47.950Z
8653930 8653930 20251130024833_7iCgP UK001L 2025-12-01T14:24:30.500Z 2025-12-05T14:43:42.914Z
8653856 8653856 20251130024435_wGaoB UK001L 2025-12-01T14:24:23.488Z 2025-12-05T14:43:41.703Z
8653690 8653690 20251130023510_Lfvs4 UK001L 2025-12-01T14:23:56.411Z 2025-12-05T14:43:37.745Z
8653684 8653684 20251130023414_qqJ7K UK001L 2025-12-01T14:23:55.942Z 2025-12-05T14:43:37.647Z
8653645 8653645 20251130023317_5nbeo UK001L 2025-12-01T14:23:54.015Z 2025-12-05T14:43:37.108Z
8653443 8653443 20251130021628_PTnyP UK001L 2025-12-01T14:23:32.077Z 2025-12-05T14:43:31.680Z
8653270 8653270 20251130020509_Ufqfg UK001L 2025-12-01T14:23:08.572Z 2025-12-05T14:43:06.958Z
8653222 8653222 20251130020355_yr6i0 UK001L 2025-12-01T14:23:06.370Z 2025-12-05T14:43:05.977Z
8653148 8653148 20251130020029_s2Wup UK001L 2025-12-01T14:22:56.828Z 2025-12-05T14:43:04.669Z
8652763 8652763 20251130013220_0Jyfw UK001L 2025-12-01T14:22:06.351Z 2025-12-05T14:42:52.007Z
8652724 8652724 20251130012853_kP2d2 UK001L 2025-12-01T14:22:02.118Z 2025-12-05T14:42:50.872Z
8652668 8652668 20251130012638_rz8ke UK001L 2025-12-01T14:21:57.422Z 2025-12-05T14:42:49.775Z
8652653 8652653 20251130012633_PA0ew UK001L 2025-12-01T14:21:56.191Z 2025-12-05T14:42:49.611Z
8652642 8652642 20251130012603_acxvx UK001L 2025-12-01T14:21:55.175Z 2025-12-05T14:42:49.348Z
8652622 8652622 20251130012501_9mbQ1 UK001L 2025-12-01T14:21:53.072Z 2025-12-05T14:42:48.927Z
8652572 8652572 20251130012218_zuePk UK001L 2025-12-01T14:21:43.898Z 2025-12-05T14:42:48.108Z
8652560 8652560 20251130012106_yu2iw UK001L 2025-12-01T14:21:41.515Z 2025-12-05T14:42:47.935Z
8652541 8652541 20251130011821_2gizD UK001L 2025-12-01T14:21:40.188Z 2025-12-05T14:42:47.257Z
8652443 8652443 20251130010925_kG7ru UK001L 2025-12-01T14:21:24.133Z 2025-12-05T14:42:44.619Z
8652337 8652337 20251130010341_0HTog UK001L 2025-12-01T14:21:16.831Z 2025-12-05T14:42:42.940Z
8652249 8652249 20251130005844_8DUzW UK001L 2025-12-01T14:21:03.056Z 2025-12-05T14:42:40.572Z
8652159 8652159 20251130005108_QcVQr UK001L 2025-12-01T14:20:50.004Z 2025-12-05T14:42:27.748Z
8652124 8652124 20251130004916_tLlCX UK001L 2025-12-01T14:20:46.756Z 2025-12-05T14:42:25.780Z
8650340 8650340 20251129195746_0niLL UK001L 2025-12-01T14:15:51.825Z 2025-12-05T14:41:04.545Z
8649924 8649924 20251129185321_t04RW UK001L 2025-12-01T14:14:27.944Z 2025-12-05T14:40:27.368Z
8649916 8649916 20251129185226_smP94 UK001L 2025-12-01T14:14:26.426Z 2025-12-05T14:40:27.064Z
8649893 8649893 20251129184941_CiKAt UK001L 2025-12-01T14:14:16.605Z 2025-12-05T14:40:26.351Z
8649680 8649680 20251129180626_UyIGH UK001L 2025-12-01T14:13:29.324Z 2025-12-05T14:40:16.361Z
8649657 8649657 20251129180343_G79as UK001L 2025-12-01T14:13:26.312Z 2025-12-05T14:40:15.742Z
8649640 8649640 20251129175923_tokR5 UK001L 2025-12-01T14:13:24.360Z 2025-12-05T14:40:15.460Z
8649339 8649339 20251129171112_2afn7 UK001L 2025-12-01T14:12:04.814Z 2025-12-05T14:40:05.014Z
8643496 8643496 20251128180159_w5uzk UK001L 2025-11-30T14:20:06.156Z 2025-12-05T14:49:22.330Z
8643485 8643485 20251128180115_Qqu25 UK001L 2025-11-30T14:20:05.321Z 2025-12-05T14:49:20.361Z
8643294 8643294 20251128174239_5Zvlt UK001L 2025-11-30T14:19:51.313Z 2025-12-05T14:49:15.183Z
8642960 8642960 20251128170740_2AxsC UK001L 2025-11-30T14:19:03.966Z 2025-12-05T14:49:07.816Z
8642944 8642944 20251128170555_ZjrFX UK001L 2025-11-30T14:19:02.238Z 2025-12-05T14:49:07.505Z
8637707 8637707 20251128062150_DrrRc UK001L 2025-11-29T14:27:45.102Z 2025-12-05T15:00:15.897Z
8637507 8637507 20251128054606_PYuwC UK001L 2025-11-29T14:27:31.433Z 2025-12-05T14:59:56.779Z
8637427 8637427 20251128053934_ghsPr UK001L 2025-11-29T14:27:14.464Z 2025-12-05T14:59:52.127Z
8637362 8637362 20251128053328_9wAT0 UK001L 2025-11-29T14:27:07.114Z 2025-12-05T14:59:45.409Z
8636658 8636658 20251128041543_W3Iq5 UK001L 2025-11-29T14:26:02.574Z 2025-12-05T14:59:27.857Z
8636326 8636326 20251128033722_TWEYv UK001L 2025-11-29T14:25:23.249Z 2025-12-05T14:59:22.909Z
8635188 8635188 20251128015049_bHIzp UK001L 2025-11-29T14:22:47.888Z 2025-12-05T14:58:31.787Z

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