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,626 rows where station_code = "BE000P" 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
9259820 9259820 20260125002811_Ryxdg BE000P 2026-01-26T14:18:43.112Z 2026-01-29T14:43:23.513Z
9259791 9259791 20260125001432_B3MSt BE000P 2026-01-26T14:18:36.663Z 2026-01-29T14:43:19.476Z
9255697 9255697 20260124043320_sFE5y BE000P 2026-01-25T14:14:25.853Z 2026-01-29T14:47:52.542Z
9255638 9255638 20260124042259_waz8y BE000P 2026-01-25T14:14:09.610Z 2026-01-29T14:47:48.920Z
9255588 9255588 20260124041713_66C2u BE000P 2026-01-25T14:14:02.913Z 2026-01-29T14:47:41.634Z
9255579 9255579 20260124041700_bbM6S BE000P 2026-01-25T14:14:01.909Z 2026-01-29T14:47:41.270Z
9255573 9255573 20260124041525_cuoME BE000P 2026-01-25T14:14:00.632Z 2026-01-29T14:47:40.859Z
9255537 9255537 20260124040649_AVQ4I BE000P 2026-01-25T14:13:53.767Z 2026-01-29T14:47:38.950Z
9255504 9255504 20260124035249_WaIk2 BE000P 2026-01-25T14:13:42.850Z 2026-01-29T14:47:35.006Z
9255489 9255489 20260124035011_Gk0Vr BE000P 2026-01-25T14:13:37.182Z 2026-01-29T14:47:34.018Z
9249672 9249672 20260122061538_dJwYk BE000P 2026-01-23T14:15:52.291Z 2026-01-29T14:58:48.748Z
9249567 9249567 20260122055018_bf9qB BE000P 2026-01-23T14:15:43.417Z 2026-01-29T14:58:45.091Z
9249559 9249559 20260122054837_bCcoP BE000P 2026-01-23T14:15:42.471Z 2026-01-29T14:58:44.705Z
9249507 9249507 20260122053340_XhyDV BE000P 2026-01-23T14:15:36.900Z 2026-01-29T14:58:42.383Z
9249489 9249489 20260122053048_oQzdr BE000P 2026-01-23T14:15:35.603Z 2026-01-29T14:58:41.688Z
9249474 9249474 20260122052739_AZ3ht BE000P 2026-01-23T14:15:28.512Z 2026-01-29T14:58:40.969Z
9249381 9249381 20260122050525_fGQ7h BE000P 2026-01-23T14:15:15.790Z 2026-01-29T14:58:28.136Z
9249373 9249373 20260122050418_fPqsX BE000P 2026-01-23T14:15:14.689Z 2026-01-29T14:58:27.765Z
9249335 9249335 20260122045513_24hx0 BE000P 2026-01-23T14:15:12.047Z 2026-01-29T14:58:26.537Z
9249324 9249324 20260122044706_9jab4 BE000P 2026-01-23T14:15:10.571Z 2026-01-29T14:58:25.884Z
9249317 9249317 20260122044550_B9Pjt BE000P 2026-01-23T14:15:09.952Z 2026-01-29T14:58:25.564Z
9249294 9249294 20260122044017_Jq2at BE000P 2026-01-23T14:15:07.845Z 2026-01-29T14:58:22.140Z
9249245 9249245 20260122042412_33bXT BE000P 2026-01-23T14:15:03.097Z 2026-01-29T14:58:19.693Z
9249102 9249102 20260122033648_xIOMH BE000P 2026-01-23T14:14:35.146Z 2026-01-29T14:58:12.696Z
9249093 9249093 20260122033349_wTULI BE000P 2026-01-23T14:14:34.142Z 2026-01-29T14:58:12.353Z
9249085 9249085 20260122033104_GkkJ5 BE000P 2026-01-23T14:14:33.467Z 2026-01-29T14:58:12.107Z
9249076 9249076 20260122032941_vED2S BE000P 2026-01-23T14:14:32.879Z 2026-01-29T14:58:11.681Z
9249053 9249053 20260122032251_3HZmI BE000P 2026-01-23T14:14:30.813Z 2026-01-29T14:58:10.867Z
9249027 9249027 20260122031207_lJ0n4 BE000P 2026-01-23T14:14:27.205Z 2026-01-29T14:58:09.754Z
9249025 9249025 20260122031149_VnFaS BE000P 2026-01-23T14:14:26.929Z 2026-01-29T14:58:09.638Z
9248943 9248943 20260122025209_ISJik BE000P 2026-01-23T14:14:09.109Z 2026-01-29T14:57:55.755Z
9248902 9248902 20260122023948_9C2U9 BE000P 2026-01-23T14:14:05.737Z 2026-01-29T14:57:54.257Z
9248837 9248837 20260122022325_2KAHe BE000P 2026-01-23T14:13:57.598Z 2026-01-29T14:57:49.029Z
9248824 9248824 20260122022151_5rbBo BE000P 2026-01-23T14:13:55.968Z 2026-01-29T14:57:48.381Z
9248782 9248782 20260122020940_GWMNA BE000P 2026-01-23T14:13:51.121Z 2026-01-29T14:57:46.442Z
9248756 9248756 20260122020112_tppgg BE000P 2026-01-23T14:13:38.918Z 2026-01-29T14:57:45.321Z
9248718 9248718 20260122015113_VOkPZ BE000P 2026-01-23T14:13:30.807Z 2026-01-29T14:57:42.668Z
9248561 9248561 20260122004152_142bH BE000P 2026-01-23T14:13:04.860Z 2026-01-29T14:57:26.627Z
9248475 9248475 20260122000551_KEoUB BE000P 2026-01-23T14:12:53.150Z 2026-01-29T14:57:22.803Z
9248426 9248426 20260121234256_hYHKZ BE000P 2026-01-23T14:12:46.440Z 2026-01-29T14:57:18.309Z
9248364 9248364 20260121231309_AnQ2L BE000P 2026-01-23T14:12:39.100Z 2026-01-29T14:57:15.753Z
9248347 9248347 20260121230402_ptWSI BE000P 2026-01-23T14:12:33.758Z 2026-01-29T14:57:14.936Z
9248290 9248290 20260121224742_iHOnM BE000P 2026-01-23T14:12:24.999Z 2026-01-29T14:57:12.103Z
9248182 9248182 20260121220541_1kIjN BE000P 2026-01-23T14:12:12.488Z 2026-01-29T14:57:07.621Z
9248177 9248177 20260121220258_BPoTC BE000P 2026-01-23T14:12:11.762Z 2026-01-29T14:57:07.320Z
9248171 9248171 20260121220236_ZHSh9 BE000P 2026-01-23T14:12:11.157Z 2026-01-29T14:57:06.798Z
9248159 9248159 20260121215810_bBgMH BE000P 2026-01-23T14:12:09.628Z 2026-01-29T14:57:05.990Z
9247969 9247969 20260121205338_HhVEv BE000P 2026-01-23T14:11:38.557Z 2026-01-29T14:56:46.516Z
9247927 9247927 20260121203504_kdid3 BE000P 2026-01-23T14:11:33.544Z 2026-01-29T14:56:44.221Z
9247484 9247484 20260121184531_OoSLI BE000P 2026-01-23T14:10:10.400Z 2026-01-29T14:56:11.257Z
9247436 9247436 20260121183007_VJZ5q BE000P 2026-01-23T14:10:03.657Z 2026-01-29T14:56:08.495Z
9239042 9239042 20260118032054_gGQqQ BE000P 2026-01-21T14:44:16.244Z 2026-01-26T15:02:50.462Z
9224701 9224701 20260118054517_HmF5W BE000P 2026-01-19T14:25:38.086Z 2026-01-26T15:03:46.071Z
9224668 9224668 20260118053601_ly224 BE000P 2026-01-19T14:25:25.882Z 2026-01-26T15:03:44.959Z
9224552 9224552 20260118051124_Y9cBp BE000P 2026-01-19T14:24:53.591Z 2026-01-26T15:03:23.461Z
9224521 9224521 20260118050639_iQzX2 BE000P 2026-01-19T14:24:44.003Z 2026-01-26T15:03:22.312Z
9224347 9224347 20260118042339_XtSXl BE000P 2026-01-19T14:24:01.667Z 2026-01-26T15:03:15.110Z
9224323 9224323 20260118042010_HnuUv BE000P 2026-01-19T14:23:52.718Z 2026-01-26T15:03:14.135Z
9224288 9224288 20260118041107_4cErr BE000P 2026-01-19T14:23:43.242Z 2026-01-26T15:03:11.848Z
9224149 9224149 20260118033738_6jgQJ BE000P 2026-01-19T14:23:05.836Z 2026-01-26T15:03:06.749Z
9224083 9224083 20260118032054_J2Zsv BE000P 2026-01-19T14:22:42.763Z 2026-01-20T14:42:26.260Z
9224059 9224059 20260118031745_4MPA6 BE000P 2026-01-19T14:22:34.352Z 2026-01-26T15:02:49.322Z
9223914 9223914 20260118024952_3kGMB BE000P 2026-01-19T14:21:49.991Z 2026-01-26T15:02:41.429Z
9223619 9223619 20260118014614_z0PBz BE000P 2026-01-19T14:20:12.909Z 2026-01-26T15:02:29.736Z
9223584 9223584 20260118013214_siLsO BE000P 2026-01-19T14:20:03.958Z 2026-01-26T15:02:23.876Z
9223570 9223570 20260118012743_jI0R0 BE000P 2026-01-19T14:20:00.165Z 2026-01-26T15:02:14.949Z
9223459 9223459 20260118004940_BdJsI BE000P 2026-01-19T14:19:26.346Z 2026-01-26T15:02:07.688Z
9223379 9223379 20260118002754_ePZNl BE000P 2026-01-19T14:18:58.202Z 2026-01-26T15:02:04.514Z
9223362 9223362 20260118002426_9Y40g BE000P 2026-01-19T14:18:54.856Z 2026-01-26T15:02:03.931Z
9223347 9223347 20260118002302_6s8ma BE000P 2026-01-19T14:18:51.785Z 2026-01-26T15:02:03.342Z
9223297 9223297 20260118000831_QmczN BE000P 2026-01-19T14:18:36.624Z 2026-01-26T15:02:01.482Z
9223270 9223270 20260118000253_Dr8Ew BE000P 2026-01-19T14:18:27.665Z 2026-01-26T15:02:00.467Z
9223246 9223246 20260117235456_jh0cu BE000P 2026-01-19T14:18:22.607Z 2026-01-26T15:01:59.552Z
9222525 9222525 20260117195018_X7Rgk BE000P 2026-01-19T14:15:08.629Z 2026-01-26T15:01:12.507Z
9222245 9222245 20260117184721_ycqcO BE000P 2026-01-19T14:13:55.324Z 2026-01-26T15:00:45.058Z
9218811 9218811 20260117055813_mnWPy BE000P 2026-01-18T14:13:47.228Z 2026-01-25T14:58:52.124Z
9128068 9128068 20260102061017_B4C7x BE000P 2026-01-03T14:13:07.010Z 2026-01-09T14:50:22.435Z
9128000 9128000 20260102060052_fTznh BE000P 2026-01-03T14:12:52.455Z 2026-01-09T14:50:20.142Z
9124276 9124276 20251231054620_b8h0L BE000P 2026-01-02T14:44:05.243Z 2026-01-08T15:11:25.179Z
9124272 9124272 20251231054147_OXQdt BE000P 2026-01-02T14:43:53.437Z 2026-01-08T15:11:21.027Z
9124171 9124171 20251231051059_N6myj BE000P 2026-01-02T14:42:23.106Z 2026-01-08T15:10:49.723Z
9123905 9123905 20251231040159_jhRsM BE000P 2026-01-02T14:38:00.025Z 2026-01-08T15:09:23.820Z
9123699 9123699 20251231030056_8xwwS BE000P 2026-01-02T14:34:07.128Z 2026-01-08T15:08:14.773Z
9123546 9123546 20251231015638_jDk03 BE000P 2026-01-02T14:30:36.197Z 2026-01-08T15:07:13.323Z
9123496 9123496 20251231013615_mui2Q BE000P 2026-01-02T14:29:22.784Z 2026-01-08T15:06:53.056Z
9123489 9123489 20251231013326_vYHvU BE000P 2026-01-02T14:29:16.536Z 2026-01-08T15:06:49.830Z
9119866 9119866 20251230192157_xJkwg BE000P 2026-01-01T14:57:32.548Z 2026-01-07T15:13:24.731Z
9119838 9119838 20251230191158_RbyrQ BE000P 2026-01-01T14:57:25.023Z 2026-01-07T15:13:22.806Z
9119731 9119731 20251230184908_fJhT2 BE000P 2026-01-01T14:57:00.321Z 2026-01-07T15:13:13.650Z
9119608 9119608 20251230182722_2RdZj BE000P 2026-01-01T14:56:40.198Z 2026-01-07T15:12:56.441Z
9119342 9119342 20251230173932_emoon BE000P 2026-01-01T14:55:47.898Z 2026-01-07T15:12:27.942Z
9116484 9116484 20251231061216_TV7Sc BE000P 2026-01-01T14:28:06.004Z 2026-01-08T15:11:49.731Z
9116120 9116120 20251231054955_U53kP BE000P 2026-01-01T14:27:18.962Z 2026-01-08T15:11:27.427Z
9116045 9116045 20251231054620_hIroR BE000P 2026-01-01T14:27:12.505Z 2026-01-08T15:11:25.297Z
9116011 9116011 20251231054147_ZB2C6 BE000P 2026-01-01T14:27:00.941Z 2026-01-08T15:11:21.176Z
9115786 9115786 20251231052918_FHICK BE000P 2026-01-01T14:26:28.993Z 2026-01-08T15:11:12.120Z
9115642 9115642 20251231052119_ndFHq BE000P 2026-01-01T14:26:04.712Z 2026-01-08T15:11:00.477Z
9115625 9115625 20251231051940_lllrQ BE000P 2026-01-01T14:25:57.511Z 2026-01-01T14:57:54.344Z
9115607 9115607 20251231051726_P1zCj BE000P 2026-01-01T14:25:54.540Z 2026-01-08T15:10:56.855Z
9115536 9115536 20251231051411_JNmdA BE000P 2026-01-01T14:25:40.802Z 2026-01-08T15:10:51.812Z

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