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

6,630 rows where station_code = "BE0009" 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
8690798 8690798 20251205015153_ol9y6 BE0009 2025-12-06T14:15:33.631Z 2025-12-06T14:18:00.963Z
8690514 8690514 20251205000812_Szrjc BE0009 2025-12-06T14:14:35.752Z 2025-12-06T14:18:00.898Z
8690412 8690412 20251204233047_V8FO3 BE0009 2025-12-06T14:14:13.769Z 2025-12-06T14:18:00.876Z
8690233 8690233 20251204222108_uCVB8 BE0009 2025-12-06T14:13:51.156Z 2025-12-06T14:18:00.845Z
8690159 8690159 20251204212854_44R5h BE0009 2025-12-06T14:13:32.659Z 2025-12-06T14:18:00.830Z
8681119 8681119 20251203022606_yDy6a BE0009 2025-12-04T14:13:53.925Z 2025-12-06T14:27:50.279Z
8681067 8681067 20251203021807_5Lly7 BE0009 2025-12-04T14:13:41.100Z 2025-12-06T14:27:48.178Z
8667353 8667353 20251130001656_G9bjA BE0009 2025-12-02T14:37:24.866Z 2025-12-06T14:46:53.621Z
8665459 8665459 20251201032202_m37R3 BE0009 2025-12-02T14:23:43.258Z 2025-12-06T14:41:37.943Z
8665379 8665379 20251201031414_ki4pK BE0009 2025-12-02T14:23:36.287Z 2025-12-06T14:41:36.545Z
8664136 8664136 20251130232247_6YD22 BE0009 2025-12-02T14:20:08.598Z 2025-12-06T14:40:37.325Z
8663876 8663876 20251130222221_bmLLI BE0009 2025-12-02T14:19:29.616Z 2025-12-06T14:40:13.691Z
8663645 8663645 20251130211425_Vf2iO BE0009 2025-12-02T14:18:39.339Z 2025-12-06T14:40:05.646Z
8663491 8663491 20251130205019_0TFZK BE0009 2025-12-02T14:18:22.394Z 2025-12-06T14:40:01.644Z
8663374 8663374 20251130204032_5Lyqf BE0009 2025-12-02T14:18:04.027Z 2025-12-06T14:39:59.239Z
8662727 8662727 20251130192414_wt3sy BE0009 2025-12-02T14:16:25.329Z 2025-12-06T14:39:27.533Z
8662673 8662673 20251130192008_umyNp BE0009 2025-12-02T14:16:17.617Z 2025-12-06T14:39:25.999Z
8662271 8662271 20251130182521_NH15V BE0009 2025-12-02T14:14:53.017Z 2025-12-06T14:38:57.650Z
8662257 8662257 20251130182339_bsvbt BE0009 2025-12-02T14:14:51.138Z 2025-12-06T14:38:57.279Z
8662188 8662188 20251130181632_uGQg0 BE0009 2025-12-02T14:14:39.392Z 2025-12-06T14:38:54.789Z
8657150 8657150 20251130053213_2LOvZ BE0009 2025-12-01T14:33:56.519Z 2025-12-06T14:49:45.343Z
8656321 8656321 20251130044932_F24pN BE0009 2025-12-01T14:28:20.491Z 2025-12-06T14:49:33.469Z
8656254 8656254 20251130044531_8otOS BE0009 2025-12-01T14:28:14.232Z 2025-12-06T14:49:32.827Z
8655879 8655879 20251130042201_wcFza BE0009 2025-12-01T14:27:34.833Z 2025-12-06T14:49:28.711Z
8655637 8655637 20251130041032_qzGAS BE0009 2025-12-01T14:27:19.708Z 2025-12-06T14:49:26.186Z
8653730 8653730 20251130023804_3DmGC BE0009 2025-12-01T14:24:08.386Z 2025-12-06T14:48:31.141Z
8653598 8653598 20251130022900_pmPr6 BE0009 2025-12-01T14:23:46.089Z 2025-12-06T14:48:19.736Z
8652841 8652841 20251130013725_XL7gf BE0009 2025-12-01T14:22:13.499Z 2025-12-06T14:47:43.235Z
8651534 8651534 20251129235400_QFVfZ BE0009 2025-12-01T14:19:17.316Z 2025-12-06T14:46:47.949Z
8651441 8651441 20251129234330_mF1v1 BE0009 2025-12-01T14:19:08.084Z 2025-12-06T14:46:46.241Z
8651196 8651196 20251129230337_xHcrk BE0009 2025-12-01T14:18:21.877Z 2025-12-06T14:46:41.772Z
8650821 8650821 20251129213659_pkT4X BE0009 2025-12-01T14:17:15.732Z 2025-12-06T14:46:34.378Z
8650781 8650781 20251129212614_CXd2Y BE0009 2025-12-01T14:17:09.368Z 2025-12-06T14:46:33.691Z
8650738 8650738 20251129212046_oMrpb BE0009 2025-12-01T14:17:04.626Z 2025-12-06T14:46:33.021Z
8646198 8646198 20251129012250_Ca3X8 BE0009 2025-11-30T14:25:24.222Z 2025-12-06T14:55:43.626Z
8645978 8645978 20251129004024_9ENl4 BE0009 2025-11-30T14:25:01.410Z 2025-12-06T14:55:21.952Z
8645947 8645947 20251129003339_VbEMk BE0009 2025-11-30T14:24:58.412Z 2025-12-06T14:55:19.581Z
8645772 8645772 20251128234739_TccWv BE0009 2025-11-30T14:24:30.621Z 2025-12-06T14:55:06.152Z
8645706 8645706 20251128233412_s1xCM BE0009 2025-11-30T14:24:25.569Z 2025-12-06T14:55:02.483Z
8645452 8645452 20251128221530_PYkxX BE0009 2025-11-30T14:23:45.478Z 2025-12-06T14:54:58.433Z
8645033 8645033 20251128203039_pmqIR BE0009 2025-11-30T14:23:00.027Z 2025-12-06T14:54:50.182Z
8644955 8644955 20251128201839_lFuts BE0009 2025-11-30T14:22:54.446Z 2025-12-06T14:54:49.407Z
8643347 8643347 20251128174430_hd7Aa BE0009 2025-11-30T14:19:55.490Z 2025-12-06T14:53:48.053Z
8622108 8622108 20251126175152_VNthS BE0009 2025-11-28T14:17:43.468Z 2025-12-05T15:02:52.386Z
8616475 8616475 20251126060212_CkC2a BE0009 2025-11-27T14:31:13.302Z 2025-12-04T15:11:39.888Z
8616255 8616255 20251126054744_ak0NG BE0009 2025-11-27T14:30:59.919Z 2025-12-04T15:11:37.334Z
8616216 8616216 20251126054722_MYiNN BE0009 2025-11-27T14:30:57.731Z 2025-12-04T15:11:37.041Z
8615786 8615786 20251126051907_bIt5B BE0009 2025-11-27T14:30:10.683Z 2025-12-04T15:11:32.353Z
8615768 8615768 20251126051821_yDLrE BE0009 2025-11-27T14:30:09.834Z 2025-12-04T15:11:32.210Z
8615314 8615314 20251126045614_pRA48 BE0009 2025-11-27T14:29:26.767Z 2025-12-04T15:11:27.686Z
8615291 8615291 20251126045414_ENHzZ BE0009 2025-11-27T14:29:24.999Z 2025-12-04T15:11:27.460Z
8615244 8615244 20251126045205_jq3wf BE0009 2025-11-27T14:29:22.620Z 2025-12-04T15:11:27.091Z
8612471 8612471 20251126023327_lsz0i BE0009 2025-11-27T14:24:15.448Z 2025-12-04T15:09:31.068Z
8611694 8611694 20251126015620_33uFz BE0009 2025-11-27T14:22:31.094Z 2025-12-04T15:09:23.500Z
8611565 8611565 20251126015159_V1DpH BE0009 2025-11-27T14:22:19.920Z 2025-12-04T15:09:22.664Z
8611496 8611496 20251126014905_53uQc BE0009 2025-11-27T14:22:13.622Z 2025-12-04T15:09:21.596Z
8611454 8611454 20251126014319_C4ej7 BE0009 2025-11-27T14:22:09.769Z 2025-12-04T15:09:20.354Z
8610475 8610475 20251126004816_craAm BE0009 2025-11-27T14:20:12.789Z 2025-12-04T15:08:06.256Z
8608763 8608763 20251125224443_I7S8R BE0009 2025-11-27T14:16:49.932Z 2025-12-04T15:07:48.482Z
8608736 8608736 20251125223948_3XxhR BE0009 2025-11-27T14:16:41.872Z 2025-12-04T15:07:48.206Z
8608285 8608285 20251125220517_63tnS BE0009 2025-11-27T14:15:39.435Z 2025-12-04T15:07:43.269Z
8608223 8608223 20251125220234_z5rAd BE0009 2025-11-27T14:15:34.806Z 2025-12-04T15:07:42.789Z
8608061 8608061 20251125214644_ABoY6 BE0009 2025-11-27T14:15:10.351Z 2025-12-04T15:07:40.698Z
8599489 8599489 20251125020751_fBS9a BE0009 2025-11-26T14:21:10.349Z 2025-12-02T15:08:27.052Z
8599453 8599453 20251125020640_lknpp BE0009 2025-11-26T14:20:56.603Z 2025-12-02T15:08:24.422Z
8598885 8598885 20251125013323_AqJtb BE0009 2025-11-26T14:20:02.277Z 2025-12-02T15:08:11.470Z
8597061 8597061 20251124225100_dU3xM BE0009 2025-11-26T14:15:56.118Z 2025-12-02T15:07:22.744Z
8596612 8596612 20251124214214_C3u7L BE0009 2025-11-26T14:14:59.996Z 2025-12-02T15:07:03.407Z
8596594 8596594 20251124214035_pZxcZ BE0009 2025-11-26T14:14:58.416Z 2025-12-02T15:07:03.204Z
8596585 8596585 20251124213544_vDwD9 BE0009 2025-11-26T14:14:48.110Z 2025-12-02T15:07:03.148Z
8596570 8596570 20251124213256_nLkSE BE0009 2025-11-26T14:14:46.473Z 2025-12-02T15:07:02.913Z
8589745 8589745 20251124015126_IWkfl BE0009 2025-11-25T14:20:28.550Z 2025-12-02T15:12:35.401Z
8589638 8589638 20251124014513_nOATT BE0009 2025-11-25T14:20:17.470Z 2025-12-02T15:12:33.070Z
8589314 8589314 20251124012349_epi9o BE0009 2025-11-25T14:19:38.284Z 2025-12-02T15:12:18.916Z
8588970 8588970 20251124004934_qQOE2 BE0009 2025-11-25T14:18:50.490Z 2025-12-02T15:12:03.379Z
8588797 8588797 20251124003132_iZxNx BE0009 2025-11-25T14:18:18.806Z 2025-12-02T15:11:56.268Z
8588611 8588611 20251124001746_qJag8 BE0009 2025-11-25T14:18:04.285Z 2025-12-02T15:11:49.837Z
8588594 8588594 20251124001419_FmzQx BE0009 2025-11-25T14:17:52.904Z 2025-12-02T15:11:49.496Z
8588525 8588525 20251124000537_dcZzK BE0009 2025-11-25T14:17:43.323Z 2025-12-02T15:11:48.845Z
8588281 8588281 20251123233833_G68pt BE0009 2025-11-25T14:17:12.755Z 2025-12-02T15:11:38.909Z
8587229 8587229 20251123213841_bxCTa BE0009 2025-11-25T14:14:54.026Z 2025-12-02T15:11:09.643Z
8586394 8586394 20251123193858_sUxWg BE0009 2025-11-25T14:12:49.106Z 2025-12-02T15:10:46.843Z
8585864 8585864 20251123180831_FZjXz BE0009 2025-11-25T14:11:10.684Z 2025-12-02T15:10:27.315Z
8585699 8585699 20251123173259_tte5T BE0009 2025-11-25T14:10:36.612Z 2025-12-02T15:10:11.232Z
8573714 8573714 20251122035808_m115U BE0009 2025-11-23T14:41:55.804Z 2025-11-30T15:06:36.217Z
8573525 8573525 20251122032619_fzMs1 BE0009 2025-11-23T14:41:15.682Z 2025-11-30T15:06:30.131Z
8573422 8573422 20251122030938_WwGa7 BE0009 2025-11-23T14:41:10.978Z 2025-11-30T15:06:23.217Z
8573288 8573288 20251122025218_QQiae BE0009 2025-11-23T14:41:04.627Z 2025-11-30T15:06:14.097Z
8573151 8573151 20251122023601_2wlwf BE0009 2025-11-23T14:40:47.663Z 2025-11-30T15:06:11.296Z
8573118 8573118 20251122023046_IOWUd BE0009 2025-11-23T14:40:45.044Z 2025-11-30T15:06:10.157Z
8572934 8572934 20251122020515_kaEJe BE0009 2025-11-23T14:40:09.693Z 2025-11-30T15:06:06.894Z
8572920 8572920 20251122020151_T6SUq BE0009 2025-11-23T14:40:07.352Z 2025-11-30T15:06:06.807Z
8572906 8572906 20251122015828_iuc8g BE0009 2025-11-23T14:40:02.747Z 2025-11-30T15:06:05.764Z
8572885 8572885 20251122015443_22B8I BE0009 2025-11-23T14:39:56.995Z 2025-11-30T15:06:05.435Z
8572711 8572711 20251122013257_Lw86Y BE0009 2025-11-23T14:39:39.698Z 2025-11-30T15:05:56.776Z
8572679 8572679 20251122012846_rpv74 BE0009 2025-11-23T14:39:38.065Z 2025-11-30T15:05:54.992Z
8572607 8572607 20251122011657_LgFQj BE0009 2025-11-23T14:39:34.046Z 2025-11-30T15:05:52.917Z
8572605 8572605 20251122011547_8Lq8n BE0009 2025-11-23T14:39:33.895Z 2025-11-30T15:05:52.874Z
8572513 8572513 20251122010349_LBFfI BE0009 2025-11-23T14:39:29.833Z 2025-11-30T15:05:51.484Z
8572502 8572502 20251122010212_8oDVA BE0009 2025-11-23T14:39:29.394Z 2025-11-23T14:39:29.394Z

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