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

5,111 rows where station_code = "BE000S" 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
8687179 8687179 20251204053245_GsKAg BE000S 2025-12-05T14:14:19.432Z 2025-12-06T14:22:35.741Z
8666667 8666667 20251130182554_mEpKm BE000S 2025-12-02T14:27:05.552Z 2025-12-06T14:38:57.930Z
8666049 8666049 20251201042740_rDAV2 BE000S 2025-12-02T14:25:09.028Z 2025-12-06T14:42:10.519Z
8665939 8665939 20251201041157_xcoiA BE000S 2025-12-02T14:24:56.758Z 2025-12-06T14:42:07.334Z
8665763 8665763 20251201035620_3nDdx BE000S 2025-12-02T14:24:26.769Z 2025-12-06T14:42:01.970Z
8665758 8665758 20251201035511_b32A4 BE000S 2025-12-02T14:24:26.256Z 2025-12-06T14:41:56.737Z
8665740 8665740 20251201035302_qZAy9 BE000S 2025-12-02T14:24:23.696Z 2025-12-06T14:41:47.729Z
8665736 8665736 20251201035232_1Rk0D BE000S 2025-12-02T14:24:23.378Z 2025-12-06T14:41:47.650Z
8665698 8665698 20251201035108_fNAWU BE000S 2025-12-02T14:24:20.757Z 2025-12-06T14:41:46.573Z
8665620 8665620 20251201034415_Kn6u6 BE000S 2025-12-02T14:24:12.953Z 2025-12-06T14:41:42.083Z
8665591 8665591 20251201034025_N3Ute BE000S 2025-12-02T14:23:57.763Z 2025-12-06T14:41:41.232Z
8665559 8665559 20251201033507_ZzgeG BE000S 2025-12-02T14:23:54.215Z 2025-12-06T14:41:40.596Z
8665510 8665510 20251201033010_Rr2j9 BE000S 2025-12-02T14:23:48.255Z 2025-12-06T14:41:39.422Z
8665494 8665494 20251201032708_plRj2 BE000S 2025-12-02T14:23:46.962Z 2025-12-06T14:41:38.850Z
8665398 8665398 20251201031540_OX6iM BE000S 2025-12-02T14:23:37.707Z 2025-12-06T14:41:36.821Z
8665355 8665355 20251201031047_859z7 BE000S 2025-12-02T14:23:33.799Z 2025-12-06T14:41:35.543Z
8665292 8665292 20251201030222_ZtZnd BE000S 2025-12-02T14:23:18.235Z 2025-12-06T14:41:33.020Z
8665221 8665221 20251201024846_nh7q2 BE000S 2025-12-02T14:23:09.776Z 2025-12-06T14:41:29.979Z
8665183 8665183 20251201024438_OmtXs BE000S 2025-12-02T14:23:05.614Z 2025-12-06T14:41:28.882Z
8665179 8665179 20251201024250_JpoX8 BE000S 2025-12-02T14:23:04.864Z 2025-12-06T14:41:28.750Z
8665113 8665113 20251201023228_322lh BE000S 2025-12-02T14:22:57.324Z 2025-12-06T14:41:27.355Z
8665046 8665046 20251201022053_Mvd0W BE000S 2025-12-02T14:22:41.617Z 2025-12-06T14:41:12.113Z
8664905 8664905 20251201020304_Ur9Pr BE000S 2025-12-02T14:22:25.746Z 2025-12-06T14:41:02.729Z
8664903 8664903 20251201020234_FxsJt BE000S 2025-12-02T14:22:25.380Z 2025-12-06T14:41:02.669Z
8664855 8664855 20251201015133_rDdv7 BE000S 2025-12-02T14:22:13.420Z 2025-12-06T14:41:01.125Z
8664811 8664811 20251201014327_m9o4j BE000S 2025-12-02T14:22:07.709Z 2025-12-06T14:40:58.532Z
8664799 8664799 20251201014206_w7fdz BE000S 2025-12-02T14:22:06.268Z 2025-12-06T14:40:58.034Z
8664686 8664686 20251201012501_vq4u4 BE000S 2025-12-02T14:21:47.973Z 2025-12-06T14:40:54.884Z
8664552 8664552 20251201005533_3NHfD BE000S 2025-12-02T14:21:21.002Z 2025-12-06T14:40:50.503Z
8664533 8664533 20251201005309_gLM72 BE000S 2025-12-02T14:21:16.753Z 2025-12-06T14:40:49.811Z
8664482 8664482 20251201004022_YZ8H5 BE000S 2025-12-02T14:21:11.367Z 2025-12-06T14:40:48.157Z
8664445 8664445 20251201002838_ADfuH BE000S 2025-12-02T14:21:05.625Z 2025-12-06T14:40:47.198Z
8664391 8664391 20251201001405_2ZBOc BE000S 2025-12-02T14:20:58.557Z 2025-12-06T14:40:45.783Z
8664378 8664378 20251201001244_YW3I8 BE000S 2025-12-02T14:20:57.325Z 2025-12-06T14:40:45.611Z
8664277 8664277 20251130235634_MUfMN BE000S 2025-12-02T14:20:38.354Z 2025-12-06T14:40:43.283Z
8664166 8664166 20251130232948_WDyGG BE000S 2025-12-02T14:20:14.010Z 2025-12-06T14:40:40.067Z
8664138 8664138 20251130232505_N0DEd BE000S 2025-12-02T14:20:09.268Z 2025-12-06T14:40:37.671Z
8663888 8663888 20251130223031_A5rrI BE000S 2025-12-02T14:19:32.002Z 2025-12-06T14:40:14.113Z
8663592 8663592 20251130210617_i2E5Q BE000S 2025-12-02T14:18:31.894Z 2025-12-06T14:40:04.374Z
8663069 8663069 20251130200442_0XO5W BE000S 2025-12-02T14:17:23.637Z 2025-12-06T14:39:48.073Z
8662554 8662554 20251130190956_bMbLG BE000S 2025-12-02T14:15:52.797Z 2025-12-06T14:39:22.290Z
8662480 8662480 20251130185615_yUcoQ BE000S 2025-12-02T14:15:42.276Z 2025-12-06T14:39:19.852Z
8662415 8662415 20251130184706_PWTki BE000S 2025-12-02T14:15:25.261Z 2025-12-06T14:39:17.657Z
8662329 8662329 20251130183414_43MTI BE000S 2025-12-02T14:15:09.403Z 2025-12-06T14:38:59.293Z
8662281 8662281 20251130182552_DXUN6 BE000S 2025-12-02T14:14:53.907Z 2025-12-06T14:38:57.822Z
8662111 8662111 20251130180109_DQNn8 BE000S 2025-12-02T14:14:21.274Z 2025-12-06T14:38:50.727Z
8655758 8655758 20251130041641_2eJFK BE000S 2025-12-01T14:27:26.937Z 2025-12-01T14:27:26.937Z
8655625 8655625 20251130041015_2wGxi BE000S 2025-12-01T14:27:18.686Z 2025-12-06T14:49:26.097Z
8655458 8655458 20251130040315_ARwKK BE000S 2025-12-01T14:26:55.352Z 2025-12-06T14:49:18.555Z
8624280 8624280 20251127035556_WCyWw BE000S 2025-11-28T14:24:24.202Z 2025-12-05T15:04:57.409Z
8624089 8624089 20251127030414_92Wyo BE000S 2025-11-28T14:23:45.312Z 2025-12-05T15:04:43.961Z
8623823 8623823 20251127021306_Tarue BE000S 2025-11-28T14:22:57.438Z 2025-12-05T15:04:18.546Z
8623760 8623760 20251127015507_eJI6y BE000S 2025-11-28T14:22:49.786Z 2025-12-05T15:04:15.131Z
8623654 8623654 20251127013724_TNatz BE000S 2025-11-28T14:22:20.402Z 2025-12-05T15:04:06.105Z
8623612 8623612 20251127012625_2OobJ BE000S 2025-11-28T14:22:15.554Z 2025-12-05T15:04:04.591Z
8622530 8622530 20251126194535_wYz24 BE000S 2025-11-28T14:19:06.190Z 2025-12-05T15:03:03.004Z
8622468 8622468 20251126192634_PHm5r BE000S 2025-11-28T14:18:55.537Z 2025-12-05T15:03:01.845Z
8622267 8622267 20251126183125_v4cmY BE000S 2025-11-28T14:18:16.943Z 2025-12-05T15:02:54.653Z
8622175 8622175 20251126180713_rFdaU BE000S 2025-11-28T14:18:03.866Z 2025-12-05T15:02:53.225Z
8622099 8622099 20251126175027_7JnYM BE000S 2025-11-28T14:17:41.853Z 2025-12-05T15:02:52.209Z
8595754 8595754 20251124181916_PrTnj BE000S 2025-11-26T14:12:23.479Z 2025-12-02T15:06:08.891Z
8595711 8595711 20251124180457_qAusb BE000S 2025-11-26T14:12:16.632Z 2025-12-02T15:06:05.983Z
8579251 8579251 20251122225523_ChIZ6 BE000S 2025-11-24T14:13:52.174Z 2025-12-01T15:20:11.605Z
8579054 8579054 20251122221258_sZ8td BE000S 2025-11-24T14:13:23.624Z 2025-12-01T15:20:00.389Z
8578959 8578959 20251122215706_oVKkG BE000S 2025-11-24T14:13:11.216Z 2025-11-24T14:13:11.216Z
8578870 8578870 20251122214300_j48dz BE000S 2025-11-24T14:12:54.250Z 2025-12-01T15:19:54.819Z
8578865 8578865 20251122214208_iCjcG BE000S 2025-11-24T14:12:53.058Z 2025-11-24T14:12:53.058Z
8578819 8578819 20251122213006_TKpFC BE000S 2025-11-24T14:12:46.440Z 2025-11-24T14:12:46.440Z
8578109 8578109 20251122194228_J1snp BE000S 2025-11-24T14:10:45.954Z 2025-12-01T15:19:09.031Z
8578073 8578073 20251122193603_1pABI BE000S 2025-11-24T14:10:40.623Z 2025-12-01T15:19:08.067Z
8577555 8577555 20251122182920_4dtEm BE000S 2025-11-24T14:09:02.600Z 2025-12-01T15:18:53.945Z
8577526 8577526 20251122182109_AUQWe BE000S 2025-11-24T14:08:56.912Z 2025-12-01T15:18:52.476Z
8577249 8577249 20251122174246_upfEE BE000S 2025-11-24T14:08:05.648Z 2025-12-01T15:18:45.518Z
8571801 8571801 20251121221158_T33Q6 BE000S 2025-11-23T14:37:44.444Z 2025-11-30T15:05:19.162Z
8571724 8571724 20251121215823_MOMzk BE000S 2025-11-23T14:37:41.549Z 2025-11-30T15:05:15.294Z
8571665 8571665 20251121214520_Fceve BE000S 2025-11-23T14:37:32.029Z 2025-11-30T15:05:11.962Z
8571597 8571597 20251121212848_A3h2q BE000S 2025-11-23T14:37:07.097Z 2025-11-30T15:05:10.758Z
8571527 8571527 20251121211032_J6dl3 BE000S 2025-11-23T14:36:47.192Z 2025-11-30T15:05:08.413Z
8571448 8571448 20251121204855_ee9SM BE000S 2025-11-23T14:36:29.719Z 2025-11-30T15:05:06.106Z
8571445 8571445 20251121204844_Pzm5j BE000S 2025-11-23T14:36:29.370Z 2025-11-30T15:05:06.080Z
8571362 8571362 20251121202344_jQSRQ BE000S 2025-11-23T14:36:13.242Z 2025-11-30T15:04:58.410Z
8571226 8571226 20251121194613_xH2LD BE000S 2025-11-23T14:36:04.947Z 2025-11-30T15:04:41.150Z
8571224 8571224 20251121194558_FQ2WR BE000S 2025-11-23T14:36:04.803Z 2025-11-30T15:04:40.696Z
8571099 8571099 20251121190850_HPjjD BE000S 2025-11-23T14:35:58.151Z 2025-11-30T15:04:28.273Z
8571084 8571084 20251121190005_X8RG9 BE000S 2025-11-23T14:35:57.228Z 2025-11-30T15:04:26.100Z
8571059 8571059 20251121184601_oTvNi BE000S 2025-11-23T14:35:55.711Z 2025-11-30T15:04:25.194Z
8570987 8570987 20251121182436_ZCdkn BE000S 2025-11-23T14:35:51.293Z 2025-11-30T15:04:17.750Z
8570933 8570933 20251121180335_zf9L4 BE000S 2025-11-23T14:35:22.086Z 2025-11-30T15:04:08.350Z
8570843 8570843 20251121173453_RTHHg BE000S 2025-11-23T14:34:54.484Z 2025-11-30T15:03:49.886Z
8547695 8547695 20251120200900_ly8RX BE000S 2025-11-22T14:15:28.921Z 2025-11-29T14:54:20.849Z
8515886 8515886 20251118051744_W6oC2 BE000S 2025-11-19T14:40:01.874Z 2025-11-26T15:08:04.631Z
8515733 8515733 20251118045854_Eeu8A BE000S 2025-11-19T14:39:55.691Z 2025-11-26T15:08:03.812Z
8515618 8515618 20251118044609_P6XnS BE000S 2025-11-19T14:39:51.530Z 2025-11-26T15:08:02.064Z
8515237 8515237 20251118040252_JHMtV BE000S 2025-11-19T14:39:15.151Z 2025-11-26T15:07:59.824Z
8514956 8514956 20251118032743_T3T2n BE000S 2025-11-19T14:38:35.123Z 2025-11-26T15:07:57.950Z
8514671 8514671 20251118025122_McnKT BE000S 2025-11-19T14:38:24.195Z 2025-11-26T15:07:56.098Z
8514664 8514664 20251118025017_Ewlm5 BE000S 2025-11-19T14:38:23.925Z 2025-11-26T15:07:56.063Z
8513522 8513522 20251118003954_rcg7B BE000S 2025-11-19T14:36:20.927Z 2025-11-26T15:07:49.698Z
8512983 8512983 20251117233846_NE37c BE000S 2025-11-19T14:35:19.072Z 2025-11-26T15:07:47.133Z
8512821 8512821 20251117231550_s7zvI BE000S 2025-11-19T14:34:57.830Z 2025-11-26T15:07:46.308Z

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