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

1,810 rows where station_code = "BE0016" 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
9610514 9610514 20260404200335_ct3ZD BE0016 2026-04-06T12:09:52.955Z 2026-04-06T12:16:14.585Z
9606883 9606883 20260402230334_YAs3x BE0016 2026-04-04T12:12:09.222Z 2026-04-06T12:23:53.930Z
9606824 9606824 20260402215753_IBBLt BE0016 2026-04-04T12:11:50.910Z 2026-04-06T12:23:47.084Z
9600441 9600441 20260330215929_WBBmS BE0016 2026-04-01T12:10:47.403Z 2026-04-06T12:33:26.002Z
9598544 9598544 20260330010419_1M0lZ BE0016 2026-03-31T12:10:53.459Z 2026-04-06T12:36:45.216Z
9594818 9594818 20260329003531_2Pq2k BE0016 2026-03-30T12:10:22.498Z 2026-04-06T12:40:16.829Z
9594522 9594522 20260328224920_QUzit BE0016 2026-03-30T12:09:45.101Z 2026-04-06T12:39:55.706Z
9592460 9592460 20260329021216_v64kh BE0016 2026-03-30T12:01:01.952Z 2026-04-06T12:34:11.220Z
9592319 9592319 20260329015233_KoO2g BE0016 2026-03-30T12:00:40.707Z 2026-04-06T12:34:00.511Z
9588501 9588501 20260326232612_ddHqW BE0016 2026-03-28T12:11:17.311Z 2026-04-04T12:42:16.991Z
9588497 9588497 20260326232437_KLKFt BE0016 2026-03-28T12:11:16.724Z 2026-04-04T12:42:16.623Z
9588391 9588391 20260326222216_mX9Iv BE0016 2026-03-28T12:11:01.281Z 2026-04-04T12:42:04.102Z
9588295 9588295 20260326205825_6UDi2 BE0016 2026-03-28T12:10:48.563Z 2026-04-04T12:41:55.707Z
9588293 9588293 20260326205825_1I8Io BE0016 2026-03-28T12:10:48.049Z 2026-04-04T12:41:55.451Z
9579389 9579389 20260324194023_UwEQO BE0016 2026-03-26T12:13:32.197Z 2026-04-02T12:37:07.514Z
9576343 9576343 20260325015548_TXDyV BE0016 2026-03-26T12:01:59.611Z 2026-04-03T12:35:53.988Z
9576321 9576321 20260325015410_2gt7t BE0016 2026-03-26T12:01:56.724Z 2026-04-03T12:35:53.339Z
9575748 9575748 20260321212626_nGcsT BE0016 2026-03-25T12:31:40.664Z 2026-03-29T12:21:00.421Z
9575698 9575698 20260321013514_Zxba3 BE0016 2026-03-25T12:27:46.897Z 2026-03-29T12:18:59.033Z
9574642 9574642 20260323040630_R1MZZ BE0016 2026-03-25T12:12:46.446Z 2026-03-31T12:26:30.575Z
9562930 9562930 20260323035326_YNrSU BE0016 2026-03-24T12:04:29.429Z 2026-03-31T12:26:29.736Z
9562837 9562837 20260323032409_CFVkq BE0016 2026-03-24T12:04:13.522Z 2026-03-31T12:26:27.376Z
9561440 9561440 20260321233423_k2Xyf BE0016 2026-03-23T12:12:19.206Z 2026-03-29T12:21:07.330Z
9561393 9561393 20260321232905_voXAq BE0016 2026-03-23T12:12:18.062Z 2026-03-29T12:21:06.933Z
9561219 9561219 20260321230908_SX1PK BE0016 2026-03-23T12:12:14.070Z 2026-03-29T12:21:05.763Z
9554435 9554435 20260322030711_QLUy9 BE0016 2026-03-23T12:02:31.812Z 2026-03-30T12:28:03.741Z
9553141 9553141 20260322011934_ED2Ba BE0016 2026-03-23T12:01:15.488Z 2026-03-30T12:27:35.655Z
9551845 9551845 20260320215354_IauaW BE0016 2026-03-22T12:27:06.344Z 2026-03-28T12:37:02.787Z
9551759 9551759 20260320212607_tGuOs BE0016 2026-03-22T12:27:01.211Z 2026-03-28T12:37:01.732Z
9551671 9551671 20260320205130_uwnMS BE0016 2026-03-22T12:26:55.274Z 2026-03-28T12:36:59.809Z
9551560 9551560 20260320201954_tnU2z BE0016 2026-03-22T12:26:48.035Z 2026-03-28T12:36:58.100Z
9551334 9551334 20260320192557_swzyp BE0016 2026-03-22T12:26:26.394Z 2026-03-28T12:36:45.141Z
9543436 9543436 20260321035547_TLkEX BE0016 2026-03-22T12:03:49.390Z 2026-03-29T12:19:07.575Z
9543125 9543125 20260321024250_evg7c BE0016 2026-03-22T12:02:44.492Z 2026-03-29T12:19:03.346Z
9542933 9542933 20260321015617_cxISK BE0016 2026-03-22T12:02:07.276Z 2026-03-29T12:19:00.436Z
9542847 9542847 20260321013514_ZM4U5 BE0016 2026-03-22T12:01:46.992Z 2026-03-24T12:25:05.355Z
9542674 9542674 20260321004559_yTUXx BE0016 2026-03-22T12:01:13.657Z 2026-03-29T12:18:56.924Z
9542490 9542490 20260320234934_Dp2hO BE0016 2026-03-22T12:00:26.352Z 2026-03-29T12:18:44.638Z
9541860 9541860 20260319215929_tUCUn BE0016 2026-03-21T12:29:26.769Z 2026-03-27T12:42:42.586Z
9533997 9533997 20260320031650_za31W BE0016 2026-03-21T12:06:52.355Z 2026-03-28T12:34:03.369Z
9533768 9533768 20260320025615_O2UUR BE0016 2026-03-21T12:06:14.018Z 2026-03-28T12:34:00.317Z
9533571 9533571 20260320024336_4E18x BE0016 2026-03-21T12:05:46.128Z 2026-03-28T12:33:56.380Z
9532700 9532700 20260320011923_q6T5V BE0016 2026-03-21T12:03:25.047Z 2026-03-28T12:33:35.326Z
9532406 9532406 20260320005303_hVANl BE0016 2026-03-21T12:02:37.798Z 2026-03-28T12:33:29.932Z
9532391 9532391 20260320005033_S4eCj BE0016 2026-03-21T12:02:34.333Z 2026-03-28T12:33:29.339Z
9531905 9531905 20260320000003_7B3uI BE0016 2026-03-21T12:01:09.748Z 2026-03-28T12:33:22.677Z
9531199 9531199 20260318224122_spQLP BE0016 2026-03-20T12:25:01.378Z 2026-03-26T12:39:17.994Z
9530935 9530935 20260318220159_AGlE1 BE0016 2026-03-20T12:24:51.863Z 2026-03-26T12:39:16.604Z
9530768 9530768 20260318214138_4tr0w BE0016 2026-03-20T12:24:45.927Z 2026-03-26T12:39:15.376Z
9530752 9530752 20260318213736_J041M BE0016 2026-03-20T12:24:45.527Z 2026-03-26T12:39:15.285Z
9530628 9530628 20260318211821_3V3NF BE0016 2026-03-20T12:24:32.868Z 2026-03-26T12:39:14.380Z
9530526 9530526 20260318210453_Z3gli BE0016 2026-03-20T12:24:27.935Z 2026-03-26T12:39:13.352Z
9529912 9529912 20260318194204_iwbvE BE0016 2026-03-20T12:23:49.031Z 2026-03-26T12:39:07.421Z
9521843 9521843 20260319044858_effJn BE0016 2026-03-20T12:08:39.709Z 2026-03-27T12:41:11.134Z
9521508 9521508 20260319042226_giEXp BE0016 2026-03-20T12:08:09.380Z 2026-03-27T12:40:55.373Z
9518479 9518479 20260319010338_y2uvB BE0016 2026-03-20T12:02:40.574Z 2026-03-27T12:40:10.368Z
9517809 9517809 20260319000458_vsYSO BE0016 2026-03-20T12:01:20.822Z 2026-03-27T12:40:03.609Z
9517106 9517106 20260317224145_FFVFN BE0016 2026-03-19T12:27:11.607Z 2026-03-25T12:43:08.712Z
9517073 9517073 20260317223759_yKX2V BE0016 2026-03-19T12:27:09.493Z 2026-03-25T12:43:08.455Z
9516835 9516835 20260317220329_lSuQz BE0016 2026-03-19T12:26:49.837Z 2026-03-25T12:43:07.230Z
9516782 9516782 20260317215719_JbHwU BE0016 2026-03-19T12:26:46.957Z 2026-03-25T12:43:06.923Z
9516183 9516183 20260317201023_DN5GK BE0016 2026-03-19T12:25:44.774Z 2026-03-25T12:42:50.756Z
9516032 9516032 20260317194513_XFXZx BE0016 2026-03-19T12:25:32.923Z 2026-03-25T12:42:46.368Z
9511985 9511985 20260318043227_NOsgh BE0016 2026-03-19T12:11:25.793Z 2026-03-26T12:37:41.305Z
9511967 9511967 20260318043117_P86RL BE0016 2026-03-19T12:11:23.820Z 2026-03-26T12:37:41.105Z
9511920 9511920 20260318042914_lTj65 BE0016 2026-03-19T12:11:20.342Z 2026-03-26T12:37:40.823Z
9511900 9511900 20260318042758_VZahA BE0016 2026-03-19T12:11:17.896Z 2026-03-26T12:37:40.684Z
9511781 9511781 20260318041733_BfCsG BE0016 2026-03-19T12:11:00.697Z 2026-03-26T12:37:39.677Z
9511487 9511487 20260318035619_2l2Ur BE0016 2026-03-19T12:10:19.234Z 2026-03-26T12:37:37.257Z
9510798 9510798 20260318031611_mK2Mx BE0016 2026-03-19T12:08:42.206Z 2026-03-26T12:37:16.747Z
9510794 9510794 20260318031610_A63qS BE0016 2026-03-19T12:08:41.963Z 2026-03-26T12:37:16.733Z
9510790 9510790 20260318031610_5mIix BE0016 2026-03-19T12:08:41.339Z 2026-03-26T12:37:16.711Z
9510591 9510591 20260318030039_EWzhe BE0016 2026-03-19T12:08:02.958Z 2026-03-26T12:37:14.585Z
9510183 9510183 20260318023731_tcbne BE0016 2026-03-19T12:07:04.879Z 2026-03-26T12:37:10.785Z
9510177 9510177 20260318023625_cTwpw BE0016 2026-03-19T12:07:04.289Z 2026-03-26T12:37:10.759Z
9509952 9509952 20260318022320_Sy7sz BE0016 2026-03-19T12:06:31.781Z 2026-03-26T12:37:08.768Z
9509695 9509695 20260318020735_FKD5R BE0016 2026-03-19T12:05:59.036Z 2026-03-26T12:37:07.083Z
9509690 9509690 20260318020735_Lta28 BE0016 2026-03-19T12:05:58.798Z 2026-03-26T12:37:07.065Z
9509450 9509450 20260318014936_V8cAk BE0016 2026-03-19T12:05:20.639Z 2026-03-26T12:37:05.507Z
9509319 9509319 20260318014324_5rZx5 BE0016 2026-03-19T12:05:06.449Z 2026-03-26T12:37:04.872Z
9509205 9509205 20260318013251_Rax3n BE0016 2026-03-19T12:04:46.252Z 2026-03-26T12:37:03.868Z
9509160 9509160 20260318012853_4cVOJ BE0016 2026-03-19T12:04:40.027Z 2026-03-26T12:37:03.569Z
9509070 9509070 20260318012543_1tM11 BE0016 2026-03-19T12:04:32.301Z 2026-03-26T12:37:03.164Z
9509064 9509064 20260318012543_zgpFd BE0016 2026-03-19T12:04:32.058Z 2026-03-26T12:37:03.151Z
9508426 9508426 20260318005341_ac8Or BE0016 2026-03-19T12:03:04.051Z 2026-03-26T12:36:58.395Z
9508422 9508422 20260318005341_kqTgu BE0016 2026-03-19T12:03:03.261Z 2026-03-26T12:36:58.393Z
9508246 9508246 20260318003628_w4QEI BE0016 2026-03-19T12:02:43.163Z 2026-03-26T12:36:57.260Z
9501878 9501878 20260316235625_ScYyW BE0016 2026-03-18T12:00:33.789Z 2026-03-25T12:41:43.515Z
9494870 9494870 20260316031604_gnHXC BE0016 2026-03-17T12:05:20.018Z 2026-03-24T12:40:50.800Z
9494757 9494757 20260316025335_8Gz1Z BE0016 2026-03-17T12:04:50.999Z 2026-03-24T12:40:49.778Z
9492943 9492943 20260314222052_uLnDO BE0016 2026-03-16T12:29:12.027Z 2026-03-22T12:42:55.906Z
9492885 9492885 20260314221040_v4h1W BE0016 2026-03-16T12:29:08.401Z 2026-03-22T12:42:55.587Z
9492265 9492265 20260314195856_C6Km3 BE0016 2026-03-16T12:28:14.812Z 2026-03-22T12:42:51.415Z
9486120 9486120 20260315045535_JXAKc BE0016 2026-03-16T12:08:44.047Z 2026-03-23T12:21:55.443Z
9486058 9486058 20260315044200_lJMv3 BE0016 2026-03-16T12:08:32.708Z 2026-03-23T12:21:55.165Z
9485938 9485938 20260315041428_7wTcH BE0016 2026-03-16T12:08:06.586Z 2026-03-23T12:21:54.584Z
9485897 9485897 20260315040704_lnl0P BE0016 2026-03-16T12:07:57.860Z 2026-03-23T12:21:54.460Z
9485852 9485852 20260315040345_MeOoD BE0016 2026-03-16T12:07:50.803Z 2026-03-23T12:21:54.313Z
9485656 9485656 20260315033629_xbgOC BE0016 2026-03-16T12:07:09.156Z 2026-03-23T12:21:53.305Z
9485380 9485380 20260315025749_HBySI BE0016 2026-03-16T12:06:13.928Z 2026-03-23T12:21:51.646Z

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