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,874 rows where station_code = "UK0073" 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
9608618 9608618 20260403235921_0Mwh9 UK0073 2026-04-05T12:10:57.066Z 2026-04-06T12:20:26.582Z
9608587 9608587 20260403234642_zOgeX UK0073 2026-04-05T12:10:52.003Z 2026-04-06T12:20:23.181Z
9608203 9608203 20260403205334_MD4w0 UK0073 2026-04-05T12:09:31.894Z 2026-04-06T12:19:55.300Z
9608157 9608157 20260403201944_ORDdZ UK0073 2026-04-05T12:09:06.892Z 2026-04-06T12:19:46.539Z
9607082 9607082 20260404032835_YDHbZ UK0073 2026-04-05T12:00:21.967Z 2026-04-06T12:16:14.357Z
9598408 9598408 20260329235413_ovg5I UK0073 2026-03-31T12:10:33.593Z 2026-04-06T12:36:31.506Z
9598332 9598332 20260329224724_pg39r UK0073 2026-03-31T12:10:20.136Z 2026-04-06T12:36:25.429Z
9595134 9595134 20260330023237_wkemZ UK0073 2026-03-31T12:00:33.490Z 2026-04-06T12:29:41.952Z
9594524 9594524 20260328224955_2Wrvl UK0073 2026-03-30T12:09:45.493Z 2026-04-06T12:39:55.810Z
9592014 9592014 20260327235212_oZJna UK0073 2026-03-29T12:07:06.073Z 2026-04-05T12:35:24.118Z
9590049 9590049 20260328043650_Mh04i UK0073 2026-03-29T12:01:55.079Z 2026-04-06T12:37:48.241Z
9589628 9589628 20260328035226_xEXF5 UK0073 2026-03-29T12:01:30.165Z 2026-04-06T12:37:29.371Z
9588971 9588971 20260328020428_32nbH UK0073 2026-03-29T12:00:35.799Z 2026-04-06T12:36:58.543Z
9588835 9588835 20260328013145_522Ia UK0073 2026-03-29T12:00:20.936Z 2026-04-06T12:36:53.429Z
9588830 9588830 20260328012958_vH0OQ UK0073 2026-03-29T12:00:20.090Z 2026-04-06T12:36:53.158Z
9585038 9585038 20260325230954_UafXl UK0073 2026-03-27T12:16:34.764Z 2026-04-03T12:39:47.285Z
9584921 9584921 20260325224430_gjez0 UK0073 2026-03-27T12:16:22.565Z 2026-04-03T12:39:44.367Z
9581866 9581866 20260326040345_qxxG7 UK0073 2026-03-27T12:03:59.882Z 2026-04-04T12:39:23.289Z
9581622 9581622 20260326033505_96EFy UK0073 2026-03-27T12:03:29.830Z 2026-04-04T12:39:12.190Z
9581486 9581486 20260326031743_IL05x UK0073 2026-03-27T12:03:15.344Z 2026-04-04T12:39:08.086Z
9581157 9581157 20260326023051_7shIm UK0073 2026-03-27T12:02:15.820Z 2026-04-04T12:38:44.196Z
9580806 9580806 20260326013537_qkVgf UK0073 2026-03-27T12:01:27.430Z 2026-04-04T12:38:29.975Z
9577152 9577152 20260325040313_wKRIR UK0073 2026-03-26T12:04:15.421Z 2026-04-03T12:36:36.348Z
9576712 9576712 20260325025805_AZZpH UK0073 2026-03-26T12:03:04.494Z 2026-04-03T12:36:18.543Z
9576446 9576446 20260325020826_lyIEc UK0073 2026-03-26T12:02:16.972Z 2026-04-03T12:35:59.262Z
9576106 9576106 20260325011643_TIlWH UK0073 2026-03-26T12:01:17.811Z 2026-04-03T12:35:44.383Z
9560419 9560419 20260321211908_N3j0F UK0073 2026-03-23T12:11:45.830Z 2026-03-29T12:20:59.973Z
9543421 9543421 20260321035028_tla5U UK0073 2026-03-22T12:03:46.806Z 2026-03-29T12:19:07.373Z
9542839 9542839 20260321013335_6Nw6r UK0073 2026-03-22T12:01:45.991Z 2026-03-29T12:18:58.982Z
9516985 9516985 20260317222416_3C3JH UK0073 2026-03-19T12:27:03.727Z 2026-03-25T12:43:07.954Z
9516683 9516683 20260317213653_fscOc UK0073 2026-03-19T12:26:39.264Z 2026-03-25T12:43:06.123Z
9516041 9516041 20260317194711_nSYy9 UK0073 2026-03-19T12:25:34.014Z 2026-03-25T12:42:46.854Z
9516039 9516039 20260317194709_khWWx UK0073 2026-03-19T12:25:33.602Z 2026-03-25T12:42:46.842Z
9511413 9511413 20260318035154_VQ2s2 UK0073 2026-03-19T12:10:07.634Z 2026-03-26T12:37:36.726Z
9511067 9511067 20260318033420_cgqQO UK0073 2026-03-19T12:09:23.383Z 2026-03-26T12:37:19.123Z
9507882 9507882 20260317235037_bgJ8z UK0073 2026-03-19T12:01:33.514Z 2026-03-26T12:36:54.206Z
9495072 9495072 20260316040417_tRILS UK0073 2026-03-17T12:06:00.077Z 2026-03-24T12:40:55.116Z
9494786 9494786 20260316030133_2gBmD UK0073 2026-03-17T12:04:57.063Z 2026-03-24T12:40:50.019Z
9494702 9494702 20260316024800_ERJB8 UK0073 2026-03-17T12:04:42.165Z 2026-03-24T12:40:49.424Z
9494298 9494298 20260316015128_Awm2l UK0073 2026-03-17T12:03:33.377Z 2026-03-24T12:40:46.673Z
9494169 9494169 20260316013406_XgkeH UK0073 2026-03-17T12:03:10.749Z 2026-03-24T12:40:44.849Z
9493616 9493616 20260316000815_Po9kj UK0073 2026-03-17T12:01:32.750Z 2026-03-24T12:40:41.108Z
9493537 9493537 20260315234800_j3iFj UK0073 2026-03-17T12:01:12.535Z 2026-03-24T12:40:40.493Z
9493426 9493426 20260315232951_pEK3c UK0073 2026-03-17T12:00:50.107Z 2026-03-24T12:40:39.620Z
9483540 9483540 20260313223643_WfwQ8 UK0073 2026-03-15T12:26:38.493Z 2026-03-21T12:50:28.292Z
9477363 9477363 20260314044655_8fwcS UK0073 2026-03-15T12:08:09.025Z 2026-03-22T12:42:02.423Z
9477086 9477086 20260314041530_RSwYj UK0073 2026-03-15T12:07:35.284Z 2026-03-22T12:42:01.135Z
9474781 9474781 20260313235652_Z8imT UK0073 2026-03-15T12:01:20.913Z 2026-03-22T12:41:24.183Z
9470126 9470126 20260313043841_Hvu9Q UK0073 2026-03-14T12:06:32.070Z 2026-03-21T12:49:06.055Z
9469854 9469854 20260313035336_GbtVd UK0073 2026-03-14T12:05:45.592Z 2026-03-21T12:49:03.255Z
9469503 9469503 20260313025913_11tpl UK0073 2026-03-14T12:04:30.431Z 2026-03-21T12:48:40.466Z
9469462 9469462 20260313025349_RW099 UK0073 2026-03-14T12:04:21.073Z 2026-03-21T12:48:39.914Z
9469414 9469414 20260313024516_QGuwJ UK0073 2026-03-14T12:04:10.527Z 2026-03-21T12:48:38.709Z
9457687 9457687 20260311045158_yQPFp UK0073 2026-03-12T12:04:22.664Z 2026-03-19T12:44:51.074Z
9457533 9457533 20260311041209_bouxP UK0073 2026-03-12T12:04:00.551Z 2026-03-19T12:44:46.508Z
9457420 9457420 20260311035340_GJMln UK0073 2026-03-12T12:03:47.042Z 2026-03-19T12:44:42.371Z
9456943 9456943 20260311015054_oSbI3 UK0073 2026-03-12T12:02:18.887Z 2026-03-19T12:44:23.943Z
9456929 9456929 20260311014550_y7uFJ UK0073 2026-03-12T12:02:14.567Z 2026-03-19T12:44:23.738Z
9456907 9456907 20260311013817_qEfI2 UK0073 2026-03-12T12:02:09.662Z 2026-03-19T12:44:23.464Z
9437628 9437628 20260307052741_VA6CO UK0073 2026-03-08T12:04:47.391Z 2026-03-15T12:41:23.887Z
9437615 9437615 20260307051521_s4jL9 UK0073 2026-03-08T12:04:43.958Z 2026-03-15T12:41:23.423Z
9437610 9437610 20260307051030_9xVha UK0073 2026-03-08T12:04:42.952Z 2026-03-15T12:41:22.976Z
9437213 9437213 20260307023308_u7das UK0073 2026-03-08T12:03:02.528Z 2026-03-15T12:41:04.535Z
9436973 9436973 20260307005705_QCsTu UK0073 2026-03-08T12:02:05.324Z 2026-03-15T12:41:00.301Z
9436948 9436948 20260307004835_UlGjJ UK0073 2026-03-08T12:01:59.686Z 2026-03-15T12:40:59.940Z
9430617 9430617 20260304201208_rJC22 UK0073 2026-03-06T14:23:45.948Z 2026-03-12T12:33:39.041Z
9422483 9422483 20260304020644_Jg1Sy UK0073 2026-03-05T14:01:29.756Z 2026-03-12T12:32:29.435Z
9422346 9422346 20260304005149_zqpx0 UK0073 2026-03-05T14:01:00.434Z 2026-03-12T12:32:26.825Z
9419592 9419592 20260303044022_0wKI0 UK0073 2026-03-04T14:01:45.267Z 2026-03-11T12:28:03.285Z
9419429 9419429 20260303034218_uhSxC UK0073 2026-03-04T14:01:24.559Z 2026-03-11T12:28:00.343Z
9412081 9412081 20260301000309_xO37p UK0073 2026-03-02T14:00:26.913Z 2026-03-09T12:39:18.521Z
9398813 9398813 20260226041455_p3rqK UK0073 2026-02-27T14:06:12.118Z 2026-03-06T14:43:58.066Z
9398046 9398046 20260226025847_RmMH8 UK0073 2026-02-27T14:04:19.725Z 2026-03-06T14:43:33.872Z
9395087 9395087 20260224225040_BLKeM UK0073 2026-02-26T14:21:03.337Z 2026-03-04T14:19:29.554Z
9374001 9374001 20260223051504_sKpLK UK0073 2026-02-24T14:04:31.748Z 2026-03-03T14:31:12.938Z
9373873 9373873 20260223043916_ySLpT UK0073 2026-02-24T14:04:11.111Z 2026-03-03T14:31:11.004Z
9373692 9373692 20260223040140_95LZv UK0073 2026-02-24T14:03:38.410Z 2026-03-03T14:31:07.743Z
9373014 9373014 20260223015429_ve6A2 UK0073 2026-02-24T14:01:58.533Z 2026-03-03T14:30:49.992Z
9364571 9364571 20260220222348_xZoCm UK0073 2026-02-22T14:21:44.640Z 2026-03-01T14:22:55.201Z
9364567 9364567 20260220222006_E3jMy UK0073 2026-02-22T14:21:43.991Z 2026-03-01T14:22:55.174Z
9340462 9340462 20260217001725_XdhxB UK0073 2026-02-18T14:24:56.966Z 2026-02-25T14:42:54.560Z
9340214 9340214 20260216232319_mAaAr UK0073 2026-02-18T14:24:19.902Z 2026-02-25T14:42:52.168Z
9337249 9337249 20260217052101_5cqaq UK0073 2026-02-18T14:06:47.123Z 2026-02-26T14:39:25.337Z
9336800 9336800 20260217043622_ToLjo UK0073 2026-02-18T14:05:31.009Z 2026-02-26T14:39:21.681Z
9336482 9336482 20260217035411_PpnA6 UK0073 2026-02-18T14:04:29.658Z 2026-02-26T14:39:18.824Z
9336380 9336380 20260217034818_MuCwz UK0073 2026-02-18T14:04:18.626Z 2026-02-26T14:39:18.307Z
9335975 9335975 20260217025718_hO3NQ UK0073 2026-02-18T14:02:55.333Z 2026-02-26T14:39:00.906Z
9335930 9335930 20260217025223_UzumX UK0073 2026-02-18T14:02:45.402Z 2026-02-26T14:38:59.654Z
9335731 9335731 20260217023513_bTcfJ UK0073 2026-02-18T14:02:11.230Z 2026-02-26T14:38:58.230Z
9334471 9334471 20260215215234_CxaPd UK0073 2026-02-17T14:24:18.900Z 2026-02-24T14:43:10.471Z
9334062 9334062 20260215200141_E7CfF UK0073 2026-02-17T14:22:53.905Z 2026-02-24T14:43:01.010Z
9331016 9331016 20260216033450_EjVe9 UK0073 2026-02-17T14:04:12.906Z 2026-02-25T14:41:36.598Z
9330994 9330994 20260216033121_cHMt3 UK0073 2026-02-17T14:04:05.542Z 2026-02-25T14:41:36.221Z
9330804 9330804 20260216024729_qHwCd UK0073 2026-02-17T14:03:09.971Z 2026-02-25T14:41:32.347Z
9326641 9326641 20260214011533_jf0Wz UK0073 2026-02-15T14:24:05.085Z 2026-02-22T14:42:53.947Z
9326623 9326623 20260214010807_rpDpk UK0073 2026-02-15T14:24:00.181Z 2026-02-22T14:42:53.435Z
9326615 9326615 20260214010155_n4uCb UK0073 2026-02-15T14:23:59.201Z 2026-02-22T14:42:53.370Z
9326252 9326252 20260213220524_moJU4 UK0073 2026-02-15T14:22:23.415Z 2026-02-22T14:42:44.921Z
9323565 9323565 20260214054111_dOnav UK0073 2026-02-15T14:06:37.655Z 2026-02-23T14:46:33.913Z
9322784 9322784 20260214035926_0cbFz UK0073 2026-02-15T14:03:58.874Z 2026-02-23T14:46:22.316Z

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