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

8,567 rows where station_code = "UK003C" 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
8971626 8971626 20251217002449_7MWRa UK003C 2025-12-25T14:54:02.592Z 2025-12-25T14:54:02.592Z
8971612 8971612 20251217002440_ikne8 UK003C 2025-12-25T14:54:02.199Z 2025-12-25T14:54:02.199Z
8970532 8970532 20251216224921_zO5ER UK003C 2025-12-25T14:52:45.896Z 2025-12-25T14:52:45.896Z
8970078 8970078 20251216214619_tpF3F UK003C 2025-12-25T14:52:04.885Z 2025-12-25T14:52:04.885Z
8969223 8969223 20251216190208_a3vol UK003C 2025-12-25T14:50:46.969Z 2025-12-25T14:50:46.969Z
8969019 8969019 20251216181357_BFENz UK003C 2025-12-25T14:50:16.856Z 2025-12-25T14:50:16.856Z
8906973 8906973 20251214055325_G7VC0 UK003C 2025-12-23T14:08:08.323Z 2025-12-24T14:21:37.519Z
8906831 8906831 20251214055124_y5XOm UK003C 2025-12-23T14:08:07.587Z 2025-12-24T14:21:36.317Z
8904751 8904751 20251214052144_LZhPc UK003C 2025-12-23T14:07:32.942Z 2025-12-24T14:20:31.330Z
8904414 8904414 20251214051740_k32Q2 UK003C 2025-12-23T14:07:21.147Z 2025-12-24T14:20:27.015Z
8899733 8899733 20251214042804_RDjyg UK003C 2025-12-23T14:04:23.164Z 2025-12-24T14:17:50.438Z
8899633 8899633 20251214042704_rf4Cq UK003C 2025-12-23T14:04:16.175Z 2025-12-24T14:17:47.969Z
8899067 8899067 20251214042143_N0xlk UK003C 2025-12-23T14:04:04.712Z 2025-12-24T14:17:36.347Z
8898690 8898690 20251214041727_8L62a UK003C 2025-12-23T14:04:02.295Z 2025-12-24T14:17:08.203Z
8898643 8898643 20251214041701_njmoi UK003C 2025-12-23T14:04:01.889Z 2025-12-24T14:17:07.430Z
8898590 8898590 20251214041634_iE3V2 UK003C 2025-12-23T14:04:01.713Z 2025-12-24T14:17:06.781Z
8898326 8898326 20251214041454_3Kc0q UK003C 2025-12-23T14:03:59.583Z 2025-12-24T14:17:01.630Z
8898125 8898125 20251214041330_YZ4t4 UK003C 2025-12-23T14:03:57.972Z 2025-12-24T14:16:58.857Z
8898043 8898043 20251214041239_1KMbw UK003C 2025-12-23T14:03:56.874Z 2025-12-24T14:16:57.778Z
8896022 8896022 20251214023733_EBSYf UK003C 2025-12-22T14:12:14.040Z 2025-12-23T14:27:54.668Z
8895995 8895995 20251214023721_2JhlF UK003C 2025-12-22T14:12:14.028Z 2025-12-23T14:27:54.642Z
8895373 8895373 20251214023214_hnEJv UK003C 2025-12-22T14:12:09.704Z 2025-12-23T14:27:53.699Z
8894618 8894618 20251214022544_Jh9T3 UK003C 2025-12-22T14:12:03.584Z 2025-12-23T14:27:52.896Z
8894296 8894296 20251214022307_uOEqt UK003C 2025-12-22T14:12:02.873Z 2025-12-23T14:27:52.553Z
8894009 8894009 20251214022053_c5quF UK003C 2025-12-22T14:12:01.180Z 2025-12-23T14:27:52.165Z
8893763 8893763 20251214021846_i3Th3 UK003C 2025-12-22T14:11:59.507Z 2025-12-23T14:27:51.744Z
8893715 8893715 20251214021831_Ns4wG UK003C 2025-12-22T14:11:59.440Z 2025-12-23T14:27:51.722Z
8893391 8893391 20251214021534_j2uVS UK003C 2025-12-22T14:11:56.428Z 2025-12-23T14:27:49.883Z
8893179 8893179 20251214021351_Ef2HB UK003C 2025-12-22T14:11:53.540Z 2025-12-23T14:27:49.174Z
8892618 8892618 20251214021001_UOHMV UK003C 2025-12-22T14:11:51.814Z 2025-12-23T14:27:48.525Z
8892443 8892443 20251214020835_Nj9XP UK003C 2025-12-22T14:11:50.967Z 2025-12-23T14:27:48.210Z
8892346 8892346 20251214020807_djtoO UK003C 2025-12-22T14:11:50.417Z 2025-12-23T14:27:48.104Z
8891984 8891984 20251214020523_g3iI6 UK003C 2025-12-22T14:11:48.757Z 2025-12-23T14:27:47.509Z
8891885 8891885 20251214020439_LzVOU UK003C 2025-12-22T14:11:48.284Z 2025-12-23T14:27:47.301Z
8891814 8891814 20251214020404_jwL0t UK003C 2025-12-22T14:11:47.352Z 2025-12-23T14:27:47.214Z
8891531 8891531 20251214020202_of4Af UK003C 2025-12-22T14:11:45.723Z 2025-12-23T14:27:46.874Z
8891456 8891456 20251214020135_XT20t UK003C 2025-12-22T14:11:45.507Z 2025-12-23T14:27:46.815Z
8891317 8891317 20251214020018_Ssz8v UK003C 2025-12-22T14:11:44.812Z 2025-12-23T14:27:46.611Z
8890328 8890328 20251214015218_bpw54 UK003C 2025-12-22T14:11:41.175Z 2025-12-23T14:27:45.315Z
8890238 8890238 20251214015107_jzSin UK003C 2025-12-22T14:11:40.786Z 2025-12-23T14:27:45.138Z
8890167 8890167 20251214015046_ChZ1R UK003C 2025-12-22T14:11:40.538Z 2025-12-23T14:27:45.039Z
8889794 8889794 20251214014747_ckyyz UK003C 2025-12-22T14:11:39.157Z 2025-12-23T14:27:44.410Z
8889440 8889440 20251214014445_717Xf UK003C 2025-12-22T14:11:36.871Z 2025-12-23T14:27:43.679Z
8889350 8889350 20251214014355_Ivluf UK003C 2025-12-22T14:11:36.572Z 2025-12-23T14:27:43.515Z
8888960 8888960 20251214014053_qLTfC UK003C 2025-12-22T14:11:34.760Z 2025-12-23T14:27:42.750Z
8888885 8888885 20251214014010_tvg2X UK003C 2025-12-22T14:11:34.587Z 2025-12-23T14:27:42.638Z
8888668 8888668 20251214013830_l0lTE UK003C 2025-12-22T14:11:33.417Z 2025-12-23T14:27:42.259Z
8888610 8888610 20251214013756_Wr4Y8 UK003C 2025-12-22T14:11:33.350Z 2025-12-23T14:27:42.201Z
8888328 8888328 20251214013531_QHXIt UK003C 2025-12-22T14:11:32.447Z 2025-12-23T14:27:41.548Z
8887956 8887956 20251214013226_EGR3P UK003C 2025-12-22T14:11:31.183Z 2025-12-23T14:27:41.096Z
8887165 8887165 20251214012631_tU9ph UK003C 2025-12-22T14:11:23.786Z 2025-12-23T14:27:39.935Z
8887099 8887099 20251214012607_cCpCW UK003C 2025-12-22T14:11:23.446Z 2025-12-23T14:27:39.808Z
8886796 8886796 20251214012255_WYnJQ UK003C 2025-12-22T14:11:21.157Z 2025-12-23T14:27:39.383Z
8886452 8886452 20251214012018_nJPlb UK003C 2025-12-22T14:11:18.322Z 2025-12-23T14:27:38.823Z
8885225 8885225 20251214041006_vEsl6 UK003C 2025-12-22T14:03:30.731Z 2025-12-24T14:16:52.893Z
8884380 8884380 20251214040337_Fs563 UK003C 2025-12-22T14:03:24.307Z 2025-12-24T14:16:18.690Z
8882128 8882128 20251214034602_iL4zU UK003C 2025-12-22T14:03:05.037Z 2025-12-24T14:15:35.628Z
8882087 8882087 20251214034545_SsjKk UK003C 2025-12-22T14:03:03.636Z 2025-12-24T14:15:35.110Z
8881420 8881420 20251214034102_qY3nQ UK003C 2025-12-22T14:02:43.800Z 2025-12-24T14:15:20.132Z
8881277 8881277 20251214034003_R5QNN UK003C 2025-12-22T14:02:39.096Z 2025-12-24T14:15:12.086Z
8881152 8881152 20251214033900_h2bPE UK003C 2025-12-22T14:02:36.421Z 2025-12-24T14:15:00.211Z
8881068 8881068 20251214033824_vQFBV UK003C 2025-12-22T14:02:34.291Z 2025-12-24T14:14:59.043Z
8881057 8881057 20251214033821_G26Bj UK003C 2025-12-22T14:02:34.060Z 2025-12-24T14:14:58.948Z
8880933 8880933 20251214033731_nbGkg UK003C 2025-12-22T14:02:30.218Z 2025-12-24T14:14:57.654Z
8880660 8880660 20251214033612_mDGnl UK003C 2025-12-22T14:02:20.789Z 2025-12-24T14:14:52.902Z
8880365 8880365 20251214033400_JAcdJ UK003C 2025-12-22T14:02:17.104Z 2025-12-24T14:14:45.839Z
8880206 8880206 20251214033300_AtMbO UK003C 2025-12-22T14:02:13.568Z 2025-12-24T14:14:41.343Z
8879719 8879719 20251214032943_cpVYg UK003C 2025-12-22T14:02:08.146Z 2025-12-24T14:14:23.270Z
8879694 8879694 20251214032933_fvjPb UK003C 2025-12-22T14:02:07.887Z 2025-12-24T14:14:22.878Z
8879614 8879614 20251214032846_asREr UK003C 2025-12-22T14:02:07.070Z 2025-12-24T14:14:20.535Z
8879430 8879430 20251214032739_RCzr4 UK003C 2025-12-22T14:02:05.212Z 2025-12-24T14:14:18.084Z
8879356 8879356 20251214032716_Tzrvh UK003C 2025-12-22T14:02:04.591Z 2025-12-24T14:14:17.168Z
8879344 8879344 20251214032711_HZuu4 UK003C 2025-12-22T14:02:04.433Z 2025-12-24T14:14:17.088Z
8879235 8879235 20251214032608_kwxbR UK003C 2025-12-22T14:02:03.000Z 2025-12-24T14:14:14.944Z
8879119 8879119 20251214032534_fh9xv UK003C 2025-12-22T14:02:01.765Z 2025-12-22T14:12:37.229Z
8879103 8879103 20251214032522_SmhRt UK003C 2025-12-22T14:02:01.615Z 2025-12-24T14:14:12.827Z
8878958 8878958 20251214032354_S33Z1 UK003C 2025-12-22T14:01:59.702Z 2025-12-24T14:14:09.422Z
8878471 8878471 20251214032038_PmbTi UK003C 2025-12-22T14:01:55.168Z 2025-12-24T14:13:50.734Z
8878169 8878169 20251214031849_i28NP UK003C 2025-12-22T14:01:51.793Z 2025-12-24T14:13:45.269Z
8875870 8875870 20251214030337_3U2Jt UK003C 2025-12-22T14:00:42.521Z 2025-12-24T14:12:49.441Z
8875164 8875164 20251214025931_69tv3 UK003C 2025-12-22T14:00:19.086Z 2025-12-24T14:12:40.463Z
8875058 8875058 20251214025847_Qu2S4 UK003C 2025-12-22T14:00:17.839Z 2025-12-24T14:12:38.385Z
8875001 8875001 20251214025835_KQs59 UK003C 2025-12-22T14:00:17.405Z 2025-12-24T14:12:37.378Z
8874967 8874967 20251214025825_vxtWn UK003C 2025-12-22T14:00:17.001Z 2025-12-24T14:12:36.602Z
8874944 8874944 20251214025814_tVWsL UK003C 2025-12-22T14:00:16.610Z 2025-12-24T14:12:35.636Z
8872549 8872549 20251214005950_C2DxQ UK003C 2025-12-21T14:10:54.165Z 2025-12-23T14:27:35.241Z
8871354 8871354 20251214005151_44JM8 UK003C 2025-12-21T14:10:43.804Z 2025-12-23T14:27:33.886Z
8871333 8871333 20251214005146_UFmBp UK003C 2025-12-21T14:10:43.704Z 2025-12-23T14:27:33.871Z
8871156 8871156 20251214005033_o3bQS UK003C 2025-12-21T14:10:41.780Z 2025-12-23T14:27:33.670Z
8870887 8870887 20251214004836_Cn0Qe UK003C 2025-12-21T14:10:39.174Z 2025-12-23T14:27:33.223Z
8870275 8870275 20251214004437_gFTQY UK003C 2025-12-21T14:10:32.607Z 2025-12-23T14:27:31.963Z
8870262 8870262 20251214004426_4OQ10 UK003C 2025-12-21T14:10:32.490Z 2025-12-23T14:27:31.956Z
8870202 8870202 20251214004354_HtjuM UK003C 2025-12-21T14:10:30.966Z 2025-12-23T14:27:31.866Z
8869153 8869153 20251214003654_5DOqc UK003C 2025-12-21T14:10:18.509Z 2025-12-23T14:27:30.854Z
8868653 8868653 20251214003320_g3J3u UK003C 2025-12-21T14:10:11.612Z 2025-12-23T14:27:30.195Z
8867516 8867516 20251214002429_ZeQMc UK003C 2025-12-21T14:10:06.010Z 2025-12-23T14:27:28.156Z
8867390 8867390 20251214002255_Csix1 UK003C 2025-12-21T14:10:04.383Z 2025-12-23T14:27:25.872Z
8867371 8867371 20251214002232_TK1dR UK003C 2025-12-21T14:10:04.282Z 2025-12-23T14:27:25.468Z
8867155 8867155 20251214001958_XmY0g UK003C 2025-12-21T14:10:02.909Z 2025-12-23T14:27:20.577Z
8867059 8867059 20251214001912_xc6D1 UK003C 2025-12-21T14:10:02.279Z 2025-12-23T14:27:18.505Z

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