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

8,134 rows where station_code = "BE000E" 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
9595215 9595215 20260330030544_pYjJv BE000E 2026-03-31T12:00:49.331Z 2026-04-06T12:29:48.674Z
9595192 9595192 20260330030115_TiItx BE000E 2026-03-31T12:00:45.589Z 2026-04-06T12:29:47.596Z
9595167 9595167 20260330024555_WNa0B BE000E 2026-03-31T12:00:40.983Z 2026-04-06T12:29:44.157Z
9595102 9595102 20260330022311_NPZW6 BE000E 2026-03-31T12:00:29.181Z 2026-04-06T12:29:40.638Z
9595067 9595067 20260330021320_3kXh3 BE000E 2026-03-31T12:00:23.074Z 2026-04-06T12:29:39.003Z
9594745 9594745 20260329001938_505NZ BE000E 2026-03-30T12:10:15.492Z 2026-04-06T12:40:14.650Z
9593034 9593034 20260329042651_49u8v BE000E 2026-03-30T12:02:42.157Z 2026-04-06T12:34:46.783Z
9593028 9593028 20260329042207_2ql2p BE000E 2026-03-30T12:02:40.884Z 2026-04-06T12:34:46.263Z
9592758 9592758 20260329031908_fSKk3 BE000E 2026-03-30T12:01:52.282Z 2026-04-06T12:34:27.140Z
9592743 9592743 20260329031221_kHbs6 BE000E 2026-03-30T12:01:49.024Z 2026-04-06T12:34:25.909Z
9592705 9592705 20260329030441_RZYlk BE000E 2026-03-30T12:01:40.264Z 2026-04-06T12:34:22.057Z
9588514 9588514 20260326233230_oJaAl BE000E 2026-03-28T12:11:18.239Z 2026-04-04T12:42:17.316Z
9588480 9588480 20260326231747_empAZ BE000E 2026-03-28T12:11:14.832Z 2026-04-04T12:42:10.280Z
9588461 9588461 20260326231114_ud3Tk BE000E 2026-03-28T12:11:12.629Z 2026-04-04T12:42:09.395Z
9588267 9588267 20260326201724_1uUkj BE000E 2026-03-28T12:10:44.223Z 2026-04-04T12:41:53.469Z
9585609 9585609 20260327015516_Fbk7w BE000E 2026-03-28T12:00:47.040Z 2026-04-05T12:32:30.139Z
9585511 9585511 20260327012438_lPNxl BE000E 2026-03-28T12:00:32.948Z 2026-04-05T12:32:24.776Z
9585473 9585473 20260327011158_HPvuO BE000E 2026-03-28T12:00:28.296Z 2026-04-05T12:32:23.258Z
9585442 9585442 20260327010003_CWP3d BE000E 2026-03-28T12:00:21.304Z 2026-04-05T12:32:21.385Z
9585386 9585386 20260327004412_IB9Up BE000E 2026-03-28T12:00:10.758Z 2026-04-05T12:32:18.911Z
9581079 9581079 20260326022107_uBcJx BE000E 2026-03-27T12:02:05.336Z 2026-04-04T12:38:41.933Z
9581053 9581053 20260326021552_IDBhp BE000E 2026-03-27T12:01:59.034Z 2026-04-04T12:38:40.725Z
9577177 9577177 20260325040752_wYx01 BE000E 2026-03-26T12:04:19.387Z 2026-04-03T12:36:37.350Z
9577125 9577125 20260325040014_BcmuM BE000E 2026-03-26T12:04:13.297Z 2026-04-03T12:36:35.672Z
9576920 9576920 20260325032538_Jr93c BE000E 2026-03-26T12:03:40.857Z 2026-04-03T12:36:25.780Z
9576444 9576444 20260325020820_SC0hM BE000E 2026-03-26T12:02:16.286Z 2026-04-03T12:35:59.134Z
9575682 9575682 20260322212141_dnTaz BE000E 2026-03-25T12:26:56.590Z 2026-03-30T12:30:42.979Z
9575655 9575655 20260322014534_8phJt BE000E 2026-03-25T12:22:30.947Z 2026-03-30T12:27:42.179Z
9571096 9571096 20260322234503_KNmgJ BE000E 2026-03-24T12:24:20.262Z 2026-03-30T12:30:55.149Z
9570940 9570940 20260322231907_2dOqU BE000E 2026-03-24T12:24:03.093Z 2026-03-30T12:30:52.350Z
9570830 9570830 20260322225746_oM2f7 BE000E 2026-03-24T12:23:52.645Z 2026-03-30T12:30:50.026Z
9570582 9570582 20260322220856_sPygG BE000E 2026-03-24T12:23:29.990Z 2026-03-30T12:30:45.978Z
9570500 9570500 20260322214059_BhieV BE000E 2026-03-24T12:23:22.138Z 2026-03-30T12:30:44.339Z
9570436 9570436 20260322212141_IzCbf BE000E 2026-03-24T12:23:17.039Z 2026-03-30T12:30:43.080Z
9570224 9570224 20260322200616_Obf35 BE000E 2026-03-24T12:22:49.966Z 2026-03-30T12:30:37.460Z
9562983 9562983 20260323042208_5MrOy BE000E 2026-03-24T12:04:38.936Z 2026-03-31T12:26:31.523Z
9561490 9561490 20260320222318_X13Wb BE000E 2026-03-23T12:15:26.138Z 2026-03-28T12:37:04.822Z
9561384 9561384 20260321232801_xqBSm BE000E 2026-03-23T12:12:17.920Z 2026-03-29T12:21:06.877Z
9561030 9561030 20260321224812_SIJLW BE000E 2026-03-23T12:12:09.997Z 2026-03-29T12:21:04.725Z
9560982 9560982 20260321224232_zIjez BE000E 2026-03-23T12:12:08.770Z 2026-03-29T12:21:04.389Z
9560934 9560934 20260321223657_3kInR BE000E 2026-03-23T12:12:07.937Z 2026-03-29T12:21:04.048Z
9560661 9560661 20260321215801_Z3di4 BE000E 2026-03-23T12:12:00.705Z 2026-03-29T12:21:02.061Z
9560634 9560634 20260321215302_AO5mQ BE000E 2026-03-23T12:11:59.881Z 2026-03-29T12:21:01.853Z
9559737 9559737 20260321193656_bB0gT BE000E 2026-03-23T12:11:28.587Z 2026-03-29T12:20:48.523Z
9555237 9555237 20260322043038_yjAjg BE000E 2026-03-23T12:03:17.169Z 2026-03-30T12:28:23.525Z
9554871 9554871 20260322033957_UjP5j BE000E 2026-03-23T12:02:53.942Z 2026-03-30T12:28:10.652Z
9554065 9554065 20260322023627_ewRGw BE000E 2026-03-23T12:02:12.099Z 2026-03-30T12:27:57.819Z
9554023 9554023 20260322023324_eG17F BE000E 2026-03-23T12:02:09.442Z 2026-03-30T12:27:57.051Z
9553791 9553791 20260322021507_iMi6m BE000E 2026-03-23T12:01:52.347Z 2026-03-30T12:27:52.713Z
9553767 9553767 20260322021239_VUNFK BE000E 2026-03-23T12:01:51.056Z 2026-03-30T12:27:52.321Z
9553724 9553724 20260322020926_t36Ez BE000E 2026-03-23T12:01:48.084Z 2026-03-30T12:27:51.603Z
9552967 9552967 20260322010048_ujQ0r BE000E 2026-03-23T12:01:05.350Z 2026-03-30T12:27:33.230Z
9552438 9552438 20260322000716_7KeQR BE000E 2026-03-23T12:00:24.547Z 2026-03-30T12:27:24.042Z
9552268 9552268 20260321234536_yGf5j BE000E 2026-03-23T12:00:09.496Z 2026-03-30T12:27:21.448Z
9552165 9552165 20260320230938_lrMQr BE000E 2026-03-22T12:27:30.704Z 2026-03-28T12:37:07.569Z
9552007 9552007 20260320223429_YxKgd BE000E 2026-03-22T12:27:22.386Z 2026-03-28T12:37:05.551Z
9543352 9543352 20260321033612_qpUDD BE000E 2026-03-22T12:03:32.451Z 2026-03-29T12:19:06.488Z
9543310 9543310 20260321032943_l9Fo3 BE000E 2026-03-22T12:03:24.995Z 2026-03-29T12:19:06.026Z
9543168 9543168 20260321025447_BemmT BE000E 2026-03-22T12:02:54.534Z 2026-03-29T12:19:03.899Z
9543086 9543086 20260321023503_tsI35 BE000E 2026-03-22T12:02:38.221Z 2026-03-29T12:19:02.752Z
9543010 9543010 20260321021611_tqD2w BE000E 2026-03-22T12:02:21.024Z 2026-03-29T12:19:01.270Z
9542921 9542921 20260321015141_ya1LM BE000E 2026-03-22T12:02:04.760Z 2026-03-29T12:19:00.256Z
9542608 9542608 20260321002429_wHYaj BE000E 2026-03-22T12:00:57.279Z 2026-03-29T12:18:46.429Z
9541850 9541850 20260319215857_PfMsP BE000E 2026-03-21T12:29:26.356Z 2026-03-27T12:42:42.447Z
9541848 9541848 20260319215856_kVqmN BE000E 2026-03-21T12:29:26.198Z 2026-03-27T12:42:42.388Z
9533865 9533865 20260320030653_ySzvf BE000E 2026-03-21T12:06:31.060Z 2026-03-28T12:34:01.736Z
9533585 9533585 20260320024531_1dVx7 BE000E 2026-03-21T12:05:50.117Z 2026-03-28T12:33:56.802Z
9532663 9532663 20260320011740_7DeQM BE000E 2026-03-21T12:03:22.123Z 2026-03-28T12:33:35.074Z
9532477 9532477 20260320010212_C9pP4 BE000E 2026-03-21T12:02:52.279Z 2026-03-28T12:33:32.330Z
9532200 9532200 20260320003718_2RzNT BE000E 2026-03-21T12:02:02.879Z 2026-03-28T12:33:25.792Z
9532118 9532118 20260320002035_htqt3 BE000E 2026-03-21T12:01:45.783Z 2026-03-28T12:33:24.748Z
9531931 9531931 20260320000324_dxQ0T BE000E 2026-03-21T12:01:13.876Z 2026-03-28T12:33:22.906Z
9531695 9531695 20260319233633_0OhXo BE000E 2026-03-21T12:00:29.906Z 2026-03-28T12:33:20.260Z
9531147 9531147 20260318223702_2ZhsI BE000E 2026-03-20T12:24:59.466Z 2026-03-26T12:39:17.763Z
9531090 9531090 20260318222529_5T8K8 BE000E 2026-03-20T12:24:57.228Z 2026-03-26T12:39:17.393Z
9530298 9530298 20260318203621_rGcgJ BE000E 2026-03-20T12:24:17.085Z 2026-03-26T12:39:11.049Z
9530170 9530170 20260318202000_xT7c9 BE000E 2026-03-20T12:24:04.872Z 2026-03-26T12:39:10.061Z
9529939 9529939 20260318194353_Ussq1 BE000E 2026-03-20T12:23:50.560Z 2026-03-26T12:39:07.657Z
9529829 9529829 20260318193606_U8z8O BE000E 2026-03-20T12:23:45.091Z 2026-03-26T12:39:06.853Z
9529790 9529790 20260318193048_dwWkk BE000E 2026-03-20T12:23:39.052Z 2026-03-26T12:39:06.564Z
9521836 9521836 20260319044807_3RkyE BE000E 2026-03-20T12:08:38.522Z 2026-03-27T12:41:11.042Z
9521717 9521717 20260319043613_0FKxV BE000E 2026-03-20T12:08:26.397Z 2026-03-27T12:41:04.962Z
9521620 9521620 20260319043023_Wjglx BE000E 2026-03-20T12:08:17.966Z 2026-03-27T12:40:56.299Z
9521493 9521493 20260319042114_TZwOX BE000E 2026-03-20T12:08:07.995Z 2026-03-27T12:40:55.231Z
9521382 9521382 20260319041014_P23bD BE000E 2026-03-20T12:07:55.080Z 2026-03-27T12:40:54.305Z
9520765 9520765 20260319033518_m5z7a BE000E 2026-03-20T12:06:56.342Z 2026-03-27T12:40:47.186Z
9520701 9520701 20260319033300_U3xCz BE000E 2026-03-20T12:06:49.538Z 2026-03-27T12:40:46.405Z
9520640 9520640 20260319032923_oARJK BE000E 2026-03-20T12:06:43.983Z 2026-03-27T12:40:45.821Z
9520387 9520387 20260319031247_AJo9d BE000E 2026-03-20T12:06:18.541Z 2026-03-27T12:40:42.520Z
9520375 9520375 20260319031222_1Zgs1 BE000E 2026-03-20T12:06:17.553Z 2026-03-27T12:40:42.406Z
9519699 9519699 20260319023021_28usz BE000E 2026-03-20T12:04:56.951Z 2026-03-27T12:40:34.558Z
9519631 9519631 20260319022359_3IcOx BE000E 2026-03-20T12:04:48.157Z 2026-03-27T12:40:33.574Z
9519359 9519359 20260319020444_wnS0x BE000E 2026-03-20T12:04:21.630Z 2026-03-27T12:40:25.751Z
9519186 9519186 20260319015359_R74DB BE000E 2026-03-20T12:04:04.494Z 2026-03-27T12:40:18.935Z
9519144 9519144 20260319015325_I7tVN BE000E 2026-03-20T12:04:01.185Z 2026-03-27T12:40:18.662Z
9519094 9519094 20260319014745_K5L8L BE000E 2026-03-20T12:03:54.862Z 2026-03-27T12:40:18.123Z
9518343 9518343 20260319005210_3EdmR BE000E 2026-03-20T12:02:20.501Z 2026-03-27T12:40:08.586Z
9518038 9518038 20260319002312_Uoc02 BE000E 2026-03-20T12:01:48.026Z 2026-03-27T12:40:05.820Z
9517940 9517940 20260319001517_bZZgM BE000E 2026-03-20T12:01:35.587Z 2026-03-27T12:40:04.865Z
9517727 9517727 20260318235820_LkUx2 BE000E 2026-03-20T12:01:07.533Z 2026-03-27T12:40:02.732Z

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