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

7,431 rows where station_code = "UK000P" 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
8683240 8683240 20251203064422_d2G2C UK000P 2025-12-04T14:18:58.980Z 2025-12-05T14:23:12.489Z
8683129 8683129 20251203062844_ezPHV UK000P 2025-12-04T14:18:35.762Z 2025-12-05T14:23:08.237Z
8682784 8682784 20251203060308_cU6Fs UK000P 2025-12-04T14:18:00.652Z 2025-12-05T14:22:51.920Z
8682670 8682670 20251203055817_5FKuV UK000P 2025-12-04T14:17:53.449Z 2025-12-05T14:22:47.208Z
8682439 8682439 20251203053348_PNejy UK000P 2025-12-04T14:17:12.164Z 2025-12-05T14:22:38.146Z
8682390 8682390 20251203052443_goTK3 UK000P 2025-12-04T14:17:05.207Z 2025-12-05T14:22:34.880Z
8682351 8682351 20251203052047_GL8hD UK000P 2025-12-04T14:16:56.449Z 2025-12-05T14:22:25.491Z
8682338 8682338 20251203051801_rnFSs UK000P 2025-12-04T14:16:50.066Z 2025-12-05T14:22:25.158Z
8682204 8682204 20251203050113_39OGM UK000P 2025-12-04T14:16:36.919Z 2025-12-05T14:22:18.437Z
8682202 8682202 20251203050103_4e3ym UK000P 2025-12-04T14:16:36.491Z 2025-12-05T14:22:18.305Z
8682181 8682181 20251203045734_E57Cs UK000P 2025-12-04T14:16:34.439Z 2025-12-05T14:22:17.471Z
8682092 8682092 20251203044805_WJ8Np UK000P 2025-12-04T14:16:25.332Z 2025-12-05T14:22:14.106Z
8681725 8681725 20251203035049_Up2TO UK000P 2025-12-04T14:15:21.581Z 2025-12-05T14:21:51.262Z
8681680 8681680 20251203034749_IBmGJ UK000P 2025-12-04T14:15:14.675Z 2025-12-05T14:21:48.890Z
8680905 8680905 20251203014734_uyeKI UK000P 2025-12-04T14:13:20.309Z 2025-12-05T14:21:06.587Z
8680873 8680873 20251203013807_6n3SL UK000P 2025-12-04T14:13:09.699Z 2025-12-05T14:21:05.174Z
8680311 8680311 20251202231441_hQloG UK000P 2025-12-04T14:11:40.485Z 2025-12-05T14:20:33.280Z
8680300 8680300 20251202230644_G3P8s UK000P 2025-12-04T14:11:38.890Z 2025-12-05T14:20:32.715Z
8680266 8680266 20251202225145_2KguX UK000P 2025-12-04T14:11:31.409Z 2025-12-05T14:20:26.588Z
8679328 8679328 20251202194309_vQIaa UK000P 2025-12-04T14:09:28.352Z 2025-12-05T14:19:37.848Z
8679288 8679288 20251202193803_CS0Sw UK000P 2025-12-04T14:09:21.434Z 2025-12-05T14:19:35.641Z
8679249 8679249 20251202192945_C0pPT UK000P 2025-12-04T14:09:18.540Z 2025-12-05T14:19:33.487Z
8678942 8678942 20251202181839_X3XPZ UK000P 2025-12-04T14:08:38.965Z 2025-12-05T14:19:11.423Z
8677100 8677100 20251202065138_4I7Dl UK000P 2025-12-03T14:26:18.048Z 2025-12-05T14:29:21.181Z
8676892 8676892 20251202063043_UNkW2 UK000P 2025-12-03T14:25:55.324Z 2025-12-05T14:29:15.824Z
8676638 8676638 20251202060936_YuXV3 UK000P 2025-12-03T14:25:23.718Z 2025-12-05T14:29:09.527Z
8676271 8676271 20251202054412_uOxod UK000P 2025-12-03T14:24:55.389Z 2025-12-05T14:28:53.746Z
8675866 8675866 20251202051903_bGZ6G UK000P 2025-12-03T14:24:26.934Z 2025-12-05T14:28:42.728Z
8675833 8675833 20251202051704_oQiqa UK000P 2025-12-03T14:24:23.911Z 2025-12-05T14:28:41.758Z
8675756 8675756 20251202051221_62GXu UK000P 2025-12-03T14:24:14.144Z 2025-12-05T14:28:40.236Z
8675586 8675586 20251202045856_2NWzz UK000P 2025-12-03T14:23:53.221Z 2025-12-05T14:28:36.262Z
8675409 8675409 20251202043645_wANAB UK000P 2025-12-03T14:23:41.310Z 2025-12-05T14:28:31.333Z
8675380 8675380 20251202043404_4Fhv9 UK000P 2025-12-03T14:23:39.461Z 2025-12-05T14:28:29.343Z
8675178 8675178 20251202041240_MhBsr UK000P 2025-12-03T14:23:15.545Z 2025-12-05T14:28:14.445Z
8675161 8675161 20251202041050_zU6aO UK000P 2025-12-03T14:23:14.170Z 2025-12-05T14:28:13.865Z
8675139 8675139 20251202040505_WAX13 UK000P 2025-12-03T14:23:07.010Z 2025-12-05T14:28:12.652Z
8675020 8675020 20251202035312_dCtVN UK000P 2025-12-03T14:22:51.299Z 2025-12-05T14:28:09.508Z
8674626 8674626 20251202030053_x47TA UK000P 2025-12-03T14:22:09.511Z 2025-12-05T14:27:58.307Z
8674246 8674246 20251202015430_FBiZ3 UK000P 2025-12-03T14:21:17.149Z 2025-12-05T14:27:33.680Z
8674171 8674171 20251202014324_d42jt UK000P 2025-12-03T14:21:07.452Z 2025-12-05T14:27:31.519Z
7189357 7189357 20250725000747_o8SAI UK000P 2025-07-26T12:33:55.706Z 2025-08-01T12:16:22.119Z
7189225 7189225 20250724235538_PGAzZ UK000P 2025-07-26T12:33:47.880Z 2025-08-01T12:16:21.884Z
7189128 7189128 20250724235120_9bRh3 UK000P 2025-07-26T12:33:40.428Z 2025-08-01T12:16:21.751Z
7188788 7188788 20250724232523_j9P7w UK000P 2025-07-26T12:33:15.298Z 2025-08-01T12:16:21.037Z
7176453 7176453 20250725014859_ceE3x UK000P 2025-07-26T12:02:49.429Z 2025-08-03T13:03:42.817Z
7099097 7099097 20250717015043_A1dTn UK000P 2025-07-18T12:10:22.008Z 2025-07-25T12:03:02.580Z
7099010 7099010 20250717013358_KMglf UK000P 2025-07-18T12:10:14.726Z 2025-07-25T12:03:02.372Z
7098499 7098499 20250717002446_2Oah6 UK000P 2025-07-18T12:08:45.632Z 2025-07-25T12:03:01.126Z
7098337 7098337 20250717000020_DJ83o UK000P 2025-07-18T12:08:29.518Z 2025-07-25T12:03:00.472Z
7098303 7098303 20250716235620_vii90 UK000P 2025-07-18T12:08:21.292Z 2025-07-25T12:03:00.420Z
7098224 7098224 20250716234707_qtbXE UK000P 2025-07-18T12:08:07.989Z 2025-07-25T12:03:00.304Z
7089233 7089233 20250715003251_RYFIf UK000P 2025-07-16T12:12:54.097Z 2025-07-23T12:05:01.750Z
7080327 7080327 20250713011337_iWpqC UK000P 2025-07-14T12:12:58.501Z 2025-07-21T12:03:03.924Z
7080206 7080206 20250713010307_3YZ6M UK000P 2025-07-14T12:12:41.813Z 2025-07-21T12:03:03.713Z
7080072 7080072 20250713004424_ebPqR UK000P 2025-07-14T12:12:16.046Z 2025-07-21T12:03:03.303Z
7079337 7079337 20250712232522_hyUfm UK000P 2025-07-14T12:10:14.124Z 2025-07-21T12:03:00.659Z
7076398 7076398 20250712013521_jEHbQ UK000P 2025-07-13T12:12:26.151Z 2025-07-20T12:25:18.150Z
7076359 7076359 20250712013314_CfH6a UK000P 2025-07-13T12:12:19.101Z 2025-07-20T12:25:17.866Z
7076112 7076112 20250712011136_eYLKW UK000P 2025-07-13T12:11:54.242Z 2025-07-20T12:25:15.700Z
7075979 7075979 20250712005817_NKLHm UK000P 2025-07-13T12:11:31.533Z 2025-07-20T12:25:14.712Z
7075910 7075910 20250712005338_aY32P UK000P 2025-07-13T12:11:25.251Z 2025-07-20T12:25:13.281Z
7075571 7075571 20250712001110_5P24j UK000P 2025-07-13T12:10:31.552Z 2025-07-20T12:25:10.958Z
7075291 7075291 20250711234418_8sZeO UK000P 2025-07-13T12:09:47.570Z 2025-07-20T12:25:08.115Z
7074940 7074940 20250711230342_OHAdY UK000P 2025-07-13T12:08:48.951Z 2025-07-20T12:25:04.131Z
7071892 7071892 20250711003417_faLjJ UK000P 2025-07-12T12:12:02.574Z 2025-07-18T12:36:06.304Z
7071605 7071605 20250711000246_G9ljc UK000P 2025-07-12T12:11:20.298Z 2025-07-18T12:35:57.501Z
7071602 7071602 20250711000048_bSfLQ UK000P 2025-07-12T12:11:19.664Z 2025-07-18T12:35:57.442Z
7071155 7071155 20250710225357_fFcFi UK000P 2025-07-12T12:09:59.887Z 2025-07-18T12:35:41.832Z
7068241 7068241 20250710011012_TCpxE UK000P 2025-07-11T12:14:43.923Z 2025-07-18T12:38:17.477Z
7059074 7059074 20250708011610_q1fQW UK000P 2025-07-09T12:23:55.687Z 2025-07-16T12:46:27.784Z
7058818 7058818 20250708005509_wtK81 UK000P 2025-07-09T12:23:17.688Z 2025-07-16T12:46:16.641Z
7058535 7058535 20250708002839_3szlX UK000P 2025-07-09T12:22:27.456Z 2025-07-16T12:46:03.139Z
7058198 7058198 20250707235104_p9mbL UK000P 2025-07-09T12:21:17.525Z 2025-07-16T12:45:47.439Z
7028962 7028962 20250702233513_LPGUB UK000P 2025-07-04T12:14:28.817Z 2025-07-10T12:26:01.521Z
7028834 7028834 20250702232950_wVreN UK000P 2025-07-04T12:14:21.122Z 2025-07-10T12:26:01.206Z
7028748 7028748 20250702232352_E25if UK000P 2025-07-04T12:14:16.151Z 2025-07-10T12:26:00.918Z
7028534 7028534 20250702230917_bS3BX UK000P 2025-07-04T12:13:47.656Z 2025-07-10T12:26:00.232Z
7025162 7025162 20250703003325_nKXe2 UK000P 2025-07-04T12:01:07.736Z 2025-07-12T12:55:44.185Z
7025030 7025030 20250703002521_s4vaR UK000P 2025-07-04T12:00:44.990Z 2025-07-12T12:55:37.015Z
6993351 6993351 20250629003414_WTid2 UK000P 2025-06-30T12:07:39.947Z 2025-07-07T12:30:19.861Z
6914722 6914722 20250617233336_qCYYR UK000P 2025-06-19T12:15:27.259Z 2025-06-26T12:36:40.969Z
6880951 6880951 20250610235605_tctqw UK000P 2025-06-11T12:09:54.952Z 2025-06-18T12:42:10.339Z
6841506 6841506 20250531235615_ZGpWt UK000P 2025-06-02T12:12:08.166Z 2025-06-09T12:45:19.460Z
6814192 6814192 20250527015128_g42mJ UK000P 2025-05-28T12:16:29.044Z 2025-06-04T13:02:59.492Z
6814130 6814130 20250527012917_g02wA UK000P 2025-05-28T12:16:11.403Z 2025-06-04T13:02:54.287Z
6814082 6814082 20250527011047_HWOj6 UK000P 2025-05-28T12:15:59.424Z 2025-06-04T13:02:46.800Z
6813998 6813998 20250527004418_ukMGh UK000P 2025-05-28T12:15:43.838Z 2025-06-04T13:02:36.615Z
6813974 6813974 20250527003727_j6vFy UK000P 2025-05-28T12:15:29.359Z 2025-06-04T13:02:35.751Z
6813862 6813862 20250526235825_ByTes UK000P 2025-05-28T12:15:05.650Z 2025-06-04T13:02:30.524Z
6813845 6813845 20250526235328_H2GtE UK000P 2025-05-28T12:15:01.279Z 2025-06-04T13:02:26.773Z
6809606 6809606 20250526004725_uW705 UK000P 2025-05-27T12:17:00.485Z 2025-06-03T13:03:20.426Z
6809586 6809586 20250526004551_gOBCe UK000P 2025-05-27T12:16:57.262Z 2025-06-03T13:03:19.499Z
6809538 6809538 20250526003854_h8nvt UK000P 2025-05-27T12:16:46.805Z 2025-06-03T13:03:18.154Z
6809528 6809528 20250526003355_Yz23U UK000P 2025-05-27T12:16:44.289Z 2025-06-03T13:03:17.558Z
6809394 6809394 20250526001032_0JMVA UK000P 2025-05-27T12:16:19.007Z 2025-06-03T13:03:11.909Z
6809288 6809288 20250525234757_J8nfN UK000P 2025-05-27T12:16:07.576Z 2025-06-03T13:03:09.140Z
6809011 6809011 20250525231140_68RO9 UK000P 2025-05-27T12:15:39.466Z 2025-06-03T13:03:02.816Z
6808982 6808982 20250525230611_3qi9J UK000P 2025-05-27T12:15:37.001Z 2025-06-03T13:03:02.027Z
6787292 6787292 20250523000233_xmIne UK000P 2025-05-24T12:20:38.557Z 2025-05-31T13:14:16.250Z
6786890 6786890 20250522231447_i6yWv UK000P 2025-05-24T12:19:47.961Z 2025-05-31T13:13:56.451Z

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