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

6,326 rows where station_code = "UK004M" 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
9611047 9611047 20260404233823_AVwQL UK004M 2026-04-06T12:12:49.259Z 2026-04-06T12:16:14.719Z
9611026 9611026 20260404232934_Vg96T UK004M 2026-04-06T12:12:40.219Z 2026-04-06T12:16:14.715Z
9611009 9611009 20260404232146_qcb5e UK004M 2026-04-06T12:12:33.419Z 2026-04-06T12:16:14.711Z
9611003 9611003 20260404231816_BToqZ UK004M 2026-04-06T12:12:31.251Z 2026-04-06T12:16:14.709Z
9608369 9608369 20260403224039_lXkxl UK004M 2026-04-05T12:10:16.446Z 2026-04-06T12:20:08.903Z
9608361 9608361 20260403223154_IERbU UK004M 2026-04-05T12:10:14.199Z 2026-04-06T12:20:08.360Z
9598335 9598335 20260329224753_3q77Q UK004M 2026-03-31T12:10:20.524Z 2026-04-06T12:36:25.505Z
9598290 9598290 20260329220541_h7bpn UK004M 2026-03-31T12:10:12.322Z 2026-04-06T12:36:22.648Z
9598234 9598234 20260329211250_Ms8xe UK004M 2026-03-31T12:10:02.988Z 2026-04-06T12:36:18.928Z
9591868 9591868 20260327225400_2vrCG UK004M 2026-03-29T12:06:53.303Z 2026-04-05T12:35:18.138Z
9590068 9590068 20260328044527_5XNmL UK004M 2026-03-29T12:01:56.802Z 2026-04-06T12:37:49.185Z
9589858 9589858 20260328041138_4fAME UK004M 2026-03-29T12:01:40.510Z 2026-04-06T12:37:36.356Z
9589483 9589483 20260328033503_BxrgB UK004M 2026-03-29T12:01:19.664Z 2026-04-06T12:37:25.492Z
9589394 9589394 20260328032603_2k12J UK004M 2026-03-29T12:01:11.797Z 2026-04-06T12:37:22.403Z
9570946 9570946 20260322232024_Y3pV8 UK004M 2026-03-24T12:24:03.971Z 2026-03-30T12:30:52.562Z
9561502 9561502 20260322235400_K0W1Q UK004M 2026-03-24T12:00:12.419Z 2026-03-31T12:25:45.469Z
9561471 9561471 20260321233804_NdLMi UK004M 2026-03-23T12:12:20.021Z 2026-03-29T12:21:07.518Z
9555472 9555472 20260322050621_tS2Ya UK004M 2026-03-23T12:03:27.991Z 2026-03-30T12:28:26.957Z
9555410 9555410 20260322044950_j56uh UK004M 2026-03-23T12:03:24.467Z 2026-03-30T12:28:26.109Z
9555214 9555214 20260322042617_42wSc UK004M 2026-03-23T12:03:15.761Z 2026-03-30T12:28:23.013Z
9553983 9553983 20260322023008_IzhMY UK004M 2026-03-23T12:02:04.925Z 2026-03-30T12:27:56.403Z
9553365 9553365 20260322013243_np373 UK004M 2026-03-23T12:01:25.334Z 2026-03-30T12:27:39.752Z
9553331 9553331 20260322013144_r1lAU UK004M 2026-03-23T12:01:24.525Z 2026-03-30T12:27:39.556Z
9553110 9553110 20260322011453_o6HiA UK004M 2026-03-23T12:01:13.814Z 2026-03-30T12:27:35.195Z
9553014 9553014 20260322010440_AGWP8 UK004M 2026-03-23T12:01:09.476Z 2026-03-30T12:27:33.767Z
9552631 9552631 20260322002508_ldDiX UK004M 2026-03-23T12:00:38.494Z 2026-03-30T12:27:27.272Z
9543632 9543632 20260321043314_nP39g UK004M 2026-03-22T12:04:19.378Z 2026-03-29T12:19:09.607Z
9543623 9543623 20260321043133_i5WYf UK004M 2026-03-22T12:04:18.271Z 2026-03-29T12:19:09.538Z
9541885 9541885 20260319220051_wevVD UK004M 2026-03-21T12:29:28.037Z 2026-03-27T12:42:42.727Z
9541830 9541830 20260319215509_6OF3v UK004M 2026-03-21T12:29:25.144Z 2026-03-27T12:42:42.255Z
9541485 9541485 20260319204410_hUM5o UK004M 2026-03-21T12:29:00.367Z 2026-03-27T12:42:38.209Z
9534999 9534999 20260320045917_0FWy3 UK004M 2026-03-21T12:09:26.925Z 2026-03-28T12:34:25.093Z
9534972 9534972 20260320045124_eSqhP UK004M 2026-03-21T12:09:21.555Z 2026-03-28T12:34:24.446Z
9534840 9534840 20260320042917_DMIAX UK004M 2026-03-21T12:09:01.095Z 2026-03-28T12:34:22.761Z
9534836 9534836 20260320042917_8QcH7 UK004M 2026-03-21T12:09:00.654Z 2026-03-28T12:34:22.750Z
9534712 9534712 20260320041429_72jD5 UK004M 2026-03-21T12:08:41.679Z 2026-03-28T12:34:21.190Z
9534702 9534702 20260320041421_MbJHE UK004M 2026-03-21T12:08:40.909Z 2026-03-28T12:34:21.126Z
9534649 9534649 20260320041017_7uMuA UK004M 2026-03-21T12:08:33.350Z 2026-03-28T12:34:20.519Z
9534516 9534516 20260320035730_IrqqO UK004M 2026-03-21T12:08:11.253Z 2026-03-28T12:34:18.995Z
9533876 9533876 20260320030700_YpHUA UK004M 2026-03-21T12:06:32.827Z 2026-03-28T12:34:01.801Z
9533367 9533367 20260320022606_PR29b UK004M 2026-03-21T12:05:16.562Z 2026-03-28T12:33:52.472Z
9533035 9533035 20260320015206_toP6c UK004M 2026-03-21T12:04:16.629Z 2026-03-28T12:33:47.959Z
9532746 9532746 20260320012124_8Kv65 UK004M 2026-03-21T12:03:29.909Z 2026-03-28T12:33:35.719Z
9532554 9532554 20260320010632_S83TM UK004M 2026-03-21T12:03:03.439Z 2026-03-28T12:33:33.875Z
9532514 9532514 20260320010446_FbX2g UK004M 2026-03-21T12:02:59.395Z 2026-03-28T12:33:33.232Z
9532254 9532254 20260320004129_9r6Dk UK004M 2026-03-21T12:02:10.589Z 2026-03-28T12:33:26.267Z
9531990 9531990 20260320000643_pqlgP UK004M 2026-03-21T12:01:21.040Z 2026-03-28T12:33:23.443Z
9531470 9531470 20260318231449_wwXNi UK004M 2026-03-20T12:25:19.877Z 2026-03-26T12:39:19.661Z
9530971 9530971 20260318221116_p7DTI UK004M 2026-03-20T12:24:53.541Z 2026-03-26T12:39:16.775Z
9530289 9530289 20260318203459_nu38s UK004M 2026-03-20T12:24:16.622Z 2026-03-26T12:39:10.991Z
9521772 9521772 20260319044247_xduRx UK004M 2026-03-20T12:08:31.145Z 2026-03-27T12:41:10.593Z
9521742 9521742 20260319044108_JtkXy UK004M 2026-03-20T12:08:29.820Z 2026-03-27T12:41:10.407Z
9521628 9521628 20260319043029_QbMyQ UK004M 2026-03-20T12:08:18.789Z 2026-03-27T12:40:56.431Z
9521252 9521252 20260319040033_22T0m UK004M 2026-03-20T12:07:45.464Z 2026-03-27T12:40:53.056Z
9520601 9520601 20260319032721_6GAiy UK004M 2026-03-20T12:06:38.080Z 2026-03-27T12:40:45.403Z
9520534 9520534 20260319032150_oYxSL UK004M 2026-03-20T12:06:31.030Z 2026-03-27T12:40:44.536Z
9520327 9520327 20260319031029_SmG3T UK004M 2026-03-20T12:06:14.504Z 2026-03-27T12:40:42.094Z
9520312 9520312 20260319031014_O53tf UK004M 2026-03-20T12:06:13.577Z 2026-03-27T12:40:41.974Z
9520267 9520267 20260319030722_dWWnb UK004M 2026-03-20T12:06:06.535Z 2026-03-27T12:40:41.358Z
9519492 9519492 20260319021326_whGoJ UK004M 2026-03-20T12:04:33.063Z 2026-03-27T12:40:31.764Z
9519367 9519367 20260319020524_FHams UK004M 2026-03-20T12:04:22.587Z 2026-03-27T12:40:29.212Z
9519195 9519195 20260319015416_M2G9N UK004M 2026-03-20T12:04:05.000Z 2026-03-27T12:40:18.961Z
9518204 9518204 20260319004112_BKpWN UK004M 2026-03-20T12:02:06.897Z 2026-03-27T12:40:07.448Z
9517384 9517384 20260318232126_SJnTE UK004M 2026-03-20T12:00:15.407Z 2026-03-27T12:39:58.856Z
9517374 9517374 20260318232103_0CmWQ UK004M 2026-03-20T12:00:14.510Z 2026-03-27T12:39:58.835Z
9512255 9512255 20260318050053_bcYpL UK004M 2026-03-19T12:12:02.714Z 2026-03-26T12:37:43.374Z
9501298 9501298 20260315214826_92ImC UK004M 2026-03-17T12:24:48.102Z 2026-03-23T12:22:43.873Z
9469958 9469958 20260313041208_RQwXy UK004M 2026-03-14T12:06:06.156Z 2026-03-21T12:49:04.582Z
9469867 9469867 20260313035543_2FHk9 UK004M 2026-03-14T12:05:47.679Z 2026-03-21T12:49:03.469Z
9469121 9469121 20260313015338_zc0fI UK004M 2026-03-14T12:03:03.737Z 2026-03-21T12:48:33.795Z
9469082 9469082 20260313014420_adb04 UK004M 2026-03-14T12:02:53.881Z 2026-03-21T12:48:33.344Z
9457781 9457781 20260311053257_8FR2I UK004M 2026-03-12T12:04:34.884Z 2026-03-19T12:44:52.048Z
9457344 9457344 20260311033931_QXbhN UK004M 2026-03-12T12:03:37.562Z 2026-03-19T12:44:39.872Z
9457306 9457306 20260311032608_VsbYO UK004M 2026-03-12T12:03:31.669Z 2026-03-19T12:44:37.195Z
9457232 9457232 20260311030911_63ror UK004M 2026-03-12T12:03:16.398Z 2026-03-19T12:44:34.271Z
9441128 9441128 20260306200138_u6d76 UK004M 2026-03-08T12:20:33.494Z 2026-03-14T12:40:45.200Z
9394903 9394903 20260224221348_WmjKN UK004M 2026-02-26T14:20:51.388Z 2026-03-04T14:19:28.224Z
9390033 9390033 20260224232941_wS7VN UK004M 2026-02-26T14:00:14.523Z 2026-03-05T14:35:30.967Z
9340355 9340355 20260216235519_HPh8s UK004M 2026-02-18T14:24:42.768Z 2026-02-25T14:42:53.586Z
9340108 9340108 20260216225710_Yqcvm UK004M 2026-02-18T14:24:04.171Z 2026-02-25T14:42:51.081Z
9340009 9340009 20260216223012_cVf79 UK004M 2026-02-18T14:23:45.504Z 2026-02-25T14:42:49.677Z
9339509 9339509 20260216191905_dsGzx UK004M 2026-02-18T14:21:15.806Z 2026-02-25T14:42:40.980Z
9337507 9337507 20260217054748_iQcgj UK004M 2026-02-18T14:07:26.268Z 2026-02-26T14:39:27.412Z
9337494 9337494 20260217054512_jkWbx UK004M 2026-02-18T14:07:23.282Z 2026-02-26T14:39:27.301Z
9337460 9337460 20260217054209_3lhXo UK004M 2026-02-18T14:07:18.681Z 2026-02-26T14:39:27.106Z
9336207 9336207 20260217032716_7gxhr UK004M 2026-02-18T14:03:39.559Z 2026-02-26T14:39:16.610Z
9336157 9336157 20260217031659_YrqkM UK004M 2026-02-18T14:03:31.582Z 2026-02-26T14:39:16.276Z
9335949 9335949 20260217025414_MyH70 UK004M 2026-02-18T14:02:50.805Z 2026-02-26T14:38:59.826Z
9326647 9326647 20260214011706_X7mzQ UK004M 2026-02-15T14:24:06.241Z 2026-02-22T14:42:54.023Z
9326502 9326502 20260214003230_uWQj3 UK004M 2026-02-15T14:23:34.151Z 2026-02-22T14:42:50.508Z
9326363 9326363 20260213232729_JGyR8 UK004M 2026-02-15T14:22:54.474Z 2026-02-22T14:42:47.493Z
9326315 9326315 20260213230310_66HG1 UK004M 2026-02-15T14:22:41.124Z 2026-02-22T14:42:46.482Z
9323862 9323862 20260214061712_0oTCE UK004M 2026-02-15T14:07:26.426Z 2026-02-23T14:46:47.874Z
9323778 9323778 20260214060138_ZhiTS UK004M 2026-02-15T14:07:11.199Z 2026-02-23T14:46:46.647Z
9323640 9323640 20260214055030_IHnZW UK004M 2026-02-15T14:06:51.375Z 2026-02-23T14:46:34.915Z
9323626 9323626 20260214054948_luZG0 UK004M 2026-02-15T14:06:49.244Z 2026-02-23T14:46:34.755Z
9323316 9323316 20260214050406_ipB65 UK004M 2026-02-15T14:05:55.793Z 2026-02-23T14:46:30.868Z
9323265 9323265 20260214045910_zE7G4 UK004M 2026-02-15T14:05:48.243Z 2026-02-23T14:46:29.781Z
9323113 9323113 20260214044843_AJdCm UK004M 2026-02-15T14:05:20.602Z 2026-02-23T14:46:27.879Z
9322985 9322985 20260214043221_4d0X2 UK004M 2026-02-15T14:04:48.430Z 2026-02-23T14:46:25.781Z

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