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 = "UK00AN" 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
9611790 9611790 20260405032412_hWkxn UK00AN 2026-04-06T12:16:00.350Z 2026-04-06T12:16:14.863Z
9610985 9610985 20260404231319_DwIJT UK00AN 2026-04-06T12:12:26.144Z 2026-04-06T12:16:14.705Z
9609190 9609190 20260405035601_yvCly UK00AN 2026-04-06T12:00:40.306Z 2026-04-06T12:00:40.306Z
9609118 9609118 20260405033841_Hhjfw UK00AN 2026-04-06T12:00:20.923Z 2026-04-06T12:00:20.923Z
9609037 9609037 20260404030720_IZDFs UK00AN 2026-04-05T12:12:44.668Z 2026-04-06T12:20:58.346Z
9609021 9609021 20260404030618_OyA8K UK00AN 2026-04-05T12:12:37.404Z 2026-04-06T12:20:57.429Z
9608920 9608920 20260404023938_vJLQu UK00AN 2026-04-05T12:12:17.932Z 2026-04-06T12:20:51.032Z
9608751 9608751 20260404011053_zdOf7 UK00AN 2026-04-05T12:11:30.502Z 2026-04-06T12:20:35.162Z
9608744 9608744 20260404011048_alQUb UK00AN 2026-04-05T12:11:29.886Z 2026-04-06T12:20:34.938Z
9608729 9608729 20260404010220_phfxT UK00AN 2026-04-05T12:11:27.596Z 2026-04-06T12:20:34.148Z
9608681 9608681 20260404003835_hR622 UK00AN 2026-04-05T12:11:16.431Z 2026-04-06T12:20:30.231Z
9608648 9608648 20260404001901_YSH13 UK00AN 2026-04-05T12:11:11.790Z 2026-04-06T12:20:28.378Z
9608640 9608640 20260404001403_Wh9e2 UK00AN 2026-04-05T12:11:04.538Z 2026-04-06T12:20:27.816Z
9608523 9608523 20260403233127_a5szt UK00AN 2026-04-05T12:10:43.786Z 2026-04-06T12:20:18.546Z
9608320 9608320 20260403214956_f3W1a UK00AN 2026-04-05T12:10:00.704Z 2026-04-06T12:20:05.480Z
9608163 9608163 20260403202352_Vjtf3 UK00AN 2026-04-05T12:09:08.372Z 2026-04-06T12:19:47.216Z
9607153 9607153 20260404040548_TDIt2 UK00AN 2026-04-05T12:00:37.257Z 2026-04-06T12:16:14.373Z
9607133 9607133 20260404034726_okBM4 UK00AN 2026-04-05T12:00:32.468Z 2026-04-06T12:16:14.369Z
9607093 9607093 20260404033151_yXAwP UK00AN 2026-04-05T12:00:23.952Z 2026-04-06T12:16:14.359Z
9602599 9602599 20260401001127_nLLkZ UK00AN 2026-04-02T12:09:29.398Z 2026-04-06T12:29:25.262Z
9602570 9602570 20260331233920_CXqUx UK00AN 2026-04-02T12:09:23.111Z 2026-04-06T12:29:23.688Z
9598446 9598446 20260330001346_JZTDW UK00AN 2026-03-31T12:10:37.572Z 2026-04-06T12:36:32.819Z
9595298 9595298 20260330031912_y7apo UK00AN 2026-03-31T12:01:01.235Z 2026-04-06T12:29:54.945Z
9594965 9594965 20260329010828_WwGLj UK00AN 2026-03-30T12:10:41.514Z 2026-04-06T12:40:21.671Z
9594876 9594876 20260329005422_cT1Ex UK00AN 2026-03-30T12:10:30.935Z 2026-04-06T12:40:19.342Z
9594679 9594679 20260328235038_HNQaR UK00AN 2026-03-30T12:10:08.774Z 2026-04-06T12:40:03.473Z
9594515 9594515 20260328224602_RrMag UK00AN 2026-03-30T12:09:43.681Z 2026-04-06T12:39:55.362Z
9594468 9594468 20260328223155_T8dJQ UK00AN 2026-03-30T12:09:38.658Z 2026-04-06T12:39:53.426Z
9594396 9594396 20260328220611_YLCTD UK00AN 2026-03-30T12:09:27.934Z 2026-04-06T12:39:50.628Z
9594373 9594373 20260328215357_Dct3P UK00AN 2026-03-30T12:09:24.860Z 2026-04-06T12:39:49.822Z
9592638 9592638 20260329025009_PK0dg UK00AN 2026-03-30T12:01:28.633Z 2026-04-06T12:34:18.433Z
9592517 9592517 20260329021945_FbKD3 UK00AN 2026-03-30T12:01:09.794Z 2026-04-06T12:34:13.382Z
9592395 9592395 20260329015937_QXjfn UK00AN 2026-03-30T12:00:51.842Z 2026-04-06T12:34:08.906Z
9592242 9592242 20260329012928_MOiJs UK00AN 2026-03-30T12:00:26.905Z 2026-04-06T12:33:54.854Z
9592224 9592224 20260329012633_bPeF0 UK00AN 2026-03-30T12:00:25.573Z 2026-04-06T12:33:54.333Z
9592179 9592179 20260329011843_A30yY UK00AN 2026-03-30T12:00:16.871Z 2026-04-06T12:33:52.430Z
9592112 9592112 20260328003742_QnuKr UK00AN 2026-03-29T12:07:11.028Z 2026-04-05T12:35:37.169Z
9592026 9592026 20260327235929_6v0iH UK00AN 2026-03-29T12:07:06.654Z 2026-04-05T12:35:24.531Z
9591898 9591898 20260327230010_qi34L UK00AN 2026-03-29T12:06:54.429Z 2026-04-05T12:35:18.932Z
9589843 9589843 20260328041053_rtluV UK00AN 2026-03-29T12:01:39.772Z 2026-04-06T12:37:35.929Z
9589803 9589803 20260328040857_Q9nAS UK00AN 2026-03-29T12:01:38.672Z 2026-04-06T12:37:33.714Z
9589517 9589517 20260328033840_L7jUP UK00AN 2026-03-29T12:01:23.103Z 2026-04-06T12:37:26.505Z
9589348 9589348 20260328031739_YHQzl UK00AN 2026-03-29T12:01:07.652Z 2026-04-06T12:37:20.593Z
9589335 9589335 20260328031734_dfZAQ UK00AN 2026-03-29T12:01:06.936Z 2026-04-06T12:37:20.308Z
9589174 9589174 20260328023959_lgWkm UK00AN 2026-03-29T12:00:48.961Z 2026-04-06T12:37:04.145Z
9589124 9589124 20260328022742_3ZEAC UK00AN 2026-03-29T12:00:44.069Z 2026-04-06T12:37:02.108Z
9589104 9589104 20260328022610_65So6 UK00AN 2026-03-29T12:00:43.259Z 2026-04-06T12:37:01.822Z
9589072 9589072 20260328022230_nV3JW UK00AN 2026-03-29T12:00:41.877Z 2026-04-06T12:37:01.138Z
9589029 9589029 20260328021320_6xRWy UK00AN 2026-03-29T12:00:38.121Z 2026-04-06T12:36:59.498Z
9588884 9588884 20260328014711_0jM1I UK00AN 2026-03-29T12:00:26.393Z 2026-04-06T12:36:55.555Z
9588826 9588826 20260328012825_2ynwd UK00AN 2026-03-29T12:00:19.693Z 2026-04-06T12:36:52.990Z
9588772 9588772 20260328011211_PsVh2 UK00AN 2026-03-29T12:00:13.261Z 2026-04-06T12:36:50.632Z
9585312 9585312 20260326001209_AW4C8 UK00AN 2026-03-27T12:17:06.256Z 2026-04-03T12:39:54.515Z
9585028 9585028 20260325230656_Ha3wx UK00AN 2026-03-27T12:16:33.034Z 2026-04-03T12:39:46.844Z
9584982 9584982 20260325225712_rMep6 UK00AN 2026-03-27T12:16:27.736Z 2026-04-03T12:39:45.499Z
9584944 9584944 20260325225153_baO6V UK00AN 2026-03-27T12:16:25.162Z 2026-04-03T12:39:44.883Z
9584915 9584915 20260325223813_56Nwm UK00AN 2026-03-27T12:16:21.305Z 2026-04-03T12:39:44.089Z
9584847 9584847 20260325222714_fFuAH UK00AN 2026-03-27T12:16:15.334Z 2026-04-03T12:39:42.250Z
9584820 9584820 20260325222152_Kj3J5 UK00AN 2026-03-27T12:16:10.442Z 2026-04-03T12:39:41.628Z
9584734 9584734 20260325215038_ep3bt UK00AN 2026-03-27T12:16:01.188Z 2026-04-03T12:39:30.982Z
9584686 9584686 20260325213555_z2TiH UK00AN 2026-03-27T12:15:57.699Z 2026-04-03T12:39:26.382Z
9584672 9584672 20260325213401_81q2t UK00AN 2026-03-27T12:15:56.591Z 2026-04-03T12:39:26.046Z
9584508 9584508 20260325201848_twLF6 UK00AN 2026-03-27T12:15:31.221Z 2026-04-03T12:39:17.586Z
9582157 9582157 20260326044233_3wgLX UK00AN 2026-03-27T12:04:44.049Z 2026-04-04T12:39:38.874Z
9582138 9582138 20260326044055_FeCwM UK00AN 2026-03-27T12:04:42.839Z 2026-04-04T12:39:38.587Z
9582019 9582019 20260326042158_snSVn UK00AN 2026-03-27T12:04:25.260Z 2026-04-04T12:39:35.061Z
9581775 9581775 20260326035611_3U2Hi UK00AN 2026-03-27T12:03:50.185Z 2026-04-04T12:39:20.353Z
9581696 9581696 20260326034454_grGDi UK00AN 2026-03-27T12:03:40.733Z 2026-04-04T12:39:15.062Z
9581589 9581589 20260326033246_5tDNt UK00AN 2026-03-27T12:03:26.862Z 2026-04-04T12:39:11.295Z
9581297 9581297 20260326024702_2Cqdr UK00AN 2026-03-27T12:02:39.678Z 2026-04-04T12:38:51.919Z
9581266 9581266 20260326024455_KoNt3 UK00AN 2026-03-27T12:02:34.775Z 2026-04-04T12:38:51.012Z
9581195 9581195 20260326023416_zUB2z UK00AN 2026-03-27T12:02:20.569Z 2026-04-04T12:38:45.264Z
9580996 9580996 20260326020739_R3fyr UK00AN 2026-03-27T12:01:51.559Z 2026-04-04T12:38:38.599Z
9580948 9580948 20260326015715_T79vB UK00AN 2026-03-27T12:01:44.895Z 2026-04-04T12:38:35.527Z
9580921 9580921 20260326015241_cEP5Z UK00AN 2026-03-27T12:01:41.388Z 2026-04-04T12:38:33.694Z
9580766 9580766 20260326012729_Woe3T UK00AN 2026-03-27T12:01:22.194Z 2026-04-04T12:38:28.476Z
9580762 9580762 20260326012729_Yrky3 UK00AN 2026-03-27T12:01:21.828Z 2026-04-04T12:38:27.956Z
9580724 9580724 20260326012234_fGn3C UK00AN 2026-03-27T12:01:14.937Z 2026-04-04T12:38:21.530Z
9580634 9580634 20260326011104_xTsLH UK00AN 2026-03-27T12:00:59.779Z 2026-04-04T12:38:18.823Z
9580536 9580536 20260326005742_FMLj3 UK00AN 2026-03-27T12:00:42.327Z 2026-04-04T12:38:13.082Z
9580522 9580522 20260326005742_3sQVy UK00AN 2026-03-27T12:00:41.730Z 2026-04-04T12:38:12.906Z
9580422 9580422 20260326004652_yRJWL UK00AN 2026-03-27T12:00:26.135Z 2026-04-04T12:38:09.522Z
9580365 9580365 20260326003912_93qzV UK00AN 2026-03-27T12:00:16.599Z 2026-04-04T12:38:07.346Z
9580357 9580357 20260326003906_bYRGT UK00AN 2026-03-27T12:00:15.641Z 2026-04-04T12:38:07.135Z
9580319 9580319 20260326002905_cEIhe UK00AN 2026-03-27T12:00:09.753Z 2026-04-04T12:38:05.366Z
9580023 9580023 20260324234848_jTlme UK00AN 2026-03-26T12:14:53.780Z 2026-04-02T12:37:39.239Z
9580021 9580021 20260324234848_aRIe7 UK00AN 2026-03-26T12:14:53.476Z 2026-04-02T12:37:39.110Z
9579786 9579786 20260324224955_5RHHi UK00AN 2026-03-26T12:14:24.158Z 2026-04-02T12:37:30.042Z
9579782 9579782 20260324224954_5O9eS UK00AN 2026-03-26T12:14:23.939Z 2026-04-02T12:37:29.907Z
9579685 9579685 20260324221709_YHzQo UK00AN 2026-03-26T12:14:12.621Z 2026-04-02T12:37:25.982Z
9577272 9577272 20260325043109_7kjQO UK00AN 2026-03-26T12:04:37.223Z 2026-04-03T12:36:54.146Z
9577101 9577101 20260325035436_idzxc UK00AN 2026-03-26T12:04:09.396Z 2026-04-03T12:36:34.490Z
9576443 9576443 20260325020739_aUGqY UK00AN 2026-03-26T12:02:14.912Z 2026-04-03T12:35:58.945Z
9575738 9575738 20260321202452_KSHc5 UK00AN 2026-03-25T12:31:32.766Z 2026-03-29T12:20:57.460Z
9561921 9561921 20260323005727_5cQ7c UK00AN 2026-03-24T12:01:36.690Z 2026-03-31T12:25:56.536Z
9561366 9561366 20260321232535_WyWd8 UK00AN 2026-03-23T12:12:17.254Z 2026-03-29T12:21:06.631Z
9561344 9561344 20260321232411_tD7cI UK00AN 2026-03-23T12:12:17.019Z 2026-03-29T12:21:06.565Z
9561010 9561010 20260321224508_Gnmmi UK00AN 2026-03-23T12:12:09.332Z 2026-03-29T12:21:04.587Z
9560889 9560889 20260321223136_OdI9d UK00AN 2026-03-23T12:12:06.624Z 2026-03-29T12:21:03.708Z
9560871 9560871 20260321223002_4QiV3 UK00AN 2026-03-23T12:12:05.990Z 2026-03-29T12:21:03.502Z

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