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

5,506 rows where station_code = "UK001U" 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
8603756 8603756 20251125063611_0MF22 UK001U 2025-11-26T14:27:50.065Z 2025-12-02T15:09:37.226Z
8602508 8602508 20251125050046_AowxF UK001U 2025-11-26T14:26:04.704Z 2025-12-02T15:09:31.292Z
8601230 8601230 20251125034022_LzzKi UK001U 2025-11-26T14:23:49.235Z 2025-12-02T15:09:05.946Z
8554007 8554007 20251120062910_jh2qg UK001U 2025-11-22T14:34:37.763Z 2025-11-28T14:58:42.657Z
8533058 8533058 20251119174058_uFATz UK001U 2025-11-21T14:09:35.974Z 2025-11-28T14:54:10.709Z
8512396 8512396 20251117221413_8ooJp UK001U 2025-11-19T14:34:39.385Z 2025-11-26T15:07:43.426Z
8507032 8507032 20251117223718_8CsOE UK001U 2025-11-19T14:14:17.200Z 2025-11-26T15:07:44.655Z
8497070 8497070 20251117051020_qayVk UK001U 2025-11-18T14:28:36.077Z 2025-11-25T15:10:29.785Z
8491805 8491805 20251116231359_iYEpQ UK001U 2025-11-18T14:18:21.375Z 2025-11-25T15:08:42.088Z
8362580 8362580 20251102191529_FMaFM UK001U 2025-11-04T14:11:48.012Z 2025-11-11T15:03:49.486Z
8362114 8362114 20251102184245_rWX1H UK001U 2025-11-04T14:10:30.220Z 2025-11-11T15:03:25.954Z
8361560 8361560 20251102175359_0z3w8 UK001U 2025-11-04T14:08:46.138Z 2025-11-11T15:03:06.109Z
8258431 8258431 20251026022002_MMPlQ UK001U 2025-10-28T12:31:40.842Z 2025-11-03T15:16:22.925Z
8258098 8258098 20251026021050_3xjP3 UK001U 2025-10-28T12:31:10.795Z 2025-11-03T15:16:19.872Z
8256604 8256604 20251026013349_6uIwK UK001U 2025-10-28T12:29:54.825Z 2025-11-03T15:16:16.212Z
8255877 8255877 20251026011212_f0gES UK001U 2025-10-28T12:29:07.210Z 2025-11-03T15:16:12.847Z
8238733 8238733 20251024235137_QVtL3 UK001U 2025-10-27T12:29:01.203Z 2025-11-02T15:05:22.300Z
8233480 8233480 20251025225142_v39Iv UK001U 2025-10-27T12:13:24.697Z 2025-11-03T15:15:59.159Z
8232820 8232820 20251025215212_VbOLP UK001U 2025-10-27T12:11:45.830Z 2025-11-03T15:15:53.538Z
8232444 8232444 20251025210357_gj4ZU UK001U 2025-10-27T12:10:48.157Z 2025-11-03T15:15:52.542Z
8220351 8220351 20251024035826_olKzB UK001U 2025-10-26T12:37:24.467Z 2025-11-01T13:11:03.213Z
8216258 8216258 20251024020040_x8J71 UK001U 2025-10-26T12:31:55.850Z 2025-11-01T13:10:31.652Z
8215092 8215092 20251024011852_GZbEt UK001U 2025-10-26T12:30:11.185Z 2025-11-01T13:10:22.637Z
8213888 8213888 20251024002550_5OAOx UK001U 2025-10-26T12:28:14.667Z 2025-11-01T13:10:18.748Z
8213792 8213792 20251024002230_KFgv5 UK001U 2025-10-26T12:28:10.121Z 2025-11-01T13:10:18.491Z
8056727 8056727 20251004044320_OiALb UK001U 2025-10-05T12:17:30.546Z 2025-10-12T12:33:03.488Z
7971684 7971684 20250925210304_3re43 UK001U 2025-09-27T12:11:00.559Z 2025-10-04T13:06:46.347Z
7949823 7949823 20250924021515_USqLo UK001U 2025-09-25T12:34:06.688Z 2025-10-02T13:27:39.818Z
7918739 7918739 20250922234315_bB23s UK001U 2025-09-24T12:26:14.417Z 2025-10-01T13:24:10.576Z
7835403 7835403 20250913235105_fN1hn UK001U 2025-09-16T12:19:28.686Z 2025-09-22T13:06:29.720Z
7805634 7805634 20250911024040_KPceH UK001U 2025-09-12T12:06:55.078Z 2025-09-19T12:56:57.824Z
7769976 7769976 20250905002201_KFUmz UK001U 2025-09-06T12:59:11.002Z 2025-09-13T12:56:27.363Z
7767874 7767874 20250904205722_qxQpM UK001U 2025-09-06T12:31:33.424Z 2025-09-13T12:55:17.412Z
7555001 7555001 20250817034006_IS9oz UK001U 2025-08-19T12:24:59.001Z 2025-08-25T12:51:48.603Z
7533128 7533128 20250816023649_mEtDj UK001U 2025-08-18T12:11:47.922Z 2025-08-24T12:47:45.896Z
7531153 7531153 20250816002811_YqYZL UK001U 2025-08-18T12:05:53.067Z 2025-08-24T12:47:31.572Z
7514574 7514574 20250814231813_96Hug UK001U 2025-08-17T12:07:16.386Z 2025-08-23T12:48:26.390Z
7486354 7486354 20250813015540_iuMNa UK001U 2025-08-15T12:30:42.324Z 2025-08-21T12:47:40.179Z
7482063 7482063 20250812234003_SvWbz UK001U 2025-08-15T12:20:03.455Z 2025-08-21T12:47:27.141Z
7421851 7421851 20250810001732_4werW UK001U 2025-08-11T12:09:45.687Z 2025-08-18T13:45:53.138Z
7406416 7406416 20250808012455_uuPxU UK001U 2025-08-09T12:12:19.963Z 2025-08-16T13:20:40.302Z
7075713 7075713 20250712003603_lGvIz UK001U 2025-07-13T12:10:55.258Z 2025-07-20T12:25:12.054Z
7068686 7068686 20250710014920_LTbpN UK001U 2025-07-11T12:15:40.566Z 2025-07-18T12:38:23.451Z
7034633 7034633 20250703230840_IKyUo UK001U 2025-07-05T12:22:02.351Z 2025-07-12T13:01:10.391Z
6883072 6883072 20250611232727_53J51 UK001U 2025-06-12T12:06:29.951Z 2025-06-20T12:54:33.588Z
6882941 6882941 20250611225755_MLe1p UK001U 2025-06-12T12:06:15.433Z 2025-06-20T12:54:15.869Z
6880846 6880846 20250610232356_cIfhS UK001U 2025-06-11T12:09:36.284Z 2025-06-18T12:42:03.885Z
6724947 6724947 20250515023632_M702C UK001U 2025-05-16T12:05:02.650Z 2025-05-23T12:36:19.268Z
6724457 6724457 20250515010150_iFz3L UK001U 2025-05-16T12:03:40.805Z 2025-05-23T12:36:10.912Z
6669415 6669415 20250506011058_Ck8wn UK001U 2025-05-07T12:17:25.343Z 2025-05-14T12:41:11.969Z
6614414 6614414 20250430023828_pxJKh UK001U 2025-05-01T12:19:00.609Z 2025-05-08T12:35:14.949Z
6585816 6585816 20250427021802_28WBr UK001U 2025-04-28T12:22:42.667Z 2025-05-05T12:31:30.661Z
6585408 6585408 20250427014257_uqmV7 UK001U 2025-04-28T12:21:54.810Z 2025-05-05T12:31:29.122Z
6569017 6569017 20250424233645_RWIhQ UK001U 2025-04-26T12:22:07.797Z 2025-05-03T12:32:33.214Z
6560709 6560709 20250424005644_23VBz UK001U 2025-04-25T12:20:18.344Z 2025-05-02T12:34:58.921Z
6560671 6560671 20250424004419_4uXfc UK001U 2025-04-25T12:20:15.936Z 2025-05-02T12:34:58.786Z
6560536 6560536 20250423235121_Y369I UK001U 2025-04-25T12:19:40.138Z 2025-05-02T12:34:58.158Z
6520019 6520019 20250417015238_UXCX9 UK001U 2025-04-18T12:09:48.988Z 2025-04-25T12:33:41.730Z
6500749 6500749 20250409230445_PzkxD UK001U 2025-04-11T12:19:29.381Z 2025-04-17T12:25:16.338Z
6500563 6500563 20250409215643_eqncW UK001U 2025-04-11T12:19:16.055Z 2025-04-17T12:25:07.843Z
6480724 6480724 20250406201904_YRKIP UK001U 2025-04-08T12:28:30.929Z 2025-04-14T12:31:59.670Z
6476845 6476845 20250406032851_pwVa9 UK001U 2025-04-08T12:19:47.748Z 2025-04-14T12:30:24.503Z
6455403 6455403 20250402202417_7acUc UK001U 2025-04-04T12:23:20.951Z 2025-04-10T12:26:55.717Z
6429710 6429710 20250330195916_ppPVf UK001U 2025-04-02T12:22:14.096Z 2025-04-08T13:00:16.014Z
6397925 6397925 20250326231509_ViaJJ UK001U 2025-03-28T12:05:14.971Z 2025-04-04T12:46:38.554Z
6397620 6397620 20250326220855_SNL20 UK001U 2025-03-28T12:04:24.082Z 2025-04-04T12:46:33.652Z
6336331 6336331 20250318030851_uwt1M UK001U 2025-03-19T12:10:39.674Z 2025-03-26T12:57:22.103Z
6316198 6316198 20250313041324_ZLsOB UK001U 2025-03-14T12:04:36.232Z 2025-03-21T12:45:10.180Z
6308655 6308655 20250311194948_LTb0z UK001U 2025-03-13T12:03:08.973Z 2025-03-17T12:22:38.045Z
6148898 6148898 20250223031043_7JYJ4 UK001U 2025-02-24T14:14:31.033Z 2025-03-03T15:21:24.331Z
6017981 6017981 20250126181848_iN3FE UK001U 2025-01-30T14:26:45.880Z 2025-02-04T14:33:39.413Z
6017902 6017902 20250126043718_Mm3m1 UK001U 2025-01-30T14:26:08.496Z 2025-02-04T14:33:27.383Z
6017900 6017900 20250126034625_FPsEm UK001U 2025-01-30T14:26:01.174Z 2025-02-04T14:33:26.073Z
6017896 6017896 20250126031713_VAzWH UK001U 2025-01-30T14:25:56.523Z 2025-02-04T14:33:25.225Z
6017885 6017885 20250126015703_8xgmT UK001U 2025-01-30T14:25:42.104Z 2025-02-04T14:33:23.277Z
6016971 6016971 20250128040932_W2I49 UK001U 2025-01-30T14:17:46.946Z 2025-02-06T14:44:42.721Z
5898446 5898446 20250103042725_xNJ6F UK001U 2025-01-05T14:17:06.104Z 2025-01-11T14:42:16.947Z
5891500 5891500 20250103013524_NOWey UK001U 2025-01-04T14:28:29.351Z 2025-01-11T14:39:56.378Z
5890851 5890851 20250103010259_B2r9o UK001U 2025-01-04T14:27:56.440Z 2025-01-11T14:39:34.698Z
5823376 5823376 20241221225600_g12v8 UK001U 2024-12-23T14:04:28.044Z 2024-12-30T14:35:57.430Z
5793083 5793083 20241214065036_dtjNY UK001U 2024-12-15T14:08:48.782Z 2024-12-22T14:27:09.299Z
5682669 5682669 20241204055952_wmtXj UK001U 2024-12-05T14:10:16.256Z 2024-12-13T14:40:29.279Z
5614703 5614703 20241126014450_pKPqa UK001U 2024-11-27T14:19:31.912Z 2024-12-04T14:30:02.780Z
5579160 5579160 20241121215444_ES8Vs UK001U 2024-11-23T14:17:56.711Z 2024-11-30T14:28:57.288Z
5578854 5578854 20241121211107_TBM06 UK001U 2024-11-23T14:17:36.260Z 2024-11-30T14:28:56.865Z
5574814 5574814 20241122063118_ayAIC UK001U 2024-11-23T14:04:29.930Z 2024-12-01T14:25:15.806Z
5572461 5572461 20241121022318_zwZJy UK001U 2024-11-22T14:18:27.844Z 2024-11-29T14:26:50.367Z
5570906 5570906 20241120212650_3OTtQ UK001U 2024-11-22T14:16:11.771Z 2024-11-29T14:26:41.946Z
5569993 5569993 20241120182124_lE2op UK001U 2024-11-22T14:14:43.773Z 2024-11-29T14:26:37.548Z
5566033 5566033 20241121052004_gAZiF UK001U 2024-11-22T14:01:35.870Z 2024-11-30T14:28:39.640Z
5561754 5561754 20241119220027_s3wLD UK001U 2024-11-21T14:13:59.572Z 2024-11-28T14:29:07.975Z
5561739 5561739 20241119215520_AkOLm UK001U 2024-11-21T14:13:54.662Z 2024-11-28T14:29:07.893Z
5561133 5561133 20241119183005_1PqO0 UK001U 2024-11-21T14:12:27.434Z 2024-11-28T14:29:04.367Z
5538740 5538740 20241113044941_tQ0Jl UK001U 2024-11-14T14:13:54.506Z 2024-11-21T14:26:28.683Z
5538459 5538459 20241113034947_B0ak3 UK001U 2024-11-14T14:13:30.023Z 2024-11-21T14:26:26.102Z
5538383 5538383 20241113032505_zqJ6Y UK001U 2024-11-14T14:13:22.011Z 2024-11-21T14:26:25.071Z
5538222 5538222 20241113024132_A6JR4 UK001U 2024-11-14T14:13:05.647Z 2024-11-21T14:26:21.777Z
5538094 5538094 20241113021049_BKQBE UK001U 2024-11-14T14:12:50.555Z 2024-11-21T14:26:20.681Z
5537914 5537914 20241113012651_3h9U4 UK001U 2024-11-14T14:12:37.432Z 2024-11-21T14:26:17.003Z
5536488 5536488 20241112181427_o06Gr UK001U 2024-11-14T14:10:03.293Z 2024-11-21T14:26:01.351Z

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