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,564 rows where station_code = "BE000P" 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
9842696 9842696 20260504023757_p2h9G BE000P 2026-05-05T12:04:21.080Z 2026-05-06T12:17:24.251Z
9842591 9842591 20260504015806_628cb BE000P 2026-05-05T12:04:00.759Z 2026-05-06T12:17:24.196Z
9842477 9842477 20260504012613_lynlj BE000P 2026-05-05T12:03:33.210Z 2026-05-06T12:17:24.134Z
9842473 9842473 20260504012518_SBnr5 BE000P 2026-05-05T12:03:32.156Z 2026-05-06T12:17:24.131Z
9842403 9842403 20260504004037_UTf2X BE000P 2026-05-05T12:03:18.112Z 2026-05-06T12:17:24.083Z
9842348 9842348 20260504001551_44Mff BE000P 2026-05-05T12:02:59.389Z 2026-05-06T12:17:24.053Z
9842126 9842126 20260503215452_u4d5B BE000P 2026-05-05T12:02:07.877Z 2026-05-06T12:17:23.918Z
9842000 9842000 20260503212133_VxA8b BE000P 2026-05-05T12:01:36.377Z 2026-05-06T12:17:23.838Z
9841954 9841954 20260503210842_WaSp8 BE000P 2026-05-05T12:01:26.062Z 2026-05-06T12:17:23.805Z
9834700 9834700 20260501225552_Wag1P BE000P 2026-05-03T12:03:21.299Z 2026-05-06T12:22:06.825Z
9834527 9834527 20260501214503_h4cjY BE000P 2026-05-03T12:02:37.810Z 2026-05-06T12:22:00.292Z
9834348 9834348 20260501210030_gQdZQ BE000P 2026-05-03T12:01:43.966Z 2026-05-06T12:21:56.149Z
9834304 9834304 20260501204813_ch9Rv BE000P 2026-05-03T12:01:35.501Z 2026-05-06T12:21:55.268Z
9832075 9832075 20260501025418_O0dXr BE000P 2026-05-02T12:08:45.853Z 2026-05-06T12:26:40.695Z
9831808 9831808 20260501022050_Qja0k BE000P 2026-05-02T12:08:06.174Z 2026-05-06T12:26:36.581Z
9831237 9831237 20260501010105_NjhiL BE000P 2026-05-02T12:06:19.732Z 2026-05-06T12:26:24.003Z
9831011 9831011 20260501003408_ft1nh BE000P 2026-05-02T12:05:46.038Z 2026-05-06T12:26:04.698Z
9830767 9830767 20260430234943_Tqrij BE000P 2026-05-02T12:04:57.118Z 2026-05-06T12:25:57.139Z
9830291 9830291 20260430220638_n23Hc BE000P 2026-05-02T12:03:32.280Z 2026-05-06T12:25:47.212Z
9830184 9830184 20260430213605_HRpJ6 BE000P 2026-05-02T12:03:10.578Z 2026-05-06T12:25:15.460Z
9830163 9830163 20260430213223_tiZR4 BE000P 2026-05-02T12:03:07.967Z 2026-05-06T12:25:14.994Z
9830052 9830052 20260430205936_mz2LY BE000P 2026-05-02T12:02:47.827Z 2026-05-06T12:25:12.686Z
9829999 9829999 20260430204911_q6EEz BE000P 2026-05-02T12:02:39.957Z 2026-05-06T12:25:11.215Z
9827249 9827249 20260430030605_C6jue BE000P 2026-05-01T12:13:30.279Z 2026-05-06T12:30:24.205Z
9827238 9827238 20260430030553_DoCZh BE000P 2026-05-01T12:13:29.769Z 2026-05-06T12:30:24.157Z
9826784 9826784 20260430022202_dPuhg BE000P 2026-05-01T12:12:26.179Z 2026-05-06T12:29:52.654Z
9826689 9826689 20260430021514_0zgiX BE000P 2026-05-01T12:12:13.587Z 2026-05-06T12:29:51.476Z
9826361 9826361 20260430014445_OaS4X BE000P 2026-05-01T12:11:10.427Z 2026-05-06T12:29:42.925Z
9826046 9826046 20260430010941_myXR0 BE000P 2026-05-01T12:10:07.211Z 2026-05-06T12:29:37.164Z
9825615 9825615 20260430001140_4Fiyx BE000P 2026-05-01T12:08:52.022Z 2026-05-06T12:29:07.873Z
9825261 9825261 20260429231206_ffrNO BE000P 2026-05-01T12:07:44.021Z 2026-05-06T12:28:58.672Z
9825250 9825250 20260429231129_Fk0GS BE000P 2026-05-01T12:07:37.796Z 2026-05-06T12:28:58.417Z
9825082 9825082 20260429224119_O8TZI BE000P 2026-05-01T12:07:11.235Z 2026-05-06T12:28:55.241Z
9825079 9825079 20260429224052_f5yDv BE000P 2026-05-01T12:07:10.660Z 2026-05-06T12:28:55.186Z
9824975 9824975 20260429221115_wEtui BE000P 2026-05-01T12:06:48.518Z 2026-05-06T12:28:53.011Z
9824963 9824963 20260429220545_U3FDb BE000P 2026-05-01T12:06:41.406Z 2026-05-06T12:28:52.465Z
9824791 9824791 20260429212307_6vRwS BE000P 2026-05-01T12:06:00.882Z 2026-05-06T12:28:48.980Z
9824749 9824749 20260429211119_96GFk BE000P 2026-05-01T12:05:49.963Z 2026-05-06T12:28:47.949Z
9824737 9824737 20260429210902_eoPmx BE000P 2026-05-01T12:05:47.723Z 2026-05-06T12:28:47.034Z
9821583 9821583 20260429025441_TaOyF BE000P 2026-04-30T12:18:28.522Z 2026-05-06T12:34:36.812Z
9821492 9821492 20260429024813_LE33x BE000P 2026-04-30T12:18:09.156Z 2026-05-06T12:34:35.993Z
9821476 9821476 20260429024649_2VFE9 BE000P 2026-04-30T12:18:08.025Z 2026-05-06T12:34:35.874Z
9821307 9821307 20260429023317_2vOtS BE000P 2026-04-30T12:17:45.386Z 2026-05-06T12:34:33.666Z
9821164 9821164 20260429021616_i5F7T BE000P 2026-04-30T12:17:22.078Z 2026-05-06T12:34:08.179Z
9820946 9820946 20260429015158_Nhj5p BE000P 2026-04-30T12:16:42.690Z 2026-05-06T12:33:51.881Z
9820796 9820796 20260429013521_ZvuhS BE000P 2026-04-30T12:16:09.704Z 2026-05-06T12:33:49.837Z
9820544 9820544 20260429011430_dRkKX BE000P 2026-04-30T12:15:23.616Z 2026-05-06T12:33:44.261Z
9819922 9819922 20260429000131_akHVz BE000P 2026-04-30T12:13:27.668Z 2026-05-06T12:33:35.524Z
9819596 9819596 20260428225009_74mLf BE000P 2026-04-30T12:12:08.201Z 2026-05-06T12:33:17.232Z
9819354 9819354 20260428220053_543FW BE000P 2026-04-30T12:11:14.050Z 2026-05-06T12:32:44.549Z
9813621 9813621 20260428025831_lhIbS BE000P 2026-04-29T12:15:18.677Z 2026-05-06T12:37:47.782Z
9809543 9809543 20260425221644_H0v4X BE000P 2026-04-28T12:28:40.157Z 2026-05-04T12:44:04.966Z
9807356 9807356 20260427031421_D5GSy BE000P 2026-04-28T12:15:53.794Z 2026-05-05T12:34:24.747Z
9807260 9807260 20260427025847_fTfD3 BE000P 2026-04-28T12:15:37.006Z 2026-05-05T12:34:23.407Z
9807163 9807163 20260427024620_WjqvV BE000P 2026-04-28T12:15:12.695Z 2026-05-05T12:34:22.076Z
9806978 9806978 20260427021401_K9kbd BE000P 2026-04-28T12:14:23.266Z 2026-05-05T12:34:18.942Z
9806727 9806727 20260427014049_3FAAj BE000P 2026-04-28T12:13:13.983Z 2026-05-05T12:34:14.734Z
9806507 9806507 20260427011557_YX7bX BE000P 2026-04-28T12:12:12.659Z 2026-05-05T12:34:09.746Z
9805981 9805981 20260426233508_JoNzq BE000P 2026-04-28T12:09:35.590Z 2026-05-05T12:33:43.767Z
9805950 9805950 20260426232837_95uzP BE000P 2026-04-28T12:09:27.778Z 2026-05-05T12:33:43.188Z
9805829 9805829 20260426230200_XwitI BE000P 2026-04-28T12:08:55.587Z 2026-05-05T12:33:41.154Z
9805731 9805731 20260426223408_JMN4S BE000P 2026-04-28T12:08:25.333Z 2026-05-05T12:33:39.268Z
9805610 9805610 20260426214924_fsyed BE000P 2026-04-28T12:07:50.408Z 2026-05-05T12:33:37.205Z
9800532 9800532 20260426024223_U5DGA BE000P 2026-04-27T12:30:01.103Z 2026-05-04T12:45:44.708Z
9800528 9800528 20260426024216_MRV5l BE000P 2026-04-27T12:30:00.603Z 2026-05-04T12:45:42.802Z
9800459 9800459 20260426023639_YHrfu BE000P 2026-04-27T12:29:53.833Z 2026-05-04T12:45:33.844Z
9800341 9800341 20260426022653_WaV4w BE000P 2026-04-27T12:29:27.406Z 2026-05-04T12:45:31.723Z
9800315 9800315 20260426022303_EPwYc BE000P 2026-04-27T12:29:24.834Z 2026-05-04T12:45:31.197Z
9799959 9799959 20260426015601_irbwW BE000P 2026-04-27T12:28:18.380Z 2026-05-04T12:45:21.562Z
9799854 9799854 20260426014822_e7XT1 BE000P 2026-04-27T12:28:03.964Z 2026-05-04T12:45:19.616Z
9797829 9797829 20260425214007_C1F4B BE000P 2026-04-27T12:21:01.386Z 2026-05-04T12:44:00.046Z
9797477 9797477 20260425205230_rUPbk BE000P 2026-04-27T12:19:40.064Z 2026-05-04T12:43:34.437Z
9797314 9797314 20260425202639_Wn2I4 BE000P 2026-04-27T12:18:59.401Z 2026-05-04T12:43:29.882Z
9787874 9787874 20260425031331_3LVp9 BE000P 2026-04-26T12:23:16.137Z 2026-05-02T13:02:32.267Z
9787836 9787836 20260425030843_iNKv5 BE000P 2026-04-26T12:23:15.327Z 2026-05-02T13:02:31.692Z
9787554 9787554 20260425024411_XqoXT BE000P 2026-04-26T12:22:41.486Z 2026-05-02T13:02:24.881Z
9787460 9787460 20260425023719_FzDnS BE000P 2026-04-26T12:22:33.972Z 2026-05-02T13:02:23.098Z
9787358 9787358 20260425023027_KOn29 BE000P 2026-04-26T12:22:29.222Z 2026-05-02T13:02:06.442Z
9787347 9787347 20260425022946_scHF2 BE000P 2026-04-26T12:22:28.582Z 2026-05-02T13:02:05.920Z
9787319 9787319 20260425022851_5TyA2 BE000P 2026-04-26T12:22:27.732Z 2026-05-02T13:02:02.483Z
9786948 9786948 20260425020507_ZEAj7 BE000P 2026-04-26T12:21:45.385Z 2026-05-02T13:01:52.568Z
9786830 9786830 20260425015741_GvwCQ BE000P 2026-04-26T12:21:37.262Z 2026-05-02T13:01:49.439Z
9786751 9786751 20260425015213_SR7iG BE000P 2026-04-26T12:21:18.549Z 2026-05-02T13:01:47.718Z
9786682 9786682 20260425014843_WdLOd BE000P 2026-04-26T12:21:15.924Z 2026-05-02T13:01:46.521Z
9785650 9785650 20260425003920_3ZvlO BE000P 2026-04-26T12:19:24.702Z 2026-05-02T13:01:05.112Z
9785225 9785225 20260425000732_p3ZyW BE000P 2026-04-26T12:18:41.753Z 2026-05-02T13:00:39.437Z
9784517 9784517 20260424230831_w1Smf BE000P 2026-04-26T12:17:17.681Z 2026-05-02T13:00:08.686Z
9784019 9784019 20260424221132_zSKxo BE000P 2026-04-26T12:16:03.261Z 2026-05-02T12:59:42.507Z
9783329 9783329 20260424211120_DpAFm BE000P 2026-04-26T12:14:32.496Z 2026-05-02T12:59:16.193Z
9772630 9772630 20260423025749_kDr36 BE000P 2026-04-25T12:49:51.911Z 2026-04-30T13:12:31.117Z
9772182 9772182 20260422211612_QwFsv BE000P 2026-04-25T12:42:30.307Z 2026-04-30T13:07:28.739Z
9770431 9770431 20260424032108_XWx1P BE000P 2026-04-25T12:32:01.751Z 2026-05-02T13:12:21.212Z
9770299 9770299 20260424030956_Xaw8Y BE000P 2026-04-25T12:31:52.806Z 2026-05-02T13:12:19.714Z
9769955 9769955 20260424024631_JXsfQ BE000P 2026-04-25T12:31:01.103Z 2026-05-02T13:12:14.219Z
9769327 9769327 20260424021125_5B6Pv BE000P 2026-04-25T12:29:38.295Z 2026-05-02T13:11:39.552Z
9769240 9769240 20260424020558_pgr2G BE000P 2026-04-25T12:29:22.160Z 2026-05-02T13:11:36.907Z
9768879 9768879 20260424014957_3Obj3 BE000P 2026-04-25T12:28:30.632Z 2026-05-02T13:11:28.996Z
9768853 9768853 20260424014852_qahV4 BE000P 2026-04-25T12:28:20.218Z 2026-05-02T13:11:28.615Z
9768696 9768696 20260424014419_r7st5 BE000P 2026-04-25T12:28:01.959Z 2026-05-02T13:11:13.954Z
9768390 9768390 20260424012735_zCh2U BE000P 2026-04-25T12:27:08.898Z 2026-05-02T13:11:05.848Z

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