participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
835 rows where station_code = "BE000Y" sorted by created_at descending
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 |
|---|---|---|---|---|---|
| 9610540 | 9610540 | 20260404201907_RTZud | BE000Y | 2026-04-06T12:10:04.798Z | 2026-04-06T12:16:14.597Z |
| 9610512 | 9610512 | 20260404200335_ct3ZD | BE000Y | 2026-04-06T12:09:52.939Z | 2026-04-06T12:16:14.585Z |
| 9609014 | 9609014 | 20260404030558_KQKtT | BE000Y | 2026-04-05T12:12:36.997Z | 2026-04-06T12:20:57.150Z |
| 9606836 | 9606836 | 20260402220352_W6YHW | BE000Y | 2026-04-04T12:11:53.172Z | 2026-04-06T12:23:47.697Z |
| 9598542 | 9598542 | 20260330010419_1M0lZ | BE000Y | 2026-03-31T12:10:53.459Z | 2026-04-06T12:36:45.216Z |
| 9598443 | 9598443 | 20260330001344_D5W7k | BE000Y | 2026-03-31T12:10:37.189Z | 2026-04-06T12:36:32.722Z |
| 9589909 | 9589909 | 20260328041852_FsMz8 | BE000Y | 2026-03-29T12:01:44.107Z | 2026-04-06T12:37:37.928Z |
| 9588491 | 9588491 | 20260326232355_PZxjY | BE000Y | 2026-03-28T12:11:16.149Z | 2026-04-04T12:42:16.406Z |
| 9588245 | 9588245 | 20260326194758_ubu3K | BE000Y | 2026-03-28T12:10:36.504Z | 2026-04-04T12:41:50.905Z |
| 9575696 | 9575696 | 20260321013514_Zxba3 | BE000Y | 2026-03-25T12:27:46.897Z | 2026-03-29T12:18:59.033Z |
| 9575649 | 9575649 | 20260322010855_3boq5 | BE000Y | 2026-03-25T12:22:09.885Z | 2026-03-30T12:27:34.413Z |
| 9517104 | 9517104 | 20260317224145_FFVFN | BE000Y | 2026-03-19T12:27:11.607Z | 2026-03-25T12:43:08.712Z |
| 9517076 | 9517076 | 20260317224118_R01G2 | BE000Y | 2026-03-19T12:27:09.734Z | 2026-03-25T12:43:08.507Z |
| 9516780 | 9516780 | 20260317215719_JbHwU | BE000Y | 2026-03-19T12:26:46.957Z | 2026-03-25T12:43:06.923Z |
| 9511716 | 9511716 | 20260318041239_5Igkq | BE000Y | 2026-03-19T12:10:49.729Z | 2026-03-26T12:37:39.119Z |
| 9510797 | 9510797 | 20260318031611_mK2Mx | BE000Y | 2026-03-19T12:08:42.206Z | 2026-03-26T12:37:16.747Z |
| 9510793 | 9510793 | 20260318031610_A63qS | BE000Y | 2026-03-19T12:08:41.963Z | 2026-03-26T12:37:16.733Z |
| 9510573 | 9510573 | 20260318030009_QTKCd | BE000Y | 2026-03-19T12:08:00.205Z | 2026-03-26T12:37:14.471Z |
| 9510562 | 9510562 | 20260318030009_FyQjZ | BE000Y | 2026-03-19T12:07:59.906Z | 2026-03-26T12:37:14.467Z |
| 9510156 | 9510156 | 20260318023547_mSRs9 | BE000Y | 2026-03-19T12:07:01.433Z | 2026-03-26T12:37:10.553Z |
| 9510148 | 9510148 | 20260318023547_9iGZu | BE000Y | 2026-03-19T12:07:01.000Z | 2026-03-26T12:37:10.514Z |
| 9508045 | 9508045 | 20260318000934_Lghfh | BE000Y | 2026-03-19T12:02:01.258Z | 2026-03-26T12:36:55.283Z |
| 9492883 | 9492883 | 20260314221040_v4h1W | BE000Y | 2026-03-16T12:29:08.401Z | 2026-03-22T12:42:55.587Z |
| 9492629 | 9492629 | 20260314212858_EjDNn | BE000Y | 2026-03-16T12:28:52.394Z | 2026-03-22T12:42:53.549Z |
| 9492263 | 9492263 | 20260314195856_C6Km3 | BE000Y | 2026-03-16T12:28:14.811Z | 2026-03-22T12:42:51.415Z |
| 9486057 | 9486057 | 20260315044200_lJMv3 | BE000Y | 2026-03-16T12:08:32.708Z | 2026-03-23T12:21:55.165Z |
| 9486039 | 9486039 | 20260315043658_nPJJR | BE000Y | 2026-03-16T12:08:27.238Z | 2026-03-23T12:21:55.079Z |
| 9485294 | 9485294 | 20260315024743_yBEFu | BE000Y | 2026-03-16T12:05:57.996Z | 2026-03-23T12:21:50.873Z |
| 9485265 | 9485265 | 20260315024442_Lc2zf | BE000Y | 2026-03-16T12:05:51.970Z | 2026-03-23T12:21:50.700Z |
| 9485094 | 9485094 | 20260315022613_eRSkM | BE000Y | 2026-03-16T12:05:16.589Z | 2026-03-23T12:21:49.992Z |
| 9484988 | 9484988 | 20260315020956_gnVyU | BE000Y | 2026-03-16T12:04:51.567Z | 2026-03-23T12:21:49.433Z |
| 9484834 | 9484834 | 20260315014533_iOig3 | BE000Y | 2026-03-16T12:04:17.382Z | 2026-03-23T12:21:48.616Z |
| 9484760 | 9484760 | 20260315013638_iyqbw | BE000Y | 2026-03-16T12:04:02.838Z | 2026-03-23T12:21:48.264Z |
| 9484715 | 9484715 | 20260315013235_FHDJE | BE000Y | 2026-03-16T12:03:54.416Z | 2026-03-23T12:21:48.105Z |
| 9484683 | 9484683 | 20260315012755_HlJIP | BE000Y | 2026-03-16T12:03:45.807Z | 2026-03-23T12:21:47.890Z |
| 9484598 | 9484598 | 20260315011109_S0l9x | BE000Y | 2026-03-16T12:03:26.475Z | 2026-03-23T12:21:47.457Z |
| 9484480 | 9484480 | 20260315004530_z7SeJ | BE000Y | 2026-03-16T12:03:01.791Z | 2026-03-23T12:21:46.970Z |
| 9484227 | 9484227 | 20260315000606_ZnhZG | BE000Y | 2026-03-16T12:02:02.665Z | 2026-03-23T12:21:45.936Z |
| 9467164 | 9467164 | 20260311202640_uuong | BE000Y | 2026-03-13T12:18:35.129Z | 2026-03-19T12:45:49.598Z |
| 9467049 | 9467049 | 20260311194615_CW82W | BE000Y | 2026-03-13T12:18:10.666Z | 2026-03-19T12:45:47.357Z |
| 9464378 | 9464378 | 20260312043718_ZYGmR | BE000Y | 2026-03-13T12:07:07.224Z | 2026-03-20T12:36:39.548Z |
| 9463503 | 9463503 | 20260312020226_DD9cb | BE000Y | 2026-03-13T12:04:23.388Z | 2026-03-20T12:36:22.960Z |
| 9463173 | 9463173 | 20260312011022_zGAKQ | BE000Y | 2026-03-13T12:03:22.552Z | 2026-03-20T12:36:20.223Z |
| 9462261 | 9462261 | 20260311224253_vXi56 | BE000Y | 2026-03-13T12:00:14.132Z | 2026-03-20T12:36:14.725Z |
| 9456212 | 9456212 | 20260309222122_H3bep | BE000Y | 2026-03-11T12:15:51.086Z | 2026-03-17T12:42:58.447Z |
| 9455901 | 9455901 | 20260309205530_U6JTF | BE000Y | 2026-03-11T12:15:12.938Z | 2026-03-17T12:42:40.375Z |
| 9455695 | 9455695 | 20260309194303_IIThA | BE000Y | 2026-03-11T12:14:47.984Z | 2026-03-17T12:42:37.711Z |
| 9430931 | 9430931 | 20260304220742_bS2Qe | BE000Y | 2026-03-06T14:24:51.390Z | 2026-03-12T12:33:44.259Z |
| 9430904 | 9430904 | 20260304215211_Gu5vH | BE000Y | 2026-03-06T14:24:48.239Z | 2026-03-12T12:33:43.836Z |
| 9426437 | 9426437 | 20260305032907_bnmiY | BE000Y | 2026-03-06T14:04:52.544Z | 2026-03-13T12:34:46.444Z |
| 9426188 | 9426188 | 20260305022747_AYi0b | BE000Y | 2026-03-06T14:03:37.266Z | 2026-03-13T12:34:43.372Z |
| 9425985 | 9425985 | 20260305013017_3KXla | BE000Y | 2026-03-06T14:02:40.010Z | 2026-03-13T12:34:40.854Z |
| 9419190 | 9419190 | 20260303020510_wQm5m | BE000Y | 2026-03-04T14:00:56.259Z | 2026-03-11T12:27:46.488Z |
| 9419053 | 9419053 | 20260303004828_nX2kA | BE000Y | 2026-03-04T14:00:37.022Z | 2026-03-11T12:27:44.132Z |
| 9418847 | 9418847 | 20260302224940_LGp4q | BE000Y | 2026-03-04T14:00:07.635Z | 2026-03-11T12:27:39.891Z |
| 9415292 | 9415292 | 20260228213307_FnbK4 | BE000Y | 2026-03-02T14:07:41.177Z | 2026-03-08T12:43:08.822Z |
| 9415179 | 9415179 | 20260228203905_iSTKc | BE000Y | 2026-03-02T14:07:31.184Z | 2026-03-08T12:43:04.667Z |
| 9415084 | 9415084 | 20260228195543_o0SGd | BE000Y | 2026-03-02T14:07:22.129Z | 2026-03-08T12:43:00.914Z |
| 9412778 | 9412778 | 20260301052754_31R6o | BE000Y | 2026-03-02T14:02:05.478Z | 2026-03-09T12:39:50.242Z |
| 9412749 | 9412749 | 20260301051851_AOPbA | BE000Y | 2026-03-02T14:02:00.611Z | 2026-03-09T12:39:49.358Z |
| 9412659 | 9412659 | 20260301044448_68AMm | BE000Y | 2026-03-02T14:01:51.485Z | 2026-03-09T12:39:46.676Z |
| 9412454 | 9412454 | 20260301033609_oeKlO | BE000Y | 2026-03-02T14:01:25.436Z | 2026-03-09T12:39:39.523Z |
| 9411994 | 9411994 | 20260228231513_v6yDv | BE000Y | 2026-03-02T14:00:12.794Z | 2026-03-09T12:39:15.687Z |
| 9411978 | 9411978 | 20260228230743_tMYTV | BE000Y | 2026-03-02T14:00:10.906Z | 2026-03-09T12:39:15.348Z |
| 9407476 | 9407476 | 20260226184144_t3v3B | BE000Y | 2026-02-28T14:21:36.974Z | 2026-03-06T14:45:09.657Z |
| 9402934 | 9402934 | 20260227052102_YFtpz | BE000Y | 2026-02-28T14:06:34.779Z | 2026-03-07T14:47:16.564Z |
| 9402908 | 9402908 | 20260227050947_WQWB9 | BE000Y | 2026-02-28T14:06:29.824Z | 2026-03-07T14:47:15.064Z |
| 9402561 | 9402561 | 20260227040622_3ijKa | BE000Y | 2026-02-28T14:05:16.101Z | 2026-03-07T14:46:52.548Z |
| 9402321 | 9402321 | 20260227033437_p1nZE | BE000Y | 2026-02-28T14:04:29.028Z | 2026-03-07T14:46:42.034Z |
| 9402246 | 9402246 | 20260227032029_2ibXR | BE000Y | 2026-02-28T14:04:09.477Z | 2026-03-07T14:46:36.077Z |
| 9401859 | 9401859 | 20260227015538_aLzRu | BE000Y | 2026-02-28T14:02:30.144Z | 2026-03-07T14:46:11.532Z |
| 9401682 | 9401682 | 20260227011302_X22Yo | BE000Y | 2026-02-28T14:01:47.678Z | 2026-03-07T14:45:57.733Z |
| 9401534 | 9401534 | 20260227002601_FYpPK | BE000Y | 2026-02-28T14:01:10.294Z | 2026-03-07T14:45:49.682Z |
| 9398249 | 9398249 | 20260226032317_wNKjV | BE000Y | 2026-02-27T14:04:49.799Z | 2026-03-06T14:43:39.057Z |
| 9396838 | 9396838 | 20260225233029_DEPso | BE000Y | 2026-02-27T14:00:28.580Z | 2026-03-06T14:42:46.208Z |
| 9394773 | 9394773 | 20260224214704_f9c3m | BE000Y | 2026-02-26T14:20:38.041Z | 2026-03-04T14:19:27.134Z |
| 9394082 | 9394082 | 20260224183125_mflSg | BE000Y | 2026-02-26T14:18:41.160Z | 2026-03-04T14:19:15.638Z |
| 9392689 | 9392689 | 20260225052234_cJZaO | BE000Y | 2026-02-26T14:08:02.607Z | 2026-03-05T14:37:04.426Z |
| 9392333 | 9392333 | 20260225040715_Wnxel | BE000Y | 2026-02-26T14:07:04.740Z | 2026-03-05T14:36:54.676Z |
| 9392260 | 9392260 | 20260225035749_gKjB9 | BE000Y | 2026-02-26T14:06:52.929Z | 2026-03-05T14:36:52.995Z |
| 9391557 | 9391557 | 20260225025132_msjWu | BE000Y | 2026-02-26T14:04:43.087Z | 2026-03-05T14:36:24.302Z |
| 9391527 | 9391527 | 20260225024748_LoP2T | BE000Y | 2026-02-26T14:04:36.208Z | 2026-03-05T14:36:23.281Z |
| 9391457 | 9391457 | 20260225024121_47Wxq | BE000Y | 2026-02-26T14:04:22.144Z | 2026-03-05T14:36:20.966Z |
| 9390560 | 9390560 | 20260225004359_wyWsB | BE000Y | 2026-02-26T14:01:43.685Z | 2026-03-05T14:35:49.686Z |
| 9390488 | 9390488 | 20260225003609_83uIb | BE000Y | 2026-02-26T14:01:31.791Z | 2026-03-05T14:35:47.812Z |
| 9390126 | 9390126 | 20260224234911_ih6lj | BE000Y | 2026-02-26T14:00:32.925Z | 2026-03-05T14:35:33.368Z |
| 9390090 | 9390090 | 20260224233715_ktOGV | BE000Y | 2026-02-26T14:00:25.808Z | 2026-03-05T14:35:32.427Z |
| 9381135 | 9381135 | 20260222210608_GY808 | BE000Y | 2026-02-24T14:24:18.279Z | 2026-02-24T14:24:18.279Z |
| 9339742 | 9339742 | 20260216204654_5BAaB | BE000Y | 2026-02-18T14:22:46.463Z | 2026-02-25T14:42:45.416Z |
| 9336116 | 9336116 | 20260217031220_w05vX | BE000Y | 2026-02-18T14:03:22.385Z | 2026-02-26T14:39:15.642Z |
| 9335968 | 9335968 | 20260217025638_hu6Hp | BE000Y | 2026-02-18T14:02:54.551Z | 2026-02-26T14:39:00.550Z |
| 9331388 | 9331388 | 20260216050805_4aMwT | BE000Y | 2026-02-17T14:06:19.647Z | 2026-02-25T14:41:56.026Z |
| 9331022 | 9331022 | 20260216033811_LuO2U | BE000Y | 2026-02-17T14:04:15.374Z | 2026-02-25T14:41:36.741Z |
| 9327179 | 9327179 | 20260215042950_kGvoq | BE000Y | 2026-02-16T14:02:58.591Z | 2026-02-24T14:41:49.178Z |
| 9327075 | 9327075 | 20260215035416_ZRF2i | BE000Y | 2026-02-16T14:02:22.419Z | 2026-02-24T14:41:41.237Z |
| 9326953 | 9326953 | 20260215030634_I6mHu | BE000Y | 2026-02-16T14:01:40.588Z | 2026-02-24T14:41:38.996Z |
| 9326867 | 9326867 | 20260215024700_L2Iwt | BE000Y | 2026-02-16T14:01:11.178Z | 2026-02-24T14:41:37.644Z |
| 9306575 | 9306575 | 20260208002219_6YmYQ | BE000Y | 2026-02-09T14:24:17.397Z | 2026-02-16T15:00:38.813Z |
| 9306548 | 9306548 | 20260208001623_cubXC | BE000Y | 2026-02-09T14:24:12.344Z | 2026-02-16T15:00:37.346Z |
| 9302958 | 9302958 | 20260207030525_L1533 | BE000Y | 2026-02-08T14:24:30.297Z | 2026-02-15T15:01:13.804Z |
Advanced export
JSON shape: default, array, newline-delimited
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);