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

7,190 rows where station_code = "UK004C" 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
9611690 9611690 20260405031449_qeobq UK004C 2026-04-06T12:15:45.689Z 2026-04-06T12:16:14.849Z
9608792 9608792 20260404013030_xVC87 UK004C 2026-04-05T12:11:42.141Z 2026-04-06T12:20:37.324Z
9600599 9600599 20260330235805_CbZa3 UK004C 2026-04-01T12:11:17.684Z 2026-04-06T12:33:41.885Z
9595495 9595495 20260330042247_2tlzY UK004C 2026-03-31T12:01:35.699Z 2026-04-06T12:30:06.523Z
9595244 9595244 20260330030826_ednWw UK004C 2026-03-31T12:00:52.682Z 2026-04-06T12:29:49.725Z
9595219 9595219 20260330030729_P1356 UK004C 2026-03-31T12:00:50.020Z 2026-04-06T12:29:48.794Z
9594460 9594460 20260328223154_erGWv UK004C 2026-03-30T12:09:38.256Z 2026-04-06T12:39:53.322Z
9592621 9592621 20260329024807_ieG6s UK004C 2026-03-30T12:01:27.200Z 2026-04-06T12:34:18.090Z
9592381 9592381 20260329015937_nK405 UK004C 2026-03-30T12:00:51.295Z 2026-04-06T12:34:08.723Z
9589998 9589998 20260328042607_xZW2S UK004C 2026-03-29T12:01:50.570Z 2026-04-06T12:37:45.482Z
9589839 9589839 20260328041053_rtluV UK004C 2026-03-29T12:01:39.755Z 2026-04-06T12:37:35.929Z
9589802 9589802 20260328040857_Q9nAS UK004C 2026-03-29T12:01:38.672Z 2026-04-06T12:37:33.714Z
9589664 9589664 20260328035735_Ol26y UK004C 2026-03-29T12:01:32.893Z 2026-04-06T12:37:31.005Z
9589278 9589278 20260328030552_aZvCV UK004C 2026-03-29T12:01:01.850Z 2026-04-06T12:37:10.917Z
9582015 9582015 20260326042158_snSVn UK004C 2026-03-27T12:04:25.259Z 2026-04-04T12:39:35.061Z
9581468 9581468 20260326031617_46F3t UK004C 2026-03-27T12:03:12.295Z 2026-04-04T12:39:07.316Z
9581260 9581260 20260326024455_KoNt3 UK004C 2026-03-27T12:02:34.775Z 2026-04-04T12:38:51.012Z
9581212 9581212 20260326023740_kSqBq UK004C 2026-03-27T12:02:25.086Z 2026-04-04T12:38:46.407Z
9581104 9581104 20260326022412_AFJOx UK004C 2026-03-27T12:02:09.543Z 2026-04-04T12:38:42.990Z
9580711 9580711 20260326012133_Hm285 UK004C 2026-03-27T12:01:14.261Z 2026-04-04T12:38:21.397Z
9580531 9580531 20260326005742_FMLj3 UK004C 2026-03-27T12:00:42.308Z 2026-04-04T12:38:13.082Z
9580521 9580521 20260326005742_3sQVy UK004C 2026-03-27T12:00:41.718Z 2026-04-04T12:38:12.906Z
9575810 9575810 20260325002103_k2NyJ UK004C 2026-03-26T12:00:17.692Z 2026-04-03T12:35:23.230Z
9575761 9575761 20260320195535_9h6ou UK004C 2026-03-25T12:35:51.828Z 2026-03-28T12:36:56.148Z
9562853 9562853 20260323032739_EzAPo UK004C 2026-03-24T12:04:17.203Z 2026-03-31T12:26:27.972Z
9562824 9562824 20260323032020_CyE29 UK004C 2026-03-24T12:04:10.610Z 2026-03-31T12:26:26.980Z
9562609 9562609 20260323024617_i93BF UK004C 2026-03-24T12:03:32.867Z 2026-03-31T12:26:15.499Z
9562528 9562528 20260323022921_T5z57 UK004C 2026-03-24T12:03:19.798Z 2026-03-31T12:26:13.518Z
9560757 9560757 20260321221142_jrRjm UK004C 2026-03-23T12:12:02.832Z 2026-03-29T12:21:02.606Z
9560226 9560226 20260321204918_HjP3E UK004C 2026-03-23T12:11:40.463Z 2026-03-29T12:20:58.710Z
9560015 9560015 20260321202327_WpDTC UK004C 2026-03-23T12:11:36.319Z 2026-03-29T12:20:57.434Z
9553185 9553185 20260322012339_lUY3w UK004C 2026-03-23T12:01:18.677Z 2026-03-30T12:27:36.222Z
9553072 9553072 20260322010853_PBRag UK004C 2026-03-23T12:01:11.463Z 2026-03-30T12:27:34.310Z
9551486 9551486 20260320195534_QVWN7 UK004C 2026-03-22T12:26:43.000Z 2026-03-28T12:36:56.049Z
9534465 9534465 20260320035120_ZIbZU UK004C 2026-03-21T12:08:03.879Z 2026-03-28T12:34:18.545Z
9534140 9534140 20260320033037_rtDrT UK004C 2026-03-21T12:07:15.620Z 2026-03-28T12:34:14.795Z
9534055 9534055 20260320031945_6hhyz UK004C 2026-03-21T12:07:00.773Z 2026-03-28T12:34:04.535Z
9533130 9533130 20260320020328_HOExB UK004C 2026-03-21T12:04:31.954Z 2026-03-28T12:33:49.111Z
9532989 9532989 20260320014433_vDhPN UK004C 2026-03-21T12:04:09.551Z 2026-03-28T12:33:47.222Z
9532173 9532173 20260320002822_qAYwG UK004C 2026-03-21T12:01:55.009Z 2026-03-28T12:33:25.287Z
9531999 9531999 20260320000707_LWCpx UK004C 2026-03-21T12:01:23.529Z 2026-03-28T12:33:23.626Z
9521346 9521346 20260319040806_vAt1S UK004C 2026-03-20T12:07:52.446Z 2026-03-27T12:40:54.020Z
9518528 9518528 20260319010630_eI1u0 UK004C 2026-03-20T12:02:46.583Z 2026-03-27T12:40:11.159Z
9518406 9518406 20260319005711_9v9Mv UK004C 2026-03-20T12:02:29.214Z 2026-03-27T12:40:09.293Z
9518281 9518281 20260319004736_M18nB UK004C 2026-03-20T12:02:15.427Z 2026-03-27T12:40:08.182Z
9518193 9518193 20260319004034_xSj6m UK004C 2026-03-20T12:02:05.929Z 2026-03-27T12:40:07.339Z
9518033 9518033 20260319002239_TQF33 UK004C 2026-03-20T12:01:47.074Z 2026-03-27T12:40:05.735Z
9516926 9516926 20260317221534_98YwW UK004C 2026-03-19T12:26:54.825Z 2026-03-25T12:43:07.563Z
9516753 9516753 20260317215345_AN1t2 UK004C 2026-03-19T12:26:45.044Z 2026-03-25T12:43:06.730Z
9516139 9516139 20260317200603_2uCaZ UK004C 2026-03-19T12:25:42.950Z 2026-03-25T12:42:49.310Z
9511745 9511745 20260318041453_IKec8 UK004C 2026-03-19T12:10:53.103Z 2026-03-26T12:37:39.350Z
9511331 9511331 20260318034705_GX3xT UK004C 2026-03-19T12:09:57.767Z 2026-03-26T12:37:35.970Z
9509798 9509798 20260318021528_jcU9e UK004C 2026-03-19T12:06:12.796Z 2026-03-26T12:37:07.910Z
9509258 9509258 20260318013751_iNRaT UK004C 2026-03-19T12:04:53.951Z 2026-03-26T12:37:04.231Z
9509250 9509250 20260318013751_RDKe8 UK004C 2026-03-19T12:04:53.645Z 2026-03-26T12:37:04.205Z
9508572 9508572 20260318010319_9IkBy UK004C 2026-03-19T12:03:21.318Z 2026-03-26T12:36:59.352Z
9501583 9501583 20260315224525_3bHqj UK004C 2026-03-17T12:25:15.755Z 2026-03-23T12:22:44.958Z
9494398 9494398 20260316021046_789Ly UK004C 2026-03-17T12:03:54.097Z 2026-03-24T12:40:47.447Z
9494067 9494067 20260316012255_AIOIz UK004C 2026-03-17T12:02:55.032Z 2026-03-24T12:40:44.307Z
9485950 9485950 20260315041805_AcDlW UK004C 2026-03-16T12:08:08.397Z 2026-03-23T12:21:54.631Z
9485434 9485434 20260315030501_4o3cz UK004C 2026-03-16T12:06:25.862Z 2026-03-23T12:21:52.245Z
9484974 9484974 20260315020842_FdvHQ UK004C 2026-03-16T12:04:49.157Z 2026-03-23T12:21:49.393Z
9484923 9484923 20260315015954_Nj2w9 UK004C 2026-03-16T12:04:37.995Z 2026-03-23T12:21:49.029Z
9483944 9483944 20260314233107_CDLe9 UK004C 2026-03-16T12:01:03.177Z 2026-03-23T12:21:44.532Z
9483917 9483917 20260314232525_Bc5wg UK004C 2026-03-16T12:00:58.783Z 2026-03-23T12:21:44.440Z
9483705 9483705 20260314230857_WxPFb UK004C 2026-03-16T12:00:29.582Z 2026-03-23T12:21:43.733Z
9483550 9483550 20260313224254_QP3Qm UK004C 2026-03-15T12:26:39.909Z 2026-03-21T12:50:28.407Z
9483411 9483411 20260313220504_lUJc7 UK004C 2026-03-15T12:26:24.006Z 2026-03-21T12:50:27.466Z
9477460 9477460 20260314045825_WRLH3 UK004C 2026-03-15T12:08:21.228Z 2026-03-22T12:42:02.960Z
9476732 9476732 20260314033734_652Vr UK004C 2026-03-15T12:06:44.279Z 2026-03-22T12:41:58.897Z
9476692 9476692 20260314033226_sibpj UK004C 2026-03-15T12:06:39.668Z 2026-03-22T12:41:58.635Z
9475284 9475284 20260314010956_2NtvD UK004C 2026-03-15T12:02:45.641Z 2026-03-22T12:41:31.279Z
9474517 9474517 20260313230611_igZ3B UK004C 2026-03-15T12:00:25.510Z 2026-03-22T12:41:21.048Z
9467298 9467298 20260311211256_a8pYY UK004C 2026-03-13T12:19:01.863Z 2026-03-19T12:45:51.396Z
9464170 9464170 20260312035038_iXkA8 UK004C 2026-03-13T12:06:31.143Z 2026-03-20T12:36:31.742Z
9463569 9463569 20260312020755_0khJQ UK004C 2026-03-13T12:04:32.924Z 2026-03-20T12:36:23.401Z
9463564 9463564 20260312020755_moAVT UK004C 2026-03-13T12:04:31.916Z 2026-03-20T12:36:23.379Z
9462794 9462794 20260312001347_EGDgi UK004C 2026-03-13T12:02:09.638Z 2026-03-20T12:36:18.030Z
9462320 9462320 20260311225334_9DpJS UK004C 2026-03-13T12:00:30.092Z 2026-03-20T12:36:15.081Z
9426976 9426976 20260305052100_GqwIA UK004C 2026-03-06T14:07:06.609Z 2026-03-13T12:34:52.967Z
9419701 9419701 20260303052903_iZCOG UK004C 2026-03-04T14:01:56.500Z 2026-03-11T12:28:05.098Z
9419685 9419685 20260303051800_GDreX UK004C 2026-03-04T14:01:54.132Z 2026-03-11T12:28:04.806Z
9395022 9395022 20260224223654_w2EhE UK004C 2026-02-26T14:20:59.862Z 2026-03-04T14:19:29.211Z
9394824 9394824 20260224215527_vm3d3 UK004C 2026-02-26T14:20:42.424Z 2026-03-04T14:19:27.491Z
9394726 9394726 20260224213750_BI6LS UK004C 2026-02-26T14:20:33.860Z 2026-03-04T14:19:26.691Z
9392580 9392580 20260225044823_ka9kk UK004C 2026-02-26T14:07:41.544Z 2026-03-05T14:37:01.556Z
9392503 9392503 20260225043338_zju22 UK004C 2026-02-26T14:07:30.880Z 2026-03-05T14:36:59.305Z
9392207 9392207 20260225035251_wtTgA UK004C 2026-02-26T14:06:45.911Z 2026-03-05T14:36:51.610Z
9392023 9392023 20260225033604_AoBcm UK004C 2026-02-26T14:06:13.063Z 2026-03-05T14:36:41.414Z
9391598 9391598 20260225025940_61vqM UK004C 2026-02-26T14:04:48.475Z 2026-03-05T14:36:25.160Z
9391405 9391405 20260225023455_kQP2M UK004C 2026-02-26T14:04:15.733Z 2026-03-05T14:36:19.624Z
9391109 9391109 20260225020140_3PZ3S UK004C 2026-02-26T14:03:31.360Z 2026-03-05T14:36:06.217Z
9391092 9391092 20260225015935_QIsek UK004C 2026-02-26T14:03:27.624Z 2026-03-05T14:36:05.943Z
9390491 9390491 20260225003659_BNZbo UK004C 2026-02-26T14:01:32.305Z 2026-03-05T14:35:47.887Z
9390408 9390408 20260225002751_pIvej UK004C 2026-02-26T14:01:20.342Z 2026-03-05T14:35:40.851Z
9383268 9383268 20260224023930_DcYhW UK004C 2026-02-25T14:00:47.673Z 2026-03-04T14:17:37.050Z
9381239 9381239 20260222212533_XjT9E UK004C 2026-02-24T14:24:26.688Z 2026-02-24T14:24:26.688Z
9373234 9373234 20260223023207_BxJ93 UK004C 2026-02-24T14:02:30.996Z 2026-03-03T14:31:00.260Z
9373077 9373077 20260223020735_znkP0 UK004C 2026-02-24T14:02:09.573Z 2026-03-03T14:30:50.931Z
9372549 9372549 20260223003305_ZCU6j UK004C 2026-02-24T14:00:50.975Z 2026-03-03T14:30:42.168Z

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