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

9,475 rows where station_code = "BE0002" 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
8665677 8665677 20251201035026_SeVWe BE0002 2025-12-02T14:24:19.354Z 2025-12-06T14:41:45.811Z
8665444 8665444 20251201032120_k8MoS BE0002 2025-12-02T14:23:42.604Z 2025-12-06T14:41:37.820Z
8664948 8664948 20251201020803_pXdMQ BE0002 2025-12-02T14:22:30.342Z 2025-12-06T14:41:03.743Z
8664775 8664775 20251201013645_5wXjm BE0002 2025-12-02T14:22:03.697Z 2025-12-06T14:40:57.385Z
8664494 8664494 20251201004225_LNcCa BE0002 2025-12-02T14:21:13.157Z 2025-12-06T14:40:48.710Z
8664385 8664385 20251201001334_ub8ir BE0002 2025-12-02T14:20:58.275Z 2025-12-06T14:40:45.699Z
8664198 8664198 20251130233846_SuHmJ BE0002 2025-12-02T14:20:18.832Z 2025-12-06T14:40:41.333Z
8664102 8664102 20251130231749_3txh2 BE0002 2025-12-02T14:20:05.409Z 2025-12-06T14:40:33.860Z
8664025 8664025 20251130230429_1p93E BE0002 2025-12-02T14:19:57.582Z 2025-12-06T14:40:20.107Z
8663912 8663912 20251130223235_HfPsl BE0002 2025-12-02T14:19:34.900Z 2025-12-06T14:40:16.244Z
8663631 8663631 20251130211255_xcyKx BE0002 2025-12-02T14:18:38.140Z 2025-12-06T14:40:05.336Z
8652987 8652987 20251130014913_YEjmH BE0002 2025-12-01T14:22:36.842Z 2025-12-06T14:47:47.317Z
8646471 8646471 20251129020945_2vLE2 BE0002 2025-11-30T14:26:02.894Z 2025-12-06T14:56:09.338Z
8646038 8646038 20251129005419_Ctrem BE0002 2025-11-30T14:25:05.967Z 2025-12-06T14:55:27.615Z
8645247 8645247 20251128210023_SVsNh BE0002 2025-11-30T14:23:28.685Z 2025-12-06T14:54:51.919Z
8645013 8645013 20251128202536_ehB98 BE0002 2025-11-30T14:22:57.350Z 2025-12-06T14:54:49.917Z
8623469 8623469 20251127004646_XfI1k BE0002 2025-11-28T14:21:48.038Z 2025-12-05T15:03:54.980Z
8623461 8623461 20251127004616_26dum BE0002 2025-11-28T14:21:47.297Z 2025-12-05T15:03:54.779Z
8623366 8623366 20251127001419_eQ24A BE0002 2025-11-28T14:21:35.767Z 2025-12-05T15:03:45.133Z
8623286 8623286 20251126234606_kwRzK BE0002 2025-11-28T14:21:27.498Z 2025-12-05T15:03:41.769Z
8622916 8622916 20251126220523_FQ66f BE0002 2025-11-28T14:20:18.391Z 2025-12-05T15:03:19.917Z
8608025 8608025 20251125214526_EDppO BE0002 2025-11-27T14:15:07.697Z 2025-12-04T15:07:40.412Z
8605762 8605762 20251125165231_Bynuo BE0002 2025-11-27T14:07:49.420Z 2025-12-04T15:05:41.164Z
8604456 8604456 20251124034659_B7pUa BE0002 2025-11-26T14:36:23.438Z 2025-12-02T15:12:57.126Z
8601763 8601763 20251125041334_ezSGq BE0002 2025-11-26T14:24:41.158Z 2025-12-02T15:09:24.141Z
8591106 8591106 20251124034659_HkgD2 BE0002 2025-11-25T14:23:37.217Z 2025-12-02T15:12:57.108Z
8591083 8591083 20251124034550_NnXeP BE0002 2025-11-25T14:23:35.471Z 2025-12-02T15:12:57.043Z
8591068 8591068 20251124034122_zH8Zk BE0002 2025-11-25T14:23:33.359Z 2025-12-02T15:12:56.870Z
8590421 8590421 20251124024004_VasYv BE0002 2025-11-25T14:21:54.979Z 2025-12-02T15:12:47.574Z
8590056 8590056 20251124021813_mUgmy BE0002 2025-11-25T14:21:19.526Z 2025-12-02T15:12:41.642Z
8589830 8589830 20251124015832_1msJj BE0002 2025-11-25T14:20:47.419Z 2025-12-02T15:12:37.092Z
8589116 8589116 20251124010343_V4kVN BE0002 2025-11-25T14:19:05.969Z 2025-12-02T15:12:09.072Z
8586756 8586756 20251123204810_9pbMW BE0002 2025-11-25T14:13:47.725Z 2025-12-02T15:11:02.588Z
8581286 8581286 20251122225454_n9u6b BE0002 2025-11-24T14:31:23.946Z 2025-12-01T15:20:11.468Z
8573896 8573896 20251122043346_2LGHR BE0002 2025-11-23T14:42:05.726Z 2025-11-30T15:06:48.563Z
8573642 8573642 20251122034821_GDKfd BE0002 2025-11-23T14:41:41.172Z 2025-11-30T15:06:34.051Z
8573419 8573419 20251122030930_KAt6B BE0002 2025-11-23T14:41:10.805Z 2025-11-30T15:06:23.151Z
8573354 8573354 20251122030050_ceWDF BE0002 2025-11-23T14:41:07.698Z 2025-11-30T15:06:16.974Z
8572927 8572927 20251122020419_7toVl BE0002 2025-11-23T14:40:08.593Z 2025-11-30T15:06:06.854Z
8572867 8572867 20251122015308_f6CMp BE0002 2025-11-23T14:39:51.764Z 2025-11-30T15:06:05.020Z
8572630 8572630 20251122012117_4QD6f BE0002 2025-11-23T14:39:35.679Z 2025-11-30T15:05:54.233Z
8572338 8572338 20251122002744_B1hQp BE0002 2025-11-23T14:38:52.221Z 2025-11-30T15:05:44.934Z
8572024 8572024 20251121231929_XS33S BE0002 2025-11-23T14:37:55.628Z 2025-11-30T15:05:32.054Z
8571770 8571770 20251121220621_CbhFT BE0002 2025-11-23T14:37:43.488Z 2025-11-30T15:05:18.851Z
8571746 8571746 20251121220334_2WQJW BE0002 2025-11-23T14:37:42.513Z 2025-11-30T15:05:18.075Z
8571510 8571510 20251121210338_e15WO BE0002 2025-11-23T14:36:46.052Z 2025-11-30T15:05:07.842Z
8571298 8571298 20251121201139_U4Tv7 BE0002 2025-11-23T14:36:09.591Z 2025-11-30T15:04:53.560Z
8571185 8571185 20251121193554_LQaAw BE0002 2025-11-23T14:36:02.376Z 2025-11-30T15:04:37.128Z
8570795 8570795 20251121170258_YAz3H BE0002 2025-11-23T14:34:38.052Z 2025-11-30T15:03:43.061Z
8515708 8515708 20251118045709_QWzA3 BE0002 2025-11-19T14:39:54.771Z 2025-11-26T15:08:03.580Z
8514512 8514512 20251118022828_JhkZ6 BE0002 2025-11-19T14:38:17.451Z 2025-11-26T15:07:54.818Z
8513660 8513660 20251118005230_ISHGh BE0002 2025-11-19T14:36:25.255Z 2025-11-26T15:07:50.399Z
8513540 8513540 20251118004152_W2oet BE0002 2025-11-19T14:36:21.630Z 2025-11-26T15:07:49.807Z
8513512 8513512 20251118003805_ByGY6 BE0002 2025-11-19T14:36:20.748Z 2025-11-26T15:07:49.633Z
8513126 8513126 20251117235328_1oN89 BE0002 2025-11-19T14:35:45.367Z 2025-11-26T15:07:47.697Z
8513123 8513123 20251117235256_WfNzj BE0002 2025-11-19T14:35:45.182Z 2025-11-26T15:07:47.686Z
8512890 8512890 20251117232543_3FufN BE0002 2025-11-19T14:35:06.891Z 2025-11-26T15:07:46.708Z
8512823 8512823 20251117231631_9hTev BE0002 2025-11-19T14:34:58.144Z 2025-11-26T15:07:46.310Z
8512271 8512271 20251117215306_eN2PB BE0002 2025-11-19T14:34:35.550Z 2025-11-26T15:07:42.743Z
8512186 8512186 20251117213729_NIIAm BE0002 2025-11-19T14:34:32.819Z 2025-11-26T15:07:42.107Z
8511885 8511885 20251117204308_6EO9a BE0002 2025-11-19T14:34:23.118Z 2025-11-26T15:07:39.693Z
8511635 8511635 20251117194901_4Gq64 BE0002 2025-11-19T14:33:39.414Z 2025-11-26T15:07:37.056Z
8511160 8511160 20251117181957_zvPuV BE0002 2025-11-19T14:32:36.080Z 2025-11-26T15:07:06.211Z
8493612 8493612 20251117015409_hoWXm BE0002 2025-11-18T14:22:33.053Z 2025-11-25T15:09:20.336Z
8492794 8492794 20251117005302_AmJMb BE0002 2025-11-18T14:20:33.756Z 2025-11-25T15:08:56.775Z
8492687 8492687 20251117004655_06NW8 BE0002 2025-11-18T14:20:23.732Z 2025-11-25T15:08:55.960Z
8491784 8491784 20251116231118_yzWlV BE0002 2025-11-18T14:18:19.754Z 2025-11-25T15:08:42.037Z
8491747 8491747 20251116230744_UaBjY BE0002 2025-11-18T14:18:16.322Z 2025-11-25T15:08:41.811Z
8491717 8491717 20251116230336_VBCC2 BE0002 2025-11-18T14:18:14.715Z 2025-11-25T15:08:41.766Z
8491622 8491622 20251116225221_aCfm4 BE0002 2025-11-18T14:17:52.839Z 2025-11-25T15:08:40.398Z
8491232 8491232 20251116220052_NCBqR BE0002 2025-11-18T14:16:54.101Z 2025-11-25T15:08:34.993Z
8456427 8456427 20251113184159_Ca12r BE0002 2025-11-15T14:11:17.309Z 2025-11-22T15:20:44.165Z
8450765 8450765 20251113052037_8ixAo BE0002 2025-11-14T14:24:10.975Z 2025-11-21T15:12:50.892Z
8450739 8450739 20251113051400_2RFh9 BE0002 2025-11-14T14:24:08.796Z 2025-11-21T15:12:50.631Z
8450686 8450686 20251113050647_XLBzh BE0002 2025-11-14T14:24:04.507Z 2025-11-21T15:12:47.773Z
8450419 8450419 20251113042758_3Yh3R BE0002 2025-11-14T14:23:23.564Z 2025-11-21T15:12:38.253Z
8449713 8449713 20251113024927_l12eD BE0002 2025-11-14T14:21:16.260Z 2025-11-21T15:12:13.043Z
8449516 8449516 20251113021647_z1qXT BE0002 2025-11-14T14:20:35.181Z 2025-11-21T15:12:05.718Z
8449437 8449437 20251113020913_oOPeM BE0002 2025-11-14T14:20:25.512Z 2025-11-21T15:12:03.320Z
8448754 8448754 20251113001212_iuUco BE0002 2025-11-14T14:18:17.601Z 2025-11-21T15:11:37.905Z
8427652 8427652 20251111045902_Lx2i0 BE0002 2025-11-12T14:28:53.251Z 2025-11-19T15:17:58.742Z
8427507 8427507 20251111044839_ircOd BE0002 2025-11-12T14:28:20.085Z 2025-11-19T15:17:54.655Z
8427117 8427117 20251111040832_xqhnN BE0002 2025-11-12T14:27:15.561Z 2025-11-19T15:17:43.939Z
8425626 8425626 20251111020115_580ik BE0002 2025-11-12T14:23:14.748Z 2025-11-19T15:16:44.695Z
8425522 8425522 20251111015357_3cpwR BE0002 2025-11-12T14:22:58.595Z 2025-11-19T15:16:43.300Z
8424883 8424883 20251111005638_1d92o BE0002 2025-11-12T14:21:25.099Z 2025-11-19T15:16:27.992Z
8413480 8413480 20251109233723_cu1Qz BE0002 2025-11-11T14:17:34.363Z 2025-11-18T15:20:21.809Z
8413019 8413019 20251109215105_Z3yio BE0002 2025-11-11T14:16:01.230Z 2025-11-18T15:20:17.703Z
8411748 8411748 20251109191746_2jAzt BE0002 2025-11-11T14:11:57.838Z 2025-11-18T15:19:53.706Z
8411152 8411152 20251109181504_3korn BE0002 2025-11-11T14:09:55.861Z 2025-11-18T15:19:28.597Z
8410661 8410661 20251109172048_fX435 BE0002 2025-11-11T14:08:16.795Z 2025-11-18T15:19:05.622Z
8410629 8410629 20251109171531_4c07R BE0002 2025-11-11T14:08:08.404Z 2025-11-18T15:19:03.160Z
8398732 8398732 20251108053819_wm2FW BE0002 2025-11-09T14:16:20.237Z 2025-11-16T15:05:05.426Z
8392023 8392023 20251107042133_MdtyA BE0002 2025-11-08T14:16:55.433Z 2025-11-15T15:00:41.340Z
8391765 8391765 20251107034705_c9pSh BE0002 2025-11-08T14:15:57.225Z 2025-11-15T15:00:37.296Z
8391440 8391440 20251107025137_JtK1K BE0002 2025-11-08T14:14:47.648Z 2025-11-15T15:00:29.153Z
8390000 8390000 20251106231526_85rvp BE0002 2025-11-08T14:09:17.932Z 2025-11-15T14:59:51.611Z
8389736 8389736 20251106221329_6wZL2 BE0002 2025-11-08T14:08:13.103Z 2025-11-15T14:59:47.217Z
8389516 8389516 20251106211618_u2aAi BE0002 2025-11-08T14:07:16.779Z 2025-11-15T14:59:40.584Z
8386539 8386539 20251106050658_QsvyN BE0002 2025-11-07T14:11:31.126Z 2025-11-14T15:08:43.681Z

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