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

274 rows where station_code = "BE001B" 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
9262673 9262673 20260126005009_Zyk4d BE001B 2026-01-27T14:14:41.850Z 2026-01-29T14:38:33.558Z
9262582 9262582 20260125202707_Q7DDP BE001B 2026-01-27T14:13:46.400Z 2026-01-29T14:38:21.217Z
9260772 9260772 20260122030612_07r39 BE001B 2026-01-26T14:38:21.779Z 2026-01-29T14:58:08.697Z
9260764 9260764 20260122012943_d3Z2a BE001B 2026-01-26T14:37:50.973Z 2026-01-29T14:57:38.665Z
9260762 9260762 20260122001849_18ovs BE001B 2026-01-26T14:37:36.454Z 2026-01-29T14:57:24.035Z
9260760 9260760 20260122001619_a1hUt BE001B 2026-01-26T14:37:36.068Z 2026-01-29T14:57:23.943Z
9260756 9260756 20260121230340_ixIdf BE001B 2026-01-26T14:37:23.786Z 2026-01-29T14:57:14.675Z
9260752 9260752 20260121220237_fwvod BE001B 2026-01-26T14:37:09.063Z 2026-01-29T14:57:06.935Z
9260612 9260612 20260125055329_8Apy7 BE001B 2026-01-26T14:22:35.168Z 2026-01-29T14:44:30.970Z
9260610 9260610 20260125055321_K2gId BE001B 2026-01-26T14:22:34.784Z 2026-01-29T14:44:30.829Z
9259513 9259513 20260124211423_9gb3C BE001B 2026-01-26T14:17:21.176Z 2026-01-29T14:42:58.030Z
9256200 9256200 20260124061735_2yBgU BE001B 2026-01-25T14:16:11.323Z 2026-01-29T14:48:28.207Z
9256183 9256183 20260124060949_oHu4Z BE001B 2026-01-25T14:16:07.659Z 2026-01-29T14:48:27.416Z
9256161 9256161 20260124060528_5h0JZ BE001B 2026-01-25T14:16:04.788Z 2026-01-29T14:48:26.670Z
9256138 9256138 20260124060301_TU43l BE001B 2026-01-25T14:16:01.367Z 2026-01-29T14:48:25.257Z
9255892 9255892 20260124051253_cbWn1 BE001B 2026-01-25T14:15:04.056Z 2026-01-29T14:48:03.923Z
9255868 9255868 20260124050940_6CZvp BE001B 2026-01-25T14:15:00.198Z 2026-01-29T14:48:02.020Z
9255774 9255774 20260124045430_x9Zib BE001B 2026-01-25T14:14:39.943Z 2026-01-29T14:47:56.763Z
9255767 9255767 20260124045210_3SeYa BE001B 2026-01-25T14:14:38.145Z 2026-01-29T14:47:56.402Z
9255745 9255745 20260124044404_qqCgZ BE001B 2026-01-25T14:14:32.345Z 2026-01-29T14:47:54.816Z
9255719 9255719 20260124043943_MQjpk BE001B 2026-01-25T14:14:28.658Z 2026-01-29T14:47:53.629Z
9255670 9255670 20260124042828_vesTg BE001B 2026-01-25T14:14:14.534Z 2026-01-29T14:47:50.185Z
9249431 9249431 20260122051612_ZJ43E BE001B 2026-01-23T14:15:25.217Z 2026-01-29T14:58:34.942Z
9249301 9249301 20260122044120_Czume BE001B 2026-01-23T14:15:08.466Z 2026-01-29T14:58:22.364Z
9249155 9249155 20260122034949_qjXiK BE001B 2026-01-23T14:14:41.055Z 2026-01-29T14:58:14.707Z
9249086 9249086 20260122033104_GkkJ5 BE001B 2026-01-23T14:14:33.467Z 2026-01-29T14:58:12.107Z
9249047 9249047 20260122032208_BaUhy BE001B 2026-01-23T14:14:30.107Z 2026-01-29T14:58:10.718Z
9249023 9249023 20260122031132_J9dSp BE001B 2026-01-23T14:14:26.618Z 2026-01-29T14:58:09.485Z
9248976 9248976 20260122030100_6tzwx BE001B 2026-01-23T14:14:14.891Z 2026-01-29T14:58:02.801Z
9248928 9248928 20260122024709_QMWTq BE001B 2026-01-23T14:14:07.226Z 2026-01-29T14:57:54.950Z
9248875 9248875 20260122023354_1sm4v BE001B 2026-01-23T14:14:02.161Z 2026-01-29T14:57:52.585Z
9248633 9248633 20260122012549_3cZ2N BE001B 2026-01-23T14:13:19.749Z 2026-01-29T14:57:37.994Z
9248580 9248580 20260122004849_38buJ BE001B 2026-01-23T14:13:11.828Z 2026-01-29T14:57:35.270Z
9248559 9248559 20260122004152_SJxuX BE001B 2026-01-23T14:13:04.650Z 2026-01-29T14:57:26.516Z
9248540 9248540 20260122003414_pncFW BE001B 2026-01-23T14:13:02.968Z 2026-01-29T14:57:25.753Z
9248412 9248412 20260121233933_n0vMw BE001B 2026-01-23T14:12:45.228Z 2026-01-29T14:57:17.930Z
9248167 9248167 20260121220147_w5W8A BE001B 2026-01-23T14:12:10.732Z 2026-01-29T14:57:06.653Z
9247361 9247361 20260121181231_CCjBT BE001B 2026-01-23T14:09:55.413Z 2026-01-29T14:56:05.830Z
9239044 9239044 20260118032845_L42IC BE001B 2026-01-21T14:44:20.879Z 2026-01-26T15:03:05.510Z
9239043 9239043 20260118032054_gGQqQ BE001B 2026-01-21T14:44:16.265Z 2026-01-26T15:02:50.462Z
9239031 9239031 20260118020548_lu4Qu BE001B 2026-01-21T14:43:45.905Z 2026-01-26T15:02:33.132Z
9237653 9237653 20260120054720_NusD5 BE001B 2026-01-21T14:27:12.192Z 2026-01-28T15:01:34.668Z
9237616 9237616 20260120054407_JqjeA BE001B 2026-01-21T14:27:08.162Z 2026-01-28T15:01:33.236Z
9237567 9237567 20260120053710_Md9UO BE001B 2026-01-21T14:27:01.528Z 2026-01-28T15:01:31.396Z
9237373 9237373 20260120050718_AQl8m BE001B 2026-01-21T14:26:20.474Z 2026-01-28T15:01:22.462Z
9237371 9237371 20260120050713_CSL8w BE001B 2026-01-21T14:26:18.706Z 2026-01-28T15:01:22.292Z
9236928 9236928 20260120042034_ywN6N BE001B 2026-01-21T14:24:31.214Z 2026-01-28T15:00:49.324Z
9236733 9236733 20260120035249_uH3qv BE001B 2026-01-21T14:23:51.299Z 2026-01-28T15:00:32.481Z
9236638 9236638 20260120034301_3Nr78 BE001B 2026-01-21T14:23:35.745Z 2026-01-28T15:00:26.776Z
9236592 9236592 20260120033711_B8blv BE001B 2026-01-21T14:23:28.538Z 2026-01-28T15:00:23.245Z
9236450 9236450 20260120031922_E2YzE BE001B 2026-01-21T14:22:51.807Z 2026-01-28T15:00:01.170Z
9236320 9236320 20260120025951_w1Pep BE001B 2026-01-21T14:22:21.385Z 2026-01-28T14:59:55.123Z
9236265 9236265 20260120025325_CLIZN BE001B 2026-01-21T14:22:12.722Z 2026-01-28T14:59:52.541Z
9236249 9236249 20260120025148_uKROq BE001B 2026-01-21T14:22:10.851Z 2026-01-28T14:59:51.937Z
9236124 9236124 20260120023827_Wgod9 BE001B 2026-01-21T14:21:33.977Z 2026-01-28T14:59:46.008Z
9235849 9235849 20260120020730_HmTzv BE001B 2026-01-21T14:20:33.731Z 2026-01-28T14:59:24.319Z
9235844 9235844 20260120020721_kRKAV BE001B 2026-01-21T14:20:33.055Z 2026-01-28T14:59:23.903Z
9235687 9235687 20260120014727_ijtFN BE001B 2026-01-21T14:19:58.243Z 2026-01-28T14:59:16.105Z
9235469 9235469 20260120011801_1PhN2 BE001B 2026-01-21T14:19:01.907Z 2026-01-28T14:58:56.873Z
9235342 9235342 20260120005829_rORa5 BE001B 2026-01-21T14:18:38.364Z 2026-01-28T14:58:50.082Z
9235046 9235046 20260120001811_3fFBd BE001B 2026-01-21T14:17:17.124Z 2026-01-28T14:58:26.596Z
9234829 9234829 20260119233351_qwlSl BE001B 2026-01-21T14:16:25.207Z 2026-01-28T14:58:15.884Z
9234807 9234807 20260119233008_gRUvK BE001B 2026-01-21T14:16:12.333Z 2026-01-28T14:58:14.351Z
9234342 9234342 20260119205312_8eGLE BE001B 2026-01-21T14:13:52.658Z 2026-01-28T14:57:30.615Z
9234307 9234307 20260119204019_nLlEa BE001B 2026-01-21T14:13:34.405Z 2026-01-28T14:57:27.930Z
9234242 9234242 20260119201857_Bt9SK BE001B 2026-01-21T14:13:13.393Z 2026-01-28T14:57:24.251Z
9234214 9234214 20260119200825_JCuh3 BE001B 2026-01-21T14:13:01.600Z 2026-01-28T14:57:21.949Z
9229613 9229613 20260119020723_kevUJ BE001B 2026-01-20T14:23:21.790Z 2026-01-27T15:03:45.056Z
9229357 9229357 20260119013604_Jm3Wx BE001B 2026-01-20T14:22:13.214Z 2026-01-27T15:03:19.752Z
9228928 9228928 20260119002111_7b2ZJ BE001B 2026-01-20T14:20:12.160Z 2026-01-27T15:02:43.525Z
9228893 9228893 20260119001539_tXnw0 BE001B 2026-01-20T14:20:03.278Z 2026-01-27T15:02:41.544Z
9228771 9228771 20260118234934_mlu0Z BE001B 2026-01-20T14:19:25.631Z 2026-01-27T15:02:34.084Z
9228275 9228275 20260118210732_Vdzdm BE001B 2026-01-20T14:16:59.748Z 2026-01-27T15:01:40.541Z
9228213 9228213 20260118204102_z0Er0 BE001B 2026-01-20T14:16:40.551Z 2026-01-27T15:01:34.266Z
9228166 9228166 20260118201315_0Atqp BE001B 2026-01-20T14:16:24.194Z 2026-01-27T15:01:30.851Z
9227922 9227922 20260118183759_CyziX BE001B 2026-01-20T14:14:54.169Z 2026-01-27T15:01:03.436Z
9224739 9224739 20260118055642_qrEx6 BE001B 2026-01-19T14:25:47.623Z 2026-01-26T15:03:47.321Z
9224731 9224731 20260118055340_JIs0w BE001B 2026-01-19T14:25:45.767Z 2026-01-26T15:03:47.034Z
9224687 9224687 20260118054250_Fg3fe BE001B 2026-01-19T14:25:36.298Z 2026-01-26T15:03:45.642Z
9224671 9224671 20260118053616_HFpNt BE001B 2026-01-19T14:25:26.315Z 2026-01-26T15:03:45.070Z
9224553 9224553 20260118051124_Y9cBp BE001B 2026-01-19T14:24:53.591Z 2026-01-26T15:03:23.461Z
9224472 9224472 20260118045345_eIRti BE001B 2026-01-19T14:24:34.274Z 2026-01-26T15:03:20.244Z
9224469 9224469 20260118045310_50oV4 BE001B 2026-01-19T14:24:33.701Z 2026-01-26T15:03:20.199Z
9224408 9224408 20260118043649_9f446 BE001B 2026-01-19T14:24:13.887Z 2026-01-26T15:03:17.587Z
9224369 9224369 20260118042754_274IH BE001B 2026-01-19T14:24:06.775Z 2026-01-26T15:03:16.070Z
9224335 9224335 20260118042147_hUY17 BE001B 2026-01-19T14:23:54.797Z 2026-01-26T15:03:14.565Z
9224324 9224324 20260118042010_HnuUv BE001B 2026-01-19T14:23:52.718Z 2026-01-26T15:03:14.135Z
9224322 9224322 20260118041858_LyLbs BE001B 2026-01-19T14:23:52.180Z 2026-01-26T15:03:14.014Z
9224240 9224240 20260118035928_Npf8m BE001B 2026-01-19T14:23:33.223Z 2026-01-26T15:03:10.194Z
9224194 9224194 20260118034859_tTz8y BE001B 2026-01-19T14:23:17.384Z 2026-01-26T15:03:08.428Z
9224084 9224084 20260118032054_J2Zsv BE001B 2026-01-19T14:22:42.763Z 2026-01-20T14:42:26.260Z
9224062 9224062 20260118031847_MDkkz BE001B 2026-01-19T14:22:35.502Z 2026-01-26T15:02:49.541Z
9224052 9224052 20260118031607_CO9nt BE001B 2026-01-19T14:22:32.640Z 2026-01-26T15:02:49.109Z
9224027 9224027 20260118031100_cKxDh BE001B 2026-01-19T14:22:27.430Z 2026-01-26T15:02:48.370Z
9223917 9223917 20260118024952_3kGMB BE001B 2026-01-19T14:21:49.992Z 2026-01-26T15:02:41.429Z
9223891 9223891 20260118024349_ub2eS BE001B 2026-01-19T14:21:43.024Z 2026-01-26T15:02:40.289Z
9223760 9223760 20260118022027_uqrp2 BE001B 2026-01-19T14:20:57.045Z 2026-01-26T15:02:35.090Z
9223571 9223571 20260118012743_jI0R0 BE001B 2026-01-19T14:20:00.166Z 2026-01-26T15:02:14.949Z
9223456 9223456 20260118004922_yUfFA BE001B 2026-01-19T14:19:25.263Z 2026-01-26T15:02:07.585Z
9223059 9223059 20260117224528_qdcpF BE001B 2026-01-19T14:17:29.225Z 2026-01-26T15:01:33.956Z

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