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 = "UK007B" 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
9608454 9608454 20260403231116_uFEEK UK007B 2026-04-05T12:10:28.844Z 2026-04-06T12:20:13.611Z
9602890 9602890 20260402035614_78DAU UK007B 2026-04-03T12:01:05.340Z 2026-04-06T12:21:19.419Z
9602819 9602819 20260402033206_7pN3p UK007B 2026-04-03T12:00:47.033Z 2026-04-06T12:21:14.533Z
9602737 9602737 20260402025640_bloUJ UK007B 2026-04-03T12:00:24.915Z 2026-04-06T12:21:07.011Z
9602719 9602719 20260402025113_nSuQD UK007B 2026-04-03T12:00:21.154Z 2026-04-06T12:21:05.595Z
9600695 9600695 20260331011735_vxlxS UK007B 2026-04-01T12:11:34.030Z 2026-04-06T12:33:46.460Z
9598533 9598533 20260330010242_ypJZR UK007B 2026-03-31T12:10:49.422Z 2026-04-06T12:36:44.559Z
9598518 9598518 20260330005639_VGsUG UK007B 2026-03-31T12:10:47.966Z 2026-04-06T12:36:44.047Z
9595522 9595522 20260330043144_wwqH4 UK007B 2026-03-31T12:01:38.418Z 2026-04-06T12:30:07.590Z
9595508 9595508 20260330042529_8HX0E UK007B 2026-03-31T12:01:36.396Z 2026-04-06T12:30:06.792Z
9595372 9595372 20260330034728_sUD9A UK007B 2026-03-31T12:01:14.174Z 2026-04-06T12:29:59.850Z
9595189 9595189 20260330025805_Eq95j UK007B 2026-03-31T12:00:45.068Z 2026-04-06T12:29:47.483Z
9595128 9595128 20260330023035_H8Ubs UK007B 2026-03-31T12:00:32.393Z 2026-04-06T12:29:41.613Z
9595015 9595015 20260330013758_ibmrg UK007B 2026-03-31T12:00:11.594Z 2026-04-06T12:29:34.953Z
9594904 9594904 20260329010039_BkSNP UK007B 2026-03-30T12:10:35.966Z 2026-04-06T12:40:20.186Z
9594887 9594887 20260329005455_pQtfB UK007B 2026-03-30T12:10:31.831Z 2026-04-06T12:40:19.621Z
9594840 9594840 20260329004326_13a1j UK007B 2026-03-30T12:10:25.042Z 2026-04-06T12:40:17.773Z
9594700 9594700 20260329000314_5JHCp UK007B 2026-03-30T12:10:11.179Z 2026-04-06T12:40:07.981Z
9594482 9594482 20260328223709_LpHpF UK007B 2026-03-30T12:09:40.367Z 2026-04-06T12:39:54.142Z
9594229 9594229 20260328202811_Vai4V UK007B 2026-03-30T12:09:02.662Z 2026-04-06T12:39:44.050Z
9592347 9592347 20260329015643_9G0mh UK007B 2026-03-30T12:00:45.700Z 2026-04-06T12:34:01.855Z
9592217 9592217 20260329012612_vjsAJ UK007B 2026-03-30T12:00:25.042Z 2026-04-06T12:33:54.222Z
9592197 9592197 20260329012110_u2goE UK007B 2026-03-30T12:00:21.960Z 2026-04-06T12:33:53.413Z
9592141 9592141 20260328005627_PtNhR UK007B 2026-03-29T12:07:12.946Z 2026-04-05T12:35:38.542Z
9592065 9592065 20260328000948_g0c3C UK007B 2026-03-29T12:07:09.063Z 2026-04-05T12:35:25.854Z
9592043 9592043 20260328000336_BWFVg UK007B 2026-03-29T12:07:07.775Z 2026-04-05T12:35:25.119Z
9589876 9589876 20260328041450_3gUQ0 UK007B 2026-03-29T12:01:42.019Z 2026-04-06T12:37:37.025Z
9589645 9589645 20260328035457_XyUJU UK007B 2026-03-29T12:01:31.545Z 2026-04-06T12:37:30.189Z
9589560 9589560 20260328034710_c7n7h UK007B 2026-03-29T12:01:26.024Z 2026-04-06T12:37:27.707Z
9589006 9589006 20260328021248_jcZ1E UK007B 2026-03-29T12:00:37.449Z 2026-04-06T12:36:59.192Z
9585306 9585306 20260326001209_AW4C8 UK007B 2026-03-27T12:17:06.256Z 2026-04-03T12:39:54.515Z
9585166 9585166 20260325233750_ai2lA UK007B 2026-03-27T12:16:52.858Z 2026-04-03T12:39:50.946Z
9584427 9584427 20260325195058_5UwN2 UK007B 2026-03-27T12:15:17.913Z 2026-04-03T12:39:13.866Z
9584401 9584401 20260325194702_mQMGI UK007B 2026-03-27T12:15:13.458Z 2026-04-03T12:39:13.171Z
9581846 9581846 20260326040209_946lO UK007B 2026-03-27T12:03:56.454Z 2026-04-04T12:39:22.167Z
9581837 9581837 20260326040209_qYvff UK007B 2026-03-27T12:03:56.080Z 2026-04-04T12:39:21.997Z
9581146 9581146 20260326023003_rdGbr UK007B 2026-03-27T12:02:15.123Z 2026-04-04T12:38:44.123Z
9581007 9581007 20260326020818_zPVnZ UK007B 2026-03-27T12:01:54.000Z 2026-04-04T12:38:39.512Z
9580819 9580819 20260326013932_5Qy36 UK007B 2026-03-27T12:01:30.037Z 2026-04-04T12:38:30.553Z
9580458 9580458 20260326005033_tCgan UK007B 2026-03-27T12:00:31.606Z 2026-04-04T12:38:10.930Z
9580446 9580446 20260326004951_TBMOf UK007B 2026-03-27T12:00:30.278Z 2026-04-04T12:38:10.666Z
9580138 9580138 20260325001104_Fv99Y UK007B 2026-03-26T12:15:09.398Z 2026-04-02T12:37:43.366Z
9579620 9579620 20260324215923_7XMxc UK007B 2026-03-26T12:14:05.502Z 2026-04-02T12:37:18.141Z
9579591 9579591 20260324214517_wtisn UK007B 2026-03-26T12:14:02.823Z 2026-04-02T12:37:17.141Z
9576370 9576370 20260325015744_N0zrn UK007B 2026-03-26T12:02:02.636Z 2026-04-03T12:35:55.082Z
9576256 9576256 20260325014446_UeJE2 UK007B 2026-03-26T12:01:44.126Z 2026-04-03T12:35:50.537Z
9576197 9576197 20260325013410_5E5vj UK007B 2026-03-26T12:01:32.750Z 2026-04-03T12:35:48.185Z
9561869 9561869 20260323005158_aZn5w UK007B 2026-03-24T12:01:29.695Z 2026-03-31T12:25:55.458Z
9561256 9561256 20260321231312_sf2Lu UK007B 2026-03-23T12:12:14.943Z 2026-03-29T12:21:05.991Z
9561140 9561140 20260321230318_BendX UK007B 2026-03-23T12:12:12.182Z 2026-03-29T12:21:05.325Z
9561016 9561016 20260321224510_0pUl5 UK007B 2026-03-23T12:12:09.516Z 2026-03-29T12:21:04.630Z
9555090 9555090 20260322040324_FGCGC UK007B 2026-03-23T12:03:09.716Z 2026-03-30T12:28:14.351Z
9554929 9554929 20260322034610_5uOZ1 UK007B 2026-03-23T12:02:57.198Z 2026-03-30T12:28:11.777Z
9554909 9554909 20260322034329_2pm2k UK007B 2026-03-23T12:02:56.343Z 2026-03-30T12:28:11.413Z
9554722 9554722 20260322033229_du2kq UK007B 2026-03-23T12:02:48.284Z 2026-03-30T12:28:08.009Z
9554633 9554633 20260322032216_3fuyd UK007B 2026-03-23T12:02:44.026Z 2026-03-30T12:28:06.610Z
9554145 9554145 20260322024312_6tSMT UK007B 2026-03-23T12:02:16.049Z 2026-03-30T12:27:59.011Z
9553718 9553718 20260322020906_pQ5zU UK007B 2026-03-23T12:01:47.894Z 2026-03-30T12:27:51.506Z
9553516 9553516 20260322014706_69bYK UK007B 2026-03-23T12:01:35.613Z 2026-03-30T12:27:42.432Z
9553358 9553358 20260322013209_VuSYC UK007B 2026-03-23T12:01:25.133Z 2026-03-30T12:27:39.663Z
9553309 9553309 20260322013003_EdXIT UK007B 2026-03-23T12:01:23.671Z 2026-03-30T12:27:39.257Z
9552314 9552314 20260321235023_zPilT UK007B 2026-03-23T12:00:13.915Z 2026-03-30T12:27:22.181Z
9551781 9551781 20260320212841_0IWaX UK007B 2026-03-22T12:27:02.357Z 2026-03-28T12:37:01.935Z
9549131 9549131 20260319234912_zGaBY UK007B 2026-03-22T12:16:49.315Z 2026-03-28T12:33:21.534Z
9542337 9542337 20260319231330_DECVW UK007B 2026-03-21T12:29:58.466Z 2026-03-27T12:42:57.486Z
9542172 9542172 20260319225536_7JP73 UK007B 2026-03-21T12:29:49.746Z 2026-03-27T12:42:46.195Z
9541989 9541989 20260319222411_Bi6Ho UK007B 2026-03-21T12:29:33.756Z 2026-03-27T12:42:43.840Z
9541750 9541750 20260319213602_RrwxM UK007B 2026-03-21T12:29:19.716Z 2026-03-27T12:42:41.318Z
9541318 9541318 20260319201627_pGw0v UK007B 2026-03-21T12:28:49.654Z 2026-03-27T12:42:36.488Z
9541231 9541231 20260319200708_X8zOz UK007B 2026-03-21T12:28:45.658Z 2026-03-27T12:42:35.756Z
9534824 9534824 20260320042842_gm2MZ UK007B 2026-03-21T12:08:59.604Z 2026-03-28T12:34:22.639Z
9533629 9533629 20260320024726_7xtGq UK007B 2026-03-21T12:05:55.255Z 2026-03-28T12:33:57.273Z
9533435 9533435 20260320023052_zWKQQ UK007B 2026-03-21T12:05:26.632Z 2026-03-28T12:33:53.070Z
9533305 9533305 20260320022351_jrnZ6 UK007B 2026-03-21T12:05:07.855Z 2026-03-28T12:33:51.821Z
9532964 9532964 20260320014328_d1a4p UK007B 2026-03-21T12:04:07.886Z 2026-03-28T12:33:47.146Z
9532849 9532849 20260320013335_0HpIw UK007B 2026-03-21T12:03:48.295Z 2026-03-28T12:33:45.110Z
9532790 9532790 20260320012705_CEYai UK007B 2026-03-21T12:03:39.487Z 2026-03-28T12:33:44.069Z
9532629 9532629 20260320011435_vxs1F UK007B 2026-03-21T12:03:16.180Z 2026-03-28T12:33:34.805Z
9532527 9532527 20260320010511_uVJRK UK007B 2026-03-21T12:03:00.741Z 2026-03-28T12:33:33.613Z
9532414 9532414 20260320005319_rykQm UK007B 2026-03-21T12:02:39.319Z 2026-03-28T12:33:30.109Z
9532221 9532221 20260320004017_wUd17 UK007B 2026-03-21T12:02:07.471Z 2026-03-28T12:33:26.014Z
9532086 9532086 20260320001809_HUCTk UK007B 2026-03-21T12:01:40.932Z 2026-03-28T12:33:24.513Z
9532076 9532076 20260320001648_Y5DEp UK007B 2026-03-21T12:01:39.758Z 2026-03-28T12:33:24.444Z
9532046 9532046 20260320001302_4L3r0 UK007B 2026-03-21T12:01:34.269Z 2026-03-28T12:33:24.213Z
9531386 9531386 20260318230308_B0LJT UK007B 2026-03-20T12:25:09.078Z 2026-03-26T12:39:19.124Z
9531337 9531337 20260318225829_LCwMO UK007B 2026-03-20T12:25:07.156Z 2026-03-26T12:39:18.892Z
9531029 9531029 20260318222015_On2Wp UK007B 2026-03-20T12:24:55.268Z 2026-03-26T12:39:17.098Z
9530740 9530740 20260318213433_iQfWC UK007B 2026-03-20T12:24:45.186Z 2026-03-26T12:39:15.149Z
9530496 9530496 20260318210324_SDE4T UK007B 2026-03-20T12:24:26.915Z 2026-03-26T12:39:13.020Z
9521762 9521762 20260319044236_RQJ3N UK007B 2026-03-20T12:08:30.704Z 2026-03-27T12:41:10.573Z
9521563 9521563 20260319042655_27cnH UK007B 2026-03-20T12:08:14.113Z 2026-03-27T12:40:55.842Z
9520738 9520738 20260319033413_C6Ekm UK007B 2026-03-20T12:06:53.593Z 2026-03-27T12:40:46.798Z
9520562 9520562 20260319032509_W0eYt UK007B 2026-03-20T12:06:34.236Z 2026-03-27T12:40:44.879Z
9520219 9520219 20260319030443_dEMcJ UK007B 2026-03-20T12:05:59.813Z 2026-03-27T12:40:40.652Z
9519909 9519909 20260319024320_9MkpZ UK007B 2026-03-20T12:05:22.735Z 2026-03-27T12:40:37.006Z
9519821 9519821 20260319023922_Q5ZSI UK007B 2026-03-20T12:05:12.081Z 2026-03-27T12:40:36.013Z
9519390 9519390 20260319020624_vGvZf UK007B 2026-03-20T12:04:24.132Z 2026-03-27T12:40:30.664Z
9518077 9518077 20260319002647_eEnch UK007B 2026-03-20T12:01:51.567Z 2026-03-27T12:40:06.161Z
9517847 9517847 20260319000630_96voQ UK007B 2026-03-20T12:01:24.158Z 2026-03-27T12:40:04.029Z
9516107 9516107 20260317200420_amMKV UK007B 2026-03-19T12:25:40.941Z 2026-03-25T12:42:48.820Z

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