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 = "BE000L" 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
9262863 9262863 20260126035406_ifg7q BE000L 2026-01-27T14:15:44.050Z 2026-01-29T14:38:57.043Z
9262855 9262855 20260126035158_kGyBD BE000L 2026-01-27T14:15:41.649Z 2026-01-29T14:38:52.879Z
9262819 9262819 20260126032534_0VkuL BE000L 2026-01-27T14:15:33.985Z 2026-01-29T14:38:50.406Z
9262784 9262784 20260126024956_8co0c BE000L 2026-01-27T14:15:17.742Z 2026-01-29T14:38:47.370Z
9262719 9262719 20260126013728_LW6OU BE000L 2026-01-27T14:15:00.690Z 2026-01-29T14:38:38.700Z
9262717 9262717 20260126013429_n2jgc BE000L 2026-01-27T14:15:00.071Z 2026-01-29T14:38:38.530Z
9262686 9262686 20260126010224_jvRCJ BE000L 2026-01-27T14:14:48.111Z 2026-01-29T14:38:34.645Z
9260781 9260781 20260122053308_Ea2ZB BE000L 2026-01-26T14:38:55.961Z 2026-01-29T14:58:42.228Z
9260774 9260774 20260122031327_KJfP1 BE000L 2026-01-26T14:38:23.497Z 2026-01-29T14:58:09.981Z
9260748 9260748 20260121212409_GDvr2 BE000L 2026-01-26T14:37:00.449Z 2026-01-29T14:56:53.228Z
9260743 9260743 20260121183137_NvmNZ BE000L 2026-01-26T14:36:14.099Z 2026-01-29T14:56:09.075Z
9260450 9260450 20260125043406_kqk39 BE000L 2026-01-26T14:21:51.624Z 2026-01-29T14:44:13.777Z
9260445 9260445 20260125043006_adLKm BE000L 2026-01-26T14:21:50.687Z 2026-01-29T14:44:13.455Z
9260193 9260193 20260125030238_R5haS BE000L 2026-01-26T14:20:36.420Z 2026-01-29T14:43:57.959Z
9260150 9260150 20260125024628_6Vng0 BE000L 2026-01-26T14:20:26.599Z 2026-01-29T14:43:51.395Z
9260132 9260132 20260125024210_vNhph BE000L 2026-01-26T14:20:22.403Z 2026-01-29T14:43:50.356Z
9260129 9260129 20260125024102_giMqk BE000L 2026-01-26T14:20:21.788Z 2026-01-29T14:43:50.163Z
9260064 9260064 20260125022006_vI8Gn BE000L 2026-01-26T14:20:00.572Z 2026-01-29T14:43:44.403Z
9259940 9259940 20260125011808_6ox4m BE000L 2026-01-26T14:19:25.276Z 2026-01-29T14:43:36.312Z
9259934 9259934 20260125011529_GkHWK BE000L 2026-01-26T14:19:23.942Z 2026-01-29T14:43:36.063Z
9259906 9259906 20260125010859_q3y5C BE000L 2026-01-26T14:19:15.268Z 2026-01-29T14:43:34.519Z
9259883 9259883 20260125005855_Ehuzt BE000L 2026-01-26T14:19:09.552Z 2026-01-29T14:43:33.245Z
9259869 9259869 20260125005305_muW2n BE000L 2026-01-26T14:19:05.857Z 2026-01-29T14:43:31.793Z
9259867 9259867 20260125005240_iGoFd BE000L 2026-01-26T14:19:05.292Z 2026-01-29T14:43:31.618Z
9259777 9259777 20260125000541_oWd3n BE000L 2026-01-26T14:18:34.020Z 2026-01-29T14:43:18.764Z
9259710 9259710 20260124233504_OF3I6 BE000L 2026-01-26T14:18:11.246Z 2026-01-29T14:43:14.553Z
9259664 9259664 20260124230001_8WV7V BE000L 2026-01-26T14:18:01.609Z 2026-01-29T14:43:11.994Z
9259616 9259616 20260124221708_FMR5Y BE000L 2026-01-26T14:17:39.999Z 2026-01-29T14:43:09.223Z
9258987 9258987 20260124181729_KsWd3 BE000L 2026-01-26T14:15:19.520Z 2026-01-29T14:42:22.285Z
9256023 9256023 20260124054513_up2ud BE000L 2026-01-25T14:15:35.847Z 2026-01-29T14:48:18.897Z
9255970 9255970 20260124053316_EEqKU BE000L 2026-01-25T14:15:26.912Z 2026-01-29T14:48:14.202Z
9255888 9255888 20260124051251_dtJT8 BE000L 2026-01-25T14:15:03.588Z 2026-01-29T14:48:03.637Z
9255614 9255614 20260124041957_kZgW9 BE000L 2026-01-25T14:14:06.753Z 2026-01-29T14:47:42.823Z
9252759 9252759 20260123060934_h2d7v BE000L 2026-01-24T14:17:02.404Z 2026-01-29T14:53:23.248Z
9251803 9251803 20260122230427_2dt5s BE000L 2026-01-24T14:13:17.397Z 2026-01-29T14:52:11.110Z
9249635 9249635 20260122060813_DCVdG BE000L 2026-01-23T14:15:49.318Z 2026-01-29T14:58:47.475Z
9249626 9249626 20260122060813_5DVwn BE000L 2026-01-23T14:15:48.888Z 2026-01-29T14:58:47.397Z
9249519 9249519 20260122053608_MX72P BE000L 2026-01-23T14:15:38.217Z 2026-01-29T14:58:42.950Z
9249479 9249479 20260122052949_1MIai BE000L 2026-01-23T14:15:29.332Z 2026-01-29T14:58:41.297Z
9249396 9249396 20260122050709_Cvh3r BE000L 2026-01-23T14:15:18.015Z 2026-01-29T14:58:28.859Z
9249352 9249352 20260122050226_Uy8Wx BE000L 2026-01-23T14:15:13.217Z 2026-01-29T14:58:27.039Z
9249332 9249332 20260122045235_eWVqL BE000L 2026-01-23T14:15:11.638Z 2026-01-29T14:58:26.465Z
9249306 9249306 20260122044404_nkSMt BE000L 2026-01-23T14:15:09.075Z 2026-01-29T14:58:22.737Z
9249263 9249263 20260122043118_HFqon BE000L 2026-01-23T14:15:04.732Z 2026-01-29T14:58:20.570Z
9249203 9249203 20260122040803_wgULS BE000L 2026-01-23T14:14:51.307Z 2026-01-29T14:58:16.843Z
9249161 9249161 20260122035458_HhIUZ BE000L 2026-01-23T14:14:41.944Z 2026-01-29T14:58:14.933Z
9249158 9249158 20260122035018_Tzg8W BE000L 2026-01-23T14:14:41.478Z 2026-01-29T14:58:14.866Z
9249146 9249146 20260122034749_MGuEO BE000L 2026-01-23T14:14:40.260Z 2026-01-29T14:58:14.387Z
9249132 9249132 20260122034520_NqVvz BE000L 2026-01-23T14:14:39.361Z 2026-01-29T14:58:14.099Z
9249013 9249013 20260122030630_2Vlox BE000L 2026-01-23T14:14:25.412Z 2026-01-29T14:58:08.960Z
9249004 9249004 20260122030514_tjVLh BE000L 2026-01-23T14:14:17.743Z 2026-01-29T14:58:08.194Z
9248996 9248996 20260122030511_p0BKw BE000L 2026-01-23T14:14:17.046Z 2026-01-29T14:58:07.872Z
9248968 9248968 20260122025620_UOuMn BE000L 2026-01-23T14:14:13.787Z 2026-01-29T14:57:58.816Z
9248961 9248961 20260122025609_a3NIl BE000L 2026-01-23T14:14:13.352Z 2026-01-29T14:57:57.846Z
9248936 9248936 20260122025135_4zUvD BE000L 2026-01-23T14:14:08.347Z 2026-01-29T14:57:55.536Z
9248854 9248854 20260122022817_DDzMt BE000L 2026-01-23T14:13:59.478Z 2026-01-29T14:57:49.753Z
9248784 9248784 20260122020950_oSQ8S BE000L 2026-01-23T14:13:51.392Z 2026-01-29T14:57:46.570Z
9248748 9248748 20260122020052_HA221 BE000L 2026-01-23T14:13:37.956Z 2026-01-29T14:57:44.922Z
9248674 9248674 20260122013859_GPTfx BE000L 2026-01-23T14:13:24.337Z 2026-01-29T14:57:40.229Z
9248650 9248650 20260122013311_psDeX BE000L 2026-01-23T14:13:21.491Z 2026-01-29T14:57:38.845Z
9248636 9248636 20260122012604_WeCIL BE000L 2026-01-23T14:13:20.091Z 2026-01-29T14:57:38.187Z
9248610 9248610 20260122011000_qVrg3 BE000L 2026-01-23T14:13:15.900Z 2026-01-29T14:57:36.663Z
9248597 9248597 20260122005914_T6g3z BE000L 2026-01-23T14:13:13.894Z 2026-01-25T14:26:46.875Z
9248587 9248587 20260122005542_TQmQA BE000L 2026-01-23T14:13:12.920Z 2026-01-29T14:57:35.710Z
9248462 9248462 20260121235512_3z1AI BE000L 2026-01-23T14:12:51.055Z 2026-01-29T14:57:21.787Z
9248436 9248436 20260121234650_2FdeR BE000L 2026-01-23T14:12:47.917Z 2026-01-29T14:57:19.023Z
9248420 9248420 20260121234109_laCIt BE000L 2026-01-23T14:12:46.112Z 2026-01-29T14:57:18.185Z
9248407 9248407 20260121233916_TQ37H BE000L 2026-01-23T14:12:44.613Z 2026-01-29T14:57:17.652Z
9248381 9248381 20260121232659_3XtTF BE000L 2026-01-23T14:12:41.011Z 2026-01-29T14:57:16.270Z
9248334 9248334 20260121225900_LjHdC BE000L 2026-01-23T14:12:31.808Z 2026-01-29T14:57:14.133Z
9248224 9248224 20260121222207_laua0 BE000L 2026-01-23T14:12:15.897Z 2026-01-29T14:57:09.125Z
9248191 9248191 20260121221247_7jvgw BE000L 2026-01-23T14:12:13.148Z 2026-01-29T14:57:08.031Z
9248187 9248187 20260121220955_lRDnR BE000L 2026-01-23T14:12:12.835Z 2026-01-29T14:57:07.765Z
9248175 9248175 20260121220238_BP3dl BE000L 2026-01-23T14:12:11.492Z 2026-01-29T14:57:07.073Z
9248133 9248133 20260121214203_luwAe BE000L 2026-01-23T14:12:06.557Z 2026-01-29T14:56:56.032Z
9248068 9248068 20260121212409_AzV3D BE000L 2026-01-23T14:11:50.421Z 2026-01-25T14:26:09.119Z
9248018 9248018 20260121211100_JUjyK BE000L 2026-01-23T14:11:43.924Z 2026-01-29T14:56:48.587Z
9247937 9247937 20260121203736_OBq5E BE000L 2026-01-23T14:11:34.682Z 2026-01-29T14:56:44.622Z
9247868 9247868 20260121201829_MN0gb BE000L 2026-01-23T14:11:18.935Z 2026-01-29T14:56:41.460Z
9247654 9247654 20260121192432_Gulcu BE000L 2026-01-23T14:10:41.383Z 2026-01-29T14:56:21.952Z
9247443 9247443 20260121183137_OzSJs BE000L 2026-01-23T14:10:04.843Z 2026-01-25T14:25:16.448Z
9247285 9247285 20260121175424_GBOuI BE000L 2026-01-23T14:09:36.698Z 2026-01-29T14:56:02.399Z
9247276 9247276 20260121175350_dgJxA BE000L 2026-01-23T14:09:35.318Z 2026-01-29T14:55:58.498Z
9247199 9247199 20260121173456_G7P2M BE000L 2026-01-23T14:09:23.641Z 2026-01-29T14:55:49.368Z
9244791 9244791 20260119183522_UcG2F BE000L 2026-01-22T14:30:53.004Z 2026-01-28T14:56:51.125Z
9244776 9244776 20260119181256_Q2jU0 BE000L 2026-01-22T14:30:45.100Z 2026-01-28T14:56:45.970Z
9243236 9243236 20260121040328_IsoFu BE000L 2026-01-22T14:21:03.872Z 2026-01-29T15:04:52.140Z
9240781 9240781 20260120174745_UMfP8 BE000L 2026-01-22T14:10:00.448Z 2026-01-29T15:01:54.787Z
9239052 9239052 20260118060336_28qKL BE000L 2026-01-21T14:44:56.952Z 2026-01-26T15:03:49.037Z
9239018 9239018 20260117213623_DVQ5U BE000L 2026-01-21T14:42:49.929Z 2026-01-26T15:01:27.081Z
9237715 9237715 20260120055520_tRqsN BE000L 2026-01-21T14:27:29.465Z 2026-01-28T15:01:37.755Z
9237620 9237620 20260120054452_Srttm BE000L 2026-01-21T14:27:08.800Z 2026-01-28T15:01:33.502Z
9237516 9237516 20260120052740_V2pEW BE000L 2026-01-21T14:26:50.549Z 2026-01-28T15:01:29.083Z
9237462 9237462 20260120052106_QEVNS BE000L 2026-01-21T14:26:37.217Z 2026-01-28T15:01:26.930Z
9237358 9237358 20260120050652_D3bWc BE000L 2026-01-21T14:26:15.940Z 2026-01-28T15:01:21.713Z
9237031 9237031 20260120042840_SJFzO BE000L 2026-01-21T14:24:59.561Z 2026-01-28T15:00:54.766Z
9236988 9236988 20260120042544_ieTvb BE000L 2026-01-21T14:24:52.679Z 2026-01-28T15:00:52.503Z
9236699 9236699 20260120034841_jxSDU BE000L 2026-01-21T14:23:43.274Z 2026-01-28T15:00:30.643Z
9236640 9236640 20260120034303_7wEVn BE000L 2026-01-21T14:23:36.134Z 2026-01-28T15:00:26.914Z
9236620 9236620 20260120034123_Lrkok BE000L 2026-01-21T14:23:33.188Z 2026-01-28T15:00:25.263Z

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