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,199 rows where station_code = "BE000K" 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
8687167 8687167 20251204052941_SdaHK BE000K 2025-12-05T14:14:08.793Z 2025-12-05T14:14:35.640Z
8687155 8687155 20251204052816_69g6x BE000K 2025-12-05T14:14:05.208Z 2025-12-05T14:14:35.637Z
8687102 8687102 20251204040101_RDyve BE000K 2025-12-05T14:13:53.889Z 2025-12-05T14:14:35.620Z
8687077 8687077 20251204031129_VOg2x BE000K 2025-12-05T14:13:49.590Z 2025-12-05T14:14:35.606Z
8687075 8687075 20251204031018_bf9zK BE000K 2025-12-05T14:13:49.223Z 2025-12-05T14:14:35.604Z
8665572 8665572 20251201033708_yyUZz BE000K 2025-12-02T14:23:55.906Z 2025-12-05T14:36:12.237Z
8665418 8665418 20251201031909_z81OE BE000K 2025-12-02T14:23:39.883Z 2025-12-05T14:36:00.041Z
8664993 8664993 20251201021404_2YjTE BE000K 2025-12-02T14:22:34.425Z 2025-12-05T14:35:38.444Z
8664576 8664576 20251201005932_4lY2y BE000K 2025-12-02T14:21:32.658Z 2025-12-05T14:35:09.096Z
8664565 8664565 20251201005748_SOPKM BE000K 2025-12-02T14:21:22.663Z 2025-12-05T14:35:08.825Z
8664294 8664294 20251130235913_xSmNt BE000K 2025-12-02T14:20:39.875Z 2025-12-05T14:34:59.868Z
8664287 8664287 20251130235905_3IXSh BE000K 2025-12-02T14:20:39.477Z 2025-12-05T14:34:59.740Z
8664084 8664084 20251130231456_G3hsV BE000K 2025-12-02T14:20:04.066Z 2025-12-05T14:34:47.213Z
8664006 8664006 20251130230108_LYVWt BE000K 2025-12-02T14:19:48.685Z 2025-12-05T14:34:41.672Z
8663942 8663942 20251130224321_Jsn4Z BE000K 2025-12-02T14:19:39.388Z 2025-12-05T14:34:39.272Z
8663872 8663872 20251130222159_3wOAA BE000K 2025-12-02T14:19:29.174Z 2025-12-05T14:34:35.072Z
8663859 8663859 20251130222056_c86jz BE000K 2025-12-02T14:19:27.366Z 2025-12-05T14:34:34.668Z
8663758 8663758 20251130215033_8PVwM BE000K 2025-12-02T14:19:02.982Z 2025-12-05T14:34:31.037Z
8663626 8663626 20251130211212_wX3Qy BE000K 2025-12-02T14:18:37.731Z 2025-12-05T14:34:26.375Z
8663562 8663562 20251130210442_bkZkC BE000K 2025-12-02T14:18:28.956Z 2025-12-05T14:34:24.515Z
8663340 8663340 20251130203356_XX86s BE000K 2025-12-02T14:18:00.700Z 2025-12-05T14:34:05.183Z
8663274 8663274 20251130202605_32kFz BE000K 2025-12-02T14:17:55.402Z 2025-12-05T14:34:03.820Z
8663233 8663233 20251130202403_1Di2K BE000K 2025-12-02T14:17:52.609Z 2025-12-05T14:34:03.150Z
8663229 8663229 20251130202354_kWtW3 BE000K 2025-12-02T14:17:52.175Z 2025-12-05T14:34:03.011Z
8663181 8663181 20251130201847_fEgeh BE000K 2025-12-02T14:17:36.294Z 2025-12-05T14:33:59.353Z
8663099 8663099 20251130201010_JhApc BE000K 2025-12-02T14:17:27.170Z 2025-12-05T14:33:57.160Z
8663019 8663019 20251130195658_OgKkt BE000K 2025-12-02T14:17:18.136Z 2025-12-05T14:33:55.036Z
8655294 8655294 20251130035333_W3DVr BE000K 2025-12-01T14:26:44.238Z 2025-12-05T14:44:31.433Z
8655003 8655003 20251130034057_utmjW BE000K 2025-12-01T14:26:15.544Z 2025-12-05T14:44:26.718Z
8653938 8653938 20251130024834_ua2zM BE000K 2025-12-01T14:24:30.824Z 2025-12-05T14:43:43.039Z
8651451 8651451 20251129234420_nE85N BE000K 2025-12-01T14:19:08.918Z 2025-12-05T14:41:58.272Z
8651190 8651190 20251129230314_ViI2q BE000K 2025-12-01T14:18:20.209Z 2025-12-05T14:41:51.469Z
8651039 8651039 20251129222831_VEotI BE000K 2025-12-01T14:17:53.122Z 2025-12-05T14:41:35.150Z
8650866 8650866 20251129214644_20U8Z BE000K 2025-12-01T14:17:23.847Z 2025-12-05T14:41:21.419Z
8646240 8646240 20251129013009_w4w3J BE000K 2025-11-30T14:25:42.527Z 2025-12-05T14:51:36.986Z
8646125 8646125 20251129010955_KQvU7 BE000K 2025-11-30T14:25:14.652Z 2025-12-05T14:51:33.725Z
8645998 8645998 20251129004624_t0GRy BE000K 2025-11-30T14:25:03.000Z 2025-12-05T14:51:30.762Z
8645905 8645905 20251129002305_V6Fiv BE000K 2025-11-30T14:24:53.503Z 2025-12-05T14:51:28.006Z
8645587 8645587 20251128230135_BYIMr BE000K 2025-11-30T14:24:14.435Z 2025-12-05T14:50:52.682Z
8645576 8645576 20251128225918_cgK3P BE000K 2025-11-30T14:24:13.503Z 2025-12-05T14:50:52.376Z
8645569 8645569 20251128225844_0Gcst BE000K 2025-11-30T14:24:12.858Z 2025-12-05T14:50:52.046Z
8645543 8645543 20251128224341_kKPRd BE000K 2025-11-30T14:23:57.133Z 2025-12-05T14:50:50.181Z
8645522 8645522 20251128223750_wC7pO BE000K 2025-11-30T14:23:54.995Z 2025-12-05T14:50:49.169Z
8645333 8645333 20251128212131_37OYy BE000K 2025-11-30T14:23:34.868Z 2025-12-05T14:50:36.897Z
8644051 8644051 20251128185410_OaGBQ BE000K 2025-11-30T14:21:16.468Z 2025-12-05T14:50:15.187Z
8623237 8623237 20251126232708_xA8z3 BE000K 2025-11-28T14:21:15.714Z 2025-12-05T15:03:39.955Z
8623225 8623225 20251126232354_Dd3I3 BE000K 2025-11-28T14:21:07.878Z 2025-12-05T15:03:38.831Z
8623110 8623110 20251126225426_3Btq9 BE000K 2025-11-28T14:20:53.850Z 2025-12-05T15:03:30.206Z
8622829 8622829 20251126214311_LhOEB BE000K 2025-11-28T14:20:08.686Z 2025-12-05T15:03:15.650Z
8622773 8622773 20251126211946_PRoUM BE000K 2025-11-28T14:19:52.304Z 2025-12-05T15:03:06.291Z
8616149 8616149 20251126054326_qJ0NF BE000K 2025-11-27T14:30:37.546Z 2025-12-04T15:11:36.406Z
8615430 8615430 20251126050318_hE9IB BE000K 2025-11-27T14:29:32.066Z 2025-12-04T15:11:28.826Z
8615190 8615190 20251126045017_0ohPa BE000K 2025-11-27T14:29:19.752Z 2025-12-04T15:11:26.722Z
8614985 8614985 20251126044012_0d3DQ BE000K 2025-11-27T14:28:49.977Z 2025-12-04T15:11:24.530Z
8614950 8614950 20251126043829_qAowh BE000K 2025-11-27T14:28:45.162Z 2025-12-04T15:11:23.077Z
8614859 8614859 20251126043147_Qg2TZ BE000K 2025-11-27T14:28:38.665Z 2025-12-04T15:11:15.290Z
8614667 8614667 20251126042311_feIbJ BE000K 2025-11-27T14:28:26.615Z 2025-12-04T15:10:57.615Z
8614526 8614526 20251126041632_sO72R BE000K 2025-11-27T14:27:58.130Z 2025-12-04T15:10:48.030Z
8614048 8614048 20251126034913_FHGYv BE000K 2025-11-27T14:27:08.245Z 2025-12-04T15:10:12.273Z
8613429 8613429 20251126031651_qaXCQ BE000K 2025-11-27T14:26:00.476Z 2025-12-04T15:09:40.445Z
8612157 8612157 20251126022006_59HBU BE000K 2025-11-27T14:23:34.176Z 2025-12-04T15:09:28.029Z
8611788 8611788 20251126020018_asavM BE000K 2025-11-27T14:22:52.769Z 2025-12-04T15:09:24.192Z
8609608 8609608 20251125235228_78Fkk BE000K 2025-11-27T14:18:33.740Z 2025-12-04T15:07:55.714Z
8608890 8608890 20251125225540_YgPO3 BE000K 2025-11-27T14:17:01.308Z 2025-12-04T15:07:49.596Z
8607953 8607953 20251125214011_b6Hov BE000K 2025-11-27T14:14:59.630Z 2025-12-04T15:07:39.518Z
8607811 8607811 20251125212456_lRCCV BE000K 2025-11-27T14:14:33.463Z 2025-12-04T15:07:32.198Z
8607780 8607780 20251125212040_NQHvc BE000K 2025-11-27T14:14:28.798Z 2025-12-04T15:07:29.773Z
8607499 8607499 20251125205750_37683 BE000K 2025-11-27T14:13:52.084Z 2025-12-04T15:07:03.051Z
8606959 8606959 20251125195956_cNPP3 BE000K 2025-11-27T14:11:51.958Z 2025-12-04T15:06:52.829Z
8606178 8606178 20251125181026_A0HU3 BE000K 2025-11-27T14:09:17.061Z 2025-12-04T15:06:29.941Z
8599866 8599866 20251125022908_CggJq BE000K 2025-11-26T14:21:33.891Z 2025-12-02T15:08:32.505Z
8599804 8599804 20251125022421_BHykE BE000K 2025-11-26T14:21:29.867Z 2025-12-02T15:08:32.158Z
8599495 8599495 20251125020833_XNvjI BE000K 2025-11-26T14:21:10.876Z 2025-12-02T15:08:27.058Z
8590684 8590684 20251124030321_bpPzk BE000K 2025-11-25T14:22:22.701Z 2025-12-02T15:12:54.201Z
8590476 8590476 20251124024508_POK92 BE000K 2025-11-25T14:22:06.008Z 2025-12-02T15:12:48.646Z
8590471 8590471 20251124024433_ty2bB BE000K 2025-11-25T14:22:05.148Z 2025-12-02T15:12:47.761Z
8590223 8590223 20251124022933_FhpG3 BE000K 2025-11-25T14:21:33.472Z 2025-12-02T15:12:43.400Z
8590111 8590111 20251124022317_CLyUm BE000K 2025-11-25T14:21:24.848Z 2025-12-02T15:12:42.442Z
8590093 8590093 20251124022151_hgbvm BE000K 2025-11-25T14:21:22.508Z 2025-12-02T15:12:42.240Z
8590032 8590032 20251124021714_0vziO BE000K 2025-11-25T14:21:08.954Z 2025-12-02T15:12:41.533Z
8589868 8589868 20251124020044_O0ouz BE000K 2025-11-25T14:20:50.846Z 2025-12-02T15:12:37.788Z
8589834 8589834 20251124015842_rV11p BE000K 2025-11-25T14:20:47.898Z 2025-12-02T15:12:37.233Z
8589806 8589806 20251124015527_WTxXX BE000K 2025-11-25T14:20:44.979Z 2025-12-02T15:12:36.069Z
8589663 8589663 20251124014548_9eYHM BE000K 2025-11-25T14:20:18.820Z 2025-12-02T15:12:33.111Z
8589467 8589467 20251124013704_NloJD BE000K 2025-11-25T14:20:06.717Z 2025-12-02T15:12:31.299Z
8589433 8589433 20251124013403_NNPN3 BE000K 2025-11-25T14:20:04.483Z 2025-12-02T15:12:30.732Z
8588728 8588728 20251124002750_W2RJO BE000K 2025-11-25T14:18:12.431Z 2025-12-02T15:11:51.103Z
8588243 8588243 20251123233437_Sabo1 BE000K 2025-11-25T14:17:07.451Z 2025-12-02T15:11:38.516Z
8588145 8588145 20251123232750_8QCCh BE000K 2025-11-25T14:16:57.994Z 2025-12-02T15:11:28.859Z
8587941 8587941 20251123230229_cqwZr BE000K 2025-11-25T14:16:28.266Z 2025-12-02T15:11:22.800Z
8587602 8587602 20251123222231_uNrat BE000K 2025-11-25T14:15:38.307Z 2025-12-02T15:11:17.763Z
8587520 8587520 20251123221309_yW92n BE000K 2025-11-25T14:15:26.811Z 2025-12-02T15:11:16.686Z
8587461 8587461 20251123220747_ffmm7 BE000K 2025-11-25T14:15:22.368Z 2025-12-02T15:11:13.712Z
8580717 8580717 20251122003719_auyz9 BE000K 2025-11-24T14:23:28.593Z 2025-11-30T15:05:49.141Z
8574184 8574184 20251122052253_r1mEl BE000K 2025-11-23T14:42:45.312Z 2025-11-30T15:07:01.765Z
8573880 8573880 20251122043204_rC2d3 BE000K 2025-11-23T14:42:05.021Z 2025-11-30T15:06:48.007Z
8573801 8573801 20251122041323_SKjix BE000K 2025-11-23T14:42:00.580Z 2025-11-30T15:06:40.384Z
8573769 8573769 20251122040703_ierb1 BE000K 2025-11-23T14:41:58.684Z 2025-11-30T15:06:37.432Z
8573565 8573565 20251122033319_hJ7BO BE000K 2025-11-23T14:41:17.675Z 2025-11-30T15:06:30.944Z
8573439 8573439 20251122031212_WX3Zg BE000K 2025-11-23T14:41:11.706Z 2025-11-30T15:06:24.533Z

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