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 = "UK004E" 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
9607148 9607148 20260404040038_LjHyp UK004E 2026-04-05T12:00:36.721Z 2026-04-06T12:16:14.372Z
9607041 9607041 20260404031741_f2rK6 UK004E 2026-04-05T12:00:13.503Z 2026-04-06T12:16:14.348Z
9602656 9602656 20260401015312_rFJVT UK004E 2026-04-02T12:09:44.370Z 2026-04-06T12:29:31.084Z
9600784 9600784 20260401025155_Uk291 UK004E 2026-04-02T12:00:16.678Z 2026-04-06T12:24:09.153Z
9595513 9595513 20260330042726_2RZEN UK004E 2026-03-31T12:01:37.164Z 2026-04-06T12:30:07.094Z
9595496 9595496 20260330042247_2tlzY UK004E 2026-03-31T12:01:35.699Z 2026-04-06T12:30:06.523Z
9595220 9595220 20260330030729_P1356 UK004E 2026-03-31T12:00:50.029Z 2026-04-06T12:29:48.794Z
9594617 9594617 20260328233442_81lpJ UK004E 2026-03-30T12:10:00.231Z 2026-04-06T12:40:01.842Z
9594587 9594587 20260328231428_Q6d9W UK004E 2026-03-30T12:09:54.320Z 2026-04-06T12:40:00.314Z
9594362 9594362 20260328214926_dAST3 UK004E 2026-03-30T12:09:23.558Z 2026-04-06T12:39:49.459Z
9592821 9592821 20260329033121_zOoM5 UK004E 2026-03-30T12:02:00.304Z 2026-04-06T12:34:29.628Z
9592709 9592709 20260329030452_31OZE UK004E 2026-03-30T12:01:40.653Z 2026-04-06T12:34:22.190Z
9592702 9592702 20260329030440_4R3Ky UK004E 2026-03-30T12:01:39.448Z 2026-04-06T12:34:21.856Z
9592613 9592613 20260329024726_pm2hD UK004E 2026-03-30T12:01:26.701Z 2026-04-06T12:34:17.964Z
9592382 9592382 20260329015937_nK405 UK004E 2026-03-30T12:00:51.299Z 2026-04-06T12:34:08.723Z
9592339 9592339 20260329015637_KVxci UK004E 2026-03-30T12:00:44.406Z 2026-04-06T12:34:01.555Z
9592333 9592333 20260329015328_i0zJf UK004E 2026-03-30T12:00:42.586Z 2026-04-06T12:34:01.114Z
9589908 9589908 20260328041823_cB7X6 UK004E 2026-03-29T12:01:43.339Z 2026-04-06T12:37:37.731Z
9589840 9589840 20260328041053_rtluV UK004E 2026-03-29T12:01:39.755Z 2026-04-06T12:37:35.929Z
9582045 9582045 20260326042319_7aZCk UK004E 2026-03-27T12:04:27.764Z 2026-04-04T12:39:35.724Z
9581725 9581725 20260326035326_vn6Hn UK004E 2026-03-27T12:03:45.839Z 2026-04-04T12:39:17.220Z
9581701 9581701 20260326034537_3L7BY UK004E 2026-03-27T12:03:41.806Z 2026-04-04T12:39:15.678Z
9581493 9581493 20260326031826_8xMQt UK004E 2026-03-27T12:03:16.608Z 2026-04-04T12:39:08.403Z
9581469 9581469 20260326031617_46F3t UK004E 2026-03-27T12:03:12.295Z 2026-04-04T12:39:07.316Z
9581449 9581449 20260326031446_o0HWz UK004E 2026-03-27T12:03:10.095Z 2026-04-04T12:39:06.584Z
9581261 9581261 20260326024455_KoNt3 UK004E 2026-03-27T12:02:34.775Z 2026-04-04T12:38:51.012Z
9581213 9581213 20260326023740_kSqBq UK004E 2026-03-27T12:02:25.086Z 2026-04-04T12:38:46.407Z
9581081 9581081 20260326022107_uBcJx UK004E 2026-03-27T12:02:05.336Z 2026-04-04T12:38:41.933Z
9581069 9581069 20260326022027_enCu2 UK004E 2026-03-27T12:02:03.759Z 2026-04-04T12:38:41.505Z
9580998 9580998 20260326020802_CgEyr UK004E 2026-03-27T12:01:52.379Z 2026-04-04T12:38:38.914Z
9580860 9580860 20260326014801_J51nm UK004E 2026-03-27T12:01:36.267Z 2026-04-04T12:38:31.620Z
9580712 9580712 20260326012133_Hm285 UK004E 2026-03-27T12:01:14.261Z 2026-04-04T12:38:21.397Z
9580486 9580486 20260326005524_l1kWK UK004E 2026-03-27T12:00:36.761Z 2026-04-04T12:38:12.049Z
9579905 9579905 20260324231328_2juio UK004E 2026-03-26T12:14:38.560Z 2026-04-02T12:37:33.917Z
9576809 9576809 20260325031252_aOmgq UK004E 2026-03-26T12:03:22.265Z 2026-04-03T12:36:21.920Z
9576567 9576567 20260325023439_Vf37I UK004E 2026-03-26T12:02:38.549Z 2026-04-03T12:36:12.784Z
9576550 9576550 20260325023110_8VIh6 UK004E 2026-03-26T12:02:35.948Z 2026-04-03T12:36:12.331Z
9576167 9576167 20260325012738_rIsHq UK004E 2026-03-26T12:01:28.708Z 2026-04-03T12:35:46.972Z
9576065 9576065 20260325010856_06yUV UK004E 2026-03-26T12:01:10.735Z 2026-04-03T12:35:42.995Z
9562854 9562854 20260323032739_EzAPo UK004E 2026-03-24T12:04:17.203Z 2026-03-31T12:26:27.972Z
9562806 9562806 20260323031643_8ND4G UK004E 2026-03-24T12:04:07.028Z 2026-03-31T12:26:26.386Z
9562732 9562732 20260323030708_SDwHo UK004E 2026-03-24T12:03:53.314Z 2026-03-31T12:26:24.364Z
9562580 9562580 20260323023951_4EHD0 UK004E 2026-03-24T12:03:29.043Z 2026-03-31T12:26:14.860Z
9562504 9562504 20260323022616_USxVe UK004E 2026-03-24T12:03:17.237Z 2026-03-31T12:26:13.136Z
9561430 9561430 20260321233147_yNAPw UK004E 2026-03-23T12:12:18.790Z 2026-03-29T12:21:07.141Z
9560954 9560954 20260321223916_oekKm UK004E 2026-03-23T12:12:08.425Z 2026-03-29T12:21:04.174Z
9560227 9560227 20260321204918_HjP3E UK004E 2026-03-23T12:11:40.463Z 2026-03-29T12:20:58.710Z
9560202 9560202 20260321204652_YRSEA UK004E 2026-03-23T12:11:40.182Z 2026-03-29T12:20:58.556Z
9559931 9559931 20260321201124_ltnjI UK004E 2026-03-23T12:11:34.033Z 2026-03-29T12:20:56.674Z
9553648 9553648 20260322020408_QC4Gf UK004E 2026-03-23T12:01:44.563Z 2026-03-30T12:27:50.600Z
9552549 9552549 20260322001903_3Q3a3 UK004E 2026-03-23T12:00:32.043Z 2026-03-30T12:27:25.997Z
9551487 9551487 20260320195534_QVWN7 UK004E 2026-03-22T12:26:43.033Z 2026-03-28T12:36:56.049Z
9551411 9551411 20260320194318_Q2wym UK004E 2026-03-22T12:26:38.836Z 2026-03-28T12:36:50.918Z
9542816 9542816 20260321013028_bP3bo UK004E 2026-03-22T12:01:42.683Z 2026-03-29T12:18:58.670Z
9534535 9534535 20260320035740_X4r1K UK004E 2026-03-21T12:08:12.939Z 2026-03-28T12:34:19.126Z
9534141 9534141 20260320033037_rtDrT UK004E 2026-03-21T12:07:15.620Z 2026-03-28T12:34:14.795Z
9533916 9533916 20260320030916_IR3S1 UK004E 2026-03-21T12:06:38.719Z 2026-03-28T12:34:02.234Z
9533565 9533565 20260320024303_0uMOi UK004E 2026-03-21T12:05:44.482Z 2026-03-28T12:33:56.126Z
9533131 9533131 20260320020328_HOExB UK004E 2026-03-21T12:04:31.954Z 2026-03-28T12:33:49.111Z
9532483 9532483 20260320010212_C9pP4 UK004E 2026-03-21T12:02:52.279Z 2026-03-28T12:33:32.330Z
9532000 9532000 20260320000707_LWCpx UK004E 2026-03-21T12:01:23.533Z 2026-03-28T12:33:23.626Z
9531678 9531678 20260319233451_Yzsgm UK004E 2026-03-21T12:00:27.525Z 2026-03-28T12:33:19.982Z
9531426 9531426 20260318230759_X3jmb UK004E 2026-03-20T12:25:10.225Z 2026-03-26T12:39:19.304Z
9531097 9531097 20260318222529_5T8K8 UK004E 2026-03-20T12:24:57.228Z 2026-03-26T12:39:17.394Z
9530877 9530877 20260318215652_2BFpM UK004E 2026-03-20T12:24:50.511Z 2026-03-26T12:39:16.352Z
9530721 9530721 20260318213114_sJHa3 UK004E 2026-03-20T12:24:37.030Z 2026-03-26T12:39:15.004Z
9521962 9521962 20260319045925_A17M3 UK004E 2026-03-20T12:08:46.347Z 2026-03-27T12:41:12.038Z
9520770 9520770 20260319033518_m5z7a UK004E 2026-03-20T12:06:56.342Z 2026-03-27T12:40:47.186Z
9520721 9520721 20260319033349_lRT99 UK004E 2026-03-20T12:06:52.096Z 2026-03-27T12:40:46.645Z
9520436 9520436 20260319031614_A3L8v UK004E 2026-03-20T12:06:22.733Z 2026-03-27T12:40:43.145Z
9519192 9519192 20260319015359_R74DB UK004E 2026-03-20T12:04:04.494Z 2026-03-27T12:40:18.935Z
9518526 9518526 20260319010630_yEJ0h UK004E 2026-03-20T12:02:46.310Z 2026-03-27T12:40:11.157Z
9518276 9518276 20260319004735_0efLD UK004E 2026-03-20T12:02:15.131Z 2026-03-27T12:40:08.157Z
9517925 9517925 20260319001158_MPkEO UK004E 2026-03-20T12:01:31.776Z 2026-03-27T12:40:04.662Z
9517276 9517276 20260317230149_J3vqJ UK004E 2026-03-19T12:27:24.670Z 2026-03-25T12:43:09.807Z
9517228 9517228 20260317225759_DPyzu UK004E 2026-03-19T12:27:21.162Z 2026-03-25T12:43:09.507Z
9517186 9517186 20260317225039_rooIn UK004E 2026-03-19T12:27:17.772Z 2026-03-25T12:43:09.167Z
9516754 9516754 20260317215345_AN1t2 UK004E 2026-03-19T12:26:45.044Z 2026-03-25T12:43:06.730Z
9516264 9516264 20260317202137_SR86o UK004E 2026-03-19T12:25:50.828Z 2026-03-25T12:42:52.679Z
9516126 9516126 20260317200550_4Zi5O UK004E 2026-03-19T12:25:42.289Z 2026-03-25T12:42:49.130Z
9516098 9516098 20260317200259_ecXyd UK004E 2026-03-19T12:25:40.317Z 2026-03-25T12:42:48.448Z
9512125 9512125 20260318044530_ZL0M3 UK004E 2026-03-19T12:11:46.006Z 2026-03-26T12:37:42.561Z
9512089 9512089 20260318044122_LUQSM UK004E 2026-03-19T12:11:40.738Z 2026-03-26T12:37:42.204Z
9511950 9511950 20260318042951_KNi85 UK004E 2026-03-19T12:11:22.403Z 2026-03-26T12:37:40.932Z
9511848 9511848 20260318042330_sZkcf UK004E 2026-03-19T12:11:09.985Z 2026-03-26T12:37:40.131Z
9511682 9511682 20260318040919_iMhJr UK004E 2026-03-19T12:10:45.135Z 2026-03-26T12:37:38.870Z
9511462 9511462 20260318035504_ocqz4 UK004E 2026-03-19T12:10:15.934Z 2026-03-26T12:37:37.106Z
9511199 9511199 20260318034002_3asMD UK004E 2026-03-19T12:09:39.100Z 2026-03-26T12:37:26.927Z
9511195 9511195 20260318034002_aYKwF UK004E 2026-03-19T12:09:38.765Z 2026-03-26T12:37:26.846Z
9510380 9510380 20260318024755_erLnu UK004E 2026-03-19T12:07:30.127Z 2026-03-26T12:37:12.054Z
9509283 9509283 20260318013817_pwBp9 UK004E 2026-03-19T12:04:56.557Z 2026-03-26T12:37:04.363Z
9509275 9509275 20260318013817_BitTZ UK004E 2026-03-19T12:04:56.271Z 2026-03-26T12:37:04.344Z
9508727 9508727 20260318010815_PU42n UK004E 2026-03-19T12:03:42.123Z 2026-03-26T12:37:00.425Z
9508361 9508361 20260318004733_EUwmb UK004E 2026-03-19T12:02:55.802Z 2026-03-26T12:36:57.992Z
9508354 9508354 20260318004733_oDRP1 UK004E 2026-03-19T12:02:55.532Z 2026-03-26T12:36:57.966Z
9508242 9508242 20260318003608_PPrmm UK004E 2026-03-19T12:02:42.161Z 2026-03-26T12:36:57.191Z
9507857 9507857 20260317234919_WKGkK UK004E 2026-03-19T12:01:29.278Z 2026-03-26T12:36:54.009Z
9507494 9507494 20260317231039_hAGEy UK004E 2026-03-19T12:00:16.681Z 2026-03-26T12:36:37.440Z
9507487 9507487 20260317231039_3vwyB UK004E 2026-03-19T12:00:16.236Z 2026-03-26T12:36:37.369Z
9501271 9501271 20260315214353_2ffou UK004E 2026-03-17T12:24:46.543Z 2026-03-23T12:22:43.802Z

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