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,557 rows where station_code = "BE0013" 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
8683035 8683035 20251203061948_emjuR BE0013 2025-12-04T14:18:27.894Z 2025-12-05T14:23:05.369Z
8683004 8683004 20251203061846_bN35k BE0013 2025-12-04T14:18:26.622Z 2025-12-05T14:23:04.871Z
8682861 8682861 20251203061124_BhuKC BE0013 2025-12-04T14:18:09.690Z 2025-12-05T14:22:54.778Z
8682637 8682637 20251203055526_IHmNu BE0013 2025-12-04T14:17:50.728Z 2025-12-05T14:22:46.259Z
8682516 8682516 20251203054201_6OVTj BE0013 2025-12-04T14:17:20.367Z 2025-12-05T14:22:41.279Z
8682281 8682281 20251203051050_FMTfL BE0013 2025-12-04T14:16:43.812Z 2025-12-05T14:22:22.944Z
8682153 8682153 20251203045510_33mE4 BE0013 2025-12-04T14:16:31.155Z 2025-12-05T14:22:16.119Z
8681820 8681820 20251203041223_KcaIM BE0013 2025-12-04T14:15:41.605Z 2025-12-05T14:22:02.935Z
8681794 8681794 20251203040716_vg2GM BE0013 2025-12-04T14:15:37.108Z 2025-12-05T14:22:01.365Z
8681476 8681476 20251203031538_ayyrO BE0013 2025-12-04T14:14:48.374Z 2025-12-05T14:21:38.646Z
8681437 8681437 20251203030941_W8My2 BE0013 2025-12-04T14:14:43.304Z 2025-12-05T14:21:37.272Z
8681301 8681301 20251203025526_cbo3y BE0013 2025-12-04T14:14:26.387Z 2025-12-05T14:21:31.582Z
8681225 8681225 20251203024516_8zKPz BE0013 2025-12-04T14:14:05.830Z 2025-12-05T14:21:27.827Z
8681194 8681194 20251203023748_oHD5Z BE0013 2025-12-04T14:14:02.297Z 2025-12-05T14:21:26.280Z
8681133 8681133 20251203022749_DQQor BE0013 2025-12-04T14:13:56.093Z 2025-12-05T14:21:18.228Z
8663376 8663376 20251130204032_5Lyqf BE0013 2025-12-02T14:18:04.027Z 2025-12-05T14:34:06.111Z
8663348 8663348 20251130203627_0Gobs BE0013 2025-12-02T14:18:01.718Z 2025-12-05T14:34:05.565Z
8655461 8655461 20251130040317_WJtXd BE0013 2025-12-01T14:26:55.778Z 2025-12-05T14:44:33.983Z
8653397 8653397 20251130021457_93gj2 BE0013 2025-12-01T14:23:21.155Z 2025-12-05T14:43:30.629Z
8650782 8650782 20251129212614_CXd2Y BE0013 2025-12-01T14:17:09.368Z 2025-12-05T14:41:17.362Z
8645948 8645948 20251129003339_VbEMk BE0013 2025-11-30T14:24:58.413Z 2025-12-05T14:51:29.494Z
8645773 8645773 20251128234739_TccWv BE0013 2025-11-30T14:24:30.621Z 2025-12-05T14:51:12.250Z
8645718 8645718 20251128233547_zNO3v BE0013 2025-11-30T14:24:26.229Z 2025-12-05T14:51:07.993Z
8645563 8645563 20251128225045_M9ftb BE0013 2025-11-30T14:24:11.007Z 2025-12-05T14:50:50.727Z
8645034 8645034 20251128203039_pmqIR BE0013 2025-11-30T14:23:00.027Z 2025-12-05T14:50:31.054Z
8644956 8644956 20251128201839_lFuts BE0013 2025-11-30T14:22:54.446Z 2025-12-05T14:50:29.900Z
8644384 8644384 20251128192417_Dyrji BE0013 2025-11-30T14:21:56.231Z 2025-12-05T14:50:21.360Z
8625575 8625575 20251126030839_Ut4oo BE0013 2025-11-28T14:35:09.751Z 2025-12-04T15:09:38.210Z
8622559 8622559 20251126195557_UD32i BE0013 2025-11-28T14:19:22.415Z 2025-12-05T15:03:03.473Z
8621935 8621935 20251126171438_vcO7i BE0013 2025-11-28T14:17:05.256Z 2025-12-05T15:02:49.636Z
8615787 8615787 20251126051907_bIt5B BE0013 2025-11-27T14:30:10.683Z 2025-12-04T15:11:32.353Z
8615231 8615231 20251126045201_goWed BE0013 2025-11-27T14:29:22.075Z 2025-12-04T15:11:26.974Z
8615174 8615174 20251126044911_3gtCZ BE0013 2025-11-27T14:29:18.345Z 2025-12-04T15:11:26.522Z
8614787 8614787 20251126042731_5lh4k BE0013 2025-11-27T14:28:33.339Z 2025-12-04T15:11:08.986Z
8614706 8614706 20251126042430_P1mlP BE0013 2025-11-27T14:28:28.655Z 2025-12-04T15:11:00.335Z
8614565 8614565 20251126041815_tAkzL BE0013 2025-11-27T14:28:03.009Z 2025-12-04T15:10:51.078Z
8614501 8614501 20251126041559_Ey14H BE0013 2025-11-27T14:27:56.065Z 2025-12-04T15:10:46.910Z
8614127 8614127 20251126035237_7N3a1 BE0013 2025-11-27T14:27:15.554Z 2025-12-04T15:10:22.989Z
8613743 8613743 20251126033251_eDKXS BE0013 2025-11-27T14:26:29.034Z 2025-11-27T14:32:45.869Z
8613731 8613731 20251126033224_qd9Pk BE0013 2025-11-27T14:26:28.607Z 2025-12-04T15:09:51.401Z
8613663 8613663 20251126032757_qsDP5 BE0013 2025-11-27T14:26:21.478Z 2025-12-04T15:09:50.299Z
8613467 8613467 20251126031855_kqobI BE0013 2025-11-27T14:26:07.240Z 2025-12-04T15:09:40.975Z
8612105 8612105 20251126021901_cWnUP BE0013 2025-11-27T14:23:31.521Z 2025-12-04T15:09:27.767Z
8610546 8610546 20251126005559_wv3Pf BE0013 2025-11-27T14:20:18.715Z 2025-12-04T15:08:13.669Z
8608804 8608804 20251125224711_ND7wV BE0013 2025-11-27T14:16:53.542Z 2025-12-04T15:07:48.771Z
8608737 8608737 20251125223948_3XxhR BE0013 2025-11-27T14:16:41.872Z 2025-12-04T15:07:48.206Z
8608224 8608224 20251125220234_z5rAd BE0013 2025-11-27T14:15:34.806Z 2025-12-04T15:07:42.789Z
8608174 8608174 20251125215741_Ofboh BE0013 2025-11-27T14:15:31.214Z 2025-12-04T15:07:42.251Z
8608158 8608158 20251125215435_JPF8T BE0013 2025-11-27T14:15:28.980Z 2025-12-04T15:07:41.803Z
8600366 8600366 20251125025445_Ivb21 BE0013 2025-11-26T14:22:21.677Z 2025-12-02T15:08:40.953Z
8600047 8600047 20251125023931_4bp8I BE0013 2025-11-26T14:22:00.347Z 2025-12-02T15:08:34.230Z
8597469 8597469 20251124233713_qHZw5 BE0013 2025-11-26T14:16:51.774Z 2025-12-02T15:07:33.206Z
8595677 8595677 20251124175445_JYm0T BE0013 2025-11-26T14:12:10.537Z 2025-12-02T15:06:05.448Z
8592148 8592148 20251124055441_6msFs BE0013 2025-11-25T14:25:57.294Z 2025-12-02T15:13:02.054Z
8592134 8592134 20251124055258_pbAbb BE0013 2025-11-25T14:25:55.818Z 2025-12-02T15:13:01.979Z
8591912 8591912 20251124051520_TbpdW BE0013 2025-11-25T14:25:20.257Z 2025-12-02T15:13:00.978Z
8591905 8591905 20251124051424_2lys0 BE0013 2025-11-25T14:25:19.958Z 2025-12-02T15:13:00.941Z
8591872 8591872 20251124051127_gRBb3 BE0013 2025-11-25T14:25:17.033Z 2025-12-02T15:13:00.844Z
8591421 8591421 20251124041334_3N22p BE0013 2025-11-25T14:24:20.476Z 2025-12-02T15:12:58.646Z
8591220 8591220 20251124035357_45ifr BE0013 2025-11-25T14:23:45.933Z 2025-12-02T15:12:57.475Z
8591212 8591212 20251124035348_nwPVe BE0013 2025-11-25T14:23:45.468Z 2025-12-02T15:12:57.474Z
8591131 8591131 20251124034925_2hxHE BE0013 2025-11-25T14:23:39.825Z 2025-12-02T15:12:57.223Z
8591094 8591094 20251124034631_2br8r BE0013 2025-11-25T14:23:36.253Z 2025-12-02T15:12:57.068Z
8590856 8590856 20251124032308_LcBOR BE0013 2025-11-25T14:22:56.698Z 2025-12-02T15:12:55.875Z
8590811 8590811 20251124031412_ZgCHv BE0013 2025-11-25T14:22:51.235Z 2025-12-02T15:12:55.579Z
8590753 8590753 20251124030800_cIETG BE0013 2025-11-25T14:22:31.089Z 2025-12-02T15:12:55.181Z
8590197 8590197 20251124022809_5BN2K BE0013 2025-11-25T14:21:31.996Z 2025-12-02T15:12:43.264Z
8590118 8590118 20251124022410_WQpOq BE0013 2025-11-25T14:21:25.584Z 2025-12-02T15:12:42.485Z
8589948 8589948 20251124020959_3tEi5 BE0013 2025-11-25T14:20:59.376Z 2025-12-02T15:12:40.468Z
8589876 8589876 20251124020111_goIZq BE0013 2025-11-25T14:20:51.468Z 2025-12-02T15:12:37.815Z
8589157 8589157 20251124010917_4ijfi BE0013 2025-11-25T14:19:20.007Z 2025-12-02T15:12:10.097Z
8589111 8589111 20251124010322_jUSlQ BE0013 2025-11-25T14:19:05.348Z 2025-12-02T15:12:09.069Z
8588990 8588990 20251124005040_gR3qs BE0013 2025-11-25T14:18:51.175Z 2025-12-02T15:12:03.489Z
8588971 8588971 20251124004934_qQOE2 BE0013 2025-11-25T14:18:50.490Z 2025-12-02T15:12:03.379Z
8588526 8588526 20251124000537_dcZzK BE0013 2025-11-25T14:17:43.323Z 2025-12-02T15:11:48.845Z
8588142 8588142 20251123232736_dMPqR BE0013 2025-11-25T14:16:57.444Z 2025-12-02T15:11:28.792Z
8588083 8588083 20251123232040_mWWlt BE0013 2025-11-25T14:16:53.200Z 2025-12-02T15:11:27.672Z
8587411 8587411 20251123220113_6SEf5 BE0013 2025-11-25T14:15:17.380Z 2025-12-02T15:11:12.385Z
8587392 8587392 20251123215822_kfuVZ BE0013 2025-11-25T14:15:14.611Z 2025-12-02T15:11:12.277Z
8587378 8587378 20251123215803_L2qrk BE0013 2025-11-25T14:15:13.795Z 2025-12-02T15:11:12.250Z
8587230 8587230 20251123213841_bxCTa BE0013 2025-11-25T14:14:54.026Z 2025-12-02T15:11:09.643Z
8587207 8587207 20251123213555_A5I2b BE0013 2025-11-25T14:14:50.662Z 2025-12-02T15:11:09.273Z
8587133 8587133 20251123212551_efLcI BE0013 2025-11-25T14:14:41.873Z 2025-12-02T15:11:07.904Z
8586956 8586956 20251123210811_vCvQg BE0013 2025-11-25T14:14:17.920Z 2025-12-02T15:11:05.165Z
8586947 8586947 20251123210607_qKMy0 BE0013 2025-11-25T14:14:16.506Z 2025-12-02T15:11:05.086Z
8586889 8586889 20251123210241_UnClt BE0013 2025-11-25T14:14:06.011Z 2025-12-02T15:11:03.983Z
8586810 8586810 20251123205458_k3e0V BE0013 2025-11-25T14:13:59.898Z 2025-12-02T15:11:03.389Z
8585976 8585976 20251123182254_XTIfC BE0013 2025-11-25T14:11:31.751Z 2025-12-02T15:10:38.858Z
8585865 8585865 20251123180831_FZjXz BE0013 2025-11-25T14:11:10.684Z 2025-12-02T15:10:27.315Z
8585668 8585668 20251123172616_vRNKW BE0013 2025-11-25T14:10:32.481Z 2025-12-02T15:10:08.308Z
8580721 8580721 20251122013125_VmmEh BE0013 2025-11-24T14:24:11.799Z 2025-11-30T15:05:55.715Z
8573423 8573423 20251122030938_WwGa7 BE0013 2025-11-23T14:41:10.978Z 2025-11-30T15:06:23.217Z
8572935 8572935 20251122020515_kaEJe BE0013 2025-11-23T14:40:09.693Z 2025-11-30T15:06:06.894Z
8572907 8572907 20251122015828_iuc8g BE0013 2025-11-23T14:40:02.747Z 2025-11-30T15:06:05.764Z
8572819 8572819 20251122014600_2APBp BE0013 2025-11-23T14:39:45.664Z 2025-11-30T15:06:02.693Z
8572796 8572796 20251122014311_N5wAz BE0013 2025-11-23T14:39:44.572Z 2025-11-30T15:06:01.088Z
8572700 8572700 20251122013125_aOUD3 BE0013 2025-11-23T14:39:39.238Z 2025-11-23T14:39:39.238Z
8572673 8572673 20251122012558_WXy18 BE0013 2025-11-23T14:39:37.652Z 2025-11-30T15:05:54.932Z
8572608 8572608 20251122011657_LgFQj BE0013 2025-11-23T14:39:34.046Z 2025-11-30T15:05:52.917Z
8572606 8572606 20251122011547_8Lq8n BE0013 2025-11-23T14:39:33.895Z 2025-11-30T15:05:52.874Z

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