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

2,209 rows where station_code = "UK009U" 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
7003445 7003445 20250630012143_jzZLJ UK009U 2025-07-01T12:10:53.556Z 2025-07-08T12:51:07.658Z
7003105 7003105 20250630010442_HY02d UK009U 2025-07-01T12:10:11.132Z 2025-07-08T12:50:57.405Z
7003061 7003061 20250630010138_6FAy2 UK009U 2025-07-01T12:09:55.060Z 2025-07-08T12:50:54.909Z
7002744 7002744 20250630004737_vf927 UK009U 2025-07-01T12:09:00.139Z 2025-07-08T12:50:49.854Z
6992978 6992978 20250629000029_3aKry UK009U 2025-06-30T12:06:13.968Z 2025-07-07T12:30:17.110Z
6992841 6992841 20250628234757_3byBr UK009U 2025-06-30T12:05:38.293Z 2025-07-07T12:30:15.721Z
6992801 6992801 20250628234403_ZJANL UK009U 2025-06-30T12:05:25.070Z 2025-07-07T12:30:15.274Z
6955778 6955778 20250623014430_686nZ UK009U 2025-06-24T12:20:41.061Z 2025-07-01T12:53:20.232Z
6955706 6955706 20250623012700_j0yUf UK009U 2025-06-24T12:20:32.711Z 2025-07-01T12:53:19.205Z
6955385 6955385 20250623002955_W1Vqp UK009U 2025-06-24T12:19:15.971Z 2025-07-01T12:53:10.593Z
6947376 6947376 20250621234630_wlJ2T UK009U 2025-06-23T12:23:12.908Z 2025-06-30T12:35:47.146Z
6936414 6936414 20250621011246_ZD734 UK009U 2025-06-22T12:14:40.120Z 2025-06-29T12:36:42.427Z
6936317 6936317 20250621010633_tZNjC UK009U 2025-06-22T12:14:18.102Z 2025-06-29T12:36:41.791Z
6935853 6935853 20250621002514_9228K UK009U 2025-06-22T12:13:09.453Z 2025-06-29T12:36:37.900Z
6935597 6935597 20250621000340_iPu0o UK009U 2025-06-22T12:12:34.363Z 2025-06-29T12:36:34.736Z
6930182 6930182 20250620012150_W239T UK009U 2025-06-21T12:19:28.290Z 2025-06-28T12:40:51.456Z
6921914 6921914 20250619012956_RGbFs UK009U 2025-06-20T12:15:44.818Z 2025-06-27T12:39:54.776Z
6921844 6921844 20250619012529_hsiIQ UK009U 2025-06-20T12:15:37.307Z 2025-06-27T12:39:53.566Z
6921704 6921704 20250619011431_MHEB5 UK009U 2025-06-20T12:15:18.273Z 2025-06-27T12:39:52.869Z
6921217 6921217 20250619003443_vCKbv UK009U 2025-06-20T12:14:15.219Z 2025-06-27T12:39:48.386Z
6920773 6920773 20250618235756_drLrA UK009U 2025-06-20T12:13:07.688Z 2025-06-27T12:39:43.695Z
6920141 6920141 20250618225425_iqUjc UK009U 2025-06-20T12:11:21.609Z 2025-06-27T12:39:36.771Z
6910383 6910383 20250616235501_7BZKQ UK009U 2025-06-18T12:20:44.228Z 2025-06-25T12:36:41.625Z
6897182 6897182 20250616000216_mwS14 UK009U 2025-06-16T12:10:19.379Z 2025-06-24T12:59:26.736Z
6892579 6892579 20250615000221_GpBvo UK009U 2025-06-15T12:11:51.778Z 2025-06-23T13:01:08.023Z
6892445 6892445 20250614232956_2RM2A UK009U 2025-06-15T12:11:36.550Z 2025-06-23T13:01:05.237Z
6892438 6892438 20250614232854_xqqIy UK009U 2025-06-15T12:11:35.888Z 2025-06-23T13:01:05.145Z
6892378 6892378 20250614231201_ymmzV UK009U 2025-06-15T12:11:29.592Z 2025-06-23T13:01:03.413Z
6892320 6892320 20250614225524_q3ma3 UK009U 2025-06-15T12:11:09.280Z 2025-06-23T13:01:00.642Z
6892272 6892272 20250614224719_k2nsk UK009U 2025-06-15T12:11:04.806Z 2025-06-23T13:00:59.817Z
6892265 6892265 20250614224717_gMWqk UK009U 2025-06-15T12:11:04.190Z 2025-06-23T13:00:59.808Z
6885006 6885006 20250612230143_j4CQt UK009U 2025-06-13T12:06:33.407Z 2025-06-21T12:37:00.264Z
6884866 6884866 20250612223406_VUuix UK009U 2025-06-13T12:06:10.725Z 2025-06-21T12:36:59.578Z
6848774 6848774 20250602013351_KmzqB UK009U 2025-06-03T12:12:02.719Z 2025-06-10T12:29:21.728Z
6848596 6848596 20250602010041_Hf0Cv UK009U 2025-06-03T12:11:29.561Z 2025-06-10T12:29:15.962Z
6848480 6848480 20250602003600_GN53i UK009U 2025-06-03T12:11:14.132Z 2025-06-10T12:29:13.408Z
6848459 6848459 20250602003403_j6jyp UK009U 2025-06-03T12:11:12.551Z 2025-06-10T12:29:13.106Z
6848435 6848435 20250602002729_LtetV UK009U 2025-06-03T12:11:10.246Z 2025-06-10T12:29:12.815Z
6848136 6848136 20250601233949_uZo2s UK009U 2025-06-03T12:10:18.813Z 2025-06-10T12:29:03.632Z
6842104 6842104 20250601013748_kEBYX UK009U 2025-06-02T12:14:04.789Z 2025-06-09T12:45:48.467Z
6842071 6842071 20250601013444_WqDTi UK009U 2025-06-02T12:13:54.168Z 2025-06-09T12:45:47.555Z
6842060 6842060 20250601013441_e4FXe UK009U 2025-06-02T12:13:53.807Z 2025-06-09T12:45:47.391Z
6841540 6841540 20250601000155_nX0ug UK009U 2025-06-02T12:12:18.885Z 2025-06-09T12:45:20.623Z
6841292 6841292 20250531225917_4G2hS UK009U 2025-06-02T12:11:18.119Z 2025-06-09T12:44:58.121Z
6836481 6836481 20250531001514_plKzZ UK009U 2025-06-01T12:17:50.264Z 2025-06-08T12:32:23.715Z
6829778 6829778 20250530014605_gLGr6 UK009U 2025-05-31T12:19:20.058Z 2025-06-07T12:36:40.942Z
6829756 6829756 20250530013754_Z3KcQ UK009U 2025-05-31T12:19:17.563Z 2025-06-07T12:36:40.696Z
6829711 6829711 20250530013054_7UM9Y UK009U 2025-05-31T12:19:08.035Z 2025-06-07T12:36:39.392Z
6829693 6829693 20250530012824_ximJK UK009U 2025-05-31T12:19:04.790Z 2025-06-07T12:36:39.164Z
6829641 6829641 20250530012028_DFH4l UK009U 2025-05-31T12:19:00.067Z 2025-06-07T12:36:38.437Z
6829587 6829587 20250530010328_NHgLh UK009U 2025-05-31T12:18:52.111Z 2025-06-07T12:36:36.309Z
6829368 6829368 20250530003649_2ZsoT UK009U 2025-05-31T12:18:13.975Z 2025-06-07T12:36:32.680Z
6829312 6829312 20250530003155_H33dC UK009U 2025-05-31T12:18:07.096Z 2025-06-07T12:36:31.877Z
6829103 6829103 20250529235127_vl3u7 UK009U 2025-05-31T12:17:34.725Z 2025-06-07T12:36:29.313Z
6829080 6829080 20250529234747_3XHi2 UK009U 2025-05-31T12:17:32.231Z 2025-06-07T12:36:28.721Z
6829073 6829073 20250529234747_ECEu2 UK009U 2025-05-31T12:17:32.064Z 2025-06-07T12:36:28.665Z
6829044 6829044 20250529233530_HKgE2 UK009U 2025-05-31T12:17:26.042Z 2025-06-07T12:36:28.095Z
6828970 6828970 20250529232047_O52RO UK009U 2025-05-31T12:17:14.884Z 2025-06-07T12:36:26.363Z
6828743 6828743 20250529221940_K6TlZ UK009U 2025-05-31T12:16:35.428Z 2025-06-07T12:36:21.447Z
6809679 6809679 20250526005942_0ozh9 UK009U 2025-05-27T12:17:08.840Z 2025-06-03T13:03:27.197Z
6809549 6809549 20250526004112_Iw7GT UK009U 2025-05-27T12:16:52.916Z 2025-06-03T13:03:18.424Z
6809005 6809005 20250525230823_LwImf UK009U 2025-05-27T12:15:38.779Z 2025-06-03T13:03:02.624Z
6808919 6808919 20250525225238_ahDA1 UK009U 2025-05-27T12:15:27.520Z 2025-06-03T13:03:00.051Z
6808903 6808903 20250525225154_XIJDm UK009U 2025-05-27T12:15:25.677Z 2025-06-03T13:02:59.743Z
6808841 6808841 20250525223917_rg5O1 UK009U 2025-05-27T12:15:08.608Z 2025-06-03T13:02:58.347Z
6808829 6808829 20250525223603_YiAqk UK009U 2025-05-27T12:15:06.229Z 2025-06-03T13:02:58.000Z
6788501 6788501 20250523020813_UQ3P9 UK009U 2025-05-24T12:22:56.502Z 2025-05-31T13:15:18.067Z
6788289 6788289 20250523015037_eEWUD UK009U 2025-05-24T12:22:29.940Z 2025-05-31T13:15:11.264Z
6787852 6787852 20250523005838_gE8Rg UK009U 2025-05-24T12:21:37.430Z 2025-05-31T13:14:46.793Z
6787444 6787444 20250523002247_SYjjT UK009U 2025-05-24T12:20:51.810Z 2025-05-31T13:14:28.698Z
6787067 6787067 20250522233937_n0lH2 UK009U 2025-05-24T12:20:02.301Z 2025-05-31T13:14:03.795Z
6780850 6780850 20250522011431_PgsvK UK009U 2025-05-23T12:24:36.418Z 2025-05-30T13:09:38.195Z
6780671 6780671 20250522005311_MDhZ9 UK009U 2025-05-23T12:24:28.077Z 2025-05-30T13:09:24.969Z
6780496 6780496 20250522001840_d8koA UK009U 2025-05-23T12:24:20.537Z 2025-05-30T13:09:19.943Z
6780489 6780489 20250522001621_bLjEs UK009U 2025-05-23T12:24:20.214Z 2025-05-30T13:09:19.298Z
6780247 6780247 20250521233219_NDNFJ UK009U 2025-05-23T12:23:38.353Z 2025-05-30T13:09:12.029Z
6746070 6746070 20250517223033_6c2jX UK009U 2025-05-19T12:14:52.223Z 2025-05-25T12:38:29.392Z
6745900 6745900 20250517220824_uRpYq UK009U 2025-05-19T12:14:41.636Z 2025-05-25T12:38:25.258Z
6745857 6745857 20250517220248_HDe8s UK009U 2025-05-19T12:14:39.265Z 2025-05-25T12:38:24.902Z
6723686 6723686 20250514230945_ThZcn UK009U 2025-05-16T12:01:14.472Z 2025-05-23T12:35:56.705Z
6723435 6723435 20250514223134_UANdX UK009U 2025-05-16T12:00:34.533Z 2025-05-23T12:35:54.337Z
6722471 6722471 20250514021346_zTAVA UK009U 2025-05-15T12:12:38.817Z 2025-05-22T12:36:20.497Z
6720597 6720597 20250513224643_eU0sL UK009U 2025-05-15T12:01:28.688Z 2025-05-22T12:36:02.759Z
6720336 6720336 20250513214608_G0KtG UK009U 2025-05-15T12:00:43.597Z 2025-05-22T12:35:56.987Z
6720333 6720333 20250513214429_d2IXp UK009U 2025-05-15T12:00:42.655Z 2025-05-22T12:35:56.857Z
6718214 6718214 20250513015052_67uG7 UK009U 2025-05-14T12:04:32.646Z 2025-05-21T12:32:09.476Z
6717894 6717894 20250513005520_VBac8 UK009U 2025-05-14T12:03:28.752Z 2025-05-21T12:32:07.360Z
6707290 6707290 20250511021734_vQJIa UK009U 2025-05-12T12:07:07.109Z 2025-05-19T12:36:39.674Z
6706946 6706946 20250511013944_Gxi2Y UK009U 2025-05-12T12:06:23.956Z 2025-05-19T12:36:29.131Z
6706925 6706925 20250511013911_wXZND UK009U 2025-05-12T12:06:22.442Z 2025-05-19T12:36:28.987Z
6706567 6706567 20250511003914_BZn2k UK009U 2025-05-12T12:05:25.551Z 2025-05-19T12:36:20.168Z
6706351 6706351 20250510235102_ooVJo UK009U 2025-05-12T12:04:38.844Z 2025-05-19T12:36:12.996Z
6706137 6706137 20250510230823_V3mN7 UK009U 2025-05-12T12:04:05.314Z 2025-05-19T12:36:05.688Z
6700368 6700368 20250510021950_2hTY5 UK009U 2025-05-11T12:09:34.059Z 2025-05-18T12:34:09.280Z
6699839 6699839 20250510014210_6tqjt UK009U 2025-05-11T12:08:37.739Z 2025-05-18T12:34:01.862Z
6699384 6699384 20250510005928_2rEDg UK009U 2025-05-11T12:07:46.608Z 2025-05-18T12:33:52.328Z
6698620 6698620 20250509231551_iV4jf UK009U 2025-05-11T12:06:03.209Z 2025-05-18T12:33:40.396Z
6698567 6698567 20250509231001_QeUJu UK009U 2025-05-11T12:05:56.083Z 2025-05-18T12:33:40.145Z
6698481 6698481 20250509225443_BaZYj UK009U 2025-05-11T12:05:44.260Z 2025-05-18T12:33:38.672Z
6698376 6698376 20250509222500_GUvo0 UK009U 2025-05-11T12:05:30.394Z 2025-05-18T12:33:36.673Z

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