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

2,089 rows where station_code = "BE0012" 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
9615104 9615104 20260406003810_2xhEE BE0012 2026-04-07T12:10:03.061Z 2026-04-07T12:13:19.737Z
9615088 9615088 20260406003634_hGND0 BE0012 2026-04-07T12:10:00.844Z 2026-04-07T12:13:19.733Z
9613895 9613895 20260405213718_1x2qg BE0012 2026-04-07T12:07:31.646Z 2026-04-07T12:13:19.478Z
9606831 9606831 20260402220209_N0Bdk BE0012 2026-04-04T12:11:52.209Z 2026-04-07T12:20:18.503Z
9606816 9606816 20260402213923_rPb5J BE0012 2026-04-04T12:11:49.110Z 2026-04-07T12:20:18.100Z
9595486 9595486 20260330041942_6XpuX BE0012 2026-03-31T12:01:32.543Z 2026-04-07T12:24:05.636Z
9595104 9595104 20260330022311_NPZW6 BE0012 2026-03-31T12:00:29.181Z 2026-04-07T12:23:55.506Z
9592611 9592611 20260329024726_pm2hD BE0012 2026-03-30T12:01:26.678Z 2026-04-07T12:26:36.130Z
9589597 9589597 20260328034818_e8Hvl BE0012 2026-03-29T12:01:27.745Z 2026-04-06T12:37:28.516Z
9588515 9588515 20260326233230_oJaAl BE0012 2026-03-28T12:11:18.239Z 2026-04-04T12:42:17.316Z
9588366 9588366 20260326221036_rBjV0 BE0012 2026-03-28T12:10:56.897Z 2026-04-04T12:42:01.264Z
9588250 9588250 20260326195102_ssmJh BE0012 2026-03-28T12:10:37.180Z 2026-04-04T12:41:51.174Z
9581054 9581054 20260326021552_IDBhp BE0012 2026-03-27T12:01:59.035Z 2026-04-04T12:38:40.725Z
9579394 9579394 20260324194814_C53ev BE0012 2026-03-26T12:13:33.093Z 2026-04-02T12:37:07.737Z
9577180 9577180 20260325040810_1KMA1 BE0012 2026-03-26T12:04:19.834Z 2026-04-03T12:36:37.497Z
9577167 9577167 20260325040629_bk3OO BE0012 2026-03-26T12:04:17.659Z 2026-04-03T12:36:36.886Z
9570566 9570566 20260322220211_7Zh3P BE0012 2026-03-24T12:23:28.331Z 2026-03-30T12:30:45.592Z
9570203 9570203 20260322194836_SUDLo BE0012 2026-03-24T12:22:47.983Z 2026-03-24T12:24:28.249Z
9570138 9570138 20260322192632_sO8Cu BE0012 2026-03-24T12:22:38.268Z 2026-03-30T12:30:28.312Z
9562973 9562973 20260323041804_xvNm3 BE0012 2026-03-24T12:04:36.738Z 2026-03-31T12:26:31.179Z
9562778 9562778 20260323031314_Hm4W7 BE0012 2026-03-24T12:04:01.059Z 2026-03-31T12:26:25.702Z
9561427 9561427 20260321233147_yNAPw BE0012 2026-03-23T12:12:18.790Z 2026-03-29T12:21:07.141Z
9561166 9561166 20260321230424_S3ZIX BE0012 2026-03-23T12:12:12.726Z 2026-03-29T12:21:05.430Z
9561093 9561093 20260321225537_HoiTO BE0012 2026-03-23T12:12:11.513Z 2026-03-29T12:21:05.147Z
9560636 9560636 20260321215302_AO5mQ BE0012 2026-03-23T12:11:59.881Z 2026-03-29T12:21:01.853Z
9560066 9560066 20260321202919_hc20P BE0012 2026-03-23T12:11:37.160Z 2026-03-29T12:20:57.713Z
9554487 9554487 20260322031324_p5Pi4 BE0012 2026-03-23T12:02:36.742Z 2026-03-30T12:28:04.654Z
9553651 9553651 20260322020432_NjxxC BE0012 2026-03-23T12:01:44.733Z 2026-03-30T12:27:50.628Z
9552995 9552995 20260322010154_kP6qq BE0012 2026-03-23T12:01:08.047Z 2026-03-30T12:27:33.498Z
9552270 9552270 20260321234536_yGf5j BE0012 2026-03-23T12:00:09.551Z 2026-03-30T12:27:21.448Z
9552039 9552039 20260320224050_Kel31 BE0012 2026-03-22T12:27:23.763Z 2026-03-28T12:37:05.755Z
9551815 9551815 20260320214825_qecwV BE0012 2026-03-22T12:27:04.487Z 2026-03-28T12:37:02.492Z
9551483 9551483 20260320195534_QVWN7 BE0012 2026-03-22T12:26:43.000Z 2026-03-28T12:36:56.049Z
9543498 9543498 20260321040444_itbGi BE0012 2026-03-22T12:03:59.586Z 2026-03-29T12:19:08.305Z
9543078 9543078 20260321023033_3lX3Q BE0012 2026-03-22T12:02:36.061Z 2026-03-29T12:19:02.594Z
9543054 9543054 20260321022453_oO8CK BE0012 2026-03-22T12:02:31.882Z 2026-03-29T12:19:02.162Z
9542499 9542499 20260320235354_NRGMy BE0012 2026-03-22T12:00:28.592Z 2026-03-29T12:18:44.728Z
9542249 9542249 20260319230513_KYSvI BE0012 2026-03-21T12:29:53.933Z 2026-03-27T12:42:51.428Z
9533590 9533590 20260320024531_uRXZb BE0012 2026-03-21T12:05:50.632Z 2026-03-28T12:33:56.827Z
9533557 9533557 20260320024302_t0F82 BE0012 2026-03-21T12:05:44.060Z 2026-03-28T12:33:56.015Z
9533237 9533237 20260320021744_vR82B BE0012 2026-03-21T12:04:53.286Z 2026-03-28T12:33:50.841Z
9531429 9531429 20260318230942_DCFy3 BE0012 2026-03-20T12:25:10.371Z 2026-03-26T12:39:19.353Z
9531347 9531347 20260318225946_Zdi5H BE0012 2026-03-20T12:25:07.528Z 2026-03-26T12:39:18.973Z
9531278 9531278 20260318225208_w6TaD BE0012 2026-03-20T12:25:03.981Z 2026-03-26T12:39:18.492Z
9531150 9531150 20260318223702_2ZhsI BE0012 2026-03-20T12:24:59.466Z 2026-03-26T12:39:17.763Z
9531092 9531092 20260318222529_5T8K8 BE0012 2026-03-20T12:24:57.228Z 2026-03-26T12:39:17.394Z
9530718 9530718 20260318213114_sJHa3 BE0012 2026-03-20T12:24:37.029Z 2026-03-26T12:39:15.004Z
9529686 9529686 20260318191242_FrCrw BE0012 2026-03-20T12:23:33.197Z 2026-03-26T12:39:05.522Z
9521618 9521618 20260319042936_ZUnvd BE0012 2026-03-20T12:08:17.486Z 2026-03-27T12:40:56.218Z
9520433 9520433 20260319031614_A3L8v BE0012 2026-03-20T12:06:22.733Z 2026-03-27T12:40:43.145Z
9520091 9520091 20260319025224_j9QVH BE0012 2026-03-20T12:05:40.734Z 2026-03-27T12:40:38.742Z
9519361 9519361 20260319020444_wnS0x BE0012 2026-03-20T12:04:21.630Z 2026-03-27T12:40:25.751Z
9519266 9519266 20260319015737_A3ES1 BE0012 2026-03-20T12:04:13.213Z 2026-03-27T12:40:19.707Z
9518566 9518566 20260319011023_a9u8d BE0012 2026-03-20T12:02:50.892Z 2026-03-27T12:40:11.409Z
9518337 9518337 20260319005107_2iRpd BE0012 2026-03-20T12:02:19.468Z 2026-03-27T12:40:08.529Z
9517921 9517921 20260319001158_MPkEO BE0012 2026-03-20T12:01:31.759Z 2026-03-27T12:40:04.662Z
9517175 9517175 20260317224942_HQPfM BE0012 2026-03-19T12:27:16.578Z 2026-03-25T12:43:09.093Z
9516776 9516776 20260317215522_caodh BE0012 2026-03-19T12:26:46.473Z 2026-03-25T12:43:06.873Z
9516516 9516516 20260317210453_0Q2Uf BE0012 2026-03-19T12:26:19.422Z 2026-03-25T12:43:00.407Z
9516205 9516205 20260317201245_a1inn BE0012 2026-03-19T12:25:46.511Z 2026-03-25T12:42:51.474Z
9516124 9516124 20260317200550_4Zi5O BE0012 2026-03-19T12:25:42.289Z 2026-03-25T12:42:49.130Z
9515865 9515865 20260317190709_J0o2F BE0012 2026-03-19T12:25:09.560Z 2026-03-25T12:42:40.391Z
9511845 9511845 20260318042330_sZkcf BE0012 2026-03-19T12:11:09.985Z 2026-03-26T12:37:40.130Z
9511542 9511542 20260318040048_o3TRo BE0012 2026-03-19T12:10:25.576Z 2026-03-26T12:37:37.752Z
9511498 9511498 20260318035655_68VZG BE0012 2026-03-19T12:10:20.952Z 2026-03-26T12:37:37.456Z
9511131 9511131 20260318033709_HMFpI BE0012 2026-03-19T12:09:31.954Z 2026-03-26T12:37:23.902Z
9509728 9509728 20260318021026_vz4sc BE0012 2026-03-19T12:06:02.377Z 2026-03-26T12:37:07.366Z
9509166 9509166 20260318012853_P3lih BE0012 2026-03-19T12:04:40.463Z 2026-03-26T12:37:03.596Z
9509131 9509131 20260318012747_2i2Zi BE0012 2026-03-19T12:04:36.958Z 2026-03-26T12:37:03.398Z
9508357 9508357 20260318004733_EUwmb BE0012 2026-03-19T12:02:55.802Z 2026-03-26T12:36:57.991Z
9508350 9508350 20260318004733_oDRP1 BE0012 2026-03-19T12:02:55.510Z 2026-03-26T12:36:57.966Z
9508281 9508281 20260318003940_jggHz BE0012 2026-03-19T12:02:48.314Z 2026-03-26T12:36:57.557Z
9508238 9508238 20260318003608_PPrmm BE0012 2026-03-19T12:02:42.161Z 2026-03-26T12:36:57.191Z
9508157 9508157 20260318002619_EURjr BE0012 2026-03-19T12:02:26.259Z 2026-03-26T12:36:56.357Z
9508098 9508098 20260318001357_WFVr8 BE0012 2026-03-19T12:02:11.926Z 2026-03-26T12:36:55.738Z
9507855 9507855 20260317234919_WKGkK BE0012 2026-03-19T12:01:29.278Z 2026-03-26T12:36:54.009Z
9507812 9507812 20260317234521_BDOGi BE0012 2026-03-19T12:01:21.305Z 2026-03-26T12:36:53.655Z
9507809 9507809 20260317234423_8Y5aA BE0012 2026-03-19T12:01:20.463Z 2026-03-26T12:36:53.620Z
9507641 9507641 20260317232836_vHk2c BE0012 2026-03-19T12:00:50.618Z 2026-03-26T12:36:48.573Z
9494913 9494913 20260316032754_6d6iP BE0012 2026-03-17T12:05:27.248Z 2026-03-24T12:40:51.140Z
9492957 9492957 20260314222115_OLIZ7 BE0012 2026-03-16T12:29:13.565Z 2026-03-22T12:42:55.970Z
9492732 9492732 20260314215038_X7oq3 BE0012 2026-03-16T12:29:00.031Z 2026-03-22T12:42:54.184Z
9492559 9492559 20260314211925_CCLeN BE0012 2026-03-16T12:28:43.901Z 2026-03-22T12:42:53.118Z
9492530 9492530 20260314211220_zrM4w BE0012 2026-03-16T12:28:40.548Z 2026-03-22T12:42:52.850Z
9492417 9492417 20260314204640_S6ag0 BE0012 2026-03-16T12:28:33.712Z 2026-03-22T12:42:52.283Z
9492401 9492401 20260314204342_8Hnf8 BE0012 2026-03-16T12:28:32.113Z 2026-03-22T12:42:52.180Z
9492366 9492366 20260314203538_29veb BE0012 2026-03-16T12:28:29.424Z 2026-03-22T12:42:51.983Z
9492243 9492243 20260314194843_l0bbG BE0012 2026-03-16T12:28:11.144Z 2026-03-22T12:42:51.083Z
9486128 9486128 20260315045838_nUbgn BE0012 2026-03-16T12:08:45.915Z 2026-03-23T12:21:55.505Z
9485954 9485954 20260315041838_YNMzh BE0012 2026-03-16T12:08:08.991Z 2026-03-23T12:21:54.652Z
9485706 9485706 20260315034244_XamsA BE0012 2026-03-16T12:07:20.352Z 2026-03-23T12:21:53.562Z
9485454 9485454 20260315030733_Zbj5N BE0012 2026-03-16T12:06:29.788Z 2026-03-23T12:21:52.309Z
9485329 9485329 20260315025223_np8ZD BE0012 2026-03-16T12:06:03.892Z 2026-03-23T12:21:51.040Z
9485275 9485275 20260315024524_MUwuG BE0012 2026-03-16T12:05:53.065Z 2026-03-23T12:21:50.724Z
9485244 9485244 20260315024155_ess27 BE0012 2026-03-16T12:05:45.794Z 2026-03-23T12:21:50.592Z
9485155 9485155 20260315023432_O9uQu BE0012 2026-03-16T12:05:27.787Z 2026-03-23T12:21:50.195Z
9485101 9485101 20260315022701_lEkj7 BE0012 2026-03-16T12:05:17.175Z 2026-03-23T12:21:49.999Z
9485040 9485040 20260315021650_32HRA BE0012 2026-03-16T12:05:02.457Z 2026-03-23T12:21:49.660Z
9485007 9485007 20260315021326_lDQSi BE0012 2026-03-16T12:04:55.685Z 2026-03-23T12:21:49.523Z
9484998 9484998 20260315021112_Gx74K BE0012 2026-03-16T12:04:52.844Z 2026-03-23T12:21:49.477Z

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