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,851 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
9607016 9607016 20260331014032_9LGTV BE0002 2026-04-04T12:25:05.683Z 2026-04-06T12:33:49.325Z
9606880 9606880 20260402230334_YAs3x BE0002 2026-04-04T12:12:09.215Z 2026-04-06T12:23:53.930Z
9592913 9592913 20260329035549_miDt5 BE0002 2026-03-30T12:02:19.026Z 2026-04-06T12:34:40.444Z
9588668 9588668 20260327002359_9eqgk BE0002 2026-03-28T12:11:37.735Z 2026-04-04T12:42:25.811Z
9588647 9588647 20260327001519_S0W9Z BE0002 2026-03-28T12:11:30.726Z 2026-04-04T12:42:23.796Z
9588389 9588389 20260326222216_mX9Iv BE0002 2026-03-28T12:11:01.281Z 2026-04-04T12:42:04.102Z
9585682 9585682 20260327020620_NlvMa BE0002 2026-03-28T12:01:01.266Z 2026-04-05T12:32:34.821Z
9579388 9579388 20260324194023_UwEQO BE0002 2026-03-26T12:13:32.180Z 2026-04-02T12:37:07.514Z
9570637 9570637 20260322222139_xAiO7 BE0002 2026-03-24T12:23:34.543Z 2026-03-30T12:30:46.963Z
9570512 9570512 20260322214425_vpgcC BE0002 2026-03-24T12:23:23.057Z 2026-03-30T12:30:44.493Z
9562516 9562516 20260323022815_cWGuA BE0002 2026-03-24T12:03:18.668Z 2026-03-31T12:26:13.378Z
9562393 9562393 20260323021641_i3r5j BE0002 2026-03-24T12:02:58.463Z 2026-03-31T12:26:09.216Z
9562383 9562383 20260323021640_xfeUC BE0002 2026-03-24T12:02:58.072Z 2026-03-31T12:26:09.156Z
9562320 9562320 20260323020825_hNMfZ BE0002 2026-03-24T12:02:49.496Z 2026-03-31T12:26:07.760Z
9562139 9562139 20260323013703_o9Tca BE0002 2026-03-24T12:02:18.111Z 2026-03-31T12:26:02.350Z
9561821 9561821 20260323004820_FPTOV BE0002 2026-03-24T12:01:24.151Z 2026-03-31T12:25:54.387Z
9561389 9561389 20260321232905_voXAq BE0002 2026-03-23T12:12:18.062Z 2026-03-29T12:21:06.933Z
9560250 9560250 20260321205343_Me3eg BE0002 2026-03-23T12:11:40.750Z 2026-03-29T12:20:58.798Z
9553140 9553140 20260322011934_ED2Ba BE0002 2026-03-23T12:01:15.468Z 2026-03-30T12:27:35.655Z
9551843 9551843 20260320215354_IauaW BE0002 2026-03-22T12:27:06.344Z 2026-03-28T12:37:02.787Z
9551332 9551332 20260320192557_swzyp BE0002 2026-03-22T12:26:26.394Z 2026-03-28T12:36:45.141Z
9543121 9543121 20260321024250_evg7c BE0002 2026-03-22T12:02:44.473Z 2026-03-29T12:19:03.346Z
9533996 9533996 20260320031650_za31W BE0002 2026-03-21T12:06:52.355Z 2026-03-28T12:34:03.369Z
9532698 9532698 20260320011923_q6T5V BE0002 2026-03-21T12:03:25.047Z 2026-03-28T12:33:35.326Z
9532405 9532405 20260320005303_hVANl BE0002 2026-03-21T12:02:37.798Z 2026-03-28T12:33:29.932Z
9532390 9532390 20260320005033_S4eCj BE0002 2026-03-21T12:02:34.333Z 2026-03-28T12:33:29.339Z
9531904 9531904 20260320000003_7B3uI BE0002 2026-03-21T12:01:09.735Z 2026-03-28T12:33:22.677Z
9530931 9530931 20260318220159_AGlE1 BE0002 2026-03-20T12:24:51.863Z 2026-03-26T12:39:16.603Z
9530522 9530522 20260318210453_Z3gli BE0002 2026-03-20T12:24:27.934Z 2026-03-26T12:39:13.352Z
9529646 9529646 20260318190223_YA3Zq BE0002 2026-03-20T12:23:30.784Z 2026-03-26T12:39:05.152Z
9518477 9518477 20260319010338_y2uvB BE0002 2026-03-20T12:02:40.548Z 2026-03-27T12:40:10.368Z
9517070 9517070 20260317223759_yKX2V BE0002 2026-03-19T12:27:09.493Z 2026-03-25T12:43:08.455Z
9511965 9511965 20260318043117_P86RL BE0002 2026-03-19T12:11:23.820Z 2026-03-26T12:37:41.105Z
9511776 9511776 20260318041733_BfCsG BE0002 2026-03-19T12:11:00.696Z 2026-03-26T12:37:39.677Z
9511116 9511116 20260318033706_fXOYT BE0002 2026-03-19T12:09:30.685Z 2026-03-26T12:37:21.642Z
9511108 9511108 20260318033706_4KEKc BE0002 2026-03-19T12:09:30.509Z 2026-03-26T12:37:21.002Z
9510786 9510786 20260318031610_5mIix BE0002 2026-03-19T12:08:41.339Z 2026-03-26T12:37:16.711Z
9510179 9510179 20260318023731_tcbne BE0002 2026-03-19T12:07:04.879Z 2026-03-26T12:37:10.785Z
9509444 9509444 20260318014936_V8cAk BE0002 2026-03-19T12:05:20.639Z 2026-03-26T12:37:05.506Z
9509159 9509159 20260318012853_4cVOJ BE0002 2026-03-19T12:04:40.015Z 2026-03-26T12:37:03.569Z
9494756 9494756 20260316025335_8Gz1Z BE0002 2026-03-17T12:04:50.976Z 2026-03-24T12:40:49.778Z
9485936 9485936 20260315041428_7wTcH BE0002 2026-03-16T12:08:06.586Z 2026-03-23T12:21:54.584Z
9485378 9485378 20260315025749_HBySI BE0002 2026-03-16T12:06:13.928Z 2026-03-23T12:21:51.646Z
9485253 9485253 20260315024206_AfvbA BE0002 2026-03-16T12:05:47.674Z 2026-03-23T12:21:50.608Z
9484488 9484488 20260315004917_TJzAB BE0002 2026-03-16T12:03:04.420Z 2026-03-23T12:21:47.073Z
9484456 9484456 20260315004333_kVFVU BE0002 2026-03-16T12:02:58.512Z 2026-03-23T12:21:46.937Z
9484048 9484048 20260314234408_owTPx BE0002 2026-03-16T12:01:22.208Z 2026-03-23T12:21:45.040Z
9463931 9463931 20260312030627_nE7Dl BE0002 2026-03-13T12:05:40.423Z 2026-03-20T12:36:25.711Z
9463703 9463703 20260312022924_mAd2U BE0002 2026-03-13T12:04:55.780Z 2026-03-20T12:36:24.194Z
9463579 9463579 20260312020830_1xHGT BE0002 2026-03-13T12:04:34.402Z 2026-03-20T12:36:23.449Z
9463391 9463391 20260312014332_V13lT BE0002 2026-03-13T12:04:00.631Z 2026-03-20T12:36:22.249Z
9463351 9463351 20260312013819_eCaDN BE0002 2026-03-13T12:03:55.437Z 2026-03-20T12:36:22.085Z
9462775 9462775 20260312001155_BSpJP BE0002 2026-03-13T12:02:06.950Z 2026-03-20T12:36:17.928Z
9460718 9460718 20260310215948_IC87t BE0002 2026-03-12T12:14:58.955Z 2026-03-18T12:40:18.430Z
9455634 9455634 20260309193056_ZHCSu BE0002 2026-03-11T12:14:42.197Z 2026-03-17T12:42:37.011Z
9446952 9446952 20260309034503_hzPXY BE0002 2026-03-10T12:04:35.016Z 2026-03-17T12:41:45.242Z
9437337 9437337 20260307031129_Y5JD0 BE0002 2026-03-08T12:03:36.321Z 2026-03-15T12:41:06.336Z
9431461 9431461 20260305234658_f9RXU BE0002 2026-03-07T14:00:45.536Z 2026-03-14T12:39:13.114Z
9426852 9426852 20260305045853_Sbyrq BE0002 2026-03-06T14:06:40.294Z 2026-03-13T12:34:51.932Z
9426845 9426845 20260305045802_nkKlp BE0002 2026-03-06T14:06:37.054Z 2026-03-13T12:34:51.818Z
9425539 9425539 20260304224236_cbjEC BE0002 2026-03-06T14:00:15.201Z 2026-03-13T12:34:24.845Z
9422411 9422411 20260304012409_57MNJ BE0002 2026-03-05T14:01:12.071Z 2026-03-12T12:32:27.768Z
9415290 9415290 20260228213307_FnbK4 BE0002 2026-03-02T14:07:41.177Z 2026-03-08T12:43:08.822Z
9412016 9412016 20260228232653_SDNTX BE0002 2026-03-02T14:00:16.523Z 2026-03-09T12:39:16.490Z
9402826 9402826 20260227044133_TgWTV BE0002 2026-02-28T14:06:10.257Z 2026-03-07T14:47:10.213Z
9401967 9401967 20260227022138_vvowP BE0002 2026-02-28T14:03:01.396Z 2026-03-07T14:46:17.467Z
9401902 9401902 20260227020635_4UzKS BE0002 2026-02-28T14:02:43.173Z 2026-03-07T14:46:14.207Z
9400907 9400907 20260225211235_GGhU2 BE0002 2026-02-27T14:15:59.706Z 2026-03-05T14:38:54.472Z
9400892 9400892 20260225211153_TrI21 BE0002 2026-02-27T14:15:59.094Z 2026-03-05T14:38:54.303Z
9399133 9399133 20260226050107_i917V BE0002 2026-02-27T14:07:02.298Z 2026-03-06T14:44:10.742Z
9398952 9398952 20260226043239_o4O1a BE0002 2026-02-27T14:06:35.811Z 2026-03-06T14:44:01.892Z
9397954 9397954 20260226024646_TDj2m BE0002 2026-02-27T14:03:59.467Z 2026-03-06T14:43:30.748Z
9392613 9392613 20260225045814_cdeSY BE0002 2026-02-26T14:07:48.294Z 2026-03-05T14:37:02.597Z
9392543 9392543 20260225044320_1cPFz BE0002 2026-02-26T14:07:37.534Z 2026-03-05T14:37:00.799Z
9392027 9392027 20260225033608_APGy3 BE0002 2026-02-26T14:06:13.654Z 2026-03-05T14:36:41.489Z
9391732 9391732 20260225031041_hL2e9 BE0002 2026-02-26T14:05:11.626Z 2026-03-05T14:36:29.156Z
9391625 9391625 20260225030133_fooN6 BE0002 2026-02-26T14:04:52.369Z 2026-03-05T14:36:26.086Z
9391569 9391569 20260225025442_nOd27 BE0002 2026-02-26T14:04:44.839Z 2026-03-05T14:36:24.601Z
9329917 9329917 20260214212155_NvEVj BE0002 2026-02-16T14:21:43.297Z 2026-02-23T14:47:38.385Z
9327341 9327341 20260215051840_jZLfi BE0002 2026-02-16T14:03:53.591Z 2026-02-24T14:41:52.399Z
9327042 9327042 20260215034714_TjMZt BE0002 2026-02-16T14:02:12.281Z 2026-02-24T14:41:40.674Z
9313708 9313708 20260210000804_8OxKn BE0002 2026-02-11T14:18:22.066Z 2026-02-18T15:02:20.181Z
9311561 9311561 20260209013424_qelR0 BE0002 2026-02-10T14:24:22.483Z 2026-02-16T14:54:55.935Z
9306978 9306978 20260208025402_U2Xxf BE0002 2026-02-09T14:25:55.207Z 2026-02-16T15:01:18.659Z
9302840 9302840 20260207021522_zuAuC BE0002 2026-02-08T14:24:01.807Z 2026-02-15T15:01:05.826Z
9302718 9302718 20260207012313_WWmb3 BE0002 2026-02-08T14:23:30.728Z 2026-02-15T15:00:58.078Z
9302691 9302691 20260207011738_PyMT7 BE0002 2026-02-08T14:23:23.988Z 2026-02-15T15:00:56.411Z
9302523 9302523 20260206231143_uqBmv BE0002 2026-02-08T14:22:45.592Z 2026-02-15T15:00:38.145Z
9298917 9298917 20260207060727_NP2du BE0002 2026-02-08T14:02:25.438Z 2026-02-16T14:55:46.873Z
9298871 9298871 20260207054152_T7Vi0 BE0002 2026-02-08T14:02:09.135Z 2026-02-16T14:55:43.516Z
9298617 9298617 20260207040337_IRxdP BE0002 2026-02-08T14:00:33.273Z 2026-02-16T14:55:22.380Z
9298580 9298580 20260207035423_eIyUO BE0002 2026-02-08T14:00:20.589Z 2026-02-16T14:55:20.480Z
9294626 9294626 20260204234022_o5pbZ BE0002 2026-02-06T14:20:29.046Z 2026-02-13T14:57:53.872Z
9294544 9294544 20260204204703_FQ0lO BE0002 2026-02-06T14:20:05.758Z 2026-02-13T14:57:41.401Z
9286148 9286148 20260201000311_BPHiY BE0002 2026-02-02T14:10:55.593Z 2026-02-09T14:52:39.292Z
9286122 9286122 20260131232550_1w6ez BE0002 2026-02-02T14:10:50.053Z 2026-02-09T14:52:37.255Z
9286107 9286107 20260131223802_6c3zR BE0002 2026-02-02T14:10:45.201Z 2026-02-09T14:52:35.775Z
9281399 9281399 20260130030424_oI8Lq BE0002 2026-01-31T14:19:09.258Z 2026-02-07T14:54:36.641Z
9262564 9262564 20260125201419_R20Ho BE0002 2026-01-27T14:13:36.859Z 2026-02-03T14:45:37.669Z
9260523 9260523 20260125050532_w3fjt BE0002 2026-01-26T14:22:07.115Z 2026-02-02T14:50:04.045Z

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