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

5,947 rows where station_code = "UK009M" 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
9608833 9608833 20260404015312_pyqC1 UK009M 2026-04-05T12:11:53.617Z 2026-04-06T12:20:41.858Z
9607091 9607091 20260404033151_yXAwP UK009M 2026-04-05T12:00:23.927Z 2026-04-06T12:16:14.359Z
9606755 9606755 20260402202027_kYmDz UK009M 2026-04-04T12:11:26.789Z 2026-04-06T12:23:38.409Z
9602645 9602645 20260401012556_GNEOe UK009M 2026-04-02T12:09:40.313Z 2026-04-06T12:29:30.074Z
9600548 9600548 20260330232656_juN5c UK009M 2026-04-01T12:11:09.041Z 2026-04-06T12:33:33.815Z
9600520 9600520 20260330230043_Hlo9U UK009M 2026-04-01T12:11:02.090Z 2026-04-06T12:33:31.901Z
9598274 9598274 20260329215707_9ss7i UK009M 2026-03-31T12:10:10.251Z 2026-04-06T12:36:21.800Z
9594779 9594779 20260329003208_FjlqZ UK009M 2026-03-30T12:10:18.684Z 2026-04-06T12:40:15.664Z
9594680 9594680 20260328235038_cSL4A UK009M 2026-03-30T12:10:09.162Z 2026-04-06T12:40:03.569Z
9594390 9594390 20260328220610_Ya9PO UK009M 2026-03-30T12:09:27.659Z 2026-04-06T12:39:50.536Z
9594304 9594304 20260328211341_bQLpT UK009M 2026-03-30T12:09:15.665Z 2026-04-06T12:39:47.176Z
9592595 9592595 20260329024234_s8pXe UK009M 2026-03-30T12:01:24.365Z 2026-04-06T12:34:17.149Z
9589521 9589521 20260328033840_e0f02 UK009M 2026-03-29T12:01:23.307Z 2026-04-06T12:37:26.627Z
9589453 9589453 20260328033025_xN2RJ UK009M 2026-03-29T12:01:16.433Z 2026-04-06T12:37:24.140Z
9589176 9589176 20260328023959_W5wNx UK009M 2026-03-29T12:00:49.136Z 2026-04-06T12:37:04.210Z
9584981 9584981 20260325225712_rMep6 UK009M 2026-03-27T12:16:27.736Z 2026-04-03T12:39:45.499Z
9584507 9584507 20260325201848_twLF6 UK009M 2026-03-27T12:15:31.221Z 2026-04-03T12:39:17.586Z
9581763 9581763 20260326035539_gQ1nS UK009M 2026-03-27T12:03:49.731Z 2026-04-04T12:39:20.221Z
9581635 9581635 20260326033539_uvD2r UK009M 2026-03-27T12:03:31.066Z 2026-04-04T12:39:12.612Z
9581503 9581503 20260326032000_wPrfj UK009M 2026-03-27T12:03:18.082Z 2026-04-04T12:39:08.916Z
9576676 9576676 20260325025123_vu9uj UK009M 2026-03-26T12:02:58.883Z 2026-04-03T12:36:17.058Z
9576127 9576127 20260325011937_qi3Gg UK009M 2026-03-26T12:01:23.131Z 2026-04-03T12:35:45.374Z
9576046 9576046 20260325010534_E50EH UK009M 2026-03-26T12:01:06.185Z 2026-04-03T12:35:42.282Z
9575822 9575822 20260325002116_Oh7Sm UK009M 2026-03-26T12:00:18.400Z 2026-04-03T12:35:23.408Z
9562679 9562679 20260323030028_qtZJQ UK009M 2026-03-24T12:03:45.241Z 2026-03-31T12:26:17.247Z
9562589 9562589 20260323024208_XiyOj UK009M 2026-03-24T12:03:30.397Z 2026-03-31T12:26:15.177Z
9562118 9562118 20260323013505_a3J39 UK009M 2026-03-24T12:02:11.644Z 2026-03-31T12:26:01.664Z
9560753 9560753 20260321221139_BXl2b UK009M 2026-03-23T12:12:02.716Z 2026-03-29T12:21:02.567Z
9552178 9552178 20260320231011_oPuMl UK009M 2026-03-22T12:27:30.971Z 2026-03-28T12:37:07.615Z
9551897 9551897 20260320220731_8240z UK009M 2026-03-22T12:27:16.295Z 2026-03-28T12:37:03.839Z
9542267 9542267 20260319230642_YdLqw UK009M 2026-03-21T12:29:54.692Z 2026-03-27T12:42:52.589Z
9542117 9542117 20260319224824_czeuf UK009M 2026-03-21T12:29:40.451Z 2026-03-27T12:42:45.197Z
9541857 9541857 20260319215923_zDdG9 UK009M 2026-03-21T12:29:26.514Z 2026-03-27T12:42:42.487Z
9533190 9533190 20260320021043_IYXE3 UK009M 2026-03-21T12:04:45.001Z 2026-03-28T12:33:50.129Z
9532882 9532882 20260320013539_Af3Vw UK009M 2026-03-21T12:03:53.200Z 2026-03-28T12:33:45.813Z
9532505 9532505 20260320010342_Qyx4j UK009M 2026-03-21T12:02:56.578Z 2026-03-28T12:33:33.010Z
9532433 9532433 20260320005704_2e397 UK009M 2026-03-21T12:02:42.069Z 2026-03-28T12:33:31.239Z
9532187 9532187 20260320003056_63OrN UK009M 2026-03-21T12:01:58.465Z 2026-03-28T12:33:25.539Z
9530275 9530275 20260318203415_Wy5YM UK009M 2026-03-20T12:24:16.282Z 2026-03-26T12:39:10.948Z
9521611 9521611 20260319042824_ejr3j UK009M 2026-03-20T12:08:16.637Z 2026-03-27T12:40:56.110Z
9521069 9521069 20260319035312_LKmJk UK009M 2026-03-20T12:07:28.976Z 2026-03-27T12:40:50.829Z
9521006 9521006 20260319034833_LUSLg UK009M 2026-03-20T12:07:21.163Z 2026-03-27T12:40:49.970Z
9520019 9520019 20260319024800_4gFRT UK009M 2026-03-20T12:05:33.021Z 2026-03-27T12:40:38.055Z
9518367 9518367 20260319005400_mJ897 UK009M 2026-03-20T12:02:23.737Z 2026-03-27T12:40:08.826Z
9518041 9518041 20260319002321_7Qxwh UK009M 2026-03-20T12:01:48.492Z 2026-03-27T12:40:05.855Z
9516949 9516949 20260317221850_MIU6Z UK009M 2026-03-19T12:26:56.364Z 2026-03-25T12:43:07.694Z
9516659 9516659 20260317212614_2q93E UK009M 2026-03-19T12:26:37.099Z 2026-03-25T12:43:05.005Z
9512179 9512179 20260318045349_VOxeI UK009M 2026-03-19T12:11:51.844Z 2026-03-26T12:37:42.822Z
9511149 9511149 20260318033746_gy9Sh UK009M 2026-03-19T12:09:33.804Z 2026-03-26T12:37:25.066Z
9510394 9510394 20260318024840_NAjC1 UK009M 2026-03-19T12:07:31.251Z 2026-03-26T12:37:12.102Z
9509090 9509090 20260318012626_SqPiY UK009M 2026-03-19T12:04:33.446Z 2026-03-26T12:37:03.224Z
9508801 9508801 20260318011119_tfDyY UK009M 2026-03-19T12:03:48.234Z 2026-03-26T12:37:00.901Z
9508473 9508473 20260318005808_ktFrF UK009M 2026-03-19T12:03:11.259Z 2026-03-26T12:36:58.761Z
9501316 9501316 20260315215530_sQPmI UK009M 2026-03-17T12:24:49.081Z 2026-03-23T12:22:43.902Z
9494827 9494827 20260316030941_ZVApI UK009M 2026-03-17T12:05:08.982Z 2026-03-24T12:40:50.448Z
9494427 9494427 20260316021429_U98eu UK009M 2026-03-17T12:03:57.065Z 2026-03-24T12:40:47.540Z
9492897 9492897 20260314221134_zU54o UK009M 2026-03-16T12:29:08.939Z 2026-03-22T12:42:55.624Z
9492869 9492869 20260314220716_SPaFg UK009M 2026-03-16T12:29:06.734Z 2026-03-22T12:42:55.478Z
9484470 9484470 20260315004456_itVTV UK009M 2026-03-16T12:03:00.320Z 2026-03-23T12:21:46.961Z
9484467 9484467 20260315004435_Aabh9 UK009M 2026-03-16T12:02:59.771Z 2026-03-23T12:21:46.940Z
9484399 9484399 20260315003432_S4xNv UK009M 2026-03-16T12:02:45.654Z 2026-03-23T12:21:46.631Z
9484360 9484360 20260315002634_y2KHM UK009M 2026-03-16T12:02:34.316Z 2026-03-23T12:21:46.480Z
9483189 9483189 20260313210720_dDRaD UK009M 2026-03-15T12:26:04.358Z 2026-03-21T12:50:23.408Z
9476983 9476983 20260314040120_gUomc UK009M 2026-03-15T12:07:20.693Z 2026-03-22T12:42:00.400Z
9476468 9476468 20260314031042_RZW0A UK009M 2026-03-15T12:06:05.161Z 2026-03-22T12:41:56.963Z
9475280 9475280 20260314010955_bjwEN UK009M 2026-03-15T12:02:45.246Z 2026-03-22T12:41:31.212Z
9474938 9474938 20260314001640_Vp5G6 UK009M 2026-03-15T12:01:47.419Z 2026-03-22T12:41:25.570Z
9474883 9474883 20260314001005_g9sDF UK009M 2026-03-15T12:01:36.231Z 2026-03-22T12:41:25.076Z
9474723 9474723 20260313234543_OM6OS UK009M 2026-03-15T12:01:09.354Z 2026-03-22T12:41:23.731Z
9467239 9467239 20260311205601_W12w0 UK009M 2026-03-13T12:18:48.543Z 2026-03-19T12:45:50.726Z
9463314 9463314 20260312013041_72yXk UK009M 2026-03-13T12:03:49.087Z 2026-03-20T12:36:21.832Z
9463095 9463095 20260312010307_U0kS9 UK009M 2026-03-13T12:03:07.575Z 2026-03-20T12:36:19.739Z
9462904 9462904 20260312003158_XGyiL UK009M 2026-03-13T12:02:32.420Z 2026-03-20T12:36:18.792Z
9460520 9460520 20260310201757_tdjaF UK009M 2026-03-12T12:14:27.541Z 2026-03-18T12:40:06.959Z
9420628 9420628 20260302222044_9X5yW UK009M 2026-03-04T14:05:13.006Z 2026-03-10T12:36:56.897Z
9419499 9419499 20260303040607_T5uAq UK009M 2026-03-04T14:01:32.723Z 2026-03-11T12:28:01.628Z
9419094 9419094 20260303012615_3qYcX UK009M 2026-03-04T14:00:44.691Z 2026-03-11T12:27:44.942Z
9412707 9412707 20260301050957_EPg2f UK009M 2026-03-02T14:01:56.442Z 2026-03-09T12:39:48.140Z
9397905 9397905 20260226023843_n9Zgm UK009M 2026-02-27T14:03:49.309Z 2026-03-06T14:43:28.866Z
9394690 9394690 20260224212555_Ka1Iq UK009M 2026-02-26T14:20:29.985Z 2026-03-04T14:19:26.247Z
9390081 9390081 20260224233638_6OqVO UK009M 2026-02-26T14:00:24.034Z 2026-03-05T14:35:32.213Z
9381499 9381499 20260222225501_sTBiW UK009M 2026-02-24T14:24:48.828Z 2026-02-24T14:24:48.828Z
9381414 9381414 20260222222626_LLsMX UK009M 2026-02-24T14:24:42.811Z 2026-02-24T14:24:42.811Z
9381296 9381296 20260222214101_9td2V UK009M 2026-02-24T14:24:30.115Z 2026-02-24T14:24:30.115Z
9374069 9374069 20260223052926_zBKzB UK009M 2026-02-24T14:04:46.684Z 2026-03-03T14:31:14.105Z
9373027 9373027 20260223020140_77u6f UK009M 2026-02-24T14:02:02.099Z 2026-03-03T14:30:50.269Z
9372849 9372849 20260223011731_32An5 UK009M 2026-02-24T14:01:34.056Z 2026-03-03T14:30:47.681Z
9364021 9364021 20260220184436_wv3yz UK009M 2026-02-22T14:20:31.383Z 2026-03-01T14:22:50.080Z
9340767 9340767 20260216010834_Ygwx0 UK009M 2026-02-18T14:33:13.807Z 2026-02-24T14:43:38.664Z
9340186 9340186 20260216231454_v3Chj UK009M 2026-02-18T14:24:14.932Z 2026-02-25T14:42:51.807Z
9339749 9339749 20260216204839_se3T3 UK009M 2026-02-18T14:22:47.650Z 2026-02-25T14:42:45.503Z
9337543 9337543 20260217055025_p1YIB UK009M 2026-02-18T14:07:29.309Z 2026-02-26T14:39:27.623Z
9337169 9337169 20260217051039_aDzyT UK009M 2026-02-18T14:06:32.357Z 2026-02-26T14:39:24.479Z
9335044 9335044 20260216002137_zAwS3 UK009M 2026-02-17T14:26:10.765Z 2026-02-24T14:43:33.793Z
9335016 9335016 20260216001553_r5jOp UK009M 2026-02-17T14:26:05.211Z 2026-02-24T14:43:22.761Z
9334737 9334737 20260215225714_2Kvm7 UK009M 2026-02-17T14:25:07.703Z 2026-02-24T14:43:15.830Z
9334669 9334669 20260215224211_nfUBc UK009M 2026-02-17T14:24:55.560Z 2026-02-24T14:43:14.041Z
9334454 9334454 20260215214954_H1Ztr UK009M 2026-02-17T14:24:14.491Z 2026-02-24T14:43:10.143Z
9334442 9334442 20260215214953_4ryuC UK009M 2026-02-17T14:24:14.091Z 2026-02-24T14:43:10.100Z
9334339 9334339 20260215213248_I99LW UK009M 2026-02-17T14:23:55.544Z 2026-02-24T14:43:07.731Z

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