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

>10,000 rows count all where station_code = "UK009P" 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
8683226 8683226 20251203064326_Uh2Qq UK009P 2025-12-04T14:18:58.110Z 2025-12-05T14:23:12.166Z
8683159 8683159 20251203063341_RLR8q UK009P 2025-12-04T14:18:39.722Z 2025-12-05T14:23:09.475Z
8683120 8683120 20251203062811_Si9IK UK009P 2025-12-04T14:18:35.205Z 2025-12-05T14:23:08.023Z
8683102 8683102 20251203062758_uq4if UK009P 2025-12-04T14:18:34.878Z 2025-12-05T14:23:07.879Z
8683046 8683046 20251203062132_f0XuC UK009P 2025-12-04T14:18:29.480Z 2025-12-05T14:23:05.851Z
8682984 8682984 20251203061840_2n14J UK009P 2025-12-04T14:18:26.216Z 2025-12-05T14:23:04.695Z
8682948 8682948 20251203061657_htRba UK009P 2025-12-04T14:18:23.389Z 2025-12-05T14:23:03.828Z
8682905 8682905 20251203061549_HKz8r UK009P 2025-12-04T14:18:19.780Z 2025-12-05T14:22:56.242Z
8682893 8682893 20251203061533_woNmB UK009P 2025-12-04T14:18:13.555Z 2025-12-05T14:22:55.973Z
8682868 8682868 20251203061134_2jYU8 UK009P 2025-12-04T14:18:10.224Z 2025-12-05T14:22:54.985Z
8682846 8682846 20251203061003_nfMe2 UK009P 2025-12-04T14:18:08.034Z 2025-12-05T14:22:54.179Z
8682819 8682819 20251203060704_fkl1Q UK009P 2025-12-04T14:18:03.707Z 2025-12-05T14:22:53.178Z
8682804 8682804 20251203060645_BV89K UK009P 2025-12-04T14:18:03.015Z 2025-12-05T14:22:52.918Z
8682673 8682673 20251203055818_xlyvB UK009P 2025-12-04T14:17:53.757Z 2025-12-05T14:22:47.393Z
8682650 8682650 20251203055550_1qL7M UK009P 2025-12-04T14:17:51.847Z 2025-12-05T14:22:46.589Z
8682345 8682345 20251203051832_xhwpw UK009P 2025-12-04T14:16:50.918Z 2025-12-05T14:22:25.276Z
8682215 8682215 20251203050246_iIocV UK009P 2025-12-04T14:16:38.383Z 2025-12-05T14:22:18.933Z
8682151 8682151 20251203045505_Zd6Qx UK009P 2025-12-04T14:16:30.913Z 2025-12-05T14:22:16.038Z
8682098 8682098 20251203045047_XLHfP UK009P 2025-12-04T14:16:26.701Z 2025-12-05T14:22:14.592Z
8682040 8682040 20251203044255_Ks5T8 UK009P 2025-12-04T14:16:16.195Z 2025-12-05T14:22:12.527Z
8681998 8681998 20251203043607_xLu8s UK009P 2025-12-04T14:16:07.419Z 2025-12-05T14:22:10.769Z
8681909 8681909 20251203042704_QSlR0 UK009P 2025-12-04T14:15:59.382Z 2025-12-05T14:22:06.939Z
8681874 8681874 20251203041836_arPv5 UK009P 2025-12-04T14:15:49.944Z 2025-12-05T14:22:04.953Z
8681700 8681700 20251203034848_tB74B UK009P 2025-12-04T14:15:18.606Z 2025-12-05T14:21:50.070Z
8681599 8681599 20251203032921_T630U UK009P 2025-12-04T14:15:06.577Z 2025-12-05T14:21:42.811Z
8681571 8681571 20251203032552_Ogp2S UK009P 2025-12-04T14:15:04.206Z 2025-12-05T14:21:41.705Z
8681552 8681552 20251203032542_IhDcd UK009P 2025-12-04T14:15:03.217Z 2025-12-05T14:21:41.292Z
8681518 8681518 20251203032141_7g0RN UK009P 2025-12-04T14:14:51.958Z 2025-12-05T14:21:40.114Z
8681377 8681377 20251203030138_keE2i UK009P 2025-12-04T14:14:35.817Z 2025-12-05T14:21:34.557Z
8681335 8681335 20251203025745_olBOe UK009P 2025-12-04T14:14:31.870Z 2025-12-05T14:21:33.349Z
8681210 8681210 20251203023940_jxRGn UK009P 2025-12-04T14:14:03.725Z 2025-12-05T14:21:27.018Z
8680915 8680915 20251203014907_3qUeH UK009P 2025-12-04T14:13:21.073Z 2025-12-05T14:21:06.866Z
8680864 8680864 20251203013559_C5MF8 UK009P 2025-12-04T14:13:08.100Z 2025-12-05T14:21:04.701Z
8680695 8680695 20251203010600_G45Sm UK009P 2025-12-04T14:12:45.627Z 2025-12-05T14:20:52.760Z
8680677 8680677 20251203005837_uojRQ UK009P 2025-12-04T14:12:38.065Z 2025-12-05T14:20:51.907Z
8680623 8680623 20251203004757_upE9Y UK009P 2025-12-04T14:12:29.177Z 2025-12-05T14:20:49.526Z
8680604 8680604 20251203004654_7OKml UK009P 2025-12-04T14:12:27.420Z 2025-12-05T14:20:48.816Z
8680579 8680579 20251203003359_i2JUt UK009P 2025-12-04T14:12:23.874Z 2025-12-05T14:20:45.312Z
8680539 8680539 20251203002613_CipJT UK009P 2025-12-04T14:12:18.013Z 2025-12-05T14:20:43.542Z
8680521 8680521 20251203002221_M2YVP UK009P 2025-12-04T14:12:15.216Z 2025-12-05T14:20:42.595Z
8680490 8680490 20251203001904_84jI5 UK009P 2025-12-04T14:12:11.212Z 2025-12-05T14:20:40.641Z
8680472 8680472 20251203001231_NYalx UK009P 2025-12-04T14:12:06.376Z 2025-12-05T14:20:39.937Z
8680465 8680465 20251203000527_NJCoL UK009P 2025-12-04T14:12:04.906Z 2025-12-05T14:20:39.477Z
8680432 8680432 20251202235905_Wqhfc UK009P 2025-12-04T14:11:59.673Z 2025-12-05T14:20:38.290Z
8680406 8680406 20251202235333_Q7cip UK009P 2025-12-04T14:11:56.267Z 2025-12-05T14:20:37.383Z
8680400 8680400 20251202234917_TBvLP UK009P 2025-12-04T14:11:55.803Z 2025-12-05T14:20:37.200Z
8680386 8680386 20251202234322_2voEr UK009P 2025-12-04T14:11:54.535Z 2025-12-05T14:20:36.752Z
8680374 8680374 20251202234007_TcvCo UK009P 2025-12-04T14:11:52.915Z 2025-12-05T14:20:36.155Z
8680368 8680368 20251202233838_yxAUi UK009P 2025-12-04T14:11:52.432Z 2025-12-05T14:20:35.969Z
8680238 8680238 20251202224132_oPb3O UK009P 2025-12-04T14:11:28.632Z 2025-12-05T14:20:25.475Z
8680158 8680158 20251202215439_sBhq4 UK009P 2025-12-04T14:11:15.571Z 2025-12-05T14:20:19.668Z
8680146 8680146 20251202215408_2ep4w UK009P 2025-12-04T14:11:11.690Z 2025-12-05T14:20:19.410Z
8680113 8680113 20251202214107_8tqR9 UK009P 2025-12-04T14:11:07.134Z 2025-12-05T14:20:17.820Z
8680013 8680013 20251202211719_1QH2i UK009P 2025-12-04T14:10:54.273Z 2025-12-05T14:20:13.597Z
8679983 8679983 20251202211345_CKdSa UK009P 2025-12-04T14:10:51.259Z 2025-12-05T14:20:12.343Z
8679980 8679980 20251202211324_jjdQr UK009P 2025-12-04T14:10:50.833Z 2025-12-05T14:20:12.165Z
8679973 8679973 20251202211301_tqBsS UK009P 2025-12-04T14:10:49.817Z 2025-12-05T14:20:11.764Z
8679951 8679951 20251202211200_skzIB UK009P 2025-12-04T14:10:48.225Z 2025-12-05T14:20:11.195Z
8679076 8679076 20251202185054_l4SS9 UK009P 2025-12-04T14:08:52.942Z 2025-12-05T14:19:18.983Z
8678876 8678876 20251202175939_NbEh2 UK009P 2025-12-04T14:08:24.220Z 2025-12-05T14:19:06.708Z
8678805 8678805 20251202173643_PCpy2 UK009P 2025-12-04T14:08:14.609Z 2025-12-05T14:19:01.799Z
8676956 8676956 20251202063438_2Pqjs UK009P 2025-12-03T14:25:57.935Z 2025-12-05T14:29:16.789Z
8676938 8676938 20251202063126_hh3Xs UK009P 2025-12-03T14:25:56.698Z 2025-12-05T14:29:16.357Z
8676877 8676877 20251202062834_wXBla UK009P 2025-12-03T14:25:54.315Z 2025-12-05T14:29:15.318Z
8676849 8676849 20251202062759_i9Ph2 UK009P 2025-12-03T14:25:52.815Z 2025-12-05T14:29:14.703Z
8676795 8676795 20251202062627_fBsOx UK009P 2025-12-03T14:25:40.360Z 2025-12-05T14:29:13.816Z
8676746 8676746 20251202062030_g0RX2 UK009P 2025-12-03T14:25:32.283Z 2025-12-05T14:29:12.354Z
8676680 8676680 20251202061146_hjmEM UK009P 2025-12-03T14:25:25.849Z 2025-12-05T14:29:10.563Z
8676657 8676657 20251202061034_pIsdl UK009P 2025-12-03T14:25:24.596Z 2025-12-05T14:29:10.066Z
8676630 8676630 20251202060933_T3bUR UK009P 2025-12-03T14:25:22.800Z 2025-12-05T14:29:09.245Z
8676422 8676422 20251202055148_BwZvy UK009P 2025-12-03T14:25:11.972Z 2025-12-05T14:28:56.189Z
8676410 8676410 20251202055146_9QRie UK009P 2025-12-03T14:25:11.576Z 2025-12-05T14:28:56.065Z
8676346 8676346 20251202054739_2BFSM UK009P 2025-12-03T14:25:07.293Z 2025-12-05T14:28:54.786Z
8676170 8676170 20251202053942_XoT3u UK009P 2025-12-03T14:24:47.969Z 2025-12-05T14:28:49.808Z
8676005 8676005 20251202053053_619Iu UK009P 2025-12-03T14:24:35.700Z 2025-12-05T14:28:45.949Z
8675985 8675985 20251202052834_5X6sK UK009P 2025-12-03T14:24:34.937Z 2025-12-05T14:28:45.571Z
8675914 8675914 20251202052257_DArRJ UK009P 2025-12-03T14:24:29.974Z 2025-12-05T14:28:44.007Z
8675855 8675855 20251202051854_2wpXN UK009P 2025-12-03T14:24:26.186Z 2025-12-05T14:28:42.448Z
8675800 8675800 20251202051517_lHN9U UK009P 2025-12-03T14:24:15.856Z 2025-12-05T14:28:40.861Z
8675665 8675665 20251202050440_IjvhH UK009P 2025-12-03T14:23:59.208Z 2025-12-05T14:28:37.573Z
8675616 8675616 20251202050215_fgICz UK009P 2025-12-03T14:23:56.044Z 2025-12-05T14:28:36.885Z
8675584 8675584 20251202045844_j6jBp UK009P 2025-12-03T14:23:52.887Z 2025-12-05T14:28:36.159Z
8675545 8675545 20251202045557_6jwAO UK009P 2025-12-03T14:23:50.825Z 2025-12-05T14:28:35.198Z
8675535 8675535 20251202045507_Lbzry UK009P 2025-12-03T14:23:50.385Z 2025-12-05T14:28:35.041Z
8675343 8675343 20251202043004_dPeUY UK009P 2025-12-03T14:23:32.179Z 2025-12-05T14:28:20.268Z
8675298 8675298 20251202042601_vsoN5 UK009P 2025-12-03T14:23:30.010Z 2025-12-05T14:28:19.345Z
8675031 8675031 20251202035409_3obmf UK009P 2025-12-03T14:22:51.881Z 2025-12-05T14:28:09.706Z
8674967 8674967 20251202034514_bEb57 UK009P 2025-12-03T14:22:46.932Z 2025-12-05T14:28:07.984Z
8674894 8674894 20251202033652_pT7HE UK009P 2025-12-03T14:22:40.649Z 2025-12-05T14:28:05.953Z
8674487 8674487 20251202023306_d0ZQJ UK009P 2025-12-03T14:21:41.830Z 2025-12-05T14:27:42.991Z
8674142 8674142 20251202013308_dzk4F UK009P 2025-12-03T14:20:59.587Z 2025-12-05T14:27:30.289Z
8674123 8674123 20251202013005_B8EpP UK009P 2025-12-03T14:20:57.512Z 2025-12-05T14:27:29.534Z
8674092 8674092 20251202012803_dtxbC UK009P 2025-12-03T14:20:55.738Z 2025-12-05T14:27:28.593Z
8674062 8674062 20251202012337_xuayj UK009P 2025-12-03T14:20:52.821Z 2025-12-05T14:27:27.902Z
8673979 8673979 20251202005444_JJCW2 UK009P 2025-12-03T14:20:35.120Z 2025-12-05T14:27:24.545Z
8673931 8673931 20251202004358_2DsWN UK009P 2025-12-03T14:20:24.060Z 2025-12-05T14:27:23.338Z
8673843 8673843 20251201235812_BjBhz UK009P 2025-12-03T14:20:10.363Z 2025-12-05T14:27:19.566Z
8673804 8673804 20251201233821_HSMwa UK009P 2025-12-03T14:20:05.252Z 2025-12-05T14:27:17.622Z
8658604 8658604 20251126053426_fNJ38 UK009P 2025-12-01T15:04:59.959Z 2025-12-04T15:11:34.931Z
8658117 8658117 20251130064213_NU3HU UK009P 2025-12-01T14:34:55.479Z 2025-12-05T14:46:02.864Z

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